CREATE TABLE `result_subject_group_assign` (
  `result_subject_group_assign_id` int(11) NOT NULL AUTO_INCREMENT,
  `result_subject_group_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  PRIMARY KEY (`result_subject_group_assign_id`),
  KEY `result_subject_group_id` (`result_subject_group_id`,`subject_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `result_subject_groups` (
  `result_subject_group_id` int(11) NOT NULL AUTO_INCREMENT,
  `result_subject_group_name` varchar(300) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`result_subject_group_id`),
  UNIQUE KEY `result_subject_group_name` (`result_subject_group_name`),
  KEY `date_created` (`date_created`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `salary_deduct` (
  `salary_deduct_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `reason` varchar(400) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  `months` varchar(30) NOT NULL,
  PRIMARY KEY (`salary_deduct_id`),
  KEY `staff_id` (`staff_id`),
  KEY `sessions` (`sessions`),
  KEY `terms` (`terms`),
  KEY `months` (`months`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `salary_info` (
  `salary_info_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `current_salary` decimal(15,2) NOT NULL,
  `past_debt` decimal(15,2) NOT NULL,
  `amount_to_pay` decimal(15,2) NOT NULL,
  `amount_paid` decimal(15,2) NOT NULL,
  `wave_over` decimal(15,2) NOT NULL,
  `current_debt` decimal(15,2) NOT NULL,
  `deduct` decimal(15,2) NOT NULL,
  `appreciation_amount` decimal(15,2) NOT NULL,
  `appreciation_reason` varchar(500) NOT NULL,
  `owing` decimal(15,2) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  `months` varchar(30) NOT NULL,
  PRIMARY KEY (`salary_info_id`),
  KEY `staff_id` (`staff_id`),
  KEY `sessions` (`sessions`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `salary_payment` (
  `salary_payment_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `accountant_id` int(10) unsigned NOT NULL,
  `amount_paid` decimal(15,2) NOT NULL,
  `staff_name` varchar(200) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  `months` varchar(30) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`salary_payment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `school_fees` (
  `school_fees_id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` char(20) NOT NULL,
  `student_id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `school_fees_payment_mode_id` int(11) NOT NULL,
  `payment_mode` varchar(300) NOT NULL,
  `staff_name` varchar(200) NOT NULL,
  `amount_paid` decimal(15,2) NOT NULL,
  `payment_no` varchar(20) NOT NULL,
  `payment_date` date NOT NULL,
  `fees_status` varchar(20) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(10) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`school_fees_id`),
  KEY `sessions` (`sessions`),
  KEY `terms` (`terms`),
  KEY `transaction_id` (`transaction_id`),
  KEY `school_fees_payment_mode_id` (`school_fees_payment_mode_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `school_fees_payment_modes` (
  `school_fees_payment_mode_id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_mode` varchar(300) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`school_fees_payment_mode_id`),
  UNIQUE KEY `payment_mode` (`payment_mode`),
  KEY `date_created` (`date_created`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `school_storages` (
  `school_storage_id` int(11) NOT NULL AUTO_INCREMENT,
  `school_storage_title` varchar(200) NOT NULL,
  `school_storage_dir` varchar(500) NOT NULL,
  `school_storage_date` datetime NOT NULL,
  PRIMARY KEY (`school_storage_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `sent_sms` (
  `sent_sms_id` int(11) NOT NULL AUTO_INCREMENT,
  `unit_spent` varchar(300) NOT NULL,
  `message` text NOT NULL,
  `people` text NOT NULL,
  `date_sent` datetime NOT NULL,
  PRIMARY KEY (`sent_sms_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `session_month` (
  `session_month_id` int(11) NOT NULL AUTO_INCREMENT,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  `months` varchar(30) NOT NULL,
  PRIMARY KEY (`session_month_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `session_term` (
  `session_term_id` int(11) NOT NULL AUTO_INCREMENT,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  PRIMARY KEY (`session_term_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;


INSERT INTO session_term VALUES
("4","2020/2021","1st Term"),
("5","2020/2021","2nd Term");




CREATE TABLE `sessions` (
  `sid` varchar(40) NOT NULL,
  `expiry` int(10) unsigned NOT NULL,
  `data` text NOT NULL,
  `date_added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;






CREATE TABLE `settings` (
  `settings_id` int(11) NOT NULL AUTO_INCREMENT,
  `setting_name` varchar(300) NOT NULL,
  `setting_value` varchar(300) NOT NULL,
  PRIMARY KEY (`settings_id`),
  KEY `setting_name` (`setting_name`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=latin1;


INSERT INTO settings VALUES
("1","total_sms","100"),
("2","school_name","ELMOT INTERNATIONAL SCHOOL"),
("3","school_login_logo","assets/images/logo.png"),
("4","login_attempt","30"),
("5","holiday_project","yes"),
("6","cumulate_test","yes"),
("7","show_test","yes"),
("8","show_waec","yes"),
("9","show_neco","yes"),
("10","lower_ca_score","30"),
("11","lower_exam_score","70"),
("12","school_phonenumber","2340000000000"),
("13","teacher_subclass","yes"),
("14","country","NIGERIA"),
("15","country_code","234"),
("16","phonenumber_length","10"),
("17","full_phonenumber_length","11"),
("18","main_phonenumber_length","13"),
("19","one_sms_amount","3"),
("20","result_cumulative","yes"),
("21","result_school_fees","no"),
("22","school_address","1ST AVENUE, 1(K) CRESCENT, SECTOR F FHA-LUGBE, ABUJA"),
("23","principal_finance","no"),
("24","one_card_amount","1000"),
("25","principal_name","SCHOOL HEAD"),
("26","principal_signature","images/principal_signatures/f31fff.jpg"),
("27","third_term_lower","no"),
("28","third_term_higher","no"),
("29","allow_finance","no"),
("30","order_class","no"),
("31","online_school_fees_payment","no"),
("32","sms_sender","NO NAME"),
("33","school_email","school@mail.com"),
("34","school_email_password","DÓ¬øÇÍÕ³J©A#ÏÌÏ"),
("35","school_email_name","School Name"),
("36","scratch_card","no"),
("37","higher_ca_score","30"),
("38","higher_exam_score","70"),
("39","class_approval","no"),
("40","allow_hostel","no"),
("41","result_attendance","no"),
("42","second_principal_signature",""),
("43","lower_no_of_ca","1"),
("44","higher_no_of_ca","1"),
("45","lower_ca1","40"),
("46","lower_ca2","0"),
("47","lower_ca3","0"),
("48","lower_ca4","0"),
("49","lower_ca5","0"),
("50","lower_ca6","0"),
("51","higher_ca1","40"),
("52","higher_ca2","0"),
("53","higher_ca3","0"),
("54","higher_ca4","0"),
("55","higher_ca5","0"),
("56","higher_ca6","0"),
("57","lower_ca_name_1","CA"),
("58","lower_ca_name_2","CA 2"),
("59","lower_ca_name_3","CA 3"),
("60","lower_ca_name_4","CA 4"),
("61","lower_ca_name_5","CA 5"),
("62","lower_ca_name_6","CA 6"),
("63","higher_ca_name_1","CA"),
("64","higher_ca_name_2","CA 2"),
("65","higher_ca_name_3","CA 3"),
("66","higher_ca_name_4","CA 4"),
("67","higher_ca_name_5","CA 5"),
("68","higher_ca_name_6","CA 6"),
("69","lower_exam_name","Exam"),
("70","higher_exam_name","Exam"),
("71","main_school_id","1"),
("72","school_id","1"),
("73","school_storage","yes"),
("74","class_storage","yes"),
("75","class_teacher_comment_setting","yes"),
("76","student_affairs","no"),
("77","admission_number","no"),
("78","admission_format",""),
("79","paystack_subaccount","ACCT_t3w6pmnwzvmv2np"),
("80","currency","&#8358;"),
("81","annual_position_for_last_term","yes"),
("82","annual_only_last_subjects","no"),
("83","parent_finance","yes"),
("84","third_term_in_annual","no"),
("85","admin_class_check_result","yes"),
("86","refresh_token","1//050SH4EtODsccCgYIARAAGAUSNwF-L9Irppe_Bv2rl35Mkj_CsbQEnCFFKltUjnWiPalTUqfLeXyBcZNM05DkpzD5NJ3CFyfFfUM"),
("87","folder_id",""),
("88","google_client_id","150277175744-n19rn2vsuio1lt7ot1cirgvfp3ehjp2l.apps.googleusercontent.com"),
("89","google_client_secret","eTWa1cXmNcG-Ky2h32o7bv4n"),
("90","online_class","no"),
("91","payment_warning","no"),
("92","instalmental_payment","yes"),
("93","classroom_materials","no");




CREATE TABLE `sms_account` (
  `sms_account_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `transaction_id` varchar(20) NOT NULL,
  `unit_bought` int(10) unsigned NOT NULL,
  `amount` varchar(20) NOT NULL,
  `status` varchar(20) NOT NULL,
  `mode` varchar(20) NOT NULL,
  `date_bought` datetime NOT NULL,
  PRIMARY KEY (`sms_account_id`),
  UNIQUE KEY `transaction_id` (`transaction_id`),
  KEY `mode` (`mode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `staff` (
  `staff_id` int(11) NOT NULL AUTO_INCREMENT,
  `school_id` int(10) unsigned NOT NULL,
  `user_key` varchar(100) DEFAULT NULL,
  `serial_number` varchar(200) NOT NULL,
  `pass` varchar(255) NOT NULL,
  `first_password` varchar(200) NOT NULL,
  `new_password` varchar(255) NOT NULL,
  `first_name` varchar(200) NOT NULL,
  `other_name` varchar(200) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `gender` varchar(10) NOT NULL,
  `status` varchar(50) NOT NULL,
  `groups` varchar(20) NOT NULL,
  `position` varchar(200) NOT NULL,
  `student_affairs` varchar(20) NOT NULL,
  `address` varchar(200) NOT NULL,
  `dob` date NOT NULL,
  `phone_number` bigint(20) unsigned NOT NULL,
  `email` varchar(200) NOT NULL,
  `country` varchar(200) NOT NULL,
  `state_origin` varchar(200) NOT NULL,
  `religion` varchar(50) NOT NULL,
  `disability` varchar(300) NOT NULL,
  `passport` varchar(200) NOT NULL,
  `form` varchar(5) NOT NULL,
  `sent_serial_pass_sms` char(3) NOT NULL,
  `forget_token` varchar(200) NOT NULL,
  `login_attempt` int(11) NOT NULL,
  `login_last_time` int(11) unsigned NOT NULL,
  `skip` varchar(5) NOT NULL,
  `activation` varchar(50) NOT NULL,
  `year_of_employment` varchar(15) NOT NULL,
  `term_of_employment` varchar(15) NOT NULL,
  PRIMARY KEY (`staff_id`),
  UNIQUE KEY `user_key` (`user_key`),
  KEY `activation` (`activation`),
  KEY `serial_number` (`serial_number`),
  KEY `status` (`status`),
  KEY `religion` (`religion`),
  KEY `sent_serial_pass_sms` (`sent_serial_pass_sms`),
  KEY `skip` (`skip`),
  KEY `school_id` (`school_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;


INSERT INTO staff VALUES
("1","169","11696eb40ef3","T/20/0001","$2y$10$QLXSfNo8WzXwmI2kZ7kwIOa9Rwxv7Nf1CKdxDD3Op2Iq2VGWEG1zm","onglobal","onglobal","GLOBAL","","ZEON","male","academic","both","","","ABUJA","2021-04-09","2340000000000","","NIGERIA","FCT","Christianity","","","","","","0","0","","activated","2020/2021","1st Term");




CREATE TABLE `staff_salary` (
  `staff_salary_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  PRIMARY KEY (`staff_salary_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;


INSERT INTO staff_salary VALUES
("1","1","0.00");




CREATE TABLE `staff_subject` (
  `staff_subject_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  PRIMARY KEY (`staff_subject_id`),
  KEY `staff_subject_class` (`staff_id`,`subject_id`,`class_id`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=latin1;


INSERT INTO staff_subject VALUES
("1","1","1","1"),
("123","1","1","2"),
("3","1","1","3"),
("4","1","1","4"),
("77","1","2","2"),
("84","1","2","3"),
("6","1","2","6"),
("7","1","2","7"),
("8","1","2","8"),
("9","1","2","9"),
("61","1","3","1"),
("80","1","3","2"),
("85","1","3","3"),
("99","1","3","5"),
("115","1","3","6"),
("19","1","3","7"),
("34","1","3","8"),
("49","1","3","9"),
("65","1","3","10"),
("100","1","4","5"),
("117","1","4","6"),
("20","1","4","7"),
("35","1","4","8"),
("50","1","4","9"),
("66","1","4","10"),
("122","1","5","1"),
("81","1","5","2"),
("86","1","5","3"),
("101","1","5","5"),
("118","1","5","6"),
("21","1","5","7"),
("36","1","5","8"),
("51","1","5","9"),
("22","1","6","7"),
("37","1","6","8"),
("52","1","6","9"),
("82","1","7","2"),
("102","1","7","5"),
("119","1","7","6"),
("23","1","7","7"),
("38","1","7","8"),
("53","1","7","9"),
("83","1","8","2"),
("87","1","8","3"),
("103","1","8","5"),
("120","1","8","6"),
("24","1","8","7"),
("39","1","8","8"),
("54","1","8","9"),
("67","1","8","10"),
("91","1","9","3"),
("104","1","9","5"),
("121","1","9","6"),
("25","1","9","7"),
("40","1","9","8"),
("55","1","9","9"),
("68","1","9","10"),
("92","1","10","5"),
("108","1","10","6"),
("11","1","10","7"),
("26","1","10","8"),
("41","1","10","9"),
("63","1","10","10"),
("125","1","11","5"),
("109","1","11","6"),
("12","1","11","7"),
("27","1","11","8"),
("42","1","11","9"),
("93","1","12","5"),
("110","1","12","6"),
("13","1","12","7"),
("28","1","12","8"),
("43","1","12","9"),
("94","1","13","5"),
("14","1","13","7"),
("107","1","14","5"),
("127","1","14","6"),
("15","1","14","7"),
("30","1","14","8"),
("45","1","14","9"),
("95","1","15","5"),
("112","1","15","6"),
("16","1","15","7"),
("31","1","15","8"),
("46","1","15","9"),
("105","1","16","5"),
("113","1","16","6"),
("17","1","16","7"),
("32","1","16","8"),
("47","1","16","9"),
("96","1","17","5"),
("114","1","17","6"),
("18","1","17","7"),
("33","1","17","8"),
("48","1","17","9"),
("64","1","17","10"),
("56","1","18","1"),
("76","1","18","2"),
("57","1","19","1"),
("89","1","19","3");
INSERT INTO staff_subject VALUES
("58","1","20","1"),
("124","1","20","2"),
("126","1","20","3"),
("59","1","21","1"),
("90","1","21","3"),
("60","1","22","1"),
("97","1","23","5"),
("69","1","23","10"),
("70","1","24","10"),
("71","1","25","10"),
("72","1","26","10"),
("73","1","27","10"),
("75","1","29","10"),
("106","1","30","5"),
("116","1","30","6");




CREATE TABLE `staff_subject_subclass` (
  `staff_subject_subclass_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `subclass_id` int(11) NOT NULL,
  PRIMARY KEY (`staff_subject_subclass_id`),
  UNIQUE KEY `staff_subject_subclass` (`staff_id`,`subject_id`,`class_id`,`subclass_id`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=latin1;


INSERT INTO staff_subject_subclass VALUES
("1","1","1","1","0"),
("123","1","1","2","0"),
("3","1","1","3","0"),
("4","1","1","4","0"),
("77","1","2","2","0"),
("84","1","2","3","0"),
("6","1","2","6","0"),
("7","1","2","7","0"),
("8","1","2","8","0"),
("9","1","2","9","0"),
("61","1","3","1","0"),
("80","1","3","2","0"),
("85","1","3","3","0"),
("99","1","3","5","0"),
("115","1","3","6","0"),
("19","1","3","7","0"),
("34","1","3","8","0"),
("49","1","3","9","0"),
("65","1","3","10","0"),
("100","1","4","5","0"),
("117","1","4","6","0"),
("20","1","4","7","0"),
("35","1","4","8","0"),
("50","1","4","9","0"),
("66","1","4","10","0"),
("122","1","5","1","0"),
("81","1","5","2","0"),
("86","1","5","3","0"),
("101","1","5","5","0"),
("118","1","5","6","0"),
("21","1","5","7","0"),
("36","1","5","8","0"),
("51","1","5","9","0"),
("22","1","6","7","0"),
("37","1","6","8","0"),
("52","1","6","9","0"),
("82","1","7","2","0"),
("102","1","7","5","0"),
("119","1","7","6","0"),
("23","1","7","7","0"),
("38","1","7","8","0"),
("53","1","7","9","0"),
("83","1","8","2","0"),
("87","1","8","3","0"),
("103","1","8","5","0"),
("120","1","8","6","0"),
("24","1","8","7","0"),
("39","1","8","8","0"),
("54","1","8","9","0"),
("67","1","8","10","0"),
("91","1","9","3","0"),
("104","1","9","5","0"),
("121","1","9","6","0"),
("25","1","9","7","0"),
("40","1","9","8","0"),
("55","1","9","9","0"),
("68","1","9","10","0"),
("92","1","10","5","0"),
("108","1","10","6","0"),
("11","1","10","7","0"),
("26","1","10","8","0"),
("41","1","10","9","0"),
("63","1","10","10","0"),
("125","1","11","5","0"),
("109","1","11","6","0"),
("12","1","11","7","0"),
("27","1","11","8","0"),
("42","1","11","9","0"),
("93","1","12","5","0"),
("110","1","12","6","0"),
("13","1","12","7","0"),
("28","1","12","8","0"),
("43","1","12","9","0"),
("94","1","13","5","0"),
("14","1","13","7","0"),
("107","1","14","5","0"),
("127","1","14","6","0"),
("15","1","14","7","0"),
("30","1","14","8","0"),
("45","1","14","9","0"),
("95","1","15","5","0"),
("112","1","15","6","0"),
("16","1","15","7","0"),
("31","1","15","8","0"),
("46","1","15","9","0"),
("105","1","16","5","0"),
("113","1","16","6","0"),
("17","1","16","7","0"),
("32","1","16","8","0"),
("47","1","16","9","0"),
("96","1","17","5","0"),
("114","1","17","6","0"),
("18","1","17","7","0"),
("33","1","17","8","0"),
("48","1","17","9","0"),
("64","1","17","10","0"),
("56","1","18","1","0"),
("76","1","18","2","0"),
("57","1","19","1","0"),
("89","1","19","3","0");
INSERT INTO staff_subject_subclass VALUES
("58","1","20","1","0"),
("124","1","20","2","0"),
("126","1","20","3","0"),
("59","1","21","1","0"),
("90","1","21","3","0"),
("60","1","22","1","0"),
("97","1","23","5","0"),
("69","1","23","10","0"),
("70","1","24","10","0"),
("71","1","25","10","0"),
("72","1","26","10","0"),
("73","1","27","10","0"),
("75","1","29","10","0"),
("106","1","30","5","0"),
("116","1","30","6","0");




CREATE TABLE `student_plan` (
  `student_plan_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  PRIMARY KEY (`student_plan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `student_subject` (
  `student_subject_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `status` varchar(10) NOT NULL,
  PRIMARY KEY (`student_subject_id`),
  KEY `student_subject_status` (`student_id`,`subject_id`,`status`)
) ENGINE=InnoDB AUTO_INCREMENT=1549 DEFAULT CHARSET=latin1;


INSERT INTO student_subject VALUES
("1","1","2","doing"),
("48","1","3","doing"),
("49","1","4","doing"),
("50","1","5","doing"),
("51","1","6","doing"),
("52","1","7","doing"),
("53","1","8","doing"),
("54","1","9","doing"),
("40","1","10","doing"),
("41","1","11","doing"),
("42","1","12","doing"),
("43","1","13","doing"),
("44","1","14","doing"),
("45","1","15","doing"),
("46","1","16","doing"),
("47","1","17","doing"),
("2","2","2","doing"),
("63","2","3","doing"),
("64","2","4","doing"),
("65","2","5","doing"),
("66","2","6","doing"),
("67","2","7","doing"),
("68","2","8","doing"),
("69","2","9","doing"),
("55","2","10","doing"),
("56","2","11","doing"),
("57","2","12","doing"),
("58","2","13","doing"),
("59","2","14","doing"),
("60","2","15","doing"),
("61","2","16","doing"),
("62","2","17","doing"),
("3","3","2","doing"),
("78","3","3","doing"),
("79","3","4","doing"),
("80","3","5","doing"),
("81","3","6","doing"),
("82","3","7","doing"),
("83","3","8","doing"),
("84","3","9","doing"),
("70","3","10","doing"),
("71","3","11","doing"),
("72","3","12","doing"),
("73","3","13","doing"),
("74","3","14","doing"),
("75","3","15","doing"),
("76","3","16","doing"),
("77","3","17","doing"),
("4","4","2","doing"),
("93","4","3","doing"),
("94","4","4","doing"),
("95","4","5","doing"),
("96","4","6","doing"),
("97","4","7","doing"),
("98","4","8","doing"),
("99","4","9","doing"),
("85","4","10","doing"),
("86","4","11","doing"),
("87","4","12","doing"),
("88","4","13","doing"),
("89","4","14","doing"),
("90","4","15","doing"),
("91","4","16","doing"),
("92","4","17","doing"),
("5","5","2","doing"),
("108","5","3","doing"),
("109","5","4","doing"),
("110","5","5","doing"),
("111","5","6","doing"),
("112","5","7","doing"),
("113","5","8","doing"),
("114","5","9","doing"),
("100","5","10","doing"),
("101","5","11","doing"),
("102","5","12","doing"),
("103","5","13","doing"),
("104","5","14","doing"),
("105","5","15","doing"),
("106","5","16","doing"),
("107","5","17","doing"),
("6","6","2","doing"),
("123","6","3","doing"),
("124","6","4","doing"),
("125","6","5","doing"),
("126","6","6","doing"),
("127","6","7","doing"),
("128","6","8","doing"),
("129","6","9","doing"),
("115","6","10","doing"),
("116","6","11","doing"),
("117","6","12","doing"),
("118","6","13","doing"),
("119","6","14","doing"),
("120","6","15","doing"),
("121","6","16","doing"),
("122","6","17","doing"),
("7","7","2","doing"),
("138","7","3","doing"),
("139","7","4","doing"),
("140","7","5","doing");
INSERT INTO student_subject VALUES
("141","7","6","doing"),
("142","7","7","doing"),
("143","7","8","doing"),
("144","7","9","doing"),
("130","7","10","doing"),
("131","7","11","doing"),
("132","7","12","doing"),
("133","7","13","doing"),
("134","7","14","doing"),
("135","7","15","doing"),
("136","7","16","doing"),
("137","7","17","doing"),
("8","8","2","doing"),
("153","8","3","doing"),
("154","8","4","doing"),
("155","8","5","doing"),
("156","8","6","doing"),
("157","8","7","doing"),
("158","8","8","doing"),
("159","8","9","doing"),
("145","8","10","doing"),
("146","8","11","doing"),
("147","8","12","doing"),
("148","8","13","doing"),
("149","8","14","doing"),
("150","8","15","doing"),
("151","8","16","doing"),
("152","8","17","doing"),
("9","9","2","doing"),
("168","9","3","doing"),
("169","9","4","doing"),
("170","9","5","doing"),
("171","9","6","doing"),
("172","9","7","doing"),
("173","9","8","doing"),
("174","9","9","doing"),
("160","9","10","doing"),
("161","9","11","doing"),
("162","9","12","doing"),
("163","9","13","doing"),
("164","9","14","doing"),
("165","9","15","doing"),
("166","9","16","doing"),
("167","9","17","doing"),
("10","10","2","doing"),
("183","10","3","doing"),
("184","10","4","doing"),
("185","10","5","doing"),
("186","10","6","doing"),
("187","10","7","doing"),
("188","10","8","doing"),
("189","10","9","doing"),
("175","10","10","doing"),
("176","10","11","doing"),
("177","10","12","doing"),
("178","10","13","doing"),
("179","10","14","doing"),
("180","10","15","doing"),
("181","10","16","doing"),
("182","10","17","doing"),
("11","11","2","doing"),
("198","11","3","doing"),
("199","11","4","doing"),
("200","11","5","doing"),
("201","11","6","doing"),
("202","11","7","doing"),
("203","11","8","doing"),
("204","11","9","doing"),
("190","11","10","doing"),
("191","11","11","doing"),
("192","11","12","doing"),
("193","11","13","doing"),
("194","11","14","doing"),
("195","11","15","doing"),
("196","11","16","doing"),
("197","11","17","doing"),
("12","12","2","doing"),
("213","12","3","doing"),
("214","12","4","doing"),
("215","12","5","doing"),
("216","12","6","doing"),
("217","12","7","doing"),
("218","12","8","doing"),
("219","12","9","doing"),
("205","12","10","doing"),
("206","12","11","doing"),
("207","12","12","doing"),
("208","12","13","doing"),
("209","12","14","doing"),
("210","12","15","doing"),
("211","12","16","doing"),
("212","12","17","doing"),
("13","13","2","doing"),
("228","13","3","doing"),
("229","13","4","doing"),
("230","13","5","doing"),
("231","13","6","doing"),
("232","13","7","doing"),
("233","13","8","doing"),
("234","13","9","doing");
INSERT INTO student_subject VALUES
("220","13","10","doing"),
("221","13","11","doing"),
("222","13","12","doing"),
("223","13","13","doing"),
("224","13","14","doing"),
("225","13","15","doing"),
("226","13","16","doing"),
("227","13","17","doing"),
("14","14","2","doing"),
("243","14","3","doing"),
("244","14","4","doing"),
("245","14","5","doing"),
("246","14","6","doing"),
("247","14","7","doing"),
("248","14","8","doing"),
("249","14","9","doing"),
("235","14","10","doing"),
("236","14","11","doing"),
("237","14","12","doing"),
("238","14","13","doing"),
("239","14","14","doing"),
("240","14","15","doing"),
("241","14","16","doing"),
("242","14","17","doing"),
("15","15","2","doing"),
("258","15","3","doing"),
("259","15","4","doing"),
("260","15","5","doing"),
("261","15","6","doing"),
("262","15","7","doing"),
("263","15","8","doing"),
("264","15","9","doing"),
("250","15","10","doing"),
("251","15","11","doing"),
("252","15","12","doing"),
("253","15","13","doing"),
("254","15","14","doing"),
("255","15","15","doing"),
("256","15","16","doing"),
("257","15","17","doing"),
("16","16","2","doing"),
("498","16","3","doing"),
("499","16","4","doing"),
("500","16","5","doing"),
("501","16","6","doing"),
("502","16","7","doing"),
("503","16","8","doing"),
("504","16","9","doing"),
("490","16","10","doing"),
("491","16","11","doing"),
("492","16","12","doing"),
("494","16","14","doing"),
("495","16","15","doing"),
("496","16","16","doing"),
("497","16","17","doing"),
("17","17","2","doing"),
("513","17","3","doing"),
("514","17","4","doing"),
("515","17","5","doing"),
("516","17","6","doing"),
("517","17","7","doing"),
("518","17","8","doing"),
("519","17","9","doing"),
("505","17","10","doing"),
("506","17","11","doing"),
("507","17","12","doing"),
("509","17","14","doing"),
("510","17","15","doing"),
("511","17","16","doing"),
("512","17","17","doing"),
("18","18","2","doing"),
("528","18","3","doing"),
("529","18","4","doing"),
("530","18","5","doing"),
("531","18","6","doing"),
("532","18","7","doing"),
("533","18","8","doing"),
("534","18","9","doing"),
("520","18","10","doing"),
("521","18","11","doing"),
("522","18","12","doing"),
("524","18","14","doing"),
("525","18","15","doing"),
("526","18","16","doing"),
("527","18","17","doing"),
("19","19","2","doing"),
("543","19","3","doing"),
("544","19","4","doing"),
("545","19","5","doing"),
("546","19","6","doing"),
("547","19","7","doing"),
("548","19","8","doing"),
("549","19","9","doing"),
("535","19","10","doing"),
("536","19","11","doing"),
("537","19","12","doing"),
("539","19","14","doing"),
("540","19","15","doing"),
("541","19","16","doing"),
("542","19","17","doing");
INSERT INTO student_subject VALUES
("20","20","2","doing"),
("558","20","3","doing"),
("559","20","4","doing"),
("560","20","5","doing"),
("561","20","6","doing"),
("562","20","7","doing"),
("563","20","8","doing"),
("564","20","9","doing"),
("550","20","10","doing"),
("551","20","11","doing"),
("552","20","12","doing"),
("554","20","14","doing"),
("555","20","15","doing"),
("556","20","16","doing"),
("557","20","17","doing"),
("21","21","2","doing"),
("573","21","3","doing"),
("574","21","4","doing"),
("575","21","5","doing"),
("576","21","6","doing"),
("577","21","7","doing"),
("578","21","8","doing"),
("579","21","9","doing"),
("565","21","10","doing"),
("566","21","11","doing"),
("567","21","12","doing"),
("569","21","14","doing"),
("570","21","15","doing"),
("571","21","16","doing"),
("572","21","17","doing"),
("22","22","2","doing"),
("588","22","3","doing"),
("589","22","4","doing"),
("590","22","5","doing"),
("591","22","6","doing"),
("592","22","7","doing"),
("593","22","8","doing"),
("594","22","9","doing"),
("580","22","10","doing"),
("581","22","11","doing"),
("582","22","12","doing"),
("584","22","14","doing"),
("585","22","15","doing"),
("586","22","16","doing"),
("587","22","17","doing"),
("23","23","2","doing"),
("603","23","3","doing"),
("604","23","4","doing"),
("605","23","5","doing"),
("606","23","6","doing"),
("607","23","7","doing"),
("608","23","8","doing"),
("609","23","9","doing"),
("595","23","10","doing"),
("596","23","11","doing"),
("597","23","12","doing"),
("599","23","14","doing"),
("600","23","15","doing"),
("601","23","16","doing"),
("602","23","17","doing"),
("24","24","2","doing"),
("618","24","3","doing"),
("619","24","4","doing"),
("620","24","5","doing"),
("621","24","6","doing"),
("622","24","7","doing"),
("623","24","8","doing"),
("624","24","9","doing"),
("610","24","10","doing"),
("611","24","11","doing"),
("612","24","12","doing"),
("614","24","14","doing"),
("615","24","15","doing"),
("616","24","16","doing"),
("617","24","17","doing"),
("25","25","2","doing"),
("273","25","3","doing"),
("274","25","4","doing"),
("275","25","5","doing"),
("276","25","6","doing"),
("277","25","7","doing"),
("278","25","8","doing"),
("279","25","9","doing"),
("265","25","10","doing"),
("266","25","11","doing"),
("267","25","12","doing"),
("269","25","14","doing"),
("270","25","15","doing"),
("271","25","16","doing"),
("272","25","17","doing"),
("26","26","2","doing"),
("288","26","3","doing"),
("289","26","4","doing"),
("290","26","5","doing"),
("291","26","6","doing"),
("292","26","7","doing"),
("293","26","8","doing"),
("294","26","9","doing"),
("280","26","10","doing"),
("281","26","11","doing");
INSERT INTO student_subject VALUES
("282","26","12","doing"),
("284","26","14","doing"),
("285","26","15","doing"),
("286","26","16","doing"),
("287","26","17","doing"),
("27","27","2","doing"),
("303","27","3","doing"),
("304","27","4","doing"),
("305","27","5","doing"),
("306","27","6","doing"),
("307","27","7","doing"),
("308","27","8","doing"),
("309","27","9","doing"),
("295","27","10","doing"),
("296","27","11","doing"),
("297","27","12","doing"),
("299","27","14","doing"),
("300","27","15","doing"),
("301","27","16","doing"),
("302","27","17","doing"),
("28","28","2","doing"),
("318","28","3","doing"),
("319","28","4","doing"),
("320","28","5","doing"),
("321","28","6","doing"),
("322","28","7","doing"),
("323","28","8","doing"),
("324","28","9","doing"),
("310","28","10","doing"),
("311","28","11","doing"),
("312","28","12","doing"),
("314","28","14","doing"),
("315","28","15","doing"),
("316","28","16","doing"),
("317","28","17","doing"),
("29","29","2","doing"),
("333","29","3","doing"),
("334","29","4","doing"),
("335","29","5","doing"),
("336","29","6","doing"),
("337","29","7","doing"),
("338","29","8","doing"),
("339","29","9","doing"),
("325","29","10","doing"),
("326","29","11","doing"),
("327","29","12","doing"),
("329","29","14","doing"),
("330","29","15","doing"),
("331","29","16","doing"),
("332","29","17","doing"),
("30","30","2","doing"),
("348","30","3","doing"),
("349","30","4","doing"),
("350","30","5","doing"),
("351","30","6","doing"),
("352","30","7","doing"),
("353","30","8","doing"),
("354","30","9","doing"),
("340","30","10","doing"),
("341","30","11","doing"),
("342","30","12","doing"),
("344","30","14","doing"),
("345","30","15","doing"),
("346","30","16","doing"),
("347","30","17","doing"),
("31","31","2","doing"),
("363","31","3","doing"),
("364","31","4","doing"),
("365","31","5","doing"),
("366","31","6","doing"),
("367","31","7","doing"),
("368","31","8","doing"),
("369","31","9","doing"),
("355","31","10","doing"),
("356","31","11","doing"),
("357","31","12","doing"),
("359","31","14","doing"),
("360","31","15","doing"),
("361","31","16","doing"),
("362","31","17","doing"),
("32","32","2","doing"),
("378","32","3","doing"),
("379","32","4","doing"),
("380","32","5","doing"),
("381","32","6","doing"),
("382","32","7","doing"),
("383","32","8","doing"),
("384","32","9","doing"),
("370","32","10","doing"),
("371","32","11","doing"),
("372","32","12","doing"),
("374","32","14","doing"),
("375","32","15","doing"),
("376","32","16","doing"),
("377","32","17","doing"),
("33","33","2","doing"),
("393","33","3","doing"),
("394","33","4","doing"),
("395","33","5","doing"),
("396","33","6","doing");
INSERT INTO student_subject VALUES
("397","33","7","doing"),
("398","33","8","doing"),
("399","33","9","doing"),
("385","33","10","doing"),
("386","33","11","doing"),
("387","33","12","doing"),
("389","33","14","doing"),
("390","33","15","doing"),
("391","33","16","doing"),
("392","33","17","doing"),
("34","34","2","doing"),
("408","34","3","doing"),
("409","34","4","doing"),
("410","34","5","doing"),
("411","34","6","doing"),
("412","34","7","doing"),
("413","34","8","doing"),
("414","34","9","doing"),
("400","34","10","doing"),
("401","34","11","doing"),
("402","34","12","doing"),
("404","34","14","doing"),
("405","34","15","doing"),
("406","34","16","doing"),
("407","34","17","doing"),
("35","35","2","doing"),
("423","35","3","doing"),
("424","35","4","doing"),
("425","35","5","doing"),
("426","35","6","doing"),
("427","35","7","doing"),
("428","35","8","doing"),
("429","35","9","doing"),
("415","35","10","doing"),
("416","35","11","doing"),
("417","35","12","doing"),
("419","35","14","doing"),
("420","35","15","doing"),
("421","35","16","doing"),
("422","35","17","doing"),
("36","36","2","doing"),
("438","36","3","doing"),
("439","36","4","doing"),
("440","36","5","doing"),
("441","36","6","doing"),
("442","36","7","doing"),
("443","36","8","doing"),
("444","36","9","doing"),
("430","36","10","doing"),
("431","36","11","doing"),
("432","36","12","doing"),
("434","36","14","doing"),
("435","36","15","doing"),
("436","36","16","doing"),
("437","36","17","doing"),
("37","37","2","doing"),
("453","37","3","doing"),
("454","37","4","doing"),
("455","37","5","doing"),
("456","37","6","doing"),
("457","37","7","doing"),
("458","37","8","doing"),
("459","37","9","doing"),
("445","37","10","doing"),
("446","37","11","doing"),
("447","37","12","doing"),
("449","37","14","doing"),
("450","37","15","doing"),
("451","37","16","doing"),
("452","37","17","doing"),
("38","38","2","doing"),
("468","38","3","doing"),
("469","38","4","doing"),
("470","38","5","doing"),
("471","38","6","doing"),
("472","38","7","doing"),
("473","38","8","doing"),
("474","38","9","doing"),
("460","38","10","doing"),
("461","38","11","doing"),
("462","38","12","doing"),
("464","38","14","doing"),
("465","38","15","doing"),
("466","38","16","doing"),
("467","38","17","doing"),
("39","39","2","doing"),
("483","39","3","doing"),
("484","39","4","doing"),
("485","39","5","doing"),
("486","39","6","doing"),
("487","39","7","doing"),
("488","39","8","doing"),
("489","39","9","doing"),
("475","39","10","doing"),
("476","39","11","doing"),
("477","39","12","doing"),
("479","39","14","doing"),
("480","39","15","doing"),
("481","39","16","doing"),
("482","39","17","doing");
INSERT INTO student_subject VALUES
("625","40","1","doing"),
("635","40","3","doing"),
("1369","40","5","doing"),
("630","40","18","doing"),
("631","40","19","doing"),
("632","40","20","doing"),
("633","40","21","doing"),
("634","40","22","doing"),
("626","41","1","doing"),
("642","41","3","doing"),
("1370","41","5","doing"),
("637","41","18","doing"),
("638","41","19","doing"),
("639","41","20","doing"),
("640","41","21","doing"),
("641","41","22","doing"),
("627","42","1","doing"),
("649","42","3","doing"),
("1371","42","5","doing"),
("644","42","18","doing"),
("645","42","19","doing"),
("646","42","20","doing"),
("647","42","21","doing"),
("648","42","22","doing"),
("628","43","1","doing"),
("656","43","3","doing"),
("1372","43","5","doing"),
("651","43","18","doing"),
("652","43","19","doing"),
("653","43","20","doing"),
("654","43","21","doing"),
("655","43","22","doing"),
("629","44","1","doing"),
("663","44","3","doing"),
("1373","44","5","doing"),
("658","44","18","doing"),
("659","44","19","doing"),
("660","44","20","doing"),
("661","44","21","doing"),
("662","44","22","doing"),
("665","45","1","doing"),
("781","45","2","doing"),
("782","45","3","doing"),
("783","45","5","doing"),
("784","45","8","doing"),
("840","45","9","doing"),
("838","45","19","doing"),
("1491","45","20","doing"),
("839","45","21","doing"),
("671","46","3","doing"),
("672","46","4","doing"),
("673","46","8","doing"),
("674","46","9","doing"),
("669","46","10","doing"),
("670","46","17","doing"),
("687","46","23","doing"),
("688","46","24","doing"),
("689","46","25","doing"),
("690","46","26","doing"),
("691","46","27","doing"),
("705","46","29","doing"),
("677","47","3","doing"),
("678","47","4","doing"),
("679","47","8","doing"),
("680","47","9","doing"),
("675","47","10","doing"),
("676","47","17","doing"),
("693","47","23","doing"),
("694","47","24","doing"),
("695","47","25","doing"),
("696","47","26","doing"),
("697","47","27","doing"),
("706","47","29","doing"),
("683","48","3","doing"),
("684","48","4","doing"),
("685","48","8","doing"),
("686","48","9","doing"),
("681","48","10","doing"),
("682","48","17","doing"),
("699","48","23","doing"),
("700","48","24","doing"),
("701","48","25","doing"),
("702","48","26","doing"),
("703","48","27","doing"),
("707","48","29","doing"),
("1458","49","1","doing"),
("726","49","2","doing"),
("729","49","3","doing"),
("730","49","5","doing"),
("731","49","7","doing"),
("732","49","8","doing"),
("725","49","18","doing"),
("1459","49","20","doing"),
("1460","50","1","doing"),
("734","50","2","doing"),
("737","50","3","doing"),
("738","50","5","doing"),
("739","50","7","doing"),
("740","50","8","doing"),
("733","50","18","doing");
INSERT INTO student_subject VALUES
("1461","50","20","doing"),
("1462","51","1","doing"),
("742","51","2","doing"),
("745","51","3","doing"),
("746","51","5","doing"),
("747","51","7","doing"),
("748","51","8","doing"),
("741","51","18","doing"),
("1463","51","20","doing"),
("1474","52","1","doing"),
("750","52","2","doing"),
("753","52","3","doing"),
("754","52","5","doing"),
("755","52","7","doing"),
("756","52","8","doing"),
("749","52","18","doing"),
("1475","52","20","doing"),
("1464","53","1","doing"),
("758","53","2","doing"),
("761","53","3","doing"),
("762","53","5","doing"),
("763","53","7","doing"),
("764","53","8","doing"),
("757","53","18","doing"),
("1465","53","20","doing"),
("900","54","3","doing"),
("901","54","4","doing"),
("902","54","5","doing"),
("903","54","7","doing"),
("904","54","8","doing"),
("905","54","9","doing"),
("893","54","10","doing"),
("1476","54","11","doing"),
("894","54","12","doing"),
("895","54","13","doing"),
("1118","54","14","doing"),
("896","54","15","doing"),
("1088","54","16","doing"),
("897","54","17","doing"),
("898","54","23","doing"),
("1103","54","30","doing"),
("913","55","3","doing"),
("914","55","4","doing"),
("915","55","5","doing"),
("916","55","7","doing"),
("917","55","8","doing"),
("918","55","9","doing"),
("906","55","10","doing"),
("1477","55","11","doing"),
("907","55","12","doing"),
("908","55","13","doing"),
("1119","55","14","doing"),
("909","55","15","doing"),
("1089","55","16","doing"),
("910","55","17","doing"),
("911","55","23","doing"),
("1104","55","30","doing"),
("926","56","3","doing"),
("927","56","4","doing"),
("928","56","5","doing"),
("929","56","7","doing"),
("930","56","8","doing"),
("931","56","9","doing"),
("919","56","10","doing"),
("1478","56","11","doing"),
("920","56","12","doing"),
("921","56","13","doing"),
("1120","56","14","doing"),
("922","56","15","doing"),
("1090","56","16","doing"),
("923","56","17","doing"),
("924","56","23","doing"),
("1105","56","30","doing"),
("939","57","3","doing"),
("940","57","4","doing"),
("941","57","5","doing"),
("942","57","7","doing"),
("943","57","8","doing"),
("944","57","9","doing"),
("932","57","10","doing"),
("1479","57","11","doing"),
("933","57","12","doing"),
("934","57","13","doing"),
("1121","57","14","doing"),
("935","57","15","doing"),
("1091","57","16","doing"),
("936","57","17","doing"),
("937","57","23","doing"),
("1106","57","30","doing"),
("952","58","3","doing"),
("953","58","4","doing"),
("954","58","5","doing"),
("955","58","7","doing"),
("956","58","8","doing"),
("957","58","9","doing"),
("945","58","10","doing"),
("1480","58","11","doing"),
("946","58","12","doing"),
("947","58","13","doing"),
("1122","58","14","doing");
INSERT INTO student_subject VALUES
("948","58","15","doing"),
("1092","58","16","doing"),
("949","58","17","doing"),
("950","58","23","doing"),
("1107","58","30","doing"),
("965","59","3","doing"),
("966","59","4","doing"),
("967","59","5","doing"),
("968","59","7","doing"),
("969","59","8","doing"),
("970","59","9","doing"),
("958","59","10","doing"),
("1481","59","11","doing"),
("959","59","12","doing"),
("960","59","13","doing"),
("1123","59","14","doing"),
("961","59","15","doing"),
("1093","59","16","doing"),
("962","59","17","doing"),
("963","59","23","doing"),
("1108","59","30","doing"),
("978","60","3","doing"),
("979","60","4","doing"),
("980","60","5","doing"),
("981","60","7","doing"),
("982","60","8","doing"),
("983","60","9","doing"),
("971","60","10","doing"),
("1482","60","11","doing"),
("972","60","12","doing"),
("973","60","13","doing"),
("1124","60","14","doing"),
("974","60","15","doing"),
("1094","60","16","doing"),
("975","60","17","doing"),
("976","60","23","doing"),
("1109","60","30","doing"),
("991","61","3","doing"),
("992","61","4","doing"),
("993","61","5","doing"),
("994","61","7","doing"),
("995","61","8","doing"),
("996","61","9","doing"),
("984","61","10","doing"),
("1483","61","11","doing"),
("985","61","12","doing"),
("986","61","13","doing"),
("1125","61","14","doing"),
("987","61","15","doing"),
("1095","61","16","doing"),
("988","61","17","doing"),
("989","61","23","doing"),
("1110","61","30","doing"),
("1004","62","3","doing"),
("1005","62","4","doing"),
("1006","62","5","doing"),
("1007","62","7","doing"),
("1008","62","8","doing"),
("1009","62","9","doing"),
("997","62","10","doing"),
("1488","62","11","doing"),
("998","62","12","doing"),
("999","62","13","doing"),
("1126","62","14","doing"),
("1000","62","15","doing"),
("1096","62","16","doing"),
("1001","62","17","doing"),
("1002","62","23","doing"),
("1111","62","30","doing"),
("1017","63","3","doing"),
("1018","63","4","doing"),
("1019","63","5","doing"),
("1020","63","7","doing"),
("1021","63","8","doing"),
("1022","63","9","doing"),
("1010","63","10","doing"),
("1484","63","11","doing"),
("1011","63","12","doing"),
("1012","63","13","doing"),
("1127","63","14","doing"),
("1013","63","15","doing"),
("1097","63","16","doing"),
("1014","63","17","doing"),
("1015","63","23","doing"),
("1112","63","30","doing"),
("1030","64","3","doing"),
("1031","64","4","doing"),
("1032","64","5","doing"),
("1033","64","7","doing"),
("1034","64","8","doing"),
("1035","64","9","doing"),
("1023","64","10","doing"),
("1485","64","11","doing"),
("1024","64","12","doing"),
("1025","64","13","doing"),
("1128","64","14","doing"),
("1026","64","15","doing"),
("1098","64","16","doing"),
("1027","64","17","doing"),
("1028","64","23","doing");
INSERT INTO student_subject VALUES
("1113","64","30","doing"),
("1043","65","3","doing"),
("1044","65","4","doing"),
("1045","65","5","doing"),
("1046","65","7","doing"),
("1047","65","8","doing"),
("1048","65","9","doing"),
("1036","65","10","doing"),
("1486","65","11","doing"),
("1037","65","12","doing"),
("1038","65","13","doing"),
("1129","65","14","doing"),
("1039","65","15","doing"),
("1099","65","16","doing"),
("1040","65","17","doing"),
("1041","65","23","doing"),
("1114","65","30","doing"),
("1056","66","3","doing"),
("1057","66","4","doing"),
("1058","66","5","doing"),
("1059","66","7","doing"),
("1060","66","8","doing"),
("1061","66","9","doing"),
("1049","66","10","doing"),
("1487","66","11","doing"),
("1050","66","12","doing"),
("1051","66","13","doing"),
("1130","66","14","doing"),
("1052","66","15","doing"),
("1100","66","16","doing"),
("1053","66","17","doing"),
("1054","66","23","doing"),
("1115","66","30","doing"),
("1069","67","3","doing"),
("1070","67","4","doing"),
("1071","67","5","doing"),
("1072","67","7","doing"),
("1073","67","8","doing"),
("1074","67","9","doing"),
("1062","67","10","doing"),
("1489","67","11","doing"),
("1063","67","12","doing"),
("1064","67","13","doing"),
("1131","67","14","doing"),
("1065","67","15","doing"),
("1101","67","16","doing"),
("1066","67","17","doing"),
("1067","67","23","doing"),
("1116","67","30","doing"),
("1082","68","3","doing"),
("1083","68","4","doing"),
("1084","68","5","doing"),
("1085","68","7","doing"),
("1086","68","8","doing"),
("1087","68","9","doing"),
("1075","68","10","doing"),
("1490","68","11","doing"),
("1076","68","12","doing"),
("1077","68","13","doing"),
("1132","68","14","doing"),
("1078","68","15","doing"),
("1102","68","16","doing"),
("1079","68","17","doing"),
("1080","68","23","doing"),
("1117","68","30","doing"),
("768","69","1","doing"),
("785","69","2","doing"),
("786","69","3","doing"),
("787","69","5","doing"),
("788","69","8","doing"),
("844","69","9","doing"),
("842","69","19","doing"),
("1492","69","20","doing"),
("843","69","21","doing"),
("769","70","1","doing"),
("829","70","2","doing"),
("830","70","3","doing"),
("831","70","5","doing"),
("832","70","8","doing"),
("888","70","9","doing"),
("886","70","19","doing"),
("1504","70","20","doing"),
("887","70","21","doing"),
("770","71","1","doing"),
("789","71","2","doing"),
("790","71","3","doing"),
("791","71","5","doing"),
("792","71","8","doing"),
("848","71","9","doing"),
("846","71","19","doing"),
("1493","71","20","doing"),
("847","71","21","doing"),
("771","72","1","doing"),
("793","72","2","doing"),
("794","72","3","doing"),
("795","72","5","doing"),
("796","72","8","doing"),
("852","72","9","doing"),
("850","72","19","doing"),
("1494","72","20","doing");
INSERT INTO student_subject VALUES
("851","72","21","doing"),
("772","73","1","doing"),
("797","73","2","doing"),
("798","73","3","doing"),
("799","73","5","doing"),
("800","73","8","doing"),
("856","73","9","doing"),
("854","73","19","doing"),
("1495","73","20","doing"),
("855","73","21","doing"),
("773","74","1","doing"),
("801","74","2","doing"),
("802","74","3","doing"),
("803","74","5","doing"),
("804","74","8","doing"),
("860","74","9","doing"),
("858","74","19","doing"),
("1496","74","20","doing"),
("859","74","21","doing"),
("774","75","1","doing"),
("805","75","2","doing"),
("806","75","3","doing"),
("807","75","5","doing"),
("808","75","8","doing"),
("864","75","9","doing"),
("862","75","19","doing"),
("1497","75","20","doing"),
("863","75","21","doing"),
("775","76","1","doing"),
("809","76","2","doing"),
("810","76","3","doing"),
("811","76","5","doing"),
("812","76","8","doing"),
("868","76","9","doing"),
("866","76","19","doing"),
("1498","76","20","doing"),
("867","76","21","doing"),
("776","77","1","doing"),
("813","77","2","doing"),
("814","77","3","doing"),
("815","77","5","doing"),
("816","77","8","doing"),
("872","77","9","doing"),
("870","77","19","doing"),
("1499","77","20","doing"),
("871","77","21","doing"),
("777","78","1","doing"),
("817","78","2","doing"),
("818","78","3","doing"),
("819","78","5","doing"),
("820","78","8","doing"),
("876","78","9","doing"),
("874","78","19","doing"),
("1500","78","20","doing"),
("875","78","21","doing"),
("778","79","1","doing"),
("821","79","2","doing"),
("822","79","3","doing"),
("823","79","5","doing"),
("824","79","8","doing"),
("880","79","9","doing"),
("878","79","19","doing"),
("1501","79","20","doing"),
("879","79","21","doing"),
("779","80","1","doing"),
("825","80","2","doing"),
("826","80","3","doing"),
("827","80","5","doing"),
("828","80","8","doing"),
("884","80","9","doing"),
("882","80","19","doing"),
("1502","80","20","doing"),
("883","80","21","doing"),
("780","81","1","doing"),
("833","81","2","doing"),
("834","81","3","doing"),
("835","81","5","doing"),
("836","81","8","doing"),
("892","81","9","doing"),
("890","81","19","doing"),
("1503","81","20","doing"),
("891","81","21","doing"),
("1133","82","2","doing"),
("1151","82","3","doing"),
("1153","82","4","doing"),
("1154","82","5","doing"),
("1155","82","7","doing"),
("1156","82","8","doing"),
("1157","82","9","doing"),
("1144","82","10","doing"),
("1145","82","11","doing"),
("1146","82","12","doing"),
("1535","82","14","doing"),
("1148","82","15","doing"),
("1149","82","16","doing"),
("1150","82","17","doing"),
("1152","82","30","doing"),
("1134","83","2","doing"),
("1165","83","3","doing"),
("1167","83","4","doing");
INSERT INTO student_subject VALUES
("1168","83","5","doing"),
("1169","83","7","doing"),
("1170","83","8","doing"),
("1171","83","9","doing"),
("1158","83","10","doing"),
("1159","83","11","doing"),
("1160","83","12","doing"),
("1536","83","14","doing"),
("1162","83","15","doing"),
("1163","83","16","doing"),
("1164","83","17","doing"),
("1166","83","30","doing"),
("1135","84","2","doing"),
("1179","84","3","doing"),
("1181","84","4","doing"),
("1182","84","5","doing"),
("1183","84","7","doing"),
("1184","84","8","doing"),
("1185","84","9","doing"),
("1172","84","10","doing"),
("1173","84","11","doing"),
("1174","84","12","doing"),
("1537","84","14","doing"),
("1176","84","15","doing"),
("1177","84","16","doing"),
("1178","84","17","doing"),
("1180","84","30","doing"),
("1136","85","2","doing"),
("1193","85","3","doing"),
("1195","85","4","doing"),
("1196","85","5","doing"),
("1197","85","7","doing"),
("1198","85","8","doing"),
("1199","85","9","doing"),
("1186","85","10","doing"),
("1187","85","11","doing"),
("1188","85","12","doing"),
("1538","85","14","doing"),
("1190","85","15","doing"),
("1191","85","16","doing"),
("1192","85","17","doing"),
("1194","85","30","doing"),
("1137","86","2","doing"),
("1207","86","3","doing"),
("1209","86","4","doing"),
("1210","86","5","doing"),
("1211","86","7","doing"),
("1212","86","8","doing"),
("1213","86","9","doing"),
("1200","86","10","doing"),
("1201","86","11","doing"),
("1202","86","12","doing"),
("1539","86","14","doing"),
("1204","86","15","doing"),
("1205","86","16","doing"),
("1206","86","17","doing"),
("1208","86","30","doing"),
("1138","87","2","doing"),
("1221","87","3","doing"),
("1223","87","4","doing"),
("1224","87","5","doing"),
("1225","87","7","doing"),
("1226","87","8","doing"),
("1227","87","9","doing"),
("1214","87","10","doing"),
("1215","87","11","doing"),
("1216","87","12","doing"),
("1540","87","14","doing"),
("1218","87","15","doing"),
("1219","87","16","doing"),
("1220","87","17","doing"),
("1222","87","30","doing"),
("1139","88","2","doing"),
("1235","88","3","doing"),
("1237","88","4","doing"),
("1238","88","5","doing"),
("1239","88","7","doing"),
("1240","88","8","doing"),
("1241","88","9","doing"),
("1228","88","10","doing"),
("1229","88","11","doing"),
("1230","88","12","doing"),
("1541","88","14","doing"),
("1232","88","15","doing"),
("1233","88","16","doing"),
("1234","88","17","doing"),
("1236","88","30","doing"),
("1140","89","2","doing"),
("1249","89","3","doing"),
("1251","89","4","doing"),
("1252","89","5","doing"),
("1253","89","7","doing"),
("1254","89","8","doing"),
("1255","89","9","doing"),
("1242","89","10","doing"),
("1243","89","11","doing"),
("1244","89","12","doing"),
("1548","89","14","doing"),
("1246","89","15","doing"),
("1247","89","16","doing");
INSERT INTO student_subject VALUES
("1248","89","17","doing"),
("1250","89","30","doing"),
("1141","90","2","doing"),
("1263","90","3","doing"),
("1265","90","4","doing"),
("1266","90","5","doing"),
("1267","90","7","doing"),
("1268","90","8","doing"),
("1269","90","9","doing"),
("1256","90","10","doing"),
("1257","90","11","doing"),
("1258","90","12","doing"),
("1542","90","14","doing"),
("1260","90","15","doing"),
("1261","90","16","doing"),
("1262","90","17","doing"),
("1264","90","30","doing"),
("1142","91","2","doing"),
("1277","91","3","doing"),
("1279","91","4","doing"),
("1280","91","5","doing"),
("1281","91","7","doing"),
("1282","91","8","doing"),
("1283","91","9","doing"),
("1270","91","10","doing"),
("1271","91","11","doing"),
("1272","91","12","doing"),
("1543","91","14","doing"),
("1274","91","15","doing"),
("1275","91","16","doing"),
("1276","91","17","doing"),
("1278","91","30","doing"),
("1143","92","2","doing"),
("1291","92","3","doing"),
("1293","92","4","doing"),
("1294","92","5","doing"),
("1295","92","7","doing"),
("1296","92","8","doing"),
("1297","92","9","doing"),
("1284","92","10","doing"),
("1285","92","11","doing"),
("1286","92","12","doing"),
("1544","92","14","doing"),
("1288","92","15","doing"),
("1289","92","16","doing"),
("1290","92","17","doing"),
("1292","92","30","doing"),
("1298","93","2","doing"),
("1306","93","3","doing"),
("1308","93","4","doing"),
("1309","93","5","doing"),
("1310","93","7","doing"),
("1311","93","8","doing"),
("1312","93","9","doing"),
("1299","93","10","doing"),
("1300","93","11","doing"),
("1301","93","12","doing"),
("1545","93","14","doing"),
("1303","93","15","doing"),
("1304","93","16","doing"),
("1305","93","17","doing"),
("1307","93","30","doing"),
("1313","94","1","doing"),
("1319","94","3","doing"),
("1374","94","5","doing"),
("1314","94","18","doing"),
("1315","94","19","doing"),
("1316","94","20","doing"),
("1317","94","21","doing"),
("1318","94","22","doing"),
("1321","95","1","doing"),
("1327","95","3","doing"),
("1375","95","5","doing"),
("1322","95","18","doing"),
("1323","95","19","doing"),
("1324","95","20","doing"),
("1325","95","21","doing"),
("1326","95","22","doing"),
("1329","96","1","doing"),
("1335","96","3","doing"),
("1376","96","5","doing"),
("1330","96","18","doing"),
("1331","96","19","doing"),
("1332","96","20","doing"),
("1333","96","21","doing"),
("1334","96","22","doing"),
("1337","97","1","doing"),
("1343","97","3","doing"),
("1377","97","5","doing"),
("1338","97","18","doing"),
("1339","97","19","doing"),
("1340","97","20","doing"),
("1341","97","21","doing"),
("1342","97","22","doing"),
("1345","98","1","doing"),
("1351","98","3","doing"),
("1378","98","5","doing"),
("1346","98","18","doing"),
("1347","98","19","doing"),
("1348","98","20","doing");
INSERT INTO student_subject VALUES
("1349","98","21","doing"),
("1350","98","22","doing"),
("1353","99","1","doing"),
("1359","99","3","doing"),
("1379","99","5","doing"),
("1354","99","18","doing"),
("1355","99","19","doing"),
("1356","99","20","doing"),
("1357","99","21","doing"),
("1358","99","22","doing"),
("1361","100","1","doing"),
("1367","100","3","doing"),
("1380","100","5","doing"),
("1362","100","18","doing"),
("1363","100","19","doing"),
("1364","100","20","doing"),
("1365","100","21","doing"),
("1366","100","22","doing"),
("1381","101","2","doing"),
("1390","101","3","doing"),
("1391","101","4","doing"),
("1392","101","5","doing"),
("1393","101","6","doing"),
("1394","101","7","doing"),
("1395","101","8","doing"),
("1396","101","9","doing"),
("1382","101","10","doing"),
("1383","101","11","doing"),
("1384","101","12","doing"),
("1385","101","13","doing"),
("1386","101","14","doing"),
("1387","101","15","doing"),
("1388","101","16","doing"),
("1389","101","17","doing"),
("1399","102","3","doing"),
("1400","102","4","doing"),
("1401","102","8","doing"),
("1402","102","9","doing"),
("1397","102","10","doing"),
("1398","102","17","doing"),
("1403","102","23","doing"),
("1404","102","24","doing"),
("1405","102","25","doing"),
("1406","102","26","doing"),
("1407","102","27","doing"),
("1409","102","29","doing"),
("1410","103","2","doing"),
("1419","103","3","doing"),
("1420","103","4","doing"),
("1421","103","5","doing"),
("1422","103","6","doing"),
("1423","103","7","doing"),
("1424","103","8","doing"),
("1425","103","9","doing"),
("1411","103","10","doing"),
("1412","103","11","doing"),
("1413","103","12","doing"),
("1415","103","14","doing"),
("1416","103","15","doing"),
("1417","103","16","doing"),
("1418","103","17","doing"),
("1466","104","1","doing"),
("1427","104","2","doing"),
("1430","104","3","doing"),
("1431","104","5","doing"),
("1432","104","7","doing"),
("1433","104","8","doing"),
("1426","104","18","doing"),
("1467","104","20","doing"),
("1468","105","1","doing"),
("1435","105","2","doing"),
("1438","105","3","doing"),
("1439","105","5","doing"),
("1440","105","7","doing"),
("1441","105","8","doing"),
("1434","105","18","doing"),
("1469","105","20","doing"),
("1470","106","1","doing"),
("1443","106","2","doing"),
("1446","106","3","doing"),
("1447","106","5","doing"),
("1448","106","7","doing"),
("1449","106","8","doing"),
("1442","106","18","doing"),
("1471","106","20","doing"),
("1472","107","1","doing"),
("1451","107","2","doing"),
("1454","107","3","doing"),
("1455","107","5","doing"),
("1456","107","7","doing"),
("1457","107","8","doing"),
("1450","107","18","doing"),
("1473","107","20","doing"),
("1505","108","2","doing"),
("1513","108","3","doing"),
("1515","108","4","doing"),
("1516","108","5","doing"),
("1517","108","7","doing"),
("1518","108","8","doing"),
("1519","108","9","doing");
INSERT INTO student_subject VALUES
("1506","108","10","doing"),
("1507","108","11","doing"),
("1508","108","12","doing"),
("1546","108","14","doing"),
("1510","108","15","doing"),
("1511","108","16","doing"),
("1512","108","17","doing"),
("1514","108","30","doing"),
("1520","109","2","doing"),
("1528","109","3","doing"),
("1530","109","4","doing"),
("1531","109","5","doing"),
("1532","109","7","doing"),
("1533","109","8","doing"),
("1534","109","9","doing"),
("1521","109","10","doing"),
("1522","109","11","doing"),
("1523","109","12","doing"),
("1547","109","14","doing"),
("1525","109","15","doing"),
("1526","109","16","doing"),
("1527","109","17","doing"),
("1529","109","30","doing");




CREATE TABLE `students` (
  `student_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_key` varchar(100) DEFAULT NULL,
  `school_id` int(10) unsigned NOT NULL,
  `parent_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `subclass_id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `hostel_id` int(11) NOT NULL,
  `room_id` int(11) NOT NULL,
  `bedspace` int(11) DEFAULT NULL,
  `first_name` varchar(50) NOT NULL,
  `other_name` varchar(50) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `serial_number` varchar(50) NOT NULL,
  `pass` char(255) NOT NULL,
  `first_password` varchar(200) NOT NULL,
  `new_password` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `dob` date NOT NULL,
  `gender` varchar(10) NOT NULL,
  `religion` varchar(50) NOT NULL,
  `reg_no` varchar(20) NOT NULL,
  `adm_no` varchar(60) NOT NULL,
  `graduation_year` varchar(20) NOT NULL,
  `graduation_term` varchar(10) NOT NULL,
  `deactivation_sess` char(20) NOT NULL,
  `deactivation_term` char(10) NOT NULL,
  `disability` varchar(300) NOT NULL,
  `passport` varchar(200) NOT NULL,
  `relationship` varchar(20) NOT NULL,
  `new_student` varchar(20) NOT NULL,
  `new_student_finance` varchar(20) NOT NULL,
  `forget_token` varchar(50) NOT NULL,
  `login_attempt` int(11) NOT NULL,
  `login_last_time` int(11) unsigned NOT NULL,
  `scratch_card_attempt` int(10) unsigned NOT NULL,
  `scratch_card_last_time` int(10) unsigned NOT NULL,
  `transfer` char(20) NOT NULL,
  `transfer_school_id` int(11) NOT NULL,
  `exempt` char(10) NOT NULL,
  `check_result` varchar(20) NOT NULL DEFAULT 'check_result',
  `activation` varchar(20) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`student_id`),
  UNIQUE KEY `serial_number` (`serial_number`),
  UNIQUE KEY `user_key` (`user_key`),
  KEY `activation` (`activation`),
  KEY `parent_id` (`parent_id`),
  KEY `plan_id` (`plan_id`),
  KEY `class_subclass` (`class_id`,`subclass_id`,`activation`),
  KEY `exempt` (`exempt`),
  KEY `check_result` (`check_result`),
  KEY `date_created` (`date_created`),
  KEY `school_id` (`school_id`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=latin1;


INSERT INTO students VALUES
("1","1169b0643f33","169","0","7","0","0","0","0","","OLAMIPOSI","","AKINOLA","S/20/0001","$2y$10$VAFO3F7B30tMHMPjSMG4SuOiHiuUC.Lg68XzTtT10159aF9AM7iWu","laolamiposi","laolamiposi","","2021-04-03","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 10:54:54"),
("2","2169b53c87ba","169","6","7","0","0","0","0","","DIKKO","","MARYAN","S/20/0002","$2y$10$kLZ25BACbvI8JE13zaLDIeKDh0t.LDByvoYVc9lVNPylHhTF7P1bC","amdikko","amdikko","","2021-04-24","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 10:55:31"),
("3","3169218cb7fc","169","0","7","0","0","0","0","","ISAAC","","H-AKINOLA","S/20/0003","$2y$10$aJNZXftDtTH0/VjCaLUfW.nG3LRdDF3bF4aezfsyga4YfNMAWduCq","laisaac","laisaac","","2021-04-24","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 10:56:04"),
("4","4169ae95c93a","169","0","7","0","0","0","0","","JESSICA","","OBEIYI","S/20/0004","$2y$10$sbBCVg.VTDz/HQm/qcBUNORnh9Gm1N/40Z5kkwsNuaIv9qGJLevh.","yijessica","yijessica","","2021-04-24","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 10:57:00"),
("5","5169c53ccdc6","169","0","7","0","0","0","0","","GABRIEL","","GIDEON","S/20/0005","$2y$10$lXEqFYAVQuAIuUleMm8zj.eXd3/70KPxoWsfslXwLd.T16Dx5L4Aq","ongabriel","ongabriel","","2021-04-24","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 10:57:59"),
("6","61695f97ab00","169","0","7","0","0","0","0","","ISRAEL","","GBADEBO","S/20/0006","$2y$10$yQewWgUTfa82xIlhxchtt.wtc8iJ7W4NqFTDcEvVFnGm3Qe3Cbs5q","boisrael","boisrael","","2021-04-24","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 10:58:31"),
("7","716988bf71b9","169","0","7","0","0","0","0","","GOODNESS","","CHIJIOKE","S/20/0007","$2y$10$GYdtXxh24octbpJo1xgunuadOYYLMR17u4jh.VrvT1MGewvg01856","legoodness","legoodness","","2021-04-24","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 10:59:08"),
("8","8169457c30a0","169","0","7","0","0","0","0","","JOAN","","ASIRU","S/20/0008","$2y$10$OyRJgWiHXRbDBpbHSkyG0.duxAIprGAJhoKdV9wBnsefy19wywgPS","rujoan","rujoan","","2021-04-24","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:00:22"),
("9","916995250202","169","0","7","0","0","0","0","","TABITHA","","AKANO","S/20/0009","$2y$10$S0Ic6kjchR7gYwSUYzfaJOQGdr11KZw3vU0I57PYWhsqpH1vlKIvu","potabitha","potabitha","","2021-04-24","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:01:09"),
("10","10169b51916b4","169","0","7","0","0","0","0","","ELIORA","UMAR","OZIGI","S/20/0010","$2y$10$L4p8rU7gLIPkf5tkcCtJpuu/byvcuGeliaernIiYxtAzuHchmGO/i","gieleora","gieleora","","2021-04-24","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:01:33"),
("11","11169eba24943","169","0","7","0","0","0","0","","DIVINE","","K-OWOEHO","S/20/0011","$2y$10$HAmTFFhFt8VqjG.dacF/v.CzOh9UqUSa3zICOiL/DE5VwmSB1G3VC","hodivine","hodivine","","2021-04-24","male","Christianity","","","","","2020/2021","2nd Term","","","","","new_student","","0","0","0","0","","0","","check_result","deactivated","2021-04-24 11:02:13"),
("12","12169f988738e","169","0","7","0","0","0","0","","STEPHANIE","","AMEADI","S/20/0012","$2y$10$T257aueEmlXF32Z6d1Z6yuzPd6nOaaIsEe9B3nLQ/vmPKeCWPxSLC","histephanie","histephanie","","2021-04-24","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:02:44"),
("13","13169fea3d914","169","0","7","0","0","0","0","","CHNONSO","","OBI","S/20/0013","$2y$10$ny.8UvJsGtld/rqViIxxIO96s9tgtS.5Toaace2YZIuVCaeh/FfLi","bichnonso","bichnonso","","2021-04-24","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:03:14"),
("14","14169ad6ae718","169","0","7","0","0","0","0","","OLAMIDE","","ALADE","S/20/0014","$2y$10$GIjbk16DanrWMzJJdrDXd.SajvvoWPg8oPeO7gtmsefubopyceW1m","deolamide","deolamide","","2021-04-24","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:04:11"),
("15","151692f416e7a","169","0","7","0","0","0","0","","YUSUF","","ALAMEEN","S/20/0015","$2y$10$7tACDYJXC.GOO6qUhpZRbeNY4WusdxuNe2DLHvr/IW.xMXDuDFRv.","enyusuf","enyusuf","","2021-04-24","male","Islam","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:04:42"),
("16","16169b0f068df","169","5","9","0","0","0","0","","RICHARD","","CHUKWUKA","S/20/0016","$2y$10$QMohA/QA55Vitcif9ijAcefN/OsxE5QAjCOIBLAXRBCs8p2Iin30i","karichard","karichard","","2010-08-21","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:05:22"),
("17","17169b828d764","169","4","9","0","0","0","0","","RONIA","M","AKINOLA","S/20/0017","$2y$10$h7dUYVROTWTzjTl5JfjiY.GHwCkLH1pcYAiaB0wHweZZ2G84.9DJK","laronia","laronia","","2011-01-28","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:05:59"),
("18","18169ca9de8b6","169","8","9","0","0","0","0","","OSINACHI","","OBAYI","S/20/0018","$2y$10$RkIJHjXV8RMIZ12SMCJ96.7bWGbBpOH94t.CaBAG/smsNOxbZu7jq","yiosinachi","yiosinachi","","2011-01-22","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:06:35"),
("19","19169e1d0e791","169","6","9","0","0","0","0","","AUBARKAR","","DIKKO","S/20/0019","$2y$10$Tfqnqae.U7FoXPFMI2UCF.pu9RCxIUBSMLC2ZFVLlLHl26o1AY.W6","koaubarkar","koaubarkar","","2011-10-10","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:07:09"),
("20","201692eb4c63d","169","9","9","0","0","0","0","","\'KANMA","","ONYEMAECHI","S/20/0020","$2y$10$cWRxmwDjhvCO064IddJB.usdKIxO8mYehlhCiWc99n6yh2BvK/9ce","hi\'kanma","hi\'kanma","","2012-06-09","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:08:02"),
("21","2116905c5ad08","169","13","9","0","0","0","0","","KING","FRED","ANAWO","S/20/0021","$2y$10$mt0a0ePY7X9EeBQq2EBCnO.PBAplDzK0N2GPCstbhT7CZwgIXAPxy","woking","woking","","2010-08-07","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:08:30"),
("22","221695c0e8b8f","169","11","9","0","0","0","0","","AISHAT","","SAIDU-YUSUF","S/20/0022","$2y$10$Us2Z8dnljlVqRAdfkkoYdOaOlgOiGYaSMo3ny9Db19sr2/3lmkOyi","duaishat","duaishat","","2010-11-22","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:08:54"),
("23","23169f92958f2","169","7","9","0","0","0","0","","ONAJITE","","FREDERICK","S/20/0023","$2y$10$/7hvZjjtw.YLAXIEOw7JTO.gtVS3JtKZsF0XuUvvbRSk3GG3OBsaq","ckonajie","ckonajie","","2011-10-14","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:09:35"),
("24","241697367ec2c","169","12","9","0","0","0","0","","JESSICA","","UKO","S/20/0024","$2y$10$dYTtcrjOIMh5zVOnzaZEluWd4wi14qZE8.CcfGL4RQ/IT0glYudoi","kojessica","kojessica","","2010-05-04","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:10:05"),
("25","251698dab08e7","169","0","8","0","0","0","0","","ABDULSALIM","","ABDULRAHMAN","S/20/0025","$2y$10$vUJhA9aanSgqT2o9/XFTQuAl46fu3CpZTMGvbJDeccNmeWHV137Zu","anabdulsalim","anabdulsalim","","2021-04-24","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:10:46"),
("26","26169656a95b7","169","24","8","0","0","0","0","","SHALOM","P","ADEJOH","S/20/0026","$2y$10$XXiWMlbRL2uoG6s.pssguO4PwyBEK17QpIDtgWh/qSbD1uhb35vp6","ohshalom","ohshalom","","2021-04-24","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:11:19"),
("27","271691ffe631f","169","0","8","0","0","0","0","","AYOOLA","","ATTE","S/20/0027","$2y$10$lrpSZfbu2G0b4lGdx0ixlej63z1VSGieXprTHPUEyT4PcMBtLF7Li","teayoola","teayoola","","2021-04-24","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:11:44"),
("28","28169829116a3","169","0","8","0","0","0","0","","BOLUWATIFE","","AYODELE","S/20/0028","$2y$10$9oOVuyL.kBjADTfkyz0fLebH7XrTrYmIXb8ovqXBomJALVTVqrirC","leboluwatife","leboluwatife","","2021-04-24","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:12:13"),
("29","2916917957a52","169","0","8","0","0","0","0","","TOBENNA","","EGERUE","S/20/0029","$2y$10$4WyW02mlMxhU9PNjUu97GexLiQ0Ke1u0QUAWIQKQmF.8niumbq8MW","uetobenna","uetobenna","","2021-04-24","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:12:37"),
("30","3016951f3b591","169","0","8","0","0","0","0","","PEACE","OBI","ENOP","S/20/0030","$2y$10$nYHHGVWNFmT8wxTCiVl44eYoEpl9bTOEd5AKpMkA.k4t4sLaYlwT6","oppeace","oppeace","","2021-04-24","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:13:08"),
("31","3116963d5bf48","169","0","8","0","0","0","0","","DIVINE","","JOSEPH","S/20/0031","$2y$10$PBi4GKtsYcFmwPoLXmhAk.o/mzu665JYghqlhX5CKGgYvS7aNssXi","phdivine","phdivine","","2021-04-24","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:13:40"),
("32","32169127dc17b","169","0","8","0","0","0","0","","SOPHIA","","NKEMAKOSI","S/20/0032","$2y$10$YE9bmL5Y6Q6.VX6jLOPY/OyI2vGYA4uRo7IhZebICfDtqGOokfaKu","sisophia","sisophia","","2021-04-24","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:14:06"),
("33","3316964a1fbc1","169","0","8","0","0","0","0","","IHEANYICHUKWU","","NWOSU","S/20/0033","$2y$10$TxuARoTIkK1drxH5rIDUveYoJ7cDuvos6G/2UBmshUNQEzLSFgZ5e","suiheanyichukwu","suiheanyichukwu","","2021-04-24","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:14:47"),
("34","341690e496252","169","0","8","0","0","0","0","","SOZO","","OCHOGWU","S/20/0034","$2y$10$kIKI3epTe5989VVrRQSqzOTvxd6tNd/TfFZHbNfhchCOcfB0QKpI2","wusozo","wusozo","","2021-04-24","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:16:27"),
("35","35169573cc14e","169","46","8","0","0","0","0","","KOSISOCHUKWU","","OSODE","S/20/0035","$2y$10$lXYiTtS9xUiNdOcAVTYWjOpU.72uAJgAXizscHj666f90gaoobwYi","dekosisochukwu","dekosisochukwu","","2021-04-24","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:16:53"),
("36","361698af357c5","169","0","8","0","0","0","0","","JOSEPH","JOSIAH","SABO","S/20/0036","$2y$10$j.sNG74iBPq53sG3KnQ5M.ZIQgc2IqxeTTtwjrM3bWmwNHSd7Alz.","bojoseph","bojoseph","","2021-04-24","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:17:25"),
("37","3716947f8122d","169","0","8","0","0","0","0","","DOOWUESE","","UMA","S/20/0037","$2y$10$VCk3LAAoc8Kjz6Mf/fE/ouDW3ODmJu6AsUHXXb5b38bCAotmx6rzG","madoowuese","madoowuese","","2021-04-24","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:18:08"),
("38","381696e6c8d03","169","0","8","0","0","0","0","","ANNAWNO","","VICTOR","S/20/0038","$2y$10$jety.WaeRdpsjEBrxZA3ReD8eUhe6ktBdzrDfYrztuSR2fKKJ4eQW","orannawno","orannawno","","2021-04-24","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:19:04"),
("39","39169186aa50c","169","0","8","0","0","0","0","","NICOLE","","IBEABUCHI","S/20/0039","$2y$10$q4lIeq7F3NKq/qR.Z8Q1OO9ywJn6deFEH7fTNlqNPD1tKf20K5UQq","hinicole","hinicole","","2021-04-24","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:19:45"),
("40","40169250e61e0","169","1","1","0","0","0","0","","ABDULSALAM","","RUKAYAT","S/20/0040","$2y$10$5HE/nAa.7b//UBBtiQ2peOS1uF3VlKRmmQcuzoCNZTUs.Kgko5F5i","zeonglobal","zeonglobal","","2021-04-01","female","Islam","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:42:53"),
("41","41169c64a20c9","169","2","1","0","0","0","0","","ALHASSAN","","MIYESOKO","S/20/0041","$2y$10$qyfPwxvNf98G6QhgbMByLuzZNtuByTypM8hH843D9o67LUNq1Qk/a","zeonglobal","zeonglobal","","2021-04-01","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:49:49"),
("42","42169da505646","169","18","1","0","0","0","0","","ELLA","","OLAYINKA","S/20/0042","$2y$10$HkLzIvtaaMraJlm0pkUwK.hDUmfziaqnd4dp6Zwc9qKP1T4b53ahO","kaella","kaella","","2021-04-01","female","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:51:40"),
("43","43169d10ebcae","169","0","1","0","0","0","0","","FOLARIN","","ALADE","S/20/0043","$2y$10$YFGKCwbvI.9.wKbUHSqiWe7nCya.ZAZG7OCvz2ZTJ2cI65rHoqZbK","bifolarin","bifolarin","","2021-04-01","female","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:52:26"),
("44","4416994616220","169","3","1","0","0","0","0","","ANDRE","","CHIJIOKE","S/20/0044","$2y$10$Lgo9QN36WT3Yo/NvzL2YT.dt57RRKuP0x57zjzJs7uPLuE2BjfbH.","zeonglobal","zeonglobal","","2018-09-24","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 11:56:04"),
("45","4516936bcd557","169","4","3","0","0","0","0","","OLAMIDE","","AKINOLA","S/20/0045","$2y$10$FWTdB1x1ufmBbJVEZbIet.E4dAh1T3AccJAJuxhlXcGjTWEC6gYI6","zeonglobal","zeonglobal","","2016-08-14","male","Christianity","20034","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 12:33:23"),
("46","46169c487ad48","169","0","10","0","0","0","0","","DAVID","A","ASIRU","S/20/0046","$2y$10$vqXfaSz0dl5/NDKD/jdZ3OOGROc62TwEoIu2JjRQ5lacrr5X5yHg.","rudaniel","rudaniel","","2011-06-28","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 12:39:35"),
("47","471692073f162","169","0","10","0","0","0","0","","DANIEL","C","PETER","S/20/0047","$2y$10$PuM7/KADuM6OfQNHCc/SQ.ZL2ka532rqint/e9O3w8E9XTmX.yP3m","erdaniel","erdaniel","","2011-03-11","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 12:40:38"),
("48","481697c9370df","169","0","10","0","0","0","0","","ELIZABETH","O","FEMI-GBADEBO","S/20/0048","$2y$10$xXGBMYTCxpxFPKIBen0IhO48WvkXK0Gk6hH8t/cyOkfmeheMixEUq","boelizabeth","boelizabeth","","2012-01-05","female","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 12:42:14"),
("49","49169c5535f3f","169","0","2","0","0","0","0","","JOSIAH","","LAWAL","S/20/0049","$2y$10$m2BO/jFFVAzQrYavpXjJ9O0cK2gHnTYn/hPw5yCxVBcu65QVGnFrG","aljosiah","aljosiah","","2021-04-01","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 13:42:21"),
("50","50169fd779802","169","0","2","0","0","0","0","","SONIA","","AMEACHI","S/20/0050","$2y$10$F4YEuvSitwvFGHZvn4flReYzuEkhidvT9e93ViVfcnV06mKj5f/YO","hisonia","hisonia","","2021-04-01","female","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 13:43:21"),
("51","5116930b4d911","169","0","2","0","0","0","0","","ABATI","","YUSUF","S/20/0051","$2y$10$lkerK/GlfjaVOYCvUOZQf.11H/bGvu3UhdFsARXMBSMd1T/POZOKm","ufabati","ufabati","","2021-04-01","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 13:44:07"),
("52","52169a584c33c","169","17","2","0","0","0","0","","OCHE","","OWOICHO","S/20/0052","$2y$10$g3SOoFIrfTzI3XjbfVXoXuPCGurl7QUlnsP94p/PHFz0tc9jXwIeK","hooche","hooche","","2021-04-02","male","Christianity","","","","","2020/2021","2nd Term","","","","","","","0","0","0","0","","0","","check_result","deactivated","2021-04-24 13:45:17"),
("53","53169cf2f33ec","169","0","2","0","0","0","0","","GIFT","","CHUKWUKA","S/20/0053","$2y$10$/D/q.8kM13YcWI29Wq02iep6ItKS1pryZq8oSDitnMWyUshZKR5eG","kagift","kagift","","2021-04-01","female","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 13:46:57"),
("54","541696d197d94","169","1","5","0","0","0","0","","AISHA","","ABDULSALAM","S/20/0054","$2y$10$.J3IIwfF2tN5OdOgADamD.gsE77RhnjbL7e.ndAiZz6r7bAhkOfb6","amaisha","amaisha","","2021-04-24","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 13:48:26"),
("55","5516948d1a1e9","169","24","5","0","0","0","0","","PRAISE","BRIAN","ADEJOH","S/20/0055","$2y$10$0a/KVtPjM3JdeBnG.AS8FeEMRLmcV0n58QeHvgQJRxUcPjKkeznkG","ohpraise","ohpraise","","2014-06-08","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 13:49:34"),
("56","5616971276856","169","23","5","0","0","0","0","","ROSELINE","","EGERUE","S/20/0056","$2y$10$6YYk4NqOYQCU5ak8A.Va0u2erirsxG7ZASSguPLilzzaiswNWGjym","ueroseline","ueroseline","","2014-03-04","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 13:50:24"),
("57","57169d94b4387","169","22","5","0","0","0","0","","CHIDUBE","DAVID","ENDY-NKUME","S/20/0057","$2y$10$7zWd6INb6yGJwL3r641SnOGJ55YBbcgQJBsqsHMdO4Z0849gHnx46","mechidube","mechidube","","2015-07-07","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 13:51:24"),
("58","58169942fe70a","169","21","5","0","0","0","0","","FEMI","PRECIOUS","GBADEBO","S/20/0058","$2y$10$yvkYbj8xbUDs6Q14ObhMI.chp9ftncT.cHRQ.zDuGNf0XUIYtNsO2","bofemi","bofemi","","2015-10-18","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 13:52:28"),
("59","59169c0e638b3","169","20","5","0","0","0","0","","TEHILAH","","LAWAL","S/20/0059","$2y$10$.Z1tl.hshXcCN2SU7Zu4a.mRyzRzC8HHeIBPArLO//FYbtpWaGGKO","altehilah","altehilah","","2015-10-21","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 13:53:24"),
("60","60169b3395dc6","169","19","5","0","0","0","0","","EINSTEIN","","OBI","S/20/0060","$2y$10$BB2w9BqicpaGNkGed9/o0e5apUS3yn0f.X60kiiBHnUsIKTtt7/jS","bieinstein","bieinstein","","2015-02-27","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 13:54:11"),
("61","61169c8f69951","169","18","5","0","0","0","0","","SUCCESS","","OLAYINKA","S/20/0061","$2y$10$n06F9rO9YknJlf0evN7ZzudXEfGkgP3eyfYr4RUhkocmgn9CEK3FC","kasuccess","kasuccess","","2015-10-01","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 13:54:55"),
("62","62169cb335fb2","169","17","5","0","0","0","0","","VICTORY","","OWOICHO","S/20/0062","$2y$10$Z29Is8Qu4H7dalvrkgLnIO4LMBb9QHY76bE/iT3FNq4z9zpUgwsmq","hoihotu","hoihotu","","2015-04-24","female","Christianity","","","","","2020/2021","2nd Term","","","","","new_student","","0","0","0","0","","0","","check_result","deactivated","2021-04-24 13:55:36"),
("63","631694f6d71df","169","7","5","0","0","0","0","","WINIFRED","UVIE","FREDERICK","S/20/0063","$2y$10$iRWI3E5EjRI2iEV2/VNiJuMKS79LD0VZCQxoDAkjb/QC.Z5/OF7a6","ckwinifred","ckwinifred","","2015-01-11","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 13:57:12"),
("64","64169b671aaa5","169","16","5","0","0","0","0","","JEMILA","","YUSUF","S/20/0064","$2y$10$2GBcHoCUXeT537e0Q6IvWuAckhCojssyyr34Q50R2T.sA3TFFcvx6","ufjemila","ufjemila","","2015-01-27","female","Islam","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 13:58:53"),
("65","651694027c5ee","169","0","5","0","0","0","0","","DANIEL","","VICTOR","S/20/0065","$2y$10$cr6yqewKc6iz2Mdn0EzpMOcRb3c5TaTprwMi2bW4PoIfrVE3ivjCG","ordaniel","ordaniel","","2021-04-24","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 13:59:22"),
("66","6616933610933","169","15","5","0","0","0","0","","SUCCESS","UGOCHUKWU","NJIMAH","S/20/0066","$2y$10$0nAh6X83z7bifyyrgRQdfuaE9zt6plnEMLL9keKiXqNtkMSjAanBy","ahsuccess","ahsuccess","","2015-04-24","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-24 14:00:10"),
("67","67169027bb744","169","14","5","0","0","0","0","","DANIEL","","ASIKIE","S/20/0067","$2y$10$wDMhbu5wE6.VFMM69U99QOkO4EN48DoCh7Kq.cqsLDwyYQf6e.MqS","kedaniel","kedaniel","","2014-12-25","male","Christianity","","","","","2020/2021","1st Term","","","","","new_student","","0","0","0","0","","0","","check_result","deactivated","2021-04-24 14:00:47"),
("68","6816975cf4f0e","169","14","5","0","0","0","0","","DAVID","","ASIKIE","S/20/0068","$2y$10$FSy7GghJzfzYm5ClqCUY8OztR8VQC5907zTL4xdZ7SPTe2Is/mYd2","iedavid","iedavid","","2014-12-25","male","Christianity","","","","","2020/2021","1st Term","","","","","new_student","","0","0","0","0","","0","","check_result","deactivated","2021-04-24 14:01:21"),
("69","691698067ef6b","169","25","3","0","0","0","0","","CHARLES","","CHIJIOKE","S/20/0069","$2y$10$TJ64HJqIGZfHXDUyu77DEuLaBeKvl7gnknl8eN7LT7fRjhk2FJxLy","kecharles","kecharles","","2016-02-13","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 14:15:24"),
("70","701697fc17618","169","26","3","0","0","0","0","","CHISOM","","EWELIKE","S/20/0070","$2y$10$H0wy0sW8mopC6sZ.aAgoleE0Tf5X9wNeRn7Lc5b.YzKahkUFtZDHq","zeonglobal","zeonglobal","","2016-03-15","female","Christianity","","","","","2020/2021","1st Term","","","PARENT","","","","0","0","0","0","","0","","check_result","deactivated","2021-04-24 14:21:26"),
("71","7116946ae1366","169","0","3","0","0","0","0","","EMMANUEL","","JOSEPH","S/20/0071","$2y$10$FWum0Tqrt3Y3630nJR4kAu3QnF5tlGMkRfiphUJqCg4PR0GfdDc2G","phemmanuel","phemmanuel","","2017-06-11","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 14:22:41"),
("72","721697685a8f6","169","27","3","0","0","0","0","","ONYEDIKACHI","","OBAYI","S/20/0072","$2y$10$CcjC3FyXi08ryx92/qqcgul6TnoCPOywBmF.ehJv623kFf7Ou7AGK","zeonglobal","zeonglobal","","2016-03-14","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 14:25:53"),
("73","7316967c9f2e1","169","28","3","0","0","0","0","","IBRAHIM","JIMBA","MUHAMMED","S/20/0073","$2y$10$dM1SZb//prqHOsOxKs2ePe11GJYsGiuggFMdo4tlDeIW0skreh5AG","zeonglobal","zeonglobal","","2016-05-02","male","ISLAM","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 14:29:40"),
("74","74169de561674","169","16","3","0","0","0","0","","FATIMA","","YUSUF","S/20/0074","$2y$10$XTdvXysCM/dbSyWuSkjumOwIR7cZcP9XwNbdgruuBLtOqLzJprIEC","uffatima","uffatima","","2016-06-03","female","Islam","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 14:36:15"),
("75","7516922b9dee1","169","29","3","0","0","0","0","","DEBORAH","FOLAWE","ALADE","S/20/0075","$2y$10$CD2sE7Wfrx1XPOy6T5mx.uNFl18Zd.uELDBz08excjPghDgtxGRpG","zeonglobal","zeonglobal","","2021-04-01","female","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 14:40:59"),
("76","76169d75e2b3f","169","35","3","0","0","0","0","","ASIN","EARL","MONDAY","S/20/0076","$2y$10$hFp/soBt09.TxGpdAkTAA.yy3I4HRFLqJpUymhTXnxrqGOV6IX8li","zeonglobal","zeonglobal","","2016-10-14","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 14:48:38"),
("77","7716946a08437","169","36","3","0","0","0","0","","ISMAIL","","YAHAYI","S/20/0077","$2y$10$XBckptjLHv./qXPPnyKfculSM6MIJOHE4qQMweu78ccy4g1HjiVpO","yiismail","yiismail","","2016-12-22","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 15:27:14"),
("78","78169ef0479f1","169","38","3","0","0","0","0","","ANYAOHA","C","EMMANUELLA","S/20/0078","$2y$10$OCWJVDhn7KORtUt/oSpIa.Of3yzfUvhZoXyCnVObsufbxm8WgOkXG","zeonglobal","zeonglobal","","2016-03-21","female","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 15:29:53"),
("79","791695580a287","169","39","3","0","0","0","0","","ANAWO","","DIVINE-GRACE","S/20/0079","$2y$10$gifOEBDJvyUXtbqzENiQeOrvZZL1eQyYKA0b6iq.3efTcQGSGewIq","zeonglobal","zeonglobal","","2016-04-12","female","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 15:33:16"),
("80","801691651e38f","169","40","3","0","0","0","0","","MUNACHI","IBEABUCHI","DARYL","S/20/0080","$2y$10$YKRm2jS5a9FyPOMZKSyRI.9.AoQ4OJ51tUEJii3pAwU1w3yrlVBIe","zeonglobal","zeonglobal","","2016-11-12","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 15:36:51"),
("81","811691fe98724","169","41","3","0","0","0","0","","CHIDUBEM","","OKOYE","S/20/0081","$2y$10$zrCzWbc6lEpd.U4H11HrLOO0Wv6sSJQS5xr9dsQuhyPfGH239KQ4K","zeonglobal","zeonglobal","","2021-04-01","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 15:41:06"),
("82","821698c1b3387","169","2","6","0","0","0","0","","OLUWASEUN","","ALHASSAN","S/20/0082","$2y$10$0X5gt5.BOud4pEdf2ybfRO3N3vz8JE6E3BgGO.b5neoFxjkL0uYkS","anoluwaseun","anoluwaseun","","2014-10-10","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 17:38:35"),
("83","8316973761223","169","2","6","0","0","0","0","","OLUWASEYI","","ALHASSAN","S/20/0083","$2y$10$k8qALGWbAFrJvN8PZ8MAH.WFWmUloqc.NAz6ZRRP1l7SLVgHpzPLy","anoluwaseyi","anoluwaseyi","","2014-10-10","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 17:39:49"),
("84","84169a15a0337","169","3","6","0","0","0","0","","DOMINION","","CHIJIOKE","S/20/0084","$2y$10$e19ybEfrsSo1zwWsEgzoh.GWiRGYlsP8X/Qa2d/3TEi4AhCeTl0ce","kedominion","kedominion","","2014-11-24","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 17:40:51"),
("85","85169fc27b739","169","42","6","0","0","0","0","","NMESOMA","","CHIDI","S/20/0085","$2y$10$Fy3mxSGXSaVo5XZb0nBwuOBRl6DgP/tdzI0Gy.RE696mMh/AaD9Ve","dinmesoma","dinmesoma","","2014-10-09","female","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 17:41:52"),
("86","86169c5f0b960","169","43","6","0","0","0","0","","JOSHUA","","JOSEPH","S/20/0086","$2y$10$e5KcTs32RiHXssMbyc7DUufmxVrG2f6k4BL1Hz5.0P.0UaqKwXSle","phjoshua","phjoshua","","2014-06-03","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 17:43:05"),
("87","87169d2dc6fae","169","28","6","0","0","0","0","","MUBARAQ","","MOHAMMED","S/20/0087","$2y$10$6KVDpdtP/bBnqLjbxyssL.ombN99wDZrZT7W1va.wqJ/Qh28yizUC","edmubaraq","edmubaraq","","2014-10-26","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 17:44:35"),
("88","881690c3a2054","169","44","6","0","0","0","0","","TREASURE","","OKIM","S/20/0088","$2y$10$knClL3dyck8bhh58i3Ii.ewaBnheZAljaiuv/XJMXoy1PMYyue.zW","imtreasure","imtreasure","","2014-05-09","female","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 17:46:46"),
("89","89169c2347bcc","169","0","6","0","0","0","0","","CHUKWUEBUKA","","EWELIKE","S/20/0089","$2y$10$GXUKE71rUdew0q43rrHu2.3ELThETC3UXQVR8UFPFkvSmjuacF6w.","kechukwuebuka","kechukwuebuka","","2021-04-01","male","Christianity","","","","","2020/2021","1st Term","","","","","","","0","0","0","0","","0","","check_result","deactivated","2021-04-24 17:48:42"),
("90","90169cd2a8480","169","45","6","0","0","0","0","","WILLIAMS","","JADEN","S/20/0090","$2y$10$56qUvsWdutpnxP0YSEU3hODyDHETsF.F3XHOLV.PcWcKWvfcEEMCq","enwilliams","enwilliams","","2014-03-26","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 17:50:18"),
("91","911693645a1fe","169","46","6","0","0","0","0","","CHUKWUDUBEM","","OSODE","S/20/0091","$2y$10$X63cOswLvol1zoIwmVccIeVlzNMiVgOVs9X3BZuEVt0lrQRmzNKlu","dechukwudubem","dechukwudubem","","2014-04-10","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 17:56:14"),
("92","92169f40615f3","169","0","6","0","0","0","0","","EFE","","FREDERICK","S/20/0092","$2y$10$1X42x2HZyzkiekZy0X/FZeCr/Q/rGOrs1AwnW.z62PsnP1BwdFjMW","ckefe","ckefe","","2021-04-01","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 17:58:24"),
("93","931694501bf29","169","0","6","0","0","0","0","","YUSUF","","MASURDEEN","S/20/0093","$2y$10$gD4Th62no0ule2ceOPU0K.iZ579a92gaJkPObIQ7DjPywYX0QusOW","enyusuf","enyusuf","","2021-04-01","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-24 18:20:22"),
("94","941691de7ab64","169","0","1","0","0","0","0","","HEAVENLY",""," GEORGE","S/20/0094","$2y$10$t9C5ZNNNqf2tDZbqylxLC.B4PzcL7FV1Jb8E14xRyh8dnuj89mJ32","geheavenly","geheavenly","","2021-04-01","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-26 09:16:24"),
("95","951698ea8a8fe","169","0","1","0","0","0","0","","ZOE","","OKOYE","S/20/0095","$2y$10$zRJycb/jqoQefTgWBjZIGOw74/Zb28J26unk3tQ5kVM3rJYfAZLjW","yezoe","yezoe","","2021-04-01","female","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-26 09:17:24"),
("96","961690c068802","169","0","1","0","0","0","0","","EMMANUELLA","","ANAWO","S/20/0096","$2y$10$8pz..iSwdBXxxTsFOiBpNez52hFVTZvdkVeoYGBocE724r0LLdtaW","woemmanuella","woemmanuella","","2021-04-01","female","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-26 09:18:13"),
("97","9716979e946a9","169","0","1","0","0","0","0","","CHIZITEREM","","AJAH","S/20/0097","$2y$10$0XJTEgAjXkZkNjMlU5V1oOBLIPH.eKA7NzG2BOrWdGXfw2VB2OPQC","ahchiziterem","ahchiziterem","","2021-04-01","male","Christianity","","","","","","","","","","new_student","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-26 09:22:12"),
("98","98169f9d3ddda","169","0","1","0","0","0","0","","ESEOSE","","AUSTINE","S/20/0098","$2y$10$V48ObaxwXuMwepNcOYEcoeFBnI2DyY.82y2Q3nfaDND1Xt87haCDa","neeseose","neeseose","","2021-04-01","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-26 09:23:10"),
("99","99169b51a8a5a","169","0","1","0","0","0","0","","ILESANMI","","IREOLUWA","S/20/0099","$2y$10$0Dig3FW9imNhaRS/DuzQueZ4PN3uRlR04OHoa356B80zA..qQmszy","wailesanmi","wailesanmi","","2021-04-01","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-26 09:30:48"),
("100","1001691502e625","169","0","1","0","0","0","0","","CHIJIOKE","","CHRISTABEL","S/20/0100","$2y$10$eleG77SbfBGKQIlAg/VUA.CIFmVRlvW3io0LYkDHgGwAULVJ4EcOK","elchijioke","elchijioke","","2021-04-01","female","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-26 09:32:12");
INSERT INTO students VALUES
("101","101169300128fe","169","0","7","0","0","0","0","","DAVID","","ADETAYO","S/20/0101","$2y$10$7C9VvZwtnnHdBEVs0Uggm.feNx09QjFeLN1OEY6KyyqfM1ItJrxRK","yodavid","yodavid","","2021-04-26","male","Christianity","","","","","","","","","","new_student","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-26 10:35:50"),
("102","10216906e66057","169","0","10","0","0","0","0","","KELECHI","B","NJIMAH","S/20/0102","$2y$10$eiuwwCLeWPF1Mtl9YAwHQejAB.WKnxOWHM9drf5/kcD3j4Nbceqh2","ahkelechi","ahkelechi","","2021-04-01","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-26 10:37:29"),
("103","103169eb2a31ab","169","0","9","0","0","0","0","","SHARON","","ADETAYO","S/20/0103","$2y$10$i8CeJGiRg70JFAnf7clevO.IXt6iqgO/CaQnv6Q5bn3FpoyzaI4Sq","yosharon","yosharon","","2021-04-26","female","Christianity","","","","","","","","","","new_student","new_student","","0","0","0","0","","0","","check_result","activated","2021-04-26 10:46:32"),
("104","104169f15f805c","169","0","2","0","0","0","0","","IFEANYI","","NJIMAH","S/20/0104","$2y$10$UoqiwbNviBPue5JAG0Z2cu3EOk1GuEDd.0yNvn3kdzfVn18fCik9G","ahifeanyi","ahifeanyi","","2021-04-01","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-26 16:44:11"),
("105","1051696b8e1bfa","169","0","2","0","0","0","0","","MARIYA","","ADAMU","S/20/0105","$2y$10$iKSLRTdOyq.rUuNCeTQNEeg/b6C469ilsZEKlfEvnUUpOZkXxAx0e","mumariya","mumariya","","2021-04-01","female","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-26 16:44:43"),
("106","1061695b54c578","169","0","2","0","0","0","0","","AMINA","","DIKKO","S/20/0106","$2y$10$n5x/ECwBw2pttxyEYI3rX.SQQX7nsZ5KAju9M8cDtbtp.rQTCfLIa","koamina","koamina","","2021-04-01","female","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-26 16:45:29"),
("107","1071690feafaea","169","0","2","0","0","0","0","","ISABEL","","OGBEIDE","S/20/0107","$2y$10$QXuIYrbCHizNKpko2zIVOOQZVlEOayvdx82hK4Pd9bO50UkpyjX4e","deisabel","deisabel","","2021-04-01","female","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-26 16:47:16"),
("108","108169398717c9","169","0","6","0","0","0","0","","IFUNANYA","","OKOYE","S/20/0108","$2y$10$sKuKb9hqPiWfUGrwviDroeyyP.YSh.D7SsQdy6VRpyWa0nNbkMpZq","yeifunanya","yeifunanya","","2021-04-02","female","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-27 10:01:44"),
("109","109169e1f55b32","169","0","6","0","0","0","0","","MOSES","","KEFAS","S/20/0109","$2y$10$2DPEqUewjDh7.lALprmP9eTRyYSNlcon3ba37y36YxlcMvxddnlK2","asmoses","asmoses","","2021-04-01","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-04-27 10:06:55");




CREATE TABLE `subclass` (
  `subclass_id` int(11) NOT NULL AUTO_INCREMENT,
  `subclass_name` varchar(30) NOT NULL,
  PRIMARY KEY (`subclass_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `subject_class` (
  `subject_class_id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  PRIMARY KEY (`subject_class_id`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=latin1;


INSERT INTO subject_class VALUES
("1","1","1"),
("3","1","3"),
("4","1","4"),
("6","2","6"),
("7","2","7"),
("8","2","8"),
("9","2","9"),
("11","10","7"),
("12","11","7"),
("13","12","7"),
("14","13","7"),
("15","14","7"),
("16","15","7"),
("17","16","7"),
("18","17","7"),
("19","3","7"),
("20","4","7"),
("21","5","7"),
("22","6","7"),
("23","7","7"),
("24","8","7"),
("25","9","7"),
("26","10","8"),
("27","11","8"),
("28","12","8"),
("30","14","8"),
("31","15","8"),
("32","16","8"),
("33","17","8"),
("34","3","8"),
("35","4","8"),
("36","5","8"),
("37","6","8"),
("38","7","8"),
("39","8","8"),
("40","9","8"),
("41","10","9"),
("42","11","9"),
("43","12","9"),
("45","14","9"),
("46","15","9"),
("47","16","9"),
("48","17","9"),
("49","3","9"),
("50","4","9"),
("51","5","9"),
("52","6","9"),
("53","7","9"),
("54","8","9"),
("55","9","9"),
("56","18","1"),
("57","19","1"),
("58","20","1"),
("59","21","1"),
("60","22","1"),
("61","3","1"),
("63","10","10"),
("64","17","10"),
("65","3","10"),
("66","4","10"),
("67","8","10"),
("68","9","10"),
("69","23","10"),
("70","24","10"),
("71","25","10"),
("72","26","10"),
("73","27","10"),
("75","29","10"),
("76","18","2"),
("77","2","2"),
("80","3","2"),
("81","5","2"),
("82","7","2"),
("83","8","2"),
("84","2","3"),
("85","3","3"),
("86","5","3"),
("87","8","3"),
("89","19","3"),
("90","21","3"),
("91","9","3"),
("92","10","5"),
("93","12","5"),
("94","13","5"),
("95","15","5"),
("96","17","5"),
("97","23","5"),
("99","3","5"),
("100","4","5"),
("101","5","5"),
("102","7","5"),
("103","8","5"),
("104","9","5"),
("105","16","5"),
("106","30","5"),
("107","14","5"),
("108","10","6"),
("109","11","6"),
("110","12","6"),
("112","15","6");
INSERT INTO subject_class VALUES
("113","16","6"),
("114","17","6"),
("115","3","6"),
("116","30","6"),
("117","4","6"),
("118","5","6"),
("119","7","6"),
("120","8","6"),
("121","9","6"),
("122","5","1"),
("123","1","2"),
("124","20","2"),
("125","11","5"),
("126","20","3"),
("127","14","6");




CREATE TABLE `subjects` (
  `subject_id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_name` varchar(50) NOT NULL,
  `subject_short` varchar(30) NOT NULL,
  `groups` varchar(100) NOT NULL,
  PRIMARY KEY (`subject_id`),
  KEY `groups` (`groups`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;


INSERT INTO subjects VALUES
("1","RHYMES","RHYMES","nursery"),
("2","ENGLISH LANGUAGE ","ENG","both"),
("3","MATHEMATICS","MATHS","both"),
("4","SPELLING/DICTATION","SPELLING/DICTATION","primary"),
("5","BASIC SCIENCE","BASIC SCI.","both"),
("6","INFORMATION AND COMMUNICATION TECHNOLOGY","I.C.T","primary"),
("7","PHYSICAL AND HEALTH EDUCATION","P.H.E","both"),
("8","RELIGION AND NATIONAL VALUES","RELIGION AND NAT. VALUES","both"),
("9","SOCIAL STUDIES","SOCIAL STUD.","both"),
("10","CIVIC EDUCATION","CIVIC EDU.","primary"),
("11","VOCATIONAL STUDIES","VOCATIONAL STUD.","primary"),
("12","AGRICULTURAL SCIENCE ","AGRIC SCI.","primary"),
("13","HAUSA","HAUSA","primary"),
("14","CULTURAL AND CREATIVE ARTS","C.C.A","both"),
("15","FRENCH","FRENCH","primary"),
("16","HOME ECONOMICS","HOME ECONS.","primary"),
("17","MUSIC","MUSIC","primary"),
("18","SOCIAL HABIT","SOCHAB","nursery"),
("19","HEALTH HABITS","HHAD","nursery"),
("20","COLOURING","COL","nursery"),
("21","PICTURE READING","PICS","nursery"),
("22","LITERACY","LIT","both"),
("23","READING","READ","both"),
("24","HANDWRITING","HW","both"),
("25","GEOGRAPHY","GEOG","primary"),
("26","FINE ARTS","FINE-ARTS","both"),
("27","CRAFTS","CRAFT","both"),
("28","ELEMENTARY SCIENCE","ELE-SCIENCE","primary"),
("29","GRAMM AND COMP","GRAMM","both"),
("30","COMPUTER STUDIES","COMP-STU","both");




CREATE TABLE `test` (
  `test_id` int(11) NOT NULL AUTO_INCREMENT,
  `test_page_id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `subclass_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `class_name` varchar(50) NOT NULL,
  `subclass_name` varchar(50) NOT NULL,
  `subject_name` varchar(100) NOT NULL,
  `student_score` float DEFAULT NULL,
  `status` varchar(10) NOT NULL,
  `sessions` char(20) NOT NULL,
  `terms` char(20) NOT NULL,
  PRIMARY KEY (`test_id`),
  KEY `test_page_id` (`test_page_id`),
  KEY `class_id` (`class_id`),
  KEY `subclass_id` (`subclass_id`),
  KEY `subject_id` (`subject_id`),
  KEY `student_score` (`student_score`),
  KEY `status` (`status`),
  KEY `sessions` (`sessions`),
  KEY `terms` (`terms`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `test_page` (
  `test_page_id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `subclass_id` int(11) NOT NULL,
  `class_name` varchar(50) NOT NULL,
  `subclass_name` varchar(50) NOT NULL,
  `subject_name` varchar(100) NOT NULL,
  `test_title` varchar(100) NOT NULL,
  `total_score` float NOT NULL,
  `students` int(11) NOT NULL,
  `status` varchar(10) NOT NULL,
  `sessions` char(20) NOT NULL,
  `terms` char(20) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`test_page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `topic` (
  `topic_id` int(11) NOT NULL AUTO_INCREMENT,
  `topic_name` varchar(200) NOT NULL,
  `class_id` int(11) NOT NULL,
  `subclass_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `table_name` varchar(20) NOT NULL,
  `published` varchar(20) NOT NULL DEFAULT 'not_published',
  `discussion_signal` tinyint(4) NOT NULL,
  `sessions` varchar(15) NOT NULL,
  `terms` varchar(15) NOT NULL,
  `date_added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`topic_id`),
  KEY `class_id` (`class_id`),
  KEY `subclass_id` (`subclass_id`),
  KEY `subject_id` (`subject_id`),
  KEY `user_id` (`user_id`),
  KEY `published` (`published`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;






CREATE TABLE `topic_discussions` (
  `topic_discussions_id` int(11) NOT NULL AUTO_INCREMENT,
  `topic_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `table_name` varchar(20) NOT NULL,
  `discussion` varchar(300) NOT NULL,
  `date_added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`topic_discussions_id`),
  KEY `user_id` (`user_id`),
  KEY `topic_id` (`topic_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;






CREATE TABLE `transfer_current_fees_info` (
  `current_fees_info_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `student_id` int(11) unsigned NOT NULL,
  `class_id` int(10) unsigned NOT NULL,
  `current_school_fees` decimal(15,2) NOT NULL,
  `past_debt` decimal(15,2) NOT NULL,
  `amount_to_pay` decimal(15,2) NOT NULL,
  `amount_paid` decimal(15,2) NOT NULL,
  `discount` decimal(15,2) NOT NULL,
  `surcharge_amount` decimal(15,2) NOT NULL,
  `surcharge_reason` varchar(500) NOT NULL,
  `wave_over` decimal(15,2) NOT NULL,
  `owing` decimal(15,2) NOT NULL,
  `present_owing` decimal(15,2) NOT NULL,
  `class_fee` decimal(15,2) NOT NULL,
  `plan_fee` decimal(15,2) NOT NULL,
  `new_student_fee` decimal(15,2) NOT NULL,
  `room_fee` decimal(15,2) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  PRIMARY KEY (`current_fees_info_id`),
  KEY `student_id` (`student_id`),
  KEY `sess_term` (`sessions`,`terms`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `transfer_fees_discount` (
  `fees_discount_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `reason` varchar(300) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  PRIMARY KEY (`fees_discount_id`),
  KEY `student_id` (`student_id`),
  KEY `session_term` (`sessions`,`terms`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `transfer_result_main` (
  `result_main_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `class_name` char(50) NOT NULL,
  `section` varchar(10) NOT NULL,
  `subclass_id` int(11) NOT NULL,
  `subclass_name` char(50) NOT NULL,
  `total` float NOT NULL,
  `cumulative_total` float NOT NULL,
  `total_obtainable` float NOT NULL,
  `cumu_total_obtainable` float NOT NULL,
  `average` varchar(10) NOT NULL,
  `cumulative_average` varchar(10) NOT NULL,
  `position_class` varchar(20) NOT NULL,
  `cumulative_position_class` varchar(20) NOT NULL,
  `position_subclass` varchar(20) NOT NULL,
  `cumulative_position_subclass` varchar(20) NOT NULL,
  `student_attendance` int(11) DEFAULT NULL,
  `total_attendance` int(11) DEFAULT NULL,
  `total_student_class` int(10) unsigned NOT NULL,
  `total_student_subclass` int(10) unsigned NOT NULL,
  `cumulative_total_student_class` int(10) unsigned NOT NULL,
  `cumulative_total_student_subclass` int(10) unsigned NOT NULL,
  `handwriting` int(11) NOT NULL,
  `cumulative_handwriting` int(11) NOT NULL,
  `neatness` int(11) NOT NULL,
  `cumulative_neatness` int(11) NOT NULL,
  `punctuality` int(11) NOT NULL,
  `cumulative_punctuality` int(11) NOT NULL,
  `attentiveness` int(11) NOT NULL,
  `cumulative_attentiveness` int(11) NOT NULL,
  `initiative` int(11) NOT NULL,
  `cumulative_initiative` int(11) NOT NULL,
  `respect` int(11) NOT NULL,
  `cumulative_respect` int(11) NOT NULL,
  `obedience` int(11) NOT NULL,
  `cumulative_obedience` int(11) NOT NULL,
  `attitude` int(11) NOT NULL,
  `cumulative_attitude` int(11) NOT NULL,
  `honesty` int(11) NOT NULL,
  `cumulative_honesty` int(11) NOT NULL,
  `creativity` int(11) NOT NULL,
  `cumulative_creativity` int(11) NOT NULL,
  `behaviour1_name` varchar(100) NOT NULL,
  `behaviour2_name` varchar(100) NOT NULL,
  `behaviour3_name` varchar(100) NOT NULL,
  `behaviour4_name` varchar(100) NOT NULL,
  `behaviour5_name` varchar(100) NOT NULL,
  `behaviour6_name` varchar(100) NOT NULL,
  `behaviour7_name` varchar(100) NOT NULL,
  `behaviour8_name` varchar(100) NOT NULL,
  `behaviour9_name` varchar(100) NOT NULL,
  `behaviour10_name` varchar(100) NOT NULL,
  `promotion` varchar(50) NOT NULL,
  `promotion_class_id` int(11) NOT NULL,
  `promotion_class_name` varchar(50) NOT NULL,
  `promotion_comment` varchar(500) NOT NULL,
  `promotion_subclass_id` int(11) NOT NULL,
  `promotion_subclass_name` varchar(50) NOT NULL,
  `pass_ave` varchar(5) NOT NULL,
  `scratch_card_number` varchar(16) NOT NULL,
  `next_term_begins` date NOT NULL,
  `ca1_total_score` float NOT NULL,
  `ca2_total_score` float NOT NULL,
  `ca3_total_score` float NOT NULL,
  `ca4_total_score` float NOT NULL,
  `ca5_total_score` float NOT NULL,
  `ca6_total_score` float NOT NULL,
  `ca_total_score` float NOT NULL,
  `exam_total_score` float NOT NULL,
  `no_of_ca` int(11) NOT NULL,
  `exam_name` varchar(50) NOT NULL,
  `ca_name_1` varchar(50) NOT NULL,
  `ca_name_2` varchar(50) NOT NULL,
  `ca_name_3` varchar(50) NOT NULL,
  `ca_name_4` varchar(50) NOT NULL,
  `ca_name_5` varchar(50) NOT NULL,
  `ca_name_6` varchar(50) NOT NULL,
  `principal_name` varchar(100) NOT NULL,
  `principal_comment` text NOT NULL,
  `form_staff_name` varchar(200) NOT NULL,
  `form_staff_comment` text NOT NULL,
  `student_affairs_comment` text NOT NULL,
  `cumulative_principal_comment` text NOT NULL,
  `cumulative_form_staff_comment` text NOT NULL,
  `principal_signature` varchar(150) NOT NULL,
  `second_principal_signature` varchar(60) NOT NULL,
  `visited` int(11) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  PRIMARY KEY (`result_main_id`),
  KEY `student_id` (`student_id`),
  KEY `sessions` (`sessions`),
  KEY `terms` (`terms`),
  KEY `promotion` (`promotion`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `transfer_result_subject` (
  `result_subject_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `subclass_id` int(11) NOT NULL,
  `class_name` varchar(50) NOT NULL,
  `subclass_name` varchar(50) NOT NULL,
  `subject_name` varchar(100) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `ca1` float DEFAULT NULL,
  `ca2` float DEFAULT NULL,
  `ca3` float DEFAULT NULL,
  `ca4` float DEFAULT NULL,
  `ca5` float DEFAULT NULL,
  `ca6` float DEFAULT NULL,
  `ca` float DEFAULT NULL,
  `exam` float DEFAULT NULL,
  `sum_total` float DEFAULT NULL,
  `total` float NOT NULL,
  `cumulative_score` float NOT NULL,
  `cumulative_score_percent` float DEFAULT NULL,
  `cumulative_position` char(10) NOT NULL,
  `position_subclass` varchar(20) NOT NULL,
  `grade` varchar(5) NOT NULL,
  `grade_comment` varchar(50) NOT NULL,
  `staff_name` varchar(200) NOT NULL,
  `staff_comment` varchar(60) NOT NULL,
  `attendance` int(11) DEFAULT NULL,
  `percent_attendance` varchar(10) DEFAULT NULL,
  `handwriting` int(11) NOT NULL,
  `neatness` int(11) NOT NULL,
  `punctuality` int(11) NOT NULL,
  `attentiveness` int(11) NOT NULL,
  `initiative` int(11) NOT NULL,
  `respect` int(11) NOT NULL,
  `obedience` int(11) NOT NULL,
  `attitude` int(11) NOT NULL,
  `honesty` int(11) NOT NULL,
  `creativity` int(11) NOT NULL,
  `status` varchar(10) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(10) NOT NULL,
  PRIMARY KEY (`result_subject_id`),
  KEY `sess_term` (`sessions`,`terms`),
  KEY `foreign_keys` (`student_id`,`class_id`,`subclass_id`,`subject_id`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `transfer_salary_info` (
  `salary_info_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `current_salary` decimal(15,2) NOT NULL,
  `past_debt` decimal(15,2) NOT NULL,
  `amount_to_pay` decimal(15,2) NOT NULL,
  `amount_paid` decimal(15,2) NOT NULL,
  `wave_over` decimal(15,2) NOT NULL,
  `current_debt` decimal(15,2) NOT NULL,
  `deduct` decimal(15,2) NOT NULL,
  `appreciation_amount` decimal(15,2) NOT NULL,
  `appreciation_reason` varchar(500) NOT NULL,
  `owing` decimal(15,2) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  `months` varchar(30) NOT NULL,
  PRIMARY KEY (`salary_info_id`),
  KEY `staff_id` (`staff_id`),
  KEY `sessions` (`sessions`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `transfer_salary_payment` (
  `salary_payment_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `accountant_id` int(10) unsigned NOT NULL,
  `amount_paid` decimal(15,2) NOT NULL,
  `staff_name` varchar(200) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  `months` varchar(30) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`salary_payment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `transfer_school_fees` (
  `school_fees_id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` char(20) NOT NULL,
  `student_id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `school_fees_payment_mode_id` int(11) NOT NULL,
  `payment_mode` varchar(300) NOT NULL,
  `staff_name` varchar(200) NOT NULL,
  `amount_paid` decimal(15,2) NOT NULL,
  `payment_no` varchar(20) NOT NULL,
  `fees_status` varchar(20) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(10) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`school_fees_id`),
  KEY `sessions` (`sessions`),
  KEY `terms` (`terms`),
  KEY `transaction_id` (`transaction_id`),
  KEY `school_fees_payment_mode_id` (`school_fees_payment_mode_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `transferred_students` (
  `transferred_student_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `parent_id` int(11) NOT NULL,
  `student_name` varchar(300) NOT NULL,
  `class_id` int(11) NOT NULL,
  `old_class_name` varchar(100) NOT NULL,
  `new_class_name` varchar(100) NOT NULL,
  `serial_number` varchar(50) NOT NULL,
  `school_id` int(11) NOT NULL,
  `database_name` varchar(100) NOT NULL,
  `status` varchar(30) NOT NULL,
  `date_transferred` datetime NOT NULL,
  PRIMARY KEY (`transferred_student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `zoom` (
  `zoom_id` int(11) NOT NULL AUTO_INCREMENT,
  `class_id` int(11) NOT NULL,
  `class_category_id` int(11) NOT NULL,
  `email` varchar(100) NOT NULL,
  `pass` varchar(50) NOT NULL,
  `api_key` varchar(200) NOT NULL,
  `api_secret` varchar(200) NOT NULL,
  `meeting_id` varchar(20) NOT NULL,
  `meeting_password` varchar(30) NOT NULL,
  `meeting_url_pwd` varchar(400) NOT NULL,
  `host_key` varchar(20) NOT NULL,
  `date_added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`zoom_id`),
  KEY `class_id` (`class_id`),
  KEY `class_category_id` (`class_category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;






