-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jan 31, 2023 at 01:15 PM
-- Server version: 8.0.31
-- PHP Version: 7.4.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;

--
-- Database: `melsoftschooless_melsoftessential`
--

-- --------------------------------------------------------

--
-- Table structure for table `accummdeprec`
--

CREATE TABLE `accummdeprec` (
  `id` int NOT NULL,
  `accummdeprec` varchar(200) NOT NULL,
  `description` varchar(300) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `accummdeprec`
--

INSERT INTO `accummdeprec` (`id`, `accummdeprec`, `description`, `active`) VALUES
(1, 'PP', 'PP', 1);

-- --------------------------------------------------------

--
-- Table structure for table `allergies`
--

CREATE TABLE `allergies` (
  `id` int NOT NULL,
  `allergies` varchar(200) NOT NULL,
  `description` varchar(300) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `allergies`
--

INSERT INTO `allergies` (`id`, `allergies`, `description`, `active`) VALUES
(1, 'ashma', 'ashmac', 1);

-- --------------------------------------------------------

--
-- Table structure for table `assets`
--

CREATE TABLE `assets` (
  `id` int NOT NULL,
  `date_captured` varchar(60) NOT NULL,
  `asset_code` varchar(100) NOT NULL,
  `description` varchar(200) NOT NULL,
  `asset_type` varchar(100) NOT NULL,
  `master_asset` varchar(200) NOT NULL,
  `units_num` varchar(100) NOT NULL,
  `serial_num` varchar(20) NOT NULL,
  `asset_type2` varchar(200) NOT NULL,
  `department` varchar(200) NOT NULL,
  `employee` varchar(100) NOT NULL,
  `supplier` varchar(100) NOT NULL,
  `capex_order` varchar(100) NOT NULL,
  `purchase_price` varchar(40) NOT NULL,
  `insured_value` varchar(40) NOT NULL,
  `scrap_value` varchar(40) NOT NULL,
  `revaluation` varchar(100) NOT NULL,
  `purchase_date` varchar(60) NOT NULL,
  `replacement_date` varchar(60) NOT NULL,
  `replacement_cost` varchar(200) NOT NULL,
  `base_cost` varchar(200) NOT NULL,
  `roll_over_relief` varchar(200) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `assets`
--

INSERT INTO `assets` (`id`, `date_captured`, `asset_code`, `description`, `asset_type`, `master_asset`, `units_num`, `serial_num`, `asset_type2`, `department`, `employee`, `supplier`, `capex_order`, `purchase_price`, `insured_value`, `scrap_value`, `revaluation`, `purchase_date`, `replacement_date`, `replacement_cost`, `base_cost`, `roll_over_relief`, `active`) VALUES
(1, '02-11-2022 01:02:53pm', 'daniel', 'new', 'll', 'ii', 'iilllllllllllllll', 'lll', '', 'Accounts', 'DANIEL', 'kk', 'kk', '40000', 'kk', 'hh', 'kk', '2022-11-10', '2022-11-10', 'll', 'ii', '2022-11-30', 1);

-- --------------------------------------------------------

--
-- Table structure for table `assettypes`
--

CREATE TABLE `assettypes` (
  `id` int NOT NULL,
  `date_captured` varchar(50) NOT NULL,
  `asset_code` varchar(100) NOT NULL,
  `description` varchar(500) NOT NULL,
  `accum_dep` varchar(200) NOT NULL,
  `dep_expenses` varchar(200) NOT NULL,
  `revaluation` varchar(200) NOT NULL,
  `insurance` varchar(200) NOT NULL,
  `tax_dep` varchar(200) NOT NULL,
  `book_dep` varchar(200) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `assettypes`
--

INSERT INTO `assettypes` (`id`, `date_captured`, `asset_code`, `description`, `accum_dep`, `dep_expenses`, `revaluation`, `insurance`, `tax_dep`, `book_dep`, `active`) VALUES
(1, '27-10-2022 02:16:50pm', 'll', 'll', 'll', 'lll', 'lll', 'll', 'll', 'lll', 1);

-- --------------------------------------------------------

--
-- Table structure for table `attendence_type`
--

CREATE TABLE `attendence_type` (
  `id` int NOT NULL,
  `type` varchar(50) DEFAULT NULL,
  `key_value` varchar(50) NOT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `attendence_type`
--

INSERT INTO `attendence_type` (`id`, `type`, `key_value`, `is_active`, `updated_at`) VALUES
(1, 'Present', '<b class=\"text text-success\">P</b>', 'yes', '0000-00-00 00:00:00'),
(2, 'Late With Excuse', '<b class=\"text text-warning\">E</b>', 'no', '0000-00-00 00:00:00'),
(3, 'Late', '<b class=\"text text-warning\">L</b>', 'yes', '0000-00-00 00:00:00'),
(4, 'Absent', '<b class=\"text text-danger\">A</b>', 'yes', '0000-00-00 00:00:00'),
(5, 'Holiday', 'H', 'yes', '0000-00-00 00:00:00'),
(6, 'Half Day', '<b class=\"text text-warning\">F</b>', 'yes', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `bankrec`
--

CREATE TABLE `bankrec` (
  `id` int NOT NULL,
  `date_captured` varchar(20) NOT NULL,
  `cbb_dr` varchar(10) NOT NULL,
  `cbb_cr` varchar(10) NOT NULL,
  `tu_dr` varchar(10) NOT NULL,
  `tu_cr` varchar(10) NOT NULL,
  `rbb_dr` varchar(10) NOT NULL,
  `rbb_cr` varchar(10) NOT NULL,
  `diff_dr` varchar(10) NOT NULL,
  `diff_cr` varchar(10) NOT NULL,
  `active` int NOT NULL,
  `cashbook_id` varchar(20) NOT NULL,
  `cashbook` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `bankrec`
--

INSERT INTO `bankrec` (`id`, `date_captured`, `cbb_dr`, `cbb_cr`, `tu_dr`, `tu_cr`, `rbb_dr`, `rbb_cr`, `diff_dr`, `diff_cr`, `active`, `cashbook_id`, `cashbook`) VALUES
(7, '2022-12-28 12:11:52p', '178', '0', '122', '300', '178', '0', '0', '10', 1, '25', 'CBZ-ZWL');

-- --------------------------------------------------------

--
-- Table structure for table `bankrec_yrperiod`
--

CREATE TABLE `bankrec_yrperiod` (
  `id` int NOT NULL,
  `year` varchar(100) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `bankrec_yrperiod`
--

INSERT INTO `bankrec_yrperiod` (`id`, `year`, `active`) VALUES
(1, '2022', 1),
(2, '2023', 1),
(3, '2024', 1),
(4, '2025', 1),
(5, '2019', 1);

-- --------------------------------------------------------

--
-- Table structure for table `bank_rates`
--

CREATE TABLE `bank_rates` (
  `id` int NOT NULL,
  `date` varchar(50) NOT NULL,
  `foreign_currency` varchar(50) NOT NULL,
  `home_currency` varchar(50) NOT NULL,
  `foreign_rate` varchar(50) NOT NULL,
  `home_rate` varchar(50) NOT NULL,
  `description` varchar(50) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bank_rates`
--

INSERT INTO `bank_rates` (`id`, `date`, `foreign_currency`, `home_currency`, `foreign_rate`, `home_rate`, `description`, `active`) VALUES
(7, '26-10-2022 12:35:39pm', 'Zwl', 'USD', '695', '1', '1 dollar for 690', 1),
(8, '26-10-2022 12:41:39pm', 'Rand', 'USD', '160', '1', '160 ZAR TO 1USD', 1),
(9, '16-12-2022 03:11:02pm', 'RTGS', 'USD', '700', '1', '1 DOLLAR FOR 700', 1);

-- --------------------------------------------------------

--
-- Table structure for table `bank_rates_history`
--

CREATE TABLE `bank_rates_history` (
  `id` int NOT NULL,
  `date` varchar(50) NOT NULL,
  `foreign_currency` varchar(50) NOT NULL,
  `home_currency` varchar(50) NOT NULL,
  `foreign_rate` varchar(50) NOT NULL,
  `home_rate` varchar(50) NOT NULL,
  `description` varchar(50) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

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

CREATE TABLE `books` (
  `id` int NOT NULL,
  `book_title` varchar(100) NOT NULL,
  `book_no` varchar(50) NOT NULL,
  `isbn_no` varchar(100) NOT NULL,
  `subject` varchar(100) DEFAULT NULL,
  `rack_no` varchar(100) NOT NULL,
  `publish` varchar(100) DEFAULT NULL,
  `author` varchar(100) DEFAULT NULL,
  `qty` int DEFAULT NULL,
  `perunitcost` float(10,2) DEFAULT NULL,
  `postdate` date DEFAULT NULL,
  `description` text,
  `available` varchar(10) DEFAULT 'yes',
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `books` (`id`, `book_title`, `book_no`, `isbn_no`, `subject`, `rack_no`, `publish`, `author`, `qty`, `perunitcost`, `postdate`, `description`, `available`, `is_active`, `updated_at`) VALUES
(1, 'Heritage Studies', 's111t', 't1234', 'English', '12', 'kennedy', 'munayaradzi', 100, 20.00, '2022-11-24', 'heritage studies', 'yes', 'no', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `book_depreciation`
--

CREATE TABLE `book_depreciation` (
  `id` int NOT NULL,
  `date_captured` varchar(30) NOT NULL,
  `assetcode` varchar(100) NOT NULL,
  `purchasevalue` varchar(100) NOT NULL,
  `purchasedate` varchar(50) NOT NULL,
  `startdate` varchar(100) NOT NULL,
  `dpmethod` varchar(100) NOT NULL,
  `total` varchar(100) NOT NULL,
  `prioryears` varchar(100) NOT NULL,
  `currentyear` varchar(100) NOT NULL,
  `currentperiod` varchar(100) NOT NULL,
  `initial_allowance` varchar(100) NOT NULL,
  `residual_vale` varchar(100) NOT NULL,
  `impairements` varchar(100) NOT NULL,
  `nbv` varchar(100) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `book_depreciation`
--

INSERT INTO `book_depreciation` (`id`, `date_captured`, `assetcode`, `purchasevalue`, `purchasedate`, `startdate`, `dpmethod`, `total`, `prioryears`, `currentyear`, `currentperiod`, `initial_allowance`, `residual_vale`, `impairements`, `nbv`, `active`) VALUES
(24, '2022-11-23 03:20:30pm', 'daniel', '40000', '2022-11-10', '2022-11-22', 'pnm', '3240.75', '1296.3', '1296.3', '108.025', '0', '1111', '0', '0', 1);

-- --------------------------------------------------------

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

CREATE TABLE `book_issues` (
  `id` int UNSIGNED NOT NULL,
  `book_id` int DEFAULT NULL,
  `return_date` date DEFAULT NULL,
  `issue_date` date DEFAULT NULL,
  `is_returned` int DEFAULT '0',
  `member_id` int DEFAULT NULL,
  `is_active` varchar(10) NOT NULL DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `book_issues` (`id`, `book_id`, `return_date`, `issue_date`, `is_returned`, `member_id`, `is_active`) VALUES
(1, 1, '2022-12-01', '2022-11-24', 1, 1, 'no'),
(2, 1, '2022-11-25', '2022-11-24', 1, 1, 'no'),
(3, 1, '2022-11-25', '2022-11-25', 1, 1, 'no'),
(4, 1, '2022-11-25', '2022-11-25', 1, 1, 'no'),
(5, 1, '2022-11-27', '2022-11-25', 0, 1, 'no');

-- --------------------------------------------------------

--
-- Table structure for table `cashbook`
--

CREATE TABLE `cashbook` (
  `id` int NOT NULL,
  `date_captured` varchar(100) NOT NULL,
  `date` varchar(20) NOT NULL,
  `cashbook` varchar(100) NOT NULL,
  `description` varchar(400) NOT NULL,
  `account` varchar(200) NOT NULL,
  `module` varchar(100) NOT NULL,
  `receipt` varchar(100) NOT NULL,
  `currency` varchar(100) NOT NULL,
  `debit` varchar(100) NOT NULL,
  `credit` varchar(100) NOT NULL,
  `balance` varchar(100) NOT NULL,
  `active` int NOT NULL,
  `bankrec` varchar(10) NOT NULL,
  `mv_expense` varchar(100) NOT NULL,
  `gl_account` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `cashbook`
--

INSERT INTO `cashbook` (`id`, `date_captured`, `date`, `cashbook`, `description`, `account`, `module`, `receipt`, `currency`, `debit`, `credit`, `balance`, `active`, `bankrec`, `mv_expense`, `gl_account`) VALUES
(20, '2022-11-22 11:40:53am', '2022-11-21', 'CBZ-ZWL', 'gg', 'dany', 'Learner', '5444', '', '122', '0', '0', 1, '0', '', ''),
(21, '2022-11-22 12:29:20pm', '2022-11-21', 'CBZ-ZWL', 'correct', 'dany', 'Learner', '5444', '', '0', '300', '0', 1, '1', '', ''),
(22, '2022-11-22 12:51:35pm', '2022-11-22', 'CBZ-ZWL', 'ww', 'dany', 'Learner', '54444', '', '0', '100', '0', 1, '0', '', ''),
(23, '2022-12-06 11:54:34am', '2022-12-06', 'CBZ-USD', 'mmm', 'mm', 'Learner', 'mm', '', '0', '888', '-888', 1, '0', '', ''),
(25, '2023-01-06 02:56:24pm', '2023-01-06', 'CBZ-USD', 'MONEY', 'TINODAISHE', 'Supplier', 'INV0004', '', '0', '300', '0', 1, '0', 'H123W', 'Income');

-- --------------------------------------------------------

--
-- Table structure for table `cashbook_accounts`
--

CREATE TABLE `cashbook_accounts` (
  `id` int NOT NULL,
  `cashbook_accounts` varchar(200) NOT NULL,
  `currency` varchar(100) NOT NULL,
  `description` varchar(300) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `cashbook_accounts`
--

INSERT INTO `cashbook_accounts` (`id`, `cashbook_accounts`, `currency`, `description`, `active`) VALUES
(1, 'CBZ-ZWL', 'zwl', 'CBZ-RTGS ', 1),
(2, 'CBZ-USD', 'USD', 'CBZ-USD', 1);

-- --------------------------------------------------------

--
-- Table structure for table `cashbook_report`
--

CREATE TABLE `cashbook_report` (
  `id` int NOT NULL,
  `date_captured` varchar(100) NOT NULL,
  `cashbook` varchar(100) NOT NULL,
  `receipt` varchar(100) NOT NULL,
  `currency` varchar(100) NOT NULL,
  `debit` varchar(100) NOT NULL,
  `credit` varchar(100) NOT NULL,
  `balance` varchar(100) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `category`, `is_active`, `updated_at`) VALUES
(1, 'student', 'no', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `certificates`
--

CREATE TABLE `certificates` (
  `id` int NOT NULL,
  `certificate_name` varchar(100) NOT NULL,
  `certificate_text` text NOT NULL,
  `left_header` varchar(100) NOT NULL,
  `center_header` varchar(100) NOT NULL,
  `right_header` varchar(100) NOT NULL,
  `left_footer` varchar(100) NOT NULL,
  `right_footer` varchar(100) NOT NULL,
  `center_footer` varchar(100) NOT NULL,
  `background_image` varchar(100) NOT NULL,
  `created_at` varchar(100) NOT NULL,
  `updated_at` varchar(100) NOT NULL,
  `created_for` tinyint(1) NOT NULL COMMENT '1 = staff, 2 = students',
  `status` tinyint(1) NOT NULL,
  `header_height` int NOT NULL,
  `content_height` int NOT NULL,
  `footer_height` int NOT NULL,
  `content_width` int NOT NULL,
  `enable_student_image` tinyint(1) NOT NULL COMMENT '0=no,1=yes',
  `enable_image_height` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `certificates`
--

INSERT INTO `certificates` (`id`, `certificate_name`, `certificate_text`, `left_header`, `center_header`, `right_header`, `left_footer`, `right_footer`, `center_footer`, `background_image`, `created_at`, `updated_at`, `created_for`, `status`, `header_height`, `content_height`, `footer_height`, `content_width`, `enable_student_image`, `enable_image_height`) VALUES
(1, 'Sample Transfer Certificate', 'This is certify that <b>[name]</b> has born on [dob]  <br> and have following details [present_address] [guardian] [created_at] [admission_no] [roll_no] [class] [section] [gender] [admission_date] [category] [cast] [father_name] [mother_name] [religion] [email] [phone] .<br>We wish best of luck for future endeavors.', 'Reff. No.......................', '', 'Date: ___/____/_______', '.................................<br>Authority Sign', '.................................<br>Principal Sign', '.................................<br>Class Teacher Sign', 'sampletc12.png', '2018-09-05 21:47:33', '0000-00-00 00:00:00', 2, 1, 360, 400, 480, 810, 1, 230);

-- --------------------------------------------------------

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

CREATE TABLE `classes` (
  `id` int NOT NULL,
  `class` varchar(60) DEFAULT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` varchar(100) NOT NULL,
  `updated_at` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `classes` (`id`, `class`, `is_active`, `created_at`, `updated_at`) VALUES
(7, 'ECD A', 'no', '2022-11-24 08:04:40', '0000-00-00 00:00:00'),
(8, 'ECD B', 'no', '2022-11-24 08:04:48', '0000-00-00 00:00:00'),
(9, 'Grade 1', 'no', '2022-11-24 08:06:13', '0000-00-00 00:00:00'),
(10, 'Grade 2', 'no', '2022-11-24 08:07:17', '0000-00-00 00:00:00'),
(11, 'Grade 3', 'no', '2022-11-24 08:07:27', '0000-00-00 00:00:00'),
(12, 'Grade 4', 'no', '2022-11-24 08:07:38', '0000-00-00 00:00:00'),
(13, 'Grade 5', 'no', '2022-11-24 08:07:44', '0000-00-00 00:00:00'),
(14, 'Grade 6', 'no', '2022-11-24 08:07:52', '0000-00-00 00:00:00'),
(15, 'Grade 7', 'no', '2022-11-24 08:08:05', '0000-00-00 00:00:00');

-- --------------------------------------------------------

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

CREATE TABLE `class_sections` (
  `id` int NOT NULL,
  `class_id` int DEFAULT NULL,
  `section_id` int DEFAULT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` varchar(100) NOT NULL,
  `updated_at` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `class_sections` (`id`, `class_id`, `section_id`, `is_active`, `created_at`, `updated_at`) VALUES
(7, 7, 11, 'no', '2022-11-24 08:04:40', '0000-00-00 00:00:00'),
(8, 8, 12, 'no', '2022-11-24 08:04:48', '0000-00-00 00:00:00'),
(9, 9, 13, 'no', '2022-11-24 08:05:44', '0000-00-00 00:00:00'),
(10, 10, 11, 'no', '2022-11-24 08:07:17', '0000-00-00 00:00:00'),
(11, 11, 11, 'no', '2022-11-24 08:07:27', '0000-00-00 00:00:00'),
(12, 12, 11, 'no', '2022-11-24 08:07:38', '0000-00-00 00:00:00'),
(13, 13, 11, 'no', '2022-11-24 08:07:44', '0000-00-00 00:00:00'),
(14, 14, 11, 'no', '2022-11-24 08:07:52', '0000-00-00 00:00:00'),
(15, 15, 11, 'no', '2022-11-24 08:08:05', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `class_teacher`
--

CREATE TABLE `class_teacher` (
  `id` int NOT NULL,
  `class_id` int NOT NULL,
  `staff_id` int NOT NULL,
  `section_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `class_teacher`
--

INSERT INTO `class_teacher` (`id`, `class_id`, `staff_id`, `section_id`) VALUES
(5, 9, 3, 13);

-- --------------------------------------------------------

--
-- Table structure for table `complaint`
--

CREATE TABLE `complaint` (
  `id` int NOT NULL,
  `complaint_type` varchar(15) NOT NULL,
  `source` varchar(15) NOT NULL,
  `name` varchar(100) NOT NULL,
  `contact` varchar(15) NOT NULL,
  `email` varchar(200) NOT NULL,
  `date` date NOT NULL,
  `description` text NOT NULL,
  `action_taken` varchar(200) NOT NULL,
  `assigned` varchar(50) NOT NULL,
  `note` text NOT NULL,
  `image` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `complaint_type`
--

CREATE TABLE `complaint_type` (
  `id` int NOT NULL,
  `complaint_type` varchar(100) NOT NULL,
  `description` mediumtext NOT NULL,
  `created_at` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `contents`
--

CREATE TABLE `contents` (
  `id` int NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `is_public` varchar(10) DEFAULT 'No',
  `class_id` int DEFAULT NULL,
  `cls_sec_id` int NOT NULL,
  `file` varchar(250) DEFAULT NULL,
  `created_by` int NOT NULL,
  `note` text,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` varchar(100) NOT NULL,
  `updated_at` varchar(200) NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `contents`
--

INSERT INTO `contents` (`id`, `title`, `type`, `is_public`, `class_id`, `cls_sec_id`, `file`, `created_by`, `note`, `is_active`, `created_at`, `updated_at`, `date`) VALUES
(1, 'English Assignment', 'Assignments', 'No', 9, 9, 'uploads/school_content/material/1.docx', 0, 'English assignment', 'no', '2022-11-24 09:22:17', '', '2022-11-24');

-- --------------------------------------------------------

--
-- Table structure for table `content_for`
--

CREATE TABLE `content_for` (
  `id` int NOT NULL,
  `role` varchar(50) DEFAULT NULL,
  `content_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `content_for`
--

INSERT INTO `content_for` (`id`, `role`, `content_id`, `user_id`) VALUES
(1, 'student', 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `currency`
--

CREATE TABLE `currency` (
  `id` int NOT NULL,
  `currency` varchar(100) NOT NULL,
  `description` varchar(200) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `currency`
--

INSERT INTO `currency` (`id`, `currency`, `description`, `active`) VALUES
(1, 'USD', 'USD ', 1),
(3, 'Bond Note', 'Bond Note ', 1),
(4, 'Ecocash ', 'Ecocash', 1),
(5, 'Swipe ', 'Swipe', 1),
(6, 'RTGS', 'RTGS ', 1),
(7, 'RAND', 'RAND', 1);

-- --------------------------------------------------------

--
-- Table structure for table `currency_table`
--

CREATE TABLE `currency_table` (
  `id` int NOT NULL,
  `currencycode` varchar(50) NOT NULL,
  `date` varchar(50) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` varchar(400) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `currency_table`
--

INSERT INTO `currency_table` (`id`, `currencycode`, `date`, `name`, `description`, `active`) VALUES
(6, 'ZWL', '2022-10-26', 'ZWL-BOND NOTE', 'Zimbabwean Dollar', 1),
(7, 'RTGS', '2022-12-16', 'ZWL', 'ZWL-RTGS', 1);

-- --------------------------------------------------------

--
-- Table structure for table `customer`
--

CREATE TABLE `customer` (
  `id` int NOT NULL,
  `date_captured` varchar(30) NOT NULL,
  `supplier_id` varchar(10) NOT NULL,
  `name` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `mobile` varchar(15) NOT NULL,
  `email` varchar(100) NOT NULL,
  `currency` varchar(20) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `customer`
--

INSERT INTO `customer` (`id`, `date_captured`, `supplier_id`, `name`, `address`, `mobile`, `email`, `currency`, `active`) VALUES
(1, '2022-12-29 09:37:15am', 'S1234E', 'DANIEL', 'HARARE', '0774233045', 'daniel@gmail.com', 'USD', 1);

-- --------------------------------------------------------

--
-- Table structure for table `customer_invoice`
--

CREATE TABLE `customer_invoice` (
  `id` int NOT NULL,
  `gl_account` varchar(100) NOT NULL,
  `date_created` varchar(30) NOT NULL,
  `name` varchar(200) NOT NULL,
  `inv_date` varchar(30) NOT NULL,
  `inv_number` varchar(100) NOT NULL,
  `currency` varchar(100) NOT NULL,
  `description` varchar(300) NOT NULL,
  `quantity` varchar(100) NOT NULL,
  `price` varchar(100) NOT NULL,
  `discount` varchar(100) NOT NULL,
  `total_amount` varchar(100) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `customer_invoice`
--

INSERT INTO `customer_invoice` (`id`, `gl_account`, `date_created`, `name`, `inv_date`, `inv_number`, `currency`, `description`, `quantity`, `price`, `discount`, `total_amount`, `active`) VALUES
(17, '', '2023-01-03 03:27:54pm', 'DANIEL', '2023-01-04', 'INV0001', 'USD', 'bb', '45', '3', '1', '133.65', 1),
(18, '', '2023-01-04 03:35:51pm', 'DANIEL', '2023-01-09', 'INV0003', 'USD', 'mmm', '200', '1', '2', '196', 1),
(19, 'Income', '2023-01-04 03:37:49pm', 'DANIEL', '2023-01-10', 'INV0004', 'USD', 'oko', '300', '2', '12', '528', 1),
(20, 'Salarries', '2023-01-04 03:40:50pm', 'DANIEL', '2023-01-10', 'INV0005', 'USD', 'jj', '400', '3', '12', '1056', 1);

-- --------------------------------------------------------

--
-- Table structure for table `customer_receipt`
--

CREATE TABLE `customer_receipt` (
  `id` int NOT NULL,
  `gl_account` varchar(100) NOT NULL,
  `date_created` varchar(30) NOT NULL,
  `name` varchar(200) NOT NULL,
  `rec_date` varchar(30) NOT NULL,
  `rec_number` varchar(100) NOT NULL,
  `inv_number` varchar(100) NOT NULL,
  `currency` varchar(100) NOT NULL,
  `description` varchar(300) NOT NULL,
  `quantity` varchar(100) NOT NULL,
  `price` varchar(100) NOT NULL,
  `discount` varchar(100) NOT NULL,
  `total_amount` varchar(100) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `customer_receipt`
--

INSERT INTO `customer_receipt` (`id`, `gl_account`, `date_created`, `name`, `rec_date`, `rec_number`, `inv_number`, `currency`, `description`, `quantity`, `price`, `discount`, `total_amount`, `active`) VALUES
(8, '', '2023-01-03 03:30:47pm', 'DANIEL', '2023-01-10', 'REC0001', 'INV0001', 'USD', 'uui', '45', '2', '12', '79.2', 1);

-- --------------------------------------------------------

--
-- Table structure for table `customer_statement`
--

CREATE TABLE `customer_statement` (
  `id` int NOT NULL,
  `gl_account` varchar(100) NOT NULL,
  `customer` varchar(200) NOT NULL,
  `reference` varchar(200) NOT NULL,
  `description` varchar(200) NOT NULL,
  `currency` varchar(100) NOT NULL,
  `debit` varchar(100) NOT NULL,
  `credit` varchar(100) NOT NULL,
  `date` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `customer_statement`
--

INSERT INTO `customer_statement` (`id`, `gl_account`, `customer`, `reference`, `description`, `currency`, `debit`, `credit`, `date`) VALUES
(9, '', 'DANIEL', 'INV0001', 'bb', 'USD', '133.65', '0', '2023-01-04'),
(10, '', 'DANIEL', 'REC0002', 'uui', 'USD', '0', '79.2', '2023-01-10'),
(11, '', 'DANIEL', 'INV0002', 'mmm', 'USD', '196', '0', '2023-01-09'),
(12, 'Income', 'DANIEL', 'INV0003', 'oko', 'USD', '528', '0', '2023-01-10'),
(13, 'Salarries', 'DANIEL', 'INV0004', 'jj', 'USD', '1056', '0', '2023-01-10');

-- --------------------------------------------------------

--
-- Table structure for table `department`
--

CREATE TABLE `department` (
  `id` int NOT NULL,
  `department_name` varchar(200) NOT NULL,
  `is_active` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `department`
--

INSERT INTO `department` (`id`, `department_name`, `is_active`) VALUES
(2, 'Science Department', 'yes'),
(3, 'English Department', 'yes'),
(4, 'ICT Department', 'yes');

-- --------------------------------------------------------

--
-- Table structure for table `depreciationexpenses`
--

CREATE TABLE `depreciationexpenses` (
  `id` int NOT NULL,
  `depreciationexpenses` varchar(300) NOT NULL,
  `description` varchar(300) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `depreciationexpenses`
--

INSERT INTO `depreciationexpenses` (`id`, `depreciationexpenses`, `description`, `active`) VALUES
(1, 'YYY', 'YYY', 1);

-- --------------------------------------------------------

--
-- Table structure for table `depreciationmethods`
--

CREATE TABLE `depreciationmethods` (
  `id` int NOT NULL,
  `date_captured` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `percentage` varchar(20) NOT NULL,
  `no_of_years` int NOT NULL,
  `total_units` varchar(500) NOT NULL,
  `initial_percentage` varchar(20) NOT NULL,
  `depreciation_basis` varchar(200) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `depreciationmethods`
--

INSERT INTO `depreciationmethods` (`id`, `date_captured`, `description`, `percentage`, `no_of_years`, `total_units`, `initial_percentage`, `depreciation_basis`, `active`) VALUES
(1, '27-10-2022 01:15:59pm', 'pp', 'ppp', 0, 'ppp', 'ppp', 'pnm', 1);

-- --------------------------------------------------------

--
-- Table structure for table `dispatch_receive`
--

CREATE TABLE `dispatch_receive` (
  `id` int NOT NULL,
  `reference_no` varchar(50) NOT NULL,
  `to_title` varchar(100) NOT NULL,
  `address` varchar(500) NOT NULL,
  `note` varchar(500) NOT NULL,
  `from_title` varchar(200) NOT NULL,
  `date` varchar(20) NOT NULL,
  `image` varchar(100) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(255) NOT NULL,
  `type` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `email_config`
--

CREATE TABLE `email_config` (
  `id` int UNSIGNED NOT NULL,
  `email_type` varchar(100) DEFAULT NULL,
  `smtp_server` varchar(100) DEFAULT NULL,
  `smtp_port` varchar(100) DEFAULT NULL,
  `smtp_username` varchar(100) DEFAULT NULL,
  `smtp_password` varchar(100) DEFAULT NULL,
  `ssl_tls` varchar(100) DEFAULT NULL,
  `is_active` varchar(10) NOT NULL DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `email_config`
--

INSERT INTO `email_config` (`id`, `email_type`, `smtp_server`, `smtp_port`, `smtp_username`, `smtp_password`, `ssl_tls`, `is_active`) VALUES
(1, 'sendmail', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `enquiry`
--

CREATE TABLE `enquiry` (
  `id` int NOT NULL,
  `name` varchar(100) NOT NULL,
  `contact` varchar(20) NOT NULL,
  `address` mediumtext NOT NULL,
  `reference` varchar(20) NOT NULL,
  `date` date NOT NULL,
  `description` varchar(500) NOT NULL,
  `follow_up_date` date NOT NULL,
  `note` mediumtext NOT NULL,
  `source` varchar(50) NOT NULL,
  `email` varchar(50) DEFAULT NULL,
  `assigned` varchar(100) NOT NULL,
  `class` int NOT NULL,
  `no_of_child` varchar(11) DEFAULT NULL,
  `status` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `enquiry_type`
--

CREATE TABLE `enquiry_type` (
  `id` int NOT NULL,
  `enquiry_type` varchar(100) NOT NULL,
  `description` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` int NOT NULL,
  `event_title` varchar(200) NOT NULL,
  `event_description` varchar(300) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `event_type` varchar(100) NOT NULL,
  `event_color` varchar(200) NOT NULL,
  `event_for` varchar(100) NOT NULL,
  `role_id` int NOT NULL,
  `is_active` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `exams`
--

CREATE TABLE `exams` (
  `id` int NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `sesion_id` int NOT NULL,
  `note` text,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `exams`
--

INSERT INTO `exams` (`id`, `name`, `sesion_id`, `note`, `is_active`, `updated_at`) VALUES
(1, 'jjj', 0, 'jj', 'no', '');

-- --------------------------------------------------------

--
-- Table structure for table `exam_results`
--

CREATE TABLE `exam_results` (
  `id` int NOT NULL,
  `attendence` varchar(10) NOT NULL,
  `exam_schedule_id` int DEFAULT NULL,
  `student_id` int DEFAULT NULL,
  `get_marks` float(10,2) DEFAULT NULL,
  `note` text,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `exam_schedules`
--

CREATE TABLE `exam_schedules` (
  `id` int NOT NULL,
  `session_id` int NOT NULL,
  `exam_id` int DEFAULT NULL,
  `teacher_subject_id` int DEFAULT NULL,
  `date_of_exam` date DEFAULT NULL,
  `start_to` varchar(50) DEFAULT NULL,
  `end_from` varchar(50) DEFAULT NULL,
  `room_no` varchar(50) DEFAULT NULL,
  `full_marks` int DEFAULT NULL,
  `passing_marks` int DEFAULT NULL,
  `note` text,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `id` int NOT NULL,
  `exp_head_id` int DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `invoice_no` varchar(200) NOT NULL,
  `date` date DEFAULT NULL,
  `amount` float(10,2) DEFAULT NULL,
  `documents` varchar(255) DEFAULT NULL,
  `note` text,
  `is_active` varchar(255) DEFAULT 'yes',
  `is_deleted` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `expenses`
--

INSERT INTO `expenses` (`id`, `exp_head_id`, `name`, `invoice_no`, `date`, `amount`, `documents`, `note`, `is_active`, `is_deleted`, `updated_at`) VALUES
(1, 1, 'Stationary', 'inv4441', '2022-11-24', 12.00, NULL, '', 'yes', 'no', '');

-- --------------------------------------------------------

--
-- Table structure for table `expense_head`
--

CREATE TABLE `expense_head` (
  `id` int NOT NULL,
  `exp_category` varchar(50) DEFAULT NULL,
  `description` text,
  `is_active` varchar(255) DEFAULT 'yes',
  `is_deleted` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `expense_head`
--

INSERT INTO `expense_head` (`id`, `exp_category`, `description`, `is_active`, `is_deleted`, `updated_at`) VALUES
(1, 'Admin Expenses', 'Admin Expenses', 'yes', 'no', '');

-- --------------------------------------------------------

--
-- Table structure for table `fd_department`
--

CREATE TABLE `fd_department` (
  `id` int NOT NULL,
  `department` varchar(200) NOT NULL,
  `description` varchar(500) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `fd_department`
--

INSERT INTO `fd_department` (`id`, `department`, `description`, `active`) VALUES
(3, 'IT', 'IT Department', 1),
(4, 'Accounts', 'Accounts Department', 1);

-- --------------------------------------------------------

--
-- Table structure for table `feecategory`
--

CREATE TABLE `feecategory` (
  `id` int NOT NULL,
  `category` varchar(50) DEFAULT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `feemasters`
--

CREATE TABLE `feemasters` (
  `id` int NOT NULL,
  `session_id` int DEFAULT NULL,
  `feetype_id` int NOT NULL,
  `class_id` int DEFAULT NULL,
  `amount` float(10,2) DEFAULT NULL,
  `description` text,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `fees_discounts`
--

CREATE TABLE `fees_discounts` (
  `id` int NOT NULL,
  `session_id` int DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `code` varchar(100) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `description` text,
  `is_active` varchar(10) NOT NULL DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `fees_discounts`
--

INSERT INTO `fees_discounts` (`id`, `session_id`, `name`, `code`, `amount`, `description`, `is_active`) VALUES
(1, 18, 'Admission Fees', 'adf333', '200.00', 'discount for admission fee', 'no');

-- --------------------------------------------------------

--
-- Table structure for table `feetype`
--

CREATE TABLE `feetype` (
  `id` int NOT NULL,
  `is_system` int NOT NULL DEFAULT '0',
  `feecategory_id` int DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `code` varchar(100) NOT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `feetype`
--

INSERT INTO `feetype` (`id`, `is_system`, `feecategory_id`, `type`, `code`, `is_active`, `updated_at`, `description`) VALUES
(4, 0, NULL, 'Admission fee', 'ADM', 'no', '', 'Admission Fee'),
(5, 0, NULL, 'Uniform Fee', 'UNIF', 'no', '', 'Uniform Fee'),
(6, 0, NULL, 'Transport Fee', 'TRS', 'no', '', 'Transport Fee'),
(7, 0, NULL, 'Exam Fee', 'EXF', 'no', '', 'Exam Fee');

-- --------------------------------------------------------

--
-- Table structure for table `fee_groups`
--

CREATE TABLE `fee_groups` (
  `id` int NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `is_system` int NOT NULL DEFAULT '0',
  `description` text,
  `is_active` varchar(10) NOT NULL DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `fee_groups`
--

INSERT INTO `fee_groups` (`id`, `name`, `is_system`, `description`, `is_active`) VALUES
(2, 'Grade 1', 0, 'Grade 1', 'no');

-- --------------------------------------------------------

--
-- Table structure for table `fee_groups_feetype`
--

CREATE TABLE `fee_groups_feetype` (
  `id` int NOT NULL,
  `fee_session_group_id` int DEFAULT NULL,
  `fee_groups_id` int DEFAULT NULL,
  `feetype_id` int DEFAULT NULL,
  `session_id` int DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `is_active` varchar(10) NOT NULL DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `fee_groups_feetype`
--

INSERT INTO `fee_groups_feetype` (`id`, `fee_session_group_id`, `fee_groups_id`, `feetype_id`, `session_id`, `due_date`, `amount`, `is_active`) VALUES
(4, 2, 2, 4, 18, '1970-01-01', '200.00', 'no'),
(5, 2, 2, 5, 18, '1970-01-01', '40.00', 'no'),
(6, 2, 2, 6, 18, '1970-01-01', '20.00', 'no'),
(7, 2, 2, 7, 18, '1970-01-01', '10.00', 'no');

-- --------------------------------------------------------

--
-- Table structure for table `fee_receipt_no`
--

CREATE TABLE `fee_receipt_no` (
  `id` int NOT NULL,
  `payment` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `fee_session_groups`
--

CREATE TABLE `fee_session_groups` (
  `id` int NOT NULL,
  `fee_groups_id` int DEFAULT NULL,
  `session_id` int DEFAULT NULL,
  `is_active` varchar(10) NOT NULL DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `fee_session_groups`
--

INSERT INTO `fee_session_groups` (`id`, `fee_groups_id`, `session_id`, `is_active`) VALUES
(1, 1, 18, 'no'),
(2, 2, 18, 'no');

-- --------------------------------------------------------

--
-- Table structure for table `follow_up`
--

CREATE TABLE `follow_up` (
  `id` int NOT NULL,
  `enquiry_id` int NOT NULL,
  `date` date NOT NULL,
  `next_date` date NOT NULL,
  `response` text NOT NULL,
  `note` text NOT NULL,
  `followup_by` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `front_cms_media_gallery`
--

CREATE TABLE `front_cms_media_gallery` (
  `id` int NOT NULL,
  `image` varchar(300) DEFAULT NULL,
  `thumb_path` varchar(300) DEFAULT NULL,
  `dir_path` varchar(300) DEFAULT NULL,
  `img_name` varchar(300) DEFAULT NULL,
  `thumb_name` varchar(300) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `file_type` varchar(100) NOT NULL,
  `file_size` varchar(100) NOT NULL,
  `vid_url` mediumtext NOT NULL,
  `vid_title` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `front_cms_menus`
--

CREATE TABLE `front_cms_menus` (
  `id` int NOT NULL,
  `menu` varchar(100) DEFAULT NULL,
  `slug` varchar(200) DEFAULT NULL,
  `description` mediumtext,
  `open_new_tab` int NOT NULL DEFAULT '0',
  `ext_url` mediumtext NOT NULL,
  `ext_url_link` mediumtext NOT NULL,
  `publish` int NOT NULL DEFAULT '0',
  `content_type` varchar(10) NOT NULL DEFAULT 'manual',
  `is_active` varchar(10) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `front_cms_menus`
--

INSERT INTO `front_cms_menus` (`id`, `menu`, `slug`, `description`, `open_new_tab`, `ext_url`, `ext_url_link`, `publish`, `content_type`, `is_active`) VALUES
(1, 'Main Menu', 'main-menu', 'Main menu', 0, '', '', 0, 'default', 'no'),
(2, 'Bottom Menu', 'bottom-menu', 'Bottom Menu', 0, '', '', 0, 'default', 'no');

-- --------------------------------------------------------

--
-- Table structure for table `front_cms_menu_items`
--

CREATE TABLE `front_cms_menu_items` (
  `id` int NOT NULL,
  `menu_id` int NOT NULL,
  `menu` varchar(100) DEFAULT NULL,
  `page_id` int NOT NULL,
  `parent_id` int NOT NULL,
  `ext_url` mediumtext,
  `open_new_tab` int DEFAULT '0',
  `ext_url_link` mediumtext,
  `slug` varchar(200) DEFAULT NULL,
  `weight` int DEFAULT NULL,
  `publish` int NOT NULL DEFAULT '0',
  `description` mediumtext,
  `is_active` varchar(10) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `front_cms_pages`
--

CREATE TABLE `front_cms_pages` (
  `id` int NOT NULL,
  `page_type` varchar(10) NOT NULL DEFAULT 'manual',
  `is_homepage` int DEFAULT '0',
  `title` varchar(250) DEFAULT NULL,
  `url` varchar(250) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `slug` varchar(200) DEFAULT NULL,
  `meta_title` mediumtext,
  `meta_description` mediumtext,
  `meta_keyword` mediumtext,
  `feature_image` varchar(200) NOT NULL,
  `description` longtext,
  `publish_date` date NOT NULL,
  `publish` int DEFAULT '0',
  `sidebar` int DEFAULT '0',
  `is_active` varchar(10) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `front_cms_pages`
--

INSERT INTO `front_cms_pages` (`id`, `page_type`, `is_homepage`, `title`, `url`, `type`, `slug`, `meta_title`, `meta_description`, `meta_keyword`, `feature_image`, `description`, `publish_date`, `publish`, `sidebar`, `is_active`) VALUES
(1, 'default', 1, 'Home', 'page/home', 'page', 'home', '', '', '', '', '<p>home page</p>', '0000-00-00', 1, NULL, 'no'),
(2, 'default', 0, 'Complain', 'page/complain', 'page', 'complain', 'Complain form', '                                                                                                                                                                                    complain form                                                                                                                                                                                                                                ', 'complain form', '', '<p>\r\n[form-builder:complain]</p>', '0000-00-00', 1, 1, 'no'),
(54, 'default', 0, '404 page', 'page/404-page', 'page', '404-page', '', '                                ', '', '', '<html>\r\n<head>\r\n <title></title>\r\n</head>\r\n<body>\r\n<p>404 page found</p>\r\n</body>\r\n</html>', '0000-00-00', 0, NULL, 'no'),
(76, 'default', 0, 'Contact us', 'page/contact-us', 'page', 'contact-us', '', '', '', '', '<title></title>\r\n<section class=\"contact\">\r\n<div class=\"container spacet50 spaceb50\">\r\n<div class=\"row\">\r\n<div class=\"col-md-12 col-sm-12\">[form-builder:contact_us]<!--./row--></div>\r\n<!--./col-md-12--></div>\r\n<!--./row--></div>\r\n<!--./container--></section>', '0000-00-00', 0, NULL, 'no');

-- --------------------------------------------------------

--
-- Table structure for table `front_cms_page_contents`
--

CREATE TABLE `front_cms_page_contents` (
  `id` int NOT NULL,
  `page_id` int DEFAULT NULL,
  `content_type` varchar(50) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `front_cms_programs`
--

CREATE TABLE `front_cms_programs` (
  `id` int NOT NULL,
  `type` varchar(50) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `url` mediumtext,
  `title` varchar(200) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `event_start` date DEFAULT NULL,
  `event_end` date DEFAULT NULL,
  `event_venue` mediumtext,
  `description` mediumtext,
  `is_active` varchar(10) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `meta_title` mediumtext NOT NULL,
  `meta_description` mediumtext NOT NULL,
  `meta_keyword` mediumtext NOT NULL,
  `feature_image` mediumtext NOT NULL,
  `publish_date` date NOT NULL,
  `publish` varchar(10) DEFAULT '0',
  `sidebar` int DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `front_cms_program_photos`
--

CREATE TABLE `front_cms_program_photos` (
  `id` int NOT NULL,
  `program_id` int DEFAULT NULL,
  `media_gallery_id` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `front_cms_settings`
--

CREATE TABLE `front_cms_settings` (
  `id` int NOT NULL,
  `theme` varchar(50) DEFAULT NULL,
  `is_active_rtl` int DEFAULT '0',
  `is_active_front_cms` int DEFAULT '0',
  `is_active_sidebar` int DEFAULT '0',
  `logo` varchar(200) DEFAULT NULL,
  `contact_us_email` varchar(100) DEFAULT NULL,
  `complain_form_email` varchar(100) DEFAULT NULL,
  `sidebar_options` mediumtext NOT NULL,
  `fb_url` varchar(200) NOT NULL,
  `twitter_url` varchar(200) NOT NULL,
  `youtube_url` varchar(200) NOT NULL,
  `google_plus` varchar(200) NOT NULL,
  `instagram_url` varchar(200) NOT NULL,
  `pinterest_url` varchar(200) NOT NULL,
  `linkedin_url` varchar(200) NOT NULL,
  `google_analytics` mediumtext,
  `footer_text` varchar(500) DEFAULT NULL,
  `fav_icon` varchar(250) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `general_calls`
--

CREATE TABLE `general_calls` (
  `id` int NOT NULL,
  `name` varchar(100) NOT NULL,
  `contact` varchar(12) NOT NULL,
  `date` date NOT NULL,
  `description` varchar(500) NOT NULL,
  `follow_up_date` date NOT NULL,
  `call_dureation` varchar(50) NOT NULL,
  `note` mediumtext NOT NULL,
  `call_type` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `glaccount_types`
--

CREATE TABLE `glaccount_types` (
  `id` int NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` varchar(200) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `glaccount_types`
--

INSERT INTO `glaccount_types` (`id`, `name`, `description`, `active`) VALUES
(1, 'Income', 'Income', 1),
(2, 'Expenses', 'Expenses', 1),
(3, 'Bank ', 'Bank', 1),
(4, 'Fixed Assets ', 'Fixed Assets ', 1),
(5, 'Liability ', 'Liability ', 1),
(6, 'Trade Receivable ', 'Trade Receivable ', 1),
(7, 'Trade Payable ', 'Trade Payable ', 1),
(8, 'Sales ', 'Sales ', 1),
(9, 'Cost of sales ', 'Cost of sales ', 1),
(10, 'Purchases ', 'Purchases ', 1);

-- --------------------------------------------------------

--
-- Table structure for table `glledger_account`
--

CREATE TABLE `glledger_account` (
  `id` int NOT NULL,
  `date` varchar(50) NOT NULL,
  `gl_code` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` varchar(200) NOT NULL,
  `account_type` varchar(200) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `glledger_account`
--

INSERT INTO `glledger_account` (`id`, `date`, `gl_code`, `name`, `description`, `account_type`, `active`) VALUES
(2, '2023-01-29 06:14:20pm', '1000', 'Sales', 'Sales Income', 'Income', 1),
(3, '2023-01-29 06:18:18pm', '2000', 'Purchases ', 'Purchases ', 'Cost of sales ', 1),
(4, '2023-01-29 06:18:49pm', '8400', 'CBZ USD', 'CBZ USD', 'Bank ', 1),
(5, '2023-01-29 06:19:28pm', '4000', 'Motor Vehicle expenses ', 'Motor Vehicle expenses ', 'Expenses', 1);

-- --------------------------------------------------------

--
-- Table structure for table `glsub_account`
--

CREATE TABLE `glsub_account` (
  `id` int NOT NULL,
  `date` varchar(100) NOT NULL,
  `glsub_code` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `account_type` varchar(100) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `glsub_account`
--

INSERT INTO `glsub_account` (`id`, `date`, `glsub_code`, `name`, `description`, `account_type`, `active`) VALUES
(3, '2023-01-29 06:21:19pm', '200', 'Repairs & Maintenance ', 'Repairs and maintenance ', '4000', 1),
(4, '2023-01-29 06:21:43pm', '100', 'Fuel', 'Fuel', '4000', 1);

-- --------------------------------------------------------

--
-- Table structure for table `grades`
--

CREATE TABLE `grades` (
  `id` int NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `point` float(10,1) DEFAULT NULL,
  `mark_from` float(10,2) DEFAULT NULL,
  `mark_upto` float(10,2) DEFAULT NULL,
  `description` text,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `homework`
--

CREATE TABLE `homework` (
  `id` int NOT NULL,
  `class_id` int NOT NULL,
  `section_id` int NOT NULL,
  `homework_date` date NOT NULL,
  `submit_date` date NOT NULL,
  `staff_id` int NOT NULL,
  `subject_id` int NOT NULL,
  `description` varchar(500) NOT NULL,
  `create_date` date NOT NULL,
  `document` varchar(200) NOT NULL,
  `created_by` int NOT NULL,
  `evaluated_by` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `homework`
--

INSERT INTO `homework` (`id`, `class_id`, `section_id`, `homework_date`, `submit_date`, `staff_id`, `subject_id`, `description`, `create_date`, `document`, `created_by`, `evaluated_by`) VALUES
(1, 9, 13, '2022-11-24', '2022-11-24', 1, 5, '<p>English home work<br></p>', '2022-11-24', 'Chapter 4 Results.docx', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `homework_evaluation`
--

CREATE TABLE `homework_evaluation` (
  `id` int NOT NULL,
  `homework_id` int NOT NULL,
  `student_id` int NOT NULL,
  `date` date NOT NULL,
  `status` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `home_currency`
--

CREATE TABLE `home_currency` (
  `id` int NOT NULL,
  `date` varchar(50) NOT NULL,
  `currencycode` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `description` varchar(50) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `home_currency`
--

INSERT INTO `home_currency` (`id`, `date`, `currencycode`, `name`, `description`, `active`) VALUES
(2, '21-12-2022 11:07:50am', 'zwl', 'ZWL', 'zwl', 1),
(7, '26-10-2022 12:34:56pm', 'USD', 'USD', 'United states dollars', 1);

-- --------------------------------------------------------

--
-- Table structure for table `hostel`
--

CREATE TABLE `hostel` (
  `id` int NOT NULL,
  `hostel_name` varchar(100) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `address` text,
  `intake` int DEFAULT NULL,
  `description` text,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `hostel_rooms`
--

CREATE TABLE `hostel_rooms` (
  `id` int NOT NULL,
  `hostel_id` int DEFAULT NULL,
  `room_type_id` int DEFAULT NULL,
  `room_no` varchar(200) DEFAULT NULL,
  `no_of_bed` int DEFAULT NULL,
  `cost_per_bed` float(10,2) DEFAULT '0.00',
  `title` varchar(200) DEFAULT NULL,
  `description` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `id_card`
--

CREATE TABLE `id_card` (
  `id` int NOT NULL,
  `title` varchar(100) NOT NULL,
  `school_name` varchar(100) NOT NULL,
  `school_address` varchar(500) NOT NULL,
  `background` varchar(100) NOT NULL,
  `logo` varchar(100) NOT NULL,
  `sign_image` varchar(100) NOT NULL,
  `header_color` varchar(100) NOT NULL,
  `enable_admission_no` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_student_name` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_class` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_fathers_name` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_mothers_name` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_address` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_phone` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_dob` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_blood_group` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `status` tinyint(1) NOT NULL COMMENT '0=disable,1=enable'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `id_card`
--

INSERT INTO `id_card` (`id`, `title`, `school_name`, `school_address`, `background`, `logo`, `sign_image`, `header_color`, `enable_admission_no`, `enable_student_name`, `enable_class`, `enable_fathers_name`, `enable_mothers_name`, `enable_address`, `enable_phone`, `enable_dob`, `enable_blood_group`, `status`) VALUES
(1, 'Sample Student Identity Card', 'Mount Carmel School', '110 Kings Street, CA  Phone: 456542 Email: mount@gmail.com', 'samplebackground12.png', 'samplelogo12.png', 'samplesign12.png', '#595959', 1, 1, 1, 1, 0, 1, 1, 1, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `income`
--

CREATE TABLE `income` (
  `id` int NOT NULL,
  `inc_head_id` varchar(11) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `invoice_no` varchar(200) NOT NULL,
  `date` date DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `note` text,
  `is_active` varchar(255) DEFAULT 'yes',
  `is_deleted` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL,
  `documents` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `income`
--

INSERT INTO `income` (`id`, `inc_head_id`, `name`, `invoice_no`, `date`, `amount`, `note`, `is_active`, `is_deleted`, `updated_at`, `documents`) VALUES
(1, '1', 'Broiler chickens', 'inv123', '2022-11-24', 6, '', 'yes', 'no', '', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `income_head`
--

CREATE TABLE `income_head` (
  `id` int NOT NULL,
  `income_category` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `is_active` varchar(255) NOT NULL DEFAULT 'yes',
  `is_deleted` varchar(255) NOT NULL DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `income_head`
--

INSERT INTO `income_head` (`id`, `income_category`, `description`, `is_active`, `is_deleted`, `updated_at`) VALUES
(1, 'POULTRY', 'POULTRY PROJECT', 'yes', 'no', '');

-- --------------------------------------------------------

--
-- Table structure for table `item`
--

CREATE TABLE `item` (
  `id` int NOT NULL,
  `item_category_id` int DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `item_photo` varchar(225) DEFAULT NULL,
  `description` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL,
  `item_store_id` int DEFAULT NULL,
  `item_supplier_id` int DEFAULT NULL,
  `quantity` int NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `item`
--

INSERT INTO `item` (`id`, `item_category_id`, `name`, `item_photo`, `description`, `updated_at`, `item_store_id`, `item_supplier_id`, `quantity`, `date`) VALUES
(1, 1, 'Mazoe 2liters Orange crush', NULL, 'Mazoe 2liters Orange crush', '', NULL, NULL, 0, '0000-00-00'),
(2, 1, 'White bread bakers Inn', NULL, 'White bread bakers Inn', '', NULL, NULL, 0, '0000-00-00');

-- --------------------------------------------------------

--
-- Table structure for table `item_category`
--

CREATE TABLE `item_category` (
  `id` int NOT NULL,
  `item_category` varchar(255) NOT NULL,
  `is_active` varchar(255) NOT NULL DEFAULT 'yes',
  `description` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `item_category`
--

INSERT INTO `item_category` (`id`, `item_category`, `is_active`, `description`, `updated_at`) VALUES
(1, 'Groceries', 'yes', 'Groceries', '');

-- --------------------------------------------------------

--
-- Table structure for table `item_issue`
--

CREATE TABLE `item_issue` (
  `id` int NOT NULL,
  `issue_to` varchar(100) DEFAULT NULL,
  `issue_from` varchar(100) NOT NULL,
  `received_by` varchar(100) NOT NULL,
  `issue_by` varchar(100) DEFAULT NULL,
  `issue_date` date DEFAULT NULL,
  `return_date` date DEFAULT NULL,
  `item_category_id` int DEFAULT NULL,
  `item_id` int DEFAULT NULL,
  `quantity` int NOT NULL,
  `note` text NOT NULL,
  `is_returned` int NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `is_active` varchar(10) DEFAULT 'no'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `item_issue`
--

INSERT INTO `item_issue` (`id`, `issue_to`, `issue_from`, `received_by`, `issue_by`, `issue_date`, `return_date`, `item_category_id`, `item_id`, `quantity`, `note`, `is_returned`, `is_active`) VALUES
(2, 'Canteen', '', 'king', 'dane', '2022-11-25', '0000-00-00', 1, 2, 3, 'mazoe', 1, 'no'),
(3, 'Canteen', 'Stores', 'mum', 'ken', '2022-11-25', '0000-00-00', 1, 1, 7, 'hello', 1, 'no');

-- --------------------------------------------------------

--
-- Table structure for table `item_stock`
--

CREATE TABLE `item_stock` (
  `id` int NOT NULL,
  `item_id` int DEFAULT NULL,
  `supplier_id` int DEFAULT NULL,
  `symbol` varchar(10) NOT NULL DEFAULT '+',
  `store_id` int DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `date` date NOT NULL,
  `attachment` varchar(250) DEFAULT NULL,
  `description` text NOT NULL,
  `is_active` varchar(10) DEFAULT 'yes',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `item_stock`
--

INSERT INTO `item_stock` (`id`, `item_id`, `supplier_id`, `symbol`, `store_id`, `quantity`, `date`, `attachment`, `description`, `is_active`) VALUES
(1, 1, 1, '+', 1, 12, '1970-01-01', NULL, '', 'yes'),
(2, 2, 1, '+', 1, 6, '1970-01-01', NULL, '', 'yes');

-- --------------------------------------------------------

--
-- Table structure for table `item_store`
--

CREATE TABLE `item_store` (
  `id` int NOT NULL,
  `item_store` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `item_store`
--

INSERT INTO `item_store` (`id`, `item_store`, `code`, `description`) VALUES
(1, 'Stores', 'sto', 'Stores'),
(2, 'Canteen', 'cn', 'Canteen');

-- --------------------------------------------------------

--
-- Table structure for table `item_supplier`
--

CREATE TABLE `item_supplier` (
  `id` int NOT NULL,
  `item_supplier` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `contact_person_name` varchar(255) NOT NULL,
  `contact_person_phone` varchar(255) NOT NULL,
  `contact_person_email` varchar(255) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `item_supplier`
--

INSERT INTO `item_supplier` (`id`, `item_supplier`, `phone`, `email`, `address`, `contact_person_name`, `contact_person_phone`, `contact_person_email`, `description`) VALUES
(1, 'Cash Supplier', '07751213114', 'cashsupplier@gmail.com', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `journal`
--

CREATE TABLE `journal` (
  `id` int NOT NULL,
  `date_captured` varchar(100) NOT NULL,
  `date` varchar(20) NOT NULL,
  `cashbook` varchar(100) NOT NULL,
  `description` varchar(400) NOT NULL,
  `account` varchar(200) NOT NULL,
  `module` varchar(100) NOT NULL,
  `receipt` varchar(100) NOT NULL,
  `currency` varchar(100) NOT NULL,
  `debit` varchar(100) NOT NULL,
  `credit` varchar(100) NOT NULL,
  `balance` varchar(100) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `journal`
--

INSERT INTO `journal` (`id`, `date_captured`, `date`, `cashbook`, `description`, `account`, `module`, `receipt`, `currency`, `debit`, `credit`, `balance`, `active`) VALUES
(18, '22-11-2022 11:15:21am', '2022-11-22', 'CBZ-USD', 'me please', 'DANIEL', 'Supplier', 'd33', '', '240', '0', '1222', 1),
(19, '22-11-2022 11:24:23am', '2022-11-23', 'CBZ-USD', 'correct', 'r131292e', 'Supplier', 'rea', '', '0', '122', '-122', 1);

-- --------------------------------------------------------

--
-- Table structure for table `journal_accounts`
--

CREATE TABLE `journal_accounts` (
  `id` int NOT NULL,
  `journal_accounts` varchar(100) NOT NULL,
  `currency` varchar(100) NOT NULL,
  `description` varchar(200) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `journal_accounts`
--

INSERT INTO `journal_accounts` (`id`, `journal_accounts`, `currency`, `description`, `active`) VALUES
(2, 'Learner Journal ', 'USD', 'Learner Journal ', 1),
(3, 'Customer Journal ', 'USD', 'Customer Journal ', 1),
(4, 'Supplier Journal ', 'USD', 'Supplier Journal ', 1),
(5, 'General Journal ', 'USD', 'General Journal ', 1);

-- --------------------------------------------------------

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` int NOT NULL,
  `language` varchar(50) DEFAULT NULL,
  `is_deleted` varchar(10) NOT NULL DEFAULT 'yes',
  `is_active` varchar(255) DEFAULT 'no',
  `code` varchar(100) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`id`, `language`, `is_deleted`, `is_active`, `code`, `updated_at`) VALUES
(1, 'Azerbaijan', 'no', 'no', 'az', '0000-00-00 00:00:00'),
(2, 'Albanian', 'no', 'no', 'sq', '0000-00-00 00:00:00'),
(3, 'Amharic', 'no', 'no', 'am', '0000-00-00 00:00:00'),
(4, 'English', 'no', 'no', 'en', '0000-00-00 00:00:00'),
(5, 'Arabic', 'no', 'no', 'ar', '0000-00-00 00:00:00'),
(7, 'Afrikaans', 'no', 'no', 'af', '0000-00-00 00:00:00'),
(8, 'Basque', 'no', 'no', 'eu', '0000-00-00 00:00:00'),
(11, 'Bengali', 'no', 'no', 'bn', '0000-00-00 00:00:00'),
(13, 'Bosnian', 'no', 'no', 'bs', '0000-00-00 00:00:00'),
(14, 'Welsh', 'no', 'no', 'cy', '0000-00-00 00:00:00'),
(15, 'Hungarian', 'no', 'no', 'hu', '0000-00-00 00:00:00'),
(16, 'Vietnamese', 'no', 'no', 'vi', '0000-00-00 00:00:00'),
(17, 'Haitian (Creole)', 'no', 'no', 'ht', '0000-00-00 00:00:00'),
(18, 'Galician', 'no', 'no', 'gl', '0000-00-00 00:00:00'),
(19, 'Dutch', 'no', 'no', 'nl', '0000-00-00 00:00:00'),
(21, 'Greek', 'no', 'no', 'el', '0000-00-00 00:00:00'),
(22, 'Georgian', 'no', 'no', 'ka', '0000-00-00 00:00:00'),
(23, 'Gujarati', 'no', 'no', 'gu', '0000-00-00 00:00:00'),
(24, 'Danish', 'no', 'no', 'da', '0000-00-00 00:00:00'),
(25, 'Hebrew', 'no', 'no', 'he', '0000-00-00 00:00:00'),
(26, 'Yiddish', 'no', 'no', 'yi', '0000-00-00 00:00:00'),
(27, 'Indonesian', 'no', 'no', 'id', '0000-00-00 00:00:00'),
(28, 'Irish', 'no', 'no', 'ga', '0000-00-00 00:00:00'),
(29, 'Italian', 'no', 'no', 'it', '0000-00-00 00:00:00'),
(30, 'Icelandic', 'no', 'no', 'is', '0000-00-00 00:00:00'),
(31, 'Spanish', 'no', 'no', 'es', '0000-00-00 00:00:00'),
(33, 'Kannada', 'no', 'no', 'kn', '0000-00-00 00:00:00'),
(34, 'Catalan', 'no', 'no', 'ca', '0000-00-00 00:00:00'),
(36, 'Chinese', 'no', 'no', 'zh', '0000-00-00 00:00:00'),
(37, 'Korean', 'no', 'no', 'ko', '0000-00-00 00:00:00'),
(38, 'Xhosa', 'no', 'no', 'xh', '0000-00-00 00:00:00'),
(39, 'Latin', 'no', 'no', 'la', '0000-00-00 00:00:00'),
(40, 'Latvian', 'no', 'no', 'lv', '0000-00-00 00:00:00'),
(41, 'Lithuanian', 'no', 'no', 'lt', '0000-00-00 00:00:00'),
(43, 'Malagasy', 'no', 'no', 'mg', '0000-00-00 00:00:00'),
(44, 'Malay', 'no', 'no', 'ms', '0000-00-00 00:00:00'),
(45, 'Malayalam', 'no', 'no', 'ml', '0000-00-00 00:00:00'),
(46, 'Maltese', 'no', 'no', 'mt', '0000-00-00 00:00:00'),
(47, 'Macedonian', 'no', 'no', 'mk', '0000-00-00 00:00:00'),
(48, 'Maori', 'no', 'no', 'mi', '0000-00-00 00:00:00'),
(49, 'Marathi', 'no', 'no', 'mr', '0000-00-00 00:00:00'),
(51, 'Mongolian', 'no', 'no', 'mn', '0000-00-00 00:00:00'),
(52, 'German', 'no', 'no', 'de', '0000-00-00 00:00:00'),
(53, 'Nepali', 'no', 'no', 'ne', '0000-00-00 00:00:00'),
(54, 'Norwegian', 'no', 'no', 'no', '0000-00-00 00:00:00'),
(55, 'Punjabi', 'no', 'no', 'pa', '0000-00-00 00:00:00'),
(57, 'Persian', 'no', 'no', 'fa', '0000-00-00 00:00:00'),
(59, 'Portuguese', 'no', 'no', 'pt', '0000-00-00 00:00:00'),
(60, 'Romanian', 'no', 'no', 'ro', '0000-00-00 00:00:00'),
(61, 'Russian', 'no', 'no', 'ru', '0000-00-00 00:00:00'),
(62, 'Cebuano', 'no', 'no', '', '0000-00-00 00:00:00'),
(64, 'Sinhala', 'no', 'no', 'si', '0000-00-00 00:00:00'),
(65, 'Slovakian', 'no', 'no', '', '0000-00-00 00:00:00'),
(66, 'Slovenian', 'no', 'no', 'sl', '0000-00-00 00:00:00'),
(67, 'Swahili', 'no', 'no', 'sw', '0000-00-00 00:00:00'),
(68, 'Sundanese', 'no', 'no', 'su', '0000-00-00 00:00:00'),
(70, 'Thai', 'no', 'no', 'th', '0000-00-00 00:00:00'),
(71, 'Tagalog', 'no', 'no', 'tl', '0000-00-00 00:00:00'),
(72, 'Tamil', 'no', 'no', 'ta', '0000-00-00 00:00:00'),
(74, 'Telugu', 'no', 'no', 'te', '0000-00-00 00:00:00'),
(75, 'Turkish', 'no', 'no', 'tr', '0000-00-00 00:00:00'),
(77, 'Uzbek', 'no', 'no', 'uz', '0000-00-00 00:00:00'),
(79, 'Urdu', 'no', 'no', 'ur', '0000-00-00 00:00:00'),
(80, 'Finnish', 'no', 'no', 'fi', '0000-00-00 00:00:00'),
(81, 'French', 'no', 'no', 'fr', '0000-00-00 00:00:00'),
(82, 'Hindi', 'no', 'no', 'hi', '0000-00-00 00:00:00'),
(84, 'Czech', 'no', 'no', 'cs', '0000-00-00 00:00:00'),
(85, 'Swedish', 'no', 'no', 'sv', '0000-00-00 00:00:00'),
(86, 'Scottish', 'no', 'no', 'gd', '0000-00-00 00:00:00'),
(87, 'Estonian', 'no', 'no', 'et', '0000-00-00 00:00:00'),
(88, 'Esperanto', 'no', 'no', 'eo', '0000-00-00 00:00:00'),
(89, 'Javanese', 'no', 'no', 'jv', '0000-00-00 00:00:00'),
(90, 'Japanese', 'no', 'no', 'ja', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `leave_types`
--

CREATE TABLE `leave_types` (
  `id` int NOT NULL,
  `type` varchar(200) NOT NULL,
  `is_active` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `libarary_members`
--

CREATE TABLE `libarary_members` (
  `id` int UNSIGNED NOT NULL,
  `library_card_no` varchar(50) DEFAULT NULL,
  `member_type` varchar(50) DEFAULT NULL,
  `member_id` int DEFAULT NULL,
  `is_active` varchar(10) NOT NULL DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `libarary_members`
--

INSERT INTO `libarary_members` (`id`, `library_card_no`, `member_type`, `member_id`, `is_active`) VALUES
(1, 'LIB001', 'student', 3, 'no'),
(2, 'STA-LIB001', 'teacher', 3, 'no');

-- --------------------------------------------------------

--
-- Table structure for table `location`
--

CREATE TABLE `location` (
  `id` int NOT NULL,
  `location` varchar(200) NOT NULL,
  `department` varchar(200) NOT NULL,
  `designation` varchar(200) NOT NULL,
  `description` varchar(500) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `location`
--

INSERT INTO `location` (`id`, `location`, `department`, `designation`, `description`, `active`) VALUES
(3, 'kennedy', 'sales1', 'certificate', 'new new', 1),
(4, 'KEN', 'sales1', 'SALES ', 'NEW SALES GUY', 1),
(5, 'DANIEL', 'IT', 'Software Developer', 'Software Development', 1);

-- --------------------------------------------------------

--
-- Table structure for table `medical`
--

CREATE TABLE `medical` (
  `id` int NOT NULL,
  `date_captured` varchar(200) NOT NULL,
  `name` varchar(100) NOT NULL,
  `address` varchar(200) NOT NULL,
  `phone` varchar(30) NOT NULL,
  `email` varchar(200) NOT NULL,
  `company_name` varchar(100) NOT NULL,
  `description` varchar(300) NOT NULL,
  `company_address` varchar(100) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `medical`
--

INSERT INTO `medical` (`id`, `date_captured`, `name`, `address`, `phone`, `email`, `company_name`, `description`, `company_address`, `active`) VALUES
(1, '09-11-2022 09:26:48am', 'dd1', 'oo', 'dd', 'oo@gmail.com', 'oo', 'oo', 'oo', 1);

-- --------------------------------------------------------

--
-- Table structure for table `medical_details`
--

CREATE TABLE `medical_details` (
  `id` int NOT NULL,
  `date_captured` varchar(20) NOT NULL,
  `student_id` varchar(200) NOT NULL,
  `doctor` varchar(200) NOT NULL,
  `allergy` varchar(200) NOT NULL,
  `period` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  `description` varchar(500) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `medical_details`
--

INSERT INTO `medical_details` (`id`, `date_captured`, `student_id`, `doctor`, `allergy`, `period`, `status`, `description`, `active`) VALUES
(1, '09-11-2022 10:13:55a', 'c17131292e', 'dd1', 'ashma', '3 months', 'sick', 'sick', 1);

-- --------------------------------------------------------

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int NOT NULL,
  `title` varchar(200) DEFAULT NULL,
  `message` text,
  `send_mail` varchar(10) DEFAULT '0',
  `send_sms` varchar(10) DEFAULT '0',
  `is_group` varchar(10) DEFAULT '0',
  `is_individual` varchar(10) DEFAULT '0',
  `is_class` int NOT NULL DEFAULT '0',
  `group_list` text,
  `user_list` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `version` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `notification_roles`
--

CREATE TABLE `notification_roles` (
  `id` int NOT NULL,
  `send_notification_id` int DEFAULT NULL,
  `role_id` int DEFAULT NULL,
  `is_active` int DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `notification_roles`
--

INSERT INTO `notification_roles` (`id`, `send_notification_id`, `role_id`, `is_active`) VALUES
(1, 1, 2, 0),
(2, 1, 7, 0);

-- --------------------------------------------------------

--
-- Table structure for table `notification_setting`
--

CREATE TABLE `notification_setting` (
  `id` int NOT NULL,
  `type` varchar(100) DEFAULT NULL,
  `is_mail` varchar(10) DEFAULT '0',
  `is_sms` varchar(10) DEFAULT '0',
  `display_notification` int NOT NULL DEFAULT '0',
  `is_notification` int DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `notification_setting`
--

INSERT INTO `notification_setting` (`id`, `type`, `is_mail`, `is_sms`, `display_notification`, `is_notification`) VALUES
(1, 'student_admission', '1', '0', 0, 0),
(2, 'exam_result', '1', '0', 1, 0),
(3, 'fee_submission', '1', '0', 1, 0),
(4, 'absent_attendence', '1', '0', 1, 0),
(5, 'login_credential', '1', '0', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` int NOT NULL,
  `payment_methods` varchar(100) NOT NULL,
  `description` varchar(200) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `payment_methods`, `description`, `active`) VALUES
(3, 'RTGS', 'ZWL-RTGS', 1);

-- --------------------------------------------------------

--
-- Table structure for table `payment_settings`
--

CREATE TABLE `payment_settings` (
  `id` int NOT NULL,
  `payment_type` varchar(200) NOT NULL,
  `api_username` varchar(200) DEFAULT NULL,
  `api_secret_key` varchar(200) NOT NULL,
  `salt` varchar(200) NOT NULL,
  `api_publishable_key` varchar(200) NOT NULL,
  `api_password` varchar(200) DEFAULT NULL,
  `api_signature` varchar(200) DEFAULT NULL,
  `api_email` varchar(200) DEFAULT NULL,
  `paypal_demo` varchar(100) NOT NULL,
  `account_no` varchar(200) NOT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `payment_settings`
--

INSERT INTO `payment_settings` (`id`, `payment_type`, `api_username`, `api_secret_key`, `salt`, `api_publishable_key`, `api_password`, `api_signature`, `api_email`, `paypal_demo`, `account_no`, `is_active`, `updated_at`) VALUES
(1, 'paypal', '', '', '', '', '', '', NULL, '', '', 'yes', '0000-00-00 00:00:00'),
(2, 'stripe', NULL, '', '', '', NULL, NULL, NULL, '', '', 'no', '0000-00-00 00:00:00'),
(3, 'payu', NULL, '', '', '', NULL, NULL, NULL, '', '', 'no', '0000-00-00 00:00:00'),
(4, 'ccavenue', NULL, '', '', '', NULL, NULL, NULL, '', '', 'no', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `payslip_allowance`
--

CREATE TABLE `payslip_allowance` (
  `id` int NOT NULL,
  `payslip_id` int NOT NULL,
  `allowance_type` varchar(200) NOT NULL,
  `amount` int NOT NULL,
  `staff_id` int NOT NULL,
  `cal_type` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `payslip_allowance`
--

INSERT INTO `payslip_allowance` (`id`, `payslip_id`, `allowance_type`, `amount`, `staff_id`, `cal_type`) VALUES
(1, 1, 'septer', 20, 1, 'positive'),
(2, 1, 'ded', 4, 1, 'negative');

-- --------------------------------------------------------

--
-- Table structure for table `permission_category`
--

CREATE TABLE `permission_category` (
  `id` int NOT NULL,
  `perm_group_id` int DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `short_code` varchar(100) DEFAULT NULL,
  `enable_view` int DEFAULT '0',
  `enable_add` int DEFAULT '0',
  `enable_edit` int DEFAULT '0',
  `enable_delete` int DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `permission_category`
--

INSERT INTO `permission_category` (`id`, `perm_group_id`, `name`, `short_code`, `enable_view`, `enable_add`, `enable_edit`, `enable_delete`) VALUES
(1, 1, 'Student', 'student', 1, 1, 1, 1),
(2, 1, 'Import Student', 'import_student', 1, 0, 0, 0),
(3, 1, 'Student Categories', 'student_categories', 1, 1, 1, 1),
(4, 1, 'Student Houses', 'student_houses', 1, 1, 1, 1),
(5, 2, 'Collect Fees', 'collect_fees', 1, 1, 0, 1),
(6, 2, 'Fees Carry Forward', 'fees_carry_forward', 1, 0, 0, 0),
(7, 2, 'Fees Master', 'fees_master', 1, 1, 1, 1),
(8, 2, 'Fees Group', 'fees_group', 1, 1, 1, 1),
(9, 3, 'Income', 'income', 1, 1, 1, 1),
(10, 3, 'Income Head', 'income_head', 1, 1, 1, 1),
(11, 3, 'Search Income', 'search_income', 1, 0, 0, 0),
(12, 4, 'Expense', 'expense', 1, 1, 1, 1),
(13, 4, 'Expense Head', 'expense_head', 1, 1, 1, 1),
(14, 4, 'Search Expense', 'search_expense', 1, 0, 0, 0),
(15, 5, 'Student Attendance', 'student_attendance', 1, 1, 1, 0),
(16, 5, 'Student Attendance Report', 'student_attendance_report', 1, 0, 0, 0),
(17, 6, 'Exam', 'exam', 1, 1, 1, 1),
(19, 6, 'Marks Register', 'marks_register', 1, 1, 1, 0),
(20, 6, 'Marks Grade', 'marks_grade', 1, 1, 1, 1),
(21, 7, 'Class Timetable', 'class_timetable', 1, 1, 1, 0),
(22, 7, 'Assign Subject', 'assign_subject', 1, 1, 1, 1),
(23, 7, 'Subject', 'subject', 1, 1, 1, 1),
(24, 7, 'Class', 'class', 1, 1, 1, 1),
(25, 7, 'Section', 'section', 1, 1, 1, 1),
(26, 7, 'Promote Student', 'promote_student', 1, 0, 0, 0),
(27, 8, 'Upload Content', 'upload_content', 1, 1, 0, 1),
(28, 9, 'Books', 'books', 1, 1, 1, 1),
(29, 9, 'Issue Return Student', 'issue_return', 1, 0, 0, 0),
(30, 9, 'Add Staff Member', 'add_staff_member', 1, 0, 0, 0),
(31, 10, 'Issue Item', 'issue_item', 1, 0, 0, 0),
(32, 10, 'Item Stock', 'item_stock', 1, 1, 1, 1),
(33, 10, 'Item', 'item', 1, 1, 1, 1),
(34, 10, 'Store', 'store', 1, 1, 1, 1),
(35, 10, 'Supplier', 'supplier', 1, 1, 1, 1),
(37, 11, 'Routes', 'routes', 1, 1, 1, 1),
(38, 11, 'Vehicle', 'vehicle', 1, 1, 1, 1),
(39, 11, 'Assign Vehicle', 'assign_vehicle', 1, 1, 1, 1),
(40, 12, 'Hostel', 'hostel', 1, 1, 1, 1),
(41, 12, 'Room Type', 'room_type', 1, 1, 1, 1),
(42, 12, 'Hostel Rooms', 'hostel_rooms', 1, 1, 1, 1),
(43, 13, 'Notice Board', 'notice_board', 1, 1, 1, 1),
(44, 13, 'Email / SMS', 'email_sms', 1, 0, 0, 0),
(46, 13, 'Email / SMS Log', 'email_sms_log', 1, 0, 0, 0),
(47, 1, 'Student Report', 'student_report', 1, 0, 0, 0),
(48, 14, 'Transaction Report', 'transaction_report', 1, 0, 0, 0),
(49, 14, 'User Log', 'user_log', 1, 0, 0, 0),
(53, 15, 'Languages', 'languages', 0, 1, 0, 0),
(54, 15, 'General Setting', 'general_setting', 1, 0, 1, 0),
(55, 15, 'Session Setting', 'session_setting', 1, 1, 1, 1),
(56, 15, 'Notification Setting', 'notification_setting', 1, 0, 1, 0),
(57, 15, 'SMS Setting', 'sms_setting', 1, 0, 1, 0),
(58, 15, 'Email Setting', 'email_setting', 1, 0, 1, 0),
(59, 15, 'Front CMS Setting', 'front_cms_setting', 1, 0, 1, 0),
(60, 15, 'Payment Methods', 'payment_methods', 1, 0, 1, 0),
(61, 16, 'Menus', 'menus', 1, 1, 0, 1),
(62, 16, 'Media Manager', 'media_manager', 1, 1, 0, 1),
(63, 16, 'Banner Images', 'banner_images', 1, 1, 0, 1),
(64, 16, 'Pages', 'pages', 1, 1, 1, 1),
(65, 16, 'Gallery', 'gallery', 1, 1, 1, 1),
(66, 16, 'Event', 'event', 1, 1, 1, 1),
(67, 16, 'News', 'notice', 1, 1, 1, 1),
(68, 2, 'Fees Group Assign', 'fees_group_assign', 1, 0, 0, 0),
(69, 2, 'Fees Type', 'fees_type', 1, 1, 1, 1),
(70, 2, 'Fees Discount', 'fees_discount', 1, 1, 1, 1),
(71, 2, 'Fees Discount Assign', 'fees_discount_assign', 1, 0, 0, 0),
(72, 2, 'Fees Statement', 'fees_statement', 1, 0, 0, 0),
(73, 2, 'Search Fees Payment', 'search_fees_payment', 1, 0, 0, 0),
(74, 2, 'Search Due Fees', 'search_due_fees', 1, 0, 0, 0),
(75, 2, 'Balance Fees Report', 'balance_fees_report', 1, 0, 0, 0),
(76, 6, 'Exam Schedule', 'exam_schedule', 1, 1, 1, 0),
(77, 7, 'Assign Class Teacher', 'assign_class_teacher', 1, 1, 1, 1),
(78, 17, 'Admission Enquiry', 'admission_enquiry', 1, 1, 1, 1),
(79, 17, 'Follow Up Admission Enquiry', 'follow_up_admission_enquiry', 1, 1, 0, 1),
(80, 17, 'Visitor Book', 'visitor_book', 1, 1, 1, 1),
(81, 17, 'Phone Call Log', 'phone_call_log', 1, 1, 1, 1),
(82, 17, 'Postal Dispatch', 'postal_dispatch', 1, 1, 1, 1),
(83, 17, 'Postal Receive', 'postal_receive', 1, 1, 1, 1),
(84, 17, 'Complain', 'complaint', 1, 1, 1, 1),
(85, 17, 'Setup Font Office', 'setup_font_office', 1, 1, 1, 1),
(86, 18, 'Staff', 'staff', 1, 1, 1, 1),
(87, 18, 'Disable Staff', 'disable_staff', 1, 0, 0, 0),
(88, 18, 'Staff Attendance', 'staff_attendance', 1, 1, 1, 0),
(89, 18, 'Staff Attendance Report', 'staff_attendance_report', 1, 0, 0, 0),
(90, 18, 'Staff Payroll', 'staff_payroll', 1, 1, 0, 1),
(91, 18, 'Payroll Report', 'payroll_report', 1, 0, 0, 0),
(93, 19, 'Homework', 'homework', 1, 1, 1, 1),
(94, 19, 'Homework Evaluation', 'homework_evaluation', 1, 1, 0, 0),
(95, 19, 'Homework Report', 'homework_report', 1, 0, 0, 0),
(96, 20, 'Student Certificate', 'student_certificate', 1, 1, 1, 1),
(97, 20, 'Generate Certificate', 'generate_certificate', 1, 0, 0, 0),
(98, 20, 'Student ID Card', 'student_id_card', 1, 1, 1, 1),
(99, 20, 'Generate ID Card', 'generate_id_card', 1, 0, 0, 0),
(102, 21, 'Calendar To Do List', 'calendar_to_do_list', 1, 1, 1, 1),
(104, 10, 'Item Category', 'item_category', 1, 1, 1, 1),
(105, 1, 'Student Parent Login Details', 'student_parent_login_details', 1, 0, 0, 0),
(106, 22, 'Quick Session Change', 'quick_session_change', 1, 0, 0, 0),
(107, 1, 'Disable Student', 'disable_student', 1, 0, 0, 0),
(108, 18, ' Approve Leave Request', 'approve_leave_request', 1, 1, 1, 1),
(109, 18, 'Apply Leave', 'apply_leave', 1, 1, 1, 1),
(110, 18, 'Leave Types ', 'leave_types', 1, 1, 1, 1),
(111, 18, 'Department', 'department', 1, 1, 1, 1),
(112, 18, 'Designation', 'designation', 1, 1, 1, 1),
(113, 22, 'Fees Collection And Expense Monthly Chart', 'fees_collection_and_expense_monthly_chart', 1, 0, 0, 0),
(114, 22, 'Fees Collection And Expense Yearly Chart', 'fees_collection_and_expense_yearly_chart', 1, 0, 0, 0),
(115, 22, 'Monthly Fees Collection Widget', 'Monthly fees_collection_widget', 1, 0, 0, 0),
(116, 22, 'Monthly Expense Widget', 'monthly_expense_widget', 1, 0, 0, 0),
(117, 22, 'Student Count Widget', 'student_count_widget', 1, 0, 0, 0),
(118, 22, 'Staff Role Count Widget', 'staff_role_count_widget', 1, 0, 0, 0),
(119, 1, 'Guardian Report', 'guardian_report', 1, 0, 0, 0),
(120, 1, 'Student History', 'student_history', 1, 0, 0, 0),
(121, 1, 'Student Login Credential', 'student_login_credential', 1, 0, 0, 0),
(122, 5, 'Attendance By Date', 'attendance_by_date', 1, 0, 0, 0),
(123, 9, 'Add Student', 'add_student', 1, 0, 0, 0),
(124, 11, 'Student Transport Report', 'student_transport_report', 1, 0, 0, 0),
(125, 12, 'Student Hostel Report', 'student_hostel_report', 1, 0, 0, 0),
(126, 15, 'User Status', 'user_status', 1, 0, 0, 0),
(127, 18, 'Can See Other Users Profile', 'can_see_other_users_profile', 1, 0, 0, 0),
(128, 1, 'Student Timeline', 'student_timeline', 0, 1, 0, 1),
(129, 18, 'Staff Timeline', 'staff_timeline', 0, 1, 0, 1),
(130, 15, 'Backup', 'backup', 1, 1, 0, 1),
(131, 15, 'Restore', 'restore', 1, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `permission_group`
--

CREATE TABLE `permission_group` (
  `id` int NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `short_code` varchar(100) NOT NULL,
  `is_active` int DEFAULT '0',
  `system` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `permission_group`
--

INSERT INTO `permission_group` (`id`, `name`, `short_code`, `is_active`, `system`) VALUES
(1, 'Student Information', 'student_information', 1, 1),
(2, 'Fees Collection', 'fees_collection', 1, 0),
(3, 'Income', 'income', 1, 1),
(4, 'Expense', 'expense', 1, 1),
(5, 'Student Attendance', 'student_attendance', 1, 0),
(6, 'Examination', 'examination', 1, 0),
(7, 'Academics', 'academics', 1, 1),
(8, 'Download Center', 'download_center', 1, 0),
(9, 'Library', 'library', 1, 1),
(10, 'Inventory', 'inventory', 1, 0),
(11, 'Transport', 'transport', 1, 0),
(12, 'Hostel', 'hostel', 1, 1),
(13, 'Communicate', 'communicate', 1, 0),
(14, 'Reports', 'reports', 1, 1),
(15, 'System Settings', 'system_settings', 1, 1),
(16, 'Front CMS', 'front_cms', 1, 1),
(17, 'Front Office', 'front_office', 1, 1),
(18, 'Human Resource', 'human_resource', 1, 1),
(19, 'Homework', 'homework', 1, 0),
(20, 'Certificate', 'certificate', 1, 1),
(21, 'Calendar To Do List', 'calendar_to_do_list', 1, 0),
(22, 'Dashboard and Widgets', 'dashboard_and_widgets', 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `read_notification`
--

CREATE TABLE `read_notification` (
  `id` int NOT NULL,
  `student_id` int DEFAULT NULL,
  `parent_id` int DEFAULT NULL,
  `staff_id` int DEFAULT NULL,
  `notification_id` int DEFAULT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `read_notification`
--

INSERT INTO `read_notification` (`id`, `student_id`, `parent_id`, `staff_id`, `notification_id`, `is_active`, `updated_at`) VALUES
(1, 3, NULL, NULL, 1, 'no', '');

-- --------------------------------------------------------

--
-- Table structure for table `reference`
--

CREATE TABLE `reference` (
  `id` int NOT NULL,
  `reference` varchar(100) NOT NULL,
  `description` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `slug` varchar(150) DEFAULT NULL,
  `is_active` int DEFAULT '0',
  `is_system` int NOT NULL DEFAULT '0',
  `is_superadmin` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `slug`, `is_active`, `is_system`, `is_superadmin`, `updated_at`) VALUES
(1, 'Admin', NULL, 0, 1, 0, '0000-00-00 00:00:00'),
(2, 'Teacher', NULL, 0, 1, 0, '0000-00-00 00:00:00'),
(3, 'Accountant', NULL, 0, 1, 0, '0000-00-00 00:00:00'),
(4, 'Librarian', NULL, 0, 1, 0, '0000-00-00 00:00:00'),
(6, 'Receptionist', NULL, 0, 1, 0, '0000-00-00 00:00:00'),
(7, 'Super Admin', NULL, 0, 1, 1, '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `roles_permissions`
--

CREATE TABLE `roles_permissions` (
  `id` int NOT NULL,
  `role_id` int DEFAULT NULL,
  `perm_cat_id` int DEFAULT NULL,
  `can_view` int DEFAULT NULL,
  `can_add` int DEFAULT NULL,
  `can_edit` int DEFAULT NULL,
  `can_delete` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `roles_permissions`
--

INSERT INTO `roles_permissions` (`id`, `role_id`, `perm_cat_id`, `can_view`, `can_add`, `can_edit`, `can_delete`) VALUES
(3, 1, 3, 1, 1, 1, 1),
(4, 1, 4, 1, 1, 1, 1),
(6, 1, 5, 1, 1, 0, 1),
(8, 1, 7, 1, 1, 1, 1),
(9, 1, 8, 1, 1, 1, 1),
(10, 1, 17, 1, 1, 1, 1),
(11, 1, 78, 1, 1, 1, 1),
(13, 1, 69, 1, 1, 1, 1),
(14, 1, 70, 1, 1, 1, 1),
(23, 1, 12, 1, 1, 1, 1),
(24, 1, 13, 1, 1, 1, 1),
(26, 1, 15, 1, 1, 1, 0),
(28, 1, 19, 1, 1, 1, 0),
(29, 1, 20, 1, 1, 1, 1),
(30, 1, 76, 1, 1, 1, 0),
(31, 1, 21, 1, 1, 1, 0),
(32, 1, 22, 1, 1, 1, 1),
(33, 1, 23, 1, 1, 1, 1),
(34, 1, 24, 1, 1, 1, 1),
(35, 1, 25, 1, 1, 1, 1),
(37, 1, 77, 1, 1, 1, 1),
(43, 1, 32, 1, 1, 1, 1),
(44, 1, 33, 1, 1, 1, 1),
(45, 1, 34, 1, 1, 1, 1),
(46, 1, 35, 1, 1, 1, 1),
(47, 1, 104, 1, 1, 1, 1),
(48, 1, 37, 1, 1, 1, 1),
(49, 1, 38, 1, 1, 1, 1),
(53, 1, 43, 1, 1, 1, 1),
(58, 1, 52, 1, 1, 0, 1),
(61, 1, 55, 1, 1, 1, 1),
(67, 1, 61, 1, 1, 0, 1),
(68, 1, 62, 1, 1, 0, 1),
(69, 1, 63, 1, 1, 0, 1),
(70, 1, 64, 1, 1, 1, 1),
(71, 1, 65, 1, 1, 1, 1),
(72, 1, 66, 1, 1, 1, 1),
(73, 1, 67, 1, 1, 1, 1),
(74, 1, 79, 1, 1, 0, 1),
(75, 1, 80, 1, 1, 1, 1),
(76, 1, 81, 1, 1, 1, 1),
(78, 1, 83, 1, 1, 1, 1),
(79, 1, 84, 1, 1, 1, 1),
(80, 1, 85, 1, 1, 1, 1),
(83, 1, 88, 1, 1, 1, 0),
(87, 1, 92, 1, 1, 1, 1),
(88, 1, 93, 1, 1, 1, 1),
(94, 1, 82, 1, 1, 1, 1),
(120, 1, 39, 1, 1, 1, 1),
(140, 1, 110, 1, 1, 1, 1),
(141, 1, 111, 1, 1, 1, 1),
(142, 1, 112, 1, 1, 1, 1),
(145, 1, 94, 1, 1, 0, 0),
(147, 2, 43, 1, 1, 1, 1),
(148, 2, 44, 1, 0, 0, 0),
(149, 2, 46, 1, 0, 0, 0),
(156, 1, 9, 1, 1, 1, 1),
(157, 1, 10, 1, 1, 1, 1),
(159, 1, 40, 1, 1, 1, 1),
(160, 1, 41, 1, 1, 1, 1),
(161, 1, 42, 1, 1, 1, 1),
(169, 1, 27, 1, 1, 0, 1),
(178, 1, 54, 1, 0, 1, 0),
(179, 1, 56, 1, 0, 1, 0),
(180, 1, 57, 1, 0, 1, 0),
(181, 1, 58, 1, 0, 1, 0),
(182, 1, 59, 1, 0, 1, 0),
(183, 1, 60, 1, 0, 1, 0),
(190, 1, 105, 1, 0, 0, 0),
(193, 1, 6, 1, 0, 0, 0),
(194, 1, 68, 1, 0, 0, 0),
(196, 1, 72, 1, 0, 0, 0),
(197, 1, 73, 1, 0, 0, 0),
(198, 1, 74, 1, 0, 0, 0),
(199, 1, 75, 1, 0, 0, 0),
(201, 1, 14, 1, 0, 0, 0),
(203, 1, 16, 1, 0, 0, 0),
(204, 1, 26, 1, 0, 0, 0),
(206, 1, 29, 1, 0, 0, 0),
(207, 1, 30, 1, 0, 0, 0),
(208, 1, 31, 1, 0, 0, 0),
(215, 1, 50, 1, 0, 0, 0),
(216, 1, 51, 1, 0, 0, 0),
(222, 1, 1, 1, 1, 1, 1),
(225, 1, 108, 1, 1, 1, 1),
(227, 1, 91, 1, 0, 0, 0),
(229, 1, 89, 1, 0, 0, 0),
(230, 10, 53, 0, 1, 0, 0),
(231, 10, 54, 0, 0, 1, 0),
(232, 10, 55, 1, 1, 1, 1),
(233, 10, 56, 0, 0, 1, 0),
(235, 10, 58, 0, 0, 1, 0),
(236, 10, 59, 0, 0, 1, 0),
(239, 10, 1, 1, 1, 1, 1),
(241, 10, 3, 1, 0, 0, 0),
(242, 10, 2, 1, 0, 0, 0),
(243, 10, 4, 1, 0, 1, 1),
(245, 10, 107, 1, 0, 0, 0),
(246, 10, 5, 1, 1, 0, 1),
(247, 10, 7, 1, 1, 1, 1),
(248, 10, 68, 1, 0, 0, 0),
(249, 10, 69, 1, 1, 1, 1),
(250, 10, 70, 1, 0, 0, 1),
(251, 10, 72, 1, 0, 0, 0),
(252, 10, 73, 1, 0, 0, 0),
(253, 10, 74, 1, 0, 0, 0),
(254, 10, 75, 1, 0, 0, 0),
(255, 10, 9, 1, 1, 1, 1),
(256, 10, 10, 1, 1, 1, 1),
(257, 10, 11, 1, 0, 0, 0),
(258, 10, 12, 1, 1, 1, 1),
(259, 10, 13, 1, 1, 1, 1),
(260, 10, 14, 1, 0, 0, 0),
(261, 10, 15, 1, 1, 1, 0),
(262, 10, 16, 1, 0, 0, 0),
(263, 10, 17, 1, 1, 1, 1),
(264, 10, 19, 1, 1, 1, 0),
(265, 10, 20, 1, 1, 1, 1),
(266, 10, 76, 1, 0, 0, 0),
(267, 10, 21, 1, 1, 1, 0),
(268, 10, 22, 1, 1, 1, 1),
(269, 10, 23, 1, 1, 1, 1),
(270, 10, 24, 1, 1, 1, 1),
(271, 10, 25, 1, 1, 1, 1),
(272, 10, 26, 1, 0, 0, 0),
(273, 10, 77, 1, 1, 1, 1),
(274, 10, 27, 1, 1, 0, 1),
(275, 10, 28, 1, 1, 1, 1),
(276, 10, 29, 1, 0, 0, 0),
(277, 10, 30, 1, 0, 0, 0),
(278, 10, 31, 1, 0, 0, 0),
(279, 10, 32, 1, 1, 1, 1),
(280, 10, 33, 1, 1, 1, 1),
(281, 10, 34, 1, 1, 1, 1),
(282, 10, 35, 1, 1, 1, 1),
(283, 10, 104, 1, 1, 1, 1),
(284, 10, 37, 1, 1, 1, 1),
(285, 10, 38, 1, 1, 1, 1),
(286, 10, 39, 1, 1, 1, 1),
(287, 10, 40, 1, 1, 1, 1),
(288, 10, 41, 1, 1, 1, 1),
(289, 10, 42, 1, 1, 1, 1),
(290, 10, 43, 1, 1, 1, 1),
(291, 10, 44, 1, 0, 0, 0),
(292, 10, 46, 1, 0, 0, 0),
(293, 10, 50, 1, 0, 0, 0),
(294, 10, 51, 1, 0, 0, 0),
(295, 10, 60, 0, 0, 1, 0),
(296, 10, 61, 1, 1, 1, 1),
(297, 10, 62, 1, 1, 1, 1),
(298, 10, 63, 1, 1, 0, 0),
(299, 10, 64, 1, 1, 1, 1),
(300, 10, 65, 1, 1, 1, 1),
(301, 10, 66, 1, 1, 1, 1),
(302, 10, 67, 1, 0, 0, 0),
(303, 10, 78, 1, 1, 1, 1),
(307, 1, 126, 1, 0, 0, 0),
(310, 1, 119, 1, 0, 0, 0),
(311, 1, 120, 1, 0, 0, 0),
(312, 1, 107, 1, 0, 0, 0),
(313, 1, 122, 1, 0, 0, 0),
(315, 1, 123, 1, 0, 0, 0),
(317, 1, 124, 1, 0, 0, 0),
(320, 1, 47, 1, 0, 0, 0),
(321, 1, 121, 1, 0, 0, 0),
(322, 1, 109, 1, 1, 1, 1),
(369, 1, 102, 1, 1, 1, 1),
(372, 10, 79, 1, 1, 0, 0),
(373, 10, 80, 1, 1, 1, 1),
(374, 10, 81, 1, 1, 1, 1),
(375, 10, 82, 1, 1, 1, 1),
(376, 10, 83, 1, 1, 1, 1),
(377, 10, 84, 1, 1, 1, 1),
(378, 10, 85, 1, 1, 1, 1),
(379, 10, 86, 1, 1, 1, 1),
(380, 10, 87, 1, 0, 0, 0),
(381, 10, 88, 1, 1, 1, 0),
(382, 10, 89, 1, 0, 0, 0),
(383, 10, 90, 1, 1, 0, 1),
(384, 10, 91, 1, 0, 0, 0),
(385, 10, 108, 1, 1, 1, 1),
(386, 10, 109, 1, 1, 1, 1),
(387, 10, 110, 1, 1, 1, 1),
(388, 10, 111, 1, 1, 1, 1),
(389, 10, 112, 1, 1, 1, 1),
(390, 10, 127, 1, 0, 0, 0),
(391, 10, 93, 1, 1, 1, 1),
(392, 10, 94, 1, 1, 0, 0),
(394, 10, 95, 1, 0, 0, 0),
(395, 10, 102, 1, 1, 1, 1),
(396, 10, 106, 1, 0, 0, 0),
(397, 10, 113, 1, 0, 0, 0),
(398, 10, 114, 1, 0, 0, 0),
(399, 10, 115, 1, 0, 0, 0),
(400, 10, 116, 1, 0, 0, 0),
(401, 10, 117, 1, 0, 0, 0),
(402, 10, 118, 1, 0, 0, 0),
(411, 1, 2, 1, 0, 0, 0),
(412, 1, 11, 1, 0, 0, 0),
(416, 2, 3, 1, 1, 1, 1),
(428, 2, 4, 1, 1, 1, 1),
(432, 1, 128, 0, 1, 0, 1),
(434, 1, 125, 1, 0, 0, 0),
(435, 1, 96, 1, 1, 1, 1),
(437, 1, 98, 1, 1, 1, 1),
(444, 1, 99, 1, 0, 0, 0),
(445, 1, 48, 1, 0, 0, 0),
(446, 1, 49, 1, 0, 0, 0),
(448, 1, 71, 1, 0, 0, 0),
(453, 1, 106, 1, 0, 0, 0),
(454, 1, 113, 1, 0, 0, 0),
(455, 1, 114, 1, 0, 0, 0),
(456, 1, 115, 1, 0, 0, 0),
(457, 1, 116, 1, 0, 0, 0),
(458, 1, 117, 1, 0, 0, 0),
(459, 1, 118, 1, 0, 0, 0),
(461, 1, 97, 1, 0, 0, 0),
(462, 1, 95, 1, 0, 0, 0),
(464, 1, 86, 1, 1, 1, 1),
(466, 1, 129, 0, 1, 0, 1),
(467, 1, 87, 1, 0, 0, 0),
(468, 1, 90, 1, 1, 0, 1),
(471, 1, 53, 0, 1, 0, 0),
(474, 1, 130, 1, 1, 0, 1),
(476, 1, 131, 1, 0, 0, 0),
(477, 2, 1, 1, 1, 1, 1),
(478, 2, 2, 1, 0, 0, 0),
(479, 2, 47, 1, 0, 0, 0),
(480, 2, 105, 1, 0, 0, 0),
(482, 2, 119, 1, 0, 0, 0),
(483, 2, 120, 1, 0, 0, 0),
(485, 2, 15, 1, 1, 1, 0),
(486, 2, 16, 1, 0, 0, 0),
(487, 2, 122, 1, 0, 0, 0),
(492, 2, 21, 1, 0, 0, 0),
(493, 2, 22, 1, 0, 0, 0),
(494, 2, 23, 1, 0, 0, 0),
(495, 2, 24, 1, 0, 0, 0),
(496, 2, 25, 1, 0, 0, 0),
(498, 2, 77, 1, 0, 0, 0),
(499, 2, 27, 1, 1, 0, 1),
(502, 2, 93, 1, 1, 1, 1),
(503, 2, 94, 1, 1, 0, 0),
(504, 2, 95, 1, 0, 0, 0),
(505, 3, 5, 1, 1, 0, 1),
(506, 3, 6, 1, 0, 0, 0),
(507, 3, 7, 1, 1, 1, 1),
(508, 3, 8, 1, 1, 1, 1),
(509, 3, 68, 1, 0, 0, 0),
(510, 3, 69, 1, 1, 1, 1),
(511, 3, 70, 1, 1, 1, 1),
(512, 3, 71, 1, 0, 0, 0),
(513, 3, 72, 1, 0, 0, 0),
(514, 3, 73, 1, 0, 0, 0),
(515, 3, 74, 1, 0, 0, 0),
(517, 3, 75, 1, 0, 0, 0),
(518, 3, 9, 1, 1, 1, 1),
(519, 3, 10, 1, 1, 1, 1),
(520, 3, 11, 1, 0, 0, 0),
(521, 3, 12, 1, 1, 1, 1),
(522, 3, 13, 1, 1, 1, 1),
(523, 3, 14, 1, 0, 0, 0),
(524, 3, 86, 1, 1, 1, 1),
(525, 3, 87, 1, 0, 0, 0),
(526, 3, 88, 1, 1, 1, 0),
(527, 3, 89, 1, 0, 0, 0),
(528, 3, 90, 1, 1, 0, 1),
(529, 3, 91, 1, 0, 0, 0),
(530, 3, 108, 1, 1, 1, 1),
(531, 3, 109, 1, 1, 1, 1),
(532, 3, 110, 1, 1, 1, 1),
(533, 3, 111, 1, 1, 1, 1),
(534, 3, 112, 1, 1, 1, 1),
(535, 3, 127, 1, 0, 0, 0),
(536, 3, 129, 0, 1, 0, 1),
(537, 3, 43, 1, 1, 1, 1),
(538, 3, 44, 1, 0, 0, 0),
(539, 3, 46, 1, 0, 0, 0),
(540, 3, 31, 1, 0, 0, 0),
(541, 3, 32, 1, 1, 1, 1),
(542, 3, 33, 1, 1, 1, 1),
(543, 3, 34, 1, 1, 1, 1),
(544, 3, 35, 1, 1, 1, 1),
(545, 3, 104, 1, 1, 1, 1),
(546, 3, 37, 1, 1, 1, 1),
(547, 3, 38, 1, 1, 1, 1),
(548, 3, 39, 1, 1, 1, 1),
(549, 3, 124, 1, 0, 0, 0),
(553, 6, 78, 1, 1, 1, 1),
(554, 6, 79, 1, 1, 0, 1),
(555, 6, 80, 1, 1, 1, 1),
(556, 6, 81, 1, 1, 1, 1),
(557, 6, 82, 1, 1, 1, 1),
(558, 6, 83, 1, 1, 1, 1),
(559, 6, 84, 1, 1, 1, 1),
(560, 6, 85, 1, 1, 1, 1),
(561, 6, 86, 1, 0, 0, 0),
(574, 6, 43, 1, 1, 1, 1),
(575, 6, 44, 1, 0, 0, 0),
(576, 6, 46, 1, 0, 0, 0),
(578, 6, 102, 1, 1, 1, 1),
(579, 4, 28, 1, 1, 1, 1),
(580, 4, 29, 1, 0, 0, 0),
(581, 4, 30, 1, 0, 0, 0),
(582, 4, 123, 1, 0, 0, 0),
(583, 4, 86, 1, 0, 0, 0),
(584, 4, 43, 1, 1, 1, 1),
(585, 4, 44, 1, 0, 0, 0),
(586, 4, 46, 1, 0, 0, 0),
(588, 2, 102, 1, 1, 1, 1),
(589, 2, 106, 1, 0, 0, 0),
(590, 2, 117, 1, 0, 0, 0),
(591, 3, 40, 1, 1, 1, 1),
(592, 3, 41, 1, 1, 1, 1),
(593, 3, 42, 1, 1, 1, 1),
(594, 3, 125, 1, 0, 0, 0),
(595, 3, 48, 1, 0, 0, 0),
(596, 3, 49, 1, 0, 0, 0),
(597, 3, 102, 1, 1, 1, 1),
(598, 3, 106, 1, 0, 0, 0),
(599, 3, 113, 1, 0, 0, 0),
(600, 3, 114, 1, 0, 0, 0),
(601, 3, 115, 1, 0, 0, 0),
(602, 3, 116, 1, 0, 0, 0),
(603, 3, 117, 1, 0, 0, 0),
(604, 3, 118, 1, 0, 0, 0),
(609, 6, 117, 1, 0, 0, 0),
(611, 2, 86, 1, 0, 0, 0),
(612, 1, 44, 1, 0, 0, 0),
(613, 1, 46, 1, 0, 0, 0),
(616, 1, 127, 1, 0, 0, 0),
(617, 2, 17, 1, 1, 1, 1),
(618, 2, 19, 1, 1, 1, 0),
(619, 2, 20, 1, 1, 1, 1),
(620, 2, 76, 1, 1, 1, 0),
(621, 2, 107, 1, 0, 0, 0),
(622, 2, 121, 1, 0, 0, 0),
(623, 2, 128, 0, 1, 0, 1),
(625, 1, 28, 1, 1, 1, 1),
(626, 6, 1, 1, 0, 0, 0),
(627, 6, 21, 1, 0, 0, 0),
(628, 6, 22, 1, 0, 0, 0),
(629, 6, 23, 1, 0, 0, 0),
(630, 6, 24, 1, 0, 0, 0),
(631, 6, 25, 1, 0, 0, 0),
(632, 6, 77, 1, 0, 0, 0),
(633, 6, 106, 1, 0, 0, 0),
(634, 4, 102, 1, 1, 1, 1),
(635, 4, 106, 1, 0, 0, 0),
(636, 4, 117, 1, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `room_types`
--

CREATE TABLE `room_types` (
  `id` int NOT NULL,
  `room_type` varchar(200) DEFAULT NULL,
  `description` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `school_houses`
--

CREATE TABLE `school_houses` (
  `id` int NOT NULL,
  `house_name` varchar(200) NOT NULL,
  `description` varchar(400) NOT NULL,
  `is_active` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `sch_settings`
--

CREATE TABLE `sch_settings` (
  `id` int NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `address` text,
  `lang_id` int DEFAULT NULL,
  `dise_code` varchar(50) DEFAULT NULL,
  `date_format` varchar(50) NOT NULL,
  `currency` varchar(50) NOT NULL,
  `currency_symbol` varchar(50) NOT NULL,
  `is_rtl` varchar(10) DEFAULT 'disabled',
  `timezone` varchar(30) DEFAULT 'UTC',
  `session_id` int DEFAULT NULL,
  `start_month` varchar(40) NOT NULL,
  `image` varchar(100) DEFAULT NULL,
  `theme` varchar(200) NOT NULL DEFAULT 'default.jpg',
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL,
  `cron_secret_key` varchar(100) NOT NULL,
  `fee_due_days` int DEFAULT '0',
  `class_teacher` varchar(100) NOT NULL,
  `mobile_api_url` text NOT NULL,
  `app_primary_color_code` varchar(20) DEFAULT NULL,
  `app_secondary_color_code` varchar(20) DEFAULT NULL,
  `app_logo` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sch_settings`
--

INSERT INTO `sch_settings` (`id`, `name`, `email`, `phone`, `address`, `lang_id`, `dise_code`, `date_format`, `currency`, `currency_symbol`, `is_rtl`, `timezone`, `session_id`, `start_month`, `image`, `theme`, `is_active`, `updated_at`, `cron_secret_key`, `fee_due_days`, `class_teacher`, `mobile_api_url`, `app_primary_color_code`, `app_secondary_color_code`, `app_logo`) VALUES
(1, 'Garland', 'galand@gmail.com', '0774233045', 'GRANNARY, ZVIMBA', 4, 'G123GRANNARY', 'd-M-Y', 'USD', '$', 'disabled', 'Africa/Harare', 18, '9', '1.png', 'default.jpg', 'no', '0000-00-00 00:00:00', '', 0, 'no', '', '#424242', '#eeeeee', '1.png');

-- --------------------------------------------------------

--
-- Table structure for table `sections`
--

CREATE TABLE `sections` (
  `id` int NOT NULL,
  `section` varchar(60) DEFAULT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sections`
--

INSERT INTO `sections` (`id`, `section`, `is_active`, `updated_at`) VALUES
(7, 'A', 'no', ''),
(8, 'B', 'no', ''),
(9, 'C', 'no', ''),
(10, 'D', 'no', ''),
(11, 'Blue', 'no', ''),
(12, 'Green', 'no', ''),
(13, 'Yellow', 'no', '');

-- --------------------------------------------------------

--
-- Table structure for table `send_notification`
--

CREATE TABLE `send_notification` (
  `id` int NOT NULL,
  `title` varchar(50) DEFAULT NULL,
  `publish_date` date DEFAULT NULL,
  `date` date DEFAULT NULL,
  `message` text,
  `visible_student` varchar(10) NOT NULL DEFAULT 'no',
  `visible_staff` varchar(10) NOT NULL DEFAULT 'no',
  `visible_parent` varchar(10) NOT NULL DEFAULT 'no',
  `created_by` varchar(60) DEFAULT NULL,
  `created_id` int DEFAULT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `send_notification`
--

INSERT INTO `send_notification` (`id`, `title`, `publish_date`, `date`, `message`, `visible_student`, `visible_staff`, `visible_parent`, `created_by`, `created_id`, `is_active`, `updated_at`) VALUES
(1, 'New Software Update Launch', '2022-11-24', '2022-11-24', '<h4>\r\n\r\nAdd Income- Go to Income > Add Income select Income Head then enter Income Name then \r\nInvoice Number, Date of Income then Amount then Attach Document then Description & click \r\non Save button. Recently added 10 Incomes can be see right side of this page.\r\n\r\n<br></h4>', 'Yes', 'Yes', 'No', 'Super Admin', 1, 'no', '');

-- --------------------------------------------------------

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` int NOT NULL,
  `session` varchar(60) DEFAULT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `session`, `is_active`, `updated_at`) VALUES
(7, '2016-17', 'no', '0000-00-00 00:00:00'),
(11, '2017-18', 'no', '0000-00-00 00:00:00'),
(13, '2018-19', 'no', '0000-00-00 00:00:00'),
(14, '2019-20', 'no', '0000-00-00 00:00:00'),
(15, '2020-21', 'no', '0000-00-00 00:00:00'),
(16, '2021-22', 'no', '0000-00-00 00:00:00'),
(18, '2022-23', 'no', '0000-00-00 00:00:00'),
(19, '2023-24', 'no', '0000-00-00 00:00:00'),
(20, '2024-25', 'no', '0000-00-00 00:00:00'),
(21, '2025-26', 'no', '0000-00-00 00:00:00'),
(22, '2026-27', 'no', '0000-00-00 00:00:00'),
(23, '2027-28', 'no', '0000-00-00 00:00:00'),
(24, '2028-29', 'no', '0000-00-00 00:00:00'),
(25, '2029-30', 'no', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `sms_config`
--

CREATE TABLE `sms_config` (
  `id` int NOT NULL,
  `type` varchar(50) NOT NULL,
  `name` varchar(100) NOT NULL,
  `api_id` varchar(100) NOT NULL,
  `authkey` varchar(100) NOT NULL,
  `senderid` varchar(100) NOT NULL,
  `contact` text,
  `username` varchar(150) DEFAULT NULL,
  `url` varchar(150) DEFAULT NULL,
  `password` varchar(150) DEFAULT NULL,
  `is_active` varchar(255) DEFAULT 'disabled',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `source`
--

CREATE TABLE `source` (
  `id` int NOT NULL,
  `source` varchar(100) NOT NULL,
  `description` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `sport`
--

CREATE TABLE `sport` (
  `id` int NOT NULL,
  `date_captured` varchar(50) NOT NULL,
  `sportcode` varchar(200) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` varchar(300) NOT NULL,
  `across` varchar(200) NOT NULL,
  `down` varchar(200) NOT NULL,
  `gender` varchar(200) NOT NULL,
  `age_group` varchar(200) NOT NULL,
  `team` varchar(200) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sport`
--

INSERT INTO `sport` (`id`, `date_captured`, `sportcode`, `name`, `description`, `across`, `down`, `gender`, `age_group`, `team`, `active`) VALUES
(1, '2022-11-09 12:47:54pm', 'soc22', 'soccer', 'sport', '9', '9', 'Male', 'under 16', 'house 1', 1);

-- --------------------------------------------------------

--
-- Table structure for table `sport_categories`
--

CREATE TABLE `sport_categories` (
  `id` int NOT NULL,
  `sport` varchar(200) NOT NULL,
  `age_group` varchar(200) NOT NULL,
  `gender` varchar(200) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sport_categories`
--

INSERT INTO `sport_categories` (`id`, `sport`, `age_group`, `gender`, `active`) VALUES
(1, 'soccer', 'under 16', 'Male', 1);

-- --------------------------------------------------------

--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `id` int NOT NULL,
  `employee_id` varchar(200) NOT NULL,
  `department` varchar(100) NOT NULL,
  `designation` varchar(100) NOT NULL,
  `qualification` varchar(200) NOT NULL,
  `work_exp` varchar(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `surname` varchar(200) NOT NULL,
  `father_name` varchar(200) NOT NULL,
  `mother_name` varchar(200) NOT NULL,
  `contact_no` varchar(200) NOT NULL,
  `emergency_contact_no` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `dob` date NOT NULL,
  `marital_status` varchar(100) NOT NULL,
  `date_of_joining` date NOT NULL,
  `date_of_leaving` date NOT NULL,
  `local_address` varchar(300) NOT NULL,
  `permanent_address` varchar(200) NOT NULL,
  `note` varchar(200) NOT NULL,
  `image` varchar(200) NOT NULL,
  `password` varchar(250) NOT NULL,
  `gender` varchar(50) NOT NULL,
  `account_title` varchar(200) NOT NULL,
  `bank_account_no` varchar(200) NOT NULL,
  `bank_name` varchar(200) NOT NULL,
  `ifsc_code` varchar(200) NOT NULL,
  `bank_branch` varchar(100) NOT NULL,
  `payscale` varchar(200) NOT NULL,
  `basic_salary` varchar(200) NOT NULL,
  `epf_no` varchar(200) NOT NULL,
  `contract_type` varchar(100) NOT NULL,
  `shift` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `facebook` varchar(200) NOT NULL,
  `twitter` varchar(200) NOT NULL,
  `linkedin` varchar(200) NOT NULL,
  `instagram` varchar(200) NOT NULL,
  `resume` varchar(200) NOT NULL,
  `joining_letter` varchar(200) NOT NULL,
  `resignation_letter` varchar(200) NOT NULL,
  `other_document_name` varchar(200) NOT NULL,
  `other_document_file` varchar(200) NOT NULL,
  `user_id` int NOT NULL,
  `is_active` int NOT NULL,
  `verification_code` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `staff`
--

INSERT INTO `staff` (`id`, `employee_id`, `department`, `designation`, `qualification`, `work_exp`, `name`, `surname`, `father_name`, `mother_name`, `contact_no`, `emergency_contact_no`, `email`, `dob`, `marital_status`, `date_of_joining`, `date_of_leaving`, `local_address`, `permanent_address`, `note`, `image`, `password`, `gender`, `account_title`, `bank_account_no`, `bank_name`, `ifsc_code`, `bank_branch`, `payscale`, `basic_salary`, `epf_no`, `contract_type`, `shift`, `location`, `facebook`, `twitter`, `linkedin`, `instagram`, `resume`, `joining_letter`, `resignation_letter`, `other_document_name`, `other_document_file`, `user_id`, `is_active`, `verification_code`) VALUES
(1, '', '', '', '', '', 'Super Admin', '', '', '', '', '', 'superadmin@gmail.com', '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '$2y$10$FR4uLfdq6eRk6Wu1WnD21OMbtQnLoNYf5pm0WPVkEp/UuqLfqLOzi', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, ''),
(2, 'GDM123H', '1', '1', 'BSc Honors In Information Technology', '2 years in Ministry', 'DANIEL', 'MAODZEKA', '', '', '0774233045', '0772330945', 'dkmao@gmail.com', '1997-11-16', 'Married', '2022-09-21', '0000-00-00', '164 st, warren park, harare', '', 'Reday to work', '2.png', '$2y$10$Z9JdCuvMWO5zTJXQRyP0.OhlADkbsVDaHLhOmU/HcJ8gfyvptOalG', 'Male', 'debit', '2000838902', 'steard', '', 'kwameh', '', '200', 'dkm123', 'permanent', '1', 'harare', '', '', '', '', '', '', '', 'Other Document', '', 0, 0, ''),
(3, 'STA001', '3', '2', 'BSC. honors in Information Technology', 'elmaz technologies', 'Daniel', 'Maodzeka', '', '', '0774233045', '0772330945', 'dkmaodzeka@gmail.com', '1997-11-16', 'Single', '2020-01-01', '0000-00-00', '164 street, 3639 warren park d, harare', '3206, grannary phase 2b, harare', 'a good teacher in english language', '', '$2y$10$qb2DYaFb/i22C/GkfCNGV.vFNekxYq7lfefX1XdFMA.mDFGVNURRu', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, '');

-- --------------------------------------------------------

--
-- Table structure for table `staff_attendance`
--

CREATE TABLE `staff_attendance` (
  `id` int NOT NULL,
  `date` date NOT NULL,
  `staff_id` int NOT NULL,
  `staff_attendance_type_id` int NOT NULL,
  `remark` varchar(200) NOT NULL,
  `is_active` int NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `staff_attendance_type`
--

CREATE TABLE `staff_attendance_type` (
  `id` int NOT NULL,
  `type` varchar(200) NOT NULL,
  `key_value` varchar(200) NOT NULL,
  `is_active` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `staff_attendance_type`
--

INSERT INTO `staff_attendance_type` (`id`, `type`, `key_value`, `is_active`, `updated_at`) VALUES
(1, 'Present', '<b class=\"text text-success\">P</b>', 'yes', '0000-00-00 00:00:00'),
(2, 'Late', '<b class=\"text text-warning\">L</b>', 'yes', '0000-00-00 00:00:00'),
(3, 'Absent', '<b class=\"text text-danger\">A</b>', 'yes', '0000-00-00 00:00:00'),
(4, 'Half Day', '<b class=\"text text-warning\">F</b>', 'yes', '0000-00-00 00:00:00'),
(5, 'Holiday', 'H', 'yes', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `staff_designation`
--

CREATE TABLE `staff_designation` (
  `id` int NOT NULL,
  `designation` varchar(200) NOT NULL,
  `is_active` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `staff_designation`
--

INSERT INTO `staff_designation` (`id`, `designation`, `is_active`) VALUES
(2, 'English Teacher', 'yes'),
(3, 'Shona Teacher', 'yes'),
(4, 'Maths Teacher', 'yes');

-- --------------------------------------------------------

--
-- Table structure for table `staff_leave_details`
--

CREATE TABLE `staff_leave_details` (
  `id` int NOT NULL,
  `staff_id` int NOT NULL,
  `leave_type_id` int NOT NULL,
  `alloted_leave` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `staff_leave_request`
--

CREATE TABLE `staff_leave_request` (
  `id` int NOT NULL,
  `staff_id` int NOT NULL,
  `leave_type_id` int NOT NULL,
  `leave_from` date NOT NULL,
  `leave_to` date NOT NULL,
  `leave_days` int NOT NULL,
  `employee_remark` varchar(200) NOT NULL,
  `admin_remark` varchar(200) NOT NULL,
  `status` varchar(100) NOT NULL,
  `applied_by` varchar(200) NOT NULL,
  `document_file` varchar(200) NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `staff_payroll`
--

CREATE TABLE `staff_payroll` (
  `id` int NOT NULL,
  `basic_salary` int NOT NULL,
  `pay_scale` varchar(200) NOT NULL,
  `grade` varchar(50) NOT NULL,
  `is_active` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `staff_payslip`
--

CREATE TABLE `staff_payslip` (
  `id` int NOT NULL,
  `staff_id` int NOT NULL,
  `basic` int NOT NULL,
  `total_allowance` int NOT NULL,
  `total_deduction` int NOT NULL,
  `leave_deduction` int NOT NULL,
  `tax` varchar(200) NOT NULL,
  `net_salary` int NOT NULL,
  `status` varchar(100) NOT NULL,
  `month` varchar(200) NOT NULL,
  `year` varchar(200) NOT NULL,
  `payment_mode` varchar(200) NOT NULL,
  `payment_date` date NOT NULL,
  `remark` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `staff_payslip`
--

INSERT INTO `staff_payslip` (`id`, `staff_id`, `basic`, `total_allowance`, `total_deduction`, `leave_deduction`, `tax`, `net_salary`, `status`, `month`, `year`, `payment_mode`, `payment_date`, `remark`) VALUES
(1, 1, 0, 20, 4, 0, '0', 16, 'generated', 'August', '2022', '', '2022-09-15', '');

-- --------------------------------------------------------

--
-- Table structure for table `staff_roles`
--

CREATE TABLE `staff_roles` (
  `id` int NOT NULL,
  `role_id` int DEFAULT NULL,
  `staff_id` int DEFAULT NULL,
  `is_active` int DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `staff_roles`
--

INSERT INTO `staff_roles` (`id`, `role_id`, `staff_id`, `is_active`, `updated_at`) VALUES
(1, 7, 1, 0, '0000-00-00 00:00:00'),
(2, 2, 2, 0, ''),
(3, 2, 3, 0, '');

-- --------------------------------------------------------

--
-- Table structure for table `staff_timeline`
--

CREATE TABLE `staff_timeline` (
  `id` int NOT NULL,
  `staff_id` int NOT NULL,
  `title` varchar(200) NOT NULL,
  `timeline_date` date NOT NULL,
  `description` varchar(300) NOT NULL,
  `document` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `id` int NOT NULL,
  `parent_id` int NOT NULL,
  `admission_no` varchar(100) DEFAULT NULL,
  `roll_no` varchar(100) DEFAULT NULL,
  `admission_date` varchar(100) DEFAULT NULL,
  `firstname` varchar(100) DEFAULT NULL,
  `lastname` varchar(100) DEFAULT NULL,
  `rte` varchar(20) NOT NULL DEFAULT 'No',
  `image` varchar(100) DEFAULT NULL,
  `mobileno` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `pincode` varchar(100) DEFAULT NULL,
  `religion` varchar(100) DEFAULT NULL,
  `cast` varchar(50) NOT NULL,
  `dob` varchar(100) DEFAULT NULL,
  `gender` varchar(100) DEFAULT NULL,
  `current_address` text,
  `permanent_address` text,
  `category_id` varchar(100) DEFAULT NULL,
  `route_id` int NOT NULL,
  `school_house_id` int NOT NULL,
  `blood_group` varchar(200) NOT NULL,
  `vehroute_id` int NOT NULL,
  `hostel_room_id` int NOT NULL,
  `adhar_no` varchar(100) DEFAULT NULL,
  `samagra_id` varchar(100) DEFAULT NULL,
  `bank_account_no` varchar(100) DEFAULT NULL,
  `bank_name` varchar(100) DEFAULT NULL,
  `ifsc_code` varchar(100) DEFAULT NULL,
  `guardian_is` varchar(100) NOT NULL,
  `father_name` varchar(100) DEFAULT NULL,
  `father_phone` varchar(100) DEFAULT NULL,
  `father_occupation` varchar(100) DEFAULT NULL,
  `mother_name` varchar(100) DEFAULT NULL,
  `mother_phone` varchar(100) DEFAULT NULL,
  `mother_occupation` varchar(100) DEFAULT NULL,
  `guardian_name` varchar(100) DEFAULT NULL,
  `guardian_relation` varchar(100) DEFAULT NULL,
  `guardian_phone` varchar(100) DEFAULT NULL,
  `guardian_occupation` varchar(150) NOT NULL,
  `guardian_address` text,
  `guardian_email` varchar(100) NOT NULL,
  `father_pic` varchar(200) NOT NULL,
  `mother_pic` varchar(200) NOT NULL,
  `guardian_pic` varchar(200) NOT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `previous_school` text,
  `height` varchar(100) NOT NULL,
  `weight` varchar(100) NOT NULL,
  `measurement_date` date NOT NULL,
  `app_key` text,
  `parent_app_key` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL,
  `disable_at` date NOT NULL,
  `note` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `students`
--

INSERT INTO `students` (`id`, `parent_id`, `admission_no`, `roll_no`, `admission_date`, `firstname`, `lastname`, `rte`, `image`, `mobileno`, `email`, `state`, `city`, `pincode`, `religion`, `cast`, `dob`, `gender`, `current_address`, `permanent_address`, `category_id`, `route_id`, `school_house_id`, `blood_group`, `vehroute_id`, `hostel_room_id`, `adhar_no`, `samagra_id`, `bank_account_no`, `bank_name`, `ifsc_code`, `guardian_is`, `father_name`, `father_phone`, `father_occupation`, `mother_name`, `mother_phone`, `mother_occupation`, `guardian_name`, `guardian_relation`, `guardian_phone`, `guardian_occupation`, `guardian_address`, `guardian_email`, `father_pic`, `mother_pic`, `guardian_pic`, `is_active`, `previous_school`, `height`, `weight`, `measurement_date`, `app_key`, `parent_app_key`, `updated_at`, `disable_at`, `note`) VALUES
(1, 2, 'c17131292e', '1', '2022-07-14', 'daniel', 'maodzeka', 'No', 'uploads/student_images/no_image.png', '0774233045', 'dkmao@gmail.com', NULL, NULL, NULL, 'christian', '990', '1997-11-16', 'Male', '', '', '1', 0, 0, '', 0, 0, '', '', '', '', '', 'father', 'kennedy', '0772330945', 'MANAGER', 'NONE', 'none2', 'nothing', 'kennedy', 'Father', '0772330945', 'MANAGER', '', 'dk@gmail.com', '', '', '', 'yes', '', '', '', '2022-07-14', NULL, NULL, '0000-00-00 00:00:00', '0000-00-00', ''),
(2, 4, 'GM123H', '1', '2022-09-21', 'GETTY', 'MAODZEKA', 'No', 'uploads/student_images/2.png', '0772112334', 'dkmaodzeka@gmail.com', NULL, NULL, NULL, 'Christian', '', '2001-06-24', 'Female', '', '', '1', 0, 0, 'A+', 0, 0, '', '', '', '', '', 'father', 'daniel', '0774233045', 'manager', 'yvette', '0785076046', 'manager', 'daniel', 'Father', '0774233045', 'manager', 'harare belgravia', 'dkmao@gmail.com', '', '', '', 'yes', '', '', '', '2022-09-21', NULL, NULL, '', '0000-00-00', ''),
(3, 6, 'LEA001', '001', '2022-11-24', 'Tafadzwa', 'Musenda', 'No', 'uploads/student_images/no_image.png', '', '', NULL, NULL, NULL, 'Christian', '', '2019-02-13', 'Male', '', '', '1', 0, 0, '', 0, 0, '', '', '', '', '', 'father', 'Mr Musenda', '0774123141', 'Employee', 'Mrs Musenda', '0778665121', 'Mr Musenda', 'Mr Musenda', 'Father', '0774123141', 'Employee', '', '', '', '', '', 'yes', '', '', '', '2022-11-24', NULL, NULL, '', '0000-00-00', ''),
(4, 0, 'LEA002', '2', '2022-12-01', 'Princess', 'Gurure', 'No', 'uploads/student_images/no_image.png', '0787000306', 'gurureprincess@gmail.com', NULL, NULL, NULL, 'AFM', '1', '2007-05-26', 'Female', '', '', '1', 0, 0, 'O+', 0, 0, '', '', '', '', '', 'mother', 'Jotham', '0774231431', 'Civil Engineer', 'Gladys', '0774725890', 'Electrical Engineer', 'Gladys', 'Mother', '0774725890', 'Electrical Engineer', '235 Old Marimba Mufakose Harare', 'cgladys@gmaiil.com', '', '', '', 'yes', '', '1.2', '45', '2022-12-01', NULL, NULL, '', '0000-00-00', '');

-- --------------------------------------------------------

--
-- Table structure for table `student_attendences`
--

CREATE TABLE `student_attendences` (
  `id` int NOT NULL,
  `student_session_id` int DEFAULT NULL,
  `date` date DEFAULT NULL,
  `attendence_type_id` int DEFAULT NULL,
  `remark` varchar(200) NOT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `student_attendences`
--

INSERT INTO `student_attendences` (`id`, `student_session_id`, `date`, `attendence_type_id`, `remark`, `is_active`, `updated_at`) VALUES
(1, 3, '2022-11-24', 1, '', 'no', '');

-- --------------------------------------------------------

--
-- Table structure for table `student_doc`
--

CREATE TABLE `student_doc` (
  `id` int NOT NULL,
  `student_id` int DEFAULT NULL,
  `title` varchar(200) DEFAULT NULL,
  `doc` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `student_fees`
--

CREATE TABLE `student_fees` (
  `id` int NOT NULL,
  `student_session_id` int DEFAULT NULL,
  `feemaster_id` int DEFAULT NULL,
  `amount` float(10,2) DEFAULT NULL,
  `amount_discount` float(10,2) NOT NULL,
  `amount_fine` float(10,2) NOT NULL DEFAULT '0.00',
  `description` text,
  `date` varchar(50) NOT NULL,
  `payment_mode` varchar(50) NOT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `student_fees_deposite`
--

CREATE TABLE `student_fees_deposite` (
  `id` int NOT NULL,
  `student_fees_master_id` int DEFAULT NULL,
  `student_group_id` int NOT NULL,
  `fee_groups_feetype_id` int DEFAULT NULL,
  `amount_detail` text,
  `receipt` varchar(20) NOT NULL,
  `is_active` varchar(10) NOT NULL DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `student_fees_deposite`
--

INSERT INTO `student_fees_deposite` (`id`, `student_fees_master_id`, `student_group_id`, `fee_groups_feetype_id`, `amount_detail`, `receipt`, `is_active`) VALUES
(26, 2, 0, 5, '{\"1\":{\"amount\":\"40\",\"date\":\"2022-12-08\",\"amount_discount\":\"0\",\"amount_fine\":\"0\",\"description\":\"FEE Collected By: Super Admin\",\"payment_mode\":\"RTGS-ZWL\",\"inv_no\":1}}', 'REC0004', 'no'),
(27, 2, 0, 6, '{\"1\":{\"amount\":\"20\",\"date\":\"2022-12-08\",\"amount_discount\":\"0\",\"amount_fine\":\"0\",\"description\":\"FEE Collected By: Super Admin\",\"payment_mode\":\"RTGS-ZWL\",\"inv_no\":1}}', 'REC0005', 'no'),
(29, 2, 0, 4, '{\"1\":{\"amount\":\"70\",\"date\":\"2022-12-16\",\"amount_discount\":\"0\",\"amount_fine\":\"0\",\"description\":\"adm\",\"payment_mode\":\"RTGS\",\"inv_no\":1},\"2\":{\"amount\":\"10\",\"date\":\"2022-12-16\",\"amount_discount\":\"0\",\"amount_fine\":\"0\",\"description\":\"ADM\",\"payment_mode\":\"RTGS\",\"inv_no\":2},\"3\":{\"amount\":0.142857142857142849212692681248881854116916656494140625,\"date\":\"2022-12-16\",\"amount_discount\":\"0\",\"amount_fine\":\"0\",\"description\":\"adm\",\"payment_mode\":\"RTGS\",\"inv_no\":3},\"4\":{\"amount\":15.7155102040816334607598037109710276126861572265625,\"date\":\"2022-12-16\",\"amount_discount\":\"0\",\"amount_fine\":\"0\",\"description\":\"adm\",\"payment_mode\":\"RTGS\",\"inv_no\":4},\"5\":{\"amount\":0.28571428571428569842538536249776370823383331298828125,\"date\":\"2023-01-29\",\"amount_discount\":\"0\",\"amount_fine\":\"0\",\"description\":\"\",\"payment_mode\":\"RTGS\",\"inv_no\":5}}', 'REC0004', 'no');

-- --------------------------------------------------------

--
-- Table structure for table `student_fees_discounts`
--

CREATE TABLE `student_fees_discounts` (
  `id` int NOT NULL,
  `student_session_id` int DEFAULT NULL,
  `fees_discount_id` int DEFAULT NULL,
  `status` varchar(20) DEFAULT 'assigned',
  `payment_id` varchar(50) DEFAULT NULL,
  `description` text,
  `is_active` varchar(10) NOT NULL DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `student_fees_discounts`
--

INSERT INTO `student_fees_discounts` (`id`, `student_session_id`, `fees_discount_id`, `status`, `payment_id`, `description`, `is_active`) VALUES
(1, 2, 1, 'applied', '10/1', 'admission fee Collected By: Super Admin', 'no'),
(2, 3, 1, 'applied', '23', 'discount', 'no');

-- --------------------------------------------------------

--
-- Table structure for table `student_fees_master`
--

CREATE TABLE `student_fees_master` (
  `id` int NOT NULL,
  `is_system` int NOT NULL DEFAULT '0',
  `student_session_id` int DEFAULT NULL,
  `fee_session_group_id` int DEFAULT NULL,
  `amount` float(10,2) DEFAULT '0.00',
  `is_active` varchar(10) NOT NULL DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `invoice` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `student_fees_master`
--

INSERT INTO `student_fees_master` (`id`, `is_system`, `student_session_id`, `fee_session_group_id`, `amount`, `is_active`, `invoice`) VALUES
(1, 0, 2, 1, 0.00, 'no', ''),
(2, 0, 3, 2, 0.00, 'no', ''),
(4, 0, 4, 2, 0.00, 'no', '');

-- --------------------------------------------------------

--
-- Table structure for table `student_session`
--

CREATE TABLE `student_session` (
  `id` int NOT NULL,
  `session_id` int DEFAULT NULL,
  `student_id` int DEFAULT NULL,
  `class_id` int DEFAULT NULL,
  `section_id` int DEFAULT NULL,
  `route_id` int NOT NULL,
  `hostel_room_id` int NOT NULL,
  `vehroute_id` int DEFAULT NULL,
  `transport_fees` float(10,2) NOT NULL DEFAULT '0.00',
  `fees_discount` float(10,2) NOT NULL DEFAULT '0.00',
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `student_session`
--

INSERT INTO `student_session` (`id`, `session_id`, `student_id`, `class_id`, `section_id`, `route_id`, `hostel_room_id`, `vehroute_id`, `transport_fees`, `fees_discount`, `is_active`, `updated_at`) VALUES
(1, 14, 1, 1, 1, 0, 0, NULL, 0.00, 0.00, 'no', '0000-00-00 00:00:00'),
(2, 18, 2, 2, 4, 0, 0, NULL, 0.00, 0.00, 'no', ''),
(3, 18, 3, 9, 13, 0, 0, NULL, 0.00, 0.00, 'no', ''),
(4, 18, 0, 9, 13, 0, 0, NULL, 0.00, 0.00, 'no', '');

-- --------------------------------------------------------

--
-- Table structure for table `student_sibling`
--

CREATE TABLE `student_sibling` (
  `id` int NOT NULL,
  `student_id` int DEFAULT NULL,
  `sibling_student_id` int DEFAULT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `student_sport`
--

CREATE TABLE `student_sport` (
  `id` int NOT NULL,
  `date_captured` varchar(100) NOT NULL,
  `sportcode` varchar(100) NOT NULL,
  `student_id` varchar(100) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `student_sport`
--

INSERT INTO `student_sport` (`id`, `date_captured`, `sportcode`, `student_id`, `active`) VALUES
(3, '2022-12-23 10:49:22am', 'soc22', 'LEA001', 1);

-- --------------------------------------------------------

--
-- Table structure for table `student_timeline`
--

CREATE TABLE `student_timeline` (
  `id` int NOT NULL,
  `student_id` int NOT NULL,
  `title` varchar(200) NOT NULL,
  `timeline_date` date NOT NULL,
  `description` varchar(200) NOT NULL,
  `document` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `student_transport_fees`
--

CREATE TABLE `student_transport_fees` (
  `id` int NOT NULL,
  `student_session_id` int DEFAULT NULL,
  `amount` float(10,2) DEFAULT NULL,
  `amount_discount` float(10,2) NOT NULL,
  `amount_fine` float(10,2) NOT NULL DEFAULT '0.00',
  `description` text,
  `date` varchar(50) NOT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `payment_mode` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `subjects`
--

CREATE TABLE `subjects` (
  `id` int NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `code` varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `subjects`
--

INSERT INTO `subjects` (`id`, `name`, `code`, `type`, `is_active`, `updated_at`) VALUES
(4, 'English', 'ENG', 'Theory', 'no', ''),
(5, 'English Pr', 'ENGP', 'Practical', 'no', ''),
(6, 'Maths', 'MATH', 'Practical', 'no', ''),
(7, 'Shona', 'SH', 'Theory', 'no', '');

-- --------------------------------------------------------

--
-- Table structure for table `supplier`
--

CREATE TABLE `supplier` (
  `id` int NOT NULL,
  `date_captured` varchar(30) NOT NULL,
  `supplier_id` varchar(10) NOT NULL,
  `name` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `mobile` varchar(15) NOT NULL,
  `email` varchar(100) NOT NULL,
  `currency` varchar(20) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `supplier`
--

INSERT INTO `supplier` (`id`, `date_captured`, `supplier_id`, `name`, `address`, `mobile`, `email`, `currency`, `active`) VALUES
(1, '2022-12-29 09:37:15am', 'S1234E', 'DANIEL', 'HARARE', '0774233045', 'daniel@gmail.com', 'USD', 1);

-- --------------------------------------------------------

--
-- Table structure for table `supplier_invoice`
--

CREATE TABLE `supplier_invoice` (
  `id` int NOT NULL,
  `gl_account` varchar(100) NOT NULL,
  `date_created` varchar(30) NOT NULL,
  `name` varchar(200) NOT NULL,
  `inv_date` varchar(30) NOT NULL,
  `inv_number` varchar(100) NOT NULL,
  `currency` varchar(100) NOT NULL,
  `description` varchar(300) NOT NULL,
  `quantity` varchar(100) NOT NULL,
  `price` varchar(100) NOT NULL,
  `discount` varchar(100) NOT NULL,
  `total_amount` varchar(100) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `supplier_invoice`
--

INSERT INTO `supplier_invoice` (`id`, `gl_account`, `date_created`, `name`, `inv_date`, `inv_number`, `currency`, `description`, `quantity`, `price`, `discount`, `total_amount`, `active`) VALUES
(15, '', '2022-12-29 03:08:35pm', 'DANIEL', '2022-12-08', 'INV0001', 'USD', 'eee', '222', '2', '22', '346.32', 1),
(16, '', '2022-12-29 03:14:01pm', 'DANIEL', '2022-12-13', 'INV0002', 'USD', 'rr', '33', '3', '33', '66.33', 1),
(17, 'Income', '2023-01-03 03:13:00pm', 'DANIEL', '2023-01-03', 'INV0004', 'USD', 'jj', '4', '1', '1', '3.96', 1),
(20, 'Income', '2023-01-04 11:33:21am', 'DANIEL', '2023-01-04', 'INV0005', 'USD', '100 mari', '100', '1', '2', '98', 1);

-- --------------------------------------------------------

--
-- Table structure for table `supplier_receipt`
--

CREATE TABLE `supplier_receipt` (
  `id` int NOT NULL,
  `date_created` varchar(30) NOT NULL,
  `gl_account` varchar(100) NOT NULL,
  `name` varchar(200) NOT NULL,
  `rec_date` varchar(30) NOT NULL,
  `rec_number` varchar(100) NOT NULL,
  `inv_number` varchar(100) NOT NULL,
  `currency` varchar(100) NOT NULL,
  `description` varchar(300) NOT NULL,
  `quantity` varchar(100) NOT NULL,
  `price` varchar(100) NOT NULL,
  `discount` varchar(100) NOT NULL,
  `total_amount` varchar(100) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `supplier_receipt`
--

INSERT INTO `supplier_receipt` (`id`, `date_created`, `gl_account`, `name`, `rec_date`, `rec_number`, `inv_number`, `currency`, `description`, `quantity`, `price`, `discount`, `total_amount`, `active`) VALUES
(7, '2022-12-29 03:14:55pm', '', 'DANIEL', '2022-12-20', 'REC0001', 'INV0001', 'USD', 'GHGH', '128', '2', '10', '230.4', 1),
(8, '2023-01-04 11:44:55am', 'Income', 'DANIEL', '2023-01-09', 'REC0002', 'INV0005', 'USD', '1000 mari', '100', '2', '2', '196', 1);

-- --------------------------------------------------------

--
-- Table structure for table `supplier_statement`
--

CREATE TABLE `supplier_statement` (
  `id` int NOT NULL,
  `gl_account` varchar(100) NOT NULL,
  `supplier` varchar(200) NOT NULL,
  `reference` varchar(200) NOT NULL,
  `description` varchar(200) NOT NULL,
  `currency` varchar(100) NOT NULL,
  `debit` varchar(100) NOT NULL,
  `credit` varchar(100) NOT NULL,
  `date` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `supplier_statement`
--

INSERT INTO `supplier_statement` (`id`, `gl_account`, `supplier`, `reference`, `description`, `currency`, `debit`, `credit`, `date`) VALUES
(6, '', 'DANIEL', 'INV0001', 'eee', 'USD', '0', '346.32', '2022-12-08'),
(7, '', 'DANIEL', 'INV0002', 'rr', 'USD', '0', '66.33', '2022-12-13'),
(8, '', 'DANIEL', 'REC0003', 'GHGH', 'USD', '230.4', '0', '2022-12-20'),
(12, 'Income', 'DANIEL', 'INV0004', '100 mari', 'USD', '0', '98', '2023-01-04'),
(13, 'Income', 'DANIEL', 'REC0005', '1000 mari', 'USD', '196', '0', '2023-01-09');

-- --------------------------------------------------------

--
-- Table structure for table `teacher_subjects`
--

CREATE TABLE `teacher_subjects` (
  `id` int NOT NULL,
  `session_id` int DEFAULT NULL,
  `class_section_id` int DEFAULT NULL,
  `subject_id` int DEFAULT NULL,
  `teacher_id` int DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `teacher_subjects`
--

INSERT INTO `teacher_subjects` (`id`, `session_id`, `class_section_id`, `subject_id`, `teacher_id`, `description`, `is_active`, `updated_at`) VALUES
(1, 18, 2, 2, 2, NULL, 'no', ''),
(2, 18, 2, 0, 0, NULL, 'no', ''),
(3, 18, 9, 5, 3, NULL, 'no', '');

-- --------------------------------------------------------

--
-- Table structure for table `teams`
--

CREATE TABLE `teams` (
  `id` int NOT NULL,
  `date_captured` varchar(50) NOT NULL,
  `team_name` varchar(200) NOT NULL,
  `sportcode` varchar(200) NOT NULL,
  `coachname` varchar(200) NOT NULL,
  `venue` varchar(200) NOT NULL,
  `description` varchar(200) NOT NULL,
  `active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `teams`
--

INSERT INTO `teams` (`id`, `date_captured`, `team_name`, `sportcode`, `coachname`, `venue`, `description`, `active`) VALUES
(1, '2022-11-10 01:58:03pm', 'house 1', 'soc22', 'daniel', 'harare', 'news', 1);

-- --------------------------------------------------------

--
-- Table structure for table `timetables`
--

CREATE TABLE `timetables` (
  `id` int NOT NULL,
  `teacher_subject_id` int DEFAULT NULL,
  `day_name` varchar(50) DEFAULT NULL,
  `start_time` varchar(50) DEFAULT NULL,
  `end_time` varchar(50) DEFAULT NULL,
  `room_no` varchar(50) DEFAULT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `timetables`
--

INSERT INTO `timetables` (`id`, `teacher_subject_id`, `day_name`, `start_time`, `end_time`, `room_no`, `is_active`, `updated_at`) VALUES
(1, 3, 'Monday', '08:00 AM', '08:30 AM', '', 'no', ''),
(2, 3, 'Tuesday', '10:00 AM', '10:30 PM', '', 'no', ''),
(3, 3, 'Wednesday', '02:00 PM', '02:30 AM', '', 'no', ''),
(4, 3, 'Thursday', '09:00 AM', '09:30 AM', '', 'no', ''),
(5, 3, 'Friday', '10:00 AM', '10:30 AM', '', 'no', ''),
(6, 3, 'Saturday', '', '', '', 'no', ''),
(7, 3, 'Sunday', '', '', '', 'no', '');

-- --------------------------------------------------------

--
-- Table structure for table `transport_route`
--

CREATE TABLE `transport_route` (
  `id` int NOT NULL,
  `route_title` varchar(100) DEFAULT NULL,
  `no_of_vehicle` int DEFAULT NULL,
  `fare` float(10,2) DEFAULT NULL,
  `note` text,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `transport_route`
--

INSERT INTO `transport_route` (`id`, `route_title`, `no_of_vehicle`, `fare`, `note`, `is_active`, `updated_at`) VALUES
(1, 'Hrare', NULL, 50.00, NULL, 'no', ''),
(3, 'Glenorah', NULL, 30.00, NULL, 'no', ''),
(4, 'Kuwadzana 4', NULL, 20.00, NULL, 'no', '');

-- --------------------------------------------------------

--
-- Table structure for table `types`
--

CREATE TABLE `types` (
  `id` int NOT NULL,
  `types` varchar(255) NOT NULL,
  `created_at` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `types`
--

INSERT INTO `types` (`id`, `types`, `created_at`) VALUES
(4, 'style-style', '2022-07-14'),
(5, 'gender', '2022-07-14'),
(6, 'size', '2022-07-14'),
(7, 'colour', '2022-07-14');

-- --------------------------------------------------------

--
-- Table structure for table `uniformitem`
--

CREATE TABLE `uniformitem` (
  `id` int NOT NULL,
  `studentid` varchar(200) NOT NULL,
  `itemcode` varchar(200) NOT NULL,
  `itemdescript` varchar(200) NOT NULL,
  `itemgroups` varchar(200) NOT NULL,
  `warehouse` varchar(255) NOT NULL,
  `costprice` varchar(200) NOT NULL,
  `sellingprice` varchar(200) NOT NULL,
  `quantity` varchar(200) NOT NULL,
  `originalqnty` varchar(100) NOT NULL,
  `groupsize` varchar(200) NOT NULL,
  `valuesize` varchar(200) NOT NULL,
  `groupstyle` varchar(200) NOT NULL,
  `stylevalue` varchar(200) NOT NULL,
  `colourgroup` varchar(200) NOT NULL,
  `colourvalue` varchar(200) NOT NULL,
  `gendergroup` varchar(200) NOT NULL,
  `gendervalue` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `uniformitem`
--

INSERT INTO `uniformitem` (`id`, `studentid`, `itemcode`, `itemdescript`, `itemgroups`, `warehouse`, `costprice`, `sellingprice`, `quantity`, `originalqnty`, `groupsize`, `valuesize`, `groupstyle`, `stylevalue`, `colourgroup`, `colourvalue`, `gendergroup`, `gendervalue`, `created_at`) VALUES
(1, '', 'oo', 'ooo', 'shirts', 'shop1', '20', '25', '5', '10', 'shirts', '14', 'shirts', 'striped', 'shirts', 'blue', 'shirts', 'lll', '2022-07-10'),
(2, '', 'grade1', 'shirt', 'shirts', 'shop1', '20', '25', '25', '25', 'shirts', '11', 'Shirt Style', 'Long Sleeved', 'shirts', 'L/S White', 'shirts', 'Boys', '2022-07-14'),
(3, '', 'SH-11-SS-BLUE', 'shirt size 11-short sleeve-blue', 'select', 'tuckshop', '10', '20', '48', '50', 'Shirt size', '11', 'Shirt style', 'ss', 'Shirt color', 'blue', 'Shirt gender', 'boy', '2022-11-24');

-- --------------------------------------------------------

--
-- Table structure for table `uniformpos`
--

CREATE TABLE `uniformpos` (
  `id` int NOT NULL,
  `student_id` varchar(255) NOT NULL,
  `itemcode` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `quantity` int NOT NULL,
  `amount` varchar(255) NOT NULL,
  `payment` varchar(255) NOT NULL,
  `created_date` varchar(255) NOT NULL,
  `balance` varchar(255) NOT NULL,
  `negativequantity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `uniformpos`
--

INSERT INTO `uniformpos` (`id`, `student_id`, `itemcode`, `description`, `quantity`, `amount`, `payment`, `created_date`, `balance`, `negativequantity`) VALUES
(16, 'LEA001', 'SH-11-SS-BLUE', 'shirt-size 11-short sleeve-blue', 2, '40', 'USD', '2022-11-24', '-20', 0);

-- --------------------------------------------------------

--
-- Table structure for table `uniform_group`
--

CREATE TABLE `uniform_group` (
  `id` int NOT NULL,
  `groups` varchar(200) NOT NULL,
  `group_type` varchar(400) NOT NULL,
  `is_active` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `uploaded_at` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `uniform_group`
--

INSERT INTO `uniform_group` (`id`, `groups`, `group_type`, `is_active`, `created_at`, `uploaded_at`) VALUES
(12, 'Shirt style', 'style-style', '', '2022-11-24', 0),
(13, 'Shirt color', 'colour', '', '2022-11-24', 0),
(14, 'Shirt gender', 'gender', '', '2022-11-24', 0),
(15, 'Shirt size', 'size', '', '2022-11-24', 0);

-- --------------------------------------------------------

--
-- Table structure for table `uniform_values`
--

CREATE TABLE `uniform_values` (
  `id` int NOT NULL,
  `values` varchar(200) NOT NULL,
  `description` varchar(200) NOT NULL,
  `groups` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `is_active` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `uniform_values`
--

INSERT INTO `uniform_values` (`id`, `values`, `description`, `groups`, `created_at`, `is_active`) VALUES
(6, '11', 'size 11', 'Shirt size', '2022-11-24', 0),
(7, 'blue', 'Shirt colour', 'Shirt color', '2022-11-24', 0),
(8, 'boy', 'Shirt gender', 'Shirt gender', '2022-11-24', 0),
(9, 'ss', 'shirt style', 'Shirt style', '2022-11-24', 0);

-- --------------------------------------------------------

--
-- Table structure for table `userlog`
--

CREATE TABLE `userlog` (
  `id` int NOT NULL,
  `user` varchar(100) DEFAULT NULL,
  `role` varchar(100) DEFAULT NULL,
  `ipaddress` varchar(100) DEFAULT NULL,
  `user_agent` varchar(500) DEFAULT NULL,
  `login_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `userlog`
--

INSERT INTO `userlog` (`id`, `user`, `role`, `ipaddress`, `user_agent`) VALUES
(1, 'superadmin@gmail.com', 'Super Admin', '127.0.0.1', 'Firefox 108.0, Windows 10'),
(216, 'superadmin@gmail.com', 'Super Admin', '127.0.0.1', 'Firefox 107.0, Windows 10'),
(217, 'superadmin@gmail.com', 'Super Admin', '127.0.0.1', 'Firefox 107.0, Windows 10'),
(218, 'superadmin@gmail.com', 'Super Admin', '127.0.0.1', 'Firefox 107.0, Windows 10'),
(219, 'superadmin@gmail.com', 'Super Admin', '127.0.0.1', 'Firefox 107.0, Windows 10'),
(220, 'superadmin@gmail.com', 'Super Admin', '127.0.0.1', 'Firefox 107.0, Windows 10'),
(221, 'superadmin@gmail.com', 'Super Admin', '127.0.0.1', 'Firefox 107.0, Windows 10'),
(222, 'superadmin@gmail.com', 'Super Admin', '197.221.255.124', 'Firefox 109.0, Windows 10'),
(223, 'superadmin@gmail.com', 'Super Admin', '197.221.255.124', 'Firefox 109.0, Windows 10'),
(224, 'superadmin@gmail.com', 'Super Admin', '77.246.53.27', 'Chrome 108.0.0.0, Android'),
(225, 'superadmin@gmail.com', 'Super Admin', '197.221.255.91', 'Chrome 108.0.0.0, Android'),
(226, 'superadmin@gmail.com', 'Super Admin', '197.221.255.6', 'Firefox 109.0, Windows 10'),
(227, 'superadmin@gmail.com', 'Super Admin', '197.221.255.6', 'Chrome 109.0.0.0, Windows 10'),
(228, 'superadmin@gmail.com', 'Super Admin', '197.221.255.6', 'Firefox 109.0, Windows 10');

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `childs` text NOT NULL,
  `role` varchar(30) NOT NULL,
  `verification_code` varchar(200) NOT NULL,
  `is_active` varchar(255) DEFAULT 'yes',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `user_id`, `username`, `password`, `childs`, `role`, `verification_code`, `is_active`, `updated_at`) VALUES
(1, 1, 'std1', 'ekxmgt', '', 'student', '', 'yes', '0000-00-00 00:00:00'),
(2, 0, 'parent1', 'ph601n', '1', 'parent', '', 'yes', '0000-00-00 00:00:00'),
(3, 2, 'std2', 'o1e29q', '', 'student', '', 'yes', ''),
(4, 0, 'parent2', '167lj4', '2', 'parent', '', 'yes', ''),
(5, 3, 'std3', '4gwfdd', '', 'student', '', 'yes', ''),
(6, 0, 'parent3', 'mr4xw6', '3', 'parent', '', 'yes', ''),
(7, 0, 'std0', '345igo', '', 'student', '', 'yes', '');

-- --------------------------------------------------------

--
-- Table structure for table `users_authentication`
--

CREATE TABLE `users_authentication` (
  `id` int NOT NULL,
  `users_id` int NOT NULL,
  `token` varchar(255) NOT NULL,
  `expired_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `vehicles`
--

CREATE TABLE `vehicles` (
  `id` int UNSIGNED NOT NULL,
  `vehicle_no` varchar(20) DEFAULT NULL,
  `vehicle_model` varchar(100) NOT NULL DEFAULT 'None',
  `manufacture_year` varchar(4) DEFAULT NULL,
  `driver_name` varchar(50) DEFAULT NULL,
  `driver_licence` varchar(50) NOT NULL DEFAULT 'None',
  `driver_contact` varchar(20) DEFAULT NULL,
  `note` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `vehicles`
--

INSERT INTO `vehicles` (`id`, `vehicle_no`, `vehicle_model`, `manufacture_year`, `driver_name`, `driver_licence`, `driver_contact`, `note`) VALUES
(2, 'H123W', 'Toyota Hiace', '2006', 'Munya', '5eer413', '0776123554', 'Toyota hiace given to munya');

-- --------------------------------------------------------

--
-- Table structure for table `vehicle_routes`
--

CREATE TABLE `vehicle_routes` (
  `id` int UNSIGNED NOT NULL,
  `route_id` int DEFAULT NULL,
  `vehicle_id` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `vehicle_routes`
--

INSERT INTO `vehicle_routes` (`id`, `route_id`, `vehicle_id`) VALUES
(2, 3, 2);

-- --------------------------------------------------------

--
-- Table structure for table `visitors_book`
--

CREATE TABLE `visitors_book` (
  `id` int NOT NULL,
  `source` varchar(100) DEFAULT NULL,
  `purpose` varchar(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `contact` varchar(12) NOT NULL,
  `id_proof` varchar(50) NOT NULL,
  `no_of_pepple` int NOT NULL,
  `date` date NOT NULL,
  `in_time` varchar(20) NOT NULL,
  `out_time` varchar(20) NOT NULL,
  `note` mediumtext NOT NULL,
  `image` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `visitors_purpose`
--

CREATE TABLE `visitors_purpose` (
  `id` int NOT NULL,
  `visitors_purpose` varchar(100) NOT NULL,
  `description` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `warehouse`
--

CREATE TABLE `warehouse` (
  `id` int NOT NULL,
  `warehouse` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `created_date` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `warehouse`
--

INSERT INTO `warehouse` (`id`, `warehouse`, `description`, `created_date`) VALUES
(1, 'shop1', 'shop', ''),
(3, 'tuckshop', 'tuckshop', '2022-11-24');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accummdeprec`
--
ALTER TABLE `accummdeprec`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `allergies`
--
ALTER TABLE `allergies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `assets`
--
ALTER TABLE `assets`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `assettypes`
--
ALTER TABLE `assettypes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `attendence_type`
--
ALTER TABLE `attendence_type`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bankrec`
--
ALTER TABLE `bankrec`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bankrec_yrperiod`
--
ALTER TABLE `bankrec_yrperiod`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bank_rates`
--
ALTER TABLE `bank_rates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bank_rates_history`
--
ALTER TABLE `bank_rates_history`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `books`
--
ALTER TABLE `books`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `book_depreciation`
--
ALTER TABLE `book_depreciation`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `book_issues`
--
ALTER TABLE `book_issues`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cashbook`
--
ALTER TABLE `cashbook`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cashbook_accounts`
--
ALTER TABLE `cashbook_accounts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cashbook_report`
--
ALTER TABLE `cashbook_report`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `certificates`
--
ALTER TABLE `certificates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `classes`
--
ALTER TABLE `classes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `class_sections`
--
ALTER TABLE `class_sections`
  ADD PRIMARY KEY (`id`),
  ADD KEY `class_id` (`class_id`),
  ADD KEY `section_id` (`section_id`);

--
-- Indexes for table `class_teacher`
--
ALTER TABLE `class_teacher`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `complaint`
--
ALTER TABLE `complaint`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `complaint_type`
--
ALTER TABLE `complaint_type`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contents`
--
ALTER TABLE `contents`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `content_for`
--
ALTER TABLE `content_for`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_id` (`content_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `currency`
--
ALTER TABLE `currency`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `currency_table`
--
ALTER TABLE `currency_table`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customer`
--
ALTER TABLE `customer`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customer_invoice`
--
ALTER TABLE `customer_invoice`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customer_receipt`
--
ALTER TABLE `customer_receipt`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customer_statement`
--
ALTER TABLE `customer_statement`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `department`
--
ALTER TABLE `department`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `depreciationexpenses`
--
ALTER TABLE `depreciationexpenses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `depreciationmethods`
--
ALTER TABLE `depreciationmethods`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dispatch_receive`
--
ALTER TABLE `dispatch_receive`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `email_config`
--
ALTER TABLE `email_config`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `enquiry`
--
ALTER TABLE `enquiry`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `enquiry_type`
--
ALTER TABLE `enquiry_type`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `exams`
--
ALTER TABLE `exams`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `exam_results`
--
ALTER TABLE `exam_results`
  ADD PRIMARY KEY (`id`),
  ADD KEY `exam_schedule_id` (`exam_schedule_id`),
  ADD KEY `student_id` (`student_id`);

--
-- Indexes for table `exam_schedules`
--
ALTER TABLE `exam_schedules`
  ADD PRIMARY KEY (`id`),
  ADD KEY `teacher_subject_id` (`teacher_subject_id`);

--
-- Indexes for table `expenses`
--
ALTER TABLE `expenses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `expense_head`
--
ALTER TABLE `expense_head`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fd_department`
--
ALTER TABLE `fd_department`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `feecategory`
--
ALTER TABLE `feecategory`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `feemasters`
--
ALTER TABLE `feemasters`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fees_discounts`
--
ALTER TABLE `fees_discounts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `session_id` (`session_id`);

--
-- Indexes for table `feetype`
--
ALTER TABLE `feetype`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fee_groups`
--
ALTER TABLE `fee_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fee_groups_feetype`
--
ALTER TABLE `fee_groups_feetype`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fee_session_group_id` (`fee_session_group_id`),
  ADD KEY `fee_groups_id` (`fee_groups_id`),
  ADD KEY `feetype_id` (`feetype_id`),
  ADD KEY `session_id` (`session_id`);

--
-- Indexes for table `fee_receipt_no`
--
ALTER TABLE `fee_receipt_no`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fee_session_groups`
--
ALTER TABLE `fee_session_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fee_groups_id` (`fee_groups_id`),
  ADD KEY `session_id` (`session_id`);

--
-- Indexes for table `follow_up`
--
ALTER TABLE `follow_up`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `front_cms_media_gallery`
--
ALTER TABLE `front_cms_media_gallery`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `front_cms_menus`
--
ALTER TABLE `front_cms_menus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `front_cms_menu_items`
--
ALTER TABLE `front_cms_menu_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `front_cms_pages`
--
ALTER TABLE `front_cms_pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `front_cms_page_contents`
--
ALTER TABLE `front_cms_page_contents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `page_id` (`page_id`);

--
-- Indexes for table `front_cms_programs`
--
ALTER TABLE `front_cms_programs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `front_cms_program_photos`
--
ALTER TABLE `front_cms_program_photos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `program_id` (`program_id`);

--
-- Indexes for table `front_cms_settings`
--
ALTER TABLE `front_cms_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `general_calls`
--
ALTER TABLE `general_calls`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `glaccount_types`
--
ALTER TABLE `glaccount_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `glledger_account`
--
ALTER TABLE `glledger_account`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `glsub_account`
--
ALTER TABLE `glsub_account`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `grades`
--
ALTER TABLE `grades`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `homework`
--
ALTER TABLE `homework`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `homework_evaluation`
--
ALTER TABLE `homework_evaluation`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `home_currency`
--
ALTER TABLE `home_currency`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hostel`
--
ALTER TABLE `hostel`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hostel_rooms`
--
ALTER TABLE `hostel_rooms`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `id_card`
--
ALTER TABLE `id_card`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `income`
--
ALTER TABLE `income`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `income_head`
--
ALTER TABLE `income_head`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `item`
--
ALTER TABLE `item`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `item_category`
--
ALTER TABLE `item_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `item_issue`
--
ALTER TABLE `item_issue`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_id` (`item_id`),
  ADD KEY `item_category_id` (`item_category_id`);

--
-- Indexes for table `item_stock`
--
ALTER TABLE `item_stock`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_id` (`item_id`),
  ADD KEY `supplier_id` (`supplier_id`),
  ADD KEY `store_id` (`store_id`);

--
-- Indexes for table `item_store`
--
ALTER TABLE `item_store`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `item_supplier`
--
ALTER TABLE `item_supplier`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `journal`
--
ALTER TABLE `journal`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `journal_accounts`
--
ALTER TABLE `journal_accounts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `leave_types`
--
ALTER TABLE `leave_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `type` (`type`);

--
-- Indexes for table `libarary_members`
--
ALTER TABLE `libarary_members`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `location`
--
ALTER TABLE `location`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `medical`
--
ALTER TABLE `medical`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `medical_details`
--
ALTER TABLE `medical_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notification_roles`
--
ALTER TABLE `notification_roles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `send_notification_id` (`send_notification_id`),
  ADD KEY `role_id` (`role_id`);

--
-- Indexes for table `notification_setting`
--
ALTER TABLE `notification_setting`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payment_methods`
--
ALTER TABLE `payment_methods`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payment_settings`
--
ALTER TABLE `payment_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payslip_allowance`
--
ALTER TABLE `payslip_allowance`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permission_category`
--
ALTER TABLE `permission_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permission_group`
--
ALTER TABLE `permission_group`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `read_notification`
--
ALTER TABLE `read_notification`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `reference`
--
ALTER TABLE `reference`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles_permissions`
--
ALTER TABLE `roles_permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `room_types`
--
ALTER TABLE `room_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `school_houses`
--
ALTER TABLE `school_houses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sch_settings`
--
ALTER TABLE `sch_settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lang_id` (`lang_id`),
  ADD KEY `session_id` (`session_id`);

--
-- Indexes for table `sections`
--
ALTER TABLE `sections`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `send_notification`
--
ALTER TABLE `send_notification`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sms_config`
--
ALTER TABLE `sms_config`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `source`
--
ALTER TABLE `source`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sport`
--
ALTER TABLE `sport`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sport_categories`
--
ALTER TABLE `sport_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `staff`
--
ALTER TABLE `staff`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `employee_id` (`employee_id`);

--
-- Indexes for table `staff_attendance`
--
ALTER TABLE `staff_attendance`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `staff_attendance_type`
--
ALTER TABLE `staff_attendance_type`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `staff_designation`
--
ALTER TABLE `staff_designation`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `staff_leave_details`
--
ALTER TABLE `staff_leave_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `staff_leave_request`
--
ALTER TABLE `staff_leave_request`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `staff_payroll`
--
ALTER TABLE `staff_payroll`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `staff_payslip`
--
ALTER TABLE `staff_payslip`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `staff_roles`
--
ALTER TABLE `staff_roles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `role_id` (`role_id`),
  ADD KEY `staff_id` (`staff_id`);

--
-- Indexes for table `staff_timeline`
--
ALTER TABLE `staff_timeline`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `students`
--
ALTER TABLE `students`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `student_attendences`
--
ALTER TABLE `student_attendences`
  ADD PRIMARY KEY (`id`),
  ADD KEY `student_session_id` (`student_session_id`),
  ADD KEY `attendence_type_id` (`attendence_type_id`);

--
-- Indexes for table `student_doc`
--
ALTER TABLE `student_doc`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `student_fees`
--
ALTER TABLE `student_fees`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `student_fees_deposite`
--
ALTER TABLE `student_fees_deposite`
  ADD PRIMARY KEY (`id`),
  ADD KEY `student_fees_master_id` (`student_fees_master_id`),
  ADD KEY `fee_groups_feetype_id` (`fee_groups_feetype_id`);

--
-- Indexes for table `student_fees_discounts`
--
ALTER TABLE `student_fees_discounts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `student_session_id` (`student_session_id`),
  ADD KEY `fees_discount_id` (`fees_discount_id`);

--
-- Indexes for table `student_fees_master`
--
ALTER TABLE `student_fees_master`
  ADD PRIMARY KEY (`id`),
  ADD KEY `student_session_id` (`student_session_id`),
  ADD KEY `fee_session_group_id` (`fee_session_group_id`);

--
-- Indexes for table `student_session`
--
ALTER TABLE `student_session`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `student_sibling`
--
ALTER TABLE `student_sibling`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `student_sport`
--
ALTER TABLE `student_sport`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `student_timeline`
--
ALTER TABLE `student_timeline`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `student_transport_fees`
--
ALTER TABLE `student_transport_fees`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `subjects`
--
ALTER TABLE `subjects`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `supplier`
--
ALTER TABLE `supplier`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `supplier_invoice`
--
ALTER TABLE `supplier_invoice`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `supplier_receipt`
--
ALTER TABLE `supplier_receipt`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `supplier_statement`
--
ALTER TABLE `supplier_statement`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `teacher_subjects`
--
ALTER TABLE `teacher_subjects`
  ADD PRIMARY KEY (`id`),
  ADD KEY `class_section_id` (`class_section_id`),
  ADD KEY `session_id` (`session_id`),
  ADD KEY `subject_id` (`subject_id`),
  ADD KEY `teacher_id` (`teacher_id`);

--
-- Indexes for table `teams`
--
ALTER TABLE `teams`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `timetables`
--
ALTER TABLE `timetables`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `transport_route`
--
ALTER TABLE `transport_route`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `types`
--
ALTER TABLE `types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `uniformitem`
--
ALTER TABLE `uniformitem`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `uniformpos`
--
ALTER TABLE `uniformpos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `uniform_group`
--
ALTER TABLE `uniform_group`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `uniform_values`
--
ALTER TABLE `uniform_values`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `userlog`
--
ALTER TABLE `userlog`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users_authentication`
--
ALTER TABLE `users_authentication`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `vehicles`
--
ALTER TABLE `vehicles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `vehicle_routes`
--
ALTER TABLE `vehicle_routes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `visitors_book`
--
ALTER TABLE `visitors_book`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `visitors_purpose`
--
ALTER TABLE `visitors_purpose`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `warehouse`
--
ALTER TABLE `warehouse`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accummdeprec`
--
ALTER TABLE `accummdeprec`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `allergies`
--
ALTER TABLE `allergies`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `assets`
--
ALTER TABLE `assets`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `assettypes`
--
ALTER TABLE `assettypes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `attendence_type`
--
ALTER TABLE `attendence_type`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `bankrec`
--
ALTER TABLE `bankrec`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `bankrec_yrperiod`
--
ALTER TABLE `bankrec_yrperiod`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `bank_rates`
--
ALTER TABLE `bank_rates`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `bank_rates_history`
--
ALTER TABLE `bank_rates_history`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `books`
--
ALTER TABLE `books`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `book_depreciation`
--
ALTER TABLE `book_depreciation`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `book_issues`
--
ALTER TABLE `book_issues`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `cashbook`
--
ALTER TABLE `cashbook`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `cashbook_accounts`
--
ALTER TABLE `cashbook_accounts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `cashbook_report`
--
ALTER TABLE `cashbook_report`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `certificates`
--
ALTER TABLE `certificates`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `classes`
--
ALTER TABLE `classes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `class_sections`
--
ALTER TABLE `class_sections`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `class_teacher`
--
ALTER TABLE `class_teacher`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `complaint`
--
ALTER TABLE `complaint`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `complaint_type`
--
ALTER TABLE `complaint_type`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contents`
--
ALTER TABLE `contents`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `content_for`
--
ALTER TABLE `content_for`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `currency`
--
ALTER TABLE `currency`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `currency_table`
--
ALTER TABLE `currency_table`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `customer`
--
ALTER TABLE `customer`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `customer_invoice`
--
ALTER TABLE `customer_invoice`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `customer_receipt`
--
ALTER TABLE `customer_receipt`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `customer_statement`
--
ALTER TABLE `customer_statement`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `department`
--
ALTER TABLE `department`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `depreciationexpenses`
--
ALTER TABLE `depreciationexpenses`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `depreciationmethods`
--
ALTER TABLE `depreciationmethods`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `dispatch_receive`
--
ALTER TABLE `dispatch_receive`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `email_config`
--
ALTER TABLE `email_config`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `enquiry`
--
ALTER TABLE `enquiry`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `enquiry_type`
--
ALTER TABLE `enquiry_type`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `exams`
--
ALTER TABLE `exams`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `exam_results`
--
ALTER TABLE `exam_results`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `exam_schedules`
--
ALTER TABLE `exam_schedules`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expenses`
--
ALTER TABLE `expenses`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `expense_head`
--
ALTER TABLE `expense_head`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `fd_department`
--
ALTER TABLE `fd_department`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `feecategory`
--
ALTER TABLE `feecategory`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `feemasters`
--
ALTER TABLE `feemasters`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fees_discounts`
--
ALTER TABLE `fees_discounts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `feetype`
--
ALTER TABLE `feetype`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `fee_groups`
--
ALTER TABLE `fee_groups`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `fee_groups_feetype`
--
ALTER TABLE `fee_groups_feetype`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `fee_receipt_no`
--
ALTER TABLE `fee_receipt_no`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fee_session_groups`
--
ALTER TABLE `fee_session_groups`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `follow_up`
--
ALTER TABLE `follow_up`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `general_calls`
--
ALTER TABLE `general_calls`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `glaccount_types`
--
ALTER TABLE `glaccount_types`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `glledger_account`
--
ALTER TABLE `glledger_account`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `glsub_account`
--
ALTER TABLE `glsub_account`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `grades`
--
ALTER TABLE `grades`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `homework`
--
ALTER TABLE `homework`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `homework_evaluation`
--
ALTER TABLE `homework_evaluation`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `home_currency`
--
ALTER TABLE `home_currency`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `hostel`
--
ALTER TABLE `hostel`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hostel_rooms`
--
ALTER TABLE `hostel_rooms`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `id_card`
--
ALTER TABLE `id_card`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `income`
--
ALTER TABLE `income`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `income_head`
--
ALTER TABLE `income_head`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `item`
--
ALTER TABLE `item`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `item_category`
--
ALTER TABLE `item_category`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `item_issue`
--
ALTER TABLE `item_issue`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `item_stock`
--
ALTER TABLE `item_stock`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `item_store`
--
ALTER TABLE `item_store`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `item_supplier`
--
ALTER TABLE `item_supplier`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `journal`
--
ALTER TABLE `journal`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `journal_accounts`
--
ALTER TABLE `journal_accounts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=91;

--
-- AUTO_INCREMENT for table `leave_types`
--
ALTER TABLE `leave_types`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `libarary_members`
--
ALTER TABLE `libarary_members`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `location`
--
ALTER TABLE `location`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `medical`
--
ALTER TABLE `medical`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `medical_details`
--
ALTER TABLE `medical_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notification_roles`
--
ALTER TABLE `notification_roles`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `notification_setting`
--
ALTER TABLE `notification_setting`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `payment_methods`
--
ALTER TABLE `payment_methods`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `payment_settings`
--
ALTER TABLE `payment_settings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `payslip_allowance`
--
ALTER TABLE `payslip_allowance`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `permission_category`
--
ALTER TABLE `permission_category`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=132;

--
-- AUTO_INCREMENT for table `permission_group`
--
ALTER TABLE `permission_group`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `read_notification`
--
ALTER TABLE `read_notification`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `reference`
--
ALTER TABLE `reference`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `roles_permissions`
--
ALTER TABLE `roles_permissions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=637;

--
-- AUTO_INCREMENT for table `room_types`
--
ALTER TABLE `room_types`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `school_houses`
--
ALTER TABLE `school_houses`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sch_settings`
--
ALTER TABLE `sch_settings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sections`
--
ALTER TABLE `sections`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `send_notification`
--
ALTER TABLE `send_notification`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sessions`
--
ALTER TABLE `sessions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `sms_config`
--
ALTER TABLE `sms_config`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `source`
--
ALTER TABLE `source`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sport`
--
ALTER TABLE `sport`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sport_categories`
--
ALTER TABLE `sport_categories`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `staff`
--
ALTER TABLE `staff`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `staff_attendance`
--
ALTER TABLE `staff_attendance`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `staff_attendance_type`
--
ALTER TABLE `staff_attendance_type`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `staff_designation`
--
ALTER TABLE `staff_designation`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `staff_leave_details`
--
ALTER TABLE `staff_leave_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `staff_leave_request`
--
ALTER TABLE `staff_leave_request`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `staff_payroll`
--
ALTER TABLE `staff_payroll`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `staff_payslip`
--
ALTER TABLE `staff_payslip`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `staff_roles`
--
ALTER TABLE `staff_roles`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `staff_timeline`
--
ALTER TABLE `staff_timeline`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `students`
--
ALTER TABLE `students`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `student_attendences`
--
ALTER TABLE `student_attendences`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `student_doc`
--
ALTER TABLE `student_doc`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `student_fees`
--
ALTER TABLE `student_fees`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `student_fees_deposite`
--
ALTER TABLE `student_fees_deposite`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `student_fees_discounts`
--
ALTER TABLE `student_fees_discounts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `student_fees_master`
--
ALTER TABLE `student_fees_master`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `student_session`
--
ALTER TABLE `student_session`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `student_sibling`
--
ALTER TABLE `student_sibling`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `student_sport`
--
ALTER TABLE `student_sport`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `student_timeline`
--
ALTER TABLE `student_timeline`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `student_transport_fees`
--
ALTER TABLE `student_transport_fees`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subjects`
--
ALTER TABLE `subjects`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `supplier`
--
ALTER TABLE `supplier`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `supplier_invoice`
--
ALTER TABLE `supplier_invoice`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `supplier_receipt`
--
ALTER TABLE `supplier_receipt`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `supplier_statement`
--
ALTER TABLE `supplier_statement`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `teacher_subjects`
--
ALTER TABLE `teacher_subjects`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `teams`
--
ALTER TABLE `teams`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `timetables`
--
ALTER TABLE `timetables`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `transport_route`
--
ALTER TABLE `transport_route`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `types`
--
ALTER TABLE `types`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `uniformitem`
--
ALTER TABLE `uniformitem`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `uniformpos`
--
ALTER TABLE `uniformpos`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `uniform_group`
--
ALTER TABLE `uniform_group`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `uniform_values`
--
ALTER TABLE `uniform_values`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `userlog`
--
ALTER TABLE `userlog`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=229;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `users_authentication`
--
ALTER TABLE `users_authentication`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vehicles`
--
ALTER TABLE `vehicles`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `vehicle_routes`
--
ALTER TABLE `vehicle_routes`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `visitors_book`
--
ALTER TABLE `visitors_book`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `visitors_purpose`
--
ALTER TABLE `visitors_purpose`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `warehouse`
--
ALTER TABLE `warehouse`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

/*!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 */;
