-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Jan 16, 2024 at 07:50 AM
-- Server version: 8.0.31
-- PHP Version: 8.1.13

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

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

--
-- Table structure for table `clouds`
--

DROP TABLE IF EXISTS `clouds`;
CREATE TABLE IF NOT EXISTS `clouds` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `departments`
--

DROP TABLE IF EXISTS `departments`;
CREATE TABLE IF NOT EXISTS `departments` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `head` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `departments_name_unique` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=78 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` (`id`, `name`, `head`, `created_at`, `updated_at`) VALUES
(55, 'PHYSICAL PLANNING', '', NULL, NULL),
(54, 'WORKS', '', NULL, NULL),
(53, 'FINANCE', '', NULL, NULL),
(52, 'SOCIAL WELFARE AND COMMUNITY DEVELOPMENT', '', NULL, NULL),
(50, 'MUNICIPAL DEVELOPMENT PLANNING', '', NULL, NULL),
(51, 'MUNICIPAL ENVIRONMENTAL HEALTH OFFICER', '', NULL, NULL),
(56, 'CENTRAL ADMINISTRATION', '', NULL, NULL),
(57, 'RECORDS MANAGEMENT UNIT', '', NULL, NULL),
(58, 'PROCUREMENT', '', NULL, NULL),
(59, 'HUMAN RESOURCE', '', NULL, NULL),
(60, 'INFORMATION', '', NULL, NULL),
(61, 'URBAN ROADS', '', NULL, NULL),
(62, 'MUNICIPAL EDUCATION SERVICE', '', NULL, NULL),
(63, 'HEALTH SERVICE', '', NULL, NULL),
(64, 'NADMO', '', NULL, NULL),
(65, 'COOPERATIVE', '', NULL, NULL),
(66, 'GHANA ENTERPRISE AGENCY (GEA)', '', NULL, NULL),
(71, 'TRANSPORT', '', NULL, NULL),
(68, 'INTERNAL AUDIT', '', NULL, NULL),
(70, 'GHANA EDUCATION SERVICE', '', NULL, NULL),
(72, 'ESTATE', '', NULL, NULL),
(73, 'MUNICIPAL BUDGET ANALYST', '', NULL, NULL),
(74, 'BIRTH & DEATH', '', NULL, NULL),
(75, 'NCCE', '', NULL, NULL),
(76, 'STOOL LANDS', '', NULL, NULL),
(77, 'GEA/NBSSI', '', NULL, NULL);

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

--
-- Table structure for table `dispatches`
--

DROP TABLE IF EXISTS `dispatches`;
CREATE TABLE IF NOT EXISTS `dispatches` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `reg_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `drp` date NOT NULL,
  `date_dispatch` date NOT NULL,
  `subject` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `folio` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `addressee` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mode` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dispatches`
--

INSERT INTO `dispatches` (`id`, `reg_no`, `drp`, `date_dispatch`, `subject`, `photo`, `ref_no`, `folio`, `addressee`, `mode`, `created_at`, `updated_at`) VALUES
(2, '2', '2023-10-09', '2023-10-16', 'Come home for holiday', '202311251515HOHOE MUNICIPAL.pdf', 'emma edit | hhem.44 edit', '2', 'lgs', 'hand', '2023-10-08 16:55:57', '2023-11-25 15:15:00'),
(4, '10', '2023-11-24', '2023-11-25', 'Final test for hosting', '202311251507data.pdf', 'wages and salary | hhma.05/10/02', '10', 'ohlg', 'copy', '2023-11-25 15:07:32', '2023-11-25 15:07:32'),
(5, '4', '2023-12-18', '2023-12-18', 'New system under development edit', '202312182035PROMOTION.pdf', 'new edit | 02/40/1 edit', '1', 'Emmanuel', 'mail', '2023-12-18 20:27:45', '2023-12-18 20:35:44');

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

