create table fy_users (
	ID int unsigned not null auto_increment,
	login character (10),
	password character (42),
	PRIMARY KEY (ID)
);

create table fy_secdb_help (
	ID int unsigned not null auto_increment,
	entryabbr character (30),
	entryname character (30),
	helptext varchar (255),
	PRIMARY KEY (ID)
);

create table fy_secdb (
	ID int unsigned not null auto_increment,
	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)
);

create table fy_groupdb (
	ID int unsigned not null auto_increment,
	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)
);
	
create table fy_states (
	ID int unsigned not null auto_increment,
	state character (20),
	abbr character (2),
	PRIMARY KEY (ID)
);

create table fy_clinical_services (
	ID int unsigned not null auto_increment,
	service character (25),
	abbr character (8),
	session_type character (10),
	code character (5),
	PRIMARY KEY (ID)
);

create table fy_clinical_sessiontypes (
	ID int unsigned not null auto_increment,
	session_type character (10),
	PRIMARY KEY (ID)
);

create table fy_clinical_diagcodes (
	ID int unsigned not null auto_increment,
	code character (6),
	abbr character (10),
	descr character (40),
	PRIMARY KEY (ID)
);

create table fy_clinical_pos (
	ID int unsigned not null auto_increment,
	pos character (2),
	descr character (30),
	PRIMARY KEY (ID)
);

create table fy_clinical_modifiers (
	ID int unsigned not null auto_increment,
	modifier character (2),
	descr character (100),
	PRIMARY KEY (ID)
);


