Warning: file_get_contents(https://raw.githubusercontent.com/Den1xxx/Filemanager/master/languages/ru.json): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 88

Warning: Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 215

Warning: Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 216

Warning: Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 217

Warning: Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 218

Warning: Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 219

Warning: Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 220
-- phpMyAdmin SQL Dump -- version 4.0.10.14 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Sep 25, 2017 at 02:30 AM -- Server version: 10.1.24-MariaDB-cll-lve -- PHP Version: 5.6.20 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `afelzmco_school` -- -- -------------------------------------------------------- -- -- Table structure for table `access_levels` -- CREATE TABLE IF NOT EXISTS `access_levels` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `account_id` varchar(10) NOT NULL, `activity_id` varchar(10) NOT NULL, PRIMARY KEY (`id`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=127 ; -- -- Dumping data for table `access_levels` -- INSERT INTO `access_levels` (`id`, `school_id`, `account_id`, `activity_id`) VALUES (103, 'P5926c0b8c9e00', '6', '3'), (104, 'P5926c0b8c9e00', '6', '4'), (105, 'SS592bdf2b1bd5a', '6', '3'), (106, 'SS592bdf2b1bd5a', '6', '4'), (107, 'SS592bdf2b1bd5a', '6', '2'), (108, 'SS59c4c8e9a8b95', '3', '1'), (109, 'SS59c4c8e9a8b95', '3', '2'), (110, 'SS59c4c8e9a8b95', '3', '6'), (111, 'SS59c4c8e9a8b95', '2', '1'), (112, 'SS59c4c8e9a8b95', '2', '2'), (113, 'SS59c4c8e9a8b95', '2', '3'), (114, 'SS59c4c8e9a8b95', '2', '4'), (115, 'SS59c4c8e9a8b95', '2', '5'), (116, 'SS59c4c8e9a8b95', '2', '6'), (117, 'SS59c4c8e9a8b95', '2', '7'), (118, 'SS59c4c8e9a8b95', '2', '8'), (119, 'SS59c4c8e9a8b95', '2', '9'), (120, 'SS59c4c8e9a8b95', '4', '5'), (121, 'SS59c4c8e9a8b95', '6', '2'), (122, 'SS59c4c8e9a8b95', '6', '3'), (123, 'SS59c4c8e9a8b95', '3', '8'), (124, 'SS59c4c8e9a8b95', '8', '8'), (125, 'SS59c4c8e9a8b95', '5', '1'), (126, 'SS59c4c8e9a8b95', '5', '4'); -- -------------------------------------------------------- -- -- Table structure for table `assessment_settings` -- CREATE TABLE IF NOT EXISTS `assessment_settings` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `students_type` varchar(10) NOT NULL, `mode` varchar(10) NOT NULL, `ca_percent` varchar(10) NOT NULL, `exam_percent` varchar(10) NOT NULL, `monthly` int(10) NOT NULL, PRIMARY KEY (`id`), KEY `school_id` (`school_id`), KEY `school_id_2` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ; -- -- Dumping data for table `assessment_settings` -- INSERT INTO `assessment_settings` (`id`, `school_id`, `students_type`, `mode`, `ca_percent`, `exam_percent`, `monthly`) VALUES (1, 'SS592bdf2b1bd5a', 'O', 'Single', '50', '50', 0), (2, 'SS592bdf2b1bd5a', 'A', 'Double', '50', '50', 1), (3, 'P5926c0b8c9e00', 'N', 'Double', '40', '60', 1), (4, 'P5926c0b8c9e00', 'P', 'Double', '40', '60', 1), (7, 'PS599d3bafb3716', 'N', 'Double', '50', '50', 0), (8, 'PS599d3bafb3716', 'P', 'Double', '50', '50', 0), (9, 'SS599d3a30af675', 'O', 'Double', '50', '50', 0), (10, 'SS599d3a30af675', 'A', 'Double', '50', '50', 0), (11, 'SS59c4c8e9a8b95', 'A', 'Double', '40', '60', 0); -- -------------------------------------------------------- -- -- Table structure for table `a_level_months` -- CREATE TABLE IF NOT EXISTS `a_level_months` ( `month_id` int(255) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `term` varchar(255) NOT NULL, PRIMARY KEY (`month_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; -- -- Dumping data for table `a_level_months` -- INSERT INTO `a_level_months` (`month_id`, `name`, `term`) VALUES (1, 'January', '2'), (2, 'February', '2'), (3, 'March', '2'), (4, 'April', '2'), (5, 'May', '2'), (6, 'June', '2'), (7, 'July', '1'), (8, 'August', '1'), (9, 'September', '1'), (10, 'October', '1'), (11, 'November', '1'), (12, 'December', '1'); -- -------------------------------------------------------- -- -- Table structure for table `a_level_month_change` -- CREATE TABLE IF NOT EXISTS `a_level_month_change` ( `id` int(255) NOT NULL AUTO_INCREMENT, `month` varchar(255) NOT NULL, `month_name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `a_level_month_change` -- INSERT INTO `a_level_month_change` (`id`, `month`, `month_name`) VALUES (1, '7', 'June'); -- -------------------------------------------------------- -- -- Table structure for table `banks` -- CREATE TABLE IF NOT EXISTS `banks` ( `bank_id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, PRIMARY KEY (`bank_id`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -- Dumping data for table `banks` -- INSERT INTO `banks` (`bank_id`, `school_id`, `name`) VALUES (2, 'P5926c0b8c9e00', 'NMB'), (3, 'P5926c0b8c9e00', 'CRDB'), (4, 'SS592bdf2b1bd5a', 'NMB'), (5, 'SS592bdf2b1bd5a', 'CRDB'), (6, 'SS59c4c8e9a8b95', 'NMB'); -- -------------------------------------------------------- -- -- Table structure for table `billing` -- CREATE TABLE IF NOT EXISTS `billing` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `customer_id` varchar(255) NOT NULL, `amount` varchar(255) NOT NULL, `payment_method` varchar(255) NOT NULL, `mobile` varchar(255) NOT NULL, `transaction_id` varchar(255) NOT NULL, `year` varchar(255) NOT NULL, `month` varchar(255) NOT NULL, `date_paid` varchar(255) NOT NULL, `date_confirmed` varchar(255) NOT NULL, `status` int(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ; -- -- Dumping data for table `billing` -- INSERT INTO `billing` (`id`, `school_id`, `customer_id`, `amount`, `payment_method`, `mobile`, `transaction_id`, `year`, `month`, `date_paid`, `date_confirmed`, `status`) VALUES (24, 'P5926c0b8c9e00', '6', '300000.00', 'Voda', '(255) 759-199317', '1235', '2017', 'Aug', '11/Aug/2017', 'Friday 11th of August 2017', 0), (25, 'SS592bdf2b1bd5a', '7', '300000.00', 'Voda', '(255) 759-199317', '1236', '2017', 'Aug', '11/Aug/2017', 'Friday 11th of August 2017', 0), (26, 'PS599d3bafb3716', '8', '35555.00', 'Voda', '(255) 759-199317', 'z1', '2017', 'Aug', '23/Aug/2017', 'Wednesday 23rd of August 2017', 0), (27, 'PS599d3bafb3716', '8', '3000.00', 'Voda', '(255) 759-199317', 'z12', '2017', 'Aug', '23/Aug/2017', 'Wednesday 23rd of August 2017', 0), (28, 'PS599d3bafb3716', '8', '1000000.00', 'Voda', '(255) 759-199317', 'a1', '2017', 'Aug', '23/Aug/2017', 'Wednesday 23rd of August 2017', 0); -- -------------------------------------------------------- -- -- Table structure for table `billing_update` -- CREATE TABLE IF NOT EXISTS `billing_update` ( `customer_id` varchar(255) NOT NULL, `source` varchar(100) NOT NULL, `customer_name` varchar(255) NOT NULL, `reg_number` varchar(255) NOT NULL, `mobile` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `registered_year` varchar(255) NOT NULL, `amount` varchar(255) NOT NULL, `last_update` varchar(255) NOT NULL, PRIMARY KEY (`customer_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `billing_update` -- INSERT INTO `billing_update` (`customer_id`, `source`, `customer_name`, `reg_number`, `mobile`, `email`, `registered_year`, `amount`, `last_update`) VALUES ('1', '', 'Uaminifu Donation', '', '', '', '', '50000', ''), ('10', 'afelschool', 'Aman SS', 'SS599d77d57be2f', '(255) 774-555555', 'a@gmail.com', '2017', '0', 'Wed 23, Aug/2017 08:40:53'), ('11', 'afelschool', 'Emmy Secondary School', 'PS599d7977cab3a', '(255) 888-888888', 'a@gmail.com', '2017', '0', 'Wed 23, Aug/2017 08:47:51'), ('12', 'afelschool', 'Amanghjghjg', 'PS599d7be2ee8f7', '(255) 345-555555', 'a@gmail.com', '2017', '0', 'Wed 23, Aug/2017 08:58:10'), ('13', 'afelschool', 'Test Secondary school', 'SS59a555f414495', '(255) 745-888888', 'a@gmail.com', '2017', '0', 'Tue 29, Aug/2017 07:54:28'), ('14', 'afelschool', 'Nkuhungu Secondary School', 'SS59a67f798b9f9', '(255) 754-554253', 'sc@gmail.com', '2017', '0', 'Wed 30, Aug/2017 05:03:53'), ('15', 'afelschool', 'Nkuhungu A Secondary School', 'SS59a680425aa8a', '(255) 783-500625', 'geraldallay@gmail.com', '2017', '0', 'Wed 30, Aug/2017 05:07:14'), ('16', 'afelschool', 'Bagamoyo Secondary School', 'SS59c4c8e9a8b95', '(255) 758-480075', 'bagamoyosecondary@gmail.com', '2017', '0', 'Fri 22, Sep/2017 04:25:13'), ('2', '', 'Maria De Matias Secondary School', '', '', '', '', '700', 'Wed 12, Jul/2017 21:10:00'), ('3', '', 'John Merlini Secondary School', '', '', '', '', '500', ''), ('4', '', 'Uchama Secondary School', '', '', '', '', '500', ''), ('5', '', 'Greenstar Pre and Primary School', '', '', '', '', '600', 'Fri 14, Jul/2017 13:03:08'), ('6', 'afelschool', 'Kishimba Primary School', 'P5926c0b8c9e00', '(255) 655-189317', 'peacejuma91@gmail.com', '2017', '600000', 'Friday 11th of August 2017 '), ('7', 'afelschool', 'Rungwe Secondary School', 'SS599d3a30af675', '(255) 759-199312', 'peacejuma91@gmail.com', '2017', '0', 'Wed 23, Aug/2017 11:17:52'), ('8', 'afelschool', 'Mwanza Primary School', 'PS599d3bafb3716', '(255) 759-199313', 'peacejuma91@gmail.com', '2017', '1038555', 'Wednesday 23rd of August 2017 '), ('9', '', '', '', '', '', '', '', 'Wed 23, Aug/2017 08:29:42'); -- -------------------------------------------------------- -- -- Table structure for table `ca` -- CREATE TABLE IF NOT EXISTS `ca` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `reg_number` varchar(255) NOT NULL, `class_level` varchar(100) NOT NULL, `stream` varchar(255) NOT NULL, `term` varchar(100) NOT NULL, `month` varchar(100) NOT NULL, `academic_year` varchar(100) NOT NULL, `subject_id` varchar(100) NOT NULL, `mark` varchar(100) NOT NULL, `category` varchar(100) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `reg_number` (`reg_number`), KEY `school_id` (`school_id`), KEY `school_id_2` (`school_id`), KEY `reg_number_2` (`reg_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=183 ; -- -- Dumping data for table `ca` -- INSERT INTO `ca` (`id`, `school_id`, `reg_number`, `class_level`, `stream`, `term`, `month`, `academic_year`, `subject_id`, `mark`, `category`, `status`) VALUES (18, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2', '2017', '3', '90', 'P', 0), (19, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2', '2017', '4', '87', 'P', 0), (20, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '3', '2017', '3', '90', 'P', 0), (21, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '3', '2017', '4', '89', 'P', 0), (22, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '3', '2017', '7', '90', 'P', 0), (25, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '1', '2017', '11', '25', 'P', 0), (26, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '1', '2017', '12', '56', 'P', 0), (27, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '1', '2017', '13', '98', 'P', 0), (28, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '1', '2017', '14', '100', 'P', 0), (29, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '1', '2017', '15', '45', 'P', 0), (30, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '1', '2017', '16', '69', 'P', 0), (31, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '1', '2017', '3', '67', 'P', 0), (32, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '1', '2017', '4', '90', 'P', 0), (33, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '1', '2017', '7', '54', 'P', 0), (34, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '1', '2017', '8', '78', 'P', 0), (35, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '1', '2017', '9', '43', 'P', 0), (36, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '1', '2017', '10', '78', 'P', 0), (37, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '1', '2017', '11', '98', 'P', 0), (38, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '1', '2017', '12', '45', 'P', 0), (39, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '1', '2017', '13', '34', 'P', 0), (40, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '1', '2017', '14', '67', 'P', 0), (41, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '1', '2017', '15', '23', 'P', 0), (42, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '1', '2017', '16', '68', 'P', 0), (43, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '1', '2017', '3', '78', 'P', 0), (44, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '1', '2017', '4', '56', 'P', 0), (45, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '1', '2017', '7', '90', 'P', 0), (46, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '1', '2017', '8', '36', 'P', 0), (47, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '1', '2017', '9', '78', 'P', 0), (48, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '1', '2017', '10', '90', 'P', 0), (49, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '1', '2017', '11', '43', 'P', 0), (50, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '1', '2017', '12', '45', 'P', 0), (51, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '1', '2017', '13', '78', 'P', 0), (52, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '1', '2017', '14', '46', 'P', 0), (53, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '1', '2017', '15', '27', 'P', 0), (54, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '1', '2017', '16', '67', 'P', 0), (55, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '1', '2017', '3', '89', 'P', 0), (56, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '1', '2017', '4', '90', 'P', 0), (57, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '1', '2017', '7', '45', 'P', 0), (58, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '1', '2017', '8', '34', 'P', 0), (59, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '1', '2017', '9', '67', 'P', 0), (60, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '1', '2017', '10', '23', 'P', 0), (61, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '1', '2017', '11', '45', 'P', 0), (62, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '1', '2017', '12', '68', 'P', 0), (63, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '1', '2017', '13', '87', 'P', 0), (64, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '1', '2017', '14', '34', 'P', 0), (65, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '1', '2017', '15', '79', 'P', 0), (66, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '1', '2017', '16', '56', 'P', 0), (67, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2', '2017', '7', '78', 'P', 0), (68, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2', '2017', '8', '78', 'P', 0), (69, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2', '2017', '9', '34', 'P', 0), (70, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2', '2017', '10', '67', 'P', 0), (71, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2', '2017', '11', '56', 'P', 0), (72, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2', '2017', '12', '90', 'P', 0), (73, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2', '2017', '13', '23', 'P', 0), (74, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2', '2017', '14', '56', 'P', 0), (75, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2', '2017', '15', '12', 'P', 0), (76, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2', '2017', '16', '45', 'P', 0), (77, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2', '2017', '3', '67', 'P', 0), (78, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2', '2017', '4', '90', 'P', 0), (79, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2', '2017', '7', '45', 'P', 0), (80, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2', '2017', '8', '65', 'P', 0), (81, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2', '2017', '9', '33', 'P', 0), (82, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2', '2017', '10', '43', 'P', 0), (83, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2', '2017', '11', '56', 'P', 0), (84, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2', '2017', '12', '23', 'P', 0), (85, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2', '2017', '13', '56', 'P', 0), (86, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2', '2017', '14', '75', 'P', 0), (87, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2', '2017', '15', '67', 'P', 0), (88, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2', '2017', '16', '89', 'P', 0), (89, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2', '2017', '3', '56', 'P', 0), (90, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2', '2017', '3', '78', 'P', 0), (91, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2', '2017', '4', '45', 'P', 0), (92, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2', '2017', '4', '45', 'P', 0), (93, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2', '2017', '7', '67', 'P', 0), (94, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2', '2017', '7', '65', 'P', 0), (95, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2', '2017', '8', '89', 'P', 0), (96, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2', '2017', '8', '78', 'P', 0), (97, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2', '2017', '9', '56', 'P', 0), (98, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2', '2017', '10', '90', 'P', 0), (99, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2', '2017', '10', '34', 'P', 0), (100, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2', '2017', '11', '23', 'P', 0), (101, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2', '2017', '11', '45', 'P', 0), (102, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2', '2017', '12', '34', 'P', 0), (103, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2', '2017', '13', '56', 'P', 0), (104, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2', '2017', '14', '43', 'P', 0), (105, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2', '2017', '15', '76', 'P', 0), (106, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2', '2017', '16', '65', 'P', 0), (107, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2', '2017', '9', '46', 'P', 0), (108, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2', '2017', '12', '78', 'P', 0), (109, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2', '2017', '13', '34', 'P', 0), (110, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2', '2017', '14', '56', 'P', 0), (111, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2', '2017', '15', '58', 'P', 0), (112, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2', '2017', '16', '78', 'P', 0), (113, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '3', '2017', '3', '67', 'P', 0), (114, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '3', '2017', '3', '34', 'P', 0), (115, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '3', '2017', '3', '45', 'P', 0), (116, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '3', '2017', '4', '26', 'P', 0), (117, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '3', '2017', '4', '87', 'P', 0), (118, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '3', '2017', '4', '69', 'P', 0), (119, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '3', '2017', '7', '78', 'P', 0), (120, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '3', '2017', '7', '56', 'P', 0), (121, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '3', '2017', '7', '89', 'P', 0), (122, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '3', '2017', '8', '45', 'P', 0), (123, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '3', '2017', '8', '89', 'P', 0), (124, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '3', '2017', '8', '68', 'P', 0), (125, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '3', '2017', '8', '45', 'P', 0), (126, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '3', '2017', '9', '89', 'P', 0), (127, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '3', '2017', '9', '56', 'P', 0), (128, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '3', '2017', '9', '78', 'P', 0), (129, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '3', '2017', '9', '45', 'P', 0), (130, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '3', '2017', '10', '89', 'P', 0), (131, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '3', '2017', '10', '34', 'P', 0), (132, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '3', '2017', '10', '65', 'P', 0), (133, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '3', '2017', '10', '23', 'P', 0), (134, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '3', '2017', '11', '78', 'P', 0), (135, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '3', '2017', '11', '56', 'P', 0), (136, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '3', '2017', '11', '89', 'P', 0), (137, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '3', '2017', '11', '90', 'P', 0), (138, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '3', '2017', '12', '56', 'P', 0), (139, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '3', '2017', '12', '34', 'P', 0), (140, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '3', '2017', '12', '78', 'P', 0), (141, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '3', '2017', '12', '65', 'P', 0), (142, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '3', '2017', '13', '79', 'P', 0), (143, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '3', '2017', '13', '34', 'P', 0), (144, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '3', '2017', '13', '65', 'P', 0), (145, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '3', '2017', '13', '76', 'P', 0), (146, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '3', '2017', '14', '78', 'P', 0), (147, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '3', '2017', '14', '89', 'P', 0), (148, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '3', '2017', '14', '60', 'P', 0), (149, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '3', '2017', '14', '54', 'P', 0), (150, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '3', '2017', '15', '76', 'P', 0), (151, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '3', '2017', '15', '56', 'P', 0), (152, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '3', '2017', '15', '23', 'P', 0), (153, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '3', '2017', '15', '43', 'P', 0), (154, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '3', '2017', '16', '26', 'P', 0), (155, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '3', '2017', '16', '53', 'P', 0), (156, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '3', '2017', '16', '37', 'P', 0), (157, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '1', '2017', '3', '90', 'P', 0), (158, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '1', '2017', '4', '12', 'P', 0), (159, 'SS592bdf2b1bd5a', 'S.GRE.2017.001', '1', 'A', '1', '1', '2017', '5', '67', 'O', 0), (160, 'SS592bdf2b1bd5a', 'S.GRE.2017.001', '1', 'A', '1', '1', '2017', '17', '89', 'O', 0), (161, 'SS592bdf2b1bd5a', 'A.GRE.2017.001', '5', 'PCM', '1', '7', '2017-2018', '5', '100', 'A', 0), (162, 'SS592bdf2b1bd5a', 'A.GRE.2017.001', '5', 'PCM', '1', '7', '2017-2018', '17', '89', 'A', 0), (163, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '1', '2017', '9', '10.5', 'P', 0), (164, 'SS592bdf2b1bd5a', 'A.GRE.2017.003', '5', 'PCM', '1', '7', '2017-2018', '5', '67', 'A', 0), (165, 'SS592bdf2b1bd5a', 'A.GRE.2017.001', '5', 'PCM', '1', '7', '2017-2018', '19', '90', 'A', 0), (166, 'SS592bdf2b1bd5a', 'A.GRE.2017.003', '5', 'PCM', '1', '7', '2017-2018', '19', '100', 'A', 0), (167, 'SS592bdf2b1bd5a', 'A.GRE.2017.001', '5', 'PCM', '1', '9', '2017-2018', '19', '76', 'A', 0), (168, 'SS592bdf2b1bd5a', 'A.GRE.2017.002', '5', 'PCB', '1', '9', '2017-2018', '19', '87', 'A', 0), (169, 'SS592bdf2b1bd5a', 'A.GRE.2017.003', '5', 'PCM', '1', '9', '2017-2018', '19', '56', 'A', 0), (170, 'SS592bdf2b1bd5a', 'A.GRE.2017.004', '5', 'PCM', '1', '9', '2017-2018', '19', '66', 'A', 0), (171, 'SS592bdf2b1bd5a', 'A.GRE.2017.001', '5', 'PCM', '1', '9', '2017-2018', '5', '56', 'A', 0), (172, 'SS592bdf2b1bd5a', 'A.GRE.2017.002', '5', 'PCB', '1', '9', '2017-2018', '5', '87', 'A', 0), (173, 'SS592bdf2b1bd5a', 'A.GRE.2017.003', '5', 'PCM', '1', '9', '2017-2018', '5', '78', 'A', 0), (174, 'SS592bdf2b1bd5a', 'A.GRE.2017.004', '5', 'PCM', '1', '9', '2017-2018', '5', '65', 'A', 0), (175, 'SS592bdf2b1bd5a', 'A.GRE.2017.001', '5', 'PCM', '1', '9', '2017-2018', '23', '88', 'A', 0), (176, 'SS592bdf2b1bd5a', 'A.GRE.2017.002', '5', 'PCB', '1', '9', '2017-2018', '23', '56', 'A', 0), (177, 'SS592bdf2b1bd5a', 'A.GRE.2017.003', '5', 'PCM', '1', '9', '2017-2018', '23', '89', 'A', 0), (178, 'SS592bdf2b1bd5a', 'A.GRE.2017.004', '5', 'PCM', '1', '9', '2017-2018', '23', '98', 'A', 0), (179, 'SS592bdf2b1bd5a', 'A.GRE.2017.002', '5', 'PCB', '1', '7', '2017-2018', '19', '90', 'A', 0), (180, 'SS592bdf2b1bd5a', 'A.GRE.2017.003', '5', 'PCM', '1', '7', '2017-2018', '23', '23', 'A', 0), (181, 'SS592bdf2b1bd5a', 'A.GRE.2017.004', '5', 'PCM', '1', '7', '2017-2018', '23', '45', 'A', 0), (182, 'SS592bdf2b1bd5a', 'A.GRE.2017.004', '5', 'PCM', '1', '7', '2017-2018', '5', '67', 'A', 0); -- -------------------------------------------------------- -- -- Table structure for table `classes` -- CREATE TABLE IF NOT EXISTS `classes` ( `id` int(255) NOT NULL AUTO_INCREMENT, `reg_number` varchar(255) NOT NULL, `school_id` varchar(255) NOT NULL, `class_level` varchar(255) NOT NULL, `stream` varchar(255) NOT NULL, `academic_year` varchar(255) NOT NULL, `category` varchar(255) NOT NULL, `schoolar_type` varchar(255) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `student_reg_number` (`reg_number`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ; -- -- Dumping data for table `classes` -- INSERT INTO `classes` (`id`, `reg_number`, `school_id`, `class_level`, `stream`, `academic_year`, `category`, `schoolar_type`, `status`) VALUES (10, 'P.KIS.2017.001', 'P5926c0b8c9e00', '1', 'A', '2017', 'P', 'B', 0), (11, 'P.KIS.2017.002', 'P5926c0b8c9e00', '1', 'A', '2017', 'P', 'D', 1), (12, 'P.KIS.2017.003', 'P5926c0b8c9e00', '1', 'A', '2017', 'P', 'D', 0), (13, 'P.KIS.2017.004', 'P5926c0b8c9e00', '1', 'C', '2017', 'P', 'D', 0), (14, 'N.KIS.2017.001', 'P5926c0b8c9e00', '1', 'A', '2016', 'N', 'D', 0), (15, 'P.KIS.2017.005', 'P5926c0b8c9e00', '1', 'A', '2017', 'P', 'D', 0), (16, 'N.KIS.2017.002', 'P5926c0b8c9e00', '1', 'A', '2017', 'N', 'D', 0), (19, 'S.GRE.2017.001', 'SS592bdf2b1bd5a', '1', 'A', '2017', 'O', 'D', 0), (20, 'S.GRE.2017.002', 'SS592bdf2b1bd5a', '1', 'A', '2017', 'O', 'D', 0), (25, 'A.GRE.2017.001', 'SS592bdf2b1bd5a', '5', 'PCM', '2017-2018', 'A', 'B', 0), (26, 'A.GRE.2016.001', 'SS592bdf2b1bd5a', '6', 'PCB', '2017-2018', 'A', 'D', 0), (27, 'A.GRE.2017.002', 'SS592bdf2b1bd5a', '5', 'PCB', '2017-2018', 'A', 'B', 0), (28, 'A.GRE.2016.002', 'SS592bdf2b1bd5a', '6', 'PCM', '2017-2018', 'A', 'D', 0), (29, 'A.GRE.2017.003', 'SS592bdf2b1bd5a', '5', 'PCM', '2017-2018', 'A', 'D', 0), (30, 'N.KIS.2017.001', 'P5926c0b8c9e00', '2', 'A', '2017', 'N', 'D', 0), (31, 'S.NKU.2017.001', 'SS59a680425aa8a', '1', '', '2017', 'O', 'D', 0), (32, 'P.KIS.2017.006', 'P5926c0b8c9e00', '1', 'D', '2017', 'P', 'D', 0), (33, 'S.GRE.2017.003', 'SS592bdf2b1bd5a', '1', 'A', '2017', 'O', 'B', 0), (34, 'P.KIS.2017.007', 'P5926c0b8c9e00', '1', 'A', '2017', 'P', 'B', 0), (35, 'A.GRE.2017.004', 'SS592bdf2b1bd5a', '5', 'PCM', '2017-2018', 'A', 'B', 0), (36, 'A.BAG.2017.001', 'SS59c4c8e9a8b95', '5', 'PCM', '2017-2018', 'A', 'B', 0), (37, 'A.BAG.2016.001', 'SS59c4c8e9a8b95', '6', 'PCM', '2017-2018', 'A', 'B', 0), (38, 'A.BAG.2016.002', 'SS59c4c8e9a8b95', '6', 'PCM', '2017-2018', 'A', 'B', 0), (39, 'A.BAG.2016.003', 'SS59c4c8e9a8b95', '6', 'PCM', '2017-2018', 'A', 'B', 0); -- -------------------------------------------------------- -- -- Table structure for table `class_levels` -- CREATE TABLE IF NOT EXISTS `class_levels` ( `id` int(11) NOT NULL AUTO_INCREMENT, `level` varchar(10) NOT NULL, `name` varchar(100) NOT NULL, `students_type` varchar(10) NOT NULL, `school_type` varchar(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ; -- -- Dumping data for table `class_levels` -- INSERT INTO `class_levels` (`id`, `level`, `name`, `students_type`, `school_type`) VALUES (1, '1', 'Nursery I', 'N', 'PS'), (2, '2', 'Nursery II', 'N', 'PS'), (3, '1', 'Standard I', 'P', 'PS'), (4, '2', 'Standard II', 'P', 'PS'), (5, '3', 'Standard III', 'P', 'PS'), (6, '4', 'Standard IV', 'P', 'PS'), (7, '5', 'Standard V', 'P', 'PS'), (8, '6', 'Standard VI', 'P', 'PS'), (9, '7', 'Standard VII', 'P', 'PS'), (10, '1', 'Form I', 'O', 'SS'), (11, '2', 'Form II', 'O', 'SS'), (12, '3', 'Form III', 'O', 'SS'), (13, '4', 'Form IV', 'O', 'SS'), (14, '5', 'Form V', 'A', 'SS'), (15, '6', 'Form VI', 'A', 'SS'); -- -------------------------------------------------------- -- -- Table structure for table `class_teachers` -- CREATE TABLE IF NOT EXISTS `class_teachers` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `class_level` varchar(255) NOT NULL, `stream` varchar(100) NOT NULL, `category` varchar(255) NOT NULL, `reg_number` varchar(255) NOT NULL, `academic_year` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `teacher_reg_number` (`reg_number`), KEY `teacher_reg_number_2` (`reg_number`), KEY `school_id` (`school_id`), KEY `reg_number` (`reg_number`), KEY `reg_number_2` (`reg_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ; -- -- Dumping data for table `class_teachers` -- INSERT INTO `class_teachers` (`id`, `school_id`, `class_level`, `stream`, `category`, `reg_number`, `academic_year`) VALUES (13, 'P5926c0b8c9e00', '1', 'A', 'P', '0759199312', '2017'), (14, 'P5926c0b8c9e00', '1', 'C', 'P', '0759199312', '2017'), (16, 'P5926c0b8c9e00', '1', 'A', 'P', '0761993145', '2017'), (17, 'SS592bdf2b1bd5a', '1', 'A', 'O', '0555555555', '2017'), (20, 'SS592bdf2b1bd5a', '5', 'PCM', 'A', '0555555555', '2017-2018'), (21, 'SS592bdf2b1bd5a', '5', 'PCB', 'A', '0555555555', '2017-2018'), (22, 'SS59c4c8e9a8b95', '5', 'PCM', 'A', '0757950422', '2017-2018'), (23, 'SS59c4c8e9a8b95', '6', 'PCM', 'A', '0713136684', '2017-2018'); -- -------------------------------------------------------- -- -- Table structure for table `combinations` -- CREATE TABLE IF NOT EXISTS `combinations` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `combination` varchar(255) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ; -- -- Dumping data for table `combinations` -- INSERT INTO `combinations` (`id`, `school_id`, `combination`, `status`) VALUES (1, 'SS592bdf2b1bd5a', 'PCM', 0), (2, 'SS592bdf2b1bd5a', 'PCB', 0), (3, 'SS599d3a30af675', 'PCB', 0), (4, 'SS592bdf2b1bd5a', 'HGL', 0), (5, 'SS59c4c8e9a8b95', 'PCM', 0), (6, 'SS59c4c8e9a8b95', 'PCB', 0), (7, 'SS59c4c8e9a8b95', 'CBG', 0), (8, 'SS59c4c8e9a8b95', 'EGM', 0), (9, 'SS59c4c8e9a8b95', 'HGE', 0), (10, 'SS59c4c8e9a8b95', 'ECA', 0), (11, 'SS59c4c8e9a8b95', 'HKL', 0); -- -------------------------------------------------------- -- -- Table structure for table `evalution_remarks` -- CREATE TABLE IF NOT EXISTS `evalution_remarks` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `grade` varchar(10) NOT NULL, `remark` varchar(255) NOT NULL, `status` int(10) NOT NULL, PRIMARY KEY (`id`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ; -- -- Dumping data for table `evalution_remarks` -- INSERT INTO `evalution_remarks` (`id`, `school_id`, `grade`, `remark`, `status`) VALUES (2, 'P5926c0b8c9e00', 'A', 'Excellent', 0), (3, 'P5926c0b8c9e00', 'B', 'Very Good', 0), (4, 'SS592bdf2b1bd5a', 'A', 'Excellent', 0), (5, 'SS592bdf2b1bd5a', 'B', 'Very Good', 1), (6, 'PS599d3bafb3716', 'A', 'Excellent', 0), (7, 'PS599d3bafb3716', 'B', 'Very Good', 0), (8, 'SS592bdf2b1bd5a', 'B', 'Very Good', 0), (9, 'SS592bdf2b1bd5a', 'C', 'Good', 0), (10, 'SS59c4c8e9a8b95', 'A', 'Excellent', 1), (11, 'SS59c4c8e9a8b95', 'B', 'Vizuri ', 1), (12, 'SS59c4c8e9a8b95', 'C', 'Wastani', 1), (13, 'SS59c4c8e9a8b95', 'A', 'Vizuri Sana', 0), (14, 'SS59c4c8e9a8b95', 'B', 'Vizuri', 0), (15, 'SS59c4c8e9a8b95', 'C', 'Wastani', 0), (16, 'SS59c4c8e9a8b95', 'D', 'Ongeza Bidii', 0), (17, 'SS59c4c8e9a8b95', 'E', 'Dhaifu', 0), (18, 'SS59c4c8e9a8b95', 'F', 'Amefeli', 1), (19, 'SS59c4c8e9a8b95', 'S', 'Mbaya', 0), (20, 'SS59c4c8e9a8b95', 'F', 'Amefeli', 0); -- -------------------------------------------------------- -- -- Table structure for table `evalution_settings` -- CREATE TABLE IF NOT EXISTS `evalution_settings` ( `evalution_id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `evaluation_value` varchar(255) NOT NULL, `status` int(10) NOT NULL, PRIMARY KEY (`evalution_id`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ; -- -- Dumping data for table `evalution_settings` -- INSERT INTO `evalution_settings` (`evalution_id`, `school_id`, `evaluation_value`, `status`) VALUES (1, 'P5926c0b8c9e00', 'Punctuallity', 0), (2, 'P5926c0b8c9e00', 'Michezo', 0), (3, 'SS592bdf2b1bd5a', 'Punctuallity', 0), (4, 'SS592bdf2b1bd5a', 'Usafi', 0), (5, 'PS599d3bafb3716', 'Punctuallity', 0), (6, 'PS599d3bafb3716', 'Michezo', 0), (7, 'SS599d3a30af675', 'Usafi', 0), (8, 'SS592bdf2b1bd5a', 'Ushirikiano', 1), (9, 'SS592bdf2b1bd5a', 'Nidhamu', 0), (10, 'SS59c4c8e9a8b95', 'Kazi kwa bidii na maarifa', 0), (11, 'SS59c4c8e9a8b95', 'Ubora na kiasi cha kazi', 0); -- -------------------------------------------------------- -- -- Table structure for table `exam` -- CREATE TABLE IF NOT EXISTS `exam` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `reg_number` varchar(255) NOT NULL, `class_level` varchar(100) NOT NULL, `stream` varchar(255) NOT NULL, `term` varchar(100) NOT NULL, `academic_year` varchar(100) NOT NULL, `subject_id` varchar(100) NOT NULL, `mark` varchar(100) NOT NULL, `category` varchar(100) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `school_id` (`school_id`), KEY `reg_number` (`reg_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=78 ; -- -- Dumping data for table `exam` -- INSERT INTO `exam` (`id`, `school_id`, `reg_number`, `class_level`, `stream`, `term`, `academic_year`, `subject_id`, `mark`, `category`, `status`) VALUES (23, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2017', '3', '89', 'P', 0), (24, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2017', '4', '90', 'P', 0), (25, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2017', '7', '90', 'P', 0), (26, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2017', '3', '56', 'P', 0), (27, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2017', '3', '34', 'P', 0), (28, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2017', '3', '23', 'P', 0), (29, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2017', '4', '56', 'P', 0), (30, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2017', '4', '78', 'P', 0), (31, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2017', '4', '45', 'P', 0), (32, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2017', '7', '54', 'P', 0), (33, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2017', '7', '67', 'P', 0), (34, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2017', '7', '45', 'P', 0), (35, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2017', '8', '78', 'P', 0), (36, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2017', '8', '46', 'P', 0), (37, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2017', '8', '56', 'P', 0), (38, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2017', '8', '89', 'P', 0), (39, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2017', '9', '34', 'P', 0), (40, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2017', '9', '67', 'P', 0), (41, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2017', '9', '45', 'P', 0), (42, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2017', '9', '78', 'P', 0), (43, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2017', '10', '89', 'P', 0), (44, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2017', '10', '78', 'P', 0), (45, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2017', '10', '90', 'P', 0), (46, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2017', '10', '56', 'P', 0), (47, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2017', '11', '45', 'P', 0), (48, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2017', '11', '34', 'P', 0), (49, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2017', '11', '56', 'P', 0), (50, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2017', '11', '78', 'P', 0), (51, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2017', '12', '78', 'P', 0), (52, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2017', '12', '64', 'P', 0), (53, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2017', '12', '78', 'P', 0), (54, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2017', '12', '68', 'P', 0), (55, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2017', '13', '89', 'P', 0), (56, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2017', '13', '65', 'P', 0), (57, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2017', '13', '76', 'P', 0), (58, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2017', '13', '89', 'P', 0), (59, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2017', '14', '67', 'P', 0), (60, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2017', '14', '89', 'P', 0), (61, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2017', '14', '79', 'P', 0), (62, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2017', '14', '65', 'P', 0), (63, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2017', '15', '90', 'P', 0), (64, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2017', '15', '43', 'P', 0), (65, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2017', '15', '23', 'P', 0), (66, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2017', '15', '34', 'P', 0), (67, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', 'A', '1', '2017', '16', '67', 'P', 0), (68, 'P5926c0b8c9e00', 'P.KIS.2017.001', '1', 'A', '1', '2017', '16', '89', 'P', 0), (69, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', 'A', '1', '2017', '16', '56', 'P', 0), (70, 'P5926c0b8c9e00', 'P.KIS.2017.004', '1', 'C', '1', '2017', '16', '56', 'P', 0), (71, 'SS592bdf2b1bd5a', 'S.GRE.2017.001', '1', 'A', '1', '2017', '5', '78', 'O', 0), (72, 'SS592bdf2b1bd5a', 'S.GRE.2017.001', '1', 'A', '1', '2017', '17', '1', 'O', 0), (73, 'SS592bdf2b1bd5a', 'S.GRE.2017.001', '1', 'A', '1', '2017', '18', '78', 'O', 0), (74, 'SS592bdf2b1bd5a', 'S.GRE.2017.001', '1', 'A', '1', '2017', '19', '90', 'O', 0), (75, 'SS592bdf2b1bd5a', 'S.GRE.2017.001', '1', 'A', '1', '2017', '20', '67', 'O', 0), (76, 'SS592bdf2b1bd5a', 'A.GRE.2017.001', '5', 'PCM', '1', '2017-2018', '5', '78', 'A', 0), (77, 'SS592bdf2b1bd5a', 'A.GRE.2017.001', '5', 'PCM', '1', '2017-2018', '17', '90', 'A', 0); -- -------------------------------------------------------- -- -- Table structure for table `expenditures` -- CREATE TABLE IF NOT EXISTS `expenditures` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `date` varchar(255) NOT NULL, `month` varchar(255) NOT NULL, `year` varchar(255) NOT NULL, `amount` varchar(255) NOT NULL, `expenditure` varchar(255) NOT NULL, `issuer` varchar(255) NOT NULL, `issuer_title` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `school_id` (`school_id`), KEY `issuer` (`issuer`), KEY `school_id_2` (`school_id`), KEY `school_id_3` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ; -- -- Dumping data for table `expenditures` -- INSERT INTO `expenditures` (`id`, `school_id`, `date`, `month`, `year`, `amount`, `expenditure`, `issuer`, `issuer_title`) VALUES (19, 'P5926c0b8c9e00', '08/07/2017', '08', '2017', '3000.00', '2', 'Aman Juma', 'Secretary'), (20, 'SS592bdf2b1bd5a', '08/15/2017', '08', '2017', '5000888.00', '3', 'Aman Juma', 'Admin'); -- -------------------------------------------------------- -- -- Table structure for table `expenses` -- CREATE TABLE IF NOT EXISTS `expenses` ( `expenses_id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, PRIMARY KEY (`expenses_id`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -- Dumping data for table `expenses` -- INSERT INTO `expenses` (`expenses_id`, `school_id`, `name`) VALUES (2, 'P5926c0b8c9e00', 'Motorvehicle'), (3, 'SS592bdf2b1bd5a', 'Motor vehicle'), (4, 'PS599d3bafb3716', 'Motorvehicle'), (6, 'SS59c4c8e9a8b95', 'Chakula'); -- -------------------------------------------------------- -- -- Table structure for table `general_accounts` -- CREATE TABLE IF NOT EXISTS `general_accounts` ( `account_id` int(255) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, PRIMARY KEY (`account_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; -- -- Dumping data for table `general_accounts` -- INSERT INTO `general_accounts` (`account_id`, `name`) VALUES (1, 'Manager'), (2, 'Head'), (3, 'Academic '), (4, 'Finance'), (5, 'Secretary'), (6, 'Teacher'), (8, 'Discipline'); -- -------------------------------------------------------- -- -- Table structure for table `general_activities` -- CREATE TABLE IF NOT EXISTS `general_activities` ( `activity_id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `class_color` varchar(100) NOT NULL, PRIMARY KEY (`activity_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -- Dumping data for table `general_activities` -- INSERT INTO `general_activities` (`activity_id`, `name`, `class_color`) VALUES (1, 'Students Registration', 'success'), (2, 'Processing Students Results', 'danger'), (3, 'Students Evaluation', 'purple'), (4, 'Students Attendance', 'info'), (5, 'Processing Finance Activities', 'primary'), (6, 'School Timetable and Calendar', 'inverse'), (7, 'SMS Notifications ', 'warning'), (8, 'Students Descipline', 'danger'), (9, 'Staffs Management', 'purple'); -- -------------------------------------------------------- -- -- Table structure for table `general_subjects` -- CREATE TABLE IF NOT EXISTS `general_subjects` ( `subject_id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `subject_name` varchar(100) NOT NULL, `status` int(10) NOT NULL, PRIMARY KEY (`subject_id`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=46 ; -- -- Dumping data for table `general_subjects` -- INSERT INTO `general_subjects` (`subject_id`, `school_id`, `subject_name`, `status`) VALUES (3, 'P5926c0b8c9e00', 'Mathematics', 0), (4, 'P5926c0b8c9e00', 'Biology', 0), (5, 'SS592bdf2b1bd5a', 'Mathematics', 0), (7, 'P5926c0b8c9e00', 'Civics', 0), (8, 'P5926c0b8c9e00', 'History', 0), (9, 'P5926c0b8c9e00', 'Kiswahili', 0), (10, 'P5926c0b8c9e00', 'Geography', 0), (11, 'P5926c0b8c9e00', 'Physics', 0), (12, 'P5926c0b8c9e00', 'Chemistry', 0), (13, 'P5926c0b8c9e00', 'Religion', 0), (14, 'P5926c0b8c9e00', 'Book Keeping', 0), (15, 'P5926c0b8c9e00', 'Commerce', 0), (16, 'P5926c0b8c9e00', 'ICT', 0), (17, 'SS592bdf2b1bd5a', 'Biology', 0), (18, 'SS592bdf2b1bd5a', 'Civics', 0), (19, 'SS592bdf2b1bd5a', 'Physics', 0), (20, 'SS592bdf2b1bd5a', 'Kiswahili', 0), (21, 'SS592bdf2b1bd5a', 'History', 0), (22, 'SS592bdf2b1bd5a', 'English', 0), (23, 'SS592bdf2b1bd5a', 'Chemistry', 0), (24, 'SS592bdf2b1bd5a', 'Geography', 0), (25, 'PS599d3bafb3716', 'Mathematics', 0), (26, 'PS599d3bafb3716', 'Biology', 0), (27, 'PS599d3bafb3716', 'Civics', 0), (28, 'PS599d3bafb3716', 'Kiswahili', 0), (29, 'SS599d3a30af675', 'Mathematics', 0), (30, 'SS599d3a30af675', 'Physics', 0), (31, 'SS592bdf2b1bd5a', 'Agriculture', 0), (32, 'SS59c4c8e9a8b95', 'PHYSICS', 0), (33, 'SS59c4c8e9a8b95', 'ADVANCED MATHEMATICS', 0), (34, 'SS59c4c8e9a8b95', 'CHEMISTRY', 0), (35, 'SS59c4c8e9a8b95', 'BIOLOGY', 0), (36, 'SS59c4c8e9a8b95', 'GEOGRAPHY', 0), (37, 'SS59c4c8e9a8b95', 'BASIC APPLIED MATHEMATICS', 0), (38, 'SS59c4c8e9a8b95', 'GENERAL STUDY', 1), (39, 'SS59c4c8e9a8b95', 'KISWAHILI', 0), (40, 'SS59c4c8e9a8b95', 'HISTORY', 0), (41, 'SS59c4c8e9a8b95', 'COMMERCE', 0), (42, 'SS59c4c8e9a8b95', 'ACCOUNTANCY', 0), (43, 'SS59c4c8e9a8b95', 'ECONOMICS', 0), (44, 'SS59c4c8e9a8b95', 'ENGLISH ', 0), (45, 'SS59c4c8e9a8b95', 'GENERAL STUDIES', 0); -- -------------------------------------------------------- -- -- Table structure for table `grade_settings` -- CREATE TABLE IF NOT EXISTS `grade_settings` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `students_type` varchar(10) NOT NULL, `start_mark` int(100) NOT NULL, `end_mark` int(100) NOT NULL, `grade` varchar(10) NOT NULL, PRIMARY KEY (`id`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ; -- -- Dumping data for table `grade_settings` -- INSERT INTO `grade_settings` (`id`, `school_id`, `students_type`, `start_mark`, `end_mark`, `grade`) VALUES (18, 'P5926c0b8c9e00', 'P', 0, 20, 'F'), (19, 'P5926c0b8c9e00', 'P', 21, 40, 'D'), (20, 'P5926c0b8c9e00', 'P', 41, 60, 'C'), (21, 'P5926c0b8c9e00', 'P', 61, 80, 'B'), (22, 'P5926c0b8c9e00', 'P', 81, 100, 'A'), (28, 'SS592bdf2b1bd5a', 'O', 0, 20, 'F'), (29, 'SS592bdf2b1bd5a', 'O', 21, 40, 'D'), (30, 'SS592bdf2b1bd5a', 'O', 41, 60, 'C'), (31, 'SS592bdf2b1bd5a', 'O', 61, 80, 'B'), (32, 'SS592bdf2b1bd5a', 'O', 81, 100, 'A'), (41, 'SS592bdf2b1bd5a', 'A', 0, 34, 'F'), (42, 'SS592bdf2b1bd5a', 'A', 35, 39, 'S'), (43, 'SS592bdf2b1bd5a', 'A', 40, 49, 'E'), (45, 'SS59c4c8e9a8b95', 'A', 0, 34, 'F'), (46, 'SS59c4c8e9a8b95', 'A', 35, 39, 'S'), (47, 'SS59c4c8e9a8b95', 'A', 40, 49, 'E'), (48, 'SS59c4c8e9a8b95', 'A', 50, 59, 'D'), (49, 'SS59c4c8e9a8b95', 'A', 60, 69, 'C'), (50, 'SS59c4c8e9a8b95', 'A', 70, 79, 'B'), (51, 'SS59c4c8e9a8b95', 'A', 80, 100, 'A'); -- -------------------------------------------------------- -- -- Table structure for table `grading_method` -- CREATE TABLE IF NOT EXISTS `grading_method` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `students_type` varchar(10) NOT NULL, `grading` varchar(100) NOT NULL, PRIMARY KEY (`id`), KEY `school_id` (`school_id`), KEY `school_id_2` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ; -- -- Dumping data for table `grading_method` -- INSERT INTO `grading_method` (`id`, `school_id`, `students_type`, `grading`) VALUES (10, 'P5926c0b8c9e00', 'N', 'Average'), (11, 'P5926c0b8c9e00', 'P', 'Average'), (12, 'PS599d3bafb3716', 'N', 'Average'), (13, 'PS599d3bafb3716', 'P', 'Average'), (14, 'SS599d3a30af675', 'O', 'Average'), (15, 'SS599d3a30af675', 'A', 'Average'), (16, 'SS592bdf2b1bd5a', 'O', 'Average'), (17, 'SS592bdf2b1bd5a', 'A', 'Division'), (18, 'SS59c4c8e9a8b95', 'A', 'Average'); -- -------------------------------------------------------- -- -- Table structure for table `groups` -- CREATE TABLE IF NOT EXISTS `groups` ( `group_id` int(11) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, PRIMARY KEY (`group_id`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `groups` -- INSERT INTO `groups` (`group_id`, `school_id`, `name`) VALUES (1, 'P5926c0b8c9e00', 'Aman'), (2, '', 'Winter'), (3, 'P5926c0b8c9e00', 'Peace'), (4, 'P5926c0b8c9e00', 'G'); -- -------------------------------------------------------- -- -- Table structure for table `group_members` -- CREATE TABLE IF NOT EXISTS `group_members` ( `id` int(255) NOT NULL AUTO_INCREMENT, `group_id` int(11) NOT NULL, `school_id` varchar(255) NOT NULL, `reg_number` varchar(255) NOT NULL, `academic_year` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `reg_number` (`reg_number`), KEY `group_id` (`group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ; -- -- Dumping data for table `group_members` -- INSERT INTO `group_members` (`id`, `group_id`, `school_id`, `reg_number`, `academic_year`) VALUES (33, 1, '', 'P.KIS.2017.001', '2017'), (34, 1, '', 'P.KIS.2017.004', '2017'), (35, 3, '', 'P.KIS.2017.001', '2017'), (36, 3, 'P5926c0b8c9e00', 'P.KIS.2017.001', '2017'), (37, 3, '', 'P.KIS.2017.003', '2017'), (38, 4, '', 'P.KIS.2017.001', '2017'), (39, 4, '', 'P.KIS.2017.001', '2017'), (40, 4, '', 'P.KIS.2017.003', '2017'), (41, 4, '', 'P.KIS.2017.003', '2017'), (42, 4, '', 'P.KIS.2017.004', '2017'); -- -------------------------------------------------------- -- -- Table structure for table `income` -- CREATE TABLE IF NOT EXISTS `income` ( `income_id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, PRIMARY KEY (`income_id`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Dumping data for table `income` -- INSERT INTO `income` (`income_id`, `school_id`, `name`) VALUES (3, 'P5926c0b8c9e00', 'School Duka'), (4, 'P5926c0b8c9e00', 'Kilimo cha shule'), (5, 'SS592bdf2b1bd5a', 'school duka'), (6, 'PS599d3bafb3716', 'School Duka'), (7, 'SS59c4c8e9a8b95', 'Kilimo'); -- -------------------------------------------------------- -- -- Table structure for table `instruction_reports` -- CREATE TABLE IF NOT EXISTS `instruction_reports` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `students_type` varchar(10) NOT NULL, `class_level` varchar(10) NOT NULL, `instructions` longtext NOT NULL, `term` varchar(255) NOT NULL, `academic_year` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; -- -- Dumping data for table `instruction_reports` -- INSERT INTO `instruction_reports` (`id`, `school_id`, `students_type`, `class_level`, `instructions`, `term`, `academic_year`) VALUES (1, 'P5926c0b8c9e00', 'N', '1', 'ddddd', '', ''), (2, 'P5926c0b8c9e00', 'N', '2', 'juma hamisi\r\n', '', ''), (3, 'P5926c0b8c9e00', 'P', '2', 'dhdhdh', '', ''), (4, 'P5926c0b8c9e00', 'P', '1', 'yttjtyjtyg', '', ''), (5, 'PS599d3bafb3716', 'N', '1', 'Come with school fees', '', ''), (7, 'SS592bdf2b1bd5a', 'O', '1', 'Hello', 'Term 1', '2017'), (8, 'P5926c0b8c9e00', 'N', '2', 'aman juma', 'Term 1', '2017'), (10, 'SS592bdf2b1bd5a', 'O', '1', 'ertert', 'Term 1', '2017'), (11, 'SS592bdf2b1bd5a', 'O', '1', 'tget', 'Term 1', '2017'); -- -------------------------------------------------------- -- -- Table structure for table `payers` -- CREATE TABLE IF NOT EXISTS `payers` ( `payer_id` int(255) NOT NULL AUTO_INCREMENT, `payment_id` varchar(255) NOT NULL, `school_id` varchar(255) NOT NULL, `class_level` varchar(10) NOT NULL, `students_type` varchar(100) NOT NULL, `schoolars_type` varchar(100) NOT NULL, `installments` int(11) NOT NULL, `payment_time` varchar(100) NOT NULL, PRIMARY KEY (`payer_id`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=152 ; -- -- Dumping data for table `payers` -- INSERT INTO `payers` (`payer_id`, `payment_id`, `school_id`, `class_level`, `students_type`, `schoolars_type`, `installments`, `payment_time`) VALUES (134, '16', 'P5926c0b8c9e00', '1', 'P', 'D', 4, 'Continously'), (135, '16', 'P5926c0b8c9e00', '1', 'P', 'B', 4, 'Continously'), (136, '17', 'P5926c0b8c9e00', '1', 'P', 'D', 4, 'Continously'), (137, '18', 'P5926c0b8c9e00', '1', 'P', 'D', 4, 'Continously'), (138, '19', 'P5926c0b8c9e00', '1', 'P', '2', 1, 'Continously'), (139, '20', 'P5926c0b8c9e00', '1', 'P', '2', 1, 'Once'), (140, '21', 'P5926c0b8c9e00', '1', 'P', '2', 1, 'Once'), (141, '22', 'P5926c0b8c9e00', '1', 'P', '2', 1, 'Once'), (142, '16', 'P5926c0b8c9e00', '1', 'N', '2', 4, 'Continously'), (143, '23', 'SS592bdf2b1bd5a', '1', 'O', 'D', 4, 'Continously'), (144, '23', 'SS592bdf2b1bd5a', '1', 'O', 'B', 4, 'Continously'), (145, '24', 'SS592bdf2b1bd5a', '1', 'O', '2', 1, 'Continously'), (146, '25', 'SS592bdf2b1bd5a', '1', 'O', '2', 1, 'Continously'), (147, '27', 'SS592bdf2b1bd5a', '1', 'O', '2', 1, 'Once'), (148, '26', 'SS592bdf2b1bd5a', '1', 'O', 'D', 4, 'Continously'), (149, '28', 'SS592bdf2b1bd5a', '1', 'O', 'D', 4, 'Continously'), (150, '23', 'SS592bdf2b1bd5a', '5', 'A', 'D', 4, 'Continously'), (151, '30', 'SS59c4c8e9a8b95', '5', 'A', 'B', 2, 'Continously'); -- -------------------------------------------------------- -- -- Table structure for table `payments_type` -- CREATE TABLE IF NOT EXISTS `payments_type` ( `payment_id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `name` varchar(100) NOT NULL, PRIMARY KEY (`payment_id`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ; -- -- Dumping data for table `payments_type` -- INSERT INTO `payments_type` (`payment_id`, `school_id`, `name`) VALUES (16, 'P5926c0b8c9e00', 'School Fees'), (17, 'P5926c0b8c9e00', 'Transportation'), (18, 'P5926c0b8c9e00', 'Food'), (19, 'P5926c0b8c9e00', 'Health'), (20, 'P5926c0b8c9e00', 'Uniform'), (21, 'P5926c0b8c9e00', 'ID'), (22, 'P5926c0b8c9e00', 'Caution'), (23, 'SS592bdf2b1bd5a', 'School Fees'), (24, 'SS592bdf2b1bd5a', 'Health'), (25, 'SS592bdf2b1bd5a', 'ID'), (26, 'SS592bdf2b1bd5a', 'Transportation'), (27, 'SS592bdf2b1bd5a', 'Uniform'), (28, 'SS592bdf2b1bd5a', 'Food'), (29, 'SS592bdf2b1bd5a', 'school'), (30, 'SS59c4c8e9a8b95', 'School Fee'), (31, 'SS59c4c8e9a8b95', 'ID'); -- -------------------------------------------------------- -- -- Table structure for table `postpone_payments` -- CREATE TABLE IF NOT EXISTS `postpone_payments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `reg_number` varchar(255) NOT NULL, `month` varchar(255) NOT NULL, `date` varchar(255) NOT NULL, `amount` varchar(255) NOT NULL, `payment_type` varchar(255) NOT NULL, `year` varchar(255) NOT NULL, `category` varchar(255) NOT NULL, `mobile` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `reg_number` (`reg_number`), KEY `reg_number_2` (`reg_number`), KEY `school_id` (`school_id`), KEY `school_id_2` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ; -- -- Dumping data for table `postpone_payments` -- INSERT INTO `postpone_payments` (`id`, `school_id`, `reg_number`, `month`, `date`, `amount`, `payment_type`, `year`, `category`, `mobile`) VALUES (4, 'P5926c0b8c9e00', 'P.KIS.2017.003', '9', '09', '3000.00', '16', '2017', 'P', '(255) 888-888888'), (8, 'P5926c0b8c9e00', 'P.KIS.2017.003', '1', '4', '3000.00', '17', '2017', 'P', '(255) 666-666666'), (9, 'P5926c0b8c9e00', 'P.KIS.2017.005', '1', '7', '50000.00', '-- Select --', '2017', 'P', '(255) 666-666666'), (10, 'SS592bdf2b1bd5a', 'A.GRE.2017.004', '10', '12', '80000.00', '23', '2017', 'A', '(255) 888-888899'); -- -------------------------------------------------------- -- -- Table structure for table `pricing` -- CREATE TABLE IF NOT EXISTS `pricing` ( `id` int(11) NOT NULL AUTO_INCREMENT, `start` varchar(255) NOT NULL, `max_list` varchar(255) NOT NULL, `amount` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `pricing` -- INSERT INTO `pricing` (`id`, `start`, `max_list`, `amount`) VALUES (1, '1', '300', '600000'), (2, '301', '600', '900000'), (3, '601', '1000', '1200000'), (4, '1001', '100000', '1500000'); -- -------------------------------------------------------- -- -- Table structure for table `primary_months` -- CREATE TABLE IF NOT EXISTS `primary_months` ( `month_id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `term` varchar(100) NOT NULL, PRIMARY KEY (`month_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; -- -- Dumping data for table `primary_months` -- INSERT INTO `primary_months` (`month_id`, `name`, `term`) VALUES (1, 'January', '1'), (2, 'February', '1'), (3, 'March', '1'), (4, 'April', '1'), (5, 'May', '1'), (6, 'June', '1'), (7, 'July', '2'), (8, 'August', '2'), (9, 'September', '2'), (10, 'October', '2'), (11, 'November', '2'), (12, 'December', '2'); -- -------------------------------------------------------- -- -- Table structure for table `reduced_payments` -- CREATE TABLE IF NOT EXISTS `reduced_payments` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `reg_number` varchar(255) NOT NULL, `payment_id` varchar(255) NOT NULL, `amount` varchar(255) NOT NULL, `academic_year` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `reg_number` (`reg_number`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `reduced_payments` -- INSERT INTO `reduced_payments` (`id`, `school_id`, `reg_number`, `payment_id`, `amount`, `academic_year`) VALUES (1, 'P5926c0b8c9e00', 'P.KIS.2017.001', '16', '1000000.00', '2017'); -- -------------------------------------------------------- -- -- Table structure for table `register_fees` -- CREATE TABLE IF NOT EXISTS `register_fees` ( `fee_id` int(255) NOT NULL AUTO_INCREMENT, `payment_id` int(255) NOT NULL, `school_id` varchar(255) NOT NULL, `payer_id` int(255) NOT NULL, `academic_year` varchar(100) NOT NULL, `amount` varchar(255) NOT NULL, `amount_per_istallment` float NOT NULL, PRIMARY KEY (`fee_id`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ; -- -- Dumping data for table `register_fees` -- INSERT INTO `register_fees` (`fee_id`, `payment_id`, `school_id`, `payer_id`, `academic_year`, `amount`, `amount_per_istallment`) VALUES (23, 22, 'P5926c0b8c9e00', 141, '2017', '30000', 30000), (24, 18, 'P5926c0b8c9e00', 137, '2017', '400000', 100000), (25, 19, 'P5926c0b8c9e00', 138, '2017', '50000', 50000), (26, 21, 'P5926c0b8c9e00', 140, '2017', '5000', 5000), (27, 17, 'P5926c0b8c9e00', 136, '2017', '400000', 100000), (28, 16, 'P5926c0b8c9e00', 134, '2017', '700000', 175000), (29, 16, 'P5926c0b8c9e00', 135, '2017', '1600000', 400000), (30, 20, 'P5926c0b8c9e00', 139, '2017', '50000', 50000), (31, 16, 'P5926c0b8c9e00', 142, '2017', '1000000', 250000), (32, 23, 'SS592bdf2b1bd5a', 143, '2017', '800000', 200000), (33, 23, 'SS592bdf2b1bd5a', 144, '2017', '1200000', 300000), (34, 24, 'SS592bdf2b1bd5a', 145, '2017', '50000', 50000), (35, 25, 'SS592bdf2b1bd5a', 146, '2017', '5000', 5000), (36, 26, 'SS592bdf2b1bd5a', 148, '2017', '400000', 100000), (37, 27, 'SS592bdf2b1bd5a', 147, '2017', '50000', 50000), (38, 28, 'SS592bdf2b1bd5a', 149, '2017', '400000.00', 100000), (40, 23, 'SS592bdf2b1bd5a', 150, '2017-2018', '800000.00', 200000), (41, 30, 'SS59c4c8e9a8b95', 151, '2017-2018', '70000', 35000); -- -------------------------------------------------------- -- -- Table structure for table `revenue` -- CREATE TABLE IF NOT EXISTS `revenue` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `date` varchar(255) NOT NULL, `month` varchar(255) NOT NULL, `year` varchar(255) NOT NULL, `amount` varchar(255) NOT NULL, `income` varchar(255) NOT NULL, `issuer` varchar(255) NOT NULL, `issuer_title` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `school_id` (`school_id`), KEY `issuer` (`issuer`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ; -- -- Dumping data for table `revenue` -- INSERT INTO `revenue` (`id`, `school_id`, `date`, `month`, `year`, `amount`, `income`, `issuer`, `issuer_title`) VALUES (21, 'P5926c0b8c9e00', '07/30/2017', '07', '2017', '500000.00', '3', 'Aman Juma', 'Admin'), (22, 'P5926c0b8c9e00', '07/30/2017', '07', '2017', '50000.00', '3', 'Aman Juma', 'Admin'), (23, 'P5926c0b8c9e00', '08/09/2017', '08', '2017', '50000.00', '4', 'Aman Juma', 'Admin'), (24, 'P5926c0b8c9e00', '07/30/2017', '07', '2017', '50000.00', '4', 'Aman Juma', 'Admin'), (25, 'SS592bdf2b1bd5a', '07/31/2017', '07', '2017', '5000.00', '5', 'Aman Juma', 'Admin'), (26, 'SS592bdf2b1bd5a', '08/24/2017', '08', '2017', '5000888.00', '5', 'Aman Juma', 'Admin'); -- -------------------------------------------------------- -- -- Table structure for table `schools` -- CREATE TABLE IF NOT EXISTS `schools` ( `school_id` varchar(255) NOT NULL, `school_name` varchar(100) NOT NULL, `school_type` varchar(10) NOT NULL, `school_reg_number` varchar(100) NOT NULL, `school_email` varchar(100) NOT NULL, `school_mobile` varchar(50) NOT NULL, `school_address` varchar(50) NOT NULL, `school_location` varchar(50) NOT NULL, `country` varchar(50) NOT NULL, `school_website` varchar(100) NOT NULL, `school_logo` varchar(255) NOT NULL, `school_moto` varchar(255) NOT NULL, `full_name` varchar(100) NOT NULL, `password` varchar(255) NOT NULL, `password_recover` varchar(255) NOT NULL, `type` varchar(100) NOT NULL, `year_registered` varchar(255) NOT NULL, PRIMARY KEY (`school_id`), UNIQUE KEY `school_id` (`school_id`), UNIQUE KEY `school_reg_number` (`school_reg_number`), KEY `school_id_2` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `schools` -- INSERT INTO `schools` (`school_id`, `school_name`, `school_type`, `school_reg_number`, `school_email`, `school_mobile`, `school_address`, `school_location`, `country`, `school_website`, `school_logo`, `school_moto`, `full_name`, `password`, `password_recover`, `type`, `year_registered`) VALUES ('P5926c0b8c9e00', 'Kishimba Primary School', 'PS', '123', 'a@gmail.com', '(255) 759-199317', '234', 'Dodoma', 'Tanzania', 'www.afel.co.tz', '150262482329753_school_logo.png', 'Education for life', 'Aman Juma', '202cb962ac59075b964b07152d234b70', 'P5926c0b8c9e00', 'Admin', ''), ('P59273ac064ed3', 'Aman', 'PS', '1234', 'a@gmail.com', '(255) 759-199317', '12', 'dodoma', 'Tanzania', 'www.afel.co.tz', '150262052622409_school_logo.png', '', '', 'f06de1c7422ea9db5ba6dfdb7d9346dd', 'P59273ac064ed3', 'Admin', ''), ('P592745010f482', 'Aman', 'PS', '34444b', 'dd@gmail.com', '(255) 759-199317', '12', 'dodoma', 'Tanzania', 'www.afel.co.tz', '150262052622409_school_logo.png', '', '', '9e31c3068b5003e2888bf673c68ca791', 'P592745010f482', 'Admin', ''), ('P5927538f2ded4', 'Aman', 'PS', '34444c', 'a@gmail.com', '(255) 759-199317', '12', 'dodoma', 'Tanzania', 'www.afel.co.tz', '150262052622409_school_logo.png', '', 'Aman Juma', '624932c662913da7afec5511717ff4b3', 'P5927538f2ded4', 'Admin', ''), ('PS59899e83677f1', 'Aman', 'PS', '34444bdgbh', 'peace@gmail.com', '(255) 466-655557', 'P.O.BOX 23 ', 'DODOMA', 'Tanzania', '', '150262052622409_school_logo.png', 'Not set', 'Winter Lyatuu', 'f591fd7b4c6f77d9038fc0d948a011c3', 'PS59899e83677f1', 'Admin', ''), ('PS59899f16711e3', 'Aman', 'PS', '34444bdgbhfd', 'peace@gmail.com', '(255) 466-655557', 'P.O.BOX 23 ', 'DODOMA', 'Tanzania', '', '150262052622409_school_logo.png', 'Not set', 'Winter Lyatuu', '6c763d2c2b87efc7f03a3833129eb7c0', 'PS59899f16711e3', 'Admin', ''), ('PS598ac61e0b0d3', 'tyryr', 'PS', '1238', 'peace@gmail.com', '(255) 777-777777', 'P.O.BOX 23 ', 'DODOMA', 'Tanzania', 'www.afel.co.tz', '150262052622409_school_logo.png', 'Not set', 'Ammm', '316cc7856a3106cd575cb57f028b1a18', 'PS598ac61e0b0d3', 'Admin', '2017'), ('PS598c6cafb65f3', 'Arsenal primary school', 'PS', '123456', 'a@gmail.com', '(255) 759-555555', 'P.O.BOX 23 ', 'dodoma', 'Tanzania', 'www.afel.co.tz', '150262052622409_school_logo.png', 'Not set', 'Arsenal', '3d0c4eeaf59e875fd04b1de538b48dc8', 'PS598c6cafb65f3', 'Admin', '2017'), ('PS599d3bafb3716', 'Mwanza Primary School', 'PS', 'M123', 'peacejuma91@gmail.com', '(255) 759-199313', 'P.O.BOX 23 ', 'Mwanza', 'Tanzania', 'www.mwanza.ac.tz', '1503493700160772460_emmy.jpg', 'Education For Life', 'Fatuma Juma', '202cb962ac59075b964b07152d234b70', '123', 'Admin', '2017'), ('PS599d7977cab3a', 'Emmy Secondary School', 'PS', '123uuuu', 'a@gmail.com', '(255) 888-888888', 'P.O.BOX 23 ', 'Dodoma', 'Tanzania', '', 'Not set', 'Not set', 'Emmy', '16cc8b7a717d7c94c772f4d860a5cb1b', 'PS599d7977cab3a', 'Admin', '2017'), ('PS599d7be2ee8f7', 'Amanghjghjg', 'PS', '34444hhhh', 'a@gmail.com', '(255) 345-555555', 'P.O.BOX 23 ', 'dodoma', 'Tanzania', 'www.afel.co.tz', 'Not set', 'Not set', 'ghhgfh', '57e3ea345395a31c1296dc1402d7ab0b', 'PS599d7be2ee8f7', 'Admin', '2017'), ('SS592bdf2b1bd5a', 'Greenstar Secondary School', 'SS', '1235', 'greenstar@gmail.com', '(255) 759-199317', '2345', 'Dodoma', 'Tanzania', 'www.afel.co.tz', '1505721023786468987_school_logo.png', 'Education for life', 'Aman Juma', '202cb962ac59075b964b07152d234b70', 'SS592bdf2b1bd5a', 'Admin', ''), ('SS598abd149370b', 'Kwema Secondary School', 'SS', '1990', 'peacejuma91@gmail.com', '(255) 655-189317', '4463', 'Kahama', 'Tanzania', 'www.kwemaschool.ac.tz', '150262052622409_school_logo.png', 'Not set', 'Kingsley Kadidi', '17bd62693f9bbc115deca243095b70a9', 'SS598abd149370b', 'Admin', ''), ('SS599d255f6f311', 'babati secondary school', 'SS', '34444f', 'a@gmail.com', '(255) 666-666666', 'P.O.BOX 23 ', 'DODOMA', 'Tanzania', 'www.afel.co.tz', 'Not set', 'Not set', 'Aman Jumaaaa', '904f63f9541103502d3a3d1aff4cdda0', 'SS599d255f6f311', 'Admin', '2017'), ('SS599d3a30af675', 'Rungwe Secondary School', 'SS', 'R123', 'peacejuma91@gmail.com', '(255) 759-199312', 'P.O.BOX 23 ', 'Mbeya, Rungwe', 'Tanzania', 'www.rungwess.sc.tz', 'Not set', 'Not set', 'Michael Kongwa', '202cb962ac59075b964b07152d234b70', '123', 'Admin', '2017'), ('SS599d75367639f', 'Kahama Secondary school', 'SS', 'K123', 'peacejuma91@gmail.com', '(255) 759-199314', 'P.O.BOX 23 ', 'Kahama, Shinyanga', 'Tanzania', 'www.afel.co.tz', 'Not set', 'Not set', 'Winter Lyatuu', '2e76a5d2cd291607667f661684e5de82', 'SS599d75367639f', 'Admin', '2017'), ('SS599d77d57be2f', 'Aman SS', 'SS', '123A', 'a@gmail.com', '(255) 774-555555', 'P.O.BOX 23 ', 'dodoma', 'Tanzania', 'www.afel.co.tz', 'Not set', 'Not set', 'Aman Juma', 'e1b69e12574e1a7ae212e1cceaa45c13', 'SS599d77d57be2f', 'Admin', '2017'), ('SS59a555f414495', 'Test Secondary school', 'SS', '123R', 'a@gmail.com', '(255) 745-888888', 'P.O.BOX 23 ', 'dodoma', 'Tanzania', 'www.afel.co.tz', 'Not set', 'Not set', 'testing', 'cc8f1b262a2f6877e9781bf4471f4352', 'SS59a555f414495', 'Admin', '2017'), ('SS59a67f798b9f9', 'Nkuhungu Secondary School', 'SS', 's.1009', 'sc@gmail.com', '(255) 754-554253', '123 Dom', 'Chama', 'Tanzania', '', 'Not set', 'Not set', 'Gerald', '5b814e39ccfea7d9ce7d6a4aa24d8c2e', 'SS59a67f798b9f9', 'Admin', '2017'), ('SS59a680425aa8a', 'Nkuhungu A Secondary School', 'SS', 's.100', 'geraldallay@gmail.com', '(255) 783-500625', '123 Dom', 'Chama', 'Kenya', '', 'Not set', 'Not set', 'Gerald', '202cb962ac59075b964b07152d234b70', '123', 'Admin', '2017'), ('SS59c4c8e9a8b95', 'Bagamoyo Secondary School', 'SS', 'S.127', 'bagamoyosecondary@gmail.com', '(255) 758-480075', 'P.O.Box 42', 'Bagamoyo, Pwani', 'Tanzania', 'www.bagamoyo.sc.tz', '1506153923876294793_log.png', 'NIKAE IDUMU', 'Shemweta Bakari', 'c97de660c8b0a3f2f8ce81ed8d5defcf', 'demore1973', 'Admin', '2017'); -- -------------------------------------------------------- -- -- Table structure for table `school_payments_transactions` -- CREATE TABLE IF NOT EXISTS `school_payments_transactions` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) DEFAULT NULL, `year` varchar(255) NOT NULL, `amount` varchar(255) NOT NULL, `payment_method` varchar(255) NOT NULL, `transaction_id` varchar(255) NOT NULL, `mobile` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `date_paid` varchar(255) NOT NULL, `date_confirmed` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `school_id` (`school_id`), KEY `school_id_2` (`school_id`), KEY `school_id_3` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ; -- -- Dumping data for table `school_payments_transactions` -- INSERT INTO `school_payments_transactions` (`id`, `school_id`, `year`, `amount`, `payment_method`, `transaction_id`, `mobile`, `name`, `date_paid`, `date_confirmed`) VALUES (14, 'P5926c0b8c9e00', '2017', '500000.00', 'Voda', '123', '(255) 759-199317', 'Aman Juma', 'Thursday 10th of August 2017 ', 'Thursday 10th of August 2017 '), (15, 'SS592bdf2b1bd5a', '2017', '3000000.00', 'Voda', '12345', '(255) 759-199317', 'Aman Juma', 'Thursday 10th of August 2017 ', ''), (18, 'PS599d3bafb3716', '2017', '500000.00', 'Voda', 'M1234', '(255) 759-199317', '', '23/Aug/2017', 'Wednesday 23rd of August 2017'), (19, 'PS599d3bafb3716', '2017', '500000.00', 'Voda', 'c12', '(255) 759-199317', '', '23/Aug/2017', 'Wednesday 23rd of August 2017'), (20, 'PS599d3bafb3716', '2017', '2000000.00', 'Voda', 'c1', '(255) 759-199317', '', '23/Aug/2017', 'Wednesday 23rd of August 2017'), (21, 'SS59a680425aa8a', '2017', '5000000.00', 'Voda', 'g234', '(255) 783-500625', '', '30/Aug/2017', 'Wednesday 30th of August 2017'); -- -------------------------------------------------------- -- -- Table structure for table `school_pyaments_required` -- CREATE TABLE IF NOT EXISTS `school_pyaments_required` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `year` varchar(255) NOT NULL, `students` varchar(255) DEFAULT NULL, `amount` varchar(255) NOT NULL, `month_started` varchar(255) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; -- -- Dumping data for table `school_pyaments_required` -- INSERT INTO `school_pyaments_required` (`id`, `school_id`, `year`, `students`, `amount`, `month_started`, `status`) VALUES (1, 'P5926c0b8c9e00', '2017', '9', '600000', '08', 0), (2, 'SS592bdf2b1bd5a', '2017', '3', '600000', '08', 0), (3, 'SS599d255f6f311', '2017', '0', '0', '08', 0), (4, 'SS599d3a30af675', '2017', '0', '0', '08', 0), (5, 'PS599d3bafb3716', '2017', '0', '0', '08', 0), (6, 'SS599d75367639f', '2017', '0', '0', '08', 0), (7, 'SS599d77d57be2f', '2017', '0', '0', '08', 0), (8, 'PS599d7977cab3a', '2017', '0', '0', '08', 0), (9, 'PS599d7be2ee8f7', '2017', '0', '0', '08', 0), (10, 'SS59a555f414495', '2017', '0', '0', '08', 0), (11, 'SS59a67f798b9f9', '2017', '0', '0', '08', 0), (12, 'SS59a680425aa8a', '2017', '1', '700000', '08', 0), (13, 'SS59c4c8e9a8b95', '2017', '0', '0', '09', 0); -- -------------------------------------------------------- -- -- Table structure for table `secondary_months` -- CREATE TABLE IF NOT EXISTS `secondary_months` ( `month_id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `term` varchar(100) NOT NULL, PRIMARY KEY (`month_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; -- -- Dumping data for table `secondary_months` -- INSERT INTO `secondary_months` (`month_id`, `name`, `term`) VALUES (1, 'January', '1'), (2, 'February', '1'), (3, 'March', '1'), (4, 'April', '1'), (5, 'May', '1'), (6, 'June', '1'), (7, 'July', '2'), (8, 'August', '2'), (9, 'September', '2'), (10, 'October', '2'), (11, 'November', '2'), (12, 'December', '2'); -- -------------------------------------------------------- -- -- Table structure for table `sent_sms` -- CREATE TABLE IF NOT EXISTS `sent_sms` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `sms` longtext NOT NULL, `sms_to` varchar(100) NOT NULL, `date` varchar(255) NOT NULL, `month` varchar(50) NOT NULL, `year` varchar(255) NOT NULL, `reg_number` varchar(255) NOT NULL, `class_level` varchar(255) NOT NULL, `category` varchar(255) NOT NULL, `time_sent` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1223 ; -- -- Dumping data for table `sent_sms` -- INSERT INTO `sent_sms` (`id`, `school_id`, `sms`, `sms_to`, `date`, `month`, `year`, `reg_number`, `class_level`, `category`, `time_sent`) VALUES (1206, 'P5926c0b8c9e00', 'Afel', '255759999999', '06', '09', '2017', 'N.KIS.2017.002', '1', 'N', '2017-09-06 14:06:41'), (1207, 'P5926c0b8c9e00', 'Afel', '255777777777', '06', '09', '2017', 'P.KIS.2017.001', '1', 'P', '2017-09-06 14:09:02'), (1208, 'P5926c0b8c9e00', 'afel', '255759999999', '06', '09', '2017', 'N.KIS.2017.002', '1', 'N', '2017-09-06 15:09:15'), (1209, 'P5926c0b8c9e00', 'afel', '255777777777', '06', '09', '2017', 'P.KIS.2017.001', '1', 'P', '2017-09-06 15:13:35'), (1210, 'P5926c0b8c9e00', 'afel', '255777777777', '06', '09', '2017', 'P.KIS.2017.004', '1', 'P', '2017-09-06 15:13:35'), (1211, 'P5926c0b8c9e00', 'afel', '255777777777', '06', '09', '2017', 'P.KIS.2017.005', '1', 'P', '2017-09-06 15:13:35'), (1212, 'P5926c0b8c9e00', 'Afel', '255777777777', '07', '09', '2017', 'P.KIS.2017.001', '1', 'P', '2017-09-07 12:15:22'), (1213, 'P5926c0b8c9e00', 'afel', '255759999999', '07', '09', '2017', 'N.KIS.2017.002', '1', 'N', '2017-09-07 12:16:22'), (1214, 'P5926c0b8c9e00', 'afel', '255777777777', '07', '09', '2017', 'P.KIS.2017.001', '1', 'P', '2017-09-07 12:17:24'), (1215, 'P5926c0b8c9e00', 'afel', '255777777777', '07', '09', '2017', 'P.KIS.2017.004', '1', 'P', '2017-09-07 12:17:24'), (1216, 'P5926c0b8c9e00', 'afel', '255777777777', '07', '09', '2017', 'P.KIS.2017.005', '1', 'P', '2017-09-07 12:17:24'), (1217, 'P5926c0b8c9e00', 'Afel', '255759199317', '11', '09', '2017', 'P.KIS.2017.006', '1', 'P', '2017-09-11 05:49:31'), (1218, 'P5926c0b8c9e00', 'Afel', '255759199317', '11', '09', '2017', 'P.KIS.2017.006', '1', 'P', '2017-09-11 05:53:24'), (1219, 'P5926c0b8c9e00', 'Afel', '255759199317', '11', '09', '2017', 'P.KIS.2017.006', '1', 'P', '2017-09-11 05:56:18'), (1220, 'P5926c0b8c9e00', 'Afel', '255759199317', '11', '09', '2017', 'P.KIS.2017.006', '1', 'P', '2017-09-11 05:58:36'), (1221, 'P5926c0b8c9e00', 'Afel Technologies', '255759199317', '21', '09', '2017', 'P.KIS.2017.006', '1', 'P', '2017-09-21 07:53:43'), (1222, 'P5926c0b8c9e00', 'Bagamoyo Sec', '255759199317', '21', '09', '2017', 'P.KIS.2017.006', '1', 'P', '2017-09-21 10:10:17'); -- -------------------------------------------------------- -- -- Table structure for table `staffs` -- CREATE TABLE IF NOT EXISTS `staffs` ( `reg_number` varchar(255) NOT NULL, `school_id` varchar(255) NOT NULL, `type` varchar(100) NOT NULL, `category` varchar(100) NOT NULL, `title` varchar(100) NOT NULL, `full_name` varchar(100) NOT NULL, `education` varchar(100) NOT NULL, `skills` varchar(100) NOT NULL, `gender` varchar(100) NOT NULL, `mobile` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `registered_year` varchar(100) NOT NULL, `released_year` varchar(100) NOT NULL, `password` varchar(100) NOT NULL, `password_reset` varchar(100) NOT NULL, `status` int(10) NOT NULL, PRIMARY KEY (`reg_number`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `staffs` -- INSERT INTO `staffs` (`reg_number`, `school_id`, `type`, `category`, `title`, `full_name`, `education`, `skills`, `gender`, `mobile`, `email`, `registered_year`, `released_year`, `password`, `password_reset`, `status`) VALUES ('00759199317', 'P5926c0b8c9e00', 'User', 'Manager', 'Manager', '', '', '', '', '0759199317', 'peacejuma90@gmail.com', '2017', '', 'd41d8cd98f00b204e9800998ecf8427e', '', 0), ('0255756030', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Vicent Sosthenes Masinde', 'BED-Arts', 'History and General Studies', 'Male', '(255) 255-756030', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0333333333', 'SS592bdf2b1bd5a', 'User', 'Secretary', 'Secretary', 'y7u8768', 'jhj', '78iu78', 'Male', '(255) 333-333333', 'uuu@gmail.com', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0444444444', 'SS592bdf2b1bd5a', 'User', 'Accountant', 'Accountant', 'Aman Juma Testingddd', '8u7768576', '78iu78', 'Male', '(255) 444-444444', 'superuser@afel.co.tz', '2017', '--', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0555555555', 'SS592bdf2b1bd5a', 'User', 'Teacher', 'Teacher', 'Fatuma', '8u7768576', '78iu78', 'Male', '(255) 555-555555', 'amanjuma90@gmail.com', '2017', '', '202cb962ac59075b964b07152d234b70', '123', 0), ('0621097418', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Leonald Joel Gange', 'BSC-ED', 'Biology and Chemistry', 'Male', '(255) 621-097418', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0657044366', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Ukumbusho Kivelege', 'BSC-ED', 'ICT and Mathematics', 'Male', '(255) 657-044366', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0657555022', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Christina Kaaya', 'BEEM', 'Economics and Mathematics', 'Female', '(255) 657-555022', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0666666666', 'SS592bdf2b1bd5a', 'User', 'Manager', 'Manager', 'ythju', 'yjyuj', 'hh', 'Male', '(255) 666-666666', 'peacejuma91@gmail.com', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0674861081', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Alice Michael Kimaro', 'BED-COM', 'Commerce', 'Female', '(255) 674-861081', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0712000668', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Said Mkoga Athumani', 'MAED', 'History', 'Male', '(255) 712-000668', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0713136684', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Emmanuel Charles Nghambi', 'BSC-ED', 'Physics and Chemistry', 'Male', '(255) 713-136684', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0713405973', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Stevin Nathaniel Lugongo', 'BA-ED', 'GS and Economics', 'Male', '(255) 713-405973', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0713706454', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Mainda Abdallah Makwiro', 'BA-ED', 'Kiswahili and ADE', 'Female', '(255) 713-706454', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0713771222', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Furaha Samata Abdul', 'ADV DIPLOMA/PGDE', 'Accountancy and Economics', 'Female', '(255) 713-771222', 'furaha.mwaimu@yahoo.com', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0713792054', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Neema Mwaka Nelson', 'BA-ED', 'Kiswahili and English', 'Female', '(255) 713-792054', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0713991028', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Method Maghabi Laurent', 'BSC-ED', 'Biology ', 'Male', '(255) 713-991028', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0714017286', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Aldegunda Boniface Shayo', 'BED-ACE', 'General Studies', 'Male', '(255) 714-017286', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0714493921', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Violet Norbert Msuya', 'MEMA', 'Education and Mathematics', 'Male', '(255) 714-493921', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0714807791', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Mwanaid Sadik Khamis', 'BSC-ED', 'Biology and Chemistry', 'Female', '(255) 714-807791', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0716432070', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Shafii Swalehe', 'BSC-ED', 'Physics and Mathematics', 'Male', '(255) 716-432070', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0716441256', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Upendo Athumani Msangi', 'BA-ED', 'Geography and Economics', 'Female', '(255) 716-441256', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0717128580', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Caroline Ephraim Thomas', 'BA-ED', 'Geography and Linguistics', 'Female', '(255) 717-128580', 'caro_makere@yahoo.com', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0717222900', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Mbwana Abdurahman Kissinga', 'BA-ED', 'Commerce and Economics', 'Male', '(255) 717-222900', 'mbwana.abdulrahman@gmail.com', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0718463484', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Rose Alexander Sarwat', 'BA-ED', 'Political Science and Economics', 'Male', '(255) 718-463484', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0752348299', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Katarina Silayo Vallery', 'BSC-ED', 'Biology and Chemistry', 'Female', '(255) 752-348299', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0754462673', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Pastory Bisoma Hosea', 'BSC-ED', 'Biology and Chemistry', 'Male', '(255) 754-462673', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0754465897', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Frola Justus Msuya', 'MEME', 'Education and Mathematics', 'Female', '(255) 754-465897', 'msuyaflora@gmail.com', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0754605138', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Leoncia Henerco Kibani', 'BA-ED', 'Biology and Chemistry', 'Female', '(255) 754-605138', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0755759045', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Rose Mohamedi Mgaya', 'BA-ED', 'Kiswahili and English', 'Male', '(255) 755-759045', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0756247558', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Hosiana Kimaro Isack', 'BA-ED', 'Kiswahili and History', 'Female', '(255) 756-247558', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0756422800', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Christina John Mhagama', 'BEL', 'Kiswahili and English', 'Female', '(255) 756-422800', 'christinamhagama@yahoo.com', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0757114242', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Elias Siao Shafrael', 'BSC-ED', 'Biology and Chemistry', 'Male', '(255) 757-114242', 'siaoely@yahoo.com', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0757950422', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Boaz Mashambo', 'BED', 'Mathematics and ICT', 'Male', '(255) 757-950422', 'nikukundie@gmail.com', '2017', '', '202cb962ac59075b964b07152d234b70', '123', 0), ('0758199317', 'P5926c0b8c9e00', 'User', 'Manager', 'Manager', 'Aman Juma', 'BSc-IS', 'Management', 'Male', '(255) 758-199317', 'peacejuma90@gmail.com', '2017', '--', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0758732365', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'David Samson Mwaipaja', 'BA.ED', 'Geography and History', 'Male', '(255) 758-732365', 'mwaipajasamson@gmail.com', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0758912346', 'P5926c0b8c9e00', 'User', 'Secretary', 'Secretary', 'Rose Alex', 'BAED', 'Kiswahili', 'Male', '(255) 758-912346', 'peacejuma90@gmail.com', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0759139317', 'P5926c0b8c9e00', 'User', 'Teacher', 'Head', 'Winter Lyatuu', 'BSc-CE', 'Physics and Mathematics', 'Male', '(255) 759-139317', 'peacejuma90@gmail.com', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0759199312', 'P5926c0b8c9e00', 'User', 'Teacher', 'Academic', 'Gerald Simon', 'BSc-IS', 'Management', 'Male', '(255) 759-199312', 'peacejuma90@gmail.com', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0759661819', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Niponawe Joash Lutula', 'BA-ED', 'Political Science and Linguistics', 'Female', '(255) 759-661819', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0761993145', 'P5926c0b8c9e00', 'User', 'Teacher', 'Teacher', 'Peter Less', 'BSc-TE', 'Physics and Mathematics', 'Male', '(255) 761-993145', 'peacejuma90@gmail.com', '2017', '', '202cb962ac59075b964b07152d234b70', '123', 0), ('0762147542', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Redempta Merdad Mwenda', 'BA-ED', 'Political Science and General Studies', 'Female', '(255) 762-147542', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0762599355', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Joseph Luca Msemwa ', 'BED', 'Physics and Mathematics', 'Male', '(255) 762-599355', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0763910710', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Nicholaus Mpiri Zerubabery', 'BSC-ED', 'Physics and Mathematics', 'Male', '(255) 763-910710', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0765886504', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Servas Raphael Msuya', 'BA-ED', 'Geography and English', 'Male', '(255) 765-886504', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0766315038', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Grace Laurent Mgalla', 'BSC-ED', 'Biology and Chemistry', 'Female', '(255) 766-315038', 'millembe06@yahoo.com', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0766361804', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Seni Kanga Mahega', 'BSC-ED', 'Biology and Chemistry', 'Male', '(255) 766-361804', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0768912345', 'P5926c0b8c9e00', 'User', 'Accountant', 'Accountant', 'Felix Alex', 'BSc-Accounting', 'Book Keeping', 'Male', '(255) 768-912345', 'peacejuma90@gmail.com', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0768945779', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Hemed Selemani Kitwana', 'BA-ED', 'History and General Studies', 'Male', '(255) 768-945779', 'pembamed@yahoo.com', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0784627979', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Tunu Tumsifu Mligiliche', 'MAED', 'Geography and Education', 'Female', '(255) 784-627979', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0787148857', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Mwanila Pelezi Farahani', 'BA-ED', 'Geography and Linguistics', 'Female', '(255) 787-148857', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0787290333', 'SS59c4c8e9a8b95', 'User', 'Teacher', 'Teacher', 'Felista Yoram Massay', 'BA-ED', 'Kiswahili and History', 'Female', '(255) 787-290333', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0), ('0787996805', 'SS59c4c8e9a8b95', 'User', 'Accountant', 'Accountant', 'Blanka Mshiki Massawe', 'Advanced Diploma Accountancy', 'Accountancy', 'Female', '(255) 787-996805', '', '2017', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default', 0); -- -------------------------------------------------------- -- -- Table structure for table `streams` -- CREATE TABLE IF NOT EXISTS `streams` ( `id` int(11) NOT NULL AUTO_INCREMENT, `stream` varchar(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ; -- -- Dumping data for table `streams` -- INSERT INTO `streams` (`id`, `stream`) VALUES (1, 'A'), (2, 'B'), (3, 'C'), (4, 'D'), (5, 'E'), (6, 'F'), (7, 'G'), (8, 'H'), (9, 'I'), (10, 'J'), (11, 'K'), (12, 'L'), (13, 'M'), (14, 'N'), (15, 'O'), (16, 'P'), (17, 'Q'), (18, 'R'), (19, 'S'), (20, 'T'), (21, 'U'), (22, 'V'), (23, 'W'), (24, 'X'), (25, 'Y'), (26, 'Z'); -- -------------------------------------------------------- -- -- Table structure for table `stream_settings` -- CREATE TABLE IF NOT EXISTS `stream_settings` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `streams` char(10) NOT NULL, PRIMARY KEY (`id`), KEY `school_id` (`school_id`), KEY `school_id_2` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ; -- -- Dumping data for table `stream_settings` -- INSERT INTO `stream_settings` (`id`, `school_id`, `streams`) VALUES (11, 'P5926c0b8c9e00', 'A'), (12, 'P5926c0b8c9e00', 'B'), (13, 'P5926c0b8c9e00', 'C'), (14, 'SS592bdf2b1bd5a', 'A'), (15, 'SS592bdf2b1bd5a', 'B'), (16, 'SS592bdf2b1bd5a', 'C'), (18, 'PS599d3bafb3716', 'A'), (19, 'PS599d3bafb3716', 'B'), (20, 'SS599d3a30af675', 'A'), (21, 'SS599d3a30af675', 'B'), (22, 'P5926c0b8c9e00', 'D'), (23, 'SS592bdf2b1bd5a', 'D'); -- -------------------------------------------------------- -- -- Table structure for table `students` -- CREATE TABLE IF NOT EXISTS `students` ( `reg_number` varchar(255) NOT NULL, `school_id` varchar(255) NOT NULL, `full_name` varchar(255) DEFAULT NULL, `gender` varchar(255) DEFAULT NULL, `birth_day` varchar(255) DEFAULT NULL, `admission_year` varchar(255) NOT NULL, `class_admitted` varchar(255) NOT NULL, `admitted_from` varchar(255) NOT NULL, `living_place` varchar(255) DEFAULT NULL, `nationality` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `mobile` varchar(255) DEFAULT NULL, `category` varchar(255) NOT NULL, `admission_number` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `password_recover` varchar(255) NOT NULL, PRIMARY KEY (`reg_number`), KEY `class_admitted` (`class_admitted`), KEY `class_admitted_2` (`class_admitted`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `students` -- INSERT INTO `students` (`reg_number`, `school_id`, `full_name`, `gender`, `birth_day`, `admission_year`, `class_admitted`, `admitted_from`, `living_place`, `nationality`, `email`, `mobile`, `category`, `admission_number`, `password`, `password_recover`) VALUES ('A.BAG.2016.001', 'SS59c4c8e9a8b95', 'Abdallah H Mulla', 'M', '', '2017', '6', '', '', 'Tanzania', '', '', 'A', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('A.BAG.2016.002', 'SS59c4c8e9a8b95', 'ABDULAZIZ MENGI MWANDU', 'M', '', '2017', '6', '', '', 'Tanzania', '', '', 'A', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('A.BAG.2016.003', 'SS59c4c8e9a8b95', 'ALLY SAID MPONDA', 'M', '', '2017', '6', '', '', 'Tanzania', '', '', 'A', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('A.BAG.2017.001', 'SS59c4c8e9a8b95', 'Rehema Magembe', 'M', '2017-08-17', '2017', '5', 'Dar Secondary school', 'Dar', 'Tanzania', 're@gmail.com', '(255) 764-488777', 'A', '2020', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('A.GRE.2016.001', 'SS592bdf2b1bd5a', 'Winter Lyatuu', 'M', '2017-08-14', '2017', '6', '', 'DODOMA', 'Tanzania', '', '(255) 888-888888', 'A', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('A.GRE.2016.002', 'SS592bdf2b1bd5a', 'Rose Alex', 'M', '', '2017', '6', '', '', 'Tanzania', '', '(255) 666-666666', 'A', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('A.GRE.2017.001', 'SS592bdf2b1bd5a', 'Aman Juma', '', '', '2017', '5', 'Arusha', 'DODOMA', 'Tanzania', 'ceo@afel.co.tz', '(255) 878-888888', 'A', 't6yu675', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('A.GRE.2017.002', 'SS592bdf2b1bd5a', 'Gerald Simon', 'M', '', '2017', '5', '', '', 'Tanzania', '', '(255) 777-777777', 'A', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('A.GRE.2017.003', 'SS592bdf2b1bd5a', 'Amina Juma', 'F', '2017-04-02', '2017', '5', '', '', 'Tanzania', '', '(255) 999-999999', 'A', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('A.GRE.2017.004', 'SS592bdf2b1bd5a', 'Shemweta Juma', 'M', '2017-07-19', '2017', '5', 'Dar', 'Dar', 'Tanzania', 'p@gmail.com', '(255) 713-521455', 'A', 'sderr', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('N.KIS.2017.001', 'P5926c0b8c9e00', 'Aman Juma', 'M', '', '2017', '1', '', '', 'Tanzania', '', '', 'N', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('N.KIS.2017.002', 'P5926c0b8c9e00', 'Gerald Simon', 'M', '2016-01-10', '2017', '1', '', '', 'Tanzania', '', '(255) 759-999999', 'N', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('P.KIS.2017.001', 'P5926c0b8c9e00', 'Aman Juma', 'M', '', '2017', '1', '', 'DODOMA', 'Tanzania', '', '(255) 777-777777', 'P', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('P.KIS.2017.002', 'P5926c0b8c9e00', 'Winter Lyatuu', 'F', '', '2017', '1', '', '', 'Tanzania', '', '', 'P', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('P.KIS.2017.003', 'P5926c0b8c9e00', 'Gerald Simon', 'M', '', '2017', '1', '', '', 'Tanzania', '', '', 'P', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('P.KIS.2017.004', 'P5926c0b8c9e00', 'Peter Less', 'F', '2017-06-14', '2017', '1', 'gdhtyrt', 'DODOMA', 'Tanzania', '', '(255) 777-777777', 'P', 't6yu675', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('P.KIS.2017.005', 'P5926c0b8c9e00', 'Felix Alex', 'F', '', '2017', '1', '', '', 'Tanzania', '', '(255) 777-777777', 'P', '', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('P.KIS.2017.006', 'P5926c0b8c9e00', 'Aisha Seleman', 'F', '', '2017', '1', 'Dodoma primary', 'DODOMA', 'Tanzania', 'an@gmail.com', '(255) 759-199317', 'P', '123g', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('P.KIS.2017.007', 'P5926c0b8c9e00', 'Wema Sepetu', '', '11/10/1990', '2017', '1', 'Kahama secondary school', 'Dodoma', 'Tanzania', 'uuu@gmail.com', '(255) 324-444444', 'P', '12345x', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('S.GRE.2017.001', 'SS592bdf2b1bd5a', 'Amina Juma', 'F', '2017-08-14', '2017', '1', 'Arusha', 'DODOMA', 'Tanzania', 'peacejuma90@gmail.com', '(255) 777-777777', 'O', '123', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('S.GRE.2017.002', 'SS592bdf2b1bd5a', 'Fatuma Juma', 'M', '2017-08-22', '2017', '1', 'Arusha', 'DODOMA', 'Tanzania', 'ceo@afel.co.tz', '(255) 777-777777', 'O', '2345', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('S.GRE.2017.003', 'SS592bdf2b1bd5a', 'Gigy Money', 'F', '2017-08-07', '2017', '1', 'Arusha', 'DODOMA', 'Tanzania', 'peacejuma90@gmail.com', '(255) 657-899999', 'O', 't6yu675s', 'c21f969b5f03d33d43e04f8f136e7682', 'default'), ('S.NKU.2017.001', 'SS59a680425aa8a', 'Hamis Hussein', 'M', '1998-11-11', '2017', '1', '', 'dodoma', 'Tanzania', 'g@mail.com', '(255) 783-500625', 'O', '0012', 'c21f969b5f03d33d43e04f8f136e7682', 'default'); -- -------------------------------------------------------- -- -- Table structure for table `students_evaluation` -- CREATE TABLE IF NOT EXISTS `students_evaluation` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `reg_number` varchar(255) NOT NULL, `evaluation_id` int(255) NOT NULL, `grade` varchar(100) NOT NULL, `class_level` varchar(255) NOT NULL, `term` varchar(50) NOT NULL, `academic_year` varchar(100) NOT NULL, PRIMARY KEY (`id`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ; -- -- Dumping data for table `students_evaluation` -- INSERT INTO `students_evaluation` (`id`, `school_id`, `reg_number`, `evaluation_id`, `grade`, `class_level`, `term`, `academic_year`) VALUES (1, 'P5926c0b8c9e00', 'P.KIS.2017.001', 2, 'A', '1', '1', '2017'), (2, 'P5926c0b8c9e00', 'P.KIS.2017.001', 2, 'A', '1', '2', '2017'), (5, 'P5926c0b8c9e00', 'N.KIS.2017.001', 2, 'A', '1', '1', '2017'), (6, 'P5926c0b8c9e00', 'N.KIS.2017.001', 2, 'A', '1', '2', '2017'), (7, 'SS592bdf2b1bd5a', 'S.GRE.2017.001', 4, 'A', '1', '1', '2017'), (8, 'SS592bdf2b1bd5a', 'S.GRE.2017.002', 4, 'A', '1', '2', '2017'), (9, 'SS592bdf2b1bd5a', 'A.GRE.2017.001', 4, 'A', '5', '1', '2017-2018'), (10, 'SS592bdf2b1bd5a', 'A.GRE.2017.001', 4, 'A', '5', '2', '2017-2018'), (11, 'SS592bdf2b1bd5a', 'A.GRE.2016.001', 4, 'A', '6', '1', '2017-2018'), (12, 'SS592bdf2b1bd5a', 'A.GRE.2017.002', 4, 'A', '5', '1', '2017-2018'), (13, 'SS592bdf2b1bd5a', 'A.GRE.2016.001', 4, 'A', '6', '2', '2017-2018'), (14, 'SS592bdf2b1bd5a', 'A.GRE.2016.001', 4, 'A', '6', '1', '2017-2018'), (15, 'SS592bdf2b1bd5a', 'A.GRE.2016.002', 9, 'A', '6', '1', '2017-2018'), (16, 'SS59c4c8e9a8b95', 'A.BAG.2017.001', 11, 'A', '5', '1', '2017-2018'), (17, 'SS59c4c8e9a8b95', 'A.BAG.2016.002', 11, 'A', '6', '1', '2017-2018'), (18, 'SS59c4c8e9a8b95', 'A.BAG.2016.003', 11, 'A', '6', '1', '2017-2018'); -- -------------------------------------------------------- -- -- Table structure for table `students_settings` -- CREATE TABLE IF NOT EXISTS `students_settings` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `students_type` varchar(10) DEFAULT NULL, `schoolars_type` varchar(10) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `school_id_3` (`school_id`), KEY `school_id` (`school_id`), KEY `school_id_2` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Dumping data for table `students_settings` -- INSERT INTO `students_settings` (`id`, `school_id`, `students_type`, `schoolars_type`) VALUES (2, 'P5926c0b8c9e00', '2', '2'), (3, 'SS592bdf2b1bd5a', 'A', 'B'), (4, 'PS599d3bafb3716', '2', '2'), (5, 'SS599d3a30af675', '2', '2'), (6, 'SS59a680425aa8a', '2', '2'), (7, 'SS59c4c8e9a8b95', 'A', 'B'); -- -------------------------------------------------------- -- -- Table structure for table `subjects` -- CREATE TABLE IF NOT EXISTS `subjects` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `subject_id` varchar(255) NOT NULL, `class_level` varchar(11) NOT NULL, `stream` varchar(255) NOT NULL, `students_type` varchar(10) NOT NULL, PRIMARY KEY (`id`), KEY `subject_id` (`subject_id`), KEY `school_id` (`school_id`), KEY `subject_id_2` (`subject_id`), KEY `school_id_2` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=123 ; -- -- Dumping data for table `subjects` -- INSERT INTO `subjects` (`id`, `school_id`, `subject_id`, `class_level`, `stream`, `students_type`) VALUES (57, 'P5926c0b8c9e00', '3', '1', 'A', 'N'), (58, 'P5926c0b8c9e00', '4', '1', 'A', 'N'), (59, 'P5926c0b8c9e00', '7', '1', 'A', 'N'), (60, 'P5926c0b8c9e00', '8', '1', 'A', 'N'), (61, 'P5926c0b8c9e00', '9', '1', 'A', 'N'), (62, 'P5926c0b8c9e00', '10', '1', 'A', 'N'), (63, 'P5926c0b8c9e00', '11', '1', 'A', 'N'), (64, 'P5926c0b8c9e00', '12', '1', 'A', 'N'), (65, 'P5926c0b8c9e00', '13', '1', 'A', 'N'), (66, 'P5926c0b8c9e00', '14', '1', 'A', 'N'), (67, 'P5926c0b8c9e00', '15', '1', 'A', 'N'), (68, 'P5926c0b8c9e00', '16', '1', 'A', 'N'), (69, 'P5926c0b8c9e00', '3', '1', 'A', 'P'), (70, 'P5926c0b8c9e00', '4', '1', 'A', 'P'), (71, 'P5926c0b8c9e00', '7', '1', 'A', 'P'), (72, 'P5926c0b8c9e00', '8', '1', 'A', 'P'), (73, 'P5926c0b8c9e00', '9', '1', 'A', 'P'), (74, 'P5926c0b8c9e00', '10', '1', 'A', 'P'), (75, 'P5926c0b8c9e00', '11', '1', 'A', 'P'), (76, 'P5926c0b8c9e00', '12', '1', 'A', 'P'), (77, 'P5926c0b8c9e00', '13', '1', 'A', 'P'), (78, 'P5926c0b8c9e00', '14', '1', 'A', 'P'), (79, 'P5926c0b8c9e00', '15', '1', 'A', 'P'), (80, 'P5926c0b8c9e00', '16', '1', 'A', 'P'), (82, 'SS592bdf2b1bd5a', '17', '1', 'A', 'O'), (83, 'SS592bdf2b1bd5a', '18', '1', 'A', 'O'), (84, 'SS592bdf2b1bd5a', '19', '1', 'A', 'O'), (85, 'SS592bdf2b1bd5a', '20', '1', 'A', 'O'), (86, 'SS592bdf2b1bd5a', '21', '1', 'A', 'O'), (87, 'SS592bdf2b1bd5a', '22', '1', 'A', 'O'), (88, 'SS592bdf2b1bd5a', '23', '1', 'A', 'O'), (89, 'SS592bdf2b1bd5a', '24', '1', 'A', 'O'), (90, 'SS592bdf2b1bd5a', '31', '1', 'A', 'O'), (91, 'SS592bdf2b1bd5a', '5', '5', 'PCM', 'A'), (92, 'SS592bdf2b1bd5a', '19', '5', 'PCM', 'A'), (93, 'SS592bdf2b1bd5a', '23', '5', 'PCM', 'A'), (94, 'SS59c4c8e9a8b95', '32', '5', 'PCM', 'A'), (95, 'SS59c4c8e9a8b95', '33', '5', 'PCM', 'A'), (96, 'SS59c4c8e9a8b95', '34', '5', 'PCM', 'A'), (98, 'SS59c4c8e9a8b95', '37', '5', 'ECA', 'A'), (100, 'SS59c4c8e9a8b95', '42', '5', 'ECA', 'A'), (101, 'SS59c4c8e9a8b95', '43', '5', 'ECA', 'A'), (102, 'SS59c4c8e9a8b95', '37', '6', 'ECA', 'A'), (104, 'SS59c4c8e9a8b95', '41', '6', 'ECA', 'A'), (105, 'SS59c4c8e9a8b95', '42', '6', 'ECA', 'A'), (106, 'SS59c4c8e9a8b95', '43', '6', 'ECA', 'A'), (107, 'SS59c4c8e9a8b95', '34', '6', 'CBG', 'A'), (108, 'SS59c4c8e9a8b95', '35', '6', 'CBG', 'A'), (109, 'SS59c4c8e9a8b95', '36', '6', 'CBG', 'A'), (110, 'SS59c4c8e9a8b95', '40', '6', 'HKL', 'A'), (111, 'SS59c4c8e9a8b95', '44', '6', 'HKL', 'A'), (112, 'SS59c4c8e9a8b95', '40', '5', 'HKL', 'A'), (113, 'SS59c4c8e9a8b95', '39', '5', 'HKL', 'A'), (114, 'SS59c4c8e9a8b95', '39', '6', 'HKL', 'A'), (115, 'SS59c4c8e9a8b95', '41', '5', 'ECA', 'A'), (116, 'SS59c4c8e9a8b95', '44', '5', 'HKL', 'A'), (117, 'SS59c4c8e9a8b95', '36', '5', 'CBG', 'A'), (118, 'SS59c4c8e9a8b95', '32', '6', 'PCB', 'A'), (119, 'SS59c4c8e9a8b95', '33', '6', 'EGM', 'A'), (120, 'SS59c4c8e9a8b95', '35', '5', 'PCB', 'A'), (121, 'SS59c4c8e9a8b95', '45', '5', 'PCM', 'A'), (122, 'SS59c4c8e9a8b95', '45', '6', 'PCM', 'A'); -- -------------------------------------------------------- -- -- Table structure for table `subjects_assigned` -- CREATE TABLE IF NOT EXISTS `subjects_assigned` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `reg_number` varchar(255) NOT NULL, `subject_id` varchar(255) NOT NULL, `class_level` varchar(255) NOT NULL, `category` varchar(255) NOT NULL, `stream` varchar(255) NOT NULL, `academic_year` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `reg_number` (`reg_number`), KEY `subject_id` (`subject_id`), KEY `reg_number_2` (`reg_number`), KEY `reg_number_3` (`reg_number`), KEY `school_id` (`school_id`), KEY `reg_number_4` (`reg_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ; -- -- Dumping data for table `subjects_assigned` -- INSERT INTO `subjects_assigned` (`id`, `school_id`, `reg_number`, `subject_id`, `class_level`, `category`, `stream`, `academic_year`) VALUES (17, 'SS592bdf2b1bd5a', '0759199314', '19', '5', 'A', 'PCM', '2017-2018'), (18, 'SS592bdf2b1bd5a', '0759199314', '17', '1', 'O', 'A', '2017'), (19, 'P5926c0b8c9e00', '0759139317', '3', '1', 'N', 'A', '2017'), (20, 'P5926c0b8c9e00', '0761993145', '7', '1', 'N', 'A', '2017'), (22, 'SS59c4c8e9a8b95', '0757950422', '33', '5', 'A', 'PCM', '2017-2018'), (23, 'SS59c4c8e9a8b95', '0674861081', '41', '5', 'A', 'ECA', '2017-2018'), (24, 'SS59c4c8e9a8b95', '0758732365', '36', '6', 'A', 'CBG', '2017-2018'), (25, 'SS59c4c8e9a8b95', '0763910710', '32', '5', 'A', 'PCM', '2017-2018'), (26, 'SS59c4c8e9a8b95', '0713991028', '35', '5', 'A', 'PCB', '2017-2018'), (27, 'SS59c4c8e9a8b95', '0621097418', '34', '5', 'A', 'PCM', '2017-2018'), (28, 'SS59c4c8e9a8b95', '0713136684', '32', '6', 'A', 'PCB', '2017-2018'), (29, 'SS59c4c8e9a8b95', '0713706454', '39', '6', 'A', 'HKL', '2017-2018'), (30, 'SS59c4c8e9a8b95', '0757114242', '34', '6', 'A', 'CBG', '2017-2018'), (31, 'SS59c4c8e9a8b95', '0718463484', '43', '5', 'A', 'ECA', '2017-2018'), (32, 'SS59c4c8e9a8b95', '0716441256', '43', '6', 'A', 'ECA', '2017-2018'), (33, 'SS59c4c8e9a8b95', '0768945779', '40', '6', 'A', 'HKL', '2017-2018'), (34, 'SS59c4c8e9a8b95', '0712000668', '40', '5', 'A', 'HKL', '2017-2018'); -- -------------------------------------------------------- -- -- Table structure for table `subjects_calculations` -- CREATE TABLE IF NOT EXISTS `subjects_calculations` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `subject_id` varchar(255) NOT NULL, `class_level` varchar(11) NOT NULL, `stream` varchar(255) NOT NULL, `students_type` varchar(10) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `subject_id` (`subject_id`), KEY `school_id` (`school_id`), KEY `subject_id_2` (`subject_id`), KEY `school_id_2` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=117 ; -- -- Dumping data for table `subjects_calculations` -- INSERT INTO `subjects_calculations` (`id`, `school_id`, `subject_id`, `class_level`, `stream`, `students_type`, `status`) VALUES (80, 'P5926c0b8c9e00', '3', '1', 'A', 'N', 0), (81, 'P5926c0b8c9e00', '4', '1', 'A', 'N', 0), (82, 'P5926c0b8c9e00', '3', '1', 'A', 'P', 0), (83, 'P5926c0b8c9e00', '4', '1', 'A', 'P', 0), (84, 'P5926c0b8c9e00', '7', '1', 'A', 'P', 0), (85, 'P5926c0b8c9e00', '8', '1', 'A', 'P', 0), (86, 'P5926c0b8c9e00', '9', '1', 'A', 'P', 0), (87, 'P5926c0b8c9e00', '10', '1', 'A', 'P', 0), (88, 'P5926c0b8c9e00', '11', '1', 'A', 'P', 0), (89, 'P5926c0b8c9e00', '12', '1', 'A', 'P', 0), (90, 'P5926c0b8c9e00', '14', '1', 'A', 'P', 0), (91, 'P5926c0b8c9e00', '15', '1', 'A', 'P', 0), (93, 'SS592bdf2b1bd5a', '17', '1', 'B', 'O', 0), (94, 'SS592bdf2b1bd5a', '18', '1', 'B', 'O', 0), (95, 'SS592bdf2b1bd5a', '19', '1', 'B', 'O', 0), (96, 'SS592bdf2b1bd5a', '20', '1', 'B', 'O', 0), (97, 'SS592bdf2b1bd5a', '21', '1', 'B', 'O', 0), (98, 'SS592bdf2b1bd5a', '22', '1', 'B', 'O', 0), (99, 'SS592bdf2b1bd5a', '23', '1', 'B', 'O', 0), (100, 'SS592bdf2b1bd5a', '24', '1', 'B', 'O', 0), (101, 'SS592bdf2b1bd5a', '5', '3', 'B', 'O', 0), (102, 'SS592bdf2b1bd5a', '17', '3', 'B', 'O', 0), (103, 'SS592bdf2b1bd5a', '18', '3', 'B', 'O', 0), (104, 'SS592bdf2b1bd5a', '19', '3', 'B', 'O', 0), (105, 'SS592bdf2b1bd5a', '20', '3', 'B', 'O', 0), (106, 'SS592bdf2b1bd5a', '21', '3', 'B', 'O', 0), (107, 'SS592bdf2b1bd5a', '22', '3', 'B', 'O', 0), (108, 'SS592bdf2b1bd5a', '23', '3', 'B', 'O', 0), (109, 'SS592bdf2b1bd5a', '24', '3', 'B', 'O', 0), (111, 'SS592bdf2b1bd5a', '19', '5', 'PCM', 'A', 0), (112, 'SS592bdf2b1bd5a', '23', '5', 'PCM', 'A', 0), (113, 'SS59c4c8e9a8b95', '32', '5', 'PCM', 'A', 0), (114, 'SS59c4c8e9a8b95', '33', '5', 'PCM', 'A', 0), (115, 'SS59c4c8e9a8b95', '34', '5', 'PCM', 'A', 0); -- -------------------------------------------------------- -- -- Table structure for table `transactions` -- CREATE TABLE IF NOT EXISTS `transactions` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `reg_number` varchar(255) NOT NULL, `category` varchar(255) NOT NULL, `class_level` varchar(255) NOT NULL, `receipt_number` varchar(255) NOT NULL, `amount` varchar(255) NOT NULL, `month` varchar(255) NOT NULL, `month_deposited` varchar(255) NOT NULL, `paid_year` varchar(255) NOT NULL, `academic_year` varchar(255) NOT NULL, `date_inserted` varchar(255) NOT NULL, `payment_type` varchar(255) NOT NULL, `payment_method` varchar(255) NOT NULL, `bank` varchar(255) NOT NULL, `school_receipt` varchar(255) NOT NULL, `date_deposited` varchar(255) NOT NULL, `date_issued` varchar(255) NOT NULL, `issuer` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `reg_number` (`reg_number`), KEY `reg_number_2` (`reg_number`), KEY `reg_number_3` (`reg_number`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ; -- -- Dumping data for table `transactions` -- INSERT INTO `transactions` (`id`, `school_id`, `reg_number`, `category`, `class_level`, `receipt_number`, `amount`, `month`, `month_deposited`, `paid_year`, `academic_year`, `date_inserted`, `payment_type`, `payment_method`, `bank`, `school_receipt`, `date_deposited`, `date_issued`, `issuer`) VALUES (25, 'P5926c0b8c9e00', 'P.KIS.2017.001', 'P', '1', '', '50000.00', 'July', 'July', '2017', '2017', 'Monday 7th of August 2017 ', '16', 'Payslip', '2', 'R1502114893', '05/07/2017', '30/07/2017', '123'), (29, 'SS592bdf2b1bd5a', 'S.GRE.2017.001', 'O', '1', '', '50000.00', 'June', 'June', '2017', '2017', 'Thursday 17th of August 2017 ', '23', 'Payslip', '4', 'R1502954611', '05/06/2017', '05/06/2017', '1235'), (30, 'SS592bdf2b1bd5a', 'A.GRE.2017.003', 'A', '5', '', '50000.00', 'June', 'June', '2017', '2017-2018', 'Thursday 17th of August 2017 ', '23', 'Payslip', '4', 'R1502954749', '05/06/2017', '05/06/2017', '1235'), (31, 'P5926c0b8c9e00', 'P.KIS.2017.001', 'P', '1', '', '50000.00', 'August', 'August', '2017', '2017', 'Tuesday 22nd of August 2017 ', '19', 'Payslip', '2', 'R1503395535', '05/08/2017', '05/08/2017', '123'), (32, 'P5926c0b8c9e00', 'N.KIS.2017.002', 'N', '1', '', '5000.00', 'September', 'September', '2017', '2017', 'Monday 11th of September 2017 ', '16', 'Payslip', '3', 'R1505106769', '07/09/2017', '07/09/2017', '123'), (33, 'P5926c0b8c9e00', 'P.KIS.2017.001', 'P', '1', '', '50000.00', 'September', 'September', '2017', '2017', 'Tuesday 12th of September 2017 ', '16', 'Payslip', '2', 'R1505218797', '05/09/2017', '11/09/2017', '123'), (34, 'SS592bdf2b1bd5a', 'A.GRE.2017.003', 'A', '5', '', '6000.00', 'September', 'September', '2017', '2017-2018', 'Tuesday 19th of September 2017 ', '23', 'Payslip', '4', 'R1505799916', '07/09/2017', '07/09/2017', '1235'), (35, 'P5926c0b8c9e00', 'N.KIS.2017.002', 'N', '1', '', '5000.00', 'September', 'September', '2017', '2017', 'Tuesday 19th of September 2017 ', '16', 'Payslip', '2', 'R1505801334', '09/09/2017', '09/09/2017', '123'), (36, 'SS592bdf2b1bd5a', 'A.GRE.2017.003', 'A', '5', '', '70000.00', 'September', 'September', '2017', '2017-2018', 'Thursday 21st of September 2017 ', '23', 'Payslip', '4', 'R1505985726', '07/09/2017', '21/09/2017', '1235'), (37, 'SS592bdf2b1bd5a', 'A.GRE.2017.003', 'A', '5', '', '70000.00', 'July', 'September', '2017', '2017-2018', 'Thursday 21st of September 2017 ', '23', 'Payslip', '4', 'R1505985745', '07/09/2017', '21/07/2017', '1235'), (38, 'SS592bdf2b1bd5a', 'A.GRE.2017.003', 'A', '5', '', '700000', 'September', 'September', '2017', '2017-2018', 'Thursday 21st of September 2017 ', '23', 'Payslip', '4', 'R1505985791', '07/09/2017', '07/09/2017', '1235'); -- -------------------------------------------------------- -- -- Table structure for table `trial` -- CREATE TABLE IF NOT EXISTS `trial` ( `id` int(255) NOT NULL AUTO_INCREMENT, `school_id` varchar(255) NOT NULL, `year` varchar(255) NOT NULL, `start_date` varchar(255) DEFAULT NULL, `expiry_date` varchar(255) NOT NULL, `month_started` varchar(255) NOT NULL, `days` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `school_id` (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Dumping data for table `trial` -- INSERT INTO `trial` (`id`, `school_id`, `year`, `start_date`, `expiry_date`, `month_started`, `days`) VALUES (4, 'SS59a555f414495', '2017', '29-Aug-2017', '28-Sep-2017', '08', '30'), (5, 'SS59a67f798b9f9', '2017', '30-Aug-2017', '29-Sep-2017', '08', '30'), (6, 'SS59a680425aa8a', '2017', '20-Aug-2017', '29-Aug-2017', '08', '9'), (7, 'SS59c4c8e9a8b95', '2017', '22-Sep-2017', '22-Oct-2017', '09', '30'); -- -------------------------------------------------------- -- -- Table structure for table `trial_setting` -- CREATE TABLE IF NOT EXISTS `trial_setting` ( `id` int(11) NOT NULL AUTO_INCREMENT, `days` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `trial_setting` -- INSERT INTO `trial_setting` (`id`, `days`) VALUES (1, '30'); -- -- Constraints for dumped tables -- -- -- Constraints for table `access_levels` -- ALTER TABLE `access_levels` ADD CONSTRAINT `access_levels_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `assessment_settings` -- ALTER TABLE `assessment_settings` ADD CONSTRAINT `assessment_settings_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `banks` -- ALTER TABLE `banks` ADD CONSTRAINT `banks_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `ca` -- ALTER TABLE `ca` ADD CONSTRAINT `ca_ibfk_1` FOREIGN KEY (`reg_number`) REFERENCES `students` (`reg_number`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `ca_ibfk_2` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `classes` -- ALTER TABLE `classes` ADD CONSTRAINT `classes_ibfk_1` FOREIGN KEY (`reg_number`) REFERENCES `students` (`reg_number`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `classes_ibfk_2` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `class_teachers` -- ALTER TABLE `class_teachers` ADD CONSTRAINT `class_teachers_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `combinations` -- ALTER TABLE `combinations` ADD CONSTRAINT `combinations_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `evalution_remarks` -- ALTER TABLE `evalution_remarks` ADD CONSTRAINT `evalution_remarks_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `evalution_settings` -- ALTER TABLE `evalution_settings` ADD CONSTRAINT `evalution_settings_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `exam` -- ALTER TABLE `exam` ADD CONSTRAINT `exam_ibfk_1` FOREIGN KEY (`reg_number`) REFERENCES `students` (`reg_number`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `exam_ibfk_2` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `expenditures` -- ALTER TABLE `expenditures` ADD CONSTRAINT `expenditures_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `expenses` -- ALTER TABLE `expenses` ADD CONSTRAINT `expenses_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `general_subjects` -- ALTER TABLE `general_subjects` ADD CONSTRAINT `general_subjects_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `grade_settings` -- ALTER TABLE `grade_settings` ADD CONSTRAINT `grade_settings_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `grading_method` -- ALTER TABLE `grading_method` ADD CONSTRAINT `grading_method_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `income` -- ALTER TABLE `income` ADD CONSTRAINT `income_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `instruction_reports` -- ALTER TABLE `instruction_reports` ADD CONSTRAINT `instruction_reports_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `payers` -- ALTER TABLE `payers` ADD CONSTRAINT `payers_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `payments_type` -- ALTER TABLE `payments_type` ADD CONSTRAINT `payments_type_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `postpone_payments` -- ALTER TABLE `postpone_payments` ADD CONSTRAINT `postpone_payments_ibfk_1` FOREIGN KEY (`reg_number`) REFERENCES `students` (`reg_number`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `postpone_payments_ibfk_2` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `reduced_payments` -- ALTER TABLE `reduced_payments` ADD CONSTRAINT `reduced_payments_ibfk_1` FOREIGN KEY (`reg_number`) REFERENCES `students` (`reg_number`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `reduced_payments_ibfk_2` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `register_fees` -- ALTER TABLE `register_fees` ADD CONSTRAINT `register_fees_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `revenue` -- ALTER TABLE `revenue` ADD CONSTRAINT `revenue_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `school_pyaments_required` -- ALTER TABLE `school_pyaments_required` ADD CONSTRAINT `school_pyaments_required_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `staffs` -- ALTER TABLE `staffs` ADD CONSTRAINT `staffs_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `stream_settings` -- ALTER TABLE `stream_settings` ADD CONSTRAINT `stream_settings_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `students` -- ALTER TABLE `students` ADD CONSTRAINT `students_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `students_evaluation` -- ALTER TABLE `students_evaluation` ADD CONSTRAINT `students_evaluation_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `students_settings` -- ALTER TABLE `students_settings` ADD CONSTRAINT `students_settings_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `subjects` -- ALTER TABLE `subjects` ADD CONSTRAINT `subjects_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `subjects_calculations` -- ALTER TABLE `subjects_calculations` ADD CONSTRAINT `subjects_calculations_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `transactions` -- ALTER TABLE `transactions` ADD CONSTRAINT `transactions_ibfk_1` FOREIGN KEY (`reg_number`) REFERENCES `students` (`reg_number`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `transactions_ibfk_2` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `trial` -- ALTER TABLE `trial` ADD CONSTRAINT `trial` FOREIGN KEY (`school_id`) REFERENCES `schools` (`school_id`) ON DELETE CASCADE ON UPDATE CASCADE; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;