--
-- Table structure for table `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `filediaries`
--

DROP TABLE IF EXISTS `filediaries`;
CREATE TABLE IF NOT EXISTS `filediaries` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `previous` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `filediaries`
--

INSERT INTO `filediaries` (`id`, `title`, `previous`, `created_at`, `updated_at`) VALUES
(1, 'hhmg edit | hjk986 edit', 'Newddd 321 edit 123', '2023-09-28 03:00:15', '2023-10-24 20:31:02'),
(5, 'wages and salary edit | hhma.05/10/02/0001', 'new', '2023-12-16 23:09:51', '2023-12-16 23:09:51');

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

--
-- Table structure for table `filelists`
--

DROP TABLE IF EXISTS `filelists`;
CREATE TABLE IF NOT EXISTS `filelists` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `function` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `activity` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `filelists_reference_unique` (`reference`)
) ENGINE=MyISAM AUTO_INCREMENT=155 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `filelists`
--

INSERT INTO `filelists` (`id`, `function`, `activity`, `transaction`, `reference`, `created_at`, `updated_at`) VALUES
(1, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'ACCOMMODATION /OFFICE', 'ADA.01/10/01/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(2, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'ACCOMMODATION /STAFF', 'ADA.01/10/01/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(3, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'ANGLOGOLD ASHANTI', 'ADA.01/10/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(4, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'ANNUAL NEW YEAR SCHOOL', 'ADA.01/10/03', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(5, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'QUARTERLY /ANNUAL ADMINISTRATIVE REPORT', 'ADA.01/10/04', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(6, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'TRADITIONAL COUNCIL/ CHIEFTAINCY', 'ADA.01/10/05', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(7, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'ANNUAL PERFORMANCE REPORT', 'ADA.01/10/06', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(8, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'BOARD OF SURVEY', 'ADA.01/10/07', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(9, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'CIRCULAR (LOCAL GOVT)', 'ADA.01/10/08/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(10, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'CIRCULAR (RCC)', 'ADA.01/10/08/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(11, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'CIRCULAR (ADA)', 'ADA.01/10/08/03', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(12, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'CLIENT SERVICE', 'ADA.01/10/09', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(13, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'COMPLAINS AND PETITION', 'ADA.01/10/10', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(14, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'CONFERENCE / WORKSHOP  FOREIGN', 'ADA.01/10/11/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(15, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'CONFERENCE / WORKSHOP LOCAL', 'ADA.01/10/11/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(16, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'QUERY', 'ADA.01/10/12', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(17, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'DEPT MONTHLY REPORT', 'ADA.01/10/13', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(18, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'ELECTORAL COMMISSION', 'ADA.01/10/14', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(19, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'GHANA AIDS COMMISSION', 'ADA.01/10/15', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(20, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'HANDING OVER NOTE', 'ADA.01/10/16', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(21, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'INFORMATION', 'ADA.01/10/17', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(22, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'INVITATION', 'ADA.01/10/18', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(23, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'INTRODUCTORY LETTER', 'ADA.01/10/19', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(24, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'NATIONAL CELEBRATIONS', 'ADA.01/10/20', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(25, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'LOCAL GOVT SERVICE', 'ADA.01/10/21', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(26, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'MEMOS/INTERNAL CIRCULAR', 'ADA.01/10/22', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(27, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'MANAGEMENT MEETING', 'ADA.01/10/23', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(28, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'MINISTRY OF LOCAL GOVT DECEN. AND RURAL DEVT', 'ADA.01/10/24', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(29, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'NOTICE / ANNOCEMENT', 'ADA.01/10/25', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(30, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'OFFICE OF THE HEAD OF THE LOCAL GOVT SERVICE', 'ADA.01/10/26', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(31, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'PRESS RELEASE/FM', 'ADA.01/10/27', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(32, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'RADIO /WIRELESS MESSAGE', 'ADA.01/10/28', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(33, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'RIGHT TO INFORMATION', 'ADA.01/10/29', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(34, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'TOUR AND VISIT', 'ADA.01/10/30', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(35, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'REGIONAL CO- ORD COUNCIL', 'ADA.01/10/31', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(36, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'SPONSORSHIP', 'ADA.01/10/32', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(37, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'DCD PERFORMANCE CONTRACT', 'ADA.01/10/33', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(38, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'PERMISSION TO TRAVEL', 'ADA.01/10/34', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(39, 'CENTRAL ADMINISTRATION', 'ADMINISTRATION', 'LETTER OF APPRECIATION', 'ADA.01/10/35', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(40, 'CENTRAL ADMINISTRATION', 'PLANNING', 'ANNUAL PROGRESS REPORT', 'ADA.01/20/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(41, 'CENTRAL ADMINISTRATION', 'PLANNING', 'DEPARTMENTAL ACTION PLAN', 'ADA.01/20/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(42, 'CENTRAL ADMINISTRATION', 'PLANNING', 'DEVELOPMENTAL  PROJECT', 'ADA.01/20/03', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(43, 'CENTRAL ADMINISTRATION', 'PLANNING', 'DISTRICT PERFORMANCE ASSESMENT TOOL (DPAT)', 'ADA.01/20/04', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(44, 'CENTRAL ADMINISTRATION', 'PLANNING', 'LOCAL ECONOMICS  DEVT', 'ADA.01/20/05', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(45, 'CENTRAL ADMINISTRATION', 'PLANNING', 'MONITORING AND EVALUATION REPORT/PLAN', 'ADA.01/20/06', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(46, 'CENTRAL ADMINISTRATION', 'PLANNING', 'MEDIUM TERM DEVELOPMENT PLAN', 'ADA.01/20/07', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(47, 'CENTRAL ADMINISTRATION', 'PLANNING', 'DPCU', 'ADA.01/20/08', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(48, 'CENTRAL ADMINISTRATION', 'PROCUREMENT & STORES (30)', 'ASSETS REGISTER', 'ADA.01/30/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(49, 'CENTRAL ADMINISTRATION', 'PROCUREMENT & STORES (30)', 'AWARD OF CONTRACT', 'ADA.01/30/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(50, 'CENTRAL ADMINISTRATION', 'PROCUREMENT & STORES (30)', 'PROCUREMENT PLANNING', 'ADA.01/30/03', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(51, 'CENTRAL ADMINISTRATION', 'PROCUREMENT & STORES (30)', 'REQUEST FOR QUOTATION- GOODS', 'ADA.01/30/04/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(52, 'CENTRAL ADMINISTRATION', 'PROCUREMENT & STORES (30)', 'REQUEST FOR QUOTATION WORKS', 'ADA.01/30/04/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(53, 'CENTRAL ADMINISTRATION', 'PROCUREMENT & STORES (30)', 'TENDER', 'ADA.01/30/05/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(54, 'CENTRAL ADMINISTRATION', 'PROCUREMENT & STORES (30)', 'TENDER COMMITTEE', 'ADA.01/30/05/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(55, 'CENTRAL ADMINISTRATION', 'PROCUREMENT & STORES (30)', 'UNSUCCESFUL TENDERY', 'ADA.01/30/06', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(56, 'CENTRAL ADMINISTRATION', 'RECORDS MGT', 'R M U', 'ADA.01/40/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(57, 'CENTRAL ADMINISTRATION', 'MIS', 'COMMUNICATION NETWORK', 'ADA.01/50/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(58, 'CENTRAL ADMINISTRATION', 'MIS', 'NIA', 'ADA.01/50/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(59, 'CENTRAL ADMINISTRATION', 'ESTATE / TRANSPORT MGT. (60)', 'ALLOCATION OF STORES', 'ADA.01/60/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(60, 'CENTRAL ADMINISTRATION', 'ESTATE / TRANSPORT MGT. (60)', 'TENANCY AGREEMENT', 'ADA.01/60/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(61, 'CENTRAL ADMINISTRATION', 'LOGISTICES & SECURITY MGT   (70)', 'GHANA POLICE', 'ADA.01/70/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(62, 'CENTRAL ADMINISTRATION', 'LOGISTICES & SECURITY MGT   (70)', 'GHANA NATIONAL FIRE SERVICE', 'ADA.01/70/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(63, 'CENTRAL ADMINISTRATION', 'LOGISTICES & SECURITY MGT   (70)', 'DISEC', 'ADA.01/70/03', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(64, 'CENTRAL ADMINISTRATION', 'LOGISTICES & SECURITY MGT   (70)', 'N.I.B/FRAUD OFFICE', 'ADA.01/70/04', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(65, 'CENTRAL ADMINISTRATION', 'LOGISTICES & SECURITY MGT   (70)', 'PRISONS', 'ADA.01/70/05', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(66, 'CENTRAL ADMINISTRATION', 'ASSEMBLY AFFAIRS', 'ASSEMBLY MATTERS', 'ADA.01/80/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(67, 'CENTRAL ADMINISTRATION', 'ASSEMBLY AFFAIRS', 'SUMMONS TO GENERAL ASSEMBLY MEETING', 'ADA.01/80/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(68, 'CENTRAL ADMINISTRATION', 'ASSEMBLY AFFAIRS', 'EXECUTIVE COMMITTEE', 'ADA.01/80/03/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(69, 'CENTRAL ADMINISTRATION', 'ASSEMBLY AFFAIRS', 'PUBLIC RELATION & COMPLAINS', 'ADA.01/80/03/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(70, 'CENTRAL ADMINISTRATION', 'ASSEMBLY AFFAIRS', 'JUST & SEC SUB-COMMITTEE', 'ADA.01/80/03/03', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(71, 'CENTRAL ADMINISTRATION', 'ASSEMBLY AFFAIRS', 'DEVT PLANNING SUB- COMMITTEE', 'ADA.01/80/03/04', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(72, 'CENTRAL ADMINISTRATION', 'ASSEMBLY AFFAIRS', 'MINING AND ANTI GALAMSEY.  SUB COMMITTEE', 'ADA.01/80/03/05', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(73, 'CENTRAL ADMINISTRATION', 'ASSEMBLY AFFAIRS', 'FINANCE & ADMI SUB-COMMTY', 'ADA.01/80/03/06', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(74, 'CENTRAL ADMINISTRATION', 'ASSEMBLY AFFAIRS', 'WORKS SUB-COMMITTEE', 'ADA.01/80/03/07', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(75, 'CENTRAL ADMINISTRATION', 'ASSEMBLY AFFAIRS', 'SOCIAL SERVICE SUB-COMMTY', 'ADA.01/80/03/08', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(76, 'CENTRAL ADMINISTRATION', 'ASSEMBLY AFFAIRS', '2023-12-22 02:09:02', 'ADA.01/80/03/09', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(77, 'CENTRAL ADMINISTRATION', 'ASSEMBLY AFFAIRS', 'NALAG', 'ADA.01/80/04', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(78, 'HUMAN RESOURCE MGT', 'PERSONEL MGT', 'APPLICATION FOR EMPLOYMENT', 'ADA.02/10/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(79, 'HUMAN RESOURCE MGT', 'PERSONEL MGT', 'STAFF PERFORMANCE APPRAISAL', 'ADA.02/10/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(80, 'HUMAN RESOURCE MGT', 'PERSONEL MGT', 'APPLICATION TO STUDY', 'ADA.02/10/03', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(81, 'HUMAN RESOURCE MGT', 'PERSONEL MGT', 'HUMAN RESOUCE DEVT', 'ADA.02/10/04', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(82, 'HUMAN RESOURCE MGT', 'PERSONEL MGT', 'INDUSTRIAL ATTACHMENT', 'ADA.02/10/05', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(83, 'HUMAN RESOURCE MGT', 'PERSONEL MGT', 'NATIONAL SERVICE', 'ADA.02/10/06', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(84, 'HUMAN RESOURCE MGT', 'PERSONEL MGT', 'APPLICATION FOR LEAVE', 'ADA.02/10/07', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(85, 'HUMAN RESOURCE MGT', 'PERSONEL MGT', 'STAFF POSTING / TRANSFER', 'ADA.02/10/08', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(86, 'HUMAN RESOURCE MGT', 'PERSONEL MGT', 'STAFF PROMOTION /INTERVIEW UPGRADING', 'ADA.02/10/09', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(87, 'HUMAN RESOURCE MGT', 'PERSONEL MGT', 'STAFF DURBAR/MEETING', 'ADA.02/10/10', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(88, 'HUMAN RESOURCE MGT', 'PERSONEL MGT', 'HRMIS', 'ADA.02/10/11', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(89, 'HUMAN RESOURCE MGT', 'PERSONNEL WELFARE', 'WORKES UNIONS', 'ADA.02/20/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(90, 'HUMAN RESOURCE MGT', 'PERSONNEL WELFARE', 'OBITUARY', 'ADA.02/20/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(91, 'HUMAN RESOURCE MGT', 'PERSONNEL WELFARE', 'PENSION/ RETAIRMENT/ SSNIT.', 'ADA.02/20/03', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(92, 'HUMAN RESOURCE MGT', 'PERSONNEL WELFARE', 'STAFF LIST', 'ADA.02/20/04', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(93, 'HUMAN RESOURCE MGT', 'PERSONNEL WELFARE', 'STAFF MATTERS', 'ADA.02/20/05', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(94, 'HUMAN RESOURCE MGT', 'PERSONNEL WELFARE', 'SALARY AND WAGES , ALLOWANCES', 'ADA.02/20/06', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(95, 'HUMAN RESOURCE MGT', 'PERSONNEL WELFARE', 'SSNIT', 'ADA.02/20/07', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(96, 'HUMAN RESOURCE MGT', 'PERSONNEL WELFARE', 'QUERY', 'ADA.02/20/08', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(97, 'HUMAN RESOURCE MGT', 'TRAINING AND DEVT', 'EXAMINATION & COURSES', 'ADA.02/30/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(98, 'HUMAN RESOURCE MGT', 'TRAINING AND DEVT', 'STAFF TRAINING / SCHEME OF SERVICE LOCAL', 'ADA.02/30/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(99, 'FINANCIAL MANAGEMENT', 'TREASURE', 'ANNUAL ACCOUNT', 'ADA.03/10/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(100, 'FINANCIAL MANAGEMENT', 'TREASURE', 'BANK OF GHANA', 'ADA.03/10/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(101, 'FINANCIAL MANAGEMENT', 'TREASURE', 'CONTROLLER AND ACCOUNTANT GEN.', 'ADA.03/10/03', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(102, 'FINANCIAL MANAGEMENT', 'TREASURE', 'DISTRICT ASSEMBLY COMMON FUND (DACF)/IGF', 'ADA.03/10/04', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(103, 'FINANCIAL MANAGEMENT', 'TREASURE', 'FINANCIAL RETURN', 'ADA.03/10/05', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(104, 'FINANCIAL MANAGEMENT', 'TREASURE', 'MONTHLY TRIAL BALANCE', 'ADA.03/10/06', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(105, 'FINANCIAL MANAGEMENT', 'TREASURE', 'MINISTRY OF FINANCE', 'ADA.03/10/07', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(106, 'FINANCIAL MANAGEMENT', 'REVENUE MOBILIZATION   (20)', 'STOOL LAND REVENUE', 'ADA.03/20/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(107, 'FINANCIAL MANAGEMENT', 'REVENUE MOBILIZATION', 'REVENUE MOBILIZATION (COLLECTION POINTS)\r\n/CEMETERY COLLECTORS', 'ADA.03/20/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(108, 'FINANCIAL MANAGEMENT', 'REVENUE MOBILIZATION', 'BONDING', 'ADA.03/20/03', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(109, 'FINANCIAL MANAGEMENT', 'REVENUE MOBILIZATION', 'BUSINESS OPERATING FEE', 'ADA.03/20/04', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(110, 'FINANCIAL MANAGEMENT', 'REVENUE MOBILIZATION', 'GRA', 'ADA.03/20/05', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(111, 'FINANCIAL MANAGEMENT', 'LEVIES', 'FEE FIXING RESOLUTION', 'ADA.03/30/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(112, 'BUDGET AND RATING', 'BUDGET  MGT', 'BUDGETESTIMATES', 'ADA.04/10/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(113, 'BUDGET AND RATING', 'BUDGET  MGT', 'ANNUAL BUDGET PLAN', 'ADA.04/10/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(114, 'BUDGET AND RATING', 'BUDGET  MGT', 'BUDGET COMMITTEE', 'ADA.04/10/03', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(115, 'BUDGET AND RATING', 'BUDGET  MGT', 'COMPOSITE BUDGET', 'ADA.04/10/04', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(116, 'BUDGET AND RATING', 'BUDGET  MGT', 'PUBLIC FORA', 'ADA.04/10/05', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(117, 'BUDGET AND RATING', 'BUDGET  MGT', 'REVENUE/BUDGET SENSITIZATION', 'ADA.04/10/06', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(118, 'AUDIT MGT', 'INTERNAL AUDIT', 'AUDIT COMMITTEE REPORT', 'ADA.05/10/01/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(119, 'AUDIT MGT', 'INTERNAL AUDIT', 'AUDIT PLAN / CHARTERS', 'ADA.05/10/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(120, 'AUDIT MGT', 'INTERNAL AUDIT', 'INTERNAL AUDIT AGENCY  REPORT /IAA', 'ADA.05/10/03', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(121, 'AUDIT MGT', 'EXTERNAL AUDIT', 'EXTERNAL AUDIT REPORT', 'ADA.05/20/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(122, 'AUDIT MGT', 'EXTERNAL AUDIT', 'SPECIAL AUDIT', 'ADA.05/20/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(123, 'LEGAL ADVICE', 'LEGAL', 'ASSEMBLY BYE-LAWS', 'ADA.06/10/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(124, 'LEGAL ADVICE', 'LEGAL', 'CHRAJ', 'ADA.06/10/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(125, 'LEGAL ADVICE', 'LEGAL', 'JUDICIAL SERVICE', 'ADA.06/10/03', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(126, 'LEGAL ADVICE', 'PROLITIGATION MGT', 'PROCUTIONS /CLAIMS AGAINST THE  ASSEMBLY', 'ADA.06/20/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(127, 'WORKS', 'BUILDING', 'DIMOLISHING OF UNAUTHORIZED STRUCTURES', 'ADA.07/10/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(128, 'WORKS', 'BUILDING', 'ELECTRICITY', 'ADA.07/10/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(129, 'WORKS', 'BUILDING', 'FINAL', 'ADA.07/10/03', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(130, 'WORKS', 'BUILDING', 'COMMISSING OF PROJECT', 'ADA.07/10/04', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(131, 'WORKS', 'BUILDING', 'OPERATION AND MAINTENANCE', 'ADA.07/10/05', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(132, 'WORKS', 'BUILDING', 'PWD', 'ADA.07/10/06', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(133, 'WORKS', 'BUILDING', 'PLANNING AND BUILDING INSPECTORATE', 'ADA.07/10/07', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(134, 'WORKS', 'BUILDING', 'RURAL ELECTRIFICATION', 'ADA.07/10/08', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(135, 'WORKS', 'BUILDING', 'COMMUNITY REQUEST', 'ADA.07/10/09', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(136, 'WORKS', 'BUILDING', 'SITE MEETING', 'ADA.07/10/10', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(137, 'WORKS', 'BUILDING', 'TEMPORAL STRUCTURE', 'ADA.07/10/11', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(138, 'WORKS', 'WATER', 'GHANA WATER', 'ADA.07/20/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(139, 'WORKS', 'WATER', 'WATER RESOURCE COMMISSION', 'ADA.07/20/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(140, 'PHYSICAL PLANNING', 'T&CP', 'APPLICATION FOR LANDS', 'ADA.08/10/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(141, 'PHYSICAL PLANNING', 'T&CP', 'BUILDING PERMIT', 'ADA.08/10/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(142, 'PHYSICAL PLANNING', 'T&CP', 'CHANGE OF USE', 'ADA.08/10/03', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(143, 'PHYSICAL PLANNING', 'T&CP', 'LAND VALUATION', 'ADA.08/10/04', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(144, 'PHYSICAL PLANNING', 'T&CP', 'LANDS COMMISSION', 'ADA.08/10/05', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(145, 'PHYSICAL PLANNING', 'T&CP', 'PHYSICAL PLANNING', 'ADA.08/10/06', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(146, 'PHYSICAL PLANNING', 'T&CP', 'REGISTRAR OF ASSEMBLY LANDS', 'ADA.08/10/07', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(147, 'PHYSICAL PLANNING', 'T&CP', 'SPATIAL PLANNING COMMITTEE', 'ADA.08/10/08', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(148, 'PHYSICAL PLANNING', 'T&CP', 'STREET/HOUSING NAMING', 'ADA.08/10/09', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(149, 'PHYSICAL PLANNING', 'T&CP', 'TECHNICAL SUB-COMMITTEE', 'ADA.08/10/10', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(150, 'PHYSICAL PLANNING', 'T&CP', 'TECHNICAL SITE INSPECTION', 'ADA.08/10/11', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(151, 'PHYSICAL PLANNING', 'T&CP', 'CHANGE OF ONWERSHIP', 'ADA.08/10/12', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(152, 'HOUSING', 'HOUSING', '2023-12-22 02:09:02', '2023-12-22 02:09:02', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(153, 'ROADS', 'ROAD MAINTENANACE  (10)', 'MAINTENANCE OF ROADS', 'ADA.10/10/01', '2023-12-22 02:09:02', '2023-12-22 02:09:02'),
(154, 'ROADS', 'ROAD TRAFIC INFRASTRUCTURE (20)', 'RAILWAY AUTHORITY', 'ADA.10/30/02', '2023-12-22 02:09:02', '2023-12-22 02:09:02');

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

--
-- Table structure for table `mails`
--

DROP TABLE IF EXISTS `mails`;
CREATE TABLE IF NOT EXISTS `mails` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `reg_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dol` date NOT NULL,
  `date_received` date NOT NULL,
  `received` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `inst_ref` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo` text COLLATE utf8mb4_unicode_ci,
  `depart` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_ref` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `folio` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `assign_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mails`
--

INSERT INTO `mails` (`id`, `reg_no`, `dol`, `date_received`, `received`, `inst_ref`, `subject`, `photo`, `depart`, `file_ref`, `folio`, `assign_date`, `created_at`, `updated_at`) VALUES
(6, '200', '2023-11-25', '2023-11-26', 'emma edit', 'ATU/321/edit', 'Final test for hosting edit', NULL, NULL, 'hhma.04/20/01', '10', '2023-11-25', '2023-11-25 13:25:45', '2023-11-25 13:51:05'),
(5, '12311', '2023-10-30', '2023-10-31', 'Felix 123', 'ATU 123', 'New computer lab 123', 'me.pdf', '[\"Finance\"]', 'hjk986 edit', '10', '2023-11-25', '2023-10-25 17:54:52', '2023-11-25 14:08:24'),
(7, '200', '2023-12-11', '2023-12-12', 'maxhh', 'max002', 'New system under development with laravel edit', '202312162317feagle_ventures_website_proposal.pdf', '[\"meho\"]', 'hhma.05/10/02/0001', '1', '2023-12-16', '2023-12-16 23:15:16', '2023-12-16 23:17:24');

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

--
-- Table structure for table `messangers`
--

DROP TABLE IF EXISTS `messangers`;
CREATE TABLE IF NOT EXISTS `messangers` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `date_dispatch` date NOT NULL,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `messenger_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `institution` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `migrations`;
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2023_09_24_002201_create_departments_table', 2),
(6, '2023_09_24_023710_create_filelists_table', 3),
(7, '2023_09_24_191951_create_filediaries_table', 4),
(8, '2023_10_02_141217_create_mails_table', 5),
(9, '2023_10_08_142047_create_dispatches_table', 6),
(10, '2023_10_08_171534_create_transits_table', 7),
(11, '2023_11_19_225543_create_movements_table', 8),
(12, '2023_12_18_210826_create_messangers_table', 9),
(13, '2023_12_19_193143_create_settings_table', 10),
(14, '2023_12_22_040716_create_clouds_table', 11);

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

