-- 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: `ms2022`
--

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

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

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