-- Table structure for table `gibbonCrowdAssessDiscuss`
--

CREATE TABLE `gibbonCrowdAssessDiscuss` (
  `gibbonCrowdAssessDiscussID` int(16) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `gibbonPlannerEntryHomeworkID` int(16) unsigned zerofill NOT NULL,
  `gibbonPersonID` int(10) unsigned zerofill NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `comment` text NOT NULL,
  `gibbonCrowdAssessDiscussIDReplyTo` int(16) unsigned zerofill DEFAULT NULL,
  PRIMARY KEY (`gibbonCrowdAssessDiscussID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonCrowdAssessDiscuss`
--


--
-- Table structure for table `gibbonCustomField`
--

CREATE TABLE `gibbonCustomField` (
  `gibbonCustomFieldID` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `context` varchar(60) NOT NULL DEFAULT 'Person',
  `name` varchar(50) NOT NULL,
  `active` enum('Y','N') NOT NULL DEFAULT 'Y',
  `description` varchar(255) NOT NULL,
  `type` enum('varchar','text','date','time','url','select','checkboxes','radio','yesno','editor','color','number','image','file','code') NOT NULL,
  `options` text NOT NULL COMMENT 'Field length for varchar, rows for text, comma-separate list for select/checkbox.',
  `required` enum('N','Y') NOT NULL DEFAULT 'N',
  `hidden` enum('Y','N') DEFAULT 'N',
  `heading` varchar(90) NOT NULL,
  `sequenceNumber` int(4) NOT NULL,
  `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,
  `activePublicRegistration` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`gibbonCustomFieldID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonCustomField`
--


--
-- Table structure for table `gibbonDataRetention`
--

CREATE TABLE `gibbonDataRetention` (
  `gibbonDataRetentionID` int(11) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `gibbonPersonID` int(10) unsigned zerofill NOT NULL,
  `tables` text NOT NULL,
  `status` enum('Success','Partial Failure') DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `gibbonPersonIDOperator` int(10) unsigned zerofill NOT NULL,
  PRIMARY KEY (`gibbonDataRetentionID`),
  UNIQUE KEY `gibbonPersonID` (`gibbonPersonID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonDataRetention`
--


--
-- Table structure for table `gibbonDaysOfWeek`
--

CREATE TABLE `gibbonDaysOfWeek` (
  `gibbonDaysOfWeekID` int(2) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `name` varchar(10) NOT NULL,
  `nameShort` varchar(4) NOT NULL,
  `sequenceNumber` int(2) NOT NULL,
  `schoolDay` enum('Y','N') NOT NULL DEFAULT 'Y',
  `schoolOpen` time DEFAULT NULL,
  `schoolStart` time DEFAULT NULL,
  `schoolEnd` time DEFAULT NULL,
  `schoolClose` time DEFAULT NULL,
  PRIMARY KEY (`gibbonDaysOfWeekID`),
  UNIQUE KEY `name` (`name`,`nameShort`),
  UNIQUE KEY `sequenceNumber` (`sequenceNumber`),
  UNIQUE KEY `nameShort` (`nameShort`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonDaysOfWeek`
--

INSERT INTO `gibbonDaysOfWeek` VALUES (01,'Monday','Mon',1,'Y','07:45:00','08:30:00','15:30:00','17:00:00'),(02,'Tuesday','Tue',2,'Y','07:45:00','08:30:00','15:30:00','17:00:00'),(03,'Wednesday','Wed',3,'Y','07:45:00','08:30:00','15:30:00','17:00:00'),(04,'Thursday','Thu',4,'Y','07:45:00','08:30:00','15:30:00','17:00:00'),(05,'Friday','Fri',5,'Y','07:45:00','08:30:00','15:30:00','17:00:00'),(06,'Saturday','Sat',6,'N',NULL,NULL,NULL,NULL),(07,'Sunday','Sun',7,'N',NULL,NULL,NULL,NULL);

--
-- Table structure for table `gibbonDepartment`
--

CREATE TABLE `gibbonDepartment` (
  `gibbonDepartmentID` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `type` enum('Learning Area','Administration') NOT NULL DEFAULT 'Learning Area',
  `name` varchar(40) NOT NULL,
  `nameShort` varchar(4) NOT NULL,
  `subjectListing` varchar(255) NOT NULL,
  `blurb` text NOT NULL,
  `logo` varchar(255) NOT NULL,
  `sequenceNumber` int(4) unsigned DEFAULT NULL,
  `fields` text DEFAULT NULL,
  PRIMARY KEY (`gibbonDepartmentID`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonDepartment`
--

INSERT INTO `gibbonDepartment` VALUES (0004,'Learning Area','Science','SCI','Sciences','','',NULL,NULL),(0005,'Learning Area','The Arts','TA','Art, Dance, Drama, Media, Music','','',NULL,NULL),(0006,'Learning Area','Humanities','HUM','Humanities, Economics, Religious Studies, Environmental Management','','',NULL,NULL),(0007,'Learning Area','English','ENG','English, English as an Additional Language','','',NULL,NULL),(0008,'Learning Area','Languages','LNG','Chinese First Language, Chinese Second Language, Japanese, Spanish','','',NULL,NULL),(0010,'Learning Area','Physical Education','PE','Physical Education','','',NULL,NULL),(0011,'Administration','Finance','FIN','','','',NULL,NULL),(0012,'Administration','Library','LIB','','','',NULL,NULL),(0014,'Administration','IT Services','ITS','','','',NULL,NULL),(0015,'Learning Area','Pastoral','PAST','','','',NULL,NULL),(0016,'Learning Area','Mathematics','MA','Maths','','',NULL,NULL),(0018,'Learning Area','Human Technologies','HT','HT, PSHE, DCVT, ENF','','',NULL,NULL),(0022,'Learning Area','Individual Needs','IN','','','',NULL,NULL);

--
-- Table structure for table `gibbonDepartmentResource`
--

CREATE TABLE `gibbonDepartmentResource` (
  `gibbonDepartmentResourceID` int(8) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `gibbonDepartmentID` int(4) unsigned zerofill NOT NULL,
  `type` enum('Link','File') NOT NULL,
  `name` varchar(100) NOT NULL,
  `url` varchar(255) NOT NULL,
  PRIMARY KEY (`gibbonDepartmentResourceID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonDepartmentResource`
--


--
-- Table structure for table `gibbonDepartmentStaff`
--

CREATE TABLE `gibbonDepartmentStaff` (
  `gibbonDepartmentStaffID` int(6) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `gibbonDepartmentID` int(4) unsigned zerofill NOT NULL,
  `gibbonPersonID` int(10) unsigned zerofill NOT NULL,
  `role` enum('Coordinator','Assistant Coordinator','Teacher (Curriculum)','Teacher','Director','Manager','Administrator','Other') NOT NULL,
  PRIMARY KEY (`gibbonDepartmentStaffID`)
) ENGINE=InnoDB AUTO_INCREMENT=285 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonDepartmentStaff`
--

INSERT INTO `gibbonDepartmentStaff` VALUES (000001,0001,0000000001,'Coordinator'),(000002,0002,0000000001,'Coordinator'),(000006,0005,0000000117,'Coordinator'),(000007,0005,0000000143,'Teacher'),(000008,0005,0000000141,'Teacher'),(000012,0004,0000000139,'Other'),(000015,0008,0000000122,'Coordinator'),(000026,0010,0000000119,'Coordinator'),(000030,0004,0000000377,'Teacher'),(000036,0008,0000000198,'Teacher (Curriculum)'),(000037,0008,0000000140,'Teacher (Curriculum)'),(000038,0008,0000000378,'Teacher (Curriculum)'),(000041,0005,0000000374,'Teacher (Curriculum)'),(000044,0008,0000000144,'Coordinator'),(000045,0007,0000000151,'Teacher (Curriculum)'),(000046,0007,0000000145,'Teacher (Curriculum)'),(000047,0010,0000000373,'Teacher (Curriculum)'),(000048,0004,0000000146,'Teacher (Curriculum)'),(000050,0006,0000000770,'Teacher (Curriculum)'),(000051,0005,0000000771,'Teacher (Curriculum)'),(000052,0008,0000000771,'Teacher (Curriculum)'),(000053,0004,0000000622,'Teacher (Curriculum)'),(000054,0008,0000000772,'Teacher (Curriculum)'),(000056,0006,0000000774,'Teacher (Curriculum)'),(000057,0004,0000000775,'Teacher (Curriculum)'),(000061,0011,0000000385,'Director'),(000062,0012,0000000824,'Director'),(000064,0014,0000000001,'Director'),(000066,0006,0000000771,'Teacher (Curriculum)'),(000068,0015,0000000774,'Coordinator'),(000069,0015,0000000142,'Coordinator'),(000070,0007,0000000769,'Coordinator'),(000071,0007,0000000142,'Teacher (Curriculum)'),(000072,0006,0000000137,'Teacher (Curriculum)'),(000077,0015,0000000117,'Teacher (Curriculum)'),(000081,0015,0000000123,'Teacher (Curriculum)'),(000082,0015,0000000769,'Teacher (Curriculum)'),(000085,0015,0000000622,'Teacher (Curriculum)'),(000088,0015,0000000773,'Teacher (Curriculum)'),(000090,0015,0000000771,'Teacher (Curriculum)'),(000093,0008,0000001057,'Teacher (Curriculum)'),(000094,0015,0000000772,'Teacher (Curriculum)'),(000096,0004,0000000868,'Coordinator'),(000098,0004,0000001055,'Teacher (Curriculum)'),(000106,0015,0000001055,'Teacher (Curriculum)'),(000108,0005,0000001053,'Teacher (Curriculum)'),(000111,0006,0000001110,'Teacher (Curriculum)'),(000114,0004,0000001112,'Teacher (Curriculum)'),(000115,0016,0000000773,'Coordinator'),(000118,0016,0000000866,'Teacher (Curriculum)'),(000119,0016,0000001104,'Teacher (Curriculum)'),(000125,0006,0000000151,'Teacher (Curriculum)'),(000126,0005,0000000770,'Teacher (Curriculum)'),(000127,0007,0000001123,'Teacher (Curriculum)'),(000128,0007,0000001118,'Teacher (Curriculum)'),(000129,0007,0000001053,'Teacher (Curriculum)'),(000130,0007,0000000867,'Coordinator'),(000131,0006,0000001118,'Teacher (Curriculum)'),(000132,0006,0000001120,'Teacher (Curriculum)'),(000133,0006,0000001121,'Teacher (Curriculum)'),(000134,0008,0000001119,'Teacher (Curriculum)'),(000135,0008,0000001122,'Teacher (Curriculum)'),(000136,0008,0000001116,'Teacher (Curriculum)'),(000137,0016,0000001117,'Teacher (Curriculum)'),(000138,0004,0000001121,'Teacher (Curriculum)'),(000139,0004,0000001117,'Teacher (Curriculum)'),(000141,0006,0000000589,'Teacher (Curriculum)'),(000142,0005,0000000375,'Coordinator'),(000143,0004,0000001120,'Teacher (Curriculum)'),(000144,0005,0000000871,'Teacher (Curriculum)'),(000145,0015,0000000869,'Teacher (Curriculum)'),(000146,0015,0000001121,'Coordinator'),(000147,0015,0000001123,'Teacher (Curriculum)'),(000148,0015,0000000124,'Teacher (Curriculum)'),(000149,0015,0000000868,'Teacher (Curriculum)'),(000150,0015,0000000375,'Teacher (Curriculum)'),(000151,0015,0000000866,'Teacher (Curriculum)'),(000152,0015,0000001104,'Teacher (Curriculum)'),(000153,0015,0000001053,'Teacher (Curriculum)'),(000154,0015,0000001117,'Teacher (Curriculum)'),(000155,0015,0000000870,'Teacher (Curriculum)'),(000156,0015,0000000120,'Teacher (Curriculum)'),(000157,0015,0000000867,'Teacher (Curriculum)'),(000158,0015,0000000140,'Teacher (Curriculum)'),(000159,0015,0000000151,'Teacher (Curriculum)'),(000160,0015,0000001120,'Teacher (Curriculum)'),(000161,0015,0000000871,'Teacher (Curriculum)'),(000162,0015,0000000198,'Teacher (Curriculum)'),(000163,0015,0000001119,'Teacher (Curriculum)'),(000166,0018,0000000373,'Teacher (Curriculum)'),(000168,0010,0000001489,'Teacher (Curriculum)'),(000169,0007,0000001502,'Teacher (Curriculum)'),(000173,0016,0000001501,'Teacher (Curriculum)'),(000174,0004,0000001505,'Teacher (Curriculum)'),(000175,0004,0000001501,'Teacher (Curriculum)'),(000177,0016,0000000868,'Coordinator'),(000183,0007,0000001778,'Teacher (Curriculum)'),(000185,0007,0000001776,'Teacher (Curriculum)'),(000186,0008,0000001776,'Teacher (Curriculum)'),(000187,0005,0000001776,'Teacher (Curriculum)'),(000189,0018,0000001777,'Teacher (Curriculum)'),(000190,0007,0000001777,'Teacher (Curriculum)'),(000191,0018,0000001506,'Teacher (Curriculum)'),(000192,0005,0000001506,'Teacher (Curriculum)'),(000200,0018,0000001119,'Teacher (Curriculum)'),(000201,0018,0000001110,'Teacher (Curriculum)'),(000204,0007,0000000871,'Teacher (Curriculum)'),(000205,0008,0000001873,'Teacher (Curriculum)'),(000207,0016,0000000120,'Coordinator'),(000209,0018,0000002027,'Teacher (Curriculum)'),(000222,0006,0000002028,'Teacher (Curriculum)'),(000223,0004,0000002026,'Teacher (Curriculum)'),(000224,0004,0000002025,'Teacher (Curriculum)'),(000225,0018,0000000124,'Teacher (Curriculum)'),(000227,0018,0000001502,'Teacher (Curriculum)'),(000230,0018,0000002028,'Teacher (Curriculum)'),(000231,0015,0000000144,'Teacher (Curriculum)'),(000232,0015,0000000373,'Teacher (Curriculum)'),(000233,0015,0000000119,'Teacher (Curriculum)'),(000234,0015,0000002096,'Teacher (Curriculum)'),(000235,0015,0000002075,'Teacher (Curriculum)'),(000236,0015,0000000374,'Teacher (Curriculum)'),(000237,0015,0000001122,'Teacher (Curriculum)'),(000238,0015,0000001506,'Teacher (Curriculum)'),(000239,0015,0000002027,'Teacher (Curriculum)'),(000240,0015,0000001776,'Teacher (Curriculum)'),(000241,0015,0000001110,'Teacher (Curriculum)'),(000242,0015,0000000589,'Teacher (Curriculum)'),(000243,0015,0000001502,'Teacher (Curriculum)'),(000244,0015,0000001778,'Teacher (Curriculum)'),(000245,0015,0000000770,'Teacher (Curriculum)'),(000246,0015,0000000001,'Teacher (Curriculum)'),(000247,0015,0000001777,'Teacher (Curriculum)'),(000248,0015,0000002026,'Teacher (Curriculum)'),(000249,0015,0000002025,'Teacher (Curriculum)'),(000250,0015,0000001799,'Teacher (Curriculum)'),(000251,0015,0000002028,'Teacher (Curriculum)'),(000252,0010,0000001104,'Teacher (Curriculum)'),(000253,0010,0000001776,'Teacher (Curriculum)'),(000254,0010,0000002134,'Teacher (Curriculum)'),(000255,0022,0000001110,'Coordinator'),(000256,0022,0000002096,'Teacher (Curriculum)'),(000257,0016,0000002312,'Teacher (Curriculum)'),(000258,0007,0000002312,'Teacher (Curriculum)'),(000259,0018,0000001778,'Coordinator'),(000260,0018,0000000001,'Teacher (Curriculum)'),(000261,0018,0000001122,'Teacher (Curriculum)'),(000262,0018,0000002134,'Teacher (Curriculum)'),(000263,0018,0000001123,'Teacher (Curriculum)'),(000264,0018,0000001104,'Teacher (Curriculum)'),(000265,0018,0000000119,'Teacher (Curriculum)'),(000266,0006,0000000124,'Teacher (Curriculum)'),(000267,0006,0000002027,'Coordinator'),(000268,0004,0000000589,'Teacher (Curriculum)'),(000269,0004,0000000870,'Coordinator'),(000270,0005,0000000001,'Teacher (Curriculum)'),(000273,0004,0000002326,'Teacher (Curriculum)'),(000275,0015,0000002326,'Teacher (Curriculum)'),(000276,0015,0000002134,'Teacher (Curriculum)'),(000277,0008,0000002347,'Teacher (Curriculum)'),(000278,0005,0000002363,'Teacher (Curriculum)'),(000279,0008,0000000869,'Assistant Coordinator'),(000280,0004,0000002134,'Teacher (Curriculum)'),(000281,0016,0000001601,'Teacher (Curriculum)'),(000282,0008,0000002551,'Teacher (Curriculum)'),(000283,0008,0000002552,'Teacher (Curriculum)'),(000284,0007,0000002562,'Teacher (Curriculum)');

--
-- Table structure for table `gibbonDiscussion`
--

CREATE TABLE `gibbonDiscussion` (
  `gibbonDiscussionID` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `foreignTable` varchar(60) NOT NULL,
  `foreignTableID` int(14) unsigned zerofill NOT NULL,
  `gibbonModuleID` int(4) unsigned zerofill NOT NULL,
  `gibbonPersonID` int(10) unsigned zerofill NOT NULL,
  `gibbonPersonIDTarget` int(10) unsigned zerofill DEFAULT NULL,
  `type` varchar(60) DEFAULT NULL,
  `tag` varchar(60) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `attachmentType` enum('File','Link') DEFAULT NULL,
  `attachmentLocation` text DEFAULT NULL,
  `gibbonDiscussionIDReplyTo` int(12) unsigned zerofill DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`gibbonDiscussionID`),
  KEY `foreignTable` (`foreignTable`,`foreignTableID`),
  KEY `gibbonPersonID` (`gibbonPersonID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonDiscussion`
--


--
-- Table structure for table `gibbonDistrict`
--

CREATE TABLE `gibbonDistrict` (
  `gibbonDistrictID` int(6) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  PRIMARY KEY (`gibbonDistrictID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonDistrict`
--


--
-- Table structure for table `gibbonEmailTemplate`
--

CREATE TABLE `gibbonEmailTemplate` (
  `gibbonEmailTemplateID` int(6) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `type` enum('Core','Additional','Custom') NOT NULL DEFAULT 'Core',
  `templateType` varchar(120) NOT NULL,
  `moduleName` varchar(30) NOT NULL,
  `templateName` varchar(120) NOT NULL,
  `templateSubject` varchar(255) DEFAULT NULL,
  `templateBody` text DEFAULT NULL,
  `variables` text DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`gibbonEmailTemplateID`),
  UNIQUE KEY `moduleTemplate` (`templateName`,`moduleName`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonEmailTemplate`
--

INSERT INTO `gibbonEmailTemplate` VALUES (000001,'Core','Send Reports to Parents','Reports','Send Reports to Parents','{{reportName|title}} for {{studentPreferredName}} {{studentSurname}}','<p>Dear {{parentPreferredName}} {{parentSurname}},</p>\r\n<p>This email includes a link to {{studentPreferredName}}\'s {{reportName|title}} created on {{date}}.</p>\r\n<p>Click the button below to download this report. To protect your student\'s security and privacy, this download link will expire after 1 week.</p>\r\n<p>Thank you,<br />{{organisationAdministratorName}}</p>','{\"reportName\": \"Test Report\", \r\n\"studentPreferredName\": [\"firstName\"],\r\n\"studentSurname\": [\"lastName\"],\r\n\"parentPreferredName\": [\"firstName\"],\r\n\"parentSurname\": [\"lastName\"],\r\n\"date\": [\"date\"]\r\n}','2022-01-24 11:20:30'),(000002,'Core','Send Reports to Students','Reports','Send Reports to Students','Your {{reportName|title}}','<p>Dear {{studentPreferredName}} {{studentSurname}},</p>\r\n<p>This email includes a link to your {{reportName|title}} created on {{date}}.</p>\r\n<p>Click the button below to download this report. To protect your security and privacy, this download link will expire after 1 week.</p>\r\n<p>Thank you,<br />{{organisationAdministratorName}}</p>','{\"reportName\": \"Test Report\", \r\n\"studentPreferredName\": [\"firstName\"],\r\n\"studentSurname\": [\"lastName\"],\r\n\"date\": [\"date\"]\r\n}','2022-01-24 11:20:30'),(000003,'Core','Negative Behaviour Letter 1','Behaviour','Negative Behaviour Letter 1','Behaviour Letter for {{studentSurname}}, {{studentPreferredName}} ({{studentFormGroup}}) via {{systemName}} at {{organisationName}}','Dear Parent/Guardian,<br/><br/>This letter has been automatically generated to alert you to the fact that your child, {{studentPreferredName}}, has reached {{behaviourCount}} negative behaviour incidents. Please see the list below for the details of these incidents:<br/><br/>{{behaviourRecord|raw}}<br/>This letter represents the first communication in a sequence of 3 potential alerts, each of which is more critical than the last.<br/><br/>If you would like more information on this matter, please contact your child\'s tutor.','{\"behaviourCount\": [\"randomDigit\"], \r\n\"behaviourRecord\": [\"paragraph\"], \r\n\"studentPreferredName\": [\"firstName\"],\r\n\"studentSurname\": [\"lastName\"],\r\n\"studentFormGroup\": \"Y07\",\r\n\"parentPreferredName\": [\"firstNameFemale\"],\r\n\"parentSurname\": [\"lastName\"],\r\n\"parentTitle\": [\"titleFemale\"],\r\n\"formTutorPreferredName\": [\"firstNameMale\"],\r\n\"formTutorSurname\": [\"lastName\"],\r\n\"formTutorTitle\": [\"titleMale\"],\r\n\"formTutorEmail\": [\"safeEmail\"],\r\n\"date\": [\"date\"]\r\n}','2021-10-20 05:58:10'),(000004,'Core','Negative Behaviour Letter 2','Behaviour','Negative Behaviour Letter 2','Behaviour Letter for {{studentSurname}}, {{studentPreferredName}} ({{studentFormGroup}}) via {{systemName}} at {{organisationName}}','Dear Parent/Guardian,<br/><br/>This letter has been automatically generated to alert you to the fact that your child, {{studentPreferredName}}, has reached {{behaviourCount}} negative behaviour incidents. Please see the list below for the details of these incidents:<br/><br/>{{behaviourRecord|raw}}<br/>This letter represents the second communication in a sequence of 3 potential alerts, each of which is more critical than the last.<br/><br/>If you would like more information on this matter, please contact your child\'s tutor.','{\"behaviourCount\": [\"randomDigit\"], \r\n\"behaviourRecord\": [\"paragraph\"], \r\n\"studentPreferredName\": [\"firstName\"],\r\n\"studentSurname\": [\"lastName\"],\r\n\"studentFormGroup\": \"Y07\",\r\n\"parentPreferredName\": [\"firstNameFemale\"],\r\n\"parentSurname\": [\"lastName\"],\r\n\"parentTitle\": [\"titleFemale\"],\r\n\"formTutorPreferredName\": [\"firstNameMale\"],\r\n\"formTutorSurname\": [\"lastName\"],\r\n\"formTutorTitle\": [\"titleMale\"],\r\n\"formTutorEmail\": [\"safeEmail\"],\r\n\"date\": [\"date\"]\r\n}','2021-10-20 05:58:10'),(000005,'Core','Negative Behaviour Letter 3','Behaviour','Negative Behaviour Letter 3','Behaviour Letter for {{studentSurname}}, {{studentPreferredName}} ({{studentFormGroup}}) via {{systemName}} at {{organisationName}}','Dear Parent/Guardian,<br/><br/>This letter has been automatically generated to alert you to the fact that your child, {{studentPreferredName}}, has reached {{behaviourCount}} negative behaviour incidents. Please see the list below for the details of these incidents:<br/><br/>{{behaviourRecord|raw}}<br/>This letter represents the final communication in a sequence of 3 potential alerts, each of which is more critical than the last.<br/><br/>If you would like more information on this matter, please contact your child\'s tutor.','{\"behaviourCount\": [\"randomDigit\"], \r\n\"behaviourRecord\": [\"paragraph\"], \r\n\"studentPreferredName\": [\"firstName\"],\r\n\"studentSurname\": [\"lastName\"],\r\n\"studentFormGroup\": \"Y07\",\r\n\"parentPreferredName\": [\"firstNameFemale\"],\r\n\"parentSurname\": [\"lastName\"],\r\n\"parentTitle\": [\"titleFemale\"],\r\n\"formTutorPreferredName\": [\"firstNameMale\"],\r\n\"formTutorSurname\": [\"lastName\"],\r\n\"formTutorTitle\": [\"titleMale\"],\r\n\"formTutorEmail\": [\"safeEmail\"],\r\n\"date\": [\"date\"]\r\n}','2021-10-20 05:58:10'),(000006,'Core','Positive Behaviour Letter 1','Behaviour','Positive Behaviour Letter 1','Positive Behaviour Letter for {{studentSurname}}, {{studentPreferredName}} ({{studentFormGroup}}) via {{systemName}} at {{organisationName}}','','{\"behaviourCount\": [\"randomDigit\"], \r\n\"behaviourRecord\": [\"paragraph\"], \r\n\"studentPreferredName\": [\"firstName\"],\r\n\"studentSurname\": [\"lastName\"],\r\n\"studentFormGroup\": \"Y07\",\r\n\"parentPreferredName\": [\"firstNameFemale\"],\r\n\"parentSurname\": [\"lastName\"],\r\n\"parentTitle\": [\"titleFemale\"],\r\n\"formTutorPreferredName\": [\"firstNameMale\"],\r\n\"formTutorSurname\": [\"lastName\"],\r\n\"formTutorTitle\": [\"titleMale\"],\r\n\"formTutorEmail\": [\"safeEmail\"],\r\n\"date\": [\"date\"]\r\n}','2021-10-20 05:58:10'),(000007,'Core','Positive Behaviour Letter 2','Behaviour','Positive Behaviour Letter 2','Positive Behaviour Letter for {{studentSurname}}, {{studentPreferredName}} ({{studentFormGroup}}) via {{systemName}} at {{organisationName}}','','{\"behaviourCount\": [\"randomDigit\"], \r\n\"behaviourRecord\": [\"paragraph\"], \r\n\"studentPreferredName\": [\"firstName\"],\r\n\"studentSurname\": [\"lastName\"],\r\n\"studentFormGroup\": \"Y07\",\r\n\"parentPreferredName\": [\"firstNameFemale\"],\r\n\"parentSurname\": [\"lastName\"],\r\n\"parentTitle\": [\"titleFemale\"],\r\n\"formTutorPreferredName\": [\"firstNameMale\"],\r\n\"formTutorSurname\": [\"lastName\"],\r\n\"formTutorTitle\": [\"titleMale\"],\r\n\"formTutorEmail\": [\"safeEmail\"],\r\n\"date\": [\"date\"]\r\n}','2021-10-20 05:58:10'),(000008,'Core','Positive Behaviour Letter 3','Behaviour','Positive Behaviour Letter 3','Positive Behaviour Letter for {{studentSurname}}, {{studentPreferredName}} ({{studentFormGroup}}) via {{systemName}} at {{organisationName}}','','{\"behaviourCount\": [\"randomDigit\"], \r\n\"behaviourRecord\": [\"paragraph\"], \r\n\"studentPreferredName\": [\"firstName\"],\r\n\"studentSurname\": [\"lastName\"],\r\n\"studentFormGroup\": \"Y07\",\r\n\"parentPreferredName\": [\"firstNameFemale\"],\r\n\"parentSurname\": [\"lastName\"],\r\n\"parentTitle\": [\"titleFemale\"],\r\n\"formTutorPreferredName\": [\"firstNameMale\"],\r\n\"formTutorSurname\": [\"lastName\"],\r\n\"formTutorTitle\": [\"titleMale\"],\r\n\"formTutorEmail\": [\"safeEmail\"],\r\n\"date\": [\"date\"]\r\n}','2021-10-20 05:58:10'),(000009,'Core','Admissions Access Link','Admissions','Admissions Access Link','Admissions Access','<p>Dear {{email}},</p>\r\n<p>Thank 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.</p>\r\n<p><span>This is an automated email initiated by the admissions page at {{organisationNameShort}}. If</span> <span>you</span> <span>did</span> <span>not</span> <span>initiate</span> this email, please let us know. You are welcome to reply to this email should you have any questions.</p>\r\n<p>Regards,<br />{{organisationAdmissionsName}},<br />{{organisationNameShort}} Admissions Administrator</p>','{\"email\": [\"safeEmail\"], \r\n\"date\": [\"date\"], \"link\": \"https://gibbonedu.org\", \"organisationAdmissionsEmail\": [\"safeEmail\"], \"organisationAdmissionsName\": [\"name\"]\r\n}','2022-05-25 18:39:48'),(000010,'Core','Application Form Reference Request','Admissions','Application Form Reference Request','Request For Reference','<p>To whom it may concern,</p>\r\n<p>This email is being sent in relation to the application of a current or former student of your school: {{studentPreferredName}} {{studentSurname}}.</p>\r\n<p>In assessing their application for our school, we would like to enlist your help in completing the following reference form: {{applicationRefereeLink}}.</p>\r\n<p>Please feel free to contact me, should you have any questions in regard to this matter.</p>\r\n<p>Regards,<br />{{organisationAdmissionsName}},<br />{{organisationNameShort}} Admissions Administrator</p>','{\r\n \"email\": [\"safeEmail\"],\r\n \"date\": [\"date\"],\r\n \"applicationRefereeLink\": \"https://gibbonedu.org\",\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:47:19'),(000011,'Core','Application Form Confirmation','Admissions','Application Form Confirmation','Application Form Confirmation','<p>Dear {{parentTitle}} {{parentPreferredName}} {{parentSurname}},</p>\r\n<p>Thank you for applying for a student place at {{organisationName}}.</p>\r\n<p>Your application was successfully submitted. Our admissions team will review your application and be in touch in due course.</p>\r\n<p>In the meantime, should you have any questions please contact {{organisationAdmissionsName}} at {{organisationAdmissionsEmail}}.</p>\r\n<p>Please find a copy of your submitted details below, for your reference:<br />{{submissionDetails|raw}}</p>','{\r\n \"email\": [\"safeEmail\"],\r\n \"date\": [\"date\"],\r\n \"applicationID\": [\"randomDigit\"],\r\n \"applicationName\": \"Sample Application Form\",\r\n \"submissionDetails\": \"Example Data\",\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:46:20'),(000012,'Core','Parent Welcome Email','Admissions','Parent Welcome Email','Welcome to {{systemName}} at {{organisationNameShort}}','<p>Dear {{parentPreferredName}} {{parentSurname}},</p>\r\n<p>Your {{applicationName}} for {{studentPreferredName}} {{studentSurname}} has been accepted.</p>\r\n<p>Welcome 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:</p>\r\n<p>Username: {{username}}<br />Password: {{password}}</p>\r\n<p>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).</p>\r\n<p>Please feel free to reply to this email should you have any questions.</p>\r\n<p>{{organisationAdmissionsName}},<br />{{organisationNameShort}} Admissions Administrator</p>','{\r\n \"email\": [\"safeEmail\"],\r\n \"date\": [\"date\"],\r\n \"username\": [\"userName\"],\r\n \"password\": [\"password\"],\r\n \"applicationID\": [\"randomDigit\"],\r\n \"applicationName\": \"Sample Application Form\",\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:50:29'),(000013,'Core','Student Welcome Email','Admissions','Student Welcome Email','Welcome to {{systemName}} at {{organisationNameShort}}','<p>Dear {{studentPreferredName}} {{studentSurname}},</p>\r\n<p>Welcome 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:</p>\r\n<p>Username: {{username}}<br />Password: {{password}}<br /><br />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).</p>\r\n<p>Please feel free to reply to this email should you have any questions.</p>\r\n<p>{{organisationAdmissionsName}},<br />{{organisationNameShort}} Admissions Administrator</p>','{\r\n \"email\": [\"safeEmail\"],\r\n \"date\": [\"date\"],\r\n \"username\": [\"userName\"],\r\n \"password\": [\"password\"],\r\n \"applicationID\": [\"randomDigit\"],\r\n \"applicationName\": \"Sample Application Form\",\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:50:25'),(000014,'Core','Application Form Fee Request','Admissions','Application Form Fee Request','Application Fee','<p>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.</p>','{\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');

--
-- 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 AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- 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(4) NOT NULL,
  `gibbonScaleID` int(5) unsigned zerofill NOT NULL,
  `gibbonYearGroupIDList` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`gibbonExternalAssessmentFieldID`),
  KEY `gibbonExternalAssessmentID` (`gibbonExternalAssessmentID`)
) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonExternalAssessmentStudent`
--


--
-- 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonExternalAssessmentStudentEntry`
--


--
-- 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,
  PRIMARY KEY (`gibbonFamilyID`)
) ENGINE=InnoDB AUTO_INCREMENT=854 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFamily`
--

INSERT INTO `gibbonFamily` VALUES (0000001,'1','','','','','Married','','',''),(0000003,'3','','','','','Married','','',''),(0000004,'4','','','','','Married','','',''),(0000005,'5','','','','','Married','','',''),(0000006,'6','','','','','Married','','',''),(0000007,'7','','','','','Married','','',''),(0000008,'8','','','','','Married','','',''),(0000009,'9','','','','','Married','','',''),(0000010,'10','','','','','Married','','',''),(0000011,'11','','','','','Married','','',''),(0000012,'12','','','','','Married','','',''),(0000013,'13','','','','','Married','','',''),(0000014,'14','','','','','Married','','',''),(0000015,'15','','','','','Married','','',''),(0000016,'16','','','','','Married','','',''),(0000017,'17','','','','','Married','','',''),(0000018,'18','','','','','Married','','',''),(0000019,'19','','','','','Married','','',''),(0000020,'20','','','','','Married','','',''),(0000021,'21','','','','','Married','','',''),(0000022,'22','','','','','Married','','',''),(0000023,'23','','','','','Married','','',''),(0000024,'24','','','','','Married','','',''),(0000025,'25','','','','','Married','','',''),(0000026,'26','','','','','Married','','',''),(0000027,'27','','','','','Married','','',''),(0000028,'28','','','','','Married','','',''),(0000030,'30','','','','','Married','','',''),(0000032,'32','','','','','Married','','',''),(0000033,'33','','','','','Married','','',''),(0000034,'34','','','','','Married','','',''),(0000035,'35','','','','','Married','','',''),(0000036,'36','','','','','Married','','',''),(0000037,'37','','','','','Married','','',''),(0000038,'38','','','','','Married','','',''),(0000039,'39','','','','','Married','','',''),(0000041,'41','','','','','Married','','',''),(0000042,'42','','','','','Married','','',''),(0000043,'43','','','','','Married','','',''),(0000044,'44','','','','','Married','','',''),(0000045,'45','','','','','Married','','',''),(0000046,'46','','','','','Married','','',''),(0000047,'47','','','','','Married','','',''),(0000050,'50','','','','','Married','','',''),(0000051,'51','','','','','Married','','',''),(0000052,'52','','','','','Married','','',''),(0000053,'53','','','','','Married','','',''),(0000054,'54','','','','','Married','','',''),(0000055,'55','','','','','Married','','',''),(0000056,'56','','','','','Married','','',''),(0000057,'57','','','','','Married','','',''),(0000058,'58','','','','','Married','','',''),(0000059,'59','','','','','Married','','',''),(0000060,'60','','','','','Married','','',''),(0000061,'61','','','','','Married','','',''),(0000062,'62','','','','','Married','','',''),(0000063,'63','','','','','Married','','',''),(0000065,'65','','','','','Married','','',''),(0000067,'67','','','','','Married','','',''),(0000071,'71','','','','','Married','','',''),(0000072,'72','','','','','Married','','',''),(0000073,'73','','','','','Married','','',''),(0000074,'74','','','','','Married','','',''),(0000075,'75','','','','','Married','','',''),(0000076,'76','','','','','Married','','',''),(0000077,'77','','','','','Married','','',''),(0000078,'78','','','','','Married','','',''),(0000079,'79','','','','','Married','','',''),(0000080,'80','','','','','Married','','',''),(0000081,'81','','','','','Married','','',''),(0000082,'82','','','','','Married','','',''),(0000083,'83','','','','','Married','','',''),(0000084,'84','','','','','Married','','',''),(0000085,'85','','','','','Married','','',''),(0000087,'87','','','','','Married','','',''),(0000088,'88','','','','','Married','','',''),(0000089,'89','','','','','Married','','',''),(0000090,'90','','','','','Married','','',''),(0000091,'91','','','','','Married','','',''),(0000092,'92','','','','','Married','','',''),(0000093,'93','','','','','Married','','',''),(0000095,'95','','','','','Married','','',''),(0000096,'96','','','','','Married','','',''),(0000097,'97','','','','','Married','','',''),(0000098,'98','','','','','Married','','',''),(0000099,'99','','','','','Married','','',''),(0000101,'101','','','','','Married','','',''),(0000102,'102','','','','','Married','','',''),(0000103,'103','','','','','Married','','',''),(0000105,'105','','','','','Married','','',''),(0000106,'106','','','','','Married','','',''),(0000107,'107','','','','','Married','','',''),(0000108,'108','','','','','Married','','',''),(0000109,'109','','','','','Married','','',''),(0000110,'110','','','','','Married','','',''),(0000111,'111','','','','','Married','','',''),(0000112,'112','','','','','Married','','',''),(0000114,'114','','','','','Married','','',''),(0000116,'116','','','','','Married','','',''),(0000117,'117','','','','','Married','','',''),(0000118,'118','','','','','Married','','',''),(0000121,'121','','','','','Married','','',''),(0000123,'123','','','','','Married','','',''),(0000124,'124','','','','','Married','','',''),(0000125,'125','','','','','Married','','',''),(0000126,'126','','','','','Married','','',''),(0000128,'128','','','','','Married','','',''),(0000129,'129','','','','','Married','','',''),(0000130,'130','','','','','Married','','',''),(0000131,'131','','','','','Married','','',''),(0000132,'132','','','','','Married','','',''),(0000134,'134','','','','','Married','','',''),(0000135,'135','','','','','Married','','',''),(0000137,'137','','','','','Married','','',''),(0000138,'138','','','','','Married','','',''),(0000139,'139','','','','','Married','','',''),(0000140,'140','','','','','Married','','',''),(0000141,'141','','','','','Married','','',''),(0000142,'142','','','','','Married','','',''),(0000143,'143','','','','','Married','','',''),(0000145,'145','','','','','Married','','',''),(0000146,'146','','','','','Married','','',''),(0000147,'147','','','','','Married','','',''),(0000148,'148','','','','','Married','','',''),(0000149,'149','','','','','Married','','',''),(0000150,'150','','','','','Married','','',''),(0000151,'151','','','','','Married','','',''),(0000152,'152','','','','','Married','','',''),(0000153,'153','','','','','Married','','',''),(0000154,'154','','','','','Married','','',''),(0000155,'155','','','','','Married','','',''),(0000156,'156','','','','','Married','','',''),(0000157,'157','','','','','Married','','',''),(0000158,'158','','','','','Married','','',''),(0000159,'159','','','','','Married','','',''),(0000160,'160','','','','','Married','','',''),(0000161,'161','','','','','Married','','',''),(0000162,'162','','','','','Married','','',''),(0000163,'163','','','','','Married','','',''),(0000164,'164','','','','','Married','','',''),(0000165,'165','','','','','Married','','',''),(0000166,'166','','','','','Married','','',''),(0000167,'167','','','','','Married','','',''),(0000168,'168','','','','','Married','','',''),(0000169,'169','','','','','Married','','',''),(0000170,'170','','','','','Married','','',''),(0000171,'171','','','','','Married','','',''),(0000172,'172','','','','','Married','','',''),(0000173,'173','','','','','Married','','',''),(0000174,'174','','','','','Married','','',''),(0000175,'175','','','','','Married','','',''),(0000176,'176','','','','','Married','','',''),(0000177,'177','','','','','Married','','',''),(0000178,'178','','','','','Married','','',''),(0000179,'179','','','','','Married','','',''),(0000180,'180','','','','','Married','','',''),(0000181,'181','','','','','Married','','',''),(0000182,'182','','','','','Married','','',''),(0000185,'185','','','','','Married','','',''),(0000187,'187','','','','','Married','','',''),(0000188,'188','','','','','Married','','',''),(0000189,'189','','','','','Married','','',''),(0000190,'190','','','','','Married','','',''),(0000191,'191','','','','','Married','','',''),(0000193,'193','','','','','Married','','',''),(0000194,'194','','','','','Married','','',''),(0000195,'195','','','','','Married','','',''),(0000196,'196','','','','','Married','','',''),(0000197,'197','','','','','Married','','',''),(0000198,'198','','','','','Married','','',''),(0000199,'199','','','','','Married','','',''),(0000200,'200','','','','','Married','','',''),(0000201,'201','','','','','Married','','',''),(0000202,'202','','','','','Married','','',''),(0000204,'204','','','','','Married','','',''),(0000205,'205','','','','','Married','','',''),(0000206,'206','','','','','Married','','',''),(0000207,'207','','','','','Married','','',''),(0000208,'208','','','','','Married','','',''),(0000210,'210','','','','','Married','','',''),(0000211,'211','','','','','Married','','',''),(0000212,'212','','','','','Married','','',''),(0000213,'213','','','','','Married','','',''),(0000214,'214','','','','','Married','','',''),(0000215,'215','','','','','Married','','',''),(0000216,'216','','','','','Married','','',''),(0000221,'221','','','','','Married','','',''),(0000222,'222','','','','','Married','','',''),(0000223,'223','','','','','Married','','',''),(0000224,'224','','','','','Married','','',''),(0000225,'225','','','','','Married','','',''),(0000227,'227','','','','','Married','','',''),(0000228,'228','','','','','Married','','',''),(0000229,'229','','','','','Married','','',''),(0000230,'230','','','','','Married','','',''),(0000231,'231','','','','','Married','','',''),(0000232,'232','','','','','Married','','',''),(0000234,'234','','','','','Married','','',''),(0000235,'235','','','','','Married','','',''),(0000236,'236','','','','','Married','','',''),(0000237,'237','','','','','Married','','',''),(0000238,'238','','','','','Married','','',''),(0000239,'239','','','','','Married','','',''),(0000240,'240','','','','','Married','','',''),(0000241,'241','','','','','Married','','',''),(0000244,'244','','','','','Married','','',''),(0000246,'246','','','','','Married','','',''),(0000247,'247','','','','','Married','','',''),(0000248,'248','','','','','Married','','',''),(0000249,'249','','','','','Married','','',''),(0000250,'250','','','','','Married','','',''),(0000251,'251','','','','','Married','','',''),(0000252,'252','','','','','Married','','',''),(0000253,'253','','','','','Married','','',''),(0000254,'254','','','','','Married','','',''),(0000256,'256','','','','','Married','','',''),(0000257,'257','','','','','Married','','',''),(0000258,'258','','','','','Married','','',''),(0000259,'259','','','','','Married','','',''),(0000260,'260','','','','','Married','','',''),(0000261,'261','','','','','Married','','',''),(0000262,'262','','','','','Married','','',''),(0000263,'263','','','','','Married','','',''),(0000264,'264','','','','','Married','','',''),(0000265,'265','','','','','Married','','',''),(0000267,'267','','','','','Married','','',''),(0000268,'268','','','','','Married','','',''),(0000269,'269','','','','','Married','','',''),(0000270,'270','','','','','Married','','',''),(0000271,'271','','','','','Married','','',''),(0000272,'272','','','','','Married','','',''),(0000273,'273','','','','','Married','','',''),(0000274,'274','','','','','Married','','',''),(0000275,'275','','','','','Married','','',''),(0000276,'276','','','','','Married','','',''),(0000279,'279','','','','','Married','','',''),(0000282,'282','','','','','Married','','',''),(0000283,'283','','','','','Married','','',''),(0000284,'284','','','','','Married','','',''),(0000285,'285','','','','','Married','','',''),(0000287,'287','','','','','Married','','',''),(0000288,'288','','','','','Married','','',''),(0000289,'289','','','','','Married','','',''),(0000292,'292','','','','','Married','','',''),(0000293,'293','','','','','Married','','',''),(0000294,'294','','','','','Married','','',''),(0000295,'295','','','','','Married','','',''),(0000296,'296','','','','','Married','','',''),(0000297,'297','','','','','Married','','',''),(0000298,'298','','','','','Married','','',''),(0000299,'299','','','','','Married','','',''),(0000300,'300','','','','','Married','','',''),(0000303,'303','','','','','Married','','',''),(0000304,'304','','','','','Married','','',''),(0000305,'305','','','','','Married','','',''),(0000307,'307','','','','','Married','','',''),(0000308,'308','','','','','Married','','',''),(0000309,'309','','','','','Married','','',''),(0000310,'310','','','','','Married','','',''),(0000312,'312','','','','','Married','','',''),(0000313,'313','','','','','Married','','',''),(0000314,'314','','','','','Married','','',''),(0000315,'315','','','','','Married','','',''),(0000316,'316','','','','','Married','','',''),(0000317,'317','','','','','Married','','',''),(0000318,'318','','','','','Married','','',''),(0000320,'320','','','','','Married','','',''),(0000321,'321','','','','','Married','','',''),(0000322,'322','','','','','Married','','',''),(0000325,'325','','','','','Married','','',''),(0000326,'326','','','','','Married','','',''),(0000327,'327','','','','','Married','','',''),(0000328,'328','','','','','Married','','',''),(0000329,'329','','','','','Married','','',''),(0000330,'330','','','','','Married','','',''),(0000331,'331','','','','','Married','','',''),(0000332,'332','','','','','Married','','',''),(0000333,'333','','','','','Married','','',''),(0000334,'334','','','','','Married','','',''),(0000335,'335','','','','','Married','','',''),(0000336,'336','','','','','Married','','',''),(0000337,'337','','','','','Married','','',''),(0000338,'338','','','','','Married','','',''),(0000339,'339','','','','','Married','','',''),(0000340,'340','','','','','Married','','',''),(0000341,'341','','','','','Married','','',''),(0000342,'342','','','','','Married','','',''),(0000344,'344','','','','','Married','','',''),(0000345,'345','','','','','Married','','',''),(0000346,'346','','','','','Married','','',''),(0000347,'347','','','','','Married','','',''),(0000348,'348','','','','','Married','','',''),(0000349,'349','','','','','Married','','',''),(0000350,'350','','','','','Married','','',''),(0000351,'351','','','','','Married','','',''),(0000352,'352','','','','','Married','','',''),(0000353,'353','','','','','Married','','',''),(0000354,'354','','','','','Married','','',''),(0000355,'355','','','','','Married','','',''),(0000356,'356','','','','','Married','','',''),(0000357,'357','','','','','Married','','',''),(0000358,'358','','','','','Married','','',''),(0000360,'360','','','','','Married','','',''),(0000361,'361','','','','','Married','','',''),(0000363,'363','','','','','Married','','',''),(0000364,'364','','','','','Married','','',''),(0000365,'365','','','','','Married','','',''),(0000366,'366','','','','','Married','','',''),(0000367,'367','','','','','Married','','',''),(0000368,'368','','','','','Married','','',''),(0000369,'369','','','','','Married','','',''),(0000370,'370','','','','','Married','','',''),(0000371,'371','','','','','Married','','',''),(0000372,'372','','','','','Married','','',''),(0000373,'373','','','','','Married','','',''),(0000374,'374','','','','','Married','','',''),(0000376,'376','','','','','Married','','',''),(0000377,'377','','','','','Married','','',''),(0000378,'378','','','','','Married','','',''),(0000379,'379','','','','','Married','','',''),(0000380,'380','','','','','Married','','',''),(0000381,'381','','','','','Married','','',''),(0000382,'382','','','','','Married','','',''),(0000383,'383','','','','','Married','','',''),(0000384,'384','','','','','Married','','',''),(0000385,'385','','','','','Married','','',''),(0000386,'386','','','','','Married','','',''),(0000387,'387','','','','','Married','','',''),(0000389,'389','','','','','Married','','',''),(0000390,'390','','','','','Married','','',''),(0000391,'391','','','','','Married','','',''),(0000392,'392','','','','','Married','','',''),(0000393,'393','','','','','Married','','',''),(0000394,'394','','','','','Married','','',''),(0000395,'395','','','','','Married','','',''),(0000396,'396','','','','','Married','','',''),(0000398,'398','','','','','Married','','',''),(0000399,'399','','','','','Married','','',''),(0000400,'400','','','','','Married','','',''),(0000403,'403','','','','','Married','','',''),(0000404,'404','','','','','Married','','',''),(0000405,'405','','','','','Married','','',''),(0000406,'406','','','','','Married','','',''),(0000407,'407','','','','','Married','','',''),(0000408,'408','','','','','Married','','',''),(0000409,'409','','','','','Married','','',''),(0000410,'410','','','','','Married','','',''),(0000411,'411','','','','','Married','','',''),(0000412,'412','','','','','Married','','',''),(0000413,'413','','','','','Married','','',''),(0000414,'414','','','','','Married','','',''),(0000415,'415','','','','','Married','','',''),(0000416,'416','','','','','Married','','',''),(0000418,'418','','','','','Married','','',''),(0000419,'419','','','','','Married','','',''),(0000422,'422','','','','','Married','','',''),(0000425,'425','','','','','Married','','',''),(0000426,'426','','','','','Married','','',''),(0000427,'427','','','','','Married','','',''),(0000429,'429','','','','','Married','','',''),(0000430,'430','','','','','Married','','',''),(0000431,'431','','','','','Married','','',''),(0000432,'432','','','','','Married','','',''),(0000433,'433','','','','','Married','','',''),(0000434,'434','','','','','Married','','',''),(0000435,'435','','','','','Married','','',''),(0000436,'436','','','','','Married','','',''),(0000437,'437','','','','','Married','','',''),(0000438,'438','','','','','Married','','',''),(0000439,'439','','','','','Married','','',''),(0000440,'440','','','','','Married','','',''),(0000441,'441','','','','','Married','','',''),(0000444,'444','','','','','Married','','',''),(0000445,'445','','','','','Married','','',''),(0000446,'446','','','','','Married','','',''),(0000447,'447','','','','','Married','','',''),(0000448,'448','','','','','Married','','',''),(0000449,'449','','','','','Married','','',''),(0000450,'450','','','','','Married','','',''),(0000451,'451','','','','','Married','','',''),(0000452,'452','','','','','Married','','',''),(0000453,'453','','','','','Married','','',''),(0000454,'454','','','','','Married','','',''),(0000456,'456','','','','','Married','','',''),(0000457,'457','','','','','Married','','',''),(0000460,'460','','','','','Married','','',''),(0000461,'461','','','','','Married','','',''),(0000462,'462','','','','','Married','','',''),(0000463,'463','','','','','Married','','',''),(0000464,'464','','','','','Married','','',''),(0000466,'466','','','','','Married','','',''),(0000467,'467','','','','','Married','','',''),(0000468,'468','','','','','Married','','',''),(0000469,'469','','','','','Married','','',''),(0000470,'470','','','','','Married','','',''),(0000471,'471','','','','','Married','','',''),(0000472,'472','','','','','Married','','',''),(0000473,'473','','','','','Married','','',''),(0000475,'475','','','','','Married','','',''),(0000476,'476','','','','','Married','','',''),(0000477,'477','','','','','Married','','',''),(0000479,'479','','','','','Married','','',''),(0000480,'480','','','','','Married','','',''),(0000482,'482','','','','','Married','','',''),(0000484,'484','','','','','Married','','',''),(0000486,'486','','','','','Married','','',''),(0000489,'489','','','','','Married','','',''),(0000490,'490','','','','','Married','','',''),(0000491,'491','','','','','Married','','',''),(0000492,'492','','','','','Married','','',''),(0000494,'494','','','','','Married','','',''),(0000495,'495','','','','','Married','','',''),(0000496,'496','','','','','Married','','',''),(0000497,'497','','','','','Married','','',''),(0000498,'498','','','','','Married','','',''),(0000499,'499','','','','','Married','','',''),(0000500,'500','','','','','Married','','',''),(0000501,'501','','','','','Married','','',''),(0000502,'502','','','','','Married','','',''),(0000504,'504','','','','','Married','','',''),(0000505,'505','','','','','Married','','',''),(0000506,'506','','','','','Married','','',''),(0000507,'507','','','','','Married','','',''),(0000508,'508','','','','','Married','','',''),(0000509,'509','','','','','Married','','',''),(0000511,'511','','','','','Married','','',''),(0000513,'513','','','','','Married','','',''),(0000514,'514','','','','','Married','','',''),(0000515,'515','','','','','Married','','',''),(0000516,'516','','','','','Married','','',''),(0000517,'517','','','','','Married','','',''),(0000518,'518','','','','','Married','','',''),(0000519,'519','','','','','Married','','',''),(0000520,'520','','','','','Married','','',''),(0000521,'521','','','','','Married','','',''),(0000524,'524','','','','','Married','','',''),(0000525,'525','','','','','Married','','',''),(0000526,'526','','','','','Married','','',''),(0000527,'527','','','','','Married','','',''),(0000528,'528','','','','','Married','','',''),(0000529,'529','','','','','Married','','',''),(0000532,'532','','','','','Married','','',''),(0000533,'533','','','','','Married','','',''),(0000534,'534','','','','','Married','','',''),(0000535,'535','','','','','Married','','',''),(0000536,'536','','','','','Married','','',''),(0000537,'537','','','','','Married','','',''),(0000538,'538','','','','','Married','','',''),(0000539,'539','','','','','Married','','',''),(0000541,'541','','','','','Married','','',''),(0000542,'542','','','','','Married','','',''),(0000543,'543','','','','','Married','','',''),(0000544,'544','','','','','Married','','',''),(0000545,'545','','','','','Married','','',''),(0000546,'546','','','','','Married','','',''),(0000547,'547','','','','','Married','','',''),(0000548,'548','','','','','Married','','',''),(0000549,'549','','','','','Married','','',''),(0000550,'550','','','','','Married','','',''),(0000551,'551','','','','','Married','','',''),(0000552,'552','','','','','Married','','',''),(0000553,'553','','','','','Married','','',''),(0000554,'554','','','','','Married','','',''),(0000555,'555','','','','','Married','','',''),(0000556,'556','','','','','Married','','',''),(0000557,'557','','','','','Married','','',''),(0000558,'558','','','','','Married','','',''),(0000559,'559','','','','','Married','','',''),(0000561,'561','','','','','Married','','',''),(0000562,'562','','','','','Married','','',''),(0000563,'563','','','','','Married','','',''),(0000564,'564','','','','','Married','','',''),(0000565,'565','','','','','Married','','',''),(0000566,'566','','','','','Married','','',''),(0000568,'568','','','','','Married','','',''),(0000569,'569','','','','','Married','','',''),(0000571,'571','','','','','Married','','',''),(0000573,'573','','','','','Married','','',''),(0000574,'574','','','','','Married','','',''),(0000575,'575','','','','','Married','','',''),(0000577,'577','','','','','Married','','',''),(0000578,'578','','','','','Married','','',''),(0000580,'580','','','','','Married','','',''),(0000582,'582','','','','','Married','','',''),(0000583,'583','','','','','Married','','',''),(0000584,'584','','','','','Married','','',''),(0000586,'586','','','','','Married','','',''),(0000587,'587','','','','','Married','','',''),(0000588,'588','','','','','Married','','',''),(0000589,'589','','','','','Married','','',''),(0000590,'590','','','','','Married','','',''),(0000591,'591','','','','','Married','','',''),(0000592,'592','','','','','Married','','',''),(0000593,'593','','','','','Married','','',''),(0000594,'594','','','','','Married','','',''),(0000595,'595','','','','','Married','','',''),(0000596,'596','','','','','Married','','',''),(0000598,'598','','','','','Married','','',''),(0000599,'599','','','','','Married','','',''),(0000600,'600','','','','','Married','','',''),(0000601,'601','','','','','Married','','',''),(0000602,'602','','','','','Married','','',''),(0000603,'603','','','','','Married','','',''),(0000604,'604','','','','','Married','','',''),(0000606,'606','','','','','Married','','',''),(0000607,'607','','','','','Married','','',''),(0000608,'608','','','','','Married','','',''),(0000609,'609','','','','','Married','','',''),(0000610,'610','','','','','Married','','',''),(0000612,'612','','','','','Married','','',''),(0000613,'613','','','','','Married','','',''),(0000614,'614','','','','','Married','','',''),(0000615,'615','','','','','Married','','',''),(0000616,'616','','','','','Married','','',''),(0000617,'617','','','','','Married','','',''),(0000618,'618','','','','','Married','','',''),(0000619,'619','','','','','Married','','',''),(0000620,'620','','','','','Married','','',''),(0000621,'621','','','','','Married','','',''),(0000622,'622','','','','','Married','','',''),(0000623,'623','','','','','Married','','',''),(0000625,'625','','','','','Married','','',''),(0000626,'626','','','','','Married','','',''),(0000627,'627','','','','','Married','','',''),(0000628,'628','','','','','Married','','',''),(0000629,'629','','','','','Married','','',''),(0000630,'630','','','','','Married','','',''),(0000631,'631','','','','','Married','','',''),(0000632,'632','','','','','Married','','',''),(0000633,'633','','','','','Married','','',''),(0000634,'634','','','','','Married','','',''),(0000635,'635','','','','','Married','','',''),(0000637,'637','','','','','Married','','',''),(0000638,'638','','','','','Married','','',''),(0000639,'639','','','','','Married','','',''),(0000641,'641','','','','','Married','','',''),(0000642,'642','','','','','Married','','',''),(0000643,'643','','','','','Married','','',''),(0000644,'644','','','','','Married','','',''),(0000645,'645','','','','','Married','','',''),(0000646,'646','','','','','Married','','',''),(0000647,'647','','','','','Married','','',''),(0000648,'648','','','','','Married','','',''),(0000649,'649','','','','','Married','','',''),(0000650,'650','','','','','Married','','',''),(0000651,'651','','','','','Married','','',''),(0000652,'652','','','','','Married','','',''),(0000654,'654','','','','','Married','','',''),(0000655,'655','','','','','Married','','',''),(0000656,'656','','','','','Married','','',''),(0000657,'657','','','','','Married','','',''),(0000658,'658','','','','','Married','','',''),(0000659,'659','','','','','Married','','',''),(0000660,'660','','','','','Married','','',''),(0000661,'661','','','','','Married','','',''),(0000662,'662','','','','','Married','','',''),(0000663,'663','','','','','Married','','',''),(0000664,'664','','','','','Married','','',''),(0000669,'669','','','','','Married','','',''),(0000670,'670','','','','','Married','','',''),(0000671,'671','','','','','Married','','',''),(0000672,'672','','','','','Married','','',''),(0000673,'673','','','','','Married','','',''),(0000674,'674','','','','','Married','','',''),(0000675,'675','','','','','Married','','',''),(0000676,'676','','','','','Married','','',''),(0000677,'677','','','','','Married','','',''),(0000678,'678','','','','','Married','','',''),(0000679,'679','','','','','Married','','',''),(0000680,'680','','','','','Married','','',''),(0000681,'681','','','','','Married','','',''),(0000682,'682','','','','','Married','','',''),(0000683,'683','','','','','Married','','',''),(0000684,'684','','','','','Married','','',''),(0000685,'685','','','','','Married','','',''),(0000686,'686','','','','','Married','','',''),(0000687,'687','','','','','Married','','',''),(0000688,'688','','','','','Married','','',''),(0000689,'689','','','','','Married','','',''),(0000690,'690','','','','','Married','','',''),(0000691,'691','','','','','Married','','',''),(0000692,'692','','','','','Married','','',''),(0000693,'693','','','','','Married','','',''),(0000694,'694','','','','','Married','','',''),(0000695,'695','','','','','Married','','',''),(0000696,'696','','','','','Married','','',''),(0000698,'698','','','','','Married','','',''),(0000699,'699','','','','','Married','','',''),(0000700,'700','','','','','Married','','',''),(0000701,'701','','','','','Married','','',''),(0000702,'702','','','','','Married','','',''),(0000704,'704','','','','','Married','','',''),(0000705,'705','','','','','Married','','',''),(0000706,'706','','','','','Married','','',''),(0000707,'707','','','','','Married','','',''),(0000708,'708','','','','','Married','','',''),(0000709,'709','','','','','Married','','',''),(0000710,'710','','','','','Married','','',''),(0000711,'711','','','','','Married','','',''),(0000712,'712','','','','','Married','','',''),(0000713,'713','','','','','Married','','',''),(0000714,'714','','','','','Married','','',''),(0000715,'715','','','','','Married','','',''),(0000716,'716','','','','','Married','','',''),(0000717,'717','','','','','Married','','',''),(0000718,'718','','','','','Married','','',''),(0000719,'719','','','','','Married','','',''),(0000720,'720','','','','','Married','','',''),(0000721,'721','','','','','Married','','',''),(0000722,'722','','','','','Married','','',''),(0000723,'723','','','','','Married','','',''),(0000724,'724','','','','','Married','','',''),(0000725,'725','','','','','Married','','',''),(0000726,'726','','','','','Married','','',''),(0000727,'727','','','','','Married','','',''),(0000728,'728','','','','','Married','','',''),(0000729,'729','','','','','Married','','',''),(0000730,'730','','','','','Married','','',''),(0000731,'731','','','','','Married','','',''),(0000732,'732','','','','','Married','','',''),(0000733,'733','','','','','Married','','',''),(0000734,'734','','','','','Married','','',''),(0000735,'735','','','','','Married','','',''),(0000736,'736','','','','','Married','','',''),(0000737,'737','','','','','Married','','',''),(0000738,'738','','','','','Married','','',''),(0000739,'739','','','','','Married','','',''),(0000740,'740','','','','','Married','','',''),(0000741,'741','','','','','Married','','',''),(0000742,'742','','','','','Married','','',''),(0000743,'743','','','','','Married','','',''),(0000744,'744','','','','','Married','','',''),(0000746,'746','','','','','Married','','',''),(0000747,'747','','','','','Married','','',''),(0000748,'748','','','','','Married','','',''),(0000749,'749','','','','','Married','','',''),(0000750,'750','','','','','Married','','',''),(0000751,'751','','','','','Married','','',''),(0000752,'752','','','','','Married','','',''),(0000753,'753','','','','','Married','','',''),(0000754,'754','','','','','Married','','',''),(0000755,'755','','','','','Married','','',''),(0000756,'756','','','','','Married','','',''),(0000757,'757','','','','','Married','','',''),(0000759,'759','','','','','Married','','',''),(0000760,'760','','','','','Married','','',''),(0000761,'761','','','','','Married','','',''),(0000762,'762','','','','','Married','','',''),(0000763,'763','','','','','Married','','',''),(0000764,'764','','','','','Married','','',''),(0000765,'765','','','','','Married','','',''),(0000767,'767','','','','','Married','','',''),(0000768,'768','','','','','Married','','',''),(0000769,'769','','','','','Married','','',''),(0000770,'770','','','','','Married','','',''),(0000771,'771','','','','','Married','','',''),(0000772,'772','','','','','Married','','',''),(0000773,'773','','','','','Married','','',''),(0000774,'774','','','','','Married','','',''),(0000775,'775','','','','','Married','','',''),(0000776,'776','','','','','Married','','',''),(0000777,'777','','','','','Married','','',''),(0000778,'778','','','','','Married','','',''),(0000779,'779','','','','','Married','','',''),(0000780,'780','','','','','Married','','',''),(0000781,'781','','','','','Married','','',''),(0000782,'782','','','','','Married','','',''),(0000783,'783','','','','','Married','','',''),(0000784,'784','','','','','Married','','',''),(0000785,'785','','','','','Married','','',''),(0000786,'786','','','','','Married','','',''),(0000787,'787','','','','','Married','','',''),(0000788,'788','','','','','Married','','',''),(0000789,'789','','','','','Married','','',''),(0000790,'790','','','','','Married','','',''),(0000791,'791','','','','','Married','','',''),(0000792,'792','','','','','Married','','',''),(0000793,'793','','','','','Married','','',''),(0000794,'794','','','','','Married','','',''),(0000795,'795','','','','','Married','','',''),(0000796,'796','','','','','Married','','',''),(0000797,'797','','','','','Married','','',''),(0000798,'798','','','','','Married','','',''),(0000799,'799','','','','','Married','','',''),(0000800,'800','','','','','Married','','',''),(0000801,'801','','','','','Married','','',''),(0000802,'802','','','','','Married','','',''),(0000803,'803','','','','','Married','','',''),(0000804,'804','','','','','Married','','',''),(0000805,'805','','','','','Married','','',''),(0000806,'806','','','','','Married','','',''),(0000807,'807','','','','','Married','','',''),(0000808,'808','','','','','Married','','',''),(0000809,'809','','','','','Married','','',''),(0000810,'810','','','','','Married','','',''),(0000811,'811','','','','','Married','','',''),(0000812,'812','','','','','Married','','',''),(0000813,'813','','','','','Married','','',''),(0000814,'814','','','','','Married','','',''),(0000815,'815','','','','','Married','','',''),(0000816,'816','','','','','Married','','',''),(0000817,'817','','','','','Married','','',''),(0000818,'818','','','','','Married','','',''),(0000819,'819','','','','','Married','','',''),(0000820,'820','','','','','Married','','',''),(0000821,'821','','','','','Married','','',''),(0000822,'822','','','','','Married','','',''),(0000823,'823','','','','','Married','','',''),(0000824,'824','','','','','Married','','',''),(0000825,'825','','','','','Married','','',''),(0000826,'826','','','','','Married','','',''),(0000827,'827','','','','','Married','','',''),(0000828,'828','','','','','Married','','',''),(0000829,'829','','','','','Married','','',''),(0000830,'830','','','','','Married','','',''),(0000831,'831','','','','','Married','','',''),(0000832,'832','','','','','Married','','',''),(0000833,'833','','','','','Married','','',''),(0000834,'834','','','','','Married','','',''),(0000835,'835','','','','','Married','','',''),(0000836,'836','','','','','Married','','',''),(0000837,'837','','','','','Married','','',''),(0000838,'838','','','','','Married','','',''),(0000839,'839','','','','','Married','','',''),(0000840,'840','','','','','Married','','',''),(0000841,'841','','','','','Married','','',''),(0000842,'842','','','','','Married','','',''),(0000843,'843','','','','','Married','','',''),(0000844,'844','','','','','Married','','',''),(0000845,'845','','','','','Married','','',''),(0000846,'846','','','','','Married','','',''),(0000847,'847','','','','','Married','','',''),(0000848,'848','','','','','Married','','',''),(0000849,'849','','','','','Married','','',''),(0000850,'850','','','','','Married','','',''),(0000851,'851','','','','','Married','','',''),(0000852,'852','','','','','Married','','',''),(0000853,'853','','','','','Married','','','');

--
-- 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(2) 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 AUTO_INCREMENT=1656 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFamilyAdult`
--

INSERT INTO `gibbonFamilyAdult` VALUES (00000010,0000001,0000000148,'','Y',2,'Y','Y','Y','Y'),(00000011,0000001,0000000149,'','Y',1,'Y','Y','Y','Y'),(00000012,0000003,0000000152,'','Y',2,'Y','Y','Y','Y'),(00000013,0000003,0000000153,'','Y',1,'Y','Y','Y','Y'),(00000014,0000004,0000000154,'','Y',2,'Y','Y','Y','Y'),(00000015,0000004,0000000155,'','Y',1,'Y','Y','Y','Y'),(00000016,0000005,0000000157,'','Y',2,'Y','Y','Y','Y'),(00000017,0000005,0000000158,'','Y',1,'Y','Y','Y','Y'),(00000018,0000006,0000000159,'','Y',2,'Y','Y','Y','Y'),(00000019,0000006,0000000160,'','Y',1,'Y','Y','Y','Y'),(00000020,0000007,0000000161,'','Y',2,'Y','Y','Y','Y'),(00000021,0000007,0000000162,'','Y',1,'Y','Y','Y','Y'),(00000022,0000008,0000000163,'','Y',2,'Y','Y','Y','Y'),(00000023,0000008,0000000164,'','Y',1,'Y','Y','Y','Y'),(00000024,0000009,0000000165,'','Y',2,'Y','Y','Y','Y'),(00000025,0000009,0000000166,'','Y',1,'Y','Y','Y','Y'),(00000026,0000010,0000000167,'','Y',2,'Y','Y','Y','Y'),(00000027,0000010,0000000168,'','Y',1,'Y','Y','Y','Y'),(00000028,0000012,0000000172,'','Y',2,'Y','Y','Y','Y'),(00000029,0000012,0000000173,'','Y',1,'Y','Y','Y','Y'),(00000030,0000013,0000000175,'','Y',1,'Y','Y','Y','Y'),(00000031,0000013,0000000174,'','Y',2,'Y','Y','Y','Y'),(00000032,0000014,0000000176,'','Y',2,'Y','Y','Y','Y'),(00000033,0000014,0000000177,'','Y',1,'Y','Y','Y','Y'),(00000034,0000015,0000000178,'','Y',2,'Y','Y','Y','Y'),(00000035,0000015,0000000179,'','Y',1,'Y','Y','Y','Y'),(00000036,0000016,0000000180,'','Y',2,'Y','Y','Y','Y'),(00000037,0000016,0000000181,'','Y',1,'Y','Y','Y','Y'),(00000038,0000017,0000000182,'','Y',2,'Y','Y','Y','Y'),(00000039,0000017,0000000183,'','Y',1,'Y','Y','Y','Y'),(00000040,0000018,0000000184,'','Y',1,'Y','Y','Y','Y'),(00000041,0000019,0000000185,'','Y',2,'Y','Y','Y','Y'),(00000042,0000019,0000000186,'','Y',1,'Y','Y','Y','Y'),(00000043,0000020,0000000187,'','Y',2,'Y','Y','Y','Y'),(00000044,0000020,0000000188,'','Y',1,'Y','Y','Y','Y'),(00000045,0000021,0000000189,'','Y',2,'Y','Y','Y','Y'),(00000046,0000021,0000000190,'','Y',1,'Y','Y','Y','Y'),(00000047,0000022,0000000191,'','Y',2,'Y','Y','Y','Y'),(00000048,0000022,0000000192,'','Y',1,'Y','Y','Y','Y'),(00000049,0000023,0000000193,'','Y',2,'Y','Y','Y','Y'),(00000050,0000023,0000000194,'','Y',1,'Y','Y','Y','Y'),(00000051,0000024,0000000195,'','Y',2,'Y','Y','Y','Y'),(00000052,0000024,0000000196,'','Y',1,'Y','Y','Y','Y'),(00000053,0000025,0000000197,'','Y',2,'Y','Y','Y','Y'),(00000054,0000025,0000000198,'','Y',1,'Y','Y','Y','Y'),(00000055,0000026,0000000199,'','Y',2,'Y','Y','Y','Y'),(00000056,0000026,0000000200,'','Y',1,'Y','Y','Y','Y'),(00000057,0000027,0000000201,'','Y',2,'Y','Y','Y','Y'),(00000058,0000027,0000000202,'','Y',1,'Y','Y','Y','Y'),(00000059,0000028,0000000203,'','Y',2,'Y','Y','Y','Y'),(00000060,0000028,0000000204,'','Y',1,'Y','Y','Y','Y'),(00000063,0000030,0000000207,'','Y',2,'Y','Y','Y','Y'),(00000064,0000030,0000000208,'','Y',1,'Y','Y','Y','Y'),(00000067,0000032,0000000211,'','Y',2,'Y','Y','Y','Y'),(00000068,0000032,0000000212,'','Y',1,'Y','Y','Y','Y'),(00000069,0000033,0000000213,'','Y',2,'Y','Y','Y','Y'),(00000070,0000033,0000000214,'','Y',1,'Y','Y','Y','Y'),(00000071,0000034,0000000215,'','Y',2,'Y','Y','Y','Y'),(00000072,0000034,0000000216,'','Y',1,'Y','Y','Y','Y'),(00000073,0000035,0000000217,'','Y',2,'Y','Y','Y','Y'),(00000074,0000035,0000000218,'','Y',1,'Y','Y','Y','Y'),(00000075,0000036,0000000219,'','Y',2,'Y','Y','Y','Y'),(00000076,0000036,0000000220,'','Y',1,'Y','Y','Y','Y'),(00000077,0000037,0000000221,'','Y',2,'Y','Y','Y','Y'),(00000078,0000037,0000000222,'','Y',1,'Y','Y','Y','Y'),(00000079,0000038,0000000226,'','Y',2,'Y','Y','Y','Y'),(00000080,0000038,0000000227,'','Y',1,'Y','Y','Y','Y'),(00000081,0000039,0000000228,'','Y',2,'Y','Y','Y','Y'),(00000082,0000039,0000000229,'','Y',1,'Y','Y','Y','Y'),(00000083,0000041,0000000230,'','Y',2,'Y','Y','Y','Y'),(00000084,0000041,0000000231,'','Y',1,'Y','Y','Y','Y'),(00000085,0000042,0000000232,'','Y',2,'Y','Y','Y','Y'),(00000086,0000042,0000000233,'','Y',1,'Y','Y','Y','Y'),(00000087,0000043,0000000234,'','Y',2,'Y','Y','Y','Y'),(00000088,0000043,0000000235,'','Y',1,'Y','Y','Y','Y'),(00000089,0000044,0000000236,'','Y',2,'Y','Y','Y','Y'),(00000090,0000044,0000000237,'','Y',1,'Y','Y','Y','Y'),(00000091,0000045,0000000238,'','Y',2,'Y','Y','Y','Y'),(00000092,0000045,0000000239,'','Y',1,'Y','Y','Y','Y'),(00000093,0000046,0000000240,'','Y',2,'Y','Y','Y','Y'),(00000094,0000046,0000000241,'','Y',1,'Y','Y','Y','Y'),(00000095,0000047,0000000242,'','Y',2,'Y','Y','Y','Y'),(00000096,0000047,0000000243,'','Y',1,'Y','Y','Y','Y'),(00000099,0000050,0000000244,'','Y',2,'Y','Y','Y','Y'),(00000100,0000050,0000000245,'','Y',1,'Y','Y','Y','Y'),(00000101,0000051,0000000246,'','Y',2,'Y','Y','Y','Y'),(00000102,0000051,0000000247,'','Y',1,'Y','Y','Y','Y'),(00000103,0000052,0000000248,'','Y',2,'Y','Y','Y','Y'),(00000104,0000052,0000000249,'','Y',1,'Y','Y','Y','Y'),(00000105,0000053,0000000250,'','Y',2,'Y','Y','Y','Y'),(00000106,0000053,0000000251,'','Y',1,'Y','Y','Y','Y'),(00000107,0000054,0000000252,'','Y',1,'Y','Y','Y','Y'),(00000108,0000054,0000000253,'','Y',1,'Y','Y','Y','Y'),(00000109,0000055,0000000254,'','Y',2,'Y','Y','Y','Y'),(00000110,0000055,0000000255,'','Y',1,'Y','Y','Y','Y'),(00000111,0000056,0000000256,'','Y',1,'Y','Y','Y','Y'),(00000112,0000056,0000000257,'','Y',2,'Y','Y','Y','Y'),(00000115,0000058,0000000261,'','Y',2,'Y','Y','Y','Y'),(00000116,0000058,0000000262,'','Y',1,'Y','Y','Y','Y'),(00000117,0000059,0000000263,'','Y',2,'Y','Y','Y','Y'),(00000118,0000059,0000000264,'','Y',1,'Y','Y','Y','Y'),(00000119,0000060,0000000265,'','Y',2,'Y','Y','Y','Y'),(00000120,0000060,0000000266,'','Y',1,'Y','Y','Y','Y'),(00000121,0000061,0000000268,'','Y',1,'Y','Y','Y','Y'),(00000122,0000061,0000000267,'','Y',2,'Y','Y','Y','Y'),(00000123,0000062,0000000269,'','Y',2,'Y','Y','Y','Y'),(00000124,0000062,0000000146,'','Y',1,'Y','Y','Y','Y'),(00000125,0000063,0000000270,'','Y',2,'Y','Y','Y','Y'),(00000126,0000063,0000000271,'','Y',1,'Y','Y','Y','Y'),(00000127,0000065,0000000272,'','Y',2,'Y','Y','Y','Y'),(00000128,0000065,0000000273,'','Y',1,'Y','Y','Y','Y'),(00000129,0000067,0000000274,'','Y',2,'Y','Y','Y','Y'),(00000130,0000067,0000000275,'','Y',1,'Y','Y','Y','Y'),(00000131,0000071,0000000276,'','Y',2,'Y','Y','Y','Y'),(00000132,0000071,0000000277,'','Y',1,'Y','Y','Y','Y'),(00000133,0000072,0000000278,'','Y',2,'Y','Y','Y','Y'),(00000134,0000072,0000000279,'','Y',1,'Y','Y','Y','Y'),(00000135,0000073,0000000280,'','Y',2,'Y','Y','Y','Y'),(00000136,0000073,0000000281,'','Y',1,'Y','Y','Y','Y'),(00000137,0000074,0000000282,'','Y',2,'Y','Y','Y','Y'),(00000138,0000074,0000000283,'','Y',1,'Y','Y','Y','Y'),(00000139,0000075,0000000284,'','Y',2,'Y','Y','Y','Y'),(00000140,0000075,0000000285,'','Y',1,'Y','Y','Y','Y'),(00000141,0000076,0000000287,'','Y',1,'Y','Y','Y','Y'),(00000142,0000076,0000000286,'','Y',2,'Y','Y','Y','Y'),(00000143,0000078,0000000288,'','Y',2,'Y','Y','Y','Y'),(00000144,0000078,0000000289,'','Y',1,'Y','Y','Y','Y'),(00000145,0000079,0000000290,'','Y',2,'Y','Y','Y','Y'),(00000146,0000079,0000000291,'','Y',1,'Y','Y','Y','Y'),(00000147,0000080,0000000292,'','Y',2,'Y','Y','Y','Y'),(00000148,0000080,0000000293,'','Y',1,'Y','Y','Y','Y'),(00000149,0000081,0000000294,'','Y',2,'Y','Y','Y','Y'),(00000150,0000081,0000000295,'','Y',1,'Y','Y','Y','Y'),(00000151,0000082,0000000296,'','Y',2,'Y','Y','Y','Y'),(00000152,0000082,0000000297,'','Y',1,'Y','Y','Y','Y'),(00000153,0000083,0000000298,'','Y',1,'Y','Y','Y','Y'),(00000154,0000083,0000000299,'','Y',1,'Y','Y','Y','Y'),(00000155,0000084,0000000300,'','Y',2,'Y','Y','Y','Y'),(00000156,0000084,0000000301,'','Y',1,'Y','Y','Y','Y'),(00000157,0000085,0000000303,'','Y',1,'Y','Y','Y','Y'),(00000158,0000085,0000000302,'','Y',2,'Y','Y','Y','Y'),(00000161,0000087,0000000306,'','Y',2,'Y','Y','Y','Y'),(00000162,0000087,0000000307,'','Y',1,'Y','Y','Y','Y'),(00000163,0000088,0000000124,'','Y',1,'Y','Y','Y','Y'),(00000164,0000089,0000000308,'','Y',2,'Y','Y','Y','Y'),(00000165,0000089,0000000309,'','Y',1,'Y','Y','Y','Y'),(00000166,0000090,0000000310,'','Y',2,'Y','Y','Y','Y'),(00000167,0000090,0000000311,'','Y',1,'Y','Y','Y','Y'),(00000168,0000091,0000000312,'','Y',1,'Y','Y','Y','Y'),(00000169,0000092,0000000313,'','Y',2,'Y','Y','Y','Y'),(00000170,0000092,0000000314,'','Y',1,'Y','Y','Y','Y'),(00000171,0000077,0000000315,'','Y',2,'Y','Y','Y','Y'),(00000172,0000077,0000000316,'','Y',1,'Y','Y','Y','Y'),(00000173,0000093,0000000317,'','Y',2,'Y','Y','Y','Y'),(00000174,0000093,0000000318,'','Y',1,'Y','Y','Y','Y'),(00000177,0000095,0000000321,'','Y',2,'Y','Y','Y','Y'),(00000178,0000095,0000000322,'','Y',1,'Y','Y','Y','Y'),(00000179,0000096,0000000323,'','Y',2,'Y','Y','Y','Y'),(00000180,0000096,0000000324,'','Y',1,'Y','Y','Y','Y'),(00000181,0000097,0000000325,'','Y',2,'Y','Y','Y','Y'),(00000182,0000097,0000000326,'','Y',1,'Y','Y','Y','Y'),(00000183,0000098,0000000328,'','Y',1,'Y','Y','Y','Y'),(00000184,0000098,0000000327,'','Y',2,'Y','Y','Y','Y'),(00000185,0000099,0000000330,'','Y',1,'Y','Y','Y','Y'),(00000186,0000099,0000000329,'','Y',2,'Y','Y','Y','Y'),(00000189,0000101,0000000333,'','Y',2,'Y','Y','Y','Y'),(00000190,0000101,0000000334,'','Y',1,'Y','Y','Y','Y'),(00000191,0000102,0000000335,'','Y',2,'Y','Y','Y','Y'),(00000192,0000102,0000000336,'','Y',1,'Y','Y','Y','Y'),(00000193,0000103,0000000337,'','Y',2,'Y','Y','Y','Y'),(00000194,0000103,0000000338,'','Y',1,'Y','Y','Y','Y'),(00000195,0000105,0000000339,'','Y',2,'Y','Y','Y','Y'),(00000196,0000105,0000000340,'','Y',1,'Y','Y','Y','Y'),(00000197,0000106,0000000341,'','Y',2,'Y','Y','Y','Y'),(00000198,0000106,0000000342,'','Y',1,'Y','Y','Y','Y'),(00000199,0000107,0000000343,'','Y',2,'Y','Y','Y','Y'),(00000200,0000107,0000000344,'','Y',1,'Y','Y','Y','Y'),(00000201,0000108,0000000346,'','Y',2,'Y','Y','Y','Y'),(00000202,0000108,0000000347,'','Y',1,'Y','Y','Y','Y'),(00000203,0000011,0000000170,'','Y',2,'Y','Y','Y','Y'),(00000204,0000011,0000000171,'','Y',1,'Y','Y','Y','Y'),(00000205,0000109,0000000331,'','Y',2,'Y','Y','Y','Y'),(00000206,0000109,0000000332,'','Y',1,'Y','Y','Y','Y'),(00000207,0000110,0000000355,'','Y',2,'Y','Y','Y','Y'),(00000208,0000110,0000000356,'','Y',1,'Y','Y','Y','Y'),(00000209,0000111,0000000224,'','Y',1,'Y','Y','Y','Y'),(00000210,0000111,0000000225,'','Y',1,'Y','Y','Y','Y'),(00000211,0000112,0000000357,'','Y',2,'Y','Y','Y','Y'),(00000212,0000112,0000000358,'','Y',1,'Y','Y','Y','Y'),(00000213,0000114,0000000359,'','Y',2,'Y','Y','Y','Y'),(00000214,0000114,0000000360,'','Y',1,'Y','Y','Y','Y'),(00000215,0000116,0000000362,'','Y',2,'Y','Y','Y','Y'),(00000216,0000116,0000000363,'','Y',1,'Y','Y','Y','Y'),(00000218,0000117,0000000367,'','Y',1,'Y','Y','Y','Y'),(00000219,0000117,0000000366,'','Y',2,'Y','Y','Y','Y'),(00000220,0000118,0000000369,'','Y',1,'Y','Y','Y','Y'),(00000221,0000118,0000000368,'','Y',2,'Y','Y','Y','Y'),(00000222,0000121,0000000383,'','Y',1,'Y','Y','Y','Y'),(00000223,0000121,0000000384,'','Y',2,'Y','Y','Y','Y'),(00000226,0000123,0000000392,'','Y',2,'Y','Y','Y','Y'),(00000227,0000123,0000000391,'','Y',1,'Y','Y','Y','Y'),(00000230,0000124,0000000394,'','Y',1,'Y','Y','Y','Y'),(00000231,0000125,0000000410,'','Y',2,'Y','Y','Y','Y'),(00000232,0000125,0000000409,'','Y',1,'Y','Y','Y','Y'),(00000233,0000126,0000000402,'','Y',1,'Y','Y','Y','Y'),(00000234,0000128,0000000407,'','Y',1,'Y','Y','Y','Y'),(00000235,0000128,0000000404,'','Y',2,'Y','Y','Y','Y'),(00000236,0000129,0000000408,'','Y',1,'Y','Y','Y','Y'),(00000237,0000129,0000000406,'','Y',2,'Y','Y','Y','Y'),(00000238,0000130,0000000400,'','Y',1,'Y','Y','Y','Y'),(00000239,0000130,0000000401,'','Y',2,'Y','Y','Y','Y'),(00000240,0000131,0000000397,'','Y',1,'Y','Y','Y','Y'),(00000241,0000131,0000000398,'','Y',2,'Y','Y','Y','Y'),(00000242,0000124,0000000395,'','Y',2,'Y','Y','Y','Y'),(00000243,0000132,0000000414,'','Y',2,'Y','Y','Y','Y'),(00000244,0000132,0000000415,'','Y',1,'Y','Y','Y','Y'),(00000247,0000134,0000000421,'','Y',1,'Y','Y','Y','Y'),(00000248,0000134,0000000422,'','Y',2,'Y','Y','Y','Y'),(00000249,0000135,0000000425,'','Y',2,'Y','Y','Y','Y'),(00000250,0000135,0000000424,'','Y',1,'Y','Y','Y','Y'),(00000253,0000137,0000000431,'','Y',1,'Y','Y','Y','Y'),(00000254,0000137,0000000430,'','Y',2,'Y','Y','Y','Y'),(00000255,0000138,0000000433,'','Y',1,'Y','Y','Y','Y'),(00000256,0000138,0000000434,'','Y',2,'Y','Y','Y','Y'),(00000257,0000139,0000000436,'','Y',2,'Y','Y','Y','Y'),(00000258,0000139,0000000437,'','Y',1,'Y','Y','Y','Y'),(00000259,0000140,0000000439,'','Y',1,'Y','Y','Y','Y'),(00000260,0000140,0000000440,'','Y',2,'Y','Y','Y','Y'),(00000261,0000141,0000000442,'','Y',2,'Y','Y','Y','Y'),(00000262,0000141,0000000441,'','Y',1,'Y','Y','Y','Y'),(00000263,0000141,0000000444,'','Y',1,'Y','Y','Y','Y'),(00000264,0000142,0000000446,'','Y',2,'Y','Y','Y','Y'),(00000265,0000142,0000000447,'','Y',1,'Y','Y','Y','Y'),(00000266,0000143,0000000449,'','Y',2,'Y','Y','Y','Y'),(00000267,0000143,0000000450,'','Y',1,'Y','Y','Y','Y'),(00000268,0000145,0000000451,'','Y',1,'Y','Y','Y','Y'),(00000269,0000145,0000000453,'','Y',2,'Y','Y','Y','Y'),(00000270,0000146,0000000455,'','Y',2,'Y','Y','Y','Y'),(00000271,0000146,0000000456,'','Y',1,'Y','Y','Y','Y'),(00000272,0000147,0000000458,'','Y',2,'Y','Y','Y','Y'),(00000273,0000147,0000000460,'','Y',1,'Y','Y','Y','Y'),(00000274,0000148,0000000463,'','Y',1,'Y','Y','Y','Y'),(00000275,0000148,0000000462,'','Y',2,'Y','Y','Y','Y'),(00000276,0000149,0000000465,'','Y',2,'Y','Y','Y','Y'),(00000277,0000149,0000000466,'','Y',1,'Y','Y','Y','Y'),(00000278,0000150,0000000468,'','Y',2,'Y','Y','Y','Y'),(00000279,0000150,0000000469,'','Y',1,'Y','Y','Y','Y'),(00000280,0000151,0000000472,'','Y',1,'Y','Y','Y','Y'),(00000281,0000151,0000000471,'','Y',2,'Y','Y','Y','Y'),(00000282,0000152,0000000476,'','Y',1,'Y','Y','Y','Y'),(00000283,0000152,0000000475,'','Y',2,'Y','Y','Y','Y'),(00000284,0000153,0000000479,'','Y',1,'Y','Y','Y','Y'),(00000285,0000153,0000000478,'','Y',2,'Y','Y','Y','Y'),(00000286,0000154,0000000481,'','Y',2,'Y','Y','Y','Y'),(00000287,0000154,0000000482,'','Y',1,'Y','Y','Y','Y'),(00000288,0000155,0000000485,'','Y',1,'Y','Y','Y','Y'),(00000289,0000155,0000000484,'','Y',2,'Y','Y','Y','Y'),(00000290,0000156,0000000488,'','Y',1,'Y','Y','Y','Y'),(00000291,0000156,0000000487,'','Y',2,'Y','Y','Y','Y'),(00000292,0000157,0000000491,'','Y',1,'Y','Y','Y','Y'),(00000293,0000157,0000000490,'','Y',2,'Y','Y','Y','Y'),(00000294,0000158,0000000494,'','Y',2,'Y','Y','Y','Y'),(00000295,0000158,0000000495,'','Y',1,'Y','Y','Y','Y'),(00000296,0000159,0000000497,'','Y',1,'Y','Y','Y','Y'),(00000297,0000160,0000000500,'','Y',2,'Y','Y','Y','Y'),(00000298,0000160,0000000499,'','Y',1,'Y','Y','Y','Y'),(00000299,0000161,0000000502,'','Y',2,'Y','Y','Y','Y'),(00000300,0000161,0000000503,'','Y',1,'Y','Y','Y','Y'),(00000301,0000162,0000000507,'','Y',2,'Y','Y','Y','Y'),(00000302,0000162,0000000508,'','Y',1,'Y','Y','Y','Y'),(00000303,0000163,0000000511,'','Y',1,'Y','Y','Y','Y'),(00000304,0000163,0000000510,'','Y',2,'Y','Y','Y','Y'),(00000305,0000164,0000000516,'','Y',2,'Y','Y','Y','Y'),(00000306,0000164,0000000517,'','Y',1,'Y','Y','Y','Y'),(00000307,0000165,0000000520,'','Y',1,'Y','Y','Y','Y'),(00000308,0000165,0000000519,'','Y',2,'Y','Y','Y','Y'),(00000309,0000166,0000000522,'','Y',2,'Y','Y','Y','Y'),(00000310,0000166,0000000523,'','Y',1,'Y','Y','Y','Y'),(00000311,0000167,0000000526,'','Y',1,'Y','Y','Y','Y'),(00000312,0000167,0000000525,'','Y',2,'Y','Y','Y','Y'),(00000313,0000168,0000000529,'','Y',1,'Y','Y','Y','Y'),(00000314,0000168,0000000528,'','Y',2,'Y','Y','Y','Y'),(00000315,0000169,0000000531,'','Y',2,'Y','Y','Y','Y'),(00000316,0000169,0000000532,'','Y',1,'Y','Y','Y','Y'),(00000317,0000170,0000000534,'','Y',2,'Y','Y','Y','Y'),(00000318,0000170,0000000535,'','Y',1,'Y','Y','Y','Y'),(00000319,0000171,0000000537,'','Y',2,'Y','Y','Y','Y'),(00000320,0000171,0000000538,'','Y',1,'Y','Y','Y','Y'),(00000321,0000172,0000000541,'','Y',1,'Y','Y','Y','Y'),(00000322,0000172,0000000542,'','Y',2,'Y','Y','Y','Y'),(00000323,0000173,0000000544,'','Y',2,'Y','Y','Y','Y'),(00000324,0000173,0000000545,'','Y',1,'Y','Y','Y','Y'),(00000325,0000174,0000000548,'','Y',1,'Y','Y','Y','Y'),(00000326,0000174,0000000547,'','Y',2,'Y','Y','Y','Y'),(00000327,0000175,0000000550,'','Y',2,'Y','Y','Y','Y'),(00000328,0000175,0000000551,'','Y',1,'Y','Y','Y','Y'),(00000329,0000176,0000000554,'','Y',1,'Y','Y','Y','Y'),(00000330,0000176,0000000553,'','Y',2,'Y','Y','Y','Y'),(00000331,0000177,0000000556,'','Y',2,'Y','Y','Y','Y'),(00000332,0000177,0000000557,'','Y',1,'Y','Y','Y','Y'),(00000333,0000178,0000000560,'','Y',1,'Y','Y','Y','Y'),(00000334,0000178,0000000559,'','Y',2,'Y','Y','Y','Y'),(00000335,0000179,0000000562,'','Y',2,'Y','Y','Y','Y'),(00000336,0000179,0000000563,'','Y',1,'Y','Y','Y','Y'),(00000337,0000180,0000000427,'','Y',1,'Y','Y','Y','Y'),(00000338,0000180,0000000428,'','Y',2,'Y','Y','Y','Y'),(00000339,0000181,0000000570,'','Y',2,'Y','Y','Y','Y'),(00000340,0000181,0000000571,'','Y',1,'Y','Y','Y','Y'),(00000341,0000182,0000000572,'','Y',2,'Y','Y','Y','Y'),(00000342,0000182,0000000573,'','Y',1,'Y','Y','Y','Y'),(00000343,0000057,0000000575,'','Y',2,'Y','Y','Y','Y'),(00000344,0000057,0000000576,'','Y',1,'Y','Y','Y','Y'),(00000345,0000185,0000000151,'','Y',1,'Y','Y','Y','Y'),(00000347,0000185,0000000578,'','Y',2,'Y','Y','Y','Y'),(00000348,0000187,0000000583,'','Y',2,'Y','Y','Y','Y'),(00000349,0000188,0000000587,'','Y',2,'Y','Y','Y','Y'),(00000350,0000188,0000000586,'','Y',1,'Y','Y','Y','Y'),(00000351,0000187,0000000588,'','Y',1,'Y','Y','Y','Y'),(00000352,0000189,0000000121,'','Y',1,'Y','Y','Y','Y'),(00000353,0000200,0000000618,'','Y',2,'Y','Y','Y','Y'),(00000355,0000195,0000000620,'','Y',2,'Y','Y','Y','Y'),(00000356,0000195,0000000621,'','Y',1,'Y','Y','Y','Y'),(00000357,0000200,0000000619,'','Y',1,'Y','Y','Y','Y'),(00000358,0000190,0000000594,'','Y',2,'Y','Y','Y','Y'),(00000359,0000190,0000000595,'','Y',2,'Y','Y','Y','Y'),(00000360,0000198,0000000613,'','Y',2,'Y','Y','Y','Y'),(00000361,0000198,0000000612,'','Y',1,'Y','Y','Y','Y'),(00000362,0000196,0000000140,'','Y',1,'Y','Y','Y','Y'),(00000363,0000196,0000000608,'','Y',2,'Y','Y','Y','Y'),(00000364,0000197,0000000610,'','Y',1,'Y','Y','Y','Y'),(00000365,0000191,0000000598,'','Y',2,'Y','Y','Y','Y'),(00000366,0000191,0000000597,'','Y',1,'Y','Y','Y','Y'),(00000367,0000199,0000000616,'','Y',2,'Y','Y','Y','Y'),(00000368,0000199,0000000615,'','Y',1,'Y','Y','Y','Y'),(00000369,0000194,0000000603,'','Y',1,'Y','Y','Y','Y'),(00000370,0000194,0000000604,'','Y',1,'Y','Y','Y','Y'),(00000371,0000193,0000000623,'','Y',2,'Y','Y','Y','Y'),(00000372,0000193,0000000624,'','Y',1,'Y','Y','Y','Y'),(00000373,0000202,0000000630,'','Y',1,'Y','Y','Y','Y'),(00000374,0000202,0000000631,'','Y',2,'Y','Y','Y','Y'),(00000375,0000204,0000000637,'','Y',2,'Y','Y','Y','Y'),(00000376,0000204,0000000636,'','Y',1,'Y','Y','Y','Y'),(00000377,0000205,0000000639,'','Y',1,'Y','Y','Y','Y'),(00000378,0000206,0000000642,'','Y',2,'Y','Y','Y','Y'),(00000379,0000206,0000000641,'','Y',1,'Y','Y','Y','Y'),(00000380,0000201,0000000626,'','Y',2,'Y','Y','Y','Y'),(00000381,0000201,0000000627,'','Y',2,'Y','Y','Y','Y'),(00000382,0000223,0000000691,'','Y',1,'Y','Y','Y','Y'),(00000383,0000223,0000000692,'','Y',2,'Y','Y','Y','Y'),(00000384,0000207,0000000644,'','Y',2,'Y','Y','Y','Y'),(00000385,0000207,0000000645,'','Y',2,'Y','Y','Y','Y'),(00000387,0000208,0000000648,'','Y',1,'Y','Y','Y','Y'),(00000388,0000208,0000000647,'','Y',1,'Y','Y','Y','Y'),(00000391,0000210,0000000654,'','Y',2,'Y','Y','Y','Y'),(00000392,0000210,0000000653,'','Y',1,'Y','Y','Y','Y'),(00000393,0000211,0000000657,'','Y',2,'Y','Y','Y','Y'),(00000394,0000211,0000000656,'','Y',1,'Y','Y','Y','Y'),(00000395,0000212,0000000660,'','Y',2,'Y','Y','Y','Y'),(00000396,0000212,0000000659,'','Y',1,'Y','Y','Y','Y'),(00000397,0000213,0000000663,'','Y',2,'Y','Y','Y','Y'),(00000398,0000214,0000000665,'','Y',1,'Y','Y','Y','Y'),(00000399,0000214,0000000666,'','Y',2,'Y','Y','Y','Y'),(00000400,0000215,0000000669,'','Y',2,'Y','Y','Y','Y'),(00000401,0000215,0000000668,'','Y',1,'Y','Y','Y','Y'),(00000402,0000216,0000000672,'','Y',2,'Y','Y','Y','Y'),(00000403,0000216,0000000671,'','Y',1,'Y','Y','Y','Y'),(00000404,0000221,0000000685,'','Y',1,'Y','Y','Y','Y'),(00000405,0000222,0000000688,'','Y',1,'Y','Y','Y','Y'),(00000406,0000222,0000000687,'','Y',1,'Y','Y','Y','Y'),(00000407,0000224,0000000695,'','Y',1,'Y','Y','Y','Y'),(00000408,0000224,0000000694,'','Y',1,'Y','Y','Y','Y'),(00000409,0000225,0000000697,'','Y',1,'Y','Y','Y','Y'),(00000410,0000225,0000000698,'','Y',2,'Y','Y','Y','Y'),(00000411,0000227,0000000703,'','Y',1,'Y','Y','Y','Y'),(00000412,0000227,0000000704,'','Y',2,'Y','Y','Y','Y'),(00000413,0000228,0000000706,'','Y',1,'Y','Y','Y','Y'),(00000414,0000228,0000000707,'','Y',1,'Y','Y','Y','Y'),(00000415,0000229,0000000709,'','Y',1,'Y','Y','Y','Y'),(00000416,0000229,0000000710,'','Y',2,'Y','Y','Y','Y'),(00000417,0000230,0000000712,'','Y',2,'Y','Y','Y','Y'),(00000418,0000230,0000000713,'','Y',1,'Y','Y','Y','Y'),(00000419,0000231,0000000715,'','Y',1,'Y','Y','Y','Y'),(00000420,0000232,0000000717,'','Y',1,'Y','Y','Y','Y'),(00000421,0000232,0000000718,'','Y',2,'Y','Y','Y','Y'),(00000424,0000234,0000000723,'','Y',1,'Y','Y','Y','Y'),(00000425,0000234,0000000724,'','Y',1,'Y','Y','Y','Y'),(00000426,0000235,0000000726,'','Y',2,'Y','Y','Y','Y'),(00000427,0000235,0000000727,'','Y',1,'Y','Y','Y','Y'),(00000428,0000236,0000000729,'','Y',1,'Y','Y','Y','Y'),(00000429,0000236,0000000730,'','Y',2,'Y','Y','Y','Y'),(00000430,0000237,0000000732,'','Y',1,'Y','Y','Y','Y'),(00000431,0000237,0000000733,'','Y',1,'Y','Y','Y','Y'),(00000432,0000238,0000000735,'','Y',1,'Y','Y','Y','Y'),(00000433,0000238,0000000736,'','Y',1,'Y','Y','Y','Y'),(00000434,0000239,0000000738,'','Y',1,'Y','Y','Y','Y'),(00000435,0000239,0000000739,'','Y',2,'Y','Y','Y','Y'),(00000436,0000240,0000000741,'','Y',1,'Y','Y','Y','Y'),(00000437,0000241,0000000743,'','Y',2,'Y','Y','Y','Y'),(00000438,0000241,0000000744,'','Y',1,'Y','Y','Y','Y'),(00000443,0000244,0000000752,'','Y',1,'Y','Y','Y','Y'),(00000444,0000244,0000000753,'','Y',2,'Y','Y','Y','Y'),(00000447,0000246,0000000758,'','Y',1,'Y','Y','Y','Y'),(00000448,0000246,0000000759,'','Y',2,'Y','Y','Y','Y'),(00000449,0000247,0000000761,'','Y',1,'Y','Y','Y','Y'),(00000450,0000247,0000000762,'','Y',2,'Y','Y','Y','Y'),(00000451,0000248,0000000764,'','Y',2,'Y','Y','Y','Y'),(00000452,0000248,0000000765,'','Y',1,'Y','Y','Y','Y'),(00000453,0000249,0000000767,'','Y',2,'Y','Y','Y','Y'),(00000454,0000249,0000000768,'','Y',1,'Y','Y','Y','Y'),(00000455,0000250,0000000777,'','Y',2,'Y','Y','Y','Y'),(00000456,0000250,0000000778,'','Y',1,'Y','Y','Y','Y'),(00000457,0000251,0000000780,'','Y',1,'Y','Y','Y','Y'),(00000458,0000252,0000000782,'','Y',1,'Y','Y','Y','Y'),(00000459,0000252,0000000783,'','Y',2,'Y','Y','Y','Y'),(00000460,0000253,0000000785,'','Y',1,'Y','Y','Y','Y'),(00000461,0000253,0000000786,'','Y',2,'Y','Y','Y','Y'),(00000462,0000254,0000000788,'','Y',2,'Y','Y','Y','Y'),(00000463,0000254,0000000789,'','Y',1,'Y','Y','Y','Y'),(00000466,0000256,0000000794,'','Y',1,'Y','Y','Y','Y'),(00000467,0000256,0000000795,'','Y',2,'Y','Y','Y','Y'),(00000468,0000257,0000000797,'','Y',3,'Y','Y','Y','Y'),(00000469,0000257,0000000798,'','Y',1,'Y','Y','Y','Y'),(00000470,0000258,0000000800,'','Y',1,'Y','Y','Y','Y'),(00000472,0000259,0000000803,'','Y',2,'Y','Y','Y','Y'),(00000473,0000259,0000000804,'','Y',2,'Y','Y','Y','Y'),(00000474,0000260,0000000806,'','Y',1,'Y','Y','Y','Y'),(00000475,0000260,0000000807,'','Y',2,'Y','Y','Y','Y'),(00000476,0000261,0000000809,'','Y',1,'Y','Y','Y','Y'),(00000477,0000262,0000000815,'','Y',2,'Y','Y','Y','Y'),(00000478,0000262,0000000816,'','Y',1,'Y','Y','Y','Y'),(00000479,0000258,0000000801,'','Y',1,'Y','Y','Y','Y'),(00000480,0000263,0000000818,'','Y',1,'Y','Y','Y','Y'),(00000481,0000263,0000000819,'','Y',2,'Y','Y','Y','Y'),(00000482,0000264,0000000821,'','Y',2,'Y','Y','Y','Y'),(00000483,0000264,0000000822,'','Y',1,'Y','Y','Y','Y'),(00000486,0000265,0000000827,'','Y',2,'Y','Y','Y','Y'),(00000487,0000265,0000000828,'','Y',1,'Y','Y','Y','Y'),(00000488,0000267,0000000825,'','Y',2,'Y','Y','Y','Y'),(00000489,0000267,0000000600,'','Y',1,'Y','Y','Y','Y'),(00000490,0000268,0000000830,'','Y',1,'Y','Y','Y','Y'),(00000491,0000269,0000000833,'','Y',1,'Y','Y','Y','Y'),(00000492,0000269,0000000834,'','Y',2,'Y','Y','Y','Y'),(00000493,0000213,0000000835,'','Y',1,'Y','Y','Y','Y'),(00000494,0000270,0000000837,'','Y',2,'Y','Y','Y','Y'),(00000495,0000270,0000000838,'','Y',1,'Y','Y','Y','Y'),(00000496,0000271,0000000842,'','Y',1,'Y','Y','Y','Y'),(00000497,0000272,0000000844,'','Y',2,'Y','Y','Y','Y'),(00000498,0000272,0000000845,'','Y',1,'Y','Y','Y','Y'),(00000499,0000273,0000000847,'','Y',1,'Y','Y','Y','Y'),(00000500,0000273,0000000848,'','Y',2,'Y','Y','Y','Y'),(00000501,0000274,0000000850,'','Y',1,'Y','Y','Y','Y'),(00000502,0000274,0000000851,'','Y',2,'Y','Y','Y','Y'),(00000503,0000275,0000000853,'','Y',2,'Y','Y','Y','Y'),(00000504,0000275,0000000854,'','Y',1,'Y','Y','Y','Y'),(00000505,0000276,0000000856,'','Y',1,'Y','Y','Y','Y'),(00000506,0000201,0000000858,'','Y',1,'Y','Y','Y','Y'),(00000509,0000279,0000000864,'','Y',1,'Y','Y','Y','Y'),(00000510,0000279,0000000865,'','Y',2,'Y','Y','Y','Y'),(00000513,0000282,0000000877,'','Y',2,'Y','Y','Y','Y'),(00000514,0000282,0000000878,'','Y',1,'Y','Y','Y','Y'),(00000515,0000283,0000000881,'','Y',1,'Y','Y','Y','Y'),(00000516,0000283,0000000882,'','Y',2,'Y','Y','Y','Y'),(00000517,0000284,0000000884,'','Y',1,'Y','Y','Y','Y'),(00000518,0000285,0000000886,'','Y',1,'Y','Y','Y','Y'),(00000519,0000285,0000000887,'','Y',2,'Y','Y','Y','Y'),(00000521,0000287,0000000892,'','Y',1,'Y','Y','Y','Y'),(00000522,0000287,0000000893,'','Y',2,'Y','Y','Y','Y'),(00000523,0000288,0000000895,'','Y',1,'Y','Y','Y','Y'),(00000524,0000288,0000000896,'','Y',2,'Y','Y','Y','Y'),(00000525,0000289,0000000898,'','Y',1,'Y','Y','Y','Y'),(00000530,0000292,0000000906,'','Y',2,'Y','Y','Y','Y'),(00000531,0000293,0000000908,'','Y',1,'Y','Y','Y','Y'),(00000532,0000293,0000000909,'','Y',2,'Y','Y','Y','Y'),(00000533,0000294,0000000911,'','Y',2,'Y','Y','Y','Y'),(00000534,0000294,0000000912,'','Y',1,'Y','Y','Y','Y'),(00000535,0000295,0000000914,'','Y',1,'Y','Y','Y','Y'),(00000536,0000295,0000000915,'','Y',2,'Y','Y','Y','Y'),(00000537,0000296,0000000917,'','Y',2,'Y','Y','Y','Y'),(00000538,0000296,0000000918,'','Y',1,'Y','Y','Y','Y'),(00000539,0000297,0000000920,'','Y',2,'Y','Y','Y','Y'),(00000540,0000297,0000000921,'','Y',1,'Y','Y','Y','Y'),(00000541,0000298,0000000923,'','Y',1,'Y','Y','Y','Y'),(00000542,0000298,0000000924,'','Y',2,'Y','Y','Y','Y'),(00000543,0000299,0000000927,'','Y',1,'Y','Y','Y','Y'),(00000544,0000300,0000000929,'','Y',2,'Y','Y','Y','Y'),(00000545,0000300,0000000930,'','Y',1,'Y','Y','Y','Y'),(00000550,0000303,0000000939,'','Y',1,'Y','Y','Y','Y'),(00000551,0000303,0000000940,'','Y',2,'Y','Y','Y','Y'),(00000552,0000304,0000000942,'','Y',1,'Y','Y','Y','Y'),(00000553,0000304,0000000943,'','Y',2,'Y','Y','Y','Y'),(00000554,0000305,0000000945,'','Y',1,'Y','Y','Y','Y'),(00000555,0000305,0000000946,'','Y',2,'Y','Y','Y','Y'),(00000558,0000307,0000000951,'','Y',1,'Y','Y','Y','Y'),(00000559,0000307,0000000952,'','Y',2,'Y','Y','Y','Y'),(00000560,0000308,0000000954,'','Y',2,'Y','Y','Y','Y'),(00000561,0000309,0000000956,'','Y',1,'Y','Y','Y','Y'),(00000562,0000309,0000000957,'','Y',2,'Y','Y','Y','Y'),(00000563,0000310,0000000959,'','Y',1,'Y','Y','Y','Y'),(00000564,0000310,0000000960,'','Y',2,'Y','Y','Y','Y'),(00000567,0000312,0000000965,'','Y',1,'Y','Y','Y','Y'),(00000568,0000312,0000000966,'','Y',2,'Y','Y','Y','Y'),(00000569,0000313,0000000968,'','Y',1,'Y','Y','Y','Y'),(00000570,0000313,0000000969,'','Y',2,'Y','Y','Y','Y'),(00000571,0000314,0000000972,'','Y',2,'Y','Y','Y','Y'),(00000572,0000314,0000000973,'','Y',1,'Y','Y','Y','Y'),(00000573,0000315,0000000975,'','Y',1,'Y','Y','Y','Y'),(00000574,0000315,0000000976,'','Y',2,'Y','Y','Y','Y'),(00000575,0000316,0000000978,'','Y',2,'Y','Y','Y','Y'),(00000576,0000316,0000000979,'','Y',1,'Y','Y','Y','Y'),(00000577,0000317,0000000981,'','Y',1,'Y','Y','Y','Y'),(00000578,0000317,0000000982,'','Y',2,'Y','Y','Y','Y'),(00000579,0000318,0000000984,'','Y',1,'Y','Y','Y','Y'),(00000580,0000318,0000000985,'','Y',2,'Y','Y','Y','Y'),(00000582,0000320,0000000990,'','Y',1,'Y','Y','Y','Y'),(00000583,0000320,0000000991,'','Y',2,'Y','Y','Y','Y'),(00000584,0000321,0000000993,'','Y',1,'Y','Y','Y','Y'),(00000585,0000322,0000000995,'','Y',1,'Y','Y','Y','Y'),(00000586,0000322,0000000996,'','Y',2,'Y','Y','Y','Y'),(00000591,0000325,0000001004,'','Y',1,'Y','Y','Y','Y'),(00000592,0000325,0000001005,'','Y',2,'Y','Y','Y','Y'),(00000593,0000326,0000001007,'','Y',1,'Y','Y','Y','Y'),(00000594,0000327,0000001009,'','Y',1,'Y','Y','Y','Y'),(00000595,0000327,0000001010,'','Y',2,'Y','Y','Y','Y'),(00000596,0000328,0000001012,'','Y',1,'Y','Y','Y','Y'),(00000597,0000328,0000001013,'','Y',1,'Y','Y','Y','Y'),(00000598,0000329,0000001015,'','Y',1,'Y','Y','Y','Y'),(00000599,0000330,0000001017,'','Y',1,'Y','Y','Y','Y'),(00000600,0000330,0000001018,'','Y',2,'Y','Y','Y','Y'),(00000601,0000331,0000001020,'','Y',1,'Y','Y','Y','Y'),(00000602,0000331,0000001021,'','Y',2,'Y','Y','Y','Y'),(00000603,0000332,0000001023,'','Y',1,'Y','Y','Y','Y'),(00000604,0000332,0000001024,'','Y',2,'Y','Y','Y','Y'),(00000605,0000333,0000001026,'','Y',1,'Y','Y','Y','Y'),(00000606,0000333,0000001027,'','Y',2,'Y','Y','Y','Y'),(00000607,0000334,0000001029,'','Y',1,'Y','Y','Y','Y'),(00000608,0000334,0000001030,'','Y',2,'Y','Y','Y','Y'),(00000609,0000335,0000001032,'','Y',1,'Y','Y','Y','Y'),(00000610,0000335,0000001033,'','Y',2,'Y','Y','Y','Y'),(00000611,0000336,0000001035,'','Y',1,'Y','Y','Y','Y'),(00000612,0000336,0000001036,'','Y',2,'Y','Y','Y','Y'),(00000613,0000321,0000001037,'','Y',2,'Y','Y','Y','Y'),(00000614,0000326,0000001038,'','Y',2,'Y','Y','Y','Y'),(00000615,0000337,0000001040,'','Y',2,'Y','Y','Y','Y'),(00000616,0000337,0000000373,'','Y',1,'Y','Y','Y','Y'),(00000617,0000338,0000001042,'','Y',2,'Y','Y','Y','Y'),(00000618,0000338,0000001043,'','Y',1,'Y','Y','Y','Y'),(00000619,0000339,0000001045,'','Y',2,'Y','Y','Y','Y'),(00000620,0000339,0000001046,'','Y',1,'Y','Y','Y','Y'),(00000621,0000340,0000001048,'','Y',1,'Y','Y','Y','Y'),(00000622,0000340,0000001049,'','Y',2,'Y','Y','Y','Y'),(00000623,0000341,0000001051,'','Y',1,'Y','Y','Y','Y'),(00000624,0000341,0000001052,'','Y',2,'Y','Y','Y','Y'),(00000625,0000342,0000001059,'','Y',1,'Y','Y','Y','Y'),(00000626,0000342,0000001060,'','Y',2,'Y','Y','Y','Y'),(00000629,0000344,0000001065,'','Y',1,'Y','Y','Y','Y'),(00000630,0000345,0000001067,'','Y',1,'Y','Y','Y','Y'),(00000631,0000345,0000001068,'','Y',2,'Y','Y','Y','Y'),(00000632,0000346,0000001070,'','Y',2,'Y','Y','Y','Y'),(00000633,0000346,0000001071,'','Y',2,'Y','Y','Y','Y'),(00000634,0000347,0000001073,'','Y',2,'Y','Y','Y','Y'),(00000635,0000347,0000001074,'','Y',1,'Y','Y','Y','Y'),(00000636,0000348,0000001076,'','Y',1,'Y','Y','Y','Y'),(00000637,0000348,0000001077,'','Y',2,'Y','Y','Y','Y'),(00000638,0000292,0000001078,'','Y',1,'Y','Y','Y','Y'),(00000639,0000349,0000001080,'','Y',1,'Y','Y','Y','Y'),(00000640,0000350,0000001082,'','Y',1,'Y','Y','Y','Y'),(00000641,0000350,0000001083,'','Y',2,'Y','Y','Y','Y'),(00000642,0000308,0000001085,'','Y',1,'Y','Y','Y','Y'),(00000643,0000351,0000001087,'','Y',1,'Y','Y','Y','Y'),(00000644,0000351,0000001088,'','Y',2,'Y','Y','Y','Y'),(00000645,0000352,0000001091,'','Y',1,'Y','Y','Y','Y'),(00000646,0000352,0000001092,'','Y',2,'Y','Y','Y','Y'),(00000647,0000353,0000001094,'','Y',1,'Y','Y','Y','Y'),(00000648,0000353,0000001095,'','Y',2,'Y','Y','Y','Y'),(00000649,0000349,0000001097,'','Y',2,'Y','Y','Y','Y'),(00000650,0000354,0000001107,'','Y',1,'Y','Y','Y','Y'),(00000651,0000354,0000001108,'','Y',2,'Y','Y','Y','Y'),(00000652,0000201,0000001111,'','Y',2,'Y','Y','Y','Y'),(00000653,0000355,0000001114,'','Y',1,'Y','Y','Y','Y'),(00000654,0000355,0000001115,'','Y',2,'Y','Y','Y','Y'),(00000655,0000356,0000001125,'','Y',1,'Y','Y','Y','Y'),(00000656,0000356,0000001126,'','Y',2,'Y','Y','Y','Y'),(00000657,0000357,0000001128,'','Y',1,'Y','Y','Y','Y'),(00000658,0000357,0000001129,'','Y',2,'Y','Y','Y','Y'),(00000659,0000358,0000001134,'','Y',1,'Y','Y','Y','Y'),(00000660,0000358,0000001135,'','Y',2,'Y','Y','Y','Y'),(00000664,0000360,0000001141,'','Y',2,'Y','Y','Y','Y'),(00000665,0000361,0000001143,'','Y',2,'Y','Y','Y','Y'),(00000666,0000361,0000001144,'','Y',1,'Y','Y','Y','Y'),(00000669,0000363,0000001149,'','Y',1,'Y','Y','Y','Y'),(00000670,0000363,0000001150,'','Y',2,'Y','Y','Y','Y'),(00000671,0000364,0000001152,'','Y',1,'Y','Y','Y','Y'),(00000672,0000364,0000001153,'','Y',2,'Y','Y','Y','Y'),(00000673,0000365,0000001155,'','Y',1,'Y','Y','Y','Y'),(00000674,0000365,0000001156,'','Y',2,'Y','Y','Y','Y'),(00000675,0000366,0000001158,'','Y',1,'Y','Y','Y','Y'),(00000676,0000366,0000001159,'','Y',2,'Y','Y','Y','Y'),(00000677,0000367,0000001161,'','Y',1,'Y','Y','Y','Y'),(00000678,0000367,0000001162,'','Y',2,'Y','Y','Y','Y'),(00000679,0000368,0000001164,'','Y',1,'Y','Y','Y','Y'),(00000680,0000368,0000001165,'','Y',2,'Y','Y','Y','Y'),(00000681,0000369,0000001167,'','Y',1,'Y','Y','Y','Y'),(00000682,0000369,0000001168,'','Y',2,'Y','Y','Y','Y'),(00000683,0000370,0000001170,'','Y',1,'Y','Y','Y','Y'),(00000684,0000370,0000001171,'','Y',2,'Y','Y','Y','Y'),(00000685,0000371,0000001173,'','Y',1,'Y','Y','Y','Y'),(00000686,0000371,0000001174,'','Y',2,'Y','Y','Y','Y'),(00000687,0000372,0000001176,'','Y',1,'Y','Y','Y','Y'),(00000688,0000372,0000001177,'','Y',2,'Y','Y','Y','Y'),(00000689,0000373,0000001180,'','Y',1,'Y','Y','Y','Y'),(00000690,0000373,0000001181,'','Y',2,'Y','Y','Y','Y'),(00000691,0000374,0000001183,'','Y',1,'Y','Y','Y','Y'),(00000692,0000374,0000001184,'','Y',2,'Y','Y','Y','Y'),(00000695,0000376,0000001189,'','Y',1,'Y','Y','Y','Y'),(00000696,0000376,0000001190,'','Y',2,'Y','Y','Y','Y'),(00000697,0000377,0000001192,'','Y',1,'Y','Y','Y','Y'),(00000698,0000378,0000001194,'','Y',1,'Y','Y','Y','Y'),(00000699,0000378,0000001195,'','Y',2,'Y','Y','Y','Y'),(00000700,0000379,0000001198,'','Y',1,'Y','Y','Y','Y'),(00000701,0000379,0000001199,'','Y',2,'Y','Y','Y','Y'),(00000702,0000380,0000001202,'','Y',1,'Y','Y','Y','Y'),(00000703,0000380,0000001203,'','Y',2,'Y','Y','Y','Y'),(00000704,0000381,0000001205,'','Y',1,'Y','Y','Y','Y'),(00000705,0000381,0000001206,'','Y',2,'Y','Y','Y','Y'),(00000706,0000382,0000001208,'','Y',1,'Y','Y','Y','Y'),(00000707,0000382,0000001209,'','Y',2,'Y','Y','Y','Y'),(00000708,0000383,0000001211,'','Y',1,'Y','Y','Y','Y'),(00000709,0000383,0000001212,'','Y',2,'Y','Y','Y','Y'),(00000710,0000384,0000001215,'','Y',1,'Y','Y','Y','Y'),(00000711,0000384,0000001216,'','Y',2,'Y','Y','Y','Y'),(00000712,0000385,0000001219,'','Y',1,'Y','Y','Y','Y'),(00000713,0000385,0000001220,'','Y',2,'Y','Y','Y','Y'),(00000714,0000386,0000001223,'','Y',1,'Y','Y','Y','Y'),(00000715,0000386,0000001224,'','Y',2,'Y','Y','Y','Y'),(00000716,0000387,0000001228,'','Y',1,'Y','Y','Y','Y'),(00000717,0000387,0000001229,'','Y',2,'Y','Y','Y','Y'),(00000720,0000389,0000001234,'','Y',1,'Y','Y','Y','Y'),(00000721,0000389,0000001235,'','Y',2,'Y','Y','Y','Y'),(00000722,0000390,0000001237,'','Y',1,'Y','Y','Y','Y'),(00000723,0000390,0000001238,'','Y',2,'Y','Y','Y','Y'),(00000724,0000391,0000001240,'','Y',1,'Y','Y','Y','Y'),(00000725,0000391,0000001241,'','Y',2,'Y','Y','Y','Y'),(00000726,0000392,0000001243,'','Y',1,'Y','Y','Y','Y'),(00000727,0000392,0000001244,'','Y',2,'Y','Y','Y','Y'),(00000728,0000393,0000001246,'','Y',3,'Y','Y','Y','Y'),(00000729,0000393,0000001247,'','Y',1,'Y','Y','Y','Y'),(00000730,0000394,0000001249,'','Y',1,'Y','Y','Y','Y'),(00000731,0000394,0000001250,'','Y',2,'Y','Y','Y','Y'),(00000732,0000395,0000001252,'','Y',1,'Y','Y','Y','Y'),(00000733,0000395,0000001253,'','Y',2,'Y','Y','Y','Y'),(00000734,0000396,0000001255,'','Y',1,'Y','Y','Y','Y'),(00000735,0000396,0000001256,'','Y',2,'Y','Y','Y','Y'),(00000737,0000398,0000001260,'','Y',1,'Y','Y','Y','Y'),(00000738,0000398,0000001261,'','Y',2,'Y','Y','Y','Y'),(00000739,0000399,0000001264,'','Y',1,'Y','Y','Y','Y'),(00000740,0000399,0000001265,'','Y',2,'Y','Y','Y','Y'),(00000741,0000400,0000001267,'','Y',1,'Y','Y','Y','Y'),(00000742,0000400,0000001268,'','Y',2,'Y','Y','Y','Y'),(00000747,0000403,0000001277,'','Y',1,'Y','Y','Y','Y'),(00000748,0000403,0000001278,'','Y',2,'Y','Y','Y','Y'),(00000749,0000404,0000001280,'','Y',1,'Y','Y','Y','Y'),(00000750,0000404,0000001281,'','Y',2,'Y','Y','Y','Y'),(00000751,0000405,0000001283,'','Y',1,'Y','Y','Y','Y'),(00000752,0000405,0000001284,'','Y',2,'Y','Y','Y','Y'),(00000753,0000406,0000001286,'','Y',2,'Y','Y','Y','Y'),(00000754,0000406,0000001287,'','Y',1,'Y','Y','Y','Y'),(00000755,0000407,0000001289,'','Y',1,'Y','Y','Y','Y'),(00000756,0000407,0000001290,'','Y',2,'Y','Y','Y','Y'),(00000757,0000408,0000001292,'','Y',1,'Y','Y','Y','Y'),(00000758,0000408,0000001293,'','Y',2,'Y','Y','Y','Y'),(00000759,0000251,0000001187,'','Y',2,'Y','Y','Y','Y'),(00000760,0000409,0000001297,'','Y',1,'Y','Y','Y','Y'),(00000761,0000409,0000001298,'','Y',2,'Y','Y','Y','Y'),(00000762,0000410,0000001300,'','Y',2,'Y','Y','Y','Y'),(00000763,0000410,0000001301,'','Y',1,'Y','Y','Y','Y'),(00000764,0000411,0000001303,'','Y',1,'Y','Y','Y','Y'),(00000765,0000412,0000001305,'','Y',1,'Y','Y','Y','Y'),(00000766,0000412,0000001306,'','Y',2,'Y','Y','Y','Y'),(00000767,0000413,0000001308,'','Y',1,'Y','Y','Y','Y'),(00000768,0000413,0000001309,'','Y',2,'Y','Y','Y','Y'),(00000769,0000414,0000001311,'','Y',1,'Y','Y','Y','Y'),(00000770,0000414,0000001312,'','Y',2,'Y','Y','Y','Y'),(00000771,0000415,0000001314,'','Y',1,'Y','Y','Y','Y'),(00000772,0000415,0000001315,'','Y',2,'Y','Y','Y','Y'),(00000773,0000416,0000001317,'','Y',1,'Y','Y','Y','Y'),(00000774,0000416,0000001318,'','Y',2,'Y','Y','Y','Y'),(00000777,0000418,0000001323,'','Y',1,'Y','Y','Y','Y'),(00000778,0000418,0000001324,'','Y',2,'Y','Y','Y','Y'),(00000779,0000419,0000001326,'','Y',1,'Y','Y','Y','Y'),(00000780,0000419,0000001327,'','Y',2,'Y','Y','Y','Y'),(00000784,0000422,0000001346,'','Y',1,'Y','Y','Y','Y'),(00000785,0000422,0000001347,'','Y',2,'Y','Y','Y','Y'),(00000788,0000425,0000001353,'','Y',1,'Y','Y','Y','Y'),(00000789,0000425,0000001354,'','Y',2,'Y','Y','Y','Y'),(00000790,0000426,0000001356,'','Y',1,'Y','Y','Y','Y'),(00000791,0000426,0000001357,'','Y',2,'Y','Y','Y','Y'),(00000792,0000427,0000001359,'','Y',1,'Y','Y','Y','Y'),(00000793,0000427,0000001360,'','Y',2,'Y','Y','Y','Y'),(00000796,0000429,0000001365,'','Y',1,'Y','Y','Y','Y'),(00000797,0000429,0000001366,'','Y',2,'Y','Y','Y','Y'),(00000798,0000430,0000001368,'','Y',1,'Y','Y','Y','Y'),(00000799,0000430,0000001369,'','Y',2,'Y','Y','Y','Y'),(00000800,0000431,0000001371,'','Y',1,'Y','Y','Y','Y'),(00000801,0000431,0000001372,'','Y',2,'Y','Y','Y','Y'),(00000802,0000432,0000001375,'','Y',1,'Y','Y','Y','Y'),(00000803,0000432,0000001376,'','Y',2,'Y','Y','Y','Y'),(00000804,0000433,0000001380,'','Y',2,'Y','Y','Y','Y'),(00000805,0000433,0000001381,'','Y',2,'Y','Y','Y','Y'),(00000807,0000433,0000000125,'','Y',2,'Y','Y','Y','Y'),(00000808,0000433,0000001231,'','Y',1,'Y','Y','Y','Y'),(00000809,0000434,0000001383,'','Y',1,'Y','Y','Y','Y'),(00000810,0000434,0000001384,'','Y',2,'Y','Y','Y','Y'),(00000811,0000435,0000001386,'','Y',1,'Y','Y','Y','Y'),(00000812,0000435,0000001387,'','Y',2,'Y','Y','Y','Y'),(00000813,0000436,0000001389,'','Y',1,'Y','Y','Y','Y'),(00000814,0000436,0000001390,'','Y',2,'Y','Y','Y','Y'),(00000815,0000437,0000001392,'','Y',1,'Y','Y','Y','Y'),(00000816,0000438,0000001394,'','Y',1,'Y','Y','Y','Y'),(00000817,0000438,0000001395,'','Y',2,'Y','Y','Y','Y'),(00000818,0000439,0000001397,'','Y',1,'Y','Y','Y','Y'),(00000819,0000439,0000001398,'','Y',2,'Y','Y','Y','Y'),(00000820,0000440,0000001401,'','Y',1,'Y','Y','Y','Y'),(00000821,0000440,0000001402,'','Y',2,'Y','Y','Y','Y'),(00000822,0000441,0000001404,'','Y',1,'Y','Y','Y','Y'),(00000823,0000441,0000001405,'','Y',2,'Y','Y','Y','Y'),(00000828,0000444,0000001414,'','Y',1,'Y','Y','Y','Y'),(00000829,0000444,0000001415,'','Y',2,'Y','Y','Y','Y'),(00000830,0000445,0000001417,'','Y',2,'Y','Y','Y','Y'),(00000831,0000445,0000001418,'','Y',1,'Y','Y','Y','Y'),(00000832,0000446,0000001420,'','Y',1,'Y','Y','Y','Y'),(00000833,0000447,0000001422,'','Y',2,'Y','Y','Y','Y'),(00000834,0000447,0000001423,'','Y',1,'Y','Y','Y','Y'),(00000835,0000448,0000001425,'','Y',1,'Y','Y','Y','Y'),(00000836,0000448,0000001426,'','Y',2,'Y','Y','Y','Y'),(00000837,0000449,0000001428,'','Y',1,'Y','Y','Y','Y'),(00000838,0000449,0000001429,'','Y',2,'Y','Y','Y','Y'),(00000839,0000450,0000001431,'','Y',1,'Y','Y','Y','Y'),(00000840,0000450,0000001432,'','Y',2,'Y','Y','Y','Y'),(00000841,0000451,0000001434,'','Y',1,'Y','Y','Y','Y'),(00000842,0000451,0000001435,'','Y',2,'Y','Y','Y','Y'),(00000843,0000452,0000001438,'','Y',1,'Y','Y','Y','Y'),(00000844,0000452,0000001439,'','Y',2,'Y','Y','Y','Y'),(00000845,0000453,0000001442,'','Y',1,'Y','Y','Y','Y'),(00000846,0000453,0000001443,'','Y',2,'Y','Y','Y','Y'),(00000847,0000454,0000001446,'','Y',1,'Y','Y','Y','Y'),(00000848,0000454,0000001447,'','Y',2,'Y','Y','Y','Y'),(00000850,0000456,0000001451,'','Y',1,'Y','Y','Y','Y'),(00000851,0000456,0000001452,'','Y',2,'Y','Y','Y','Y'),(00000852,0000457,0000001454,'','Y',1,'Y','Y','Y','Y'),(00000853,0000457,0000001455,'','Y',2,'Y','Y','Y','Y'),(00000858,0000460,0000001466,'','Y',1,'Y','Y','Y','Y'),(00000859,0000460,0000001467,'','Y',2,'Y','Y','Y','Y'),(00000860,0000461,0000001469,'','Y',1,'Y','Y','Y','Y'),(00000861,0000461,0000001470,'','Y',2,'Y','Y','Y','Y'),(00000862,0000462,0000001472,'','Y',1,'Y','Y','Y','Y'),(00000863,0000462,0000001473,'','Y',2,'Y','Y','Y','Y'),(00000864,0000463,0000001475,'','Y',1,'Y','Y','Y','Y'),(00000865,0000463,0000001476,'','Y',2,'Y','Y','Y','Y'),(00000866,0000464,0000001478,'','Y',1,'Y','Y','Y','Y'),(00000867,0000464,0000001479,'','Y',2,'Y','Y','Y','Y'),(00000870,0000466,0000001484,'','Y',1,'Y','Y','Y','Y'),(00000871,0000466,0000001485,'','Y',2,'Y','Y','Y','Y'),(00000872,0000467,0000001487,'','Y',1,'Y','Y','Y','Y'),(00000873,0000467,0000001488,'','Y',2,'Y','Y','Y','Y'),(00000874,0000468,0000001493,'','Y',1,'Y','Y','Y','Y'),(00000875,0000468,0000001494,'','Y',2,'Y','Y','Y','Y'),(00000876,0000469,0000001496,'','Y',1,'Y','Y','Y','Y'),(00000877,0000469,0000001497,'','Y',2,'Y','Y','Y','Y'),(00000878,0000470,0000001499,'','Y',1,'Y','Y','Y','Y'),(00000879,0000470,0000001500,'','Y',2,'Y','Y','Y','Y'),(00000880,0000471,0000001508,'','Y',1,'Y','Y','Y','Y'),(00000881,0000471,0000001509,'','Y',2,'Y','Y','Y','Y'),(00000882,0000158,0000000835,'','Y',3,'Y','Y','Y','Y'),(00000883,0000472,0000001512,'','Y',1,'Y','Y','Y','Y'),(00000884,0000472,0000001513,'','Y',2,'Y','Y','Y','Y'),(00000885,0000473,0000001515,'','Y',1,'Y','Y','Y','Y'),(00000886,0000473,0000001516,'','Y',2,'Y','Y','Y','Y'),(00000889,0000475,0000001524,'','Y',1,'Y','Y','Y','Y'),(00000890,0000475,0000001525,'','Y',2,'Y','Y','Y','Y'),(00000891,0000476,0000001529,'','Y',1,'Y','Y','Y','Y'),(00000892,0000476,0000001530,'','Y',2,'Y','Y','Y','Y'),(00000893,0000477,0000001533,'','Y',1,'Y','Y','Y','Y'),(00000894,0000477,0000001534,'','Y',2,'Y','Y','Y','Y'),(00000897,0000479,0000001539,'','Y',1,'Y','Y','Y','Y'),(00000898,0000479,0000001540,'','Y',2,'Y','Y','Y','Y'),(00000899,0000480,0000001542,'','Y',1,'Y','Y','Y','Y'),(00000900,0000480,0000001543,'','Y',2,'Y','Y','Y','Y'),(00000903,0000482,0000001549,'','Y',1,'Y','Y','Y','Y'),(00000904,0000482,0000001550,'','Y',2,'Y','Y','Y','Y'),(00000907,0000484,0000001555,'','Y',1,'Y','Y','Y','Y'),(00000908,0000484,0000001556,'','Y',2,'Y','Y','Y','Y'),(00000911,0000486,0000001563,'','Y',2,'Y','Y','Y','Y'),(00000912,0000486,0000001564,'','Y',1,'Y','Y','Y','Y'),(00000917,0000489,0000001572,'','Y',1,'Y','Y','Y','Y'),(00000918,0000489,0000001573,'','Y',2,'Y','Y','Y','Y'),(00000919,0000437,0000001574,'','Y',2,'Y','Y','Y','Y'),(00000920,0000490,0000001576,'','Y',1,'Y','Y','Y','Y'),(00000921,0000490,0000001577,'','Y',2,'Y','Y','Y','Y'),(00000923,0000491,0000001583,'','Y',1,'Y','Y','Y','Y'),(00000924,0000491,0000001584,'','Y',2,'Y','Y','Y','Y'),(00000925,0000492,0000001586,'','Y',1,'Y','Y','Y','Y'),(00000926,0000492,0000001587,'','Y',2,'Y','Y','Y','Y'),(00000930,0000494,0000001595,'','Y',1,'Y','Y','Y','Y'),(00000931,0000494,0000001596,'','Y',2,'Y','Y','Y','Y'),(00000932,0000495,0000001598,'','Y',1,'Y','Y','Y','Y'),(00000933,0000495,0000001599,'','Y',2,'Y','Y','Y','Y'),(00000934,0000496,0000001601,'','Y',1,'Y','Y','Y','Y'),(00000935,0000496,0000001602,'','Y',2,'Y','Y','Y','Y'),(00000936,0000497,0000001604,'','Y',1,'Y','Y','Y','Y'),(00000937,0000497,0000001605,'','Y',2,'Y','Y','Y','Y'),(00000938,0000498,0000001607,'','Y',1,'Y','Y','Y','Y'),(00000939,0000498,0000001608,'','Y',2,'Y','Y','Y','Y'),(00000940,0000499,0000001610,'','Y',1,'Y','Y','Y','Y'),(00000941,0000499,0000001611,'','Y',2,'Y','Y','Y','Y'),(00000942,0000500,0000001613,'','Y',2,'Y','Y','Y','Y'),(00000943,0000500,0000001614,'','Y',1,'Y','Y','Y','Y'),(00000944,0000501,0000001619,'','Y',1,'Y','Y','Y','Y'),(00000945,0000501,0000001620,'','Y',2,'Y','Y','Y','Y'),(00000946,0000502,0000001622,'','Y',1,'Y','Y','Y','Y'),(00000947,0000502,0000001623,'','Y',2,'Y','Y','Y','Y'),(00000950,0000504,0000001629,'','Y',1,'Y','Y','Y','Y'),(00000951,0000504,0000001630,'','Y',2,'Y','Y','Y','Y'),(00000952,0000505,0000001632,'','Y',1,'Y','Y','Y','Y'),(00000953,0000506,0000001634,'','Y',1,'Y','Y','Y','Y'),(00000954,0000506,0000001635,'','Y',2,'Y','Y','Y','Y'),(00000955,0000507,0000001637,'','Y',1,'Y','Y','Y','Y'),(00000956,0000507,0000001638,'','Y',2,'Y','Y','Y','Y'),(00000957,0000508,0000001640,'','Y',1,'Y','Y','Y','Y'),(00000958,0000508,0000001641,'','Y',2,'Y','Y','Y','Y'),(00000959,0000509,0000001643,'','Y',1,'Y','Y','Y','Y'),(00000960,0000509,0000001644,'','Y',2,'Y','Y','Y','Y'),(00000963,0000511,0000001649,'','Y',1,'Y','Y','Y','Y'),(00000964,0000511,0000001650,'','Y',2,'Y','Y','Y','Y'),(00000967,0000513,0000001655,'','Y',1,'Y','Y','Y','Y'),(00000968,0000513,0000001656,'','Y',2,'Y','Y','Y','Y'),(00000969,0000514,0000001659,'','Y',1,'Y','Y','Y','Y'),(00000970,0000514,0000001660,'','Y',2,'Y','Y','Y','Y'),(00000971,0000515,0000001662,'','Y',1,'Y','Y','Y','Y'),(00000972,0000515,0000001663,'','Y',2,'Y','Y','Y','Y'),(00000973,0000360,0000001626,'','Y',1,'Y','Y','Y','Y'),(00000974,0000516,0000001665,'','Y',1,'Y','Y','Y','Y'),(00000975,0000516,0000001666,'','Y',2,'Y','Y','Y','Y'),(00000976,0000517,0000001668,'','Y',2,'Y','Y','Y','Y'),(00000977,0000517,0000001669,'','Y',1,'Y','Y','Y','Y'),(00000979,0000518,0000001672,'','Y',2,'Y','Y','Y','Y'),(00000980,0000518,0000000890,'','Y',1,'Y','Y','Y','Y'),(00000981,0000154,0000000651,'','Y',2,'Y','Y','Y','Y'),(00000982,0000519,0000001675,'','Y',1,'Y','Y','Y','Y'),(00000983,0000519,0000001676,'','Y',2,'Y','Y','Y','Y'),(00000984,0000520,0000001678,'','Y',1,'Y','Y','Y','Y'),(00000985,0000520,0000001679,'','Y',2,'Y','Y','Y','Y'),(00000986,0000521,0000001681,'','Y',1,'Y','Y','Y','Y'),(00000987,0000521,0000001682,'','Y',2,'Y','Y','Y','Y'),(00000992,0000524,0000001690,'','Y',1,'Y','Y','Y','Y'),(00000993,0000524,0000001691,'','Y',2,'Y','Y','Y','Y'),(00000994,0000525,0000001693,'','Y',1,'Y','Y','Y','Y'),(00000995,0000525,0000001694,'','Y',2,'Y','Y','Y','Y'),(00000996,0000526,0000001698,'','Y',1,'Y','Y','Y','Y'),(00000997,0000526,0000001699,'','Y',2,'Y','Y','Y','Y'),(00000998,0000527,0000001701,'','Y',1,'Y','Y','Y','Y'),(00000999,0000527,0000001702,'','Y',2,'Y','Y','Y','Y'),(00001000,0000528,0000001704,'','Y',1,'Y','Y','Y','Y'),(00001001,0000528,0000001705,'','Y',2,'Y','Y','Y','Y'),(00001002,0000529,0000001708,'','Y',1,'Y','Y','Y','Y'),(00001003,0000529,0000001709,'','Y',2,'Y','Y','Y','Y'),(00001008,0000532,0000001717,'','Y',1,'Y','Y','Y','Y'),(00001009,0000533,0000001719,'','Y',1,'Y','Y','Y','Y'),(00001010,0000533,0000001720,'','Y',2,'Y','Y','Y','Y'),(00001011,0000534,0000001722,'','Y',1,'Y','Y','Y','Y'),(00001012,0000534,0000001723,'','Y',2,'Y','Y','Y','Y'),(00001013,0000535,0000001725,'','Y',1,'Y','Y','Y','Y'),(00001014,0000535,0000001726,'','Y',2,'Y','Y','Y','Y'),(00001015,0000536,0000001731,'','Y',1,'Y','Y','Y','Y'),(00001016,0000537,0000001733,'','Y',1,'Y','Y','Y','Y'),(00001017,0000537,0000001734,'','Y',2,'Y','Y','Y','Y'),(00001018,0000538,0000001736,'','Y',1,'Y','Y','Y','Y'),(00001019,0000538,0000001737,'','Y',2,'Y','Y','Y','Y'),(00001020,0000539,0000001740,'','Y',1,'Y','Y','Y','Y'),(00001021,0000539,0000001741,'','Y',2,'Y','Y','Y','Y'),(00001024,0000541,0000001745,'','Y',1,'Y','Y','Y','Y'),(00001025,0000541,0000001746,'','Y',2,'Y','Y','Y','Y'),(00001026,0000542,0000001748,'','Y',1,'Y','Y','Y','Y'),(00001027,0000542,0000001749,'','Y',2,'Y','Y','Y','Y'),(00001028,0000543,0000001751,'','Y',1,'Y','Y','Y','Y'),(00001029,0000543,0000001752,'','Y',2,'Y','Y','Y','Y'),(00001030,0000544,0000001754,'','Y',1,'Y','Y','Y','Y'),(00001031,0000544,0000001755,'','Y',2,'Y','Y','Y','Y'),(00001032,0000545,0000001757,'','Y',1,'Y','Y','Y','Y'),(00001033,0000546,0000001759,'','Y',1,'Y','Y','Y','Y'),(00001034,0000546,0000001760,'','Y',2,'Y','Y','Y','Y'),(00001035,0000547,0000001762,'','Y',1,'Y','Y','Y','Y'),(00001036,0000547,0000001763,'','Y',2,'Y','Y','Y','Y'),(00001037,0000548,0000001774,'','Y',1,'Y','Y','Y','Y'),(00001038,0000548,0000001775,'','Y',2,'Y','Y','Y','Y'),(00001039,0000549,0000001780,'','Y',1,'Y','Y','Y','Y'),(00001040,0000549,0000001781,'','Y',2,'Y','Y','Y','Y'),(00001041,0000550,0000001784,'','Y',1,'Y','Y','Y','Y'),(00001042,0000550,0000001785,'','Y',2,'Y','Y','Y','Y'),(00001043,0000551,0000001787,'','Y',2,'Y','Y','Y','Y'),(00001044,0000552,0000001789,'','Y',1,'Y','Y','Y','Y'),(00001045,0000552,0000001790,'','Y',2,'Y','Y','Y','Y'),(00001046,0000553,0000001792,'','Y',1,'Y','Y','Y','Y'),(00001047,0000553,0000001793,'','Y',2,'Y','Y','Y','Y'),(00001048,0000554,0000001795,'','Y',1,'Y','Y','Y','Y'),(00001049,0000555,0000001797,'','Y',1,'Y','Y','Y','Y'),(00001050,0000555,0000001798,'','Y',2,'Y','Y','Y','Y'),(00001051,0000551,0000001800,'','Y',1,'Y','Y','Y','Y'),(00001052,0000556,0000001802,'','Y',2,'Y','Y','Y','Y'),(00001053,0000556,0000001803,'','Y',3,'Y','Y','Y','Y'),(00001054,0000557,0000001805,'','Y',1,'Y','Y','Y','Y'),(00001055,0000558,0000001807,'','Y',1,'Y','Y','Y','Y'),(00001056,0000559,0000001809,'','Y',1,'Y','Y','Y','Y'),(00001059,0000561,0000001815,'','Y',1,'Y','Y','Y','Y'),(00001060,0000561,0000001816,'','Y',2,'Y','Y','Y','Y'),(00001061,0000562,0000001820,'','Y',1,'Y','Y','Y','Y'),(00001062,0000562,0000001821,'','Y',2,'Y','Y','Y','Y'),(00001063,0000563,0000001823,'','Y',1,'Y','Y','Y','Y'),(00001064,0000563,0000001824,'','Y',2,'Y','Y','Y','Y'),(00001065,0000564,0000001826,'','Y',1,'Y','Y','Y','Y'),(00001066,0000564,0000001827,'','Y',2,'Y','Y','Y','Y'),(00001067,0000565,0000001829,'','Y',1,'Y','Y','Y','Y'),(00001068,0000565,0000001830,'','Y',2,'Y','Y','Y','Y'),(00001069,0000566,0000001832,'','Y',2,'Y','Y','Y','Y'),(00001070,0000566,0000001833,'','Y',2,'Y','Y','Y','Y'),(00001072,0000568,0000001837,'','Y',2,'Y','Y','Y','Y'),(00001074,0000568,0000001835,'','Y',1,'Y','Y','Y','Y'),(00001075,0000566,0000001778,'','Y',1,'Y','Y','Y','Y'),(00001076,0000569,0000001841,'','Y',1,'Y','Y','Y','Y'),(00001077,0000569,0000001842,'','Y',2,'Y','Y','Y','Y'),(00001080,0000571,0000001846,'','Y',1,'Y','Y','Y','Y'),(00001081,0000571,0000001847,'','Y',2,'Y','Y','Y','Y'),(00001084,0000573,0000001856,'','Y',1,'Y','Y','Y','Y'),(00001085,0000573,0000001857,'','Y',2,'Y','Y','Y','Y'),(00001086,0000574,0000001859,'','Y',1,'Y','Y','Y','Y'),(00001087,0000574,0000001860,'','Y',2,'Y','Y','Y','Y'),(00001088,0000575,0000001862,'','Y',1,'Y','Y','Y','Y'),(00001089,0000575,0000001863,'','Y',2,'Y','Y','Y','Y'),(00001092,0000577,0000001868,'','Y',1,'Y','Y','Y','Y'),(00001093,0000577,0000001869,'','Y',2,'Y','Y','Y','Y'),(00001094,0000578,0000001871,'','Y',1,'Y','Y','Y','Y'),(00001095,0000578,0000001872,'','Y',2,'Y','Y','Y','Y'),(00001096,0000554,0000001874,'','Y',3,'Y','Y','Y','Y'),(00001099,0000580,0000001880,'','Y',1,'Y','Y','Y','Y'),(00001100,0000580,0000001881,'','Y',2,'Y','Y','Y','Y'),(00001103,0000582,0000001886,'','Y',1,'Y','Y','Y','Y'),(00001104,0000582,0000001887,'','Y',2,'Y','Y','Y','Y'),(00001105,0000583,0000001889,'','Y',1,'Y','Y','Y','Y'),(00001106,0000583,0000001890,'','Y',2,'Y','Y','Y','Y'),(00001107,0000584,0000001892,'','Y',1,'Y','Y','Y','Y'),(00001108,0000584,0000001893,'','Y',2,'Y','Y','Y','Y'),(00001111,0000586,0000001899,'','Y',1,'Y','Y','Y','Y'),(00001112,0000586,0000001900,'','Y',2,'Y','Y','Y','Y'),(00001113,0000587,0000001902,'','Y',1,'Y','Y','Y','Y'),(00001114,0000587,0000001903,'','Y',2,'Y','Y','Y','Y'),(00001115,0000588,0000001906,'','Y',1,'Y','Y','Y','Y'),(00001116,0000588,0000001907,'','Y',2,'Y','Y','Y','Y'),(00001117,0000589,0000001909,'','Y',1,'Y','Y','Y','Y'),(00001118,0000589,0000001910,'','Y',2,'Y','Y','Y','Y'),(00001119,0000590,0000001912,'','Y',1,'Y','Y','Y','Y'),(00001120,0000591,0000001916,'','Y',1,'Y','Y','Y','Y'),(00001121,0000591,0000001917,'','Y',2,'Y','Y','Y','Y'),(00001122,0000592,0000001919,'','Y',1,'Y','Y','Y','Y'),(00001123,0000592,0000001920,'','Y',2,'Y','Y','Y','Y'),(00001124,0000593,0000001922,'','Y',1,'Y','Y','Y','Y'),(00001125,0000593,0000001923,'','Y',2,'Y','Y','Y','Y'),(00001126,0000594,0000001926,'','Y',1,'Y','Y','Y','Y'),(00001127,0000594,0000001927,'','Y',2,'Y','Y','Y','Y'),(00001128,0000595,0000001929,'','Y',1,'Y','Y','Y','Y'),(00001129,0000595,0000001930,'','Y',2,'Y','Y','Y','Y'),(00001130,0000596,0000001932,'','Y',1,'Y','Y','Y','Y'),(00001131,0000596,0000001933,'','Y',2,'Y','Y','Y','Y'),(00001134,0000598,0000001938,'','Y',1,'Y','Y','Y','Y'),(00001135,0000598,0000001939,'','Y',2,'Y','Y','Y','Y'),(00001136,0000599,0000001941,'','Y',1,'Y','Y','Y','Y'),(00001137,0000599,0000001942,'','Y',2,'Y','Y','Y','Y'),(00001138,0000600,0000001944,'','Y',1,'Y','Y','Y','Y'),(00001139,0000600,0000001945,'','Y',2,'Y','Y','Y','Y'),(00001140,0000601,0000001947,'','Y',1,'Y','Y','Y','Y'),(00001141,0000601,0000001948,'','Y',2,'Y','Y','Y','Y'),(00001142,0000602,0000001950,'','Y',1,'Y','Y','Y','Y'),(00001143,0000602,0000001951,'','Y',2,'Y','Y','Y','Y'),(00001144,0000603,0000001953,'','Y',1,'Y','Y','Y','Y'),(00001145,0000603,0000001954,'','Y',2,'Y','Y','Y','Y'),(00001146,0000604,0000001956,'','Y',1,'Y','Y','Y','Y'),(00001147,0000604,0000001957,'','Y',2,'Y','Y','Y','Y'),(00001149,0000606,0000001962,'','Y',1,'Y','Y','Y','Y'),(00001150,0000606,0000001963,'','Y',2,'Y','Y','Y','Y'),(00001151,0000607,0000001965,'','Y',1,'Y','Y','Y','Y'),(00001152,0000607,0000001966,'','Y',2,'Y','Y','Y','Y'),(00001153,0000608,0000001968,'','Y',1,'Y','Y','Y','Y'),(00001154,0000608,0000001969,'','Y',2,'Y','Y','Y','Y'),(00001155,0000609,0000001971,'','Y',1,'Y','Y','Y','Y'),(00001156,0000609,0000001972,'','Y',2,'Y','Y','Y','Y'),(00001157,0000610,0000001975,'','Y',1,'Y','Y','Y','Y'),(00001158,0000610,0000001976,'','Y',2,'Y','Y','Y','Y'),(00001161,0000612,0000001981,'','Y',1,'Y','Y','Y','Y'),(00001162,0000612,0000001982,'','Y',2,'Y','Y','Y','Y'),(00001163,0000613,0000001984,'','Y',1,'Y','Y','Y','Y'),(00001164,0000613,0000001985,'','Y',2,'Y','Y','Y','Y'),(00001165,0000614,0000001987,'','Y',1,'Y','Y','Y','Y'),(00001166,0000614,0000001988,'','Y',2,'Y','Y','Y','Y'),(00001167,0000615,0000001990,'','Y',1,'Y','Y','Y','Y'),(00001168,0000615,0000001991,'','Y',2,'Y','Y','Y','Y'),(00001169,0000616,0000001993,'','Y',1,'Y','Y','Y','Y'),(00001170,0000616,0000001994,'','Y',2,'Y','Y','Y','Y'),(00001171,0000617,0000001996,'','Y',3,'Y','Y','Y','Y'),(00001172,0000617,0000001997,'','Y',2,'Y','Y','Y','Y'),(00001173,0000618,0000001999,'','Y',1,'Y','Y','Y','Y'),(00001174,0000619,0000002001,'','Y',1,'Y','Y','Y','Y'),(00001175,0000619,0000002002,'','Y',2,'Y','Y','Y','Y'),(00001176,0000620,0000002004,'','Y',1,'Y','Y','Y','Y'),(00001177,0000620,0000002005,'','Y',2,'Y','Y','Y','Y'),(00001178,0000621,0000002007,'','Y',1,'Y','Y','Y','Y'),(00001179,0000621,0000002008,'','Y',2,'Y','Y','Y','Y'),(00001180,0000622,0000002010,'','Y',1,'Y','Y','Y','Y'),(00001181,0000622,0000002011,'','Y',2,'Y','Y','Y','Y'),(00001182,0000623,0000002013,'','Y',1,'Y','Y','Y','Y'),(00001183,0000623,0000002014,'','Y',2,'Y','Y','Y','Y'),(00001186,0000625,0000002020,'','Y',1,'Y','Y','Y','Y'),(00001187,0000625,0000002021,'','Y',2,'Y','Y','Y','Y'),(00001188,0000626,0000002023,'','Y',1,'Y','Y','Y','Y'),(00001189,0000626,0000002024,'','Y',2,'Y','Y','Y','Y'),(00001190,0000627,0000002030,'','Y',1,'Y','Y','Y','Y'),(00001191,0000627,0000002031,'','Y',2,'Y','Y','Y','Y'),(00001192,0000627,0000002032,'','Y',2,'Y','Y','Y','Y'),(00001193,0000628,0000002034,'','Y',1,'Y','Y','Y','Y'),(00001194,0000629,0000002036,'','Y',1,'Y','Y','Y','Y'),(00001195,0000630,0000002038,'','Y',1,'Y','Y','Y','Y'),(00001196,0000630,0000002039,'','Y',2,'Y','Y','Y','Y'),(00001197,0000631,0000002041,'','Y',1,'Y','Y','Y','Y'),(00001198,0000631,0000002042,'','Y',3,'Y','Y','Y','Y'),(00001199,0000632,0000002044,'','Y',1,'Y','Y','Y','Y'),(00001200,0000632,0000002045,'','Y',2,'Y','Y','Y','Y'),(00001201,0000633,0000002047,'','Y',1,'Y','Y','Y','Y'),(00001202,0000633,0000002048,'','Y',2,'Y','Y','Y','Y'),(00001203,0000634,0000002050,'','Y',1,'Y','Y','Y','Y'),(00001204,0000634,0000002051,'','Y',2,'Y','Y','Y','Y'),(00001205,0000635,0000002054,'','Y',1,'Y','Y','Y','Y'),(00001206,0000635,0000002055,'','Y',2,'Y','Y','Y','Y'),(00001209,0000637,0000002061,'','Y',2,'Y','Y','Y','Y'),(00001210,0000637,0000002062,'','Y',1,'Y','Y','Y','Y'),(00001211,0000638,0000002064,'','Y',1,'Y','Y','Y','Y'),(00001212,0000638,0000002065,'','Y',2,'Y','Y','Y','Y'),(00001213,0000639,0000002067,'','Y',1,'Y','Y','Y','Y'),(00001214,0000639,0000002068,'','Y',3,'Y','Y','Y','Y'),(00001217,0000641,0000002073,'','Y',1,'Y','Y','Y','Y'),(00001218,0000641,0000002074,'','Y',2,'Y','Y','Y','Y'),(00001219,0000642,0000002077,'','Y',2,'Y','Y','Y','Y'),(00001220,0000642,0000002078,'','Y',1,'Y','Y','Y','Y'),(00001221,0000643,0000002080,'','Y',2,'Y','Y','Y','Y'),(00001222,0000644,0000002082,'','Y',1,'Y','Y','Y','Y'),(00001223,0000644,0000002083,'','Y',2,'Y','Y','Y','Y'),(00001224,0000645,0000002085,'','Y',1,'Y','Y','Y','Y'),(00001225,0000645,0000002086,'','Y',2,'Y','Y','Y','Y'),(00001226,0000646,0000002088,'','Y',1,'Y','Y','Y','Y'),(00001227,0000646,0000002089,'','Y',2,'Y','Y','Y','Y'),(00001228,0000647,0000002091,'','Y',1,'Y','Y','Y','Y'),(00001229,0000647,0000002092,'','Y',2,'Y','Y','Y','Y'),(00001230,0000648,0000002094,'','Y',1,'Y','Y','Y','Y'),(00001231,0000556,0000002095,'','Y',1,'Y','Y','Y','Y'),(00001232,0000649,0000002098,'','Y',1,'Y','Y','Y','Y'),(00001233,0000649,0000002099,'','Y',2,'Y','Y','Y','Y'),(00001234,0000650,0000002101,'','Y',1,'Y','Y','Y','Y'),(00001235,0000650,0000002102,'','Y',2,'Y','Y','Y','Y'),(00001238,0000651,0000002104,'','Y',1,'Y','Y','Y','Y'),(00001239,0000651,0000002105,'','Y',3,'Y','Y','Y','Y'),(00001240,0000652,0000002107,'','Y',1,'Y','Y','Y','Y'),(00001241,0000652,0000002108,'','Y',2,'Y','Y','Y','Y'),(00001244,0000617,0000001089,'','Y',1,'Y','Y','Y','Y'),(00001245,0000654,0000002114,'','Y',1,'Y','Y','Y','Y'),(00001246,0000654,0000002115,'','Y',2,'Y','Y','Y','Y'),(00001247,0000655,0000002117,'','Y',1,'Y','Y','Y','Y'),(00001248,0000655,0000002118,'','Y',2,'Y','Y','Y','Y'),(00001249,0000656,0000002025,'','Y',1,'Y','Y','Y','Y'),(00001250,0000656,0000002026,'','Y',2,'Y','Y','Y','Y'),(00001251,0000657,0000002121,'','Y',1,'Y','Y','Y','Y'),(00001252,0000657,0000002122,'','Y',2,'Y','Y','Y','Y'),(00001253,0000658,0000002124,'','Y',1,'Y','Y','Y','Y'),(00001254,0000658,0000002125,'','Y',2,'Y','Y','Y','Y'),(00001255,0000659,0000002127,'','Y',1,'Y','Y','Y','Y'),(00001256,0000659,0000002128,'','Y',2,'Y','Y','Y','Y'),(00001257,0000660,0000002130,'','Y',1,'Y','Y','Y','Y'),(00001258,0000660,0000002131,'','Y',2,'Y','Y','Y','Y'),(00001259,0000661,0000002136,'','Y',1,'Y','Y','Y','Y'),(00001260,0000661,0000002137,'','Y',2,'Y','Y','Y','Y'),(00001261,0000662,0000002139,'','Y',1,'Y','Y','Y','Y'),(00001262,0000662,0000002140,'','Y',2,'Y','Y','Y','Y'),(00001263,0000663,0000002142,'','Y',1,'Y','Y','Y','Y'),(00001264,0000663,0000002143,'','Y',2,'Y','Y','Y','Y'),(00001265,0000664,0000002146,'','Y',1,'Y','Y','Y','Y'),(00001266,0000664,0000002147,'','Y',2,'Y','Y','Y','Y'),(00001270,0000669,0000002157,'','Y',1,'Y','Y','Y','Y'),(00001271,0000669,0000002158,'','Y',2,'Y','Y','Y','Y'),(00001272,0000670,0000002161,'','Y',1,'Y','Y','Y','Y'),(00001273,0000670,0000002162,'','Y',2,'Y','Y','Y','Y'),(00001274,0000671,0000002164,'','Y',1,'Y','Y','Y','Y'),(00001275,0000671,0000002165,'','Y',2,'Y','Y','Y','Y'),(00001276,0000672,0000002167,'','Y',1,'Y','Y','Y','Y'),(00001277,0000672,0000002168,'','Y',2,'Y','Y','Y','Y'),(00001278,0000673,0000002170,'','Y',1,'Y','Y','Y','Y'),(00001279,0000673,0000002171,'','Y',2,'Y','Y','Y','Y'),(00001280,0000674,0000002173,'','Y',1,'Y','Y','Y','Y'),(00001281,0000674,0000002174,'','Y',2,'Y','Y','Y','Y'),(00001282,0000675,0000002176,'','Y',1,'Y','Y','Y','Y'),(00001283,0000675,0000002177,'','Y',2,'Y','Y','Y','Y'),(00001284,0000676,0000002179,'','Y',1,'Y','Y','Y','Y'),(00001285,0000676,0000002180,'','Y',2,'Y','Y','Y','Y'),(00001286,0000677,0000002182,'','Y',1,'Y','Y','Y','Y'),(00001287,0000677,0000002183,'','Y',2,'Y','Y','Y','Y'),(00001288,0000678,0000002185,'','Y',1,'Y','Y','Y','Y'),(00001289,0000678,0000002186,'','Y',2,'Y','Y','Y','Y'),(00001290,0000679,0000002188,'','Y',1,'Y','Y','Y','Y'),(00001291,0000679,0000002189,'','Y',2,'Y','Y','Y','Y'),(00001292,0000680,0000002191,'','Y',1,'Y','Y','Y','Y'),(00001293,0000680,0000002192,'','Y',2,'Y','Y','Y','Y'),(00001294,0000681,0000002195,'','Y',1,'Y','Y','Y','Y'),(00001295,0000681,0000002196,'','Y',2,'Y','Y','Y','Y'),(00001296,0000682,0000002198,'','Y',1,'Y','Y','Y','Y'),(00001297,0000682,0000002199,'','Y',2,'Y','Y','Y','Y'),(00001298,0000683,0000002201,'','Y',1,'Y','Y','Y','Y'),(00001299,0000683,0000002202,'','Y',2,'Y','Y','Y','Y'),(00001300,0000684,0000002204,'','Y',1,'Y','Y','Y','Y'),(00001301,0000684,0000002205,'','Y',2,'Y','Y','Y','Y'),(00001302,0000685,0000002207,'','Y',1,'Y','Y','Y','Y'),(00001303,0000685,0000002208,'','Y',2,'Y','Y','Y','Y'),(00001304,0000686,0000002210,'','Y',1,'Y','Y','Y','Y'),(00001305,0000686,0000002211,'','Y',2,'Y','Y','Y','Y'),(00001306,0000687,0000002213,'','Y',1,'Y','Y','Y','Y'),(00001307,0000687,0000002214,'','Y',2,'Y','Y','Y','Y'),(00001308,0000688,0000002217,'','Y',1,'Y','Y','Y','Y'),(00001309,0000688,0000002218,'','Y',2,'Y','Y','Y','Y'),(00001310,0000689,0000002220,'','Y',1,'Y','Y','Y','Y'),(00001311,0000689,0000002221,'','Y',2,'Y','Y','Y','Y'),(00001312,0000690,0000002223,'','Y',1,'Y','Y','Y','Y'),(00001313,0000690,0000002224,'','Y',2,'Y','Y','Y','Y'),(00001314,0000691,0000002226,'','Y',1,'Y','Y','Y','Y'),(00001315,0000691,0000002227,'','Y',2,'Y','Y','Y','Y'),(00001316,0000692,0000002229,'','Y',1,'Y','Y','Y','Y'),(00001317,0000692,0000002230,'','Y',2,'Y','Y','Y','Y'),(00001318,0000693,0000002234,'','Y',1,'Y','Y','Y','Y'),(00001319,0000693,0000002235,'','Y',2,'Y','Y','Y','Y'),(00001320,0000694,0000002237,'','Y',1,'Y','Y','Y','Y'),(00001321,0000694,0000002238,'','Y',2,'Y','Y','Y','Y'),(00001322,0000695,0000002241,'','Y',1,'Y','Y','Y','Y'),(00001323,0000695,0000002242,'','Y',2,'Y','Y','Y','Y'),(00001324,0000696,0000002245,'','Y',1,'Y','Y','Y','Y'),(00001325,0000696,0000002246,'','Y',2,'Y','Y','Y','Y'),(00001328,0000698,0000002251,'','Y',1,'Y','Y','Y','Y'),(00001329,0000698,0000002252,'','Y',2,'Y','Y','Y','Y'),(00001330,0000699,0000002254,'','Y',1,'Y','Y','Y','Y'),(00001331,0000699,0000002255,'','Y',2,'Y','Y','Y','Y'),(00001332,0000700,0000002257,'','Y',1,'Y','Y','Y','Y'),(00001333,0000700,0000002258,'','Y',2,'Y','Y','Y','Y'),(00001334,0000701,0000002260,'','Y',1,'Y','Y','Y','Y'),(00001335,0000701,0000002261,'','Y',2,'Y','Y','Y','Y'),(00001336,0000702,0000002263,'','Y',1,'Y','Y','Y','Y'),(00001337,0000702,0000002264,'','Y',2,'Y','Y','Y','Y'),(00001340,0000704,0000002269,'','Y',1,'Y','Y','Y','Y'),(00001341,0000704,0000002270,'','Y',2,'Y','Y','Y','Y'),(00001342,0000705,0000002272,'','Y',1,'Y','Y','Y','Y'),(00001343,0000705,0000002273,'','Y',2,'Y','Y','Y','Y'),(00001344,0000706,0000002275,'','Y',1,'Y','Y','Y','Y'),(00001345,0000706,0000002276,'','Y',2,'Y','Y','Y','Y'),(00001346,0000707,0000002278,'','Y',1,'Y','Y','Y','Y'),(00001347,0000707,0000002279,'','Y',2,'Y','Y','Y','Y'),(00001349,0000708,0000002281,'','Y',1,'Y','Y','Y','Y'),(00001350,0000708,0000002282,'','Y',2,'Y','Y','Y','Y'),(00001351,0000709,0000002284,'','Y',1,'Y','Y','Y','Y'),(00001352,0000709,0000002285,'','Y',2,'Y','Y','Y','Y'),(00001353,0000710,0000002287,'','Y',1,'Y','Y','Y','Y'),(00001354,0000710,0000002288,'','Y',2,'Y','Y','Y','Y'),(00001355,0000711,0000002294,'','Y',1,'Y','Y','Y','Y'),(00001356,0000711,0000002295,'','Y',2,'Y','Y','Y','Y'),(00001357,0000712,0000002297,'','Y',1,'Y','Y','Y','Y'),(00001358,0000712,0000002298,'','Y',2,'Y','Y','Y','Y'),(00001359,0000713,0000002300,'','Y',1,'Y','Y','Y','Y'),(00001360,0000713,0000002301,'','Y',2,'Y','Y','Y','Y'),(00001361,0000714,0000002303,'','Y',1,'Y','Y','Y','Y'),(00001362,0000714,0000002304,'','Y',2,'Y','Y','Y','Y'),(00001363,0000715,0000002307,'','Y',1,'Y','Y','Y','Y'),(00001364,0000715,0000002308,'','Y',2,'Y','Y','Y','Y'),(00001365,0000716,0000002310,'','Y',1,'Y','Y','Y','Y'),(00001366,0000716,0000002311,'','Y',2,'Y','Y','Y','Y'),(00001369,0000717,0000002314,'','Y',1,'Y','Y','Y','Y'),(00001370,0000717,0000002315,'','Y',2,'Y','Y','Y','Y'),(00001371,0000718,0000002317,'','Y',1,'Y','Y','Y','Y'),(00001372,0000718,0000002318,'','Y',2,'Y','Y','Y','Y'),(00001373,0000719,0000002320,'','Y',1,'Y','Y','Y','Y'),(00001374,0000719,0000002321,'','Y',2,'Y','Y','Y','Y'),(00001375,0000720,0000002324,'','Y',1,'Y','Y','Y','Y'),(00001376,0000720,0000002325,'','Y',2,'Y','Y','Y','Y'),(00001377,0000721,0000002328,'','Y',1,'Y','Y','Y','Y'),(00001378,0000721,0000002329,'','Y',2,'Y','Y','Y','Y'),(00001379,0000722,0000002331,'','Y',1,'Y','Y','Y','Y'),(00001380,0000722,0000002332,'','Y',2,'Y','Y','Y','Y'),(00001381,0000723,0000002335,'','Y',1,'Y','Y','Y','Y'),(00001382,0000723,0000002336,'','Y',2,'Y','Y','Y','Y'),(00001383,0000724,0000002338,'','Y',1,'Y','Y','Y','Y'),(00001384,0000724,0000002339,'','Y',2,'Y','Y','Y','Y'),(00001385,0000725,0000002341,'','Y',1,'Y','Y','Y','Y'),(00001386,0000725,0000002342,'','Y',2,'Y','Y','Y','Y'),(00001387,0000726,0000002351,'','Y',1,'Y','Y','Y','Y'),(00001388,0000726,0000002352,'','Y',2,'Y','Y','Y','Y'),(00001389,0000727,0000002354,'','Y',1,'Y','Y','Y','Y'),(00001390,0000727,0000002355,'','Y',2,'Y','Y','Y','Y'),(00001392,0000728,0000002358,'','Y',1,'Y','Y','Y','Y'),(00001393,0000728,0000002359,'','Y',2,'Y','Y','Y','Y'),(00001394,0000729,0000002361,'','Y',1,'Y','Y','Y','Y'),(00001395,0000729,0000002362,'','Y',2,'Y','Y','Y','Y'),(00001396,0000730,0000002365,'','Y',1,'Y','Y','Y','Y'),(00001397,0000730,0000002366,'','Y',2,'Y','Y','Y','Y'),(00001398,0000731,0000002368,'','Y',1,'Y','Y','Y','Y'),(00001399,0000731,0000002369,'','Y',2,'Y','Y','Y','Y'),(00001400,0000732,0000002372,'','Y',1,'Y','Y','Y','Y'),(00001401,0000732,0000002373,'','Y',2,'Y','Y','Y','Y'),(00001402,0000733,0000002375,'','Y',1,'Y','Y','Y','Y'),(00001403,0000733,0000002376,'','Y',2,'Y','Y','Y','Y'),(00001404,0000734,0000002381,'','Y',1,'Y','Y','Y','Y'),(00001405,0000734,0000002382,'','Y',2,'Y','Y','Y','Y'),(00001406,0000735,0000002384,'','Y',1,'Y','Y','Y','Y'),(00001407,0000735,0000002385,'','Y',2,'Y','Y','Y','Y'),(00001408,0000736,0000002387,'','Y',1,'Y','Y','Y','Y'),(00001409,0000736,0000002388,'','Y',2,'Y','Y','Y','Y'),(00001410,0000737,0000002390,'','Y',1,'Y','Y','Y','Y'),(00001411,0000737,0000002391,'','Y',2,'Y','Y','Y','Y'),(00001412,0000738,0000002393,'','Y',1,'Y','Y','Y','Y'),(00001413,0000738,0000002394,'','Y',2,'Y','Y','Y','Y'),(00001414,0000739,0000002396,'','Y',1,'Y','Y','Y','Y'),(00001415,0000739,0000002397,'','Y',2,'Y','Y','Y','Y'),(00001416,0000740,0000002399,'','Y',1,'Y','Y','Y','Y'),(00001417,0000740,0000002400,'','Y',2,'Y','Y','Y','Y'),(00001418,0000741,0000002402,'','Y',1,'Y','Y','Y','Y'),(00001419,0000741,0000002403,'','Y',2,'Y','Y','Y','Y'),(00001420,0000742,0000002405,'','Y',1,'Y','Y','Y','Y'),(00001421,0000742,0000002406,'','Y',2,'Y','Y','Y','Y'),(00001422,0000743,0000002408,'','Y',1,'Y','Y','Y','Y'),(00001423,0000734,0000002409,'','Y',3,'Y','Y','Y','Y'),(00001424,0000744,0000002412,'','Y',1,'Y','Y','Y','Y'),(00001425,0000744,0000002413,'','Y',2,'Y','Y','Y','Y'),(00001430,0000746,0000002418,'','Y',1,'Y','Y','Y','Y'),(00001431,0000746,0000002419,'','Y',2,'Y','Y','Y','Y'),(00001432,0000747,0000002421,'','Y',3,'Y','Y','Y','Y'),(00001433,0000747,0000002422,'','Y',1,'Y','Y','Y','Y'),(00001434,0000747,0000002423,'','Y',2,'Y','Y','Y','Y'),(00001435,0000748,0000000119,'','Y',1,'Y','Y','Y','Y'),(00001436,0000748,0000002428,'','Y',2,'Y','Y','Y','Y'),(00001437,0000643,0000002429,'','Y',1,'Y','Y','Y','Y'),(00001444,0000749,0000002431,'','Y',1,'Y','Y','Y','Y'),(00001445,0000749,0000002432,'','Y',2,'Y','Y','Y','Y'),(00001446,0000750,0000002434,'','Y',1,'Y','Y','Y','Y'),(00001447,0000750,0000002435,'','Y',2,'Y','Y','Y','Y'),(00001449,0000751,0000002437,'','Y',1,'Y','Y','Y','Y'),(00001450,0000751,0000002438,'','Y',2,'Y','Y','Y','Y'),(00001451,0000752,0000002442,'','Y',1,'Y','Y','Y','Y'),(00001452,0000752,0000002443,'','Y',2,'Y','Y','Y','Y'),(00001453,0000753,0000002445,'','Y',1,'Y','Y','Y','Y'),(00001454,0000753,0000002446,'','Y',2,'Y','Y','Y','Y'),(00001455,0000754,0000002448,'','Y',1,'Y','Y','Y','Y'),(00001456,0000754,0000002449,'','Y',2,'Y','Y','Y','Y'),(00001457,0000755,0000002451,'','Y',1,'Y','Y','Y','Y'),(00001458,0000755,0000002452,'','Y',2,'Y','Y','Y','Y'),(00001459,0000756,0000002454,'','Y',1,'Y','Y','Y','Y'),(00001460,0000756,0000002455,'','Y',2,'Y','Y','Y','Y'),(00001461,0000757,0000002457,'','Y',1,'Y','Y','Y','Y'),(00001462,0000757,0000002458,'','Y',2,'Y','Y','Y','Y'),(00001465,0000759,0000002464,'','Y',1,'Y','Y','Y','Y'),(00001466,0000759,0000002465,'','Y',2,'Y','Y','Y','Y'),(00001467,0000760,0000002467,'','Y',1,'Y','Y','Y','Y'),(00001468,0000760,0000002468,'','Y',2,'Y','Y','Y','Y'),(00001469,0000761,0000002470,'','Y',1,'Y','Y','Y','Y'),(00001470,0000761,0000002471,'','Y',2,'Y','Y','Y','Y'),(00001471,0000762,0000002474,'','Y',1,'Y','Y','Y','Y'),(00001472,0000762,0000002475,'','Y',2,'Y','Y','Y','Y'),(00001473,0000763,0000002477,'','Y',1,'Y','Y','Y','Y'),(00001474,0000763,0000002478,'','Y',2,'Y','Y','Y','Y'),(00001475,0000764,0000002480,'','Y',1,'Y','Y','Y','Y'),(00001476,0000764,0000002481,'','Y',2,'Y','Y','Y','Y'),(00001477,0000765,0000002483,'','Y',1,'Y','Y','Y','Y'),(00001478,0000765,0000002484,'','Y',2,'Y','Y','Y','Y'),(00001481,0000767,0000002489,'','Y',1,'Y','Y','Y','Y'),(00001482,0000768,0000002492,'','Y',1,'Y','Y','Y','Y'),(00001483,0000768,0000002493,'','Y',2,'Y','Y','Y','Y'),(00001485,0000769,0000002496,'','Y',1,'Y','Y','Y','Y'),(00001486,0000769,0000002497,'','Y',2,'Y','Y','Y','Y'),(00001487,0000770,0000002499,'','Y',2,'Y','Y','Y','Y'),(00001488,0000770,0000002500,'','Y',1,'Y','Y','Y','Y'),(00001489,0000771,0000002502,'','Y',1,'Y','Y','Y','Y'),(00001490,0000771,0000002503,'','Y',2,'Y','Y','Y','Y'),(00001491,0000772,0000002506,'','Y',1,'Y','Y','Y','Y'),(00001492,0000772,0000002507,'','Y',2,'Y','Y','Y','Y'),(00001493,0000773,0000002509,'','Y',1,'Y','Y','Y','Y'),(00001494,0000773,0000002510,'','Y',2,'Y','Y','Y','Y'),(00001495,0000774,0000002512,'','Y',1,'Y','Y','Y','Y'),(00001496,0000774,0000002513,'','Y',2,'Y','Y','Y','Y'),(00001497,0000775,0000002515,'','Y',1,'Y','Y','Y','Y'),(00001498,0000775,0000002516,'','Y',2,'Y','Y','Y','Y'),(00001499,0000776,0000002518,'','Y',1,'Y','Y','Y','Y'),(00001500,0000776,0000002519,'','Y',2,'Y','Y','Y','Y'),(00001501,0000777,0000002521,'','Y',1,'Y','Y','Y','Y'),(00001502,0000777,0000002522,'','Y',2,'Y','Y','Y','Y'),(00001503,0000778,0000002524,'','Y',1,'Y','Y','Y','Y'),(00001504,0000778,0000002525,'','Y',2,'Y','Y','Y','Y'),(00001505,0000779,0000002527,'','Y',1,'Y','Y','Y','Y'),(00001506,0000779,0000002528,'','Y',2,'Y','Y','Y','Y'),(00001507,0000780,0000002530,'','Y',1,'Y','Y','Y','Y'),(00001508,0000780,0000002531,'','Y',2,'Y','Y','Y','Y'),(00001510,0000781,0000002533,'','Y',1,'Y','Y','Y','Y'),(00001511,0000781,0000002534,'','Y',2,'Y','Y','Y','Y'),(00001512,0000782,0000002536,'','Y',1,'Y','Y','Y','Y'),(00001513,0000783,0000002538,'','Y',1,'Y','Y','Y','Y'),(00001514,0000783,0000002539,'','Y',2,'Y','Y','Y','Y'),(00001515,0000784,0000002542,'','Y',1,'Y','Y','Y','Y'),(00001516,0000784,0000002543,'','Y',2,'Y','Y','Y','Y'),(00001517,0000785,0000002546,'','Y',1,'Y','Y','Y','Y'),(00001518,0000785,0000002547,'','Y',2,'Y','Y','Y','Y'),(00001519,0000786,0000002549,'','Y',1,'Y','Y','Y','Y'),(00001520,0000786,0000002550,'','Y',2,'Y','Y','Y','Y'),(00001521,0000787,0000002556,'','Y',1,'Y','Y','Y','Y'),(00001522,0000787,0000002557,'','Y',2,'Y','Y','Y','Y'),(00001523,0000788,0000002559,'','Y',1,'Y','Y','Y','Y'),(00001524,0000788,0000002560,'','Y',2,'Y','Y','Y','Y'),(00001525,0000789,0000002564,'','Y',1,'Y','Y','Y','Y'),(00001526,0000789,0000002565,'','Y',2,'Y','Y','Y','Y'),(00001527,0000790,0000002568,'','Y',1,'Y','Y','Y','Y'),(00001528,0000790,0000002569,'','Y',2,'Y','Y','Y','Y'),(00001529,0000791,0000002571,'','Y',1,'Y','Y','Y','Y'),(00001530,0000791,0000002572,'','Y',2,'Y','Y','Y','Y'),(00001531,0000792,0000002574,'','Y',1,'Y','Y','Y','Y'),(00001532,0000792,0000002575,'','Y',2,'Y','Y','Y','Y'),(00001533,0000793,0000002578,'','Y',1,'Y','Y','Y','Y'),(00001534,0000793,0000002579,'','Y',2,'Y','Y','Y','Y'),(00001535,0000794,0000002581,'','Y',1,'Y','Y','Y','Y'),(00001536,0000794,0000002582,'','Y',2,'Y','Y','Y','Y'),(00001537,0000795,0000002584,'','Y',1,'Y','Y','Y','Y'),(00001538,0000795,0000002585,'','Y',2,'Y','Y','Y','Y'),(00001539,0000796,0000002587,'','Y',1,'Y','Y','Y','Y'),(00001540,0000796,0000002588,'','Y',2,'Y','Y','Y','Y'),(00001541,0000797,0000002590,'','Y',1,'Y','Y','Y','Y'),(00001542,0000797,0000002591,'','Y',2,'Y','Y','Y','Y'),(00001543,0000798,0000002593,'','Y',1,'Y','Y','Y','Y'),(00001544,0000798,0000002594,'','Y',2,'Y','Y','Y','Y'),(00001545,0000799,0000002596,'','Y',1,'Y','Y','Y','Y'),(00001546,0000799,0000002597,'','Y',2,'Y','Y','Y','Y'),(00001547,0000800,0000002599,'','Y',1,'Y','Y','Y','Y'),(00001548,0000800,0000002600,'','Y',2,'Y','Y','Y','Y'),(00001549,0000801,0000002602,'','Y',1,'Y','Y','Y','Y'),(00001550,0000801,0000002603,'','Y',2,'Y','Y','Y','Y'),(00001551,0000802,0000002605,'','Y',1,'Y','Y','Y','Y'),(00001552,0000802,0000002606,'','Y',2,'Y','Y','Y','Y'),(00001553,0000803,0000002608,'','Y',1,'Y','Y','Y','Y'),(00001554,0000803,0000002609,'','Y',2,'Y','Y','Y','Y'),(00001555,0000804,0000002612,'','Y',1,'Y','Y','Y','Y'),(00001556,0000804,0000002613,'','Y',2,'Y','Y','Y','Y'),(00001557,0000805,0000002616,'','Y',1,'Y','Y','Y','Y'),(00001558,0000805,0000002617,'','Y',2,'Y','Y','Y','Y'),(00001559,0000806,0000002619,'','Y',1,'Y','Y','Y','Y'),(00001560,0000806,0000002620,'','Y',2,'Y','Y','Y','Y'),(00001561,0000807,0000002622,'','Y',1,'Y','Y','Y','Y'),(00001562,0000807,0000002623,'','Y',2,'Y','Y','Y','Y'),(00001563,0000808,0000002625,'','Y',1,'Y','Y','Y','Y'),(00001564,0000808,0000002626,'','Y',2,'Y','Y','Y','Y'),(00001565,0000809,0000002628,'','Y',1,'Y','Y','Y','Y'),(00001566,0000809,0000002629,'','Y',2,'Y','Y','Y','Y'),(00001567,0000810,0000002631,'','Y',1,'Y','Y','Y','Y'),(00001568,0000810,0000002632,'','Y',2,'Y','Y','Y','Y'),(00001569,0000811,0000002634,'','Y',1,'Y','Y','Y','Y'),(00001570,0000811,0000002635,'','Y',2,'Y','Y','Y','Y'),(00001571,0000812,0000002637,'','Y',1,'Y','Y','Y','Y'),(00001572,0000812,0000002638,'','Y',2,'Y','Y','Y','Y'),(00001573,0000813,0000002640,'','Y',1,'Y','Y','Y','Y'),(00001574,0000813,0000002641,'','Y',2,'Y','Y','Y','Y'),(00001575,0000814,0000002643,'','Y',1,'Y','Y','Y','Y'),(00001576,0000814,0000002644,'','Y',2,'Y','Y','Y','Y'),(00001577,0000815,0000002646,'','Y',1,'Y','Y','Y','Y'),(00001578,0000815,0000002647,'','Y',2,'Y','Y','Y','Y'),(00001579,0000816,0000002649,'','Y',1,'Y','Y','Y','Y'),(00001580,0000816,0000002650,'','Y',2,'Y','Y','Y','Y'),(00001581,0000817,0000002653,'','Y',1,'Y','Y','Y','Y'),(00001582,0000818,0000002655,'','Y',1,'Y','Y','Y','Y'),(00001583,0000818,0000002656,'','Y',2,'Y','Y','Y','Y'),(00001584,0000819,0000002658,'','Y',1,'Y','Y','Y','Y'),(00001585,0000819,0000002659,'','Y',2,'Y','Y','Y','Y'),(00001586,0000820,0000002661,'','Y',1,'Y','Y','Y','Y'),(00001587,0000820,0000002662,'','Y',2,'Y','Y','Y','Y'),(00001588,0000821,0000002664,'','Y',1,'Y','Y','Y','Y'),(00001589,0000821,0000002665,'','Y',2,'Y','Y','Y','Y'),(00001590,0000822,0000002668,'','Y',1,'Y','Y','Y','Y'),(00001591,0000822,0000002669,'','Y',2,'Y','Y','Y','Y'),(00001592,0000823,0000002671,'','Y',1,'Y','Y','Y','Y'),(00001593,0000823,0000002672,'','Y',2,'Y','Y','Y','Y'),(00001594,0000824,0000002674,'','Y',1,'Y','Y','Y','Y'),(00001595,0000824,0000002675,'','Y',2,'Y','Y','Y','Y'),(00001596,0000825,0000002677,'','Y',1,'Y','Y','Y','Y'),(00001597,0000825,0000002678,'','Y',2,'Y','Y','Y','Y'),(00001598,0000826,0000002681,'','Y',1,'Y','Y','Y','Y'),(00001599,0000826,0000002682,'','Y',2,'Y','Y','Y','Y'),(00001600,0000827,0000002684,'','Y',1,'Y','Y','Y','Y'),(00001601,0000827,0000002685,'','Y',2,'Y','Y','Y','Y'),(00001602,0000828,0000002687,'','Y',1,'Y','Y','Y','Y'),(00001603,0000828,0000002688,'','Y',2,'Y','Y','Y','Y'),(00001604,0000829,0000002690,'','Y',1,'Y','Y','Y','Y'),(00001605,0000829,0000002691,'','Y',2,'Y','Y','Y','Y'),(00001606,0000830,0000002693,'','Y',1,'Y','Y','Y','Y'),(00001607,0000830,0000002694,'','Y',2,'Y','Y','Y','Y'),(00001608,0000831,0000002697,'','Y',1,'Y','Y','Y','Y'),(00001609,0000831,0000002698,'','Y',2,'Y','Y','Y','Y'),(00001612,0000832,0000002701,'','Y',1,'Y','Y','Y','Y'),(00001613,0000833,0000002703,'','Y',1,'Y','Y','Y','Y'),(00001614,0000833,0000002704,'','Y',2,'Y','Y','Y','Y'),(00001615,0000834,0000002706,'','Y',1,'Y','Y','Y','Y'),(00001616,0000834,0000002707,'','Y',2,'Y','Y','Y','Y'),(00001617,0000835,0000002709,'','Y',1,'Y','Y','Y','Y'),(00001618,0000835,0000002710,'','Y',2,'Y','Y','Y','Y'),(00001619,0000836,0000002712,'','Y',1,'Y','Y','Y','Y'),(00001620,0000836,0000002713,'','Y',2,'Y','Y','Y','Y'),(00001621,0000837,0000002716,'','Y',1,'Y','Y','Y','Y'),(00001622,0000837,0000002717,'','Y',2,'Y','Y','Y','Y'),(00001623,0000838,0000002720,'','Y',1,'Y','Y','Y','Y'),(00001624,0000838,0000002721,'','Y',2,'Y','Y','Y','Y'),(00001625,0000839,0000002724,'','Y',1,'Y','Y','Y','Y'),(00001626,0000839,0000002725,'','Y',2,'Y','Y','Y','Y'),(00001627,0000840,0000002727,'','Y',1,'Y','Y','Y','Y'),(00001628,0000840,0000002728,'','Y',2,'Y','Y','Y','Y'),(00001629,0000841,0000002730,'','Y',1,'Y','Y','Y','Y'),(00001630,0000841,0000002731,'','Y',2,'Y','Y','Y','Y'),(00001632,0000842,0000002738,'','Y',1,'Y','Y','Y','Y'),(00001633,0000842,0000002739,'','Y',2,'Y','Y','Y','Y'),(00001635,0000843,0000002741,'','Y',1,'Y','Y','Y','Y'),(00001636,0000843,0000002742,'','Y',2,'Y','Y','Y','Y'),(00001637,0000844,0000002744,'','Y',1,'Y','Y','Y','Y'),(00001638,0000844,0000002745,'','Y',2,'Y','Y','Y','Y'),(00001639,0000845,0000002747,'','Y',1,'Y','Y','Y','Y'),(00001640,0000845,0000002748,'','Y',2,'Y','Y','Y','Y'),(00001641,0000846,0000002750,'','Y',1,'Y','Y','Y','Y'),(00001642,0000846,0000002751,'','Y',2,'Y','Y','Y','Y'),(00001643,0000847,0000002753,'','Y',1,'Y','Y','Y','Y'),(00001644,0000848,0000002755,'','Y',1,'Y','Y','Y','Y'),(00001645,0000848,0000002756,'','Y',2,'Y','Y','Y','Y'),(00001646,0000849,0000002758,'','Y',1,'Y','Y','Y','Y'),(00001647,0000849,0000002759,'','Y',2,'Y','Y','Y','Y'),(00001648,0000850,0000002762,'','Y',1,'Y','Y','Y','Y'),(00001649,0000850,0000002763,'','Y',2,'Y','Y','Y','Y'),(00001650,0000851,0000002765,'','Y',1,'Y','Y','Y','Y'),(00001651,0000851,0000002766,'','Y',2,'Y','Y','Y','Y'),(00001652,0000852,0000002768,'','Y',1,'Y','Y','Y','Y'),(00001653,0000852,0000002769,'','Y',2,'Y','Y','Y','Y'),(00001654,0000853,0000002771,'','Y',1,'Y','Y','Y','Y'),(00001655,0000853,0000002772,'','Y',2,'Y','Y','Y','Y');

--
-- 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 AUTO_INCREMENT=1032 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFamilyChild`
--

INSERT INTO `gibbonFamilyChild` VALUES (00000017,0000001,0000000005,''),(00000018,0000003,0000000115,''),(00000019,0000004,0000000090,''),(00000020,0000004,0000000034,''),(00000021,0000005,0000000058,''),(00000022,0000006,0000000018,''),(00000023,0000007,0000000068,''),(00000024,0000008,0000000071,''),(00000025,0000009,0000000075,''),(00000026,0000010,0000000092,''),(00000027,0000012,0000000084,''),(00000028,0000013,0000000012,''),(00000029,0000014,0000000007,''),(00000030,0000015,0000000023,''),(00000031,0000016,0000000069,''),(00000032,0000017,0000000086,''),(00000033,0000018,0000000102,''),(00000034,0000019,0000000051,''),(00000035,0000020,0000000095,''),(00000036,0000020,0000000025,''),(00000037,0000021,0000000085,''),(00000038,0000022,0000000014,''),(00000040,0000023,0000000083,''),(00000041,0000024,0000000111,''),(00000042,0000025,0000000032,''),(00000043,0000026,0000000038,''),(00000044,0000027,0000000024,''),(00000045,0000028,0000000042,''),(00000047,0000030,0000000063,''),(00000049,0000032,0000000022,''),(00000050,0000033,0000000046,''),(00000051,0000034,0000000048,''),(00000052,0000035,0000000105,''),(00000053,0000035,0000000021,''),(00000054,0000036,0000000020,''),(00000055,0000037,0000000091,''),(00000056,0000007,0000000027,''),(00000057,0000038,0000000044,''),(00000058,0000039,0000000104,''),(00000059,0000041,0000000074,''),(00000060,0000042,0000000011,''),(00000061,0000043,0000000064,''),(00000062,0000044,0000000013,''),(00000063,0000045,0000000026,''),(00000064,0000046,0000000070,''),(00000065,0000047,0000000004,''),(00000066,0000047,0000000009,''),(00000068,0000050,0000000059,''),(00000071,0000051,0000000017,''),(00000072,0000052,0000000060,''),(00000073,0000014,0000000103,''),(00000074,0000053,0000000053,''),(00000075,0000054,0000000052,''),(00000076,0000055,0000000106,''),(00000077,0000055,0000000041,''),(00000078,0000056,0000000036,''),(00000079,0000056,0000000099,''),(00000081,0000058,0000000080,''),(00000082,0000058,0000000066,''),(00000083,0000059,0000000089,''),(00000084,0000060,0000000031,''),(00000085,0000061,0000000101,''),(00000086,0000062,0000000077,''),(00000087,0000063,0000000006,''),(00000088,0000065,0000000050,''),(00000089,0000067,0000000047,''),(00000090,0000071,0000000033,''),(00000091,0000072,0000000055,''),(00000092,0000073,0000000138,''),(00000093,0000074,0000000010,''),(00000094,0000075,0000000043,''),(00000095,0000076,0000000002,''),(00000096,0000028,0000000098,''),(00000097,0000078,0000000073,''),(00000098,0000079,0000000030,''),(00000099,0000080,0000000113,''),(00000100,0000081,0000000037,''),(00000101,0000082,0000000116,''),(00000103,0000083,0000000093,''),(00000104,0000083,0000000114,''),(00000105,0000084,0000000016,''),(00000106,0000085,0000000065,''),(00000108,0000087,0000000019,''),(00000109,0000088,0000000087,''),(00000110,0000089,0000000078,''),(00000111,0000089,0000000079,''),(00000112,0000090,0000000028,''),(00000113,0000091,0000000008,''),(00000114,0000092,0000000035,''),(00000115,0000092,0000000054,''),(00000116,0000077,0000000062,''),(00000117,0000093,0000000110,''),(00000120,0000095,0000000094,''),(00000121,0000095,0000000088,''),(00000122,0000096,0000000109,''),(00000123,0000097,0000000039,''),(00000124,0000098,0000000061,''),(00000125,0000099,0000000015,''),(00000127,0000101,0000000040,''),(00000128,0000102,0000000107,''),(00000129,0000103,0000000112,''),(00000130,0000105,0000000045,''),(00000131,0000081,0000000081,''),(00000132,0000106,0000000056,''),(00000133,0000106,0000000003,''),(00000134,0000107,0000000108,''),(00000135,0000108,0000000345,''),(00000136,0000011,0000000169,''),(00000137,0000109,0000000057,''),(00000138,0000108,0000000352,''),(00000139,0000110,0000000097,''),(00000140,0000111,0000000223,''),(00000141,0000112,0000000351,''),(00000142,0000114,0000000353,''),(00000143,0000114,0000000354,''),(00000144,0000116,0000000361,''),(00000145,0000117,0000000365,''),(00000146,0000118,0000000029,''),(00000147,0000121,0000000382,''),(00000148,0000123,0000000390,''),(00000150,0000124,0000000393,''),(00000151,0000131,0000000396,''),(00000152,0000130,0000000399,''),(00000153,0000126,0000000443,''),(00000154,0000128,0000000403,''),(00000155,0000129,0000000405,''),(00000156,0000125,0000000411,''),(00000157,0000108,0000000379,''),(00000158,0000132,0000000413,''),(00000159,0000132,0000000416,''),(00000161,0000134,0000000420,''),(00000162,0000135,0000000423,''),(00000163,0000137,0000000429,''),(00000164,0000139,0000000435,''),(00000165,0000140,0000000438,''),(00000166,0000141,0000000380,''),(00000167,0000142,0000000445,''),(00000168,0000143,0000000448,''),(00000169,0000145,0000000452,''),(00000170,0000146,0000000454,''),(00000171,0000147,0000000457,''),(00000172,0000148,0000000461,''),(00000173,0000149,0000000464,''),(00000174,0000150,0000000467,''),(00000175,0000128,0000000473,''),(00000176,0000151,0000000470,''),(00000177,0000152,0000000474,''),(00000178,0000153,0000000477,''),(00000179,0000154,0000000480,''),(00000180,0000155,0000000483,''),(00000181,0000156,0000000486,''),(00000182,0000157,0000000489,''),(00000183,0000157,0000000492,''),(00000184,0000158,0000000493,''),(00000185,0000159,0000000496,''),(00000186,0000160,0000000498,''),(00000187,0000161,0000000501,''),(00000188,0000161,0000000505,''),(00000189,0000161,0000000504,''),(00000190,0000162,0000000506,''),(00000191,0000163,0000000509,''),(00000192,0000103,0000000512,''),(00000193,0000105,0000000513,''),(00000194,0000164,0000000515,''),(00000195,0000165,0000000518,''),(00000196,0000166,0000000521,''),(00000197,0000167,0000000524,''),(00000198,0000168,0000000527,''),(00000199,0000169,0000000530,''),(00000200,0000170,0000000533,''),(00000201,0000171,0000000539,''),(00000202,0000171,0000000536,''),(00000203,0000172,0000000540,''),(00000204,0000173,0000000543,''),(00000205,0000174,0000000546,''),(00000206,0000175,0000000549,''),(00000207,0000176,0000000552,''),(00000208,0000177,0000000555,''),(00000209,0000178,0000000558,''),(00000210,0000179,0000000561,''),(00000211,0000138,0000000432,''),(00000212,0000180,0000000426,''),(00000213,0000084,0000000389,''),(00000214,0000181,0000000569,''),(00000215,0000182,0000000568,''),(00000216,0000182,0000000567,''),(00000219,0000057,0000000574,''),(00000221,0000185,0000000577,''),(00000222,0000187,0000000582,''),(00000223,0000149,0000000082,''),(00000224,0000188,0000000585,''),(00000225,0000189,0000000591,''),(00000226,0000200,0000000617,''),(00000227,0000195,0000000605,''),(00000228,0000190,0000000593,''),(00000230,0000021,0000000592,''),(00000232,0000198,0000000611,''),(00000233,0000196,0000000606,''),(00000234,0000197,0000000609,''),(00000235,0000191,0000000596,''),(00000237,0000193,0000000601,''),(00000238,0000199,0000000614,''),(00000239,0000194,0000000602,''),(00000240,0000059,0000000632,''),(00000241,0000202,0000000629,''),(00000242,0000204,0000000635,''),(00000243,0000205,0000000638,''),(00000244,0000206,0000000640,''),(00000245,0000201,0000000625,''),(00000246,0000089,0000000681,''),(00000247,0000065,0000000699,''),(00000248,0000223,0000000690,''),(00000249,0000207,0000000643,''),(00000250,0000208,0000000646,''),(00000253,0000210,0000000652,''),(00000254,0000211,0000000655,''),(00000255,0000212,0000000658,''),(00000256,0000054,0000000661,''),(00000257,0000213,0000000662,''),(00000258,0000214,0000000664,''),(00000259,0000215,0000000667,''),(00000260,0000216,0000000670,''),(00000261,0000019,0000000673,''),(00000262,0000221,0000000684,''),(00000263,0000222,0000000686,''),(00000264,0000224,0000000693,''),(00000265,0000225,0000000696,''),(00000266,0000227,0000000702,''),(00000267,0000228,0000000705,''),(00000268,0000229,0000000708,''),(00000269,0000230,0000000711,''),(00000270,0000231,0000000714,''),(00000271,0000232,0000000716,''),(00000273,0000234,0000000722,''),(00000274,0000235,0000000725,''),(00000275,0000236,0000000728,''),(00000276,0000237,0000000731,''),(00000277,0000238,0000000734,''),(00000278,0000239,0000000737,''),(00000279,0000240,0000000740,''),(00000280,0000241,0000000742,''),(00000283,0000241,0000000748,''),(00000284,0000241,0000000745,''),(00000285,0000244,0000000751,''),(00000287,0000246,0000000757,''),(00000288,0000247,0000000760,''),(00000289,0000248,0000000763,''),(00000290,0000249,0000000766,''),(00000291,0000250,0000000776,''),(00000292,0000251,0000000779,''),(00000293,0000252,0000000781,''),(00000294,0000253,0000000784,''),(00000295,0000053,0000000754,''),(00000296,0000254,0000000787,''),(00000298,0000256,0000000793,''),(00000299,0000257,0000000796,''),(00000300,0000258,0000000799,''),(00000301,0000259,0000000802,''),(00000302,0000260,0000000805,''),(00000303,0000261,0000000808,''),(00000304,0000262,0000000814,''),(00000305,0000025,0000000678,''),(00000306,0000258,0000000790,''),(00000307,0000263,0000000817,''),(00000308,0000264,0000000820,''),(00000309,0000265,0000000826,''),(00000311,0000267,0000000599,''),(00000312,0000268,0000000829,''),(00000313,0000005,0000000831,''),(00000314,0000269,0000000832,''),(00000315,0000270,0000000836,''),(00000316,0000271,0000000841,''),(00000317,0000272,0000000843,''),(00000318,0000273,0000000846,''),(00000319,0000274,0000000849,''),(00000320,0000275,0000000852,''),(00000321,0000276,0000000855,''),(00000324,0000279,0000000863,''),(00000327,0000282,0000000876,''),(00000328,0000200,0000000879,''),(00000329,0000283,0000000880,''),(00000330,0000284,0000000883,''),(00000331,0000285,0000000885,''),(00000332,0000024,0000000888,''),(00000334,0000287,0000000891,''),(00000335,0000288,0000000894,''),(00000336,0000289,0000000897,''),(00000338,0000108,0000000899,''),(00000340,0000134,0000000902,''),(00000341,0000292,0000000905,''),(00000342,0000293,0000000907,''),(00000343,0000294,0000000910,''),(00000344,0000295,0000000913,''),(00000345,0000296,0000000916,''),(00000346,0000297,0000000919,''),(00000347,0000298,0000000922,''),(00000348,0000148,0000000925,''),(00000349,0000299,0000000926,''),(00000350,0000300,0000000928,''),(00000352,0000047,0000000931,''),(00000354,0000232,0000000937,''),(00000355,0000303,0000000938,''),(00000356,0000304,0000000941,''),(00000357,0000305,0000000944,''),(00000359,0000305,0000000947,''),(00000360,0000307,0000000950,''),(00000361,0000308,0000000953,''),(00000362,0000309,0000000955,''),(00000363,0000310,0000000958,''),(00000365,0000312,0000000964,''),(00000366,0000313,0000000967,''),(00000367,0000037,0000000970,''),(00000368,0000314,0000000971,''),(00000369,0000315,0000000974,''),(00000370,0000316,0000000977,''),(00000371,0000317,0000000980,''),(00000372,0000318,0000000983,''),(00000374,0000156,0000000986,''),(00000375,0000034,0000000988,''),(00000376,0000320,0000000989,''),(00000377,0000321,0000000992,''),(00000378,0000322,0000000994,''),(00000380,0000170,0000000997,''),(00000382,0000171,0000001000,''),(00000383,0000325,0000001003,''),(00000384,0000326,0000001006,''),(00000385,0000327,0000001008,''),(00000386,0000328,0000001011,''),(00000387,0000329,0000001014,''),(00000388,0000330,0000001016,''),(00000389,0000331,0000001019,''),(00000390,0000332,0000001022,''),(00000391,0000333,0000001025,''),(00000392,0000334,0000001028,''),(00000393,0000335,0000001031,''),(00000394,0000336,0000001034,''),(00000395,0000337,0000001039,''),(00000396,0000338,0000001041,''),(00000397,0000339,0000001044,''),(00000398,0000340,0000001047,''),(00000399,0000341,0000001050,''),(00000400,0000342,0000001058,''),(00000402,0000344,0000001064,''),(00000403,0000345,0000001066,''),(00000404,0000346,0000001069,''),(00000405,0000347,0000001072,''),(00000406,0000348,0000001075,''),(00000407,0000342,0000001061,''),(00000408,0000050,0000000934,''),(00000409,0000009,0000000719,''),(00000410,0000003,0000000885,''),(00000411,0000212,0000000961,''),(00000412,0000349,0000001079,''),(00000413,0000350,0000001081,''),(00000414,0000351,0000001086,''),(00000415,0000352,0000001090,''),(00000416,0000353,0000001093,''),(00000417,0000354,0000001106,''),(00000418,0000355,0000001113,''),(00000419,0000356,0000001124,''),(00000420,0000357,0000001127,''),(00000421,0000293,0000001132,''),(00000422,0000358,0000001133,''),(00000424,0000360,0000001139,''),(00000425,0000361,0000001142,''),(00000427,0000363,0000001148,''),(00000428,0000364,0000001151,''),(00000429,0000365,0000001154,''),(00000430,0000366,0000001157,''),(00000431,0000367,0000001160,''),(00000432,0000368,0000001163,''),(00000433,0000369,0000001166,''),(00000434,0000370,0000001169,''),(00000435,0000371,0000001172,''),(00000436,0000372,0000001175,''),(00000437,0000264,0000001178,''),(00000438,0000373,0000001179,''),(00000439,0000374,0000001182,''),(00000441,0000376,0000001188,''),(00000442,0000377,0000001191,''),(00000443,0000378,0000001193,''),(00000444,0000275,0000001196,''),(00000445,0000379,0000001197,''),(00000446,0000331,0000001200,''),(00000447,0000380,0000001201,''),(00000448,0000381,0000001204,''),(00000449,0000382,0000001207,''),(00000450,0000383,0000001210,''),(00000451,0000185,0000001213,''),(00000452,0000384,0000001214,''),(00000453,0000197,0000001217,''),(00000454,0000385,0000001218,''),(00000455,0000145,0000001221,''),(00000456,0000386,0000001222,''),(00000457,0000213,0000001225,''),(00000458,0000180,0000001226,''),(00000459,0000387,0000001227,''),(00000461,0000389,0000001233,''),(00000462,0000390,0000001236,''),(00000463,0000391,0000001239,''),(00000464,0000392,0000001242,''),(00000465,0000393,0000001245,''),(00000466,0000394,0000001248,''),(00000467,0000395,0000001251,''),(00000468,0000396,0000001254,''),(00000470,0000398,0000001259,''),(00000471,0000095,0000001262,''),(00000472,0000399,0000001263,''),(00000473,0000400,0000001266,''),(00000476,0000131,0000001275,''),(00000477,0000403,0000001276,''),(00000478,0000404,0000001279,''),(00000479,0000405,0000001282,''),(00000480,0000406,0000001285,''),(00000481,0000407,0000001288,''),(00000482,0000408,0000001291,''),(00000483,0000223,0000001136,''),(00000484,0000342,0000001145,''),(00000485,0000251,0000001185,''),(00000486,0000289,0000001257,''),(00000487,0000265,0000001269,''),(00000488,0000045,0000001272,''),(00000489,0000409,0000001296,''),(00000490,0000410,0000001299,''),(00000491,0000411,0000001302,''),(00000492,0000412,0000001304,''),(00000493,0000413,0000001307,''),(00000494,0000414,0000001310,''),(00000495,0000412,0000001310,''),(00000496,0000415,0000001313,''),(00000497,0000416,0000001316,''),(00000499,0000418,0000001322,''),(00000500,0000419,0000001325,''),(00000502,0000022,0000000072,''),(00000504,0000422,0000001345,''),(00000506,0000062,0000001351,''),(00000507,0000425,0000001352,''),(00000508,0000426,0000001355,''),(00000509,0000427,0000001358,''),(00000511,0000429,0000001364,''),(00000513,0000431,0000001370,''),(00000514,0000204,0000001373,''),(00000515,0000432,0000001374,''),(00000516,0000148,0000001377,''),(00000517,0000017,0000001378,''),(00000518,0000433,0000001379,''),(00000519,0000434,0000001382,''),(00000520,0000435,0000001385,''),(00000521,0000436,0000001388,''),(00000522,0000437,0000001391,''),(00000523,0000438,0000001393,''),(00000524,0000439,0000001396,''),(00000525,0000378,0000001399,''),(00000526,0000440,0000001400,''),(00000527,0000441,0000001403,''),(00000529,0000261,0000001409,''),(00000531,0000416,0000001319,''),(00000532,0000416,0000001410,''),(00000533,0000444,0000001413,''),(00000534,0000445,0000001416,''),(00000535,0000446,0000001419,''),(00000536,0000447,0000001421,''),(00000537,0000448,0000001424,''),(00000538,0000449,0000001427,''),(00000539,0000450,0000001430,''),(00000540,0000451,0000001433,''),(00000541,0000338,0000001436,''),(00000542,0000452,0000001437,''),(00000543,0000199,0000001440,''),(00000544,0000453,0000001441,''),(00000545,0000261,0000001444,''),(00000546,0000454,0000001445,''),(00000548,0000456,0000001450,''),(00000549,0000457,0000001453,''),(00000550,0000338,0000001456,''),(00000553,0000460,0000001465,''),(00000554,0000461,0000001468,''),(00000555,0000462,0000001471,''),(00000556,0000463,0000001474,''),(00000557,0000464,0000001477,''),(00000559,0000466,0000001483,''),(00000560,0000467,0000001486,''),(00000561,0000468,0000001492,''),(00000562,0000469,0000001495,''),(00000563,0000470,0000001498,''),(00000564,0000034,0000001361,''),(00000565,0000154,0000000649,''),(00000566,0000471,0000001507,''),(00000567,0000472,0000001511,''),(00000568,0000473,0000001514,''),(00000570,0000475,0000001523,''),(00000571,0000282,0000001520,''),(00000572,0000476,0000001528,''),(00000573,0000477,0000001532,''),(00000575,0000477,0000001535,''),(00000576,0000212,0000001406,''),(00000577,0000479,0000001538,''),(00000578,0000480,0000001541,''),(00000580,0000482,0000001548,''),(00000582,0000484,0000001554,''),(00000584,0000419,0000001560,''),(00000585,0000486,0000001562,''),(00000588,0000489,0000001571,''),(00000589,0000490,0000001575,''),(00000590,0000491,0000001582,''),(00000591,0000492,0000001585,''),(00000593,0000180,0000001591,''),(00000594,0000180,0000001592,''),(00000595,0000403,0000001593,''),(00000596,0000494,0000001594,''),(00000597,0000495,0000001597,''),(00000598,0000496,0000001600,''),(00000599,0000497,0000001603,''),(00000600,0000498,0000001606,''),(00000601,0000499,0000001609,''),(00000602,0000500,0000001612,''),(00000603,0000304,0000001615,''),(00000604,0000321,0000001616,''),(00000605,0000382,0000001617,''),(00000606,0000501,0000001618,''),(00000607,0000502,0000001621,''),(00000609,0000392,0000001627,''),(00000610,0000504,0000001628,''),(00000611,0000505,0000001631,''),(00000612,0000506,0000001633,''),(00000613,0000507,0000001636,''),(00000614,0000508,0000001639,''),(00000615,0000509,0000001642,''),(00000617,0000509,0000001645,''),(00000618,0000511,0000001648,''),(00000620,0000513,0000001654,''),(00000621,0000380,0000001657,''),(00000622,0000514,0000001658,''),(00000623,0000515,0000001661,''),(00000624,0000360,0000001624,''),(00000625,0000516,0000001664,''),(00000626,0000517,0000001667,''),(00000627,0000518,0000001670,''),(00000628,0000518,0000000889,''),(00000629,0000154,0000001673,''),(00000630,0000519,0000001674,''),(00000631,0000520,0000001677,''),(00000632,0000521,0000001680,''),(00000634,0000521,0000001683,''),(00000636,0000521,0000001686,''),(00000637,0000524,0000001689,''),(00000638,0000525,0000001692,''),(00000639,0000372,0000001695,''),(00000640,0000288,0000001696,''),(00000641,0000526,0000001697,''),(00000642,0000527,0000001700,''),(00000643,0000528,0000001703,''),(00000644,0000374,0000001706,''),(00000645,0000529,0000001707,''),(00000648,0000142,0000001713,''),(00000649,0000532,0000001716,''),(00000650,0000533,0000001718,''),(00000651,0000534,0000001721,''),(00000652,0000535,0000001724,''),(00000653,0000410,0000001729,''),(00000654,0000536,0000001730,''),(00000655,0000537,0000001732,''),(00000656,0000538,0000001735,''),(00000657,0000539,0000001739,''),(00000659,0000541,0000001744,''),(00000660,0000542,0000001747,''),(00000661,0000543,0000001750,''),(00000662,0000544,0000001753,''),(00000663,0000545,0000001756,''),(00000664,0000546,0000001758,''),(00000665,0000547,0000001761,''),(00000666,0000548,0000001773,''),(00000667,0000549,0000001779,''),(00000668,0000550,0000001783,''),(00000669,0000551,0000001786,''),(00000670,0000552,0000001788,''),(00000671,0000553,0000001791,''),(00000672,0000554,0000001794,''),(00000673,0000555,0000001796,''),(00000674,0000556,0000001801,''),(00000675,0000557,0000001804,''),(00000676,0000558,0000001806,''),(00000677,0000559,0000001808,''),(00000679,0000513,0000001811,''),(00000680,0000561,0000001814,''),(00000681,0000473,0000001817,''),(00000682,0000562,0000001819,''),(00000683,0000563,0000001822,''),(00000684,0000564,0000001825,''),(00000685,0000565,0000001828,''),(00000686,0000565,0000001710,''),(00000687,0000566,0000001831,''),(00000689,0000568,0000001836,''),(00000690,0000568,0000001834,''),(00000691,0000569,0000001840,''),(00000693,0000569,0000001843,''),(00000694,0000571,0000001845,''),(00000696,0000571,0000001848,''),(00000697,0000573,0000001855,''),(00000698,0000574,0000001858,''),(00000699,0000575,0000001861,''),(00000701,0000500,0000001864,''),(00000702,0000577,0000001867,''),(00000703,0000578,0000001870,''),(00000705,0000425,0000001875,''),(00000706,0000399,0000001878,''),(00000707,0000580,0000001879,''),(00000709,0000432,0000001882,''),(00000710,0000582,0000001885,''),(00000711,0000583,0000001888,''),(00000712,0000584,0000001891,''),(00000714,0000366,0000001894,''),(00000715,0000384,0000001897,''),(00000716,0000586,0000001898,''),(00000717,0000587,0000001901,''),(00000718,0000365,0000001904,''),(00000719,0000588,0000001905,''),(00000720,0000589,0000001908,''),(00000721,0000590,0000001911,''),(00000722,0000396,0000001913,''),(00000723,0000206,0000001914,''),(00000724,0000591,0000001915,''),(00000725,0000592,0000001918,''),(00000726,0000593,0000001921,''),(00000727,0000292,0000001924,''),(00000728,0000594,0000001925,''),(00000729,0000595,0000001928,''),(00000730,0000596,0000001931,''),(00000733,0000188,0000001934,''),(00000734,0000598,0000001937,''),(00000735,0000599,0000001940,''),(00000736,0000600,0000001943,''),(00000737,0000601,0000001946,''),(00000738,0000602,0000001949,''),(00000739,0000603,0000001952,''),(00000740,0000604,0000001955,''),(00000742,0000272,0000001958,''),(00000743,0000407,0000001960,''),(00000744,0000606,0000001961,''),(00000745,0000607,0000001964,''),(00000746,0000608,0000001967,''),(00000747,0000609,0000001970,''),(00000748,0000577,0000001973,''),(00000749,0000610,0000001974,''),(00000751,0000610,0000001977,''),(00000752,0000612,0000001980,''),(00000753,0000613,0000001983,''),(00000754,0000614,0000001986,''),(00000755,0000615,0000001989,''),(00000756,0000616,0000001992,''),(00000757,0000617,0000001995,''),(00000758,0000618,0000001998,''),(00000759,0000619,0000002000,''),(00000760,0000620,0000002003,''),(00000761,0000621,0000002006,''),(00000762,0000622,0000002009,''),(00000763,0000623,0000002012,''),(00000765,0000550,0000002016,''),(00000766,0000625,0000002019,''),(00000767,0000626,0000002022,''),(00000768,0000627,0000002029,''),(00000769,0000628,0000002033,''),(00000770,0000629,0000002035,''),(00000771,0000630,0000002037,''),(00000772,0000631,0000002040,''),(00000773,0000632,0000002043,''),(00000774,0000633,0000002046,''),(00000775,0000634,0000002049,''),(00000776,0000635,0000002053,''),(00000778,0000571,0000002056,''),(00000779,0000637,0000002060,''),(00000780,0000638,0000002063,''),(00000781,0000639,0000002066,''),(00000783,0000155,0000002069,''),(00000784,0000641,0000002072,''),(00000785,0000642,0000002076,''),(00000786,0000643,0000002079,''),(00000787,0000644,0000002081,''),(00000788,0000645,0000002084,''),(00000789,0000646,0000002087,''),(00000791,0000647,0000002090,''),(00000792,0000648,0000002093,''),(00000793,0000649,0000002097,''),(00000794,0000650,0000002100,''),(00000795,0000651,0000002103,''),(00000796,0000652,0000002106,''),(00000798,0000547,0000002109,''),(00000799,0000654,0000002113,''),(00000800,0000655,0000002116,''),(00000801,0000656,0000002119,''),(00000802,0000657,0000002120,''),(00000803,0000658,0000002123,''),(00000804,0000659,0000002126,''),(00000805,0000660,0000002129,''),(00000806,0000661,0000002135,''),(00000807,0000662,0000002138,''),(00000808,0000663,0000002141,''),(00000809,0000651,0000002144,''),(00000810,0000664,0000002145,''),(00000813,0000426,0000002150,''),(00000817,0000669,0000002156,''),(00000818,0000670,0000002160,''),(00000819,0000671,0000002163,''),(00000820,0000672,0000002166,''),(00000821,0000673,0000002169,''),(00000822,0000674,0000002172,''),(00000823,0000675,0000002175,''),(00000824,0000676,0000002178,''),(00000825,0000677,0000002181,''),(00000826,0000678,0000002184,''),(00000827,0000679,0000002187,''),(00000828,0000680,0000002190,''),(00000829,0000450,0000002193,''),(00000830,0000681,0000002194,''),(00000831,0000682,0000002197,''),(00000832,0000683,0000002200,''),(00000833,0000684,0000002203,''),(00000834,0000685,0000002206,''),(00000835,0000686,0000002209,''),(00000836,0000687,0000002212,''),(00000837,0000651,0000002215,''),(00000838,0000688,0000002216,''),(00000839,0000689,0000002219,''),(00000840,0000690,0000002222,''),(00000841,0000691,0000002225,''),(00000842,0000692,0000002228,''),(00000843,0000165,0000002231,''),(00000844,0000374,0000002232,''),(00000845,0000693,0000002233,''),(00000846,0000694,0000002236,''),(00000847,0000295,0000002239,''),(00000848,0000695,0000002240,''),(00000849,0000471,0000002243,''),(00000850,0000696,0000002244,''),(00000852,0000412,0000002247,''),(00000853,0000698,0000002250,''),(00000854,0000699,0000002253,''),(00000855,0000700,0000002256,''),(00000856,0000701,0000002259,''),(00000857,0000702,0000002262,''),(00000859,0000616,0000002265,''),(00000860,0000704,0000002268,''),(00000861,0000705,0000002271,''),(00000862,0000706,0000002274,''),(00000863,0000707,0000002277,''),(00000864,0000708,0000002280,''),(00000865,0000709,0000002283,''),(00000866,0000710,0000002286,''),(00000867,0000711,0000002293,''),(00000868,0000712,0000002296,''),(00000869,0000713,0000002299,''),(00000870,0000714,0000002302,''),(00000871,0000715,0000002306,''),(00000872,0000716,0000002309,''),(00000873,0000717,0000002313,''),(00000874,0000718,0000002316,''),(00000875,0000719,0000002319,''),(00000876,0000720,0000002323,''),(00000877,0000721,0000002327,''),(00000878,0000722,0000002330,''),(00000879,0000496,0000002333,''),(00000880,0000723,0000002334,''),(00000881,0000724,0000002337,''),(00000882,0000725,0000002340,''),(00000883,0000430,0000001367,''),(00000884,0000156,0000002348,''),(00000885,0000726,0000002350,''),(00000886,0000727,0000002353,''),(00000887,0000728,0000002357,''),(00000888,0000729,0000002360,''),(00000889,0000730,0000002364,''),(00000890,0000731,0000002367,''),(00000891,0000732,0000002371,''),(00000892,0000733,0000002374,''),(00000893,0000734,0000002380,''),(00000894,0000735,0000002383,''),(00000895,0000736,0000002386,''),(00000896,0000737,0000002389,''),(00000897,0000738,0000002392,''),(00000898,0000739,0000002395,''),(00000899,0000740,0000002398,''),(00000900,0000741,0000002401,''),(00000901,0000742,0000002404,''),(00000902,0000743,0000002407,''),(00000903,0000744,0000002411,''),(00000905,0000746,0000002417,''),(00000906,0000747,0000002420,''),(00000907,0000430,0000002425,''),(00000908,0000499,0000002426,''),(00000909,0000748,0000002427,''),(00000910,0000749,0000002430,''),(00000911,0000750,0000002433,''),(00000912,0000751,0000002436,''),(00000913,0000752,0000002441,''),(00000914,0000753,0000002444,''),(00000915,0000754,0000002447,''),(00000916,0000755,0000002450,''),(00000917,0000756,0000002453,''),(00000918,0000757,0000002456,''),(00000919,0000468,0000002459,''),(00000921,0000132,0000002460,''),(00000922,0000759,0000002463,''),(00000923,0000760,0000002466,''),(00000924,0000761,0000002469,''),(00000925,0000439,0000002472,''),(00000926,0000762,0000002473,''),(00000927,0000763,0000002476,''),(00000928,0000764,0000002479,''),(00000929,0000765,0000002482,''),(00000931,0000024,0000002485,''),(00000932,0000767,0000002488,''),(00000933,0000767,0000002490,''),(00000934,0000768,0000002491,''),(00000935,0000769,0000002495,''),(00000936,0000770,0000002498,''),(00000937,0000771,0000002501,''),(00000938,0000771,0000002504,''),(00000939,0000772,0000002505,''),(00000940,0000773,0000002508,''),(00000941,0000774,0000002511,''),(00000942,0000775,0000002514,''),(00000943,0000776,0000002517,''),(00000944,0000777,0000002520,''),(00000945,0000778,0000002523,''),(00000946,0000779,0000002526,''),(00000947,0000780,0000002529,''),(00000948,0000781,0000002532,''),(00000949,0000782,0000002535,''),(00000950,0000783,0000002537,''),(00000951,0000784,0000002541,''),(00000952,0000785,0000002545,''),(00000953,0000786,0000002548,''),(00000954,0000787,0000002555,''),(00000955,0000788,0000002558,''),(00000956,0000789,0000002563,''),(00000957,0000403,0000002566,''),(00000958,0000790,0000002567,''),(00000959,0000791,0000002570,''),(00000960,0000792,0000002573,''),(00000961,0000289,0000002576,''),(00000962,0000793,0000002577,''),(00000963,0000794,0000002580,''),(00000964,0000795,0000002583,''),(00000965,0000796,0000002586,''),(00000966,0000797,0000002589,''),(00000967,0000798,0000002592,''),(00000968,0000799,0000002595,''),(00000969,0000800,0000002598,''),(00000970,0000801,0000002601,''),(00000971,0000802,0000002604,''),(00000972,0000803,0000002607,''),(00000973,0000504,0000002610,''),(00000974,0000804,0000002611,''),(00000975,0000367,0000002614,''),(00000976,0000805,0000002615,''),(00000977,0000806,0000002618,''),(00000978,0000807,0000002621,''),(00000979,0000808,0000002624,''),(00000980,0000809,0000002627,''),(00000981,0000810,0000002630,''),(00000982,0000811,0000002633,''),(00000983,0000812,0000002636,''),(00000984,0000813,0000002639,''),(00000985,0000814,0000002642,''),(00000986,0000815,0000002645,''),(00000987,0000816,0000002648,''),(00000988,0000787,0000002651,''),(00000989,0000817,0000002652,''),(00000990,0000818,0000002654,''),(00000991,0000819,0000002657,''),(00000992,0000820,0000002660,''),(00000993,0000821,0000002663,''),(00000994,0000772,0000002666,''),(00000995,0000822,0000002667,''),(00000996,0000823,0000002670,''),(00000997,0000824,0000002673,''),(00000998,0000825,0000002676,''),(00000999,0000705,0000002679,''),(00001000,0000826,0000002680,''),(00001001,0000827,0000002683,''),(00001002,0000828,0000002686,''),(00001003,0000829,0000002689,''),(00001004,0000830,0000002692,''),(00001005,0000438,0000002695,''),(00001006,0000831,0000002696,''),(00001007,0000607,0000002699,''),(00001008,0000832,0000002700,''),(00001009,0000833,0000002702,''),(00001010,0000834,0000002705,''),(00001011,0000835,0000002708,''),(00001012,0000836,0000002711,''),(00001013,0000660,0000002714,''),(00001014,0000837,0000002715,''),(00001015,0000838,0000002719,''),(00001016,0000839,0000002723,''),(00001017,0000840,0000002726,''),(00001018,0000841,0000002729,''),(00001019,0000842,0000002737,''),(00001020,0000843,0000002740,''),(00001021,0000844,0000002743,''),(00001022,0000845,0000002746,''),(00001023,0000846,0000002749,''),(00001024,0000847,0000002752,''),(00001025,0000848,0000002754,''),(00001026,0000849,0000002757,''),(00001027,0000849,0000002760,''),(00001028,0000850,0000002761,''),(00001029,0000851,0000002764,''),(00001030,0000852,0000002767,''),(00001031,0000853,0000002770,'');

--
-- 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 COLLATE=utf8mb3_general_ci COMMENT='Person 1 is [relationship] to person 2?';

--
-- Dumping data for table `gibbonFamilyRelationship`
--


--
-- 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFamilyUpdate`
--


--
-- 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 AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFinanceBillingSchedule`
--


--
-- 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFinanceBudget`
--


--
-- 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(6) 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFinanceBudgetCycle`
--


--
-- 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFinanceBudgetCycleAllocation`
--


--
-- 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFinanceBudgetPerson`
--


--
-- 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFinanceExpense`
--


--
-- 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(4) 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFinanceExpenseApprover`
--


--
-- 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFinanceExpenseLog`
--


--
-- 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFinanceFee`
--


--
-- 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 AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- 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),(0019,'Tuition Fee','TUIT','School Tuition ','Y',0000001810,'2017-04-12 12:43:01',0000000857,'2017-05-22 09:59:14'),(0020,'Debenture','DEB','Non-Refundable Debenture','Y',0000001810,'2017-05-22 09:41:23',0000000857,'2017-05-22 11:29:17'),(0021,'Public Exam Fee','EXAM','','Y',0000000857,'2017-06-15 15:02:52',NULL,NULL),(0022,'Misc Deposit','DEP','Deposit for Activities and Miscellaneous Costs','Y',0000000857,'2018-06-27 11:25:45',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 DEFAULT NULL,
  `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(3) 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFinanceInvoice`
--


--
-- 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 DEFAULT NULL,
  `gibbonFinanceFeeCategoryID` int(4) unsigned zerofill DEFAULT NULL,
  `fee` decimal(12,2) DEFAULT NULL,
  `sequenceNumber` int(10) DEFAULT NULL,
  PRIMARY KEY (`gibbonFinanceInvoiceFeeID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFinanceInvoiceFee`
--


--
-- 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 DEFAULT NULL,
  `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 DEFAULT NULL COMMENT 'If companyAll is N, list category IDs for campany to pay here.',
  PRIMARY KEY (`gibbonFinanceInvoiceeID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFinanceInvoicee`
--


--
-- 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 DEFAULT NULL,
  `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 DEFAULT NULL 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFinanceInvoiceeUpdate`
--


--
-- 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 DEFAULT NULL,
  PRIMARY KEY (`gibbonFirstAidID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFirstAid`
--


--
-- 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFirstAidFollowUp`
--


--
-- 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 DEFAULT NULL,
  PRIMARY KEY (`gibbonFormID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- 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 DEFAULT NULL,
  `label` varchar(90) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `conditional` text DEFAULT NULL COMMENT 'json',
  `defaultValue` varchar(255) DEFAULT NULL,
  `sequenceNumber` int(3) NOT NULL,
  PRIMARY KEY (`gibbonFormFieldID`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- 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','AdmissionsFields','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 AUTO_INCREMENT=165 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFormGroup`
--

INSERT INTO `gibbonFormGroup` VALUES (00143,025,'07.1','07.1',0000002363,NULL,NULL,NULL,NULL,NULL,00007,00000,'Y',''),(00144,025,'07.2','07.2',0000001778,NULL,NULL,NULL,NULL,NULL,00006,00000,'Y',''),(00145,025,'07.3','07.3',0000001601,NULL,NULL,NULL,NULL,NULL,00020,00000,'Y',''),(00146,025,'08.1','08.1',0000002732,NULL,NULL,NULL,NULL,NULL,00024,00000,'Y',''),(00147,025,'08.2','08.2',0000000120,NULL,NULL,NULL,NULL,NULL,00019,00000,'Y',''),(00148,025,'08.3','08.3',0000002562,NULL,NULL,NULL,NULL,NULL,00001,00000,'Y',''),(00149,025,'09.1','09.1',0000002134,NULL,NULL,NULL,NULL,NULL,00002,00000,'Y',''),(00150,025,'09.2','09.2',0000001123,NULL,NULL,NULL,NULL,NULL,00008,00000,'Y',''),(00151,025,'10.1','10.1',0000002347,NULL,NULL,NULL,NULL,NULL,00046,00000,'Y',''),(00152,025,'10.2','10.2',0000000198,NULL,NULL,NULL,NULL,NULL,00049,00000,'Y',''),(00153,025,'11.1','11.1',0000000866,NULL,NULL,NULL,NULL,NULL,00018,00000,'Y',''),(00154,025,'11.2','11.2',0000001119,NULL,NULL,NULL,NULL,NULL,00047,00000,'Y',''),(00155,025,'12.1','12.1',0000000867,NULL,NULL,NULL,NULL,NULL,00004,00000,'Y',''),(00156,025,'13.1','13.1',0000000124,NULL,NULL,NULL,NULL,NULL,00031,00000,'Y',''),(00157,025,'12.2','12.2',0000000869,NULL,NULL,NULL,NULL,NULL,00010,00000,'Y',''),(00159,025,'09.3','09.3',0000002326,NULL,NULL,NULL,NULL,NULL,00021,00000,'Y',''),(00162,025,'07.4','07.4',0000002722,NULL,NULL,NULL,NULL,NULL,00029,00000,'Y',''),(00163,025,'10.3','10.3',0000001122,NULL,NULL,NULL,NULL,NULL,00048,00000,'Y',''),(00164,025,'11.3','11.3',0000002027,NULL,NULL,NULL,NULL,NULL,00023,00000,'Y','');

--
-- 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 DEFAULT NULL,
  `postscript` text DEFAULT NULL,
  `sequenceNumber` int(3) NOT NULL,
  PRIMARY KEY (`gibbonFormPageID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- 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 DEFAULT NULL,
  `result` text DEFAULT NULL,
  `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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFormSubmission`
--


--
-- 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonFormUpload`
--


--
-- 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonGroup`
--


--
-- 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonGroupPerson`
--


--
-- 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonHook`
--


--
-- 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 AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonHouse`
--

INSERT INTO `gibbonHouse` VALUES (009,'Ming','M',''),(010,'Song','S',''),(011,'Tang','T','');

--
-- 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 DEFAULT NULL,
  PRIMARY KEY (`gibbonINID`),
  UNIQUE KEY `gibbonPersonID` (`gibbonPersonID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonIN`
--


--
-- 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 DEFAULT NULL,
  PRIMARY KEY (`gibbonINArchiveID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonINArchive`
--


--
-- 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 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `gibbonINAssistant`
--


--
-- 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(3) NOT NULL,
  PRIMARY KEY (`gibbonINDescriptorID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- 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 DEFAULT NULL,
  `resolutionDetails` text DEFAULT NULL,
  PRIMARY KEY (`gibbonINInvestigationID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonINInvestigation`
--


--
-- 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 DEFAULT NULL,
  `memory` text DEFAULT NULL,
  `selfManagement` text DEFAULT NULL,
  `attention` text DEFAULT NULL,
  `socialInteraction` text DEFAULT NULL,
  `communication` text DEFAULT NULL,
  `comment` text DEFAULT NULL,
  PRIMARY KEY (`gibbonINInvestigationContributionID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonINInvestigationContribution`
--


--
-- 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 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gibbonINPersonDescriptor`
--


--
-- 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 COLLATE=utf8mb3_general_ci;

--
