drop table fy_users;
drop sequence fy_users_id_seq;
create table fy_users (
	ID serial,
	login character (10),
	password character (42),
	PRIMARY KEY (ID)
);

drop table fy_secdb_help;
drop sequence fy_secdb_help_id_seq;
create table fy_secdb_help (
	ID serial,
	entryabbr character (30),
	entryname character (30),
	helptext varchar,
	PRIMARY KEY (ID)
);

drop table fy_secdb;
drop sequence fy_secdb_id_seq;
create table fy_secdb (
	ID serial,
	loginid integer,
	topadmin character (1),
	makeuser character (1),
	secdb character (1),
	secdb_edit character (1),
	groupdb character (1),
	groupdb_edit character (1),
	con character (1),
	con_edit character (1),
	con_hr character (1),
	ir character (1),
	ir_enter character (1),
	ir_edit character (1),
	ir_edit_admin character (1),
	ir_merge character (1),
	ir_admin character (1),
	clinical_therapist character (1),
	clinical_db character (1),
	clinical_ccn character (1),
	clinical_admin character (1),
	PRIMARY KEY (ID)
);

drop table fy_groupdb;
drop sequence fy_groupdb_id_seq;
create table fy_groupdb (
	ID serial,
	abbr character (2),
	type character (6),
	shortname character (8),
	longname character (40),
	numcode integer,
	charcode character (30),
	streetaddress character (30),
	city character (15),
	state character (2),
	zip character (10),
	phone character (10),
	PRIMARY KEY (ID)
);
	
drop table fy_states;
drop sequence fy_states_id_seq;
create table fy_states (
	ID serial,
	state character (20),
	abbr character (2),
	PRIMARY KEY (ID)
);

drop table fy_clinical_services;
drop sequence fy_clinical_services_id_seq;
create table fy_clinical_services (
	ID serial,
	service character (25),
	abbr character (8),
	session_type character (10),
	code character (5),
	PRIMARY KEY (ID)
);

drop table fy_clinical_sessiontypes;
drop sequence fy_clinical_sessiontypes_id_seq;
create table fy_clinical_sessiontypes (
	ID serial,
	session_type character (10),
	PRIMARY KEY (ID)
);

drop table fy_clinical_diagcodes;
drop sequence fy_clinical_diagcodes_id_seq;
create table fy_clinical_diagcodes (
	ID serial,
	code character (6),
	abbr character (10),
	descr character (40),
	PRIMARY KEY (ID)
);

drop table fy_clinical_pos;
drop sequence fy_clinical_pos_id_seq;
create table fy_clinical_pos (
	ID serial,
	pos character (2),
	descr character (30),
	PRIMARY KEY (ID)
);

drop table fy_clinical_modifiers;
drop sequence fy_clinical_modifiers_id_seq;
create table fy_clinical_modifiers (
	ID serial,
	modifier character (2),
	descr character (100),
	PRIMARY KEY (ID)
);


