insert into fy_users (login, password) values ('root','202cb962ac59075b964b07152d234b70');
insert into fy_secdb (loginid, topadmin, makeuser, secdb, secdb_edit, groupdb, groupdb_edit, con, con_hr, con_edit, clinical_db, clinical_ccn, clinical_therapist, ir, ir_enter, ir_edit, ir_merge, ir_admin) values ('1','X','X','X','X','X','X','X','X','X','X','X','X','X','X','X','X','X');

insert into fy_states (state, abbr) VALUES ('Alabama','AL');
insert into fy_states (state, abbr) VALUES ('Alaska','AK');
insert into fy_states (state, abbr) VALUES ('Arizona','AZ');
insert into fy_states (state, abbr) VALUES ('Arkansas','AR');

insert into fy_states (state, abbr) VALUES ('California','CA');
insert into fy_states (state, abbr) VALUES ('Colorado','CO');
insert into fy_states (state, abbr) VALUES ('Connecticut','CT');

insert into fy_states (state, abbr) VALUES ('Delaware','DE');
insert into fy_states (state, abbr) VALUES ('District of Columbia','DC');

insert into fy_states (state, abbr) VALUES ('Florida','FL');

insert into fy_states (state, abbr) VALUES ('Georgia','GA');

insert into fy_states (state, abbr) VALUES ('Hawaii','HI');

insert into fy_states (state, abbr) VALUES ('Idaho','ID');
insert into fy_states (state, abbr) VALUES ('Illinois','IL');
insert into fy_states (state, abbr) VALUES ('Indiana','IN');
insert into fy_states (state, abbr) VALUES ('Iowa','IA');

insert into fy_states (state, abbr) VALUES ('Kansas','KS');
insert into fy_states (state, abbr) VALUES ('Kentucky','KY');

insert into fy_states (state, abbr) VALUES ('Louisiana','LA');

insert into fy_states (state, abbr) VALUES ('Maine','ME');
insert into fy_states (state, abbr) VALUES ('Maryland','MD');
insert into fy_states (state, abbr) VALUES ('Massachusetts','MA');
insert into fy_states (state, abbr) VALUES ('Michigan','MI');
insert into fy_states (state, abbr) VALUES ('Minnesota','MN');
insert into fy_states (state, abbr) VALUES ('Mississippi','MS');
insert into fy_states (state, abbr) VALUES ('Missouri','MO');
insert into fy_states (state, abbr) VALUES ('Montana','MT');

insert into fy_states (state, abbr) VALUES ('Nebraska','NE');
insert into fy_states (state, abbr) VALUES ('Nevada','NV');
insert into fy_states (state, abbr) VALUES ('New Hampshire','NH');
insert into fy_states (state, abbr) VALUES ('New Jersey','NJ');
insert into fy_states (state, abbr) VALUES ('New Mexico','NM');
insert into fy_states (state, abbr) VALUES ('New York','NY');
insert into fy_states (state, abbr) VALUES ('North Carolina','NC');
insert into fy_states (state, abbr) VALUES ('North Dakota','ND');

insert into fy_states (state, abbr) VALUES ('Ohio','OH');
insert into fy_states (state, abbr) VALUES ('Oklahoma','OK');
insert into fy_states (state, abbr) VALUES ('Oregon','OR');

insert into fy_states (state, abbr) VALUES ('Pennsylvania','PE');

insert into fy_states (state, abbr) VALUES ('Rhode Island','RI');

insert into fy_states (state, abbr) VALUES ('South Carolina','SC');
insert into fy_states (state, abbr) VALUES ('South Dakota','SD');

insert into fy_states (state, abbr) VALUES ('Tennessee','TN');
insert into fy_states (state, abbr) VALUES ('Texas','TX');

insert into fy_states (state, abbr) VALUES ('Utah','UT');

insert into fy_states (state, abbr) VALUES ('Vermont','VT');
insert into fy_states (state, abbr) VALUES ('Virginia','VA');

insert into fy_states (state, abbr) VALUES ('Washington','WA');
insert into fy_states (state, abbr) VALUES ('West Virginia','WV');
insert into fy_states (state, abbr) VALUES ('Wisconsin','WI');
insert into fy_states (state, abbr) VALUES ('Wyoming','WY');

insert into fy_clinical_services (service,abbr,session_type,code) VALUES ('Individual Counseling','indcoun','Individual','M1410');
insert into fy_clinical_services (service,abbr,session_type,code) VALUES ('Group Counseling','grpcoun','Group','M1420');
insert into fy_clinical_services (service,abbr,session_type,code) VALUES ('Medication/Somatic','medsom','Individual','M1310');
insert into fy_clinical_services (service,abbr,session_type,code) VALUES ('Diagnostic','diag','Individual','M1210');
insert into fy_clinical_services (service,abbr) VALUES ('All','all');

insert into fy_clinical_sessiontypes (session_type) VALUES ('Individual');
insert into fy_clinical_sessiontypes (session_type) VALUES ('Group');

insert into fy_clinical_diagcodes (code, abbr, descr) VALUES ('309.81','PTSD','Post Traumattic Stress Disorder');
insert into fy_clinical_diagcodes (code, abbr, descr) VALUES ('296.64','','Bipolar');
insert into fy_clinical_diagcodes (code, abbr, descr) VALUES ('312.8','Conduct DO','Conduct Disorder');
insert into fy_clinical_diagcodes (code, abbr, descr) VALUES ('296.63','','Bipolar');
insert into fy_clinical_diagcodes (code, abbr, descr) VALUES ('314.01','ADHD','Attention Deficit Hyperactivity Disorder');