--
-- Table structure for table `movements`
--

DROP TABLE IF EXISTS `movements`;
CREATE TABLE IF NOT EXISTS `movements` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `depart` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remarks` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `move_date` date NOT NULL,
  `return_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `movements`
--

INSERT INTO `movements` (`id`, `name`, `depart`, `ref_no`, `remarks`, `move_date`, `return_date`, `created_at`, `updated_at`) VALUES
(1, 'kofi', 'mis', 'gdgdgdfgd', '', '2023-11-01', '2023-11-19', '2023-11-19 23:15:46', '2023-11-19 00:00:00'),
(2, 'Transfer Student', 'Finance', 'hhma.04/20/01', 'FYNA', '2023-11-25', NULL, '2023-11-25 21:04:15', '2023-11-25 21:04:15'),
(3, 'john', 'meho', 'hjk986 edit', 'ddsss', '2023-12-19', NULL, '2023-12-19 02:22:17', '2023-12-19 02:22:17');

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

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
CREATE TABLE IF NOT EXISTS `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `personal_access_tokens`
--

DROP TABLE IF EXISTS `personal_access_tokens`;
CREATE TABLE IF NOT EXISTS `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
CREATE TABLE IF NOT EXISTS `settings` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `prefix` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `footer` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `name`, `prefix`, `email`, `footer`, `logo`, `created_at`, `updated_at`) VALUES
(1, 'hohoe mun assembly edi', 'hhma', 'infoedit@gmail.com', 'copy right 2023 edit', '', '2023-12-19 20:31:15', '2023-12-21 12:48:26');

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

