Dear {{parentPreferredName}} {{parentSurname}},
\r\nThis email includes a link to {{studentPreferredName}}''s {{reportName|title}} created on {{date}}.
\r\nClick the button below to download this report. To protect your student''s security and privacy, this download link will expire after 1 week.
\r\nThank you,
{{organisationAdministratorName}}
Dear {{studentPreferredName}} {{studentSurname}},
\r\nThis email includes a link to your {{reportName|title}} created on {{date}}.
\r\nClick the button below to download this report. To protect your security and privacy, this download link will expire after 1 week.
\r\nThank you,
{{organisationAdministratorName}}
Dear {{email}},
\r\nThank you for your admissions request. Please click the button below to access your current or pending application forms. You can also check the status of your forms as well as submit new forms.
\r\nThis is an automated email initiated by the admissions page at {{organisationNameShort}}. If you did not initiate this email, please let us know. You are welcome to reply to this email should you have any questions.
\r\nRegards,
{{organisationAdmissionsName}},
{{organisationNameShort}} Admissions Administrator
To whom it may concern,
\r\nThis email is being sent in relation to the application of a current or former student of your school: {{studentPreferredName}} {{studentSurname}}.
\r\nIn assessing their application for our school, we would like to enlist your help in completing the following reference form: {{applicationRefereeLink}}.
\r\nPlease feel free to contact me, should you have any questions in regard to this matter.
\r\nRegards,
{{organisationAdmissionsName}},
{{organisationNameShort}} Admissions Administrator
Dear {{parentTitle}} {{parentPreferredName}} {{parentSurname}},
\r\nThank you for applying for a student place at {{organisationName}}.
\r\nYour application was successfully submitted. Our admissions team will review your application and be in touch in due course.
\r\nIn the meantime, should you have any questions please contact {{organisationAdmissionsName}} at {{organisationAdmissionsEmail}}.
\r\nPlease find a copy of your submitted details below, for your reference:
{{submissionDetails|raw}}
Dear {{parentPreferredName}} {{parentSurname}},
\r\nYour {{applicationName}} for {{studentPreferredName}} {{studentSurname}} has been accepted.
\r\nWelcome to {{systemName}}, {{organisationNameShort}}''s system for managing school information. You can access the system by going to {{absoluteURL}} and logging in with your new username and password:
\r\nUsername: {{username}}
Password: {{password}}
In order to maintain the security of your data, we highly recommend you change your password to something easy to remember but hard to guess. This can be done by using the Preferences page after logging in (top-right of the screen).
\r\nPlease feel free to reply to this email should you have any questions.
\r\n{{organisationAdmissionsName}},
{{organisationNameShort}} Admissions Administrator
Dear {{studentPreferredName}} {{studentSurname}},
\r\nWelcome to {{systemName}}, {{organisationNameShort}}''s system for managing school information. You can access the system by going to {{absoluteURL}} and logging in with your new username and password:
\r\nUsername: {{username}}
Password: {{password}}
In order to maintain the security of your data, we highly recommend you change your password to something easy to remember but hard to guess. This can be done by using the Preferences page after logging in (top-right of the screen).
Please feel free to reply to this email should you have any questions.
\r\n{{organisationAdmissionsName}},
{{organisationNameShort}} Admissions Administrator
Thank you for your application submission. Please pay the following processing fee before your application is complete. Payment can be made by credit card, using our secure online payment gateway. Click the button below to pay now.
', '{\r\n "email": ["safeEmail"],\r\n "date": ["date"],\r\n "link": "https://gibbonedu.org",\r\n "applicationID": ["randomDigit"],\r\n "applicationName": "Sample Application Form",\r\n "applicationFee": ["numberBetween", 100, 400],\r\n "studentPreferredName": ["firstName"],\r\n "studentSurname": ["lastName"],\r\n "studentOfficialName": ["name"],\r\n "parentTitle": ["titleFemale"],\r\n "parentPreferredName": ["firstNameFemale"],\r\n "parentSurname": ["lastName"],\r\n "organisationAdmissionsName": ["name"],\r\n "organisationAdmissionsEmail": ["safeEmail"]\r\n}', '2022-05-25 18:54:31'), (000015, 'Core', 'Student Petty Cash', 'Finance', 'Student Petty Cash', 'Notice of Petty Cash Balance', 'Dear {{parentTitle}} {{parentPreferredName}} {{parentSurname}},
\r\nThis is a notice to let you know that {{studentPreferredName}} has a petty cash balance of {{amount}}. Please help us to remind them to repay this amount to the school.
\r\nThis is an automated message. Please contact {{organisationEmail}} with any questions.
', '{\r\n"parentEmail": ["safeEmail"], \r\n"date": ["date"],\r\n"amount": ["randomFloat", 2, 10, 100],\r\n"studentPreferredName": ["firstName"],\r\n"studentSurname": ["lastName"],\r\n"studentOfficialName": ["name"],\r\n"parentTitle": ["titleFemale"],\r\n"parentPreferredName": ["firstNameFemale"],\r\n"parentSurname": ["lastName"],\r\n"organisationEmail": ["safeEmail"],\r\n"organisationName": ["name"]\r\n}', '2025-01-24 01:30:16'), (000016, 'Core', 'Staff Petty Cash', 'Finance', 'Staff Petty Cash', 'Notice of Petty Cash Balance', 'Dear {{preferredName}},
\r\nThis is a notice to let you know that you have a petty cash balance of {{amount}}. Please help us to repay this amount at your earliest convenience.
\r\nThis is an automated message. Please contact {{organisationEmail}} with any questions.
', '{\r\n"email": ["safeEmail"], \r\n"date": ["date"],\r\n"amount": ["randomFloat", 2, 10, 100],\r\n"title": ["titleFemale"],\r\n"preferredName": ["firstName"],\r\n"surname": ["lastName"],\r\n"organisationEmail": ["safeEmail"],\r\n"organisationName": ["name"]\r\n}', '2025-01-24 01:30:16'), (000017, 'Core', 'Parent Notification for Student Lending Item', 'Library', 'Parent Notification for Student Lending Item', 'Notice of Student Lending Item', 'Dear {{preferredName}},
\r\nThis is a notice to let you know that {{studentPreferredName}} has recently borrowed an item from the library. Please return the item according to the return date.
\r\nThis is an automated message. Please contact {{organisationEmail}} with any questions.
', '{\r\n"parentEmail": ["safeEmail"], \r\n"date": ["date"],\r\n"amount": ["randomFloat", 2, 10, 100],\r\n"studentPreferredName": ["firstName"],\r\n"studentSurname": ["lastName"],\r\n"studentOfficialName": ["name"],\r\n"parentTitle": ["titleFemale"],\r\n"parentPreferredName": ["firstNameFemale"],\r\n"parentSurname": ["lastName"],\r\n"organisationEmail": ["safeEmail"],\r\n"organisationName": ["name"]\r\n}', '2025-11-20 09:46:01'); -- -------------------------------------------------------- -- -- Table structure for table `gibbonExternalAssessment` -- CREATE TABLE `gibbonExternalAssessment` ( `gibbonExternalAssessmentID` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `nameShort` varchar(10) NOT NULL, `description` varchar(255) NOT NULL, `website` text NOT NULL, `active` enum('Y','N') NOT NULL, `allowFileUpload` enum('Y','N') NOT NULL DEFAULT 'N', PRIMARY KEY (`gibbonExternalAssessmentID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=4 ; -- -- Dumping data for table `gibbonExternalAssessment` -- INSERT INTO `gibbonExternalAssessment` VALUES (0001, 'Cognitive Abilities Test', 'CAT', 'UK-based standardised tests that provides scores in maths, verbal and non-verbal skills, as well as KS3 and GCSE predicted grades.', '', 'Y', 'N'), (0002, 'GCSE/iGCSE', 'GCSE', 'UK-based General Certificate of Secondary Education', '', 'Y', 'N'), (0003, 'IB Diploma', 'IB Diploma', 'International Baccalaureate Diploma', 'http://www.ibo.org/', 'Y', 'N'); -- -------------------------------------------------------- -- -- Table structure for table `gibbonExternalAssessmentField` -- CREATE TABLE `gibbonExternalAssessmentField` ( `gibbonExternalAssessmentFieldID` int(6) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonExternalAssessmentID` int(4) unsigned zerofill NOT NULL, `name` varchar(50) NOT NULL, `category` varchar(50) NOT NULL, `order` int NOT NULL, `gibbonScaleID` int(5) unsigned zerofill NOT NULL, `gibbonYearGroupIDList` varchar(255) DEFAULT NULL, PRIMARY KEY (`gibbonExternalAssessmentFieldID`), KEY `gibbonExternalAssessmentID` (`gibbonExternalAssessmentID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=129 ; -- -- Dumping data for table `gibbonExternalAssessmentField` -- INSERT INTO `gibbonExternalAssessmentField` VALUES (000001, 0001, 'Maths', '1_Scores', 1, 00010, NULL), (000002, 0001, 'Non-Verbal', '1_Scores', 2, 00010, NULL), (000003, 0001, 'Verbal', '1_Scores', 3, 00010, NULL), (000004, 0001, 'English', '2_KS3 Target Grades', 3, 00011, '001,002,003'), (000005, 0001, 'Maths', '2_KS3 Target Grades', 7, 00011, '001,002,003'), (000006, 0001, 'Science', '2_KS3 Target Grades', 11, 00011, '001,002,003'), (000007, 0001, 'English Language', '3_GCSE Target Grades', 10, 00012, '004,005'), (000008, 0001, 'Mathematics', '3_GCSE Target Grades', 18, 00012, '004,005'), (000009, 0001, 'Science - Double Award', '3_GCSE Target Grades', 25, 00012, '004,005'), (000010, 0001, 'Art & Design', '2_KS3 Target Grades', 1, 00011, '001,002,003'), (000011, 0001, 'Design & Tech', '2_KS3 Target Grades', 2, 00011, '001,002,003'), (000012, 0001, 'Geography', '2_KS3 Target Grades', 4, 00011, '001,002,003'), (000013, 0001, 'History', '2_KS3 Target Grades', 5, 00011, '001,002,003'), (000014, 0001, 'ICT', '2_KS3 Target Grades', 6, 00011, '001,002,003'), (000015, 0001, 'MFL', '2_KS3 Target Grades', 8, 00011, '001,002,003'), (000016, 0001, 'Music', '2_KS3 Target Grades', 9, 00011, '001,002,003'), (000017, 0001, 'PE', '2_KS3 Target Grades', 10, 00011, '001,002,003'), (000018, 0001, 'Art & Design', '3_GCSE Target Grades', 1, 00012, '004,005'), (000019, 0001, 'Business Studies', '3_GCSE Target Grades', 2, 00012, '004,005'), (000020, 0001, 'D&T - Electronics', '3_GCSE Target Grades', 3, 00012, '004,005'), (000021, 0001, 'D&T - Food', '3_GCSE Target Grades', 4, 00012, '004,005'), (000022, 0001, 'D&T - Graphics', '3_GCSE Target Grades', 5, 00012, '004,005'), (000023, 0001, 'D&T - Resistant Materials', '3_GCSE Target Grades', 6, 00012, '004,005'), (000024, 0001, 'D&T - Systems Control', '3_GCSE Target Grades', 7, 00012, '004,005'), (000025, 0001, 'D&T - Textiles', '3_GCSE Target Grades', 8, 00012, '004,005'), (000026, 0001, 'Drama', '3_GCSE Target Grades', 9, 00012, '004,005'), (000027, 0001, 'English Literature', '3_GCSE Target Grades', 11, 00012, '004,005'), (000028, 0001, 'French', '3_GCSE Target Grades', 12, 00012, '004,005'), (000029, 0001, 'Geography', '3_GCSE Target Grades', 13, 00012, '004,005'), (000030, 0001, 'German', '3_GCSE Target Grades', 14, 00012, '004,005'), (000031, 0001, 'History', '3_GCSE Target Grades', 15, 00012, '004,005'), (000032, 0001, 'Home Economics', '3_GCSE Target Grades', 16, 00012, '004,005'), (000033, 0001, 'Information Technology', '3_GCSE Target Grades', 17, 00012, '004,005'), (000034, 0001, 'Media Studies', '3_GCSE Target Grades', 19, 00012, '004,005'), (000035, 0001, 'Music', '3_GCSE Target Grades', 20, 00012, '004,005'), (000036, 0001, 'Physical Education', '3_GCSE Target Grades', 21, 00012, '004,005'), (000037, 0001, 'Religious Education', '3_GCSE Target Grades', 22, 00012, '004,005'), (000038, 0001, 'Science - Biology', '3_GCSE Target Grades', 23, 00012, '004,005'), (000039, 0001, 'Science - Chemistry', '3_GCSE Target Grades', 24, 00012, '004,005'), (000040, 0001, 'Science - Physics', '3_GCSE Target Grades', 26, 00012, '004,005'), (000041, 0001, 'Science - Single Award', '3_GCSE Target Grades', 27, 00012, '004,005'), (000042, 0001, 'Sociology', '3_GCSE Target Grades', 28, 00012, '004,005'), (000043, 0001, 'Spanish', '3_GCSE Target Grades', 29, 00012, '004,005'), (000044, 0001, 'Statistics', '3_GCSE Target Grades', 30, 00012, '004,005'), (000045, 0002, 'Art & Design', '1_Final Grade', 1, 00003, '004,005'), (000046, 0002, 'Chinese (Mandarin)', '1_Final Grade', 2, 00003, '004,005'), (000047, 0002, 'Drama', '1_Final Grade', 3, 00003, '004,005'), (000048, 0002, 'Dutch', '1_Final Grade', 4, 00003, '004,005'), (000049, 0002, 'Economics', '1_Final Grade', 5, 00003, '004,005'), (000050, 0002, 'English Language', '1_Final Grade', 6, 00003, '004,005'), (000051, 0002, 'English Literature', '1_Final Grade', 7, 00003, '004,005'), (000052, 0002, 'Environmental Management', '1_Final Grade', 8, 00003, '004,005'), (000053, 0002, 'Mathematics', '1_Final Grade', 9, 00003, '004,005'), (000054, 0002, 'Media Studies', '1_Final Grade', 10, 00003, '004,005'), (000055, 0002, 'Physical Education', '1_Final Grade', 11, 00003, '004,005'), (000056, 0002, 'Science - Double Award', '1_Final Grade', 12, 00003, '004,005'), (000057, 0002, 'Spanish', '1_Final Grade', 13, 00003, '004,005'), (000058, 0002, 'Art & Design', '0_Target Grade', 1, 00012, '004,005'), (000059, 0002, 'Chinese (Mandarin)', '0_Target Grade', 2, 00012, '004,005'), (000060, 0002, 'Drama', '0_Target Grade', 3, 00012, '004,005'), (000061, 0002, 'Dutch', '0_Target Grade', 4, 00012, '004,005'), (000062, 0002, 'Economics', '0_Target Grade', 5, 00012, '004,005'), (000063, 0002, 'English Language', '0_Target Grade', 6, 00012, '004,005'), (000064, 0002, 'English Literature', '0_Target Grade', 7, 00012, '004,005'), (000065, 0002, 'Environmental Management', '0_Target Grade', 8, 00012, '004,005'), (000066, 0002, 'Mathematics', '0_Target Grade', 9, 00012, '004,005'), (000067, 0002, 'Media Studies', '0_Target Grade', 10, 00012, '004,005'), (000068, 0002, 'Physical Education', '0_Target Grade', 11, 00012, '004,005'), (000069, 0002, 'Science - Double Award', '0_Target Grade', 12, 00012, '004,005'), (000070, 0002, 'Spanish', '0_Target Grade', 13, 00012, '004,005'), (000071, 0003, 'IB Diploma Total', '0_Target Grade', 0, 00014, '006,007'), (000072, 0003, 'IB Diploma Total', '1_Final Grade', 0, 00014, '006,007'), (000073, 0003, 'Chinese A: Language and Literature HL', '0_Target Grade', 1, 00013, '006,007'), (000074, 0003, 'Chinese A: Language and Literature SL', '0_Target Grade', 2, 00013, '006,007'), (000075, 0003, 'English A: Language and Literature HL', '0_Target Grade', 3, 00013, '006,007'), (000076, 0003, 'English A: Language and Literature SL', '0_Target Grade', 4, 00013, '006,007'), (000077, 0003, 'English A: Literature HL', '0_Target Grade', 5, 00013, '006,007'), (000078, 0003, 'English A: Literature SL', '0_Target Grade', 6, 00013, '006,007'), (000079, 0003, 'Self-Taught Language SL', '0_Target Grade', 7, 00013, '006,007'), (000080, 0003, 'Chinese B HL', '0_Target Grade', 8, 00013, '006,007'), (000081, 0003, 'Chinese B SL', '0_Target Grade', 9, 00013, '006,007'), (000082, 0003, 'Spanish B HL', '0_Target Grade', 10, 00013, '006,007'), (000083, 0003, 'Spanish B SL', '0_Target Grade', 11, 00013, '006,007'), (000084, 0003, 'Italian ab initio SL', '0_Target Grade', 12, 00013, '006,007'), (000085, 0003, 'Economics HL', '0_Target Grade', 13, 00013, '006,007'), (000086, 0003, 'Economics SL', '0_Target Grade', 14, 00013, '006,007'), (000087, 0003, 'Psychology HL', '0_Target Grade', 15, 00013, '006,007'), (000088, 0003, 'Psychology SL', '0_Target Grade', 16, 00013, '006,007'), (000089, 0003, 'Environmental Systems and Society SL', '0_Target Grade', 17, 00013, '006,007'), (000090, 0003, 'Chemistry HL', '0_Target Grade', 18, 00013, '006,007'), (000091, 0003, 'Chemistry SL', '0_Target Grade', 19, 00013, '006,007'), (000092, 0003, 'Physics HL', '0_Target Grade', 20, 00013, '006,007'), (000093, 0003, 'Physics SL', '0_Target Grade', 21, 00013, '006,007'), (000094, 0003, 'Mathematics HL', '0_Target Grade', 22, 00013, '006,007'), (000095, 0003, 'Mathematics SL', '0_Target Grade', 23, 00013, '006,007'), (000096, 0003, 'Maths Studies SL', '0_Target Grade', 24, 00013, '006,007'), (000097, 0003, 'Theatre Arts HL', '0_Target Grade', 25, 00013, '006,007'), (000098, 0003, 'Theatre Arts SL', '0_Target Grade', 26, 00013, '006,007'), (000099, 0003, 'Visual Arts HL', '0_Target Grade', 27, 00013, '006,007'), (000100, 0003, 'Visual Arts SL', '0_Target Grade', 28, 00013, '006,007'), (000101, 0003, 'Chinese A: Language and Literature HL', '1_Final Grade', 1, 00013, '006,007'), (000102, 0003, 'Chinese A: Language and Literature SL', '1_Final Grade', 2, 00013, '006,007'), (000103, 0003, 'English A: Language and Literature HL', '1_Final Grade', 3, 00013, '006,007'), (000104, 0003, 'English A: Language and Literature SL', '1_Final Grade', 4, 00013, '006,007'), (000105, 0003, 'English A: Literature HL', '1_Final Grade', 5, 00013, '006,007'), (000106, 0003, 'English A: Literature SL', '1_Final Grade', 6, 00013, '006,007'), (000107, 0003, 'Self-Taught Language SL', '1_Final Grade', 7, 00013, '006,007'), (000108, 0003, 'Chinese B HL', '1_Final Grade', 8, 00013, '006,007'), (000109, 0003, 'Chinese B SL', '1_Final Grade', 9, 00013, '006,007'), (000110, 0003, 'Spanish B HL', '1_Final Grade', 10, 00013, '006,007'), (000111, 0003, 'Spanish B SL', '1_Final Grade', 11, 00013, '006,007'), (000112, 0003, 'Italian ab initio SL', '1_Final Grade', 12, 00013, '006,007'), (000113, 0003, 'Economics HL', '1_Final Grade', 13, 00013, '006,007'), (000114, 0003, 'Economics SL', '1_Final Grade', 14, 00013, '006,007'), (000115, 0003, 'Psychology HL', '1_Final Grade', 15, 00013, '006,007'), (000116, 0003, 'Psychology SL', '1_Final Grade', 16, 00013, '006,007'), (000117, 0003, 'Environmental Systems and Society SL', '1_Final Grade', 17, 00013, '006,007'), (000118, 0003, 'Chemistry HL', '1_Final Grade', 18, 00013, '006,007'), (000119, 0003, 'Chemistry SL', '1_Final Grade', 19, 00013, '006,007'), (000120, 0003, 'Physics HL', '1_Final Grade', 20, 00013, '006,007'), (000121, 0003, 'Physics SL', '1_Final Grade', 21, 00013, '006,007'), (000122, 0003, 'Mathematics HL', '1_Final Grade', 22, 00013, '006,007'), (000123, 0003, 'Mathematics SL', '1_Final Grade', 23, 00013, '006,007'), (000124, 0003, 'Maths Studies SL', '1_Final Grade', 24, 00013, '006,007'), (000125, 0003, 'Theatre Arts HL', '1_Final Grade', 25, 00013, '006,007'), (000126, 0003, 'Theatre Arts SL', '1_Final Grade', 26, 00013, '006,007'), (000127, 0003, 'Visual Arts HL', '1_Final Grade', 27, 00013, '006,007'), (000128, 0003, 'Visual Arts SL', '1_Final Grade', 28, 00013, '006,007'); -- -------------------------------------------------------- -- -- Table structure for table `gibbonExternalAssessmentStudent` -- CREATE TABLE `gibbonExternalAssessmentStudent` ( `gibbonExternalAssessmentStudentID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonExternalAssessmentID` int(4) unsigned zerofill NOT NULL, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `date` date NOT NULL, `attachment` varchar(255) NOT NULL, PRIMARY KEY (`gibbonExternalAssessmentStudentID`), KEY `gibbonExternalAssessmentID` (`gibbonExternalAssessmentID`), KEY `gibbonPersonID` (`gibbonPersonID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonExternalAssessmentStudentEntry` -- CREATE TABLE `gibbonExternalAssessmentStudentEntry` ( `gibbonExternalAssessmentStudentEntryID` int(14) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonExternalAssessmentStudentID` int(12) unsigned zerofill NOT NULL, `gibbonExternalAssessmentFieldID` int(6) unsigned zerofill NOT NULL, `gibbonScaleGradeID` int(7) unsigned zerofill DEFAULT NULL COMMENT 'Key for the actual grade achieved', PRIMARY KEY (`gibbonExternalAssessmentStudentEntryID`), KEY `gibbonExternalAssessmentStudentID` (`gibbonExternalAssessmentStudentID`), KEY `gibbonExternalAssessmentFieldID` (`gibbonExternalAssessmentFieldID`), KEY `gibbonScaleGradeID` (`gibbonScaleGradeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFamily` -- CREATE TABLE `gibbonFamily` ( `gibbonFamilyID` int(7) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `nameAddress` varchar(100) NOT NULL COMMENT 'The formal name to be used for addressing the family (e.g. Mr. & Mrs. Smith)', `homeAddress` mediumtext NOT NULL, `homeAddressDistrict` varchar(255) NOT NULL, `homeAddressCountry` varchar(255) NOT NULL, `status` enum('Married','Separated','Divorced','De Facto','Other','Single') NOT NULL, `languageHomePrimary` varchar(30) NOT NULL, `languageHomeSecondary` varchar(30) DEFAULT NULL, `familySync` varchar(50) DEFAULT NULL, `fields` text, PRIMARY KEY (`gibbonFamilyID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFamilyAdult` -- CREATE TABLE `gibbonFamilyAdult` ( `gibbonFamilyAdultID` int(8) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonFamilyID` int(7) unsigned zerofill NOT NULL, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `comment` text NOT NULL, `childDataAccess` enum('Y','N') NOT NULL, `contactPriority` int NOT NULL DEFAULT '1', `contactCall` enum('Y','N') NOT NULL, `contactSMS` enum('Y','N') NOT NULL, `contactEmail` enum('Y','N') NOT NULL, `contactMail` enum('Y','N') NOT NULL, PRIMARY KEY (`gibbonFamilyAdultID`), KEY `gibbonFamilyID` (`gibbonFamilyID`,`contactPriority`), KEY `gibbonPersonIndex` (`gibbonPersonID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFamilyChild` -- CREATE TABLE `gibbonFamilyChild` ( `gibbonFamilyChildID` int(8) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonFamilyID` int(7) unsigned zerofill NOT NULL, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `comment` text NOT NULL, PRIMARY KEY (`gibbonFamilyChildID`), KEY `gibbonPersonIndex` (`gibbonPersonID`), KEY `gibbonFamilyIndex` (`gibbonFamilyID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFamilyRelationship` -- CREATE TABLE `gibbonFamilyRelationship` ( `gibbonFamilyRelationshipID` int(9) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonFamilyID` int(7) unsigned zerofill NOT NULL, `gibbonPersonID1` int(10) unsigned zerofill NOT NULL, `gibbonPersonID2` int(10) unsigned zerofill NOT NULL, `relationship` varchar(50) NOT NULL, PRIMARY KEY (`gibbonFamilyRelationshipID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Person 1 is [relationship] to person 2?' AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFamilyUpdate` -- CREATE TABLE `gibbonFamilyUpdate` ( `gibbonFamilyUpdateID` int(9) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonSchoolYearID` int(3) unsigned zerofill DEFAULT NULL, `status` enum('Pending','Complete') NOT NULL DEFAULT 'Pending', `gibbonFamilyID` int(7) unsigned zerofill NOT NULL, `nameAddress` varchar(100) NOT NULL DEFAULT '', `homeAddress` mediumtext NOT NULL, `homeAddressDistrict` varchar(255) NOT NULL DEFAULT '', `homeAddressCountry` varchar(255) NOT NULL DEFAULT '', `languageHomePrimary` varchar(30) NOT NULL, `languageHomeSecondary` varchar(30) NOT NULL, `gibbonPersonIDUpdater` int(10) unsigned zerofill NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`gibbonFamilyUpdateID`), KEY `gibbonFamilyIndex` (`gibbonFamilyID`,`gibbonSchoolYearID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFileExtension` -- CREATE TABLE `gibbonFileExtension` ( `gibbonFileExtensionID` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT, `type` enum('Document','Spreadsheet','Presentation','Graphics/Design','Video','Audio','Other') NOT NULL DEFAULT 'Other', `extension` varchar(7) NOT NULL, `name` varchar(50) NOT NULL, PRIMARY KEY (`gibbonFileExtensionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=47 ; -- -- Dumping data for table `gibbonFileExtension` -- INSERT INTO `gibbonFileExtension` VALUES (0001, 'Document', 'doc', 'Microsoft Word 97/2000/XP'), (0002, 'Document', 'docx', 'Microsoft Word 2007+'), (0003, 'Document', 'pages', 'Apple Pages'), (0004, 'Document', 'odt', 'OpenOffice Text'), (0005, 'Document', 'txt', 'Plain Text'), (0006, 'Document', 'rtf', 'Rich Text Format'), (0007, 'Spreadsheet', 'xls', 'Microsoft Excel 97/2000/XP'), (0008, 'Spreadsheet', 'xlsx', 'Microsoft Excel 2007+'), (0009, 'Spreadsheet', 'ods', 'OpenOffice SpreadSheet'), (0010, 'Spreadsheet', 'numbers', 'Apple Numbers'), (0011, 'Spreadsheet', 'csv', 'Comma Seperate Values'), (0012, 'Presentation', 'ppt', 'Microsoft PowerPoint 97/2000/XP'), (0013, 'Presentation', 'pptx', 'Microsoft PowerPoint 2007+'), (0014, 'Presentation', 'key', 'Apple Keynote'), (0015, 'Audio', 'mp3', 'MPEG Audio'), (0016, 'Audio', 'mp4', 'MPEG Audio'), (0017, 'Audio', 'm4a', 'MPEG Audio'), (0018, 'Audio', 'wma', 'Windows Media Audio'), (0019, 'Audio', 'ogg', 'Vorbis Ogg'), (0020, 'Audio', 'aac', 'MPEG Audio'), (0021, 'Graphics/Design', 'png', 'Portable Network Graphics'), (0022, 'Graphics/Design', 'jpg', 'Joint Picture Expert Group'), (0023, 'Graphics/Design', 'gif', 'Graphics Interchange Format'), (0024, 'Graphics/Design', 'acorn', 'Acorn'), (0025, 'Graphics/Design', 'ai', 'Adobe Illustrator'), (0026, 'Graphics/Design', 'psd', 'Adobe Photoshop'), (0028, 'Graphics/Design', 'xcf', 'GIMP eXperimental Computing Facility'), (0029, 'Video', 'avi', 'Audio Video Interleave'), (0030, 'Video', 'wmv', 'Windows Media Video'), (0031, 'Video', 'mpg', 'MPEG Video'), (0032, 'Video', 'mov', 'QuickTime Movie'), (0033, 'Video', 'flv', 'Adobe Flash Video'), (0034, 'Other', 'fla', 'Adobe Flash'), (0035, 'Video', 'swf', 'Adobe Flash'), (0036, 'Graphics/Design', 'skp', 'Google SketchUp'), (0037, 'Document', 'pdf', 'Portable Document Format'), (0038, 'Graphics/Design', 'jpeg', 'Joint Picture Expert Group'), (0039, 'Video', 'mpeg', 'MPEG Video'), (0040, 'Other', 'sb', 'Scratch'), (0041, 'Video', 'm4v', 'MPG Varient'), (0042, 'Other', 'zip', 'ZIP Compressed Archive'), (0043, 'Document', 'htm', 'HyperText Marrkup Language'), (0044, 'Document', 'html', 'HyperText Marrkup Language'), (0045, 'Video', '3gp', '3rd Generation Partnership Video'), (0046, 'Other', 'sb2', 'Scratch 2'); -- -------------------------------------------------------- -- -- Table structure for table `gibbonFinanceBillingSchedule` -- CREATE TABLE `gibbonFinanceBillingSchedule` ( `gibbonFinanceBillingScheduleID` int(6) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonSchoolYearID` int(3) unsigned zerofill NOT NULL, `name` varchar(100) NOT NULL, `description` text NOT NULL, `active` enum('Y','N') NOT NULL DEFAULT 'Y', `invoiceIssueDate` date DEFAULT NULL, `invoiceDueDate` date DEFAULT NULL, `gibbonPersonIDCreator` int(10) unsigned zerofill NOT NULL, `timestampCreator` timestamp NULL DEFAULT NULL, `gibbonPersonIDUpdate` int(10) unsigned zerofill DEFAULT NULL, `timestampUpdate` timestamp NULL DEFAULT NULL, PRIMARY KEY (`gibbonFinanceBillingScheduleID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFinanceBudget` -- CREATE TABLE `gibbonFinanceBudget` ( `gibbonFinanceBudgetID` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, `nameShort` varchar(8) NOT NULL, `active` enum('Y','N') NOT NULL DEFAULT 'Y', `category` varchar(255) NOT NULL, `gibbonPersonIDCreator` int(10) unsigned zerofill NOT NULL, `timestampCreator` timestamp NULL DEFAULT NULL, `gibbonPersonIDUpdate` int(10) unsigned zerofill DEFAULT NULL, `timestampUpdate` timestamp NULL DEFAULT NULL, PRIMARY KEY (`gibbonFinanceBudgetID`), UNIQUE KEY `name` (`name`), UNIQUE KEY `nameShort` (`nameShort`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFinanceBudgetCycle` -- CREATE TABLE `gibbonFinanceBudgetCycle` ( `gibbonFinanceBudgetCycleID` int(6) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(7) NOT NULL, `status` enum('Past','Current','Upcoming') NOT NULL DEFAULT 'Upcoming', `dateStart` date NOT NULL, `dateEnd` date NOT NULL, `sequenceNumber` int NOT NULL, `gibbonPersonIDCreator` int(10) unsigned zerofill NOT NULL, `timestampCreator` timestamp NULL DEFAULT NULL, `gibbonPersonIDUpdate` int(10) unsigned zerofill DEFAULT NULL, `timestampUpdate` timestamp NULL DEFAULT NULL, PRIMARY KEY (`gibbonFinanceBudgetCycleID`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFinanceBudgetCycleAllocation` -- CREATE TABLE `gibbonFinanceBudgetCycleAllocation` ( `gibbonFinanceBudgetCycleAllocationID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonFinanceBudgetID` int(4) unsigned zerofill NOT NULL, `gibbonFinanceBudgetCycleID` int(6) unsigned zerofill NOT NULL, `value` decimal(14,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`gibbonFinanceBudgetCycleAllocationID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFinanceBudgetPerson` -- CREATE TABLE `gibbonFinanceBudgetPerson` ( `gibbonFinanceBudgetPersonID` int(8) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonFinanceBudgetID` int(4) unsigned zerofill NOT NULL, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `access` enum('Full','Write','Read') NOT NULL, PRIMARY KEY (`gibbonFinanceBudgetPersonID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFinanceExpense` -- CREATE TABLE `gibbonFinanceExpense` ( `gibbonFinanceExpenseID` int(14) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonFinanceBudgetID` int(4) unsigned zerofill NOT NULL, `gibbonFinanceBudgetCycleID` int(6) unsigned zerofill NOT NULL, `title` varchar(60) NOT NULL, `body` text NOT NULL, `status` enum('Requested','Approved','Rejected','Cancelled','Ordered','Paid') NOT NULL, `cost` decimal(12,2) NOT NULL, `countAgainstBudget` enum('Y','N') NOT NULL DEFAULT 'Y', `purchaseBy` enum('School','Self') NOT NULL DEFAULT 'School', `purchaseDetails` text NOT NULL, `paymentMethod` enum('Cash','Cheque','Credit Card','Bank Transfer','Other') DEFAULT NULL, `paymentDate` date DEFAULT NULL, `paymentAmount` decimal(12,2) DEFAULT NULL, `gibbonPersonIDPayment` int(10) unsigned zerofill DEFAULT NULL, `paymentID` varchar(100) DEFAULT NULL, `paymentReimbursementReceipt` varchar(255) NOT NULL, `paymentReimbursementStatus` enum('Requested','Complete') DEFAULT NULL, `gibbonPersonIDCreator` int(10) unsigned zerofill NOT NULL, `timestampCreator` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `statusApprovalBudgetCleared` enum('N','Y') NOT NULL DEFAULT 'N', PRIMARY KEY (`gibbonFinanceExpenseID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFinanceExpenseApprover` -- CREATE TABLE `gibbonFinanceExpenseApprover` ( `gibbonFinanceExpenseApproverID` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `sequenceNumber` int DEFAULT NULL, `gibbonPersonIDCreator` int(10) unsigned zerofill NOT NULL, `timestampCreator` timestamp NULL DEFAULT NULL, `gibbonPersonIDUpdate` int(10) unsigned zerofill DEFAULT NULL, `timestampUpdate` timestamp NULL DEFAULT NULL, PRIMARY KEY (`gibbonFinanceExpenseApproverID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFinanceExpenseLog` -- CREATE TABLE `gibbonFinanceExpenseLog` ( `gibbonFinanceExpenseLogID` int(16) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonFinanceExpenseID` int(14) unsigned zerofill NOT NULL, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `action` enum('Request','Approval - Partial - Budget','Approval - Partial - School','Approval - Final','Approval - Exempt','Rejection','Cancellation','Order','Payment','Reimbursement Request','Reimbursement Completion','Comment') NOT NULL, `comment` text NOT NULL, PRIMARY KEY (`gibbonFinanceExpenseLogID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFinanceFee` -- CREATE TABLE `gibbonFinanceFee` ( `gibbonFinanceFeeID` int(6) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonSchoolYearID` int(3) unsigned zerofill NOT NULL, `name` varchar(100) NOT NULL, `nameShort` varchar(6) NOT NULL, `description` text NOT NULL, `active` enum('Y','N') NOT NULL DEFAULT 'Y', `gibbonFinanceFeeCategoryID` int(4) unsigned zerofill NOT NULL, `fee` decimal(12,2) NOT NULL, `gibbonPersonIDCreator` int(10) unsigned zerofill NOT NULL, `timestampCreator` timestamp NULL DEFAULT NULL, `gibbonPersonIDUpdate` int(10) unsigned zerofill DEFAULT NULL, `timestampUpdate` timestamp NULL DEFAULT NULL, PRIMARY KEY (`gibbonFinanceFeeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFinanceFeeCategory` -- CREATE TABLE `gibbonFinanceFeeCategory` ( `gibbonFinanceFeeCategoryID` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `nameShort` varchar(6) NOT NULL, `description` text NOT NULL, `active` enum('Y','N') NOT NULL, `gibbonPersonIDCreator` int(10) unsigned zerofill NOT NULL, `timestampCreator` timestamp NULL DEFAULT NULL, `gibbonPersonIDUpdate` int(10) unsigned zerofill DEFAULT NULL, `timestampUpdate` timestamp NULL DEFAULT NULL, PRIMARY KEY (`gibbonFinanceFeeCategoryID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=2 ; -- -- Dumping data for table `gibbonFinanceFeeCategory` -- INSERT INTO `gibbonFinanceFeeCategory` VALUES (0001, 'Other', 'OTHR', 'Category for fees not fitting into any other category.', 'Y', 0000000001, '2013-07-12 08:25:32', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `gibbonFinanceInvoice` -- CREATE TABLE `gibbonFinanceInvoice` ( `gibbonFinanceInvoiceID` int(14) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonSchoolYearID` int(3) unsigned zerofill NOT NULL, `gibbonFinanceInvoiceeID` int(10) unsigned zerofill NOT NULL, `invoiceTo` enum('Family','Company') NOT NULL DEFAULT 'Family', `billingScheduleType` enum('Scheduled','Ad Hoc') NOT NULL DEFAULT 'Ad Hoc', `separated` enum('N','Y') DEFAULT NULL COMMENT 'Has this invoice been separated from its schedule in gibbonFinanceBillingSchedule? Only applies to scheduled invoices. Separation takes place during invoice issueing.', `gibbonFinanceBillingScheduleID` int(6) unsigned zerofill DEFAULT NULL, `status` enum('Pending','Issued','Paid','Paid - Partial','Cancelled','Refunded') NOT NULL DEFAULT 'Pending', `gibbonFinanceFeeCategoryIDList` text, `invoiceIssueDate` date DEFAULT NULL, `invoiceDueDate` date DEFAULT NULL, `paidDate` date DEFAULT NULL, `paidAmount` decimal(13,2) DEFAULT NULL COMMENT 'The current running total amount paid to this invoice', `gibbonPaymentID` int(14) unsigned zerofill DEFAULT NULL, `reminderCount` int NOT NULL DEFAULT '0', `notes` text NOT NULL, `key` varchar(40) NOT NULL, `gibbonPersonIDCreator` int(10) unsigned zerofill NOT NULL, `timestampCreator` timestamp NULL DEFAULT NULL, `gibbonPersonIDUpdate` int(10) unsigned zerofill DEFAULT NULL, `timestampUpdate` timestamp NULL DEFAULT NULL, PRIMARY KEY (`gibbonFinanceInvoiceID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFinanceInvoicee` -- CREATE TABLE `gibbonFinanceInvoicee` ( `gibbonFinanceInvoiceeID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `invoiceTo` enum('Family','Company') NOT NULL, `companyName` varchar(100) DEFAULT NULL, `companyContact` varchar(100) DEFAULT NULL, `companyAddress` varchar(255) DEFAULT NULL, `companyEmail` text, `companyCCFamily` enum('N','Y') DEFAULT NULL COMMENT 'When company is billed, should family receive a copy?', `companyPhone` varchar(20) DEFAULT NULL, `companyAll` enum('Y','N') DEFAULT NULL COMMENT 'Should company pay all invoices?.', `gibbonFinanceFeeCategoryIDList` text COMMENT 'If companyAll is N, list category IDs for campany to pay here.', PRIMARY KEY (`gibbonFinanceInvoiceeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFinanceInvoiceeUpdate` -- CREATE TABLE `gibbonFinanceInvoiceeUpdate` ( `gibbonFinanceInvoiceeUpdateID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonSchoolYearID` int(3) unsigned zerofill DEFAULT NULL, `status` enum('Pending','Complete') NOT NULL DEFAULT 'Pending', `gibbonFinanceInvoiceeID` int(10) unsigned zerofill NOT NULL, `invoiceTo` enum('Family','Company') NOT NULL, `companyName` varchar(100) DEFAULT NULL, `companyContact` varchar(100) DEFAULT NULL, `companyAddress` varchar(255) DEFAULT NULL, `companyEmail` text, `companyCCFamily` enum('N','Y') DEFAULT NULL COMMENT 'When company is billed, should family receive a copy?', `companyPhone` varchar(20) DEFAULT NULL, `companyAll` enum('Y','N') DEFAULT NULL COMMENT 'Should company pay all invoices?.', `gibbonFinanceFeeCategoryIDList` text COMMENT 'If companyAll is N, list category IDs for campany to pay here.', `gibbonPersonIDUpdater` int(10) unsigned zerofill NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`gibbonFinanceInvoiceeUpdateID`), KEY `gibbonInvoiceeIndex` (`gibbonFinanceInvoiceeID`,`gibbonSchoolYearID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFinanceInvoiceFee` -- CREATE TABLE `gibbonFinanceInvoiceFee` ( `gibbonFinanceInvoiceFeeID` int(15) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonFinanceInvoiceID` int(14) unsigned zerofill NOT NULL, `feeType` enum('Standard','Ad Hoc') NOT NULL DEFAULT 'Ad Hoc', `gibbonFinanceFeeID` int(6) unsigned zerofill DEFAULT NULL, `separated` enum('N','Y') DEFAULT NULL COMMENT 'Has this fee been separated from its parent in gibbonFinanceFee? Only applies to Standard fees. Separation takes place during invoice issueing.', `name` varchar(100) DEFAULT NULL, `description` text, `gibbonFinanceFeeCategoryID` int(4) unsigned zerofill DEFAULT NULL, `fee` decimal(12,2) DEFAULT NULL, `sequenceNumber` int DEFAULT NULL, PRIMARY KEY (`gibbonFinanceInvoiceFeeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFinancePettyCash` -- CREATE TABLE `gibbonFinancePettyCash` ( `gibbonFinancePettyCashID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonSchoolYearID` varchar(3) NOT NULL, `gibbonPersonID` int NOT NULL, `amount` decimal(12,2) NOT NULL, `reason` varchar(90) DEFAULT NULL, `notes` text, `gibbonPersonIDCreated` int DEFAULT NULL, `timestampCreated` timestamp NULL DEFAULT NULL, `actionRequired` varchar(60) DEFAULT NULL, `gibbonPersonIDStatus` int DEFAULT NULL, `timestampStatus` timestamp NULL DEFAULT NULL, `status` varchar(60) NOT NULL, PRIMARY KEY (`gibbonFinancePettyCashID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFirstAid` -- CREATE TABLE `gibbonFirstAid` ( `gibbonFirstAidID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPersonIDPatient` int(10) unsigned zerofill NOT NULL, `gibbonCourseClassID` int(8) unsigned zerofill DEFAULT NULL, `gibbonPersonIDFirstAider` int(10) unsigned zerofill NOT NULL, `gibbonPersonIDFollowUp` int(10) unsigned zerofill DEFAULT NULL, `gibbonSchoolYearID` int(3) unsigned zerofill NOT NULL, `description` text NOT NULL, `actionTaken` text NOT NULL, `followUp` text NOT NULL, `date` date NOT NULL, `timeIn` time NOT NULL, `timeOut` time DEFAULT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `fields` text, PRIMARY KEY (`gibbonFirstAidID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFirstAidFollowUp` -- CREATE TABLE `gibbonFirstAidFollowUp` ( `gibbonFirstAidFollowUpID` int(11) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonFirstAidID` int(10) unsigned zerofill NOT NULL, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `followUp` text NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`gibbonFirstAidFollowUpID`), KEY `gibbonFirstAidID` (`gibbonFirstAidID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonForm` -- CREATE TABLE `gibbonForm` ( `gibbonFormID` int(6) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(90) NOT NULL, `description` varchar(255) DEFAULT NULL, `type` varchar(60) NOT NULL, `active` enum('Y','N') NOT NULL DEFAULT 'Y', `public` enum('Y','N') NOT NULL DEFAULT 'N', `gibbonYearGroupIDList` varchar(255) DEFAULT NULL, `config` text, PRIMARY KEY (`gibbonFormID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=2 ; -- -- Dumping data for table `gibbonForm` -- INSERT INTO `gibbonForm` VALUES (000001, 'Sample Application Form', 'An example of many of the available fields in the application form. Be sure to edit this to customize it for your school.', 'Application', 'N', 'N', '001,002,003', '{"applicationReferee":"Y","applicationRefereeLink":"https:\\/\\/gibbonedu.org","sendSubmissionEmail":"Y","submissionEmailTemplate":"000011","createStudent":"Y","createFamily":"Y","createParents":"Y","autoHouseAssign":"Y","newStudentDetails":"Y","studentDefaultEmail":"[username]@localhost.test","studentDefaultWebsite":"http:\\/\\/localhost\\/[username]","enrolStudent":"Y","enableLimitedYearsOfEntry":"Y","availableYearsOfEntry":["025","026"],"createMedicalRecord":"Y","createINRecord":"Y","createInvoicee":"Y","acceptanceEmailStudentDefault":"N","acceptanceEmailStudentTemplate":"000013","acceptanceEmailParentDefault":"Y","acceptanceEmailParentTemplate":"000012"}'); -- -------------------------------------------------------- -- -- Table structure for table `gibbonFormField` -- CREATE TABLE `gibbonFormField` ( `gibbonFormFieldID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonFormPageID` int(8) unsigned zerofill NOT NULL, `fieldName` varchar(90) NOT NULL, `fieldType` varchar(60) NOT NULL, `fieldGroup` varchar(60) NOT NULL, `required` enum('Y','N','X') NOT NULL DEFAULT 'N', `hidden` enum('Y','N') NOT NULL DEFAULT 'N', `prefill` enum('Y','N') NOT NULL DEFAULT 'N', `options` text, `label` varchar(90) DEFAULT NULL, `description` text, `conditional` text COMMENT 'json', `defaultValue` varchar(255) DEFAULT NULL, `sequenceNumber` int NOT NULL, PRIMARY KEY (`gibbonFormFieldID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=105 ; -- -- Dumping data for table `gibbonFormField` -- INSERT INTO `gibbonFormField` VALUES (0000000001, 00000001, 'headingStudentPersonalData', 'subheading', 'LayoutHeadings', 'N', 'N', 'N', NULL, 'Student Personal Data', NULL, NULL, NULL, 2), (0000000002, 00000001, 'surname', 'varchar', 'StudentFields', 'X', 'N', 'N', NULL, 'Surname', 'Family name as shown in ID documents.', NULL, NULL, 3), (0000000003, 00000001, 'firstName', 'varchar', 'StudentFields', 'X', 'N', 'N', NULL, 'First Name', 'First name as shown in ID documents.', NULL, NULL, 4), (0000000004, 00000001, 'preferredName', 'varchar', 'StudentFields', 'Y', 'N', 'N', NULL, 'Preferred Name', 'Most common name, alias, nickname, etc.', NULL, NULL, 5), (0000000005, 00000001, 'officialName', 'varchar', 'StudentFields', 'Y', 'N', 'N', NULL, 'Official Name', 'Full name as shown in ID documents.', NULL, NULL, 6), (0000000006, 00000001, 'nameInCharacters', 'varchar', 'StudentFields', 'N', 'N', 'N', NULL, 'Name In Characters', 'Chinese or other character-based name.', NULL, NULL, 7), (0000000007, 00000001, 'gender', 'varchar', 'StudentFields', 'Y', 'N', 'N', NULL, 'Gender', NULL, NULL, NULL, 8), (0000000008, 00000001, 'dob', 'date', 'StudentFields', 'Y', 'N', 'N', NULL, 'Date of Birth', NULL, NULL, NULL, 9), (0000000009, 00000001, 'headingStudentBackground', 'subheading', 'LayoutHeadings', 'N', 'N', 'N', NULL, 'Student Background', NULL, NULL, NULL, 10), (0000000010, 00000001, 'languageHomePrimary', 'varchar', 'StudentFields', 'Y', 'N', 'N', NULL, 'Home Language - Primary', 'The primary language used in the student''s home.', NULL, NULL, 11), (0000000011, 00000001, 'languageHomeSecondary', 'varchar', 'StudentFields', 'N', 'N', 'N', NULL, 'Home Language - Secondary', NULL, NULL, NULL, 12), (0000000012, 00000001, 'languageFirst', 'varchar', 'StudentFields', 'Y', 'N', 'N', NULL, 'First Language', 'Student''s native/first/mother language.', NULL, NULL, 13), (0000000013, 00000001, 'languageSecond', 'varchar', 'StudentFields', 'N', 'N', 'N', NULL, 'Second Language', NULL, NULL, NULL, 14), (0000000014, 00000001, 'languageThird', 'varchar', 'StudentFields', 'N', 'N', 'N', NULL, 'Third Language', NULL, NULL, NULL, 15), (0000000015, 00000001, 'countryOfBirth', 'varchar', 'StudentFields', 'Y', 'N', 'N', NULL, 'Country of Birth', NULL, NULL, NULL, 16), (0000000016, 00000001, 'headingStudentContact', 'subheading', 'LayoutHeadings', 'N', 'N', 'N', NULL, 'Student Contact', NULL, NULL, NULL, 17), (0000000017, 00000001, 'phone', 'phone', 'StudentFields', 'N', 'N', 'N', NULL, 'Phone', 'Type, country code, number.', NULL, NULL, 20), (0000000018, 00000002, 'headingStudentEducation', 'heading', 'LayoutHeadings', 'N', 'N', 'N', NULL, 'Student Education', NULL, NULL, NULL, 1), (0000000019, 00000002, 'gibbonSchoolYearIDEntry', 'varchar', 'AdmissionsFields', 'X', 'N', 'N', NULL, 'Anticipated Year of Entry', 'What school year will the student join in?', NULL, NULL, 2), (0000000020, 00000002, 'dateStart', 'date', 'AdmissionsFields', 'X', 'N', 'N', NULL, 'Intended Start Date', 'Student''s intended first day at school.', NULL, NULL, 3), (0000000021, 00000002, 'gibbonYearGroupIDEntry', 'varchar', 'AdmissionsFields', 'X', 'N', 'N', NULL, 'Year Group at Entry', 'Which year level will student enter.', NULL, NULL, 4), (0000000022, 00000002, 'gibbonFormGroupIDEntry', 'varchar', 'AdmissionsFields', 'N', 'Y', 'N', NULL, 'Form Group at Entry', 'If set, the student will automatically be enrolled on Accept.', NULL, NULL, 5), (0000000023, 00000002, 'referenceEmail', 'varchar', 'AdmissionsFields', 'Y', 'N', 'N', NULL, 'Current School Reference Email', 'An email address for a referee at the applicant''s current school.', NULL, NULL, 9), (0000000024, 00000002, 'previousSchools', 'varchar', 'AdmissionsFields', 'N', 'N', 'N', NULL, 'Previous Schools', 'Please give information on the last two schools attended by the applicant.', NULL, NULL, 10), (0000000025, 00000002, 'dayType', 'varchar', 'AdmissionsFields', 'N', 'N', 'N', NULL, 'Day Type', 'This is example text.', NULL, NULL, 6), (0000000026, 00000003, 'headingHomeAddress', 'heading', 'LayoutHeadings', 'N', 'N', 'N', 'familySection', 'Home Address', 'This address will be used for all members of the family. If an individual within the family needs a different address, this can be set through Data Updater after admission.', NULL, NULL, 1), (0000000027, 00000003, 'homeAddress', 'varchar', 'FamilyFields', 'X', 'N', 'Y', NULL, 'Home Address', 'Unit, Building, Street', NULL, NULL, 2), (0000000028, 00000003, 'homeAddressDistrict', 'varchar', 'FamilyFields', 'Y', 'N', 'Y', NULL, 'Home Address (District)', 'County, State, District', NULL, NULL, 3), (0000000029, 00000003, 'homeAddressCountry', 'varchar', 'FamilyFields', 'Y', 'N', 'Y', NULL, 'Home Address (Country)', NULL, NULL, NULL, 4), (0000000030, 00000003, 'headingParentGuardian1PersonalData', 'subheading', 'LayoutHeadings', 'N', 'N', 'N', 'parentSection1', 'Parent/Guardian 1 Personal Data', NULL, NULL, NULL, 6), (0000000031, 00000003, 'parent1title', 'varchar', 'Parent1Fields', 'Y', 'N', 'Y', NULL, 'Title', NULL, NULL, NULL, 7), (0000000032, 00000003, 'parent1surname', 'varchar', 'Parent1Fields', 'X', 'N', 'Y', NULL, 'Surname', 'Family name as shown in ID documents.', NULL, NULL, 8), (0000000033, 00000003, 'parent1firstName', 'varchar', 'Parent1Fields', 'Y', 'N', 'Y', NULL, 'First Name', 'First name as shown in ID documents.', NULL, NULL, 9), (0000000034, 00000003, 'parent1preferredName', 'varchar', 'Parent1Fields', 'X', 'N', 'Y', NULL, 'Preferred Name', 'Most common name, alias, nickname, etc.', NULL, NULL, 10), (0000000035, 00000003, 'parent1officialName', 'varchar', 'Parent1Fields', 'Y', 'N', 'Y', NULL, 'Official Name', 'Full name as shown in ID documents.', NULL, NULL, 11), (0000000036, 00000003, 'parent1nameInCharacters', 'varchar', 'Parent1Fields', 'N', 'N', 'Y', NULL, 'Name In Characters', 'Chinese or other character-based name.', NULL, NULL, 12), (0000000037, 00000003, 'parent1gender', 'varchar', 'Parent1Fields', 'Y', 'N', 'Y', NULL, 'Gender', NULL, NULL, NULL, 13), (0000000038, 00000003, 'parent1relationship', 'varchar', 'Parent1Fields', 'Y', 'N', 'Y', NULL, 'Relationship', NULL, NULL, NULL, 14), (0000000039, 00000003, 'headingParentGuardian1PersonalBackground', 'subheading', 'LayoutHeadings', 'N', 'N', 'N', 'parentSection1', 'Parent/Guardian 1 Personal Background', NULL, NULL, NULL, 15), (0000000040, 00000003, 'parent1languageFirst', 'varchar', 'Parent1Fields', 'N', 'N', 'Y', NULL, 'First Language', 'Student''s native/first/mother language.', NULL, NULL, 16), (0000000041, 00000003, 'parent1languageSecond', 'varchar', 'Parent1Fields', 'N', 'N', 'Y', NULL, 'Second Language', NULL, NULL, NULL, 17), (0000000042, 00000003, 'headingParentGuardian1Contact', 'subheading', 'LayoutHeadings', 'N', 'N', 'N', 'parentSection1', 'Parent/Guardian 1 Contact', NULL, NULL, NULL, 18), (0000000043, 00000003, 'parent1email', 'email', 'Parent1Fields', 'Y', 'N', 'Y', NULL, 'Email', NULL, NULL, NULL, 19), (0000000044, 00000003, 'parent1phone', 'phone', 'Parent1Fields', 'N', 'N', 'N', NULL, 'Phone', 'Type, country code, number.', NULL, NULL, 20), (0000000045, 00000003, 'headingParentGuardian1Employment', 'subheading', 'LayoutHeadings', 'N', 'N', 'N', 'parentSection1', 'Parent/Guardian 1 Employment', NULL, NULL, NULL, 21), (0000000046, 00000003, 'parent1profession', 'varchar', 'Parent1Fields', 'Y', 'N', 'Y', NULL, 'Profession', NULL, NULL, NULL, 22), (0000000047, 00000003, 'parent1employer', 'varchar', 'Parent1Fields', 'N', 'N', 'Y', NULL, 'Employer', NULL, NULL, NULL, 23), (0000000048, 00000003, 'secondParent', 'checkbox', 'Parent2Fields', 'N', 'N', 'N', NULL, 'Do not include a second parent/guardian', NULL, NULL, NULL, 26), (0000000049, 00000003, 'headingParentGuardian2PersonalData', 'subheading', 'LayoutHeadings', 'N', 'N', 'N', 'parentSection2', 'Parent/Guardian 2 Personal Data', NULL, NULL, NULL, 27), (0000000050, 00000003, 'parent2title', 'varchar', 'Parent2Fields', 'Y', 'N', 'Y', NULL, 'Title', NULL, NULL, NULL, 28), (0000000051, 00000003, 'parent2surname', 'varchar', 'Parent2Fields', 'X', 'N', 'Y', NULL, 'Surname', 'Family name as shown in ID documents.', NULL, NULL, 29), (0000000052, 00000003, 'parent2firstName', 'varchar', 'Parent2Fields', 'Y', 'N', 'Y', NULL, 'First Name', 'First name as shown in ID documents.', NULL, NULL, 30), (0000000053, 00000003, 'parent2preferredName', 'varchar', 'Parent2Fields', 'X', 'N', 'Y', NULL, 'Preferred Name', 'Most common name, alias, nickname, etc.', NULL, NULL, 31), (0000000054, 00000003, 'parent2officialName', 'varchar', 'Parent2Fields', 'Y', 'N', 'Y', NULL, 'Official Name', 'Full name as shown in ID documents.', NULL, NULL, 32), (0000000055, 00000003, 'parent2nameInCharacters', 'varchar', 'Parent2Fields', 'N', 'N', 'Y', NULL, 'Name In Characters', 'Chinese or other character-based name.', NULL, NULL, 33), (0000000056, 00000003, 'parent2gender', 'varchar', 'Parent2Fields', 'Y', 'N', 'Y', NULL, 'Gender', NULL, NULL, NULL, 34), (0000000057, 00000003, 'parent2relationship', 'varchar', 'Parent2Fields', 'Y', 'N', 'Y', NULL, 'Relationship', NULL, NULL, NULL, 35), (0000000058, 00000003, 'headingParentGuardian2PersonalBackground', 'subheading', 'LayoutHeadings', 'N', 'N', 'N', 'parentSection2', 'Parent/Guardian 2 Personal Background', NULL, NULL, NULL, 36), (0000000059, 00000003, 'parent2languageFirst', 'varchar', 'Parent2Fields', 'N', 'N', 'Y', NULL, 'First Language', 'Student''s native/first/mother language.', NULL, NULL, 37), (0000000060, 00000003, 'parent2languageSecond', 'varchar', 'Parent2Fields', 'N', 'N', 'Y', NULL, 'Second Language', NULL, NULL, NULL, 38), (0000000061, 00000003, 'headingParentGuardian2Contact', 'subheading', 'LayoutHeadings', 'N', 'N', 'N', 'parentSection2', 'Parent/Guardian 2 Contact', NULL, NULL, NULL, 39), (0000000062, 00000003, 'parent2email', 'email', 'Parent2Fields', 'Y', 'N', 'Y', NULL, 'Email', NULL, NULL, NULL, 40), (0000000063, 00000003, 'parent2phone', 'phone', 'Parent2Fields', 'N', 'N', 'Y', NULL, 'Phone', 'Type, country code, number.', NULL, NULL, 41), (0000000064, 00000003, 'headingParentGuardian2Employment', 'subheading', 'LayoutHeadings', 'N', 'N', 'N', 'parentSection2', 'Parent/Guardian 2 Employment', NULL, NULL, NULL, 42), (0000000065, 00000003, 'parent2profession', 'varchar', 'Parent2Fields', 'Y', 'N', 'Y', NULL, 'Profession', NULL, NULL, NULL, 43), (0000000066, 00000003, 'parent2employer', 'varchar', 'Parent2Fields', 'N', 'N', 'Y', NULL, 'Employer', NULL, NULL, NULL, 44), (0000000067, 00000003, 'heading', 'heading', 'LayoutHeadings', 'N', 'N', 'N', NULL, 'Parent/Guardian 1', '', NULL, NULL, 5), (0000000068, 00000003, 'headingParentGuardian2', 'heading', 'LayoutHeadings', 'N', 'N', 'N', 'familySection', 'Parent/Guardian 2', NULL, NULL, NULL, 25), (0000000069, 00000003, 'parent1Documents', 'personalDocument', 'PersonalDocuments', 'N', 'N', 'N', NULL, 'Personal Documents', NULL, NULL, NULL, 24), (0000000070, 00000003, 'headingSiblings', 'heading', 'LayoutHeadings', 'N', 'N', 'N', 'familySection', 'Siblings', NULL, NULL, NULL, 46), (0000000071, 00000003, 'siblings', 'varchar', 'FamilyFields', 'N', 'N', 'Y', NULL, 'Siblings', 'Please give information on the applicants''s siblings.', NULL, NULL, 47), (0000000072, 00000004, 'requiredDocuments', 'files', 'RequiredDocuments', 'N', 'N', 'N', 'Most Recent School Report,Recent Photo of Applicant,Special Educational Needs Report ', 'Required Documents', '', NULL, NULL, 3), (0000000073, 00000004, 'headingRequiredDocuments', 'heading', 'LayoutHeadings', 'N', 'N', 'N', NULL, 'Supporting Documents', 'Please provide the following documents.', NULL, NULL, 1), (0000000074, 00000004, 'studentDocuments', 'personalDocument', 'PersonalDocuments', 'N', 'N', 'N', NULL, 'Personal Documents', NULL, NULL, NULL, 2), (0000000075, 00000005, 'headingMedicalInformation', 'heading', 'LayoutHeadings', 'N', 'N', 'N', NULL, 'Medical Information', NULL, NULL, NULL, 1), (0000000076, 00000005, 'medical', 'varchar', 'MedicalFields', 'X', 'N', 'N', NULL, 'Medical Conditions', 'Does your child have any medical conditions or concerns?', NULL, NULL, 2), (0000000077, 00000005, 'medicalInformation', 'varchar', 'MedicalFields', 'Y', 'N', 'N', NULL, 'Medical Information', 'Please indicate any medical conditions.', NULL, NULL, 3), (0000000078, 00000005, 'headingSpecialEducationalNeeds', 'heading', 'LayoutHeadings', 'N', 'N', 'N', NULL, 'Special Educational Needs', NULL, NULL, NULL, 4), (0000000079, 00000005, 'sen', 'varchar', 'INFields', 'X', 'N', 'N', NULL, 'Special Educational Needs (SEN)', 'Are there any known or suspected SEN concerns, or previous SEN assessments?', NULL, NULL, 5), (0000000080, 00000005, 'senDetails', 'varchar', 'INFields', 'Y', 'N', 'N', NULL, 'SEN Details', 'Provide any comments or information concerning your child''s development and SEN history.', NULL, NULL, 6), (0000000081, 00000005, 'headingPayment', 'heading', 'LayoutHeadings', 'N', 'N', 'N', NULL, 'Payment', '', NULL, NULL, 7), (0000000082, 00000005, 'payment', 'varchar', 'FinanceFields', 'X', 'N', 'Y', NULL, 'Send Future Invoices To', NULL, NULL, NULL, 9), (0000000083, 00000005, 'companyName', 'varchar', 'FinanceFields', 'X', 'N', 'Y', NULL, 'Company Name', NULL, NULL, NULL, 10), (0000000084, 00000005, 'companyContact', 'varchar', 'FinanceFields', 'X', 'N', 'Y', NULL, 'Company Contact Person', NULL, NULL, NULL, 11), (0000000085, 00000005, 'companyAddress', 'varchar', 'FinanceFields', 'X', 'N', 'Y', NULL, 'Company Address', NULL, NULL, NULL, 12), (0000000086, 00000005, 'companyEmail', 'varchar', 'FinanceFields', 'X', 'N', 'Y', NULL, 'Company Emails', 'Comma-separated list of email address', NULL, NULL, 13), (0000000087, 00000005, 'companyCCFamily', 'varchar', 'FinanceFields', 'N', 'N', 'Y', NULL, 'CC Family?', 'Should the family be sent a copy of billing emails?', NULL, NULL, 14), (0000000088, 00000005, 'companyPhone', 'varchar', 'FinanceFields', 'N', 'N', 'Y', NULL, 'Company Phone', NULL, NULL, NULL, 15), (0000000089, 00000005, 'companyAll', 'varchar', 'FinanceFields', 'N', 'N', 'Y', NULL, 'Company All?', 'Should all items be billed to the specified company, or just some?', NULL, NULL, 16), (0000000090, 00000005, 'gibbonFinanceFeeCategoryIDList', 'varchar', 'FinanceFields', 'N', 'N', 'Y', NULL, 'Company Fee Categories', 'If the specified company is not paying all fees, which categories are they paying?', NULL, NULL, 17), (0000000091, 00000005, 'headingAgreement', 'heading', 'LayoutHeadings', 'N', 'N', 'N', NULL, 'Agreement', 'This is example text. Edit it to suit your school context.', NULL, NULL, 22), (0000000092, 00000005, 'agreement', 'checkbox', 'AgreementFields', 'X', 'N', 'N', NULL, 'Do you agree to the above?', NULL, NULL, NULL, 23), (0000000093, 00000002, 'headingLanguageSelection', 'heading', 'LayoutHeadings', 'N', 'N', 'N', NULL, 'Language Selection', 'This is example text. Edit it to suit your school context.', NULL, NULL, 11), (0000000094, 00000002, 'languageChoice', 'select', 'LanguageFields', 'N', 'N', 'N', 'One,Two,Three', 'Language Choice', 'Please choose preferred additional language to study.', NULL, NULL, 12), (0000000095, 00000002, 'languageChoiceExperience', 'varchar', 'LanguageFields', 'N', 'N', 'N', NULL, 'Language Choice Experience', 'Has the applicant studied the selected language before? If so, please describe the level and type of experience.', NULL, NULL, 13), (0000000096, 00000002, 'headingScholarships', 'heading', 'LayoutHeadings', 'N', 'N', 'N', NULL, 'Scholarships', 'Information to display before the scholarship options', NULL, NULL, 14), (0000000097, 00000002, 'scholarshipInterest', 'radio', 'ScholarshipFields', 'N', 'N', 'N', NULL, 'Interest', 'Indicate if you are interested in a scholarship.', NULL, NULL, 15), (0000000098, 00000002, 'scholarshipRequired', 'radio', 'ScholarshipFields', 'N', 'N', 'N', NULL, 'Required?', 'Is a scholarship required for you to take up a place at the school?', NULL, NULL, 16), (0000000099, 00000005, 'text', 'layout', 'LayoutText', 'N', 'N', 'N', NULL, '', 'If you choose family, future invoices will be sent according to your family''s contact preferences, which can be changed at a later date by contacting the school. For example you may wish both parents to receive the invoice, or only one. Alternatively, if you choose Company, you can choose for all or only some fees to be covered by the specified company.', NULL, NULL, 8), (0000000100, 00000005, 'headingMiscellaneous', 'heading', 'LayoutHeadings', 'N', 'N', 'N', NULL, 'Miscellaneous', NULL, NULL, NULL, 18), (0000000101, 00000005, 'howDidYouHear', 'varchar', 'MiscellaneousFields', 'N', 'N', 'Y', NULL, 'How Did You Hear About Us?', NULL, NULL, NULL, 19), (0000000102, 00000001, 'email', 'varchar', 'StudentFields', 'N', 'N', 'N', NULL, 'Email', NULL, NULL, NULL, 18), (0000000103, 00000001, 'headingStudent', 'heading', 'LayoutHeadings', 'N', 'N', 'N', NULL, 'Student', NULL, NULL, NULL, 1), (0000000104, 00000003, 'parent2Documents', 'personalDocument', 'PersonalDocuments', 'N', 'N', 'N', NULL, 'Personal Documents', NULL, NULL, NULL, 45); -- -------------------------------------------------------- -- -- Table structure for table `gibbonFormGroup` -- CREATE TABLE `gibbonFormGroup` ( `gibbonFormGroupID` int(5) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonSchoolYearID` int(3) unsigned zerofill NOT NULL, `name` varchar(20) NOT NULL, `nameShort` varchar(8) NOT NULL, `gibbonPersonIDTutor` int(10) unsigned zerofill DEFAULT NULL, `gibbonPersonIDTutor2` int(10) unsigned zerofill DEFAULT NULL, `gibbonPersonIDTutor3` int(10) unsigned zerofill DEFAULT NULL, `gibbonPersonIDEA` int(10) unsigned zerofill DEFAULT NULL, `gibbonPersonIDEA2` int(10) unsigned zerofill DEFAULT NULL, `gibbonPersonIDEA3` int(10) unsigned zerofill DEFAULT NULL, `gibbonSpaceID` int(5) unsigned zerofill DEFAULT NULL, `gibbonFormGroupIDNext` int(5) unsigned zerofill DEFAULT NULL, `attendance` enum('Y','N') NOT NULL DEFAULT 'Y', `website` varchar(255) NOT NULL, PRIMARY KEY (`gibbonFormGroupID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFormPage` -- CREATE TABLE `gibbonFormPage` ( `gibbonFormPageID` int(8) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonFormID` int(6) unsigned zerofill NOT NULL, `name` varchar(90) NOT NULL, `introduction` text, `postscript` text, `sequenceNumber` int NOT NULL, PRIMARY KEY (`gibbonFormPageID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=6 ; -- -- Dumping data for table `gibbonFormPage` -- INSERT INTO `gibbonFormPage` VALUES (00000001, 000001, 'Student', '', '', 1), (00000002, 000001, 'Enrolment', '', '', 2), (00000003, 000001, 'Family', '', '', 3), (00000004, 000001, 'Documents', '', '', 4), (00000005, 000001, 'Final Details', '', '', 5); -- -------------------------------------------------------- -- -- Table structure for table `gibbonFormSubmission` -- CREATE TABLE `gibbonFormSubmission` ( `gibbonFormSubmissionID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonFormID` int(6) unsigned zerofill DEFAULT NULL, `gibbonFormPageID` int(8) unsigned zerofill DEFAULT NULL, `foreignTable` varchar(60) DEFAULT NULL, `foreignTableID` int(14) unsigned zerofill DEFAULT NULL, `status` enum('Incomplete','Pending','Processed','Withdrawn') NOT NULL DEFAULT 'Incomplete', `owner` varchar(75) DEFAULT NULL, `identifier` varchar(255) DEFAULT NULL, `data` mediumtext, `result` text, `timestampCreated` timestamp NULL DEFAULT NULL, `timestampModified` timestamp NULL DEFAULT NULL, `gibbonPersonIDModified` int(10) unsigned zerofill DEFAULT NULL, PRIMARY KEY (`gibbonFormSubmissionID`), KEY `foreignTable` (`foreignTable`,`foreignTableID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonFormUpload` -- CREATE TABLE `gibbonFormUpload` ( `gibbonFormUploadID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonFormID` int(6) unsigned zerofill DEFAULT NULL, `gibbonFormFieldID` int(10) unsigned zerofill DEFAULT NULL, `foreignTable` varchar(60) DEFAULT NULL, `foreignTableID` int(14) unsigned zerofill DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `path` varchar(255) DEFAULT NULL, `confirmed` enum('Y','N') NOT NULL DEFAULT 'N', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`gibbonFormUploadID`), KEY `foreignTable` (`foreignTable`,`foreignTableID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonGroup` -- CREATE TABLE `gibbonGroup` ( `gibbonGroupID` int(8) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPersonIDOwner` int(10) unsigned zerofill NOT NULL, `gibbonSchoolYearID` int(3) unsigned zerofill NOT NULL, `name` varchar(60) NOT NULL, `timestampCreated` timestamp NULL DEFAULT NULL, `timestampUpdated` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`gibbonGroupID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonGroupPerson` -- CREATE TABLE `gibbonGroupPerson` ( `gibbonGroupPersonID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonGroupID` int(8) unsigned zerofill NOT NULL, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, PRIMARY KEY (`gibbonGroupPersonID`), UNIQUE KEY `gibbonGroupID` (`gibbonGroupID`,`gibbonPersonID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonHook` -- CREATE TABLE `gibbonHook` ( `gibbonHookID` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `type` enum('Public Home Page','Student Profile','Parental Dashboard','Staff Dashboard','Student Dashboard','Report Writing','Staff Profile','Lesson Planner') DEFAULT NULL, `options` text NOT NULL, `gibbonModuleID` int(4) unsigned zerofill NOT NULL COMMENT 'The module which installed this hook.', PRIMARY KEY (`gibbonHookID`), UNIQUE KEY `name` (`name`,`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonHouse` -- CREATE TABLE `gibbonHouse` ( `gibbonHouseID` int(3) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, `nameShort` varchar(10) NOT NULL, `logo` varchar(255) NOT NULL, PRIMARY KEY (`gibbonHouseID`), UNIQUE KEY `name` (`name`,`nameShort`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibboni18n` -- CREATE TABLE `gibboni18n` ( `gibboni18nID` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT, `code` varchar(5) NOT NULL, `name` varchar(100) NOT NULL, `version` varchar(10) DEFAULT NULL, `active` enum('Y','N') NOT NULL DEFAULT 'Y', `installed` enum('Y','N') NOT NULL DEFAULT 'N', `systemDefault` enum('Y','N') NOT NULL DEFAULT 'N', `dateFormat` varchar(20) NOT NULL, `dateFormatRegEx` text NOT NULL, `dateFormatPHP` varchar(20) NOT NULL, `rtl` enum('Y','N') NOT NULL DEFAULT 'N', PRIMARY KEY (`gibboni18nID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=50 ; -- -- Dumping data for table `gibboni18n` -- INSERT INTO `gibboni18n` VALUES (0001, 'en_GB', 'English - United Kingdom', NULL, 'Y', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0002, 'en_US', 'English - United States', '30.0.01', 'Y', 'Y', 'Y', 'mm/dd/yyyy', '/(0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])[- /.](19|20\\d\\d)/', 'm/d/Y', 'N'), (0003, 'es_ES', 'Español - España', NULL, 'Y', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0004, 'zh_CN', '汉语 - 中国', NULL, 'Y', 'N', 'N', 'yyyy-mm-dd', '/^[0-9]{4}-(0[1-9]|1[0-2])-(0[1-9]|[1-2][0-9]|3[0-1])$/', 'Y-m-d', 'N'), (0005, 'zh_HK', '繁體字 - 香港', NULL, 'Y', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0007, 'pl_PL', 'Język polski - Polska', NULL, 'Y', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0008, 'it_IT', 'Italiano - Italia', NULL, 'Y', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0010, 'id_ID', 'Bahasa Indonesia - Indonesia', NULL, 'N', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0011, 'ar_SA', 'العربية - المملكة العربية السعودية', NULL, 'Y', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'Y'), (0012, 'fr_FR', 'Français - France', NULL, 'Y', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0013, 'ur_PK', 'پاکستان - اُردُو', NULL, 'Y', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'Y'), (0014, 'sw_KE', 'Swahili', NULL, 'N', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0015, 'pt_PT', 'Português', NULL, 'Y', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0016, 'ro_RO', 'Română', NULL, 'Y', 'N', 'N', 'dd.mm.yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd.m.Y', 'N'), (0017, 'ja_JP', '日本語', NULL, 'Y', 'N', 'N', 'yyyy-mm-dd', '/^[0-9]{4}-(0[1-9]|1[0-2])-(0[1-9]|[1-2][0-9]|3[0-1])$/', 'Y-m-d', 'N'), (0018, 'ru_RU', 'ру́сский язы́к', NULL, 'N', 'N', 'N', 'dd.mm.yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd.m.Y', 'N'), (0019, 'uk_UA', 'українська мова', NULL, 'N', 'N', 'N', 'dd.mm.yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd.m.Y', 'N'), (0020, 'bn_BD', 'বাংলা', NULL, 'N', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0021, 'da_DK', 'Dansk - Danmark', NULL, 'N', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0022, 'fa_IR', 'فارسی', NULL, 'N', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'Y'), (0023, 'pt_BR', 'Português - Brasil', NULL, 'Y', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0024, 'ka_GE', 'ქართული ენა', NULL, 'N', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0025, 'nl_NL', 'Dutch - Nederland', NULL, 'Y', 'N', 'N', 'dd-mm-yyyy', '/^(0[1-9]|[12][0-9]|3[01])[-](0[1-9]|1[012])[-](19|20)\\d\\d$/i', 'd-m-Y', 'N'), (0026, 'hu_HU', 'Magyar - Magyarország', NULL, 'N', 'N', 'N', 'dd-mm-yyyy', '/^(0[1-9]|[12][0-9]|3[01])[-](0[1-9]|1[012])[-](19|20)\\d\\d$/i', 'd-m-Y', 'N'), (0027, 'bg_BG', 'български език', NULL, 'N', 'N', 'N', 'dd-mm-yyyy', '/^(0[1-9]|[12][0-9]|3[01])[-](0[1-9]|1[012])[-](19|20)\\d\\d$/i', 'd-m-Y', 'N'), (0028, 'ko_KP', '한국어 - 대한민국', NULL, 'N', 'N', 'N', 'dd-mm-yyyy', '/^(0[1-9]|[12][0-9]|3[01])[-](0[1-9]|1[012])[-](19|20)\\d\\d$/i', 'd-m-Y', 'N'), (0029, 'fi_FI', 'Suomen Kieli - Suomi', NULL, 'N', 'N', 'N', 'dd-mm-yyyy', '/^(0[1-9]|[12][0-9]|3[01])[-](0[1-9]|1[012])[-](19|20)\\d\\d$/i', 'd-m-Y', 'N'), (0030, 'de_DE', 'Deutsch - Deutschland', NULL, 'Y', 'N', 'N', 'dd.mm.yyyy', '/^(0[1-9]|[12][0-9]|3[01])[.](0[1-9]|1[012])[.](19|20)\\d\\d$/i', 'd.m.Y', 'N'), (0031, 'in_OR', 'ଓଡ଼ିଆ - इंडिया', NULL, 'N', 'N', 'N', 'dd-mm-yyyy', '/^(0[1-9]|[12][0-9]|3[01])[-](0[1-9]|1[012])[-](19|20)\\d\\d$/i', 'd-m-Y', 'N'), (0032, 'no_NO', 'Norsk - Norge', NULL, 'N', 'N', 'N', 'dd-mm-yyyy', '/^(0[1-9]|[12][0-9]|3[01])[-](0[1-9]|1[012])[-](19|20)\\d\\d$/i', 'd-m-Y', 'N'), (0033, 'vi_VN', 'Tiếng Việt - Việt Nam', NULL, 'Y', 'N', 'N', 'dd-mm-yyyy', '/^(0[1-9]|[12][0-9]|3[01])[-](0[1-9]|1[012])[-](19|20)\\d\\d$/i', 'd-m-Y', 'N'), (0034, 'sq_AL', 'Shqip - Shqipëri', NULL, 'Y', 'N', 'N', 'dd-mm-yyyy', '/^(0[1-9]|[12][0-9]|3[01])[-](0[1-9]|1[012])[-](19|20)\\d\\d$/i', 'd-m-Y', 'N'), (0035, 'th_TH', 'ภาษาไทย - ราชอาณาจักรไทย', NULL, 'Y', 'N', 'N', 'dd-mm-yyyy', '/^(0[1-9]|[12][0-9]|3[01])[-](0[1-9]|1[012])[-](19|20)\\d\\d$/i', 'd-m-Y', 'N'), (0036, 'el_GR', 'ελληνικά - Ελλάδα', NULL, 'Y', 'N', 'N', 'dd-mm-yyyy', '/^(0[1-9]|[12][0-9]|3[01])[-](0[1-9]|1[012])[-](19|20)\\d\\d$/i', 'd-m-Y', 'N'), (0037, 'am_ET', 'አማርኛ - ኢትዮጵያ', NULL, 'N', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0038, 'om_ET', 'Afaan Oromo - Ethiopia', NULL, 'N', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0039, 'hr_HR', 'Hrvatski - Hrvatska', NULL, 'Y', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0040, 'et_EE', 'Eesti Keel - Eesti', NULL, 'N', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0041, 'he_IL', 'עברית - ישראל', NULL, 'Y', 'N', 'N', 'dd.mm.yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd.m.Y', 'Y'), (0042, 'tr_TR', 'Türkçe - Türkiye', NULL, 'Y', 'N', 'N', 'dd.mm.yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd.m.Y', 'N'), (0043, 'my_MM', 'မြန်မာ - မြန်မာ', NULL, 'N', 'N', 'N', 'dd-mm-yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd-m-Y', 'N'), (0044, 'es_MX', 'Español - Mexico', NULL, 'Y', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0045, 'af_ZA', 'Afrikaans - Suid-Afrika', NULL, 'Y', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0046, 'uk_UA', 'українська мова - Україна', '21.0.00', 'Y', 'N', 'N', 'dd.mm.yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd.m.Y', 'N'), (0047, 'es_DO', 'Español - República Dominicana', NULL, 'Y', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'), (0048, 'lt_LT', 'Lietuvių Kalba - Lithuanian', '25.0.00', 'Y', 'N', 'N', 'yyyy.mm.dd', '/^[0-9]{4}.(0[1-9]|1[0-2]).(0[1-9]|[1-2][0-9]|3[0-1])$/', 'Y.m.d', 'N'), (0049, 'ca_CA', 'Català - Catalonia', '30.0.00', 'Y', 'N', 'N', 'dd/mm/yyyy', '/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d$/i', 'd/m/Y', 'N'); -- -------------------------------------------------------- -- -- Table structure for table `gibbonIN` -- CREATE TABLE `gibbonIN` ( `gibbonINID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `strategies` text NOT NULL, `targets` text NOT NULL, `notes` text NOT NULL, `fields` text, PRIMARY KEY (`gibbonINID`), UNIQUE KEY `gibbonPersonID` (`gibbonPersonID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonINArchive` -- CREATE TABLE `gibbonINArchive` ( `gibbonINArchiveID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `strategies` text NOT NULL, `targets` text NOT NULL, `notes` text NOT NULL, `descriptors` text NOT NULL COMMENT 'Serialised array of descriptors.', `archiveTitle` varchar(50) NOT NULL, `archiveTimestamp` timestamp NULL DEFAULT NULL, `fields` text, PRIMARY KEY (`gibbonINArchiveID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonINAssistant` -- CREATE TABLE `gibbonINAssistant` ( `gibbonINAssistantID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPersonIDStudent` int(10) unsigned zerofill NOT NULL, `gibbonPersonIDAssistant` int(10) unsigned zerofill NOT NULL, `comment` text NOT NULL, PRIMARY KEY (`gibbonINAssistantID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonINDescriptor` -- CREATE TABLE `gibbonINDescriptor` ( `gibbonINDescriptorID` int(3) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `nameShort` varchar(5) NOT NULL, `description` text NOT NULL, `sequenceNumber` int NOT NULL, PRIMARY KEY (`gibbonINDescriptorID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=4 ; -- -- Dumping data for table `gibbonINDescriptor` -- INSERT INTO `gibbonINDescriptor` VALUES (001, 'Special Education Needs', 'SEN', 'Official learning needs that have been professionally identified.', 1), (002, 'English as an Additional Language', 'EAL', 'Obvious language needs in English acquisition.', 2), (003, 'Other Needs', 'ON', 'Any other case. E.g. learning issues that have not been assessed, or ongoing home/family issues that should be known to staff and which may relate to teaching and learning.', 3); -- -------------------------------------------------------- -- -- Table structure for table `gibbonINInvestigation` -- CREATE TABLE `gibbonINInvestigation` ( `gibbonINInvestigationID` int(11) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonSchoolYearID` int(3) unsigned zerofill NOT NULL, `gibbonPersonIDCreator` int(10) unsigned zerofill NOT NULL, `gibbonPersonIDStudent` int(10) unsigned zerofill NOT NULL, `status` enum('Referral','Resolved','Investigation','Investigation Complete') DEFAULT NULL, `date` date NOT NULL, `reason` text NOT NULL, `strategiesTried` text NOT NULL, `parentsInformed` enum('N','Y') NOT NULL DEFAULT 'N', `parentsResponse` text, `resolutionDetails` text, PRIMARY KEY (`gibbonINInvestigationID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonINInvestigationContribution` -- CREATE TABLE `gibbonINInvestigationContribution` ( `gibbonINInvestigationContributionID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonINInvestigationID` int(11) unsigned zerofill NOT NULL, `type` enum('Teacher','Head of Year') NOT NULL DEFAULT 'Teacher', `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `gibbonCourseClassPersonID` int(10) unsigned zerofill DEFAULT NULL, `status` enum('Pending','Complete') NOT NULL DEFAULT 'Pending', `cognition` text, `memory` text, `selfManagement` text, `attention` text, `socialInteraction` text, `communication` text, `comment` text, PRIMARY KEY (`gibbonINInvestigationContributionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonINPersonDescriptor` -- CREATE TABLE `gibbonINPersonDescriptor` ( `gibbonINPersonDescriptorID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `gibbonINDescriptorID` int(3) unsigned zerofill DEFAULT NULL, `gibbonAlertLevelID` int(3) unsigned zerofill DEFAULT NULL, PRIMARY KEY (`gibbonINPersonDescriptorID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonInternalAssessmentColumn` -- CREATE TABLE `gibbonInternalAssessmentColumn` ( `gibbonInternalAssessmentColumnID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonCourseClassID` int(8) unsigned zerofill NOT NULL, `groupingID` int(8) unsigned zerofill DEFAULT NULL COMMENT 'A value used to group multiple columns.', `name` varchar(30) NOT NULL, `description` text NOT NULL, `type` varchar(50) NOT NULL, `attachment` varchar(255) NOT NULL, `attainment` enum('Y','N') NOT NULL DEFAULT 'Y', `gibbonScaleIDAttainment` int(5) unsigned zerofill DEFAULT NULL, `effort` enum('Y','N') NOT NULL DEFAULT 'Y', `gibbonScaleIDEffort` int(5) unsigned zerofill DEFAULT NULL, `comment` enum('Y','N') NOT NULL DEFAULT 'Y', `uploadedResponse` enum('N','Y') NOT NULL DEFAULT 'N', `complete` enum('N','Y') NOT NULL, `completeDate` date DEFAULT NULL, `viewableStudents` enum('N','Y') NOT NULL, `viewableParents` enum('N','Y') NOT NULL, `gibbonPersonIDCreator` int(10) unsigned zerofill NOT NULL, `gibbonPersonIDLastEdit` int(10) unsigned zerofill NOT NULL, PRIMARY KEY (`gibbonInternalAssessmentColumnID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonInternalAssessmentEntry` -- CREATE TABLE `gibbonInternalAssessmentEntry` ( `gibbonInternalAssessmentEntryID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonInternalAssessmentColumnID` int(10) unsigned zerofill NOT NULL, `gibbonPersonIDStudent` int(10) unsigned zerofill NOT NULL, `attainmentValue` varchar(10) DEFAULT NULL, `attainmentDescriptor` varchar(100) DEFAULT NULL, `effortValue` varchar(10) DEFAULT NULL, `effortDescriptor` varchar(100) DEFAULT NULL, `comment` text, `response` text, `gibbonPersonIDLastEdit` int(10) unsigned zerofill NOT NULL, PRIMARY KEY (`gibbonInternalAssessmentEntryID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonLanguage` -- CREATE TABLE `gibbonLanguage` ( `gibbonLanguageID` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, PRIMARY KEY (`gibbonLanguageID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=86 ; -- -- Dumping data for table `gibbonLanguage` -- INSERT INTO `gibbonLanguage` VALUES (0001, 'Afrikaans'), (0002, 'Albanian'), (0003, 'Arabic'), (0004, 'Armenian'), (0005, 'Basque'), (0006, 'Bengali'), (0007, 'Bulgarian'), (0008, 'Catalan'), (0009, 'Cambodian'), (0010, 'Chinese (Mandarin)'), (0011, 'Chinese (Cantonese)'), (0012, 'Croatian'), (0013, 'Czech'), (0014, 'Danish'), (0015, 'Dutch'), (0016, 'English'), (0017, 'Estonian'), (0018, 'Fijian'), (0019, 'Finnish'), (0020, 'French'), (0021, 'Georgian'), (0022, 'German'), (0023, 'Greek'), (0024, 'Gujarati'), (0025, 'Hebrew'), (0026, 'Hindi'), (0027, 'Hungarian'), (0028, 'Icelandic'), (0029, 'Indonesian'), (0030, 'Irish'), (0031, 'Italian'), (0032, 'Japanese'), (0033, 'Javanese'), (0034, 'Korean'), (0035, 'Latin'), (0036, 'Latvian'), (0037, 'Lithuanian'), (0038, 'Macedonian'), (0039, 'Malay'), (0040, 'Malayalam'), (0041, 'Maltese'), (0042, 'Maori'), (0043, 'Marathi'), (0044, 'Mongolian'), (0045, 'Nepali'), (0046, 'Norwegian'), (0047, 'Persian'), (0048, 'Polish'), (0049, 'Portuguese'), (0050, 'Punjabi'), (0051, 'Quechua'), (0052, 'Romanian'), (0053, 'Russian'), (0054, 'Samoan'), (0055, 'Serbian'), (0056, 'Slovak'), (0057, 'Slovenian'), (0058, 'Spanish'), (0059, 'Swahili'), (0060, 'Swedish'), (0061, 'Tamil'), (0062, 'Tatar'), (0063, 'Telugu'), (0064, 'Thai'), (0065, 'Tibetan'), (0066, 'Tongan'), (0067, 'Turkish'), (0068, 'Ukrainian'), (0069, 'Urdu'), (0070, 'Uzbek'), (0071, 'Vietnamese'), (0072, 'Welsh'), (0073, 'Xhosa'), (0074, 'Odia'), (0075, 'Myanmar'), (0076, 'Burmese'), (0077, 'Filipino'), (0078, 'Sinhala'), (0079, 'Malagasy'), (0080, 'Maldivian'), (0081, 'Somali'), (0082, 'Zulu'), (0083, 'Tamazight'), (0084, 'Putonghua'), (0085, 'Balochi'); -- -------------------------------------------------------- -- -- Table structure for table `gibbonLibraryItem` -- CREATE TABLE `gibbonLibraryItem` ( `gibbonLibraryItemID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonLibraryItemIDParent` int DEFAULT NULL, `gibbonLibraryTypeID` int(5) unsigned zerofill NOT NULL, `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL COMMENT 'Name for book, model for computer, etc.', `producer` varchar(255) NOT NULL COMMENT 'Author for book, manufacturer for computer, etc', `fields` text NOT NULL COMMENT 'JSON object', `vendor` varchar(100) NOT NULL, `purchaseDate` date DEFAULT NULL, `invoiceNumber` varchar(50) NOT NULL, `cost` decimal(10,2) DEFAULT NULL, `imageType` enum('','Link','File') NOT NULL DEFAULT '' COMMENT 'Type of image. Image should be 240px x 240px, or smaller.', `imageLocation` varchar(255) NOT NULL COMMENT 'URL or local FS path of image.', `comment` text NOT NULL, `gibbonSpaceID` int(5) unsigned zerofill DEFAULT NULL, `locationDetail` varchar(255) NOT NULL, `ownershipType` enum('School','Individual') NOT NULL DEFAULT 'School', `gibbonPersonIDOwnership` int(10) unsigned zerofill DEFAULT NULL COMMENT 'If owned by school, then this is the main user. If owned by individual, then this is that individual.', `gibbonDepartmentID` int(4) unsigned zerofill DEFAULT NULL COMMENT 'Who is responsible for managing this item? By default this will be the person who added the record, but it can be changed.', `replacement` enum('Y','N') NOT NULL DEFAULT 'Y', `replacementCost` decimal(10,2) DEFAULT NULL, `gibbonSchoolYearIDReplacement` int(3) unsigned zerofill DEFAULT NULL, `physicalCondition` enum('','As New','Lightly Worn','Moderately Worn','Damaged','Unusable') NOT NULL, `bookable` enum('N','Y') NOT NULL DEFAULT 'N', `borrowable` enum('Y','N') NOT NULL DEFAULT 'Y', `status` enum('Available','In Use','Decommissioned','Lost','On Loan','Repair','Reserved','On Order') NOT NULL DEFAULT 'Available' COMMENT 'The current status of the item.', `gibbonPersonIDStatusResponsible` int(10) unsigned zerofill DEFAULT NULL COMMENT 'The person who is responsible for the current status.', `gibbonPersonIDStatusRecorder` int(10) unsigned zerofill DEFAULT NULL COMMENT 'The person who recored the current status.', `timestampStatus` datetime DEFAULT NULL COMMENT 'The time the status was recorded', `returnExpected` date DEFAULT NULL COMMENT 'The time when the event expires.', `returnAction` enum('Make Available','Decommission','Repair','Reserve') DEFAULT NULL COMMENT 'What to do when the item is returned?', `gibbonPersonIDReturnAction` int(10) unsigned zerofill DEFAULT NULL, `gibbonPersonIDCreator` int(10) unsigned zerofill NOT NULL, `timestampCreator` datetime NOT NULL, `gibbonPersonIDUpdate` int(10) unsigned zerofill DEFAULT NULL, `timestampUpdate` datetime DEFAULT NULL, PRIMARY KEY (`gibbonLibraryItemID`), UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonLibraryItemEvent` -- CREATE TABLE `gibbonLibraryItemEvent` ( `gibbonLibraryItemEventID` int(14) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonLibraryItemID` int(10) unsigned zerofill NOT NULL, `type` enum('Decommission','Loss','Loan','Repair','Reserve','Other') NOT NULL DEFAULT 'Other' COMMENT 'This is maintained even after the item is returned, so we know what type of event it was.', `status` enum('Available','Decommissioned','Lost','On Loan','Repair','Reserved','Returned') NOT NULL DEFAULT 'Available', `gibbonPersonIDStatusResponsible` int(10) unsigned zerofill DEFAULT NULL COMMENT 'The person who was responsible for the event.', `gibbonPersonIDOut` int(10) unsigned zerofill DEFAULT NULL COMMENT 'The person who recored the event.', `timestampOut` datetime DEFAULT NULL COMMENT 'The time the event was recorded', `returnExpected` date DEFAULT NULL COMMENT 'The time when the event expires.', `returnAction` enum('Make Available','Decommission','Repair','Reserve') DEFAULT NULL COMMENT 'What to do when the item is returned?', `gibbonPersonIDReturnAction` int(10) unsigned zerofill DEFAULT NULL, `timestampReturn` datetime DEFAULT NULL, `gibbonPersonIDIn` int(10) unsigned zerofill DEFAULT NULL, PRIMARY KEY (`gibbonLibraryItemEventID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonLibraryShelf` -- CREATE TABLE `gibbonLibraryShelf` ( `gibbonLibraryShelfID` int(6) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(90) NOT NULL, `active` enum('Y','N') NOT NULL DEFAULT 'N', `shuffle` enum('N','Y') NOT NULL DEFAULT 'N', `field` varchar(90) NOT NULL, `fieldValue` varchar(90) DEFAULT NULL, `type` enum('Manual','Automatic') NOT NULL DEFAULT 'Manual', `sequenceNumber` int NOT NULL, PRIMARY KEY (`gibbonLibraryShelfID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonLibraryShelfItem` -- CREATE TABLE `gibbonLibraryShelfItem` ( `gibbonLibraryShelfItemID` int(6) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonLibraryItemID` int(10) unsigned zerofill NOT NULL, `gibbonLibraryShelfID` int(6) unsigned zerofill NOT NULL, PRIMARY KEY (`gibbonLibraryShelfItemID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonLibraryType` -- CREATE TABLE `gibbonLibraryType` ( `gibbonLibraryTypeID` int(5) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, `active` enum('Y','N') NOT NULL DEFAULT 'Y', `fields` text NOT NULL COMMENT 'JSON object', PRIMARY KEY (`gibbonLibraryTypeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=15 ; -- -- Dumping data for table `gibbonLibraryType` -- INSERT INTO `gibbonLibraryType` VALUES (00004, 'Print Publication', 'Y', '[{"name":"Format","description":"","type":"Select","options":",Art - Original,Art - Reproduction,Book,Braille,Cartographic material,Chart,Diorama,Electronic Resource,Filmstrip,Flash Card,Game,Globe,Journal,Kit,Large print,Magazine,Manuscript,Microform,Microscope slide,Model,Motion Picture,Music,Picture,Realia,Resource,Serial,Slide,Sound Recording,Technical Drawing,Text,Toy,Transparency,Videorecording","default":"","required":"N"},{"name":"Publisher","description":"Name of the company who published the volume.","type":"Text","options":"255","default":"","required":"N"},{"name":"Publication Date","description":"Format: dd\\/mm\\/yyyy, mm\\/yyyy or yyyy.","type":"Text","options":"10","default":"","required":"N"},{"name":"Country of Publication","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"Edition","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"ISBN10","description":"10-digit unique ISBN number.","type":"Text","options":"10","default":"","required":"N"},{"name":"ISBN13","description":"13-digit unique ISBN number.","type":"Text","options":"13","default":"","required":"Y"},{"name":"Description","description":"A brief blurb describing the volume.","type":"Textarea","options":"10","default":"","required":"N"},{"name":"Subjects","description":"Comma separated list of subjects.","type":"Textarea","options":"2","default":"","required":"N"},{"name":"Collection","description":"","type":"Select","options":",Fiction, Fiction - Best Sellers, Fiction - Classics, Fiction - Mystery, Fiction - Series, Fiction - Young Adult, Nonfiction, Nonfiction - College Prep, Nonfiction - Graphic Novels, Nonfiction - Life Skills, Nonfiction - Reference","default":"","required":"N"},{"name":"Control Number","description":"","type":"Text","options":"255","default":"","required":"N"},{"name":"Cataloging Authority","description":"Issuing authority for Control Number.","type":"Text","options":"255","default":"","required":"N"},{"name":"Reader Age (Youngest)","description":"Age in years, youngest reading age recommendation.","type":"Text","options":"3","default":"","required":"N"},{"name":"Reader Age (Oldest)","description":"Age in years, oldest reading age recommendation.","type":"Text","options":"3","default":"","required":"N"},{"name":"Page Count","description":"The number of pages in the volume.","type":"Text","options":"4","default":"","required":"N"},{"name":"Height","description":"The physical height of the volume, in cm.","type":"Text","options":"6","default":"","required":"N"},{"name":"Width","description":"The physical width of the volume, in cm.","type":"Text","options":"6","default":"","required":"N"},{"name":"Thickness","description":"The physical thickness of the volume, in cm.","type":"Text","options":"6","default":"","required":"N"},{"name":"Language","description":"The primary language of the volume.","type":"Text","options":"50","default":"","required":"N"},{"name":"Link","description":"Link to web-based information on the volume.","type":"URL","options":"255","default":"","required":"N"}]'), (00007, 'Computer', 'Y', '[{"name":"Form Factor","description":"","type":"Select","options":"Desktop, Laptop, Tablet, Phone, Set-Top Box, Rack-Mounted Server, Other","default":"Laptop","required":"Y"},{"name":"Operating System","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"Serial Number","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"Model Name","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"Model ID","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"CPU Type","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"CPU Speed","description":"In GHz.","type":"Text","options":"6","default":"","required":"N"},{"name":"Memory","description":"Total RAM, in GB.","type":"Text","options":"6","default":"","required":"N"},{"name":"Storage Type","description":"Primary internal storage type.","type":"Select","options":",HDD, SSD, Hybrid, Other","default":"","required":"N"},{"name":"Storage","description":"Total HDD/SDD capacity, in GB.","type":"Text","options":"6","default":"","required":"N"},{"name":"Wireless MAC Address","description":"","type":"Text","options":"17","default":"","required":"N"},{"name":"Wired MAC Address","description":"","type":"Text","options":"17","default":"","required":"N"},{"name":"Accessories","description":"Any chargers, display dongles, remotes etc?","type":"Text","options":"255","default":"","required":"N"},{"name":"Warranty Number","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"Warranty Expiry","description":"Format: dd/mm/yyyy.","type":"Date","options":"","default":"","required":"N"},{"name":"Last Reinstall Date","description":"Format: dd/mm/yyyy.","type":"Date","options":"","default":"","required":"N"},{"name":"Repair Log/Notes","description":"","type":"Textarea","options":"10","default":"","required":"N"}]'), (00008, 'Electronics', 'Y', '[{"name":"Type","description":"What kind of product is this?","type":"Text","options":"50","default":"","required":"Y"},{"name":"Serial Number","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"Model Name","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"Model ID","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"Accessories","description":"Any chargers, remotes controls, etc?","type":"Text","options":"255","default":"","required":"N"},{"name":"Warranty Number","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"Warranty Expiry","description":"Format: dd\\/mm\\/yyyy.","type":"Date","options":"","default":"","required":"N"},{"name":"Repair Log\\/Notes","description":"","type":"Textarea","options":"10","default":"","required":"N"}]'), (00009, 'Other', 'Y', '[{"name":"Type","description":"What kind of product is this?","type":"Text","options":"50","default":"","required":"Y"}]'), (00010, 'Software', 'Y', '[{"name":"Version","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"Operating System","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"License Type","description":"E.g. Open Source, Site License, number of users.","type":"Text","options":"255","default":"","required":"N"},{"name":"License Name","description":"If the software is registered, who is it registered to?","type":"Text","options":"255","default":"","required":"N"},{"name":"License Serial Number","description":"","type":"Text","options":"255","default":"","required":"N"},{"name":"License Expiry","description":"Format: dd\\/mm\\/yyyy.","type":"Date","options":"","default":"","required":"N"},{"name":"License Management Link","description":"Link to web-based management tool.","type":"URL","options":"255","default":"","required":"N"}]'), (00011, 'Audio/Visual Hardware', 'Y', '[{"name":"Type","description":"What kind of product is this?","type":"Text","options":"50","default":"","required":"Y"},{"name":"Serial Number","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"Model Name","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"Model ID","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"Accessories","description":"Any chargers, remotes controls, etc?","type":"Text","options":"255","default":"","required":"N"},{"name":"Warranty Number","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"Warranty Expiry","description":"Format: dd\\/mm\\/yyyy.","type":"Date","options":"","default":"","required":"N"},{"name":"Repair Log\\/Notes","description":"","type":"Textarea","options":"10","default":"","required":"N"}]'), (00012, 'Optical Media', 'Y', '[{"name":"Type","description":"What type of optical media is this?","type":"Select","options":"CD,DVD,Blu-Ray","default":"","required":"Y"},{"name":"Format","description":"Technical details of media formatting.","type":"Text","options":"255","default":"","required":"N"},{"name":"Language","description":"","type":"Text","options":"255","default":"","required":"N"},{"name":"Subtitles","description":"","type":"Text","options":"255","default":"","required":"N"},{"name":"Aspect Ratio","description":"","type":"Text","options":"20","default":"","required":"N"},{"name":"Number of Discs","description":"","type":"Select","options":",1,2,3,4,5","default":"","required":"N"},{"name":"Content Rating","description":"Details of age guidance or retrictions.","type":"Text","options":"255","default":"","required":"N"},{"name":"Studio","description":"Name of originating studio.","type":"Text","options":"255","default":"","required":"N"},{"name":"Release Date","description":"Format: dd\\/mm\\/yyyy, mm\\/yyyy or yyyy.","type":"Text","options":"10","default":"","required":"N"},{"name":"Run Time","description":"In minutes.","type":"Text","options":"3","default":"","required":"N"}]'), (00013, 'Telephone', 'Y', '[{"name":"Serial Number","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"Model Name","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"Model ID","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"Telephone Number","description":"External telephone number","type":"Text","options":"50","default":"","required":"N"},{"name":"Telephone Extension","description":"Internal telephone extension","type":"Text","options":"50","default":"","required":"N"},{"name":"Accessories","description":"Any chargers, remotes controls, etc?","type":"Text","options":"255","default":"","required":"N"},{"name":"Warranty Number","description":"","type":"Text","options":"50","default":"","required":"N"},{"name":"Warranty Expiry","description":"Format: dd\\/mm\\/yyyy.","type":"Date","options":"","default":"","required":"N"},{"name":"Wireless MAC Address","description":"","type":"Text","options":"17","default":"","required":"N"},{"name":"Wired MAC Address","description":"","type":"Text","options":"17","default":"","required":"N"},{"name":"Repair Log\\/Notes","description":"","type":"Textarea","options":"10","default":"","required":"N"}]'), (00014, 'Digital Publication', 'Y', '[{"name":"URL Link","description":"Paste the url link of the digital publication","type":"Text","options":"","default":"","required":"Y"}]'); -- -------------------------------------------------------- -- -- Table structure for table `gibbonLog` -- CREATE TABLE `gibbonLog` ( `gibbonLogID` int(16) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonModuleID` int(4) unsigned zerofill DEFAULT NULL, `gibbonPersonID` int(10) unsigned zerofill DEFAULT NULL, `gibbonSchoolYearID` int(3) unsigned zerofill NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `title` varchar(50) NOT NULL, `serialisedArray` text, `ip` varchar(15) DEFAULT NULL, PRIMARY KEY (`gibbonLogID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonMarkbookColumn` -- CREATE TABLE `gibbonMarkbookColumn` ( `gibbonMarkbookColumnID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonCourseClassID` int(8) unsigned zerofill NOT NULL, `gibbonHookID` int(4) unsigned zerofill DEFAULT NULL, `gibbonUnitID` int(10) unsigned zerofill DEFAULT NULL, `gibbonPlannerEntryID` int(14) unsigned zerofill DEFAULT NULL, `gibbonSchoolYearTermID` int(5) unsigned zerofill DEFAULT NULL, `groupingID` int(8) unsigned zerofill DEFAULT NULL COMMENT 'A value used to group multiple markbook columns.', `type` varchar(50) NOT NULL, `name` varchar(40) DEFAULT NULL, `description` text NOT NULL, `columnColor` varchar(7) DEFAULT NULL, `date` date DEFAULT NULL, `sequenceNumber` int unsigned NOT NULL DEFAULT '0', `attachment` varchar(255) NOT NULL, `attainment` enum('Y','N') NOT NULL DEFAULT 'Y', `gibbonScaleIDAttainment` int(5) unsigned zerofill DEFAULT NULL, `attainmentWeighting` decimal(5,2) DEFAULT NULL, `attainmentRaw` enum('Y','N') NOT NULL DEFAULT 'N', `attainmentRawMax` decimal(8,2) DEFAULT NULL, `effort` enum('Y','N') NOT NULL DEFAULT 'Y', `gibbonScaleIDEffort` int(5) unsigned zerofill DEFAULT NULL, `gibbonRubricIDAttainment` int(8) unsigned zerofill DEFAULT NULL, `gibbonRubricIDEffort` int(8) unsigned zerofill DEFAULT NULL, `comment` enum('Y','N') NOT NULL DEFAULT 'Y', `uploadedResponse` enum('Y','N') NOT NULL DEFAULT 'Y', `complete` enum('N','Y') NOT NULL, `completeDate` date DEFAULT NULL, `viewableStudents` enum('N','Y') NOT NULL, `viewableParents` enum('N','Y') NOT NULL, `gibbonPersonIDCreator` int(10) unsigned zerofill NOT NULL, `gibbonPersonIDLastEdit` int(10) unsigned zerofill NOT NULL, PRIMARY KEY (`gibbonMarkbookColumnID`), KEY `gibbonCourseClassID` (`gibbonCourseClassID`), KEY `completeDate` (`completeDate`), KEY `complete` (`complete`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonMarkbookEntry` -- CREATE TABLE `gibbonMarkbookEntry` ( `gibbonMarkbookEntryID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonMarkbookColumnID` int(10) unsigned zerofill NOT NULL, `gibbonPersonIDStudent` int(10) unsigned zerofill NOT NULL, `modifiedAssessment` enum('N','Y') DEFAULT NULL, `attainmentValue` varchar(10) DEFAULT NULL, `attainmentValueRaw` varchar(10) DEFAULT NULL, `attainmentDescriptor` varchar(100) DEFAULT NULL, `attainmentConcern` enum('N','Y','P') DEFAULT NULL COMMENT '''P'' denotes that student has exceed their personal target', `effortValue` varchar(10) DEFAULT NULL, `effortDescriptor` varchar(100) DEFAULT NULL, `effortConcern` enum('N','Y') DEFAULT NULL, `comment` text, `response` varchar(255) DEFAULT NULL, `gibbonPersonIDLastEdit` int(10) unsigned zerofill NOT NULL, PRIMARY KEY (`gibbonMarkbookEntryID`), KEY `gibbonPersonIDStudent` (`gibbonPersonIDStudent`), KEY `gibbonMarkbookColumnID` (`gibbonMarkbookColumnID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonMarkbookTarget` -- CREATE TABLE `gibbonMarkbookTarget` ( `gibbonMarkbookTargetID` int(14) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonCourseClassID` int(8) unsigned zerofill NOT NULL, `gibbonPersonIDStudent` int(10) unsigned zerofill NOT NULL, `gibbonScaleGradeID` int(7) unsigned zerofill DEFAULT NULL, PRIMARY KEY (`gibbonMarkbookTargetID`), UNIQUE KEY `coursePerson` (`gibbonCourseClassID`,`gibbonPersonIDStudent`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonMarkbookWeight` -- CREATE TABLE `gibbonMarkbookWeight` ( `gibbonMarkbookWeightID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonCourseClassID` int(8) unsigned zerofill NOT NULL, `type` varchar(50) NOT NULL, `description` varchar(50) NOT NULL, `reportable` enum('Y','N') NOT NULL DEFAULT 'Y', `calculate` enum('term','year') NOT NULL DEFAULT 'year', `weighting` decimal(5,2) NOT NULL, PRIMARY KEY (`gibbonMarkbookWeightID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonMedicalCondition` -- CREATE TABLE `gibbonMedicalCondition` ( `gibbonMedicalConditionID` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(80) NOT NULL, `description` text, PRIMARY KEY (`gibbonMedicalConditionID`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=28 ; -- -- Dumping data for table `gibbonMedicalCondition` -- INSERT INTO `gibbonMedicalCondition` VALUES (0001, 'Allergy - Food', NULL), (0002, 'Allergy - Insect', NULL), (0003, 'Allergy - Drug', NULL), (0004, 'Allergy - Animal', NULL), (0005, 'Allergy - Grass/Pollen', NULL), (0006, 'Allergy - Other', NULL), (0007, 'Asthma', NULL), (0008, 'G6PD Deficiency', NULL), (0009, 'Joint Problems', NULL), (0010, 'Diabetes', NULL), (0011, 'Hypertension', NULL), (0012, 'Convulsions/Epilepsy', NULL), (0013, 'Kidney Disease', NULL), (0014, 'Rare Blood Type', NULL), (0015, 'Heart Condition', NULL), (0016, 'Previous Concussion or Head Injury', NULL), (0017, 'Previous Serious Injury', NULL), (0018, 'Dizziness or Fainting spells', NULL), (0019, 'Rheumatic Fever', NULL), (0020, 'Frequent Nose Bleeds', NULL), (0021, 'Psychological Condition', NULL), (0022, 'Hearing Impairment', NULL), (0023, 'Visual Impairment', NULL), (0024, 'Visual Impairment - Requiring Contact Lenses or Glasses', NULL), (0025, 'Visual Impairment - Colour Blindness', NULL), (0026, 'Travel Sickness', NULL), (0027, 'Other', NULL); -- -------------------------------------------------------- -- -- Table structure for table `gibbonMessenger` -- CREATE TABLE `gibbonMessenger` ( `gibbonMessengerID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonSchoolYearID` int(3) unsigned zerofill DEFAULT NULL, `status` enum('Draft','Sending','Sent') NOT NULL DEFAULT 'Sent', `email` enum('N','Y') NOT NULL DEFAULT 'N', `messageWall` enum('N','Y') NOT NULL DEFAULT 'N', `messageWallPin` enum('N','Y') NOT NULL DEFAULT 'N', `messageWall_dateStart` date DEFAULT NULL, `messageWall_dateEnd` date DEFAULT NULL, `sms` enum('N','Y') NOT NULL DEFAULT 'N', `subject` varchar(60) NOT NULL, `body` text NOT NULL, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `timestamp` timestamp NULL DEFAULT NULL, `emailFrom` varchar(75) DEFAULT NULL, `emailReplyTo` varchar(75) DEFAULT NULL, `emailReport` text NOT NULL, `emailReceipt` enum('N','Y') DEFAULT NULL, `emailReceiptText` text, `individualNaming` enum('N','Y') NOT NULL DEFAULT 'N', `includeSignature` enum('N','Y') NOT NULL DEFAULT 'N', `smsReport` text NOT NULL, `confidential` enum('N','Y') NOT NULL DEFAULT 'N', `enableSharingLink` enum('N','Y') NOT NULL DEFAULT 'N', PRIMARY KEY (`gibbonMessengerID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonMessengerCannedResponse` -- CREATE TABLE `gibbonMessengerCannedResponse` ( `gibbonMessengerCannedResponseID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `subject` varchar(30) NOT NULL, `body` text NOT NULL, `timestampCreator` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `gibbonPersonIDCreator` int(10) unsigned zerofill NOT NULL, PRIMARY KEY (`gibbonMessengerCannedResponseID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonMessengerMailingList` -- CREATE TABLE `gibbonMessengerMailingList` ( `gibbonMessengerMailingListID` int(8) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(60) NOT NULL, `active` enum('Y','N') NOT NULL DEFAULT 'Y', `timestampCreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`gibbonMessengerMailingListID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonMessengerMailingListRecipient` -- CREATE TABLE `gibbonMessengerMailingListRecipient` ( `gibbonMessengerMailingListRecipientID` int(8) unsigned zerofill NOT NULL AUTO_INCREMENT, `surname` varchar(60) DEFAULT NULL, `preferredName` varchar(60) DEFAULT NULL, `email` varchar(75) NOT NULL, `organisation` varchar(60) DEFAULT NULL, `gibbonMessengerMailingListIDList` text, `key` varchar(40) DEFAULT NULL, `timestampCreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`gibbonMessengerMailingListRecipientID`), UNIQUE KEY `email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonMessengerReceipt` -- CREATE TABLE `gibbonMessengerReceipt` ( `gibbonMessengerReceiptID` int(14) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonMessengerID` int(12) unsigned zerofill NOT NULL, `gibbonPersonID` int(10) unsigned zerofill DEFAULT NULL, `sent` enum('N','Y') NOT NULL DEFAULT 'N', `targetType` enum('Class','Course','Form Group','Year Group','Activity','Role','Applicants','Individuals','Houses','Role Category','Transport','Attendance','Group','Mailing List') DEFAULT NULL, `targetID` varchar(30) NOT NULL, `contactType` enum('Email','SMS') DEFAULT NULL, `contactDetail` varchar(255) DEFAULT NULL, `key` varchar(40) DEFAULT NULL, `confirmed` enum('N','Y') DEFAULT NULL, `confirmedTimestamp` timestamp NULL DEFAULT NULL, `gibbonPersonIDListStudent` text, `nameListStudent` text, `unsubscribeKey` varchar(50) DEFAULT NULL, PRIMARY KEY (`gibbonMessengerReceiptID`), KEY `duplicateCheck` USING BTREE (`gibbonMessengerID`,`gibbonPersonID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonMessengerTarget` -- CREATE TABLE `gibbonMessengerTarget` ( `gibbonMessengerTargetID` int(14) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonMessengerID` int(12) unsigned zerofill NOT NULL, `type` enum('Class','Course','Form Group','Year Group','Activity','Role','Applicants','Individuals','Houses','Role Category','Transport','Attendance','Group','Mailing List') DEFAULT NULL, `id` varchar(30) NOT NULL, `parents` enum('N','Y') NOT NULL DEFAULT 'N', `students` enum('N','Y') NOT NULL DEFAULT 'N', `staff` enum('N','Y') NOT NULL DEFAULT 'N', PRIMARY KEY (`gibbonMessengerTargetID`), KEY `gibbonMessengerID` (`gibbonMessengerID`,`gibbonMessengerTargetID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonMigration` -- CREATE TABLE `gibbonMigration` ( `gibbonMigrationID` int(8) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(60) NOT NULL, `version` varchar(8) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`gibbonMigrationID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonModule` -- CREATE TABLE `gibbonModule` ( `gibbonModuleID` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT COMMENT 'This number is assigned at install, and is only unique to the installation', `name` varchar(30) NOT NULL DEFAULT '' COMMENT 'This name should be globally unique preferably, but certainly locally unique', `description` text NOT NULL, `entryURL` varchar(255) NOT NULL DEFAULT 'index.php', `type` enum('Core','Additional') NOT NULL DEFAULT 'Core', `active` enum('Y','N') NOT NULL DEFAULT 'Y', `category` varchar(12) NOT NULL, `version` varchar(8) NOT NULL, `author` varchar(40) NOT NULL, `url` varchar(255) NOT NULL, PRIMARY KEY (`gibbonModuleID`), UNIQUE KEY `gibbonModuleName` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=148 ; -- -- Dumping data for table `gibbonModule` -- INSERT INTO `gibbonModule` VALUES (0001, 'School Admin', 'Allows administrators to configure school settings.', 'schoolYear_manage.php', 'Core', 'Y', 'Admin', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0002, 'User Admin', 'Allows administrators to manage users.', 'user_manage.php', 'Core', 'Y', 'Admin', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0003, 'System Admin', 'Allows administrators to configure system settings.', 'systemOverview.php', 'Core', 'Y', 'Admin', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0004, 'Departments', 'View details within a department', 'departments.php', 'Core', 'Y', 'Learn', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0005, 'Students', 'Allows users to view student data', 'student_view.php', 'Core', 'Y', 'People', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0006, 'Attendance', 'School attendance taking', 'attendance.php', 'Core', 'Y', 'Pastoral', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0007, 'Markbook', 'A system for keeping track of marks', 'markbook_view.php', 'Core', 'Y', 'Assess', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0008, 'Data Updater', 'Allow users to update their family''s data', 'data_updates.php', 'Core', 'Y', 'People', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0009, 'Planner', 'Supports lesson planning and information sharing for staff, student and parents', 'planner.php', 'Core', 'Y', 'Learn', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0011, 'Individual Needs', 'Individual Needs', 'in_view.php', 'Core', 'Y', 'Pastoral', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0012, 'Crowd Assessment', 'Allows users to assess each other''s work', 'crowdAssess.php', 'Core', 'Y', 'Assess', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0013, 'Timetable Admin', 'Timetable administration', 'tt.php', 'Core', 'Y', 'Admin', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0014, 'Timetable', 'Allows users to view timetables', 'tt.php', 'Core', 'Y', 'Learn', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0015, 'Activities', 'Run a school activities program', 'explore.php', 'Core', 'Y', 'Learn', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0016, 'Formal Assessment', 'Facilitates tracking of student performance in external examinations.', 'externalAssessment.php', 'Core', 'Y', 'Assess', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0119, 'Behaviour', 'Tracking Student Behaviour', 'behaviour_manage.php', 'Core', 'Y', 'Pastoral', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0121, 'Messenger', 'Unified messenger for email, message wall and more.', 'messenger_manage.php', 'Core', 'Y', 'Other', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0126, 'Rubrics', 'Allows users to create rubrics for assessment', 'rubrics.php', 'Core', 'Y', 'Assess', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0130, 'Library', 'Allows the management of a catalog from which items can be borrowed.', 'library_manage_catalog.php', 'Core', 'Y', 'Learn', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0135, 'Finance', 'Allows a school to issue invoices and track payments.', 'invoices_manage.php', 'Core', 'Y', 'Other', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0136, 'Staff', 'Allows users to view staff information', 'staff_view.php', 'Core', 'Y', 'People', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0137, 'Form Groups', 'Allows users to view a listing of form groups', 'formGroups.php', 'Core', 'Y', 'People', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0141, 'Tracking', 'Provides visual graphing of student progress, as recorded in the Markbook and Internal Assessment.', 'graphing.php', 'Core', 'Y', 'Assess', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0144, 'Reports', 'Report writing and PDF generation', 'reporting_my.php', 'Core', 'Y', 'Assess', 'v19.0.', 'Gibbon Foundation', 'https://gibbonedu.org'), (0145, 'Admissions', '', 'studentEnrolment_manage.php', 'Core', 'Y', 'People', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0146, 'Student Alerts', 'View, create and manage alerts for students', 'studentAlerts_manage.php', 'Core', 'Y', 'Pastoral', '', 'Gibbon Foundation', 'https://gibbonedu.org'), (0147, 'Calendar', 'View and manage school events on a shared calendar.', 'calendar_view.php', 'Core', 'Y', 'Other', '', 'Gibbon Foundation', 'https://gibbonedu.org'); -- -------------------------------------------------------- -- -- Table structure for table `gibbonNotification` -- CREATE TABLE `gibbonNotification` ( `gibbonNotificationID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `status` enum('New','Archived') NOT NULL DEFAULT 'New', `gibbonModuleID` int(4) unsigned zerofill DEFAULT NULL, `count` int NOT NULL DEFAULT '1', `text` text NOT NULL, `actionLink` varchar(255) NOT NULL COMMENT 'Relative to absoluteURL, start with a forward slash', `timestamp` datetime NOT NULL, PRIMARY KEY (`gibbonNotificationID`), KEY `gibbonPersonID` (`gibbonPersonID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonNotificationEvent` -- CREATE TABLE `gibbonNotificationEvent` ( `gibbonNotificationEventID` int(6) unsigned zerofill NOT NULL AUTO_INCREMENT, `event` varchar(90) NOT NULL, `moduleName` varchar(30) NOT NULL, `actionName` varchar(50) NOT NULL, `type` enum('Core','Additional','CLI') NOT NULL DEFAULT 'Core', `scopes` varchar(255) NOT NULL DEFAULT 'All', `active` enum('Y','N') NOT NULL DEFAULT 'Y', PRIMARY KEY (`gibbonNotificationEventID`), UNIQUE KEY `event` (`event`,`moduleName`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=49 ; -- -- Dumping data for table `gibbonNotificationEvent` -- INSERT INTO `gibbonNotificationEvent` VALUES (000001, 'Daily Behaviour Summary', 'Behaviour', 'Find Behaviour Patterns', 'CLI', 'All', 'Y'), (000002, 'New Negative Record', 'Behaviour', 'View Behaviour Records_all', 'Core', 'All,gibbonPersonIDStudent,gibbonYearGroupID', 'Y'), (000003, 'New Positive Record', 'Behaviour', 'View Behaviour Records_all', 'Core', 'All,gibbonPersonIDStudent,gibbonYearGroupID', 'Y'), (000004, 'Family Data Updates', 'Data Updater', 'Family Data Updates', 'Core', 'All', 'Y'), (000005, 'Finance Data Updates', 'Data Updater', 'Finance Data Updates', 'Core', 'All', 'Y'), (000006, 'Medical Form Updates', 'Data Updater', 'Medical Form Updates', 'Core', 'All', 'Y'), (000007, 'Personal Data Updates', 'Data Updater', 'Personal Data Updates', 'Core', 'All', 'Y'), (000008, 'Login - Failed', 'User Admin', 'Manage Users', 'Core', 'All', 'Y'), (000009, 'New Public Registration', 'User Admin', 'Manage Users', 'Core', 'All', 'Y'), (000010, 'New Application Form', 'Admissions', 'View Student Profile_full', 'Core', 'All', 'Y'), (000011, 'New Application Form', 'Staff', 'Manage Applications', 'Core', 'All', 'Y'), (000012, 'Student Withdrawn', 'Activities', 'Manage Activities', 'Core', 'All,gibbonPersonIDStudent,gibbonYearGroupID', 'Y'), (000013, 'New Activity Registration', 'Activities', 'Manage Activities', 'Core', 'All,gibbonPersonIDStudent,gibbonYearGroupID', 'Y'), (000014, 'Updated Individual Needs', 'Individual Needs', 'Individual Needs Records_viewEdit', 'Core', 'All,gibbonPersonIDStudent,gibbonYearGroupID', 'Y'), (000015, 'Student Notes', 'Students', 'View Student Profile_full', 'Core', 'All,gibbonPersonIDStudent,gibbonYearGroupID', 'Y'), (000016, 'Updated Privacy Settings', 'Students', 'View Student Profile_full', 'Core', 'All,gibbonPersonIDStudent,gibbonYearGroupID', 'Y'), (000017, 'Daily Attendance Summary', 'Attendance', 'Form Groups Not Registered', 'CLI', 'All', 'Y'), (000018, 'User Status Check and Fix', 'User Admin', 'Manage Users', 'CLI', 'All', 'Y'), (000019, 'Overdue Loan Items', 'Library', 'Lending & Activity Log', 'CLI', 'All', 'Y'), (000020, 'Behaviour Letters', 'Behaviour', 'View Behaviour Records_all', 'CLI', 'All', 'Y'), (000021, 'Parent Weekly Email Summary', 'School Admin', 'Parent Weekly Email Summary', 'CLI', 'All', 'Y'), (000022, 'Application Form Accepted', 'Admissions', 'View Student Profile_full', 'Core', 'All,gibbonYearGroupID', 'Y'), (000023, 'Weekly Attendance Summary', 'Attendance', 'Attendance Summary by Date', 'CLI', 'All,gibbonYearGroupID', 'Y'), (000024, 'Student Bumped', 'Activities', 'Manage Activities', 'Core', 'All', 'Y'), (000025, 'Updated Behaviour Record', 'Behaviour', 'View Behaviour Records_all', 'Core', 'All,gibbonPersonIDStudent,gibbonYearGroupID', 'Y'), (000026, 'Student Withdrawn', 'Admissions', 'View Student Profile_full', 'Core', 'All,gibbonYearGroupID', 'Y'), (000027, 'New Staff', 'Staff', 'Staff Directory_full', 'Core', 'All', 'Y'), (000028, 'Staff Left', 'Staff', 'Staff Directory_full', 'Core', 'All', 'Y'), (000029, 'Parent Daily Email Summary', 'School Admin', 'Parent Weekly Email Summary', 'CLI', 'All', 'Y'), (000030, 'Tutor Daily Email Summary', 'School Admin', 'Parent Weekly Email Summary', 'CLI', 'All', 'Y'), (000031, 'Medical Condition', 'Students', 'Manage Medical Forms', 'Core', 'All,gibbonPersonIDStudent,gibbonYearGroupID', 'Y'), (000032, 'New Application with SEN/Medical', 'Admissions', 'Manage Applications', 'Core', 'All,gibbonPersonIDStudent,gibbonYearGroupID', 'Y'), (000033, 'Staff Data Updates', 'Data Updater', 'Staff Data Updates', 'Core', 'All', 'Y'), (000034, 'Updated Timetable Subscriber', 'Timetable', 'View Timetable by Person', 'Core', 'All', 'Y'), (000035, 'New Investigation', 'Individual Needs', 'Manage Investigations', 'Core', 'All,gibbonPersonIDStudent,gibbonYearGroupID', 'Y'), (000036, 'Behaviour Record for IN Student', 'Behaviour', 'View Behaviour Records_all', 'Core', 'All,gibbonPersonIDStudent,gibbonYearGroupID', 'Y'), (000037, 'Remove Stale Notifications', 'User Admin', 'Manage Users', 'CLI', 'All', 'Y'), (000038, 'Activity Enrolment Added', 'Activities', 'View Activities', 'Core', 'All', 'Y'), (000039, 'Activity Enrolment Removed', 'Activities', 'View Activities', 'Core', 'All', 'Y'), (000040, 'Activity Status Changed', 'Activities', 'View Activities', 'Core', 'All', 'Y'), (000041, 'First Aid Qualification Expiry', 'Staff', 'Manage Staff', 'Core', 'All', 'Y'), (000042, 'Student Form Group Changed', 'Admissions', 'View Student Profile_full', 'Core', 'All,gibbonYearGroupID', 'Y'), (000043, 'Petty Cash Notification', 'Finance', 'Petty Cash', 'Core', 'All', 'Y'), (000044, 'New Observation Record', 'Behaviour', 'View Behaviour Records_all', 'Core', 'All,gibbonPersonIDStudent,gibbonYearGroupID', 'Y'), (000045, 'Pending Student Alert', 'Student Alerts', 'Manage Student Alerts', 'Core', 'All,gibbonPersonIDStudent,gibbonYearGroupID', 'Y'), (000046, 'New Global Alert', 'Student Alerts', 'Manage Student Alerts', 'Core', 'All,gibbonPersonIDStudent,gibbonYearGroupID', 'Y'), (000047, 'Updated Student Alert', 'Student Alerts', 'Manage Student Alerts', 'Core', 'All,gibbonPersonIDStudent,gibbonYearGroupID', 'Y'), (000048, 'New Class Alert', 'Student Alerts', 'Manage Student Alerts', 'Core', 'All,gibbonPersonIDStudent,gibbonYearGroupID', 'Y'); -- -------------------------------------------------------- -- -- Table structure for table `gibbonNotificationListener` -- CREATE TABLE `gibbonNotificationListener` ( `gibbonNotificationListenerID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonNotificationEventID` int(6) unsigned zerofill DEFAULT NULL, `gibbonPersonID` int(10) unsigned zerofill DEFAULT NULL, `scopeType` varchar(30) DEFAULT NULL, `scopeID` int unsigned DEFAULT NULL, PRIMARY KEY (`gibbonNotificationListenerID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonOutcome` -- CREATE TABLE `gibbonOutcome` ( `gibbonOutcomeID` int(8) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `nameShort` varchar(14) NOT NULL, `category` varchar(50) NOT NULL, `description` text NOT NULL, `active` enum('Y','N') NOT NULL, `scope` enum('School','Learning Area') NOT NULL, `gibbonDepartmentID` int(4) unsigned zerofill DEFAULT NULL, `gibbonYearGroupIDList` varchar(255) NOT NULL, `gibbonPersonIDCreator` int(10) unsigned zerofill NOT NULL, PRIMARY KEY (`gibbonOutcomeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonPayment` -- CREATE TABLE `gibbonPayment` ( `gibbonPaymentID` int(14) unsigned zerofill NOT NULL AUTO_INCREMENT, `foreignTable` varchar(50) NOT NULL, `foreignTableID` int(14) unsigned zerofill NOT NULL, `gibbonPersonID` int(10) unsigned zerofill DEFAULT NULL COMMENT 'Person recording the transaction', `type` varchar(60) NOT NULL DEFAULT 'Online', `status` enum('Complete','Partial','Final','Failure') NOT NULL DEFAULT 'Complete' COMMENT 'Complete means paid in one go, partial is part of a set of payments, and final is last in a set of payments.', `amount` decimal(13,2) NOT NULL, `gateway` varchar(30) DEFAULT NULL, `onlineTransactionStatus` enum('Success','Failure') DEFAULT NULL, `paymentToken` varchar(50) DEFAULT NULL, `paymentPayerID` varchar(50) DEFAULT NULL, `paymentTransactionID` varchar(50) DEFAULT NULL, `paymentReceiptID` varchar(50) DEFAULT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`gibbonPaymentID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonPermission` -- CREATE TABLE `gibbonPermission` ( `permissionID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonRoleID` int(3) unsigned zerofill NOT NULL, `gibbonActionID` int(7) unsigned zerofill NOT NULL, PRIMARY KEY (`permissionID`), KEY `gibbonRoleID` (`gibbonRoleID`), KEY `gibbonActionID` (`gibbonActionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=54100 ; -- -- Dumping data for table `gibbonPermission` -- INSERT INTO `gibbonPermission` VALUES (0000053554, 001, 0000705), (0000053555, 006, 0000705), (0000053556, 002, 0000705), (0000053557, 001, 0000709), (0000053558, 002, 0000709), (0000053559, 001, 0000673), (0000053560, 006, 0000673), (0000053561, 002, 0000673), (0000053562, 001, 0000067), (0000053563, 006, 0000067), (0000053564, 002, 0000067), (0000053565, 001, 0000058), (0000053566, 006, 0000058), (0000053567, 002, 0000058), (0000053568, 001, 0000055), (0000053569, 001, 0000056), (0000053570, 003, 0000056), (0000053571, 002, 0000056), (0000053572, 001, 0000057), (0000053573, 006, 0000057), (0000053574, 002, 0000057), (0000053575, 001, 0000059), (0000053576, 006, 0000059), (0000053578, 003, 0000053), (0000053579, 001, 0000052), (0000053580, 004, 0000052), (0000053581, 006, 0000052), (0000053582, 002, 0000052), (0000053587, 001, 0000026), (0000053588, 006, 0000026), (0000053589, 002, 0000026), (0000053590, 001, 0000027), (0000053591, 006, 0000027), (0000053592, 002, 0000027), (0000053593, 001, 0000030), (0000053594, 006, 0000030), (0000053595, 002, 0000030), (0000053596, 001, 0000028), (0000053597, 006, 0000028), (0000053598, 002, 0000028), (0000053599, 001, 0000031), (0000053600, 006, 0000031), (0000053601, 002, 0000031), (0000053602, 004, 0000060), (0000053603, 001, 0000044), (0000053604, 006, 0000044), (0000053605, 002, 0000044), (0000053606, 001, 0000029), (0000053607, 006, 0000029), (0000053608, 002, 0000029), (0000053609, 001, 0000719), (0000053610, 002, 0000719), (0000053611, 001, 0000606), (0000053612, 002, 0000607), (0000053613, 001, 0000608), (0000053614, 002, 0000608), (0000053615, 001, 0000047), (0000053616, 004, 0000047), (0000053617, 003, 0000047), (0000053618, 002, 0000047), (0000053619, 001, 0000764), (0000053620, 001, 0000765), (0000053621, 004, 0000765), (0000053622, 006, 0000765), (0000053623, 002, 0000765), (0000053624, 001, 0000773), (0000053625, 001, 0000774), (0000053626, 004, 0000774), (0000053627, 006, 0000774), (0000053628, 002, 0000774), (0000053629, 001, 0000586), (0000053630, 004, 0000064), (0000053631, 001, 0000585), (0000053632, 004, 0000014), (0000053633, 006, 0000014), (0000053634, 002, 0000014), (0000053635, 001, 0000022), (0000053636, 004, 0000022), (0000053637, 003, 0000022), (0000053638, 006, 0000022), (0000053639, 002, 0000022), (0000053640, 001, 0000069), (0000053641, 001, 0000068), (0000053642, 002, 0000068), (0000053643, 001, 0000772), (0000053644, 001, 0000770), (0000053645, 001, 0000767), (0000053646, 001, 0000769), (0000053647, 001, 0000768), (0000053648, 001, 0000771), (0000053649, 002, 0000716), (0000053650, 001, 0000046), (0000053651, 001, 0000718), (0000053652, 001, 0000720), (0000053653, 004, 0000720), (0000053654, 003, 0000720), (0000053655, 006, 0000720), (0000053656, 002, 0000720), (0000053657, 001, 0000748), (0000053658, 006, 0000748), (0000053659, 001, 0000711), (0000053660, 001, 0000710), (0000053661, 001, 0000722), (0000053662, 002, 0000722), (0000053663, 001, 0000721), (0000053664, 001, 0000759), (0000053665, 002, 0000758), (0000053666, 001, 0000034), (0000053667, 002, 0000034), (0000053668, 004, 0000041), (0000053669, 001, 0000033), (0000053670, 006, 0000033), (0000053671, 002, 0000033), (0000053672, 003, 0000039), (0000053673, 001, 0000630), (0000053674, 002, 0000629), (0000053675, 001, 0000624), (0000053676, 001, 0000623), (0000053677, 002, 0000623), (0000053678, 001, 0000625), (0000053679, 002, 0000625), (0000053680, 001, 0000657), (0000053681, 001, 0000743), (0000053682, 002, 0000743), (0000053683, 001, 0000744), (0000053684, 002, 0000744), (0000053685, 001, 0000745), (0000053686, 001, 0000615), (0000053687, 001, 0000614), (0000053688, 002, 0000614), (0000053689, 001, 0000616), (0000053690, 002, 0000616), (0000053691, 001, 0000618), (0000053692, 001, 0000617), (0000053693, 002, 0000617), (0000053694, 001, 0000619), (0000053695, 002, 0000619), (0000053696, 001, 0000632), (0000053697, 001, 0000660), (0000053698, 002, 0000660), (0000053699, 001, 0000658), (0000053700, 002, 0000658), (0000053701, 001, 0000628), (0000053702, 001, 0000621), (0000053703, 001, 0000620), (0000053704, 002, 0000620), (0000053705, 001, 0000622), (0000053706, 002, 0000622), (0000053707, 001, 0000626), (0000053708, 002, 0000626), (0000053709, 001, 0000627), (0000053710, 001, 0000746), (0000053711, 004, 0000746), (0000053712, 003, 0000746), (0000053713, 002, 0000746), (0000053714, 002, 0000036), (0000053715, 001, 0000038), (0000053716, 004, 0000040), (0000053717, 003, 0000035), (0000053718, 002, 0000675), (0000053719, 001, 0000676), (0000053720, 001, 0000661), (0000053721, 002, 0000662), (0000053722, 001, 0000061), (0000053723, 002, 0000061), (0000053724, 001, 0000611), (0000053725, 006, 0000612), (0000053726, 002, 0000612), (0000053727, 001, 0000613), (0000053728, 006, 0000613), (0000053729, 002, 0000613), (0000053730, 001, 0000781), (0000053731, 003, 0000781), (0000053732, 006, 0000781), (0000053733, 002, 0000781), (0000053734, 002, 0000678), (0000053735, 001, 0000679), (0000053736, 001, 0000708), (0000053737, 004, 0000708), (0000053738, 003, 0000708), (0000053739, 002, 0000708), (0000053740, 001, 0000726), (0000053741, 001, 0000054), (0000053742, 001, 0000715), (0000053743, 001, 0000605), (0000053744, 001, 0000013), (0000053745, 001, 0000062), (0000053746, 001, 0000756), (0000053747, 001, 0000706), (0000053748, 001, 0000008), (0000053749, 001, 0000717), (0000053750, 001, 0000712), (0000053751, 001, 0000674), (0000053752, 001, 0000610), (0000053753, 001, 0000007), (0000053754, 001, 0000003), (0000053755, 001, 0000747), (0000053756, 001, 0000025), (0000053757, 001, 0000016), (0000053758, 001, 0000742), (0000053759, 001, 0000015), (0000053760, 001, 0000006), (0000053761, 001, 0000727), (0000053762, 001, 0000779), (0000053763, 001, 0000780), (0000053764, 001, 0000713), (0000053765, 001, 0000077), (0000053766, 006, 0000077), (0000053767, 002, 0000077), (0000053768, 001, 0000724), (0000053769, 001, 0000755), (0000053770, 001, 0000075), (0000053771, 006, 0000075), (0000053772, 002, 0000075), (0000053773, 001, 0000707), (0000053774, 002, 0000707), (0000053775, 001, 0000714), (0000053776, 001, 0000073), (0000053777, 006, 0000073), (0000053778, 002, 0000073), (0000053779, 001, 0000757), (0000053780, 001, 0000072), (0000053781, 006, 0000072), (0000053782, 002, 0000072), (0000053783, 001, 0000043), (0000053784, 006, 0000043), (0000053785, 002, 0000043), (0000053786, 003, 0000023), (0000053787, 001, 0000024), (0000053788, 006, 0000024), (0000053789, 002, 0000024), (0000053790, 004, 0000042), (0000053791, 001, 0000010), (0000053792, 001, 0000020), (0000053793, 001, 0000005), (0000053794, 001, 0000631), (0000053795, 001, 0000760), (0000053796, 001, 0000051), (0000053797, 004, 0000051), (0000053798, 003, 0000051), (0000053799, 006, 0000051), (0000053800, 002, 0000051), (0000053801, 001, 0000655), (0000053802, 006, 0000655), (0000053803, 002, 0000655), (0000053804, 001, 0000066), (0000053805, 001, 0000018), (0000053806, 001, 0000656), (0000053807, 001, 0000049), (0000053808, 001, 0000017), (0000053809, 001, 0000048), (0000053810, 001, 0000050), (0000053812, 001, 0000725), (0000053813, 001, 0000766), (0000053814, 001, 0000775), (0000053816, 001, 0000019), (0000053817, 001, 0000021), (0000053818, 001, 0000012), (0000053819, 001, 0000009), (0000053820, 001, 0000032), (0000053821, 001, 0000723), (0000053822, 001, 0000002), (0000053823, 001, 0000065), (0000053824, 001, 0000063), (0000053825, 001, 0000070), (0000053826, 001, 0000004), (0000053827, 001, 0000778), (0000053828, 001, 0000777), (0000053829, 001, 0000776), (0000053842, 001, 0000796), (0000053851, 001, 0000802), (0000053852, 002, 0000802), (0000053853, 004, 0000781), (0000053854, 001, 0000803), (0000053855, 001, 0000804), (0000053856, 001, 0000805), (0000053857, 001, 0000804), (0000053858, 001, 0000806), (0000053859, 001, 0000807), (0000053860, 002, 0000807), (0000053861, 001, 0000808), (0000053862, 001, 0000809), (0000053863, 001, 0000810), (0000053864, 002, 0000810), (0000053865, 001, 0000811), (0000053866, 001, 0000812), (0000053867, 002, 0000813), (0000053868, 001, 0000814), (0000053869, 002, 0000815), (0000053870, 001, 0000816), (0000053871, 001, 0000817), (0000053872, 002, 0000817), (0000053873, 001, 0000818), (0000053874, 002, 0000818), (0000053875, 006, 0000818), (0000053876, 001, 0000819), (0000053878, 001, 0000820), (0000053879, 001, 0000821), (0000053880, 001, 0000822), (0000053881, 001, 0000823), (0000053882, 001, 0000824), (0000053883, 001, 0000825), (0000053884, 001, 0000826), (0000053885, 001, 0000827), (0000053886, 002, 0000827), (0000053887, 006, 0000827), (0000053888, 001, 0000828), (0000053889, 002, 0000829), (0000053890, 006, 0000829), (0000053891, 001, 0000830), (0000053892, 001, 0000831), (0000053893, 001, 0000832), (0000053894, 001, 0000833), (0000053895, 002, 0000834), (0000053896, 001, 0000835), (0000053897, 003, 0000836), (0000053898, 004, 0000837), (0000053899, 001, 0000838), (0000053900, 002, 0000838), (0000053901, 001, 0000839), (0000053902, 001, 0000841), (0000053903, 001, 0000842), (0000053904, 001, 0000843), (0000053905, 001, 0000844), (0000053906, 001, 0000846), (0000053907, 001, 0000847), (0000053908, 001, 0000848), (0000053909, 004, 0000849), (0000053910, 001, 0000851), (0000053912, 001, 0000853), (0000053913, 001, 0000854), (0000053914, 001, 0000855), (0000053915, 001, 0000856), (0000053916, 002, 0000856), (0000053917, 006, 0000856), (0000053918, 001, 0000857), (0000053920, 001, 0000859), (0000053921, 001, 0000860), (0000053922, 002, 0000860), (0000053923, 001, 0000861), (0000053924, 002, 0000861), (0000053925, 001, 0000866), (0000053926, 001, 0000867), (0000053927, 001, 0000868), (0000053928, 001, 0000869), (0000053929, 002, 0000869), (0000053930, 001, 0000870), (0000053931, 001, 0000871), (0000053932, 001, 0000872), (0000053933, 001, 0000873), (0000053934, 002, 0000873), (0000053935, 001, 0000874), (0000053936, 002, 0000874), (0000053937, 001, 0000875), (0000053938, 002, 0000875), (0000053939, 001, 0000876), (0000053940, 002, 0000876), (0000053941, 001, 0000877), (0000053942, 001, 0000878), (0000053943, 002, 0000878), (0000053944, 006, 0000878), (0000053945, 001, 0000879), (0000053946, 001, 0000880), (0000053947, 002, 0000880), (0000053948, 001, 0000881), (0000053949, 001, 0000882), (0000053950, 001, 0000883), (0000053951, 001, 0000884), (0000053952, 001, 0000886), (0000053953, 006, 0000746), (0000053954, 001, 0000888), (0000053955, 001, 0000889), (0000053956, 002, 0000889), (0000053957, 001, 0000890), (0000053958, 002, 0000890), (0000053959, 001, 0000891), (0000053960, 003, 0000894), (0000053961, 004, 0000895), (0000053962, 003, 0000896), (0000053963, 001, 0000898), (0000053964, 001, 0000899), (0000053965, 001, 0000900), (0000053966, 001, 0000902), (0000053967, 001, 0000903), (0000053968, 002, 0000903), (0000053969, 001, 0000904), (0000053970, 002, 0000904), (0000053971, 004, 0000904), (0000053972, 006, 0000904), (0000053973, 001, 0000905), (0000053974, 002, 0000906), (0000053975, 001, 0000907), (0000053976, 002, 0000908), (0000053977, 001, 0000909), (0000053978, 001, 0000910), (0000053979, 001, 0000912), (0000053980, 001, 0000913), (0000053981, 001, 0000914), (0000053982, 001, 0000916), (0000053983, 001, 0000918), (0000053984, 001, 0000919), (0000053985, 001, 0000920), (0000053986, 001, 0000921), (0000053987, 001, 0000922), (0000053988, 001, 0000923), (0000053989, 001, 0000924), (0000053990, 001, 0000925), (0000053991, 001, 0000926), (0000053992, 001, 0000927), (0000053993, 001, 0000928), (0000053994, 001, 0000930), (0000053995, 001, 0000933), (0000053996, 001, 0000934), (0000053997, 001, 0000935), (0000053998, 002, 0000936), (0000053999, 001, 0000937), (0000054000, 002, 0000937), (0000054001, 001, 0000938), (0000054002, 001, 0000939), (0000054003, 001, 0000940), (0000054004, 001, 0000941), (0000054005, 001, 0000942), (0000054006, 001, 0000943), (0000054007, 001, 0000944), (0000054008, 004, 0000945), (0000054009, 003, 0000946), (0000054010, 001, 0000947), (0000054011, 001, 0000948), (0000054012, 002, 0000948), (0000054013, 001, 0000949), (0000054014, 002, 0000949), (0000054015, 001, 0000950), (0000054016, 001, 0000951), (0000054017, 001, 0000952), (0000054018, 001, 0000953), (0000054019, 002, 0000954), (0000054020, 001, 0000955), (0000054021, 001, 0000956), (0000054022, 001, 0000957), (0000054023, 001, 0000958), (0000054024, 001, 0000959), (0000054025, 002, 0000960), (0000054026, 001, 0000961), (0000054027, 001, 0000962), (0000054028, 001, 0000963), (0000054029, 001, 0000965), (0000054030, 001, 0000966), (0000054031, 001, 0000967), (0000054032, 001, 0000968), (0000054033, 001, 0000969), (0000054034, 001, 0000970), (0000054035, 001, 0000971), (0000054036, 002, 0000971), (0000054037, 001, 0000972), (0000054038, 001, 0000973), (0000054039, 001, 0000974), (0000054040, 001, 0000975), (0000054041, 001, 0000976), (0000054042, 001, 0000977), (0000054043, 002, 0000977), (0000054044, 001, 0000978), (0000054045, 001, 0000979), (0000054046, 001, 0000980), (0000054047, 002, 0000980), (0000054048, 001, 0000981), (0000054049, 006, 0000977), (0000054050, 001, 0000982), (0000054051, 001, 0000983), (0000054052, 001, 0000984), (0000054053, 001, 0000985), (0000054054, 001, 0000986), (0000054056, 001, 0000988), (0000054057, 001, 0000989), (0000054058, 002, 0000990), (0000054059, 004, 0000990), (0000054060, 006, 0000990), (0000054061, 001, 0000991), (0000054062, 001, 0000992), (0000054063, 001, 0000993), (0000054064, 001, 0000994), (0000054065, 002, 0000994), (0000054066, 001, 0000995), (0000054067, 001, 0000997), (0000054068, 001, 0000999), (0000054069, 001, 0001000), (0000054070, 001, 0001001), (0000054071, 001, 0001002), (0000054072, 001, 0001003), (0000054073, 002, 0001003), (0000054074, 004, 0001003), (0000054075, 001, 0001004), (0000054076, 003, 0001005), (0000054077, 001, 0001006), (0000054078, 001, 0001007), (0000054079, 001, 0001008), (0000054080, 001, 0001009), (0000054081, 001, 0001010), (0000054082, 001, 0001011), (0000054083, 001, 0001012), (0000054084, 004, 0001013), (0000054085, 001, 0001015), (0000054086, 001, 0001018), (0000054087, 001, 0001017), (0000054088, 002, 0001017), (0000054089, 001, 0001020), (0000054090, 001, 0001021), (0000054091, 002, 0001021), (0000054092, 001, 0001022), (0000054093, 001, 0001023), (0000054094, 001, 0001024), (0000054095, 002, 0001024), (0000054096, 001, 0001025), (0000054097, 002, 0001025), (0000054098, 002, 0001020), (0000054099, 001, 0001026); -- -------------------------------------------------------- -- -- Table structure for table `gibbonPerson` -- CREATE TABLE `gibbonPerson` ( `gibbonPersonID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `title` varchar(5) NOT NULL, `surname` varchar(60) NOT NULL DEFAULT '', `firstName` varchar(60) NOT NULL DEFAULT '', `preferredName` varchar(60) NOT NULL DEFAULT '', `officialName` varchar(150) NOT NULL, `nameInCharacters` varchar(60) NOT NULL, `gender` enum('M','F','Other','Unspecified') NOT NULL DEFAULT 'Unspecified', `username` varchar(40) DEFAULT NULL, `passwordStrong` varchar(255) NOT NULL, `passwordStrongSalt` varchar(255) NOT NULL, `passwordForceReset` enum('N','Y') NOT NULL DEFAULT 'N' COMMENT 'Force user to reset password on next login.', `status` enum('Full','Expected','Left','Pending Approval') NOT NULL DEFAULT 'Full', `canLogin` enum('Y','N') NOT NULL DEFAULT 'Y', `gibbonRoleIDPrimary` int(3) unsigned zerofill NOT NULL, `gibbonRoleIDAll` varchar(255) NOT NULL, `dob` date DEFAULT NULL, `email` varchar(75) DEFAULT NULL, `emailAlternate` varchar(75) DEFAULT NULL, `image_240` varchar(255) DEFAULT NULL, `lastIPAddress` varchar(15) NOT NULL DEFAULT '', `lastTimestamp` timestamp NULL DEFAULT NULL, `lastFailIPAddress` varchar(15) DEFAULT NULL, `lastFailTimestamp` timestamp NULL DEFAULT NULL, `failCount` int DEFAULT '0', `address1` mediumtext NOT NULL, `address1District` varchar(255) NOT NULL, `address1Country` varchar(255) NOT NULL, `address2` mediumtext NOT NULL, `address2District` varchar(255) NOT NULL, `address2Country` varchar(255) NOT NULL, `phone1Type` enum('','Mobile','Home','Work','Fax','Pager','Other') NOT NULL DEFAULT '', `phone1CountryCode` varchar(7) NOT NULL, `phone1` varchar(20) NOT NULL, `phone3Type` enum('','Mobile','Home','Work','Fax','Pager','Other') NOT NULL DEFAULT '', `phone3CountryCode` varchar(7) NOT NULL, `phone3` varchar(20) NOT NULL, `phone2Type` enum('','Mobile','Home','Work','Fax','Pager','Other') NOT NULL DEFAULT '', `phone2CountryCode` varchar(7) NOT NULL, `phone2` varchar(20) NOT NULL, `phone4Type` enum('','Mobile','Home','Work','Fax','Pager','Other') NOT NULL DEFAULT '', `phone4CountryCode` varchar(7) NOT NULL, `phone4` varchar(20) NOT NULL, `website` varchar(255) NOT NULL, `languageFirst` varchar(30) NOT NULL, `languageSecond` varchar(30) NOT NULL, `languageThird` varchar(30) NOT NULL, `countryOfBirth` varchar(30) NOT NULL, `birthCertificateScan` varchar(255) NOT NULL, `ethnicity` varchar(255) NOT NULL, `religion` varchar(30) NOT NULL, `profession` varchar(90) NOT NULL, `employer` varchar(90) NOT NULL, `jobTitle` varchar(90) NOT NULL, `emergency1Name` varchar(90) NOT NULL, `emergency1Number1` varchar(30) NOT NULL, `emergency1Number2` varchar(30) NOT NULL, `emergency1Relationship` varchar(30) NOT NULL, `emergency2Name` varchar(90) NOT NULL, `emergency2Number1` varchar(30) NOT NULL, `emergency2Number2` varchar(30) NOT NULL, `emergency2Relationship` varchar(30) NOT NULL, `gibbonHouseID` int(3) unsigned zerofill DEFAULT NULL, `studentID` varchar(15) NOT NULL, `dateStart` date DEFAULT NULL, `dateEnd` date DEFAULT NULL, `gibbonSchoolYearIDClassOf` int(3) unsigned zerofill DEFAULT NULL, `lastSchool` varchar(100) NOT NULL, `nextSchool` varchar(100) NOT NULL, `departureReason` varchar(100) NOT NULL, `transport` varchar(255) NOT NULL, `transportNotes` text NOT NULL, `calendarFeedPersonal` text NOT NULL, `viewCalendarSchool` enum('Y','N') NOT NULL DEFAULT 'Y', `viewCalendarPersonal` enum('Y','N') NOT NULL DEFAULT 'Y', `viewCalendarSpaceBooking` enum('Y','N') NOT NULL DEFAULT 'N', `gibbonApplicationFormID` int(12) unsigned zerofill DEFAULT NULL, `lockerNumber` varchar(20) NOT NULL, `vehicleRegistration` varchar(20) NOT NULL, `personalBackground` varchar(255) NOT NULL, `messengerLastRead` datetime DEFAULT NULL, `privacy` text, `dayType` varchar(255) DEFAULT NULL COMMENT 'Student day type, as specified in the application form.', `gibbonThemeIDPersonal` int(4) unsigned zerofill DEFAULT NULL, `gibboni18nIDPersonal` int(4) unsigned zerofill DEFAULT NULL, `studentAgreements` text, `googleAPIRefreshToken` text NOT NULL, `microsoftAPIRefreshToken` text NOT NULL, `genericAPIRefreshToken` text NOT NULL, `receiveNotificationEmails` enum('Y','N') NOT NULL DEFAULT 'Y', `mfaSecret` varchar(16) DEFAULT NULL, `mfaToken` text, `cookieConsent` enum('Y','N') DEFAULT NULL, `preferences` text, `fields` text NOT NULL COMMENT 'JSON object of custom field values', PRIMARY KEY (`gibbonPersonID`), UNIQUE KEY `username` (`username`), KEY `username_2` (`username`,`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=2 ; -- -- Dumping data for table `gibbonPerson` -- INSERT INTO `gibbonPerson` VALUES (0000000001, '[[title]]', '[[sname]]', '[[fname]]', '[[fname]]', '[[fname]] [[sname]]', '', 'Unspecified', '[[admin_username]]', '[[admin_pass]]', '[[passwordStrongSalt]]', 'N', 'Full', 'Y', 001, '001', NULL, '[[admin_email]]', NULL, NULL, '', NULL, NULL, NULL, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', NULL, NULL, NULL, '', '', '', '', '', '', 'Y', 'Y', 'N', NULL, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', 'Y', NULL, NULL, NULL, NULL, ''); -- -------------------------------------------------------- -- -- Table structure for table `gibbonPersonalDocument` -- CREATE TABLE `gibbonPersonalDocument` ( `gibbonPersonalDocumentID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPersonalDocumentTypeID` int(3) unsigned zerofill NOT NULL, `foreignTable` varchar(60) NOT NULL, `foreignTableID` int(12) unsigned zerofill NOT NULL, `document` enum('Passport','ID Card','Visa','Document') NOT NULL DEFAULT 'Document', `documentNumber` varchar(120) DEFAULT NULL, `documentName` varchar(120) DEFAULT NULL, `documentType` varchar(60) DEFAULT NULL, `dateIssue` date DEFAULT NULL, `dateExpiry` date DEFAULT NULL, `filePath` varchar(255) DEFAULT NULL, `country` varchar(60) DEFAULT NULL, `gibbonPersonIDUpdater` int(10) unsigned zerofill DEFAULT NULL, `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`gibbonPersonalDocumentID`), UNIQUE KEY `foreignTableID` (`gibbonPersonalDocumentTypeID`,`foreignTable`,`foreignTableID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonPersonalDocumentType` -- CREATE TABLE `gibbonPersonalDocumentType` ( `gibbonPersonalDocumentTypeID` int(3) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(60) NOT NULL, `description` varchar(255) NOT NULL, `active` enum('Y','N') NOT NULL DEFAULT 'Y', `type` enum('Core','Additional') NOT NULL DEFAULT 'Additional', `document` enum('Passport','ID Card','Visa','Document') NOT NULL DEFAULT 'Document', `fields` text, `required` enum('Y','N') NOT NULL DEFAULT 'Y', `sequenceNumber` int NOT NULL DEFAULT '0', `activePersonStudent` tinyint(1) NOT NULL DEFAULT '0', `activePersonStaff` tinyint(1) NOT NULL DEFAULT '0', `activePersonParent` tinyint(1) NOT NULL DEFAULT '0', `activePersonOther` tinyint(1) NOT NULL DEFAULT '0', `activeApplicationForm` tinyint(1) NOT NULL DEFAULT '0', `activeDataUpdater` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`gibbonPersonalDocumentTypeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=6 ; -- -- Dumping data for table `gibbonPersonalDocumentType` -- INSERT INTO `gibbonPersonalDocumentType` VALUES (001, 'Primary Passport', '', 'Y', 'Core', 'Passport', '["documentName","documentNumber","country","dateIssue","dateExpiry","filePath"]', 'N', 1, 1, 1, 0, 0, 1, 1), (002, 'Additional Passport', '', 'Y', 'Core', 'Passport', '["documentName","documentNumber","country","dateIssue","dateExpiry","filePath"]', 'N', 2, 1, 1, 0, 0, 0, 1), (003, 'ID Card', '', 'Y', 'Core', 'ID Card', '["documentNumber","filePath"]', 'N', 3, 1, 1, 1, 1, 1, 1), (004, 'Residency/Visa', '', 'Y', 'Core', 'Visa', '["documentType","dateExpiry"]', 'N', 4, 1, 1, 1, 1, 0, 1), (005, 'Birth Certificate', '', 'Y', 'Core', 'Document', '["country","filePath"]', 'N', 5, 1, 1, 1, 1, 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `gibbonPersonMedical` -- CREATE TABLE `gibbonPersonMedical` ( `gibbonPersonMedicalID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `longTermMedication` enum('','Y','N') NOT NULL DEFAULT 'N', `longTermMedicationDetails` text NOT NULL, `comment` text NOT NULL, `fields` text, PRIMARY KEY (`gibbonPersonMedicalID`), KEY `gibbonPersonID` (`gibbonPersonID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonPersonMedicalCondition` -- CREATE TABLE `gibbonPersonMedicalCondition` ( `gibbonPersonMedicalConditionID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPersonMedicalID` int(10) unsigned zerofill NOT NULL, `name` varchar(100) NOT NULL, `gibbonAlertLevelID` int(3) unsigned zerofill DEFAULT NULL, `triggers` varchar(255) NOT NULL, `reaction` varchar(255) NOT NULL, `response` varchar(255) NOT NULL, `medication` varchar(255) NOT NULL, `lastEpisode` date DEFAULT NULL, `lastEpisodeTreatment` varchar(255) NOT NULL, `comment` text NOT NULL, `attachment` varchar(255) DEFAULT NULL, PRIMARY KEY (`gibbonPersonMedicalConditionID`), KEY `gibbonPersonMedicalID` (`gibbonPersonMedicalID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonPersonMedicalConditionUpdate` -- CREATE TABLE `gibbonPersonMedicalConditionUpdate` ( `gibbonPersonMedicalConditionUpdateID` int(14) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPersonMedicalUpdateID` int(12) unsigned zerofill DEFAULT NULL, `gibbonPersonMedicalConditionID` int(12) unsigned zerofill DEFAULT NULL, `gibbonPersonMedicalID` int(10) unsigned zerofill DEFAULT NULL, `name` varchar(80) NOT NULL, `gibbonAlertLevelID` int(3) unsigned zerofill DEFAULT NULL, `triggers` varchar(255) NOT NULL, `reaction` varchar(255) NOT NULL, `response` varchar(255) NOT NULL, `medication` varchar(255) NOT NULL, `lastEpisode` date DEFAULT NULL, `lastEpisodeTreatment` varchar(255) NOT NULL, `comment` text NOT NULL, `attachment` varchar(255) DEFAULT NULL, `gibbonPersonIDUpdater` int(10) unsigned zerofill NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`gibbonPersonMedicalConditionUpdateID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonPersonMedicalUpdate` -- CREATE TABLE `gibbonPersonMedicalUpdate` ( `gibbonPersonMedicalUpdateID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonSchoolYearID` int(3) unsigned zerofill DEFAULT NULL, `status` enum('Pending','Complete') NOT NULL DEFAULT 'Pending', `gibbonPersonMedicalID` int(10) unsigned zerofill DEFAULT NULL, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `longTermMedication` enum('','Y','N') NOT NULL, `longTermMedicationDetails` text NOT NULL, `comment` text NOT NULL, `gibbonPersonIDUpdater` int(10) unsigned zerofill NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `fields` text, PRIMARY KEY (`gibbonPersonMedicalUpdateID`), KEY `gibbonMedicalIndex` (`gibbonPersonID`,`gibbonPersonMedicalID`,`gibbonSchoolYearID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonPersonPhoto` -- CREATE TABLE `gibbonPersonPhoto` ( `gibbonPersonPhotoID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonSchoolYearID` int(3) unsigned zerofill NOT NULL, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `personImage` varchar(255) NOT NULL, `gibbonPersonIDCreated` int DEFAULT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`gibbonPersonPhotoID`), UNIQUE KEY `gibbonPersonID` (`gibbonPersonID`,`gibbonSchoolYearID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonPersonReset` -- CREATE TABLE `gibbonPersonReset` ( `gibbonPersonResetID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `key` varchar(40) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`gibbonPersonResetID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonPersonStatusLog` -- CREATE TABLE `gibbonPersonStatusLog` ( `gibbonPersonStatusLogID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `statusOld` enum('Full','Expected','Left','Pending Approval') NOT NULL DEFAULT 'Full', `statusNew` enum('Full','Expected','Left','Pending Approval') NOT NULL DEFAULT 'Full', `reason` text NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `gibbonPersonIDModified` int(10) unsigned zerofill DEFAULT NULL, PRIMARY KEY (`gibbonPersonStatusLogID`), KEY `gibbonPersonID` (`gibbonPersonID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonPersonUpdate` -- CREATE TABLE `gibbonPersonUpdate` ( `gibbonPersonUpdateID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonSchoolYearID` int(3) unsigned zerofill DEFAULT NULL, `status` enum('Pending','Complete') NOT NULL DEFAULT 'Pending', `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `title` varchar(5) NOT NULL, `surname` varchar(60) NOT NULL DEFAULT '', `firstName` varchar(60) NOT NULL DEFAULT '', `preferredName` varchar(60) NOT NULL DEFAULT '', `officialName` varchar(150) NOT NULL, `nameInCharacters` varchar(60) NOT NULL, `dob` date DEFAULT NULL, `email` varchar(75) DEFAULT NULL, `emailAlternate` varchar(75) DEFAULT NULL, `address1` mediumtext NOT NULL, `address1District` varchar(255) NOT NULL, `address1Country` varchar(255) NOT NULL, `address2` mediumtext NOT NULL, `address2District` varchar(255) NOT NULL, `address2Country` varchar(255) NOT NULL, `phone1Type` enum('','Mobile','Home','Work','Fax','Pager','Other') NOT NULL DEFAULT '', `phone1CountryCode` varchar(7) NOT NULL, `phone1` varchar(20) NOT NULL, `phone3Type` enum('','Mobile','Home','Work','Fax','Pager','Other') NOT NULL DEFAULT '', `phone3CountryCode` varchar(7) NOT NULL, `phone3` varchar(20) NOT NULL, `phone2Type` enum('','Mobile','Home','Work','Fax','Pager','Other') NOT NULL DEFAULT '', `phone2CountryCode` varchar(7) NOT NULL, `phone2` varchar(20) NOT NULL, `phone4Type` enum('','Mobile','Home','Work','Fax','Pager','Other') NOT NULL DEFAULT '', `phone4CountryCode` varchar(7) NOT NULL, `phone4` varchar(20) NOT NULL, `languageFirst` varchar(30) NOT NULL, `languageSecond` varchar(30) NOT NULL, `languageThird` varchar(30) NOT NULL, `countryOfBirth` varchar(30) NOT NULL, `ethnicity` varchar(255) NOT NULL, `religion` varchar(30) NOT NULL, `profession` varchar(90) DEFAULT NULL, `employer` varchar(90) DEFAULT NULL, `jobTitle` varchar(90) DEFAULT NULL, `emergency1Name` varchar(90) DEFAULT NULL, `emergency1Number1` varchar(30) DEFAULT NULL, `emergency1Number2` varchar(30) DEFAULT NULL, `emergency1Relationship` varchar(30) DEFAULT NULL, `emergency2Name` varchar(90) DEFAULT NULL, `emergency2Number1` varchar(30) DEFAULT NULL, `emergency2Number2` varchar(30) DEFAULT NULL, `emergency2Relationship` varchar(30) DEFAULT NULL, `vehicleRegistration` varchar(20) NOT NULL, `gibbonPersonIDUpdater` int(10) unsigned zerofill NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `privacy` text, `fields` text NOT NULL COMMENT 'Serialised array of custom field values', PRIMARY KEY (`gibbonPersonUpdateID`), KEY `gibbonPersonIndex` (`gibbonPersonID`,`gibbonSchoolYearID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonPlannerEntry` -- CREATE TABLE `gibbonPlannerEntry` ( `gibbonPlannerEntryID` int(14) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonCourseClassID` int(8) unsigned zerofill NOT NULL, `gibbonUnitID` int(10) unsigned zerofill DEFAULT NULL, `date` date DEFAULT NULL, `timeStart` time DEFAULT NULL, `timeEnd` time DEFAULT NULL, `name` varchar(50) NOT NULL, `summary` varchar(255) NOT NULL, `description` mediumtext NOT NULL, `teachersNotes` mediumtext NOT NULL, `homework` enum('N','Y') NOT NULL DEFAULT 'N', `homeworkDueDateTime` datetime DEFAULT NULL, `homeworkDetails` mediumtext NOT NULL, `homeworkTimeCap` int DEFAULT NULL, `homeworkLocation` enum('Out of Class','In Class') DEFAULT NULL, `homeworkSubmission` enum('N','Y') NOT NULL, `homeworkSubmissionDateOpen` date DEFAULT NULL, `homeworkSubmissionDrafts` varchar(1) DEFAULT NULL, `homeworkSubmissionType` enum('','Link','File','Link/File') NOT NULL, `homeworkSubmissionRequired` enum('Optional','Required') DEFAULT NULL, `homeworkCrowdAssess` enum('N','Y') NOT NULL, `homeworkCrowdAssessOtherTeachersRead` enum('N','Y') NOT NULL, `homeworkCrowdAssessOtherParentsRead` enum('N','Y') NOT NULL, `homeworkCrowdAssessClassmatesParentsRead` enum('N','Y') NOT NULL, `homeworkCrowdAssessSubmitterParentsRead` enum('N','Y') NOT NULL, `homeworkCrowdAssessOtherStudentsRead` enum('N','Y') NOT NULL, `homeworkCrowdAssessClassmatesRead` enum('N','Y') NOT NULL, `viewableStudents` enum('Y','N') NOT NULL DEFAULT 'Y', `viewableParents` enum('Y','N') NOT NULL DEFAULT 'N', `gibbonPersonIDCreator` int(10) unsigned zerofill NOT NULL, `gibbonPersonIDLastEdit` int(10) unsigned zerofill NOT NULL, `fields` text, PRIMARY KEY (`gibbonPlannerEntryID`), KEY `gibbonCourseClassID` (`gibbonCourseClassID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonPlannerEntryDiscuss` -- CREATE TABLE `gibbonPlannerEntryDiscuss` ( `gibbonPlannerEntryDiscussID` int(16) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPlannerEntryID` int(14) unsigned zerofill NOT NULL, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `comment` text NOT NULL, `gibbonPlannerEntryDiscussIDReplyTo` int(16) unsigned zerofill DEFAULT NULL, PRIMARY KEY (`gibbonPlannerEntryDiscussID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonPlannerEntryGuest` -- CREATE TABLE `gibbonPlannerEntryGuest` ( `gibbonPlannerEntryGuestID` int(16) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPlannerEntryID` int(14) unsigned zerofill NOT NULL, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `role` enum('Guest Student','Guest Teacher','Guest Assistant','Guest Technician','Guest Parent','Other Guest') NOT NULL, PRIMARY KEY (`gibbonPlannerEntryGuestID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonPlannerEntryHomework` -- CREATE TABLE `gibbonPlannerEntryHomework` ( `gibbonPlannerEntryHomeworkID` int(16) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPlannerEntryID` int(14) unsigned zerofill NOT NULL, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `type` enum('Link','File') NOT NULL, `version` enum('Draft','Final') NOT NULL, `status` enum('On Time','Late','Exemption') NOT NULL, `location` varchar(255) DEFAULT NULL, `count` int NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`gibbonPlannerEntryHomeworkID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonPlannerEntryOutcome` -- CREATE TABLE `gibbonPlannerEntryOutcome` ( `gibbonPlannerEntryOutcomeID` int(16) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPlannerEntryID` int(14) unsigned zerofill NOT NULL, `gibbonOutcomeID` int(8) unsigned zerofill NOT NULL, `sequenceNumber` int NOT NULL, `content` text NOT NULL, PRIMARY KEY (`gibbonPlannerEntryOutcomeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonPlannerEntryStudentHomework` -- CREATE TABLE `gibbonPlannerEntryStudentHomework` ( `gibbonPlannerEntryStudentHomeworkID` int(14) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPlannerEntryID` int(14) unsigned zerofill NOT NULL, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `homeworkDueDateTime` datetime NOT NULL, `homeworkDetails` mediumtext NOT NULL, `homeworkComplete` enum('Y','N') NOT NULL DEFAULT 'N', PRIMARY KEY (`gibbonPlannerEntryStudentHomeworkID`), KEY `gibbonPlannerEntryID` (`gibbonPlannerEntryID`,`gibbonPersonID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Allows students to add homework deadlines themselves' AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonPlannerEntryStudentTracker` -- CREATE TABLE `gibbonPlannerEntryStudentTracker` ( `gibbonPlannerEntryStudentTrackerID` int(16) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonPlannerEntryID` int(14) unsigned zerofill NOT NULL, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `homeworkComplete` enum('Y','N') NOT NULL, PRIMARY KEY (`gibbonPlannerEntryStudentTrackerID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonPlannerParentWeeklyEmailSummary` -- CREATE TABLE `gibbonPlannerParentWeeklyEmailSummary` ( `gibbonPlannerParentWeeklyEmailSummaryID` int(14) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonSchoolYearID` int(3) unsigned zerofill NOT NULL, `gibbonPersonIDParent` int(10) unsigned zerofill NOT NULL, `gibbonPersonIDStudent` int(10) unsigned zerofill NOT NULL, `weekOfYear` int NOT NULL, `key` varchar(40) NOT NULL, `confirmed` enum('N','Y') NOT NULL DEFAULT 'N', PRIMARY KEY (`gibbonPlannerParentWeeklyEmailSummaryID`), UNIQUE KEY `key` (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonReport` -- CREATE TABLE `gibbonReport` ( `gibbonReportID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonReportArchiveID` int(5) unsigned zerofill DEFAULT NULL, `gibbonReportTemplateID` int(10) unsigned zerofill DEFAULT NULL, `gibbonSchoolYearID` int(3) unsigned zerofill DEFAULT NULL, `name` varchar(90) DEFAULT NULL, `active` enum('Y','N') NOT NULL DEFAULT 'Y', `status` enum('None','Draft','Published') NOT NULL DEFAULT 'None', `gibbonReportingCycleID` int(10) unsigned zerofill DEFAULT NULL, `gibbonYearGroupIDList` varchar(255) DEFAULT NULL, `queryBuilderQueryID` int(10) unsigned zerofill DEFAULT NULL, `accessDate` datetime DEFAULT NULL, `timestampModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `timestampGenerated` timestamp NULL DEFAULT NULL, PRIMARY KEY (`gibbonReportID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonReportArchive` -- CREATE TABLE `gibbonReportArchive` ( `gibbonReportArchiveID` int(5) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(90) DEFAULT NULL, `path` varchar(255) DEFAULT NULL, `readonly` enum('Y','N') NOT NULL DEFAULT 'N', `viewableStaff` enum('Y','N') NOT NULL DEFAULT 'N', `viewableStudents` enum('Y','N') NOT NULL DEFAULT 'N', `viewableParents` enum('Y','N') NOT NULL DEFAULT 'N', `viewableOther` enum('Y','N') NOT NULL DEFAULT 'N', PRIMARY KEY (`gibbonReportArchiveID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=2 ; -- -- Dumping data for table `gibbonReportArchive` -- INSERT INTO `gibbonReportArchive` VALUES (00001, 'Default Archive', '/uploads/reports', 'N', 'Y', 'N', 'N', 'N'); -- -------------------------------------------------------- -- -- Table structure for table `gibbonReportArchiveEntry` -- CREATE TABLE `gibbonReportArchiveEntry` ( `gibbonReportArchiveEntryID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonReportArchiveID` int(5) unsigned zerofill DEFAULT NULL, `gibbonReportID` int(10) unsigned zerofill DEFAULT NULL, `gibbonSchoolYearID` int(3) unsigned zerofill DEFAULT NULL, `gibbonYearGroupID` int(3) unsigned zerofill DEFAULT NULL, `gibbonFormGroupID` int(5) unsigned zerofill DEFAULT NULL, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `type` enum('Single','Batch') NOT NULL DEFAULT 'Single', `status` enum('Draft','Final') NOT NULL DEFAULT 'Draft', `reportIdentifier` varchar(255) DEFAULT NULL, `filePath` varchar(255) DEFAULT NULL, `timestampCreated` timestamp NULL DEFAULT NULL, `timestampModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `timestampSent` timestamp NULL DEFAULT NULL, `gibbonPersonIDAccessed` int(10) unsigned zerofill DEFAULT NULL, `timestampAccessed` timestamp NULL DEFAULT NULL, `timestampAccessExpiry` timestamp NULL DEFAULT NULL, `accessToken` varchar(60) DEFAULT NULL, PRIMARY KEY (`gibbonReportArchiveEntryID`), UNIQUE KEY `archiveEntry` (`gibbonReportArchiveID`,`gibbonSchoolYearID`,`reportIdentifier`,`type`,`gibbonYearGroupID`,`gibbonPersonID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonReportingAccess` -- CREATE TABLE `gibbonReportingAccess` ( `gibbonReportingAccessID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonReportingCycleID` int(10) unsigned zerofill DEFAULT NULL, `gibbonReportingScopeIDList` varchar(255) DEFAULT NULL, `gibbonRoleIDList` varchar(255) DEFAULT NULL, `gibbonPersonIDList` varchar(255) DEFAULT NULL, `accessType` enum('Role','Person') NOT NULL DEFAULT 'Role', `dateStart` date DEFAULT NULL, `dateEnd` date DEFAULT NULL, `canWrite` enum('Y','N') NOT NULL DEFAULT 'N', `canProofRead` enum('Y','N') NOT NULL DEFAULT 'N', PRIMARY KEY (`gibbonReportingAccessID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonReportingCriteria` -- CREATE TABLE `gibbonReportingCriteria` ( `gibbonReportingCriteriaID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonReportingCycleID` int(10) unsigned zerofill DEFAULT NULL, `gibbonReportingScopeID` int(10) unsigned zerofill DEFAULT NULL, `gibbonReportingCriteriaTypeID` int(10) unsigned zerofill DEFAULT NULL, `gibbonYearGroupID` int(3) unsigned zerofill DEFAULT NULL, `gibbonFormGroupID` int(5) unsigned zerofill DEFAULT NULL, `gibbonCourseID` int(8) unsigned zerofill DEFAULT NULL, `target` enum('Per Student','Per Group') NOT NULL DEFAULT 'Per Student', `name` varchar(255) DEFAULT NULL, `description` text, `category` varchar(255) DEFAULT NULL, `gibbonScaleID` int(5) unsigned zerofill DEFAULT NULL, `sequenceNumber` int DEFAULT NULL, `groupID` varchar(255) DEFAULT NULL, PRIMARY KEY (`gibbonReportingCriteriaID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonReportingCriteriaType` -- CREATE TABLE `gibbonReportingCriteriaType` ( `gibbonReportingCriteriaTypeID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(90) DEFAULT NULL, `valueType` varchar(30) DEFAULT NULL, `defaultValue` varchar(255) DEFAULT NULL, `active` enum('Y','N') NOT NULL DEFAULT 'Y', `characterLimit` int DEFAULT NULL, `gibbonScaleID` int(5) unsigned zerofill DEFAULT NULL, `options` text, PRIMARY KEY (`gibbonReportingCriteriaTypeID`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=3 ; -- -- Dumping data for table `gibbonReportingCriteriaType` -- INSERT INTO `gibbonReportingCriteriaType` VALUES (0000000001, 'Comment, Short', 'Comment', NULL, 'Y', 500, NULL, NULL), (0000000002, 'Comment, Long', 'Comment', NULL, 'Y', 1000, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `gibbonReportingCycle` -- CREATE TABLE `gibbonReportingCycle` ( `gibbonReportingCycleID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonSchoolYearID` int(3) unsigned zerofill DEFAULT NULL, `gibbonYearGroupIDList` varchar(255) DEFAULT NULL, `name` varchar(90) DEFAULT NULL, `nameShort` varchar(20) DEFAULT NULL, `sequenceNumber` int DEFAULT NULL, `cycleNumber` int DEFAULT NULL, `cycleTotal` int DEFAULT NULL, `dateStart` date DEFAULT NULL, `dateEnd` date DEFAULT NULL, `milestones` text, `notes` text, PRIMARY KEY (`gibbonReportingCycleID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonReportingProgress` -- CREATE TABLE `gibbonReportingProgress` ( `gibbonReportingProgressID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonReportingScopeID` int(10) unsigned zerofill DEFAULT NULL, `gibbonYearGroupID` int(3) unsigned zerofill DEFAULT NULL, `gibbonFormGroupID` int(5) unsigned zerofill DEFAULT NULL, `gibbonCourseClassID` int(8) unsigned zerofill NOT NULL, `gibbonPersonIDStudent` int(10) unsigned zerofill NOT NULL, `status` enum('In Progress','Complete') NOT NULL DEFAULT 'In Progress', PRIMARY KEY (`gibbonReportingProgressID`), UNIQUE KEY `gibbonReportingScopeID` (`gibbonReportingScopeID`,`gibbonCourseClassID`,`gibbonPersonIDStudent`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonReportingProof` -- CREATE TABLE `gibbonReportingProof` ( `gibbonReportingProofID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonReportingValueID` int(12) unsigned zerofill DEFAULT NULL, `status` enum('Done','Edited','Accepted','Declined') NOT NULL DEFAULT 'Done', `reason` varchar(255) DEFAULT NULL, `comment` text, `gibbonPersonIDProofed` int(10) unsigned zerofill DEFAULT NULL, `timestampProofed` timestamp NULL DEFAULT NULL, `gibbonPersonIDActioned` int(10) unsigned zerofill DEFAULT NULL, `timestampActioned` timestamp NULL DEFAULT NULL, PRIMARY KEY (`gibbonReportingProofID`), UNIQUE KEY `gibbonReportingValueID` (`gibbonReportingValueID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonReportingScope` -- CREATE TABLE `gibbonReportingScope` ( `gibbonReportingScopeID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonReportingCycleID` int(10) unsigned zerofill DEFAULT NULL, `scopeType` enum('Year Group','Form Group','Course') NOT NULL DEFAULT 'Year Group', `name` varchar(90) DEFAULT NULL, `sequenceNumber` int DEFAULT NULL, PRIMARY KEY (`gibbonReportingScopeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonReportingValue` -- CREATE TABLE `gibbonReportingValue` ( `gibbonReportingValueID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonReportingCycleID` int(10) unsigned zerofill DEFAULT NULL, `gibbonReportingCriteriaID` int(12) unsigned zerofill DEFAULT NULL, `gibbonSchoolYearID` int(3) unsigned zerofill DEFAULT NULL, `gibbonCourseClassID` int(8) unsigned zerofill NOT NULL, `gibbonPersonIDStudent` int(10) unsigned zerofill NOT NULL, `gibbonScaleGradeID` int(7) unsigned zerofill DEFAULT NULL, `value` varchar(255) DEFAULT NULL, `comment` text, `gibbonPersonIDCreated` int(10) unsigned zerofill DEFAULT NULL, `timestampCreated` timestamp NULL DEFAULT NULL, `gibbonPersonIDModified` int(10) unsigned zerofill DEFAULT NULL, `timestampModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`gibbonReportingValueID`), UNIQUE KEY `gibbonReportingCriteriaID` USING BTREE (`gibbonReportingCriteriaID`,`gibbonPersonIDStudent`,`gibbonCourseClassID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonReportPrototypeSection` -- CREATE TABLE `gibbonReportPrototypeSection` ( `gibbonReportPrototypeSectionID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(90) DEFAULT NULL, `type` enum('Core','Additional') NOT NULL DEFAULT 'Additional', `category` varchar(90) DEFAULT NULL, `active` enum('Y','N') NOT NULL DEFAULT 'Y', `types` varchar(60) DEFAULT NULL, `config` text, `templateParams` text, `templateFile` varchar(255) DEFAULT NULL, `dataSources` text, `icon` varchar(120) DEFAULT NULL, `fonts` varchar(255) DEFAULT NULL, `gibbonPersonIDLastEdit` int(10) unsigned zerofill DEFAULT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`gibbonReportPrototypeSectionID`), UNIQUE KEY `type` (`type`,`templateFile`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonReportTemplate` -- CREATE TABLE `gibbonReportTemplate` ( `gibbonReportTemplateID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `context` enum('Student Enrolment','Reporting Cycle','Custom Query') NOT NULL DEFAULT 'Student Enrolment', `name` varchar(90) DEFAULT NULL, `active` enum('Y','N') NOT NULL DEFAULT 'Y', `orientation` char(1) NOT NULL DEFAULT 'P', `pageSize` varchar(20) NOT NULL DEFAULT 'A4', `marginX` decimal(4,2) NOT NULL DEFAULT '10.00', `marginY` decimal(4,2) NOT NULL DEFAULT '10.00', `flags` int(10) unsigned zerofill DEFAULT NULL, `config` text, `stylesheet` varchar(120) DEFAULT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`gibbonReportTemplateID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonReportTemplateFont` -- CREATE TABLE `gibbonReportTemplateFont` ( `gibbonReportTemplateFontID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `fontName` varchar(90) NOT NULL, `fontTCPDF` varchar(90) DEFAULT NULL, `fontPath` text, `fontType` enum('R','B','I','BI') NOT NULL DEFAULT 'R', `fontFamily` varchar(60) DEFAULT NULL, PRIMARY KEY (`gibbonReportTemplateFontID`), UNIQUE KEY `fontTCPDF` (`fontTCPDF`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonReportTemplateSection` -- CREATE TABLE `gibbonReportTemplateSection` ( `gibbonReportTemplateSectionID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonReportTemplateID` int(10) unsigned zerofill DEFAULT NULL, `gibbonReportPrototypeSectionID` int(10) unsigned zerofill DEFAULT NULL, `name` varchar(90) DEFAULT NULL, `type` enum('Body','Header','Footer') NOT NULL DEFAULT 'Body', `flags` int(10) unsigned zerofill DEFAULT NULL, `page` int NOT NULL DEFAULT '0', `config` text, `sequenceNumber` int unsigned DEFAULT NULL, `templateParams` text, `templateContent` text, PRIMARY KEY (`gibbonReportTemplateSectionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonResource` -- CREATE TABLE `gibbonResource` ( `gibbonResourceID` int(14) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(60) NOT NULL, `description` text NOT NULL, `gibbonYearGroupIDList` varchar(255) NOT NULL, `type` enum('File','HTML','Link') NOT NULL, `category` varchar(255) NOT NULL, `purpose` varchar(255) NOT NULL, `tags` text NOT NULL, `content` text NOT NULL, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `timestamp` timestamp NULL DEFAULT NULL, PRIMARY KEY (`gibbonResourceID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonResourceTag` -- CREATE TABLE `gibbonResourceTag` ( `gibbonResourceTagID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT, `tag` varchar(100) NOT NULL, `count` int NOT NULL, PRIMARY KEY (`gibbonResourceTagID`), UNIQUE KEY `tag` (`tag`), KEY `tag_2` (`tag`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonRole` -- CREATE TABLE `gibbonRole` ( `gibbonRoleID` int(3) unsigned zerofill NOT NULL AUTO_INCREMENT, `category` enum('Staff','Student','Parent','Other') NOT NULL DEFAULT 'Staff', `name` varchar(20) NOT NULL, `nameShort` varchar(4) NOT NULL, `description` varchar(60) NOT NULL, `type` enum('Core','Additional') NOT NULL DEFAULT 'Core', `canLoginRole` enum('Y','N') NOT NULL DEFAULT 'Y', `futureYearsLogin` enum('Y','N') NOT NULL DEFAULT 'Y', `pastYearsLogin` enum('Y','N') NOT NULL DEFAULT 'Y', `restriction` enum('None','Same Role','Admin Only') NOT NULL DEFAULT 'None', PRIMARY KEY (`gibbonRoleID`), UNIQUE KEY `name` (`name`), UNIQUE KEY `nameShort` (`nameShort`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=7 ; -- -- Dumping data for table `gibbonRole` -- INSERT INTO `gibbonRole` VALUES (001, 'Staff', 'Administrator', 'Adm', 'Controls all aspects of the system', 'Core', 'Y', 'Y', 'Y', 'Admin Only'), (002, 'Staff', 'Teacher', 'Tcr', 'Regular, classroom teacher', 'Core', 'Y', 'Y', 'Y', 'None'), (003, 'Student', 'Student', 'Std', 'Person studying in the school', 'Core', 'Y', 'Y', 'Y', 'None'), (004, 'Parent', 'Parent', 'Prt', 'Parent or guardian of person studying in', 'Core', 'Y', 'Y', 'Y', 'None'), (006, 'Staff', 'Support Staff', 'SSt', 'Staff who support teaching and learning', 'Core', 'Y', 'Y', 'Y', 'None'); -- -------------------------------------------------------- -- -- Table structure for table `gibbonRubric` -- CREATE TABLE `gibbonRubric` ( `gibbonRubricID` int(8) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `category` varchar(50) NOT NULL, `description` text NOT NULL, `active` enum('Y','N') NOT NULL, `scope` enum('School','Learning Area') NOT NULL, `gibbonDepartmentID` int(4) unsigned zerofill DEFAULT NULL, `gibbonYearGroupIDList` varchar(255) NOT NULL, `gibbonScaleID` int(5) unsigned zerofill DEFAULT NULL, `gibbonPersonIDCreator` int(10) unsigned zerofill NOT NULL, PRIMARY KEY (`gibbonRubricID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonRubricCell` -- CREATE TABLE `gibbonRubricCell` ( `gibbonRubricCellID` int(11) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonRubricID` int(8) unsigned zerofill NOT NULL, `gibbonRubricColumnID` int(9) unsigned zerofill NOT NULL, `gibbonRubricRowID` int(9) unsigned zerofill NOT NULL, `contents` text NOT NULL, PRIMARY KEY (`gibbonRubricCellID`), KEY `gibbonRubricID` (`gibbonRubricID`), KEY `gibbonRubricColumnID` (`gibbonRubricColumnID`), KEY `gibbonRubricRowID` (`gibbonRubricRowID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonRubricColumn` -- CREATE TABLE `gibbonRubricColumn` ( `gibbonRubricColumnID` int(9) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonRubricID` int(8) unsigned zerofill NOT NULL, `title` varchar(20) NOT NULL, `backgroundColor` varchar(7) DEFAULT NULL, `sequenceNumber` int NOT NULL, `gibbonScaleGradeID` int(7) unsigned zerofill DEFAULT NULL, `visualise` enum('Y','N') NOT NULL DEFAULT 'Y', PRIMARY KEY (`gibbonRubricColumnID`), KEY `gibbonRubricID` (`gibbonRubricID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonRubricEntry` -- CREATE TABLE `gibbonRubricEntry` ( `gibbonRubricEntry` int(14) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonRubricID` int(8) unsigned zerofill NOT NULL, `gibbonPersonID` int(10) unsigned zerofill NOT NULL, `gibbonRubricCellID` int(11) unsigned zerofill NOT NULL, `contextDBTable` varchar(255) NOT NULL COMMENT 'Which database table is this entry related to?', `contextDBTableID` int(20) unsigned zerofill NOT NULL, PRIMARY KEY (`gibbonRubricEntry`), KEY `gibbonRubricID` (`gibbonRubricID`), KEY `gibbonPersonID` (`gibbonPersonID`), KEY `gibbonRubricCellID` (`gibbonRubricCellID`), KEY `contextDBTable` (`contextDBTable`), KEY `contextDBTableID` (`contextDBTableID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonRubricRow` -- CREATE TABLE `gibbonRubricRow` ( `gibbonRubricRowID` int(9) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonRubricID` int(8) unsigned zerofill NOT NULL, `title` varchar(40) NOT NULL, `backgroundColor` varchar(7) DEFAULT NULL, `sequenceNumber` int NOT NULL, `gibbonOutcomeID` int(8) unsigned zerofill DEFAULT NULL, PRIMARY KEY (`gibbonRubricRowID`), KEY `gibbonRubricID` (`gibbonRubricID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonScale` -- CREATE TABLE `gibbonScale` ( `gibbonScaleID` int(5) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(40) NOT NULL, `nameShort` varchar(5) NOT NULL, `usage` varchar(50) NOT NULL, `lowestAcceptable` varchar(5) DEFAULT NULL COMMENT 'This is the sequence number of the lowest grade a student can get without being unsatisfactory', `active` enum('Y','N') NOT NULL DEFAULT 'Y', `numeric` enum('N','Y') NOT NULL DEFAULT 'N', PRIMARY KEY (`gibbonScaleID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=16 ; -- -- Dumping data for table `gibbonScale` -- INSERT INTO `gibbonScale` VALUES (00001, 'International Baccalaureate', 'IB', '7 (highest) to 1 (lowest)', '', 'N', 'Y'), (00002, 'International Baccalaureate EE', 'IBEE', 'A (highest) to E (lowest)', '', 'N', 'N'), (00003, 'United Kingdom GCSE/iGCSE', 'GCSE', 'A* (highest) to U (lowest)', '', 'Y', 'N'), (00004, 'Percentage', '%', '100 (highest) to 0 (lowest)', '51', 'Y', 'Y'), (00005, 'Full Letter Grade', 'FLG', 'A+ (highest) to F (lowest)', '', 'N', 'N'), (00006, 'Simple Letter Grade', 'SLG', 'A (highest) to F (lowest)', '', 'N', 'N'), (00007, 'International College HK', 'ICHK', '7 (highest) to 1 (lowest)', '4', 'Y', 'Y'), (00009, 'Completion', 'Comp', 'Has task has been completed?', '1', 'Y', 'N'), (00010, 'Cognitive Abilities Test', 'CAT', '140 (highest) to 60 (lowest)', '70', 'Y', 'Y'), (00011, 'UK National Curriculum KS3', 'KS3', '8A (highest) to B3 (lowest)', '14', 'Y', 'N'), (00012, 'United Kingdom GCSE/iGCSE Predicted', 'GPrd', '8A (highest) to B3 (lowest)', '', 'Y', 'N'), (00013, 'IB Diploma (Subject)', 'IBDS', '7 (highest) to 1 (lowest)', '4', 'Y', 'Y'), (00014, 'IB Diploma (Total)', 'IBDT', '45 (highest) to 0', '22', 'Y', 'Y'), (00015, 'UK National Curriculum KS3 Simplified', 'KS3S', 'Level 8 (highest) to Level 3 (lowest)', '4', 'Y', 'N'); -- -------------------------------------------------------- -- -- Table structure for table `gibbonScaleGrade` -- CREATE TABLE `gibbonScaleGrade` ( `gibbonScaleGradeID` int(7) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonScaleID` int(5) unsigned zerofill NOT NULL, `value` varchar(10) NOT NULL, `descriptor` varchar(50) NOT NULL, `sequenceNumber` int NOT NULL, `isDefault` enum('N','Y') NOT NULL DEFAULT 'N', PRIMARY KEY (`gibbonScaleGradeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=331 ; -- -- Dumping data for table `gibbonScaleGrade` -- INSERT INTO `gibbonScaleGrade` VALUES (0000001, 00001, '7', '7', 1, 'N'), (0000002, 00001, '6', '6', 2, 'N'), (0000003, 00001, '5', '5', 3, 'N'), (0000004, 00001, '4', '4', 4, 'N'), (0000005, 00001, '3', '3', 5, 'N'), (0000006, 00001, '2', '2', 6, 'N'), (0000007, 00001, '1', '1', 7, 'N'), (0000008, 00002, 'A', '49–60', 1, 'N'), (0000009, 00002, 'B', '40–48', 2, 'N'), (0000010, 00002, 'C', '32–39', 3, 'N'), (0000011, 00002, 'D', '22–31', 4, 'N'), (0000012, 00002, 'E', '0–21', 5, 'N'), (0000013, 00003, 'A*', 'A*', 1, 'N'), (0000014, 00003, 'A', 'A', 2, 'N'), (0000015, 00003, 'B', 'B', 3, 'N'), (0000016, 00003, 'C', 'C', 4, 'N'), (0000017, 00003, 'D', 'D', 5, 'N'), (0000018, 00003, 'E', 'E', 6, 'N'), (0000019, 00003, 'F', 'F', 7, 'N'), (0000020, 00003, 'G', 'G', 8, 'N'), (0000021, 00003, 'U', 'Unclassified', 9, 'N'), (0000022, 00004, '100%', '100%', 1, 'N'), (0000023, 00004, '99%', '99%', 2, 'N'), (0000024, 00004, '98%', '98%', 3, 'N'), (0000025, 00004, '97%', '97%', 4, 'N'), (0000026, 00004, '96%', '96%', 5, 'N'), (0000027, 00004, '95%', '95%', 6, 'N'), (0000028, 00004, '94%', '94%', 7, 'N'), (0000029, 00004, '93%', '93%', 8, 'N'), (0000030, 00004, '92%', '92%', 9, 'N'), (0000031, 00004, '91%', '91%', 10, 'N'), (0000032, 00004, '90%', '90%', 11, 'N'), (0000033, 00004, '89%', '89%', 12, 'N'), (0000034, 00004, '88%', '88%', 13, 'N'), (0000035, 00004, '87%', '87%', 14, 'N'), (0000036, 00004, '86%', '86%', 15, 'N'), (0000037, 00004, '85%', '85%', 16, 'N'), (0000038, 00004, '84%', '84%', 17, 'N'), (0000039, 00004, '83%', '83%', 18, 'N'), (0000040, 00004, '82%', '82%', 19, 'N'), (0000041, 00004, '81%', '81%', 20, 'N'), (0000042, 00004, '80%', '80%', 21, 'N'), (0000043, 00004, '79%', '79%', 22, 'N'), (0000044, 00004, '78%', '78%', 23, 'N'), (0000045, 00004, '77%', '77%', 24, 'N'), (0000046, 00004, '76%', '76%', 25, 'N'), (0000047, 00004, '75%', '75%', 26, 'N'), (0000048, 00004, '74%', '74%', 27, 'N'), (0000049, 00004, '73%', '73%', 28, 'N'), (0000050, 00004, '72%', '72%', 29, 'N'), (0000051, 00004, '71%', '71%', 30, 'N'), (0000052, 00004, '70%', '70%', 31, 'N'), (0000053, 00004, '69%', '69%', 32, 'N'), (0000054, 00004, '68%', '68%', 33, 'N'), (0000055, 00004, '67%', '67%', 34, 'N'), (0000056, 00004, '66%', '66%', 35, 'N'), (0000057, 00004, '65%', '65%', 36, 'N'), (0000058, 00004, '64%', '64%', 37, 'N'), (0000059, 00004, '63%', '63%', 38, 'N'), (0000060, 00004, '62%', '62%', 39, 'N'), (0000061, 00004, '61%', '61%', 40, 'N'), (0000062, 00004, '60%', '60%', 41, 'N'), (0000063, 00004, '59%', '59%', 42, 'N'), (0000064, 00004, '58%', '58%', 43, 'N'), (0000065, 00004, '57%', '57%', 44, 'N'), (0000066, 00004, '56%', '56%', 45, 'N'), (0000067, 00004, '55%', '55%', 46, 'N'), (0000068, 00004, '54%', '54%', 47, 'N'), (0000069, 00004, '53%', '53%', 48, 'N'), (0000070, 00004, '52%', '52%', 49, 'N'), (0000071, 00004, '51%', '51%', 50, 'N'), (0000072, 00004, '50%', '50%', 51, 'N'), (0000073, 00004, '49%', '49%', 52, 'N'), (0000074, 00004, '48%', '48%', 53, 'N'), (0000075, 00004, '47%', '47%', 54, 'N'), (0000076, 00004, '46%', '46%', 55, 'N'), (0000077, 00004, '45%', '45%', 56, 'N'), (0000078, 00004, '44%', '44%', 57, 'N'), (0000079, 00004, '43%', '43%', 58, 'N'), (0000080, 00004, '42%', '42%', 59, 'N'), (0000081, 00004, '41%', '41%', 60, 'N'), (0000082, 00004, '40%', '40%', 61, 'N'), (0000083, 00004, '39%', '39%', 62, 'N'), (0000084, 00004, '38%', '38%', 63, 'N'), (0000085, 00004, '37%', '37%', 64, 'N'), (0000086, 00004, '36%', '36%', 65, 'N'), (0000087, 00004, '35%', '35%', 66, 'N'), (0000088, 00004, '34%', '34%', 67, 'N'), (0000089, 00004, '33%', '33%', 68, 'N'), (0000090, 00004, '32%', '32%', 69, 'N'), (0000091, 00004, '31%', '31%', 70, 'N'), (0000092, 00004, '30%', '30%', 71, 'N'), (0000093, 00004, '29%', '29%', 72, 'N'), (0000094, 00004, '28%', '28%', 73, 'N'), (0000095, 00004, '27%', '27%', 74, 'N'), (0000096, 00004, '26%', '26%', 75, 'N'), (0000097, 00004, '25%', '25%', 76, 'N'), (0000098, 00004, '24%', '24%', 77, 'N'), (0000099, 00004, '23%', '23%', 78, 'N'), (0000100, 00004, '22%', '22%', 79, 'N'), (0000101, 00004, '21%', '21%', 80, 'N'), (0000102, 00004, '20%', '20%', 81, 'N'), (0000103, 00004, '19%', '19%', 82, 'N'), (0000104, 00004, '18%', '18%', 83, 'N'), (0000105, 00004, '17%', '17%', 84, 'N'), (0000106, 00004, '16%', '16%', 85, 'N'), (0000107, 00004, '15%', '15%', 86, 'N'), (0000108, 00004, '14%', '14%', 87, 'N'), (0000109, 00004, '13%', '13%', 88, 'N'), (0000110, 00004, '12%', '12%', 89, 'N'), (0000111, 00004, '11%', '11%', 90, 'N'), (0000112, 00004, '10%', '10%', 91, 'N'), (0000113, 00004, '9%', '9%', 92, 'N'), (0000114, 00004, '8%', '8%', 93, 'N'), (0000115, 00004, '7%', '7%', 94, 'N'), (0000116, 00004, '6%', '6%', 95, 'N'), (0000117, 00004, '5%', '5%', 96, 'N'), (0000118, 00004, '4%', '4%', 97, 'N'), (0000119, 00004, '3%', '3%', 98, 'N'), (0000120, 00004, '2%', '2%', 99, 'N'), (0000121, 00004, '1%', '1%', 100, 'N'), (0000122, 00004, '0%', '0%', 101, 'N'), (0000123, 00005, 'A+', 'A+', 1, 'N'), (0000124, 00005, 'A', 'A', 2, 'N'), (0000125, 00005, 'A-', 'A-', 3, 'N'), (0000126, 00005, 'B+', 'B+', 4, 'N'), (0000127, 00005, 'B', 'B', 5, 'N'), (0000128, 00005, 'B-', 'B-', 6, 'N'), (0000129, 00005, 'C+', 'C+', 7, 'N'), (0000130, 00005, 'C', 'C', 8, 'N'), (0000131, 00005, 'C-', 'C-', 9, 'N'), (0000132, 00005, 'D+', 'D+', 10, 'N'), (0000133, 00005, 'D', 'D', 11, 'N'), (0000134, 00005, 'D-', 'D-', 12, 'N'), (0000135, 00005, 'E+', 'E+', 13, 'N'), (0000136, 00005, 'E', 'E', 14, 'N'), (0000137, 00005, 'E-', 'E-', 15, 'N'), (0000138, 00005, 'F', 'F', 16, 'N'), (0000139, 00006, 'A', 'A', 1, 'N'), (0000140, 00006, 'B', 'B', 2, 'N'), (0000141, 00006, 'C', 'C', 3, 'N'), (0000142, 00006, 'D', 'D', 4, 'N'), (0000143, 00006, 'E', 'E', 5, 'N'), (0000144, 00006, 'F', 'F', 6, 'N'), (0000145, 00007, '7', 'Exceptional Performance', 1, 'N'), (0000146, 00007, '6', 'Well Above Expected Level', 2, 'N'), (0000147, 00007, '5', 'Above Expected Level', 3, 'N'), (0000148, 00007, '4', 'At Expected Level', 4, 'N'), (0000149, 00007, '3', 'Below Expected Level', 5, 'N'), (0000150, 00007, '2', 'Well Below Expected Level', 6, 'N'), (0000151, 00007, '1', 'Cause For Concern', 7, 'N'), (0000152, 00009, 'Complete', 'Work complete', 1, 'N'), (0000153, 00009, 'Incomplete', 'Work incomplete', 3, 'N'), (0000154, 00009, 'Late', 'Work submitted late', 2, 'N'), (0000155, 00007, 'Incomplete', 'Work incomplete', 8, 'N'), (0000156, 00001, 'Incomplete', 'Work incomplete', 8, 'N'), (0000157, 00003, 'Incomplete', 'Work incomplete', 10, 'N'), (0000158, 00004, 'Incomplete', 'Work incomplete', 102, 'N'), (0000159, 00005, 'Incomplete', 'Work incomplete', 17, 'N'), (0000160, 00006, 'Incomplete', 'Work incomplete', 7, 'N'), (0000162, 00010, '60', '60', 110, 'N'), (0000163, 00010, '61', '61', 109, 'N'), (0000164, 00010, '62', '62', 108, 'N'), (0000165, 00010, '63', '63', 107, 'N'), (0000166, 00010, '64', '64', 106, 'N'), (0000167, 00010, '65', '65', 105, 'N'), (0000168, 00010, '66', '66', 104, 'N'), (0000169, 00010, '67', '67', 103, 'N'), (0000170, 00010, '68', '68', 102, 'N'), (0000171, 00010, '69', '69', 101, 'N'), (0000172, 00010, '70', '70', 100, 'N'), (0000173, 00010, '71', '71', 99, 'N'), (0000174, 00010, '72', '72', 98, 'N'), (0000175, 00010, '73', '73', 97, 'N'), (0000176, 00010, '74', '74', 96, 'N'), (0000177, 00010, '75', '75', 95, 'N'), (0000178, 00010, '76', '76', 94, 'N'), (0000179, 00010, '77', '77', 93, 'N'), (0000180, 00010, '78', '78', 92, 'N'), (0000181, 00010, '79', '79', 91, 'N'), (0000182, 00010, '80', '80', 90, 'N'), (0000183, 00010, '81', '81', 89, 'N'), (0000184, 00010, '82', '82', 88, 'N'), (0000185, 00010, '83', '83', 87, 'N'), (0000186, 00010, '84', '84', 86, 'N'), (0000187, 00010, '85', '85', 85, 'N'), (0000188, 00010, '86', '86', 84, 'N'), (0000189, 00010, '87', '87', 83, 'N'), (0000190, 00010, '88', '88', 82, 'N'), (0000191, 00010, '89', '89', 81, 'N'), (0000192, 00010, '90', '90', 80, 'N'), (0000193, 00010, '91', '91', 79, 'N'), (0000194, 00010, '92', '92', 78, 'N'), (0000195, 00010, '93', '93', 77, 'N'), (0000196, 00010, '94', '94', 76, 'N'), (0000197, 00010, '95', '95', 75, 'N'), (0000198, 00010, '96', '96', 74, 'N'), (0000199, 00010, '97', '97', 73, 'N'), (0000200, 00010, '98', '98', 72, 'N'), (0000201, 00010, '99', '99', 71, 'N'), (0000202, 00010, '100', '100', 70, 'N'), (0000203, 00010, '101', '101', 69, 'N'), (0000204, 00010, '102', '102', 68, 'N'), (0000205, 00010, '103', '103', 67, 'N'), (0000206, 00010, '104', '104', 66, 'N'), (0000207, 00010, '105', '105', 65, 'N'), (0000208, 00010, '106', '106', 64, 'N'), (0000209, 00010, '107', '107', 63, 'N'), (0000210, 00010, '108', '108', 62, 'N'), (0000211, 00010, '109', '109', 61, 'N'), (0000212, 00010, '110', '110', 60, 'N'), (0000213, 00010, '111', '111', 59, 'N'), (0000214, 00010, '112', '112', 58, 'N'), (0000215, 00010, '113', '113', 57, 'N'), (0000216, 00010, '114', '114', 56, 'N'), (0000217, 00010, '115', '115', 55, 'N'), (0000218, 00010, '116', '116', 54, 'N'), (0000219, 00010, '117', '117', 53, 'N'), (0000220, 00010, '118', '118', 52, 'N'), (0000221, 00010, '119', '119', 51, 'N'), (0000222, 00010, '120', '120', 50, 'N'), (0000223, 00010, '121', '121', 49, 'N'), (0000224, 00010, '122', '122', 48, 'N'), (0000225, 00010, '123', '123', 47, 'N'), (0000226, 00010, '124', '124', 46, 'N'), (0000227, 00010, '125', '125', 45, 'N'), (0000228, 00010, '126', '126', 44, 'N'), (0000229, 00010, '127', '127', 43, 'N'), (0000230, 00010, '128', '128', 42, 'N'), (0000231, 00010, '129', '129', 41, 'N'), (0000232, 00010, '130', '130', 40, 'N'), (0000233, 00010, '131', '131', 39, 'N'), (0000234, 00010, '132', '132', 38, 'N'), (0000235, 00010, '133', '133', 37, 'N'), (0000236, 00010, '134', '134', 36, 'N'), (0000237, 00010, '135', '135', 35, 'N'), (0000238, 00010, '136', '136', 34, 'N'), (0000239, 00010, '137', '137', 33, 'N'), (0000240, 00010, '138', '138', 32, 'N'), (0000241, 00010, '139', '139', 31, 'N'), (0000242, 00010, '140', '140', 30, 'N'), (0000243, 00011, '8A', '8A', 1, 'N'), (0000244, 00011, '8B', '8B', 2, 'N'), (0000245, 00011, '8C', '8C', 3, 'N'), (0000246, 00011, '7A', '7A', 4, 'N'), (0000247, 00011, '7B', '7B', 5, 'N'), (0000248, 00011, '7C', '7C', 6, 'N'), (0000249, 00011, '6A', '6A', 7, 'N'), (0000250, 00011, '6B', '6B', 8, 'N'), (0000251, 00011, '6C', '6C', 9, 'N'), (0000252, 00011, '5A', '5A', 9, 'N'), (0000253, 00011, '5B', '5B', 10, 'N'), (0000254, 00011, '5C', '5C', 11, 'N'), (0000255, 00011, '4A', '4A', 12, 'N'), (0000256, 00011, '4B', '4B', 13, 'N'), (0000257, 00011, '4C', '4C', 14, 'N'), (0000258, 00011, 'B3', 'B3', 15, 'N'), (0000259, 00012, 'A', 'A', 1, 'N'), (0000260, 00012, 'A/B', 'A/B', 2, 'N'), (0000261, 00012, 'B', 'B', 3, 'N'), (0000262, 00012, 'B/C', 'B/C', 4, 'N'), (0000263, 00012, 'C', 'C', 5, 'N'), (0000264, 00012, 'C/D', 'C/D', 6, 'N'), (0000265, 00012, 'D', 'D', 7, 'N'), (0000266, 00012, 'D/E', 'D/E', 8, 'N'), (0000267, 00012, 'E', 'E', 9, 'N'), (0000268, 00012, 'E/F', 'E/F', 10, 'N'), (0000269, 00012, 'F', 'F', 11, 'N'), (0000270, 00012, 'G', 'G', 12, 'N'), (0000271, 00012, 'U', 'Unclassified', 13, 'N'), (0000272, 00010, '141', '141', 29, 'N'), (0000273, 00013, '7', '7', 1, 'N'), (0000274, 00013, '6', '6', 2, 'N'), (0000275, 00013, '5', '5', 3, 'N'), (0000276, 00013, '4', '4', 4, 'N'), (0000277, 00013, '3', '3', 5, 'N'), (0000278, 00013, '2', '2', 6, 'N'), (0000279, 00013, '1', '1', 7, 'N'), (0000280, 00014, '45', '45', 1, 'N'), (0000281, 00014, '44', '44', 2, 'N'), (0000282, 00014, '43', '43', 3, 'N'), (0000283, 00014, '42', '42', 4, 'N'), (0000284, 00014, '41', '41', 5, 'N'), (0000285, 00014, '40', '40', 6, 'N'), (0000286, 00014, '39', '39', 7, 'N'), (0000287, 00014, '38', '38', 8, 'N'), (0000288, 00014, '37', '37', 9, 'N'), (0000289, 00014, '36', '36', 10, 'N'), (0000290, 00014, '35', '35', 11, 'N'), (0000291, 00014, '34', '34', 12, 'N'), (0000292, 00014, '33', '33', 13, 'N'), (0000293, 00014, '32', '32', 14, 'N'), (0000294, 00014, '31', '31', 15, 'N'), (0000295, 00014, '30', '30', 16, 'N'), (0000296, 00014, '29', '29', 17, 'N'), (0000297, 00014, '28', '28', 18, 'N'), (0000298, 00014, '27', '27', 19, 'N'), (0000299, 00014, '26', '26', 20, 'N'), (0000300, 00014, '25', '25', 21, 'N'), (0000301, 00014, '24', '24', 22, 'N'), (0000302, 00014, '23', '23', 23, 'N'), (0000303, 00014, '22', '22', 24, 'N'), (0000304, 00014, '21', '21', 25, 'N'), (0000305, 00014, '20', '20', 26, 'N'), (0000306, 00014, '19', '19', 27, 'N'), (0000307, 00014, '18', '18', 28, 'N'), (0000308, 00014, '17', '17', 29, 'N'), (0000309, 00014, '16', '16', 30, 'N'), (0000310, 00014, '15', '15', 31, 'N'), (0000311, 00014, '14', '14', 32, 'N'), (0000312, 00014, '13', '13', 33, 'N'), (0000313, 00014, '12', '12', 34, 'N'), (0000314, 00014, '11', '11', 35, 'N'), (0000315, 00014, '10', '10', 36, 'N'), (0000316, 00014, '9', '9', 37, 'N'), (0000317, 00014, '8', '8', 38, 'N'), (0000318, 00014, '7', '7', 39, 'N'), (0000319, 00014, '6', '6', 40, 'N'), (0000320, 00014, '5', '5', 41, 'N'), (0000321, 00014, '4', '4', 42, 'N'), (0000322, 00014, '3', '3', 43, 'N'), (0000323, 00014, '2', '2', 44, 'N'), (0000324, 00014, '1', '1', 45, 'N'), (0000325, 00015, '8', 'Level 8', 1, 'N'), (0000326, 00015, '7', 'Level 7', 2, 'N'), (0000327, 00015, '6', 'Level 6', 3, 'N'), (0000328, 00015, '5', 'Level 5', 4, 'N'), (0000329, 00015, '4', 'Level 4', 5, 'N'), (0000330, 00015, '3', 'Level 3', 6, 'N'); -- -------------------------------------------------------- -- -- Table structure for table `gibbonSchoolYear` -- CREATE TABLE `gibbonSchoolYear` ( `gibbonSchoolYearID` int(3) unsigned zerofill NOT NULL AUTO_INCREMENT, `name` varchar(9) NOT NULL DEFAULT '', `status` enum('Past','Current','Upcoming') NOT NULL DEFAULT 'Upcoming', `sequenceNumber` int NOT NULL, `firstDay` date DEFAULT NULL, `lastDay` date DEFAULT NULL, PRIMARY KEY (`gibbonSchoolYearID`), UNIQUE KEY `academicYearName` (`name`), UNIQUE KEY `sequenceNumber` (`sequenceNumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=27 ; -- -- Dumping data for table `gibbonSchoolYear` -- INSERT INTO `gibbonSchoolYear` VALUES (025, '2025-2026', 'Current', 3, '2025-05-19', '2026-06-29'), (026, '2026-2027', 'Upcoming', 4, '2026-08-10', '2027-06-29'); -- -------------------------------------------------------- -- -- Table structure for table `gibbonSchoolYearSpecialDay` -- CREATE TABLE `gibbonSchoolYearSpecialDay` ( `gibbonSchoolYearSpecialDayID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonSchoolYearTermID` int(5) unsigned zerofill NOT NULL, `type` enum('School Closure','Timing Change','Off Timetable') DEFAULT NULL, `name` varchar(20) NOT NULL, `description` varchar(255) NOT NULL, `date` date NOT NULL, `schoolOpen` time DEFAULT NULL, `schoolStart` time DEFAULT NULL, `schoolEnd` time DEFAULT NULL, `schoolClose` time DEFAULT NULL, `context` enum('Year Group','Form Group') DEFAULT NULL, `gibbonYearGroupIDList` varchar(255) DEFAULT NULL, `gibbonFormGroupIDList` varchar(255) DEFAULT NULL, `cancelActivities` enum('Y','N') DEFAULT 'N', `cancelDuty` enum('Y','N') DEFAULT 'N', `cancelBookings` enum('Y','N') DEFAULT 'N', `cancelClasses` enum('Y','N') DEFAULT 'N', PRIMARY KEY (`gibbonSchoolYearSpecialDayID`), UNIQUE KEY `date` (`date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gibbonSchoolYearTerm` -- CREATE TABLE `gibbonSchoolYearTerm` ( `gibbonSchoolYearTermID` int(5) unsigned zerofill NOT NULL AUTO_INCREMENT, `gibbonSchoolYearID` int(3) unsigned zerofill NOT NULL, `sequenceNumber` int NOT NULL, `name` varchar(20) NOT NULL, `nameShort` varchar(4) NOT NULL, `firstDay` date NOT NULL, `lastDay` date NOT NULL, PRIMARY KEY (`gibbonSchoolYearTermID`), UNIQUE KEY `sequenceNumber` (`sequenceNumber`,`gibbonSchoolYearID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=40 ; -- -- Dumping data for table `gibbonSchoolYearTerm` -- INSERT INTO `gibbonSchoolYearTerm` VALUES (00034, 025, 31, 'Term 1', 'T1', '2025-05-19', '2026-01-04'), (00035, 025, 32, 'Term 2', 'T2', '2026-01-05', '2026-04-19'), (00036, 025, 33, 'Term 3', 'T3', '2026-04-13', '2026-06-29'), (00037, 026, 34, 'Term 1', 'T1', '2026-08-10', '2027-01-03'), (00038, 026, 35, 'Term 2', 'T2', '2027-01-04', '2027-04-11'), (00039, 026, 36, 'Term 3', 'T3', '2027-04-12', '2027-06-29'); -- -------------------------------------------------------- -- -- Table structure for table `gibbonSession` -- CREATE TABLE `gibbonSession` ( `gibbonSessionID` varchar(40) NOT NULL, `gibbonPersonID` int(10) unsigned zerofill DEFAULT NULL, `gibbonActionID` int(7) unsigned zerofill DEFAULT NULL, `sessionData` mediumtext, `sessionStatus` varchar(20) DEFAULT NULL, `timestampCreated` timestamp NULL DEFAULT NULL, `timestampModified` timestamp NULL DEFAULT NULL, PRIMARY KEY (`gibbonSessionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; -- -- Dumping data for table `gibbonSession` -- -- -- Table structure for table `gibbonSetting` -- CREATE TABLE `gibbonSetting` ( `gibbonSettingID` int(5) unsigned zerofill NOT NULL AUTO_INCREMENT, `scope` varchar(50) NOT NULL, `name` varchar(50) NOT NULL, `nameDisplay` varchar(60) NOT NULL, `description` varchar(255) NOT NULL, `value` text NOT NULL, PRIMARY KEY (`gibbonSettingID`), UNIQUE KEY `scope` (`scope`,`nameDisplay`), UNIQUE KEY `scope_2` (`scope`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 AUTO_INCREMENT=363 ; -- -- Dumping data for table `gibbonSetting` -- INSERT INTO `gibbonSetting` VALUES (00001, 'System', 'absoluteURL', 'Base URL', 'The address at which the whole system resides.', '[[softurl]]'), (00002, 'System', 'organisationName', 'Organisation Name', '', '[[organisation_name]]'), (00003, 'System', 'organisationNameShort', 'Organisation Initials', '', '[[organisation_initials]]'), (00006, 'System', 'pagination', 'Pagination Count', 'Must be numeric. Number of records shown per page.', '50'), (00007, 'System', 'systemName', 'System Name', '', '[[system_name]]'), (00008, 'System', 'indexText', 'Index Page Text', 'Text displayed in system''s welcome page.', 'Welcome to Gibbon, the free, open, flexible school platform. Designed by teachers for learning, Gibbon gives you the school tools you need.'), (00009, 'System', 'absolutePath', 'Base Path', 'The local FS path to the system', '[[softpath]]'), (00011, 'System', 'timezone', 'Timezone', 'The timezone where the school is located', 'America/New_York'), (00013, 'System', 'analytics', 'Analytics', 'Javascript code to integrate statistics, such as Google Analytics', ''), (00014, 'System', 'emailLink', 'Link To Email', 'The link that points to the school/''s email system', ''), (00015, 'System', 'webLink', 'Link To Web', 'The link that points to the school/''s website', ''), (00018, 'System', 'defaultAssessmentScale', 'Default Assessment Scale', 'This is the scale used as a default where assessment scales need to be selected.', '00007'), (00021, 'System', 'country', 'Country', 'The country the school is located in', 'United States'), (00022, 'System', 'organisationLogo', 'Logo', 'Relative path to site logo (400 x 100px)', 'themes/Default/img/logo.png'), (00023, 'System', 'calendarFeed', 'School Google Calendar ID', 'Google Calendar ID for your school calendar. Only enables timetable integration when logging in via Google.', ''), (00024, 'Activities', 'access', 'Access', 'System-wide access control', 'Register'), (00025, 'Activities', 'payment', 'Payment', 'Payment system', 'Per Activity'), (00026, 'Activities', 'enrolmentType', 'Enrolment Type', 'Enrolment process type', 'Competitive'), (00027, 'Activities', 'backupChoice', 'Backup Choice', 'Allow students to choose a backup, in case enroled activity is full.', 'Y'), (00029, 'Application Form', 'introduction', 'Introduction', 'Information to display before the form', ''), (00030, 'Application Form', 'postscript', 'Postscript', 'Information to display at the end of the form', ''), (00031, 'Application Form', 'scholarships', 'Scholarships', 'Information to display before the scholarship options', ''), (00032, 'Application Form', 'agreement', 'Agreement', 'Without this text, which is displayed above the agreement, users will not be asked to agree to anything', ''), (00033, 'Application Form', 'publicApplications', 'Public Applications?', 'If yes, members of the public can submit applications', 'Y'), (00034, 'Behaviour', 'positiveDescriptors', 'Positive Descriptors', 'Allowable choices for positive behaviour', 'Attitude to learning,Collaboration,Community spirit,Creativity,Effort,Leadership,Participation,Persistence,Problem solving,Quality of work,Values'), (00035, 'Behaviour', 'negativeDescriptors', 'Negative Descriptors', 'Allowable choices for negative behaviour', 'Classwork - Late,Classwork - Incomplete,Classwork - Unacceptable,Disrespectful,Disruptive,Homework - Late,Homework - Incomplete,Homework - Unacceptable,ICT Misuse,Truancy,Other'), (00036, 'Behaviour', 'levels', 'Levels', 'Allowable choices for severity level (from lowest to highest)', ',Stage 1,Stage 1 (Actioned),Stage 2,Stage 2 (Actioned),Stage 3,Stage 3 (Actioned),Actioned'), (00037, 'Resources', 'categories', 'Categories', 'Allowable choices for category', 'Article,Book,Document,Graphic,Idea,Music,Object,Painting,Person,Photo,Place,Poetry,Prose,Rubric,Text,Video,Website,Work Sample,Other'), (00038, 'Resources', 'purposesGeneral', 'Purposes (General)', 'Allowable choices for purpose when creating a resource', 'Assessment Aid,Concept,Inspiration,Learner Profile,Mass Mailer Attachment,Provocation,Skill,Teaching and Learning Strategy,Other'), (00039, 'System', 'version', 'Version', 'The version of the Gibbon database', '30.0.01'), (00040, 'Resources', 'purposesRestricted', 'Purposes (Restricted)', 'Additional allowable choices for purpose when creating a resource, for those with "Manage All Resources" rights', ''), (00041, 'System', 'organisationEmail', 'Organisation Email', 'General email address for the school', '[[admin_email]]'), (00042, 'Activities', 'dateType', 'Date Type', 'Should activities be organised around dates (flexible) or terms (easy)?', 'Term'), (00043, 'System', 'installType', 'Install Type', 'The purpose of this installation of Gibbon', 'Production'), (00044, 'System', 'statsCollection', 'Statistics Collection', 'To track Gibbon uptake, the system tracks basic data (current URL, install type, organisation name) on each install. Do you want to help?', 'N'), (00045, 'Activities', 'maxPerTerm', 'Maximum Activities per Term', 'The most a student can sign up for in one term. Set to 0 for unlimited.', '0'), (00046, 'Planner', 'lessonDetailsTemplate', 'Lesson Details Template', 'Template to be inserted into Lesson Details field', ''), (00047, 'Planner', 'teachersNotesTemplate', 'Teacher''s Notes Template', 'Template to be inserted into Teacher''s Notes field', ''), (00048, 'Planner', 'smartBlockTemplate', 'Smart Block Template', 'Template to be inserted into new block in Smart Unit', ''), (00049, 'Planner', 'unitOutlineTemplate', 'Unit Outline Template', 'Template to be inserted into Unit Outline section of planner', ''), (00050, 'Application Form', 'milestones', 'Milestones', 'Comma-separated list of the major steps in the application process. Applicants can be tracked through the various stages.', 'Information Reviewed,Documents Checked,Ready to Accept'), (00051, 'Library', 'defaultLoanLength', 'Default Loan Length', 'The standard loan length for a library item, in days', '7'), (00052, 'Behaviour', 'policyLink', 'Policy Link', 'A link to the school behaviour policy.', ''), (00053, 'Library', 'browseBGColor', 'Browse Library BG Colour', 'Click to select a colour.', ''), (00054, 'Library', 'browseBGImage', 'Browse Library BG Image', 'URL to background image used behind library browsing screen.', ''), (00055, 'System', 'passwordPolicyAlpha', 'Password - Alpha Requirement', 'Require both upper and lower case alpha characters?', 'Y'), (00056, 'System', 'passwordPolicyNumeric', 'Password - Numeric Requirement', 'Require at least one numeric character?', 'Y'), (00057, 'System', 'passwordPolicyNonAlphaNumeric', 'Password - Non-Alphanumeric Requirement', 'Require at least one non-alphanumeric character (e.g. punctuation mark or space)?', 'N'), (00058, 'System', 'passwordPolicyMinLength', 'Password - Minimum Length', 'Minimum acceptable password length.', '8'), (00059, 'User Admin', 'ethnicity', 'Ethnicity', 'Comma-separated list of ethnicities available in system', ''), (00060, 'User Admin', 'nationality', 'Nationality', 'Comma-separated list of nationalities available in system. If blank, system will default to list of countries', ''), (00061, 'User Admin', 'residencyStatus', 'Residency Status', 'Comma-separated list of residency status available in system. If blank, system will allow text input', ''), (00063, 'User Admin', 'personalDataUpdaterRequiredFields', 'Personal Data Updater Required Fields', 'Serialized array listed personal fields in data updater, and whether or not they are required.', 'a:47:{s:5:"title";s:1:"N";s:7:"surname";s:1:"Y";s:9:"firstName";s:1:"N";s:10:"otherNames";s:1:"N";s:13:"preferredName";s:1:"Y";s:12:"officialName";s:1:"Y";s:16:"nameInCharacters";s:1:"N";s:3:"dob";s:1:"N";s:5:"email";s:1:"N";s:14:"emailAlternate";s:1:"N";s:8:"address1";s:1:"Y";s:16:"address1District";s:1:"N";s:15:"address1Country";s:1:"N";s:8:"address2";s:1:"N";s:16:"address2District";s:1:"N";s:15:"address2Country";s:1:"N";s:10:"phone1Type";s:1:"N";s:17:"phone1CountryCode";s:1:"N";s:6:"phone1";s:1:"N";s:6:"phone2";s:1:"N";s:6:"phone3";s:1:"N";s:6:"phone4";s:1:"N";s:13:"languageFirst";s:1:"N";s:14:"languageSecond";s:1:"N";s:13:"languageThird";s:1:"N";s:14:"countryOfBirth";s:1:"N";s:9:"ethnicity";s:1:"N";s:12:"citizenship1";s:1:"N";s:20:"citizenship1Passport";s:1:"N";s:12:"citizenship2";s:1:"N";s:20:"citizenship2Passport";s:1:"N";s:8:"religion";s:1:"N";s:20:"nationalIDCardNumber";s:1:"N";s:15:"residencyStatus";s:1:"N";s:14:"visaExpiryDate";s:1:"N";s:10:"profession";s:1:"N";s:8:"employer";s:1:"N";s:8:"jobTitle";s:1:"N";s:14:"emergency1Name";s:1:"N";s:17:"emergency1Number1";s:1:"N";s:17:"emergency1Number2";s:1:"N";s:22:"emergency1Relationship";s:1:"N";s:14:"emergency2Name";s:1:"N";s:17:"emergency2Number1";s:1:"N";s:17:"emergency2Number2";s:1:"N";s:22:"emergency2Relationship";s:1:"N";s:19:"vehicleRegistration";s:1:"N";}'), (00065, 'School Admin', 'primaryExternalAssessmentByYearGroup', 'Primary External Assessment By Year Group', 'Serialized array connected gibbonExternalAssessmentID to gibbonYearGroupID, and specify which field set to use.', 'a:7:{s:3:"001";s:1:"-";s:3:"002";s:1:"-";s:3:"003";s:1:"-";s:3:"004";s:1:"-";s:3:"005";s:1:"-";s:3:"006";s:1:"-";s:3:"007";s:1:"-";}'), (00066, 'Markbook', 'markbookType', 'Markbook Type', 'Comma-separated list of types to make available in the Markbook.', 'Essay,Exam,Homework,Reflection,Test,Unit,End of Year,Other'), (00067, 'System', 'allowableHTML', 'Allowable HTML', 'TinyMCE-style list of acceptable HTML tags and options.', 'br[style|class],strong[style|class],b[style|class],em[style|class],span[style|class],p[style|class],address[style|class],pre[style|class],h1[style|class],h2[style|class],h3[style|class],h4[style|class],h5[style|class],h6[style|class],table[style|class],thead[style|class],tbody[style|class],tfoot[style|class],tr[style|class],td[style|class|colspan|rowspan],ol[style|class],ul[style|class],li[style|class],blockquote[style|class],a[style|class|target|href],img[style|class|src|width|height],video[style|class],source[style|class],hr[style|class],iframe[style|class|width|height|src|frameborder|allowfullscreen],embed[style|class],div[style|class],sup[style|class],sub[style|class],code[style|class],details[style|class],summary[style|class],pagebreak,columnbreak'), (00068, 'Application Form', 'howDidYouHear', 'How Did Your Hear?', 'Comma-separated list', 'Advertisement,Personal Recommendation,World Wide Web,Others'), (00070, 'Messenger', 'smsUsername', 'SMS Username', 'SMS gateway username.', ''), (00071, 'Messenger', 'smsPassword', 'SMS Password', 'SMS gateway password.', ''), (00072, 'Messenger', 'smsURL', 'SMS URL', 'SMS gateway URL for send requests.', ''), (00073, 'Messenger', 'smsURLCredit', 'SMS URL Credit', 'SMS gateway URL for checking credit.', ''), (00074, 'System', 'currency', 'Currency', 'System-wde currency for financial transactions. Support for online payment in this currency depends on your credit card gateway: please consult their support documentation.', 'USD $'), (00075, 'System', 'enablePayments', 'Enable Payments', 'Should payments be enabled across the system?', 'N'), (00076, 'System', 'paymentAPIUsername', 'API Username', 'API details are provided by the payment gateway provider', ''), (00077, 'System', 'paymentAPIPassword', 'API Password', 'API details are provided by the payment gateway provider', ''), (00078, 'System', 'paymentAPISignature', 'API Signature', 'API details are provided by the payment gateway provider', ''), (00079, 'Application Form', 'applicationFee', 'Application Submission Fee', 'The cost of applying to the school. Paid when submitting the application form.', '0'), (00080, 'Application Form', 'requiredDocuments', 'Required Documents', 'Comma-separated list of documents which must be submitted electronically with the application form.', ''), (00081, 'Application Form', 'requiredDocumentsCompulsory', 'Required Documents Compulsory?', 'Are the required documents compulsory?', 'N'), (00082, 'Application Form', 'requiredDocumentsText', 'Required Documents Text', 'Explanatory text to appear with the required documents?', ''), (00083, 'Application Form', 'notificationStudentDefault', 'Student Notification Default', 'Should student acceptance email be turned on or off by default.', 'On'), (00084, 'Application Form', 'languageOptionsActive', 'Language Options Active', 'Should the Language Options section be turned on?', 'Off'), (00085, 'Application Form', 'languageOptionsBlurb', 'Language Options Blurb', 'Introductory text if Language Options section is turned on.', ''), (00086, 'Application Form', 'languageOptionsLanguageList', 'Language Options Language List', 'Comma-separated list of available language selections if Language Options section is turned on.', ''), (00088, 'User Admin', 'personalBackground', 'Personal Background', 'Should users be allowed to set their own personal backgrounds?', 'Y'), (00091, 'User Admin', 'dayTypeOptions', 'Day-Type Options', 'Comma-separated list of options to make available (e.g. half-day, full-day). If blank, this field will not show up in the application form.', ''), (00092, 'User Admin', 'dayTypeText', 'Day-Type Text', 'Explanatory text to include with Day-Type Options.', ''), (00095, 'Markbook', 'showStudentAttainmentWarning', 'Show Student Attainment Warning', 'Show low attainment grade visual warning to students?', 'Y'), (00096, 'Markbook', 'showStudentEffortWarning', 'Show Student Effort Warning', 'Show low effort grade visual warning to students?', 'Y'), (00097, 'Markbook', 'showParentAttainmentWarning', 'Show Parent Attainment Warning', 'Show low attainment grade visual warning to parents?', 'Y'), (00098, 'Markbook', 'showParentEffortWarning', 'Show Parent Effort Warning', 'Show low effort grade visual warning to parents?', 'Y'), (00099, 'Planner', 'allowOutcomeEditing', 'Allow Outcome Editing', 'Should the text within outcomes be editable when planning lessons and units?', 'Y'), (00100, 'User Admin', 'privacy', 'Privacy', 'Should privacy options be turned on across the system?', 'N'), (00101, 'User Admin', 'privacyBlurb', 'Privacy Blurb', 'Descriptive text to accompany image privacy option when shown to users.', ''), (00102, 'Finance', 'invoiceText', 'Invoice Text', 'Text to appear in invoice, above invoice details and fees.', ''), (00103, 'Finance', 'invoiceNotes', 'Invoice Notes', 'Text to appear in invoice, below invoice details and fees.', ''), (00104, 'Finance', 'receiptText', 'Receipt Text', 'Text to appear in receipt, above receipt details and fees.', ''), (00105, 'Finance', 'receiptNotes', 'Receipt Notes', 'Text to appear in receipt, below receipt details and fees.', ''), (00106, 'Finance', 'reminder1Text', 'Reminder 1 Text', 'Text to appear in first level reminder level, above invoice details and fees.', ''), (00107, 'Finance', 'reminder2Text', 'Reminder 2 Text', 'Text to appear in second level reminder level, above invoice details and fees.', ''), (00108, 'Finance', 'reminder3Text', 'Reminder 3 Text', 'Text to appear in third level reminder level, above invoice details and fees.', ''), (00109, 'Finance', 'email', 'Email', 'Email address to send finance emails from.', '[[admin_email]]'), (00110, 'Application Form', 'notificationParentsDefault', 'Parents Notification Default', 'Should parent acceptance email be turned on or off by default.', 'On'), (00111, 'User Admin', 'privacyOptions', 'Privacy Options', 'Comma-separated list of choices to make available if privacy options are turned on.', ''), (00112, 'Planner', 'sharingDefaultParents', 'Sharing Default: Parents', 'When adding lessons and deploying units, should sharing default for parents be Y or N?', 'Y'), (00113, 'Planner', 'sharingDefaultStudents', 'Sharing Default: Students', 'When adding lessons and deploying units, should sharing default for students be Y or N?', 'Y'), (00116, 'Application Form', 'notificationParentsMessage', 'Parents Notification Message', 'A custom message to add to the standard email to parents on acceptance.', ''), (00117, 'Application Form', 'notificationStudentMessage', 'Student Notification Message', 'A custom message to add to the standard email to students on acceptance.', ''), (00118, 'Finance', 'invoiceNumber', 'Invoice Number Style', 'How should invoice numbers be constructed?', 'Invoice ID'), (00119, 'User Admin', 'departureReasons', 'Departure Reasons', 'Comma-separated list of reasons for departure from school. If blank, user can enter any text.', ''), (00120, 'System', 'googleOAuth', 'Google Integration', '', 'Migrated'), (00127, 'Markbook', 'personalisedWarnings', 'Personalised Warnings', 'Should markbook warnings be based on personal targets, if they are available?', 'Y'), (00128, 'Activities', 'disableExternalProviderSignup', 'Disable External Provider Signup', 'Should we turn off the option to sign up for activities provided by an outside agency?', 'N'), (00129, 'Activities', 'hideExternalProviderCost', 'Hide External Provider Cost', 'Should we hide the cost of activities provided by an outside agency from the Activities View?', 'N'), (00130, 'System', 'cuttingEdgeCode', 'Cutting Edge Code', 'Are you running cutting edge code, instead of stable versions?', 'N'), (00131, 'System', 'cuttingEdgeCodeLine', 'Cutting Edge Code Line', 'What line of SQL code did the last cutting edge update hit?', ''), (00132, 'System', 'gibboneduComOrganisationName', 'Catalyst License Organisation Name', 'Name of organisation on your Catalyst License', ''), (00133, 'System', 'gibboneduComOrganisationKey', 'Catalyst License Key', 'Organisation''s private key, as registered on your Catalyst License', ''), (00134, 'Application Form', 'studentDefaultEmail', 'Student Default Email', 'Set default email for students on acceptance, using [username] to insert username.', ''), (00135, 'Application Form', 'studentDefaultWebsite', 'Student Default Website', 'Set default website for students on acceptance, using [username] to insert username.', ''), (00136, 'School Admin', 'studentAgreementOptions', 'Student Agreement Options', 'Comma-separated list of agreements that students might be asked to sign in school (e.g. ICT Policy).', ''), (00137, 'Markbook', 'attainmentAlternativeName', 'Attainment Alternative Name', 'A name to use instead of "Attainment" in the first grade column of the markbook.', ''), (00138, 'Markbook', 'effortAlternativeName', 'Effort Alternative Name', 'A name to use instead of "Effort" in the second grade column of the markbook.', ''), (00139, 'Markbook', 'attainmentAlternativeNameAbrev', 'Attainment Alternative Name Abbreviation', 'A short name to use instead of "Attainment" in the first grade column of the markbook.', ''), (00140, 'Markbook', 'effortAlternativeNameAbrev', 'Effort Alternative Name Abbreviation', 'A short name to use instead of "Effort" in the second grade column of the markbook..', ''), (00141, 'School Admin', 'parentWeeklyEmailSummaryIncludeBehaviour', 'Parent Weekly Email Summary Include Behaviour', 'Should behaviour information be included in the weekly planner email summary that goes out to parents?', 'Y'), (00142, 'Finance', 'financeOnlinePaymentEnabled', 'Enable Online Payment', 'Should invoices be payable online, via an encrypted link in the invoice? Requires correctly configured payment gateway in System Settings.', 'N'), (00143, 'Finance', 'financeOnlinePaymentThreshold', 'Online Payment Threshold', 'If invoices are payable online, what is the maximum payment allowed? Useful for controlling payment fees. No value means unlimited.', ''), (00144, 'Departments', 'makeDepartmentsPublic', 'Make Departments Public', 'Should department information be made available to the public, via the Gibbon homepage?', 'N'), (00145, 'System', 'sessionDuration', 'Session Duration', 'Time, in seconds, before system logs a user out. Should be less than PHP''s session.gc_maxlifetime option.', '1200'), (00146, 'Planner', 'makeUnitsPublic', 'Make Units Public', 'Enables a public listing of units, with teachers able to opt in to share units.', 'N'), (00150, 'Students', 'enableStudentNotes', 'Enable Student Notes', 'Should student notes be turned on?', 'Y'), (00151, 'Finance', 'budgetCategories', 'Budget Categories', 'Comma-separated list of budget categories.', 'Academic, Administration, Capital'), (00153, 'Finance', 'expenseApprovalType', 'Expense Approval Type', 'How should expense approval be dealt with?', 'One Of'), (00154, 'Finance', 'budgetLevelExpenseApproval', 'Budget Level Expense Approval', 'Should approval from a budget member with Full access be required?', 'Y'), (00155, 'Finance', 'expenseRequestTemplate', 'Expense Request Template', 'An HTML template to be used in the description field of expense requests.', ''), (00156, 'Finance', 'purchasingOfficer', 'Purchasing Officer', 'User responsible for purchasing for the school.', ''), (00157, 'Finance', 'reimbursementOfficer', 'Reimbursement Officer', 'User responsible for reimbursing expenses.', ''), (00158, 'Messenger', 'enableHomeScreenWidget', 'Enable Home Screen Widget', 'Adds a Message Wall widget to the home page, hihglighting current messages.', 'N'), (00159, 'User Admin', 'enablePublicRegistration', 'Enable Public Registration', 'Allows members of the public to register to use the system.', 'N'), (00160, 'User Admin', 'publicRegistrationMinimumAge', 'Public Registration Minimum Age', 'The minimum age, in years, permitted to register.', '13'), (00161, 'User Admin', 'publicRegistrationDefaultStatus', 'Public Registration Default Status', 'Should new users be ''Full'' or ''Pending Approval''?', 'Pending Approval'), (00162, 'User Admin', 'publicRegistrationDefaultRole', 'Public Registration Default Role', 'System role to be assigned to registering members of the public.', '003'), (00163, 'User Admin', 'publicRegistrationIntro', 'Public Registration Introductory Text', 'HTML text that will appear above the public registration form.', ''), (00164, 'User Admin', 'publicRegistrationPrivacyStatement', 'Public Registration Privacy Statement', 'HTML text that will appear above the Submit button, explaining privacy policy.', 'By registering for this site you are giving permission for your personal data to be used and shared within this organisation and its websites. We will not share your personal data outside our organisation.'), (00165, 'User Admin', 'publicRegistrationAgreement', 'Public Registration Agreement', 'Agreement that user must confirm before joining. Blank for no agreement.', 'In joining this site, and checking the box below, I agree to act lawfully, ethically and with respect for others. I agree to use this site for learning purposes only, and understand that access may be withdrawn at any time, at the discretion of the site''s administrators.'), (00166, 'User Admin', 'publicRegistrationPostscript', 'Public Registration Postscript', 'HTML text that will appear underneath the public registration form.', ''), (00167, 'System', 'alarm', 'Alarm', 'Sound a system wide alarm to all staff.', 'None'), (00168, 'Behaviour', 'enableDescriptors', 'Enable Descriptors', 'Setting to No reduces complexity of behaviour tracking.', 'Y'), (00169, 'Behaviour', 'enableLevels', 'Enable Levels', 'Setting to No reduces complexity of behaviour tracking.', 'Y'), (00170, 'Formal Assessment', 'internalAssessmentTypes', 'Internal Assessment Types', 'Comma-separated list of types to make available in Internal Assessments.', 'Expected Grade,Predicted Grade,Target Grade'), (00171, 'System Admin', 'customAlarmSound', 'Custom Alarm Sound', 'A custom alarm sound file.', ''), (00172, 'School Admin', 'facilityTypes', 'FacilityTypes', 'A comma-separated list of types for facilities.', 'Classroom,Hall,Laboratory,Library,Office,Outdoor,Performance,Staffroom,Storage,Study,Undercover,Other'), (00173, 'Finance', 'allowExpenseAdd', 'Allow Expense Add', 'Allows privileged users to add expenses without going through request process.', 'Y'), (00174, 'System', 'organisationAdministrator', 'System Administrator', 'The staff member who receives notifications for system events.', '1'), (00175, 'System', 'organisationDBA', 'Database Administrator', 'The staff member who receives notifications for data events.', '1'), (00176, 'System', 'organisationAdmissions', 'Admissions Administrator', 'The staff member who receives notifications for admissions events.', '1'), (00177, 'Finance', 'hideItemisation', 'Hide Itemisation', 'Hide fee and payment details in receipts?', 'N'), (00178, 'Application Form', 'autoHouseAssign', 'Auto House Assign', 'Attempt to automatically place student in a house?', 'N'), (00179, 'Tracking', 'externalAssessmentDataPoints', 'External Assessment Data Points', 'Stores the external assessment choices for data points output in tracking.', ''), (00180, 'Tracking', 'internalAssessmentDataPoints', 'Internal Assessment Data Points', 'Stores the internal assessment choices for data points output in tracking.', ''), (00181, 'Behaviour', 'enableNegativeBehaviourLetters', 'Enable Negative Behaviour Letters', 'Should automated behaviour letter functionality be enabled?', 'N'), (00182, 'Behaviour', 'behaviourLettersNegativeLetter1Count', 'Negative Letter 1 Count', 'After how many negative records should letter 1 be sent?', '3'), (00183, 'Behaviour', 'behaviourLettersLetter1Text', 'Letter 1 Text', 'The contents of letter 1, as HTML.', 'Dear Parent/Guardian,| \n Job Description \n \n | \n |
| \n Responsibilities \n
| \n \n Required Skills/Characteristics \n
| \n
| \n Remuneration \n
| \n \n Other Details \n
| \n
Our admissions system will help you to create new application forms as well as submit required documents and track your application status.
Select an application form below to begin the admissions process. If you already have one or more application forms in progress, you can choose to receive an email which will give you access to your existing forms.
'), (00345, 'Admissions', 'admissionsEnabled', 'Enable New Admissions Page', 'Should the new admissions page show up on the homepage, in place of the original student application link?', 'Y'), (00346, 'Admissions', 'admissionsLinkText', 'Admissions Link Text', 'Text to display on the homepage with the admissions link.', 'Parents of students interested in study at %1$s may use our %2$s online form%3$s to initiate the application process.'), (00347, 'Admissions', 'admissionsLinkName', 'Admissions Link Name', 'Title of the admissions link on the homepage.', 'Student Applications'), (00348, 'Timetable Admin', 'enrolmentMinDefault', 'Minimum Enrolment Default', 'The default value for minimum class enrolment.', ''), (00349, 'Timetable Admin', 'enrolmentMaxDefault', 'Maximum Enrolment Default', 'The default value for maximum class enrolment.', ''), (00350, 'Staff', 'coverageMode', 'Coverage Mode', 'Should teachers send coverage requests directly to substitutes, or will it be assigned for them?', 'Requested'), (00351, 'Staff', 'coverageInternal', 'Internal Coverage', 'If Yes, teachers can be assigned to cover each other. Otherwise, only users added through Manage Substitutes will be available for coverage.', 'N'), (00352, 'Students', 'emergencyFollowUpGroup', 'Follow-up Contacts', 'An optional list of staff to include in the follow-up contacts section.', ''), (00353, 'Messenger', 'signatureTemplate', 'Signature Template', 'An HTML and Twig template used to add signatures to messages.', '----