insert into fy_users (login, password) values ('frank','202cb962ac59075b964b07152d234b70');
insert into fy_secdb (loginid, ir, ir_edit, clinical_therapist) values ('2','X', 'X', 'X');

insert into fy_con (loginid, type, firstname, lastname, nickname, descr) VALUES (2, 'Staff','Joebob','Sponge','Frank','');
insert into fy_con (type, firstname, lastname, nickname, descr) VALUES ('Resident','Michelle','Smith','Shelly','');
insert into fy_con (type, firstname, lastname, nickname, descr) VALUES ('Resident','James','Johnson','Jimmy','');
insert into fy_con (loginid, type, firstname, middlename, lastname, descr) VALUES (3, 'Staff','Mary','Tyler','Moore','');

insert into fy_users (login, password) values ('mary','202cb962ac59075b964b07152d234b70');
insert into fy_secdb (loginid, ir, ir_enter, ir_edit, ir_edit_admin, ir_merge, ir_admin, clinical_db, clinical_therapist, clinical_admin) values ('3','X','X','X','X','X','X','X','X','X');

insert into fy_groupdb (abbr, type, shortname, longname, numcode, charcode) VALUES ('BJ','Home','johnson','The Bob Johnson Memorial Group Home','100','LA');

insert into fy_con_groups (fid, group_id, primary_gh, coordinator) VALUES ('1','BJ','Y','N');
insert into fy_con_groups (fid, group_id, primary_gh, coordinator) VALUES ('2','BJ','Y','N');
insert into fy_con_groups (fid, group_id, primary_gh, coordinator) VALUES ('3','BJ','Y','N');
insert into fy_con_groups (fid, group_id, primary_gh, coordinator) VALUES ('4','BJ','Y','N');
insert into fy_con_groups (fid, group_id, primary_gh, coordinator) VALUES ('5','BJ','Y','N');

insert into fy_con_res_diagcodes (fid, code) VALUES ('3','309.81');
insert into fy_con_res_diagcodes (fid, code) VALUES ('4','296.64');

