INSERT INTO `buildingSites` (`ID`, `siteName`, `siteContact`) VALUES
(1, 'SchoolTown High School', 4),
(2, 'SchoolTown Middle School', 3),
(3, 'SchoolTown Elementary', 6),
(4, 'SchoolTown Pre-School', 2),
(5, 'Schooltown Maintenance', 5);

INSERT INTO `districtAdmin` (`ID`, `userName`, `passwordHash`, `adminType`) VALUES
(1, 'dbanks7@gmail.com', 'd3c5a9eb9e328cdeb17b7cb8efad0f61d2b60323625b99996aa27e345cc3ea39', 1),
(2, 'dbanks7@floorpie.org', '', 3);

INSERT INTO `districtInfo` (`ID`, `districtName`, `districtNameAbbrev`, `districtURL`, `districtLogo`, `districtLogoFileType`) VALUES
(0, 'Schooltown Schools', 'Schooltown', 'www.schooltown.com', 0x[encoded data, 72936 characters], 'jpeg');


INSERT INTO `districtJobTitles` (`ID`, `JobTitle`, `ReviewerID`, `Email_Timestamp`, `Token`) VALUES
(1, 'Head Mechanic', 0, NULL, '73ceef780c056d770425c9e187731af5'),
(2, 'Mechanic II', 0, NULL, '7b8fde7ef868ae465be1d348605f2ae3'),
(3, 'Mechanic I', 0, NULL, 'edaad37074859b5a68859c928ea342c5'),
(4, 'Head Cook', 0, NULL, 'daf661e6a90ab95c2ed7630888c2f001'),
(5, 'Cook', 0, NULL, 'af37b9f0297956852f2a8002b888f33b');


INSERT INTO `districtSettings` (`setKey`, `setValue`) VALUES
('ADMIN_JDSURVEY_COMPLETED_SECTION_110', '1'),
('REVIEW_SURVEY_PAGE_COUNT', '7'),
('SURVEY_PAGE_COUNT', '28');


INSERT INTO `Employee` (`ID`, `First_Name`, `Last_Name`, `Email`, `Supervisor_ID`, `Position_Start_Year`, `District_Start_Year`, `Profession_Start_Year`, `Employment_Type`, `Gender`, `Ethnicity`, `Race`, `Work_Location`, `Imported_Job_Title`, `Job_Title`, `Survey_Value`, `Email_Group`, `Email_Timestamp`, `User_Defined_1`, `User_Defined_2`, `User_Defined_3`, `Token`) VALUES
(1, 'John', 'Goodwrench', 'jgood@floorpie.org', 0, 0, 0, 0, '', '', '', '', 1, 1, 1, 0, 0, '0000-00-00 00:00:00', '890', 'DEPT90', 'jgood', '04b138825d8f069e6ae74298fda7a38c'),
(2, 'Terry', 'White', 'terry.white@floorpie.org', 0, 0, 0, 0, '', '', '', '', 1, 2, 2, 0, 0, '0000-00-00 00:00:00', '520', 'DEPT90', 'twhite', '79694a73982c40ac0d9273566bb06c13'),
(3, 'Susan', 'Little', 'susan.little@floorpie.org', 0, 0, 0, 0, '', '', '', '', 2, 3, 3, 0, 0, '0000-00-00 00:00:00', '891', 'DEPT90', 'slittle', '33ca64f79ee564f25198e10885c77b04'),
(4, 'John', 'Cook', 'jcook@floorpie.org', 0, 0, 0, 0, '', '', '', '', 3, 4, 4, 0, 0, '0000-00-00 00:00:00', '510', 'DEPT10', 'jcook', '9eb5169d27d4723fdf1155eed590dcfe'),
(5, 'Sara', 'Fry', 'sfry@floorpie.org', 0, 0, 0, 0, '', '', '', '', 4, 5, 5, 0, 0, '0000-00-00 00:00:00', '100', 'DEPT10', 'sfry', 'f7170b91576ec6550330381e3b24d5f5'),
(6, 'Denise', 'Berger', 'dberger@floorpie.org', 0, 0, 0, 0, '', '', '', '', 5, 5, 5, 0, 0, '0000-00-00 00:00:00', '910', 'DEPT10', 'dberger', 'd3476cc030a71d2779e226d05ca3f2e0');
COMMIT;