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 AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;


INSERT INTO sent_sms VALUES
("1","22","Your Serial Number is [SERIAL NUMBER] and First Password is [FIRST PASSWORD] for Firm Foundation at firmfoundationschools.com.ng. Login to view personal account and other activities in your dashboard. Please, remember to change your password for security reasons.\nFrom\nFirm Foundation School","SERIAL NUMBER AND FIRST PASSWORD SENT TO ALL STAFF","2019-02-07 15:06:16"),
("2","42","Your Serial Number is [SERIAL NUMBER] and First Password is [FIRST PASSWORD] for Firm Foundation at firmfoundationschools.com.ng. Login to view personal account, check ward\'s result, assessment and finance. Please, remember to change your password for security reasons.","SERIAL NUMBER AND FIRST PASSWORD SENT TO ALL PARENTS","2019-02-13 09:04:18"),
("3","42","Your Serial Number is [SERIAL NUMBER] and First Password is [FIRST PASSWORD] for Firm Foundation at firmfoundationschools.com.ng. Login to view personal account, check ward\'s result, assessment and finance. Please, remember to change your password for security reasons.","SERIAL NUMBER AND FIRST PASSWORD SENT TO ALL PARENTS","2019-02-13 09:55:35"),
("4","42","Your Serial Number is [SERIAL NUMBER] and First Password is [FIRST PASSWORD] for Firm Foundation at firmfoundationschools.com.ng. Login to view personal account, check ward\'s result, assessment and finance. Please, remember to change your password for security reasons.","SERIAL NUMBER AND FIRST PASSWORD SENT TO ALL PARENTS","2019-02-13 10:47:52"),
("5","42","Your Serial Number is [SERIAL NUMBER] and First Password is [FIRST PASSWORD] for Firm Foundation at firmfoundationschools.com.ng. Login to view personal account, check ward\'s result, assessment and finance. Please, remember to change your password for security reasons.","SERIAL NUMBER AND FIRST PASSWORD SENT TO ALL PARENTS","2019-02-13 13:57:54"),
("6","42","Our dear parents, our results will be published tomorrow Thursday 25th July 2019. Be reminded also of our summer lesson that will start on the 5th of August 2019. Thanks for your patronage","<hr/> GROUPS ARE:- Parents","2019-07-24 17:55:20"),
("7","2","Gdmoni Ma, I have been calling ur line, but  u are not picking, pls hw do I get JSS 3 scores on French to finalize my class results? Martins Maths Teacher ","SENT MESSAGE TO HAPPI JUDITH ","2019-12-16 10:05:53"),
("8","198","This is to inform our esteemed parents that our Open day for the term will be on Thursday, 13/02/2020. Our PTA meeting will be on same day by 12 noon. The agenda will be election of new officers and cultural day celebration. Please make it a point of responsibility to be part of these two important events concerning the welfare of your wards by planning to be there. Thanks for your usual co-operation.\nMrs Onyedinma P.\nProprietress Firm Foundation School","<hr/> GROUPS ARE:- Parents","2020-02-05 21:32:00"),
("9","65","Good morning parents, please our online classes begins today, check our parents whatsapp page for more information.                    Firm foundation school","<hr/> GROUPS ARE:- Parents","2020-05-06 09:38:04"),
("10","84","Your Serial Number is [SERIAL NUMBER] and Password is [FIRST PASSWORD] for Firm Foundation International School Akpajo at firmfoundationschools.com.ng. Login to view personal account, check ward\'s result, assessment and finance. Please, remember to change your password for security reasons.","SERIAL NUMBER AND FIRST PASSWORD SENT TO ALL PARENTS","2021-03-19 09:57:33");




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=15 DEFAULT CHARSET=latin1;


