gp.sql

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Nov 18, 2024 at 01:06 PM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.0.28

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

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `fname` varchar(50) DEFAULT NULL,
  `lname` varchar(50) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `nic` varchar(20) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `fname`, `lname`, `email`, `nic`, `password`) VALUES
(1100, 'Imalsha', 'Jathunarachchi', 'imalsha.contact@gmail.com', '200138241314', 'Digifine00');

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

--
-- Table structure for table `dmt_drivers`
--

CREATE TABLE `dmt_drivers` (
  `id` int(11) NOT NULL,
  `fname` varchar(50) NOT NULL,
  `lname` varchar(50) NOT NULL,
  `license_id` varchar(10) NOT NULL,
  `nic` varchar(20) NOT NULL,
  `address` varchar(300) NOT NULL,
  `license_issue_date` date NOT NULL,
  `license_expiry_date` date NOT NULL,
  `restrictions` date NOT NULL,
  `blood_group` enum('A+','A-','B+','B-','O+','O-','AB+','AB-') NOT NULL,
  `A1_issue_date` date NOT NULL,
  `A1_expiry_date` date NOT NULL,
  `A_issue_date` date NOT NULL,
  `A_expiry_date` date NOT NULL,
  `B1_issue_date` date NOT NULL,
  `B1_expiry_date` date NOT NULL,
  `B_issue_date` date NOT NULL,
  `B_expiry_date` date NOT NULL,
  `C1_issue_date` date NOT NULL,
  `C1_expiry_date` date NOT NULL,
  `C_issue_date` date NOT NULL,
  `C_expiry_date` date NOT NULL,
  `CE_issue_date` date NOT NULL,
  `CE_expiry_date` date NOT NULL,
  `D1_issue_date` date NOT NULL,
  `D1_expiry_date` date NOT NULL,
  `D_issue_date` date NOT NULL,
  `D_expiry_date` date NOT NULL,
  `DE_issue_date` date NOT NULL,
  `DE_expiry_date` date NOT NULL,
  `G1_issue_date` date NOT NULL,
  `G1_expiry_date` date NOT NULL,
  `G_issue_date` date NOT NULL,
  `G_expiry_date` date NOT NULL,
  `J_issue_date` date NOT NULL,
  `J_expiry_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `drivers`
--

CREATE TABLE `drivers` (
  `id` varchar(20) NOT NULL,
  `fname` varchar(50) NOT NULL,
  `lname` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone_no` varchar(15) NOT NULL,
  `nic` varchar(20) NOT NULL,
  `password` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `drivers`
--

INSERT INTO `drivers` (`id`, `fname`, `lname`, `email`, `phone_no`, `nic`, `password`, `created_at`) VALUES
('b1111111', 'Imalsha', 'Jathunarachchi', 'imalshajathunarachchi@gmail.com', '0762381520', '200134465734', '$2y$10$Gp2q3qnEoA7AH8GhoxW.G.BVjIt.VnSp6.3dX92Xj4pP58pN5kSx.', '2024-09-19 20:47:59'),
('b1234567', 'John', 'Doe', 'mrclocktd@gmail.com', '0766743755', '200224903146', '$2y$10$DooxggI8H82zkdYel3kRjOt7uylaneKtQ/qPwmqVemccJrjprJVlq', '2024-09-19 14:59:12'),
('b2222222', 'Kasun', 'Kalhara', 'kasun@gmail.com', '0768509437', '20023242435', '$2y$10$u.JzajQAUmn/bF4HHYZyHeMliB/5f1Yk8Cj8IO0hLlouWa.NnCXXy', '2024-09-20 06:15:24');

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

--
-- Table structure for table `offences`
--

CREATE TABLE `offences` (
  `offence_id` int(11) NOT NULL,
  `offence_number` varchar(10) DEFAULT NULL,
  `description_sinhala` varchar(255) NOT NULL,
  `description_tamil` varchar(255) NOT NULL,
  `description_english` varchar(255) NOT NULL,
  `points_deducted` int(11) DEFAULT NULL,
  `fine` decimal(10,2) NOT NULL DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `offences`
--

INSERT INTO `offences` (`offence_id`, `offence_number`, `description_sinhala`, `description_tamil`, `description_english`, `points_deducted`, `fine`) VALUES
(1, '001', 'හඳුනාගැනීමේ තහඩු', 'அடையாளங்காணல் தகடுகள்', 'Identification Plates', 1, 1000.00);

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

--
-- Table structure for table `officers`
--

CREATE TABLE `officers` (
  `id` int(11) NOT NULL,
  `fname` varchar(50) NOT NULL,
  `lname` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone_no` varchar(15) NOT NULL,
  `nic` varchar(20) NOT NULL,
  `police_station` int(11) NOT NULL,
  `password` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `is_oic` tinyint(4) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `officers`
--

INSERT INTO `officers` (`id`, `fname`, `lname`, `email`, `phone_no`, `nic`, `police_station`, `password`, `created_at`, `is_oic`) VALUES
(15364, 'Sakuna', 'Manamperi', 'sakunasanka@gmail.com', '0762381520', '200238273819', 1, '$2y$10$4CW08N6ppv2o190oQC5MfOnKZ6s6W9P3O.KeOH6xpCihr5fyBIpF2', '2024-11-17 16:35:01', 1),
(15365, 'Pawan', 'Weearasuriya', 'pawan@gmail.com', '0782381520', '200223356485', 1, '$2y$10$vegPhLKyMQdySvO6A5udrOC9KXHV.cMY.TL8ih1QtFT72JqGcOJl6', '2024-11-17 16:36:28', 0),
(15366, 'Roneth', 'Nimlaka', 'rowneth@gmail.com', '0784564436', '200234254634', 529, '$2y$10$1Nqfly5VSZLFya.L1g62fu4gDsI6LgxKfSZ7FfJczIDY/n/NOA9eS', '2024-11-17 16:45:20', 1),
(15367, 'Risafa', 'Imtiyas', 'risafaimtiyas@gmail.com', '0783425345', '200145365456', 350, '$2y$10$UtkpQ4OA7OJO8ASr/NItjeXYw5BE04qoJI2FIP5IF1kpVUFcCs/SK', '2024-11-17 18:43:44', 0),
(23233, 'Imalsha', 'Akalanka', 'imaz@gmail.com', '0766743755', '2001362824646', 515, '$2y$10$t8p0egMwMC1UJPS3hr/.I.3epX3PxeAh4QWGCAXjmt4HZNy.Qiuf.', '2024-11-10 17:03:05', 1);

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

--
-- Table structure for table `police_stations`
--

CREATE TABLE `police_stations` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `telephone` varchar(15) NOT NULL,
  `province` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `police_stations`
--

INSERT INTO `police_stations` (`id`, `name`, `telephone`, `province`) VALUES
(1, 'Gampaha', '0332222224', 1),
(2, 'Minuwangoda', '0112295222', 1),
(3, 'Ganemulla', '0332260222', 1),
(4, 'Weliweriya', '0332255222', 1),
(5, 'Weeragula', '0332279442', 1),
(6, 'Yakkala', '0332225924', 1),
(7, 'Malwathuhiripitiya', '0332278800', 1),
(8, 'Pugoda', '0112405224', 1),
(9, 'Dompe', '0112409222', 1),
(10, 'Kirindiwela', '0332267222', 1),
(11, 'Nittambuwa', '0332287224', 1),
(12, 'Mirigama', '0332273222', 1),
(13, 'Veyangoda', '0332287222', 1),
(14, 'Pallewela', '0332271413', 1),
(15, 'Bemmulla', '0332252600', 1),
(16, 'Aththanagalla', '0332280626', 1),
(17, 'Nalla', '0372288669', 1),
(18, 'Danowita', '0352239054', 1),
(19, 'Nungamuwa', '0718592950', 1),
(20, 'Kadawatha', '0112925222', 1),
(21, 'Peliyagoda', '0112911222', 1),
(22, 'Kiribathgoda', '0112914985', 1),
(23, 'JaEla', '0112236222', 1),
(24, 'Wattala', '0112930222', 1),
(25, 'Kandana', '0112236333', 1),
(26, 'Biyagama', '0112487574', 1),
(27, 'Kelaniya', '0112911922', 1),
(28, 'Sapugaskanda', '0112400315', 1),
(29, 'Ragama', '0112958222', 1),
(30, 'Mahabage', '0112948469', 1),
(31, 'Meegahawatta', '0112977233', 1),
(32, 'Ederamulla', '0112940966', 1),
(33, 'Negombo', '0312222222', 1),
(34, 'Katunayaka Airport', '0312252948', 1),
(35, 'Katana', '0312246377', 1),
(36, 'Kotadeniyawa', '0312255616', 1),
(37, 'Divulapitiya', '0312293322', 1),
(38, 'Katunayaka', '0312237223', 1),
(39, 'Raddolugama', '0312247108', 1),
(40, 'Kochchikade', '0312275222', 1),
(41, 'Seeduwa', '0112256222', 1),
(42, 'Pamunugama', '0312251807', 1),
(43, 'Dungalpitiya', '0312277722', 1),
(44, 'Badalgama', '0312241492', 1),
(45, 'Panadura South', '0382236222', 1),
(46, 'Panadura North', '0382234222', 1),
(47, 'Wadduwa', '0382296222', 1),
(48, 'Millaniya', '0342258663', 1),
(49, 'Bandaragama', '0342269222', 1),
(50, 'Anguruwatota', '0342260492', 1),
(51, 'Morontuduwa', '0342265525', 1),
(52, 'Horana', '0342262222', 1),
(53, 'Ingiriya', '0342283222', 1),
(54, 'Moragahahena', '0342283772', 1),
(55, 'Pinwatta', '0382296224', 1),
(56, 'Hirana', '0382232224', 1),
(57, 'Alubomulla', '0342295624', 1),
(58, 'Mount Lavinia', '0112738222', 1),
(59, 'Angulana', '0112738333', 1),
(60, 'Dehiwala', '0112733224', 1),
(61, 'Kohuwala', '0112825222', 1),
(62, 'Moratuwa', '0112643222', 1),
(63, 'Egoda Uyana', '0112646222', 1),
(64, 'Moratumulla', '0112645122', 1),
(65, 'Piliyandala', '0112706222', 1),
(66, 'Kahathuduwa', '0112725222', 1),
(67, 'Mattegoda', '0112741222', 1),
(68, 'Kesbewa', '0112710222', 1),
(69, 'Mirihana', '0112859222', 1),
(70, 'Boralesgamuwa', '0112501322', 1),
(71, 'Gothatuwa', '0112570222', 1),
(72, 'Welikada', '0112873222', 1),
(73, 'Thalangama', '0112786222', 1),
(74, 'Meepe', '0342269114', 1),
(75, 'Athurugiriya', '0112768222', 1),
(76, 'Padukka', '0362242233', 1),
(77, 'Hanwella', '0362256222', 1),
(78, 'Kottawa', '0112843222', 1),
(79, 'Maharagama', '0112857222', 1),
(80, 'Homagama', '0112857222', 1),
(81, 'Mulleriyava', '0112790922', 1),
(82, 'Wellampitiya', '0112533222', 1),
(83, 'Nawagamuwa', '0112746222', 1),
(84, 'Kaduwela', '0112576111', 1),
(85, 'Malabe', '0112787777', 1),
(86, 'Kalutara South', '0342222224', 1),
(87, 'Kalutara North', '0342231224', 1),
(88, 'Beruwala', '0342276222', 1),
(89, 'Aluthgama', '0342272022', 1),
(90, 'Payagala', '0342254066', 1),
(91, 'Dodangoda', '0342254266', 1),
(92, 'Thebuwana', '0342261426', 1),
(93, 'Mathugama', '0342248264', 1),
(94, 'Agalawatta', '0342242624', 1),
(95, 'Warakagoda', '0342243246', 1),
(96, 'Welipanna', '0342243222', 1),
(97, 'Baduraliya', '0342277222', 1),
(98, 'Bulathsinhala', '0342282222', 1),
(99, 'Meegahathenna', '0342288222', 1),
(100, 'Thiniyawala', '0342242222', 1),
(101, 'Iththapana', '0342252346', 1),
(102, 'Pettah', '0112322893', 1),
(103, 'Keselwatta', '0112434303', 1),
(104, 'Fort', '0112327991', 1),
(105, 'Slave Island', '0112434317', 1),
(106, 'Maradana', '0112691545', 1),
(107, 'Maligawatta', '0112434307', 1),
(108, 'Wolfendhal', '0112331746', 1),
(109, 'Dam Street', '0112446443', 1),
(110, 'Colombo Harbour', '0112327558', 1),
(111, 'Fore Shore', '0112332084', 1),
(112, 'Kotahena', '0112446004', 1),
(113, 'Modara', '0112541846', 1),
(114, 'Grandpass', '0112522278', 1),
(115, 'Dematagoda', '0112678764', 1),
(116, 'Mattakkuliya', '0112526445', 1),
(117, 'Bluemandal', '0112593514', 1),
(118, 'Mihijayasewana', '0112536014', 1),
(119, 'Bambalapitiya', '0112580678', 1),
(120, 'Kollupitiya', '0112572210', 1),
(121, 'Kirulapana', '0112519544', 1),
(122, 'Narahenpita', '0112508203', 1),
(123, 'Wellawatta', '0112589347', 1),
(124, 'Borella', '0112691224', 1),
(125, 'Cinnamon Garden', '0112695881', 1),
(126, 'BMICH', '0112681567', 1),
(127, 'Police Headquarters', '0112433333', 1),
(128, 'Batticaloa', '0111234567', 9),
(129, 'Vavunathive', '0111234567', 9),
(130, 'Kaththankudi', '0111234567', 9),
(131, 'Eravur', '0111234567', 9),
(132, 'Karadiyanaru', '0111234567', 9),
(133, 'Aiththamalai', '0111234567', 9),
(134, 'Valachchanai', '0111234567', 9),
(135, 'Kalkudah', '0111234567', 9),
(136, 'Kalawanchikudy', '0111234567', 9),
(137, 'Vellavali', '0111234567', 9),
(138, 'Kokkadicholai', '0111234567', 9),
(139, 'Kokuwill', '0111234567', 9),
(140, 'Ampara', '0111234567', 9),
(141, 'Damana', '0111234567', 9),
(142, 'Inginiyagala', '0111234567', 9),
(143, 'Uhana', '0111234567', 9),
(144, 'Bakkiella', '0111234567', 9),
(145, 'Central Camp', '0111234567', 9),
(146, 'Mangalagama', '0111234567', 9),
(147, 'Mahaoya', '0111234567', 9),
(148, 'Dehiaththakandiya', '0111234567', 9),
(149, 'Padiyathalawa', '0111234567', 9),
(150, 'Kalmunai', '0111234567', 9),
(151, 'Samanthurai', '0111234567', 9),
(152, 'Chawalakade', '0111234567', 9),
(153, 'Akkaraipattu', '0111234567', 9),
(154, 'Thirukkovil', '0111234567', 9),
(155, 'Pothuvil', '0111234567', 9),
(156, 'Panama', '0111234567', 9),
(157, 'Eragama', '0111234567', 9),
(158, 'Bandaraduwa', '0111234567', 9),
(159, 'Karthivue', '0111234567', 9),
(160, 'Saindamarudu', '0111234567', 9),
(161, 'Periyanilawali', '0111234567', 9),
(162, 'Nindavur', '0111234567', 9),
(163, 'Trincomalee', '0111234567', 9),
(164, 'Trinco Harbour Police', '0111234567', 9),
(165, 'Chinabay', '0111234567', 9),
(166, 'Kuchchaweli', '0111234567', 9),
(167, 'Uppuweli', '0111234567', 9),
(168, 'Pulmudai', '0111234567', 9),
(169, 'Sri pura', '0111234567', 9),
(170, 'Nilawely', '0111234567', 9),
(171, 'Mutur', '0111234567', 9),
(172, 'Sampoor', '0111234567', 9),
(173, 'Kinniya', '0111234567', 9),
(174, 'Kantale', '0111234567', 9),
(175, 'Agbopura', '0111234567', 9),
(176, 'Thambalagamuva', '0111234567', 9),
(177, 'Serunuwara', '0111234567', 9),
(178, 'Sooriyapura', '0111234567', 9),
(179, 'Wan Ela', '0111234567', 9),
(180, 'Morawewa', '0111234567', 9),
(181, 'Gomarankadawala', '0111234567', 9),
(182, 'Echchallmpaththu', '0111234567', 9),
(183, 'Anuradhapura', '0111234567', 7),
(184, 'Hidogama', '0111234567', 7),
(185, 'Udamaluwa', '0111234567', 7),
(186, 'Mihintale', '0111234567', 7),
(187, 'Kekirawa', '0111234567', 7),
(188, 'Thirappone', '0111234567', 7),
(189, 'Eppawala', '0111234567', 7),
(190, 'Galnewa', '0111234567', 7),
(191, 'Galkiriyagama', '0111234567', 7),
(192, 'Thambuttegama', '0111234567', 7),
(193, 'Rajangane', '0111234567', 7),
(194, 'Nochchiyagama', '0111234567', 7),
(195, 'Thalawa', '0111234567', 7),
(196, 'Thanthirimalaya', '0111234567', 7),
(197, 'Mahawilachchiya', '0111234567', 7),
(198, 'Padavi Sri Pura', '0111234567', 7),
(199, 'Ipallogama', '0111234567', 7),
(200, 'Parasangaswewa', '0111234567', 7),
(201, 'Moragoda', '0111234567', 7),
(202, 'Oyamaduwa', '0111234567', 7),
(203, 'Kallanchiya', '0111234567', 7),
(204, 'Hurigaswewea', '0111234567', 7),
(205, 'Elayapathtuwa', '0111234567', 7),
(206, 'Giranegama', '0111234567', 7),
(207, 'Kawarakkulam', '0111234567', 7),
(208, 'Madatugama', '0111234567', 7),
(209, 'Maradankadawala', '0111234567', 7),
(210, 'Priyankaragama', '0111234567', 7),
(211, 'Siwalakulam', '0111234567', 7),
(212, 'Puhudiula', '0111234567', 7),
(213, 'Kebithigollawa', '0111234567', 7),
(214, 'Horowpathana', '0111234567', 7),
(215, 'Padaviya', '0111234567', 7),
(216, 'Medawachchiya', '0111234567', 7),
(217, 'Galenbidunuwewa', '0111234567', 7),
(218, 'Kahatagasdigiliya', '0111234567', 7),
(219, 'Pihibiyagollewa', '0111234567', 7),
(220, 'Kapugollewa', '0111234567', 7),
(221, 'Kokawewa', '0111234567', 7),
(222, 'Devuolwewa', '0111234567', 7),
(223, 'Etaweeragollewa', '0111234567', 7),
(224, 'Wahalkada', '0111234567', 7),
(225, 'Punewa', '0111234567', 7),
(226, 'Polonnaruwa', '0111234567', 7),
(227, 'Pulasthipura', '0111234567', 7),
(228, 'Welikanda', '0111234567', 7),
(229, 'Aralaganwila', '0111234567', 7),
(230, 'Hingurakgoda', '0111234567', 7),
(231, 'Medirigiriya', '0111234567', 7),
(232, 'Habarana', '0111234567', 7),
(233, 'Bakamuna', '0111234567', 7),
(234, 'Minneriya', '0111234567', 7),
(235, 'Siripura', '0111234567', 7),
(236, 'Diyabeduma', '0111234567', 7),
(237, 'Megaswewa', '0111234567', 7),
(238, 'Manampitiya', '0111234567', 7),
(239, 'Kankasanthurai', '0111234567', 8),
(240, 'Illawali', '0111234567', 8),
(241, 'Achchuweli', '0111234567', 8),
(242, 'Thelippalai', '0111234567', 8),
(243, 'Palali', '0111234567', 8),
(244, 'Point Pedro', '0111234567', 8),
(245, 'Velvatithurai', '0111234567', 8),
(246, 'Jaffna', '0111234567', 8),
(247, 'Manippai', '0111234567', 8),
(248, 'Chunnakam', '0111234567', 8),
(249, 'Kayts', '0111234567', 8),
(250, 'Delft', '0111234567', 8),
(251, 'Wadukotte', '0111234567', 8),
(252, 'Chawakachcheri', '0111234567', 8),
(253, 'Kopai', '0111234567', 8),
(254, 'Kodikamam', '0111234567', 8),
(255, 'Vavuniya', '0111234567', 8),
(256, 'Bogaswewa', '0111234567', 8),
(257, 'Puliyankulam', '0111234567', 8),
(258, 'Chettikulam', '0111234567', 8),
(259, 'Ulukkulam', '0111234567', 8),
(260, 'Puwarasamkulam', '0111234567', 8),
(261, 'Echchanmkulam', '0111234567', 8),
(262, 'MaMaduwa', '0111234567', 8),
(263, 'Irattaperiyakulam', '0111234567', 8),
(264, 'Parayanakulam', '0111234567', 8),
(265, 'Omantha', '0111234567', 8),
(266, 'Nedumkenrni', '0111234567', 8),
(267, 'Kanagarayankulam', '0111234567', 8),
(268, 'Nerukkulam', '0111234567', 8),
(269, 'Sidambarampuram', '0111234567', 8),
(270, 'Kilinochchi', '0111234567', 8),
(271, 'Palei', '0111234567', 8),
(272, 'Punarin', '0111234567', 8),
(273, 'Jayapuram', '0111234567', 8),
(274, 'Mulankavil', '0111234567', 8),
(275, 'Dharmapuram', '0111234567', 8),
(276, 'Akkarayankulam', '0111234567', 8),
(277, 'Maradankerni', '0111234567', 8),
(278, 'Mannar', '0111234567', 8),
(279, 'Silawathura', '0111234567', 8),
(280, 'Iluppakadawai', '0111234567', 8),
(281, 'Thalaimannar', '0111234567', 8),
(282, 'Murunkan', '0111234567', 8),
(283, 'Madu', '0111234567', 8),
(284, 'Wankala', '0111234567', 8),
(285, 'Pesale', '0111234567', 8),
(286, 'Uilankulam', '0111234567', 8),
(287, 'Mullaittivu', '0111234567', 8),
(288, 'Pudukuduiruppu', '0111234567', 8),
(289, 'Mulliyaweli', '0111234567', 8),
(290, 'Oddusudan', '0111234567', 8),
(291, 'Welioya', '0111234567', 8),
(292, 'Mankulam', '0111234567', 8),
(293, 'Mallavi', '0111234567', 8),
(294, 'Aiyankulam', '0111234567', 8),
(295, 'Kokilai', '0111234567', 8),
(296, 'Nattonkadda', '0111234567', 8),
(297, 'Kurunegala', '0111234567', 6),
(298, 'Polgahawela', '0111234567', 6),
(299, 'Alawwa', '0111234567', 6),
(300, 'Pothuhera', '0111234567', 6),
(301, 'Wariyapola', '0111234567', 6),
(302, 'Weerambugedara', '0111234567', 6),
(303, 'Wellawa', '0111234567', 6),
(304, 'Gokarella', '0111234567', 6),
(305, 'Mawathagama', '0111234567', 6),
(306, 'Rideegama', '0111234567', 6),
(307, 'Kumbukgatei', '0111234567', 6),
(308, 'Thalamalgama', '0111234567', 6),
(309, 'Bogamuwa', '0111234567', 6),
(310, 'Malsiripura', '0111234567', 6),
(311, 'Maduragoda', '0111234567', 6),
(312, 'Delvita', '0111234567', 6),
(313, 'Inguruwatta', '0111234567', 6),
(314, 'Welagedara', '0111234567', 6),
(315, 'Boyawalana', '0111234567', 6),
(316, 'Doratiyawa', '0111234567', 6),
(317, 'Gonagama', '0111234567', 6),
(318, 'Kuliyapitiya', '0111234567', 6),
(319, 'Narammala', '0111234567', 6),
(320, 'Pannala', '0111234567', 6),
(321, 'Giriulla', '0111234567', 6),
(322, 'Hettipola', '0111234567', 6),
(323, 'Katupotha', '0111234567', 6),
(324, 'Dummalasooriya', '0111234567', 6),
(325, 'Bingiriya', '0111234567', 6),
(326, 'Kadanegedara', '0111234567', 6),
(327, 'Erapola', '0111234567', 6),
(328, 'Welipannagahamula', '0111234567', 6),
(329, 'Mohottawa', '0111234567', 6),
(330, 'Nikaweratiya', '0111234567', 6),
(331, 'Kobeigane', '0111234567', 6),
(332, 'Kotawehera', '0111234567', 6),
(333, 'Rasnayakapura', '0111234567', 6),
(334, 'Maho', '0111234567', 6),
(335, 'Ambanpola', '0111234567', 6),
(336, 'Polpithigama', '0111234567', 6),
(337, 'Galgamuwa', '0111234567', 6),
(338, 'Meegalewa', '0111234567', 6),
(339, 'Giribawa', '0111234567', 6),
(340, 'Pansiyagama', '0111234567', 6),
(341, 'Girilla', '0111234567', 6),
(342, 'Nagollagama', '0111234567', 6),
(343, 'Moragollagama', '0111234567', 6),
(344, 'Nannariya', '0111234567', 6),
(345, 'Ehatuwewa', '0111234567', 6),
(346, 'Anamaduwa', '0111234567', 6),
(347, 'Pallama', '0111234567', 6),
(348, 'Nawagaththegama', '0111234567', 6),
(349, 'Saliyawewa', '0111234567', 6),
(350, 'Rathnapura', '0111234567', 5),
(351, 'Wewalwatta', '0111234567', 5),
(352, 'Balangoda', '0111234567', 5),
(353, 'Opanayaka', '0111234567', 5),
(354, 'Kaltota', '0111234567', 5),
(355, 'Weligepola', '0111234567', 5),
(356, 'Kahawatta', '0111234567', 5),
(357, 'Rakwana', '0111234567', 5),
(358, 'Ayagama', '0111234567', 5),
(359, 'Kalawana', '0111234567', 5),
(360, 'Nivithigala', '0111234567', 5),
(361, 'Kuruwita', '0111234567', 5),
(362, 'Ehaliyagoda', '0111234567', 5),
(363, 'Kiriella', '0111234567', 5),
(364, 'Pinnawala', '0111234567', 5),
(365, 'Siripagama', '0111234567', 5),
(366, 'Palmadulla', '0111234567', 5),
(367, 'Enadana', '0111234567', 5),
(368, 'Samanala wewa', '0111234567', 5),
(369, 'Delwala', '0111234567', 5),
(370, 'Elapatha', '0111234567', 5),
(371, 'Pothupitiya', '0111234567', 5),
(372, 'Embilipitiya', '0111234567', 5),
(373, 'Kuttigala', '0111234567', 5),
(374, 'Godakawela', '0111234567', 5),
(375, 'Kolonna', '0111234567', 5),
(376, 'Panamure', '0111234567', 5),
(377, 'Sewanagala', '0111234567', 5),
(378, 'Udawalawa', '0111234567', 5),
(379, 'Sooriyakanda', '0111234567', 5),
(380, 'Kegalle', '0111234567', 5),
(381, 'Warakapola', '0111234567', 5),
(382, 'Aranayaka', '0111234567', 5),
(383, 'Dedigama', '0111234567', 5),
(384, 'Mawanella', '0111234567', 5),
(385, 'Rambukkana', '0111234567', 5),
(386, 'Pindeniya', '0111234567', 5),
(387, 'Hemmathagama', '0111234567', 5),
(388, 'Dewalegama', '0111234567', 5),
(389, 'Awissawella', '0111234567', 5),
(390, 'Kosgama', '0111234567', 5),
(391, 'Deraniyagala', '0111234567', 5),
(392, 'Ruwanwella', '0111234567', 5),
(393, 'Yatiyantota', '0111234567', 5),
(394, 'Kithulgala', '0111234567', 5),
(395, 'Bulathkohupitiya', '0111234567', 5),
(396, 'Nuriya', '0111234567', 5),
(397, 'Galapitamada', '0111234567', 5),
(398, 'Dehiowita', '0111234567', 5),
(399, 'Morontota', '0111234567', 5),
(400, 'Matara', '0111234567', 3),
(401, 'Gandara', '0111234567', 3),
(402, 'Dikwella', '0111234567', 3),
(403, 'Thihagoda', '0111234567', 3),
(404, 'Kamburupitiya', '0111234567', 3),
(405, 'Hakmana', '0111234567', 3),
(406, 'Morawaka', '0111234567', 3),
(407, 'Urubokka', '0111234567', 3),
(408, 'Mawarala', '0111234567', 3),
(409, 'Deniyaya', '0111234567', 3),
(410, 'Weligama', '0111234567', 3),
(411, 'Akuressa', '0111234567', 3),
(412, 'Kananke', '0111234567', 3),
(413, 'Pitabeddara', '0111234567', 3),
(414, 'Kotawila', '0111234567', 3),
(415, 'Kosmodara', '0111234567', 3),
(416, 'Malimbada', '0111234567', 3),
(417, 'Rotumba', '0111234567', 3),
(418, 'Deyyandara', '0111234567', 3),
(419, 'Bangama', '0111234567', 3),
(420, 'Midigama', '0111234567', 3),
(421, 'Galle', '0111234567', 3),
(422, 'Rathgama', '0111234567', 3),
(423, 'Hikkaduwa', '0111234567', 3),
(424, 'Akmeemana', '0111234567', 3),
(425, 'Wanduramba', '0111234567', 3),
(426, 'Yakkalamulla', '0111234567', 3),
(427, 'Poddala', '0111234567', 3),
(428, 'Habaraduwa', '0111234567', 3),
(429, 'Ahangama', '0111234567', 3),
(430, 'Galle Harbour', '0111234567', 3),
(431, 'Nagoda', '0111234567', 3),
(432, 'Hiniduma', '0111234567', 3),
(433, 'Neluwa', '0111234567', 3),
(434, 'Udugama', '0111234567', 3),
(435, 'Imaduwa', '0111234567', 3),
(436, 'Opatha', '0111234567', 3),
(437, 'Gonapinuwala', '0111234567', 3),
(438, 'Elpitiya', '0111234567', 3),
(439, 'Uragasmanhandiya', '0111234567', 3),
(440, 'Pitigala', '0111234567', 3),
(441, 'Karandeniya', '0111234567', 3),
(442, 'Baddegama', '0111234567', 3),
(443, 'Batapola', '0111234567', 3),
(444, 'Meetiyagoda', '0111234567', 3),
(445, 'Thelikada', '0111234567', 3),
(446, 'Ambalangoda', '0111234567', 3),
(447, 'Ahungalla', '0111234567', 3),
(448, 'Kosgoda', '0111234567', 3),
(449, 'Bentota', '0111234567', 3),
(450, 'Tangalle', '0111234567', 3),
(451, 'Hungama', '0111234567', 3),
(452, 'Weeraketiya', '0111234567', 3),
(453, 'Angunakolapelessa', '0111234567', 3),
(454, 'Walasmulla', '0111234567', 3),
(455, 'Beliaththa', '0111234567', 3),
(456, 'Katuwana', '0111234567', 3),
(457, 'Middeniya', '0111234567', 3),
(458, 'Sooriyawewa', '0111234567', 3),
(459, 'Hambantota', '0111234567', 3),
(460, 'Ambalantota', '0111234567', 3),
(461, 'Tissamaharamaya', '0111234567', 3),
(462, 'Kataragama', '0111234567', 3),
(463, 'Lunugamwehera', '0111234567', 3),
(464, 'Weeravila', '0111234567', 3),
(465, 'Kirinda', '0111234567', 3),
(466, 'Hambantota Haber', '0111234567', 3),
(467, 'Mathtala', '0111234567', 3),
(468, 'Okewella', '0111234567', 3),
(469, 'Badulla', '0111234567', 4),
(470, 'Passara', '0111234567', 4),
(471, 'Madolseema', '0111234567', 4),
(472, 'Lunugala', '0111234567', 4),
(473, 'Mahiyangane', '0111234567', 4),
(474, 'Giradurukotte', '0111234567', 4),
(475, 'Kandaketiya', '0111234567', 4),
(476, 'Haliela', '0111234567', 4),
(477, 'Rideemaliyadda (Kanugolla P/P)', '0111234567', 4),
(478, 'Kahataruppa', '0111234567', 4),
(479, 'Diulapalassa', '0111234567', 4),
(480, 'Higurukaduwa', '0111234567', 4),
(481, 'Arawa', '0111234567', 4),
(482, 'Galauda', '0111234567', 4),
(483, 'Namunukula', '0111234567', 4),
(484, 'Bandarawela', '0111234567', 4),
(485, 'Ella', '0111234567', 4),
(486, 'Welimada', '0111234567', 4),
(487, 'Uvaparanagama', '0111234567', 4),
(488, 'Etampitiya', '0111234567', 4),
(489, 'Haputale', '0111234567', 4),
(490, 'Diyathalawa', '0111234567', 4),
(491, 'Koslanda', '0111234567', 4),
(492, 'Haldummulla', '0111234567', 4),
(493, 'Bogahakumbura', '0111234567', 4),
(494, 'Ambagasdowa', '0111234567', 4),
(495, 'Ballaketuwa', '0111234567', 4),
(496, 'Keppattipola', '0111234567', 4),
(497, 'Liyangahawela', '0111234567', 4),
(498, 'Medagama', '0111234567', 4),
(499, 'Monaragala', '0111234567', 4),
(500, 'Karandugala', '0111234567', 4),
(501, 'Bibila', '0111234567', 4),
(502, 'Buththala', '0111234567', 4),
(503, 'Gonaganara', '0111234567', 4),
(504, 'Okkampitiya', '0111234567', 4),
(505, 'Badalkumbura', '0111234567', 4),
(506, 'Thanamalwila', '0111234567', 4),
(507, 'Wellawaya', '0111234567', 4),
(508, 'Hambegamuwa', '0111234567', 4),
(509, 'Kudaoya', '0111234567', 4),
(510, 'Siyambalanduwa', '0111234567', 4),
(511, 'Govindupura', '0111234567', 4),
(512, 'Ethimale', '0111234567', 4),
(513, 'Mahakalugolla', '0111234567', 4),
(514, 'Dambagalla', '0111234567', 4),
(515, 'Alawathugoda', '0111234567', 2),
(516, 'Ankumbura', '0111234567', 2),
(517, 'Dalada Maligawa', '0111234567', 2),
(518, 'Daulagala', '0111234567', 2),
(519, 'Galagedara', '0111234567', 2),
(520, 'Hanguranketha', '0111234567', 2),
(521, 'Hatharaliyadda', '0111234567', 2),
(522, 'Kadugannawa', '0111234567', 2),
(523, 'Kandy', '0111234567', 2),
(524, 'Katugastota', '0111234567', 2),
(525, 'Pallakele', '0111234567', 2),
(526, 'Peradeniya', '0111234567', 2),
(527, 'Poojapitiya', '0111234567', 2),
(528, 'Poththapitiya', '0111234567', 2),
(529, 'Welambada', '0111234567', 2),
(530, 'Bokkawala', '0111234567', 2),
(531, 'Aladeniya', '0111234567', 2),
(532, 'Hasalaka', '0111234567', 2),
(533, 'Manikhinna', '0111234567', 2),
(534, 'Panwila', '0111234567', 2),
(535, 'Rangala', '0111234567', 2),
(536, 'Theldeniya', '0111234567', 2),
(537, 'Ududumbara', '0111234567', 2),
(538, 'Wattegama', '0111234567', 2),
(539, 'Galaha', '0111234567', 2),
(540, 'Gampola', '0111234567', 2),
(541, 'Nawa Kurunduwatta', '0111234567', 2),
(542, 'Nawalapitiya', '0111234567', 2),
(543, 'Pupuressa', '0111234567', 2),
(544, 'Pussellawa', '0111234567', 2),
(545, 'Parrateasse', '0111234567', 2),
(546, 'Ethgala', '0111234567', 2),
(547, 'Frotop', '0111234567', 2),
(548, 'Dambulla', '0111234567', 2),
(549, 'Galewela', '0111234567', 2),
(550, 'Laggala', '0111234567', 2),
(551, 'Mahawela', '0111234567', 2),
(552, 'Makulugaswewa', '0111234567', 2),
(553, 'Matale', '0111234567', 2),
(554, 'Naula', '0111234567', 2),
(555, 'Rattota', '0111234567', 2),
(556, 'Sigiriya', '0111234567', 2),
(557, 'Wilgamuwa', '0111234567', 2),
(558, 'Yatawatta', '0111234567', 2),
(559, 'Kandenuwara', '0111234567', 2),
(560, 'Handungamuwa', '0111234567', 2),
(561, 'Agarapathana', '0111234567', 2),
(562, 'Dayagama', '0111234567', 2),
(563, 'Dimbulapathana', '0111234567', 2),
(564, 'Kandapola', '0111234567', 2),
(565, 'Keerthi Bandarapura', '0111234567', 2),
(566, 'Kothmale', '0111234567', 2),
(567, 'Lindula', '0111234567', 2),
(568, 'Mandaram Nuwara', '0111234567', 2),
(569, 'Maturata', '0111234567', 2),
(570, 'Nanuoya', '0111234567', 2),
(571, 'Nuwaraeliya', '0111234567', 2),
(572, 'Pattipola', '0111234567', 2),
(573, 'Pudalu oya', '0111234567', 2),
(574, 'Ragala', '0111234567', 2),
(575, 'Thalawakale', '0111234567', 2),
(576, 'Theripaha', '0111234567', 2),
(577, 'Udupussellawa', '0111234567', 2),
(578, 'Walapone', '0111234567', 2),
(579, 'Highforest', '0111234567', 2),
(580, 'Hatton', '0111234567', 2),
(581, 'Watawala', '0111234567', 2),
(582, 'Ginigathhena', '0111234567', 2),
(583, 'Nortonbridge', '0111234567', 2),
(584, 'Nallathanni', '0111234567', 2),
(585, 'Bagawanthalawa', '0111234567', 2),
(586, 'Norwood', '0111234567', 2),
(587, 'Maskeliya', '0111234567', 2),
(588, 'Polpitiya', '0111234567', 2);

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

--
-- Table structure for table `police_stations_draft`
--

CREATE TABLE `police_stations_draft` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `telephone` varchar(10) NOT NULL,
  `province` int(11) NOT NULL DEFAULT 1 COMMENT 'Province Index from 1 to 9 which represents the 9 provinces in Sri Lanka.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `police_stations_draft`
--

INSERT INTO `police_stations_draft` (`id`, `name`, `telephone`, `province`) VALUES
(1, 'Gampaha', '0332222224', 1),
(2, 'Minuwangoda', '0112295222', 1),
(3, 'Ganemulla', '0332260222', 1),
(4, 'Weliweriya', '0332255222', 1),
(5, 'Weeragula', '0332279442', 1),
(6, 'Yakkala', '0332225924', 1),
(7, 'Malwathuhiripitiya', '0332278800', 1),
(8, 'Pugoda', '0112405224', 1),
(9, 'Dompe', '0112409222', 1),
(10, 'Kirindiwela', '0332267222', 1),
(11, 'Nittambuwa', '0332287224', 1),
(12, 'Mirigama', '0332273222', 1),
(13, 'Veyangoda', '0332287222', 1),
(14, 'Pallewela', '0332271413', 1),
(15, 'Bemmulla', '0332252600', 1),
(16, 'Aththanagalla', '0332280626', 1),
(17, 'Nalla', '0372288669', 1),
(18, 'Danowita', '0352239054', 1),
(19, 'Nungamuwa', '0718592950', 1),
(20, 'Kadawatha', '0112925222', 1),
(21, 'Peliyagoda', '0112911222', 1),
(22, 'Kiribathgoda', '0112914985', 1),
(23, 'JaEla', '0112236222', 1),
(24, 'Wattala', '0112930222', 1),
(25, 'Kandana', '0112236333', 1),
(26, 'Biyagama', '0112487574', 1),
(27, 'Kelaniya', '0112911922', 1),
(28, 'Sapugaskanda', '0112400315', 1),
(29, 'Ragama', '0112958222', 1),
(30, 'Mahabage', '0112948469', 1),
(31, 'Meegahawatta', '0112977233', 1),
(32, 'Ederamulla', '0112940966', 1),
(33, 'Negombo', '0312222222', 1),
(34, 'Katunayaka Airport', '0312252948', 1),
(35, 'Katana', '0312246377', 1),
(36, 'Kotadeniyawa', '0312255616', 1),
(37, 'Divulapitiya', '0312293322', 1),
(38, 'Katunayaka', '0312237223', 1),
(39, 'Raddolugama', '0312247108', 1),
(40, 'Kochchikade', '0312275222', 1),
(41, 'Seeduwa', '0112256222', 1),
(42, 'Pamunugama', '0312251807', 1),
(43, 'Dungalpitiya', '0312277722', 1),
(44, 'Badalgama', '0312241492', 1),
(45, 'Panadura South', '0382236222', 1),
(46, 'Panadura North', '0382234222', 1),
(47, 'Wadduwa', '0382296222', 1),
(48, 'Millaniya', '0342258663', 1),
(49, 'Bandaragama', '0342269222', 1),
(50, 'Anguruwatota', '0342260492', 1),
(51, 'Morontuduwa', '0342265525', 1),
(52, 'Horana', '0342262222', 1),
(53, 'Ingiriya', '0342283222', 1),
(54, 'Moragahahena', '0342283772', 1),
(55, 'Pinwatta', '0382296224', 1),
(56, 'Hirana', '0382232224', 1),
(57, 'Alubomulla', '0342295624', 1),
(58, 'Mount Lavinia', '0112738222', 1),
(59, 'Angulana', '0112738333', 1),
(60, 'Dehiwala', '0112733224', 1),
(61, 'Kohuwala', '0112825222', 1),
(62, 'Moratuwa', '0112643222', 1),
(63, 'Egoda Uyana', '0112646222', 1),
(64, 'Moratumulla', '0112645122', 1),
(65, 'Piliyandala', '0112706222', 1),
(66, 'Kahathuduwa', '0112725222', 1),
(67, 'Mattegoda', '0112741222', 1),
(68, 'Kesbewa', '0112710222', 1),
(69, 'Mirihana', '0112859222', 1),
(70, 'Boralesgamuwa', '0112501322', 1),
(71, 'Gothatuwa', '0112570222', 1),
(72, 'Welikada', '0112873222', 1),
(73, 'Thalangama', '0112786222', 1),
(74, 'Meepe', '0342269114', 1),
(75, 'Athurugiriya', '0112768222', 1),
(76, 'Padukka', '0362242233', 1),
(77, 'Hanwella', '0362256222', 1),
(78, 'Kottawa', '0112843222', 1),
(79, 'Maharagama', '0112857222', 1),
(80, 'Homagama', '0112857222', 1),
(81, 'Mulleriyava', '0112790922', 1),
(82, 'Wellampitiya', '0112533222', 1),
(83, 'Nawagamuwa', '0112746222', 1),
(84, 'Kaduwela', '0112576111', 1),
(85, 'Malabe', '0112787777', 1),
(86, 'Kalutara South', '0342222224', 1),
(87, 'Kalutara North', '0342231224', 1),
(88, 'Beruwala', '0342276222', 1),
(89, 'Aluthgama', '0342272022', 1),
(90, 'Payagala', '0342254066', 1),
(91, 'Dodangoda', '0342254266', 1),
(92, 'Thebuwana', '0342261426', 1),
(93, 'Mathugama', '0342248264', 1),
(94, 'Agalawatta', '0342242624', 1),
(95, 'Warakagoda', '0342243246', 1),
(96, 'Welipanna', '0342243222', 1),
(97, 'Baduraliya', '0342277222', 1),
(98, 'Bulathsinhala', '0342282222', 1),
(99, 'Meegahathenna', '0342288222', 1),
(100, 'Thiniyawala', '0342242222', 1),
(101, 'Iththapana', '0342252346', 1),
(102, 'Pettah', '0112322893', 1),
(103, 'Keselwatta', '0112434303', 1),
(104, 'Fort', '0112327991', 1),
(105, 'Slave Island', '0112434317', 1),
(106, 'Maradana', '0112691545', 1),
(107, 'Maligawatta', '0112434307', 1),
(108, 'Wolfendhal', '0112331746', 1),
(109, 'Dam Street', '0112446443', 1),
(110, 'Colombo Harbour', '0112327558', 1),
(111, 'Fore Shore', '0112332084', 1),
(112, 'Kotahena', '0112446004', 1),
(113, 'Modara', '0112541846', 1),
(114, 'Grandpass', '0112522278', 1),
(115, 'Dematagoda', '0112678764', 1),
(116, 'Mattakkuliya', '0112526445', 1),
(117, 'Bluemandal', '0112593514', 1),
(118, 'Mihijayasewana', '0112536014', 1),
(119, 'Bambalapitiya', '0112580678', 1),
(120, 'Kollupitiya', '0112572210', 1),
(121, 'Kirulapana', '0112519544', 1),
(122, 'Narahenpita', '0112508203', 1),
(123, 'Wellawatta', '0112589347', 1),
(124, 'Borella', '0112691224', 1),
(125, 'Cinnamon Garden', '0112695881', 1),
(126, 'BMICH', '0112681567', 1),
(127, 'Police Headquarters', '0112433333', 1),
(128, 'Batticaloa', '0652222101', 1),
(129, 'Vavunathive', '0652222102', 1),
(130, 'Kaththankudi', '0652222103', 1),
(131, 'Eravur', '0652222104', 1),
(132, 'Karadiyanaru', '0652222105', 1),
(133, 'Aiththamalai', '0652222106', 1),
(134, 'Valachchanai', '0652222107', 1),
(135, 'Kalkudah', '0652222108', 1),
(136, 'Kalawanchikudy', '0652222109', 1),
(137, 'Vellavali', '0652222110', 1),
(138, 'Kokkadicholai', '0652222111', 1),
(139, 'Kokuwill', '0652222112', 1),
(140, 'Ampara', '0652222113', 1),
(141, 'Damana', '0652222114', 1),
(142, 'Inginiyagala', '0652222115', 1),
(143, 'Uhana', '0652222116', 1),
(144, 'Bakkiella', '0652222117', 1),
(145, 'Central Camp', '0652222118', 1),
(146, 'Mangalagama', '0652222119', 1),
(147, 'Mahaoya', '0652222120', 1),
(148, 'Dehiaththakandiya', '0652222121', 1),
(149, 'Padiyathalawa', '0652222122', 1),
(150, 'Kalmunai', '0652222123', 1),
(151, 'Samanthurai', '0652222124', 1),
(152, 'Chawalakade', '0652222125', 1),
(153, 'Akkaraipattu', '0652222126', 1),
(154, 'Thirukkovil', '0652222127', 1),
(155, 'Pothuvil', '0652222128', 1),
(156, 'Panama', '0652222129', 1),
(157, 'Eragama', '0652222130', 1),
(158, 'Bandaraduwa', '0652222131', 1),
(159, 'Karthivue', '0652222132', 1),
(160, 'Saindamarudu', '0652222133', 1),
(161, 'Periyanilawali', '0652222134', 1),
(162, 'Nindavur', '0652222135', 1),
(163, 'Trincomalee', '0652222136', 1),
(164, 'Trinco Harbour Police', '0652222137', 1),
(165, 'Chinabay', '0652222138', 1),
(166, 'Kuchchaweli', '0652222139', 1),
(167, 'Uppuweli', '0652222140', 1),
(168, 'Pulmudai', '0652222141', 1),
(169, 'Sri pura', '0652222142', 1),
(170, 'Nilawely', '0652222143', 1),
(171, 'Mutur', '0652222144', 1),
(172, 'Sampoor', '0652222145', 1),
(173, 'Kinniya', '0652222146', 1),
(174, 'Kantale', '0652222147', 1),
(175, 'Agbopura', '0652222148', 1),
(176, 'Thambalagamuva', '0652222149', 1),
(177, 'Serunuwara', '0652222150', 1),
(178, 'Sooriyapura', '0652222151', 1),
(179, 'Wan Ela', '0652222152', 1),
(180, 'Morawewa', '0652222153', 1),
(181, 'Gomarankadawala', '0652222154', 1),
(182, 'Echchallmpaththu', '0652222155', 1),
(183, 'Anuradhapura', '0662222201', 1),
(184, 'Hidogama', '0662222202', 1),
(185, 'Udamaluwa', '0662222203', 1),
(186, 'Mihintale', '0662222204', 1),
(187, 'Kekirawa', '0662222205', 1),
(188, 'Thirappone', '0662222206', 1),
(189, 'Eppawala', '0662222207', 1),
(190, 'Galnewa', '0662222208', 1),
(191, 'Galkiriyagama', '0662222209', 1),
(192, 'Thambuttegama', '0662222210', 1),
(193, 'Rajangane', '0662222211', 1),
(194, 'Nochchiyagama', '0662222212', 1),
(195, 'Thalawa', '0662222213', 1),
(196, 'Thanthirimalaya', '0662222214', 1),
(197, 'Mahawilachchiya', '0662222215', 1),
(198, 'Padavi Sri Pura', '0662222216', 1),
(199, 'Ipallogama', '0662222217', 1),
(200, 'Parasangaswewa', '0662222218', 1),
(201, 'Moragoda', '0662222219', 1),
(202, 'Oyamaduwa', '0662222220', 1),
(203, 'Kallanchiya', '0662222221', 1),
(204, 'Hurigaswewea', '0662222222', 1),
(205, 'Elayapathtuwa', '0662222223', 1),
(206, 'Giranegama', '0662222224', 1),
(207, 'Kawarakkulam', '0662222225', 1),
(208, 'Madatugama', '0662222226', 1),
(209, 'Maradankadawala', '0662222227', 1),
(210, 'Priyankaragama', '0662222228', 1),
(211, 'Siwalakulam', '0662222229', 1),
(212, 'Puhudiula', '0662222230', 1),
(213, 'Kebithigollawa', '0662222231', 1),
(214, 'Horowpathana', '0662222232', 1),
(215, 'Padaviya', '0662222233', 1),
(216, 'Medawachchiya', '0662222234', 1),
(217, 'Galenbidunuwewa', '0662222235', 1),
(218, 'Kahatagasdigiliya', '0662222236', 1),
(219, 'Pihibiyagollewa', '0662222237', 1),
(220, 'Kapugollewa', '0662222238', 1),
(221, 'Kokawewa', '0662222239', 1),
(222, 'Devuolwewa', '0662222240', 1),
(223, 'Etaweeragollewa', '0662222241', 1),
(224, 'Wahalkada', '0662222242', 1),
(225, 'Punewa', '0662222243', 1),
(226, 'Polonnaruwa', '0662222244', 1),
(227, 'Pulasthipura', '0662222245', 1),
(228, 'Welikanda', '0662222246', 1),
(229, 'Aralaganwila', '0662222247', 1),
(230, 'Hingurakgoda', '0662222248', 1),
(231, 'Medirigiriya', '0662222249', 1),
(232, 'Habarana', '0662222250', 1),
(233, 'Bakamuna', '0662222251', 1),
(234, 'Minneriya', '0662222252', 1),
(235, 'Siripura', '0662222253', 1),
(236, 'Diyabeduma', '0662222254', 1),
(237, 'Megaswewa', '0662222255', 1),
(238, 'Manampitiya', '0662222256', 1),
(239, 'Kankasanthurai', '0652222001', 1),
(240, 'Illawali', '0652222002', 1),
(241, 'Achchuweli', '0652222003', 1),
(242, 'Thelippalai', '0652222004', 1),
(243, 'Palali', '0652222005', 1),
(244, 'Point Pedro', '0652222006', 1),
(245, 'Velvatithurai', '0652222007', 1),
(246, 'Jaffna', '0652222008', 1),
(247, 'Manippai', '0652222009', 1),
(248, 'Chunnakam', '0652222010', 1),
(249, 'Kayts', '0652222011', 1),
(250, 'Delft', '0652222012', 1),
(251, 'Wadukotte', '0652222013', 1),
(252, 'Chawakachcheri', '0652222014', 1),
(253, 'Kopai', '0652222015', 1),
(254, 'Kodikamam', '0652222016', 1),
(255, 'Vavuniya', '0652222017', 1),
(256, 'Bogaswewa', '0652222018', 1),
(257, 'Puliyankulam', '0652222019', 1),
(258, 'Chettikulam', '0652222020', 1),
(259, 'Ulukkulam', '0652222021', 1),
(260, 'Puwarasamkulam', '0652222022', 1),
(261, 'Echchanmkulam', '0652222023', 1),
(262, 'MaMaduwa', '0652222024', 1),
(263, 'Irattaperiyakulam', '0652222025', 1),
(264, 'Parayanakulam', '0652222026', 1),
(265, 'Omantha', '0652222027', 1),
(266, 'Nedumkenrni', '0652222028', 1),
(267, 'Kanagarayankulam', '0652222029', 1),
(268, 'Nerukkulam', '0652222030', 1),
(269, 'Sidambarampuram', '0652222031', 1),
(270, 'Kilinochchi', '0652222032', 1),
(271, 'Palei', '0652222033', 1),
(272, 'Punarin', '0652222034', 1),
(273, 'Jayapuram', '0652222035', 1),
(274, 'Mulankavil', '0652222036', 1),
(275, 'Dharmapuram', '0652222037', 1),
(276, 'Akkarayankulam', '0652222038', 1),
(277, 'Maradankerni', '0652222039', 1),
(278, 'Mannar', '0652222040', 1),
(279, 'Silawathura', '0652222041', 1),
(280, 'Iluppakadawai', '0652222042', 1),
(281, 'Thalaimannar', '0652222043', 1),
(282, 'Murunkan', '0652222044', 1),
(283, 'Madu', '0652222045', 1),
(284, 'Wankala', '0652222046', 1),
(285, 'Pesale', '0652222047', 1),
(286, 'Uilankulam', '0652222048', 1),
(287, 'Mullaittivu', '0652222049', 1),
(288, 'Pudukuduiruppu', '0652222050', 1),
(289, 'Mulliyaweli', '0652222051', 1),
(290, 'Oddusudan', '0652222052', 1),
(291, 'Welioya', '0652222053', 1),
(292, 'Mankulam', '0652222054', 1),
(293, 'Mallavi', '0652222055', 1),
(294, 'Aiyankulam', '0652222056', 1),
(295, 'Kokilai', '0652222057', 1),
(296, 'Nattonkaddal', '0652222058', 1),
(350, 'Kurunegala', '0372222201', 1),
(351, 'Polgahawela', '0372222202', 1),
(352, 'Alawwa', '0372222203', 1),
(353, 'Pothuhera', '0372222204', 1),
(354, 'Wariyapola', '0372222205', 1),
(355, 'Weerambugedara', '0372222206', 1),
(356, 'Wellawa', '0372222207', 1),
(357, 'Gokarella', '0372222208', 1),
(358, 'Mawathagama', '0372222209', 1),
(359, 'Rideegama', '0372222210', 1),
(360, 'Kumbukgatei', '0372222211', 1),
(361, 'Thalamalgama', '0372222212', 1),
(362, 'Bogamuwa', '0372222213', 1),
(363, 'Malsiripura', '0372222214', 1),
(364, 'Maduragoda', '0372222215', 1),
(365, 'Delvita', '0372222216', 1),
(366, 'Inguruwatta', '0372222217', 1),
(367, 'Welagedara', '0372222218', 1),
(368, 'Boyawalana', '0372222219', 1),
(369, 'Doratiyawa', '0372222220', 1),
(370, 'Gonagama', '0372222221', 1),
(371, 'Kuliyapitiya', '0372222222', 1),
(372, 'Narammala', '0372222223', 1),
(373, 'Pannala', '0372222224', 1),
(374, 'Giriulla', '0372222225', 1),
(375, 'Hettipola', '0372222226', 1),
(376, 'Katupotha', '0372222227', 1),
(377, 'Dummalasooriya', '0372222228', 1),
(378, 'Bingiriya', '0372222229', 1),
(379, 'Kadanegedara', '0372222230', 1),
(380, 'Erapola', '0372222231', 1),
(381, 'Welipannagahamula', '0372222232', 1),
(382, 'Mohottawa', '0372222233', 1),
(383, 'Nikaweratiya', '0372222234', 1),
(384, 'Kobeigane', '0372222235', 1),
(385, 'Kotawehera', '0372222236', 1),
(386, 'Rasnayakapura', '0372222237', 1),
(387, 'Maho', '0372222238', 1),
(388, 'Ambanpola', '0372222239', 1),
(389, 'Polpithigama', '0372222240', 1),
(390, 'Galgamuwa', '0372222241', 1),
(391, 'Meegalewa', '0372222242', 1),
(392, 'Giribawa', '0372222243', 1),
(393, 'Pansiyagama', '0372222244', 1),
(394, 'Girilla', '0372222245', 1),
(395, 'Nagollagama', '0372222246', 1),
(396, 'Moragollagama', '0372222247', 1),
(397, 'Nannariya', '0372222248', 1),
(398, 'Ehatuwewa', '0372222249', 1),
(399, 'Anamaduwa', '0372222250', 1),
(400, 'Pallama', '0372222251', 1),
(401, 'Nawagaththegama', '0372222252', 1),
(402, 'Saliyawewa', '0372222253', 1),
(403, 'Rathnapura', '0452222201', 1),
(404, 'Wewalwatta', '0452222202', 1),
(405, 'Balangoda', '0452222203', 1),
(406, 'Opanayaka', '0452222204', 1),
(407, 'Kaltota', '0452222205', 1),
(408, 'Weligepola', '0452222206', 1),
(409, 'Kahawatta', '0452222207', 1),
(410, 'Rakwana', '0452222208', 1),
(411, 'Ayagama', '0452222209', 1),
(412, 'Kalawana', '0452222210', 1),
(413, 'Nivithigala', '0452222211', 1),
(414, 'Kuruwita', '0452222212', 1),
(415, 'Ehaliyagoda', '0452222213', 1),
(416, 'Kiriella', '0452222214', 1),
(417, 'Pinnawala', '0452222215', 1),
(418, 'Siripagama', '0452222216', 1),
(419, 'Palmadulla', '0452222217', 1),
(420, 'Enadana', '0452222218', 1),
(421, 'Samanala wewa', '0452222219', 1),
(422, 'Delwala', '0452222220', 1),
(423, 'Elapatha', '0452222221', 1),
(424, 'Pothupitiya', '0452222222', 1),
(425, 'Embilipitiya', '0452222223', 1),
(426, 'Kuttigala', '0452222224', 1),
(427, 'Godakawela', '0452222225', 1),
(428, 'Kolonna', '0452222226', 1),
(429, 'Panamure', '0452222227', 1),
(430, 'Sewanagala', '0452222228', 1),
(431, 'Udawalawa', '0452222229', 1),
(432, 'Sooriyakanda', '0452222230', 1),
(433, 'Kegalle', '0352222231', 1),
(434, 'Warakapola', '0352222232', 1),
(435, 'Aranayaka', '0352222233', 1),
(436, 'Dedigama', '0352222234', 1),
(437, 'Mawanella', '0352222235', 1),
(438, 'Rambukkana', '0352222236', 1),
(439, 'Pindeniya', '0352222237', 1),
(440, 'Hemmathagama', '0352222238', 1),
(441, 'Dewalegama', '0352222239', 1),
(442, 'Awissawella', '0352222240', 1),
(443, 'Kosgama', '0352222241', 1),
(444, 'Deraniyagala', '0352222242', 1),
(445, 'Ruwanwella', '0352222243', 1),
(446, 'Yatiyantota', '0352222244', 1),
(447, 'Kithulgala', '0352222245', 1),
(448, 'Bulathkohupitiya', '0352222246', 1),
(449, 'Nuriya', '0352222247', 1),
(450, 'Galapitamada', '0352222248', 1),
(451, 'Dehiowita', '0352222249', 1),
(452, 'Morontota', '0352222250', 1),
(522, 'Matara', '0412222201', 1),
(523, 'Gandara', '0412222202', 1),
(524, 'Dikwella', '0412222203', 1),
(525, 'Thihagoda', '0412222204', 1),
(526, 'Kamburupitiya', '0412222205', 1),
(527, 'Hakmana', '0412222206', 1),
(528, 'Morawaka', '0412222207', 1),
(529, 'Urubokka', '0412222208', 1),
(530, 'Mawarala', '0412222209', 1),
(531, 'Deniyaya', '0412222210', 1),
(532, 'Weligama', '0412222211', 1),
(533, 'Akuressa', '0412222212', 1),
(534, 'Kananke', '0412222213', 1),
(535, 'Pitabeddara', '0412222214', 1),
(536, 'Kotawila', '0412222215', 1),
(537, 'Kosmodara', '0412222216', 1),
(538, 'Malimbada', '0412222217', 1),
(539, 'Rotumba', '0412222218', 1),
(540, 'Deyyandara', '0412222219', 1),
(541, 'Bangama', '0412222220', 1),
(542, 'Midigama', '0412222221', 1),
(543, 'Galle', '0912222222', 1),
(544, 'Rathgama', '0912222223', 1),
(545, 'Hikkaduwa', '0912222224', 1),
(546, 'Akmeemana', '0912222225', 1),
(547, 'Wanduramba', '0912222226', 1),
(548, 'Yakkalamulla', '0912222227', 1),
(549, 'Poddala', '0912222228', 1),
(550, 'Habaraduwa', '0912222229', 1),
(551, 'Ahangama', '0912222230', 1),
(552, 'Galle Harbour', '0912222231', 1),
(553, 'Nagoda', '0912222232', 1),
(554, 'Hiniduma', '0912222233', 1),
(555, 'Neluwa', '0912222234', 1),
(556, 'Udugama', '0912222235', 1),
(557, 'Imaduwa', '0912222236', 1),
(558, 'Opatha', '0912222237', 1),
(559, 'Gonapinuwala', '0912222238', 1),
(560, 'Elpitiya', '0912222239', 1),
(561, 'Uragasmanhandiya', '0912222240', 1),
(562, 'Pitigala', '0912222241', 1),
(563, 'Karandeniya', '0912222242', 1),
(564, 'Baddegama', '0912222243', 1),
(565, 'Batapola', '0912222244', 1),
(566, 'Meetiyagoda', '0912222245', 1),
(567, 'Thelikada', '0912222246', 1),
(568, 'Ambalangoda', '0912222247', 1),
(569, 'Ahungalla', '0912222248', 1),
(570, 'Kosgoda', '0912222249', 1),
(571, 'Bentota', '0912222250', 1),
(572, 'Tangalle', '0472222251', 1),
(573, 'Hungama', '0472222252', 1),
(574, 'Weeraketiya', '0472222253', 1),
(575, 'Angunakolapelessa', '0472222254', 1),
(576, 'Walasmulla', '0472222255', 1),
(577, 'Beliaththa', '0472222256', 1),
(578, 'Katuwana', '0472222257', 1),
(579, 'Middeniya', '0472222258', 1),
(580, 'Sooriyawewa', '0472222259', 1),
(581, 'Hambantota', '0472222260', 1),
(582, 'Ambalantota', '0472222261', 1),
(583, 'Tissamaharamaya', '0472222262', 1),
(584, 'Kataragama', '0472222263', 1),
(585, 'Lunugamwehera', '0472222264', 1),
(586, 'Weeravila', '0472222265', 1),
(587, 'Kirinda', '0472222266', 1),
(588, 'Hambantota Harbour', '0472222267', 1),
(589, 'Mathtala', '0472222268', 1),
(590, 'Okewella', '0472222269', 1),
(591, 'Badulla', '0552222201', 1),
(592, 'Passara', '0552222202', 1),
(593, 'Madolseema', '0552222203', 1),
(594, 'Lunugala', '0552222204', 1),
(595, 'Mahiyangane', '0552222205', 1),
(596, 'Giradurukotte', '0552222206', 1),
(597, 'Kandaketiya', '0552222207', 1),
(598, 'Haliela', '0552222208', 1),
(599, 'Rideemaliyadda (Kanugolla P/P)', '0552222209', 1),
(600, 'Kahataruppa', '0552222210', 1),
(601, 'Diulapalassa', '0552222211', 1),
(602, 'Higurukaduwa', '0552222212', 1),
(603, 'Arawa', '0552222213', 1),
(604, 'Galauda', '0552222214', 1),
(605, 'Namunukula', '0552222215', 1),
(606, 'Bandarawela', '0552222216', 1),
(607, 'Ella', '0552222217', 1),
(608, 'Welimada', '0552222218', 1),
(609, 'Uvaparanagama', '0552222219', 1),
(610, 'Etampitiya', '0552222220', 1),
(611, 'Haputale', '0552222221', 1),
(612, 'Diyathalawa', '0552222222', 1),
(613, 'Koslanda', '0552222223', 1),
(614, 'Haldummulla', '0552222224', 1),
(615, 'Bogahakumbura', '0552222225', 1),
(616, 'Ambagasdowa', '0552222226', 1),
(617, 'Ballaketuwa', '0552222227', 1),
(618, 'Keppattipola', '0552222228', 1),
(619, 'Liyangahawela', '0552222229', 1),
(620, 'Medagama', '0552222230', 1),
(621, 'Monaragala', '0572222231', 1),
(622, 'Karandugala', '0572222232', 1),
(623, 'Bibila', '0572222233', 1),
(624, 'Buththala', '0572222234', 1),
(625, 'Gonaganara', '0572222235', 1),
(626, 'Okkampitiya', '0572222236', 1),
(627, 'Badalkumbura', '0572222237', 1),
(628, 'Thanamalwila', '0572222238', 1),
(629, 'Wellawaya', '0572222239', 1),
(630, 'Hambegamuwa', '0572222240', 1),
(631, 'Kudaoya', '0572222241', 1),
(632, 'Siyambalanduwa', '0572222242', 1),
(633, 'Govindupura', '0572222243', 1),
(634, 'Ethimale', '0572222244', 1),
(635, 'Mahakalugolla', '0572222245', 1),
(636, 'Dambagalla', '0572222246', 1),
(637, 'Alawathugoda', '0812222201', 1),
(638, 'Ankumbura', '0812222202', 1),
(639, 'Dalada Maligawa', '0812222203', 1),
(640, 'Daulagala', '0812222204', 1),
(641, 'Galagedara', '0812222205', 1),
(642, 'Hanguranketha', '0812222206', 1),
(643, 'Hatharaliyadda', '0812222207', 1),
(644, 'Kadugannawa', '0812222208', 1),
(645, 'Kandy', '0812222209', 1),
(646, 'Katugastota', '0812222210', 1),
(647, 'Pallakele', '0812222211', 1),
(648, 'Peradeniya', '0812222212', 1),
(649, 'Poojapitiya', '0812222213', 1),
(650, 'Poththapitiya', '0812222214', 1),
(651, 'Welambada', '0812222215', 1),
(652, 'Bokkawala', '0812222216', 1),
(653, 'Aladeniya', '0812222217', 1),
(654, 'Hasalaka', '0812222218', 1),
(655, 'Manikhinna', '0812222219', 1),
(656, 'Panwila', '0812222220', 1),
(657, 'Rangala', '0812222221', 1),
(658, 'Theldeniya', '0812222222', 1),
(659, 'Ududumbara', '0812222223', 1),
(660, 'Wattegama', '0812222224', 1),
(661, 'Galaha', '0812222225', 1),
(662, 'Gampola', '0812222226', 1),
(663, 'Nawa Kurunduwatta', '0812222227', 1),
(664, 'Nawalapitiya', '0812222228', 1),
(665, 'Pupuressa', '0812222229', 1),
(666, 'Pussellawa', '0812222230', 1),
(667, 'Parrateasse', '0812222231', 1),
(668, 'Ethgala', '0812222232', 1),
(669, 'Frotop', '0812222233', 1),
(670, 'Dambulla', '0662222234', 1),
(671, 'Galewela', '0662222235', 1),
(672, 'Laggala', '0662222236', 1),
(673, 'Mahawela', '0662222237', 1),
(674, 'Makulugaswewa', '0662222238', 1),
(675, 'Matale', '0662222239', 1),
(676, 'Naula', '0662222240', 1),
(677, 'Rattota', '0662222241', 1),
(678, 'Sigiriya', '0662222242', 1),
(679, 'Wilgamuwa', '0662222243', 1),
(680, 'Yatawatta', '0662222244', 1),
(681, 'Kandenuwara', '0662222245', 1),
(682, 'Handungamuwa', '0662222246', 1),
(683, 'Agarapathana', '0522222247', 1),
(684, 'Dayagama', '0522222248', 1),
(685, 'Dimbulapathana', '0522222249', 1),
(686, 'Kandapola', '0522222250', 1),
(687, 'Keerthi Bandarapura', '0522222251', 1),
(688, 'Kothmale', '0522222252', 1),
(689, 'Lindula', '0522222253', 1),
(690, 'Mandaram Nuwara', '0522222254', 1),
(691, 'Maturata', '0522222255', 1),
(692, 'Nanuoya', '0522222256', 1),
(693, 'Nuwaraeliya', '0522222257', 1),
(694, 'Pattipola', '0522222258', 1),
(695, 'Pudalu oya', '0522222259', 1),
(696, 'Ragala', '0522222260', 1),
(697, 'Thalawakale', '0522222261', 1),
(698, 'Theripaha', '0522222262', 1),
(699, 'Udupussellawa', '0522222263', 1),
(700, 'Walapone', '0522222264', 1),
(701, 'Highforest', '0522222265', 1),
(702, 'Hatton', '0522222266', 1),
(703, 'Watawala', '0522222267', 1),
(704, 'Ginigathhena', '0522222268', 1),
(705, 'Nortonbridge', '0522222269', 1),
(706, 'Nallathanni', '0522222270', 1),
(707, 'Bagawanthalawa', '0522222271', 1),
(708, 'Norwood', '0522222272', 1),
(709, 'Maskeliya', '0522222273', 1),
(710, 'Polpitiya', '0522222274', 1);

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

--
-- Table structure for table `update_driver_profile_requests`
--

CREATE TABLE `update_driver_profile_requests` (
  `id` varchar(20) NOT NULL,
  `fname` varchar(50) NOT NULL,
  `lname` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone_no` varchar(15) NOT NULL,
  `nic` varchar(20) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `update_driver_profile_requests`
--

INSERT INTO `update_driver_profile_requests` (`id`, `fname`, `lname`, `email`, `phone_no`, `nic`, `password`, `created_at`) VALUES
('b1234567', 'John', 'Does', 'mrclocktd@gmail.com', '0766743755', '200224903146', NULL, '2024-09-19 16:02:15'),
('b2222222', 'Imaz', 'Kalhara', 'ikasun@gmail.com', '0768509438', '20023242435', NULL, '2024-09-20 06:23:17');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `dmt_drivers`
--
ALTER TABLE `dmt_drivers`
  ADD UNIQUE KEY `license_id` (`license_id`),
  ADD UNIQUE KEY `nic` (`nic`);

--
-- Indexes for table `drivers`
--
ALTER TABLE `drivers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`),
  ADD UNIQUE KEY `phone_no` (`phone_no`),
  ADD UNIQUE KEY `nic` (`nic`);

--
-- Indexes for table `offences`
--
ALTER TABLE `offences`
  ADD PRIMARY KEY (`offence_id`);

--
-- Indexes for table `officers`
--
ALTER TABLE `officers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `police_station` (`police_station`);

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

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

--
-- Indexes for table `update_driver_profile_requests`
--
ALTER TABLE `update_driver_profile_requests`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`),
  ADD UNIQUE KEY `phone_no` (`phone_no`),
  ADD UNIQUE KEY `nic` (`nic`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `officers`
--
ALTER TABLE `officers`
  ADD CONSTRAINT `officers_ibfk_2` FOREIGN KEY (`police_station`) REFERENCES `police_stations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `update_driver_profile_requests`
--
ALTER TABLE `update_driver_profile_requests`
  ADD CONSTRAINT `update_driver_profile_requests_ibfk_1` FOREIGN KEY (`id`) REFERENCES `drivers` (`id`);
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 */;