-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Apr 18, 2024 at 06:55 AM
-- Server version: 5.7.36
-- PHP Version: 8.1.0

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

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

--
-- Table structure for table `lookup_departments`
--

DROP TABLE IF EXISTS `lookup_departments`;
CREATE TABLE IF NOT EXISTS `lookup_departments` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `latitude` double(10,6) DEFAULT NULL,
  `longitude` double(10,6) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_departments`
--

INSERT INTO `lookup_departments` (`id`, `name`, `latitude`, `longitude`, `is_active`) VALUES
(1, 'School Education and Literacy Department (Institutions from Montessori up to Class-X)', NULL, NULL, 1),
(2, 'School Education and Literacy Department (Higher Secondary School)', NULL, NULL, 1),
(3, 'School Education and Literacy Department (Institutions of \"O\" & \"A\" Level)', NULL, NULL, 1),
(4, 'School Education and Literacy Department (Degree awarding institutes and universities including Institutions having academic linkage / foreign collaboration/affiliation with any other institutions of higher learning)', NULL, NULL, 1),
(5, 'Sindh Health Care Commission ( Single specialty (i.e general practitioner, homeo, tibb, detist, nursing/ maternity home, laboratories, radiology centre etc.) (Category III & IV))', NULL, NULL, 1),
(6, 'Sindh Health Care Commission (1-24 bedded Medical Centre/ Hospital (Category II-B))', NULL, NULL, 1),
(7, 'Sindh Health Care Commission ( 25 and above bedded Hospital (Category I & II-A))', NULL, NULL, 1),
(8, 'Sindh Health Care Commission', NULL, NULL, 1),
(9, 'Sindh Health Care Commission (Any change in the already registered HCE)', NULL, NULL, 1),
(10, 'Sindh Environmental Protection Agency (SEPA) (Up to 20 Million)', NULL, NULL, 1),
(11, 'Sindh Environmental Protection Agency (SEPA) (Above 20 Million up to 100 Million)', NULL, NULL, 1),
(12, 'Sindh Environmental Protection Agency (SEPA) (Above 100 Milliion up to 200Million)', NULL, NULL, 1),
(13, 'Sindh Environmental Protection Agency (SEPA) (Above 200 Million up to 500 Million)', NULL, NULL, 1),
(14, 'Sindh Environmental Protection Agency (SEPA) (Above 500 Million)', NULL, NULL, 1),
(15, 'Sindh Environmental Protection Agency (SEPA) (Review fee for Environmental Checklist or EMP is)', NULL, NULL, 1),
(16, 'Sindh Environmental Protection Agency (SEPA) (Security Fee)', NULL, NULL, 1),
(17, 'Sindh Environmental Protection Agency (SEPA) (Certificate Fee)', NULL, NULL, 1),
(18, 'Sindh Building Control Authority (SBCA) (Residential area category I. I-A. II. III. IX & X.)', NULL, NULL, 1),
(19, 'Sindh Building Control Authority (SBCA) (Residential area category Area category IV. V. VI. VII &. VIII)', NULL, NULL, 1),
(20, 'Sindh Building Control Authority (SBCA) (Commercial Public Sale Projects Area Cat I. I-A. II. III. IX & X)', NULL, NULL, 1),
(21, 'Sindh Building Control Authority (SBCA) (Commercial Public Sale Projects Area CatI V.V. VII. VII& VIII)', NULL, NULL, 1),
(22, 'Sindh Building Control Authority (SBCA) (Industrial Scrutiny fee for industrial plot, which is situated beyond 50km from Municipal Limit All Cat)', NULL, NULL, 1),
(23, 'Sindh Building Control Authority (SBCA) (Amanities)', NULL, NULL, 1),
(24, 'Sindh Building Control Authority (SBCA) (Residential area category IV. V. VI. VII &. VIII)', NULL, NULL, 1),
(25, 'Sindh Building Control Authority (SBCA) (Cat A-l)', NULL, NULL, 1),
(26, 'Sindh Building Control Authority (SBCA) (Cat : 2)', NULL, NULL, 1),
(27, 'Sindh Building Control Authority (SBCA) (Cat : 3)', NULL, NULL, 1),
(28, 'Sindh Building Control Authority (SBCA) (Cat : 4)', NULL, NULL, 1),
(29, 'Sindh Building Control Authority (SBCA) (Cat : 5)', NULL, NULL, 1),
(30, 'Sindh Building Control Authority (SBCA) (Cat : 6)', NULL, NULL, 1),
(31, 'Sindh Building Control Authority (SBCA) (Cat : 7)', NULL, NULL, 1),
(32, 'Sindh Industrial Trading Estate (S.I.T.E) Limited', NULL, NULL, 1),
(33, 'Sindh Small Industries Corporation (SSIC)', NULL, NULL, 1),
(34, 'Board of Revenue', NULL, NULL, 1),
(35, 'District Municipal Corporation (DMC)', NULL, NULL, 1),
(36, 'Karachi Metropolitan Corporation (KMC)', NULL, NULL, 1),
(37, 'Karachi Metropolitan Corporation (KMC) (Commercial Building & Complex)', NULL, NULL, 1),
(38, 'Karachi Metropolitan Corporation (KMC) (Resedential)', NULL, NULL, 1),
(39, 'Sindh Employees Social Security Institution (SESSI)', NULL, NULL, 1),
(40, 'Excise, Taxation & Narcotics Control Department', NULL, NULL, 1),
(41, 'Excise, Taxation & Narcotics Control Department(Motorcycle)', NULL, NULL, 1),
(42, 'Excise, Taxation & Narcotics Control Department(M/Cars, Jeeps, etc. up to 800 cc Engine Power)', NULL, NULL, 1),
(43, 'Excise, Taxation & Narcotics Control Department(M/Cars, Jeeps, etc. from 801 cc to 2,000 cc Engine Power)', NULL, NULL, 1),
(44, 'Excise, Taxation & Narcotics Control Department(Rickshaws)', NULL, NULL, 1),
(45, 'Excise, Taxation & Narcotics Control Department(Tractors)', NULL, NULL, 1),
(46, 'Excise, Taxation & Narcotics Control Department(Big Vehicle)', NULL, NULL, 1),
(47, 'Excise, Taxation & Narcotics Control Department(Small Vehicle)', NULL, NULL, 1),
(48, 'Sindh Revenue Board', NULL, NULL, 1),
(49, 'Local Government Department', NULL, NULL, 1),
(50, 'Karachi Water & Sewerage Board', NULL, NULL, 1),
(51, 'Excise, Taxation & Narcotics Control Department(M/Cars, Jeeps, etc. up to 800 cc Engine Power)', 0.000000, 0.000000, 0),
(52, 'Excise, Taxation & Narcotics Control Department(M/Cars, Jeeps, etc. from 801 cc to 2,000 cc Engine Power)', 0.000000, 0.000000, 0),
(53, 'Excise, Taxation & Narcotics Control Department(Rickshaws)', 0.000000, 0.000000, 0),
(54, 'Excise, Taxation & Narcotics Control Department(Tractors)', 0.000000, 0.000000, 0),
(55, 'Excise, Taxation & Narcotics Control Department(Big Vehicle)', 0.000000, 0.000000, 0),
(56, 'Excise, Taxation & Narcotics Control Department(Small Vehicle)', 0.000000, 0.000000, 0),
(57, 'Sindh Revenue Board', 0.000000, 0.000000, 0),
(58, 'Local Government Department', 0.000000, 0.000000, 0),
(59, 'Karachi Water & Sewerage Board', 0.000000, 0.000000, 0);
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 */;
