-- Table structure for table `innodb_index_stats`
--

CREATE TABLE `innodb_index_stats` (
  `database_name` varchar(64) COLLATE utf8_bin NOT NULL,
  `table_name` varchar(199) COLLATE utf8_bin NOT NULL,
  `index_name` varchar(64) COLLATE utf8_bin NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `stat_name` varchar(64) COLLATE utf8_bin NOT NULL,
  `stat_value` bigint(20) unsigned NOT NULL,
  `sample_size` bigint(20) unsigned DEFAULT NULL,
  `stat_description` varchar(1024) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`database_name`,`table_name`,`index_name`,`stat_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;

--
-- Dumping data for table `innodb_index_stats`
--

INSERT INTO `innodb_index_stats` VALUES ('mysql','gtid_executed','PRIMARY','2022-12-11 11:13:52','n_diff_pfx01',0,1,'source_uuid'),('mysql','gtid_executed','PRIMARY','2022-12-11 11:13:52','n_diff_pfx02',0,1,'source_uuid,interval_start'),('mysql','gtid_executed','PRIMARY','2022-12-11 11:13:52','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('mysql','gtid_executed','PRIMARY','2022-12-11 11:13:52','size',1,NULL,'Number of pages in the index'),('school14_gjc823','academic_positions','PRIMARY','2022-12-12 16:23:29','n_diff_pfx01',0,1,'id'),('school14_gjc823','academic_positions','PRIMARY','2022-12-12 16:23:29','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','academic_positions','PRIMARY','2022-12-12 16:23:29','size',1,NULL,'Number of pages in the index'),('school14_gjc823','academic_positions','Unique Position','2022-12-12 16:23:29','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','academic_positions','Unique Position','2022-12-12 16:23:29','n_diff_pfx02',0,1,'student_id,term_id'),('school14_gjc823','academic_positions','Unique Position','2022-12-12 16:23:29','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','academic_positions','Unique Position','2022-12-12 16:23:29','size',1,NULL,'Number of pages in the index'),('school14_gjc823','admins','PRIMARY','2022-12-12 16:23:29','n_diff_pfx01',0,1,'id'),('school14_gjc823','admins','PRIMARY','2022-12-12 16:23:29','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','admins','PRIMARY','2022-12-12 16:23:29','size',1,NULL,'Number of pages in the index'),('school14_gjc823','admins','employee role duplicate','2022-12-12 16:23:29','n_diff_pfx01',0,1,'employee_id'),('school14_gjc823','admins','employee role duplicate','2022-12-12 16:23:29','n_diff_pfx02',0,1,'employee_id,role_id'),('school14_gjc823','admins','employee role duplicate','2022-12-12 16:23:29','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','admins','employee role duplicate','2022-12-12 16:23:29','size',1,NULL,'Number of pages in the index'),('school14_gjc823','admission_settings','PRIMARY','2022-12-12 16:23:29','n_diff_pfx01',0,1,'id'),('school14_gjc823','admission_settings','PRIMARY','2022-12-12 16:23:29','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','admission_settings','PRIMARY','2022-12-12 16:23:29','size',1,NULL,'Number of pages in the index'),('school14_gjc823','api_requests','PRIMARY','2022-12-12 16:23:29','n_diff_pfx01',0,1,'id'),('school14_gjc823','api_requests','PRIMARY','2022-12-12 16:23:29','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','api_requests','PRIMARY','2022-12-12 16:23:29','size',1,NULL,'Number of pages in the index'),('school14_gjc823','assigned_subjects','PRIMARY','2022-12-12 16:23:29','n_diff_pfx01',0,1,'id'),('school14_gjc823','assigned_subjects','PRIMARY','2022-12-12 16:23:29','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','assigned_subjects','PRIMARY','2022-12-12 16:23:29','size',1,NULL,'Number of pages in the index'),('school14_gjc823','assignment_replies','PRIMARY','2022-12-12 16:23:29','n_diff_pfx01',0,1,'id'),('school14_gjc823','assignment_replies','PRIMARY','2022-12-12 16:23:29','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','assignment_replies','PRIMARY','2022-12-12 16:23:29','size',1,NULL,'Number of pages in the index'),('school14_gjc823','assignment_replies','Unique reply','2022-12-12 16:23:29','n_diff_pfx01',0,1,'assignment_id'),('school14_gjc823','assignment_replies','Unique reply','2022-12-12 16:23:29','n_diff_pfx02',0,1,'assignment_id,student_id'),('school14_gjc823','assignment_replies','Unique reply','2022-12-12 16:23:29','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','assignment_replies','Unique reply','2022-12-12 16:23:29','size',1,NULL,'Number of pages in the index'),('school14_gjc823','assignments','PRIMARY','2022-12-12 16:23:29','n_diff_pfx01',0,1,'id'),('school14_gjc823','assignments','PRIMARY','2022-12-12 16:23:29','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','assignments','PRIMARY','2022-12-12 16:23:29','size',1,NULL,'Number of pages in the index'),('school14_gjc823','assignments','title','2022-12-12 16:23:29','n_diff_pfx01',0,1,'topic'),('school14_gjc823','assignments','title','2022-12-12 16:23:29','n_diff_pfx02',0,1,'topic,employee_id'),('school14_gjc823','assignments','title','2022-12-12 16:23:29','n_diff_pfx03',0,1,'topic,employee_id,subject_id'),('school14_gjc823','assignments','title','2022-12-12 16:23:29','n_diff_pfx04',0,1,'topic,employee_id,subject_id,class_id'),('school14_gjc823','assignments','title','2022-12-12 16:23:29','n_diff_pfx05',0,1,'topic,employee_id,subject_id,class_id,date'),('school14_gjc823','assignments','title','2022-12-12 16:23:29','n_diff_pfx06',0,1,'topic,employee_id,subject_id,class_id,date,dueDate'),('school14_gjc823','assignments','title','2022-12-12 16:23:29','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','assignments','title','2022-12-12 16:23:29','size',1,NULL,'Number of pages in the index'),('school14_gjc823','assignments','title_2','2022-12-12 16:23:29','n_diff_pfx01',0,1,'topic'),('school14_gjc823','assignments','title_2','2022-12-12 16:23:29','n_diff_pfx02',0,1,'topic,date'),('school14_gjc823','assignments','title_2','2022-12-12 16:23:29','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','assignments','title_2','2022-12-12 16:23:29','size',1,NULL,'Number of pages in the index'),('school14_gjc823','assignments','title_3','2022-12-12 16:23:29','n_diff_pfx01',0,1,'topic'),('school14_gjc823','assignments','title_3','2022-12-12 16:23:29','n_diff_pfx02',0,1,'topic,employee_id'),('school14_gjc823','assignments','title_3','2022-12-12 16:23:29','n_diff_pfx03',0,1,'topic,employee_id,postType'),('school14_gjc823','assignments','title_3','2022-12-12 16:23:29','n_diff_pfx04',0,1,'topic,employee_id,postType,subject_id'),('school14_gjc823','assignments','title_3','2022-12-12 16:23:29','n_diff_pfx05',0,1,'topic,employee_id,postType,subject_id,class_id'),('school14_gjc823','assignments','title_3','2022-12-12 16:23:29','n_diff_pfx06',0,1,'topic,employee_id,postType,subject_id,class_id,date'),('school14_gjc823','assignments','title_3','2022-12-12 16:23:29','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','assignments','title_3','2022-12-12 16:23:29','size',1,NULL,'Number of pages in the index'),('school14_gjc823','attendance','PRIMARY','2022-12-12 16:23:29','n_diff_pfx01',0,1,'id'),('school14_gjc823','attendance','PRIMARY','2022-12-12 16:23:29','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','attendance','PRIMARY','2022-12-12 16:23:29','size',1,NULL,'Number of pages in the index'),('school14_gjc823','attendance','Student date','2022-12-12 16:23:29','n_diff_pfx01',0,1,'date'),('school14_gjc823','attendance','Student date','2022-12-12 16:23:29','n_diff_pfx02',0,1,'date,students_id'),('school14_gjc823','attendance','Student date','2022-12-12 16:23:29','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','attendance','Student date','2022-12-12 16:23:29','size',1,NULL,'Number of pages in the index'),('school14_gjc823','attendance','status','2022-12-12 16:23:29','n_diff_pfx01',0,1,'status'),('school14_gjc823','attendance','status','2022-12-12 16:23:29','n_diff_pfx02',0,1,'status,term_id'),('school14_gjc823','attendance','status','2022-12-12 16:23:29','n_diff_pfx03',0,1,'status,term_id,date'),('school14_gjc823','attendance','status','2022-12-12 16:23:29','n_diff_pfx04',0,1,'status,term_id,date,class_id'),('school14_gjc823','attendance','status','2022-12-12 16:23:29','n_diff_pfx05',0,1,'status,term_id,date,class_id,students_id'),('school14_gjc823','attendance','status','2022-12-12 16:23:29','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','attendance','status','2022-12-12 16:23:29','size',1,NULL,'Number of pages in the index'),('school14_gjc823','auto_sms','PRIMARY','2022-12-12 16:23:30','n_diff_pfx01',0,1,'id'),('school14_gjc823','auto_sms','PRIMARY','2022-12-12 16:23:30','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','auto_sms','PRIMARY','2022-12-12 16:23:30','size',1,NULL,'Number of pages in the index'),('school14_gjc823','average_ranks','PRIMARY','2022-12-12 16:23:30','n_diff_pfx01',0,1,'id'),('school14_gjc823','average_ranks','PRIMARY','2022-12-12 16:23:30','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','average_ranks','PRIMARY','2022-12-12 16:23:30','size',1,NULL,'Number of pages in the index'),('school14_gjc823','bank_accounts','PRIMARY','2022-12-12 16:23:30','n_diff_pfx01',0,1,'id'),('school14_gjc823','bank_accounts','PRIMARY','2022-12-12 16:23:30','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','bank_accounts','PRIMARY','2022-12-12 16:23:30','size',1,NULL,'Number of pages in the index'),('school14_gjc823','bank_accounts','Unique Account','2022-12-12 16:23:30','n_diff_pfx01',0,1,'bank_id'),('school14_gjc823','bank_accounts','Unique Account','2022-12-12 16:23:30','n_diff_pfx02',0,1,'bank_id,number'),('school14_gjc823','bank_accounts','Unique Account','2022-12-12 16:23:30','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','bank_accounts','Unique Account','2022-12-12 16:23:30','size',1,NULL,'Number of pages in the index'),('school14_gjc823','banks','PRIMARY','2022-12-12 16:23:41','n_diff_pfx01',20,1,'id'),('school14_gjc823','banks','PRIMARY','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','banks','PRIMARY','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','book_authors','PRIMARY','2022-12-12 16:23:30','n_diff_pfx01',0,1,'id'),('school14_gjc823','book_authors','PRIMARY','2022-12-12 16:23:30','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','book_authors','PRIMARY','2022-12-12 16:23:30','size',1,NULL,'Number of pages in the index'),('school14_gjc823','book_authors','Unique Author','2022-12-12 16:23:30','n_diff_pfx01',0,1,'author'),('school14_gjc823','book_authors','Unique Author','2022-12-12 16:23:30','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','book_authors','Unique Author','2022-12-12 16:23:30','size',1,NULL,'Number of pages in the index'),('school14_gjc823','book_categories','PRIMARY','2022-12-12 16:23:32','n_diff_pfx01',2,1,'id'),('school14_gjc823','book_categories','PRIMARY','2022-12-12 16:23:32','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','book_categories','PRIMARY','2022-12-12 16:23:32','size',1,NULL,'Number of pages in the index'),('school14_gjc823','book_categories','Unique Category','2022-12-12 16:23:32','n_diff_pfx01',2,1,'category'),('school14_gjc823','book_categories','Unique Category','2022-12-12 16:23:32','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','book_categories','Unique Category','2022-12-12 16:23:32','size',1,NULL,'Number of pages in the index'),('school14_gjc823','book_issues','PRIMARY','2022-12-12 16:23:30','n_diff_pfx01',0,1,'id'),('school14_gjc823','book_issues','PRIMARY','2022-12-12 16:23:30','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','book_issues','PRIMARY','2022-12-12 16:23:30','size',1,NULL,'Number of pages in the index'),('school14_gjc823','book_issues','Unique Issued Status','2022-12-12 16:23:30','n_diff_pfx01',0,1,'book_id'),('school14_gjc823','book_issues','Unique Issued Status','2022-12-12 16:23:30','n_diff_pfx02',0,1,'book_id,copyNumber'),('school14_gjc823','book_issues','Unique Issued Status','2022-12-12 16:23:30','n_diff_pfx03',0,1,'book_id,copyNumber,status'),('school14_gjc823','book_issues','Unique Issued Status','2022-12-12 16:23:30','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','book_issues','Unique Issued Status','2022-12-12 16:23:30','size',1,NULL,'Number of pages in the index'),('school14_gjc823','book_losses','PRIMARY','2022-12-12 16:23:30','n_diff_pfx01',0,1,'id'),('school14_gjc823','book_losses','PRIMARY','2022-12-12 16:23:30','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','book_losses','PRIMARY','2022-12-12 16:23:30','size',1,NULL,'Number of pages in the index'),('school14_gjc823','book_losses','Unique Loss','2022-12-12 16:23:30','n_diff_pfx01',0,1,'book_id'),('school14_gjc823','book_losses','Unique Loss','2022-12-12 16:23:30','n_diff_pfx02',0,1,'book_id,copyNumber'),('school14_gjc823','book_losses','Unique Loss','2022-12-12 16:23:30','n_diff_pfx03',0,1,'book_id,copyNumber,date'),('school14_gjc823','book_losses','Unique Loss','2022-12-12 16:23:30','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','book_losses','Unique Loss','2022-12-12 16:23:30','size',1,NULL,'Number of pages in the index'),('school14_gjc823','book_losses','UniqueBook','2022-12-12 16:23:30','n_diff_pfx01',0,1,'book_id'),('school14_gjc823','book_losses','UniqueBook','2022-12-12 16:23:30','n_diff_pfx02',0,1,'book_id,copyNumber'),('school14_gjc823','book_losses','UniqueBook','2022-12-12 16:23:30','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','book_losses','UniqueBook','2022-12-12 16:23:30','size',1,NULL,'Number of pages in the index'),('school14_gjc823','book_publishers','PRIMARY','2022-12-12 16:23:30','n_diff_pfx01',0,1,'id'),('school14_gjc823','book_publishers','PRIMARY','2022-12-12 16:23:30','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','book_publishers','PRIMARY','2022-12-12 16:23:30','size',1,NULL,'Number of pages in the index'),('school14_gjc823','book_publishers','Unique Publisher','2022-12-12 16:23:30','n_diff_pfx01',0,1,'publisher'),('school14_gjc823','book_publishers','Unique Publisher','2022-12-12 16:23:30','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','book_publishers','Unique Publisher','2022-12-12 16:23:30','size',1,NULL,'Number of pages in the index'),('school14_gjc823','book_renewals','PRIMARY','2022-12-12 16:23:31','n_diff_pfx01',0,1,'id'),('school14_gjc823','book_renewals','PRIMARY','2022-12-12 16:23:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','book_renewals','PRIMARY','2022-12-12 16:23:31','size',1,NULL,'Number of pages in the index'),('school14_gjc823','book_renewals','unique Renewal','2022-12-12 16:23:31','n_diff_pfx01',0,1,'issue_id'),('school14_gjc823','book_renewals','unique Renewal','2022-12-12 16:23:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','book_renewals','unique Renewal','2022-12-12 16:23:31','size',1,NULL,'Number of pages in the index'),('school14_gjc823','book_returns','PRIMARY','2022-12-12 16:23:31','n_diff_pfx01',0,1,'id'),('school14_gjc823','book_returns','PRIMARY','2022-12-12 16:23:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','book_returns','PRIMARY','2022-12-12 16:23:31','size',1,NULL,'Number of pages in the index'),('school14_gjc823','book_returns','unique Renewal','2022-12-12 16:23:31','n_diff_pfx01',0,1,'issue_id'),('school14_gjc823','book_returns','unique Renewal','2022-12-12 16:23:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','book_returns','unique Renewal','2022-12-12 16:23:31','size',1,NULL,'Number of pages in the index'),('school14_gjc823','book_shop','PRIMARY','2022-12-12 16:23:31','n_diff_pfx01',0,1,'id'),('school14_gjc823','book_shop','PRIMARY','2022-12-12 16:23:31','n_diff_pfx02',0,1,'id,book_id'),('school14_gjc823','book_shop','PRIMARY','2022-12-12 16:23:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','book_shop','PRIMARY','2022-12-12 16:23:31','size',1,NULL,'Number of pages in the index'),('school14_gjc823','book_shop','Unique book','2022-12-12 16:23:31','n_diff_pfx01',0,1,'book_id'),('school14_gjc823','book_shop','Unique book','2022-12-12 16:23:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','book_shop','Unique book','2022-12-12 16:23:31','size',1,NULL,'Number of pages in the index'),('school14_gjc823','books','PRIMARY','2022-12-12 16:23:31','n_diff_pfx01',0,1,'id'),('school14_gjc823','books','PRIMARY','2022-12-12 16:23:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','books','PRIMARY','2022-12-12 16:23:31','size',1,NULL,'Number of pages in the index'),('school14_gjc823','books','Unique Book','2022-12-12 16:23:31','n_diff_pfx01',0,1,'bookTitle'),('school14_gjc823','books','Unique Book','2022-12-12 16:23:31','n_diff_pfx02',0,1,'bookTitle,author_id'),('school14_gjc823','books','Unique Book','2022-12-12 16:23:31','n_diff_pfx03',0,1,'bookTitle,author_id,publisher_id'),('school14_gjc823','books','Unique Book','2022-12-12 16:23:31','n_diff_pfx04',0,1,'bookTitle,author_id,publisher_id,edition'),('school14_gjc823','books','Unique Book','2022-12-12 16:23:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','books','Unique Book','2022-12-12 16:23:31','size',1,NULL,'Number of pages in the index'),('school14_gjc823','books','Unique Code','2022-12-12 16:23:31','n_diff_pfx01',0,1,'code'),('school14_gjc823','books','Unique Code','2022-12-12 16:23:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','books','Unique Code','2022-12-12 16:23:31','size',1,NULL,'Number of pages in the index'),('school14_gjc823','books','Unique ISBN','2022-12-12 16:23:31','n_diff_pfx01',0,1,'ISBN'),('school14_gjc823','books','Unique ISBN','2022-12-12 16:23:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','books','Unique ISBN','2022-12-12 16:23:31','size',1,NULL,'Number of pages in the index'),('school14_gjc823','books','UniqueEdition','2022-12-12 16:23:31','n_diff_pfx01',0,1,'bookTitle'),('school14_gjc823','books','UniqueEdition','2022-12-12 16:23:31','n_diff_pfx02',0,1,'bookTitle,edition'),('school14_gjc823','books','UniqueEdition','2022-12-12 16:23:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','books','UniqueEdition','2022-12-12 16:23:31','size',1,NULL,'Number of pages in the index'),('school14_gjc823','cafeteria_transactions','PRIMARY','2022-12-12 16:23:31','n_diff_pfx01',0,1,'id'),('school14_gjc823','cafeteria_transactions','PRIMARY','2022-12-12 16:23:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','cafeteria_transactions','PRIMARY','2022-12-12 16:23:31','size',1,NULL,'Number of pages in the index'),('school14_gjc823','career_categories','PRIMARY','2022-12-12 16:23:31','n_diff_pfx01',0,1,'id'),('school14_gjc823','career_categories','PRIMARY','2022-12-12 16:23:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','career_categories','PRIMARY','2022-12-12 16:23:31','size',1,NULL,'Number of pages in the index'),('school14_gjc823','career_categories','code','2022-12-12 16:23:31','n_diff_pfx01',0,1,'code'),('school14_gjc823','career_categories','code','2022-12-12 16:23:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','career_categories','code','2022-12-12 16:23:31','size',1,NULL,'Number of pages in the index'),('school14_gjc823','career_groups','PRIMARY','2022-12-12 16:23:31','n_diff_pfx01',0,1,'id'),('school14_gjc823','career_groups','PRIMARY','2022-12-12 16:23:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','career_groups','PRIMARY','2022-12-12 16:23:31','size',1,NULL,'Number of pages in the index'),('school14_gjc823','career_questions','PRIMARY','2022-12-12 16:23:31','n_diff_pfx01',0,1,'id'),('school14_gjc823','career_questions','PRIMARY','2022-12-12 16:23:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','career_questions','PRIMARY','2022-12-12 16:23:31','size',1,NULL,'Number of pages in the index'),('school14_gjc823','career_tests','PRIMARY','2022-12-12 16:23:31','n_diff_pfx01',0,1,'id'),('school14_gjc823','career_tests','PRIMARY','2022-12-12 16:23:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','career_tests','PRIMARY','2022-12-12 16:23:31','size',1,NULL,'Number of pages in the index'),('school14_gjc823','career_tests','student_id','2022-12-12 16:23:31','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','career_tests','student_id','2022-12-12 16:23:31','n_diff_pfx02',0,1,'student_id,date'),('school14_gjc823','career_tests','student_id','2022-12-12 16:23:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','career_tests','student_id','2022-12-12 16:23:31','size',1,NULL,'Number of pages in the index'),('school14_gjc823','careers','PRIMARY','2022-12-12 16:23:32','n_diff_pfx01',0,1,'id'),('school14_gjc823','careers','PRIMARY','2022-12-12 16:23:32','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','careers','PRIMARY','2022-12-12 16:23:32','size',1,NULL,'Number of pages in the index'),('school14_gjc823','cgpa','PRIMARY','2022-12-12 16:23:32','n_diff_pfx01',0,1,'id'),('school14_gjc823','cgpa','PRIMARY','2022-12-12 16:23:32','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','cgpa','PRIMARY','2022-12-12 16:23:32','size',1,NULL,'Number of pages in the index'),('school14_gjc823','cgpa','Unique_Student','2022-12-12 16:23:32','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','cgpa','Unique_Student','2022-12-12 16:23:32','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','cgpa','Unique_Student','2022-12-12 16:23:32','size',1,NULL,'Number of pages in the index'),('school14_gjc823','class_coordinators','PRIMARY','2022-12-12 16:23:32','n_diff_pfx01',0,1,'id'),('school14_gjc823','class_coordinators','PRIMARY','2022-12-12 16:23:32','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','class_coordinators','PRIMARY','2022-12-12 16:23:32','size',1,NULL,'Number of pages in the index'),('school14_gjc823','class_coordinators','employee_id','2022-12-12 16:23:32','n_diff_pfx01',0,1,'employee_id'),('school14_gjc823','class_coordinators','employee_id','2022-12-12 16:23:32','n_diff_pfx02',0,1,'employee_id,class_level_id'),('school14_gjc823','class_coordinators','employee_id','2022-12-12 16:23:32','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','class_coordinators','employee_id','2022-12-12 16:23:32','size',1,NULL,'Number of pages in the index'),('school14_gjc823','class_electvie_exemption','PRIMARY','2022-12-12 16:23:32','n_diff_pfx01',0,1,'id'),('school14_gjc823','class_electvie_exemption','PRIMARY','2022-12-12 16:23:32','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','class_electvie_exemption','PRIMARY','2022-12-12 16:23:32','size',1,NULL,'Number of pages in the index'),('school14_gjc823','class_electvie_exemption','subject_id','2022-12-12 16:23:32','n_diff_pfx01',0,1,'subject_id'),('school14_gjc823','class_electvie_exemption','subject_id','2022-12-12 16:23:32','n_diff_pfx02',0,1,'subject_id,class_id'),('school14_gjc823','class_electvie_exemption','subject_id','2022-12-12 16:23:32','n_diff_pfx03',0,1,'subject_id,class_id,session_id'),('school14_gjc823','class_electvie_exemption','subject_id','2022-12-12 16:23:32','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','class_electvie_exemption','subject_id','2022-12-12 16:23:32','size',1,NULL,'Number of pages in the index'),('school14_gjc823','class_levels','PRIMARY','2022-12-12 16:23:32','n_diff_pfx01',6,1,'id'),('school14_gjc823','class_levels','PRIMARY','2022-12-12 16:23:32','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','class_levels','PRIMARY','2022-12-12 16:23:32','size',1,NULL,'Number of pages in the index'),('school14_gjc823','class_levels','level','2022-12-12 16:23:32','n_diff_pfx01',6,1,'level'),('school14_gjc823','class_levels','level','2022-12-12 16:23:32','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','class_levels','level','2022-12-12 16:23:32','size',1,NULL,'Number of pages in the index'),('school14_gjc823','class_promotions','PRIMARY','2022-12-12 16:23:33','n_diff_pfx01',269,2,'id'),('school14_gjc823','class_promotions','PRIMARY','2022-12-12 16:23:33','n_leaf_pages',2,NULL,'Number of leaf pages in the index'),('school14_gjc823','class_promotions','PRIMARY','2022-12-12 16:23:33','size',3,NULL,'Number of pages in the index'),('school14_gjc823','class_promotions','Unique Promotion','2022-12-12 16:23:33','n_diff_pfx01',182,1,'student_id'),('school14_gjc823','class_promotions','Unique Promotion','2022-12-12 16:23:33','n_diff_pfx02',269,1,'student_id,session_id'),('school14_gjc823','class_promotions','Unique Promotion','2022-12-12 16:23:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','class_promotions','Unique Promotion','2022-12-12 16:23:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','class_sections','PRIMARY','2022-12-12 16:23:33','n_diff_pfx01',4,1,'id'),('school14_gjc823','class_sections','PRIMARY','2022-12-12 16:23:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','class_sections','PRIMARY','2022-12-12 16:23:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','class_sections','sections','2022-12-12 16:23:33','n_diff_pfx01',4,1,'section'),('school14_gjc823','class_sections','sections','2022-12-12 16:23:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','class_sections','sections','2022-12-12 16:23:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','class_session_teachers','PRIMARY','2022-12-15 17:42:52','n_diff_pfx01',36,1,'id'),('school14_gjc823','class_session_teachers','PRIMARY','2022-12-15 17:42:52','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','class_session_teachers','PRIMARY','2022-12-15 17:42:52','size',1,NULL,'Number of pages in the index'),('school14_gjc823','class_session_teachers','Unique session teacher','2022-12-15 17:42:52','n_diff_pfx01',25,1,'class_id'),('school14_gjc823','class_session_teachers','Unique session teacher','2022-12-15 17:42:52','n_diff_pfx02',36,1,'class_id,session_id'),('school14_gjc823','class_session_teachers','Unique session teacher','2022-12-15 17:42:52','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','class_session_teachers','Unique session teacher','2022-12-15 17:42:52','size',1,NULL,'Number of pages in the index'),('school14_gjc823','class_subjects','PRIMARY','2022-12-12 16:23:33','n_diff_pfx01',0,1,'id'),('school14_gjc823','class_subjects','PRIMARY','2022-12-12 16:23:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','class_subjects','PRIMARY','2022-12-12 16:23:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','classes','PRIMARY','2022-12-12 16:23:34','n_diff_pfx01',24,1,'id'),('school14_gjc823','classes','PRIMARY','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','classes','PRIMARY','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','classes','level','2022-12-12 16:23:34','n_diff_pfx01',24,1,'level'),('school14_gjc823','classes','level','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','classes','level','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','client','PRIMARY','2022-12-12 16:23:33','n_diff_pfx01',0,1,'client_id'),('school14_gjc823','client','PRIMARY','2022-12-12 16:23:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','client','PRIMARY','2022-12-12 16:23:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','comments','PRIMARY','2022-12-12 16:23:35','n_diff_pfx01',25,2,'id'),('school14_gjc823','comments','PRIMARY','2022-12-12 16:23:35','n_leaf_pages',2,NULL,'Number of leaf pages in the index'),('school14_gjc823','comments','PRIMARY','2022-12-12 16:23:35','size',3,NULL,'Number of pages in the index'),('school14_gjc823','comments','Unique Student Comment','2022-12-12 16:23:35','n_diff_pfx01',3,1,'sender'),('school14_gjc823','comments','Unique Student Comment','2022-12-12 16:23:35','n_diff_pfx02',25,1,'sender,students_id'),('school14_gjc823','comments','Unique Student Comment','2022-12-12 16:23:35','n_diff_pfx03',25,1,'sender,students_id,date'),('school14_gjc823','comments','Unique Student Comment','2022-12-12 16:23:35','n_diff_pfx04',25,1,'sender,students_id,date,subject'),('school14_gjc823','comments','Unique Student Comment','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','comments','Unique Student Comment','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','compound_subject_structure','PRIMARY','2022-12-12 16:23:33','n_diff_pfx01',0,1,'id'),('school14_gjc823','compound_subject_structure','PRIMARY','2022-12-12 16:23:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','compound_subject_structure','PRIMARY','2022-12-12 16:23:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','compound_subject_structure','compound_subject_id','2022-12-12 16:23:33','n_diff_pfx01',0,1,'compound_subject_id'),('school14_gjc823','compound_subject_structure','compound_subject_id','2022-12-12 16:23:33','n_diff_pfx02',0,1,'compound_subject_id,subject_id'),('school14_gjc823','compound_subject_structure','compound_subject_id','2022-12-12 16:23:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','compound_subject_structure','compound_subject_id','2022-12-12 16:23:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','compound_subjects','PRIMARY','2022-12-12 16:23:33','n_diff_pfx01',0,1,'id'),('school14_gjc823','compound_subjects','PRIMARY','2022-12-12 16:23:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','compound_subjects','PRIMARY','2022-12-12 16:23:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','course_reg','PRIMARY','2022-12-12 16:23:34','n_diff_pfx01',0,1,'id'),('school14_gjc823','course_reg','PRIMARY','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','course_reg','PRIMARY','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','course_reg','Unique Course Reg','2022-12-12 16:23:34','n_diff_pfx01',0,1,'subject_id'),('school14_gjc823','course_reg','Unique Course Reg','2022-12-12 16:23:34','n_diff_pfx02',0,1,'subject_id,student_id'),('school14_gjc823','course_reg','Unique Course Reg','2022-12-12 16:23:34','n_diff_pfx03',0,1,'subject_id,student_id,session_id'),('school14_gjc823','course_reg','Unique Course Reg','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','course_reg','Unique Course Reg','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','cron_refresh','PRIMARY','2022-12-16 19:34:50','n_diff_pfx01',18,1,'id'),('school14_gjc823','cron_refresh','PRIMARY','2022-12-16 19:34:50','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','cron_refresh','PRIMARY','2022-12-16 19:34:50','size',1,NULL,'Number of pages in the index'),('school14_gjc823','cron_refresh','unique_status','2022-12-16 19:34:50','n_diff_pfx01',6,1,'class_id'),('school14_gjc823','cron_refresh','unique_status','2022-12-16 19:34:50','n_diff_pfx02',18,1,'class_id,term_id'),('school14_gjc823','cron_refresh','unique_status','2022-12-16 19:34:50','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','cron_refresh','unique_status','2022-12-16 19:34:50','size',1,NULL,'Number of pages in the index'),('school14_gjc823','default_performance','PRIMARY','2022-12-12 16:23:34','n_diff_pfx01',0,1,'id'),('school14_gjc823','default_performance','PRIMARY','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','default_performance','PRIMARY','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','default_salary_structure','PRIMARY','2022-12-12 16:23:34','n_diff_pfx01',0,1,'id'),('school14_gjc823','default_salary_structure','PRIMARY','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','default_salary_structure','PRIMARY','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','default_salary_structure','Unique level pay','2022-12-12 16:23:34','n_diff_pfx01',0,1,'description'),('school14_gjc823','default_salary_structure','Unique level pay','2022-12-12 16:23:34','n_diff_pfx02',0,1,'description,type'),('school14_gjc823','default_salary_structure','Unique level pay','2022-12-12 16:23:34','n_diff_pfx03',0,1,'description,type,level'),('school14_gjc823','default_salary_structure','Unique level pay','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','default_salary_structure','Unique level pay','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','default_salary_structure','Unique title pay','2022-12-12 16:23:34','n_diff_pfx01',0,1,'type'),('school14_gjc823','default_salary_structure','Unique title pay','2022-12-12 16:23:34','n_diff_pfx02',0,1,'type,title_id'),('school14_gjc823','default_salary_structure','Unique title pay','2022-12-12 16:23:34','n_diff_pfx03',0,1,'type,title_id,description'),('school14_gjc823','default_salary_structure','Unique title pay','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','default_salary_structure','Unique title pay','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','default_schoolfees_structure','PRIMARY','2022-12-12 16:23:34','n_diff_pfx01',0,1,'id'),('school14_gjc823','default_schoolfees_structure','PRIMARY','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','default_schoolfees_structure','PRIMARY','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','default_schoolfees_structure','class_id','2022-12-12 16:23:34','n_diff_pfx01',0,1,'class_id'),('school14_gjc823','default_schoolfees_structure','class_id','2022-12-12 16:23:34','n_diff_pfx02',0,1,'class_id,purpose'),('school14_gjc823','default_schoolfees_structure','class_id','2022-12-12 16:23:34','n_diff_pfx03',0,1,'class_id,purpose,term_id'),('school14_gjc823','default_schoolfees_structure','class_id','2022-12-12 16:23:34','n_diff_pfx04',0,1,'class_id,purpose,term_id,plan'),('school14_gjc823','default_schoolfees_structure','class_id','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','default_schoolfees_structure','class_id','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','demerits','PRIMARY','2022-12-12 16:23:34','n_diff_pfx01',0,1,'id'),('school14_gjc823','demerits','PRIMARY','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','demerits','PRIMARY','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','demerits','Unique Student Comment','2022-12-12 16:23:34','n_diff_pfx01',0,1,'sender'),('school14_gjc823','demerits','Unique Student Comment','2022-12-12 16:23:34','n_diff_pfx02',0,1,'sender,students_id'),('school14_gjc823','demerits','Unique Student Comment','2022-12-12 16:23:34','n_diff_pfx03',0,1,'sender,students_id,date'),('school14_gjc823','demerits','Unique Student Comment','2022-12-12 16:23:34','n_diff_pfx04',0,1,'sender,students_id,date,subject'),('school14_gjc823','demerits','Unique Student Comment','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','demerits','Unique Student Comment','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','departments','PRIMARY','2022-12-12 16:23:36','n_diff_pfx01',23,1,'id'),('school14_gjc823','departments','PRIMARY','2022-12-12 16:23:36','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','departments','PRIMARY','2022-12-12 16:23:36','size',1,NULL,'Number of pages in the index'),('school14_gjc823','departments','department','2022-12-12 16:23:36','n_diff_pfx01',23,1,'department'),('school14_gjc823','departments','department','2022-12-12 16:23:36','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','departments','department','2022-12-12 16:23:36','size',1,NULL,'Number of pages in the index'),('school14_gjc823','description','PRIMARY','2022-12-12 16:23:34','n_diff_pfx01',0,1,'id'),('school14_gjc823','description','PRIMARY','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','description','PRIMARY','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','detentions','PRIMARY','2022-12-12 16:23:34','n_diff_pfx01',0,1,'id'),('school14_gjc823','detentions','PRIMARY','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','detentions','PRIMARY','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','diary','PRIMARY','2022-12-12 16:23:34','n_diff_pfx01',0,1,'diary_id'),('school14_gjc823','diary','PRIMARY','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','diary','PRIMARY','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','discipline','PRIMARY','2022-12-12 16:23:34','n_diff_pfx01',0,1,'id'),('school14_gjc823','discipline','PRIMARY','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','discipline','PRIMARY','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','elective_groups','PRIMARY','2022-12-12 16:23:34','n_diff_pfx01',0,1,'id'),('school14_gjc823','elective_groups','PRIMARY','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','elective_groups','PRIMARY','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','elective_groups','unique codes','2022-12-12 16:23:34','n_diff_pfx01',0,1,'code'),('school14_gjc823','elective_groups','unique codes','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','elective_groups','unique codes','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','elective_status','PRIMARY','2022-12-12 16:23:34','n_diff_pfx01',0,1,'id'),('school14_gjc823','elective_status','PRIMARY','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','elective_status','PRIMARY','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','elective_status','unique student','2022-12-12 16:23:34','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','elective_status','unique student','2022-12-12 16:23:34','n_diff_pfx02',0,1,'student_id,session_id'),('school14_gjc823','elective_status','unique student','2022-12-12 16:23:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','elective_status','unique student','2022-12-12 16:23:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','electives_grades_locker','PRIMARY','2022-12-12 16:23:35','n_diff_pfx01',0,1,'id'),('school14_gjc823','electives_grades_locker','PRIMARY','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','electives_grades_locker','PRIMARY','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','electives_grades_locker','Uniqe term lock','2022-12-12 16:23:35','n_diff_pfx01',0,1,'group_id'),('school14_gjc823','electives_grades_locker','Uniqe term lock','2022-12-12 16:23:35','n_diff_pfx02',0,1,'group_id,term_id'),('school14_gjc823','electives_grades_locker','Uniqe term lock','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','electives_grades_locker','Uniqe term lock','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','employee','PRIMARY','2022-12-12 16:23:36','n_diff_pfx01',94,1,'id'),('school14_gjc823','employee','PRIMARY','2022-12-12 16:23:36','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','employee','PRIMARY','2022-12-12 16:23:36','size',1,NULL,'Number of pages in the index'),('school14_gjc823','employee','title','2022-12-12 16:23:36','n_diff_pfx01',6,1,'title'),('school14_gjc823','employee','title','2022-12-12 16:23:36','n_diff_pfx02',94,1,'title,firstname'),('school14_gjc823','employee','title','2022-12-12 16:23:36','n_diff_pfx03',94,1,'title,firstname,surname'),('school14_gjc823','employee','title','2022-12-12 16:23:36','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','employee','title','2022-12-12 16:23:36','size',1,NULL,'Number of pages in the index'),('school14_gjc823','employee','username','2022-12-12 16:23:36','n_diff_pfx01',94,1,'username'),('school14_gjc823','employee','username','2022-12-12 16:23:36','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','employee','username','2022-12-12 16:23:36','size',1,NULL,'Number of pages in the index'),('school14_gjc823','employee_accounts','PRIMARY','2022-12-12 16:23:35','n_diff_pfx01',0,1,'id'),('school14_gjc823','employee_accounts','PRIMARY','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','employee_accounts','PRIMARY','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','employee_accounts','UniquePay','2022-12-12 16:23:35','n_diff_pfx01',0,1,'employee_id'),('school14_gjc823','employee_accounts','UniquePay','2022-12-12 16:23:35','n_diff_pfx02',0,1,'employee_id,month_id'),('school14_gjc823','employee_accounts','UniquePay','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','employee_accounts','UniquePay','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','employee_fees','PRIMARY','2022-12-12 16:23:35','n_diff_pfx01',0,1,'id'),('school14_gjc823','employee_fees','PRIMARY','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','employee_fees','PRIMARY','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','employee_fees','type','2022-12-12 16:23:35','n_diff_pfx01',0,1,'type'),('school14_gjc823','employee_fees','type','2022-12-12 16:23:35','n_diff_pfx02',0,1,'type,amount'),('school14_gjc823','employee_fees','type','2022-12-12 16:23:35','n_diff_pfx03',0,1,'type,amount,description'),('school14_gjc823','employee_fees','type','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','employee_fees','type','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','employee_transport','PRIMARY','2022-12-12 16:23:35','n_diff_pfx01',0,1,'id'),('school14_gjc823','employee_transport','PRIMARY','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','employee_transport','PRIMARY','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','employee_transport','Unique staff bus','2022-12-12 16:23:35','n_diff_pfx01',0,1,'employee_id'),('school14_gjc823','employee_transport','Unique staff bus','2022-12-12 16:23:35','n_diff_pfx02',0,1,'employee_id,vehicle_route_id'),('school14_gjc823','employee_transport','Unique staff bus','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','employee_transport','Unique staff bus','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','employees_leaves','PRIMARY','2022-12-12 16:23:35','n_diff_pfx01',0,1,'id'),('school14_gjc823','employees_leaves','PRIMARY','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','employees_leaves','PRIMARY','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','employees_leaves','all entries unique','2022-12-12 16:23:35','n_diff_pfx01',0,1,'employee_id'),('school14_gjc823','employees_leaves','all entries unique','2022-12-12 16:23:35','n_diff_pfx02',0,1,'employee_id,startDate'),('school14_gjc823','employees_leaves','all entries unique','2022-12-12 16:23:35','n_diff_pfx03',0,1,'employee_id,startDate,endDate'),('school14_gjc823','employees_leaves','all entries unique','2022-12-12 16:23:35','n_diff_pfx04',0,1,'employee_id,startDate,endDate,leave_type_id'),('school14_gjc823','employees_leaves','all entries unique','2022-12-12 16:23:35','n_diff_pfx05',0,1,'employee_id,startDate,endDate,leave_type_id,superadmin_id'),('school14_gjc823','employees_leaves','all entries unique','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','employees_leaves','all entries unique','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','entrance_settings','PRIMARY','2022-12-12 16:23:35','n_diff_pfx01',0,1,'id'),('school14_gjc823','entrance_settings','PRIMARY','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','entrance_settings','PRIMARY','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','evaluation_reports','PRIMARY','2022-12-12 16:23:36','n_diff_pfx01',439,14,'id'),('school14_gjc823','evaluation_reports','PRIMARY','2022-12-12 16:23:36','n_leaf_pages',14,NULL,'Number of leaf pages in the index'),('school14_gjc823','evaluation_reports','PRIMARY','2022-12-12 16:23:36','size',15,NULL,'Number of pages in the index'),('school14_gjc823','evaluation_reports','student_id','2022-12-12 16:23:36','n_diff_pfx01',182,1,'student_id'),('school14_gjc823','evaluation_reports','student_id','2022-12-12 16:23:36','n_diff_pfx02',439,1,'student_id,term_id'),('school14_gjc823','evaluation_reports','student_id','2022-12-12 16:23:36','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','evaluation_reports','student_id','2022-12-12 16:23:36','size',1,NULL,'Number of pages in the index'),('school14_gjc823','events_holidays','PRIMARY','2022-12-12 16:23:35','n_diff_pfx01',0,1,'id'),('school14_gjc823','events_holidays','PRIMARY','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','events_holidays','PRIMARY','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','events_holidays','startDate','2022-12-12 16:23:35','n_diff_pfx01',0,1,'startDate'),('school14_gjc823','events_holidays','startDate','2022-12-12 16:23:35','n_diff_pfx02',0,1,'startDate,endDate'),('school14_gjc823','events_holidays','startDate','2022-12-12 16:23:35','n_diff_pfx03',0,1,'startDate,endDate,title'),('school14_gjc823','events_holidays','startDate','2022-12-12 16:23:35','n_diff_pfx04',0,1,'startDate,endDate,title,description'),('school14_gjc823','events_holidays','startDate','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','events_holidays','startDate','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','exam_centres','PRIMARY','2022-12-12 16:23:35','n_diff_pfx01',0,1,'id'),('school14_gjc823','exam_centres','PRIMARY','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','exam_centres','PRIMARY','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','exam_centres','centre','2022-12-12 16:23:35','n_diff_pfx01',0,1,'centre'),('school14_gjc823','exam_centres','centre','2022-12-12 16:23:35','n_diff_pfx02',0,1,'centre,city_id'),('school14_gjc823','exam_centres','centre','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','exam_centres','centre','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','exam_cities','PRIMARY','2022-12-12 16:23:35','n_diff_pfx01',0,1,'id'),('school14_gjc823','exam_cities','PRIMARY','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','exam_cities','PRIMARY','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','exam_cities','city','2022-12-12 16:23:35','n_diff_pfx01',0,1,'city'),('school14_gjc823','exam_cities','city','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','exam_cities','city','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','exchange_rates','PRIMARY','2022-12-12 16:23:35','n_diff_pfx01',0,1,'id'),('school14_gjc823','exchange_rates','PRIMARY','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','exchange_rates','PRIMARY','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','exchange_rates','source','2022-12-12 16:23:35','n_diff_pfx01',0,1,'source'),('school14_gjc823','exchange_rates','source','2022-12-12 16:23:35','n_diff_pfx02',0,1,'source,target'),('school14_gjc823','exchange_rates','source','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','exchange_rates','source','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','faculties','PRIMARY','2022-12-12 16:23:35','n_diff_pfx01',0,1,'id'),('school14_gjc823','faculties','PRIMARY','2022-12-12 16:23:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','faculties','PRIMARY','2022-12-12 16:23:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','files','PRIMARY','2022-12-12 16:23:36','n_diff_pfx01',0,1,'id'),('school14_gjc823','files','PRIMARY','2022-12-12 16:23:36','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','files','PRIMARY','2022-12-12 16:23:36','size',1,NULL,'Number of pages in the index'),('school14_gjc823','gradding_structure','PRIMARY','2022-12-12 16:23:36','n_diff_pfx01',0,1,'id'),('school14_gjc823','gradding_structure','PRIMARY','2022-12-12 16:23:36','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','gradding_structure','PRIMARY','2022-12-12 16:23:36','size',1,NULL,'Number of pages in the index'),('school14_gjc823','gradding_structure','class_level_id','2022-12-12 16:23:36','n_diff_pfx01',0,1,'class_level_id'),('school14_gjc823','gradding_structure','class_level_id','2022-12-12 16:23:36','n_diff_pfx02',0,1,'class_level_id,session_id'),('school14_gjc823','gradding_structure','class_level_id','2022-12-12 16:23:36','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','gradding_structure','class_level_id','2022-12-12 16:23:36','size',1,NULL,'Number of pages in the index'),('school14_gjc823','grades','PRIMARY','2022-12-12 16:23:36','n_diff_pfx01',5,1,'id'),('school14_gjc823','grades','PRIMARY','2022-12-12 16:23:36','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','grades','PRIMARY','2022-12-12 16:23:36','size',1,NULL,'Number of pages in the index'),('school14_gjc823','grades','unique key','2022-12-12 16:23:36','n_diff_pfx01',5,1,'key'),('school14_gjc823','grades','unique key','2022-12-12 16:23:36','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','grades','unique key','2022-12-12 16:23:36','size',1,NULL,'Number of pages in the index'),('school14_gjc823','grades_locker','PRIMARY','2022-12-12 16:23:37','n_diff_pfx01',290,1,'id'),('school14_gjc823','grades_locker','PRIMARY','2022-12-12 16:23:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','grades_locker','PRIMARY','2022-12-12 16:23:37','size',1,NULL,'Number of pages in the index'),('school14_gjc823','grades_locker','subject_id','2022-12-12 16:23:37','n_diff_pfx01',21,1,'subject_id'),('school14_gjc823','grades_locker','subject_id','2022-12-12 16:23:37','n_diff_pfx02',55,1,'subject_id,term_id'),('school14_gjc823','grades_locker','subject_id','2022-12-12 16:23:37','n_diff_pfx03',290,1,'subject_id,term_id,class_id'),('school14_gjc823','grades_locker','subject_id','2022-12-12 16:23:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','grades_locker','subject_id','2022-12-12 16:23:37','size',1,NULL,'Number of pages in the index'),('school14_gjc823','grading_default','PRIMARY','2022-12-12 16:23:37','n_diff_pfx01',7,1,'id'),('school14_gjc823','grading_default','PRIMARY','2022-12-12 16:23:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','grading_default','PRIMARY','2022-12-12 16:23:37','size',1,NULL,'Number of pages in the index'),('school14_gjc823','grading_system','PRIMARY','2022-12-12 16:23:37','n_diff_pfx01',6,1,'id'),('school14_gjc823','grading_system','PRIMARY','2022-12-12 16:23:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','grading_system','PRIMARY','2022-12-12 16:23:37','size',1,NULL,'Number of pages in the index'),('school14_gjc823','graduation_awards','PRIMARY','2022-12-12 16:23:36','n_diff_pfx01',0,1,'id'),('school14_gjc823','graduation_awards','PRIMARY','2022-12-12 16:23:36','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','graduation_awards','PRIMARY','2022-12-12 16:23:36','size',1,NULL,'Number of pages in the index'),('school14_gjc823','graduation_awards','student_id','2022-12-12 16:23:36','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','graduation_awards','student_id','2022-12-12 16:23:36','n_diff_pfx02',0,1,'student_id,session_id'),('school14_gjc823','graduation_awards','student_id','2022-12-12 16:23:36','n_diff_pfx03',0,1,'student_id,session_id,subject_id'),('school14_gjc823','graduation_awards','student_id','2022-12-12 16:23:36','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','graduation_awards','student_id','2022-12-12 16:23:36','size',1,NULL,'Number of pages in the index'),('school14_gjc823','graduation_awards_averages','PRIMARY','2022-12-12 16:23:36','n_diff_pfx01',0,1,'id'),('school14_gjc823','graduation_awards_averages','PRIMARY','2022-12-12 16:23:36','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','graduation_awards_averages','PRIMARY','2022-12-12 16:23:36','size',1,NULL,'Number of pages in the index'),('school14_gjc823','graduation_awards_averages','student_id','2022-12-12 16:23:36','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','graduation_awards_averages','student_id','2022-12-12 16:23:36','n_diff_pfx02',0,1,'student_id,session_id'),('school14_gjc823','graduation_awards_averages','student_id','2022-12-12 16:23:36','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','graduation_awards_averages','student_id','2022-12-12 16:23:36','size',1,NULL,'Number of pages in the index'),('school14_gjc823','grouped_subjects','PRIMARY','2022-12-12 16:23:36','n_diff_pfx01',0,1,'id'),('school14_gjc823','grouped_subjects','PRIMARY','2022-12-12 16:23:36','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','grouped_subjects','PRIMARY','2022-12-12 16:23:36','size',1,NULL,'Number of pages in the index'),('school14_gjc823','health_reports','PRIMARY','2022-12-12 16:23:36','n_diff_pfx01',0,1,'id'),('school14_gjc823','health_reports','PRIMARY','2022-12-12 16:23:36','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','health_reports','PRIMARY','2022-12-12 16:23:36','size',1,NULL,'Number of pages in the index'),('school14_gjc823','hostel_houses','PRIMARY','2022-12-12 16:23:37','n_diff_pfx01',4,1,'id'),('school14_gjc823','hostel_houses','PRIMARY','2022-12-12 16:23:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','hostel_houses','PRIMARY','2022-12-12 16:23:37','size',1,NULL,'Number of pages in the index'),('school14_gjc823','hostel_rooms','PRIMARY','2022-12-12 16:23:38','n_diff_pfx01',8,1,'id'),('school14_gjc823','hostel_rooms','PRIMARY','2022-12-12 16:23:38','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','hostel_rooms','PRIMARY','2022-12-12 16:23:38','size',1,NULL,'Number of pages in the index'),('school14_gjc823','hostel_rooms','Unique Number','2022-12-12 16:23:38','n_diff_pfx01',8,1,'number'),('school14_gjc823','hostel_rooms','Unique Number','2022-12-12 16:23:38','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','hostel_rooms','Unique Number','2022-12-12 16:23:38','size',1,NULL,'Number of pages in the index'),('school14_gjc823','hostel_rooms','Unique name','2022-12-12 16:23:38','n_diff_pfx01',8,1,'name'),('school14_gjc823','hostel_rooms','Unique name','2022-12-12 16:23:38','n_diff_pfx02',8,1,'name,hostel_id'),('school14_gjc823','hostel_rooms','Unique name','2022-12-12 16:23:38','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','hostel_rooms','Unique name','2022-12-12 16:23:38','size',1,NULL,'Number of pages in the index'),('school14_gjc823','hostels','PRIMARY','2022-12-12 16:23:38','n_diff_pfx01',2,1,'id'),('school14_gjc823','hostels','PRIMARY','2022-12-12 16:23:38','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','hostels','PRIMARY','2022-12-12 16:23:38','size',1,NULL,'Number of pages in the index'),('school14_gjc823','improvement_awards','PRIMARY','2022-12-12 16:23:37','n_diff_pfx01',0,1,'id'),('school14_gjc823','improvement_awards','PRIMARY','2022-12-12 16:23:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','improvement_awards','PRIMARY','2022-12-12 16:23:37','size',1,NULL,'Number of pages in the index'),('school14_gjc823','improvement_awards','student_id','2022-12-12 16:23:37','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','improvement_awards','student_id','2022-12-12 16:23:37','n_diff_pfx02',0,1,'student_id,session_id'),('school14_gjc823','improvement_awards','student_id','2022-12-12 16:23:37','n_diff_pfx03',0,1,'student_id,session_id,subject_id'),('school14_gjc823','improvement_awards','student_id','2022-12-12 16:23:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','improvement_awards','student_id','2022-12-12 16:23:37','size',1,NULL,'Number of pages in the index'),('school14_gjc823','improvement_awards_averages','PRIMARY','2022-12-12 16:23:37','n_diff_pfx01',0,1,'id'),('school14_gjc823','improvement_awards_averages','PRIMARY','2022-12-12 16:23:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','improvement_awards_averages','PRIMARY','2022-12-12 16:23:37','size',1,NULL,'Number of pages in the index'),('school14_gjc823','improvement_awards_averages','student_id','2022-12-12 16:23:37','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','improvement_awards_averages','student_id','2022-12-12 16:23:37','n_diff_pfx02',0,1,'student_id,session_id'),('school14_gjc823','improvement_awards_averages','student_id','2022-12-12 16:23:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','improvement_awards_averages','student_id','2022-12-12 16:23:37','size',1,NULL,'Number of pages in the index'),('school14_gjc823','interface','PRIMARY','2022-12-12 16:23:38','n_diff_pfx01',12,1,'id'),('school14_gjc823','interface','PRIMARY','2022-12-12 16:23:38','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','interface','PRIMARY','2022-12-12 16:23:38','size',1,NULL,'Number of pages in the index'),('school14_gjc823','interface','option','2022-12-12 16:23:38','n_diff_pfx01',12,1,'option'),('school14_gjc823','interface','option','2022-12-12 16:23:38','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','interface','option','2022-12-12 16:23:38','size',1,NULL,'Number of pages in the index'),('school14_gjc823','interview_datetimes','PRIMARY','2022-12-12 16:23:37','n_diff_pfx01',0,1,'id'),('school14_gjc823','interview_datetimes','PRIMARY','2022-12-12 16:23:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','interview_datetimes','PRIMARY','2022-12-12 16:23:37','size',1,NULL,'Number of pages in the index'),('school14_gjc823','interview_datetimes','date','2022-12-12 16:23:37','n_diff_pfx01',0,1,'date'),('school14_gjc823','interview_datetimes','date','2022-12-12 16:23:37','n_diff_pfx02',0,1,'date,time'),('school14_gjc823','interview_datetimes','date','2022-12-12 16:23:37','n_diff_pfx03',0,1,'date,time,session_id'),('school14_gjc823','interview_datetimes','date','2022-12-12 16:23:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','interview_datetimes','date','2022-12-12 16:23:37','size',1,NULL,'Number of pages in the index'),('school14_gjc823','inventory','PRIMARY','2022-12-12 16:23:37','n_diff_pfx01',0,1,'id'),('school14_gjc823','inventory','PRIMARY','2022-12-12 16:23:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','inventory','PRIMARY','2022-12-12 16:23:37','size',1,NULL,'Number of pages in the index'),('school14_gjc823','inventory','UniqueItem','2022-12-12 16:23:37','n_diff_pfx01',0,1,'name'),('school14_gjc823','inventory','UniqueItem','2022-12-12 16:23:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','inventory','UniqueItem','2022-12-12 16:23:37','size',1,NULL,'Number of pages in the index'),('school14_gjc823','leave_types','PRIMARY','2022-12-12 16:23:37','n_diff_pfx01',0,1,'id'),('school14_gjc823','leave_types','PRIMARY','2022-12-12 16:23:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','leave_types','PRIMARY','2022-12-12 16:23:37','size',1,NULL,'Number of pages in the index'),('school14_gjc823','lesson_notes','PRIMARY','2022-12-12 16:23:37','n_diff_pfx01',0,1,'id'),('school14_gjc823','lesson_notes','PRIMARY','2022-12-12 16:23:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','lesson_notes','PRIMARY','2022-12-12 16:23:37','size',1,NULL,'Number of pages in the index'),('school14_gjc823','level_payment_plans','PRIMARY','2022-12-12 16:23:37','n_diff_pfx01',0,1,'id'),('school14_gjc823','level_payment_plans','PRIMARY','2022-12-12 16:23:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','level_payment_plans','PRIMARY','2022-12-12 16:23:37','size',1,NULL,'Number of pages in the index'),('school14_gjc823','levels','PRIMARY','2022-12-12 16:23:38','n_diff_pfx01',12,1,'id'),('school14_gjc823','levels','PRIMARY','2022-12-12 16:23:38','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','levels','PRIMARY','2022-12-12 16:23:38','size',1,NULL,'Number of pages in the index'),('school14_gjc823','levels','level and title','2022-12-12 16:23:38','n_diff_pfx01',12,1,'level'),('school14_gjc823','levels','level and title','2022-12-12 16:23:38','n_diff_pfx02',12,1,'level,title'),('school14_gjc823','levels','level and title','2022-12-12 16:23:38','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','levels','level and title','2022-12-12 16:23:38','size',1,NULL,'Number of pages in the index'),('school14_gjc823','library_setting','PRIMARY','2022-12-12 16:23:37','n_diff_pfx01',0,1,'id'),('school14_gjc823','library_setting','PRIMARY','2022-12-12 16:23:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','library_setting','PRIMARY','2022-12-12 16:23:37','size',1,NULL,'Number of pages in the index'),('school14_gjc823','log','PRIMARY','2022-12-17 14:31:29','n_diff_pfx01',1423,20,'id'),('school14_gjc823','log','PRIMARY','2022-12-17 14:31:29','n_leaf_pages',42,NULL,'Number of leaf pages in the index'),('school14_gjc823','log','PRIMARY','2022-12-17 14:31:29','size',97,NULL,'Number of pages in the index'),('school14_gjc823','mails','PRIMARY','2022-12-17 16:43:06','n_diff_pfx01',234,5,'id'),('school14_gjc823','mails','PRIMARY','2022-12-17 16:43:06','n_leaf_pages',5,NULL,'Number of leaf pages in the index'),('school14_gjc823','mails','PRIMARY','2022-12-17 16:43:06','size',6,NULL,'Number of pages in the index'),('school14_gjc823','message_templates','PRIMARY','2022-12-12 16:23:38','n_diff_pfx01',0,1,'id'),('school14_gjc823','message_templates','PRIMARY','2022-12-12 16:23:38','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','message_templates','PRIMARY','2022-12-12 16:23:38','size',1,NULL,'Number of pages in the index'),('school14_gjc823','months','PRIMARY','2022-12-12 16:23:39','n_diff_pfx01',12,1,'id'),('school14_gjc823','months','PRIMARY','2022-12-12 16:23:39','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','months','PRIMARY','2022-12-12 16:23:39','size',1,NULL,'Number of pages in the index'),('school14_gjc823','newsletters','PRIMARY','2022-12-12 16:23:39','n_diff_pfx01',10,1,'id'),('school14_gjc823','newsletters','PRIMARY','2022-12-12 16:23:39','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','newsletters','PRIMARY','2022-12-12 16:23:39','size',1,NULL,'Number of pages in the index'),('school14_gjc823','notifications','PRIMARY','2022-12-12 16:23:38','n_diff_pfx01',0,1,'id'),('school14_gjc823','notifications','PRIMARY','2022-12-12 16:23:38','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','notifications','PRIMARY','2022-12-12 16:23:38','size',1,NULL,'Number of pages in the index'),('school14_gjc823','offences','PRIMARY','2022-12-12 16:23:40','n_diff_pfx01',10,1,'id'),('school14_gjc823','offences','PRIMARY','2022-12-12 16:23:40','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','offences','PRIMARY','2022-12-12 16:23:40','size',1,NULL,'Number of pages in the index'),('school14_gjc823','options','PRIMARY','2022-12-12 16:23:40','n_diff_pfx01',95,1,'key'),('school14_gjc823','options','PRIMARY','2022-12-12 16:23:40','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','options','PRIMARY','2022-12-12 16:23:40','size',1,NULL,'Number of pages in the index'),('school14_gjc823','options','id','2022-12-12 16:23:40','n_diff_pfx01',95,1,'id'),('school14_gjc823','options','id','2022-12-12 16:23:40','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','options','id','2022-12-12 16:23:40','size',1,NULL,'Number of pages in the index'),('school14_gjc823','paid_bills','PRIMARY','2022-12-12 16:23:38','n_diff_pfx01',0,1,'id'),('school14_gjc823','paid_bills','PRIMARY','2022-12-12 16:23:38','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','paid_bills','PRIMARY','2022-12-12 16:23:38','size',1,NULL,'Number of pages in the index'),('school14_gjc823','paid_bills','fee_id','2022-12-12 16:23:38','n_diff_pfx01',0,1,'fee_id'),('school14_gjc823','paid_bills','fee_id','2022-12-12 16:23:38','n_diff_pfx02',0,1,'fee_id,student_id'),('school14_gjc823','paid_bills','fee_id','2022-12-12 16:23:38','n_diff_pfx03',0,1,'fee_id,student_id,id'),('school14_gjc823','paid_bills','fee_id','2022-12-12 16:23:38','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','paid_bills','fee_id','2022-12-12 16:23:38','size',1,NULL,'Number of pages in the index'),('school14_gjc823','paid_bills','transaction_id','2022-12-12 16:23:38','n_diff_pfx01',0,1,'transaction_id'),('school14_gjc823','paid_bills','transaction_id','2022-12-12 16:23:38','n_diff_pfx02',0,1,'transaction_id,student_id'),('school14_gjc823','paid_bills','transaction_id','2022-12-12 16:23:38','n_diff_pfx03',0,1,'transaction_id,student_id,id'),('school14_gjc823','paid_bills','transaction_id','2022-12-12 16:23:38','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','paid_bills','transaction_id','2022-12-12 16:23:38','size',1,NULL,'Number of pages in the index'),('school14_gjc823','paid_students','PRIMARY','2022-12-12 16:23:38','n_diff_pfx01',0,1,'id'),('school14_gjc823','paid_students','PRIMARY','2022-12-12 16:23:38','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','paid_students','PRIMARY','2022-12-12 16:23:38','size',1,NULL,'Number of pages in the index'),('school14_gjc823','paid_students','student_id','2022-12-12 16:23:38','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','paid_students','student_id','2022-12-12 16:23:38','n_diff_pfx02',0,1,'student_id,term_id'),('school14_gjc823','paid_students','student_id','2022-12-12 16:23:38','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','paid_students','student_id','2022-12-12 16:23:38','size',1,NULL,'Number of pages in the index'),('school14_gjc823','parent_login','PRIMARY','2022-12-12 16:23:41','n_diff_pfx01',326,2,'id'),('school14_gjc823','parent_login','PRIMARY','2022-12-12 16:23:41','n_leaf_pages',2,NULL,'Number of leaf pages in the index'),('school14_gjc823','parent_login','PRIMARY','2022-12-12 16:23:41','size',3,NULL,'Number of pages in the index'),('school14_gjc823','parent_login','parents_id','2022-12-12 16:23:41','n_diff_pfx01',326,1,'parent_id'),('school14_gjc823','parent_login','parents_id','2022-12-12 16:23:41','n_diff_pfx02',326,1,'parent_id,username'),('school14_gjc823','parent_login','parents_id','2022-12-12 16:23:41','n_diff_pfx03',326,1,'parent_id,username,password'),('school14_gjc823','parent_login','parents_id','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','parent_login','parents_id','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','parent_login','parents_id_2','2022-12-12 16:23:41','n_diff_pfx01',326,1,'parent_id'),('school14_gjc823','parent_login','parents_id_2','2022-12-12 16:23:41','n_diff_pfx02',326,1,'parent_id,username'),('school14_gjc823','parent_login','parents_id_2','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','parent_login','parents_id_2','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','parent_login','parents_id_3','2022-12-12 16:23:41','n_diff_pfx01',326,1,'parent_id'),('school14_gjc823','parent_login','parents_id_3','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','parent_login','parents_id_3','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','parent_pins','PRIMARY','2022-12-12 16:23:38','n_diff_pfx01',0,1,'id'),('school14_gjc823','parent_pins','PRIMARY','2022-12-12 16:23:38','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','parent_pins','PRIMARY','2022-12-12 16:23:38','size',1,NULL,'Number of pages in the index'),('school14_gjc823','parent_pins','Unique PIN','2022-12-12 16:23:38','n_diff_pfx01',0,1,'pin'),('school14_gjc823','parent_pins','Unique PIN','2022-12-12 16:23:38','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','parent_pins','Unique PIN','2022-12-12 16:23:38','size',1,NULL,'Number of pages in the index'),('school14_gjc823','parents','PRIMARY','2022-12-12 16:23:41','n_diff_pfx01',326,3,'id'),('school14_gjc823','parents','PRIMARY','2022-12-12 16:23:41','n_leaf_pages',3,NULL,'Number of leaf pages in the index'),('school14_gjc823','parents','PRIMARY','2022-12-12 16:23:41','size',4,NULL,'Number of pages in the index'),('school14_gjc823','parents','email','2022-12-12 16:23:41','n_diff_pfx01',326,1,'email'),('school14_gjc823','parents','email','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','parents','email','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','parents','mobile','2022-12-12 16:23:41','n_diff_pfx01',326,1,'mobile'),('school14_gjc823','parents','mobile','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','parents','mobile','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','payment_plans','PRIMARY','2022-12-12 16:23:38','n_diff_pfx01',0,1,'id'),('school14_gjc823','payment_plans','PRIMARY','2022-12-12 16:23:38','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','payment_plans','PRIMARY','2022-12-12 16:23:38','size',1,NULL,'Number of pages in the index'),('school14_gjc823','payment_types','PRIMARY','2022-12-12 16:23:42','n_diff_pfx01',5,1,'id'),('school14_gjc823','payment_types','PRIMARY','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','payment_types','PRIMARY','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','payment_types','Unique payment system','2022-12-12 16:23:42','n_diff_pfx01',5,1,'type'),('school14_gjc823','payment_types','Unique payment system','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','payment_types','Unique payment system','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','penalty_fees','PRIMARY','2022-12-12 16:23:39','n_diff_pfx01',0,1,'id'),('school14_gjc823','penalty_fees','PRIMARY','2022-12-12 16:23:39','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','penalty_fees','PRIMARY','2022-12-12 16:23:39','size',1,NULL,'Number of pages in the index'),('school14_gjc823','pending_parent_login','PRIMARY','2022-12-12 16:23:39','n_diff_pfx01',0,1,'id'),('school14_gjc823','pending_parent_login','PRIMARY','2022-12-12 16:23:39','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','pending_parent_login','PRIMARY','2022-12-12 16:23:39','size',1,NULL,'Number of pages in the index'),('school14_gjc823','pending_parent_login','parents_id','2022-12-12 16:23:39','n_diff_pfx01',0,1,'parent_id'),('school14_gjc823','pending_parent_login','parents_id','2022-12-12 16:23:39','n_diff_pfx02',0,1,'parent_id,username'),('school14_gjc823','pending_parent_login','parents_id','2022-12-12 16:23:39','n_diff_pfx03',0,1,'parent_id,username,password'),('school14_gjc823','pending_parent_login','parents_id','2022-12-12 16:23:39','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','pending_parent_login','parents_id','2022-12-12 16:23:39','size',1,NULL,'Number of pages in the index'),('school14_gjc823','pending_parent_login','parents_id_2','2022-12-12 16:23:39','n_diff_pfx01',0,1,'parent_id'),('school14_gjc823','pending_parent_login','parents_id_2','2022-12-12 16:23:39','n_diff_pfx02',0,1,'parent_id,username'),('school14_gjc823','pending_parent_login','parents_id_2','2022-12-12 16:23:39','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','pending_parent_login','parents_id_2','2022-12-12 16:23:39','size',1,NULL,'Number of pages in the index'),('school14_gjc823','pending_parent_login','parents_id_3','2022-12-12 16:23:39','n_diff_pfx01',0,1,'parent_id'),('school14_gjc823','pending_parent_login','parents_id_3','2022-12-12 16:23:39','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','pending_parent_login','parents_id_3','2022-12-12 16:23:39','size',1,NULL,'Number of pages in the index'),('school14_gjc823','pending_parent_login','username','2022-12-12 16:23:39','n_diff_pfx01',0,1,'username'),('school14_gjc823','pending_parent_login','username','2022-12-12 16:23:39','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','pending_parent_login','username','2022-12-12 16:23:39','size',1,NULL,'Number of pages in the index'),('school14_gjc823','pending_parents','PRIMARY','2022-12-12 16:23:42','n_diff_pfx01',1526,20,'id'),('school14_gjc823','pending_parents','PRIMARY','2022-12-12 16:23:42','n_leaf_pages',27,NULL,'Number of leaf pages in the index'),('school14_gjc823','pending_parents','PRIMARY','2022-12-12 16:23:42','size',28,NULL,'Number of pages in the index'),('school14_gjc823','pending_student_login','PRIMARY','2022-12-12 16:23:39','n_diff_pfx01',0,1,'id'),('school14_gjc823','pending_student_login','PRIMARY','2022-12-12 16:23:39','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','pending_student_login','PRIMARY','2022-12-12 16:23:39','size',1,NULL,'Number of pages in the index'),('school14_gjc823','pending_student_login','student_id','2022-12-12 16:23:39','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','pending_student_login','student_id','2022-12-12 16:23:39','n_diff_pfx02',0,1,'student_id,username'),('school14_gjc823','pending_student_login','student_id','2022-12-12 16:23:39','n_diff_pfx03',0,1,'student_id,username,password'),('school14_gjc823','pending_student_login','student_id','2022-12-12 16:23:39','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','pending_student_login','student_id','2022-12-12 16:23:39','size',1,NULL,'Number of pages in the index'),('school14_gjc823','pending_student_login','username','2022-12-12 16:23:39','n_diff_pfx01',0,1,'username'),('school14_gjc823','pending_student_login','username','2022-12-12 16:23:39','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','pending_student_login','username','2022-12-12 16:23:39','size',1,NULL,'Number of pages in the index'),('school14_gjc823','pending_students','PRIMARY','2022-12-12 16:23:42','n_diff_pfx01',882,20,'id'),('school14_gjc823','pending_students','PRIMARY','2022-12-12 16:23:42','n_leaf_pages',22,NULL,'Number of leaf pages in the index'),('school14_gjc823','pending_students','PRIMARY','2022-12-12 16:23:42','size',23,NULL,'Number of pages in the index'),('school14_gjc823','pending_students','Unique PIN','2022-12-12 16:23:42','n_diff_pfx01',892,3,'pin'),('school14_gjc823','pending_students','Unique PIN','2022-12-12 16:23:42','n_leaf_pages',3,NULL,'Number of leaf pages in the index'),('school14_gjc823','pending_students','Unique PIN','2022-12-12 16:23:42','size',4,NULL,'Number of pages in the index'),('school14_gjc823','performance_comments','PRIMARY','2022-12-12 16:23:40','n_diff_pfx01',0,1,'id'),('school14_gjc823','performance_comments','PRIMARY','2022-12-12 16:23:40','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performance_comments','PRIMARY','2022-12-12 16:23:40','size',1,NULL,'Number of pages in the index'),('school14_gjc823','performance_comments','all','2022-12-12 16:23:40','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','performance_comments','all','2022-12-12 16:23:40','n_diff_pfx02',0,1,'student_id,comment'),('school14_gjc823','performance_comments','all','2022-12-12 16:23:40','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performance_comments','all','2022-12-12 16:23:40','size',1,NULL,'Number of pages in the index'),('school14_gjc823','performance_comments','studentSession','2022-12-12 16:23:40','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','performance_comments','studentSession','2022-12-12 16:23:40','n_diff_pfx02',0,1,'student_id,session_id'),('school14_gjc823','performance_comments','studentSession','2022-12-12 16:23:40','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performance_comments','studentSession','2022-12-12 16:23:40','size',1,NULL,'Number of pages in the index'),('school14_gjc823','performance_comments','studentSessionTerm','2022-12-12 16:23:40','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','performance_comments','studentSessionTerm','2022-12-12 16:23:40','n_diff_pfx02',0,1,'student_id,term_id'),('school14_gjc823','performance_comments','studentSessionTerm','2022-12-12 16:23:40','n_diff_pfx03',0,1,'student_id,term_id,session_id'),('school14_gjc823','performance_comments','studentSessionTerm','2022-12-12 16:23:40','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performance_comments','studentSessionTerm','2022-12-12 16:23:40','size',1,NULL,'Number of pages in the index'),('school14_gjc823','performance_comments','studentTerm','2022-12-12 16:23:40','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','performance_comments','studentTerm','2022-12-12 16:23:40','n_diff_pfx02',0,1,'student_id,term_id'),('school14_gjc823','performance_comments','studentTerm','2022-12-12 16:23:40','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performance_comments','studentTerm','2022-12-12 16:23:40','size',1,NULL,'Number of pages in the index'),('school14_gjc823','performance_settings','PRIMARY','2022-12-12 16:23:42','n_diff_pfx01',27,1,'id'),('school14_gjc823','performance_settings','PRIMARY','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performance_settings','PRIMARY','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','performance_settings','class_id','2022-12-12 16:23:42','n_diff_pfx01',1,1,'class_id'),('school14_gjc823','performance_settings','class_id','2022-12-12 16:23:42','n_diff_pfx02',7,1,'class_id,class_level_id'),('school14_gjc823','performance_settings','class_id','2022-12-12 16:23:42','n_diff_pfx03',7,1,'class_id,class_level_id,term'),('school14_gjc823','performance_settings','class_id','2022-12-12 16:23:42','n_diff_pfx04',7,1,'class_id,class_level_id,term,session_id'),('school14_gjc823','performance_settings','class_id','2022-12-12 16:23:42','n_diff_pfx05',27,1,'class_id,class_level_id,term,session_id,id'),('school14_gjc823','performance_settings','class_id','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performance_settings','class_id','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','performances','PRIMARY','2022-12-16 19:28:28','n_diff_pfx01',8001,20,'id'),('school14_gjc823','performances','PRIMARY','2022-12-16 19:28:28','n_leaf_pages',83,NULL,'Number of leaf pages in the index'),('school14_gjc823','performances','PRIMARY','2022-12-16 19:28:28','size',97,NULL,'Number of pages in the index'),('school14_gjc823','performances','UniqueResult','2022-12-16 19:28:28','n_diff_pfx01',183,20,'student_id'),('school14_gjc823','performances','UniqueResult','2022-12-16 19:28:28','n_diff_pfx02',3535,20,'student_id,subject_id'),('school14_gjc823','performances','UniqueResult','2022-12-16 19:28:28','n_diff_pfx03',7991,20,'student_id,subject_id,term_id'),('school14_gjc823','performances','UniqueResult','2022-12-16 19:28:28','n_diff_pfx04',7991,20,'student_id,subject_id,term_id,class_id'),('school14_gjc823','performances','UniqueResult','2022-12-16 19:28:28','n_leaf_pages',20,NULL,'Number of leaf pages in the index'),('school14_gjc823','performances','UniqueResult','2022-12-16 19:28:28','size',21,NULL,'Number of pages in the index'),('school14_gjc823','performances','student_id','2022-12-16 19:28:28','n_diff_pfx01',183,21,'student_id'),('school14_gjc823','performances','student_id','2022-12-16 19:28:28','n_diff_pfx02',3535,21,'student_id,subject_id'),('school14_gjc823','performances','student_id','2022-12-16 19:28:28','n_diff_pfx03',7991,21,'student_id,subject_id,term_id'),('school14_gjc823','performances','student_id','2022-12-16 19:28:28','n_leaf_pages',21,NULL,'Number of leaf pages in the index'),('school14_gjc823','performances','student_id','2022-12-16 19:28:28','size',22,NULL,'Number of pages in the index'),('school14_gjc823','performances_compound','PRIMARY','2022-12-12 16:23:41','n_diff_pfx01',0,1,'id'),('school14_gjc823','performances_compound','PRIMARY','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performances_compound','PRIMARY','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','performances_compound','UNIQUE COMPOUND','2022-12-12 16:23:41','n_diff_pfx01',0,1,'term_id'),('school14_gjc823','performances_compound','UNIQUE COMPOUND','2022-12-12 16:23:41','n_diff_pfx02',0,1,'term_id,student_id'),('school14_gjc823','performances_compound','UNIQUE COMPOUND','2022-12-12 16:23:41','n_diff_pfx03',0,1,'term_id,student_id,compound_subject_id'),('school14_gjc823','performances_compound','UNIQUE COMPOUND','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performances_compound','UNIQUE COMPOUND','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','performances_compound','ca1_rank','2022-12-12 16:23:41','n_diff_pfx01',0,1,'ca1_rank'),('school14_gjc823','performances_compound','ca1_rank','2022-12-12 16:23:41','n_diff_pfx02',0,1,'ca1_rank,id'),('school14_gjc823','performances_compound','ca1_rank','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performances_compound','ca1_rank','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','performances_compound','ca2_rank','2022-12-12 16:23:41','n_diff_pfx01',0,1,'ca2_rank'),('school14_gjc823','performances_compound','ca2_rank','2022-12-12 16:23:41','n_diff_pfx02',0,1,'ca2_rank,id'),('school14_gjc823','performances_compound','ca2_rank','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performances_compound','ca2_rank','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','performances_compound','class_id','2022-12-12 16:23:41','n_diff_pfx01',0,1,'class_id'),('school14_gjc823','performances_compound','class_id','2022-12-12 16:23:41','n_diff_pfx02',0,1,'class_id,id'),('school14_gjc823','performances_compound','class_id','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performances_compound','class_id','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','performances_compound','compound_subject_id','2022-12-12 16:23:41','n_diff_pfx01',0,1,'compound_subject_id'),('school14_gjc823','performances_compound','compound_subject_id','2022-12-12 16:23:41','n_diff_pfx02',0,1,'compound_subject_id,id'),('school14_gjc823','performances_compound','compound_subject_id','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performances_compound','compound_subject_id','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','performances_compound','rank','2022-12-12 16:23:41','n_diff_pfx01',0,1,'rank'),('school14_gjc823','performances_compound','rank','2022-12-12 16:23:41','n_diff_pfx02',0,1,'rank,id'),('school14_gjc823','performances_compound','rank','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performances_compound','rank','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','performances_compound','student_id','2022-12-12 16:23:41','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','performances_compound','student_id','2022-12-12 16:23:41','n_diff_pfx02',0,1,'student_id,id'),('school14_gjc823','performances_compound','student_id','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performances_compound','student_id','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','performances_compound','tavg','2022-12-12 16:23:41','n_diff_pfx01',0,1,'tavg'),('school14_gjc823','performances_compound','tavg','2022-12-12 16:23:41','n_diff_pfx02',0,1,'tavg,id'),('school14_gjc823','performances_compound','tavg','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performances_compound','tavg','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','performances_compound','term_id','2022-12-12 16:23:41','n_diff_pfx01',0,1,'term_id'),('school14_gjc823','performances_compound','term_id','2022-12-12 16:23:41','n_diff_pfx02',0,1,'term_id,id'),('school14_gjc823','performances_compound','term_id','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performances_compound','term_id','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','performances_special','PRIMARY','2022-12-12 16:23:41','n_diff_pfx01',0,1,'id'),('school14_gjc823','performances_special','PRIMARY','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performances_special','PRIMARY','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','performances_special','UniqueResult','2022-12-12 16:23:41','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','performances_special','UniqueResult','2022-12-12 16:23:41','n_diff_pfx02',0,1,'student_id,subject_id'),('school14_gjc823','performances_special','UniqueResult','2022-12-12 16:23:41','n_diff_pfx03',0,1,'student_id,subject_id,term_id'),('school14_gjc823','performances_special','UniqueResult','2022-12-12 16:23:41','n_diff_pfx04',0,1,'student_id,subject_id,term_id,class_id'),('school14_gjc823','performances_special','UniqueResult','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','performances_special','UniqueResult','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','physical_records','PRIMARY','2022-12-12 16:23:41','n_diff_pfx01',0,1,'id'),('school14_gjc823','physical_records','PRIMARY','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','physical_records','PRIMARY','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','physical_records','Unique student','2022-12-12 16:23:41','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','physical_records','Unique student','2022-12-12 16:23:41','n_diff_pfx02',0,1,'student_id,term_id'),('school14_gjc823','physical_records','Unique student','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','physical_records','Unique student','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','pins','PRIMARY','2022-12-12 16:23:43','n_diff_pfx01',20,1,'id'),('school14_gjc823','pins','PRIMARY','2022-12-12 16:23:43','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','pins','PRIMARY','2022-12-12 16:23:43','size',1,NULL,'Number of pages in the index'),('school14_gjc823','pins','Unique PIN','2022-12-12 16:23:43','n_diff_pfx01',20,1,'pin'),('school14_gjc823','pins','Unique PIN','2022-12-12 16:23:43','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','pins','Unique PIN','2022-12-12 16:23:43','size',1,NULL,'Number of pages in the index'),('school14_gjc823','pins','pin','2022-12-12 16:23:43','n_diff_pfx01',20,1,'pin'),('school14_gjc823','pins','pin','2022-12-12 16:23:43','n_diff_pfx02',20,1,'pin,id'),('school14_gjc823','pins','pin','2022-12-12 16:23:43','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','pins','pin','2022-12-12 16:23:43','size',1,NULL,'Number of pages in the index'),('school14_gjc823','pre_mock','PRIMARY','2022-12-15 17:30:33','n_diff_pfx01',0,1,'id'),('school14_gjc823','pre_mock','PRIMARY','2022-12-15 17:30:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','pre_mock','PRIMARY','2022-12-15 17:30:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','pre_mock','student_id','2022-12-15 17:30:33','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','pre_mock','student_id','2022-12-15 17:30:33','n_diff_pfx02',0,1,'student_id,term_id'),('school14_gjc823','pre_mock','student_id','2022-12-15 17:30:33','n_diff_pfx03',0,1,'student_id,term_id,subject_id'),('school14_gjc823','pre_mock','student_id','2022-12-15 17:30:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','pre_mock','student_id','2022-12-15 17:30:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','pre_mock_performance_averages','PRIMARY','2022-12-15 17:30:33','n_diff_pfx01',0,1,'id'),('school14_gjc823','pre_mock_performance_averages','PRIMARY','2022-12-15 17:30:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','pre_mock_performance_averages','PRIMARY','2022-12-15 17:30:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','pre_mock_performance_averages','student_id','2022-12-15 17:30:33','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','pre_mock_performance_averages','student_id','2022-12-15 17:30:33','n_diff_pfx02',0,1,'student_id,term_id'),('school14_gjc823','pre_mock_performance_averages','student_id','2022-12-15 17:30:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','pre_mock_performance_averages','student_id','2022-12-15 17:30:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','premock_elective_groups','PRIMARY','2022-12-15 17:30:33','n_diff_pfx01',0,1,'id'),('school14_gjc823','premock_elective_groups','PRIMARY','2022-12-15 17:30:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','premock_elective_groups','PRIMARY','2022-12-15 17:30:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','premock_elective_groups','code','2022-12-15 17:30:33','n_diff_pfx01',0,1,'code'),('school14_gjc823','premock_elective_groups','code','2022-12-15 17:30:33','n_diff_pfx02',0,1,'code,session_id'),('school14_gjc823','premock_elective_groups','code','2022-12-15 17:30:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','premock_elective_groups','code','2022-12-15 17:30:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','premock_elective_status','PRIMARY','2022-12-15 17:30:33','n_diff_pfx01',0,1,'id'),('school14_gjc823','premock_elective_status','PRIMARY','2022-12-15 17:30:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','premock_elective_status','PRIMARY','2022-12-15 17:30:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','premock_elective_status','unique student','2022-12-15 17:30:33','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','premock_elective_status','unique student','2022-12-15 17:30:33','n_diff_pfx02',0,1,'student_id,session_id'),('school14_gjc823','premock_elective_status','unique student','2022-12-15 17:30:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','premock_elective_status','unique student','2022-12-15 17:30:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','premock_electives_grades_locker','PRIMARY','2022-12-15 17:30:33','n_diff_pfx01',0,1,'id'),('school14_gjc823','premock_electives_grades_locker','PRIMARY','2022-12-15 17:30:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','premock_electives_grades_locker','PRIMARY','2022-12-15 17:30:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','premock_electives_grades_locker','group_id','2022-12-15 17:30:33','n_diff_pfx01',0,1,'group_id'),('school14_gjc823','premock_electives_grades_locker','group_id','2022-12-15 17:30:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','premock_electives_grades_locker','group_id','2022-12-15 17:30:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','premock_electives_grades_locker','subject_id','2022-12-15 17:30:33','n_diff_pfx01',0,1,'group_id'),('school14_gjc823','premock_electives_grades_locker','subject_id','2022-12-15 17:30:33','n_diff_pfx02',0,1,'group_id,term_id'),('school14_gjc823','premock_electives_grades_locker','subject_id','2022-12-15 17:30:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','premock_electives_grades_locker','subject_id','2022-12-15 17:30:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','premock_grades_locker','PRIMARY','2022-12-15 17:30:33','n_diff_pfx01',0,1,'id'),('school14_gjc823','premock_grades_locker','PRIMARY','2022-12-15 17:30:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','premock_grades_locker','PRIMARY','2022-12-15 17:30:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','premock_grades_locker','subject_id','2022-12-15 17:30:33','n_diff_pfx01',0,1,'subject_id'),('school14_gjc823','premock_grades_locker','subject_id','2022-12-15 17:30:33','n_diff_pfx02',0,1,'subject_id,term_id'),('school14_gjc823','premock_grades_locker','subject_id','2022-12-15 17:30:33','n_diff_pfx03',0,1,'subject_id,term_id,class_id'),('school14_gjc823','premock_grades_locker','subject_id','2022-12-15 17:30:33','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','premock_grades_locker','subject_id','2022-12-15 17:30:33','size',1,NULL,'Number of pages in the index'),('school14_gjc823','premock_students_electives','PRIMARY','2022-12-15 17:30:34','n_diff_pfx01',0,1,'id'),('school14_gjc823','premock_students_electives','PRIMARY','2022-12-15 17:30:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','premock_students_electives','PRIMARY','2022-12-15 17:30:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','premock_students_electives','Unique Electives','2022-12-15 17:30:34','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','premock_students_electives','Unique Electives','2022-12-15 17:30:34','n_diff_pfx02',0,1,'student_id,session_id'),('school14_gjc823','premock_students_electives','Unique Electives','2022-12-15 17:30:34','n_diff_pfx03',0,1,'student_id,session_id,subject_id'),('school14_gjc823','premock_students_electives','Unique Electives','2022-12-15 17:30:34','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','premock_students_electives','Unique Electives','2022-12-15 17:30:34','size',1,NULL,'Number of pages in the index'),('school14_gjc823','premock_teachers_subjects','PRIMARY','2022-12-15 17:32:55','n_diff_pfx01',0,1,'id'),('school14_gjc823','premock_teachers_subjects','PRIMARY','2022-12-15 17:32:55','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','premock_teachers_subjects','PRIMARY','2022-12-15 17:32:55','size',1,NULL,'Number of pages in the index'),('school14_gjc823','premock_teachers_subjects','unique_Session_class','2022-12-15 17:32:55','n_diff_pfx01',0,1,'teacher_id'),('school14_gjc823','premock_teachers_subjects','unique_Session_class','2022-12-15 17:32:55','n_diff_pfx02',0,1,'teacher_id,subject_id'),('school14_gjc823','premock_teachers_subjects','unique_Session_class','2022-12-15 17:32:55','n_diff_pfx03',0,1,'teacher_id,subject_id,class_id'),('school14_gjc823','premock_teachers_subjects','unique_Session_class','2022-12-15 17:32:55','n_diff_pfx04',0,1,'teacher_id,subject_id,class_id,session_id'),('school14_gjc823','premock_teachers_subjects','unique_Session_class','2022-12-15 17:32:55','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','premock_teachers_subjects','unique_Session_class','2022-12-15 17:32:55','size',1,NULL,'Number of pages in the index'),('school14_gjc823','previledges','Distint Url','2022-12-12 16:23:41','n_diff_pfx01',0,1,'url'),('school14_gjc823','previledges','Distint Url','2022-12-12 16:23:41','n_diff_pfx02',0,1,'url,status'),('school14_gjc823','previledges','Distint Url','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','previledges','Distint Url','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','previledges','PRIMARY','2022-12-12 16:23:41','n_diff_pfx01',0,1,'id'),('school14_gjc823','previledges','PRIMARY','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','previledges','PRIMARY','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','previledges','Url check','2022-12-12 16:23:41','n_diff_pfx01',0,1,'url'),('school14_gjc823','previledges','Url check','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','previledges','Url check','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','privileges','Distint Url','2022-12-12 16:23:43','n_diff_pfx01',73,1,'url'),('school14_gjc823','privileges','Distint Url','2022-12-12 16:23:43','n_diff_pfx02',73,1,'url,status'),('school14_gjc823','privileges','Distint Url','2022-12-12 16:23:43','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','privileges','Distint Url','2022-12-12 16:23:43','size',1,NULL,'Number of pages in the index'),('school14_gjc823','privileges','PRIMARY','2022-12-12 16:23:43','n_diff_pfx01',73,1,'id'),('school14_gjc823','privileges','PRIMARY','2022-12-12 16:23:43','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','privileges','PRIMARY','2022-12-12 16:23:43','size',1,NULL,'Number of pages in the index'),('school14_gjc823','privileges','Url check','2022-12-12 16:23:43','n_diff_pfx01',73,1,'url'),('school14_gjc823','privileges','Url check','2022-12-12 16:23:43','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','privileges','Url check','2022-12-12 16:23:43','size',1,NULL,'Number of pages in the index'),('school14_gjc823','promotions','PRIMARY','2022-12-12 16:23:41','n_diff_pfx01',0,1,'id'),('school14_gjc823','promotions','PRIMARY','2022-12-12 16:23:41','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','promotions','PRIMARY','2022-12-12 16:23:41','size',1,NULL,'Number of pages in the index'),('school14_gjc823','result_comments','PRIMARY','2022-12-12 16:23:43','n_diff_pfx01',261,17,'id'),('school14_gjc823','result_comments','PRIMARY','2022-12-12 16:23:43','n_leaf_pages',17,NULL,'Number of leaf pages in the index'),('school14_gjc823','result_comments','PRIMARY','2022-12-12 16:23:43','size',18,NULL,'Number of pages in the index'),('school14_gjc823','result_comments','student_id','2022-12-12 16:23:43','n_diff_pfx01',87,1,'student_id'),('school14_gjc823','result_comments','student_id','2022-12-12 16:23:43','n_diff_pfx02',261,1,'student_id,term_id'),('school14_gjc823','result_comments','student_id','2022-12-12 16:23:43','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','result_comments','student_id','2022-12-12 16:23:43','size',1,NULL,'Number of pages in the index'),('school14_gjc823','roles','PRIMARY','2022-12-12 16:23:43','n_diff_pfx01',4,1,'id'),('school14_gjc823','roles','PRIMARY','2022-12-12 16:23:43','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','roles','PRIMARY','2022-12-12 16:23:43','size',1,NULL,'Number of pages in the index'),('school14_gjc823','roles','roleCheck','2022-12-12 16:23:43','n_diff_pfx01',4,1,'role'),('school14_gjc823','roles','roleCheck','2022-12-12 16:23:43','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','roles','roleCheck','2022-12-12 16:23:43','size',1,NULL,'Number of pages in the index'),('school14_gjc823','room_types','PRIMARY','2022-12-12 16:23:44','n_diff_pfx01',3,1,'id'),('school14_gjc823','room_types','PRIMARY','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','room_types','PRIMARY','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','room_types','type','2022-12-12 16:23:44','n_diff_pfx01',3,1,'type'),('school14_gjc823','room_types','type','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','room_types','type','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','routes','PRIMARY','2022-12-12 16:23:42','n_diff_pfx01',0,1,'id'),('school14_gjc823','routes','PRIMARY','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','routes','PRIMARY','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','routes','Unique route','2022-12-12 16:23:42','n_diff_pfx01',0,1,'start'),('school14_gjc823','routes','Unique route','2022-12-12 16:23:42','n_diff_pfx02',0,1,'start,end'),('school14_gjc823','routes','Unique route','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','routes','Unique route','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','routes','Unique tag','2022-12-12 16:23:42','n_diff_pfx01',0,1,'tag'),('school14_gjc823','routes','Unique tag','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','routes','Unique tag','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','salary_structure','PRIMARY','2022-12-12 16:23:42','n_diff_pfx01',0,1,'id'),('school14_gjc823','salary_structure','PRIMARY','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','salary_structure','PRIMARY','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','salary_structure','Unique level pay','2022-12-12 16:23:42','n_diff_pfx01',0,1,'description'),('school14_gjc823','salary_structure','Unique level pay','2022-12-12 16:23:42','n_diff_pfx02',0,1,'description,type'),('school14_gjc823','salary_structure','Unique level pay','2022-12-12 16:23:42','n_diff_pfx03',0,1,'description,type,level'),('school14_gjc823','salary_structure','Unique level pay','2022-12-12 16:23:42','n_diff_pfx04',0,1,'description,type,level,month'),('school14_gjc823','salary_structure','Unique level pay','2022-12-12 16:23:42','n_diff_pfx05',0,1,'description,type,level,month,year'),('school14_gjc823','salary_structure','Unique level pay','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','salary_structure','Unique level pay','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','salary_structure','Unique title pay','2022-12-12 16:23:42','n_diff_pfx01',0,1,'type'),('school14_gjc823','salary_structure','Unique title pay','2022-12-12 16:23:42','n_diff_pfx02',0,1,'type,title_id'),('school14_gjc823','salary_structure','Unique title pay','2022-12-12 16:23:42','n_diff_pfx03',0,1,'type,title_id,month'),('school14_gjc823','salary_structure','Unique title pay','2022-12-12 16:23:42','n_diff_pfx04',0,1,'type,title_id,month,year'),('school14_gjc823','salary_structure','Unique title pay','2022-12-12 16:23:42','n_diff_pfx05',0,1,'type,title_id,month,year,description'),('school14_gjc823','salary_structure','Unique title pay','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','salary_structure','Unique title pay','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','sales','PRIMARY','2022-12-12 16:23:42','n_diff_pfx01',0,1,'id'),('school14_gjc823','sales','PRIMARY','2022-12-12 16:23:42','n_diff_pfx02',0,1,'id,transaction_id'),('school14_gjc823','sales','PRIMARY','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','sales','PRIMARY','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','scheme_of_work','PRIMARY','2022-12-12 16:23:42','n_diff_pfx01',0,1,'id'),('school14_gjc823','scheme_of_work','PRIMARY','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','scheme_of_work','PRIMARY','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','scheme_of_work','subject_id','2022-12-12 16:23:42','n_diff_pfx01',0,1,'subject_id'),('school14_gjc823','scheme_of_work','subject_id','2022-12-12 16:23:42','n_diff_pfx02',0,1,'subject_id,week'),('school14_gjc823','scheme_of_work','subject_id','2022-12-12 16:23:42','n_diff_pfx03',0,1,'subject_id,week,topic'),('school14_gjc823','scheme_of_work','subject_id','2022-12-12 16:23:42','n_diff_pfx04',0,1,'subject_id,week,topic,term'),('school14_gjc823','scheme_of_work','subject_id','2022-12-12 16:23:42','n_diff_pfx05',0,1,'subject_id,week,topic,term,level'),('school14_gjc823','scheme_of_work','subject_id','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','scheme_of_work','subject_id','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','school_details','PRIMARY','2022-12-12 16:23:42','n_diff_pfx01',0,1,'id'),('school14_gjc823','school_details','PRIMARY','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','school_details','PRIMARY','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','school_details','Unique ID','2022-12-12 16:23:42','n_diff_pfx01',0,1,'id'),('school14_gjc823','school_details','Unique ID','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','school_details','Unique ID','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','school_diary','PRIMARY','2022-12-12 16:23:42','n_diff_pfx01',0,1,'id'),('school14_gjc823','school_diary','PRIMARY','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','school_diary','PRIMARY','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','school_diary','subject_id','2022-12-12 16:23:42','n_diff_pfx01',0,1,'subject_id'),('school14_gjc823','school_diary','subject_id','2022-12-12 16:23:42','n_diff_pfx02',0,1,'subject_id,week'),('school14_gjc823','school_diary','subject_id','2022-12-12 16:23:42','n_diff_pfx03',0,1,'subject_id,week,topic'),('school14_gjc823','school_diary','subject_id','2022-12-12 16:23:42','n_diff_pfx04',0,1,'subject_id,week,topic,term_id'),('school14_gjc823','school_diary','subject_id','2022-12-12 16:23:42','n_diff_pfx05',0,1,'subject_id,week,topic,term_id,level'),('school14_gjc823','school_diary','subject_id','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','school_diary','subject_id','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','school_fees_status','PRIMARY','2022-12-12 16:23:42','n_diff_pfx01',0,1,'id'),('school14_gjc823','school_fees_status','PRIMARY','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','school_fees_status','PRIMARY','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','school_rooms','PRIMARY','2022-12-12 16:23:44','n_diff_pfx01',26,1,'id'),('school14_gjc823','school_rooms','PRIMARY','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','school_rooms','PRIMARY','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','school_sessions','PRIMARY','2022-12-12 16:23:44','n_diff_pfx01',10,1,'id'),('school14_gjc823','school_sessions','PRIMARY','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','school_sessions','PRIMARY','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','school_sessions','endDate','2022-12-12 16:23:44','n_diff_pfx01',10,1,'endDate'),('school14_gjc823','school_sessions','endDate','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','school_sessions','endDate','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','school_sessions','startDate','2022-12-12 16:23:44','n_diff_pfx01',10,1,'startDate'),('school14_gjc823','school_sessions','startDate','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','school_sessions','startDate','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','school_sessions','year_2','2022-12-12 16:23:44','n_diff_pfx01',10,1,'startDate'),('school14_gjc823','school_sessions','year_2','2022-12-12 16:23:44','n_diff_pfx02',10,1,'startDate,endDate'),('school14_gjc823','school_sessions','year_2','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','school_sessions','year_2','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','school_structure','PRIMARY','2022-12-12 16:23:42','n_diff_pfx01',0,1,'id'),('school14_gjc823','school_structure','PRIMARY','2022-12-12 16:23:42','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','school_structure','PRIMARY','2022-12-12 16:23:42','size',1,NULL,'Number of pages in the index'),('school14_gjc823','school_terms','PRIMARY','2022-12-12 16:23:44','n_diff_pfx01',24,1,'id'),('school14_gjc823','school_terms','PRIMARY','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','school_terms','PRIMARY','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','school_terms','endDate','2022-12-12 16:23:44','n_diff_pfx01',24,1,'endDate'),('school14_gjc823','school_terms','endDate','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','school_terms','endDate','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','school_terms','session_id','2022-12-12 16:23:44','n_diff_pfx01',9,1,'session_id'),('school14_gjc823','school_terms','session_id','2022-12-12 16:23:44','n_diff_pfx02',24,1,'session_id,startDate'),('school14_gjc823','school_terms','session_id','2022-12-12 16:23:44','n_diff_pfx03',24,1,'session_id,startDate,endDate'),('school14_gjc823','school_terms','session_id','2022-12-12 16:23:44','n_diff_pfx04',24,1,'session_id,startDate,endDate,term'),('school14_gjc823','school_terms','session_id','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','school_terms','session_id','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','school_terms','startDate','2022-12-12 16:23:44','n_diff_pfx01',24,1,'startDate'),('school14_gjc823','school_terms','startDate','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','school_terms','startDate','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','school_terms','unique session term','2022-12-12 16:23:44','n_diff_pfx01',9,1,'session_id'),('school14_gjc823','school_terms','unique session term','2022-12-12 16:23:44','n_diff_pfx02',24,1,'session_id,term'),('school14_gjc823','school_terms','unique session term','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','school_terms','unique session term','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','schoolfees_structure','PRIMARY','2022-12-12 16:23:43','n_diff_pfx01',0,1,'id'),('school14_gjc823','schoolfees_structure','PRIMARY','2022-12-12 16:23:43','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','schoolfees_structure','PRIMARY','2022-12-12 16:23:43','size',1,NULL,'Number of pages in the index'),('school14_gjc823','schoolfees_structure','type','2022-12-12 16:23:43','n_diff_pfx01',0,1,'type'),('school14_gjc823','schoolfees_structure','type','2022-12-12 16:23:43','n_diff_pfx02',0,1,'type,class_id'),('school14_gjc823','schoolfees_structure','type','2022-12-12 16:23:43','n_diff_pfx03',0,1,'type,class_id,purpose'),('school14_gjc823','schoolfees_structure','type','2022-12-12 16:23:43','n_diff_pfx04',0,1,'type,class_id,purpose,term_id'),('school14_gjc823','schoolfees_structure','type','2022-12-12 16:23:43','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','schoolfees_structure','type','2022-12-12 16:23:43','size',1,NULL,'Number of pages in the index'),('school14_gjc823','sections','PRIMARY','2022-12-12 16:23:43','n_diff_pfx01',0,1,'id'),('school14_gjc823','sections','PRIMARY','2022-12-12 16:23:43','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','sections','PRIMARY','2022-12-12 16:23:43','size',1,NULL,'Number of pages in the index'),('school14_gjc823','security','PRIMARY','2022-12-12 16:23:43','n_diff_pfx01',0,1,'id'),('school14_gjc823','security','PRIMARY','2022-12-12 16:23:43','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','security','PRIMARY','2022-12-12 16:23:43','size',1,NULL,'Number of pages in the index'),('school14_gjc823','session_cron_refresh','PRIMARY','2022-12-12 16:23:45','n_diff_pfx01',4,1,'id'),('school14_gjc823','session_cron_refresh','PRIMARY','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','session_cron_refresh','PRIMARY','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','session_cron_refresh','unique_status','2022-12-12 16:23:45','n_diff_pfx01',4,1,'class_id'),('school14_gjc823','session_cron_refresh','unique_status','2022-12-12 16:23:45','n_diff_pfx02',4,1,'class_id,session_id'),('school14_gjc823','session_cron_refresh','unique_status','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','session_cron_refresh','unique_status','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','session_performance_averages','PRIMARY','2022-12-12 16:23:45','n_diff_pfx01',87,1,'id'),('school14_gjc823','session_performance_averages','PRIMARY','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','session_performance_averages','PRIMARY','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','session_performance_averages','student_id','2022-12-12 16:23:45','n_diff_pfx01',87,1,'student_id'),('school14_gjc823','session_performance_averages','student_id','2022-12-12 16:23:45','n_diff_pfx02',87,1,'student_id,session_id'),('school14_gjc823','session_performance_averages','student_id','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','session_performance_averages','student_id','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','session_subjects_averages','PRIMARY','2022-12-12 16:23:45','n_diff_pfx01',1653,10,'id'),('school14_gjc823','session_subjects_averages','PRIMARY','2022-12-12 16:23:45','n_leaf_pages',10,NULL,'Number of leaf pages in the index'),('school14_gjc823','session_subjects_averages','PRIMARY','2022-12-12 16:23:45','size',11,NULL,'Number of pages in the index'),('school14_gjc823','session_subjects_averages','student_id','2022-12-12 16:23:45','n_diff_pfx01',87,4,'student_id'),('school14_gjc823','session_subjects_averages','student_id','2022-12-12 16:23:45','n_diff_pfx02',87,4,'student_id,session_id'),('school14_gjc823','session_subjects_averages','student_id','2022-12-12 16:23:45','n_diff_pfx03',1653,4,'student_id,session_id,subject_id'),('school14_gjc823','session_subjects_averages','student_id','2022-12-12 16:23:45','n_leaf_pages',4,NULL,'Number of leaf pages in the index'),('school14_gjc823','session_subjects_averages','student_id','2022-12-12 16:23:45','size',5,NULL,'Number of pages in the index'),('school14_gjc823','short_codes','PRIMARY','2022-12-12 16:23:43','n_diff_pfx01',0,1,'id'),('school14_gjc823','short_codes','PRIMARY','2022-12-12 16:23:43','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','short_codes','PRIMARY','2022-12-12 16:23:43','size',1,NULL,'Number of pages in the index'),('school14_gjc823','skills','PRIMARY','2022-12-15 17:48:01','n_diff_pfx01',10,1,'id'),('school14_gjc823','skills','PRIMARY','2022-12-15 17:48:01','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','skills','PRIMARY','2022-12-15 17:48:01','size',1,NULL,'Number of pages in the index'),('school14_gjc823','skills','Unique skill and type','2022-12-15 17:48:01','n_diff_pfx01',10,1,'skill'),('school14_gjc823','skills','Unique skill and type','2022-12-15 17:48:01','n_diff_pfx02',10,1,'skill,type'),('school14_gjc823','skills','Unique skill and type','2022-12-15 17:48:01','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','skills','Unique skill and type','2022-12-15 17:48:01','size',1,NULL,'Number of pages in the index'),('school14_gjc823','skills_performance','PRIMARY','2022-12-12 16:23:45','n_diff_pfx01',10,1,'id'),('school14_gjc823','skills_performance','PRIMARY','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','skills_performance','PRIMARY','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','skills_performance','Unique student Term','2022-12-12 16:23:45','n_diff_pfx01',1,1,'student_id'),('school14_gjc823','skills_performance','Unique student Term','2022-12-12 16:23:45','n_diff_pfx02',1,1,'student_id,term_id'),('school14_gjc823','skills_performance','Unique student Term','2022-12-12 16:23:45','n_diff_pfx03',10,1,'student_id,term_id,skill_id'),('school14_gjc823','skills_performance','Unique student Term','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','skills_performance','Unique student Term','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','sms','PRIMARY','2022-12-12 16:23:43','n_diff_pfx01',0,1,'id'),('school14_gjc823','sms','PRIMARY','2022-12-12 16:23:43','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','sms','PRIMARY','2022-12-12 16:23:43','size',1,NULL,'Number of pages in the index'),('school14_gjc823','sms_templates','PRIMARY','2022-12-12 16:23:43','n_diff_pfx01',0,1,'id'),('school14_gjc823','sms_templates','PRIMARY','2022-12-12 16:23:43','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','sms_templates','PRIMARY','2022-12-12 16:23:43','size',1,NULL,'Number of pages in the index'),('school14_gjc823','special_performances','PRIMARY','2022-12-12 16:23:44','n_diff_pfx01',0,1,'id'),('school14_gjc823','special_performances','PRIMARY','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','special_performances','PRIMARY','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','special_performances','Unique class','2022-12-12 16:23:44','n_diff_pfx01',0,1,'class_id'),('school14_gjc823','special_performances','Unique class','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','special_performances','Unique class','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','staff_apprasial','PRIMARY','2022-12-12 16:23:44','n_diff_pfx01',0,1,'id'),('school14_gjc823','staff_apprasial','PRIMARY','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','staff_apprasial','PRIMARY','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','stock','PRIMARY','2022-12-12 16:23:44','n_diff_pfx01',0,1,'id'),('school14_gjc823','stock','PRIMARY','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','stock','PRIMARY','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','student_credit_history','PRIMARY','2022-12-12 16:23:44','n_diff_pfx01',0,1,'id'),('school14_gjc823','student_credit_history','PRIMARY','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','student_credit_history','PRIMARY','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','student_credit_history','ref_code','2022-12-12 16:23:44','n_diff_pfx01',0,1,'ref_code'),('school14_gjc823','student_credit_history','ref_code','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','student_credit_history','ref_code','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','student_credit_history','ref_code_2','2022-12-12 16:23:44','n_diff_pfx01',0,1,'ref_code'),('school14_gjc823','student_credit_history','ref_code_2','2022-12-12 16:23:44','n_diff_pfx02',0,1,'ref_code,student_id'),('school14_gjc823','student_credit_history','ref_code_2','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','student_credit_history','ref_code_2','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','student_credits','PRIMARY','2022-12-12 16:23:45','n_diff_pfx01',179,1,'id'),('school14_gjc823','student_credits','PRIMARY','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','student_credits','PRIMARY','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','student_credits','student_id','2022-12-12 16:23:45','n_diff_pfx01',179,1,'student_id'),('school14_gjc823','student_credits','student_id','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','student_credits','student_id','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','student_debits','PRIMARY','2022-12-12 16:23:44','n_diff_pfx01',0,1,'id'),('school14_gjc823','student_debits','PRIMARY','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','student_debits','PRIMARY','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','student_debits','transaction_id','2022-12-12 16:23:44','n_diff_pfx01',0,1,'transaction_id'),('school14_gjc823','student_debits','transaction_id','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','student_debits','transaction_id','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','student_login','PRIMARY','2022-12-12 16:23:45','n_diff_pfx01',183,1,'id'),('school14_gjc823','student_login','PRIMARY','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','student_login','PRIMARY','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','student_login','student_id','2022-12-12 16:23:45','n_diff_pfx01',183,1,'student_id'),('school14_gjc823','student_login','student_id','2022-12-12 16:23:45','n_diff_pfx02',183,1,'student_id,username'),('school14_gjc823','student_login','student_id','2022-12-12 16:23:45','n_diff_pfx03',183,1,'student_id,username,password'),('school14_gjc823','student_login','student_id','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','student_login','student_id','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','student_login','username','2022-12-12 16:23:45','n_diff_pfx01',183,1,'username'),('school14_gjc823','student_login','username','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','student_login','username','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','student_rooms','PRIMARY','2022-12-17 18:23:43','n_diff_pfx01',266,1,'id'),('school14_gjc823','student_rooms','PRIMARY','2022-12-17 18:23:43','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','student_rooms','PRIMARY','2022-12-17 18:23:43','size',1,NULL,'Number of pages in the index'),('school14_gjc823','student_rooms','student_id','2022-12-17 18:23:43','n_diff_pfx01',183,1,'student_id'),('school14_gjc823','student_rooms','student_id','2022-12-17 18:23:43','n_diff_pfx02',266,1,'student_id,session_id'),('school14_gjc823','student_rooms','student_id','2022-12-17 18:23:43','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','student_rooms','student_id','2022-12-17 18:23:43','size',1,NULL,'Number of pages in the index'),('school14_gjc823','student_transport','PRIMARY','2022-12-12 16:23:44','n_diff_pfx01',0,1,'id'),('school14_gjc823','student_transport','PRIMARY','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','student_transport','PRIMARY','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','student_transport','Unique staff bus','2022-12-12 16:23:44','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','student_transport','Unique staff bus','2022-12-12 16:23:44','n_diff_pfx02',0,1,'student_id,vehicle_route_id'),('school14_gjc823','student_transport','Unique staff bus','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','student_transport','Unique staff bus','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','students','PRIMARY','2022-12-12 16:23:55','n_diff_pfx01',183,3,'id'),('school14_gjc823','students','PRIMARY','2022-12-12 16:23:55','n_leaf_pages',3,NULL,'Number of leaf pages in the index'),('school14_gjc823','students','PRIMARY','2022-12-12 16:23:55','size',4,NULL,'Number of pages in the index'),('school14_gjc823','students_electives','PRIMARY','2022-12-12 16:23:44','n_diff_pfx01',0,1,'id'),('school14_gjc823','students_electives','PRIMARY','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','students_electives','PRIMARY','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','students_electives','Unique Electives','2022-12-12 16:23:44','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','students_electives','Unique Electives','2022-12-12 16:23:44','n_diff_pfx02',0,1,'student_id,session_id'),('school14_gjc823','students_electives','Unique Electives','2022-12-12 16:23:44','n_diff_pfx03',0,1,'student_id,session_id,subject_id'),('school14_gjc823','students_electives','Unique Electives','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','students_electives','Unique Electives','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','subject_attendance','PRIMARY','2022-12-12 16:23:44','n_diff_pfx01',0,1,'id'),('school14_gjc823','subject_attendance','PRIMARY','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','subject_attendance','PRIMARY','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','subject_attendance','Student date','2022-12-12 16:23:44','n_diff_pfx01',0,1,'date'),('school14_gjc823','subject_attendance','Student date','2022-12-12 16:23:44','n_diff_pfx02',0,1,'date,students_id'),('school14_gjc823','subject_attendance','Student date','2022-12-12 16:23:44','n_diff_pfx03',0,1,'date,students_id,subject_id'),('school14_gjc823','subject_attendance','Student date','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','subject_attendance','Student date','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','subject_attendance','status','2022-12-12 16:23:44','n_diff_pfx01',0,1,'status'),('school14_gjc823','subject_attendance','status','2022-12-12 16:23:44','n_diff_pfx02',0,1,'status,term_id'),('school14_gjc823','subject_attendance','status','2022-12-12 16:23:44','n_diff_pfx03',0,1,'status,term_id,date'),('school14_gjc823','subject_attendance','status','2022-12-12 16:23:44','n_diff_pfx04',0,1,'status,term_id,date,class_id'),('school14_gjc823','subject_attendance','status','2022-12-12 16:23:44','n_diff_pfx05',0,1,'status,term_id,date,class_id,students_id'),('school14_gjc823','subject_attendance','status','2022-12-12 16:23:44','n_diff_pfx06',0,1,'status,term_id,date,class_id,students_id,subject_id'),('school14_gjc823','subject_attendance','status','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','subject_attendance','status','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','subject_groups','PRIMARY','2022-12-12 16:23:44','n_diff_pfx01',0,1,'id'),('school14_gjc823','subject_groups','PRIMARY','2022-12-12 16:23:44','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','subject_groups','PRIMARY','2022-12-12 16:23:44','size',1,NULL,'Number of pages in the index'),('school14_gjc823','subjects','PRIMARY','2022-12-12 16:24:05','n_diff_pfx01',61,1,'id'),('school14_gjc823','subjects','PRIMARY','2022-12-12 16:24:05','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','subjects','PRIMARY','2022-12-12 16:24:05','size',1,NULL,'Number of pages in the index'),('school14_gjc823','subjects','id','2022-12-12 16:24:05','n_diff_pfx01',61,1,'title'),('school14_gjc823','subjects','id','2022-12-12 16:24:05','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','subjects','id','2022-12-12 16:24:05','size',1,NULL,'Number of pages in the index'),('school14_gjc823','subjects','title','2022-12-12 16:24:05','n_diff_pfx01',61,1,'title'),('school14_gjc823','subjects','title','2022-12-12 16:24:05','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','subjects','title','2022-12-12 16:24:05','size',1,NULL,'Number of pages in the index'),('school14_gjc823','subjects_high_low','PRIMARY','2022-12-12 16:24:15','n_diff_pfx01',98,1,'id'),('school14_gjc823','subjects_high_low','PRIMARY','2022-12-12 16:24:15','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','subjects_high_low','PRIMARY','2022-12-12 16:24:15','size',1,NULL,'Number of pages in the index'),('school14_gjc823','subjects_high_low','Unique high low','2022-12-12 16:24:15','n_diff_pfx01',25,1,'subject_id'),('school14_gjc823','subjects_high_low','Unique high low','2022-12-12 16:24:15','n_diff_pfx02',80,1,'subject_id,term_id'),('school14_gjc823','subjects_high_low','Unique high low','2022-12-12 16:24:15','n_diff_pfx03',98,1,'subject_id,term_id,class_level_id'),('school14_gjc823','subjects_high_low','Unique high low','2022-12-12 16:24:15','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','subjects_high_low','Unique high low','2022-12-12 16:24:15','size',1,NULL,'Number of pages in the index'),('school14_gjc823','superadmin','PRIMARY','2022-12-12 16:24:25','n_diff_pfx01',7,1,'id'),('school14_gjc823','superadmin','PRIMARY','2022-12-12 16:24:25','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','superadmin','PRIMARY','2022-12-12 16:24:25','size',1,NULL,'Number of pages in the index'),('school14_gjc823','superadmin','Unique Username','2022-12-12 16:24:25','n_diff_pfx01',7,1,'username'),('school14_gjc823','superadmin','Unique Username','2022-12-12 16:24:25','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','superadmin','Unique Username','2022-12-12 16:24:25','size',1,NULL,'Number of pages in the index'),('school14_gjc823','superadmin','token','2022-12-12 16:24:25','n_diff_pfx01',3,1,'token'),('school14_gjc823','superadmin','token','2022-12-12 16:24:25','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','superadmin','token','2022-12-12 16:24:25','size',1,NULL,'Number of pages in the index'),('school14_gjc823','teachers_comments','PRIMARY','2022-12-12 16:23:45','n_diff_pfx01',0,1,'id'),('school14_gjc823','teachers_comments','PRIMARY','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','teachers_comments','PRIMARY','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','teachers_comments','UniqueComment','2022-12-12 16:23:45','n_diff_pfx01',0,1,'student_id'),('school14_gjc823','teachers_comments','UniqueComment','2022-12-12 16:23:45','n_diff_pfx02',0,1,'student_id,term_id'),('school14_gjc823','teachers_comments','UniqueComment','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','teachers_comments','UniqueComment','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','teachers_subjects','PRIMARY','2022-12-12 16:24:35','n_diff_pfx01',266,1,'id'),('school14_gjc823','teachers_subjects','PRIMARY','2022-12-12 16:24:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','teachers_subjects','PRIMARY','2022-12-12 16:24:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','teachers_subjects','teacher_id','2022-12-12 16:24:35','n_diff_pfx01',31,1,'teacher_id'),('school14_gjc823','teachers_subjects','teacher_id','2022-12-12 16:24:35','n_diff_pfx02',37,1,'teacher_id,subject_id'),('school14_gjc823','teachers_subjects','teacher_id','2022-12-12 16:24:35','n_diff_pfx03',185,1,'teacher_id,subject_id,class_id'),('school14_gjc823','teachers_subjects','teacher_id','2022-12-12 16:24:35','n_diff_pfx04',249,1,'teacher_id,subject_id,class_id,session_id'),('school14_gjc823','teachers_subjects','teacher_id','2022-12-12 16:24:35','n_diff_pfx05',266,1,'teacher_id,subject_id,class_id,session_id,id'),('school14_gjc823','teachers_subjects','teacher_id','2022-12-12 16:24:35','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','teachers_subjects','teacher_id','2022-12-12 16:24:35','size',1,NULL,'Number of pages in the index'),('school14_gjc823','term_performance_averages','PRIMARY','2022-12-12 16:24:45','n_diff_pfx01',440,3,'id'),('school14_gjc823','term_performance_averages','PRIMARY','2022-12-12 16:24:45','n_leaf_pages',3,NULL,'Number of leaf pages in the index'),('school14_gjc823','term_performance_averages','PRIMARY','2022-12-12 16:24:45','size',4,NULL,'Number of pages in the index'),('school14_gjc823','term_performance_averages','student_id','2022-12-12 16:24:45','n_diff_pfx01',183,1,'student_id'),('school14_gjc823','term_performance_averages','student_id','2022-12-12 16:24:45','n_diff_pfx02',440,1,'student_id,term_id'),('school14_gjc823','term_performance_averages','student_id','2022-12-12 16:24:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','term_performance_averages','student_id','2022-12-12 16:24:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','timetable','PRIMARY','2022-12-12 16:23:45','n_diff_pfx01',0,1,'id'),('school14_gjc823','timetable','PRIMARY','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','timetable','PRIMARY','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','timetable','busy teacher','2022-12-12 16:23:45','n_diff_pfx01',0,1,'day'),('school14_gjc823','timetable','busy teacher','2022-12-12 16:23:45','n_diff_pfx02',0,1,'day,period'),('school14_gjc823','timetable','busy teacher','2022-12-12 16:23:45','n_diff_pfx03',0,1,'day,period,teacher_id'),('school14_gjc823','timetable','busy teacher','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','timetable','busy teacher','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','timetable','specific_class_periods','2022-12-12 16:23:45','n_diff_pfx01',0,1,'day'),('school14_gjc823','timetable','specific_class_periods','2022-12-12 16:23:45','n_diff_pfx02',0,1,'day,period'),('school14_gjc823','timetable','specific_class_periods','2022-12-12 16:23:45','n_diff_pfx03',0,1,'day,period,subject_teacher_id'),('school14_gjc823','timetable','specific_class_periods','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','timetable','specific_class_periods','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','timetable_durations','PRIMARY','2022-12-12 16:24:55','n_diff_pfx01',60,1,'id'),('school14_gjc823','timetable_durations','PRIMARY','2022-12-12 16:24:55','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','timetable_durations','PRIMARY','2022-12-12 16:24:55','size',1,NULL,'Number of pages in the index'),('school14_gjc823','timetable_durations','period','2022-12-12 16:24:55','n_diff_pfx01',10,1,'period'),('school14_gjc823','timetable_durations','period','2022-12-12 16:24:55','n_diff_pfx02',60,1,'period,day'),('school14_gjc823','timetable_durations','period','2022-12-12 16:24:55','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','timetable_durations','period','2022-12-12 16:24:55','size',1,NULL,'Number of pages in the index'),('school14_gjc823','titles','PRIMARY','2022-12-12 16:25:05','n_diff_pfx01',29,1,'id'),('school14_gjc823','titles','PRIMARY','2022-12-12 16:25:05','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','titles','PRIMARY','2022-12-12 16:25:05','size',1,NULL,'Number of pages in the index'),('school14_gjc823','titles','id','2022-12-12 16:25:05','n_diff_pfx01',29,1,'id'),('school14_gjc823','titles','id','2022-12-12 16:25:05','n_diff_pfx02',29,1,'id,title'),('school14_gjc823','titles','id','2022-12-12 16:25:05','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','titles','id','2022-12-12 16:25:05','size',1,NULL,'Number of pages in the index'),('school14_gjc823','transaction_log','PRIMARY','2022-12-12 16:23:45','n_diff_pfx01',0,1,'id'),('school14_gjc823','transaction_log','PRIMARY','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','transaction_log','PRIMARY','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','transaction_log','Unique ref','2022-12-12 16:23:45','n_diff_pfx01',0,1,'ref'),('school14_gjc823','transaction_log','Unique ref','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','transaction_log','Unique ref','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','transaction_log','ref','2022-12-12 16:23:45','n_diff_pfx01',0,1,'ref'),('school14_gjc823','transaction_log','ref','2022-12-12 16:23:45','n_diff_pfx02',0,1,'ref,id'),('school14_gjc823','transaction_log','ref','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','transaction_log','ref','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','transactions','PRIMARY','2022-12-12 16:23:45','n_diff_pfx01',0,1,'id'),('school14_gjc823','transactions','PRIMARY','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','transactions','PRIMARY','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','transactions','order_id','2022-12-12 16:23:45','n_diff_pfx01',0,1,'order_id'),('school14_gjc823','transactions','order_id','2022-12-12 16:23:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','transactions','order_id','2022-12-12 16:23:45','size',1,NULL,'Number of pages in the index'),('school14_gjc823','vehicle_routes','PRIMARY','2022-12-12 16:23:46','n_diff_pfx01',0,1,'id'),('school14_gjc823','vehicle_routes','PRIMARY','2022-12-12 16:23:46','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','vehicle_routes','PRIMARY','2022-12-12 16:23:46','size',1,NULL,'Number of pages in the index'),('school14_gjc823','vehicle_routes','Unique Bus Attendant','2022-12-12 16:23:46','n_diff_pfx01',0,1,'vehicle_id'),('school14_gjc823','vehicle_routes','Unique Bus Attendant','2022-12-12 16:23:46','n_diff_pfx02',0,1,'vehicle_id,attendant_id'),('school14_gjc823','vehicle_routes','Unique Bus Attendant','2022-12-12 16:23:46','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','vehicle_routes','Unique Bus Attendant','2022-12-12 16:23:46','size',1,NULL,'Number of pages in the index'),('school14_gjc823','vehicle_routes','Unique Bus Route','2022-12-12 16:23:46','n_diff_pfx01',0,1,'vehicle_id'),('school14_gjc823','vehicle_routes','Unique Bus Route','2022-12-12 16:23:46','n_diff_pfx02',0,1,'vehicle_id,route_id'),('school14_gjc823','vehicle_routes','Unique Bus Route','2022-12-12 16:23:46','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','vehicle_routes','Unique Bus Route','2022-12-12 16:23:46','size',1,NULL,'Number of pages in the index'),('school14_gjc823','vehicles','PRIMARY','2022-12-12 16:23:46','n_diff_pfx01',0,1,'id'),('school14_gjc823','vehicles','PRIMARY','2022-12-12 16:23:46','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','vehicles','PRIMARY','2022-12-12 16:23:46','size',1,NULL,'Number of pages in the index'),('school14_gjc823','vehicles','Unique Alias','2022-12-12 16:23:46','n_diff_pfx01',0,1,'alias'),('school14_gjc823','vehicles','Unique Alias','2022-12-12 16:23:46','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','vehicles','Unique Alias','2022-12-12 16:23:46','size',1,NULL,'Number of pages in the index'),('school14_gjc823','vehicles','Unique Reg','2022-12-12 16:23:46','n_diff_pfx01',0,1,'reg_number'),('school14_gjc823','vehicles','Unique Reg','2022-12-12 16:23:46','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','vehicles','Unique Reg','2022-12-12 16:23:46','size',1,NULL,'Number of pages in the index'),('school14_gjc823','vehicles','Unique Vehicle','2022-12-12 16:23:46','n_diff_pfx01',0,1,'alias'),('school14_gjc823','vehicles','Unique Vehicle','2022-12-12 16:23:46','n_diff_pfx02',0,1,'alias,brand'),('school14_gjc823','vehicles','Unique Vehicle','2022-12-12 16:23:46','n_diff_pfx03',0,1,'alias,brand,model'),('school14_gjc823','vehicles','Unique Vehicle','2022-12-12 16:23:46','n_diff_pfx04',0,1,'alias,brand,model,reg_number'),('school14_gjc823','vehicles','Unique Vehicle','2022-12-12 16:23:46','n_diff_pfx05',0,1,'alias,brand,model,reg_number,id'),('school14_gjc823','vehicles','Unique Vehicle','2022-12-12 16:23:46','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','vehicles','Unique Vehicle','2022-12-12 16:23:46','size',1,NULL,'Number of pages in the index'),('school14_gjc823','vouchers','PRIMARY','2022-12-12 16:23:46','n_diff_pfx01',0,1,'Id'),('school14_gjc823','vouchers','PRIMARY','2022-12-12 16:23:46','n_diff_pfx02',0,1,'Id,transaction_id'),('school14_gjc823','vouchers','PRIMARY','2022-12-12 16:23:46','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','vouchers','PRIMARY','2022-12-12 16:23:46','size',1,NULL,'Number of pages in the index'),('school14_gjc823','vouchers','transaction','2022-12-12 16:23:46','n_diff_pfx01',0,1,'transaction_id'),('school14_gjc823','vouchers','transaction','2022-12-12 16:23:46','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('school14_gjc823','vouchers','transaction','2022-12-12 16:23:46','size',1,NULL,'Number of pages in the index'),('sys','sys_config','PRIMARY','2022-12-11 11:13:53','n_diff_pfx01',6,1,'variable'),('sys','sys_config','PRIMARY','2022-12-11 11:13:53','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('sys','sys_config','PRIMARY','2022-12-11 11:13:53','size',1,NULL,'Number of pages in the index');

--
-- Table structure for table `innodb_table_stats`
--

CREATE TABLE `innodb_table_stats` (
  `database_name` varchar(64) COLLATE utf8_bin NOT NULL,
  `table_name` varchar(199) COLLATE utf8_bin NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `n_rows` bigint(20) unsigned NOT NULL,
  `clustered_index_size` bigint(20) unsigned NOT NULL,
  `sum_of_other_index_sizes` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`database_name`,`table_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;

--
-- Dumping data for table `innodb_table_stats`
--

INSERT INTO `innodb_table_stats` VALUES ('mysql','gtid_executed','2022-12-11 11:13:52',0,1,0),('school14_gjc823','academic_positions','2022-12-12 16:23:29',0,1,1),('school14_gjc823','admins','2022-12-12 16:23:29',0,1,1),('school14_gjc823','admission_settings','2022-12-12 16:23:29',0,1,0),('school14_gjc823','api_requests','2022-12-12 16:23:29',0,1,0),('school14_gjc823','assigned_subjects','2022-12-12 16:23:29',0,1,0),('school14_gjc823','assignment_replies','2022-12-12 16:23:29',0,1,1),('school14_gjc823','assignments','2022-12-12 16:23:29',0,1,3),('school14_gjc823','attendance','2022-12-12 16:23:29',0,1,2),('school14_gjc823','auto_sms','2022-12-12 16:23:30',0,1,0),('school14_gjc823','average_ranks','2022-12-12 16:23:30',0,1,0),('school14_gjc823','bank_accounts','2022-12-12 16:23:30',0,1,1),('school14_gjc823','banks','2022-12-12 16:23:41',20,1,0),('school14_gjc823','book_authors','2022-12-12 16:23:30',0,1,1),('school14_gjc823','book_categories','2022-12-12 16:23:32',2,1,1),('school14_gjc823','book_issues','2022-12-12 16:23:30',0,1,1),('school14_gjc823','book_losses','2022-12-12 16:23:30',0,1,2),('school14_gjc823','book_publishers','2022-12-12 16:23:30',0,1,1),('school14_gjc823','book_renewals','2022-12-12 16:23:31',0,1,1),('school14_gjc823','book_returns','2022-12-12 16:23:31',0,1,1),('school14_gjc823','book_shop','2022-12-12 16:23:31',0,1,1),('school14_gjc823','books','2022-12-12 16:23:31',0,1,4),('school14_gjc823','cafeteria_transactions','2022-12-12 16:23:31',0,1,0),('school14_gjc823','career_categories','2022-12-12 16:23:31',0,1,1),('school14_gjc823','career_groups','2022-12-12 16:23:31',0,1,0),('school14_gjc823','career_questions','2022-12-12 16:23:31',0,1,0),('school14_gjc823','career_tests','2022-12-12 16:23:31',0,1,1),('school14_gjc823','careers','2022-12-12 16:23:32',0,1,0),('school14_gjc823','cgpa','2022-12-12 16:23:32',0,1,1),('school14_gjc823','class_coordinators','2022-12-12 16:23:32',0,1,1),('school14_gjc823','class_electvie_exemption','2022-12-12 16:23:32',0,1,1),('school14_gjc823','class_levels','2022-12-12 16:23:32',6,1,1),('school14_gjc823','class_promotions','2022-12-12 16:23:33',269,3,1),('school14_gjc823','class_sections','2022-12-12 16:23:33',4,1,1),('school14_gjc823','class_session_teachers','2022-12-15 17:42:52',36,1,1),('school14_gjc823','class_subjects','2022-12-12 16:23:33',0,1,0),('school14_gjc823','classes','2022-12-12 16:23:34',24,1,1),('school14_gjc823','client','2022-12-12 16:23:33',0,1,0),('school14_gjc823','comments','2022-12-12 16:23:35',25,3,1),('school14_gjc823','compound_subject_structure','2022-12-12 16:23:33',0,1,1),('school14_gjc823','compound_subjects','2022-12-12 16:23:33',0,1,0),('school14_gjc823','course_reg','2022-12-12 16:23:34',0,1,1),('school14_gjc823','cron_refresh','2022-12-16 19:34:50',18,1,1),('school14_gjc823','default_performance','2022-12-12 16:23:34',0,1,0),('school14_gjc823','default_salary_structure','2022-12-12 16:23:34',0,1,2),('school14_gjc823','default_schoolfees_structure','2022-12-12 16:23:34',0,1,1),('school14_gjc823','demerits','2022-12-12 16:23:34',0,1,1),('school14_gjc823','departments','2022-12-12 16:23:36',23,1,1),('school14_gjc823','description','2022-12-12 16:23:34',0,1,0),('school14_gjc823','detentions','2022-12-12 16:23:34',0,1,0),('school14_gjc823','diary','2022-12-12 16:23:34',0,1,0),('school14_gjc823','discipline','2022-12-12 16:23:34',0,1,0),('school14_gjc823','elective_groups','2022-12-12 16:23:34',0,1,1),('school14_gjc823','elective_status','2022-12-12 16:23:34',0,1,1),('school14_gjc823','electives_grades_locker','2022-12-12 16:23:35',0,1,1),('school14_gjc823','employee','2022-12-12 16:23:36',94,1,2),('school14_gjc823','employee_accounts','2022-12-12 16:23:35',0,1,1),('school14_gjc823','employee_fees','2022-12-12 16:23:35',0,1,1),('school14_gjc823','employee_transport','2022-12-12 16:23:35',0,1,1),('school14_gjc823','employees_leaves','2022-12-12 16:23:35',0,1,1),('school14_gjc823','entrance_settings','2022-12-12 16:23:35',0,1,0),('school14_gjc823','evaluation_reports','2022-12-12 16:23:36',439,15,1),('school14_gjc823','events_holidays','2022-12-12 16:23:35',0,1,1),('school14_gjc823','exam_centres','2022-12-12 16:23:35',0,1,1),('school14_gjc823','exam_cities','2022-12-12 16:23:35',0,1,1),('school14_gjc823','exchange_rates','2022-12-12 16:23:35',0,1,1),('school14_gjc823','faculties','2022-12-12 16:23:35',0,1,0),('school14_gjc823','files','2022-12-12 16:23:36',0,1,0),('school14_gjc823','gradding_structure','2022-12-12 16:23:36',0,1,1),('school14_gjc823','grades','2022-12-12 16:23:36',5,1,1),('school14_gjc823','grades_locker','2022-12-12 16:23:37',290,1,1),('school14_gjc823','grading_default','2022-12-12 16:23:37',7,1,0),('school14_gjc823','grading_system','2022-12-12 16:23:37',6,1,0),('school14_gjc823','graduation_awards','2022-12-12 16:23:36',0,1,1),('school14_gjc823','graduation_awards_averages','2022-12-12 16:23:36',0,1,1),('school14_gjc823','grouped_subjects','2022-12-12 16:23:36',0,1,0),('school14_gjc823','health_reports','2022-12-12 16:23:36',0,1,0),('school14_gjc823','hostel_houses','2022-12-12 16:23:37',4,1,0),('school14_gjc823','hostel_rooms','2022-12-12 16:23:38',8,1,2),('school14_gjc823','hostels','2022-12-12 16:23:38',2,1,0),('school14_gjc823','improvement_awards','2022-12-12 16:23:37',0,1,1),('school14_gjc823','improvement_awards_averages','2022-12-12 16:23:37',0,1,1),('school14_gjc823','interface','2022-12-12 16:23:38',12,1,1),('school14_gjc823','interview_datetimes','2022-12-12 16:23:37',0,1,1),('school14_gjc823','inventory','2022-12-12 16:23:37',0,1,1),('school14_gjc823','leave_types','2022-12-12 16:23:37',0,1,0),('school14_gjc823','lesson_notes','2022-12-12 16:23:37',0,1,0),('school14_gjc823','level_payment_plans','2022-12-12 16:23:37',0,1,0),('school14_gjc823','levels','2022-12-12 16:23:38',12,1,1),('school14_gjc823','library_setting','2022-12-12 16:23:37',0,1,0),('school14_gjc823','log','2022-12-17 14:31:29',1423,97,0),('school14_gjc823','mails','2022-12-17 16:43:06',234,6,0),('school14_gjc823','message_templates','2022-12-12 16:23:38',0,1,0),('school14_gjc823','months','2022-12-12 16:23:39',12,1,0),('school14_gjc823','newsletters','2022-12-12 16:23:39',10,1,0),('school14_gjc823','notifications','2022-12-12 16:23:38',0,1,0),('school14_gjc823','offences','2022-12-12 16:23:40',10,1,0),('school14_gjc823','options','2022-12-12 16:23:40',95,1,1),('school14_gjc823','paid_bills','2022-12-12 16:23:38',0,1,2),('school14_gjc823','paid_students','2022-12-12 16:23:38',0,1,1),('school14_gjc823','parent_login','2022-12-12 16:23:41',326,3,3),('school14_gjc823','parent_pins','2022-12-12 16:23:38',0,1,1),('school14_gjc823','parents','2022-12-12 16:23:41',326,4,2),('school14_gjc823','payment_plans','2022-12-12 16:23:38',0,1,0),('school14_gjc823','payment_types','2022-12-12 16:23:42',5,1,1),('school14_gjc823','penalty_fees','2022-12-12 16:23:39',0,1,0),('school14_gjc823','pending_parent_login','2022-12-12 16:23:39',0,1,4),('school14_gjc823','pending_parents','2022-12-12 16:23:42',1526,28,0),('school14_gjc823','pending_student_login','2022-12-12 16:23:39',0,1,2),('school14_gjc823','pending_students','2022-12-12 16:23:42',882,23,4),('school14_gjc823','performance_comments','2022-12-12 16:23:40',0,1,4),('school14_gjc823','performance_settings','2022-12-12 16:23:42',27,1,1),('school14_gjc823','performances','2022-12-16 19:28:28',8001,97,43),('school14_gjc823','performances_compound','2022-12-12 16:23:41',0,1,9),('school14_gjc823','performances_special','2022-12-12 16:23:41',0,1,1),('school14_gjc823','physical_records','2022-12-12 16:23:41',0,1,1),('school14_gjc823','pins','2022-12-12 16:23:43',20,1,2),('school14_gjc823','pre_mock','2022-12-15 17:30:33',0,1,1),('school14_gjc823','pre_mock_performance_averages','2022-12-15 17:30:33',0,1,1),('school14_gjc823','premock_elective_groups','2022-12-15 17:30:33',0,1,1),('school14_gjc823','premock_elective_status','2022-12-15 17:30:33',0,1,1),('school14_gjc823','premock_electives_grades_locker','2022-12-15 17:30:33',0,1,2),('school14_gjc823','premock_grades_locker','2022-12-15 17:30:33',0,1,1),('school14_gjc823','premock_students_electives','2022-12-15 17:30:34',0,1,1),('school14_gjc823','premock_teachers_subjects','2022-12-15 17:32:55',0,1,1),('school14_gjc823','previledges','2022-12-12 16:23:41',0,1,2),('school14_gjc823','privileges','2022-12-12 16:23:43',73,1,2),('school14_gjc823','promotions','2022-12-12 16:23:41',0,1,0),('school14_gjc823','result_comments','2022-12-12 16:23:43',261,18,1),('school14_gjc823','roles','2022-12-12 16:23:43',4,1,1),('school14_gjc823','room_types','2022-12-12 16:23:44',3,1,1),('school14_gjc823','routes','2022-12-12 16:23:42',0,1,2),('school14_gjc823','salary_structure','2022-12-12 16:23:42',0,1,2),('school14_gjc823','sales','2022-12-12 16:23:42',0,1,0),('school14_gjc823','scheme_of_work','2022-12-12 16:23:42',0,1,1),('school14_gjc823','school_details','2022-12-12 16:23:42',0,1,1),('school14_gjc823','school_diary','2022-12-12 16:23:42',0,1,1),('school14_gjc823','school_fees_status','2022-12-12 16:23:42',0,1,0),('school14_gjc823','school_rooms','2022-12-12 16:23:44',26,1,0),('school14_gjc823','school_sessions','2022-12-12 16:23:44',10,1,3),('school14_gjc823','school_structure','2022-12-12 16:23:42',0,1,0),('school14_gjc823','school_terms','2022-12-12 16:23:44',24,1,4),('school14_gjc823','schoolfees_structure','2022-12-12 16:23:43',0,1,1),('school14_gjc823','sections','2022-12-12 16:23:43',0,1,0),('school14_gjc823','security','2022-12-12 16:23:43',0,1,0),('school14_gjc823','session_cron_refresh','2022-12-12 16:23:45',4,1,1),('school14_gjc823','session_performance_averages','2022-12-12 16:23:45',87,1,1),('school14_gjc823','session_subjects_averages','2022-12-12 16:23:45',1653,11,5),('school14_gjc823','short_codes','2022-12-12 16:23:43',0,1,0),('school14_gjc823','skills','2022-12-15 17:48:01',10,1,1),('school14_gjc823','skills_performance','2022-12-12 16:23:45',10,1,1),('school14_gjc823','sms','2022-12-12 16:23:43',0,1,0),('school14_gjc823','sms_templates','2022-12-12 16:23:43',0,1,0),('school14_gjc823','special_performances','2022-12-12 16:23:44',0,1,1),('school14_gjc823','staff_apprasial','2022-12-12 16:23:44',0,1,0),('school14_gjc823','stock','2022-12-12 16:23:44',0,1,0),('school14_gjc823','student_credit_history','2022-12-12 16:23:44',0,1,2),('school14_gjc823','student_credits','2022-12-12 16:23:45',179,1,1),('school14_gjc823','student_debits','2022-12-12 16:23:44',0,1,1),('school14_gjc823','student_login','2022-12-12 16:23:45',183,1,2),('school14_gjc823','student_rooms','2022-12-17 18:23:43',266,1,1),('school14_gjc823','student_transport','2022-12-12 16:23:44',0,1,1),('school14_gjc823','students','2022-12-12 16:23:55',183,4,0),('school14_gjc823','students_electives','2022-12-12 16:23:44',0,1,1),('school14_gjc823','subject_attendance','2022-12-12 16:23:44',0,1,2),('school14_gjc823','subject_groups','2022-12-12 16:23:44',0,1,0),('school14_gjc823','subjects','2022-12-12 16:24:05',61,1,2),('school14_gjc823','subjects_high_low','2022-12-12 16:24:15',98,1,1),('school14_gjc823','superadmin','2022-12-12 16:24:25',7,1,2),('school14_gjc823','teachers_comments','2022-12-12 16:23:45',0,1,1),('school14_gjc823','teachers_subjects','2022-12-12 16:24:35',266,1,1),('school14_gjc823','term_performance_averages','2022-12-12 16:24:45',440,4,1),('school14_gjc823','timetable','2022-12-12 16:23:45',0,1,2),('school14_gjc823','timetable_durations','2022-12-12 16:24:55',60,1,1),('school14_gjc823','titles','2022-12-12 16:25:05',29,1,1),('school14_gjc823','transaction_log','2022-12-12 16:23:45',0,1,2),('school14_gjc823','transactions','2022-12-12 16:23:45',0,1,1),('school14_gjc823','vehicle_routes','2022-12-12 16:23:46',0,1,2),('school14_gjc823','vehicles','2022-12-12 16:23:46',0,1,3),('school14_gjc823','vouchers','2022-12-12 16:23:46',0,1,1),('sys','sys_config','2022-12-11 11:13:53',6,1,0);

--
-- Table structure for table `ndb_binlog_index`
--

CREATE TABLE `ndb_binlog_index` (
  `Position` bigint(20) unsigned NOT NULL,
  `File` varchar(255) NOT NULL,
  `epoch` bigint(20) unsigned NOT NULL,
  `inserts` int(10) unsigned NOT NULL,
  `updates` int(10) unsigned NOT NULL,
  `deletes` int(10) unsigned NOT NULL,
  `schemaops` int(10) unsigned NOT NULL,
  `orig_server_id` int(10) unsigned NOT NULL,
  `orig_epoch` bigint(20) unsigned NOT NULL,
  `gci` int(10) unsigned NOT NULL,
  `next_position` bigint(20) unsigned NOT NULL,
  `next_file` varchar(255) NOT NULL,
  PRIMARY KEY (`epoch`,`orig_server_id`,`orig_epoch`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ndb_binlog_index`
--


--
-- Table structure for table `plugin`
--

CREATE TABLE `plugin` (
  `name` varchar(64) NOT NULL DEFAULT '',
  `dl` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='MySQL plugins';

--
-- Dumping data for table `plugin`
--

INSERT INTO `plugin` VALUES ('auth_socket','auth_socket.so');

--
-- Table structure for table `proc`
--

CREATE TABLE `proc` (
  `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `name` char(64) NOT NULL DEFAULT '',
  `type` enum('FUNCTION','PROCEDURE') NOT NULL,
  `specific_name` char(64) NOT NULL DEFAULT '',
  `language` enum('SQL') NOT NULL DEFAULT 'SQL',
  `sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',
  `is_deterministic` enum('YES','NO') NOT NULL DEFAULT 'NO',
  `security_type` enum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',
  `param_list` blob NOT NULL,
  `returns` longblob NOT NULL,
  `body` longblob NOT NULL,
  `definer` char(93) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',
  `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `body_utf8` longblob,
  PRIMARY KEY (`db`,`name`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures';

--
-- Dumping data for table `proc`
--


--
-- Table structure for table `procs_priv`
--

CREATE TABLE `procs_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Routine_name` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Routine_type` enum('FUNCTION','PROCEDURE') COLLATE utf8_bin NOT NULL,
  `Grantor` char(93) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proc_priv` set('Execute','Alter Routine','Grant') CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`Host`,`Db`,`User`,`Routine_name`,`Routine_type`),
  KEY `Grantor` (`Grantor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges';

--
-- Dumping data for table `procs_priv`
--


--
-- Table structure for table `proxies_priv`
--

CREATE TABLE `proxies_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proxied_host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proxied_user` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `With_grant` tinyint(1) NOT NULL DEFAULT '0',
  `Grantor` char(93) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`Host`,`User`,`Proxied_host`,`Proxied_user`),
  KEY `Grantor` (`Grantor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User proxy privileges';

--
-- Dumping data for table `proxies_priv`
--

INSERT INTO `proxies_priv` VALUES ('localhost','root','','',1,'boot@connecting host','0000-00-00 00:00:00');

--
-- Table structure for table `server_cost`
--

CREATE TABLE `server_cost` (
  `cost_name` varchar(64) NOT NULL,
  `cost_value` float DEFAULT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `comment` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`cost_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0;

--
-- Dumping data for table `server_cost`
--

INSERT INTO `server_cost` VALUES ('disk_temptable_create_cost',NULL,'2022-12-11 11:13:52',NULL),('disk_temptable_row_cost',NULL,'2022-12-11 11:13:52',NULL),('key_compare_cost',NULL,'2022-12-11 11:13:52',NULL),('memory_temptable_create_cost',NULL,'2022-12-11 11:13:52',NULL),('memory_temptable_row_cost',NULL,'2022-12-11 11:13:52',NULL),('row_evaluate_cost',NULL,'2022-12-11 11:13:52',NULL);

--
-- Table structure for table `servers`
--

CREATE TABLE `servers` (
  `Server_name` char(64) NOT NULL DEFAULT '',
  `Host` char(64) NOT NULL DEFAULT '',
  `Db` char(64) NOT NULL DEFAULT '',
  `Username` char(64) NOT NULL DEFAULT '',
  `Password` char(64) NOT NULL DEFAULT '',
  `Port` int(4) NOT NULL DEFAULT '0',
  `Socket` char(64) NOT NULL DEFAULT '',
  `Wrapper` char(64) NOT NULL DEFAULT '',
  `Owner` char(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`Server_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='MySQL Foreign Servers table';

--
-- Dumping data for table `servers`
--


--
-- Table structure for table `slave_master_info`
--

CREATE TABLE IF NOT EXISTS `slave_master_info` (
  `Number_of_lines` int(10) unsigned NOT NULL COMMENT 'Number of lines in the file.',
  `Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the master binary log currently being read from the master.',
  `Master_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The master log position of the last read event.',
  `Host` char(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'The host name of the master.',
  `User_name` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The user name used to connect to the master.',
  `User_password` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The password used to connect to the master.',
  `Port` int(10) unsigned NOT NULL COMMENT 'The network port used to connect to the master.',
  `Connect_retry` int(10) unsigned NOT NULL COMMENT 'The period (in seconds) that the slave will wait before trying to reconnect to the master.',
  `Enabled_ssl` tinyint(1) NOT NULL COMMENT 'Indicates whether the server supports SSL connections.',
  `Ssl_ca` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Authority (CA) certificate.',
  `Ssl_capath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path to the Certificate Authority (CA) certificates.',
  `Ssl_cert` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL certificate file.',
  `Ssl_cipher` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the cipher in use for the SSL connection.',
  `Ssl_key` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL key file.',
  `Ssl_verify_server_cert` tinyint(1) NOT NULL COMMENT 'Whether to verify the server certificate.',
  `Heartbeat` float NOT NULL,
  `Bind` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Displays which interface is employed when connecting to the MySQL server',
  `Ignored_server_ids` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The number of server IDs to be ignored, followed by the actual server IDs',
  `Uuid` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The master server uuid.',
  `Retry_count` bigint(20) unsigned NOT NULL COMMENT 'Number of reconnect attempts, to the master, before giving up.',
  `Ssl_crl` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Revocation List (CRL)',
  `Ssl_crlpath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path used for Certificate Revocation List (CRL) files',
  `Enabled_auto_position` tinyint(1) NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.',
  `Channel_name` char(64) NOT NULL COMMENT 'The channel on which the slave is connected to a source. Used in Multisource Replication',
  `Tls_version` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Tls version',
  PRIMARY KEY (`Channel_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Master Information';

--
-- Table structure for table `slave_relay_log_info`
--

CREATE TABLE IF NOT EXISTS `slave_relay_log_info` (
  `Number_of_lines` int(10) unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
  `Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the current relay log file.',
  `Relay_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The relay log position of the last executed event.',
  `Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the master binary log file from which the events in the relay log file were read.',
  `Master_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The master log position of the last executed event.',
  `Sql_delay` int(11) NOT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',
  `Number_of_workers` int(10) unsigned NOT NULL,
  `Id` int(10) unsigned NOT NULL COMMENT 'Internal Id that uniquely identifies this record.',
  `Channel_name` char(64) NOT NULL COMMENT 'The channel on which the slave is connected to a source. Used in Multisource Replication',
  PRIMARY KEY (`Channel_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Relay Log Information';

--
-- Table structure for table `slave_worker_info`
--

CREATE TABLE `slave_worker_info` (
  `Id` int(10) unsigned NOT NULL,
  `Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Relay_log_pos` bigint(20) unsigned NOT NULL,
  `Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Master_log_pos` bigint(20) unsigned NOT NULL,
  `Checkpoint_relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Checkpoint_relay_log_pos` bigint(20) unsigned NOT NULL,
  `Checkpoint_master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Checkpoint_master_log_pos` bigint(20) unsigned NOT NULL,
  `Checkpoint_seqno` int(10) unsigned NOT NULL,
  `Checkpoint_group_size` int(10) unsigned NOT NULL,
  `Checkpoint_group_bitmap` blob NOT NULL,
  `Channel_name` char(64) NOT NULL COMMENT 'The channel on which the slave is connected to a source. Used in Multisource Replication',
  PRIMARY KEY (`Channel_name`,`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Worker Information';

--
-- Dumping data for table `slave_worker_info`
--


--
-- Table structure for table `tables_priv`
--

CREATE TABLE `tables_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Grantor` char(93) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
  PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`),
  KEY `Grantor` (`Grantor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table privileges';

--
-- Dumping data for table `tables_priv`
--

INSERT INTO `tables_priv` VALUES ('localhost','mysql','mysql.session','user','boot@connecting host','0000-00-00 00:00:00','Select',''),('localhost','sys','mysql.sys','sys_config','root@localhost','2022-12-11 11:13:53','Select','');

--
-- Table structure for table `time_zone`
--

CREATE TABLE `time_zone` (
  `Time_zone_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Use_leap_seconds` enum('Y','N') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`Time_zone_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Time zones';

--
-- Dumping data for table `time_zone`
--


--
-- Table structure for table `time_zone_leap_second`
--

CREATE TABLE `time_zone_leap_second` (
  `Transition_time` bigint(20) NOT NULL,
  `Correction` int(11) NOT NULL,
  PRIMARY KEY (`Transition_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Leap seconds information for time zones';

--
-- Dumping data for table `time_zone_leap_second`
--


--
-- Table structure for table `time_zone_name`
--

CREATE TABLE `time_zone_name` (
  `Name` char(64) NOT NULL,
  `Time_zone_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`Name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Time zone names';

--
-- Dumping data for table `time_zone_name`
--


--
-- Table structure for table `time_zone_transition`
--

CREATE TABLE `time_zone_transition` (
  `Time_zone_id` int(10) unsigned NOT NULL,
  `Transition_time` bigint(20) NOT NULL,
  `Transition_type_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`Time_zone_id`,`Transition_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Time zone transitions';

--
-- Dumping data for table `time_zone_transition`
--


--
-- Table structure for table `time_zone_transition_type`
--

CREATE TABLE `time_zone_transition_type` (
  `Time_zone_id` int(10) unsigned NOT NULL,
  `Transition_type_id` int(10) unsigned NOT NULL,
  `Offset` int(11) NOT NULL DEFAULT '0',
  `Is_DST` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `Abbreviation` char(8) NOT NULL DEFAULT '',
  PRIMARY KEY (`Time_zone_id`,`Transition_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Time zone transition types';

--
-- Dumping data for table `time_zone_transition_type`
--


--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Reload_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Shutdown_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Process_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `File_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Show_db_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Super_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Repl_slave_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Repl_client_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_user_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_tablespace_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8 NOT NULL DEFAULT '',
  `ssl_cipher` blob NOT NULL,
  `x509_issuer` blob NOT NULL,
  `x509_subject` blob NOT NULL,
  `max_questions` int(11) unsigned NOT NULL DEFAULT '0',
  `max_updates` int(11) unsigned NOT NULL DEFAULT '0',
  `max_connections` int(11) unsigned NOT NULL DEFAULT '0',
  `max_user_connections` int(11) unsigned NOT NULL DEFAULT '0',
  `plugin` char(64) COLLATE utf8_bin NOT NULL DEFAULT 'mysql_native_password',
  `authentication_string` text COLLATE utf8_bin,
  `password_expired` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `password_last_changed` timestamp NULL DEFAULT NULL,
  `password_lifetime` smallint(5) unsigned DEFAULT NULL,
  `account_locked` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  PRIMARY KEY (`Host`,`User`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges';

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES ('localhost','root','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'auth_socket','','N','2022-12-11 11:13:53',NULL,'N'),('localhost','mysql.session','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'mysql_native_password','*THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE','N','2022-12-11 11:13:53',NULL,'Y'),('localhost','mysql.sys','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'mysql_native_password','*THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE','N','2022-12-11 11:13:53',NULL,'Y'),('localhost','debian-sys-maint','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'mysql_native_password','*5C7511C4F967B144176B5C3948FE1606C3E2C9DA','N','2022-12-11 11:13:54',NULL,'N'),('%','revocubemysql','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'mysql_native_password','*58E20BEBFC298E16550EB8940114D55F15473243','N','2022-12-12 16:17:03',NULL,'N');

--
-- Table structure for table `general_log`
--

CREATE TABLE IF NOT EXISTS `general_log` (
  `event_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `user_host` mediumtext NOT NULL,
  `thread_id` bigint(21) unsigned NOT NULL,
  `server_id` int(10) unsigned NOT NULL,
  `command_type` varchar(64) NOT NULL,
  `argument` mediumblob NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='General log';

--
-- Table structure for table `slow_log`
--

CREATE TABLE IF NOT EXISTS `slow_log` (
  `start_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `user_host` mediumtext NOT NULL,
  `query_time` time(6) NOT NULL,
  `lock_time` time(6) NOT NULL,
  `rows_sent` int(11) NOT NULL,
  `rows_examined` int(11) NOT NULL,
  `db` varchar(512) NOT NULL,
  `last_insert_id` int(11) NOT NULL,
  `insert_id` int(11) NOT NULL,
  `server_id` int(10) unsigned NOT NULL,
  `sql_text` mediumblob NOT NULL,
  `thread_id` bigint(21) unsigned NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log';

--
-- Current Database: `school14_gjc823`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `school14_gjc823` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `school14_gjc823`;

--
-- Table structure for table `academic_positions`
--

CREATE TABLE `academic_positions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `term_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `position` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Unique Position` (`student_id`,`term_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `academic_positions`
--


--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` smallint(5) unsigned zerofill NOT NULL DEFAULT '00000',
  `role_id` tinyint(3) unsigned zerofill NOT NULL DEFAULT '000',
  PRIMARY KEY (`id`),
  UNIQUE KEY `employee role duplicate` (`employee_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `admins`
--


--
-- Table structure for table `admission_settings`
--

CREATE TABLE `admission_settings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `session_id` int(2) DEFAULT NULL,
  `exam_date` date DEFAULT NULL,
  `exam_fee` int(8) NOT NULL DEFAULT '10000',
  `passed_message` varchar(400) DEFAULT NULL,
  `failed_message` varchar(400) DEFAULT NULL,
  `admitted_message` varchar(500) DEFAULT NULL,
  `public_notice` varchar(1000) DEFAULT NULL,
  `applicants_notice` varchar(600) DEFAULT NULL,
  `closing_date` date DEFAULT NULL,
  `enable_pins` enum('1','0') DEFAULT '1',
  `cutoff` int(3) DEFAULT NULL,
  `pins_count` int(4) NOT NULL DEFAULT '100',
  `result_date` date DEFAULT NULL,
  `show_scores` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `admission_settings`
--


--
-- Table structure for table `api_requests`
--

CREATE TABLE `api_requests` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ip` varchar(18) DEFAULT NULL,
  `request` text,
  `endpoint` varchar(300) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `api_requests`
--


--
-- Table structure for table `assigned_subjects`
--

CREATE TABLE `assigned_subjects` (
  `id` smallint(5) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `employee_id` smallint(5) unsigned zerofill NOT NULL DEFAULT '00000',
  `subjects_id` smallint(5) unsigned zerofill NOT NULL DEFAULT '00000',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `assigned_subjects`
--


--
-- Table structure for table `assignment_replies`
--

CREATE TABLE `assignment_replies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `assignment_id` bigint(20) unsigned NOT NULL,
  `reply` longtext NOT NULL,
  `student_id` bigint(20) NOT NULL,
  `datetime` datetime NOT NULL,
  `attachment` varchar(60) DEFAULT NULL,
  `grade` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Unique reply` (`assignment_id`,`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `assignment_replies`
--


--
-- Table structure for table `assignments`
--

CREATE TABLE `assignments` (
  `id` smallint(5) NOT NULL AUTO_INCREMENT,
  `topic` varchar(60) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `superadmin_id` int(11) DEFAULT NULL,
  `postType` varchar(20) NOT NULL,
  `subject_id` tinyint(3) unsigned NOT NULL,
  `class_id` smallint(6) unsigned NOT NULL DEFAULT '0',
  `date` date NOT NULL,
  `dueDate` date NOT NULL,
  `content` text NOT NULL,
  `attachment` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `title_2` (`topic`,`date`),
  UNIQUE KEY `title` (`topic`,`employee_id`,`subject_id`,`class_id`,`date`,`dueDate`),
  UNIQUE KEY `title_3` (`topic`,`employee_id`,`postType`,`subject_id`,`class_id`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `assignments`
--


--
-- Table structure for table `attendance`
--

CREATE TABLE `attendance` (
  `id` bigint(5) unsigned NOT NULL AUTO_INCREMENT,
  `status` varchar(10) NOT NULL,
  `term_id` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `date` date NOT NULL,
  `class_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `students_id` bigint(5) unsigned NOT NULL DEFAULT '0',
  `registrar` varchar(40) DEFAULT 'Annonymous',
  PRIMARY KEY (`id`),
  UNIQUE KEY `status` (`status`,`term_id`,`date`,`class_id`,`students_id`),
  UNIQUE KEY `Student date` (`date`,`students_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `attendance`
--


--
-- Table structure for table `auto_sms`
--

CREATE TABLE `auto_sms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(20) NOT NULL,
  `sender` varchar(10) NOT NULL,
  `message` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `auto_sms`
--


--
-- Table structure for table `average_ranks`
--

CREATE TABLE `average_ranks` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` tinyint(2) DEFAULT NULL,
  `student_id` tinyint(2) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `average_ranks`
--


--
-- Table structure for table `bank_accounts`
--

CREATE TABLE `bank_accounts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bank_id` int(11) NOT NULL,
  `number` varchar(10) NOT NULL DEFAULT '',
  `title` varchar(60) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `type` varchar(30) DEFAULT 'Current',
  `balance` double(12,2) DEFAULT '0.00',
  `status` varchar(40) DEFAULT 'active',
  `live_monnify_code` varchar(30) DEFAULT NULL,
  `live_paystack_code` varchar(30) DEFAULT NULL,
  `live_rave_code` varchar(30) DEFAULT NULL,
  `live_billscube_code` varchar(30) DEFAULT NULL,
  `demo_monnify_code` varchar(30) DEFAULT NULL,
  `demo_paystack_code` varchar(30) DEFAULT NULL,
  `demo_rave_code` varchar(30) DEFAULT NULL,
  `demo_billscube_code` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Unique Account` (`bank_id`,`number`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `bank_accounts`
--


--
-- Table structure for table `banks`
--

CREATE TABLE `banks` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` tinytext NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `code` int(3) unsigned zerofill NOT NULL DEFAULT '000',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `banks`
--

INSERT INTO `banks` VALUES (1,'Access Bank Plc',NULL,044),(3,'Diamond Bank Plc',NULL,063),(4,'Ecobank Nigeria Plc',NULL,050),(5,'Fidelity Bank Plc',NULL,070),(6,'First City Monument Bank Plc',NULL,214),(7,'Guaranty Trust Bank Plc',NULL,058),(8,'Key Stone Bank',NULL,082),(9,'Polaris Bank',NULL,076),(10,'Stanbic IBTC Bank Ltd.',NULL,221),(11,'Standard Chartered Bank Nigeria Ltd.',NULL,068),(12,'Sterling Bank Plc',NULL,232),(13,'SunTrust Bank Nigeria Limited',NULL,100),(14,'Union Bank of Nigeria Plc',NULL,032),(15,'United Bank For Africa Plc',NULL,033),(16,'Unity  Bank Plc',NULL,215),(17,'Wema Bank Plc',NULL,035),(18,'Zenith Bank Plc',NULL,057),(19,'Heritage Bank',NULL,030),(20,'First Bank',NULL,011),(21,'Providus Bank',NULL,101);

--
-- Table structure for table `book_authors`
--

CREATE TABLE `book_authors` (
  `id` bigint(3) unsigned NOT NULL AUTO_INCREMENT,
  `author` varchar(400) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Unique Author` (`author`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `book_authors`
--


--
-- Table structure for table `book_categories`
--

CREATE TABLE `book_categories` (
  `id` bigint(4) unsigned NOT NULL AUTO_INCREMENT,
  `category` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Unique Category` (`category`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `book_categories`
--

INSERT INTO `book_categories` VALUES (2,'Science'),(1,'Social Sciences ');

--
-- Table structure for table `book_issues`
--

CREATE TABLE `book_issues` (
  `id` bigint(3) unsigned NOT NULL AUTO_INCREMENT,
  `book_id` bigint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'books',
  `patronType` tinytext NOT NULL,
  `patron_id` bigint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'employees or students',
  `dateOfIssue` datetime NOT NULL,
  `dueDate` datetime NOT NULL,
  `copyNumber` bigint(4) unsigned DEFAULT '0',
  `status` varchar(30) NOT NULL DEFAULT '',
  `recipientType` varchar(40) NOT NULL,
  `recipient_id` bigint(20) DEFAULT NULL,
  `remarks` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Unique Issued Status` (`book_id`,`copyNumber`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `book_issues`
--


--
-- Table structure for table `book_losses`
--

CREATE TABLE `book_losses` (
  `id` smallint(4) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `book_id` smallint(5) unsigned zerofill NOT NULL DEFAULT '00000' COMMENT 'books',
  `copyNumber` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `date` datetime NOT NULL,
  `dateLost` date DEFAULT NULL,
  `issue_id` int(11) DEFAULT NULL,
  `comment` varchar(100) DEFAULT NULL,
  `reporterType` varchar(20) DEFAULT NULL,
  `reporter` varchar(80) DEFAULT NULL,
  `reporterName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Unique Loss` (`book_id`,`copyNumber`,`date`),
  UNIQUE KEY `UniqueBook` (`book_id`,`copyNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `book_losses`
--


--
-- Table structure for table `book_publishers`
--

CREATE TABLE `book_publishers` (
  `id` bigint(3) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `publisher` varchar(150) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Unique Publisher` (`publisher`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `book_publishers`
--


--
-- Table structure for table `book_renewals`
--

CREATE TABLE `book_renewals` (
  `id` mediumint(5) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `issue_id` smallint(5) unsigned zerofill NOT NULL DEFAULT '00000',
  `renewalDate` datetime NOT NULL,
  `remarks` varchar(200) DEFAULT NULL,
  `patronType` varchar(30) DEFAULT NULL,
  `patron_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique Renewal` (`issue_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `book_renewals`
--


--
-- Table structure for table `book_returns`
--

CREATE TABLE `book_returns` (
  `id` mediumint(5) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `issue_id` smallint(5) unsigned zerofill NOT NULL DEFAULT '00000',
  `returnDate` datetime NOT NULL,
  `remarks` varchar(200) DEFAULT NULL,
  `patronType` varchar(30) DEFAULT NULL,
  `patron_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique Renewal` (`issue_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `book_returns`
--


--
-- Table structure for table `book_shop`
--

CREATE TABLE `book_shop` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `book_id` int(11) NOT NULL,
  `qty` int(11) NOT NULL,
  `costPrice` double NOT NULL,
  `salesPrice` double NOT NULL,
  `patron` varchar(40) NOT NULL,
  `dateTime` datetime NOT NULL,
  `reorder` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`,`book_id`),
  UNIQUE KEY `Unique book` (`book_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `book_shop`
--


--
-- Table structure for table `books`
--

CREATE TABLE `books` (
  `id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
  `bookTitle` varchar(200) NOT NULL,
  `cat_id` bigint(11) unsigned NOT NULL DEFAULT '0' COMMENT 'book_categories',
  `author_id` bigint(11) unsigned NOT NULL DEFAULT '0' COMMENT 'book_authors',
  `publisher_id` bigint(11) unsigned NOT NULL DEFAULT '0' COMMENT 'book_publishers',
  `subject_id` bigint(20) DEFAULT NULL,
  `edition` tinyint(4) NOT NULL,
  `unitPrice` decimal(11,2) unsigned NOT NULL DEFAULT '0.00',
  `copies` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `copyNumber` tinyint(3) unsigned DEFAULT '0',
  `date` datetime NOT NULL,
  `code` varchar(50) DEFAULT NULL,
  `ISBN` varchar(40) DEFAULT NULL,
  `row_no` int(11) DEFAULT NULL,
  `shelf_no` int(11) DEFAULT NULL,
  `column_no` int(11) DEFAULT NULL,
  `registrar` varchar(60) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `cover_photo` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Unique Book` (`bookTitle`,`author_id`,`publisher_id`,`edition`),
  UNIQUE KEY `UniqueEdition` (`bookTitle`,`edition`),
  UNIQUE KEY `Unique Code` (`code`),
  UNIQUE KEY `Unique ISBN` (`ISBN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `books`
--


--
-- Table structure for table `cafeteria_transactions`
--

CREATE TABLE `cafeteria_transactions` (
  `id` smallint(5) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `itemCode` tinyint(3) unsigned zerofill NOT NULL DEFAULT '000' COMMENT 'itemCode in inventory',
  `qty` tinyint(3) unsigned zerofill NOT NULL DEFAULT '000',
  `tranTotal` mediumint(9) NOT NULL DEFAULT '0',
  `tranDate` varchar(18) NOT NULL DEFAULT '0',
  `tranType` tinytext NOT NULL,
  `patronID` smallint(5) unsigned zerofill NOT NULL DEFAULT '00000' COMMENT 'studentID or employeeID',
  `paymentTypeID` smallint(5) unsigned zerofill NOT NULL DEFAULT '00000' COMMENT 'paymentTypeID in payment_types',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `cafeteria_transactions`
--


--
-- Table structure for table `career_categories`
--

CREATE TABLE `career_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `summary` varchar(200) NOT NULL,
  `details` text NOT NULL,
  `group_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `code` (`code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `career_categories`
--


--
-- Table structure for table `career_groups`
--

CREATE TABLE `career_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(300) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `career_groups`
--


--
-- Table structure for table `career_questions`
--

CREATE TABLE `career_questions` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(2) NOT NULL DEFAULT '',
  `question` varchar(200) NOT NULL DEFAULT '',
  `icon` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `career_questions`
--


--
-- Table structure for table `career_tests`
--

CREATE TABLE `career_tests` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `student_id` int(11) DEFAULT NULL,
  `career_id1` int(4) DEFAULT NULL,
  `term_id` int(4) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `career_id2` int(4) DEFAULT NULL,
  `career_id3` int(4) DEFAULT NULL,
  `date` date DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `student_id` (`student_id`,`date`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `career_tests`
--


--
-- Table structure for table `careers`
--

CREATE TABLE `careers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `career` varchar(150) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `careers`
--


--
-- Table structure for table `cgpa`
--

CREATE TABLE `cgpa` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `cgpa` double(3,2) NOT NULL,
  `rank` int(3) DEFAULT NULL,
  `junior_avg` double(5,2) DEFAULT NULL,
  `junior_cgpa` double(3,2) DEFAULT NULL,
  `junior_rank` int(3) DEFAULT NULL,
  `senior_avg` double(5,2) DEFAULT NULL,
  `senior_cgpa` double(3,2) DEFAULT NULL,
  `senior_rank` int(11) DEFAULT NULL,
  `avg` double(5,2) DEFAULT NULL,
  `junior_class_id` int(11) DEFAULT NULL,
  `senior_class_id` int(11) DEFAULT NULL,
  `admission_session_id` int(2) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `Unique_Student` (`student_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `cgpa`
--


--
-- Table structure for table `class_alias`
--

CREATE TABLE `class_alias` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `class_id` int(11) NOT NULL,
  `alias` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `class_alias`
--


--
-- Table structure for table `class_coordinators`
--

CREATE TABLE `class_coordinators` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `class_level_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `employee_id` (`employee_id`,`class_level_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `class_coordinators`
--


--
-- Table structure for table `class_electvie_exemption`
--

CREATE TABLE `class_electvie_exemption` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `class_id` int(11) DEFAULT NULL,
  `subject_id` int(3) DEFAULT NULL,
  `session_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `subject_id` (`subject_id`,`class_id`,`session_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `class_electvie_exemption`
--


--
-- Table structure for table `class_levels`
--

CREATE TABLE `class_levels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `level` varchar(60) NOT NULL,
  `rank` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `level` (`level`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `class_levels`
--

INSERT INTO `class_levels` VALUES (1,'JSS1',1),(2,'JSS2',2),(3,'JSS3',3),(4,'SSS1',4),(5,'SSS2',5),(6,'SSS3',6);

--
-- Table structure for table `class_promotions`
--

CREATE TABLE `class_promotions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `student_id` bigint(20) NOT NULL,
  `old_class_id` bigint(20) NOT NULL,
  `new_class_id` bigint(20) NOT NULL,
  `patron` varchar(40) NOT NULL,
  `remarks` varchar(40) DEFAULT NULL,
  `dateTime` datetime DEFAULT NULL,
  `session_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Unique Promotion` (`student_id`,`session_id`)
) ENGINE=InnoDB AUTO_INCREMENT=360 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `class_promotions`
--

INSERT INTO `class_promotions` VALUES (1,1,1,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:21:42',9),(2,2,9,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:22:29',9),(3,3,7,10,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:23:00',9),(4,4,1,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:23:27',9),(5,5,8,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:24:31',9),(6,6,9,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:24:51',9),(7,7,9,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:25:13',9),(8,8,7,10,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:25:38',9),(9,9,7,10,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:26:16',9),(10,10,7,10,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:26:44',9),(11,11,8,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:27:13',9),(12,12,9,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:27:48',9),(13,13,7,10,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:28:14',9),(14,14,1,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:28:43',9),(15,15,1,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:30:20',9),(17,17,9,7,'',NULL,NULL,9),(18,18,8,9,'',NULL,NULL,9),(19,19,7,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:35:07',9),(20,20,7,10,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:35:47',9),(21,21,8,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:36:16',9),(22,22,8,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:36:43',9),(23,23,1,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:37:10',9),(24,24,9,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:37:52',9),(25,25,1,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:38:21',9),(26,26,8,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:38:49',9),(27,27,8,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:40:26',9),(28,28,1,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:41:12',9),(29,29,9,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:41:39',9),(30,30,1,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:42:09',9),(31,31,8,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:42:39',9),(32,32,8,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:43:12',9),(33,33,1,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:43:46',9),(34,34,7,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:44:16',9),(35,35,7,10,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:44:47',9),(36,36,1,10,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:45:35',9),(37,37,9,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:46:03',9),(38,38,8,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:46:27',9),(39,39,9,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:47:17',9),(40,40,1,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:47:49',9),(41,41,1,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:48:16',9),(42,42,1,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:48:38',9),(43,43,9,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:49:00',9),(44,44,8,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:49:28',9),(45,45,7,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:49:55',9),(46,46,1,10,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:50:32',9),(47,47,9,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:50:56',9),(48,48,7,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:51:50',9),(49,49,8,10,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:52:38',9),(50,50,9,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:53:13',9),(51,51,8,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:53:39',9),(52,52,8,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:54:35',9),(53,53,9,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:55:35',9),(54,54,7,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:56:11',9),(55,55,7,10,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:56:59',9),(56,56,7,7,'',NULL,NULL,9),(57,57,7,10,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:59:03',9),(58,58,9,10,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 05:59:53',9),(59,59,7,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:01:09',9),(60,60,8,10,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:01:54',9),(61,61,8,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:02:34',9),(62,62,8,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:03:18',9),(63,63,9,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:03:58',9),(64,64,1,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:04:43',9),(65,65,1,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:06:34',9),(66,66,9,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:07:25',9),(67,67,9,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:08:06',9),(68,68,8,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:08:42',9),(69,69,9,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:09:25',9),(70,70,9,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:10:13',9),(71,71,7,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:11:05',9),(72,72,8,7,'',NULL,NULL,9),(73,73,9,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:12:34',9),(74,74,8,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:13:09',9),(75,75,8,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:13:54',9),(76,76,7,11,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:14:35',9),(77,77,1,10,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:15:27',9),(78,78,1,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:16:18',9),(79,79,1,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:17:17',9),(80,80,7,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:17:54',9),(81,81,7,10,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:18:52',9),(82,82,9,10,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:19:28',9),(83,83,1,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:20:09',9),(84,84,1,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:21:21',9),(85,85,7,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:21:53',9),(86,86,9,10,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:23:01',9),(87,87,1,13,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:23:52',9),(88,88,1,2,'Innocent Onyenezi Ezeme','Portal class update','2022-11-21 06:24:25',9),(176,1,2,2,'','promoted','2022-11-10 18:52:20',10),(177,2,13,13,'','promoted','2022-11-10 18:52:20',10),(178,3,2,10,'','promoted','2022-11-10 18:52:20',10),(179,4,2,2,'','promoted','2022-11-10 18:52:20',10),(180,5,2,11,'','promoted','2022-11-10 18:52:21',10),(181,6,13,13,'','promoted','2022-11-10 18:52:21',10),(182,7,13,13,'','promoted','2022-11-10 18:52:21',10),(183,8,2,10,'','promoted','2022-11-10 18:52:21',10),(184,9,2,10,'','promoted','2022-11-10 18:52:21',10),(185,10,2,10,'','promoted','2022-11-10 18:52:21',10),(186,11,2,11,'','promoted','2022-11-10 18:52:21',10),(187,12,13,13,'','promoted','2022-11-10 18:52:22',10),(188,13,2,10,'','promoted','2022-11-10 18:52:22',10),(189,14,2,2,'','promoted','2022-11-10 18:52:22',10),(190,15,2,2,'','promoted','2022-11-10 18:52:22',10),(191,17,2,10,'','promoted','2022-11-10 18:52:22',10),(192,18,13,13,'','promoted','2022-11-10 18:52:22',10),(193,19,2,11,'','promoted','2022-11-10 18:52:22',10),(194,20,2,10,'','promoted','2022-11-10 18:52:23',10),(195,21,2,11,'','promoted','2022-11-10 18:52:23',10),(196,22,2,11,'','promoted','2022-11-10 18:52:23',10),(197,23,2,11,'','promoted','2022-11-10 18:52:23',10),(198,24,2,2,'','promoted','2022-11-10 18:52:23',10),(199,25,13,13,'','promoted','2022-11-10 18:52:23',10),(200,26,2,2,'','promoted','2022-11-10 18:52:23',10),(201,27,2,11,'','promoted','2022-11-10 18:52:23',10),(202,28,2,11,'','promoted','2022-11-10 18:52:24',10),(203,29,2,2,'','promoted','2022-11-10 18:52:24',10),(204,30,13,13,'','promoted','2022-11-10 18:52:24',10),(205,31,2,2,'','promoted','2022-11-10 18:52:24',10),(206,32,2,11,'','promoted','2022-11-10 18:52:24',10),(207,33,2,11,'','promoted','2022-11-10 18:52:24',10),(208,34,2,2,'','promoted','2022-11-10 18:52:24',10),(209,35,2,10,'','promoted','2022-11-10 18:52:24',10),(210,36,2,10,'','promoted','2022-11-10 18:52:25',10),(211,37,2,2,'','promoted','2022-11-10 18:52:25',10),(212,38,13,13,'','promoted','2022-11-10 18:52:25',10),(213,39,2,11,'','promoted','2022-11-10 18:52:25',10),(214,40,13,13,'','promoted','2022-11-10 18:52:25',10),(215,41,2,2,'','promoted','2022-11-10 18:52:25',10),(216,42,2,2,'','promoted','2022-11-10 18:52:25',10),(217,43,2,2,'','promoted','2022-11-10 18:52:26',10),(218,44,13,13,'','promoted','2022-11-10 18:52:26',10),(219,45,2,11,'','promoted','2022-11-10 18:52:26',10),(220,46,2,10,'','promoted','2022-11-10 18:52:26',10),(221,47,2,2,'','promoted','2022-11-10 18:52:26',10),(222,48,13,13,'','promoted','2022-11-10 18:52:26',10),(223,49,2,10,'','promoted','2022-11-10 18:52:26',10),(224,50,2,11,'','promoted','2022-11-10 18:52:27',10),(225,51,13,13,'','promoted','2022-11-10 18:52:27',10),(226,52,2,11,'','promoted','2022-11-10 18:52:27',10),(227,53,2,11,'','promoted','2022-11-10 18:52:27',10),(228,54,13,13,'','promoted','2022-11-10 18:52:27',10),(229,55,2,10,'','promoted','2022-11-10 18:52:27',10),(230,56,2,10,'','promoted','2022-11-10 18:52:27',10),(231,57,2,10,'','promoted','2022-11-10 18:52:27',10),(232,58,2,10,'','promoted','2022-11-10 18:52:27',10),(233,59,13,13,'','promoted','2022-11-10 18:52:28',10),(234,60,2,10,'','promoted','2022-11-10 18:52:28',10),(235,61,2,11,'','promoted','2022-11-10 18:52:28',10),(236,62,2,11,'','promoted','2022-11-10 18:52:28',10),(237,63,2,11,'','promoted','2022-11-10 18:52:28',10),(238,64,13,13,'','promoted','2022-11-10 18:52:28',10),(239,65,2,2,'','promoted','2022-11-10 18:52:28',10),(240,66,2,2,'','promoted','2022-11-10 18:52:29',10),(241,67,13,13,'','promoted','2022-11-10 18:52:29',10),(242,68,13,13,'','promoted','2022-11-10 18:52:29',10),(243,69,2,11,'','promoted','2022-11-10 18:52:29',10),(244,70,13,13,'','promoted','2022-11-10 18:52:29',10),(245,71,13,13,'','promoted','2022-11-10 18:52:29',10),(246,72,2,10,'','promoted','2022-11-10 18:52:29',10),(247,73,2,11,'','promoted','2022-11-10 18:52:30',10),(248,74,13,13,'','promoted','2022-11-10 18:52:30',10),(249,75,2,11,'','promoted','2022-11-10 18:52:30',10),(250,76,2,11,'','promoted','2022-11-10 18:52:30',10),(251,77,2,10,'','promoted','2022-11-10 18:52:30',10),(252,78,2,2,'','promoted','2022-11-10 18:52:30',10),(253,79,2,2,'','promoted','2022-11-10 18:52:30',10),(254,80,2,2,'','promoted','2022-11-10 18:52:30',10),(255,81,2,10,'','promoted','2022-11-10 18:52:31',10),(256,82,2,10,'','promoted','2022-11-10 18:52:31',10),(257,83,13,13,'','promoted','2022-11-10 18:52:31',10),(258,84,2,2,'','promoted','2022-11-10 18:52:31',10),(259,85,2,2,'','promoted','2022-11-10 18:52:31',10),(260,86,2,10,'','promoted','2022-11-10 18:52:31',10),(261,87,13,13,'','promoted','2022-11-10 18:52:31',10),(262,88,2,2,'','promoted','2022-11-10 18:52:31',10),(263,89,1,1,'',NULL,NULL,10),(264,90,1,1,'',NULL,NULL,10),(265,91,1,8,'',NULL,NULL,10),(266,92,1,9,'',NULL,NULL,10),(267,93,1,8,'',NULL,NULL,10),(268,94,1,7,'',NULL,NULL,10),(269,95,1,8,'',NULL,NULL,10),(270,96,1,9,'',NULL,NULL,10),(271,97,1,7,'',NULL,NULL,10),(272,98,1,9,'',NULL,NULL,10),(273,99,1,8,'',NULL,NULL,10),(274,100,1,8,'',NULL,NULL,10),(275,101,1,9,'',NULL,NULL,10),(276,102,1,8,'',NULL,NULL,10),(277,103,1,1,'',NULL,NULL,10),(278,104,1,8,'',NULL,NULL,10),(279,105,1,8,'',NULL,NULL,10),(280,106,1,7,'',NULL,NULL,10),(281,107,1,1,'',NULL,NULL,10),(282,108,1,7,'',NULL,NULL,10),(283,109,1,8,'',NULL,NULL,10),(284,110,1,9,'',NULL,NULL,10),(285,111,1,9,'',NULL,NULL,10),(286,112,1,8,'',NULL,NULL,10),(287,113,1,1,'',NULL,NULL,10),(288,114,1,9,'',NULL,NULL,10),(289,115,1,8,'',NULL,NULL,10),(290,116,1,9,'',NULL,NULL,10),(291,117,1,8,'',NULL,NULL,10),(292,118,1,7,'',NULL,NULL,10),(293,119,1,9,'',NULL,NULL,10),(294,120,1,7,'',NULL,NULL,10),(295,121,1,1,'',NULL,NULL,10),(296,122,1,1,'',NULL,NULL,10),(297,123,1,1,'',NULL,NULL,10),(298,124,1,1,'',NULL,NULL,10),(299,125,1,1,'',NULL,NULL,10),(300,126,1,1,'',NULL,NULL,10),(301,127,1,7,'',NULL,NULL,10),(302,128,1,8,'',NULL,NULL,10),(303,129,1,9,'',NULL,NULL,10),(304,130,1,7,'',NULL,NULL,10),(305,131,1,1,'',NULL,NULL,10),(306,132,1,8,'',NULL,NULL,10),(307,133,1,1,'',NULL,NULL,10),(308,134,1,8,'',NULL,NULL,10),(309,135,1,8,'',NULL,NULL,10),(310,136,1,7,'',NULL,NULL,10),(311,137,1,1,'',NULL,NULL,10),(312,138,1,7,'',NULL,NULL,10),(313,139,1,7,'',NULL,NULL,10),(314,140,1,7,'',NULL,NULL,10),(315,141,1,7,'',NULL,NULL,10),(316,142,1,1,'',NULL,NULL,10),(317,143,1,9,'',NULL,NULL,10),(318,144,1,9,'',NULL,NULL,10),(319,145,1,7,'',NULL,NULL,10),(320,146,1,1,'',NULL,NULL,10),(321,147,1,1,'',NULL,NULL,10),(322,148,1,7,'',NULL,NULL,10),(323,149,1,1,'',NULL,NULL,10),(324,150,1,9,'',NULL,NULL,10),(325,151,1,1,'',NULL,NULL,10),(326,152,1,9,'',NULL,NULL,10),(327,153,1,7,'',NULL,NULL,10),(328,154,1,8,'',NULL,NULL,10),(329,155,1,8,'',NULL,NULL,10),(330,156,1,7,'',NULL,NULL,10),(331,157,1,9,'',NULL,NULL,10),(332,158,1,9,'',NULL,NULL,10),(333,159,1,7,'',NULL,NULL,10),(334,160,1,1,'',NULL,NULL,10),(335,161,1,7,'',NULL,NULL,10),(336,162,1,7,'',NULL,NULL,10),(337,163,1,1,'',NULL,NULL,10),(338,164,1,1,'',NULL,NULL,10),(339,165,1,7,'',NULL,NULL,10),(340,166,1,9,'',NULL,NULL,10),(341,167,1,1,'',NULL,NULL,10),(342,168,1,9,'',NULL,NULL,10),(343,169,1,9,'',NULL,NULL,10),(344,170,1,8,'',NULL,NULL,10),(345,171,1,7,'',NULL,NULL,10),(346,172,1,9,'',NULL,NULL,10),(347,173,1,8,'',NULL,NULL,10),(348,174,1,9,'',NULL,NULL,10),(349,175,1,9,'',NULL,NULL,10),(350,176,1,9,'',NULL,NULL,10),(351,177,1,1,'',NULL,NULL,10),(352,178,1,7,'',NULL,NULL,10),(353,179,1,7,'',NULL,NULL,10),(354,180,1,8,'',NULL,NULL,10),(355,181,1,8,'',NULL,NULL,10),(356,182,1,9,'',NULL,NULL,10),(359,184,8,8,'',NULL,NULL,10);

--
-- Table structure for table `class_sections`
--

CREATE TABLE `class_sections` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `section` varchar(30) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sections` (`section`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `class_sections`
--

INSERT INTO `class_sections` VALUES (1,'A'),(2,'B'),(3,'C'),(4,'D');

--
-- Table structure for table `class_session_teachers`
--

CREATE TABLE `class_session_teachers` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `class_id` int(2) DEFAULT NULL,
  `employee_id` int(3) DEFAULT NULL,
  `session_id` int(2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Unique session teacher` (`class_id`,`session_id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `class_session_teachers`
--

INSERT INTO `class_session_teachers` VALUES (1,1,19,9),(2,2,0,9),(3,3,0,9),(4,4,0,9),(5,5,0,9),(6,6,0,9),(7,7,14,9),(8,8,4,9),(9,9,6,9),(10,10,0,9),(11,11,0,9),(12,0,0,9),(13,2,8,10),(14,10,27,10),(15,11,9,10),(16,13,21,10),(17,9,6,10),(18,7,14,10),(19,1,19,10),(20,8,4,10),(29,3,0,10),(30,14,0,10),(31,15,0,10),(32,16,0,10),(33,4,0,10),(34,17,0,10),(35,18,0,10),(36,19,0,10),(37,5,0,10),(38,20,0,10),(39,21,0,10),(40,22,0,10),(41,6,0,10),(42,23,0,10),(43,24,0,10),(44,25,0,10);

--
-- Table structure for table `class_subjects`
--

CREATE TABLE `class_subjects` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `class_id` bigint(20) NOT NULL,
  `subject_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `class_subjects`
--


--
-- Table structure for table `classes`
--

CREATE TABLE `classes` (
  `id` int(3) unsigned NOT NULL AUTO_INCREMENT,
  `level` varchar(40) NOT NULL,
  `level_id` smallint(11) NOT NULL,
  `room_id` smallint(4) NOT NULL,
  `teacher_id` smallint(5) NOT NULL DEFAULT '0' COMMENT 'employeeID',
  `teacher_id2` smallint(6) DEFAULT NULL,
  `is_special` enum('1','0') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `level` (`level`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `classes`
--

INSERT INTO `classes` VALUES (1,'JSS 1A',1,1,19,0,'0'),(2,'JSS2A',2,1,8,0,'0'),(3,'JSS 3A',3,3,0,0,'0'),(4,'SSS 1A',4,4,0,0,'0'),(5,'SSS 2A',5,5,0,0,'0'),(6,'SSS 3A',6,6,0,0,'0'),(7,'JSS 1B',1,1,14,NULL,'0'),(8,'JSS 1C',1,1,4,NULL,'0'),(9,'JSS 1D',1,1,6,NULL,'0'),(10,'JSS 2B',2,2,27,NULL,'0'),(11,'JSS 2C',2,2,9,NULL,'0'),(13,'JSS 2D',2,2,21,NULL,'0'),(14,'JSS 3B',3,3,0,0,'0'),(15,'JSS 3C',3,3,0,0,'0'),(16,'JSS 3D',3,3,0,0,'0'),(17,'SSS 1B',4,4,0,0,'0'),(18,'SSS 1C',4,4,0,0,'0'),(19,'SSS 1D',4,4,0,0,'0'),(20,'SSS 2B',5,5,0,0,'0'),(21,'SSS 2C',5,5,0,0,'0'),(22,'SSS 2D',5,5,0,0,'0'),(23,'SSS 3B',6,6,0,0,'0'),(24,'SSS 3C',6,6,0,0,'0'),(25,'SSS 3D',6,6,0,0,'0');

--
-- Table structure for table `client`
--

CREATE TABLE `client` (
  `client_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `client`
--


--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `sender` varchar(60) NOT NULL,
  `students_id` int(5) unsigned NOT NULL DEFAULT '0',
  `date` date NOT NULL,
  `subject` varchar(200) NOT NULL,
  `content` text NOT NULL,
  `term_id` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Unique Student Comment` (`sender`,`students_id`,`date`,`subject`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` VALUES (1,'Ms. ACHILIKE NKECHI DORIS',94,'2022-12-07','Class activity','<div>Karo is a smart, intelligent and respectful student. He is friendly and relates well with his classmates. He shows remorse and takes correction whenever he is convicted of any wrong doing. He demonstrates grit towards achieving academic excellence. He is generally good in sporting activities like sprints and football. He is the class games prefect.&nbsp;&nbsp;</div><div>He is encouraged to keep improving on his personal cleanliness and work on his tendency of being disorganized in class.</div>',29),(8,'Ms. ACHILIKE NKECHI DORIS',97,'2022-12-07','Class activity','Amanda is a brilliant, calm and well behaved student. She is hardworking, academically focused and goal oriented. She has huge quest for knowledge and brings a lot of experience in the class outside the normal classroom experiences. She carries out any responsibility given to her well and participates actively in other school activities like debates and singing. She is kind hearted and demonstrate such by willfully helping out some of her class mates who may be struggling in one way or the other academically to the best of her ability. She is the assistant class prefect. She is encouraged to keep up her academic enthusiasm for better performances, be more resilient and work on her tendency of being easily worked up over little things.&nbsp;',29),(11,'Mr. NWABICHIE OBIORA EMMANUEL',5,'2022-12-09','Class activity','Chidubem is a smart and intelligent student who puts\r\nforth his best effort in his assignments and class work. He is an enthusiastic\r\nlearner who enjoy school.\r\nHe talks to everyone with a sense of respect and gentleness. He is neat, obedient,\r\nand transits\r\neasily between classroom activities without distraction. However, needs to double his\r\neffort in staying focused during classes. He really needs to channel more of\r\nhis time and energy into his studies, and learn to manage better his time during\r\nstudies.',29),(12,'Mr. NWABICHIE OBIORA EMMANUEL',11,'2022-12-09','Class activity','Daluchi is a conscientious, self-motivated, and hard-working\r\nstudent. She is a caring and\r\nloving, intelligent, smart, and selfless girl. She accepts her setbacks and\r\nwith her determination she will continue to be a strong force to contend with.\r\nShe is presently the class prefect, and this comes with more responsibilities. She\r\nneeds to work harder on her time management skills, confidence, and\r\nself-discipline. As the class prefect she needs to carry out her duties with\r\nfairness and equity.',29),(14,'Mr. NWABICHIE OBIORA EMMANUEL',19,'2022-12-09','Class activity','<span>Kamsi is a brilliant and smart student. He listens attentively in\r\nclass and responds to what has been read or discussed in class and at group\r\nwork. He is honest and straightforward. He is a craftsman, very good with his hands, and\r\nsometimes, it distracts him from following up with the class learning. He needs\r\nto learn to build up a solid foundation in terms of putting more efforts in\r\nstudies, and avoid distractions when learning is going on.&nbsp; </span>',29),(16,'Mr. NWABICHIE OBIORA EMMANUEL',21,'2022-12-09','Class activity','Chidubem is a brilliant and wise student. He prepares well for\r\nclass each day and works at an appropriate pace, neither too quickly or slowly.\r\nHe works independently, displays self-discipline, respect, good comportment\r\nduring learning, and class meetings. But he needs to learn to share some of his time with his classmates by\r\nimproving in his social interactions with his peers. This will certainly give\r\nhim more confidence to interact freely with others in class and contribute meaningfully\r\nduring class discussions.',29),(21,'Mr. NWABICHIE OBIORA EMMANUEL',22,'2022-12-09','Class activity','Bunienna is a determined, confident, and bold student.\r\nHe likes setting goals/targets for himself in each subject. He directs his\r\nenergy just to make a point. He is proud of his achievements and cannot be\r\neasily intimated by anyone both in class work and extracurricular activities.\r\nHe loves team work especially when it comes to creativity, brainstorming, and\r\nsports. He needs to learn to accept the recommendations of his peers and acts on them when\r\nappropriate. He is encouraged to be more sensitive to the thoughts and opinions\r\nof others in the class, stay\r\nfocused during learning, build up his self-discipline and respect for people.',29),(24,'Mr. NWABICHIE OBIORA EMMANUEL',23,'2022-12-09','Class activity','Clare is special, curious and intelligent student. She\r\nhas an impressive\r\nunderstanding and depth of knowledge about her own interest. She seeks\r\nadditional information independently from teachers and peers about classroom\r\ntopics that pique her interest. She regularly volunteers to assist in classroom\r\nactivities, and accepts recommendations from her peers. She loves to multitask, and always asks for\r\nclarification when needed. She losses focus in class, is unable to arrange her\r\nclass materials (textbooks and notebooks), locker, table and chair. She needs\r\nto learn how to take one task at a time, be more focused on managing her time\r\nin relation to her activity. She is encouraged to work more on her\r\nself-discipline and class work responsibilities.',29),(27,'Mr. NWABICHIE OBIORA EMMANUEL',27,'2022-12-09','Class activity','Chinkemka is an enthusiastic learner who exhibits\r\npositive outlook and attitude in the classroom. He appears well rested and\r\nready for each day’s activities. He is smart, confident, bold, and eager to\r\nlearn. He is one of the neatest students in the class. He is a talented\r\nfootball player and school house prefect (Captain male) for Xavier house.\r\nHowever, he needs to be more aware of his responsibilities and focus on his\r\nstudies. He should concentrate more during class learning rather than\r\ndistracting himself and his peers.',29),(31,'Mr. NWABICHIE OBIORA EMMANUEL',28,'2022-12-09','Class activity','Nathan is a conscientious, hardworking student who is\r\ndetermined to achievie his goals. He is attentive and quiet during class\r\ninteraction, and contributes during group work and assignments.&nbsp; He is confident, proud of his origin and\r\nculture, honest and sincere with his peers and teachers. He is determined to be\r\namong the top best students in the college. He is good with asking questions\r\nduring class interactions, class meetings and assembly. However, he gets\r\ncarried away or lost in thought during class interaction. He needs to keep his\r\nmind and thought together during class and avoid all forms of distraction both\r\nfrom friends and himself. He should learn to accept corrections from teachers\r\nand peers rather than getting angry and moody.',29),(35,'Mr. NWABICHIE OBIORA EMMANUEL',32,'2022-12-09','Class activity','Valour is a smart,\r\nintelligent, self-motivated student who puts forth his best effort into his\r\nclasswork. He is outspoken, respectful, and happy. He sets goals for himself,\r\nand has positive optimistic attitude to life. He takes active role in class\r\ndiscussion and work. &nbsp;He dresses neatly\r\nand likes sports and storytelling. However, he needs to work on his temper and\r\nis encourage to learn to accept other students the way they are, take corrections\r\nand recommendations from both teachers and his peers gladly.',29),(36,'Mr. NWABICHIE OBIORA EMMANUEL',33,'2022-12-09','Class activity','Zikorachukwu is a brilliant, enthusiastic learner who\r\nseems to like school. She is courteous and well behaved during classes. She\r\nappears well rested and ready for each day’s activities and exhibits this\r\npositive outlook and attitude towards learning. However, she should work and\r\nfocus more on her studies, time management skills, and confidence during class.\r\nShe should turn down the attitude of been shy and feel free to ask questions\r\nduring class interaction and study hall.',29),(39,'Mr. NWABICHIE OBIORA EMMANUEL',39,'2022-12-09','Class activity','Erika is humble, selfless, focused, confident, goal driven,\r\nand competent. She is attentive in class and makes useful contribution during\r\nclass activities. She has a vibrant imagination and expresses ideas clearly\r\nboth verbally and in writing. She is the school house prefect (Captain female)\r\nfor Xavier house. However, she needs to be more aware of the expected\r\nresponsibilities associated with her position, and the fact that caring for\r\nothers (her peers) that needs help is a way of learning to be compassionate,\r\nand competent. She can achieve this by learning how to manage her time, build\r\nher self-discipline and confidence.',29),(41,'Mr. NWABICHIE OBIORA EMMANUEL',45,'2022-12-10','Class activity','Nnamdi is a brilliant and clever student. He is\r\nenthusiastic about learning and class work. He listens attentively in class and\r\nplays an active role in group discussions. He is selfless, humble, neat, and\r\nrespectful student. However, he needs to put his personal studies first, and\r\navoid distracting himself and others during class interaction and study time.\r\nHe is encouraged to learn how to organize himself, and manage his transition time\r\nbetween classes. He should work more on his self-discipline, and time\r\nmanagement skills especially during study hall.',29),(50,'Mr. NWABICHIE OBIORA EMMANUEL',50,'2022-12-10','Class activity','Stephanie is intelligent, brilliant, kind, and\r\nresponsible girl. She is focused and does her assignments on time. She is eager\r\nto learn and loves to study at any given time. She has a good sense of humour,\r\nan impressive understanding and depth of knowledge about her interest. She is\r\nwilling to help any of her classmate that comes to her for anything. She needs\r\nto learn to overcome being shy and build friendship that will benefit her\r\npositively. She is encouraged to learn to stand firm in doing the right thing,\r\nand avoid peer influence especially with regards to her studies.',29),(53,'Mr. NWABICHIE OBIORA EMMANUEL',52,'2022-12-10','Class activity','Donald is smart, brilliant, calm, gentle and punctual\r\nto classes. He has a good sense of humour, is eager to learn, and likes been in\r\nschool. He makes good use of his transition time between classes. He interacts\r\nwith his peers freely during group work and takes note of what is shared. He is\r\na good soccer player, and one of those that represents the house in sports.\r\nHowever, he gets easily distracted during class work. He is encouraged to use\r\nthe time for siesta and lights out time to catch enough sleep in order to avoid\r\nsleeping during classes.&nbsp; He should work\r\nmore on his time management skills and building self-confidence.',29),(58,'Mr. NWABICHIE OBIORA EMMANUEL',53,'2022-12-10','Class activity','Michael is an enthusiastic learner who likes school.\r\nHe is confident, brilliant, smart, and dedicated student. He has initiative and\r\nlooks for new ways to get involved. He puts more efforts in his studies, especially\r\non subjects that are challenging to him. He is full of hope, and he never gives\r\nup believing that he can do better. Michael is a skillful footballer, an actor,\r\nand a good dancer. He is truthful and honest with himself and to his peers,\r\nencouraging everyone to keep to the schools’ rules. But he needs to work hard\r\non his handwriting, stay focused during class interaction and avoid sleeping\r\nduring class interaction. He needs to complete his assignments/project\r\ncorrectly and on time.',29),(63,'Mr. NWABICHIE OBIORA EMMANUEL',61,'2022-12-10','Class activity','Kristos is a conscientious, self-motivated, and\r\nhardworking student. He is intelligent, smart, and brilliant. He is\r\nenthusiastic about participating in class work and group sharing. He puts in\r\nmore effort and determination in learning in class. He is a skillful soccer\r\nplayer. He is distracted during classes, noisy and likes distracting others.\r\nHowever, he needs to focus more in class and avoid all forms of distraction if\r\nhe wants to improve in his grades. He is encourage to learn how to control and\r\nmanage his temper.',29),(64,'Mr. NWABICHIE OBIORA EMMANUEL',62,'2022-12-10','Class activity','Flora is an intelligent, smart and dedicated student\r\nwho is enthusiastic about learning. She is proactive in class, ready to learn\r\nsomething new based on her interest. In group work and sharing, she likes to\r\ncarry everyone along. She is humble and does not select those she can learn or\r\nwork with her. She is full of creative thoughts based on how she presents her\r\nquestions during class lessons. However, she needs to keep her self-discipline\r\nin check, and remain committed and honest with her work. She is encouraged to\r\nwork on her time management skills in relations to her activities.',29),(66,'Mr. NWABICHIE OBIORA EMMANUEL',63,'2022-12-10','Class activity','Ada is a brilliant, smart and dedicated student. She\r\nis neat, eager to learn and willing to take instructions from teachers. She\r\nappears well rested and ready for each day’s activities. Ada is a hardworking\r\nstudent, but has difficulty staying on task and completing her class work and\r\nassignments. She should learn to be open minded to accepting corrections or\r\ninstructions from teachers rather than getting angry and moody. Ada needs to\r\nwork on participating during social events and sports.',29),(67,'Mr. NWABICHIE OBIORA EMMANUEL',69,'2022-12-11','Class activity','Chidimma is brilliant, smart, honest, and selfless\r\nstudent. She is a conscientious, hardworking, self-motivated student. She is an\r\nenthusiastic learner who plays active role in group discussions. She makes\r\nfriends quickly in class and is well-liked by her classmate. She has difficulty\r\nconcentrating during class interaction and gets distracted easily. She needs to\r\nwork on her time management skills and self-discipline. She is encouraged to\r\norganize herself by making use of the transition time.',29),(70,'Mr. NWABICHIE OBIORA EMMANUEL',73,'2022-12-11','Class activity','Ifechukwu is clever, hardworking, intelligent, and\r\nsmart student. She has a good sense of humour, good with calculations and\r\nscience and likes reading anytime she gets the opportunity. She is attentive in\r\nclass and is eager to ask questions on specific area which is not clear to her.\r\nShe gets along well with other classmates, and likes suggesting topics for\r\nsharing during class discussions/guardians. She should learn to manage her\r\ntime, remain firm and focus with her studies. She should work on her self-discipline\r\nand respect for her peers.',29),(73,'Mr. NWABICHIE OBIORA EMMANUEL',75,'2022-12-11','Class activity','Takim is an enthusiastic learner who loves to be in\r\nschool. He is determined and eager to learn, sensitive to the thoughts and\r\nopinion of others during group work and class discussion. He is a music lover,\r\nand loves to sing in the choir. He has difficult time concentrating, gets\r\ndistracted easily, and he tends to be noisy and playful. He has difficulty time\r\nstaying on task and completing his classwork and assignments. He needs to organize\r\nhimself by working on his time management skills especially during study hall.',29),(76,'Mr. NWABICHIE OBIORA EMMANUEL',76,'2022-12-11','Class activity','Demilade is a quiet, intelligent, brilliant, smart,\r\nand determined student. He is an enthusiastic learner who is attentive in class\r\nand contributes to classwork and group discussions. He is able to transits\r\nbetween classroom activities without causing distractions. He sets example of\r\nexcellence in behaviour and cooperation. He is the sanitation/assignment\r\nprefect of the class. He needs to work on his self-confidence, shyness, and\r\ntime management skills. He is encouraged to stay focused and avoid distractions\r\nespecially during the study hall period. He needs to be firm in his personal\r\nbelief and values.',29),(78,'Revocube Support',90,'2022-12-12','Class Activity','The student is performing well',NULL),(79,'Innocent Onyenezi Ezeme',89,'2022-12-14','STUDENT\'S SELF EVALUATION','Socially: I socialize with people often but sometimes people annoy me and I get very angry and snob the person. I need to learn to tolerate other people and other characters to help me to be socially stable.\r\nAcademically: I am actually not bad at it but I have issues focusing during study hall. But right now I caution myself and I remember my goal and it has helped me.\r\nMorally: I am not so perfect morally because I get punished a lot but I will try and keep finding new solutions to the problems, especially lateness.\r\n',NULL),(80,'Innocent Onyenezi Ezeme',89,'2022-12-14','TEACHER\'S COMMENT','W8X1SAZY',NULL),(81,'Innocent Onyenezi Ezeme',89,'2022-12-14','HOUSE MASTER\'S COMMENTS','W8X1SAZY',NULL);

--
-- Table structure for table `compound_subject_structure`
--

CREATE TABLE `compound_subject_structure` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `compound_subject_id` tinyint(2) DEFAULT NULL,
  `subject_id` tinyint(2) DEFAULT NULL,
  `ce1` tinyint(3) DEFAULT NULL,
  `ce2` tinyint(3) DEFAULT NULL,
  `ca1` tinyint(3) DEFAULT NULL,
  `ce3` tinyint(3) DEFAULT NULL,
  `ce4` tinyint(3) DEFAULT NULL,
  `ca2` tinyint(3) DEFAULT NULL,
  `as1` tinyint(3) DEFAULT NULL,
  `as2` tinyint(3) DEFAULT NULL,
  `ce5` tinyint(3) DEFAULT NULL,
  `pr` tinyint(3) DEFAULT NULL,
  `as3` tinyint(3) DEFAULT NULL,
  `exam` tinyint(3) DEFAULT NULL,
  `class_level_id` tinyint(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `compound_subject_id` (`compound_subject_id`,`subject_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `compound_subject_structure`
--


--
-- Table structure for table `compound_subjects`
--

CREATE TABLE `compound_subjects` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `main_subject_id` tinyint(4) DEFAULT NULL,
  `sub_subjetct_ids` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `compound_subjects`
--


--
-- Table structure for table `course_reg`
--

CREATE TABLE `course_reg` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `subject_id` tinyint(3) NOT NULL,
  `student_id` tinyint(3) NOT NULL,
  `session_id` tinyint(2) NOT NULL,
  `position` tinyint(2) NOT NULL,
  `class_id` tinyint(2) NOT NULL,
  `teacher_id` tinyint(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Unique Course Reg` (`subject_id`,`student_id`,`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `course_reg`
--


--
-- Table structure for table `cron_refresh`
--

CREATE TABLE `cron_refresh` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `class_id` tinyint(3) NOT NULL,
  `term_id` tinyint(3) NOT NULL,
  `status` binary(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_status` (`class_id`,`term_id`)
) ENGINE=InnoDB AUTO_INCREMENT=684 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `cron_refresh`
--

INSERT INTO `cron_refresh` VALUES (153,1,27,_binary '1'),(154,7,27,_binary '1'),(155,8,27,_binary '1'),(184,1,28,_binary '1'),(185,7,28,_binary '1'),(188,8,28,_binary '1'),(191,9,28,_binary '1'),(195,9,27,_binary '1'),(196,1,26,_binary '1'),(197,7,26,_binary '1'),(198,8,26,_binary '1'),(199,9,26,_binary '1'),(676,1,29,_binary '1'),(677,7,29,_binary '1'),(678,8,29,_binary '1'),(679,9,29,_binary '1'),(680,2,29,_binary '1'),(681,10,29,_binary '1'),(682,11,29,_binary '1'),(683,13,29,_binary '1');

--
-- Table structure for table `default_performance`
--

CREATE TABLE `default_performance` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `session_id` bigint(20) NOT NULL,
  `test1` double(5,2) DEFAULT NULL,
  `test2` double(5,2) DEFAULT NULL,
  `test3` double(5,2) DEFAULT NULL,
  `test4` double(5,2) DEFAULT NULL,
  `test5` double(5,2) DEFAULT NULL,
  `test6` double(5,2) DEFAULT NULL,
  `test7` double(5,2) DEFAULT NULL,
  `test8` double(5,2) DEFAULT NULL,
  `test9` double(5,2) DEFAULT NULL,
  `test10` double(5,2) DEFAULT NULL,
  `ca1` double NOT NULL,
  `ca2` double NOT NULL,
  `midTerm` double NOT NULL,
  `exam` double NOT NULL,
  `passMark` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
