-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 10, 2023 at 10:23 AM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 8.0.19

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: `ms`
--
CREATE DATABASE MS;

USE MS;

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

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

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

INSERT INTO `ACCUMMDEPREC` (
  `ID`,
  `ACCUMMDEPREC`,
  `DESCRIPTION`,
  `ACTIVE`
) VALUES (
  1,
  'PP',
  'PP',
  1
);

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

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

CREATE TABLE `ALLERGIES` (
  `ID` INT(11) NOT NULL,
  `ALLERGIES` VARCHAR(200) NOT NULL,
  `DESCRIPTION` VARCHAR(300) NOT NULL,
  `ACTIVE` INT(11) NOT NULL
) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4;

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

INSERT INTO `ALLERGIES` (
  `ID`,
  `ALLERGIES`,
  `DESCRIPTION`,
  `ACTIVE`
) VALUES (
  1,
  'ashma',
  'ashmac',
  1
);

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

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

CREATE TABLE `ASSETS` (
  `ID` INT(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;

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

INSERT INTO `ASSETS` (
  `ID`,
  `DATE_CAPTURED`,
  `ASSET_CODE`,
  `DESCRIPTION`,
  `ASSET_TYPE`,
  `MASTER_ASSET`,
  `UNITS_NUM`,
  `SERIAL_NUM`,
  `ASSET_TYPE2`,
  `DEPARTMENT`,
  `EMPLOYEE`,
  `SUPPLIER`,
  `CAPEX_ORDER`,
  `PURCHASE_PRICE`,
  `INSURED_VALUE`,
  `SCRAP_VALUE`,
  `REVALUATION`,
  `PURCHASE_DATE`,
  `REPLACEMENT_DATE`,
  `REPLACEMENT_COST`,
  `BASE_COST`,
  `ROLL_OVER_RELIEF`,
  `ACTIVE`
) VALUES (
  1,
  '02-11-2022 01:02:53pm',
  'daniel',
  'new',
  'll',
  'ii',
  'iilllllllllllllll',
  'lll',
  '',
  'Accounts',
  'DANIEL',
  'kk',
  'kk',
  '40000',
  'kk',
  'hh',
  'kk',
  '2022-11-10',
  '2022-11-10',
  'll',
  'ii',
  '2022-11-30',
  1
);

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

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

CREATE TABLE `ASSETTYPES` (
  `ID` INT(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;

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

INSERT INTO `ASSETTYPES` (
  `ID`,
  `DATE_CAPTURED`,
  `ASSET_CODE`,
  `DESCRIPTION`,
  `ACCUM_DEP`,
  `DEP_EXPENSES`,
  `REVALUATION`,
  `INSURANCE`,
  `TAX_DEP`,
  `BOOK_DEP`,
  `ACTIVE`
) VALUES (
  1,
  '27-10-2022 02:16:50pm',
  'll',
  'll',
  'll',
  'lll',
  'lll',
  'll',
  'll',
  'lll',
  1
);

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

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

CREATE TABLE `ATTENDENCE_TYPE` (
  `ID` INT(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;

--
-- 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 NOT NULL,
  `DATE_CAPTURED` VARCHAR(20) NOT NULL,
  `CBB_DR` VARCHAR(10) NOT NULL,
  `CBB_CR` VARCHAR(10) NOT NULL,
  `TU_DR` VARCHAR(10) NOT NULL,
  `TU_CR` VARCHAR(10) NOT NULL,
  `RBB_DR` VARCHAR(10) NOT NULL,
  `RBB_CR` VARCHAR(10) NOT NULL,
  `DIFF_DR` VARCHAR(10) NOT NULL,
  `DIFF_CR` VARCHAR(10) NOT NULL,
  `ACTIVE` INT NOT NULL,
  `CASHBOOK_ID` VARCHAR(20) NOT NULL,
  `CASHBOOK` VARCHAR(100) NOT NULL
) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4;

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

INSERT INTO `BANKREC` (
  `ID`,
  `DATE_CAPTURED`,
  `CBB_DR`,
  `CBB_CR`,
  `TU_DR`,
  `TU_CR`,
  `RBB_DR`,
  `RBB_CR`,
  `DIFF_DR`,
  `DIFF_CR`,
  `ACTIVE`,
  `CASHBOOK_ID`,
  `CASHBOOK`
) VALUES (
  7,
  '2022-12-28 12:11:52p',
  '178',
  '0',
  '122',
  '300',
  '178',
  '0',
  '0',
  '10',
  1,
  '25',
  'CBZ-ZWL'
);

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

CREATE TABLE `BANKREC_YRPERIOD` (
  `ID` INT(11) NOT NULL,
  `YEAR` VARCHAR(100) NOT NULL,
  `ACTIVE` INT(11) NOT NULL
) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4;

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

--
-- Indexes for dumped tables
--
--
-- 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;

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

INSERT INTO `BANK_RATES` (
  `ID`,
  `DATE`,
  `FOREIGN_CURRENCY`,
  `HOME_CURRENCY`,
  `FOREIGN_RATE`,
  `HOME_RATE`,
  `DESCRIPTION`,
  `ACTIVE`
) VALUES (
  7,
  '26-10-2022 12:35:39pm',
  'Zwl',
  'USD',
  '695',
  '1',
  '1 dollar for 690',
  1
),
(
  8,
  '26-10-2022 12:41:39pm',
  'Rand',
  'USD',
  '160',
  '1',
  '160 ZAR TO 1USD',
  1
),
(
  9,
  '16-12-2022 03:11:02pm',
  'RTGS',
  'USD',
  '700',
  '1',
  '1 DOLLAR FOR 700',
  1
);

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

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

CREATE TABLE `BANK_RATES_HISTORY` (
  `ID` INT(50) 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;

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

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

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

INSERT INTO `BOOKS` (
  `ID`,
  `BOOK_TITLE`,
  `BOOK_NO`,
  `ISBN_NO`,
  `SUBJECT`,
  `RACK_NO`,
  `PUBLISH`,
  `AUTHOR`,
  `QTY`,
  `PERUNITCOST`,
  `POSTDATE`,
  `DESCRIPTION`,
  `AVAILABLE`,
  `IS_ACTIVE`,
  `CREATED_AT`,
  `UPDATED_AT`
) VALUES (
  1,
  'Heritage Studies',
  's111t',
  't1234',
  'English',
  '12',
  'kennedy',
  'munayaradzi',
  100,
  20.00,
  '2022-11-24',
  'heritage studies',
  'yes',
  'no',
  '2022-11-24 08:29:18',
  '0000-00-00 00:00:00'
);

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

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

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

INSERT INTO `BOOK_DEPRECIATION` (
  `ID`,
  `DATE_CAPTURED`,
  `ASSETCODE`,
  `PURCHASEVALUE`,
  `PURCHASEDATE`,
  `STARTDATE`,
  `DPMETHOD`,
  `TOTAL`,
  `PRIORYEARS`,
  `CURRENTYEAR`,
  `CURRENTPERIOD`,
  `INITIAL_ALLOWANCE`,
  `RESIDUAL_VALE`,
  `IMPAIREMENTS`,
  `NBV`,
  `ACTIVE`
) VALUES (
  24,
  '2022-11-23 03:20:30pm',
  'daniel',
  '40000',
  '2022-11-10',
  '2022-11-22',
  'pnm',
  '3240.75',
  '1296.3',
  '1296.3',
  '108.025',
  '0',
  '1111',
  '0',
  '0',
  1
);

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

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

CREATE TABLE `BOOK_ISSUES` (
  `ID` INT(11) 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;

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

INSERT INTO `BOOK_ISSUES` (
  `ID`,
  `BOOK_ID`,
  `RETURN_DATE`,
  `ISSUE_DATE`,
  `IS_RETURNED`,
  `MEMBER_ID`,
  `IS_ACTIVE`,
  `CREATED_AT`
) VALUES (
  1,
  1,
  '2022-12-01',
  '2022-11-24',
  1,
  1,
  'no',
  '2022-11-24 08:32:47'
),
(
  2,
  1,
  '2022-11-25',
  '2022-11-24',
  1,
  1,
  'no',
  '2022-11-25 00:57:18'
),
(
  3,
  1,
  '2022-11-25',
  '2022-11-25',
  1,
  1,
  'no',
  '2022-11-25 00:57:04'
),
(
  4,
  1,
  '2022-11-25',
  '2022-11-25',
  1,
  1,
  'no',
  '2022-11-25 00:58:50'
),
(
  5,
  1,
  '2022-11-27',
  '2022-11-25',
  0,
  1,
  'no',
  '2022-11-25 14:17:52'
);

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

--
-- 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
) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4;

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

INSERT INTO `CASHBOOK` (
  `ID`,
  `DATE_CAPTURED`,
  `DATE`,
  `CASHBOOK`,
  `DESCRIPTION`,
  `ACCOUNT`,
  `MODULE`,
  `RECEIPT`,
  `CURRENCY`,
  `DEBIT`,
  `CREDIT`,
  `BALANCE`,
  `ACTIVE`,
  `BANKREC`,
  `MV_EXPENSE`,
  `GL_ACCOUNT`
) VALUES (
  20,
  '2022-11-22 11:40:53am',
  '2022-11-21',
  'CBZ-ZWL',
  'gg',
  'dany',
  'Learner',
  '5444',
  '',
  '122',
  '0',
  '0',
  1,
  '0',
  '',
  ''
),
(
  21,
  '2022-11-22 12:29:20pm',
  '2022-11-21',
  'CBZ-ZWL',
  'correct',
  'dany',
  'Learner',
  '5444',
  '',
  '0',
  '300',
  '0',
  1,
  '1',
  '',
  ''
),
(
  22,
  '2022-11-22 12:51:35pm',
  '2022-11-22',
  'CBZ-ZWL',
  'ww',
  'dany',
  'Learner',
  '54444',
  '',
  '0',
  '100',
  '0',
  1,
  '0',
  '',
  ''
),
(
  23,
  '2022-12-06 11:54:34am',
  '2022-12-06',
  'CBZ-USD',
  'mmm',
  'mm',
  'Learner',
  'mm',
  '',
  '0',
  '888',
  '-888',
  1,
  '0',
  '',
  ''
),
(
  25,
  '2023-01-06 02:56:24pm',
  '2023-01-06',
  'CBZ-USD',
  'MONEY',
  'TINODAISHE',
  'Supplier',
  'INV0004',
  '',
  '0',
  '300',
  '0',
  1,
  '0',
  'H123W',
  'Income'
);

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

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

CREATE TABLE `CASHBOOK_ACCOUNTS` (
  `ID` INT(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;

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

INSERT INTO `CASHBOOK_ACCOUNTS` (
  `ID`,
  `CASHBOOK_ACCOUNTS`,
  `CURRENCY`,
  `DESCRIPTION`,
  `ACTIVE`
) VALUES (
  1,
  'CBZ-ZWL',
  'ZWL',
  'CBZ-ZWL',
  1
),
(
  2,
  'CBZ-USD',
  'USD',
  'CBZ-USD',
  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;

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

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

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

INSERT INTO `CATEGORIES` (
  `ID`,
  `CATEGORY`,
  `IS_ACTIVE`,
  `CREATED_AT`,
  `UPDATED_AT`
) VALUES (
  1,
  'student',
  'no',
  '2022-07-14 13:05:35',
  '0000-00-00 00:00:00'
);

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

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

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

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

INSERT INTO `CLASSES` (
  `ID`,
  `CLASS`,
  `IS_ACTIVE`,
  `CREATED_AT`,
  `UPDATED_AT`
) VALUES (
  7,
  'ECD A',
  'no',
  '2022-11-24 08:04:40',
  '0000-00-00 00:00:00'
),
(
  8,
  'ECD B',
  'no',
  '2022-11-24 08:04:48',
  '0000-00-00 00:00:00'
),
(
  9,
  'Grade 1',
  'no',
  '2022-11-24 08:06:13',
  '0000-00-00 00:00:00'
),
(
  10,
  'Grade 2',
  'no',
  '2022-11-24 08:07:17',
  '0000-00-00 00:00:00'
),
(
  11,
  'Grade 3',
  'no',
  '2022-11-24 08:07:27',
  '0000-00-00 00:00:00'
),
(
  12,
  'Grade 4',
  'no',
  '2022-11-24 08:07:38',
  '0000-00-00 00:00:00'
),
(
  13,
  'Grade 5',
  'no',
  '2022-11-24 08:07:44',
  '0000-00-00 00:00:00'
),
(
  14,
  'Grade 6',
  'no',
  '2022-11-24 08:07:52',
  '0000-00-00 00:00:00'
),
(
  15,
  'Grade 7',
  'no',
  '2022-11-24 08:08:05',
  '0000-00-00 00:00:00'
);

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

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

CREATE TABLE `CLASS_SECTIONS` (
  `ID` INT(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;

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

INSERT INTO `CLASS_SECTIONS` (
  `ID`,
  `CLASS_ID`,
  `SECTION_ID`,
  `IS_ACTIVE`,
  `CREATED_AT`,
  `UPDATED_AT`
) VALUES (
  7,
  7,
  11,
  'no',
  '2022-11-24 08:04:40',
  '0000-00-00 00:00:00'
),
(
  8,
  8,
  12,
  'no',
  '2022-11-24 08:04:48',
  '0000-00-00 00:00:00'
),
(
  9,
  9,
  13,
  'no',
  '2022-11-24 08:05:44',
  '0000-00-00 00:00:00'
),
(
  10,
  10,
  11,
  'no',
  '2022-11-24 08:07:17',
  '0000-00-00 00:00:00'
),
(
  11,
  11,
  11,
  'no',
  '2022-11-24 08:07:27',
  '0000-00-00 00:00:00'
),
(
  12,
  12,
  11,
  'no',
  '2022-11-24 08:07:38',
  '0000-00-00 00:00:00'
),
(
  13,
  13,
  11,
  'no',
  '2022-11-24 08:07:44',
  '0000-00-00 00:00:00'
),
(
  14,
  14,
  11,
  'no',
  '2022-11-24 08:07:52',
  '0000-00-00 00:00:00'
),
(
  15,
  15,
  11,
  'no',
  '2022-11-24 08:08:05',
  '0000-00-00 00:00:00'
);

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

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

CREATE TABLE `CLASS_TEACHER` (
  `ID` INT(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;

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

INSERT INTO `CLASS_TEACHER` (
  `ID`,
  `CLASS_ID`,
  `STAFF_ID`,
  `SECTION_ID`
) VALUES (
  5,
  9,
  3,
  13
);

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

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

CREATE TABLE `COMPLAINT` (
  `ID` INT(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;

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

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

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

--
-- 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(10) 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;

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

INSERT INTO `CONTENTS` (
  `ID`,
  `TITLE`,
  `TYPE`,
  `IS_PUBLIC`,
  `CLASS_ID`,
  `CLS_SEC_ID`,
  `FILE`,
  `CREATED_BY`,
  `NOTE`,
  `IS_ACTIVE`,
  `CREATED_AT`,
  `UPDATED_AT`,
  `DATE`
) VALUES (
  1,
  'English Assignment',
  'Assignments',
  'No',
  9,
  9,
  'uploads/school_content/material/1.docx',
  0,
  'English assignment',
  'no',
  '2022-11-24 09:22:17',
  '',
  '2022-11-24'
);

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

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

CREATE TABLE `CONTENT_FOR` (
  `ID` INT(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;

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

INSERT INTO `CONTENT_FOR` (
  `ID`,
  `ROLE`,
  `CONTENT_ID`,
  `USER_ID`,
  `CREATED_AT`
) VALUES (
  1,
  'student',
  1,
  NULL,
  '2022-11-24 07:22:17'
);

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

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

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

INSERT INTO `CURRENCY` (
  `ID`,
  `CURRENCY`,
  `DESCRIPTION`,
  `ACTIVE`
) VALUES (
  1,
  'USD',
  'UNITED STATES OF AMERICA',
  1
),
(
  2,
  'ZWL',
  'ZIMBABAWE',
  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;

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

INSERT INTO `CURRENCY_TABLE` (
  `ID`,
  `CURRENCYCODE`,
  `DATE`,
  `NAME`,
  `DESCRIPTION`,
  `ACTIVE`
) VALUES (
  6,
  'ZWL',
  '2022-10-26',
  'ZWL-BOND NOTE',
  'Zimbabwean Dollar',
  1
),
(
  7,
  'RTGS',
  '2022-12-16',
  'ZWL',
  'ZWL-RTGS',
  1
);

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

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

CREATE TABLE `CUSTOMER` (
  `ID` INT(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;

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

INSERT INTO `CUSTOMER` (
  `ID`,
  `DATE_CAPTURED`,
  `SUPPLIER_ID`,
  `NAME`,
  `ADDRESS`,
  `MOBILE`,
  `EMAIL`,
  `CURRENCY`,
  `ACTIVE`
) VALUES (
  1,
  '2022-12-29 09:37:15am',
  'S1234E',
  'DANIEL',
  'HARARE',
  '0774233045',
  'daniel@gmail.com',
  'USD',
  1
);

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

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

CREATE TABLE `CUSTOMER_INVOICE` (
  `ID` INT(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;

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

INSERT INTO `CUSTOMER_INVOICE` (
  `ID`,
  `GL_ACCOUNT`,
  `DATE_CREATED`,
  `NAME`,
  `INV_DATE`,
  `INV_NUMBER`,
  `CURRENCY`,
  `DESCRIPTION`,
  `QUANTITY`,
  `PRICE`,
  `DISCOUNT`,
  `TOTAL_AMOUNT`,
  `ACTIVE`
) VALUES (
  17,
  '',
  '2023-01-03 03:27:54pm',
  'DANIEL',
  '2023-01-04',
  'INV0001',
  'USD',
  'bb',
  '45',
  '3',
  '1',
  '133.65',
  1
),
(
  18,
  '',
  '2023-01-04 03:35:51pm',
  'DANIEL',
  '2023-01-09',
  'INV0003',
  'USD',
  'mmm',
  '200',
  '1',
  '2',
  '196',
  1
),
(
  19,
  'Income',
  '2023-01-04 03:37:49pm',
  'DANIEL',
  '2023-01-10',
  'INV0004',
  'USD',
  'oko',
  '300',
  '2',
  '12',
  '528',
  1
),
(
  20,
  'Salarries',
  '2023-01-04 03:40:50pm',
  'DANIEL',
  '2023-01-10',
  'INV0005',
  'USD',
  'jj',
  '400',
  '3',
  '12',
  '1056',
  1
);

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

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

CREATE TABLE `CUSTOMER_RECEIPT` (
  `ID` INT(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;

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

INSERT INTO `CUSTOMER_RECEIPT` (
  `ID`,
  `GL_ACCOUNT`,
  `DATE_CREATED`,
  `NAME`,
  `REC_DATE`,
  `REC_NUMBER`,
  `INV_NUMBER`,
  `CURRENCY`,
  `DESCRIPTION`,
  `QUANTITY`,
  `PRICE`,
  `DISCOUNT`,
  `TOTAL_AMOUNT`,
  `ACTIVE`
) VALUES (
  8,
  '',
  '2023-01-03 03:30:47pm',
  'DANIEL',
  '2023-01-10',
  'REC0001',
  'INV0001',
  'USD',
  'uui',
  '45',
  '2',
  '12',
  '79.2',
  1
);

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

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

CREATE TABLE `CUSTOMER_STATEMENT` (
  `ID` INT(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;

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

INSERT INTO `CUSTOMER_STATEMENT` (
  `ID`,
  `GL_ACCOUNT`,
  `CUSTOMER`,
  `REFERENCE`,
  `DESCRIPTION`,
  `CURRENCY`,
  `DEBIT`,
  `CREDIT`,
  `DATE`
) VALUES (
  9,
  '',
  'DANIEL',
  'INV0001',
  'bb',
  'USD',
  '133.65',
  '0',
  '2023-01-04'
),
(
  10,
  '',
  'DANIEL',
  'REC0002',
  'uui',
  'USD',
  '0',
  '79.2',
  '2023-01-10'
),
(
  11,
  '',
  'DANIEL',
  'INV0002',
  'mmm',
  'USD',
  '196',
  '0',
  '2023-01-09'
),
(
  12,
  'Income',
  'DANIEL',
  'INV0003',
  'oko',
  'USD',
  '528',
  '0',
  '2023-01-10'
),
(
  13,
  'Salarries',
  'DANIEL',
  'INV0004',
  'jj',
  'USD',
  '1056',
  '0',
  '2023-01-10'
);

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

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

CREATE TABLE `DEPARTMENT` (
  `ID` INT(11) NOT NULL,
  `DEPARTMENT_NAME` VARCHAR(200) NOT NULL,
  `IS_ACTIVE` VARCHAR(100) NOT NULL
) ENGINE=INNODB DEFAULT CHARSET=UTF8;

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

INSERT INTO `DEPARTMENT` (
  `ID`,
  `DEPARTMENT_NAME`,
  `IS_ACTIVE`
) VALUES (
  2,
  'Science Department',
  'yes'
),
(
  3,
  'English Department',
  'yes'
),
(
  4,
  'ICT Department',
  'yes'
);

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

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

CREATE TABLE `DEPRECIATIONEXPENSES` (
  `ID` INT(11) NOT NULL,
  `DEPRECIATIONEXPENSES` VARCHAR(300) NOT NULL,
  `DESCRIPTION` VARCHAR(300) NOT NULL,
  `ACTIVE` INT(11) NOT NULL
) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4;

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

INSERT INTO `DEPRECIATIONEXPENSES` (
  `ID`,
  `DEPRECIATIONEXPENSES`,
  `DESCRIPTION`,
  `ACTIVE`
) VALUES (
  1,
  'YYY',
  'YYY',
  1
);

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

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

CREATE TABLE `DEPRECIATIONMETHODS` (
  `ID` INT(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;

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

INSERT INTO `DEPRECIATIONMETHODS` (
  `ID`,
  `DATE_CAPTURED`,
  `DESCRIPTION`,
  `PERCENTAGE`,
  `NO_OF_YEARS`,
  `TOTAL_UNITS`,
  `INITIAL_PERCENTAGE`,
  `DEPRECIATION_BASIS`,
  `ACTIVE`
) VALUES (
  1,
  '27-10-2022 01:15:59pm',
  'pp',
  'ppp',
  0,
  'ppp',
  'ppp',
  'pnm',
  1
);

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

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

CREATE TABLE `DISPATCH_RECEIVE` (
  `ID` INT(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;

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

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

CREATE TABLE `EMAIL_CONFIG` (
  `ID` INT(11) 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;

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

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

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

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

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

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

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

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

INSERT INTO `EXAMS` (
  `ID`,
  `NAME`,
  `SESION_ID`,
  `NOTE`,
  `IS_ACTIVE`,
  `CREATED_AT`,
  `UPDATED_AT`
) VALUES (
  1,
  'jjj',
  0,
  'jj',
  'no',
  '2022-10-26 11:13:10',
  ''
);

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

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

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

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

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

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

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

INSERT INTO `EXPENSES` (
  `ID`,
  `EXP_HEAD_ID`,
  `NAME`,
  `INVOICE_NO`,
  `DATE`,
  `AMOUNT`,
  `DOCUMENTS`,
  `NOTE`,
  `IS_ACTIVE`,
  `IS_DELETED`,
  `CREATED_AT`,
  `UPDATED_AT`
) VALUES (
  1,
  1,
  'Stationary',
  'inv4441',
  '2022-11-24',
  12.00,
  NULL,
  '',
  'yes',
  'no',
  '2022-11-24 06:41:43',
  ''
);

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

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

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

INSERT INTO `EXPENSE_HEAD` (
  `ID`,
  `EXP_CATEGORY`,
  `DESCRIPTION`,
  `IS_ACTIVE`,
  `IS_DELETED`,
  `CREATED_AT`,
  `UPDATED_AT`
) VALUES (
  1,
  'Admin Expenses',
  'Admin Expenses',
  'yes',
  'no',
  '2022-11-24 06:41:05',
  ''
);

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

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

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

INSERT INTO `FD_DEPARTMENT` (
  `ID`,
  `DEPARTMENT`,
  `DESCRIPTION`,
  `ACTIVE`
) VALUES (
  3,
  'IT',
  'IT Department',
  1
),
(
  4,
  'Accounts',
  'Accounts Department',
  1
);

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

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

CREATE TABLE `FEECATEGORY` (
  `ID` INT(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;

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

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

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

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

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

INSERT INTO `FEES_DISCOUNTS` (
  `ID`,
  `SESSION_ID`,
  `NAME`,
  `CODE`,
  `AMOUNT`,
  `DESCRIPTION`,
  `IS_ACTIVE`,
  `CREATED_AT`
) VALUES (
  1,
  18,
  'Admission Fees',
  'adf333',
  '200.00',
  'discount for admission fee',
  'no',
  '2022-09-21 06:48:18'
);

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

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

CREATE TABLE `FEETYPE` (
  `ID` INT(11) NOT NULL,
  `IS_SYSTEM` INT(1) 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;

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

INSERT INTO `FEETYPE` (
  `ID`,
  `IS_SYSTEM`,
  `FEECATEGORY_ID`,
  `TYPE`,
  `CODE`,
  `IS_ACTIVE`,
  `CREATED_AT`,
  `UPDATED_AT`,
  `DESCRIPTION`
) VALUES (
  4,
  0,
  NULL,
  'Admission fee',
  'ADM',
  'no',
  '2022-11-24 04:46:55',
  '',
  'Admission Fee'
),
(
  5,
  0,
  NULL,
  'Uniform Fee',
  'UNIF',
  'no',
  '2022-11-24 04:47:18',
  '',
  'Uniform Fee'
),
(
  6,
  0,
  NULL,
  'Transport Fee',
  'TRS',
  'no',
  '2022-11-24 04:49:10',
  '',
  'Transport Fee'
),
(
  7,
  0,
  NULL,
  'Exam Fee',
  'EXF',
  'no',
  '2022-11-24 04:49:35',
  '',
  'Exam Fee'
);

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

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

CREATE TABLE `FEE_GROUPS` (
  `ID` INT(11) NOT NULL,
  `NAME` VARCHAR(200) DEFAULT NULL,
  `IS_SYSTEM` INT(1) 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;

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

INSERT INTO `FEE_GROUPS` (
  `ID`,
  `NAME`,
  `IS_SYSTEM`,
  `DESCRIPTION`,
  `IS_ACTIVE`,
  `CREATED_AT`
) VALUES (
  2,
  'Grade 1',
  0,
  'Grade 1',
  'no',
  '2022-11-24 04:50:24'
);

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

--
-- 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()
) ENGINE=INNODB DEFAULT CHARSET=UTF8;

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

INSERT INTO `FEE_GROUPS_FEETYPE` (
  `ID`,
  `FEE_SESSION_GROUP_ID`,
  `FEE_GROUPS_ID`,
  `FEETYPE_ID`,
  `SESSION_ID`,
  `DUE_DATE`,
  `AMOUNT`,
  `IS_ACTIVE`,
  `CREATED_AT`
) VALUES (
  4,
  2,
  2,
  4,
  18,
  '1970-01-01',
  '200.00',
  'no',
  '2022-11-24 04:51:00'
),
(
  5,
  2,
  2,
  5,
  18,
  '1970-01-01',
  '40.00',
  'no',
  '2022-11-24 04:51:11'
),
(
  6,
  2,
  2,
  6,
  18,
  '1970-01-01',
  '20.00',
  'no',
  '2022-11-24 04:51:20'
),
(
  7,
  2,
  2,
  7,
  18,
  '1970-01-01',
  '10.00',
  'no',
  '2022-11-24 04:51:29'
);

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

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

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

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

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

INSERT INTO `FEE_SESSION_GROUPS` (
  `ID`,
  `FEE_GROUPS_ID`,
  `SESSION_ID`,
  `IS_ACTIVE`,
  `CREATED_AT`
) VALUES (
  1,
  1,
  18,
  'no',
  '2022-09-21 05:28:15'
),
(
  2,
  2,
  18,
  'no',
  '2022-11-24 04:51:00'
);

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