--
-- Table structure for table `transits`
--

DROP TABLE IF EXISTS `transits`;
CREATE TABLE IF NOT EXISTS `transits` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `sent_to` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remarks` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transits`
--

INSERT INTO `transits` (`id`, `sent_to`, `ref_no`, `remarks`, `created_at`, `updated_at`) VALUES
(1, 'Environmental Health edit', 'hhma.05/10/02', 'FYNA edit', '2023-11-07 21:27:26', '2023-11-07 23:53:02'),
(3, 'Central Administration', 'hhma.05/10/02/0001', 'fya edit', '2023-12-19 02:17:32', '2023-12-19 02:20:34');

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

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

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `depart` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `depart`, `email`, `phone`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'emmanuel ntiamoah', 'Central Administration', 'emma@gmail.com', '9877', NULL, '$2y$10$U4wuYdaedhVlNEz4Y43RGec4hMuzd6wN3GVmIpwA.jLzCY/8KkCeC', NULL, '2023-09-23 22:12:46', '2023-12-22 02:47:02'),
(2, 'Hannah Yaa', '', 'hanny@gmail.com', '', NULL, '$2y$10$0WbBsGeFxr5VMq667KqmrO4pihCULGhEejMW2sMRSmFtiWXzPXei.', NULL, '2023-09-23 23:08:45', '2023-09-23 23:08:45'),
(3, 'Day Student new', 'meho', 'maxy001@gmail.com', '089998', NULL, '$2y$10$6cgZTMXAKkwoOTyzAQocc.uOxgj4jYA51Qh3MS3iKhxQhTX0cjL5K', NULL, '2023-12-19 16:18:46', '2023-12-19 16:58:41');
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 */;