-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 21, 2025 at 04:21 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `melsoftschoolpre_mp2`
--

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

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

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

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

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

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

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

--
-- Table structure for table `array_testing`
--

CREATE TABLE `array_testing` (
  `id` int(11) NOT NULL,
  `student_fees_master_id` int(11) NOT NULL,
  `fee_groups_feetype_id` int(11) NOT NULL,
  `amounts` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `array_testing`
--

INSERT INTO `array_testing` (`id`, `student_fees_master_id`, `fee_groups_feetype_id`, `amounts`) VALUES
(16, 0, 0, 20),
(17, 0, 0, 40),
(18, 0, 0, 200),
(19, 0, 0, 0),
(20, 0, 0, 30),
(21, 0, 0, 50),
(22, 0, 0, 250);

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

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

CREATE TABLE `assets` (
  `id` int(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `assettypes` (
  `id` int(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `attendence_type` (
  `id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `attendence_type` (`id`, `type`, `key_value`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Present', '<b class=\"text text-success\">P</b>', 'yes', '2016-06-23 18:11:37', '0000-00-00 00:00:00'),
(2, 'Late With Excuse', '<b class=\"text text-warning\">E</b>', 'no', '2018-05-29 08:19:48', '0000-00-00 00:00:00'),
(3, 'Late', '<b class=\"text text-warning\">L</b>', 'yes', '2016-06-23 18:12:28', '0000-00-00 00:00:00'),
(4, 'Absent', '<b class=\"text text-danger\">A</b>', 'yes', '2016-10-11 11:35:40', '0000-00-00 00:00:00'),
(5, 'Holiday', 'H', 'yes', '2016-10-11 11:35:01', '0000-00-00 00:00:00'),
(6, 'Half Day', '<b class=\"text text-warning\">F</b>', 'yes', '2016-06-23 18:12:28', '0000-00-00 00:00:00');

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

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

CREATE TABLE `bankrec` (
  `id` int(11) 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(11) NOT NULL,
  `cashbook_id` varchar(10) NOT NULL,
  `cashbook` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_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
(1, '2023-04-12 01:20:07p', '-110', '0', '260', '150', '-110', '0', '0', '0', 1, '64', 'PETTY CASH'),
(2, '2023-04-12 01:20:48p', '-160', '0', '260', '100', '-160', '0', '0', '0', 1, '65', 'PETTY CASH'),
(3, '2023-04-13 09:59:32a', '-45', '0', '95', '50', '-45', '0', '0', '0', 1, '68', 'PETTY CASH USD');

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

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

CREATE TABLE `bankrec_yrperiod` (
  `id` int(11) NOT NULL,
  `year` varchar(100) NOT NULL,
  `active` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_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(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `bank_rates` (`id`, `date`, `foreign_currency`, `home_currency`, `foreign_rate`, `home_rate`, `description`, `active`) VALUES
(12, '31-03-2023 07:38:31am', 'ZAR', 'USD', '18', '1', 'USD - RAND', 1),
(13, '31-03-2023 07:42:06am', 'ECOCASH', 'USD', '1', '1', 'USD-ECOCASH', 1),
(14, '08-02-2025 08:26:45pm', 'NOSTRO', 'USD', '1', '1', 'USD NOSTRO', 1),
(15, '18-02-2025 09:31:41am', 'ZWG', 'USD', '40', '1', 'USD-ZWG', 1);

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

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

CREATE TABLE `bank_rates_history` (
  `id` int(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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

CREATE TABLE `books` (
  `id` int(11) 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(11) DEFAULT NULL,
  `perunitcost` float(10,2) DEFAULT NULL,
  `postdate` date DEFAULT NULL,
  `description` text DEFAULT NULL,
  `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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `book_depreciation` (
  `id` int(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `book_issues` (
  `id` int(10) UNSIGNED NOT NULL,
  `book_id` int(11) DEFAULT NULL,
  `return_date` date DEFAULT NULL,
  `issue_date` date DEFAULT NULL,
  `is_returned` int(11) DEFAULT 0,
  `member_id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `cashbook` (
  `id` int(11) 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(11) NOT NULL,
  `bankrec` varchar(10) NOT NULL,
  `mv_expense` varchar(100) NOT NULL,
  `gl_account` varchar(100) NOT NULL,
  `date_from` varchar(50) NOT NULL,
  `date_to` varchar(50) NOT NULL,
  `currency_type` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

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

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

INSERT INTO `cashbook_accounts` (`id`, `cashbook_accounts`, `currency`, `description`, `active`) VALUES
(5, 'CABS RTGS', 'ZWL', 'CABS RTGS', 1),
(6, 'ECOCASH', 'ZWL', 'ECOCASH', 1),
(7, 'NEDBANK', 'ZAR', 'NEDBANK ZAR', 1),
(8, 'CASH ACCOUNT', 'USD', 'CASH ACCOUNT', 1),
(9, 'PETTY CASH', 'USD', 'PETTY CASH', 1);

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

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

CREATE TABLE `cashbook_report` (
  `id` int(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `cashbook_temp`
--

CREATE TABLE `cashbook_temp` (
  `id` int(11) 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(11) NOT NULL,
  `bankrec` varchar(10) NOT NULL,
  `mv_expense` varchar(100) NOT NULL,
  `gl_account` varchar(100) NOT NULL,
  `date_from` varchar(50) NOT NULL,
  `date_to` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `categories` (
  `id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `categories` (`id`, `category`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'STUDENT', 'no', '2023-02-06 22:26:19', '0000-00-00 00:00:00'),
(2, 'PREFECT', 'no', '2023-02-06 22:25:58', ''),
(3, 'WEEKLY BOARDER', 'no', '2023-02-06 22:26:43', ''),
(4, 'FULL TIME BOARDER', 'no', '2023-02-06 22:26:53', '');

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

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

CREATE TABLE `certificates` (
  `id` int(11) 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(11) NOT NULL,
  `content_height` int(11) NOT NULL,
  `footer_height` int(11) NOT NULL,
  `content_width` int(11) NOT NULL,
  `enable_student_image` tinyint(1) NOT NULL COMMENT '0=no,1=yes',
  `enable_image_height` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- 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(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

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

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

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

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

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

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

CREATE TABLE `complaint` (
  `id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

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

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

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

CREATE TABLE `contents` (
  `id` int(11) NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `is_public` varchar(10) DEFAULT 'No',
  `class_id` int(11) DEFAULT NULL,
  `cls_sec_id` int(11) NOT NULL,
  `file` varchar(250) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `note` text DEFAULT NULL,
  `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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `content_for` (
  `id` int(11) NOT NULL,
  `role` varchar(50) DEFAULT NULL,
  `content_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

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

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

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

INSERT INTO `currency` (`id`, `currency`, `description`, `active`) VALUES
(3, 'USD', 'UNITED STATES DOLLARS', 1),
(4, 'ZWG', 'ZWG', 1),
(5, 'ZAR', 'RAND', 1),
(6, 'ECOCASH', 'ECOCASH USD', 1),
(7, 'NOSTRO', 'NOSTRO USD', 1),
(8, 'ECOCASH', 'ECOCASH USD', 1),
(9, 'INNBUCKS ', 'INNBUCKS USD', 1);

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

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

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

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

INSERT INTO `currency_table` (`id`, `currencycode`, `date`, `name`, `description`, `active`) VALUES
(11, 'ZWG', '2023-03-31', 'ZWG', 'ZWG', 1),
(13, 'ZAR', '2023-03-31', 'ZAR', 'SOUTH AFRICAN RAND', 1),
(14, 'ECOCASH', '2023-03-31', 'ECOCASH', 'ECOCASH USD', 1),
(15, 'NOSTRO', '2024-10-15', 'NOSTRO', 'USD NOSTRO', 1),
(16, 'INNBUCKS', '2025-05-20', 'INNBUCKS ', 'INNBUCKS USD', 1);

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

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

CREATE TABLE `customer` (
  `id` int(11) NOT NULL,
  `date_captured` varchar(30) NOT NULL,
  `customer_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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `customer_invoice` (
  `id` int(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `customer_receipt` (
  `id` int(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `customer_statement` (
  `id` int(11) 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_general_ci;

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

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

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

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

INSERT INTO `department` (`id`, `department_name`, `is_active`) VALUES
(9, 'INFANT DEPARTMENT', 'yes'),
(10, 'CLEANING DEPARTMENT', 'yes'),
(11, 'KITCHEN DEPARTMENT', 'yes'),
(12, 'SENIOR TEACHER', 'yes'),
(13, 'ADMINISTRATION ', 'yes'),
(14, 'LOWER GRADES DEPARTMENT', 'yes'),
(15, 'UPPER GRADES DEPARTMENT', 'yes'),
(16, 'SPORTS DEPARTMENT ', 'yes'),
(17, 'TRANSPORT DEPARTMENT', 'yes'),
(18, 'PREFECTS DEPARTMENT', 'yes'),
(19, 'SECURITY DEPARTMENT', 'yes');

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

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

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

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

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

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

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

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

CREATE TABLE `dispatch_receive` (
  `id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `email_config` (
  `id` int(10) 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=utf8 COLLATE=utf8_general_ci;

--
-- 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`, `created_at`) VALUES
(1, 'sendmail', '', '', '', '', '', '', '2017-12-04 22:33:22');

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

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

CREATE TABLE `enquiry` (
  `id` int(11) 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(11) NOT NULL,
  `no_of_child` varchar(11) DEFAULT NULL,
  `status` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

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

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

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

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

CREATE TABLE `events` (
  `id` int(11) 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(11) NOT NULL,
  `is_active` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `exams` (
  `id` int(11) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `sesion_id` int(11) NOT NULL,
  `note` text 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `exam_results` (
  `id` int(11) NOT NULL,
  `attendence` varchar(10) NOT NULL,
  `exam_schedule_id` int(11) DEFAULT NULL,
  `student_id` int(11) DEFAULT NULL,
  `get_marks` float(10,2) DEFAULT NULL,
  `note` text 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `exam_schedules` (
  `id` int(11) NOT NULL,
  `session_id` int(11) NOT NULL,
  `exam_id` int(11) DEFAULT NULL,
  `teacher_subject_id` int(11) 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(11) DEFAULT NULL,
  `passing_marks` int(11) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `expenses` (
  `id` int(11) NOT NULL,
  `exp_head_id` int(11) 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 DEFAULT NULL,
  `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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `expense_head` (
  `id` int(11) NOT NULL,
  `exp_category` varchar(50) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `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=utf8 COLLATE=utf8_general_ci;

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

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

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

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

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

CREATE TABLE `feecategory` (
  `id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `feemasters` (
  `id` int(11) NOT NULL,
  `session_id` int(11) DEFAULT NULL,
  `feetype_id` int(11) NOT NULL,
  `class_id` int(11) DEFAULT NULL,
  `amount` float(10,2) DEFAULT NULL,
  `description` text 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `fees_discounts` (
  `id` int(11) NOT NULL,
  `session_id` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `code` varchar(100) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `description` text 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `feetype` (
  `id` int(11) NOT NULL,
  `is_system` int(11) NOT NULL DEFAULT 0,
  `feecategory_id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `fee_groups` (
  `id` int(11) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `is_system` int(11) NOT NULL DEFAULT 0,
  `description` text 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `fee_groups_feetype` (
  `id` int(11) NOT NULL,
  `fee_session_group_id` int(11) DEFAULT NULL,
  `fee_groups_id` int(11) DEFAULT NULL,
  `feetype_id` int(11) DEFAULT NULL,
  `session_id` int(11) 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(),
  `routes` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `fee_receipt_no` (
  `id` int(11) NOT NULL,
  `payment` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `fee_session_groups` (
  `id` int(11) NOT NULL,
  `fee_groups_id` int(11) DEFAULT NULL,
  `session_id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `follow_up` (
  `id` int(11) NOT NULL,
  `enquiry_id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `front_cms_media_gallery` (
  `id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `front_cms_menus` (
  `id` int(11) NOT NULL,
  `menu` varchar(100) DEFAULT NULL,
  `slug` varchar(200) DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  `open_new_tab` int(11) NOT NULL DEFAULT 0,
  `ext_url` mediumtext NOT NULL,
  `ext_url_link` mediumtext NOT NULL,
  `publish` int(11) 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=utf8 COLLATE=utf8_general_ci;

--
-- 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`, `created_at`) VALUES
(1, 'Main Menu', 'main-menu', 'Main menu', 0, '', '', 0, 'default', 'no', '2018-04-20 10:54:49'),
(2, 'Bottom Menu', 'bottom-menu', 'Bottom Menu', 0, '', '', 0, 'default', 'no', '2018-04-20 10:54:55');

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

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

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

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

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

CREATE TABLE `front_cms_pages` (
  `id` int(11) NOT NULL,
  `page_type` varchar(10) NOT NULL DEFAULT 'manual',
  `is_homepage` int(11) 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 DEFAULT NULL,
  `meta_description` mediumtext DEFAULT NULL,
  `meta_keyword` mediumtext DEFAULT NULL,
  `feature_image` varchar(200) NOT NULL,
  `description` longtext DEFAULT NULL,
  `publish_date` date NOT NULL,
  `publish` int(11) DEFAULT 0,
  `sidebar` int(11) DEFAULT 0,
  `is_active` varchar(10) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- 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`, `created_at`) VALUES
(1, 'default', 1, 'Home', 'page/home', 'page', 'home', '', '', '', '', '<p>home page</p>', '0000-00-00', 1, NULL, 'no', '2018-07-11 14:04:33'),
(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', '2018-05-09 11:14:34'),
(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', '2018-05-18 10:46:04'),
(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', '2018-07-11 14:03:41');

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

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

CREATE TABLE `front_cms_page_contents` (
  `id` int(11) NOT NULL,
  `page_id` int(11) DEFAULT NULL,
  `content_type` varchar(50) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `front_cms_programs` (
  `id` int(11) NOT NULL,
  `type` varchar(50) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `url` mediumtext DEFAULT NULL,
  `title` varchar(200) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `event_start` date DEFAULT NULL,
  `event_end` date DEFAULT NULL,
  `event_venue` mediumtext DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  `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(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `front_cms_program_photos` (
  `id` int(11) NOT NULL,
  `program_id` int(11) DEFAULT NULL,
  `media_gallery_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `front_cms_settings` (
  `id` int(11) NOT NULL,
  `theme` varchar(50) DEFAULT NULL,
  `is_active_rtl` int(11) DEFAULT 0,
  `is_active_front_cms` int(11) DEFAULT 0,
  `is_active_sidebar` int(11) 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 DEFAULT NULL,
  `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=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `front_cms_settings`
--

INSERT INTO `front_cms_settings` (`id`, `theme`, `is_active_rtl`, `is_active_front_cms`, `is_active_sidebar`, `logo`, `contact_us_email`, `complain_form_email`, `sidebar_options`, `fb_url`, `twitter_url`, `youtube_url`, `google_plus`, `instagram_url`, `pinterest_url`, `linkedin_url`, `google_analytics`, `footer_text`, `fav_icon`, `created_at`) VALUES
(0, 'default', 1, 1, 1, './uploads/school_content/logo/front_logo-63d227cd056bf8.35545872.png', '', '', '[\"news\"]', '', '', '', '', '', '', '', 'none', 'Melsoft School Standard By Melsoft Pvt', './uploads/school_content/logo/front_fav_icon-63d227cd05ccd9.67557367.png', '2023-01-26 07:12:13');

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

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

CREATE TABLE `general_calls` (
  `id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

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

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

INSERT INTO `glaccount_types` (`id`, `name`, `description`, `active`) VALUES
(1, 'Other Income', 'Other Income', 1),
(2, 'Expenses', 'Expenses', 1),
(3, 'Revenue', 'Revenue', 1),
(4, 'Cost of Sales', 'Cost of Sales', 1),
(5, 'Property, Plant & Equipment ', 'Property, Plant & Equipment ', 1),
(7, 'Other Expenses', 'Other Expenses', 1),
(8, 'Cash, or Cash Equivalent', 'Cash, or Cash Equivalent ', 1),
(9, 'Other Current Liability', 'Other Current Liability', 1),
(10, 'Trade Receivable', 'Trade Receivable', 1),
(11, 'Trade Payable', 'Trade Payable', 1),
(12, 'VAT Control', 'VAT Control', 1),
(13, 'Prepayment', 'Prepayment', 1),
(14, 'Other Current Asset', 'Other Current Asset', 1),
(15, 'Current Asset ', 'Current Asset ', 1),
(16, 'Long term liability', 'Long term liability', 1),
(17, 'Liability', 'Liability', 1),
(18, 'Non-Current Asset ', 'Non-Current Asset ', 1),
(19, 'Cost of Goods Sold ', 'Cost of Goods Sold ', 1),
(20, 'Fixed Assets', 'Fixed Assets', 1),
(21, 'Inventory ', 'Inventory ', 1),
(22, 'Equity', 'Equity', 1);

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

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

CREATE TABLE `glledger_account` (
  `id` int(11) 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(11) NOT NULL,
  `balance_totals` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `glledger_account` (`id`, `date`, `gl_code`, `name`, `description`, `account_type`, `active`, `balance_totals`) VALUES
(100, '2023-01-10 01:29:09pm', '1000', 'Fees Income ', 'Fees Income', 'Revenue', 1, ''),
(102, '2023-01-10 01:30:04pm', '2000', 'Purchases Grocery ', 'Purchases Grocery ', 'Cost of Sales', 1, ''),
(104, '2023-01-10 01:30:48pm', '4000', 'General Expenses', 'General Expenses', 'Expenses', 1, ''),
(106, '2023-01-10 01:31:39pm', '4100', 'Motor Vehicle Expenses', 'Motor Vehicle Expenses', 'Expenses', 1, ''),
(108, '2023-01-10 01:32:21pm', '4200', 'Repairs & Maintenance', 'Repairs & Maintenance', 'Expenses', 1, ''),
(110, '2023-01-10 01:32:52pm', '4300', 'Admin Expenses', 'Admin Expenses', 'Expenses', 1, ''),
(112, '2023-01-10 01:33:44pm', '4400', 'HR & Staff Expenses', 'HR & Staff Expenses', 'Expenses', 1, ''),
(114, '2023-01-10 01:34:46pm', '4500', 'Printing & Stationery', 'Printing & Stationery', 'Expenses', 1, ''),
(116, '2023-01-15 03:33:46am', '9550', 'Suspense Take On', 'Suspense Take On', 'Other Current Liability', 1, ''),
(118, '2023-01-15 03:34:37am', '9500', 'Suspense ', 'Suspense ', 'Other Current Liability', 1, ''),
(120, '2023-01-15 10:45:07am', '4600', 'Depreciation ', 'Depreciation Expenses', 'Expenses', 1, ''),
(122, '2023-03-31 08:20:29am', '4700', 'Generator expenses', 'Generator expenses', 'Expenses', 1, ''),
(124, '2023-03-31 08:54:03am', '4800', 'Staff welfare', 'Staff welfare', 'Expenses', 1, ''),
(126, '2023-03-31 08:54:39am', '4900', 'Amortisation ', 'Amortisation ', 'Expenses', 1, ''),
(128, '2023-04-05 01:52:50pm', '7100', 'Accounts Receivable ', 'Accounts Receivable Control', 'Trade Receivable', 1, ''),
(130, '2023-04-05 01:53:21pm', '9100', 'Accounts Payable ', 'Accounts Payable Control ', 'Trade Payable', 1, ''),
(132, '2023-04-05 01:54:23pm', '9600', 'Directors Loan', 'Directors Loan/To', 'Other Current Liability', 1, ''),
(134, '2025-01-09 07:46:09pm', '8400', 'Cash Account USD', 'Cash Account USD ', 'Cash, or Cash Equivalent', 1, ''),
(136, '2025-04-07 06:58:21pm', '1100', 'Sales Grocery - Tuckshop', 'Sales Grocery - Tuckshop', 'Revenue', 1, ''),
(138, '2025-04-15 06:44:42am', '6501', 'Interest income ', 'Interest income ', 'Other Income', 1, ''),
(140, '2025-04-15 06:46:11am', '6502', 'Other income ', 'Other income ', 'Other Income', 1, ''),
(142, '2025-04-15 11:54:36pm', '1110', 'Sales Uniform', 'Sales Uniform', 'Revenue', 1, ''),
(144, '2025-04-15 11:57:42pm', '2100', 'Purchases Uniform ', 'Purchases Uniform ', 'Cost of Goods Sold', 1, ''),
(146, '2025-04-15 11:58:11pm', '2110', 'Purchases Grocery - Tuckshop', 'Purchases Grocery - Tuckshop', 'Cost of Goods Sold ', 1, ''),
(148, '2025-04-16 12:00:02am', '7700', 'Stock', 'Stock Control ', 'Inventory ', 1, ''),
(150, '2025-04-16 01:13:57am', '6300', 'Software ', 'Software ', 'Non-Current Asset ', 1, ''),
(152, '2025-04-16 01:40:42am', '6000', 'Motor vehicle ', 'Motor vehicle ', 'Fixed Assets', 1, ''),
(154, '2025-04-16 01:41:33am', '6100', 'Computer Equipment ', 'Computer Equipment ', 'Fixed Assets', 1, ''),
(156, '2025-04-16 01:42:05am', '6200', 'Furniture & Fitting ', 'Furniture & Fitting ', 'Fixed Assets', 1, ''),
(158, '2025-04-16 10:23:46am', '1200', 'Sales', 'Sales', 'Revenue', 1, ''),
(160, '2025-04-30 02:48:17am', '6600', 'Director Loan/From', 'Director Loan/From ', 'Current Asset', 1, ''),
(162, '2025-04-30 03:02:47am', '9750', 'Shareholder Capital ', 'Shareholder Capital ', 'Equity', 1, ''),
(164, '2025-04-30 03:10:05am', '6620', 'Prepayment ', 'Prepayment ', 'Current Asset ', 1, ''),
(166, '2025-04-30 03:11:46am', '9620', 'Dividend Payable ', 'Dividend Payable ', 'Other Current Liability', 1, ''),
(168, '2025-04-30 03:13:45am', '6650', 'Undeposited Funds ', 'Undeposited Funds', 'Current Asset ', 1, ''),
(170, '2025-04-30 03:16:16am', '4350', 'Salaries and Wages ', 'Salaries and Wages ', 'Expenses', 1, ''),
(172, '2025-04-30 03:20:41am', '9650', 'Salaries and Wages Payable ', 'Salaries and Wages Payable ', 'Other Current Liability', 1, ''),
(174, '2025-04-30 03:27:54am', '9610', 'Unearned Revenue ', 'Unearned Revenue ', 'Other Current Liability', 1, ''),
(176, '2025-04-30 03:36:25am', '4510', 'Income Tax', 'Income Tax', 'Expenses', 1, ''),
(178, '2025-04-30 03:37:06am', '9630', 'Income Tax Payable ', 'Income Tax Payable ', 'Other Current Liability', 1, ''),
(180, '2025-04-30 03:40:53am', '9660', 'Deferred Income Tax', 'Deferred Income Tax ', 'Long term liability', 1, ''),
(182, '2025-04-30 03:50:17am', '6320', 'Deferred Income Tax ', 'Deferred Income Tax ', 'Non-Current Asset ', 1, ''),
(184, '2025-04-30 07:53:26am', '6630', 'Intercompany Receivable', 'Intercompany Receivable ', 'Current Asset ', 1, ''),
(186, '2025-04-30 07:55:13am', '9615', 'Intercompany Payable ', 'Intercompany Payable ', 'Other Current Liability', 1, ''),
(188, '2025-04-30 08:07:49am', '4250', 'Rent Paid ', 'Rent Paid', 'Expenses', 1, ''),
(190, '2025-04-30 08:08:55am', '1500', 'Rent Received ', 'Rent Received ', 'Other Income', 1, ''),
(192, '2025-04-30 08:09:57am', '9640', 'Rent Payable ', 'Rent Payable ', 'Other Current Liability', 1, ''),
(194, '2025-04-30 08:15:53am', '6610', 'Loan to Subsidiaries ', 'Loan to Subsidiaries ', 'Current Asset', 1, ''),
(196, '2025-04-30 08:17:02am', '9625', 'Loan from Subsidiaries ', 'Loan from Subsidiaries ', 'Other Current Liability', 1, ''),
(198, '2025-04-30 08:18:23am', '8410', 'Cash Account ZWG', 'Cash Account ZWG ', 'Cash, or Cash Equivalent', 1, '');

--
-- Triggers `glledger_account`
--
DELIMITER $$
CREATE TRIGGER `trg_glledger_account_assign_even_id` BEFORE INSERT ON `glledger_account` FOR EACH ROW BEGIN
  IF NEW.id IS NULL OR NEW.id = 0 THEN
    SELECT IFNULL(MAX(id), 0) + 2
      INTO @next_even
      FROM glledger_account;
    SET NEW.id = @next_even;
  END IF;
END
$$
DELIMITER ;

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

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

CREATE TABLE `glsub_account` (
  `id` int(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `glsub_account` (`id`, `date`, `glsub_code`, `name`, `description`, `account_type`, `active`) VALUES
(101, '2023-01-15 03:37:08am', '100', 'General ledger Take On ', 'General ledger Take On ', '9550', 1),
(103, '2023-01-15 03:37:36am', '200', 'Customers Take On ', 'Customers Take On ', '9550', 1),
(105, '2023-01-15 03:38:01am', '300', 'Suppliers Take On ', 'Suppliers Take On ', '9550', 1),
(107, '2023-01-15 03:38:29am', '400', 'Inventory Take On ', 'Inventory Take On ', '9550', 1),
(109, '2023-01-15 03:39:23am', '200', 'Insurance ', 'Insurance ', '4100', 1),
(111, '2023-01-15 03:39:51am', '300', 'Toll gates', 'Toll gates', '4100', 1),
(113, '2023-01-15 03:40:23am', '400', 'Repairs & Maintenance ', 'Repairs & Maintenance ', '4100', 1),
(115, '2023-01-15 10:47:38am', '001', 'Depreciation>Motor Vehicle ', 'Depreciation>Motor Vehicle ', '4600', 1),
(117, '2023-01-15 10:49:18am', '002', 'Depreciation>Furniture & Fittings ', 'Depreciation>Furniture & Fittings ', '4600', 1),
(119, '2023-01-15 10:50:05am', '003', 'Depreciation>Computer Equipment ', 'Depreciation>Computer Equipment ', '4600', 1),
(121, '2023-03-31 08:24:54am', '100', 'Generator fuel', 'Generator fuel', '4700', 1),
(123, '2023-03-31 08:25:49am', '200', 'Generator repair & maintanance', 'Generator repair & maintanance', '4700', 1),
(125, '2024-02-01 09:54:37am', '002', 'Software > Acc - Amortisation ', 'Melsoft Essential', '6300', 1),
(127, '2025-04-16 12:59:42am', '001', 'Amortisation> Software', 'Amortisation > Software', '4900', 1),
(129, '2025-04-16 01:18:55am', '001', 'Software @cost', 'Software @cost', '6300', 1),
(131, '2025-04-16 01:30:02am', '001', 'Motor vehicle @cost', 'Motor vehicle @cost', '600', 1),
(133, '2025-04-16 01:30:49am', '002', 'Motor vehicle>Acc Depreciation ', 'Motor vehicle>Acc Depreciation ', '600', 1),
(135, '2025-04-16 01:32:01am', '001 ', 'Computer Equipment @cost', 'Computer Equipment @cost', '6100', 1),
(137, '2025-04-16 01:32:51am', '002', 'Computer Equipment>Acc Depreciation ', 'Computer Equipment>Acc Depreciation ', '6100', 1),
(139, '2025-04-16 01:34:29am', '001', 'Furniture & Fitting @cost', 'Furniture & Fitting @cost', '6200', 1),
(141, '2025-04-16 01:35:22am', '002', 'Furniture & Fitting>Acc Depreciation ', 'Furniture & Fitting>Acc Depreciation ', '6200', 1),
(143, '2025-04-17 02:23:10pm', '100', 'Fuel', 'Fuel', '4100', 1),
(145, '2025-04-29 08:22:07pm', '100', 'Uniform ', 'Uniform Item', '7700', 1),
(147, '2025-04-29 08:23:02pm', '200', 'Grocery ', 'Grocery item', '7700', 1);

--
-- Triggers `glsub_account`
--
DELIMITER $$
CREATE TRIGGER `trg_glsub_account_assign_odd_id` BEFORE INSERT ON `glsub_account` FOR EACH ROW BEGIN
  -- Only auto-assign if no explicit ID was provided
  IF NEW.id IS NULL OR NEW.id = 0 THEN
    -- Pick the current maximum odd ID and add 2
    SELECT IFNULL(MAX(id), 0) + 2
      INTO @next_odd
      FROM glsub_account;
    SET NEW.id = @next_odd;
  END IF;
END
$$
DELIMITER ;

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

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

CREATE TABLE `grades` (
  `id` int(11) 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 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=utf8 COLLATE=utf8_general_ci;

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

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

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

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

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

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

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

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

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

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

INSERT INTO `home_currency` (`id`, `date`, `currencycode`, `name`, `description`, `active`) VALUES
(9, '31-03-2023 07:37:22am', 'USD', 'USD', 'UNITED STATES DOLLARS', 1),
(11, '20-05-2025 03:19:36pm', 'NOSTRO', 'NOSTRO', 'NOSTRO USD', 1);

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

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

CREATE TABLE `hostel` (
  `id` int(11) NOT NULL,
  `hostel_name` varchar(100) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `intake` int(11) DEFAULT NULL,
  `description` text 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=utf8 COLLATE=utf8_general_ci;

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

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

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

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

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

CREATE TABLE `id_card` (
  `id` int(11) 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=utf8 COLLATE=utf8_general_ci;

--
-- 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(11) 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 DEFAULT NULL,
  `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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `income_head` (
  `id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `invoicegenaration`
--

CREATE TABLE `invoicegenaration` (
  `ID` int(11) NOT NULL,
  `Status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `item` (
  `id` int(11) NOT NULL,
  `item_category_id` int(11) 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(11) DEFAULT NULL,
  `item_supplier_id` int(11) DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `item` (`id`, `item_category_id`, `name`, `item_photo`, `description`, `created_at`, `updated_at`, `item_store_id`, `item_supplier_id`, `quantity`, `date`) VALUES
(3, 3, 'sugar hullets', NULL, 'sugar hullets', '2023-02-03 20:35:54', '', NULL, NULL, 0, '0000-00-00'),
(4, 2, 'cremora', NULL, 'cremora', '2023-02-03 20:36:28', '', NULL, NULL, 0, '0000-00-00');

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

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

CREATE TABLE `item_category` (
  `id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `item_category` (`id`, `item_category`, `is_active`, `description`, `created_at`, `updated_at`) VALUES
(2, 'milk', 'yes', 'milk', '2023-02-03 20:34:41', ''),
(3, 'sugar', 'yes', 'sugar', '2023-02-03 20:34:56', '');

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

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

CREATE TABLE `item_issue` (
  `id` int(11) 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(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  `note` text NOT NULL,
  `is_returned` int(11) 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=utf8 COLLATE=utf8_general_ci;

--
-- 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`, `created_at`, `is_active`) VALUES
(1, 'Canteen', 'Stores', 'jj', 'ggg', '2023-04-13', '0000-00-00', 2, 4, 2, 'cfgfgggh', 1, '2023-04-13 09:43:10', 'no'),
(2, 'breakages', 'Stores', 'JJJ', 'REJOICE', '2023-04-13', '0000-00-00', 2, 4, 3, 'BREAKAGES', 1, '2023-04-13 09:48:07', 'no');

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

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

CREATE TABLE `item_stock` (
  `id` int(11) NOT NULL,
  `item_id` int(11) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `symbol` varchar(10) NOT NULL DEFAULT '+',
  `store_id` int(11) DEFAULT NULL,
  `quantity` int(11) 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(),
  `supplier_reference` varchar(100) NOT NULL,
  `cost` decimal(12,2) NOT NULL,
  `amount` decimal(12,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `item_stock` (`id`, `item_id`, `supplier_id`, `symbol`, `store_id`, `quantity`, `date`, `attachment`, `description`, `is_active`, `created_at`, `supplier_reference`, `cost`, `amount`) VALUES
(3, 4, 2, '+', 1, 10, '2023-02-01', NULL, 'cremora milk', 'yes', '2023-02-03 20:37:28', '', 0.00, 0.00);

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

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

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

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

INSERT INTO `item_store` (`id`, `item_store`, `code`, `description`) VALUES
(1, 'Stores', 'sto', 'Stores'),
(2, 'Canteen', 'cn', 'Canteen'),
(3, 'STORE 1', 'STR1', 'STORE 1'),
(4, 'breakages', 'BR', 'BREAKAGE WAREHOUSE ');

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

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

CREATE TABLE `item_supplier` (
  `id` int(11) 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=utf8 COLLATE=utf8_general_ci;

--
-- 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
(2, 'OK', '0778893765', '', '', 'NYASHA', '', '', '');

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

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

CREATE TABLE `journal` (
  `id` int(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `journaltemp`
--

CREATE TABLE `journaltemp` (
  `id` int(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

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

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

INSERT INTO `journal_accounts` (`id`, `journal_accounts`, `currency`, `description`, `active`) VALUES
(3, 'Sales journal', 'USD', 'Sales journal', 1),
(4, 'Purchases journal', 'USD', 'Purchases journal', 1),
(5, 'General journal', 'USD', 'General journal', 1),
(6, 'Sales returns journal', 'USD', 'Sales returns journal', 1),
(7, 'Purchases returns journal', 'USD', 'Purchases returns journal', 1),
(8, 'Learner journal ', 'USD', 'Learner journal ', 1),
(9, 'Learner Returns Journal ', 'USD', 'Learner Returns Journal ', 1);

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

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

CREATE TABLE `languages` (
  `id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

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

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

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

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

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

CREATE TABLE `libarary_members` (
  `id` int(10) UNSIGNED NOT NULL,
  `library_card_no` varchar(50) DEFAULT NULL,
  `member_type` varchar(50) DEFAULT NULL,
  `member_id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

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

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

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

CREATE TABLE `medical` (
  `id` int(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `medical_details` (
  `id` int(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `messages` (
  `id` int(11) NOT NULL,
  `title` varchar(200) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `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(11) NOT NULL DEFAULT 0,
  `group_list` text DEFAULT NULL,
  `user_list` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `migrations` (
  `version` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `notification_roles` (
  `id` int(11) NOT NULL,
  `send_notification_id` int(11) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `is_active` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `notification_roles` (`id`, `send_notification_id`, `role_id`, `is_active`, `created_at`) VALUES
(1, 1, 2, 0, '2022-11-24 04:46:11'),
(2, 1, 7, 0, '2022-11-24 04:46:11');

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

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

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

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

INSERT INTO `notification_setting` (`id`, `type`, `is_mail`, `is_sms`, `display_notification`, `is_notification`, `created_at`) VALUES
(1, 'student_admission', '1', '0', 0, 0, '2019-04-10 10:27:50'),
(2, 'exam_result', '1', '0', 1, 0, '2019-04-10 10:27:50'),
(3, 'fee_submission', '1', '0', 1, 0, '2019-04-10 10:27:50'),
(4, 'absent_attendence', '1', '0', 1, 0, '2019-04-10 10:27:50'),
(5, 'login_credential', '1', '0', 0, 0, '2019-04-10 10:27:50');

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

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

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

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

INSERT INTO `payment_methods` (`id`, `payment_methods`, `description`, `active`) VALUES
(4, 'ZWG', 'ZWG', 1),
(5, 'USD', 'USD', 1),
(6, 'ZAR', 'RAND', 1),
(7, 'ECOCASH ', 'USD', 1),
(8, 'NOSTRO', 'USD', 1);

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

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

CREATE TABLE `payment_settings` (
  `id` int(11) 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=utf8 COLLATE=utf8_general_ci;

--
-- 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`, `created_at`, `updated_at`) VALUES
(1, 'paypal', '', '', '', '', '', '', NULL, '', '', 'yes', '2018-07-12 01:26:13', '0000-00-00 00:00:00'),
(4, 'paynow', NULL, '', '', '', NULL, NULL, NULL, '', '', 'no', '2023-01-26 10:39:24', '0000-00-00 00:00:00');

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

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

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

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

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

CREATE TABLE `permission_category` (
  `id` int(11) NOT NULL,
  `perm_group_id` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `short_code` varchar(100) DEFAULT NULL,
  `enable_view` int(11) DEFAULT 0,
  `enable_add` int(11) DEFAULT 0,
  `enable_edit` int(11) DEFAULT 0,
  `enable_delete` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

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

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

CREATE TABLE `permission_group` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `short_code` varchar(100) NOT NULL,
  `is_active` int(11) DEFAULT 0,
  `system` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `permission_group` (`id`, `name`, `short_code`, `is_active`, `system`, `created_at`) VALUES
(1, 'Student Information', 'student_information', 1, 1, '2018-06-27 05:09:31'),
(2, 'Fees Collection', 'fees_collection', 1, 0, '2018-07-11 04:19:10'),
(3, 'Income', 'income', 1, 1, '2022-09-14 05:19:16'),
(4, 'Expense', 'expense', 1, 1, '2022-09-14 05:19:13'),
(5, 'Student Attendance', 'student_attendance', 1, 0, '2018-07-02 09:18:08'),
(6, 'Examination', 'examination', 1, 0, '2018-07-11 04:19:08'),
(7, 'Academics', 'academics', 1, 1, '2018-07-02 08:55:43'),
(8, 'Download Center', 'download_center', 1, 0, '2018-07-02 09:19:29'),
(9, 'Library', 'library', 1, 1, '2022-09-14 05:18:59'),
(10, 'Inventory', 'inventory', 1, 0, '2018-06-27 02:18:58'),
(11, 'Transport', 'transport', 1, 0, '2018-06-27 09:21:26'),
(12, 'Hostel', 'hostel', 1, 1, '2022-09-14 05:17:47'),
(13, 'Communicate', 'communicate', 1, 0, '2018-07-02 09:20:00'),
(14, 'Reports', 'reports', 1, 1, '2018-06-27 05:10:22'),
(15, 'System Settings', 'system_settings', 1, 1, '2018-06-27 05:10:28'),
(16, 'Front CMS', 'front_cms', 1, 1, '2022-09-14 05:17:26'),
(17, 'Front Office', 'front_office', 1, 1, '2022-09-14 05:17:23'),
(18, 'Human Resource', 'human_resource', 1, 1, '2018-06-27 05:11:02'),
(19, 'Homework', 'homework', 1, 0, '2018-06-27 02:19:38'),
(20, 'Certificate', 'certificate', 1, 1, '2022-09-14 05:17:11'),
(21, 'Calendar To Do List', 'calendar_to_do_list', 1, 0, '2018-06-27 05:12:25'),
(22, 'Dashboard and Widgets', 'dashboard_and_widgets', 1, 1, '2018-06-27 05:11:17');

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

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

CREATE TABLE `read_notification` (
  `id` int(11) NOT NULL,
  `student_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `staff_id` int(11) DEFAULT NULL,
  `notification_id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `read_notification` (`id`, `student_id`, `parent_id`, `staff_id`, `notification_id`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 3, NULL, NULL, 1, 'no', '2022-11-24 04:47:00', ''),
(2, NULL, NULL, 24, 1, 'no', '2023-04-19 06:23:54', '');

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

--
-- Table structure for table `receiptgenaration`
--

CREATE TABLE `receiptgenaration` (
  `id` int(11) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

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

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

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

CREATE TABLE `roles` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `slug` varchar(150) DEFAULT NULL,
  `is_active` int(11) DEFAULT 0,
  `is_system` int(11) NOT NULL DEFAULT 0,
  `is_superadmin` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `roles` (`id`, `name`, `slug`, `is_active`, `is_system`, `is_superadmin`, `created_at`, `updated_at`) VALUES
(1, 'Admin', NULL, 0, 1, 0, '2018-06-30 11:39:11', '0000-00-00 00:00:00'),
(2, 'Teacher', NULL, 0, 1, 0, '2018-06-30 11:39:14', '0000-00-00 00:00:00'),
(3, 'Accountant', NULL, 0, 1, 0, '2018-06-30 11:39:17', '0000-00-00 00:00:00'),
(4, 'Librarian', NULL, 0, 1, 0, '2018-06-30 11:39:21', '0000-00-00 00:00:00'),
(6, 'Receptionist', NULL, 0, 1, 0, '2018-07-02 01:39:03', '0000-00-00 00:00:00'),
(7, 'Super Admin', NULL, 0, 1, 1, '2018-07-11 10:11:29', '0000-00-00 00:00:00');

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

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

CREATE TABLE `roles_permissions` (
  `id` int(11) NOT NULL,
  `role_id` int(11) DEFAULT NULL,
  `perm_cat_id` int(11) DEFAULT NULL,
  `can_view` int(11) DEFAULT NULL,
  `can_add` int(11) DEFAULT NULL,
  `can_edit` int(11) DEFAULT NULL,
  `can_delete` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `roles_permissions` (`id`, `role_id`, `perm_cat_id`, `can_view`, `can_add`, `can_edit`, `can_delete`, `created_at`) VALUES
(757, 1, 1, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(758, 1, 2, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(759, 1, 3, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(760, 1, 4, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(761, 1, 47, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(762, 1, 105, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(763, 1, 107, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(764, 1, 119, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(765, 1, 120, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(766, 1, 121, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(767, 1, 128, 0, 1, 0, 1, '2023-03-13 09:19:27'),
(768, 1, 5, 1, 1, 0, 1, '2023-03-13 09:19:27'),
(769, 1, 6, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(770, 1, 7, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(771, 1, 8, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(772, 1, 68, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(773, 1, 69, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(774, 1, 70, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(775, 1, 71, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(776, 1, 72, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(777, 1, 73, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(778, 1, 74, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(779, 1, 75, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(780, 1, 9, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(781, 1, 10, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(782, 1, 11, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(783, 1, 12, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(784, 1, 13, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(785, 1, 14, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(786, 1, 15, 1, 1, 1, 0, '2023-03-13 09:19:27'),
(787, 1, 16, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(788, 1, 122, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(789, 1, 17, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(790, 1, 19, 1, 1, 1, 0, '2023-03-13 09:19:27'),
(791, 1, 20, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(792, 1, 76, 1, 1, 1, 0, '2023-03-13 09:19:27'),
(793, 1, 21, 1, 1, 1, 0, '2023-03-13 09:19:27'),
(794, 1, 22, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(795, 1, 23, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(796, 1, 24, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(797, 1, 25, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(798, 1, 26, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(799, 1, 77, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(800, 1, 27, 1, 1, 0, 1, '2023-03-13 09:19:27'),
(801, 1, 28, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(802, 1, 29, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(803, 1, 30, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(804, 1, 123, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(805, 1, 31, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(806, 1, 32, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(807, 1, 33, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(808, 1, 34, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(809, 1, 35, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(810, 1, 104, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(811, 1, 37, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(812, 1, 38, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(813, 1, 39, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(814, 1, 124, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(815, 1, 40, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(816, 1, 41, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(817, 1, 42, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(818, 1, 125, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(819, 1, 43, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(820, 1, 44, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(821, 1, 46, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(822, 1, 48, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(823, 1, 49, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(824, 1, 53, 0, 1, 0, 0, '2023-03-13 09:19:27'),
(825, 1, 54, 1, 0, 1, 0, '2023-03-13 09:19:27'),
(826, 1, 55, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(827, 1, 56, 1, 0, 1, 0, '2023-03-13 09:19:27'),
(828, 1, 57, 1, 0, 1, 0, '2023-03-13 09:19:27'),
(829, 1, 58, 1, 0, 1, 0, '2023-03-13 09:19:27'),
(830, 1, 60, 1, 0, 1, 0, '2023-03-13 09:19:27'),
(831, 1, 126, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(832, 1, 130, 1, 1, 0, 1, '2023-03-13 09:19:27'),
(833, 1, 131, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(834, 1, 61, 1, 1, 0, 1, '2023-03-13 09:19:27'),
(835, 1, 62, 1, 1, 0, 1, '2023-03-13 09:19:27'),
(836, 1, 63, 1, 1, 0, 1, '2023-03-13 09:19:27'),
(837, 1, 64, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(838, 1, 65, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(839, 1, 66, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(840, 1, 67, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(841, 1, 78, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(842, 1, 79, 1, 1, 0, 1, '2023-03-13 09:19:27'),
(843, 1, 80, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(844, 1, 81, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(845, 1, 82, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(846, 1, 83, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(847, 1, 84, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(848, 1, 85, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(849, 1, 86, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(850, 1, 87, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(851, 1, 88, 1, 1, 1, 0, '2023-03-13 09:19:27'),
(852, 1, 89, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(853, 1, 90, 1, 1, 0, 1, '2023-03-13 09:19:27'),
(854, 1, 91, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(855, 1, 108, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(856, 1, 109, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(857, 1, 110, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(858, 1, 111, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(859, 1, 112, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(860, 1, 127, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(861, 1, 129, 0, 1, 0, 1, '2023-03-13 09:19:27'),
(862, 1, 93, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(863, 1, 94, 1, 1, 0, 0, '2023-03-13 09:19:27'),
(864, 1, 95, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(865, 1, 96, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(866, 1, 97, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(867, 1, 98, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(868, 1, 99, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(869, 1, 102, 1, 1, 1, 1, '2023-03-13 09:19:27'),
(870, 1, 106, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(871, 1, 113, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(872, 1, 114, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(873, 1, 115, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(874, 1, 116, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(875, 1, 117, 1, 0, 0, 0, '2023-03-13 09:19:27'),
(876, 1, 118, 1, 0, 0, 0, '2023-03-13 09:19:27');

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

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

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

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

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

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

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

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

CREATE TABLE `sch_settings` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `bank_details1` varchar(400) NOT NULL,
  `bank_details2` varchar(400) NOT NULL,
  `bank_details3` varchar(400) NOT NULL,
  `lang_id` int(11) 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(11) 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(100) NOT NULL,
  `cron_secret_key` varchar(100) NOT NULL,
  `fee_due_days` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `sch_settings` (`id`, `name`, `email`, `phone`, `address`, `bank_details1`, `bank_details2`, `bank_details3`, `lang_id`, `dise_code`, `date_format`, `currency`, `currency_symbol`, `is_rtl`, `timezone`, `session_id`, `start_month`, `image`, `theme`, `is_active`, `created_at`, `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, 'Melsoft School Premium', 'NA', 'NA', '25 G Silundika Ave Regal Star House, Harare', 'NA', 'NA', 'NA', 4, 'MP', 'd-m-Y', 'USD', 'USD', 'disabled', 'Africa/Harare', 26, '1', '1.png', 'default.jpg', 'no', '2025-05-29 11:09:00', '0000-00-00 00:00:00', '', 7, 'no', '', '#424242', '#eeeeee', '1.jpeg');

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

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

CREATE TABLE `sections` (
  `id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `send_notification` (
  `id` int(11) NOT NULL,
  `title` varchar(50) DEFAULT NULL,
  `publish_date` date DEFAULT NULL,
  `date` date DEFAULT NULL,
  `message` text DEFAULT NULL,
  `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(11) 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=utf8 COLLATE=utf8_general_ci;

--
-- 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`, `created_at`, `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', '2022-11-24 02:46:11', '');

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

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

CREATE TABLE `sessions` (
  `id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `sessions` (`id`, `session`, `is_active`, `created_at`, `updated_at`) VALUES
(7, '2016-17', 'no', '2017-04-20 00:42:19', '0000-00-00 00:00:00'),
(11, '2017-18', 'no', '2017-04-20 00:41:37', '0000-00-00 00:00:00'),
(13, '2018-19', 'no', '2016-08-24 13:26:44', '0000-00-00 00:00:00'),
(14, '2024', 'no', '2024-01-23 09:59:44', '0000-00-00 00:00:00'),
(15, '2020-21', 'no', '2016-09-30 23:28:08', '0000-00-00 00:00:00'),
(16, '2021-22', 'no', '2016-09-30 23:28:20', '0000-00-00 00:00:00'),
(18, '2022-23', 'no', '2016-09-30 23:29:02', '0000-00-00 00:00:00'),
(19, '2023-24', 'no', '2016-09-30 23:29:10', '0000-00-00 00:00:00'),
(20, '2024-25', 'no', '2016-09-30 23:29:18', '0000-00-00 00:00:00'),
(21, '2025-26', 'no', '2016-09-30 23:30:10', '0000-00-00 00:00:00'),
(22, '2026-27', 'no', '2016-09-30 23:30:18', '0000-00-00 00:00:00'),
(23, '2027-28', 'no', '2016-09-30 23:30:24', '0000-00-00 00:00:00'),
(24, '2028-29', 'no', '2016-09-30 23:30:30', '0000-00-00 00:00:00'),
(25, '2029-30', 'no', '2016-09-30 23:30:37', '0000-00-00 00:00:00'),
(26, '2025', 'no', '2025-01-23 10:28:00', ''),
(27, '2026', 'no', '2025-05-05 13:50:59', '');

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

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

CREATE TABLE `sms_config` (
  `id` int(11) 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 DEFAULT NULL,
  `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=utf8 COLLATE=utf8_general_ci;

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

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

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

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

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

CREATE TABLE `sport` (
  `id` int(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `sport_categories` (
  `id` int(11) NOT NULL,
  `sport` varchar(200) NOT NULL,
  `age_group` varchar(200) NOT NULL,
  `gender` varchar(200) NOT NULL,
  `active` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_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(11) 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(11) NOT NULL,
  `is_active` int(11) NOT NULL,
  `verification_code` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- 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, 'MS0001', 'select', 'select', '', '', 'MS Super Admin', '', '', '', '', '', 'mssuperadmin@gmail.com', '1997-11-30', '', '0000-00-00', '0000-00-00', '', '', '', '', '$2y$10$FR4uLfdq6eRk6Wu1WnD21OMbtQnLoNYf5pm0WPVkEp/UuqLfqLOzi', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Other Document', '', 1, 1, ''),
(4, 'PRS0001', '15', '17', 'DIPLOMA IN EDUCATION\r\n', '', 'JOSEPH', 'NDADZIIRA', '', '', '0773538372', '', 'jndadziira@gmail.com', '1986-04-05', '', '2021-05-04', '0000-00-00', '', 'MUPFUMI PRIMARY SCHOOL\r\nP.BAG 8090\r\nRUSAPE', '', '', '$2y$10$4VzMNMj51rEIUy7.Zg0gFep3zH.BWOLQX6L7L1pG3vj4JbqkGn8Ve', 'Male', '', '', '', '', '', '', '', '', 'permanent', '', '', '', '', '', '', '', '', '', 'Other Document', '', 0, 1, ''),
(5, 'PRS0002', '16', '17', '', '', 'MELISA', 'CHIDIYA', '', '', '0783124572', '', 'melchidiya@gmail.com', '1997-04-08', 'Single', '2021-01-01', '0000-00-00', '', 'STAND 362 JURU\r\nGOROMONZI', '', '', '$2y$10$VONZnUFH0qyVRXjBGN1e.uHNZvQnqc3DLVD4DCrzu/R.0oEc/zU9m', 'Female', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Other Document', '', 0, 0, ''),
(6, 'PRS0003', '15', '16', '', '', 'CHERYL', 'MASVIBO', 'none', 'none', '0784801373', '', 'cmasvimbo@gmail.com', '1997-08-11', 'Single', '2023-01-17', '0000-00-00', '', '30039 UNIT L SEKE\r\nCHITUNGWIZA', '', '', '$2y$10$Vo2yZArAq2co5J0nfRt4H.7Hpc4LjyNKajDMJ1dv/.puSaZAxqL2e', 'Female', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, ''),
(7, 'PRS0004', '14', '15', '', '', 'RUVIMBO', 'TSIGA', 'none', 'none', '0782420860', '', 'rtsiga@gmail.com', '1992-03-19', 'Seperated', '0000-00-00', '0000-00-00', '', 'PLOT 15\r\nETON FARM\r\nGOROMONZI', '', '', '$2y$10$pM.LloCSZSG2i1bEkHn2euv3YDqDzA.B5RqA9kJOzHo2Y.tCPjRJO', 'Female', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, ''),
(8, 'PRS0005', '14', '14', '', '', 'REJOYCE', 'MUNYIRA', 'none', 'none', '0784075025', '', 'rmunyira@gmail.com', '1997-08-10', 'Married', '0000-00-00', '0000-00-00', '', '', '', '', '$2y$10$17f.7LuJAvayJFtfqmca/uxzSmQapwcWeGetz.3fHdjeask0Vv10.', 'Female', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, ''),
(9, 'PRS0006', '9', '13', '', '', 'REJOICE', 'CHIRESHE', 'none', 'none', '0777067971', '', 'rchireshe@gmail.com', '1982-10-22', 'Married', '0000-00-00', '0000-00-00', '', '', '', '', '$2y$10$R3mb3p6udyOpkqAhyifsl./FLxVMxnxKKXo3Y7M/K4.SyeDbmWoni', 'Female', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Other Document', '', 0, 1, ''),
(10, 'PRS0007', '13', '22', '', '', 'RUEJULLIAN', 'BLACK', 'none', 'none', '0773752274', '', 'rblack@gmail.com', '1995-02-18', 'Married', '0000-00-00', '0000-00-00', 'NHEMHARA VILLAGE\r\nGOROMONZI', '', '', '', '$2y$10$XrcgtVMoymy83n5zumihFudps./r7w.Ga6rADsy3NXjagJqHv8A1C', 'Female', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Other Document', '', 0, 1, ''),
(11, 'PRS0008', '9', '11', '', '', 'CHIDO', 'MUTUMBA', 'none', 'none', '0772672733', '', 'cmutumba@gmail.com', '1979-09-07', 'Married', '0000-00-00', '0000-00-00', 'MASENYAMA RESIDENCW\r\nTAKADII VILAGE\r\nGOROMONZI', '', '', '', '$2y$10$oGbsViwyvrTD3zUKXsjXUegxqDK1PxtYjVrT4l2zHvPxgTUysaEay', 'Female', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Other Document', '', 0, 1, ''),
(12, 'PRS0009', '9', '11', '', '', 'YOLLANDAR', 'MANJEYA', 'none', 'none', '0776080277', '', 'ymanjeya@gmail.com', '1990-07-22', 'Married', '0000-00-00', '0000-00-00', '475 MAJURU 2\r\nGOROMONZI', '', '', '', '$2y$10$aLlL4I2D6xmNm0X.g9kFF..GBs.F/WXVa2a4nnEbZh8y9sa4qBXFy', 'Female', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Other Document', '', 0, 0, ''),
(13, 'PRS0010', '9', '12', '', '', 'POLITE', 'BENGESA', 'none', 'none', '0772949704', '', 'pbengesa@gmail.com', '1984-03-20', 'Married', '0000-00-00', '0000-00-00', '', '', '', '', '$2y$10$oppQTl2vYXtW/D.4bkMoVORys5sv5kzlmfeE1Ecd01pWVPjGhNh6G', 'Female', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Other Document', '', 0, 1, ''),
(14, 'PRS0011', 'select', '5', '', '', 'IGATIUS', 'KATERERE', 'none', 'none', '', '', 'igykayz@gmail.com', '1991-01-25', 'Single', '0000-00-00', '0000-00-00', 'PRINCE JUNIOR SCHOOL\r\n', '8684 PARADISE\r\nHIGHFIELD HARARE', '', '', '$2y$10$hMZmyQQehdkNWSxLDa67zeqypqS4jJSbKcsiMn4B6si9lPZIRAuru', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, ''),
(15, 'PRS0012', '15', '15', '', '', 'WONDER', 'MUTEDE', 'none', 'none', '0774267835', '', 'wondermutede@gmail.com', '1992-12-29', 'Married', '0000-00-00', '0000-00-00', 'TAKADII VILLAGE\r\nGOROMONZI', '', '', '', '$2y$10$J17Hi5L4CgWbUi78b1T24eeI8xsVQtrAwLOW6WZ2jJKFHW77ehvoG', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Other Document', '', 0, 1, ''),
(16, 'PRS0013', '17', '19', '', '', 'PETER', 'KATENDERE', 'none', 'none', '0776963868', '', 'pkatendere@gmail.com', '1958-11-23', 'Married', '0000-00-00', '0000-00-00', 'NEMHARA VILLAGE\r\nGOROMONZI', '', '', '', '$2y$10$3nDzp6s2X36F6FnWxgHJRubBYfSvliVDLoVRToAchHv62MDhTezJW', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, ''),
(17, 'PRS0015', '11', '20', '', '', 'IRENE', 'ZHOU', 'none', 'none', '078470331', '', 'izhou@gmail.com', '1974-09-01', '', '0000-00-00', '0000-00-00', 'NGAZIMBE VILLAGE\r\nP BAG 108\r\nGOROMONZI', '', '', '', '$2y$10$B2XD.v8txAUJittwafoy6.yLbsd0Ff2jm/9KG6CSwfAf0b6F48vjq', 'Female', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, ''),
(18, 'PRS0016', '11', '20', '', '', 'TUNGAWE', 'PETER', 'none', 'none', '0773147741', '', 'tpeter@gmail.com', '1974-12-24', 'Widowed', '0000-00-00', '0000-00-00', 'NGAZIMBE VILLAGE\r\nP BAG 108\r\nGOROMONZI', '', '', '', '$2y$10$/jwiwgjipdi4JYIMw2xKO.WGmOZe8AjzvgJ3FkL0wRUXGz0FO9Qjq', 'Female', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Other Document', '', 0, 1, ''),
(19, 'PRS0017', '10', '20', '', '', 'MAUD', 'ANTONIO', 'none', 'none', '0776831887', '', 'mantonio@gmail.com', '1986-02-28', '', '0000-00-00', '0000-00-00', 'NGAZIMBE VILLAGE\r\nP BAG 108\r\nGOROMONZI', '', '', '', '$2y$10$T5gFLJ922/ylqoIAkXSC9O73xHdMVKwsv3XVOq8/JpSGWiiTNmM2y', 'Female', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, ''),
(20, 'PRS0018', '19', '26', '', '', 'PATRICK', 'KAMBALE', 'none', 'none', '0771246266', '', 'pkambale@gmail.com', '1999-04-21', '', '0000-00-00', '0000-00-00', 'NGAZIMBE VILLAGE\r\nP BAG 108\r\nGOROMONZI', '', '', '', '$2y$10$ZCmLE3PP0NNWxMG04AtLaOLSsMiwh84NR8V17Aj4QiglaFFcwSOpa', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Other Document', '', 0, 1, ''),
(21, 'PRS0019', '19', '26', '', '', 'RUSHTON', 'MUSAMA', 'none', 'none', '', '', 'rmusam@gmail.com', '1969-09-02', 'Married', '0000-00-00', '0000-00-00', 'NGAZIMBE VILLAGE', '', '', '', '$2y$10$dt56.ztu0fJmtUGyaTQhfO275LGjEdsB1KVfNTZI/1A2OKFRWkn8y', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, ''),
(22, 'PRS20', '19', '26', '', '', 'AGGRIPA', 'CHISURO', 'none', 'none', '', '', 'achisuro@gmail.com', '1973-05-24', 'Married', '0000-00-00', '0000-00-00', 'NGAZIMBE VILLAGE', '', '', '', '$2y$10$PfE1eI8DYQvb5R3E2CctEO4hc9pIzp7dJ1TKl9E3yPQXKT5stHCLi', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, ''),
(24, 'MP00042', 'select', 'select', '', '', 'MP Super Admin', '', 'none', 'none', '', '', 'mpsuperadmin@gmail.com', '2001-11-11', '', '0000-00-00', '0000-00-00', '', '', '', '', '$2y$10$vx80lOVIiqm0vDu0JUcrQu9Vfxo7eTPb0X9vlUUotkSfKLjw3JjH6', 'Female', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Other Document', '', 0, 1, ''),
(25, 'PRS0022', '14', '10', '', '', 'JULIANA', 'MUREVI', 'none', 'none', '0775634748', '0773623369', 'jmurevi@gmail.com', '1989-08-20', 'Married', '2025-02-06', '0000-00-00', '32191 MABVAZUVA ESTATE, RUWA', '', '', '', '$2y$10$1N/fx7l0fskNEhw15.dp6.pR3zkRHqoLzIIN5mqtYx3dnHi10/npS', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, ''),
(26, 'PRS0030', '14', '10', '', '', 'JULIANA', 'MUREVI', 'none', 'none', '0775634748', '0773623369', 'jmurevi1@gmail.com', '1989-08-20', 'Married', '2025-02-06', '0000-00-00', '32191 MABVAZUVA ESTATE, RUWA', '', '', '', '$2y$10$o82YMuQmBLeVG4r3ogJziuCtY0sqoHAY7Vo3rIYL9bFUq8BB5x20y', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, ''),
(27, 'PRS0023', '14', '14', '', '', 'KEPHAS', 'TURE', 'none', 'none', '0773527946', '0776503844', 'kture@gmail.com', '1980-07-19', 'Married', '2025-01-21', '0000-00-00', '4972 USHEWEKUNZE, HARARE', '', '', '', '$2y$10$k1URlCxFXrtcxztrdyVSzOSk1YFL8rUZY1OoLefk3ahkkNZ/hVdMO', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, ''),
(29, 'PRS0024', '15', '16', '', '', 'RUTENDO', 'MUDARIKWA', 'none', 'none', '0781556156', '0772650635', 'rmudarikwa@gmail.com', '1990-06-25', 'Married', '2024-01-09', '0000-00-00', 'TAPFUMANEYI VILLAGE', '', '', '', '$2y$10$eeGvTLqr.2OHLKV3HSzQPe2pNIm8HreW0NgR88D9EGY3rtGGnEoTq', 'Female', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, ''),
(30, 'PRS0025', '15', '18', '', '', 'ISCAAC', 'LONGWE', 'none', 'none', '0773788179', '0772707770', 'ilongwe@gmail.com', '1964-06-06', 'Married', '2025-03-03', '0000-00-00', '2040 EASTLEA ZVISHAVANE', '', '', '', '$2y$10$XVn/XyJGlsQ1W8NAA/2coeGbxWKwH6xpXFYKKrrr41JIDB00us99m', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, ''),
(31, 'PRS0026', '20', '27', '', '', 'TINOTENDA', 'CHIHWAYI', 'none', 'none', '0788422756', '0773577127', 'tchihwayi@gmail.com', '2000-07-01', 'Single', '2025-05-28', '0000-00-00', '', '', '', '', '$2y$10$3cIhQhdcgXtBAICivHayOeZNsS2D05ezfKBv0fbHmPOdhBJzm6peS', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, ''),
(32, 'PRS0027', '20', '22', '', '', 'ROBSON', 'KARAMBA', 'none', 'none', '0773160033', '0775688584', 'rkwaramba@gmail.com', '1989-05-30', 'Married', '0000-00-00', '0000-00-00', '', '', '', '', '$2y$10$IlaslLBp57XRfqjHmFjkGuiI/hC.fflD3SiGwlw22WfXzFmISApYq', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, ''),
(33, 'PRS0028', '17', '19', '', '', 'CLEOPAS', 'DAMBA', 'none', 'none', '07834353633', '0780956269', 'cdamba@gmail.com', '1994-09-09', 'Married', '2023-01-01', '0000-00-00', '', '', '', '', '$2y$10$tuX4rilxZS3zd2MUjXbKAuJAQBBE/nJ0VkzwTGNB5DkTM3vcTfrs6', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, ''),
(34, 'PRS0029', '17', '19', '', '', 'TATENDA', 'HOFISI', 'none', 'none', '0774255824', '', 'thofisi@gmail.com', '1991-10-09', '', '0000-00-00', '0000-00-00', '', '', '', '', '$2y$10$oY7WZZiFsvOgPzrnq6.1QOmjszXCVHqNonxTCl3Q59FsgaTMa.QR2', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Other Document', '', 0, 1, ''),
(35, 'PRS0031', '17', '19', '', '', 'NDONGAYAMI', 'MATAURE', 'none', 'none', '0710833325', '', 'nmataurw@gmail.com', '1984-12-10', '', '0000-00-00', '0000-00-00', '', '', '', '', '$2y$10$EAANt8/azdoJy.8Aa/qxHOqYQHmD.aKEusRe35dMkeXl57x3fZ4uS', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, ''),
(36, 'PRS0033', '10', '20', '', '', 'VELDAH', 'GAMBARA', 'none', 'none', '0776352676', '', 'vgambara@gmail.com', '1979-02-25', '', '0000-00-00', '0000-00-00', '', '', '', '', '$2y$10$C34.CXmE4adtLDAyjZxg1u3.USBV28.ZEbxnHpJRo/iBKhoUvHGZO', 'Female', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, ''),
(37, 'PRS0034', '10', '20', '', '', 'ANNE', 'KAMBAMBARA', 'none', 'none', '0776193569', '', 'akambambara@gmail.com', '1985-08-06', '', '0000-00-00', '0000-00-00', '', '', '', '', '$2y$10$3VzG2qInateHGelGxLZ2jeJLKsrxDSJK/x2/Oyl.7Y.I7sRdQt9l2', 'Female', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, ''),
(38, 'PRS0035', '10', '20', '', '', 'IRENE', 'SADOMBA', 'none', 'none', '0772204676', '', 'isadomba@gmail.com', '1969-06-27', '', '0000-00-00', '0000-00-00', '', '', '', '', '$2y$10$OqWkq3S8Famn3FpPazPxN.lhgsfofkfTVeF6lvLzVFcnPTyY3hERa', 'Female', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, ''),
(39, 'fhhehes', '14', '6', 'ffff', 'fff', 'tdfsss', 'ffff', 'none', 'none', 'ds233443', 'fff', 'fff@gmail.com', '2025-08-21', 'Widowed', '2025-07-28', '0000-00-00', '2434bbfff', 'sss', 'ss', '', '$2y$10$.eEEm5Hcqh8b4ZBbo27oQuw0CuSQheNrOCI0pzAMKmjWLzrL3jId6', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, '');

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

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

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

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

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

CREATE TABLE `staff_attendance_type` (
  `id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

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

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

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

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

INSERT INTO `staff_designation` (`id`, `designation`, `is_active`) VALUES
(5, 'VPA TEACHER', 'yes'),
(6, 'ICT TEACHER', 'yes'),
(10, 'ECD A TEACHER', 'yes'),
(11, 'ECD B TEACHER', 'yes'),
(12, 'GRADE 1 TEACHER', 'yes'),
(13, 'GRADE 2 TEACHER', 'yes'),
(14, 'GRADE 3 TEACHER', 'yes'),
(15, 'GRADE 4 TEACHER', 'yes'),
(16, 'GRADE 5 TEACHER', 'yes'),
(17, 'GRADE 6 TEACHER', 'yes'),
(18, 'GRADE 7 TEACHER', 'yes'),
(19, 'DRIVER', 'yes'),
(20, 'ANCILLARY STAFF', 'yes'),
(21, 'ADMIN ASSISTANT', 'yes'),
(22, 'PRINCIPAL', 'yes'),
(23, 'ADMINISTRATOR ', 'yes'),
(24, 'RECEPTIONIST', 'yes'),
(25, 'MATRON', 'yes'),
(26, 'SECURITY', 'yes');

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

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

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

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

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

CREATE TABLE `staff_leave_request` (
  `id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `leave_type_id` int(11) NOT NULL,
  `leave_from` date NOT NULL,
  `leave_to` date NOT NULL,
  `leave_days` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

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

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

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

CREATE TABLE `staff_payslip` (
  `id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `basic` int(11) NOT NULL,
  `total_allowance` int(11) NOT NULL,
  `total_deduction` int(11) NOT NULL,
  `leave_deduction` int(11) NOT NULL,
  `tax` varchar(200) NOT NULL,
  `net_salary` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `staff_roles` (
  `id` int(11) NOT NULL,
  `role_id` int(11) DEFAULT NULL,
  `staff_id` int(11) DEFAULT NULL,
  `is_active` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `staff_roles` (`id`, `role_id`, `staff_id`, `is_active`, `created_at`, `updated_at`) VALUES
(0, 2, 0, 0, '2025-08-21 06:39:00', ''),
(1, 7, 1, 0, '2022-08-11 11:24:34', '0000-00-00 00:00:00'),
(4, 2, 4, 0, '2023-02-03 18:04:08', ''),
(5, 2, 5, 0, '2023-02-03 18:06:21', ''),
(6, 2, 6, 0, '2023-02-10 15:53:20', ''),
(7, 2, 7, 0, '2023-02-10 15:57:10', ''),
(8, 2, 8, 0, '2023-02-10 15:59:33', ''),
(9, 2, 9, 0, '2023-02-10 16:01:41', ''),
(10, 2, 10, 0, '2023-02-10 16:05:01', ''),
(11, 2, 11, 0, '2023-02-10 16:10:29', ''),
(12, 2, 12, 0, '2023-02-10 16:15:16', ''),
(13, 2, 13, 0, '2023-02-14 18:00:11', ''),
(14, 2, 14, 0, '2023-02-10 16:32:26', ''),
(15, 2, 15, 0, '2023-02-10 16:35:54', ''),
(16, 1, 16, 0, '2023-02-10 16:40:08', ''),
(17, 1, 17, 0, '2023-02-10 16:44:19', ''),
(18, 1, 18, 0, '2023-02-10 16:48:06', ''),
(19, 1, 19, 0, '2023-02-10 16:56:07', ''),
(20, 1, 20, 0, '2023-02-10 17:01:26', ''),
(21, 1, 21, 0, '2023-02-10 17:05:18', ''),
(22, 1, 22, 0, '2023-02-10 17:07:48', ''),
(24, 7, 24, 0, '2023-04-19 06:07:38', '');

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

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

CREATE TABLE `staff_timeline` (
  `id` int(11) NOT NULL,
  `staff_id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `students` (
  `id` int(11) NOT NULL,
  `parent_id` int(11) 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 DEFAULT NULL,
  `permanent_address` text DEFAULT NULL,
  `category_id` varchar(100) DEFAULT NULL,
  `route_id` int(11) NOT NULL,
  `school_house_id` int(11) NOT NULL,
  `blood_group` varchar(200) NOT NULL,
  `vehroute_id` int(11) NOT NULL,
  `hostel_room_id` int(11) 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 DEFAULT NULL,
  `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 DEFAULT NULL,
  `height` varchar(100) NOT NULL,
  `weight` varchar(100) NOT NULL,
  `measurement_date` date NOT NULL,
  `app_key` text DEFAULT NULL,
  `parent_app_key` text DEFAULT NULL,
  `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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `student_attendences` (
  `id` int(11) NOT NULL,
  `student_session_id` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `attendence_type_id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

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

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

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

CREATE TABLE `student_fees` (
  `id` int(11) NOT NULL,
  `student_session_id` int(11) DEFAULT NULL,
  `feemaster_id` int(11) 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 DEFAULT NULL,
  `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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `student_fees_deposite` (
  `id` int(11) NOT NULL,
  `student_fees_master_id` int(11) NOT NULL,
  `student_group_id` int(11) NOT NULL,
  `fee_groups_feetype_id` int(11) NOT NULL,
  `amount_detail` text NOT NULL,
  `receipt` varchar(20) NOT NULL,
  `is_active` varchar(10) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `invoice` varchar(400) NOT NULL,
  `transfer` int(11) NOT NULL,
  `cashbook` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `student_fees_discounts` (
  `id` int(11) NOT NULL,
  `student_session_id` int(11) DEFAULT NULL,
  `fees_discount_id` int(11) DEFAULT NULL,
  `status` varchar(20) DEFAULT 'assigned',
  `payment_id` varchar(50) DEFAULT NULL,
  `description` text 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `student_fees_master` (
  `id` int(11) NOT NULL,
  `is_system` int(11) NOT NULL,
  `student_session_id` int(11) NOT NULL,
  `fee_session_group_id` int(11) NOT NULL,
  `amount` float(10,2) NOT NULL,
  `is_active` varchar(10) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `invoice` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `student_session` (
  `id` int(11) NOT NULL,
  `session_id` int(11) DEFAULT NULL,
  `student_id` int(11) DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `route_id` int(11) NOT NULL,
  `hostel_room_id` int(11) NOT NULL,
  `vehroute_id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `student_sibling` (
  `id` int(11) NOT NULL,
  `student_id` int(11) DEFAULT NULL,
  `sibling_student_id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

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

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

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

CREATE TABLE `student_timeline` (
  `id` int(11) NOT NULL,
  `student_id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `student_transport_fees` (
  `id` int(11) NOT NULL,
  `student_session_id` int(11) 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 DEFAULT NULL,
  `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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `subjects` (
  `id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `supinvoicegenaration`
--

CREATE TABLE `supinvoicegenaration` (
  `id` int(11) NOT NULL,
  `status` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `supplier` (
  `id` int(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `supplier_invoice` (
  `id` int(11) NOT NULL,
  `account_name` 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,
  `warehouse` varchar(255) NOT NULL,
  `originalqnty` int(11) DEFAULT NULL,
  `quantity` varchar(100) NOT NULL,
  `price` varchar(100) NOT NULL,
  `discount` varchar(100) NOT NULL,
  `total_amount` varchar(100) NOT NULL,
  `mv_expense` varchar(100) NOT NULL,
  `active` int(11) NOT NULL,
  `module` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Triggers `supplier_invoice`
--
DELIMITER $$
CREATE TRIGGER `after_supplier_invoice_insert` AFTER INSERT ON `supplier_invoice` FOR EACH ROW BEGIN
    INSERT INTO unif_stock_mvmnt (itemcode, date, description, warehouse, qnty_in, reference, balance)
    VALUES (NEW.account_name, NEW.date_created, NEW.description, NEW.warehouse, NEW.quantity, NEW.inv_number, NEW.originalqnty + NEW.quantity);
END
$$
DELIMITER ;

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

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

CREATE TABLE `supplier_receipt` (
  `id` int(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `supplier_statement` (
  `id` int(11) NOT NULL,
  `account_name` varchar(100) NOT NULL,
  `supplier` varchar(200) NOT NULL,
  `reference` varchar(200) NOT NULL,
  `description` varchar(200) NOT NULL,
  `warehouse` varchar(255) NOT NULL,
  `currency` varchar(100) NOT NULL,
  `debit` varchar(100) NOT NULL,
  `credit` varchar(100) NOT NULL,
  `mv_expense` varchar(100) NOT NULL,
  `date` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `teacher_subjects` (
  `id` int(11) NOT NULL,
  `session_id` int(11) DEFAULT NULL,
  `class_section_id` int(11) DEFAULT NULL,
  `subject_id` int(11) DEFAULT NULL,
  `teacher_id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `teams` (
  `id` int(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tempsup_invoice`
--

CREATE TABLE `tempsup_invoice` (
  `id` int(11) NOT NULL,
  `account_name` 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,
  `warehouse` varchar(255) NOT NULL,
  `quantity` varchar(100) NOT NULL,
  `price` varchar(100) NOT NULL,
  `discount` varchar(100) NOT NULL,
  `total_amount` varchar(100) NOT NULL,
  `mv_expense` varchar(100) NOT NULL,
  `active` int(11) NOT NULL,
  `module` varchar(100) NOT NULL,
  `originalqnty` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `timetables` (
  `id` int(11) NOT NULL,
  `teacher_subject_id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `transfered_funds`
--

CREATE TABLE `transfered_funds` (
  `id` int(11) NOT NULL,
  `date` varchar(200) NOT NULL,
  `cashbook` varchar(200) NOT NULL,
  `module` varchar(100) NOT NULL,
  `account` varchar(200) NOT NULL,
  `description` varchar(400) NOT NULL,
  `reference` varchar(100) NOT NULL,
  `deposits` varchar(200) NOT NULL,
  `udf_status` int(11) NOT NULL,
  `date_from` varchar(50) NOT NULL,
  `date_to` varchar(50) NOT NULL,
  `payment_mode` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transfered_funds`
--

INSERT INTO `transfered_funds` (`id`, `date`, `cashbook`, `module`, `account`, `description`, `reference`, `deposits`, `udf_status`, `date_from`, `date_to`, `payment_mode`) VALUES
(1, '2025-05-05', 'CASH ACCOUNT', 'GL', 'Undeposited Funds', 'Undeposited Funds History From 01-03-2025 To 05-05-2025', 'UDF1723', '495.00', 1, '2025-03-01', '2025-05-05', 'USD');

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

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

CREATE TABLE `transport_route` (
  `id` int(11) NOT NULL,
  `route_title` varchar(100) DEFAULT NULL,
  `no_of_vehicle` int(11) DEFAULT NULL,
  `fare` float(10,2) DEFAULT NULL,
  `note` text 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=utf8 COLLATE=utf8_general_ci;

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

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

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

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

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

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

--
-- Table structure for table `undeposited_funds`
--

CREATE TABLE `undeposited_funds` (
  `id` int(11) NOT NULL,
  `date_captured` varchar(100) NOT NULL,
  `cashbook` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `account` varchar(100) NOT NULL,
  `module` varchar(100) NOT NULL,
  `receipt` varchar(100) NOT NULL,
  `debit` varchar(100) NOT NULL,
  `date_from` varchar(100) NOT NULL,
  `date_to` varchar(100) NOT NULL,
  `payment_mode` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `uniformitem` (
  `id` int(11) 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` int(11) 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 COLLATE=latin1_swedish_ci;

--
-- Triggers `uniformitem`
--
DELIMITER $$
CREATE TRIGGER `after_uniformitem_delete` AFTER DELETE ON `uniformitem` FOR EACH ROW BEGIN
    DELETE FROM unif_stock_level WHERE id = OLD.id;
END
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `after_uniformitem_insert` AFTER INSERT ON `uniformitem` FOR EACH ROW BEGIN
    INSERT INTO unif_stock_level (id, itemcode, description, warehouse, qnty_on_hand)
    VALUES (NEW.id, NEW.itemcode, NEW.itemdescript, NEW.warehouse, NEW.quantity);
END
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `after_uniformitem_update` AFTER UPDATE ON `uniformitem` FOR EACH ROW BEGIN
    UPDATE unif_stock_level
    SET 
        itemcode = NEW.itemcode,
        description = NEW.itemdescript,
        warehouse = NEW.warehouse,
        qnty_on_hand = NEW.quantity
    WHERE id = NEW.id;
END
$$
DELIMITER ;

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

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

CREATE TABLE `uniformpos` (
  `id` int(11) NOT NULL,
  `student_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `itemcode` varchar(200) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `narration` varchar(255) NOT NULL,
  `warehouse` varchar(255) DEFAULT NULL,
  `originalqnty` varchar(255) DEFAULT NULL,
  `quantity` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `payment` varchar(255) DEFAULT NULL,
  `created_date` varchar(255) DEFAULT NULL,
  `balance` varchar(255) DEFAULT NULL,
  `cost` varchar(255) DEFAULT NULL,
  `discount` varchar(255) NOT NULL DEFAULT '0',
  `batch_num` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Triggers `uniformpos`
--
DELIMITER $$
CREATE TRIGGER `after_uniformpos_insert` AFTER INSERT ON `uniformpos` FOR EACH ROW BEGIN
    INSERT INTO unif_stock_mvmnt (itemcode, date, description,qnty_out, reference,warehouse,balance)
    VALUES (NEW.itemcode, NEW.created_date, NEW.description, NEW.quantity, NEW.batch_num, NEW.warehouse,NEW.originalqnty-NEW.quantity);
END
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `insert_to_stock_mgmtt` AFTER INSERT ON `uniformpos` FOR EACH ROW BEGIN
    -- Insert data into unif_stock_mgnt table with additional calculations
    INSERT INTO unif_stock_mgnt (
        created_date, 
        itemcode, 
        description, 
        cost_price, 
        selling_price, 
        originalqnty, 
        quantity, 
        qnty_on_hand, 
        total_cost_price, 
        total_selling_price, 
        profit_loss, 
        exp_total_cost, 
        exp_total_selling, 
        exp_profit_loss
    )
    VALUES (
        NEW.created_date,                            -- Use the created_date from the inserted record
        NEW.itemcode,                                -- Use the itemcode from the inserted record
        NEW.description,                             -- Use the description from the inserted record
        NEW.cost,                                    -- Use the cost from the inserted record
        NEW.amount,                                  -- Use the amount (selling price) from the inserted record
        NEW.originalqnty,                            -- Use the original quantity from the inserted record
        NEW.quantity,                                -- Use the quantity from the inserted record
        NEW.originalqnty - NEW.quantity,             -- Calculate qnty_on_hand
        (NEW.originalqnty - NEW.quantity) * NEW.cost, -- Calculate total_cost_price
        (NEW.originalqnty - NEW.quantity) * NEW.amount, -- Calculate total_selling_price
        ((NEW.originalqnty - NEW.quantity) * NEW.amount) - ((NEW.originalqnty - NEW.quantity) * NEW.cost), -- Calculate profit/loss
        ((NEW.originalqnty - NEW.quantity) * NEW.cost) , -- Calculate expected total cost
        ((NEW.originalqnty - NEW.quantity) * NEW.amount), -- Calculate expected total selling price
        ((NEW.originalqnty - NEW.quantity) * NEW.amount) - ((NEW.originalqnty - NEW.quantity) * NEW.cost) -- Calculate expected profit/loss
    );
END
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `uniformstatement` AFTER INSERT ON `uniformpos` FOR EACH ROW BEGIN
    INSERT INTO uniformstatement (payment,name,student_id, created_date, description,narration,credit, reference,balance)
    VALUES (NEW.payment,NEW.name,NEW.student_id, NEW.created_date, NEW.description,NEW.narration, NEW.amount, NEW.batch_num,-NEW.amount);
END
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `update_uniform_stocks` AFTER INSERT ON `uniformpos` FOR EACH ROW BEGIN
    UPDATE uniformitem 
    SET quantity = quantity - NEW.quantity 
    WHERE itemcode = NEW.itemcode;
END
$$
DELIMITER ;

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

--
-- Table structure for table `uniformposrec`
--

CREATE TABLE `uniformposrec` (
  `id` int(11) NOT NULL,
  `student_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `gl_account` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `narration` varchar(19) NOT NULL,
  `reference` varchar(255) NOT NULL,
  `warehouse` varchar(255) DEFAULT NULL,
  `originalqnty` varchar(255) DEFAULT NULL,
  `quantity` varchar(255) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `payment` varchar(255) DEFAULT NULL,
  `created_date` varchar(255) DEFAULT NULL,
  `balance` int(11) DEFAULT NULL,
  `total_amount` int(11) DEFAULT NULL,
  `discount` int(11) NOT NULL DEFAULT 0,
  `batch_num` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `uniformposrec`
--

INSERT INTO `uniformposrec` (`id`, `student_id`, `name`, `gl_account`, `description`, `narration`, `reference`, `warehouse`, `originalqnty`, `quantity`, `amount`, `payment`, `created_date`, `balance`, `total_amount`, `discount`, `batch_num`) VALUES
(1, 'PR23-0001', 'JORDIN DIWA', 'Uniform ', 'pyament', 'pyament', 'INV0002', NULL, NULL, NULL, 80, 'USD', '2025-05-05', NULL, 0, 0, 'REC0001');

--
-- Triggers `uniformposrec`
--
DELIMITER $$
CREATE TRIGGER `after_insert_uniformposrec` AFTER INSERT ON `uniformposrec` FOR EACH ROW BEGIN
    INSERT INTO uniformstatement (payment,name,student_id, created_date, description,narration,debit, reference,balance)
    VALUES (NEW.payment,NEW.name,NEW.student_id, NEW.created_date, NEW.description,NEW.narration, NEW.amount, NEW.batch_num,-NEW.amount);
END
$$
DELIMITER ;

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

--
-- Table structure for table `uniformpostemp`
--

CREATE TABLE `uniformpostemp` (
  `id` int(11) NOT NULL,
  `student_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `itemcode` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `narration` varchar(255) DEFAULT NULL,
  `warehouse` varchar(255) DEFAULT NULL,
  `originalqnty` varchar(255) DEFAULT NULL,
  `quantity` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `payment` varchar(255) DEFAULT NULL,
  `created_date` varchar(255) DEFAULT NULL,
  `cost` varchar(255) DEFAULT NULL,
  `discount` varchar(255) NOT NULL DEFAULT '0',
  `batch_num` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `uniformpostemprec`
--

CREATE TABLE `uniformpostemprec` (
  `id` int(11) NOT NULL,
  `student_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `gl_account` varchar(255) DEFAULT NULL,
  `itemcode` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `narration` varchar(19) NOT NULL,
  `reference` varchar(255) DEFAULT NULL,
  `warehouse` varchar(255) DEFAULT NULL,
  `originalqnty` varchar(255) DEFAULT NULL,
  `quantity` varchar(255) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `payment` varchar(255) DEFAULT NULL,
  `created_date` varchar(255) DEFAULT NULL,
  `total_amount` int(11) DEFAULT NULL,
  `discount` int(11) NOT NULL DEFAULT 0,
  `batch_num` varchar(255) DEFAULT NULL,
  `balance` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `uniformstatement`
--

CREATE TABLE `uniformstatement` (
  `id` int(11) NOT NULL,
  `created_date` date NOT NULL,
  `student_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `reference` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `narration` varchar(223) NOT NULL,
  `payment` varchar(255) NOT NULL,
  `debit` decimal(10,0) DEFAULT NULL,
  `credit` decimal(10,0) DEFAULT NULL,
  `balance` decimal(10,0) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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

CREATE TABLE `uniform_group` (
  `id` int(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Stand-in structure for view `uniform_summary`
-- (See below for the actual view)
--
CREATE TABLE `uniform_summary` (
`qnty_in` decimal(32,0)
,`qnty_out` decimal(32,0)
,`quantity` decimal(32,0)
);

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

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

CREATE TABLE `uniform_values` (
  `id` int(11) 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(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `unifreceipting`
--

CREATE TABLE `unifreceipting` (
  `id` int(11) NOT NULL,
  `student_id` varchar(255) DEFAULT NULL,
  `rec` varchar(25) NOT NULL,
  `created_date` date NOT NULL,
  `gl_account` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `inv_number` varchar(255) DEFAULT NULL,
  `amount` decimal(11,0) DEFAULT NULL,
  `currency` varchar(40) NOT NULL,
  `discount` int(11) NOT NULL,
  `total_amount` decimal(10,0) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `unifreceipttemp`
--

CREATE TABLE `unifreceipttemp` (
  `id` int(11) NOT NULL,
  `student_id` varchar(255) DEFAULT NULL,
  `rec` varchar(25) NOT NULL,
  `created_date` date NOT NULL,
  `gl_account` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `inv_number` varchar(255) DEFAULT NULL,
  `amount` decimal(11,0) DEFAULT NULL,
  `currency` varchar(40) NOT NULL,
  `discount` int(11) NOT NULL,
  `total_amount` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `unif_stock_level`
--

CREATE TABLE `unif_stock_level` (
  `id` int(11) NOT NULL,
  `itemcode` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `warehouse` varchar(255) NOT NULL,
  `qnty_on_hand` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `unif_stock_mgnt`
--

CREATE TABLE `unif_stock_mgnt` (
  `id` int(11) NOT NULL,
  `created_date` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `itemcode` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `originalqnty` varchar(255) NOT NULL,
  `quantity` varchar(255) NOT NULL,
  `qnty_on_hand` varchar(255) DEFAULT NULL,
  `cost_price` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `selling_price` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `total_cost_price` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `total_selling_price` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `profit_loss` int(11) DEFAULT NULL,
  `exp_total_cost` int(11) DEFAULT NULL,
  `exp_total_selling` int(11) DEFAULT NULL,
  `exp_profit_loss` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `unif_stock_mvmnt`
--

CREATE TABLE `unif_stock_mvmnt` (
  `id` int(11) NOT NULL,
  `date` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `itemcode` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `description` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `reference` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `warehouse` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `qnty_in` int(11) DEFAULT NULL,
  `qnty_out` int(11) DEFAULT NULL,
  `balance` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `uni_trans_report`
--

CREATE TABLE `uni_trans_report` (
  `id` int(11) NOT NULL,
  `created_date` date NOT NULL,
  `studentid` int(11) NOT NULL,
  `student_name` varchar(255) NOT NULL,
  `itemcode` varchar(50) NOT NULL,
  `description` varchar(255) NOT NULL,
  `reference` varchar(100) DEFAULT NULL,
  `debit` decimal(10,2) NOT NULL,
  `credit` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `userlog` (
  `id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `userlog` (`id`, `user`, `role`, `ipaddress`, `user_agent`, `login_datetime`) VALUES
(0, 'pjssuperadmin@gmail.com', 'Super Admin', '::1', 'Chrome 139.0.0.0, Windows 10', '2025-08-21 14:13:58');

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `user_id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `users_authentication` (
  `id` int(11) NOT NULL,
  `users_id` int(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `vehicles` (
  `id` int(10) 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 DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `vehicle_routes` (
  `id` int(10) UNSIGNED NOT NULL,
  `route_id` int(11) DEFAULT NULL,
  `vehicle_id` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

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

CREATE TABLE `visitors_book` (
  `id` int(11) 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(11) 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=utf8 COLLATE=utf8_general_ci;

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

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

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

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

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

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

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

INSERT INTO `warehouse` (`id`, `warehouse`, `description`, `created_date`) VALUES
(1, 'Store room', 'Store room', '2025-05-05');

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

--
-- Structure for view `uniform_summary`
--
DROP TABLE IF EXISTS `uniform_summary`;

CREATE ALGORITHM=UNDEFINED DEFINER=`melsoftschoolpre`@`localhost` SQL SECURITY DEFINER VIEW `uniform_summary`  AS SELECT (select sum(`unif_stock_mvmnt`.`qnty_in`) from `unif_stock_mvmnt`) AS `qnty_in`, (select sum(`unif_stock_mvmnt`.`qnty_out`) from `unif_stock_mvmnt`) AS `qnty_out`, (select sum(`uniformitem`.`quantity`) from `uniformitem`) AS `quantity` ;

--
-- 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 `array_testing`
--
ALTER TABLE `array_testing`
  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 `cashbook_temp`
--
ALTER TABLE `cashbook_temp`
  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 `invoicegenaration`
--
ALTER TABLE `invoicegenaration`
  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 `journaltemp`
--
ALTER TABLE `journaltemp`
  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 `receiptgenaration`
--
ALTER TABLE `receiptgenaration`
  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`);

--
-- 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`);

--
-- 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 `supinvoicegenaration`
--
ALTER TABLE `supinvoicegenaration`
  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 `tempsup_invoice`
--
ALTER TABLE `tempsup_invoice`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `transfered_funds`
--
ALTER TABLE `transfered_funds`
  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 `undeposited_funds`
--
ALTER TABLE `undeposited_funds`
  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 `uniformposrec`
--
ALTER TABLE `uniformposrec`
  ADD PRIMARY KEY (`id`);

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

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

--
-- Indexes for table `uniformstatement`
--
ALTER TABLE `uniformstatement`
  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 `unifreceipting`
--
ALTER TABLE `unifreceipting`
  ADD PRIMARY KEY (`id`);

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

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

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

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

--
-- Indexes for table `uni_trans_report`
--
ALTER TABLE `uni_trans_report`
  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(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `allergies`
--
ALTER TABLE `allergies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `array_testing`
--
ALTER TABLE `array_testing`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `assets`
--
ALTER TABLE `assets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `assettypes`
--
ALTER TABLE `assettypes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `attendence_type`
--
ALTER TABLE `attendence_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `bankrec`
--
ALTER TABLE `bankrec`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `bankrec_yrperiod`
--
ALTER TABLE `bankrec_yrperiod`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `bank_rates`
--
ALTER TABLE `bank_rates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `bank_rates_history`
--
ALTER TABLE `bank_rates_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `books`
--
ALTER TABLE `books`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `book_depreciation`
--
ALTER TABLE `book_depreciation`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `book_issues`
--
ALTER TABLE `book_issues`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cashbook`
--
ALTER TABLE `cashbook`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cashbook_accounts`
--
ALTER TABLE `cashbook_accounts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `cashbook_report`
--
ALTER TABLE `cashbook_report`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cashbook_temp`
--
ALTER TABLE `cashbook_temp`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `certificates`
--
ALTER TABLE `certificates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `classes`
--
ALTER TABLE `classes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `class_sections`
--
ALTER TABLE `class_sections`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `class_teacher`
--
ALTER TABLE `class_teacher`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `complaint`
--
ALTER TABLE `complaint`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `complaint_type`
--
ALTER TABLE `complaint_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contents`
--
ALTER TABLE `contents`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_for`
--
ALTER TABLE `content_for`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `currency`
--
ALTER TABLE `currency`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `currency_table`
--
ALTER TABLE `currency_table`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `customer`
--
ALTER TABLE `customer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_invoice`
--
ALTER TABLE `customer_invoice`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_receipt`
--
ALTER TABLE `customer_receipt`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_statement`
--
ALTER TABLE `customer_statement`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `department`
--
ALTER TABLE `department`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `depreciationexpenses`
--
ALTER TABLE `depreciationexpenses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `depreciationmethods`
--
ALTER TABLE `depreciationmethods`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dispatch_receive`
--
ALTER TABLE `dispatch_receive`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `email_config`
--
ALTER TABLE `email_config`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `enquiry`
--
ALTER TABLE `enquiry`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `enquiry_type`
--
ALTER TABLE `enquiry_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `exams`
--
ALTER TABLE `exams`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `exam_results`
--
ALTER TABLE `exam_results`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `exam_schedules`
--
ALTER TABLE `exam_schedules`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expenses`
--
ALTER TABLE `expenses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expense_head`
--
ALTER TABLE `expense_head`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fd_department`
--
ALTER TABLE `fd_department`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `feecategory`
--
ALTER TABLE `feecategory`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `feemasters`
--
ALTER TABLE `feemasters`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fees_discounts`
--
ALTER TABLE `fees_discounts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `feetype`
--
ALTER TABLE `feetype`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fee_groups`
--
ALTER TABLE `fee_groups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fee_groups_feetype`
--
ALTER TABLE `fee_groups_feetype`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fee_receipt_no`
--
ALTER TABLE `fee_receipt_no`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fee_session_groups`
--
ALTER TABLE `fee_session_groups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `follow_up`
--
ALTER TABLE `follow_up`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `general_calls`
--
ALTER TABLE `general_calls`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `glaccount_types`
--
ALTER TABLE `glaccount_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `glledger_account`
--
ALTER TABLE `glledger_account`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=200;

--
-- AUTO_INCREMENT for table `glsub_account`
--
ALTER TABLE `glsub_account`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=149;

--
-- AUTO_INCREMENT for table `grades`
--
ALTER TABLE `grades`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `homework`
--
ALTER TABLE `homework`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `homework_evaluation`
--
ALTER TABLE `homework_evaluation`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `home_currency`
--
ALTER TABLE `home_currency`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `staff`
--
ALTER TABLE `staff`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;
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 */;