insert into fy_clinical_pos (pos, descr) VALUES ('35','Group Home');
insert into fy_clinical_pos (pos, descr) VALUES ('11','Office');
insert into fy_clinical_pos (pos, descr) VALUES ('13','School');
insert into fy_clinical_pos (pos, descr) VALUES ('21','Inpatient Hospital');
insert into fy_clinical_pos (pos, descr) VALUES ('22','Outpatient Hospital');
insert into fy_clinical_pos (pos, descr) VALUES ('23','Emergecy Room-Hospital');
insert into fy_clinical_pos (pos, descr) VALUES ('58','Crisis/Rescue');
insert into fy_clinical_pos (pos, descr) VALUES ('84','Jail');
insert into fy_clinical_pos (pos, descr) VALUES ('92','Public Setting');

insert into fy_clinical_modifiers (modifier, descr) VALUES ('F0','Face to face with client only');
insert into fy_clinical_modifiers (modifier, descr) VALUES ('T0','Telephone with client only');
insert into fy_clinical_modifiers (modifier, descr) VALUES ('F1','Face to face with client and family/Significant Other');
insert into fy_clinical_modifiers (modifier, descr) VALUES ('T1','Telephone with client and family/Significant Other');
insert into fy_clinical_modifiers (modifier, descr) VALUES ('F2','Face to face with family/Significant Other, client NOT present');
insert into fy_clinical_modifiers (modifier, descr) VALUES ('T2','Telephone with family/Significant Other, client NOT present');
insert into fy_clinical_modifiers (modifier, descr) VALUES ('F3','Face to face with other professional, client NOT present');
insert into fy_clinical_modifiers (modifier, descr) VALUES ('T3','Telephone with other professional, client NOT present');
insert into fy_clinical_modifiers (modifier, descr) VALUES ('F4','Face to face with client in penal system');
insert into fy_clinical_modifiers (modifier, descr) VALUES ('T4','Telephone with client in penal system');
insert into fy_clinical_modifiers (modifier, descr) VALUES ('F5','Face to face with family/Significant Other, client in penal system, client NOT present');
insert into fy_clinical_modifiers (modifier, descr) VALUES ('T5','Telephone with family/Significant Other, client in penal system, client NOT present');
insert into fy_clinical_modifiers (modifier, descr) VALUES ('F6','Face to face with client on rolls at State Hospital');
insert into fy_clinical_modifiers (modifier, descr) VALUES ('T6','Telephone with client on rolls at State Hospital');
insert into fy_clinical_modifiers (modifier, descr) VALUES ('F7','Face to face with family/Significant Other/professional, client on rools at State Hospital');
insert into fy_clinical_modifiers (modifier, descr) VALUES ('T7','Telephone with family/Significant Other/professional, client on rools at State Hospital');

insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('topadmin','Top Admin','');
insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('makeuser','Make User','This permission allows a user to create users on this Freemed-YiRC system.');
insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('secdb','View Security DB','This permission allows a user to view the Security Database (SecDB)');
insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('secdb_edit','Edit Security DB','This permission allows a user to edit the Security Database (SecDB).  This includes adding, modifying, and deleting records.');
insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('groupdb','View Group DB','This permission allows a user to view the Group Database.');
insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('groupdb_edit','Edit Group DB','This permission allows a user to edit the Group Database.  This includes adding, modifying, and deleting records.');
insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('con','View Contact DB','This permission allows a user to view the Contact Database.');
insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('con_edit','Edit Contact DB','This permission allows a user to edit the Contact Database.  This includes adding, modifying, and deleting records.');
insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('con_hr','Contact DB HR Priv','This permission gives a user Human Resource privelidges, namely for specifying program coordinators and other important HR functions.');
insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('ir','View IR DB','This permission allows a user to view the Incident Report (IR) Database.');
insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('ir_enter','Enter IR','This permission allows a user to enter Incident Reports (IRs) into the database.');
insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('ir_edit','Edit IR DB','This permission allows a user to edit Incident Reports (IRs).');
insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('ir_edit_admin','Edit Admin','This permission allows a user to administratively edit Incident Reports (IRs).');
insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('ir_merge','Merge IRs','This permission allows a user to merge Incident Reports (IRs).  Merging is the process of moving an IR from an active state to an inactive one.');
insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('ir_admin','Admin Priv','This permission names a user as an Incident Report (IR) administrator.');
insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('clinical_therapist','Clinical Therapist','This permission names a user as a Clinical Therapist, and allows a user to enter Clinical CaseNotes (CCNs).');
insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('clinical_db','Access Clinical DB','This permission allows a user access (including edit priviledges) to the Clinical Databases.');
insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('clinical_ccn','Modfy Clinical Casenote Design','This permission allows a user to add/modify/delete/import/export the Clinical CaseNote (CCN) Databases.');
insert into fy_secdb_help (entryabbr, entryname, helptext) VALUES ('clinical_admin','CCN Admin','This permission names a user as a Clinical CaseNote Administrator, and gives them full access (including add, edit, and delete privelidges) to Clinical CaseNotes.');