INSERT INTO session_term VALUES
("4","2018/2019","1st Term"),
("5","2018/2019","2nd Term"),
("6","2018/2019","3rd Term"),
("7","2019/2020","1st Term"),
("8","2019/2020","2nd Term"),
("9","2019/2020","3rd Term"),
("10","2020/2021","1st Term"),
("11","2020/2021","2nd Term"),
("12","2020/2021","3rd Term"),
("13","2021/2022","1st Term"),
("14","2021/2022","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=97 DEFAULT CHARSET=latin1;


INSERT INTO settings VALUES
("1","total_sms","153"),
("2","school_name","FIRM FOUNDATION INTERNATIONAL SCHOOL AKPAJO"),
("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","2348037959807"),
("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","NO 9 REDEMPTION CLOSE NEW HEAVEN AVENUE, AKPAJO PORT HARCOURT."),
("23","principal_finance","no"),
("24","one_card_amount","1000"),
("25","principal_name","SCHOOL HEAD"),
("26","principal_signature","images/principal_signatures/8b2978.png"),
("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","FFIS"),
("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","images/principal_signatures/7ffd78.png"),
("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//0fntNXTOlunFHCgYIARAAGA8SNwF-L9IrzETOpTHncez2VBnewQOd8r4It23cLGkmMKuur9GzpmyaX49-MdMIQVr78skNAvlgPkM"),
("87","folder_id","1XGY7KckDreTMIIrUvHIJirlL1KhKRb-v"),
("88","google_client_id","150277175744-n19rn2vsuio1lt7ot1cirgvfp3ehjp2l.apps.googleusercontent.com"),
("89","google_client_secret","eTWa1cXmNcG-Ky2h32o7bv4n"),
("90","online_class","yes"),
("91","payment_warning","no"),
("92","instalmental_payment","yes"),
("93","classroom_materials","no"),
("94","class_activity_name","CLASS ACTIVITY"),
("95","upload_admission_form","yes"),
("96","admit_student_button","yes");




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=24 DEFAULT CHARSET=latin1;


INSERT INTO staff VALUES
("1","56","156b098e72e","T/18/0001","$2y$10$jYHF4FNgQGXwnw4df0w56e3y3t62iY22wl8zLD3NLLvhqvQu2fs.K","onglobal","onglobal","GLOBAL","","ZEON","male","academic","both","","","PORT HARCOURT ","2019-01-10","234708234980","","NIGERIA","ABIA","Christianity","","","","","","0","0","","activated","2018/2019","1st Term"),
("2","56","256030f2ea3","T/18/0002","$2y$10$ozQQxtOB79/zjkG1eSxtpeLpNLcasdggMzC.5tc/e6FRWNsbsub36","anlucky","jayden13","LUCKY","NYEWEMADU","JONATHAN","male","academic","both","","","PORTHARCOURT","1987-05-31","2347032127058","luckynyewe@gmail.com","NIGERIA","RIVERS","Christianity","FIT","","form","","","0","1649333894","","activated","2018/2019","1st Term"),
("3","56","35631650ae1","T/18/0003","$2y$10$WB.nYuQeZ/rwnUu17bBnMu8gdijKZKF2pa..O2y3cKIqIcsVg3lqG","reokorafor","reokorafor","OKORAFOR","","IJERE","male","academic","both","","","PORTHARCOURT","1988-10-11","2347037273347","","NIGERIA","ABIA","Christianity","","","","","","0","1563876432","","deactivated","2018/2019","1st Term"),
("4","56","45647402c67","T/18/0004","$2y$10$LlfreHXUDbQcEA6kp0WMDO6oEUcNuI/QqtD02CBQH5tkw/PQp.mG.","pejames","pejames","JAMES","","HOPE","female","academic","both","","","PORTHARCOURT","1982-11-20","2348035090579","","NIGERIA","DELTA","Christianity","","","","","","0","1563984561","","deactivated","2018/2019","1st Term"),
("5","56","556cb7f2e71","T/18/0005","$2y$10$juALuoUDkqqPUTZX87SkNOlGSEX0Jau.EYr13OqFdDGiy11pT6/xm","necollins","necollins","COLLINS","","NWANNE","male","academic","both","","","PORTHARCOURT","1990-11-14","2349095751420","","NIGERIA","IMO","Christianity","","","form","","","0","1648831254","","activated","2018/2019","1st Term"),
("6","56","6561c5bc635","T/18/0006","$2y$10$RmxczZFVWLXInU86LU7DNON6iKhRK2SDlGFv0zKPPUo9Y4Engo.Pq","sochika","sochika","CHIKA","","OGBOSO","male","academic","both","","","PORTHARCOURT","1976-11-12","2348137656028","","NIGERIA","ABIA","Christianity","\n","","","","","0","1553678980","","deactivated","2018/2019","1st Term"),
("7","56","756be8915c1","T/18/0007","$2y$10$HmNFWf/.k/LHKIhbN03w3uSDPDi1n2ZwgvLGNjBRs6mJS93B6cEXC","neowho","neowho","OWHO","","JOSEPHINE","female","academic","senior","","","PORTHARCOURT","1958-07-04","2348038810870","","NIGERIA","RIVERS","Christianity","","","","","","0","1563582986","","deactivated","2018/2019","1st Term"),
("8","56","8560876aa8c","T/18/0008","$2y$10$IflNca.HwJ5Tp41XVyPpIehJxsRezPsFOGHHEiN9/j077rK5SLac.","hiokeke","hiokeke","OKEKE","","KELECHI","male","academic","both","","","PORTHARCOURT","1990-01-02","2348035357603","","NIGERIA","IMO","Christianity","","","","","","0","1649229672","","activated","2018/2019","1st Term"),
("9","56","956792606fa","T/18/0009","$2y$10$8r.gaNySrNVMngzcpZKygO498WA5ybb0vA2F5NqgNv0GIFR5IHxbG","duclara","duclara","CLARA","CHINENYE","UCHENDU","female","academic","both","","","PORTHARCOURT","1985-11-05","2347036843403","","NIGERIA","ANAMBRA","Christianity","","","form","","","0","1648794467","","activated","2018/2019","1st Term"),
("10","56","10564c718b04","T/18/0010","$2y$10$Mo65lXrKtW.loJf83pYkaeL9.HKDk5V8btnwxs5k4bE4iyf8Ntqvu","deadebayo","deadebayo","ADEBAYO","T","OKIKIADE","male","academic","senior","","","PORTHARCOURT","1991-06-22","2347033878726","adebayotookikiade2@gmail.com","NIGERIA","OSUN","Christianity","","","","","","0","1649157519","","activated","2018/2019","1st Term"),
("11","56","115606bb8a76","T/18/0011","$2y$10$QSlocktSYjH2fGQNQYiHv.LGDIS.8NbnKTafQJEkRNqSpd4l/IRCW","pijudith","pijudith","JUDITH","","HAPPI","female","academic","both","","","PORTHARCOURT","1982-04-30","2348063870358","","NIGERIA","RIVERS","Christianity","","","","","","0","1649155308","","activated","2018/2019","1st Term"),
("12","56","1256ce6d33c0","T/18/0012","$2y$10$jcsMbrgJd30egoGmzIhCI.Kwju1htoH.knOpepuBNDUG/d75Bm66m","ahobyziotta","ahobyziotta","OBYZIOTTA","","EJAH","male","academic","both","","","PORT HARCOURT, RIVERS STATE","1989-10-24","2347063866989","","NIGERIA","CROSS RIVER","Christianity","","","","","","0","1630922296","","activated","2018/2019","3rd Term"),
("13","56","1356476bbc6b","T/19/0001","$2y$10$W9naBI0gd8QPKyDSfW5hSe/r6t7NxJqFpyVT1toJ9UqN5G12hd1ym","nkobianuju","nkobianuju","OBIANUJU","","FRANK","female","academic","both","","","RIVERS","1984-08-02","2348062766095","","NIGERIA","IMO","Christianity","","","form","","","0","1649171669","","activated","2019/2020","1st Term"),
("14","56","145608e123a1","T/19/0002","$2y$10$6Mn0ljERaScUj.I78EyKBOKd.B5lJPhozype.MUh0gj8W21abdL7C","nachristina","nachristina","CHRISTINA","","UCHENNA","female","academic","both","","","RIVER STATE","1990-12-20","2348134603797","","NIGERIA","IMO","Christianity","","","","","","0","1635415709","","deactivated","2019/2020","1st Term"),
("15","56","1556512e92a5","T/19/0003","$2y$10$WUZ6.Vjra555A6MQ0dWgcuEW/xx42QYdVri.d4YPMRsLlWUEhwsqe","wumartins","wumartins","MARTINS","","OHAMAEZIOKWU","male","academic","both","","","RIVERS","1981-11-03","2348035261027","","NIGERIA","IMO","Christianity","","","form","","","0","1648798261","","activated","2019/2020","1st Term"),
("16","56","1656addf09ea","T/19/0004","$2y$10$3Zo.JJ8KlIVZbTdilkgcKO33Eo9MtuGizWm97WcqJZLWF/iqs9QKK","rschiagoziem","rschiagoziem","CHIAGOZIEM","","MRS","female","academic_admin","senior","","","RIVERS","2018-10-24","2340806625043","","NIGERIA","RIVERS","Christianity","","","","","","0","1631278947","","activated","2019/2020","1st Term"),
("17","56","175668dac070","T/20/0001","$2y$10$q7Zqglq1tzsoUfV1azwzzeMjjCaedQ9Tx33Qk96nF7CqSsHdR7uMq","mrbarnabas","mrbarnabas","BARNABAS","UKWEH ABAA","MR","male","academic","both","","","PORT HARCOURT ","2021-05-04","2348068085658","ogamickkyy1@gmail.com","NIGERIA","CROSS RIVER","Christianity","","","form","","","0","1648801611","","activated","2020/2021","2nd Term"),
("18","56","1856d14830c9","T/20/0002","$2y$10$GrBfFyTb33kZcHeHbPDb2eoNVN9s9VwOT.Q8y3mpkRZw1n7B048Oy","mrnsikak","mrnsikak","NSIKAN","IKOH","MR","male","academic","both","","","PORT HARCOURT ","2021-05-05","2348061954485","nsikanetimikoh@gmail.com","NIGERIA","RIVERS","Christianity","","","form","","","0","1648644282","","activated","2020/2021","2nd Term"),
("19","56","19567d58f1bc","T/21/0001","$2y$10$1KEhLAT.JNoEckoAcpT/fOZiX5DKVEJkxNIBwfOqsqUJA8PPWQbKG","reokeke","reokeke","OKEKE","","CHIDIEBERE","male","academic","both","","","PORT HARCOURT","1992-03-11","2348166326386","","NIGERIA","CROSS RIVER","Christianity","","","","","","0","1640015271","","activated","2021/2022","1st Term"),
("20","56","205646f15d08","T/21/0002","$2y$10$f31CV.L1cnl8LRekeT4HW.8WYxb7MpjCOgUUEiVhciRhNdI4f.Sh.","anonyekwere","kyrian66","KYRIAN","CHIKA","ONYEKWERE","male","academic","both","","","ELELENWO,PORT HARCOURT","1990-10-03","2347030419494","Onyekwerechika87@gmail.com","NIGERIA","IMO","Christianity","GOOD AND SOUND","","","","","0","1648799220","","activated","2021/2022","1st Term"),
("21","56","21560443a3e6","T/21/0003","$2y$10$XWIiJx1H/gjt2WrpU5MCmu9pgGcnr4tTxnaC3tt7ecYxvAEuKAWpW","keotuya","keotuya","OTUYA","","AZUBUIKE","male","academic","both","","","RIVERS","1990-04-15","2347018910753","","NIGERIA","RIVERS","Christianity","","","form","","","0","1649179464","","activated","2021/2022","2nd Term"),
("22","56","2256ef0a7a43","T/21/0004","$2y$10$.ww.Lxgr4HBtxMYGZGUc9.ZvXXyUtVccIJ0g79R6JaCh0TNmM8z5S","refrancis","refrancis","FRANCIS","","IHEUKWUMERE","male","academic","both","","","PH","2022-04-01","234082349380","","NIGERIA","ABIA","Christianity","","","","","","0","1649697616","","activated","2021/2022","2nd 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=24 DEFAULT CHARSET=latin1;


INSERT INTO staff_salary VALUES
("1","1","0.00"),
("2","2","0.00"),
("3","3","0.00"),
("4","4","0.00"),
("5","5","0.00"),
("6","6","0.00"),
("7","7","0.00"),
("8","8","0.00"),
("9","9","0.00"),
("10","10","0.00"),
("11","11","0.00"),
("12","12","0.00"),
("13","13","0.00"),
("14","14","0.00"),
("15","15","0.00"),
("16","16","0.00"),
("17","17","0.00"),
("18","18","0.00"),
("19","19","0.00"),
("20","20","0.00"),
("21","21","0.00"),
("22","22","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=115 DEFAULT CHARSET=latin1;


INSERT INTO staff_subject VALUES
("111","0","28","5"),
("14","2","8","1"),
("29","2","8","2"),
("44","2","8","3"),
("49","2","17","4"),
("65","2","17","5"),
("81","2","17","6"),
("50","2","18","4"),
("66","2","18","5"),
("82","2","18","6"),
("8","5","2","1"),
("23","5","2","2"),
("38","5","2","3"),
("52","5","2","4"),
("68","5","2","5"),
("84","5","2","6"),
("58","5","3","4"),
("74","5","3","5"),
("106","5","3","6"),
("101","5","27","4"),
("97","5","27","5"),
("102","5","27","6"),
("6","8","14","1"),
("21","8","14","2"),
("36","8","14","3"),
("10","9","4","1"),
("25","9","4","2"),
("40","9","4","3"),
("12","9","6","1"),
("27","9","6","2"),
("42","9","6","3"),
("4","9","12","1"),
("19","9","12","2"),
("34","9","12","3"),
("7","10","15","1"),
("22","10","15","2"),
("37","10","15","3"),
("11","11","5","1"),
("26","11","5","2"),
("41","11","5","3"),
("9","13","3","1"),
("24","13","3","2"),
("39","13","3","3"),
("15","13","9","1"),
("30","13","9","2"),
("45","13","9","3"),
("61","13","9","4"),
("5","13","13","1"),
("20","13","13","2"),
("35","13","13","3"),
("46","15","1","4"),
("62","15","1","5"),
("78","15","1","6"),
("48","15","16","4"),
("64","15","16","5"),
("80","15","16","6"),
("113","15","25","4"),
("59","17","4","4"),
("75","17","4","5"),
("91","17","4","6"),
("54","17","21","4"),
("70","17","21","5"),
("107","17","21","6"),
("2","18","10","1"),
("17","18","10","2"),
("32","18","10","3"),
("51","18","19","4"),
("67","18","19","5"),
("1","20","1","1"),
("16","20","1","2"),
("31","20","1","3"),
("13","20","7","1"),
("28","20","7","2"),
("43","20","7","3"),
("53","21","20","4"),
("69","21","20","5"),
("85","21","20","6"),
("55","21","22","4"),
("103","21","22","5"),
("56","21","23","4"),
("72","21","23","5"),
("88","21","23","6"),
("57","21","24","4"),
("3","22","11","1"),
("18","22","11","2"),
("33","22","11","3"),
("47","22","11","4"),
("63","22","11","5"),
("79","22","11","6"),
("110","22","28","4"),
("112","22","28","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=383 DEFAULT CHARSET=latin1;


INSERT INTO staff_subject_subclass VALUES
("379","0","28","5","0"),
("199","2","8","1","0"),
("335","2","8","2","0"),
("320","2","8","3","0"),
("303","2","17","4","0"),
("350","2","17","5","0"),
("365","2","17","6","0"),
("304","2","18","4","0"),
("351","2","18","5","0"),
("366","2","18","6","0"),
("200","5","2","1","0"),
("336","5","2","2","0"),
("321","5","2","3","0"),
("305","5","2","4","0"),
("352","5","2","5","0"),
("367","5","2","6","0"),
("306","5","3","4","0"),
("353","5","3","5","0"),
("368","5","3","6","0"),
("307","5","27","4","0"),
("354","5","27","5","0"),
("369","5","27","6","0"),
("202","8","14","1","0"),
("338","8","14","2","0"),
("323","8","14","3","0"),
("203","9","4","1","0"),
("339","9","4","2","0"),
("324","9","4","3","0"),
("204","9","6","1","0"),
("340","9","6","2","0"),
("325","9","6","3","0"),
("205","9","12","1","0"),
("341","9","12","2","0"),
("326","9","12","3","0"),
("206","10","15","1","0"),
("342","10","15","2","0"),
("327","10","15","3","0"),
("207","11","5","1","0"),
("343","11","5","2","0"),
("328","11","5","3","0"),
("210","13","3","1","0"),
("346","13","3","2","0"),
("331","13","3","3","0"),
("211","13","9","1","0"),
("347","13","9","2","0"),
("332","13","9","3","0"),
("312","13","9","4","0"),
("212","13","13","1","0"),
("348","13","13","2","0"),
("333","13","13","3","0"),
("317","15","1","4","0"),
("362","15","1","5","0"),
("376","15","1","6","0"),
("318","15","16","4","0"),
("363","15","16","5","0"),
("377","15","16","6","0"),
("381","15","25","4","0"),
("309","17","4","4","0"),
("356","17","4","5","0"),
("370","17","4","6","0"),
("310","17","21","4","0"),
("357","17","21","5","0"),
("371","17","21","6","0"),
("201","18","10","1","0"),
("337","18","10","2","0"),
("322","18","10","3","0"),
("308","18","19","4","0"),
("355","18","19","5","0"),
("213","20","1","1","0"),
("349","20","1","2","0"),
("334","20","1","3","0"),
("208","20","7","1","0"),
("344","20","7","2","0"),
("329","20","7","3","0"),
("313","21","20","4","0"),
("359","21","20","5","0"),
("373","21","20","6","0"),
("314","21","22","4","0"),
("360","21","22","5","0"),
("315","21","23","4","0"),
("361","21","23","5","0"),
("374","21","23","6","0"),
("316","21","24","4","0"),
("209","22","11","1","0"),
("345","22","11","2","0"),
("330","22","11","3","0"),
("311","22","11","4","0"),
("358","22","11","5","0"),
("372","22","11","6","0"),
("378","22","28","4","0"),
("380","22","28","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=2235 DEFAULT CHARSET=latin1;


INSERT INTO student_subject VALUES
("1524","1","1","doing"),
("1530","1","2","doing"),
("1536","1","3","doing"),
("1537","1","4","doing"),
("1538","1","9","doing"),
("1525","1","11","doing"),
("1526","1","16","doing"),
("1527","1","17","doing"),
("1528","1","18","doing"),
("1529","1","19","doing"),
("1531","1","20","doing"),
("1532","1","21","doing"),
("1533","1","22","doing"),
("1534","1","23","not_doing"),
("1535","1","24","doing"),
("2118","1","25","doing"),
("1539","1","27","not_doing"),
("1540","1","28","doing"),
("1541","2","1","doing"),
("1547","2","2","doing"),
("1553","2","3","doing"),
("1554","2","4","doing"),
("1555","2","9","doing"),
("1542","2","11","doing"),
("1543","2","16","doing"),
("1544","2","17","doing"),
("1545","2","18","doing"),
("1546","2","19","doing"),
("1548","2","20","doing"),
("1549","2","21","doing"),
("1550","2","22","doing"),
("1551","2","23","not_doing"),
("1552","2","24","doing"),
("2119","2","25","doing"),
("1556","2","27","not_doing"),
("1557","2","28","doing"),
("1558","3","1","doing"),
("1564","3","2","doing"),
("1570","3","3","doing"),
("1571","3","4","doing"),
("1572","3","9","doing"),
("1559","3","11","doing"),
("1560","3","16","doing"),
("1561","3","17","doing"),
("1562","3","18","doing"),
("1563","3","19","doing"),
("1565","3","20","doing"),
("1566","3","21","doing"),
("1567","3","22","doing"),
("1568","3","23","not_doing"),
("1569","3","24","doing"),
("2120","3","25","doing"),
("1573","3","27","not_doing"),
("1574","3","28","doing"),
("1575","4","1","doing"),
("1581","4","2","doing"),
("1587","4","3","doing"),
("1588","4","4","doing"),
("1589","4","9","doing"),
("1576","4","11","doing"),
("1577","4","16","doing"),
("1578","4","17","doing"),
("1579","4","18","doing"),
("1580","4","19","not_doing"),
("1582","4","20","doing"),
("1583","4","21","doing"),
("1584","4","22","doing"),
("1585","4","23","doing"),
("1586","4","24","doing"),
("2121","4","25","doing"),
("1590","4","27","doing"),
("1591","4","28","not_doing"),
("1592","5","1","doing"),
("1598","5","2","doing"),
("1604","5","3","doing"),
("1605","5","4","doing"),
("1606","5","9","doing"),
("1593","5","11","doing"),
("1594","5","16","doing"),
("1595","5","17","doing"),
("1596","5","18","doing"),
("1597","5","19","doing"),
("1599","5","20","doing"),
("1600","5","21","doing"),
("1601","5","22","doing"),
("1602","5","23","not_doing"),
("1603","5","24","doing"),
("2122","5","25","doing"),
("1607","5","27","not_doing"),
("1608","5","28","doing"),
("1609","6","1","doing"),
("1615","6","2","doing"),
("1621","6","3","doing"),
("1622","6","4","doing"),
("1623","6","9","doing"),
("1610","6","11","doing"),
("1611","6","16","doing"),
("1612","6","17","doing"),
("1613","6","18","doing"),
("1614","6","19","not_doing");
INSERT INTO student_subject VALUES
("1616","6","20","doing"),
("1617","6","21","doing"),
("1618","6","22","doing"),
("1619","6","23","doing"),
("1620","6","24","doing"),
("2123","6","25","doing"),
("1624","6","27","doing"),
("1625","6","28","not_doing"),
("1626","7","1","not_doing"),
("1632","7","2","doing"),
("1638","7","3","doing"),
("1639","7","4","doing"),
("1640","7","9","not_doing"),
("1627","7","11","not_doing"),
("1628","7","16","not_doing"),
("1629","7","17","not_doing"),
("1630","7","18","not_doing"),
("1631","7","19","not_doing"),
("1633","7","20","doing"),
("1634","7","21","doing"),
("1635","7","22","doing"),
("1636","7","23","not_doing"),
("1637","7","24","doing"),
("2124","7","25","not_doing"),
("1641","7","27","not_doing"),
("1642","7","28","not_doing"),
("495","8","1","doing"),
("501","8","2","doing"),
("507","8","3","not_doing"),
("508","8","4","doing"),
("496","8","11","doing"),
("497","8","16","doing"),
("498","8","17","doing"),
("499","8","18","doing"),
("502","8","20","not_doing"),
("503","8","21","not_doing"),
("505","8","23","not_doing"),
("754","8","27","not_doing"),
("1499","8","28","doing"),
("511","9","1","doing"),
("517","9","2","doing"),
("523","9","3","doing"),
("524","9","4","doing"),
("525","9","9","doing"),
("512","9","11","doing"),
("513","9","16","doing"),
("514","9","17","doing"),
("515","9","18","doing"),
("516","9","19","doing"),
("518","9","20","doing"),
("519","9","21","doing"),
("520","9","22","doing"),
("521","9","23","doing"),
("522","9","24","doing"),
("2134","9","25","doing"),
("758","9","27","doing"),
("1494","9","28","doing"),
("527","10","1","doing"),
("533","10","2","doing"),
("539","10","3","not_doing"),
("540","10","4","doing"),
("528","10","11","not_doing"),
("529","10","16","doing"),
("530","10","17","doing"),
("531","10","18","doing"),
("534","10","20","doing"),
("535","10","21","not_doing"),
("537","10","23","not_doing"),
("759","10","27","not_doing"),
("1500","10","28","doing"),
("543","11","1","doing"),
("549","11","2","doing"),
("555","11","3","doing"),
("556","11","4","doing"),
("544","11","11","not_doing"),
("545","11","16","not_doing"),
("546","11","17","not_doing"),
("547","11","18","doing"),
("550","11","20","doing"),
("551","11","21","doing"),
("553","11","23","doing"),
("755","11","27","doing"),
("1501","11","28","not_doing"),
("559","12","1","doing"),
("565","12","2","doing"),
("571","12","3","not_doing"),
("572","12","4","doing"),
("560","12","11","not_doing"),
("561","12","16","doing"),
("562","12","17","doing"),
("563","12","18","doing"),
("566","12","20","doing"),
("567","12","21","not_doing"),
("569","12","23","doing"),
("756","12","27","not_doing"),
("1502","12","28","not_doing"),
("575","13","1","doing"),
("581","13","2","doing"),
("587","13","3","doing"),
("588","13","4","doing");
INSERT INTO student_subject VALUES
("589","13","9","doing"),
("576","13","11","doing"),
("577","13","16","doing"),
("578","13","17","doing"),
("579","13","18","doing"),
("580","13","19","doing"),
("582","13","20","doing"),
("583","13","21","doing"),
("584","13","22","doing"),
("585","13","23","doing"),
("586","13","24","doing"),
("2135","13","25","doing"),
("760","13","27","doing"),
("1495","13","28","doing"),
("591","14","1","doing"),
("597","14","2","doing"),
("603","14","3","doing"),
("604","14","4","doing"),
("605","14","9","doing"),
("592","14","11","doing"),
("593","14","16","doing"),
("594","14","17","doing"),
("595","14","18","doing"),
("596","14","19","doing"),
("598","14","20","doing"),
("599","14","21","doing"),
("600","14","22","doing"),
("601","14","23","doing"),
("602","14","24","doing"),
("2136","14","25","doing"),
("761","14","27","doing"),
("1496","14","28","doing"),
("211","15","1","doing"),
("217","15","2","doing"),
("223","15","3","not_doing"),
("224","15","4","doing"),
("212","15","11","not_doing"),
("213","15","16","doing"),
("214","15","17","doing"),
("215","15","18","doing"),
("218","15","20","doing"),
("219","15","21","not_doing"),
("221","15","23","not_doing"),
("1077","15","24","not_doing"),
("613","15","27","not_doing"),
("1504","15","28","doing"),
("227","16","1","doing"),
("233","16","2","doing"),
("239","16","3","not_doing"),
("240","16","4","doing"),
("228","16","11","doing"),
("229","16","16","not_doing"),
("230","16","17","not_doing"),
("231","16","18","doing"),
("234","16","20","doing"),
("235","16","21","doing"),
("237","16","23","doing"),
("1079","16","24","not_doing"),
("614","16","27","doing"),
("1505","16","28","doing"),
("243","17","1","doing"),
("249","17","2","doing"),
("255","17","3","not_doing"),
("256","17","4","doing"),
("244","17","11","doing"),
("245","17","16","doing"),
("246","17","17","doing"),
("247","17","18","doing"),
("250","17","20","doing"),
("251","17","21","not_doing"),
("253","17","23","not_doing"),
("1078","17","24","not_doing"),
("615","17","27","not_doing"),
("1506","17","28","doing"),
("262","18","1","doing"),
("268","18","2","doing"),
("784","18","3","not_doing"),
("275","18","4","doing"),
("263","18","11","not_doing"),
("264","18","16","doing"),
("265","18","17","doing"),
("266","18","18","doing"),
("269","18","20","doing"),
("838","18","21","not_doing"),
("272","18","23","doing"),
("778","18","24","not_doing"),
("762","18","27","not_doing"),
("278","19","1","doing"),
("284","19","2","doing"),
("785","19","3","not_doing"),
("291","19","4","doing"),
("279","19","11","not_doing"),
("280","19","16","not_doing"),
("281","19","17","not_doing"),
("282","19","18","doing"),
("285","19","20","doing"),
("839","19","21","doing"),
("288","19","23","doing"),
("779","19","24","doing"),
("763","19","27","doing");
INSERT INTO student_subject VALUES
("356","20","1","doing"),
("362","20","2","doing"),
("786","20","3","not_doing"),
("369","20","4","doing"),
("357","20","11","not_doing"),
("358","20","16","not_doing"),
("359","20","17","not_doing"),
("360","20","18","doing"),
("363","20","20","doing"),
("840","20","21","doing"),
("366","20","23","doing"),
("780","20","24","not_doing"),
("764","20","27","doing"),
("372","21","1","doing"),
("378","21","2","doing"),
("787","21","3","not_doing"),
("385","21","4","doing"),
("373","21","11","doing"),
("374","21","16","doing"),
("375","21","17","doing"),
("376","21","18","doing"),
("379","21","20","doing"),
("841","21","21","not_doing"),
("382","21","23","doing"),
("781","21","24","not_doing"),
("765","21","27","not_doing"),
("324","22","1","doing"),
("330","22","2","doing"),
("788","22","3","doing"),
("337","22","4","doing"),
("325","22","11","not_doing"),
("326","22","16","not_doing"),
("327","22","17","not_doing"),
("328","22","18","doing"),
("331","22","20","doing"),
("842","22","21","doing"),
("334","22","23","doing"),
("782","22","24","not_doing"),
("766","22","27","doing"),
("340","23","1","doing"),
("346","23","2","doing"),
("789","23","3","not_doing"),
("353","23","4","doing"),
("341","23","11","doing"),
("342","23","16","doing"),
("343","23","17","doing"),
("344","23","18","doing"),
("347","23","20","doing"),
("843","23","21","not_doing"),
("350","23","23","doing"),
("783","23","24","not_doing"),
("767","23","27","not_doing"),
("394","24","1","doing"),
("400","24","2","doing"),
("404","24","4","doing"),
("405","24","9","doing"),
("395","24","11","doing"),
("396","24","16","doing"),
("397","24","17","doing"),
("398","24","18","doing"),
("399","24","19","not_doing"),
("401","24","20","not_doing"),
("403","24","23","doing"),
("406","24","25","doing"),
("407","25","1","doing"),
("413","25","2","doing"),
("417","25","4","doing"),
("418","25","9","doing"),
("408","25","11","not_doing"),
("409","25","16","doing"),
("410","25","17","doing"),
("411","25","18","doing"),
("412","25","19","doing"),
("414","25","20","doing"),
("416","25","23","doing"),
("419","25","25","not_doing"),
("1060","26","1","doing"),
("1066","26","2","doing"),
("1072","26","3","doing"),
("1073","26","4","doing"),
("1074","26","9","doing"),
("1061","26","11","doing"),
("1062","26","16","doing"),
("1063","26","17","doing"),
("1064","26","18","doing"),
("1065","26","19","doing"),
("1067","26","20","doing"),
("1068","26","21","doing"),
("1069","26","22","doing"),
("1070","26","23","doing"),
("1071","26","24","doing"),
("2137","26","25","doing"),
("1075","26","27","doing"),
("1497","26","28","doing"),
("435","27","1","not_doing"),
("442","27","2","not_doing"),
("443","27","3","not_doing"),
("444","27","4","not_doing"),
("445","27","5","doing"),
("446","27","6","not_doing");
INSERT INTO student_subject VALUES
("447","27","7","not_doing"),
("448","27","8","not_doing"),
("449","27","9","not_doing"),
("436","27","10","doing"),
("437","27","11","not_doing"),
("438","27","12","not_doing"),
("439","27","13","not_doing"),
("440","27","14","doing"),
("441","27","15","not_doing"),
("1009","28","1","doing"),
("1015","28","2","doing"),
("1021","28","3","not_doing"),
("1022","28","4","doing"),
("1010","28","11","doing"),
("1011","28","16","doing"),
("1012","28","17","doing"),
("1013","28","18","doing"),
("1014","28","19","doing"),
("1016","28","20","doing"),
("1017","28","21","not_doing"),
("1018","28","22","not_doing"),
("1019","28","23","not_doing"),
("1024","28","27","not_doing"),
("1491","28","28","doing"),
("1026","29","1","doing"),
("1032","29","2","doing"),
("1038","29","3","doing"),
("1039","29","4","doing"),
("1040","29","9","doing"),
("1027","29","11","doing"),
("1028","29","16","doing"),
("1029","29","17","doing"),
("1030","29","18","doing"),
("1031","29","19","doing"),
("1033","29","20","doing"),
("1034","29","21","doing"),
("1035","29","22","doing"),
("1036","29","23","doing"),
("1037","29","24","doing"),
("2138","29","25","doing"),
("1041","29","27","doing"),
("1498","29","28","doing"),
("1643","30","1","doing"),
("1649","30","2","doing"),
("1655","30","3","doing"),
("1656","30","4","doing"),
("1657","30","9","doing"),
("1644","30","11","doing"),
("1645","30","16","doing"),
("1646","30","17","doing"),
("1647","30","18","doing"),
("1648","30","19","not_doing"),
("1650","30","20","doing"),
("1651","30","21","doing"),
("1652","30","22","doing"),
("1653","30","23","doing"),
("1654","30","24","doing"),
("2125","30","25","doing"),
("1658","30","27","doing"),
("1659","30","28","not_doing"),
("616","31","1","doing"),
("622","31","2","doing"),
("627","31","3","doing"),
("628","31","4","doing"),
("617","31","11","not_doing"),
("618","31","16","not_doing"),
("619","31","17","not_doing"),
("620","31","18","doing"),
("623","31","20","doing"),
("624","31","21","doing"),
("625","31","23","doing"),
("1080","31","24","not_doing"),
("630","31","27","doing"),
("1507","31","28","doing"),
("631","32","1","doing"),
("637","32","2","doing"),
("643","32","3","not_doing"),
("644","32","4","doing"),
("632","32","11","doing"),
("633","32","16","doing"),
("634","32","17","doing"),
("635","32","18","doing"),
("638","32","20","not_doing"),
("639","32","21","not_doing"),
("641","32","23","doing"),
("757","32","27","not_doing"),
("1503","32","28","not_doing"),
("1043","33","1","doing"),
("1049","33","2","doing"),
("1055","33","3","not_doing"),
("1056","33","4","doing"),
("1044","33","11","doing"),
("1045","33","16","doing"),
("1046","33","17","doing"),
("1047","33","18","doing"),
("1048","33","19","doing"),
("1050","33","20","doing"),
("1051","33","21","not_doing"),
("1052","33","22","not_doing"),
("1053","33","23","not_doing");
INSERT INTO student_subject VALUES
("1058","33","27","not_doing"),
("1492","33","28","doing"),
("1660","35","1","doing"),
("1666","35","2","doing"),
("1672","35","3","doing"),
("1673","35","4","doing"),
("1674","35","9","doing"),
("1661","35","11","doing"),
("1662","35","16","doing"),
("1663","35","17","doing"),
("1664","35","18","doing"),
("1665","35","19","doing"),
("1667","35","20","doing"),
("1668","35","21","doing"),
("1669","35","22","doing"),
("1670","35","23","not_doing"),
("1671","35","24","doing"),
("2126","35","25","doing"),
("1675","35","27","not_doing"),
("1676","35","28","doing"),
("1677","36","1","not_doing"),
("1683","36","2","not_doing"),
("1689","36","3","not_doing"),
("1690","36","4","not_doing"),
("1691","36","9","not_doing"),
("1678","36","11","not_doing"),
("1679","36","16","not_doing"),
("1680","36","17","not_doing"),
("1681","36","18","not_doing"),
("1682","36","19","not_doing"),
("1684","36","20","not_doing"),
("1685","36","21","not_doing"),
("1686","36","22","not_doing"),
("1687","36","23","not_doing"),
("1688","36","24","not_doing"),
("2127","36","25","not_doing"),
("1692","36","27","not_doing"),
("1693","36","28","not_doing"),
("1694","37","1","doing"),
("1700","37","2","doing"),
("1706","37","3","doing"),
("1707","37","4","doing"),
("1708","37","9","doing"),
("1695","37","11","doing"),
("1696","37","16","doing"),
("1697","37","17","doing"),
("1698","37","18","doing"),
("1699","37","19","doing"),
("1701","37","20","doing"),
("1702","37","21","doing"),
("1703","37","22","doing"),
("1704","37","23","not_doing"),
("1705","37","24","doing"),
("2128","37","25","doing"),
("1709","37","27","not_doing"),
("1710","37","28","doing"),
("722","38","1","doing"),
("729","38","2","doing"),
("730","38","3","doing"),
("731","38","4","doing"),
("732","38","5","doing"),
("733","38","6","doing"),
("734","38","7","doing"),
("735","38","8","doing"),
("736","38","9","doing"),
("723","38","10","doing"),
("724","38","11","doing"),
("725","38","12","doing"),
("726","38","13","doing"),
("727","38","14","doing"),
("728","38","15","doing"),
("790","39","1","doing"),
("797","39","2","doing"),
("798","39","3","doing"),
("799","39","4","doing"),
("800","39","5","doing"),
("801","39","6","doing"),
("802","39","7","doing"),
("803","39","8","doing"),
("804","39","9","doing"),
("791","39","10","doing"),
("792","39","11","doing"),
("793","39","12","doing"),
("794","39","13","doing"),
("795","39","14","doing"),
("796","39","15","doing"),
("806","40","1","doing"),
("813","40","2","doing"),
("814","40","3","doing"),
("815","40","4","doing"),
("816","40","5","doing"),
("817","40","6","doing"),
("818","40","7","doing"),
("819","40","8","doing"),
("820","40","9","doing"),
("807","40","10","doing"),
("808","40","11","doing"),
("809","40","12","doing"),
("810","40","13","doing"),
("811","40","14","doing");
INSERT INTO student_subject VALUES
("812","40","15","doing"),
("822","41","1","doing"),
("829","41","2","doing"),
("830","41","3","doing"),
("831","41","4","doing"),
("832","41","5","doing"),
("833","41","6","doing"),
("834","41","7","doing"),
("835","41","8","doing"),
("836","41","9","doing"),
("823","41","10","doing"),
("824","41","11","doing"),
("825","41","12","doing"),
("826","41","13","doing"),
("827","41","14","doing"),
("828","41","15","doing"),
("844","42","1","doing"),
("851","42","2","doing"),
("852","42","3","doing"),
("853","42","4","doing"),
("854","42","5","doing"),
("855","42","6","doing"),
("856","42","7","doing"),
("857","42","8","doing"),
("858","42","9","doing"),
("845","42","10","doing"),
("846","42","11","doing"),
("847","42","12","doing"),
("848","42","13","doing"),
("849","42","14","doing"),
("850","42","15","not_doing"),
("860","43","1","doing"),
("867","43","2","doing"),
("868","43","3","doing"),
("869","43","4","doing"),
("870","43","5","doing"),
("871","43","6","doing"),
("872","43","7","doing"),
("873","43","8","doing"),
("874","43","9","doing"),
("861","43","10","doing"),
("862","43","11","doing"),
("863","43","12","doing"),
("864","43","13","doing"),
("865","43","14","doing"),
("866","43","15","doing"),
("876","44","1","doing"),
("883","44","2","doing"),
("884","44","3","doing"),
("885","44","4","doing"),
("886","44","5","doing"),
("887","44","6","doing"),
("888","44","7","doing"),
("889","44","8","doing"),
("890","44","9","doing"),
("877","44","10","doing"),
("878","44","11","doing"),
("879","44","12","doing"),
("880","44","13","doing"),
("881","44","14","doing"),
("882","44","15","doing"),
("892","45","1","doing"),
("899","45","2","doing"),
("900","45","3","doing"),
("901","45","4","doing"),
("902","45","5","doing"),
("903","45","6","doing"),
("904","45","7","doing"),
("905","45","8","doing"),
("906","45","9","doing"),
("893","45","10","doing"),
("894","45","11","doing"),
("895","45","12","doing"),
("896","45","13","doing"),
("897","45","14","doing"),
("898","45","15","doing"),
("908","46","1","doing"),
("915","46","2","doing"),
("916","46","3","doing"),
("917","46","4","doing"),
("918","46","5","doing"),
("919","46","6","doing"),
("920","46","7","doing"),
("921","46","8","doing"),
("922","46","9","doing"),
("909","46","10","doing"),
("910","46","11","doing"),
("911","46","12","doing"),
("912","46","13","doing"),
("913","46","14","doing"),
("914","46","15","doing"),
("924","47","1","doing"),
("931","47","2","doing"),
("932","47","3","doing"),
("933","47","4","doing"),
("934","47","5","doing"),
("935","47","6","doing"),
("936","47","7","doing"),
("937","47","8","doing"),
("938","47","9","doing");
INSERT INTO student_subject VALUES
("925","47","10","doing"),
("926","47","11","doing"),
("927","47","12","doing"),
("928","47","13","doing"),
("929","47","14","doing"),
("930","47","15","doing"),
("940","48","1","doing"),
("947","48","2","doing"),
("948","48","3","doing"),
("949","48","4","doing"),
("950","48","5","doing"),
("951","48","6","doing"),
("952","48","7","doing"),
("953","48","8","doing"),
("954","48","9","doing"),
("941","48","10","doing"),
("942","48","11","doing"),
("943","48","12","doing"),
("944","48","13","doing"),
("945","48","14","doing"),
("946","48","15","doing"),
("956","49","1","doing"),
("963","49","2","doing"),
("964","49","3","doing"),
("965","49","4","doing"),
("966","49","5","doing"),
("967","49","6","doing"),
("968","49","7","doing"),
("969","49","8","doing"),
("970","49","9","doing"),
("957","49","10","doing"),
("958","49","11","doing"),
("959","49","12","doing"),
("960","49","13","doing"),
("961","49","14","doing"),
("962","49","15","doing"),
("971","50","1","doing"),
("978","50","2","doing"),
("979","50","3","doing"),
("980","50","4","doing"),
("981","50","5","doing"),
("982","50","6","doing"),
("983","50","7","doing"),
("984","50","8","doing"),
("985","50","9","doing"),
("972","50","10","doing"),
("973","50","11","doing"),
("974","50","12","doing"),
("975","50","13","doing"),
("976","50","14","doing"),
("977","50","15","doing"),
("1711","51","1","doing"),
("1717","51","2","doing"),
("1723","51","3","doing"),
("1724","51","4","doing"),
("1725","51","9","doing"),
("1712","51","11","doing"),
("1713","51","16","doing"),
("1714","51","17","doing"),
("1715","51","18","doing"),
("1716","51","19","doing"),
("1718","51","20","doing"),
("1719","51","21","doing"),
("1720","51","22","doing"),
("1721","51","23","not_doing"),
("1722","51","24","doing"),
("2129","51","25","doing"),
("1726","51","27","not_doing"),
("1727","51","28","doing"),
("1081","52","1","doing"),
("1088","52","2","doing"),
("1089","52","3","doing"),
("1090","52","4","doing"),
("1091","52","5","doing"),
("1092","52","6","doing"),
("1093","52","7","doing"),
("1094","52","8","doing"),
("1095","52","9","doing"),
("1082","52","10","doing"),
("1083","52","11","doing"),
("1084","52","12","doing"),
("1085","52","13","doing"),
("1086","52","14","doing"),
("1087","52","15","doing"),
("1096","53","1","doing"),
("1103","53","2","doing"),
("1104","53","3","doing"),
("1105","53","4","doing"),
("1106","53","5","doing"),
("1107","53","6","doing"),
("1108","53","7","doing"),
("1109","53","8","doing"),
("1110","53","9","doing"),
("1097","53","10","doing"),
("1098","53","11","doing"),
("1099","53","12","doing"),
("1100","53","13","doing"),
("1101","53","14","doing"),
("1102","53","15","doing"),
("1111","54","1","doing");
INSERT INTO student_subject VALUES
("1118","54","2","doing"),
("1119","54","3","doing"),
("1120","54","4","doing"),
("1121","54","5","doing"),
("1122","54","6","doing"),
("1123","54","7","doing"),
("1124","54","8","doing"),
("1125","54","9","doing"),
("1112","54","10","doing"),
("1113","54","11","doing"),
("1114","54","12","doing"),
("1115","54","13","doing"),
("1116","54","14","doing"),
("1117","54","15","doing"),
("1126","55","1","doing"),
("1133","55","2","doing"),
("1134","55","3","doing"),
("1135","55","4","doing"),
("1136","55","5","doing"),
("1137","55","6","doing"),
("1138","55","7","doing"),
("1139","55","8","doing"),
("1140","55","9","doing"),
("1127","55","10","doing"),
("1128","55","11","doing"),
("1129","55","12","doing"),
("1130","55","13","doing"),
("1131","55","14","doing"),
("1132","55","15","doing"),
("1141","56","1","doing"),
("1148","56","2","doing"),
("1149","56","3","doing"),
("1150","56","4","doing"),
("1151","56","5","doing"),
("1152","56","6","doing"),
("1153","56","7","doing"),
("1154","56","8","doing"),
("1155","56","9","doing"),
("1142","56","10","doing"),
("1143","56","11","doing"),
("1144","56","12","doing"),
("1145","56","13","doing"),
("1146","56","14","doing"),
("1147","56","15","doing"),
("1156","57","1","doing"),
("1163","57","2","doing"),
("1164","57","3","doing"),
("1165","57","4","doing"),
("1166","57","5","doing"),
("1167","57","6","doing"),
("1168","57","7","doing"),
("1169","57","8","doing"),
("1170","57","9","doing"),
("1157","57","10","doing"),
("1158","57","11","doing"),
("1159","57","12","doing"),
("1160","57","13","doing"),
("1161","57","14","doing"),
("1162","57","15","doing"),
("1171","58","1","doing"),
("1178","58","2","doing"),
("1179","58","3","doing"),
("1180","58","4","doing"),
("1181","58","5","doing"),
("1182","58","6","doing"),
("1183","58","7","doing"),
("1184","58","8","doing"),
("1185","58","9","doing"),
("1172","58","10","doing"),
("1173","58","11","doing"),
("1174","58","12","doing"),
("1175","58","13","doing"),
("1176","58","14","doing"),
("1177","58","15","doing"),
("1186","59","1","not_doing"),
("1193","59","2","not_doing"),
("1194","59","3","not_doing"),
("1195","59","4","not_doing"),
("1196","59","5","not_doing"),
("1197","59","6","not_doing"),
("1198","59","7","not_doing"),
("1199","59","8","not_doing"),
("1200","59","9","not_doing"),
("1187","59","10","not_doing"),
("1188","59","11","doing"),
("1189","59","12","not_doing"),
("1190","59","13","not_doing"),
("1191","59","14","not_doing"),
("1192","59","15","not_doing"),
("1201","60","1","doing"),
("1208","60","2","doing"),
("1209","60","3","doing"),
("1210","60","4","doing"),
("1211","60","5","doing"),
("1212","60","6","doing"),
("1213","60","7","doing"),
("1214","60","8","doing"),
("1215","60","9","doing"),
("1202","60","10","doing"),
("1203","60","11","doing");
INSERT INTO student_subject VALUES
("1204","60","12","doing"),
("1205","60","13","doing"),
("1206","60","14","doing"),
("1207","60","15","doing"),
("1216","61","1","doing"),
("1223","61","2","doing"),
("1224","61","3","doing"),
("1225","61","4","doing"),
("1226","61","5","doing"),
("1227","61","6","doing"),
("1228","61","7","doing"),
("1229","61","8","doing"),
("1230","61","9","doing"),
("1217","61","10","doing"),
("1218","61","11","doing"),
("1219","61","12","doing"),
("1220","61","13","doing"),
("1221","61","14","doing"),
("1222","61","15","doing"),
("1231","62","1","doing"),
("1238","62","2","doing"),
("1239","62","3","not_doing"),
("1240","62","4","not_doing"),
("1241","62","5","not_doing"),
("1242","62","6","not_doing"),
("1243","62","7","not_doing"),
("1244","62","8","not_doing"),
("1245","62","9","not_doing"),
("1232","62","10","doing"),
("1233","62","11","not_doing"),
("1234","62","12","not_doing"),
("1235","62","13","doing"),
("1236","62","14","doing"),
("1237","62","15","not_doing"),
("1246","63","1","doing"),
("1253","63","2","doing"),
("1254","63","3","doing"),
("1255","63","4","doing"),
("1256","63","5","doing"),
("1257","63","6","doing"),
("1258","63","7","doing"),
("1259","63","8","doing"),
("1260","63","9","doing"),
("1247","63","10","doing"),
("1248","63","11","doing"),
("1249","63","12","doing"),
("1250","63","13","doing"),
("1251","63","14","doing"),
("1252","63","15","doing"),
("1261","64","1","doing"),
("1268","64","2","not_doing"),
("1269","64","3","doing"),
("1270","64","4","doing"),
("1271","64","5","doing"),
("1272","64","6","doing"),
("1273","64","7","doing"),
("1274","64","8","doing"),
("1275","64","9","doing"),
("1262","64","10","not_doing"),
("1263","64","11","not_doing"),
("1264","64","12","doing"),
("1265","64","13","doing"),
("1266","64","14","doing"),
("1267","64","15","not_doing"),
("1276","65","1","doing"),
("1283","65","2","doing"),
("1284","65","3","doing"),
("1285","65","4","doing"),
("1286","65","5","doing"),
("1287","65","6","doing"),
("1288","65","7","doing"),
("1289","65","8","doing"),
("1290","65","9","doing"),
("1277","65","10","doing"),
("1278","65","11","doing"),
("1279","65","12","doing"),
("1280","65","13","doing"),
("1281","65","14","doing"),
("1282","65","15","doing"),
("1291","66","1","doing"),
("1298","66","2","doing"),
("1299","66","3","doing"),
("1300","66","4","doing"),
("1301","66","5","doing"),
("1302","66","6","doing"),
("1303","66","7","doing"),
("1304","66","8","doing"),
("1305","66","9","doing"),
("1292","66","10","doing"),
("1293","66","11","doing"),
("1294","66","12","doing"),
("1295","66","13","doing"),
("1296","66","14","doing"),
("1297","66","15","doing"),
("1306","67","1","doing"),
("1313","67","2","doing"),
("1314","67","3","doing"),
("1315","67","4","doing"),
("1316","67","5","doing"),
("1317","67","6","doing");
INSERT INTO student_subject VALUES
("1318","67","7","doing"),
("1319","67","8","doing"),
("1320","67","9","doing"),
("1307","67","10","doing"),
("1308","67","11","doing"),
("1309","67","12","doing"),
("1310","67","13","doing"),
("1311","67","14","doing"),
("1312","67","15","doing"),
("1321","68","1","doing"),
("1328","68","2","doing"),
("1329","68","3","doing"),
("1330","68","4","doing"),
("1331","68","5","doing"),
("1332","68","6","doing"),
("1333","68","7","doing"),
("1334","68","8","doing"),
("1335","68","9","doing"),
("1322","68","10","doing"),
("1323","68","11","doing"),
("1324","68","12","doing"),
("1325","68","13","doing"),
("1326","68","14","doing"),
("1327","68","15","doing"),
("1728","69","1","doing"),
("1734","69","2","doing"),
("1740","69","3","doing"),
("1741","69","4","doing"),
("1742","69","9","doing"),
("1729","69","11","doing"),
("1730","69","16","doing"),
("1731","69","17","doing"),
("1732","69","18","doing"),
("1733","69","19","doing"),
("1735","69","20","doing"),
("1736","69","21","doing"),
("1737","69","22","doing"),
("1738","69","23","not_doing"),
("1739","69","24","doing"),
("2130","69","25","doing"),
("1743","69","27","not_doing"),
("1744","69","28","doing"),
("1745","70","1","doing"),
("1751","70","2","doing"),
("1757","70","3","doing"),
("1758","70","4","doing"),
("1759","70","9","doing"),
("1746","70","11","doing"),
("1747","70","16","doing"),
("1748","70","17","doing"),
("1749","70","18","doing"),
("1750","70","19","doing"),
("1752","70","20","doing"),
("1753","70","21","doing"),
("1754","70","22","doing"),
("1755","70","23","not_doing"),
("1756","70","24","doing"),
("2131","70","25","doing"),
("1760","70","27","not_doing"),
("1761","70","28","doing"),
("1762","71","1","doing"),
("1768","71","2","doing"),
("1774","71","3","doing"),
("1775","71","4","doing"),
("1776","71","9","doing"),
("1763","71","11","doing"),
("1764","71","16","doing"),
("1765","71","17","doing"),
("1766","71","18","doing"),
("1767","71","19","doing"),
("1769","71","20","doing"),
("1770","71","21","doing"),
("1771","71","22","doing"),
("1772","71","23","not_doing"),
("1773","71","24","doing"),
("2132","71","25","doing"),
("1777","71","27","not_doing"),
("1778","71","28","doing"),
("1381","72","1","doing"),
("1387","72","2","doing"),
("1393","72","3","doing"),
("1394","72","4","doing"),
("1382","72","11","doing"),
("1383","72","16","not_doing"),
("1384","72","17","not_doing"),
("1385","72","18","doing"),
("1386","72","19","not_doing"),
("1388","72","20","doing"),
("1389","72","21","doing"),
("1390","72","22","doing"),
("1391","72","23","doing"),
("1396","72","27","doing"),
("1493","72","28","not_doing"),
("1398","73","1","doing"),
("1403","73","2","doing"),
("1409","73","3","not_doing"),
("1406","73","4","doing"),
("1399","73","11","not_doing"),
("1400","73","16","doing"),
("1401","73","17","doing");
INSERT INTO student_subject VALUES
("1402","73","18","doing"),
("1404","73","20","doing"),
("1410","73","21","not_doing"),
("1405","73","23","not_doing"),
("1408","73","24","not_doing"),
("1407","73","27","not_doing"),
("1508","73","28","doing"),
("1416","74","1","doing"),
("1423","74","2","doing"),
("1424","74","3","doing"),
("1425","74","4","doing"),
("1426","74","5","doing"),
("1427","74","6","doing"),
("1428","74","7","doing"),
("1429","74","8","doing"),
("1430","74","9","doing"),
("1417","74","10","doing"),
("1418","74","11","doing"),
("1419","74","12","doing"),
("1420","74","13","doing"),
("1421","74","14","doing"),
("1422","74","15","doing"),
("1431","75","1","doing"),
("1438","75","2","doing"),
("1439","75","3","doing"),
("1440","75","4","doing"),
("1441","75","5","doing"),
("1442","75","6","doing"),
("1443","75","7","doing"),
("1444","75","8","doing"),
("1445","75","9","doing"),
("1432","75","10","doing"),
("1433","75","11","doing"),
("1434","75","12","doing"),
("1435","75","13","doing"),
("1436","75","14","doing"),
("1437","75","15","doing"),
("1446","76","1","not_doing"),
("1453","76","2","not_doing"),
("1454","76","3","not_doing"),
("1455","76","4","not_doing"),
("1456","76","5","not_doing"),
("1457","76","6","not_doing"),
("1458","76","7","not_doing"),
("1459","76","8","not_doing"),
("1460","76","9","not_doing"),
("1447","76","10","not_doing"),
("1448","76","11","not_doing"),
("1449","76","12","not_doing"),
("1450","76","13","not_doing"),
("1451","76","14","not_doing"),
("1452","76","15","not_doing"),
("1461","77","1","not_doing"),
("1468","77","2","not_doing"),
("1469","77","3","not_doing"),
("1470","77","4","not_doing"),
("1471","77","5","not_doing"),
("1472","77","6","not_doing"),
("1473","77","7","not_doing"),
("1474","77","8","not_doing"),
("1475","77","9","not_doing"),
("1462","77","10","not_doing"),
("1463","77","11","doing"),
("1464","77","12","not_doing"),
("1465","77","13","not_doing"),
("1466","77","14","not_doing"),
("1467","77","15","doing"),
("1779","78","1","doing"),
("1785","78","2","doing"),
("1791","78","3","doing"),
("1792","78","4","doing"),
("1793","78","9","doing"),
("1780","78","11","doing"),
("1781","78","16","doing"),
("1782","78","17","doing"),
("1783","78","18","doing"),
("1784","78","19","doing"),
("1786","78","20","doing"),
("1787","78","21","doing"),
("1788","78","22","doing"),
("1789","78","23","not_doing"),
("1790","78","24","doing"),
("2133","78","25","doing"),
("1794","78","27","not_doing"),
("1795","78","28","doing"),
("1509","79","1","doing"),
("1516","79","2","not_doing"),
("1517","79","3","doing"),
("1518","79","4","not_doing"),
("1519","79","5","doing"),
("1520","79","6","not_doing"),
("1521","79","7","doing"),
("1522","79","8","doing"),
("1523","79","9","not_doing"),
("1510","79","10","not_doing"),
("1511","79","11","doing"),
("1512","79","12","not_doing"),
("1513","79","13","not_doing"),
("1514","79","14","not_doing"),
("1515","79","15","doing");
INSERT INTO student_subject VALUES
("1804","80","1","doing"),
("1811","80","2","doing"),
("1812","80","3","doing"),
("1813","80","4","doing"),
("1814","80","5","doing"),
("1815","80","6","doing"),
("1816","80","7","doing"),
("1817","80","8","doing"),
("1818","80","9","doing"),
("1805","80","10","doing"),
("1806","80","11","doing"),
("1807","80","12","doing"),
("1808","80","13","doing"),
("1809","80","14","doing"),
("1810","80","15","doing"),
("1819","81","1","doing"),
("1826","81","2","doing"),
("1827","81","3","doing"),
("1828","81","4","doing"),
("1829","81","5","doing"),
("1830","81","6","doing"),
("1831","81","7","doing"),
("1832","81","8","doing"),
("1833","81","9","doing"),
("1820","81","10","doing"),
("1821","81","11","doing"),
("1822","81","12","doing"),
("1823","81","13","doing"),
("1824","81","14","doing"),
("1825","81","15","doing"),
("1834","82","1","doing"),
("1841","82","2","doing"),
("1842","82","3","doing"),
("1843","82","4","doing"),
("1844","82","5","doing"),
("1845","82","6","doing"),
("1846","82","7","doing"),
("1847","82","8","doing"),
("1848","82","9","doing"),
("1835","82","10","doing"),
("1836","82","11","doing"),
("1837","82","12","doing"),
("1838","82","13","doing"),
("1839","82","14","doing"),
("1840","82","15","doing"),
("1849","83","1","doing"),
("1856","83","2","doing"),
("1857","83","3","doing"),
("1858","83","4","doing"),
("1859","83","5","doing"),
("1860","83","6","doing"),
("1861","83","7","doing"),
("1862","83","8","doing"),
("1863","83","9","doing"),
("1850","83","10","doing"),
("1851","83","11","doing"),
("1852","83","12","doing"),
("1853","83","13","doing"),
("1854","83","14","doing"),
("1855","83","15","doing"),
("1864","84","1","doing"),
("1871","84","2","doing"),
("1872","84","3","doing"),
("1873","84","4","doing"),
("1874","84","5","doing"),
("1875","84","6","doing"),
("1876","84","7","doing"),
("1877","84","8","doing"),
("1878","84","9","doing"),
("1865","84","10","doing"),
("1866","84","11","doing"),
("1867","84","12","doing"),
("1868","84","13","doing"),
("1869","84","14","doing"),
("1870","84","15","doing"),
("1879","85","1","doing"),
("1886","85","2","doing"),
("1887","85","3","doing"),
("1888","85","4","doing"),
("1889","85","5","doing"),
("1890","85","6","doing"),
("1891","85","7","doing"),
("1892","85","8","doing"),
("1893","85","9","doing"),
("1880","85","10","doing"),
("1881","85","11","doing"),
("1882","85","12","doing"),
("1883","85","13","doing"),
("1884","85","14","doing"),
("1885","85","15","doing"),
("1894","86","1","doing"),
("1901","86","2","doing"),
("1902","86","3","doing"),
("1903","86","4","doing"),
("1904","86","5","doing"),
("1905","86","6","doing"),
("1906","86","7","doing"),
("1907","86","8","doing"),
("1908","86","9","doing"),
("1895","86","10","doing");
INSERT INTO student_subject VALUES
("1896","86","11","doing"),
("1897","86","12","doing"),
("1898","86","13","doing"),
("1899","86","14","doing"),
("1900","86","15","doing"),
("1909","87","1","doing"),
("1916","87","2","doing"),
("1917","87","3","doing"),
("1918","87","4","doing"),
("1919","87","5","doing"),
("1920","87","6","doing"),
("1921","87","7","doing"),
("1922","87","8","doing"),
("1923","87","9","doing"),
("1910","87","10","doing"),
("1911","87","11","doing"),
("1912","87","12","doing"),
("1913","87","13","doing"),
("1914","87","14","doing"),
("1915","87","15","doing"),
("1924","88","1","doing"),
("1931","88","2","doing"),
("1932","88","3","doing"),
("1933","88","4","doing"),
("1934","88","5","doing"),
("1935","88","6","doing"),
("1936","88","7","doing"),
("1937","88","8","doing"),
("1938","88","9","doing"),
("1925","88","10","doing"),
("1926","88","11","doing"),
("1927","88","12","doing"),
("1928","88","13","doing"),
("1929","88","14","doing"),
("1930","88","15","doing"),
("1939","89","1","doing"),
("1946","89","2","doing"),
("1947","89","3","doing"),
("1948","89","4","doing"),
("1949","89","5","doing"),
("1950","89","6","doing"),
("1951","89","7","doing"),
("1952","89","8","doing"),
("1953","89","9","doing"),
("1940","89","10","doing"),
("1941","89","11","doing"),
("1942","89","12","doing"),
("1943","89","13","doing"),
("1944","89","14","doing"),
("1945","89","15","doing"),
("1954","90","1","doing"),
("1961","90","2","doing"),
("1962","90","3","doing"),
("1963","90","4","doing"),
("1964","90","5","doing"),
("1965","90","6","doing"),
("1966","90","7","doing"),
("1967","90","8","doing"),
("1968","90","9","doing"),
("1955","90","10","doing"),
("1956","90","11","doing"),
("1957","90","12","doing"),
("1958","90","13","doing"),
("1959","90","14","doing"),
("1960","90","15","doing"),
("1969","91","1","doing"),
("1976","91","2","doing"),
("1977","91","3","doing"),
("1978","91","4","doing"),
("1979","91","5","doing"),
("1980","91","6","doing"),
("1981","91","7","doing"),
("1982","91","8","doing"),
("1983","91","9","doing"),
("1970","91","10","doing"),
("1971","91","11","doing"),
("1972","91","12","doing"),
("1973","91","13","doing"),
("1974","91","14","doing"),
("1975","91","15","doing"),
("1984","92","1","doing"),
("1991","92","2","doing"),
("1992","92","3","doing"),
("1993","92","4","doing"),
("1994","92","5","doing"),
("1995","92","6","doing"),
("1996","92","7","doing"),
("1997","92","8","doing"),
("1998","92","9","doing"),
("1985","92","10","doing"),
("1986","92","11","doing"),
("1987","92","12","doing"),
("1988","92","13","doing"),
("1989","92","14","doing"),
("1990","92","15","doing"),
("1999","93","1","doing"),
("2006","93","2","doing"),
("2007","93","3","doing"),
("2008","93","4","doing"),
("2009","93","5","doing");
INSERT INTO student_subject VALUES
("2010","93","6","doing"),
("2011","93","7","doing"),
("2012","93","8","doing"),
("2013","93","9","doing"),
("2000","93","10","doing"),
("2001","93","11","doing"),
("2002","93","12","doing"),
("2003","93","13","doing"),
("2004","93","14","doing"),
("2005","93","15","doing"),
("2014","94","1","doing"),
("2021","94","2","doing"),
("2022","94","3","doing"),
("2023","94","4","doing"),
("2024","94","5","doing"),
("2025","94","6","doing"),
("2026","94","7","doing"),
("2027","94","8","doing"),
("2028","94","9","doing"),
("2015","94","10","doing"),
("2016","94","11","doing"),
("2017","94","12","doing"),
("2018","94","13","doing"),
("2019","94","14","doing"),
("2020","94","15","doing"),
("2029","95","1","doing"),
("2036","95","2","doing"),
("2037","95","3","doing"),
("2038","95","4","doing"),
("2039","95","5","doing"),
("2040","95","6","doing"),
("2041","95","7","doing"),
("2042","95","8","doing"),
("2043","95","9","doing"),
("2030","95","10","doing"),
("2031","95","11","doing"),
("2032","95","12","doing"),
("2033","95","13","doing"),
("2034","95","14","doing"),
("2035","95","15","doing"),
("2044","96","1","doing"),
("2051","96","2","doing"),
("2052","96","3","doing"),
("2053","96","4","doing"),
("2054","96","5","doing"),
("2055","96","6","doing"),
("2056","96","7","doing"),
("2057","96","8","doing"),
("2058","96","9","doing"),
("2045","96","10","doing"),
("2046","96","11","doing"),
("2047","96","12","doing"),
("2048","96","13","doing"),
("2049","96","14","doing"),
("2050","96","15","doing"),
("2059","97","1","doing"),
("2066","97","2","doing"),
("2067","97","3","doing"),
("2068","97","4","doing"),
("2069","97","5","doing"),
("2070","97","6","doing"),
("2071","97","7","doing"),
("2072","97","8","doing"),
("2073","97","9","doing"),
("2060","97","10","doing"),
("2061","97","11","doing"),
("2062","97","12","doing"),
("2063","97","13","doing"),
("2064","97","14","doing"),
("2065","97","15","doing"),
("2074","98","1","doing"),
("2081","98","2","doing"),
("2082","98","3","doing"),
("2083","98","4","doing"),
("2084","98","5","doing"),
("2085","98","6","doing"),
("2086","98","7","doing"),
("2087","98","8","doing"),
("2088","98","9","doing"),
("2075","98","10","doing"),
("2076","98","11","doing"),
("2077","98","12","doing"),
("2078","98","13","doing"),
("2079","98","14","doing"),
("2080","98","15","doing"),
("2089","99","1","doing"),
("2096","99","2","doing"),
("2097","99","3","doing"),
("2098","99","4","doing"),
("2099","99","5","doing"),
("2100","99","6","doing"),
("2101","99","7","doing"),
("2102","99","8","doing"),
("2103","99","9","doing"),
("2090","99","10","doing"),
("2091","99","11","doing"),
("2092","99","12","doing"),
("2093","99","13","doing"),
("2094","99","14","doing"),
("2095","99","15","doing");
INSERT INTO student_subject VALUES
("2104","100","1","doing"),
("2109","100","2","doing"),
("2115","100","3","doing"),
("2112","100","4","doing"),
("2105","100","11","not_doing"),
("2106","100","16","not_doing"),
("2107","100","17","not_doing"),
("2108","100","18","doing"),
("2110","100","20","doing"),
("2116","100","21","doing"),
("2111","100","23","doing"),
("2113","100","27","doing"),
("2117","100","28","not_doing"),
("2142","101","1","doing"),
("2149","101","2","doing"),
("2150","101","3","doing"),
("2151","101","4","doing"),
("2152","101","5","doing"),
("2153","101","6","doing"),
("2154","101","7","doing"),
("2155","101","8","doing"),
("2156","101","9","doing"),
("2143","101","10","doing"),
("2144","101","11","doing"),
("2145","101","12","doing"),
("2146","101","13","doing"),
("2147","101","14","doing"),
("2148","101","15","doing"),
("2157","102","1","doing"),
("2164","102","2","doing"),
("2165","102","3","doing"),
("2166","102","4","doing"),
("2167","102","5","doing"),
("2168","102","6","doing"),
("2169","102","7","doing"),
("2170","102","8","doing"),
("2171","102","9","doing"),
("2158","102","10","doing"),
("2159","102","11","doing"),
("2160","102","12","doing"),
("2161","102","13","doing"),
("2162","102","14","doing"),
("2163","102","15","doing"),
("2172","103","1","doing"),
("2179","103","2","doing"),
("2180","103","3","doing"),
("2181","103","4","doing"),
("2182","103","5","doing"),
("2183","103","6","doing"),
("2184","103","7","doing"),
("2185","103","8","doing"),
("2186","103","9","doing"),
("2173","103","10","doing"),
("2174","103","11","doing"),
("2175","103","12","doing"),
("2176","103","13","doing"),
("2177","103","14","doing"),
("2178","103","15","not_doing"),
("2187","104","1","doing"),
("2193","104","2","doing"),
("2197","104","3","not_doing"),
("2198","104","4","doing"),
("2188","104","11","doing"),
("2189","104","16","doing"),
("2190","104","17","doing"),
("2191","104","18","doing"),
("2192","104","19","doing"),
("2194","104","20","doing"),
("2195","104","21","not_doing"),
("2200","104","22","not_doing"),
("2196","104","23","doing"),
("2199","104","27","not_doing"),
("2201","104","28","doing"),
("2202","105","1","doing"),
("2208","105","2","doing"),
("2214","105","3","doing"),
("2215","105","4","doing"),
("2216","105","9","doing"),
("2203","105","11","doing"),
("2204","105","16","doing"),
("2205","105","17","doing"),
("2206","105","18","doing"),
("2207","105","19","doing"),
("2209","105","20","doing"),
("2210","105","21","doing"),
("2211","105","22","doing"),
("2212","105","23","not_doing"),
("2213","105","24","doing"),
("2219","105","25","not_doing"),
("2217","105","27","not_doing"),
("2218","105","28","doing"),
("2220","106","1","not_doing"),
("2227","106","2","doing"),
("2228","106","3","doing"),
("2229","106","4","not_doing"),
("2230","106","5","doing"),
("2231","106","6","doing"),
("2232","106","7","not_doing"),
("2233","106","8","doing"),
("2234","106","9","doing");
INSERT INTO student_subject VALUES
("2221","106","10","doing"),
("2222","106","11","doing"),
("2223","106","12","not_doing"),
("2224","106","13","doing"),
("2225","106","14","not_doing"),
("2226","106","15","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=107 DEFAULT CHARSET=latin1;


INSERT INTO students VALUES
("1","156c097c33a","56","2","4","0","0","0","0","","MARSHAL","PETER","AKPAN","S/18/0001","$2y$10$eRjgbP4nn.zvRvZDa5sHEOO5uJ/L6IHszYKUmIOLsB1h2If8nryje","anmarshal","anmarshal","","2007-09-13","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/8a1e50.jpg","PARENT","","","","0","1590492634","0","0","","0","","check_result","activated","2019-01-17 13:09:13"),
("2","256cd322f9d","56","7","4","0","0","0","0","","WILLIAMS","","WISE","S/18/0002","$2y$10$DVSIXq5Yy/U5G9FXEDEaNu4CITxpdRlGlQKHWhpfZD.gzUtNhDLnO","sewilliams","sewilliams","","2008-05-12","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/e885bd.jpg","PARENT","","","","0","1641979356","0","0","","0","","check_result","activated","2019-01-17 13:09:42"),
("3","3564d5b0c20","56","6","4","0","0","0","0","","DESTINY","","UBAWUIKE","S/18/0003","$2y$10$5UjYgbmNpneoUCKfSYXPwOgSYCQ.CSwMWtlCERWtRILfBygK571sm","kedestiny","kedestiny","","2009-02-22","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/3c37e7.jpg","PARENT","","","","0","1633975849","0","0","","0","","check_result","activated","2019-01-17 13:10:15"),
("4","456c55a2b51","56","4","4","0","0","0","0","","BLOSSOM","","NWOKE","S/18/0004","$2y$10$5PNmantg20ORX4VC7ZslMeVBQBheAMqWZdqXkgYkvaPfNohzIoLo.","keblossom","keblossom","","2008-02-26","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/8b5f31.jpg","PARENT","","","","0","1643028551","0","0","","0","","check_result","activated","2019-01-17 13:11:00"),
("5","5563ca2b0ad","56","3","4","0","0","0","0","","CHINENYE","CHIGOZIRIM","LIVINUS","S/18/0005","$2y$10$k5cBhH41f7HVAh8VPmCzIu3CXeCRauYDbfZ3tXQVB7WtcJDlXnvC.","uschinenye","uschinenye","","2008-07-13","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/8f61ad.jpg","PARENT","","","","0","1590766177","0","0","","0","","check_result","activated","2019-01-17 13:11:34"),
("6","65693a756f8","56","5","4","0","0","0","0","","AMARACHI","D","SOLOMON","S/18/0006","$2y$10$OLZnHShkRFi05kdensuI6OecaCglBRfoBahStUN5tJ8nBuXLjBrkG","onamarachi","onamarachi","","2008-02-03","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/064522.jpg","PARENT","","","","0","1590742293","0","0","","0","","check_result","activated","2019-01-17 13:12:06"),
("7","75634d5cad9","56","1","4","0","0","0","0","","COMFORT","VICTOR","AKPAN","S/18/0007","$2y$10$P/jnI9fhqumSy5vQfK4DAOb/6XkWVmZc6vdwxkR1ZsEhPJL0G5AE2","ancomfort","ancomfort","","2008-07-20","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/3bd036.jpg","PARENT","","","","0","1550820622","0","0","","0","","check_result","activated","2019-01-17 13:12:42"),
("8","85643751036","56","11","6","0","0","0","0","","DESTINY","","FELIX","S/18/0008","$2y$10$MIn2vY0OfhiJ0gmz6EKZ0OdOdWIZILF0XiiEPYVVrA5r6m4Bpn0I.","ixdestiny","ixdestiny","","2006-01-31","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/951283.jpg","PARENT","","","","1","1622465250","0","0","","0","","not_check_result","activated","2019-01-17 13:54:29"),
("9","9565337000e","56","8","4","0","0","0","0","","CHIDIEBERE","","ONYEABOR","S/18/0009","$2y$10$SK6CkegEAB8BMrnOcVMaD.4REK65pq3Pv4kVlrSiD2LWgfhonKG.K","orchidiebere","orchidiebere","","2005-03-20","male","Christianity","","","","","2019/2020","1st Term","","/home/zeonglob/public_html/firm//private/images/student_passport/77b7b7.jpg","PARENT","","","","0","0","0","0","","0","","not_check_result","deactivated","2019-01-17 13:54:59"),
("10","10563eabd9e5","56","13","6","0","0","0","0","","DANIEL","","ONUM","S/18/0010","$2y$10$VbYmA/MS5Sapb8S6ygyfY.hOMOsfm.7xLCmR6nVKpv1iVk//lAM/C","umdaniel","umdaniel","","2007-03-06","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/eab2ee.jpg","PARENT","","","","0","1644416424","0","0","","0","","check_result","activated","2019-01-17 13:55:27"),
("11","115685f13785","56","14","6","0","0","0","0","","FAVOUR","","AZUNNA","S/18/0011","$2y$10$WQz3.w5tz/JlhsBPvcHbbOMnWiyjfZaPyny4CjqxfVFfe.93jhxse","nafavour","nafavour","","2005-07-02","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/5ed8d9.jpg","PARENT","","","","0","1644415980","0","0","","0","","check_result","activated","2019-01-17 13:56:11"),
("12","125692baf033","56","3","6","0","0","0","0","","NMESOMA","","LIVINUS","S/18/0012","$2y$10$99H.T19DzCJCtwS/yOB70.6/WzjJdjZoQWbKpdpae0NhgU8XSRdSe","usnmesoma","usnmesoma","","2007-01-19","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/eb8bba.jpg","PARENT","","","","0","1644416276","0","0","","0","","check_result","activated","2019-01-17 13:56:56"),
("13","1356abba4617","56","15","4","0","0","0","0","","DOOSHIMA","","TORKUMA","S/18/0013","$2y$10$ZGy8jYn2cbEhQ.Ayfkmf4eypji.ZlNJ9JFd9es8Z6/EdpFvnh3HwG","madooshima","madooshima","","2005-10-21","female","Christianity","","","","","2019/2020","1st Term","","/home/zeonglob/public_html/firm//private/images/student_passport/812935.jpg","PARENT","","","","0","0","0","0","","0","","check_result","deactivated","2019-01-17 13:57:31"),
("14","1456b2dac788","56","12","4","0","0","0","0","","SAMSON","","FIYEBO","S/18/0014","$2y$10$dCpyNgidL8RvXQcGDyUMtOGYX5DTKQpMyRpGOqbiMvm5SrYSMj/Rq","bosamson","bosamson","","2006-02-03","male","Christianity","","","","","2019/2020","1st Term","","/home/zeonglob/public_html/firm//private/images/student_passport/4d7cb5.jpg","PARENT","","","","0","0","0","0","","0","","check_result","deactivated","2019-01-17 13:58:03"),
("15","155632c53153","56","16","0","0","0","0","0","","QUEEN","B","NNA","S/18/0015","$2y$10$wgkluYDwteTai2fuptHfWORGwlRR.rt0Mrzd9bOzhNcTj/8Qe/QL2","naqueen","naqueen","","2004-05-13","female","Christianity","","","2020/2021","3rd Term","","","","/home/zeonglob/public_html/firm//private/images/student_passport/3e4112.jpg","PARENT","","","","0","1563977447","0","0","","0","","check_result","graduated","2019-01-18 16:53:02"),
("16","1656516b2dcd","56","17","0","0","0","0","0","","CHIOMA","DEBORAH","ONOUHA","S/18/0016","$2y$10$IRQ4H.7layk6ZJPcnqZJaOmYFgWGBvftD86OhmhrIO1aD.rcK1dqi","hachioma","hachioma","","2005-10-10","female","Christianity","","","2020/2021","3rd Term","","","","/home/zeonglob/public_html/firm//private/images/student_passport/46375d.jpg","PARENT","","","","0","1589275991","0","0","","0","","check_result","graduated","2019-01-18 16:53:42"),
("17","1756992fde3e","56","10","0","0","0","0","0","","SALIHU","AKRAM","AISHA","S/18/0017","$2y$10$6fXJ.M7c7FM5yu5iiu.wau/j2zpY8dMmzzUFzhfcvwIsaaJC4t/ym","hasalihu","hasalihu","","2006-03-23","female","Islam","","","2020/2021","3rd Term","","","","/home/zeonglob/public_html/firm//private/images/student_passport/f9364f.jpg","PARENT","","","","0","1622474171","0","0","","0","","check_result","graduated","2019-01-18 16:54:33"),
("18","1856484ce2d6","56","20","0","0","0","0","0","","RUTH","","MARKUS","S/18/0018","$2y$10$fdZxDxYwPVtz6tFC.IfdOuicpppHBSZmoOttrkl1u2Bsp7v.mrMuS","usruth","usruth","","2003-12-28","female","Christianity","","","2019/2020","3rd Term","","","","/home/zeonglob/public_html/firm//private/images/student_passport/87d650.jpg","PARENT","","","","0","1589448903","0","0","","0","","check_result","graduated","2019-01-21 11:30:30"),
("19","19567a4dcad7","56","4","0","0","0","0","0","","SHANTEL","","NWOKE","S/18/0019","$2y$10$lFL/5CW7iYtfpduilDNCieYEKNe6d2lrtGBW8t61wzJ1zrlVT.j4a","keshantel","keshantel","","2005-04-06","female","Christianity","","","2019/2020","3rd Term","","","","/home/zeonglob/public_html/firm//private/images/student_passport/2666e6.jpg","PARENT","","","","2","1551210014","0","0","","0","","check_result","graduated","2019-01-21 11:31:02"),
("20","20567d5172cd","56","10","0","0","0","0","0","","FADILA","","SALIHU","S/18/0020","$2y$10$M5lPLdGdJwZNJ2BZAcxmi.bA1Jf36HEdMXIYbUi2TIP8zoceXgqi.","iifadila","iifadila","","2004-06-10","female","Islam","","","2019/2020","3rd Term","","","","/home/zeonglob/public_html/firm//private/images/student_passport/601552.jpg","PARENT","","","","0","1589534937","0","0","","0","","check_result","graduated","2019-01-21 11:32:00"),
("21","2156c5c12ca5","56","18","0","0","0","0","0","","OBINNA","","ENEJE","S/18/0021","$2y$10$2eA80Ros1abHWKV.4YXA/O61q01PdSE5e6QFEKxuaHQQpQz5eB6Wq","jeobinna","jeobinna","","2003-08-25","male","Christianity","","","2019/2020","3rd Term","","","","/home/zeonglob/public_html/firm//private/images/student_passport/f45de3.jpg","PARENT","","","","0","1551210965","0","0","","0","","check_result","graduated","2019-01-21 11:33:26"),
("22","2256a3c0ea1b","56","21","0","0","0","0","0","","QUEEN","","TIGIRI","S/18/0022","$2y$10$jkJdm0lDfLt8EE0dUm0YO.AQj90bUNfc1MMxhtZ0hEgZVrFEBp6v6","riqueen","riqueen","","2002-12-25","female","Christianity","","","2019/2020","3rd Term","","","","/home/zeonglob/public_html/firm//private/images/student_passport/ec7b0c.jpg","PARENT","","","","0","0","0","0","","0","","check_result","graduated","2019-01-21 11:34:17"),
("23","2356acbc7804","56","19","0","0","0","0","0","","ESTHER","","ISIRAMWEN","S/18/0023","$2y$10$qY9haw4wVTfmGpc8NwlTKu9M.gbHY20.df6Vg6laliavuq8qiXIxW","enesther","enesther","","2003-01-12","female","Christianity","","","2019/2020","3rd Term","","","","/home/zeonglob/public_html/firm//private/images/student_passport/b1f15f.jpg","PARENT","","","","0","1589792191","0","0","","0","","check_result","graduated","2019-01-21 12:16:33"),
("24","2456a1c8194a","56","10","0","0","0","0","0","","SALIHU","AKRAM","FARUQ","S/18/0024","$2y$10$y1bWRWzyERe6lo6a1KtthOfR7FUzrL9w0Ea9E.Mmn9NunzM0Tdix.","ugsalihu","ugsalihu","","2003-11-13","female","Christianity","","","2018/2019","3rd Term","2018/2019","3rd Term","","","PARENT","","","","0","0","0","0","","0","","check_result","graduated","2019-01-21 22:13:47"),
("25","255619ea3d35","56","0","0","0","0","0","0","","HERBERT","","ESTHER","S/18/0025","$2y$10$yhMLjDagQPQbuX0S4z8fPuDGI1VJaB.f5K37WvMLj4NDOswXH0NJS","erherbert","erherbert","","2019-01-02","female","Christianity","","","2018/2019","3rd Term","2018/2019","2nd Term","","","","","","","0","0","0","0","","0","","check_result","graduated","2019-01-21 22:14:14"),
("26","26561781797f","56","10","4","0","0","0","0","","SALIHU","","FAISAL","S/18/0026","$2y$10$tosKiuISH1I3mwA53zYm3ufX3lsg8GXWGQczlQu5SqaCvsn2e63CS","alsalibu","alsalibu","","2005-09-10","male","Christianity","","","","","2019/2020","1st Term","","/home/zeonglob/public_html/firm//private/images/student_passport/1b8265.jpg","PARENT","","","","0","1551211797","0","0","","0","","check_result","deactivated","2019-01-22 10:08:42"),
("27","2756e67c1fd6","56","0","2","0","0","0","0","","NEKUBO","","GODSWILL","S/18/0027","$2y$10$5JIXwWp5c9VmtRzl8gxWPuBuBNGMcyAmiyKNPYU3IanSzeeU23aj2","ernekubo","ernekubo","","2019-01-02","male","Christianity","","","","","2018/2019","2nd Term","","","","","","","0","0","0","0","","0","","check_result","deactivated","2019-01-22 10:10:05"),
("28","285666225158","56","9","5","0","0","0","0","","NWABUEZE","","ESTHER","S/18/0028","$2y$10$GoWL.u5Gyt4xCnliW/kNuu.xBNSTt37cYLAVNdI6G3oQ643803hzq","ernwabueze","ernwabueze","","2006-07-28","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/7ffad6.jpg","PARENT","","","","0","1641643407","0","0","","0","","check_result","activated","2019-01-22 10:10:50"),
("29","2956b469ff32","56","8","4","0","0","0","0","","ONYEABOR","","CHINAZA","S/18/0029","$2y$10$/6UYxyL0OchiajIZvo4seu.Q6drMV6hRhAvAZh2Qz1gkNRsk9dJkG","zaonyeabor","zaonyeabor","","2006-10-28","female","Christianity","","","","","2020/2021","1st Term","","/home/zeonglob/public_html/firm//private/images/student_passport/126989.jpg","PARENT","","","","0","1554193855","0","0","","0","","not_check_result","deactivated","2019-01-22 10:11:58"),
("30","305625332129","56","103","4","0","0","0","0","","CLEMENT","","IFUNANYA","S/18/0030","$2y$10$OCLLo4LmQDad9MU8dLu.Ieba/ti0HwBF6YnFW84XUoidsmUu8ac7a","yaclement","yaclement","","2004-02-04","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/afdcfc.jpg","PARENT","","","","0","0","0","0","","0","","check_result","activated","2019-06-03 12:57:18"),
("31","31565f6e6cd2","56","97","0","0","0","0","0","","MAVERICK","","DICK","S/19/0001","$2y$10$pvUJkrO9PMpbAk7UPdg7fetKV/od1O6qm/rs4drTeafICNyrZuln.","zeonglobal","zeonglobal","","2005-09-03","male","Christianity","","","2020/2021","3rd Term","","","","/home/zeonglob/public_html/firm//private/images/student_passport/a12fb8.jpg","PARENT","","","","0","0","0","0","","0","","check_result","graduated","2019-10-07 10:48:26"),
("32","3256ae60fcf6","56","98","6","0","0","0","0","","MIRACLE","ONYEDIKA","CHUKWUDE","S/19/0002","$2y$10$OGFvseUm8YeVV.chbi/g5uyFpgd6sdYy55Q0I/PJkjDbvl.3V7JFa","zeonglobal","zeonglobal","","2003-01-05","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/f55170.jpg","PARENT","","","","0","1644416735","0","0","","0","","check_result","activated","2019-10-07 11:00:45"),
("33","3356371e8ab9","56","37","5","0","0","0","0","","NABEEHA","ADAMU","ABDULLAHI","S/19/0003","$2y$10$hgncSqSYUyGjgxHbPzTYX.9K.AULucSFqw2Q2TU/TdZipJaQPLNj6","hinabeeha","hinabeeha","","2007-09-13","female","Islam","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/7c7b32.jpg","PARENT","","","","0","1640088749","0","0","","0","","check_result","activated","2019-10-07 11:09:37"),
("35","3556c206728c","56","100","4","0","0","0","0","","BENEDICTA","CHARLES","AUGUSTINE","S/19/0004","$2y$10$ggeVZPFRWLGSN4nkkRmChOHMXAWKuEm0f0Z95ygGugfEJx8sCb5vK","zeonglobal","zeonglobal","","2007-10-04","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/65849a.jpg","PARENT","","","","0","0","0","0","","0","","check_result","activated","2019-10-07 11:44:26"),
("36","3656d405fc14","56","101","4","0","0","0","0","","CHINELO","","ACHEBE","S/19/0005","$2y$10$icJixJiV9yW15HN36jZCz.7lzlVigpyE9Cl9hQANTPBE/bOIjCyfS","zeonglobal","zeonglobal","","2006-01-21","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/19a19c.jpg","PARENT","","","","1","1589190346","0","0","","0","","check_result","activated","2019-10-07 11:50:12"),
("37","375665ab384e","56","102","4","0","0","0","0","","ALEEM","AFEGBUA","ABDUL","S/19/0006","$2y$10$CjkZqSi48AV8WHY5Ss08WexbKGjPrYsUBe/NAlK3IGEEoPQDzpQ2S","zeonglobal","zeonglobal","","2006-12-04","male","Islam","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/9373bf.jpg","PARENT","","","","2","1590496587","0","0","","0","","check_result","activated","2019-10-07 11:54:59"),
("38","38568c578a9d","56","37","3","0","0","0","0","","AMAL","","ABDULLAHI","S/19/0007","$2y$10$SNlJ6mr955dGKizYzMocKeldX4ho/UoINIMosj/LPvcqNHgJlZxAa","hiamal","hiamal","","2009-05-14","female","Islam","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/e75c5c.jpg","PARENT","","","","0","1640113242","0","0","","0","","check_result","activated","2019-10-07 12:12:57"),
("39","39562f3d4002","56","105","3","0","0","0","0","","TEMILOLUWA","","ADEWUMI","S/19/0008","$2y$10$XCELHJhgThynEDTBb0MByOXsn8eeT9qKa088PvuvaI7NwQuwSKCRm","zeonglobal","zeonglobal","","2010-09-27","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/5934c9.jpg","PARENT","","","","0","0","0","0","","0","","check_result","activated","2019-10-07 12:24:54"),
("40","4056a61e6c0d","56","2","3","0","0","0","0","","PETER","JOY","AKPAN","S/19/0009","$2y$10$0Re6t/yoelEUuDn9B3Ep1uCpQ.k.3sHI.ZhWAd/Jly08GUX8FL/Zq","anpeter","anpeter","","2009-11-05","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/00a6e0.jpg","","","","","0","1579823201","0","0","","0","","check_result","activated","2019-10-07 12:26:35"),
("41","4156ef23fb3c","56","97","3","0","0","0","0","","NEWDAWN","","DICK","S/19/0010","$2y$10$Sw7cz2Kd73f9vuo5/comfOPRlM87T3kMMLZw1ZlEhczJ5PH4CTvxK","cknewdawn","cknewdawn","","2010-01-22","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/714e3a.jpg","","","","","0","0","0","0","","0","","check_result","activated","2019-10-07 12:28:40"),
("42","4256b863fab0","56","92","3","0","0","0","0","","CHIOMA","MITCHELL","EREGE","S/19/0011","$2y$10$Tl/E8ScE/GnDGFLLxUiF8.z9.eFHkhcrER7OVWuBmjJhoNinE5d7C","gechioma","gechioma","","2009-03-28","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/0347e5.jpg","PARENT","","","","0","1588930922","0","0","","0","","check_result","activated","2019-10-07 12:32:40"),
("43","435631c7f311","56","11","3","0","0","0","0","","PRAISE","","FELIX","S/19/0012","$2y$10$V195mz3yrd/L16MewlpUu.izwYsw5mNTWGJSTgWHw0dv4w2LKWCIi","ixpraise","ixpraise","","2008-01-10","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/3e162f.jpg","PARENT","","","","0","1589981927","0","0","","0","","check_result","activated","2019-10-07 12:36:46"),
("44","445691d408b2","56","29","3","0","0","0","0","","DICKSON","UNYANA","KARIO","S/19/0013","$2y$10$KXViu5ltT1heaogsTtloHegzieHNJYOKM9PjXHFycj7cu2EttQUma","iodickson","iodickson","","2009-01-20","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/deff96.jpg","PARENT","","","","3","1629216349","0","0","","0","","check_result","activated","2019-10-07 12:39:28"),
("45","45565153bfee","56","89","3","0","0","0","0","","DAVID","ANTHONY","NDUESO","S/19/0014","$2y$10$xHMNHSC/peFSGdty/s1SQOpPbXyXVI1px153EkbxcOQopODTCHCZq","sodavid","sodavid","","2009-05-24","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/428ffc.jpg","PARENT","","","","0","0","0","0","","0","","check_result","activated","2019-10-07 12:41:31"),
("46","46561c95a809","56","90","3","0","0","0","0","","BISHOP","","NWANWA","S/19/0015","$2y$10$8J6KCFzeG0bkJwdzGy0qhuWyQ8Gh1z2n8w9prdqtOzbQ2og/N0zZS","wabishop","wabishop","","2009-09-09","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/93bf26.jpg","PARENT","","","","0","1632225532","0","0","","0","","check_result","activated","2019-10-07 12:43:11"),
("47","4756195e1e3c","56","66","3","0","0","0","0","","OGECHUKWU","","NZEREM","S/19/0016","$2y$10$7tMl8P/fa4oR2krlT2WP9.Tg4TH9KA6qC6N4D8C5uATyv/aPnmOji","emogechukwu","emogechukwu","","2008-11-28","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/5ffb2c.jpg","PARENT","","","","0","1592308716","0","0","","0","","check_result","activated","2019-10-07 12:45:26"),
("48","4856abc59a50","56","80","3","0","0","0","0","","ODINAKA","CHIBUEZE","OGBONNA","S/19/0017","$2y$10$bYwetXNCtN5/SE997mUVX.8phhM/Kdd.DfAqSNXzd5OZI38rYp/OO","naodinaka","naodinaka","","2009-01-01","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/7d0f1a.jpg","PARENT","","","","0","1631781991","0","0","","0","","check_result","activated","2019-10-07 12:47:34"),
("49","495652623383","56","106","3","0","0","0","0","","KRISTABEL","EBERECHI","ONYEOGAZIRI","S/19/0018","$2y$10$MQSgsZbHPIbxLy/Fc7L.8eaPnveimnHRS2lLrohniubMEuwBJudLm","zeonglobal","zeonglobal","","2009-04-24","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/3627ab.jpg","PARENT","","","","0","1589976242","0","0","","0","","check_result","activated","2019-10-07 12:51:55"),
("50","505648278c08","56","113","3","0","0","0","0","","CHIOMA","FAVOUR","OKOYE","S/19/0019","$2y$10$SOuY5SUfmNqV44rmwFfdke7v82eW1VoF2ybw4QzYemDKu8a.ilR.y","yechioma","yechioma","","2009-03-20","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/d60a64.jpg","PARENT","","","","0","0","0","0","","0","","check_result","activated","2020-02-05 21:16:37"),
("51","515623c92678","56","97","4","0","0","0","0","","BLOSSOM","","DICK","S/19/0020","$2y$10$amGZNThSQtfFgK8SIsSdUeZ1b4ws4narusv7leAez/TPyTFlTV192","ckblossom","ckblossom","","2008-06-01","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/f69bfa.jpg","PARENT","","","","0","0","0","0","","0","","check_result","activated","2020-02-05 21:18:15"),
("52","52569ab9783a","56","51","2","0","0","0","0","","ASAHEL","","BENJAMIN","S/20/0001","$2y$10$fHRxet8m8IEKRU9yxH8GauNgbgxRn8r9DO7hRPtul1LzlUasxsFWi","diasahel","diasahel","","2010-09-15","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/501a98.jpg","PARENT","","new_student","","0","1624622579","0","0","","0","","check_result","activated","2021-01-21 15:59:29"),
("53","535686ea0274","56","127","2","0","0","0","0","","DIVINE","","ABEL","S/20/0002","$2y$10$EnJ8jZJp1twscMUaxMNwyuRZfyxGEiw9hBc3FsR8piaC5.C40AD8S","eldivine","eldivine","","2011-05-21","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/0f198d.jpg","","","new_student","","0","1624973103","0","0","","0","","check_result","activated","2021-01-21 16:00:19"),
("54","545696f6a28f","56","100","2","0","0","0","0","","EDISON","CHARLES","AUGUSTINE","S/20/0003","$2y$10$SKQgK/14HCIucXKWYWxJNuuTRXkeNgtA83YNG4BpUzNxrsmLwfdhy","needison","needison","","2010-03-15","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/af1762.jpg","PARENT","","new_student","","12","1642148597","0","0","","0","","check_result","activated","2021-01-21 16:04:08"),
("55","55567f7c3da0","56","115","2","0","0","0","0","","JOY","","ADEDOKUN","S/20/0004","$2y$10$oAVLoaIJQ7QnFbWbak8m3uTumgVMw6NxvpkiCiusXcRzQnXDO0mry","zeonglobal","zeonglobal","","2010-03-19","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/ce2e40.jpg","PARENT","","new_student","","0","1631729633","0","0","","0","","check_result","activated","2021-01-21 16:21:28"),
("56","56568e4834b9","56","55","2","0","0","0","0","","NMESOMA","","CHIKODI","S/20/0005","$2y$10$c5jH4p6JRoj.8regkTYd7.Tp.Dc6K2S9paroBKMYkwWD6kzwxcnT6","dinmesoma","dinmesoma","","2010-06-12","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/2bf286.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-01-21 16:51:33"),
("57","5756b7868197","56","29","2","0","0","0","0","","SUCCESS","","DICKSON","S/20/0006","$2y$10$6.WMRr.CU9hSUsm99IQL7.ZjRPUoeMbavQbJKgqpgR7oAaJywN39S","onsuccess","onsuccess","","2010-06-12","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/9033a1.jpg","PARENT","","new_student","","1","1636051013","0","0","","0","","check_result","activated","2021-01-21 18:07:07"),
("58","5856cd7eb0ab","56","118","2","0","0","0","0","","DELIGHT","","DUGBOR","S/20/0007","$2y$10$JnQd.ly62OCx4ouSFEzune02tSQxz3r0IW/xa5U.vWvpQdoFqOqpK","zeonglobal","zeonglobal","","2010-08-14","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/e9c5b8.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-01-21 18:10:45"),
("59","5956ed29391e","56","119","2","0","0","0","0","","FAVOUR","","LAWSON","S/20/0008","$2y$10$a7X216kQ/2RoV3MWLhP2F.c0lmsb.MVRhWFjVBMtmHyw7uDzo2hiW","zeonglobal","zeonglobal","","2011-01-17","female","Christianity","","","","","2021/2022","1st Term","","","PARENT","","new_student","","0","1632243796","0","0","","0","","check_result","deactivated","2021-01-21 18:14:25"),
("60","60561fe4060a","56","3","2","0","0","0","0","","CHETACHI","","LIVINUS","S/20/0009","$2y$10$RbD/0hhglMRc6bZ2sZIXq.UIQYTPvdH6YlpXAgy28FhWuTyS6fEzm","uschetachi","uschetachi","","2010-04-25","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/44b079.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-01-21 18:15:48"),
("61","61568b07cfe6","56","110","2","0","0","0","0","","DEBORAH","","CHUKWUKA","S/20/0010","$2y$10$Lh35/kHz3gutK9DVTqlfYOCjf/C.OgcH36d/KZE1c/lSqoG4ki0T6","kadeborah","kadeborah","","2010-06-06","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/ddd9f6.jpg","","","new_student","","0","1641928193","0","0","","0","","check_result","activated","2021-01-21 18:16:32"),
("62","62561a01b6cb","56","120","1","0","0","0","0","","JANENT","","LEMEBRI","S/20/0011","$2y$10$Hb6OQ7FG9VfcHYodTZppIOg2bI.9eunLeJz3M.1/SR8lZrVV7JGuG","zeonglobal","zeonglobal","","2010-02-03","female","Christianity","","","","","2020/2021","1st Term","","","","","new_student","","0","0","0","0","","0","","check_result","deactivated","2021-01-21 18:27:26"),
("63","63562113dd81","56","121","2","0","0","0","0","","MICHAEL","","OGU-LOIS","S/20/0012","$2y$10$CKheFxMkPDbXGsAkiZKvGeXelnmd92te0BzI2NPGZl55hexo6FS2O","zeonglobal","zeonglobal","","2009-07-16","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/a7e861.jpg","PARENT","","new_student","","0","1624616190","0","0","","0","","check_result","activated","2021-01-21 18:29:46"),
("64","6456e73c926b","56","17","2","0","0","0","0","","EMMANUEL","","ONUOHA","S/20/0013","$2y$10$6Gk2IOeNtkuLnvoCqfqeqe.45cTxgfmDe1SqXZlfQz9i0ptZASe/W","haemmanuel","haemmanuel","","2009-12-16","male","Christianity","","","","","","","","","PARENT","","new_student","","0","1641972943","0","0","","0","","check_result","activated","2021-01-21 18:33:42"),
("65","6556c69b35c1","56","122","2","0","0","0","0","","FAITH","","OLOGUN","S/20/0014","$2y$10$En8zjqZwJs7lGdYA/DLSGuIYLHNh5MCkl3sPeBtd/7XuNhMS26FG2","zeonglobal","zeonglobal","","2009-11-20","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/460010.jpg","","","new_student","","0","1624616389","0","0","","0","","check_result","activated","2021-01-21 18:35:34"),
("66","6656fc85c904","56","5","2","0","0","0","0","","VICTORIA","","SOLOMON","S/20/0015","$2y$10$PhMTm0nHY0r9imu6ZGXadOSwQf7MNNyvjiRzijtRc4oVvVATsKqya","onvictoria","onvictoria","","2010-04-30","female","Christianity","","","","","","","","","PARENT","","new_student","","0","1624616799","0","0","","0","","check_result","activated","2021-01-21 18:36:48"),
("67","6756297fac77","56","56","2","0","0","0","0","","DANIELLA","","UGWUNEKE","S/20/0016","$2y$10$XzjgihUSvbvLRJ/HrUnABuqbYlG1mAbXPTAm7h16H84n4K8BKZ4V.","kedaniella","kedaniella","","2010-07-20","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/d4089d.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-01-21 18:38:17"),
("68","68569ff5b515","56","123","2","0","0","0","0","","IVAN","LUCA","SALINETI","S/20/0017","$2y$10$TMQ0WzrS39hlYFkW.nZnUeLDtzLQTmtfW8k8gpQAfh3CVyNr.We2y","zeonglobal","zeonglobal","","2009-01-06","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/4ac294.jpg","PARENT","","new_student","","0","1629111293","0","0","","0","","check_result","activated","2021-01-21 18:41:54"),
("69","6956e4598723","56","124","4","0","0","0","0","","DOMINION","","OGBONNA","S/20/0018","$2y$10$DKhcdv3jfNJthzVwTJDC3ul0myet1whktQjuM.80tjafm107OUSBW","zeonglobal","zeonglobal","","2007-08-14","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/24a4c7.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-01-21 18:55:18"),
("70","7056460654c4","56","125","4","0","0","0","0","","DIVINEGRACE","OSARONWOKE","OKPORI","S/20/0019","$2y$10$zBk9j8rWvgUtDE1MOjja5OFS7pglM19NY0z6dOCi3nas7XA2zgbJ.","zeonglobal","zeonglobal","","2009-08-28","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/0ac3ff.jpg","PARENT","","new_student","","0","1619094096","0","0","","0","","check_result","activated","2021-01-21 18:58:32"),
("71","715649a96c07","56","117","4","0","0","0","0","","VICTORY","","UWEM","S/20/0020","$2y$10$SFdpi9hkxCLbNNClBynYj.OA92XYkF9p4oK0s0s.yGM0JkApgrscu","emvictory","emvictory","","2008-06-06","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/2b188b.jpg","PARENT","","new_student","","0","1631370959","0","0","","0","","check_result","activated","2021-01-21 19:01:19"),
("72","72569a99ca4b","56","103","5","0","0","0","0","","AUGUSTA","","CHINELE","S/20/0021","$2y$10$lAN4RmTwCWvhJNQFLUOR2uNTuAxCRg6jdHuJ/KC8RVKqZK/f0pFhK","leaugusta","leaugusta","","2004-08-30","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/735811.jpg","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-01-21 19:08:19"),
("73","73565b0efc5d","56","124","0","0","0","0","0","","MUNACHIMSO","","OGBONNA","S/20/0022","$2y$10$QVb6Tl9tWFxrn6B8mZtXLOAtlpZZDYQ2OU5lDes/e2hOua6X6TMIe","namunachimso","namunachimso","","2005-09-11","female","Christianity","","","2020/2021","3rd Term","","","","","","","new_student","","0","0","0","0","","0","","check_result","graduated","2021-01-21 19:14:21"),
("74","7456935581e8","56","95","2","0","0","0","0","","OKORO","","UZOMA","S/20/0023","$2y$10$qiTkhIO9qDcTzv5qeHsQsuVJuEq.PgD0aCcnt2eOzBzdXzJ5hngrq","maokoro","maokoro","","2010-09-10","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/9ae35b.jpg","PARENT","","new_student","","0","1642610493","0","0","","0","","check_result","activated","2021-02-25 13:23:41"),
("75","7556d719c3ca","56","126","2","0","0","0","0","","BARIEEBA","DANIEL","SAMPSON-WIKINA","S/20/0024","$2y$10$O8Fok7sJ0n.9wfA1RFOPEuLwfIB4Yg.A0ZPc7FvUTfhQwnP8rhGkm","zeonglobal","zeonglobal","godwinwikina@gmail.com","2010-07-06","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/ee7720.jpg","PARENT","","new_student","","0","1640170233","0","0","","0","","check_result","activated","2021-05-04 13:14:41"),
("76","7656465cbd65","56","142","2","0","0","0","0","","GLADYS","","OKANJE-FRIDAY","S/20/0025","$2y$10$WoR1EZ4VqpxzOBZGNNvfX.FH3FFZ0W/VilzPR0EXis4l7DDuWoiCK","aygladys","aygladys","","2021-05-05","female","Christianity","","","","","","","","","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-05-25 07:35:55"),
("77","7756e481ebae","56","142","3","0","0","0","0","","SARAH","","OKANJE-FRIDAY","S/20/0026","$2y$10$y/JX.FaPvgbYeU8ejYs3mOau8MMffZ2GNw0qrjgDce.60pGCpTTUu","aysarah","aysarah","","2021-05-05","female","Christianity","","","","","","","","","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-05-25 07:36:38"),
("78","785675c59af4","56","142","4","0","0","0","0","","BLESSING","","OKANJE-FRIDAY","S/20/0027","$2y$10$99vX8aFvwY77M6yUs4DhIuwK4ANAVE0mLdEVvIWaHVK9pqzrhyYvK","ayblessing","ayblessing","","2021-05-06","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/8e59f8.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-05-25 07:37:18"),
("79","795663112c86","56","0","2","0","0","0","0","","WIKINA","","DANIEL","S/20/0028","$2y$10$BB/g7lqpFsudmaj92RGmUeHpwyl247RpVNt5aoSTebYyMHGieBpRK","elwikina","elwikina","","2021-05-07","male","Christianity","","","","","2021/2022","1st Term","","","","","new_student","","0","0","0","0","","0","","check_result","deactivated","2021-05-31 22:07:48"),
("80","8056ff0255df","56","0","1","0","0","0","0","","FORTUNE","PETER","AKPAN","S/21/0001","$2y$10$LfktkVbL91LZmdIeNrMlBeziU6ZATVVH9rPs2YAWZH4gY/2PAAT1a","anfortune","anfortune","","2010-12-14","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/abf03f.jpg","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 20:17:38"),
("81","815664cd4189","56","151","1","0","0","0","0","","OLUWAFERANMI","","ADEWUMI","S/21/0002","$2y$10$L.1MxGZM.9bz2Z6Doexa7u18rsySOg51I7JSdqHUa86HkCMPgFy9u","zeonglobal","zeonglobal","","2012-10-23","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/49e2f7.jpg","PARENT","","new_student","","0","1640326784","0","0","","0","","check_result","activated","2021-10-21 20:23:32"),
("82","8256b96b9290","56","76","1","0","0","0","0","","ZION","INIOLUWA","BABALOLA","S/21/0003","$2y$10$jEcGTGbIMUQPMc533lI6ze4zChL/890kCYLUGfMtMRdBro.SY6/8y","lazion","lazion","","2010-10-23","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/211ec5.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 20:27:16"),
("83","8356ae53faed","56","49","1","0","0","0","0","","PREVAIL","","CHIBUEZE-OGBONNA","S/21/0004","$2y$10$0LEojqZgmDMm7EGSl3zTWeLt00t8fcwTUmm0bzicqPcfM1ZrLI7ZC","naprevail","naprevail","","2011-05-18","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/554a1b.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 20:30:11"),
("84","84560809f7fc","56","77","1","0","0","0","0","","KAMSI","MICHAEL","CHIBUEZE","S/21/0005","$2y$10$AESK4DBTLmmSVbyQbx7K7.hQdKHaj5cUvMoDWrGRyRDpOr.UOyCMq","zekamsi","zekamsi","","2012-05-30","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/d8411f.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 20:37:53"),
("85","855653d0dcf5","56","29","1","0","0","0","0","","NTEIMAM","KAIRO","DICKSON","S/21/0006","$2y$10$a57inVFCkzL1IiR42sj1XeL/hA18QGtQ.LH/38mToxdiPMeeArfIK","onnteimam","onnteimam","","2012-06-21","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/dbda0d.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 20:39:15"),
("86","8656a5322e2c","56","146","1","0","0","0","0","","TAMUNO-OPUBO","PROMINENCE","JUMBO","S/21/0007","$2y$10$TrDyeqH2.optCHMKNo7.wuUIWO9DkA6g0nWu8tc.tVGg.zWgS4Wii","botamuno-opubo","botamuno-opubo","","2011-06-21","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/2f5c4f.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 20:41:27"),
("87","8756976c60f7","56","152","1","0","0","0","0","","TAMUNONIMI","TONYE","JUMBO","S/21/0008","$2y$10$TN8arJM/cFkeRNFP8YBCSuKTaI79crMXz09J3UrAa44aDkp.P6p5S","zeonglobal","zeonglobal","","2011-04-19","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/adba00.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 21:28:50"),
("88","885669999fa3","56","113","1","0","0","0","0","","AKACHUKWU","DAVID","OKOYE","S/21/0009","$2y$10$yDWZ2mvi.81s3s6nUFRH4OWmJWM4WGVdY7IvIbPzxXPq3AN7EbP4e","yeakachukwu","yeakachukwu","","2010-12-16","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/ecb7b3.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 21:30:06"),
("89","89561d45c9c2","56","13","1","0","0","0","0","","GABRIEL","CHIKEZIE","ONUM","S/21/0010","$2y$10$CAvZL/LVx95OUnpGgjbYMO6AgRvjmkgoZfxCZ5BBW5xMwKhh8e2Tu","umgabriel","umgabriel","","2012-03-08","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/4dfa0a.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 21:31:22"),
("90","9056c55a6588","56","58","1","0","0","0","0","","BARISILEE","ANGEL","BIENE","S/21/0011","$2y$10$10QxJ6yC.ZJK7n7eu06qhOdDcNQHfb/8qGMQFW8zJQxAjwrsZsJka","nebarisilee","nebarisilee","","2011-10-25","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/8e242c.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 21:32:48"),
("91","91564a4dd78b","56","149","1","0","0","0","0","","UDOTONG","ABIGAIL","DICKSON","S/21/0012","$2y$10$piKixSALzCQUY88m9cVEPuwzQ3101WthNRoKfz7kLeklDdRyp8Jfu","onudotong","onudotong","","2012-10-13","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/36a094.jpg","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 21:34:48"),
("92","92566be41dda","56","39","1","0","0","0","0","","IDONGESIT","","EMMANSON","S/21/0013","$2y$10$K2DHpvN3IqqAKOYaQsWAcuDUcPFsdgOmhUi6ww3CuCUdffQUbd6Gm","onidongesit","onidongesit","","2011-07-16","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/73cd92.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 21:36:41"),
("93","9356a4d9c148","56","146","1","0","0","0","0","","LOLIA","BRILLIANCE","JUMBO","S/21/0014","$2y$10$8migTr1Hjsvs/6c20Iv3aeVdOfMDQm.Z7b4Brlu3sSMb69J5brvJa","bololia","bololia","","2011-07-16","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/895702.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 21:38:29"),
("94","94566ce65b80","56","116","1","0","0","0","0","","EMMANUELLA","EDIDION","MFONISO","S/21/0015","$2y$10$VyNIWPWjYeutx0WZ8hO/1ey7uArglEx/IfN4Ze5t0NA9Fu8cYylPi","soemmanuella","soemmanuella","","2011-08-10","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/6e2ef6.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 21:40:15"),
("95","9556e6e965d6","56","56","1","0","0","0","0","","DIAMOND","MUNACHIMSO","UGWUNEKE","S/21/0016","$2y$10$mnnk.zTNwHDYR/ZT4kLDKOMz/gxzMW5nH3oiruMsAm4HWboaDk922","kediamond","kediamond","","2012-04-17","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/63c772.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 21:48:23"),
("96","9656a00b3603","56","153","1","0","0","0","0","","FLOURISH","HACHIBENUM","CHIBEOSO","S/21/0017","$2y$10$QJofy4fuRtJ1Psw6HXlauuasx7rLKPXW8QLRpnOhwTWNkBqEfLGGa","zeonglobal","zeonglobal","wodichibeoso@gmail.com","2011-05-02","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/10f844.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 21:54:06"),
("97","97568bf20b73","56","154","1","0","0","0","0","","AALIYAH","BOLUWATIFE","ISIAKA","S/21/0018","$2y$10$PkLsGoEscgmMPlvRFFbEaO8HMpOCbriOxJscKfEmgAncKYVg/YhO6","zeonglobal","zeonglobal","","2012-09-25","female","Islam","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/7addf5.jpg","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 22:03:59"),
("98","9856ad2d6e0d","56","155","2","0","0","0","0","","SHARON","","NWABUEZE","S/21/0019","$2y$10$Sz6Nz/O8X3on9W3aly/1vO0a6mCylIYONUSmhcL7kLYtmfqUK2pIm","zeonglobal","zeonglobal","","2010-06-09","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/6f3310.jpg","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 22:06:24"),
("99","99565a7be18f","56","156","3","0","0","0","0","","SARAH","TOMBARI","SUNNY-MENE","S/21/0020","$2y$10$Hg2m./h0i49lZPT.w7ez1udW2NPOQ0NYiyttelqwClLbJkpl.4J3W","zeonglobal","zeonglobal","","2009-05-25","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/4955fd.jpg","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-21 22:09:39"),
("100","10056e7aa27be","56","157","6","0","0","0","0","","INIMFON-ABASI","","DAVID","S/21/0021","$2y$10$H6KIPxxvduClgu9fYK00/.Fd9m.i/4bZbSj7uQBavfr/FkwKGELEy","zeonglobal","zeonglobal","","2021-10-01","female","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-10-28 10:30:12"),
("101","101567637b032","56","132","1","0","0","0","0","","FAITH","","AMAKOR","S/21/0022","$2y$10$BmlAEuq1YDJbgCqB3cqvCuwxw/SECjO86O2Yj3Cl9a3gzwJEq1Sgy","orfaith","orfaith","","2008-08-03","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/24c9ec.jpg","PARENT","new_student","new_student","","0","0","0","0","","0","","check_result","activated","2022-02-20 15:23:17");
INSERT INTO students VALUES
("102","1025628fcc2fd","56","62","1","0","0","0","0","","EMMANUEL","","OCHINDO","S/21/0023","$2y$10$l9te8TRb3hrS0YD12YanSOCpgxSjLNtaNR5zlf/FyCkIJQD1ZRsZC","doemmanuel","doemmanuel","","2011-10-28","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/895f36.jpg","PARENT","new_student","new_student","","0","0","0","0","","0","","check_result","activated","2022-02-20 15:25:38"),
("103","1035682afeb59","56","0","3","0","0","0","0","","FAISAL","","SAFIYA","S/21/0024","$2y$10$0rhDNBrjOspqiWPAyao2iuhr5Tzqc2ot61twMDQda.OUZp0kebfs.","yafaisal","yafaisal","","2007-01-12","female","Islam","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/4795c7.jpg","","new_student","new_student","","0","0","0","0","","0","","check_result","activated","2022-02-24 09:20:09"),
("104","1045658b94d2b","56","0","5","0","0","0","0","","COMFORT","","DAVID","S/21/0025","$2y$10$c6l.ffkRsSrSCV72XEHsAuw8g9NbrJ.YOTHWUQONld5Qq4KL5sKiS","idcomfort","idcomfort","","2022-02-01","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/c5d7ae.jpg","","new_student","new_student","","0","0","0","0","","0","","check_result","activated","2022-02-26 19:18:49"),
("105","105568e5224e3","56","0","4","0","0","0","0","","ESTHER","OLUEBUBE","OBIAKOR","S/21/0026","$2y$10$X8a1ozXfMGQF/Vps5wSNk.DEDj7d8wWNaC4qB8EF7CqVPCYRW7jE2","oresther","oresther","","2022-02-01","female","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/d1ef78.jpg","","new_student","new_student","","0","0","0","0","","0","","check_result","activated","2022-02-26 19:23:06"),
("106","10656cca18c15","56","0","2","0","0","0","0","","ONUOHA","","NNADOZIE","S/21/0027","$2y$10$wYKtq.YhsElIgTG.7mNur.8MhpiYhiL/HiidkXx98nPCTr0EkM.le","ieonuoha","ieonuoha","","2022-02-01","male","Christianity","","","","","","","","/home/zeonglob/public_html/firm//private/images/student_passport/a989a3.jpg","","new_student","new_student","","0","0","0","0","","0","","check_result","activated","2022-02-26 19:33:56");




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


INSERT INTO subclass VALUES
("1","A"),
("2","EMPTY");




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=115 DEFAULT CHARSET=latin1;


INSERT INTO subject_class VALUES
("1","1","1"),
("2","10","1"),
("3","11","1"),
("4","12","1"),
("5","13","1"),
("6","14","1"),
("7","15","1"),
("8","2","1"),
("9","3","1"),
("10","4","1"),
("11","5","1"),
("12","6","1"),
("13","7","1"),
("14","8","1"),
("15","9","1"),
("16","1","2"),
("17","10","2"),
("18","11","2"),
("19","12","2"),
("20","13","2"),
("21","14","2"),
("22","15","2"),
("23","2","2"),
("24","3","2"),
("25","4","2"),
("26","5","2"),
("27","6","2"),
("28","7","2"),
("29","8","2"),
("30","9","2"),
("31","1","3"),
("32","10","3"),
("33","11","3"),
("34","12","3"),
("35","13","3"),
("36","14","3"),
("37","15","3"),
("38","2","3"),
("39","3","3"),
("40","4","3"),
("41","5","3"),
("42","6","3"),
("43","7","3"),
("44","8","3"),
("45","9","3"),
("46","1","4"),
("47","11","4"),
("48","16","4"),
("49","17","4"),
("50","18","4"),
("51","19","4"),
("52","2","4"),
("53","20","4"),
("54","21","4"),
("55","22","4"),
("56","23","4"),
("57","24","4"),
("58","3","4"),
("59","4","4"),
("61","9","4"),
("62","1","5"),
("63","11","5"),
("64","16","5"),
("65","17","5"),
("66","18","5"),
("67","19","5"),
("68","2","5"),
("69","20","5"),
("70","21","5"),
("72","23","5"),
("74","3","5"),
("75","4","5"),
("78","1","6"),
("79","11","6"),
("80","16","6"),
("81","17","6"),
("82","18","6"),
("84","2","6"),
("85","20","6"),
("88","23","6"),
("91","4","6"),
("97","27","5"),
("101","27","4"),
("102","27","6"),
("103","22","5"),
("106","3","6"),
("107","21","6"),
("110","28","4"),
("111","28","5"),
("112","28","6"),
("113","25","4");




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=29 DEFAULT CHARSET=latin1;


INSERT INTO subjects VALUES
("1","MATHEMATICS ","MATHS","both"),
("2","ENGLISH LANGUAGE ","ENG","both"),
("3","CHRISTIAN RELIGIOUS KNOWLEDGE ","C.R.K","both"),
("4","CIVIC EDUCATION ","CIVIC","both"),
("5","FRENCH ","FRE","junior"),
("6","BUSINESS STUDIES ","BUS. STD","junior"),
("7","BASIC TECHNOLOGY ","BAS. TECH","junior"),
("8","BASIC SCIENCE ","BAS SCI ","junior"),
("9","AGRICULTURAL SCIENCE ","AGRIC","both"),
("10","PHYSICAL & HEALTH EDUCATION ","PHE","junior"),
("11","COMPUTER SCIENCE ","COMP","both"),
("12","SOCIAL STUDIES","SOC STD","junior"),
("13","HOME ECONOMICS ","HOME ECO","junior"),
("14","CREATIVE ART","C.ART","junior"),
("15","MUSIC","MUSIC ","junior"),
("16","PHYSICS ","PHY","senior"),
("17","CHEMISTRY ","CHEM","senior"),
("18","BIOLOGY ","BIO","senior"),
("19","GEOGRAPHY","GEO ","senior"),
("20","ECONOMICS","ECO ","senior"),
("21","GOVERNMENT ","GOV","senior"),
("22","COMMERCE ","COMM.","senior"),
("23","MARKETING","MARK.","senior"),
("24","ACCOUNT ","ACCT","senior"),
("25","FURTHER MATHEMATICS ","F.MATHS","senior"),
("27","LITERATURE-IN-ENGLISH","LIT ENG","both"),
("28","DATA PROCESSING ","DATA PRO","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 AUTO_INCREMENT=425 DEFAULT CHARSET=latin1;


INSERT INTO test VALUES
("1","1","1","1","0","15","JSS 1","","MUSIC","9","submit","2018/2019","2nd Term"),
("2","1","2","1","0","15","JSS 1","","MUSIC","9","submit","2018/2019","2nd Term"),
("3","1","3","1","0","15","JSS 1","","MUSIC","5","submit","2018/2019","2nd Term"),
("4","1","4","1","0","15","JSS 1","","MUSIC","6","submit","2018/2019","2nd Term"),
("5","1","5","1","0","15","JSS 1","","MUSIC","6","submit","2018/2019","2nd Term"),
("6","1","6","1","0","15","JSS 1","","MUSIC","4","submit","2018/2019","2nd Term"),
("7","1","7","1","0","15","JSS 1","","MUSIC","5","submit","2018/2019","2nd Term"),
("8","2","26","2","0","15","JSS 2","","MUSIC","7","submit","2018/2019","2nd Term"),
("9","2","28","2","0","15","JSS 2","","MUSIC","5","submit","2018/2019","2nd Term"),
("10","2","29","2","0","15","JSS 2","","MUSIC","8","submit","2018/2019","2nd Term"),
("11","3","8","3","0","15","JSS 3","","MUSIC","10","submit","2018/2019","2nd Term"),
("12","3","9","3","0","15","JSS 3","","MUSIC","10","submit","2018/2019","2nd Term"),
("13","3","10","3","0","15","JSS 3","","MUSIC","9","submit","2018/2019","2nd Term"),
("14","3","11","3","0","15","JSS 3","","MUSIC","8","submit","2018/2019","2nd Term"),
("15","3","12","3","0","15","JSS 3","","MUSIC","7","submit","2018/2019","2nd Term"),
("16","3","13","3","0","15","JSS 3","","MUSIC","9","submit","2018/2019","2nd Term"),
("17","3","14","3","0","15","JSS 3","","MUSIC","8","submit","2018/2019","2nd Term"),
("18","4","1","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("19","4","2","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("20","4","3","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("21","4","4","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("22","4","5","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("23","4","6","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("24","4","7","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("25","5","8","3","0","13","JSS 3","","HOME ECONOMICS","10","submit","2018/2019","2nd Term"),
("26","5","9","3","0","13","JSS 3","","HOME ECONOMICS","10","submit","2018/2019","2nd Term"),
("27","5","10","3","0","13","JSS 3","","HOME ECONOMICS","10","submit","2018/2019","2nd Term"),
("28","5","11","3","0","13","JSS 3","","HOME ECONOMICS","10","submit","2018/2019","2nd Term"),
("29","5","12","3","0","13","JSS 3","","HOME ECONOMICS","10","submit","2018/2019","2nd Term"),
("30","5","13","3","0","13","JSS 3","","HOME ECONOMICS","10","submit","2018/2019","2nd Term"),
("31","5","14","3","0","13","JSS 3","","HOME ECONOMICS","10","submit","2018/2019","2nd Term"),
("32","6","1","1","0","15","JSS 1","","MUSIC","44","submit","2018/2019","2nd Term"),
("33","6","2","1","0","15","JSS 1","","MUSIC","35","submit","2018/2019","2nd Term"),
("34","6","3","1","0","15","JSS 1","","MUSIC","38","submit","2018/2019","2nd Term"),
("35","6","4","1","0","15","JSS 1","","MUSIC","38","submit","2018/2019","2nd Term"),
("36","6","5","1","0","15","JSS 1","","MUSIC","37","submit","2018/2019","2nd Term"),
("37","6","6","1","0","15","JSS 1","","MUSIC","27","submit","2018/2019","2nd Term"),
("38","6","7","1","0","15","JSS 1","","MUSIC","31","submit","2018/2019","2nd Term"),
("39","7","26","2","0","15","JSS 2","","MUSIC","42","submit","2018/2019","2nd Term"),
("40","7","28","2","0","15","JSS 2","","MUSIC","36","submit","2018/2019","2nd Term"),
("41","7","29","2","0","15","JSS 2","","MUSIC","42","submit","2018/2019","2nd Term"),
("42","8","8","3","0","15","JSS 3","","MUSIC","55","submit","2018/2019","2nd Term"),
("43","8","9","3","0","15","JSS 3","","MUSIC","51","submit","2018/2019","2nd Term"),
("44","8","10","3","0","15","JSS 3","","MUSIC","44","submit","2018/2019","2nd Term"),
("45","8","11","3","0","15","JSS 3","","MUSIC","49","submit","2018/2019","2nd Term"),
("46","8","12","3","0","15","JSS 3","","MUSIC","51","submit","2018/2019","2nd Term"),
("47","8","13","3","0","15","JSS 3","","MUSIC","43","submit","2018/2019","2nd Term"),
("48","8","14","3","0","15","JSS 3","","MUSIC","39","submit","2018/2019","2nd Term"),
("49","9","1","1","0","6","JSS 1","","BUSINESS STUDIES","10","submit","2018/2019","2nd Term"),
("50","9","2","1","0","6","JSS 1","","BUSINESS STUDIES","7","submit","2018/2019","2nd Term"),
("51","9","3","1","0","6","JSS 1","","BUSINESS STUDIES","8","submit","2018/2019","2nd Term"),
("52","9","4","1","0","6","JSS 1","","BUSINESS STUDIES","10","submit","2018/2019","2nd Term"),
("53","9","5","1","0","6","JSS 1","","BUSINESS STUDIES","10","submit","2018/2019","2nd Term"),
("54","9","6","1","0","6","JSS 1","","BUSINESS STUDIES","7","submit","2018/2019","2nd Term"),
("55","9","7","1","0","6","JSS 1","","BUSINESS STUDIES","8","submit","2018/2019","2nd Term"),
("56","10","1","1","0","4","JSS 1","","CIVIC EDUCATION","8","submit","2018/2019","2nd Term"),
("57","10","2","1","0","4","JSS 1","","CIVIC EDUCATION","5","submit","2018/2019","2nd Term"),
("58","10","3","1","0","4","JSS 1","","CIVIC EDUCATION","10","submit","2018/2019","2nd Term"),
("59","10","4","1","0","4","JSS 1","","CIVIC EDUCATION","6","submit","2018/2019","2nd Term"),
("60","10","5","1","0","4","JSS 1","","CIVIC EDUCATION","7","submit","2018/2019","2nd Term"),
("61","10","6","1","0","4","JSS 1","","CIVIC EDUCATION","7","submit","2018/2019","2nd Term"),
("62","10","7","1","0","4","JSS 1","","CIVIC EDUCATION","5","submit","2018/2019","2nd Term"),
("63","11","1","1","0","12","JSS 1","","SOCIAL STUDIES","10","submit","2018/2019","2nd Term"),
("64","11","2","1","0","12","JSS 1","","SOCIAL STUDIES","10","submit","2018/2019","2nd Term"),
("65","11","3","1","0","12","JSS 1","","SOCIAL STUDIES","10","submit","2018/2019","2nd Term"),
("66","11","4","1","0","12","JSS 1","","SOCIAL STUDIES","10","submit","2018/2019","2nd Term"),
("67","11","5","1","0","12","JSS 1","","SOCIAL STUDIES","10","submit","2018/2019","2nd Term"),
("68","11","6","1","0","12","JSS 1","","SOCIAL STUDIES","10","submit","2018/2019","2nd Term"),
("69","11","7","1","0","12","JSS 1","","SOCIAL STUDIES","10","submit","2018/2019","2nd Term"),
("70","12","26","2","0","6","JSS 2","","BUSINESS STUDIES","10","submit","2018/2019","2nd Term"),
("71","12","28","2","0","6","JSS 2","","BUSINESS STUDIES","10","submit","2018/2019","2nd Term"),
("72","12","29","2","0","6","JSS 2","","BUSINESS STUDIES","10","submit","2018/2019","2nd Term"),
("73","13","26","2","0","4","JSS 2","","CIVIC EDUCATION","10","submit","2018/2019","2nd Term"),
("74","13","28","2","0","4","JSS 2","","CIVIC EDUCATION","10","submit","2018/2019","2nd Term"),
("75","13","29","2","0","4","JSS 2","","CIVIC EDUCATION","10","submit","2018/2019","2nd Term"),
("76","14","1","1","0","8","JSS 1","","BASIC SCIENCE","10","submit","2018/2019","2nd Term"),
("77","14","2","1","0","8","JSS 1","","BASIC SCIENCE","10","submit","2018/2019","2nd Term"),
("78","14","3","1","0","8","JSS 1","","BASIC SCIENCE","10","submit","2018/2019","2nd Term"),
("79","14","4","1","0","8","JSS 1","","BASIC SCIENCE","10","submit","2018/2019","2nd Term"),
("80","14","5","1","0","8","JSS 1","","BASIC SCIENCE","10","submit","2018/2019","2nd Term"),
("81","14","6","1","0","8","JSS 1","","BASIC SCIENCE","10","submit","2018/2019","2nd Term"),
("82","14","7","1","0","8","JSS 1","","BASIC SCIENCE","10","submit","2018/2019","2nd Term"),
("83","15","26","2","0","12","JSS 2","","SOCIAL STUDIES","10","submit","2018/2019","2nd Term"),
("84","15","28","2","0","12","JSS 2","","SOCIAL STUDIES","10","submit","2018/2019","2nd Term"),
("85","15","29","2","0","12","JSS 2","","SOCIAL STUDIES","10","submit","2018/2019","2nd Term"),
("86","16","8","3","0","6","JSS 3","","BUSINESS STUDIES","10","submit","2018/2019","2nd Term"),
("87","16","9","3","0","6","JSS 3","","BUSINESS STUDIES","10","submit","2018/2019","2nd Term"),
("88","16","10","3","0","6","JSS 3","","BUSINESS STUDIES","10","submit","2018/2019","2nd Term"),
("89","16","11","3","0","6","JSS 3","","BUSINESS STUDIES","10","submit","2018/2019","2nd Term"),
("90","16","12","3","0","6","JSS 3","","BUSINESS STUDIES","10","submit","2018/2019","2nd Term"),
("91","16","13","3","0","6","JSS 3","","BUSINESS STUDIES","10","submit","2018/2019","2nd Term"),
("92","16","14","3","0","6","JSS 3","","BUSINESS STUDIES","10","submit","2018/2019","2nd Term"),
("93","17","8","3","0","4","JSS 3","","CIVIC EDUCATION","10","submit","2018/2019","2nd Term"),
("94","17","9","3","0","4","JSS 3","","CIVIC EDUCATION","9","submit","2018/2019","2nd Term"),
("95","17","10","3","0","4","JSS 3","","CIVIC EDUCATION","10","submit","2018/2019","2nd Term"),
("96","17","11","3","0","4","JSS 3","","CIVIC EDUCATION","10","submit","2018/2019","2nd Term"),
("97","17","12","3","0","4","JSS 3","","CIVIC EDUCATION","10","submit","2018/2019","2nd Term"),
("98","17","13","3","0","4","JSS 3","","CIVIC EDUCATION","7","submit","2018/2019","2nd Term"),
("99","17","14","3","0","4","JSS 3","","CIVIC EDUCATION","9","submit","2018/2019","2nd Term"),
("100","18","8","3","0","12","JSS 3","","SOCIAL STUDIES","10","submit","2018/2019","2nd Term");
INSERT INTO test VALUES
("101","18","9","3","0","12","JSS 3","","SOCIAL STUDIES","10","submit","2018/2019","2nd Term"),
("102","18","10","3","0","12","JSS 3","","SOCIAL STUDIES","6","submit","2018/2019","2nd Term"),
("103","18","11","3","0","12","JSS 3","","SOCIAL STUDIES","10","submit","2018/2019","2nd Term"),
("104","18","12","3","0","12","JSS 3","","SOCIAL STUDIES","9","submit","2018/2019","2nd Term"),
("105","18","13","3","0","12","JSS 3","","SOCIAL STUDIES","7","submit","2018/2019","2nd Term"),
("106","18","14","3","0","12","JSS 3","","SOCIAL STUDIES","7","submit","2018/2019","2nd Term"),
("107","19","15","4","0","4","SSS 1","","CIVIC EDUCATION","8","submit","2018/2019","2nd Term"),
("108","19","16","4","0","4","SSS 1","","CIVIC EDUCATION","8","submit","2018/2019","2nd Term"),
("109","19","17","4","0","4","SSS 1","","CIVIC EDUCATION","8","submit","2018/2019","2nd Term"),
("110","20","15","4","0","21","SSS 1","","GOVERNMENT","5","submit","2018/2019","2nd Term"),
("111","20","16","4","0","21","SSS 1","","GOVERNMENT","5","submit","2018/2019","2nd Term"),
("112","20","17","4","0","21","SSS 1","","GOVERNMENT","5","submit","2018/2019","2nd Term"),
("113","21","18","5","0","4","SSS 2","","CIVIC EDUCATION","5","submit","2018/2019","2nd Term"),
("114","21","19","5","0","4","SSS 2","","CIVIC EDUCATION","10","submit","2018/2019","2nd Term"),
("115","21","20","5","0","4","SSS 2","","CIVIC EDUCATION","10","submit","2018/2019","2nd Term"),
("116","21","21","5","0","4","SSS 2","","CIVIC EDUCATION","8","submit","2018/2019","2nd Term"),
("117","21","22","5","0","4","SSS 2","","CIVIC EDUCATION","10","submit","2018/2019","2nd Term"),
("118","21","23","5","0","4","SSS 2","","CIVIC EDUCATION","8","submit","2018/2019","2nd Term"),
("119","22","19","5","0","21","SSS 2","","GOVERNMENT","8","submit","2018/2019","2nd Term"),
("120","22","20","5","0","21","SSS 2","","GOVERNMENT","8","submit","2018/2019","2nd Term"),
("121","22","22","5","0","21","SSS 2","","GOVERNMENT","8","submit","2018/2019","2nd Term"),
("122","23","1","1","0","7","JSS 1","","BASIC TECHNOLOGY","10","submit","2018/2019","2nd Term"),
("123","23","2","1","0","7","JSS 1","","BASIC TECHNOLOGY","10","submit","2018/2019","2nd Term"),
("124","23","3","1","0","7","JSS 1","","BASIC TECHNOLOGY","10","submit","2018/2019","2nd Term"),
("125","23","4","1","0","7","JSS 1","","BASIC TECHNOLOGY","10","submit","2018/2019","2nd Term"),
("126","23","5","1","0","7","JSS 1","","BASIC TECHNOLOGY","10","submit","2018/2019","2nd Term"),
("127","23","6","1","0","7","JSS 1","","BASIC TECHNOLOGY","9","submit","2018/2019","2nd Term"),
("128","23","7","1","0","7","JSS 1","","BASIC TECHNOLOGY","9","submit","2018/2019","2nd Term"),
("129","24","1","1","0","11","JSS 1","","COMPUTER SCIENCE","10","submit","2018/2019","2nd Term"),
("130","24","2","1","0","11","JSS 1","","COMPUTER SCIENCE","10","submit","2018/2019","2nd Term"),
("131","24","3","1","0","11","JSS 1","","COMPUTER SCIENCE","10","submit","2018/2019","2nd Term"),
("132","24","4","1","0","11","JSS 1","","COMPUTER SCIENCE","10","submit","2018/2019","2nd Term"),
("133","24","5","1","0","11","JSS 1","","COMPUTER SCIENCE","10","submit","2018/2019","2nd Term"),
("134","24","6","1","0","11","JSS 1","","COMPUTER SCIENCE","10","submit","2018/2019","2nd Term"),
("135","24","7","1","0","11","JSS 1","","COMPUTER SCIENCE","10","submit","2018/2019","2nd Term"),
("136","25","26","2","0","7","JSS 2","","BASIC TECHNOLOGY","10","submit","2018/2019","2nd Term"),
("137","25","28","2","0","7","JSS 2","","BASIC TECHNOLOGY","9","submit","2018/2019","2nd Term"),
("138","25","29","2","0","7","JSS 2","","BASIC TECHNOLOGY","9","submit","2018/2019","2nd Term"),
("139","26","26","2","0","11","JSS 2","","COMPUTER SCIENCE","10","submit","2018/2019","2nd Term"),
("140","26","28","2","0","11","JSS 2","","COMPUTER SCIENCE","10","submit","2018/2019","2nd Term"),
("141","26","29","2","0","11","JSS 2","","COMPUTER SCIENCE","10","submit","2018/2019","2nd Term"),
("142","27","8","3","0","7","JSS 3","","BASIC TECHNOLOGY","10","submit","2018/2019","2nd Term"),
("143","27","9","3","0","7","JSS 3","","BASIC TECHNOLOGY","10","submit","2018/2019","2nd Term"),
("144","27","10","3","0","7","JSS 3","","BASIC TECHNOLOGY","10","submit","2018/2019","2nd Term"),
("145","27","11","3","0","7","JSS 3","","BASIC TECHNOLOGY","9","submit","2018/2019","2nd Term"),
("146","27","12","3","0","7","JSS 3","","BASIC TECHNOLOGY","10","submit","2018/2019","2nd Term"),
("147","27","13","3","0","7","JSS 3","","BASIC TECHNOLOGY","8","submit","2018/2019","2nd Term"),
("148","27","14","3","0","7","JSS 3","","BASIC TECHNOLOGY","4","submit","2018/2019","2nd Term"),
("149","28","8","3","0","11","JSS 3","","COMPUTER SCIENCE","10","submit","2018/2019","2nd Term"),
("150","28","9","3","0","11","JSS 3","","COMPUTER SCIENCE","10","submit","2018/2019","2nd Term"),
("151","28","10","3","0","11","JSS 3","","COMPUTER SCIENCE","10","submit","2018/2019","2nd Term"),
("152","28","11","3","0","11","JSS 3","","COMPUTER SCIENCE","10","submit","2018/2019","2nd Term"),
("153","28","12","3","0","11","JSS 3","","COMPUTER SCIENCE","10","submit","2018/2019","2nd Term"),
("154","28","13","3","0","11","JSS 3","","COMPUTER SCIENCE","10","submit","2018/2019","2nd Term"),
("155","28","14","3","0","11","JSS 3","","COMPUTER SCIENCE","5","submit","2018/2019","2nd Term"),
("156","29","15","4","0","11","SSS 1","","COMPUTER SCIENCE","10","submit","2018/2019","2nd Term"),
("157","29","16","4","0","11","SSS 1","","COMPUTER SCIENCE","9","submit","2018/2019","2nd Term"),
("158","29","17","4","0","11","SSS 1","","COMPUTER SCIENCE","9","submit","2018/2019","2nd Term"),
("159","30","21","5","0","11","SSS 2","","COMPUTER SCIENCE","10","submit","2018/2019","2nd Term"),
("160","31","26","2","0","8","JSS 2","","BASIC SCIENCE","9","submit","2018/2019","2nd Term"),
("161","31","28","2","0","8","JSS 2","","BASIC SCIENCE","7","submit","2018/2019","2nd Term"),
("162","31","29","2","0","8","JSS 2","","BASIC SCIENCE","6","submit","2018/2019","2nd Term"),
("163","32","8","3","0","8","JSS 3","","BASIC SCIENCE","9","submit","2018/2019","2nd Term"),
("164","32","9","3","0","8","JSS 3","","BASIC SCIENCE","9","submit","2018/2019","2nd Term"),
("165","32","10","3","0","8","JSS 3","","BASIC SCIENCE","6","submit","2018/2019","2nd Term"),
("166","32","11","3","0","8","JSS 3","","BASIC SCIENCE","8","submit","2018/2019","2nd Term"),
("167","32","12","3","0","8","JSS 3","","BASIC SCIENCE","7","submit","2018/2019","2nd Term"),
("168","32","13","3","0","8","JSS 3","","BASIC SCIENCE","5","submit","2018/2019","2nd Term"),
("169","32","14","3","0","8","JSS 3","","BASIC SCIENCE","8","submit","2018/2019","2nd Term"),
("170","33","15","4","0","18","SSS 1","","BIOLOGY","9","submit","2018/2019","2nd Term"),
("171","33","16","4","0","18","SSS 1","","BIOLOGY","9","submit","2018/2019","2nd Term"),
("172","33","17","4","0","18","SSS 1","","BIOLOGY","9","submit","2018/2019","2nd Term"),
("173","34","15","4","0","17","SSS 1","","CHEMISTRY","9","submit","2018/2019","2nd Term"),
("174","34","16","4","0","17","SSS 1","","CHEMISTRY","9","submit","2018/2019","2nd Term"),
("175","34","17","4","0","17","SSS 1","","CHEMISTRY","9","submit","2018/2019","2nd Term"),
("176","35","18","5","0","18","SSS 2","","BIOLOGY","9","submit","2018/2019","2nd Term"),
("177","35","19","5","0","18","SSS 2","","BIOLOGY","9","submit","2018/2019","2nd Term"),
("178","35","20","5","0","18","SSS 2","","BIOLOGY","8","submit","2018/2019","2nd Term"),
("179","35","21","5","0","18","SSS 2","","BIOLOGY","9","submit","2018/2019","2nd Term"),
("180","35","22","5","0","18","SSS 2","","BIOLOGY","8","submit","2018/2019","2nd Term"),
("181","35","23","5","0","18","SSS 2","","BIOLOGY","8","submit","2018/2019","2nd Term"),
("182","36","18","5","0","17","SSS 2","","CHEMISTRY","8","submit","2018/2019","2nd Term"),
("183","36","21","5","0","17","SSS 2","","CHEMISTRY","8","submit","2018/2019","2nd Term"),
("184","36","23","5","0","17","SSS 2","","CHEMISTRY","8","submit","2018/2019","2nd Term"),
("185","37","15","4","0","2","SSS 1","","ENGLISH LANGUAGE","5","submit","2018/2019","2nd Term"),
("186","37","16","4","0","2","SSS 1","","ENGLISH LANGUAGE","6","submit","2018/2019","2nd Term"),
("187","37","17","4","0","2","SSS 1","","ENGLISH LANGUAGE","7","submit","2018/2019","2nd Term"),
("188","38","18","5","0","2","SSS 2","","ENGLISH LANGUAGE","7","submit","2018/2019","2nd Term"),
("189","38","19","5","0","2","SSS 2","","ENGLISH LANGUAGE","7","submit","2018/2019","2nd Term"),
("190","38","20","5","0","2","SSS 2","","ENGLISH LANGUAGE","6","submit","2018/2019","2nd Term"),
("191","38","21","5","0","2","SSS 2","","ENGLISH LANGUAGE","7","submit","2018/2019","2nd Term"),
("192","38","22","5","0","2","SSS 2","","ENGLISH LANGUAGE","7","submit","2018/2019","2nd Term"),
("193","38","23","5","0","2","SSS 2","","ENGLISH LANGUAGE","6","submit","2018/2019","2nd Term"),
("194","39","1","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("195","39","2","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("196","39","3","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("197","39","4","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("198","39","5","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("199","39","6","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("200","39","7","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term");
INSERT INTO test VALUES
("208","41","26","2","0","9","JSS 2","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("209","41","28","2","0","9","JSS 2","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("210","41","29","2","0","9","JSS 2","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("211","42","26","2","0","13","JSS 2","","HOME ECONOMICS","10","submit","2018/2019","2nd Term"),
("212","42","28","2","0","13","JSS 2","","HOME ECONOMICS","10","submit","2018/2019","2nd Term"),
("213","42","29","2","0","13","JSS 2","","HOME ECONOMICS","10","submit","2018/2019","2nd Term"),
("214","43","1","1","0","13","JSS 1","","HOME ECONOMICS","10","submit","2018/2019","2nd Term"),
("215","43","2","1","0","13","JSS 1","","HOME ECONOMICS","10","submit","2018/2019","2nd Term"),
("216","43","3","1","0","13","JSS 1","","HOME ECONOMICS","10","submit","2018/2019","2nd Term"),
("217","43","4","1","0","13","JSS 1","","HOME ECONOMICS","10","submit","2018/2019","2nd Term"),
("218","43","5","1","0","13","JSS 1","","HOME ECONOMICS","10","submit","2018/2019","2nd Term"),
("219","43","6","1","0","13","JSS 1","","HOME ECONOMICS","10","submit","2018/2019","2nd Term"),
("220","43","7","1","0","13","JSS 1","","HOME ECONOMICS","10","submit","2018/2019","2nd Term"),
("221","44","8","3","0","9","JSS 3","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("222","44","9","3","0","9","JSS 3","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("223","44","10","3","0","9","JSS 3","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("224","44","11","3","0","9","JSS 3","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("225","44","12","3","0","9","JSS 3","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("226","44","13","3","0","9","JSS 3","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("227","44","14","3","0","9","JSS 3","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("228","45","8","3","0","13","JSS 3","","HOME ECONOMICS","","save","2018/2019","2nd Term"),
("229","45","9","3","0","13","JSS 3","","HOME ECONOMICS","","save","2018/2019","2nd Term"),
("230","45","10","3","0","13","JSS 3","","HOME ECONOMICS","","save","2018/2019","2nd Term"),
("231","45","11","3","0","13","JSS 3","","HOME ECONOMICS","","save","2018/2019","2nd Term"),
("232","45","12","3","0","13","JSS 3","","HOME ECONOMICS","","save","2018/2019","2nd Term"),
("233","45","13","3","0","13","JSS 3","","HOME ECONOMICS","","save","2018/2019","2nd Term"),
("234","45","14","3","0","13","JSS 3","","HOME ECONOMICS","","save","2018/2019","2nd Term"),
("235","46","15","4","0","24","SSS 1","","ACCOUNT","10","submit","2018/2019","2nd Term"),
("236","46","16","4","0","24","SSS 1","","ACCOUNT","10","submit","2018/2019","2nd Term"),
("237","46","17","4","0","24","SSS 1","","ACCOUNT","10","submit","2018/2019","2nd Term"),
("238","47","15","4","0","9","SSS 1","","AGRICULTURAL SCIENCE","","save","2018/2019","2nd Term"),
("239","47","16","4","0","9","SSS 1","","AGRICULTURAL SCIENCE","","save","2018/2019","2nd Term"),
("240","47","17","4","0","9","SSS 1","","AGRICULTURAL SCIENCE","","save","2018/2019","2nd Term"),
("241","48","15","4","0","9","SSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("242","48","16","4","0","9","SSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("243","48","17","4","0","9","SSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("244","49","15","4","0","22","SSS 1","","COMMERCE","10","submit","2018/2019","2nd Term"),
("245","49","16","4","0","22","SSS 1","","COMMERCE","10","submit","2018/2019","2nd Term"),
("246","49","17","4","0","22","SSS 1","","COMMERCE","10","submit","2018/2019","2nd Term"),
("247","50","15","4","0","20","SSS 1","","ECONOMICS","10","submit","2018/2019","2nd Term"),
("248","50","16","4","0","20","SSS 1","","ECONOMICS","10","submit","2018/2019","2nd Term"),
("249","50","17","4","0","20","SSS 1","","ECONOMICS","10","submit","2018/2019","2nd Term"),
("250","51","15","4","0","23","SSS 1","","MARKETING","10","submit","2018/2019","2nd Term"),
("251","51","16","4","0","23","SSS 1","","MARKETING","10","submit","2018/2019","2nd Term"),
("252","51","17","4","0","23","SSS 1","","MARKETING","10","submit","2018/2019","2nd Term"),
("253","52","19","5","0","24","SSS 2","","ACCOUNT","10","submit","2018/2019","2nd Term"),
("254","52","20","5","0","24","SSS 2","","ACCOUNT","10","submit","2018/2019","2nd Term"),
("255","52","22","5","0","24","SSS 2","","ACCOUNT","10","submit","2018/2019","2nd Term"),
("256","53","18","5","0","9","SSS 2","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("257","53","19","5","0","9","SSS 2","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("258","53","20","5","0","9","SSS 2","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("259","53","21","5","0","9","SSS 2","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("260","53","22","5","0","9","SSS 2","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("261","53","23","5","0","9","SSS 2","","AGRICULTURAL SCIENCE","10","submit","2018/2019","2nd Term"),
("262","54","18","5","0","20","SSS 2","","ECONOMICS","10","submit","2018/2019","2nd Term"),
("263","54","19","5","0","20","SSS 2","","ECONOMICS","10","submit","2018/2019","2nd Term"),
("264","54","20","5","0","20","SSS 2","","ECONOMICS","10","submit","2018/2019","2nd Term"),
("265","54","21","5","0","20","SSS 2","","ECONOMICS","10","submit","2018/2019","2nd Term"),
("266","54","22","5","0","20","SSS 2","","ECONOMICS","10","submit","2018/2019","2nd Term"),
("267","54","23","5","0","20","SSS 2","","ECONOMICS","10","submit","2018/2019","2nd Term"),
("268","55","1","1","0","3","JSS 1","","CHRISTIAN RELIGIOUS KNOWLEDGE","9","submit","2018/2019","2nd Term"),
("269","55","2","1","0","3","JSS 1","","CHRISTIAN RELIGIOUS KNOWLEDGE","8","submit","2018/2019","2nd Term"),
("270","55","3","1","0","3","JSS 1","","CHRISTIAN RELIGIOUS KNOWLEDGE","9","submit","2018/2019","2nd Term"),
("271","55","4","1","0","3","JSS 1","","CHRISTIAN RELIGIOUS KNOWLEDGE","10","submit","2018/2019","2nd Term"),
("272","55","5","1","0","3","JSS 1","","CHRISTIAN RELIGIOUS KNOWLEDGE","9","submit","2018/2019","2nd Term"),
("273","55","6","1","0","3","JSS 1","","CHRISTIAN RELIGIOUS KNOWLEDGE","7","submit","2018/2019","2nd Term"),
("274","55","7","1","0","3","JSS 1","","CHRISTIAN RELIGIOUS KNOWLEDGE","7","submit","2018/2019","2nd Term"),
("275","56","18","5","0","23","SSS 2","","MARKETING","10","submit","2018/2019","2nd Term"),
("276","56","19","5","0","23","SSS 2","","MARKETING","10","submit","2018/2019","2nd Term"),
("277","56","20","5","0","23","SSS 2","","MARKETING","10","submit","2018/2019","2nd Term"),
("278","56","21","5","0","23","SSS 2","","MARKETING","10","submit","2018/2019","2nd Term"),
("279","56","22","5","0","23","SSS 2","","MARKETING","10","submit","2018/2019","2nd Term"),
("280","56","23","5","0","23","SSS 2","","MARKETING","10","submit","2018/2019","2nd Term"),
("281","57","1","1","0","2","JSS 1","","ENGLISH LANGUAGE","9","submit","2018/2019","2nd Term"),
("282","57","2","1","0","2","JSS 1","","ENGLISH LANGUAGE","8","submit","2018/2019","2nd Term"),
("283","57","3","1","0","2","JSS 1","","ENGLISH LANGUAGE","8","submit","2018/2019","2nd Term"),
("284","57","4","1","0","2","JSS 1","","ENGLISH LANGUAGE","9","submit","2018/2019","2nd Term"),
("285","57","5","1","0","2","JSS 1","","ENGLISH LANGUAGE","9","submit","2018/2019","2nd Term"),
("286","57","6","1","0","2","JSS 1","","ENGLISH LANGUAGE","7","submit","2018/2019","2nd Term"),
("287","57","7","1","0","2","JSS 1","","ENGLISH LANGUAGE","7","submit","2018/2019","2nd Term"),
("288","58","26","2","0","3","JSS 2","","CHRISTIAN RELIGIOUS KNOWLEDGE","9","submit","2018/2019","2nd Term"),
("289","58","28","2","0","3","JSS 2","","CHRISTIAN RELIGIOUS KNOWLEDGE","9","submit","2018/2019","2nd Term"),
("290","58","29","2","0","3","JSS 2","","CHRISTIAN RELIGIOUS KNOWLEDGE","9","submit","2018/2019","2nd Term"),
("291","59","1","1","0","1","JSS 1","","MATHEMATICS","8","submit","2018/2019","2nd Term"),
("292","59","2","1","0","1","JSS 1","","MATHEMATICS","8","submit","2018/2019","2nd Term"),
("293","59","3","1","0","1","JSS 1","","MATHEMATICS","8","submit","2018/2019","2nd Term"),
("294","59","4","1","0","1","JSS 1","","MATHEMATICS","8","submit","2018/2019","2nd Term"),
("295","59","5","1","0","1","JSS 1","","MATHEMATICS","8","submit","2018/2019","2nd Term"),
("296","59","6","1","0","1","JSS 1","","MATHEMATICS","8","submit","2018/2019","2nd Term"),
("297","59","7","1","0","1","JSS 1","","MATHEMATICS","8","submit","2018/2019","2nd Term"),
("298","60","26","2","0","1","JSS 2","","MATHEMATICS","8","submit","2018/2019","2nd Term"),
("299","60","28","2","0","1","JSS 2","","MATHEMATICS","8","submit","2018/2019","2nd Term"),
("300","60","29","2","0","1","JSS 2","","MATHEMATICS","8","submit","2018/2019","2nd Term"),
("301","61","8","3","0","1","JSS 3","","MATHEMATICS","10","submit","2018/2019","2nd Term"),
("302","61","9","3","0","1","JSS 3","","MATHEMATICS","10","submit","2018/2019","2nd Term"),
("303","61","10","3","0","1","JSS 3","","MATHEMATICS","5","submit","2018/2019","2nd Term"),
("304","61","11","3","0","1","JSS 3","","MATHEMATICS","10","submit","2018/2019","2nd Term"),
("305","61","12","3","0","1","JSS 3","","MATHEMATICS","10","submit","2018/2019","2nd Term"),
("306","61","13","3","0","1","JSS 3","","MATHEMATICS","5","submit","2018/2019","2nd Term"),
("307","61","14","3","0","1","JSS 3","","MATHEMATICS","8","submit","2018/2019","2nd Term");
INSERT INTO test VALUES
("308","62","15","4","0","25","SSS 1","","FURTHER MATHEMATICS","8","submit","2018/2019","2nd Term"),
("309","62","16","4","0","25","SSS 1","","FURTHER MATHEMATICS","8","submit","2018/2019","2nd Term"),
("310","62","17","4","0","25","SSS 1","","FURTHER MATHEMATICS","8","submit","2018/2019","2nd Term"),
("311","63","15","4","0","16","SSS 1","","PHYSICS","10","submit","2018/2019","2nd Term"),
("312","63","16","4","0","16","SSS 1","","PHYSICS","10","submit","2018/2019","2nd Term"),
("313","63","17","4","0","16","SSS 1","","PHYSICS","10","submit","2018/2019","2nd Term"),
("314","64","8","3","0","3","JSS 3","","CHRISTIAN RELIGIOUS KNOWLEDGE","9","submit","2018/2019","2nd Term"),
("315","64","9","3","0","3","JSS 3","","CHRISTIAN RELIGIOUS KNOWLEDGE","9","submit","2018/2019","2nd Term"),
("316","64","10","3","0","3","JSS 3","","CHRISTIAN RELIGIOUS KNOWLEDGE","9","submit","2018/2019","2nd Term"),
("317","64","11","3","0","3","JSS 3","","CHRISTIAN RELIGIOUS KNOWLEDGE","9","submit","2018/2019","2nd Term"),
("318","64","12","3","0","3","JSS 3","","CHRISTIAN RELIGIOUS KNOWLEDGE","9","submit","2018/2019","2nd Term"),
("319","64","13","3","0","3","JSS 3","","CHRISTIAN RELIGIOUS KNOWLEDGE","9","submit","2018/2019","2nd Term"),
("320","64","14","3","0","3","JSS 3","","CHRISTIAN RELIGIOUS KNOWLEDGE","8","submit","2018/2019","2nd Term"),
("321","65","26","2","0","2","JSS 2","","ENGLISH LANGUAGE","8","submit","2018/2019","2nd Term"),
("322","65","28","2","0","2","JSS 2","","ENGLISH LANGUAGE","8","submit","2018/2019","2nd Term"),
("323","65","29","2","0","2","JSS 2","","ENGLISH LANGUAGE","9","submit","2018/2019","2nd Term"),
("324","66","8","3","0","2","JSS 3","","ENGLISH LANGUAGE","9","submit","2018/2019","2nd Term"),
("325","66","9","3","0","2","JSS 3","","ENGLISH LANGUAGE","7","submit","2018/2019","2nd Term"),
("326","66","10","3","0","2","JSS 3","","ENGLISH LANGUAGE","9","submit","2018/2019","2nd Term"),
("327","66","11","3","0","2","JSS 3","","ENGLISH LANGUAGE","8","submit","2018/2019","2nd Term"),
("328","66","12","3","0","2","JSS 3","","ENGLISH LANGUAGE","8","submit","2018/2019","2nd Term"),
("329","66","13","3","0","2","JSS 3","","ENGLISH LANGUAGE","8","submit","2018/2019","2nd Term"),
("330","66","14","3","0","2","JSS 3","","ENGLISH LANGUAGE","9","submit","2018/2019","2nd Term"),
("331","67","15","4","0","3","SSS 1","","CHRISTIAN RELIGIOUS KNOWLEDGE","9","submit","2018/2019","2nd Term"),
("332","67","16","4","0","3","SSS 1","","CHRISTIAN RELIGIOUS KNOWLEDGE","9","submit","2018/2019","2nd Term"),
("333","67","17","4","0","3","SSS 1","","CHRISTIAN RELIGIOUS KNOWLEDGE","7","submit","2018/2019","2nd Term"),
("334","68","22","5","0","3","SSS 2","","CHRISTIAN RELIGIOUS KNOWLEDGE","9","submit","2018/2019","2nd Term"),
("335","69","19","5","0","27","SSS 2","","LITERATURE-IN-ENGLISH","9","submit","2018/2019","2nd Term"),
("336","69","20","5","0","27","SSS 2","","LITERATURE-IN-ENGLISH","8","submit","2018/2019","2nd Term"),
("337","69","22","5","0","27","SSS 2","","LITERATURE-IN-ENGLISH","8","submit","2018/2019","2nd Term"),
("338","69","23","5","0","27","SSS 2","","LITERATURE-IN-ENGLISH","9","submit","2018/2019","2nd Term"),
("339","70","15","4","0","1","SSS 1","","MATHEMATICS","10","submit","2018/2019","2nd Term"),
("340","70","16","4","0","1","SSS 1","","MATHEMATICS","10","submit","2018/2019","2nd Term"),
("341","70","17","4","0","1","SSS 1","","MATHEMATICS","8","submit","2018/2019","2nd Term"),
("342","71","18","5","0","1","SSS 2","","MATHEMATICS","10","submit","2018/2019","2nd Term"),
("343","71","19","5","0","1","SSS 2","","MATHEMATICS","7","submit","2018/2019","2nd Term"),
("344","71","20","5","0","1","SSS 2","","MATHEMATICS","5","submit","2018/2019","2nd Term"),
("345","71","21","5","0","1","SSS 2","","MATHEMATICS","7","submit","2018/2019","2nd Term"),
("346","71","22","5","0","1","SSS 2","","MATHEMATICS","5","submit","2018/2019","2nd Term"),
("347","71","23","5","0","1","SSS 2","","MATHEMATICS","6","submit","2018/2019","2nd Term"),
("348","72","18","5","0","16","SSS 2","","PHYSICS","10","submit","2018/2019","2nd Term"),
("349","72","21","5","0","16","SSS 2","","PHYSICS","7","submit","2018/2019","2nd Term"),
("350","72","23","5","0","16","SSS 2","","PHYSICS","10","submit","2018/2019","2nd Term"),
("351","73","1","1","0","15","JSS 1","","MUSIC","","save","2018/2019","3rd Term"),
("352","73","2","1","0","15","JSS 1","","MUSIC","","save","2018/2019","3rd Term"),
("353","73","3","1","0","15","JSS 1","","MUSIC","","save","2018/2019","3rd Term"),
("354","73","4","1","0","15","JSS 1","","MUSIC","","save","2018/2019","3rd Term"),
("355","73","5","1","0","15","JSS 1","","MUSIC","","save","2018/2019","3rd Term"),
("356","73","6","1","0","15","JSS 1","","MUSIC","","save","2018/2019","3rd Term"),
("357","73","7","1","0","15","JSS 1","","MUSIC","","save","2018/2019","3rd Term"),
("358","73","30","1","0","15","JSS 1","","MUSIC","","save","2018/2019","3rd Term"),
("359","74","1","1","0","15","JSS 1","","MUSIC","9","submit","2018/2019","3rd Term"),
("360","74","2","1","0","15","JSS 1","","MUSIC","9","submit","2018/2019","3rd Term"),
("361","74","3","1","0","15","JSS 1","","MUSIC","5","submit","2018/2019","3rd Term"),
("362","74","4","1","0","15","JSS 1","","MUSIC","5","submit","2018/2019","3rd Term"),
("363","74","5","1","0","15","JSS 1","","MUSIC","6","submit","2018/2019","3rd Term"),
("364","74","6","1","0","15","JSS 1","","MUSIC","6","submit","2018/2019","3rd Term"),
("365","74","7","1","0","15","JSS 1","","MUSIC","2","submit","2018/2019","3rd Term"),
("366","74","30","1","0","15","JSS 1","","MUSIC","2","submit","2018/2019","3rd Term"),
("367","75","26","2","0","15","JSS 2","","MUSIC","6","submit","2018/2019","3rd Term"),
("368","75","28","2","0","15","JSS 2","","MUSIC","4","submit","2018/2019","3rd Term"),
("369","75","29","2","0","15","JSS 2","","MUSIC","9","submit","2018/2019","3rd Term"),
("370","76","1","1","0","7","JSS 1","","BASIC TECHNOLOGY","9","submit","2018/2019","3rd Term"),
("371","76","2","1","0","7","JSS 1","","BASIC TECHNOLOGY","2","submit","2018/2019","3rd Term"),
("372","76","3","1","0","7","JSS 1","","BASIC TECHNOLOGY","9","submit","2018/2019","3rd Term"),
("373","76","4","1","0","7","JSS 1","","BASIC TECHNOLOGY","9","submit","2018/2019","3rd Term"),
("374","76","5","1","0","7","JSS 1","","BASIC TECHNOLOGY","8","submit","2018/2019","3rd Term"),
("375","76","6","1","0","7","JSS 1","","BASIC TECHNOLOGY","10","submit","2018/2019","3rd Term"),
("376","76","7","1","0","7","JSS 1","","BASIC TECHNOLOGY","2","submit","2018/2019","3rd Term"),
("377","76","30","1","0","7","JSS 1","","BASIC TECHNOLOGY","5","submit","2018/2019","3rd Term"),
("378","77","1","1","0","11","JSS 1","","COMPUTER SCIENCE","7","submit","2018/2019","3rd Term"),
("379","77","2","1","0","11","JSS 1","","COMPUTER SCIENCE","3","submit","2018/2019","3rd Term"),
("380","77","3","1","0","11","JSS 1","","COMPUTER SCIENCE","4","submit","2018/2019","3rd Term"),
("381","77","4","1","0","11","JSS 1","","COMPUTER SCIENCE","8","submit","2018/2019","3rd Term"),
("382","77","5","1","0","11","JSS 1","","COMPUTER SCIENCE","4","submit","2018/2019","3rd Term"),
("383","77","6","1","0","11","JSS 1","","COMPUTER SCIENCE","5","submit","2018/2019","3rd Term"),
("384","77","7","1","0","11","JSS 1","","COMPUTER SCIENCE","3","submit","2018/2019","3rd Term"),
("385","77","30","1","0","11","JSS 1","","COMPUTER SCIENCE","2","submit","2018/2019","3rd Term"),
("386","78","26","2","0","7","JSS 2","","BASIC TECHNOLOGY","6","submit","2018/2019","3rd Term"),
("387","78","28","2","0","7","JSS 2","","BASIC TECHNOLOGY","6","submit","2018/2019","3rd Term"),
("388","78","29","2","0","7","JSS 2","","BASIC TECHNOLOGY","8","submit","2018/2019","3rd Term"),
("389","79","26","2","0","11","JSS 2","","COMPUTER SCIENCE","2","submit","2018/2019","3rd Term"),
("390","79","28","2","0","11","JSS 2","","COMPUTER SCIENCE","5","submit","2018/2019","3rd Term"),
("391","79","29","2","0","11","JSS 2","","COMPUTER SCIENCE","2","submit","2018/2019","3rd Term"),
("392","80","15","4","0","11","SSS 1","","COMPUTER SCIENCE","5","submit","2018/2019","3rd Term"),
("393","80","16","4","0","11","SSS 1","","COMPUTER SCIENCE","5","submit","2018/2019","3rd Term"),
("394","80","17","4","0","11","SSS 1","","COMPUTER SCIENCE","5","submit","2018/2019","3rd Term"),
("395","81","21","5","0","11","SSS 2","","COMPUTER SCIENCE","5","submit","2018/2019","3rd Term"),
("396","82","1","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","3rd Term"),
("397","82","2","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","3rd Term"),
("398","82","3","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","3rd Term"),
("399","82","4","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","3rd Term"),
("400","82","5","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","3rd Term"),
("401","82","6","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","3rd Term"),
("402","82","7","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","3rd Term"),
("403","82","30","1","0","9","JSS 1","","AGRICULTURAL SCIENCE","10","submit","2018/2019","3rd Term"),
("404","83","1","1","0","15","JSS 1","","MUSIC","","save","2018/2019","3rd Term"),
("405","83","2","1","0","15","JSS 1","","MUSIC","","save","2018/2019","3rd Term"),
("406","83","3","1","0","15","JSS 1","","MUSIC","","save","2018/2019","3rd Term"),
("407","83","4","1","0","15","JSS 1","","MUSIC","","save","2018/2019","3rd Term");
INSERT INTO test VALUES
("408","83","5","1","0","15","JSS 1","","MUSIC","","save","2018/2019","3rd Term"),
("409","83","6","1","0","15","JSS 1","","MUSIC","","save","2018/2019","3rd Term"),
("410","83","7","1","0","15","JSS 1","","MUSIC","","save","2018/2019","3rd Term"),
("411","83","30","1","0","15","JSS 1","","MUSIC","","save","2018/2019","3rd Term"),
("412","84","22","5","0","3","SSS 2","","CHRISTIAN RELIGIOUS KNOWLEDGE","7","submit","2018/2019","3rd Term"),
("413","85","38","1","0","15","JSS 1","","MUSIC","4","save","2019/2020","1st Term"),
("414","85","39","1","0","15","JSS 1","","MUSIC","5","save","2019/2020","1st Term"),
("415","85","40","1","0","15","JSS 1","","MUSIC","5","save","2019/2020","1st Term"),
("416","85","41","1","0","15","JSS 1","","MUSIC","4","save","2019/2020","1st Term"),
("417","85","42","1","0","15","JSS 1","","MUSIC","9","save","2019/2020","1st Term"),
("418","85","43","1","0","15","JSS 1","","MUSIC","6","save","2019/2020","1st Term"),
("419","85","44","1","0","15","JSS 1","","MUSIC","10","save","2019/2020","1st Term"),
("420","85","45","1","0","15","JSS 1","","MUSIC","8","save","2019/2020","1st Term"),
("421","85","46","1","0","15","JSS 1","","MUSIC","8","save","2019/2020","1st Term"),
("422","85","47","1","0","15","JSS 1","","MUSIC","8","save","2019/2020","1st Term"),
("423","85","48","1","0","15","JSS 1","","MUSIC","","save","2019/2020","1st Term"),
("424","85","49","1","0","15","JSS 1","","MUSIC","","save","2019/2020","1st Term");




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 AUTO_INCREMENT=86 DEFAULT CHARSET=latin1;


INSERT INTO test_page VALUES
("1","15","1","0","JSS 1","","MUSIC","CA 2","10","7","submit","2018/2019","2nd Term","2019-03-04 12:56:03"),
("2","15","2","0","JSS 2","","MUSIC","CA 2","10","3","submit","2018/2019","2nd Term","2019-03-04 13:25:04"),
("3","15","3","0","JSS 3","","MUSIC","CA 2","10","7","submit","2018/2019","2nd Term","2019-03-06 09:46:15"),
("4","9","1","0","JSS 1","","AGRICULTURAL SCIENCE","SECOND CA","10","7","submit","2018/2019","2nd Term","2019-03-15 11:51:43"),
("5","13","3","0","JSS 3","","HOME ECONOMICS","SECOND CA","10","7","submit","2018/2019","2nd Term","2019-03-15 11:56:38"),
("6","15","1","0","JSS 1","","MUSIC","EXAMINATION","60","7","submit","2018/2019","2nd Term","2019-03-25 10:32:44"),
("7","15","2","0","JSS 2","","MUSIC","EXAMINATION ","60","3","submit","2018/2019","2nd Term","2019-03-25 10:35:12"),
("8","15","3","0","JSS 3","","MUSIC","EXAMINATION ","60","7","submit","2018/2019","2nd Term","2019-03-25 10:37:59"),
("9","6","1","0","JSS 1","","BUSINESS STUDIES","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-26 12:46:52"),
("10","4","1","0","JSS 1","","CIVIC EDUCATION","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-26 12:53:25"),
("11","12","1","0","JSS 1","","SOCIAL STUDIES","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-26 13:23:42"),
("12","6","2","0","JSS 2","","BUSINESS STUDIES","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-26 13:25:59"),
("13","4","2","0","JSS 2","","CIVIC EDUCATION","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-26 13:30:16"),
("14","8","1","0","JSS 1","","BASIC SCIENCE","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-26 13:34:50"),
("15","12","2","0","JSS 2","","SOCIAL STUDIES","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-26 13:32:24"),
("16","6","3","0","JSS 3","","BUSINESS STUDIES","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-26 13:34:54"),
("17","4","3","0","JSS 3","","CIVIC EDUCATION","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-26 13:37:41"),
("18","12","3","0","JSS 3","","SOCIAL STUDIES","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-26 13:40:23"),
("19","4","4","0","SSS 1","","CIVIC EDUCATION","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-26 13:42:31"),
("20","21","4","0","SSS 1","","GOVERNMENT","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-26 13:44:52"),
("21","4","5","0","SSS 2","","CIVIC EDUCATION","SECOND TEST","10","6","submit","2018/2019","2nd Term","2019-03-26 13:47:11"),
("22","21","5","0","SSS 2","","GOVERNMENT","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-26 13:49:25"),
("23","7","1","0","JSS 1","","BASIC TECHNOLOGY","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-26 14:48:32"),
("24","11","1","0","JSS 1","","COMPUTER SCIENCE","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-26 14:51:21"),
("25","7","2","0","JSS 2","","BASIC TECHNOLOGY","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-26 14:53:25"),
("26","11","2","0","JSS 2","","COMPUTER SCIENCE","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-26 14:55:32"),
("27","7","3","0","JSS 3","","BASIC TECHNOLOGY","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-26 14:58:48"),
("28","11","3","0","JSS 3","","COMPUTER SCIENCE","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-26 15:01:04"),
("29","11","4","0","SSS 1","","COMPUTER SCIENCE","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-26 15:03:06"),
("30","11","5","0","SSS 2","","COMPUTER SCIENCE","SECOND TEST","10","1","submit","2018/2019","2nd Term","2019-03-26 15:05:00"),
("31","8","2","0","JSS 2","","BASIC SCIENCE","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 08:25:56"),
("32","8","3","0","JSS 3","","BASIC SCIENCE","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-27 09:06:31"),
("33","18","4","0","SSS 1","","BIOLOGY","SECOND  TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 09:16:04"),
("34","17","4","0","SSS 1","","CHEMISTRY","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 09:21:42"),
("35","18","5","0","SSS 2","","BIOLOGY","SECOND TEST","10","6","submit","2018/2019","2nd Term","2019-03-27 09:27:03"),
("36","17","5","0","SSS 2","","CHEMISTRY","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 09:31:18"),
("37","2","4","0","SSS 1","","ENGLISH LANGUAGE","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 10:18:06"),
("38","2","5","0","SSS 2","","ENGLISH LANGUAGE","SECOND TEST","10","6","submit","2018/2019","2nd Term","2019-03-27 10:21:03"),
("39","9","1","0","JSS 1","","AGRICULTURAL SCIENCE","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-27 10:35:14"),
("41","9","2","0","JSS 2","","AGRICULTURAL SCIENCE","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 11:23:29"),
("42","13","2","0","JSS 2","","HOME ECONOMICS","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 11:44:58"),
("43","13","1","0","JSS 1","","HOME ECONOMICS","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-27 11:41:00"),
("44","9","3","0","JSS 3","","AGRICULTURAL SCIENCE","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-27 11:32:59"),
("45","13","3","0","JSS 3","","HOME ECONOMICS","SECOND TEST","10","7","save","2018/2019","2nd Term","0000-00-00 00:00:00"),
("46","24","4","0","SSS 1","","ACCOUNT","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 11:50:32"),
("47","9","4","0","SSS 1","","AGRICULTURAL SCIENCE","SECOND TESY","10","3","save","2018/2019","2nd Term","0000-00-00 00:00:00"),
("48","9","4","0","SSS 1","","AGRICULTURAL SCIENCE","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 12:53:34"),
("49","22","4","0","SSS 1","","COMMERCE","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 12:05:19"),
("50","20","4","0","SSS 1","","ECONOMICS","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 12:08:57"),
("51","23","4","0","SSS 1","","MARKETING","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 12:13:54"),
("52","24","5","0","SSS 2","","ACCOUNT","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 12:31:21"),
("53","9","5","0","SSS 2","","AGRICULTURAL SCIENCE","SECOND TEST","10","6","submit","2018/2019","2nd Term","2019-03-27 12:36:29"),
("54","20","5","0","SSS 2","","ECONOMICS","SECOND TEST","10","6","submit","2018/2019","2nd Term","2019-03-27 12:41:20"),
("55","3","1","0","JSS 1","","CHRISTIAN RELIGIOUS KNOWLEDGE","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-27 12:44:48"),
("56","23","5","0","SSS 2","","MARKETING","SECOND TEST","10","6","submit","2018/2019","2nd Term","2019-03-27 12:46:46"),
("57","2","1","0","JSS 1","","ENGLISH LANGUAGE","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-27 12:50:00"),
("58","3","2","0","JSS 2","","CHRISTIAN RELIGIOUS KNOWLEDGE","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 13:06:11"),
("59","1","1","0","JSS 1","","MATHEMATICS","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-27 13:45:14"),
("60","1","2","0","JSS 2","","MATHEMATICS","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 13:57:51"),
("61","1","3","0","JSS 3","","MATHEMATICS","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-27 14:02:38"),
("62","25","4","0","SSS 1","","FURTHER MATHEMATICS","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 14:07:34"),
("63","16","4","0","SSS 1","","PHYSICS","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 14:11:24"),
("64","3","3","0","JSS 3","","CHRISTIAN RELIGIOUS KNOWLEDGE","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-27 14:33:32"),
("65","2","2","0","JSS 2","","ENGLISH LANGUAGE","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 14:37:57"),
("66","2","3","0","JSS 3","","ENGLISH LANGUAGE","SECOND TEST","10","7","submit","2018/2019","2nd Term","2019-03-27 14:41:50"),
("67","3","4","0","SSS 1","","CHRISTIAN RELIGIOUS KNOWLEDGE","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 14:46:10"),
("68","3","5","0","SSS 2","","CHRISTIAN RELIGIOUS KNOWLEDGE","SECOND TEST","10","1","submit","2018/2019","2nd Term","2019-03-27 14:49:29"),
("69","27","5","0","SSS 2","","LITERATURE-IN-ENGLISH","SECOND TEST","10","4","submit","2018/2019","2nd Term","2019-03-27 14:52:54"),
("70","1","4","0","SSS 1","","MATHEMATICS","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 15:02:57"),
("71","1","5","0","SSS 2","","MATHEMATICS","SECOND TEST","10","6","submit","2018/2019","2nd Term","2019-03-27 15:19:29"),
("72","16","5","0","SSS 2","","PHYSICS","SECOND TEST","10","3","submit","2018/2019","2nd Term","2019-03-27 15:26:02"),
("73","15","1","0","JSS 1","","MUSIC","MID TERMS","30","8","save","2018/2019","3rd Term","0000-00-00 00:00:00"),
("74","15","1","0","JSS 1","","MUSIC","SECOND C.A","10","8","submit","2018/2019","3rd Term","2019-07-08 11:30:15"),
("75","15","2","0","JSS 2","","MUSIC","SECOND C.A","10","3","submit","2018/2019","3rd Term","2019-07-08 11:41:57"),
("76","7","1","0","JSS 1","","BASIC TECHNOLOGY","SECOND  CA","10","8","submit","2018/2019","3rd Term","2019-07-15 09:14:54"),
("77","11","1","0","JSS 1","","COMPUTER SCIENCE","SECOND CA","10","8","submit","2018/2019","3rd Term","2019-07-15 09:22:14"),
("78","7","2","0","JSS 2","","BASIC TECHNOLOGY","SECOND CA","10","3","submit","2018/2019","3rd Term","2019-07-15 09:26:52"),
("79","11","2","0","JSS 2","","COMPUTER SCIENCE","SECOND CA","10","3","submit","2018/2019","3rd Term","2019-07-15 09:30:36"),
("80","11","4","0","SSS 1","","COMPUTER SCIENCE","SECOND CA","10","3","submit","2018/2019","3rd Term","2019-07-15 09:33:38"),
("81","11","5","0","SSS 2","","COMPUTER SCIENCE","SECOND CA","10","1","submit","2018/2019","3rd Term","2019-07-15 09:37:07"),
("82","9","1","0","JSS 1","","AGRICULTURAL SCIENCE","SECOND CA","10","8","submit","2018/2019","3rd Term","2019-07-16 11:20:59"),
("83","15","1","0","JSS 1","","MUSIC","EXAM","60","8","save","2018/2019","3rd Term","0000-00-00 00:00:00"),
("84","3","5","0","SSS 2","","CHRISTIAN RELIGIOUS KNOWLEDGE","SECOND CA","10","1","submit","2018/2019","3rd Term","2019-07-19 12:03:49"),
("85","15","1","0","JSS 1","","MUSIC","1ST TEST","10","12","save","2019/2020","1st Term","2019-10-31 14:55:08");




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 AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4;


INSERT INTO topic VALUES
("1","PROGRAMMING","1","0","11","12","staff","not_published","0","2019/2020","2nd Term","2020-04-29 17:23:19"),
("2","COMPUTER","1","0","11","12","staff","not_published","0","2019/2020","2nd Term","2020-04-29 18:30:08"),
("3","SOFTWARE IN COMPUTER","1","0","11","12","staff","not_published","0","2019/2020","2nd Term","2020-04-29 22:56:32"),
("4","SOLVING EQUATIONS","2","0","1","15","staff","published","0","2019/2020","2nd Term","2020-05-04 07:25:41"),
("5","FIRST AID AND SAFETY EDUCATION","2","0","10","8","staff","published","0","2019/2020","2nd Term","2020-05-04 12:50:13"),
("6","SOCIAL GROUPS","1","0","12","9","staff","published","0","2019/2020","2nd Term","2020-05-21 16:00:23"),
("7","BEARING AND DISTANCE","2","0","1","15","staff","not_published","0","2019/2020","2nd Term","2020-05-18 07:19:32"),
("8","KIDNAPPING","1","0","12","9","staff","published","0","2019/2020","2nd Term","2020-05-21 16:00:14"),
("9","ALGEBRAIC EQUATIONS 3","3","0","1","15","staff","not_published","0","2019/2020","2nd Term","2020-05-20 11:40:46"),
("10","SIMILAR SURDS","4","0","25","16","staff","not_published","0","2019/2020","2nd Term","2020-05-20 14:52:58"),
("11","W, E AND P","2","0","8","2","staff","not_published","0","2019/2020","2nd Term","2020-05-20 19:56:02"),
("12","SAFETY REGULATIONS IN WIRING 1","3","0","7","12","staff","published","0","2019/2020","2nd Term","2020-05-21 08:23:48"),
("13","STATISTICS 1","4","0","1","15","staff","not_published","0","2019/2020","2nd Term","2020-05-21 08:29:53"),
("14","ICT TRANS TOOL","2","0","11","12","staff","published","0","2019/2020","2nd Term","2020-05-21 09:22:07"),
("15","BASIC COMPUTER CONCEPTS","1","0","11","12","staff","published","0","2019/2020","2nd Term","2020-05-21 09:28:57"),
("16","COMPUTER VIRUS 1","3","0","11","12","staff","published","0","2019/2020","2nd Term","2020-05-21 09:35:45"),
("17","ECONOMIC INSTITUTIONS","3","0","12","9","staff","published","0","2019/2020","2nd Term","2020-05-21 12:59:06"),
("18","HUMAN RIGHTS","1","0","4","9","staff","published","0","2019/2020","2nd Term","2020-05-21 16:00:05"),
("19","DESIGN IN THEATER","2","0","14","8","staff","published","0","2019/2020","2nd Term","2020-05-26 12:48:36"),
("20","MAGNETISM","3","0","8","2","staff","not_published","0","2019/2020","2nd Term","2020-05-25 03:27:44"),
("21","FREEHAND SKETCHING 1","1","0","7","12","staff","not_published","0","2019/2020","2nd Term","2020-05-26 07:23:21"),
("22","HYDRAULIC MACHINES 1","2","0","7","12","staff","not_published","0","2019/2020","2nd Term","2020-05-26 07:30:38"),
("23","GRAPHIC PACKAGE 1","2","0","11","12","staff","not_published","0","2019/2020","2nd Term","2020-05-26 07:36:59"),
("24","PARTS OF THE COMPUTER SYSTEM 1","1","0","11","12","staff","not_published","0","2019/2020","2nd Term","2020-05-26 07:45:07"),
("25","SIMPLE BLUEPRINT READING 1","3","0","7","12","staff","not_published","0","2019/2020","2nd Term","2020-05-26 07:51:31"),
("26","COMMUNICATION SYSTEMS","4","0","11","12","staff","not_published","0","2019/2020","2nd Term","2020-05-26 09:10:44"),
("27","DRAMA AND THEATER","1","0","14","8","staff","not_published","0","2019/2020","2nd Term","2020-05-26 12:50:34"),
("28","ANTIVIRUS 2","3","0","11","12","staff","not_published","0","2019/2020","2nd Term","2020-05-27 08:35:28"),
("29","ICT GADGETS 1","2","0","11","12","staff","not_published","0","2019/2020","2nd Term","2020-05-27 08:55:18");




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 AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4;


INSERT INTO topic_discussions VALUES
("1","3","12","staff","Software is a computer program that controls the hardware of the computer.Software also tells the computer what to do and how to do it","2020-04-29 22:59:50"),
("2","5","8","staff","The objectives of this topic are\n1. Define terms in safety education \n2. State measures to be observed at home, school, play ground and on the road. \n3. Classify accidents and injuries \n4. List causes of accidents and injuries \n5. State measures to prevent accidents and injuries. \nFor this first per","2020-05-04 12:58:00"),
("3","5","8","staff","For this first period we shall deal with the first 2 objectives","2020-05-04 12:59:39"),
("4","5","8","staff","Students shall make use of their physical and health education text books from page 114 as well as a note and pen.","2020-05-04 13:25:21"),
("5","6","9","staff","Hdgvsghsbs","2020-05-06 12:42:07"),
("6","12","12","staff","PLEASE THIS IS FOR JSS3 STUDENTS....I WOULD WANT YOU ALL TO READ THE MATERIAL","2020-05-21 07:10:44"),
("7","12","12","staff","PLEASE THIS IS FOR JSS3 STUDENTS....I WOULD WANT YOU ALL TO READ THE MATERIAL","2020-05-21 07:10:44"),
("8","14","12","staff","please check up the materials i have uploaded...\nplease respond via this platform if you have seen it...thanks\nmr Ejah","2020-05-21 09:23:33"),
("9","15","12","staff","PLEASE KINDLY READ THE MATERIALS I UPLOADED\nTHANKS\nMR EJAH","2020-05-21 09:31:28"),
("10","16","12","staff","AS YOU ACCESS THIS MATERIALS....HUMBLY DROP YOUR APPRECIATIVE COMMENTS.THANKS\nMR EJAH","2020-05-21 09:36:45"),
("11","6","38","students","I dont understand","2020-05-22 08:53:57"),
("12","19","8","staff","1. WHAT IS THEATER?\nTheater is the entire drama creating process. It refers to all that is involved in putting up a drama performance. Drama is an art form. And like all art forms one of its features is beauty. It uses beauty to entertain and add value to the performance. This beauty must be added b","2020-05-22 18:22:14"),
("13","12","28","students","okay I got ur message","2020-05-25 13:46:24"),
("14","15","38","students","Okay  sir","2020-05-25 19:50:20");




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 AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;


INSERT INTO zoom VALUES
("1","1","0","Jss1@firmfoundationschools.com.ng","Zeononline/2019","Fx48gKXvSoGUG7ZN3R4BRQ","xZJ9AsP74WGiaNRkVODvCR56URy7bZUa7BWy","92488895079","0kf5DK","WndGMGVVZTFYT0dGODdHNHVTbUgxUT09","751295","2020-04-29 01:16:09"),
("2","2","0","Jss2@firmfoundationschools.com.ng","Zeononline/2019","w9K0XZ_NStWk8MowNZwpLw","48HC9ynMAE5ronwZ8RiiOHavwBdQqLPIEU0h","98438588363","6LkMp9","SitWbDBqZ0pEM29nMi9VYmRmT0tRQT09","152086","2020-04-29 01:16:09"),
("3","3","0","Jss3@firmfoundationschools.com.ng","Zeononline/2019","w9K0XZ_NStWk8MowNZwpLw","48HC9ynMAE5ronwZ8RiiOHavwBdQqLPIEU0h","91433040690"," 1CcWnb","ZksrSnZRNWYvLy9KRnFlZG11Ui9yQT09","320377","2020-04-29 01:16:09"),
("4","4","0","ss1@firmfoundationschools.com.ng","Zeononline/2019","Kwa5XJsCQI-3b7MKmr2kvg","Esjl7Iokls0O1qb4fezLaTNkDgCA7bw6Ghku","91019043045"," 9K9STr","SVhhRUNnVkp5NC9XQ3ZYT0JUUU1zQT09","403461","2020-04-29 01:16:09"),
("5","5","0","ss2@firmfoundationschools.com.ng","Zeononline/2019","9XEs6ySgQ_O8xcTt9vFFbA","x3XDptevU7H42nCz3G54PHdepy2fA22cnCJz","91472550160","4wcZsz","NW40QUlJeFhTeGdJUHNyNG1UK1lEQT09","657606","2020-04-29 01:16:09"),
("6","6","0","ss3@firmfoundationschools.com.ng","Zeononline/2019","FhtdZRYxRpqoi-8qyT85bQ","ScU90YvDGIypog5UAMV6HcCMTbDBMLKpHIHo","94878420607"," 1eQzry","TUxxUndoZmVlMWVZKzJMNVk3MjVyZz09","958588","2020-04-29 01:16:09");




