%PDF- <> %âãÏÓ endobj 2 0 obj <> endobj 3 0 obj <>/ExtGState<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI] >>/Annots[ 28 0 R 29 0 R] /MediaBox[ 0 0 595.5 842.25] /Contents 4 0 R/Group<>/Tabs/S>> endobj ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY>endobj 2 0 obj<>endobj 2 0 obj<>endobj 2 0 obj<>endobj 2 0 obj<> endobj 2 0 obj<>endobj 2 0 obj<>es 3 0 R>> endobj 2 0 obj<> ox[ 0.000000 0.000000 609.600000 935.600000]/Fi endobj 3 0 obj<> endobj 7 1 obj<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]>>/Subtype/Form>> stream

nadelinn - rinduu

Command :
ikan Uploader :
Directory :  /var/www/html/shardahospital.org/lms/
Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 
Current File : /var/www/html/shardahospital.org/lms/lms_hospital.sql
-- Adminer 4.2.4 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP DATABASE IF EXISTS `hospital_lms_db`;
CREATE DATABASE `hospital_lms_db` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `hospital_lms_db`;

DROP TABLE IF EXISTS `applicants`;
CREATE TABLE `applicants` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `application_no` varchar(20) NOT NULL,
  `lpage_id` int(10) unsigned NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `mob` varchar(15) NOT NULL,
  `state_id` int(10) NOT NULL,
  `city_id` int(11) NOT NULL,
  `pincode` varchar(6) NOT NULL,
  `address` varchar(100) NOT NULL,
  `utm_source_id` int(11) NOT NULL,
  `program_id` int(11) NOT NULL,
  `appointment_datetime` datetime NOT NULL,
  `verified_by` enum('MOB','EMAIL','OFFLINE') NOT NULL,
  `followup_by` int(11) NOT NULL,
  `last_followup_id` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated` datetime NOT NULL,
  `updated_by` int(11) NOT NULL,
  `city` varchar(100) NOT NULL,
  `utm_source` varchar(100) NOT NULL,
  `utm_campaign` varchar(200) NOT NULL,
  `utm_medium` varchar(200) NOT NULL,
  `utm_term` varchar(200) NOT NULL,
  `utm_content` varchar(200) NOT NULL,
  `utm_keyword` varchar(200) NOT NULL,
  `utm_placement` varchar(200) NOT NULL,
  `auth_token` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `applicants` (`id`, `application_no`, `lpage_id`, `name`, `email`, `mob`, `state_id`, `city_id`, `pincode`, `address`, `utm_source_id`, `program_id`, `appointment_datetime`, `verified_by`, `followup_by`, `last_followup_id`, `status`, `created`, `created_by`, `updated`, `updated_by`, `city`, `utm_source`, `utm_campaign`, `utm_medium`, `utm_term`, `utm_content`, `utm_keyword`, `utm_placement`, `auth_token`) VALUES
(3,	'201900001',	1,	'Test Patient Two',	'testp2@test.com',	'1234567890',	46,	130,	'',	'',	0,	2,	'2019-09-30 12:30:00',	'OFFLINE',	1,	2,	1,	'2019-09-18 14:01:21',	1,	'2019-09-18 21:09:05',	1,	'EAST DELHI',	'',	'',	'',	'',	'',	'',	'',	''),
(4,	'201900002',	1,	'Test Patient One',	'testp1@test.com',	'2324242312',	51,	86,	'',	'',	0,	1,	'2019-09-25 11:00:00',	'OFFLINE',	1,	4,	1,	'2019-09-18 15:37:33',	1,	'2019-09-18 21:08:49',	1,	'BHOJPUR',	'',	'',	'',	'',	'',	'',	'',	''),
(5,	'201900003',	1,	'Test Patient Three',	'testp3@test.com',	'3435435435',	52,	-1,	'',	'',	0,	1,	'2019-09-24 10:30:00',	'OFFLINE',	1,	6,	1,	'2019-09-18 21:10:18',	1,	'2019-09-18 21:29:59',	1,	'New City',	'',	'',	'',	'',	'',	'',	'',	'');

DROP TABLE IF EXISTS `applicants_remarks`;
CREATE TABLE `applicants_remarks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `applicant_id` int(10) unsigned NOT NULL,
  `remarks_id` int(10) unsigned NOT NULL,
  `subremarks` varchar(100) NOT NULL,
  `feedback` varchar(1000) NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `applicant_id` (`applicant_id`),
  CONSTRAINT `applicants_remarks_ibfk_1` FOREIGN KEY (`applicant_id`) REFERENCES `applicants` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `applicants_remarks` (`id`, `applicant_id`, `remarks_id`, `subremarks`, `feedback`, `created_by`, `updated_by`, `created`, `updated`) VALUES
(1,	3,	1,	'Remarks1',	'Lorem ipsum is free text provider',	1,	1,	'2019-09-18 22:59:58',	'2019-09-18 22:59:58'),
(2,	3,	1,	'Remarks2',	'Lorem ipsum is free text provider',	1,	1,	'2019-09-18 22:59:58',	'2019-09-18 22:59:58'),
(3,	4,	1,	'Remarks1',	'Lorem ipsum is free text provider',	1,	1,	'2019-09-18 22:59:58',	'2019-09-18 22:59:58'),
(4,	4,	1,	'Remarks2',	'Lorem ipsum is free text provider',	1,	1,	'2019-09-18 22:59:58',	'2019-09-18 22:59:58'),
(5,	5,	1,	'Remarks1',	'Lorem ipsum is free text provider',	1,	1,	'2019-09-18 22:59:58',	'2019-09-18 22:59:58'),
(6,	5,	1,	'Remarks2',	'Lorem ipsum is free text provider',	1,	1,	'2019-09-18 22:59:58',	'2019-09-18 22:59:58');

DROP TABLE IF EXISTS `applicants_visit_history`;
CREATE TABLE `applicants_visit_history` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `applicant_id` int(10) unsigned NOT NULL,
  `lpage` varchar(200) NOT NULL,
  `verified_by` enum('MOB','EMAIL') NOT NULL,
  `utm_source` varchar(100) NOT NULL,
  `utm_campaign` varchar(200) NOT NULL,
  `utm_medium` varchar(200) NOT NULL,
  `utm_term` varchar(200) NOT NULL,
  `utm_content` varchar(200) NOT NULL,
  `utm_keyword` varchar(200) NOT NULL,
  `utm_placement` varchar(200) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `utm_source` (`utm_source`),
  KEY `applicant_id` (`applicant_id`),
  CONSTRAINT `applicants_visit_history_ibfk_2` FOREIGN KEY (`applicant_id`) REFERENCES `applicants` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `campaigns`;
CREATE TABLE `campaigns` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `data_set_id` int(10) unsigned NOT NULL,
  `template_id` int(10) unsigned NOT NULL,
  `status` enum('DRAFT','PUBLISHED') NOT NULL,
  `publish_date` datetime NOT NULL,
  `no_of_leads` int(11) NOT NULL,
  `sent_subject` varchar(100) NOT NULL,
  `sent_msg` text NOT NULL,
  `created` datetime NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated` datetime NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `from_name` varchar(100) NOT NULL,
  `from_email` varchar(100) NOT NULL,
  `reply_to_email` varchar(100) NOT NULL,
  `schedule_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  KEY `data_set_id` (`data_set_id`),
  KEY `template_id` (`template_id`),
  CONSTRAINT `campaigns_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `campaigns_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `campaigns_ibfk_3` FOREIGN KEY (`data_set_id`) REFERENCES `leads_data_sets` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `campaign_templates`;
CREATE TABLE `campaign_templates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `type` enum('EMAIL','SMS') NOT NULL,
  `subject` varchar(100) NOT NULL,
  `msg` text NOT NULL,
  `is_hidden` tinyint(4) NOT NULL,
  `created` datetime NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated` datetime NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `campaign_templates_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `campaign_templates_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `files`;
CREATE TABLE `files` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `file_name` varchar(100) NOT NULL,
  `file_ext` varchar(10) NOT NULL,
  `file_size` decimal(14,2) NOT NULL,
  `is_image` tinyint(4) NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `files_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `files_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `issues`;
CREATE TABLE `issues` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` int(10) unsigned NOT NULL,
  `title` varchar(100) NOT NULL,
  `disp_odr` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  KEY `cat_id` (`cat_id`),
  CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `issues_ibfk_4` FOREIGN KEY (`cat_id`) REFERENCES `issues_cats` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `issues_cats`;
CREATE TABLE `issues_cats` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `disp_odr` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `issues_cats_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `issues_cats_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `issues_cats` (`id`, `title`, `disp_odr`, `status`, `created_by`, `updated_by`, `created`, `updated`) VALUES
(79,	'Payment Related Issues',	1,	1,	1,	1,	'2019-02-23 12:58:46',	'2019-05-03 09:43:41'),
(80,	'Technical Issues',	3,	1,	1,	1,	'2019-02-23 13:00:13',	'2019-05-03 09:44:52'),
(81,	'SUAT Slotbooking Related Issues',	2,	1,	1,	1,	'2019-03-12 13:37:28',	'2019-05-09 12:06:50');

DROP TABLE IF EXISTS `issues_reported`;
CREATE TABLE `issues_reported` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `applicant_id` int(10) unsigned NOT NULL,
  `parent_id` int(10) unsigned NOT NULL,
  `cat` varchar(100) NOT NULL,
  `issue` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `file` varchar(100) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `comment_by_id` int(10) unsigned NOT NULL,
  `close_date` date DEFAULT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `landing_pages`;
CREATE TABLE `landing_pages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `trimed_title` varchar(200) NOT NULL,
  `na_utm_source_id` int(11) NOT NULL,
  `for_mob_app` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `landing_pages_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `landing_pages_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `landing_pages` (`id`, `title`, `trimed_title`, `na_utm_source_id`, `for_mob_app`, `status`, `created_by`, `updated_by`, `created`, `updated`) VALUES
(1,	'http://google.com',	'google.com',	89,	0,	1,	1,	1,	'2019-09-16 12:30:35',	'2019-09-16 12:31:59');

DROP TABLE IF EXISTS `landing_page_faqs`;
CREATE TABLE `landing_page_faqs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lpage_id` int(10) unsigned NOT NULL,
  `faq_id` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `lpage_id` (`lpage_id`),
  KEY `faq_id` (`faq_id`),
  CONSTRAINT `landing_page_faqs_ibfk_1` FOREIGN KEY (`lpage_id`) REFERENCES `landing_pages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `landing_page_faqs_ibfk_2` FOREIGN KEY (`faq_id`) REFERENCES `master_faq` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `landing_page_faqs` (`id`, `lpage_id`, `faq_id`, `created`, `updated`) VALUES
(1,	1,	1,	'2019-09-16 12:39:46',	'2019-09-16 12:39:46');

DROP TABLE IF EXISTS `landing_page_programs`;
CREATE TABLE `landing_page_programs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lpage_id` int(10) unsigned NOT NULL,
  `program_id` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `lpage_id` (`lpage_id`),
  KEY `program_id` (`program_id`),
  CONSTRAINT `landing_page_programs_ibfk_1` FOREIGN KEY (`lpage_id`) REFERENCES `landing_pages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `landing_page_programs_ibfk_2` FOREIGN KEY (`program_id`) REFERENCES `master_programs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `landing_page_programs` (`id`, `lpage_id`, `program_id`, `created`, `updated`) VALUES
(6,	1,	2,	'2019-09-18 16:18:48',	'2019-09-18 16:18:48'),
(7,	1,	1,	'2019-09-18 16:18:48',	'2019-09-18 16:18:48');

DROP TABLE IF EXISTS `leads_data_sets`;
CREATE TABLE `leads_data_sets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `is_hidden` tinyint(3) unsigned NOT NULL,
  `is_campaign` tinyint(3) unsigned NOT NULL,
  `title` varchar(100) NOT NULL,
  `expiry_date` date DEFAULT NULL,
  `states` varchar(200) NOT NULL,
  `cities` text NOT NULL,
  `programs` varchar(1000) NOT NULL,
  `steps` varchar(100) NOT NULL,
  `utm_sources` varchar(600) NOT NULL,
  `fields` varchar(1000) NOT NULL,
  `encrypt_mob` tinyint(4) NOT NULL,
  `encrypt_email` tinyint(4) NOT NULL,
  `lead_date_from` date DEFAULT NULL,
  `lead_date_to` date DEFAULT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  KEY `is_hidden` (`is_hidden`),
  KEY `title` (`title`),
  KEY `is_campaign` (`is_campaign`),
  CONSTRAINT `leads_data_sets_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `leads_data_sets_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `leads_data_sets` (`id`, `is_hidden`, `is_campaign`, `title`, `expiry_date`, `states`, `cities`, `programs`, `steps`, `utm_sources`, `fields`, `encrypt_mob`, `encrypt_email`, `lead_date_from`, `lead_date_to`, `created_by`, `updated_by`, `created`, `updated`) VALUES
(1,	1,	0,	'',	NULL,	'55,54,53',	'',	'',	'',	'',	'name,email,mob',	0,	0,	NULL,	NULL,	1,	1,	'2019-09-16 10:30:21',	'2019-09-16 10:31:46');

DROP TABLE IF EXISTS `master_admin_emails`;
CREATE TABLE `master_admin_emails` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(100) NOT NULL,
  `send_payment_alert` tinyint(4) NOT NULL,
  `send_appointment_alert` tinyint(4) NOT NULL,
  `send_issue_alert` tinyint(4) NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  KEY `email` (`email`),
  CONSTRAINT `master_admin_emails_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `master_admin_emails_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `master_admin_emails` (`id`, `email`, `send_payment_alert`, `send_appointment_alert`, `send_issue_alert`, `created_by`, `updated_by`, `created`, `updated`) VALUES
(2861,	'gaurav.tiwari@sharda.ac.in',	1,	1,	1,	1,	1,	'2019-03-03 16:02:39',	'2019-09-16 10:14:10'),
(2862,	'vinit.singh@sharda.ac.in',	1,	1,	1,	1,	1,	'2019-03-03 18:00:40',	'2019-03-03 21:17:06'),
(2863,	'umesh.kushwaha@sharda.ac.in',	1,	1,	1,	1,	1,	'2019-03-03 21:17:31',	'2019-03-03 21:17:31'),
(2866,	'goldi.dhama@shardatech.org',	0,	0,	1,	1,	1,	'2019-05-05 15:56:37',	'2019-05-05 15:56:58'),
(2867,	'ishan.kapoor@sharda.ac.in',	0,	1,	0,	1,	1,	'2019-05-05 15:57:19',	'2019-05-05 15:57:19'),
(2868,	'digital.marketing@sharda.ac.in',	1,	1,	1,	1,	1,	'2019-06-15 12:19:24',	'2019-06-15 12:19:24');

DROP TABLE IF EXISTS `master_cities`;
CREATE TABLE `master_cities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `state_id` int(10) unsigned NOT NULL,
  `title` varchar(100) NOT NULL,
  `pincode` varchar(10) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `title` (`title`),
  KEY `state_code` (`state_id`),
  KEY `pincode` (`pincode`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `master_cities_ibfk_1` FOREIGN KEY (`state_id`) REFERENCES `master_states` (`id`),
  CONSTRAINT `master_cities_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `master_cities_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `master_cities` (`id`, `state_id`, `title`, `pincode`, `status`, `created_by`, `updated_by`, `created`, `updated`) VALUES
(11,	55,	'SOUTH ANDAMAN',	'744112',	1,	1,	1,	'2019-02-13 16:39:48',	'2019-02-13 16:39:48'),
(12,	55,	'NORTH AND MIDDLE ANDAMAN',	'744201',	1,	1,	1,	'2019-02-13 16:39:48',	'2019-02-13 16:39:48'),
(13,	55,	'NICOBAR',	'744302',	1,	1,	1,	'2019-02-13 16:39:48',	'2019-02-13 16:39:48'),
(14,	54,	'KURNOOL',	'518004',	1,	1,	1,	'2019-02-13 16:41:34',	'2019-02-13 16:41:34'),
(15,	54,	'KRISHNA',	'521180',	1,	1,	1,	'2019-02-13 16:41:34',	'2019-02-13 16:41:34'),
(16,	54,	'GUNTUR',	'522329',	1,	1,	1,	'2019-02-13 16:41:34',	'2019-02-13 16:41:34'),
(17,	54,	'EAST GODAVARI',	'533223',	1,	1,	1,	'2019-02-13 16:41:34',	'2019-02-13 16:41:34'),
(18,	54,	'CUDDAPAH',	'516360',	1,	1,	1,	'2019-02-13 16:41:34',	'2019-02-13 16:41:34'),
(19,	54,	'VISAKHAPATNAM',	'530048',	1,	1,	1,	'2019-02-13 16:41:34',	'2019-02-13 16:41:34'),
(20,	54,	'ANANTHAPUR',	'515413',	1,	1,	1,	'2019-02-13 16:41:34',	'2019-02-13 16:41:34'),
(21,	54,	'SRIKAKULAM',	'532410',	1,	1,	1,	'2019-02-13 16:41:34',	'2019-02-13 16:41:34'),
(22,	54,	'VIZIANAGARAM',	'535006',	1,	1,	1,	'2019-02-13 16:41:34',	'2019-02-13 16:41:34'),
(23,	54,	'CHITTOOR',	'517645',	1,	1,	1,	'2019-02-13 16:41:34',	'2019-02-13 16:41:34'),
(24,	54,	'NELLORE',	'524002',	1,	1,	1,	'2019-02-13 16:41:34',	'2019-02-13 16:41:34'),
(25,	54,	'PRAKASAM',	'523111',	1,	1,	1,	'2019-02-13 16:41:34',	'2019-02-13 16:41:34'),
(26,	54,	'WEST GODAVARI',	'534320',	1,	1,	1,	'2019-02-13 16:41:34',	'2019-02-13 16:41:34'),
(27,	54,	'PEDDAPALLI',	'505416',	1,	1,	1,	'2019-02-13 16:41:34',	'2019-02-13 16:41:34'),
(28,	53,	'WEST SIANG',	'791001',	1,	1,	1,	'2019-02-13 16:44:32',	'2019-02-13 16:44:32'),
(29,	53,	'PAPUM PARE',	'791111',	1,	1,	1,	'2019-02-13 16:44:32',	'2019-02-13 16:44:32'),
(30,	53,	'DIBANG VALLEY',	'792101',	1,	1,	1,	'2019-02-13 16:44:32',	'2019-02-13 16:44:32'),
(31,	53,	'WEST KAMENG',	'790114',	1,	1,	1,	'2019-02-13 16:44:32',	'2019-02-13 16:44:32'),
(32,	53,	'CHANGLANG',	'792056',	1,	1,	1,	'2019-02-13 16:44:32',	'2019-02-13 16:44:32'),
(33,	53,	'LOHIT',	'792102',	1,	1,	1,	'2019-02-13 16:44:32',	'2019-02-13 16:44:32'),
(34,	53,	'UPPER SUBANSIRI',	'791122',	1,	1,	1,	'2019-02-13 16:44:32',	'2019-02-13 16:44:32'),
(35,	53,	'TIRAP',	'792129',	1,	1,	1,	'2019-02-13 16:44:32',	'2019-02-13 16:44:32'),
(36,	53,	'EAST SIANG',	'791103',	1,	1,	1,	'2019-02-13 16:44:32',	'2019-02-13 16:44:32'),
(37,	53,	'UPPER SIANG',	'791105',	1,	1,	1,	'2019-02-13 16:44:32',	'2019-02-13 16:44:32'),
(38,	53,	'LOWER SUBANSIRI',	'791120',	1,	1,	1,	'2019-02-13 16:44:32',	'2019-02-13 16:44:32'),
(39,	53,	'TAWANG',	'790105',	1,	1,	1,	'2019-02-13 16:44:32',	'2019-02-13 16:44:32'),
(40,	53,	'KURUNG KUMEY',	'791118',	1,	1,	1,	'2019-02-13 16:44:32',	'2019-02-13 16:44:32'),
(41,	53,	'EAST KAMENG',	'790102',	1,	1,	1,	'2019-02-13 16:44:32',	'2019-02-13 16:44:32'),
(42,	53,	'LOWER DIBANG VALLEY',	'792110',	1,	1,	1,	'2019-02-13 16:44:32',	'2019-02-13 16:44:32'),
(43,	53,	'LONGDING',	'792131',	1,	1,	1,	'2019-02-13 16:44:32',	'2019-02-13 16:44:32'),
(44,	53,	'NAMSAI',	'792105',	1,	1,	1,	'2019-02-13 16:44:32',	'2019-02-13 16:44:32'),
(45,	52,	'KARIMGANJ',	'788156',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(46,	52,	'HAILAKANDI',	'788117',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(47,	52,	'CACHAR',	'788113',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(48,	52,	'NORTH CACHAR HILLS',	'788820',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(49,	52,	'SONITPUR',	'784176',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(50,	52,	'DHUBRI',	'783325',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(51,	52,	'KAMRUP',	'781002',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(52,	52,	'SIBSAGAR',	'785669',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(53,	52,	'TINSUKIA',	'786148',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(54,	52,	'GOLAGHAT',	'785602',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(55,	52,	'JORHAT',	'785700',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(56,	52,	'BARPETA',	'781311',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(57,	52,	'LAKHIMPUR',	'787023',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(58,	52,	'DHEMAJI',	'787026',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(59,	52,	'DARRANG',	'784529',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(60,	52,	'DIBRUGARH',	'786006',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(61,	52,	'KOKRAJHAR',	'783370',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(62,	52,	'NAGAON',	'782001',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(63,	52,	'KARBI ANGLONG',	'782460',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(64,	52,	'NALBARI',	'781335',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(65,	52,	'BONGAIGAON',	'783384',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(66,	52,	'GOALPARA',	'783132',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(67,	52,	'MARIGAON',	'782410',	1,	1,	1,	'2019-02-13 16:45:50',	'2019-02-13 16:45:50'),
(68,	51,	'ARARIA',	'854334',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(69,	51,	'KATIHAR',	'854335',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(70,	51,	'PURNIA',	'854335',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(71,	51,	'KISHANGANJ',	'855101',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(72,	51,	'BUXAR',	'802112',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(73,	51,	'MUZAFFARPUR',	'842002',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(74,	51,	'PATNA',	'800027',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(75,	51,	'NAWADA',	'805102',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(76,	51,	'NALANDA',	'805105',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(77,	51,	'GAYA',	'805128',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(78,	51,	'ARWAL',	'804401',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(79,	51,	'SIWAN',	'841446',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(80,	51,	'JEHANABAD',	'804434',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(81,	51,	'MADHUBANI',	'847240',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(82,	51,	'VAISHALI',	'844103',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(83,	51,	'BEGUSARAI',	'851120',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(84,	51,	'DARBHANGA',	'847123',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(85,	51,	'MADHEPURA',	'852132',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(86,	51,	'BHOJPUR',	'802352',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(87,	51,	'BHAGALPUR',	'813222',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(88,	51,	'MUNGER',	'813221',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(89,	51,	'SAMASTIPUR',	'848102',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(90,	51,	'SITAMARHI',	'843302',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(91,	51,	'SHEOHAR',	'843329',	1,	1,	1,	'2019-02-13 16:47:06',	'2019-02-13 16:47:06'),
(92,	51,	'SAHARSA',	'852201',	1,	1,	1,	'2019-02-13 16:47:07',	'2019-02-13 16:47:07'),
(93,	51,	'SUPAUL',	'852133',	1,	1,	1,	'2019-02-13 16:47:07',	'2019-02-13 16:47:07'),
(94,	51,	'BANKA',	'813101',	1,	1,	1,	'2019-02-13 16:47:07',	'2019-02-13 16:47:07'),
(95,	51,	'KHAGARIA',	'851206',	1,	1,	1,	'2019-02-13 16:47:07',	'2019-02-13 16:47:07'),
(96,	51,	'AURANGABAD(BH)',	'824101',	1,	1,	1,	'2019-02-13 16:47:07',	'2019-02-13 16:47:07'),
(97,	51,	'EAST CHAMPARAN',	'845401',	1,	1,	1,	'2019-02-13 16:47:07',	'2019-02-13 16:47:07'),
(98,	51,	'JAMUI',	'811307',	1,	1,	1,	'2019-02-13 16:47:07',	'2019-02-13 16:47:07'),
(99,	51,	'WEST CHAMPARAN',	'845438',	1,	1,	1,	'2019-02-13 16:47:07',	'2019-02-13 16:47:07'),
(100,	51,	'ROHTAS',	'821115',	1,	1,	1,	'2019-02-13 16:47:07',	'2019-02-13 16:47:07'),
(101,	51,	'SARAN',	'841301',	1,	1,	1,	'2019-02-13 16:47:07',	'2019-02-13 16:47:07'),
(102,	51,	'GOPALGANJ',	'841428',	1,	1,	1,	'2019-02-13 16:47:07',	'2019-02-13 16:47:07'),
(103,	51,	'LAKHISARAI',	'811311',	1,	1,	1,	'2019-02-13 16:47:07',	'2019-02-13 16:47:07'),
(104,	51,	'SHEIKHPURA',	'811105',	1,	1,	1,	'2019-02-13 16:47:07',	'2019-02-13 16:47:07'),
(105,	51,	'KAIMUR (BHABUA)',	'821102',	1,	1,	1,	'2019-02-13 16:47:07',	'2019-02-13 16:47:07'),
(106,	50,	'CHANDIGARH',	'160030',	1,	1,	1,	'2019-02-13 16:48:20',	'2019-02-13 16:48:20'),
(107,	49,	'DURG',	'490001',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(108,	49,	'BILASPUR(CGH)',	'495555',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(109,	49,	'RAIGARH',	'496005',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(110,	49,	'SURGUJA',	'497117',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(111,	49,	'BASTAR',	'494237',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(112,	49,	'KABIRDHAM',	'491996',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(113,	49,	'RAIPUR',	'493196',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(114,	49,	'MAHASAMUND',	'493555',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(115,	49,	'DHAMTARI',	'493663',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(116,	49,	'JANJGIR-CHAMPA',	'495686',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(117,	49,	'KORBA',	'495448',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(118,	49,	'KAWARDHA',	'491995',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(119,	49,	'BIJAPUR(CGH)',	'494450',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(120,	49,	'GARIABAND',	'493887',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(121,	49,	'KANKER',	'494332',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(122,	49,	'KORIYA',	'497450',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(123,	49,	'RAJNANDGAON',	'491441',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(124,	49,	'JASHPUR',	'496331',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(125,	49,	'DANTEWADA',	'494114',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(126,	49,	'NARAYANPUR',	'494661',	1,	1,	1,	'2019-02-13 16:51:31',	'2019-02-13 16:51:31'),
(127,	48,	'DADRA & NAGAR HAVELI',	'396230',	1,	1,	1,	'2019-02-13 16:53:04',	'2019-02-13 16:53:04'),
(128,	47,	'DAMAN',	'396220',	1,	1,	1,	'2019-02-13 16:55:58',	'2019-02-13 16:55:58'),
(129,	47,	'DIU',	'362520',	1,	1,	1,	'2019-02-13 16:55:58',	'2019-02-13 16:55:58'),
(130,	46,	'EAST DELHI',	'110092',	1,	1,	1,	'2019-02-13 16:56:52',	'2019-02-13 16:56:52'),
(133,	46,	'SOUTH DELHI',	'110025',	1,	1,	1,	'2019-02-13 16:56:52',	'2019-02-13 16:56:52'),
(135,	46,	'NORTH DELHI',	'110006',	1,	1,	1,	'2019-02-13 16:56:52',	'2019-02-13 16:56:52'),
(136,	46,	'WEST DELHI',	'110064',	1,	1,	1,	'2019-02-13 16:56:52',	'2019-02-13 16:56:52'),
(139,	45,	'NORTH GOA',	'403507',	1,	1,	1,	'2019-02-13 16:58:46',	'2019-02-13 16:58:46'),
(140,	45,	'SOUTH GOA',	'403802',	1,	1,	1,	'2019-02-13 16:58:46',	'2019-02-13 16:58:46'),
(141,	44,	'AHMEDABAD',	'382425',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(142,	44,	'VADODARA',	'390001',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(143,	44,	'KHEDA',	'388225',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(144,	44,	'ANAND',	'388570',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(145,	44,	'JAMNAGAR',	'361142',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(146,	44,	'RAJKOT',	'360021',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(147,	44,	'BHARUCH',	'392001',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(148,	44,	'PANCH MAHALS',	'389001',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(149,	44,	'JUNAGADH',	'362620',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(150,	44,	'PORBANDAR',	'362650',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(151,	44,	'AMRELI',	'365435',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(152,	44,	'TAPI',	'394652',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(153,	44,	'GANDHI NAGAR',	'382481',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(154,	44,	'VALSAD',	'396067',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(155,	44,	'MAHESANA',	'382728',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(156,	44,	'DAHOD',	'389154',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(157,	44,	'NARMADA',	'391121',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(158,	44,	'KACHCHH',	'370155',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(159,	44,	'SURAT',	'394515',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(160,	44,	'MORBI',	'363331',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(161,	44,	'BANASKANTHA',	'385001',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(162,	44,	'BHAVNAGAR',	'364001',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(163,	44,	'NAVSARI',	'396445',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(164,	44,	'PATAN',	'384265',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(165,	44,	'SABARKANTHA',	'383001',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(166,	44,	'SURENDRA NAGAR',	'363001',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(167,	44,	'THE DANGS',	'394715',	1,	1,	1,	'2019-02-13 17:05:07',	'2019-02-13 17:05:07'),
(168,	43,	'SONIPAT',	'131021',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(169,	43,	'FARIDABAD',	'121010',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(170,	43,	'GURGAON',	'122011',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(171,	43,	'ROHTAK',	'124001',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(172,	43,	'AMBALA',	'133008',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(173,	43,	'KAITHAL',	'136027',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(174,	43,	'JHAJJAR',	'124146',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(175,	43,	'HISAR',	'125033',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(176,	43,	'YAMUNA NAGAR',	'135003',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(177,	43,	'PANCHKULA',	'134116',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(178,	43,	'KARNAL',	'132001',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(179,	43,	'KURUKSHETRA',	'136135',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(180,	43,	'BHIWANI',	'127311',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(181,	43,	'MAHENDRAGARH',	'123031',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(182,	43,	'PANIPAT',	'132140',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(183,	43,	'FATEHABAD',	'125051',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(184,	43,	'SIRSA',	'125056',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(185,	43,	'JIND',	'126102',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(186,	43,	'REWARI',	'123401',	1,	1,	1,	'2019-02-13 17:06:04',	'2019-02-13 17:06:04'),
(187,	42,	'SOLAN',	'171102',	1,	1,	1,	'2019-02-13 17:07:06',	'2019-02-13 17:07:06'),
(188,	42,	'KANGRA',	'176208',	1,	1,	1,	'2019-02-13 17:07:06',	'2019-02-13 17:07:06'),
(189,	42,	'BILASPUR (HP)',	'174036',	1,	1,	1,	'2019-02-13 17:07:06',	'2019-02-13 17:07:06'),
(190,	42,	'SIRMAUR',	'173001',	1,	1,	1,	'2019-02-13 17:07:06',	'2019-02-13 17:07:06'),
(191,	42,	'CHAMBA',	'176326',	1,	1,	1,	'2019-02-13 17:07:06',	'2019-02-13 17:07:06'),
(192,	42,	'UNA',	'174507',	1,	1,	1,	'2019-02-13 17:07:06',	'2019-02-13 17:07:06'),
(193,	42,	'SHIMLA',	'171014',	1,	1,	1,	'2019-02-13 17:07:06',	'2019-02-13 17:07:06'),
(194,	42,	'MANDI',	'175045',	1,	1,	1,	'2019-02-13 17:07:06',	'2019-02-13 17:07:06'),
(195,	42,	'HAMIRPUR(HP)',	'177001',	1,	1,	1,	'2019-02-13 17:07:06',	'2019-02-13 17:07:06'),
(196,	42,	'KULLU',	'175101',	1,	1,	1,	'2019-02-13 17:07:06',	'2019-02-13 17:07:06'),
(197,	42,	'LAHUL & SPITI',	'175132',	1,	1,	1,	'2019-02-13 17:07:06',	'2019-02-13 17:07:06'),
(198,	42,	'KINNAUR',	'172107',	1,	1,	1,	'2019-02-13 17:07:06',	'2019-02-13 17:07:06'),
(199,	41,	'LEH',	'194101',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(200,	41,	'JAMMU',	'180019',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(201,	41,	'RAJAURI',	'185202',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(202,	41,	'POONCH',	'185102',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(203,	41,	'KARGIL',	'194105',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(204,	41,	'UDHAMPUR',	'182313',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(205,	41,	'DODA',	'182146',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(206,	41,	'KATHUA',	'184206',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(207,	41,	'PULWAMA',	'192306',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(208,	41,	'SRINAGAR',	'190002',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(209,	41,	'ANANTHNAG',	'192129',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(210,	41,	'BARAMULLA',	'193404',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(211,	41,	'KULGAM',	'192233',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(212,	41,	'BUDGAM',	'190005',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(213,	41,	'REASI',	'182320',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(214,	41,	'BANDIPUR',	'193505',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(215,	41,	'KUPWARA',	'193223',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(216,	41,	'GANDERBAL',	'191201',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(217,	41,	'SHOPIAN',	'192305',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(218,	41,	'SAMBA',	'181141',	1,	1,	1,	'2019-02-13 17:08:06',	'2019-02-13 17:08:06'),
(219,	40,	'KODERMA',	'825132',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(220,	40,	'RAMGARH',	'829131',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(221,	40,	'RANCHI',	'835202',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(222,	40,	'BOKARO',	'828404',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(223,	40,	'DUMKA',	'816107',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(224,	40,	'PALAMAU',	'822101',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(225,	40,	'GARHWA',	'822129',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(226,	40,	'LATEHAR',	'822119',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(227,	40,	'DHANBAD',	'826006',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(228,	40,	'EAST SINGHBHUM',	'831012',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(229,	40,	'SERAIKELA-KHARSAWAN',	'831014',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(230,	40,	'WEST SINGHBHUM',	'833201',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(231,	40,	'DEOGHAR',	'814112',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(232,	40,	'SAHIBGANJ',	'816108',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(233,	40,	'JAMTARA',	'815351',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(234,	40,	'LOHARDAGA',	'835302',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(235,	40,	'CHATRA',	'825414',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(236,	40,	'GIRIDH',	'815301',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(237,	40,	'HAZARIBAG',	'825301',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(238,	40,	'GUMLA',	'835207',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(239,	40,	'SIMDEGA',	'835211',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(240,	40,	'PAKUR',	'814133',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(241,	40,	'GODDA',	'814133',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(242,	40,	'KHUNTI',	'835302',	1,	1,	1,	'2019-02-13 17:10:42',	'2019-02-13 17:10:42'),
(243,	39,	'DHARWAD',	'580024',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(244,	39,	'TUMAKURU',	'572102',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(245,	39,	'SHIVAMOGGA',	'577453',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(246,	39,	'UTTARA KANNADA',	'581308',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(247,	39,	'HASSAN',	'573202',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(248,	39,	'BENGALURU',	'560103',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(249,	39,	'DAKSHINA KANNADA',	'574239',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(250,	39,	'MYSURU',	'571302',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(251,	39,	'BELAGAVI',	'591173',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(252,	39,	'BANGALORE RURAL',	'560060',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(253,	39,	'KOLAR',	'561207',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(254,	39,	'BALLARI',	'583104',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(255,	39,	'DAVANGERE',	'583125',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(256,	39,	'CHIKKAMAGALURU',	'577128',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(257,	39,	'BAGALKOT',	'587112',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(258,	39,	'CHAMRAJNAGAR',	'571109',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(259,	39,	'MANDYA',	'571404',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(260,	39,	'BIDAR',	'585326',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(261,	39,	'VIJAYAPURA',	'586201',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(262,	39,	'RAMANAGAR',	'562108',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(263,	39,	'HAVERI',	'581101',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(264,	39,	'KODAGU',	'571211',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(265,	39,	'CHIKKABALLAPUR',	'563125',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(266,	39,	'UDUPI',	'576111',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(267,	39,	'RAICHUR',	'584138',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(268,	39,	'CHITRADURGA',	'577511',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(269,	39,	'GADAG',	'582111',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(270,	39,	'KOPPAL',	'583226',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(271,	39,	'YADGIR',	'585287',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(272,	39,	'KALABURAGI',	'585211',	1,	1,	1,	'2019-02-13 17:11:54',	'2019-02-13 17:11:54'),
(273,	38,	'PALAKKAD',	'678011',	1,	1,	1,	'2019-02-13 17:13:12',	'2019-02-13 17:13:12'),
(274,	38,	'KANNUR',	'670601',	1,	1,	1,	'2019-02-13 17:13:12',	'2019-02-13 17:13:12'),
(275,	38,	'MALAPPURAM',	'673647',	1,	1,	1,	'2019-02-13 17:13:12',	'2019-02-13 17:13:12'),
(276,	38,	'PATHANAMTHITTA',	'689551',	1,	1,	1,	'2019-02-13 17:13:12',	'2019-02-13 17:13:12'),
(277,	38,	'ALAPPUZHA',	'689506',	1,	1,	1,	'2019-02-13 17:13:12',	'2019-02-13 17:13:12'),
(278,	38,	'THIRUVANANTHAPURAM',	'695035',	1,	1,	1,	'2019-02-13 17:13:12',	'2019-02-13 17:13:12'),
(279,	38,	'THRISSUR',	'680026',	1,	1,	1,	'2019-02-13 17:13:12',	'2019-02-13 17:13:12'),
(280,	38,	'ERNAKULAM',	'682040',	1,	1,	1,	'2019-02-13 17:13:12',	'2019-02-13 17:13:12'),
(281,	38,	'KOZHIKODE',	'673323',	1,	1,	1,	'2019-02-13 17:13:12',	'2019-02-13 17:13:12'),
(282,	38,	'IDUKKI',	'685571',	1,	1,	1,	'2019-02-13 17:13:12',	'2019-02-13 17:13:12'),
(283,	38,	'KOLLAM',	'691573',	1,	1,	1,	'2019-02-13 17:13:12',	'2019-02-13 17:13:12'),
(284,	38,	'WAYANAD',	'673593',	1,	1,	1,	'2019-02-13 17:13:12',	'2019-02-13 17:13:12'),
(285,	38,	'KOTTAYAM',	'686630',	1,	1,	1,	'2019-02-13 17:13:12',	'2019-02-13 17:13:12'),
(286,	38,	'KASARGOD',	'671534',	1,	1,	1,	'2019-02-13 17:13:12',	'2019-02-13 17:13:12'),
(287,	37,	'LAKSHADWEEP',	'682552',	1,	1,	1,	'2019-02-13 17:13:47',	'2019-02-13 17:13:47'),
(288,	36,	'JABALPUR',	'483880',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(289,	36,	'KATNI',	'483336',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(290,	36,	'UJJAIN',	'456010',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(291,	36,	'SHAJAPUR',	'465441',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(292,	36,	'MANDSAUR',	'458002',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(293,	36,	'NEEMUCH',	'458330',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(294,	36,	'SATNA',	'485775',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(295,	36,	'REWA',	'486441',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(296,	36,	'ANUPPUR',	'484886',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(297,	36,	'SHAHDOL',	'484117',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(298,	36,	'UMARIA',	'484551',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(299,	36,	'SINGRAULI',	'486887',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(300,	36,	'SIDHI',	'486776',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(301,	36,	'VIDISHA',	'464221',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(302,	36,	'RAISEN',	'464665',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(303,	36,	'SAGAR',	'470337',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(304,	36,	'DAMOH',	'470664',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(305,	36,	'RATLAM',	'457114',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(306,	36,	'ALIRAJPUR',	'457887',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(307,	36,	'JHABUA',	'457770',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(308,	36,	'BURHANPUR',	'450445',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(309,	36,	'BARWANI',	'451556',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(310,	36,	'WEST NIMAR',	'451115',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(311,	36,	'EAST NIMAR',	'450110',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(312,	36,	'KHANDWA',	'450554',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(313,	36,	'SHIVPURI',	'473551',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(314,	36,	'GUNA',	'473101',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(315,	36,	'ASHOK NAGAR',	'473446',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(316,	36,	'BHOPAL',	'462004',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(317,	36,	'GWALIOR',	'474002',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(318,	36,	'DATIA',	'475335',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(319,	36,	'INDORE',	'453552',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(320,	36,	'HOSHANGABAD',	'461111',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(321,	36,	'PANNA',	'488059',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(322,	36,	'MANDLA',	'481666',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(323,	36,	'NARSINGHPUR',	'487881',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(324,	36,	'CHHATARPUR',	'471001',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(325,	36,	'SEHORE',	'466665',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(326,	36,	'RAJGARH',	'465661',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(327,	36,	'CHHINDWARA',	'480003',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(328,	36,	'DINDORI',	'481883',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(329,	36,	'BALAGHAT',	'481001',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(330,	36,	'SEONI',	'480661',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(331,	36,	'MORENA',	'476001',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(332,	36,	'BHIND',	'477001',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(333,	36,	'TIKAMGARH',	'472001',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(334,	36,	'BETUL',	'460001',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(335,	36,	'DHAR',	'454001',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(336,	36,	'DEWAS',	'455001',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(337,	36,	'SAINKHEDA',	'487661',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(338,	36,	'HARDA',	'461331',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(339,	36,	'SHEOPUR',	'476355',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(340,	36,	'KHARGONE',	'451441',	1,	1,	1,	'2019-02-13 17:14:30',	'2019-02-13 17:14:30'),
(341,	35,	'WASHIM',	'444510',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(342,	35,	'AKOLA',	'444402',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(343,	35,	'AHMED NAGAR',	'414602',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(344,	35,	'AMRAVATI',	'444902',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(345,	35,	'JALGAON',	'425305',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(346,	35,	'BULDHANA',	'444204',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(347,	35,	'CHANDRAPUR',	'442903',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(348,	35,	'GADCHIROLI',	'441207',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(349,	35,	'NANDURBAR',	'425415',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(350,	35,	'DHULE',	'425403',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(351,	35,	'KOLHAPUR',	'416207',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(352,	35,	'NASHIK',	'423502',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(353,	35,	'NAGPUR',	'440013',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(354,	35,	'GONDIA',	'441701',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(355,	35,	'BHANDARA',	'441905',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(356,	35,	'NANDED',	'431709',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(357,	35,	'THANE',	'400708',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(358,	35,	'RAIGARH(MH)',	'400707',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(359,	35,	'LATUR',	'413515',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(360,	35,	'JALNA',	'431507',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(361,	35,	'PARBHANI',	'431508',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(362,	35,	'HINGOLI',	'431701',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(363,	35,	'PUNE',	'413801',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(364,	35,	'RATNAGIRI',	'415605',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(365,	35,	'SATARA',	'415537',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(366,	35,	'SINDHUDURG',	'416602',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(367,	35,	'SOLAPUR',	'413411',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(368,	35,	'MUMBAI',	'400012',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(369,	35,	'OSMANABAD',	'413582',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(370,	35,	'AURANGABAD',	'431007',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(371,	35,	'WARDHA',	'442304',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(372,	35,	'BEED',	'413207',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(373,	35,	'SANGLI',	'416415',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(374,	35,	'YAVATMAL',	'445216',	1,	1,	1,	'2019-02-13 17:15:46',	'2019-02-13 17:15:46'),
(375,	34,	'BISHNUPUR',	'795011',	1,	1,	1,	'2019-02-13 17:16:47',	'2019-02-13 17:16:47'),
(376,	34,	'CHURACHANDPUR',	'795006',	1,	1,	1,	'2019-02-13 17:16:47',	'2019-02-13 17:16:47'),
(377,	34,	'IMPHAL WEST',	'795001',	1,	1,	1,	'2019-02-13 17:16:47',	'2019-02-13 17:16:47'),
(378,	34,	'IMPHAL EAST',	'795114',	1,	1,	1,	'2019-02-13 17:16:47',	'2019-02-13 17:16:47'),
(379,	34,	'SENAPATI',	'795122',	1,	1,	1,	'2019-02-13 17:16:47',	'2019-02-13 17:16:47'),
(380,	34,	'THOUBAL',	'795130',	1,	1,	1,	'2019-02-13 17:16:47',	'2019-02-13 17:16:47'),
(381,	34,	'CHANDEL',	'795131',	1,	1,	1,	'2019-02-13 17:16:47',	'2019-02-13 17:16:47'),
(382,	34,	'TAMENGLONG',	'795159',	1,	1,	1,	'2019-02-13 17:16:47',	'2019-02-13 17:16:47'),
(383,	34,	'UKHRUL',	'795142',	1,	1,	1,	'2019-02-13 17:16:47',	'2019-02-13 17:16:47'),
(384,	34,	'TENGNOUPAL',	'795131',	1,	1,	1,	'2019-02-13 17:16:47',	'2019-02-13 17:16:47'),
(385,	34,	'KANGPOKPI',	'795122',	1,	1,	1,	'2019-02-13 17:16:47',	'2019-02-13 17:16:47'),
(386,	34,	'JARIBAM',	'795116',	1,	1,	1,	'2019-02-13 17:16:47',	'2019-02-13 17:16:47'),
(387,	34,	'KAKCHING',	'795101',	1,	1,	1,	'2019-02-13 17:16:47',	'2019-02-13 17:16:47'),
(388,	33,	'EAST KHASI HILLS',	'793018',	1,	1,	1,	'2019-02-13 17:17:54',	'2019-02-13 17:17:54'),
(389,	33,	'WEST GARO HILLS',	'794107',	1,	1,	1,	'2019-02-13 17:17:54',	'2019-02-13 17:17:54'),
(390,	33,	'EAST GARO HILLS',	'794110',	1,	1,	1,	'2019-02-13 17:17:54',	'2019-02-13 17:17:54'),
(391,	33,	'SOUTH GARO HILLS',	'794114',	1,	1,	1,	'2019-02-13 17:17:54',	'2019-02-13 17:17:54'),
(392,	33,	'WEST KHASI HILLS',	'793114',	1,	1,	1,	'2019-02-13 17:17:54',	'2019-02-13 17:17:54'),
(393,	33,	'RI BHOI',	'793102',	1,	1,	1,	'2019-02-13 17:17:54',	'2019-02-13 17:17:54'),
(394,	33,	'JAINTIA HILLS',	'793151',	1,	1,	1,	'2019-02-13 17:17:54',	'2019-02-13 17:17:54'),
(395,	19,	'NADIA',	'741139',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(396,	19,	'PURBA BARDHAMAN',	'713154',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(397,	19,	'BANKURA',	'713513',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(398,	19,	'NORTH 24 PARGANAS',	'700159',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(399,	19,	'KOLKATA',	'700015',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(400,	19,	'HOWRAH',	'711306',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(401,	19,	'PASCHIM BARDHAMAN',	'713208',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(402,	19,	'MURSHIDABAD',	'742238',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(403,	19,	'BIRBHUM',	'731304',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(404,	19,	'SOUTH 24 PARGANAS',	'700094',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(405,	19,	'ALIPURDUAR',	'736121',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(406,	19,	'BURDWAN',	'713104',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(407,	19,	'EAST MIDNAPORE',	'721454',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(408,	19,	'WEST MIDNAPORE',	'721424',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(409,	19,	'MALDA',	'732141',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(410,	19,	'DARJILING',	'734425',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(411,	19,	'HOOGHLY',	'712311',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(412,	19,	'MEDINIPUR',	'721101',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(413,	19,	'COOCH BEHAR',	'736101',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(414,	19,	'SOUTH DINAJPUR',	'733101',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(415,	19,	'JALPAIGURI',	'735101',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(416,	19,	'PURULIA',	'723101',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(417,	19,	'KALIMPONG',	'734314',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(418,	19,	'NORTH DINAJPUR',	'733156',	1,	1,	1,	'2019-02-13 17:18:57',	'2019-02-13 17:18:57'),
(490,	22,	'KANNAUJ',	'209728',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(491,	22,	'FARRUKHABAD',	'209503',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(492,	22,	'FATEHPUR',	'209503',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(493,	22,	'JAUNPUR',	'222165',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(494,	22,	'BAREILLY',	'243002',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(495,	22,	'MEERUT',	'250223',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(496,	22,	'GHAZIABAD',	'201009',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(497,	22,	'GAUTAM BUDDHA NAGAR',	'201303',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(498,	22,	'GHAZIPUR',	'275201',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(499,	22,	'VARANASI',	'221010',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(500,	22,	'RAEBARELI',	'229201',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(501,	22,	'FAIZABAD',	'224116',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(502,	22,	'LUCKNOW',	'226010',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(503,	22,	'BUDAUN',	'243636',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(504,	22,	'SAHARANPUR',	'247002',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(505,	22,	'ALIGARH',	'202001',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(506,	22,	'KHERI',	'262722',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(507,	22,	'BANDA',	'210203',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(508,	22,	'HAMIRPUR',	'210341',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(509,	22,	'MAHOBA',	'210433',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(510,	22,	'HATHRAS',	'204216',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(511,	22,	'SHRAWASTI',	'271803',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(512,	22,	'GORAKHPUR',	'273012',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(513,	22,	'HARDOI',	'241001',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(514,	22,	'BIJNOR',	'246701',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(515,	22,	'SHAHJAHANPUR',	'242001',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(516,	22,	'MUZAFFARNAGAR',	'247776',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(517,	22,	'KANPUR NAGAR',	'208017',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(518,	22,	'ALLAHABAD',	'211010',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(519,	22,	'MATHURA',	'281004',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(520,	22,	'KUSHINAGAR',	'274307',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(521,	22,	'HAPUR',	'245304',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(522,	22,	'SULTANPUR',	'228178',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(523,	22,	'KAUSHAMBI',	'212201',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(524,	22,	'BARABANKI',	'225401',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(525,	22,	'MIRZAPUR',	'231305',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(526,	22,	'SONBHADRA',	'231223',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(527,	22,	'SITAPUR',	'261001',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(528,	22,	'UNNAO',	'209860',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(529,	22,	'AGRA',	'282005',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(530,	22,	'BAHRAICH',	'271806',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(531,	22,	'DEORIA',	'274806',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(532,	22,	'MAHARAJGANJ',	'273311',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(533,	22,	'PRATAPGARH',	'230133',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(534,	22,	'MAU',	'275103',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(535,	22,	'MORADABAD',	'244104',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(536,	22,	'JHANSI',	'284001',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(537,	22,	'CHITRAKOOT',	'210205',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(538,	22,	'AZAMGARH',	'276140',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(539,	22,	'SIDDHARTHNAGAR',	'272207',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(540,	22,	'BALLIA',	'277001',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(541,	22,	'PILIBHIT',	'262001',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(542,	22,	'BASTI',	'272153',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(543,	22,	'BULANDSHAHR',	'203001',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(544,	22,	'ETAH',	'207001',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(545,	22,	'ETAWAH',	'206001',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(546,	22,	'AURAIYA',	'206122',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(547,	22,	'AMBEDKAR NAGAR',	'224122',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(548,	22,	'GONDA',	'271001',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(549,	22,	'BALRAMPUR',	'271201',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(550,	22,	'JALAUN',	'285001',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(551,	22,	'LALITPUR',	'284403',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(552,	22,	'MAINPURI',	'205001',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(553,	22,	'FIROZABAD',	'283203',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(554,	22,	'BAGPAT',	'250611',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(555,	22,	'RAMPUR',	'244901',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(556,	22,	'JYOTIBA PHULE NAGAR',	'244221',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(557,	22,	'SANT KABIR NAGAR',	'272154',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(558,	22,	'KANPUR DEHAT',	'209306',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(559,	22,	'CHANDAULI',	'232105',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(560,	22,	'SANT RAVIDAS NAGAR',	'221314',	1,	1,	1,	'2019-02-13 17:20:39',	'2019-02-13 17:20:39'),
(561,	32,	'AIZAWL',	'796161',	1,	1,	1,	'2019-03-10 23:43:42',	'2019-03-10 23:43:42'),
(562,	32,	'CHAMPHAI',	'796320',	1,	1,	1,	'2019-03-10 23:43:42',	'2019-03-10 23:43:42'),
(563,	32,	'KOLASIB',	'796101',	1,	1,	1,	'2019-03-10 23:43:42',	'2019-03-10 23:43:42'),
(564,	32,	'LAWNGTLAI',	'796891',	1,	1,	1,	'2019-03-10 23:43:42',	'2019-03-10 23:43:42'),
(565,	32,	'LUNGLEI',	'796691',	1,	1,	1,	'2019-03-10 23:43:42',	'2019-03-10 23:43:42'),
(566,	32,	'MAMIT',	'796441',	1,	1,	1,	'2019-03-10 23:43:42',	'2019-03-10 23:43:42'),
(567,	32,	'SAIHA',	'796901',	1,	1,	1,	'2019-03-10 23:43:42',	'2019-03-10 23:43:42'),
(568,	32,	'SERCHHIP',	'796181',	1,	1,	1,	'2019-03-10 23:43:42',	'2019-03-10 23:43:42'),
(569,	31,	'DIMAPUR',	'797115',	1,	1,	1,	'2019-03-10 23:44:47',	'2019-03-10 23:44:47'),
(570,	31,	'KIPHIRE',	'798611',	1,	1,	1,	'2019-03-10 23:44:47',	'2019-03-10 23:44:47'),
(571,	31,	'KOHIMA',	'797105',	1,	1,	1,	'2019-03-10 23:44:47',	'2019-03-10 23:44:47'),
(572,	31,	'LONGLENG',	'798625',	1,	1,	1,	'2019-03-10 23:44:47',	'2019-03-10 23:44:47'),
(573,	31,	'MOKOKCHUNG',	'798613',	1,	1,	1,	'2019-03-10 23:44:47',	'2019-03-10 23:44:47'),
(574,	31,	'MON',	'798603',	1,	1,	1,	'2019-03-10 23:44:47',	'2019-03-10 23:44:47'),
(575,	31,	'PEREN',	'797110',	1,	1,	1,	'2019-03-10 23:44:47',	'2019-03-10 23:44:47'),
(576,	31,	'PHEK',	'797104',	1,	1,	1,	'2019-03-10 23:44:47',	'2019-03-10 23:44:47'),
(577,	31,	'TUENSANG',	'798616',	1,	1,	1,	'2019-03-10 23:44:47',	'2019-03-10 23:44:47'),
(578,	31,	'WOKHA',	'797111',	1,	1,	1,	'2019-03-10 23:44:47',	'2019-03-10 23:44:47'),
(579,	31,	'ZUNHEBOTO',	'798620',	1,	1,	1,	'2019-03-10 23:44:47',	'2019-03-10 23:44:47'),
(580,	30,	'ANGUL',	'759040',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(581,	30,	'BALANGIR',	'767038',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(582,	30,	'BALESHWAR',	'756046',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(583,	30,	'BARGARH',	'768102',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(584,	30,	'BHADRAK',	'756129',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(585,	30,	'BOUDH',	'762017',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(586,	30,	'CUTTACK',	'753011',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(587,	30,	'DEBAGARH',	'768119',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(588,	30,	'DHENKANAL',	'759023',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(589,	30,	'GAJAPATI',	'761017',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(590,	30,	'GANJAM',	'761141',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(591,	30,	'JAGATSINGHPUR',	'754137',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(592,	30,	'JAJPUR',	'755049',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(593,	30,	'JHARSUGUDA',	'768220',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(594,	30,	'KALAHANDI',	'766027',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(595,	30,	'KANDHAMAL',	'762022',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(596,	30,	'KENDRAPARA',	'754217',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(597,	30,	'KENDUJHAR',	'758021',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(598,	30,	'KEONJHARGARH',	'758084',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(599,	30,	'KHORDA',	'754004',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(600,	30,	'KORAPUT',	'764055',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(601,	30,	'MALKANGIRI',	'764051',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(602,	30,	'MAYURBHANJ',	'757001',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(603,	30,	'NABARANGPUR',	'764070',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(604,	30,	'NAYAGARH',	'752082',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(605,	30,	'NUAPADA',	'766105',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(606,	30,	'PURI',	'752001',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(607,	30,	'RAYAGADA',	'765019',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(608,	30,	'SAMBALPUR',	'768107',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(609,	30,	'SONEPUR',	'767068',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(610,	30,	'SUNDERGARH',	'769011',	1,	1,	1,	'2019-03-10 23:45:36',	'2019-03-10 23:45:36'),
(611,	29,	'KARAIKAL',	'609605',	1,	1,	1,	'2019-03-10 23:46:17',	'2019-03-10 23:46:17'),
(612,	29,	'MAHE',	'673310',	1,	1,	1,	'2019-03-10 23:46:17',	'2019-03-10 23:46:17'),
(613,	29,	'PONDICHERRY',	'605010',	1,	1,	1,	'2019-03-10 23:46:17',	'2019-03-10 23:46:17'),
(614,	28,	'AMRITSAR',	'143002',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(615,	28,	'BARNALA',	'148101',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(616,	28,	'BATHINDA',	'151005',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(617,	28,	'FARIDKOT',	'151212',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(618,	28,	'FATEHGARH SAHIB',	'141411',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(619,	28,	'FAZILKA',	'152118',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(620,	28,	'FEROZEPUR',	'152116',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(621,	28,	'GURDASPUR',	'145001',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(622,	28,	'HOSHIARPUR',	'146001',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(623,	28,	'JALANDHAR',	'144102',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(624,	28,	'KAPURTHALA',	'144622',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(625,	28,	'LUDHIANA',	'141003',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(626,	28,	'MANSA',	'151501',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(627,	28,	'MOGA',	'142045',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(628,	28,	'MOHALI',	'140506',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(629,	28,	'MUKTASAR',	'152032',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(630,	28,	'NAWANSHAHR',	'144522',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(631,	28,	'PATHANKOT',	'145027',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(632,	28,	'PATIALA',	'147004',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(633,	28,	'ROPAR',	'140115',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(634,	28,	'RUPNAGAR',	'140126',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(635,	28,	'SANGRUR',	'148021',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(636,	28,	'TARN TARAN',	'143303',	1,	1,	1,	'2019-03-10 23:46:55',	'2019-03-10 23:46:55'),
(637,	27,	'AJMER',	'305926',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(638,	27,	'ALWAR',	'301001',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(639,	27,	'BANSWARA',	'327031',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(640,	27,	'BARAN',	'325221',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(641,	27,	'BARMER',	'344034',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(642,	27,	'BHARATPUR',	'321001',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(643,	27,	'BHILWARA',	'311301',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(644,	27,	'BIKANER',	'334305',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(645,	27,	'BUNDI',	'323001',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(646,	27,	'CHITTORGARH',	'326501',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(647,	27,	'CHURU',	'331501',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(648,	27,	'DAUSA',	'322240',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(649,	27,	'DHOLPUR',	'328031',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(650,	27,	'DUNGARPUR',	'314801',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(651,	27,	'HANUMANGARH',	'335064',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(652,	27,	'JAIPUR',	'303805',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(653,	27,	'JAISALMER',	'345024',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(654,	27,	'JALOR',	'307029',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(655,	27,	'JHALAWAR',	'326516',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(656,	27,	'JHUJHUNU',	'333705',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(657,	27,	'JODHPUR',	'342008',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(658,	27,	'KARAULI',	'322220',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(659,	27,	'KOTA',	'326518',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(660,	27,	'NAGAUR',	'341517',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(661,	27,	'PALI',	'306301',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(662,	27,	'RAJSAMAND',	'313202',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(663,	27,	'SAWAI MADHOPUR',	'322001',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(664,	27,	'SIKAR',	'332715',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(665,	27,	'SIROHI',	'307501',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(666,	27,	'SRI GANGANAGAR',	'335701',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(667,	27,	'TONK',	'304023',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(668,	27,	'UDAIPUR',	'313205',	1,	1,	1,	'2019-03-10 23:47:29',	'2019-03-10 23:47:29'),
(669,	26,	'EAST SIKKIM',	'737102',	1,	1,	1,	'2019-03-10 23:48:09',	'2019-03-10 23:48:09'),
(670,	26,	'NORTH SIKKIM',	'737116',	1,	1,	1,	'2019-03-10 23:48:09',	'2019-03-10 23:48:09'),
(671,	26,	'SOUTH SIKKIM',	'737128',	1,	1,	1,	'2019-03-10 23:48:09',	'2019-03-10 23:48:09'),
(672,	26,	'WEST SIKKIM',	'737111',	1,	1,	1,	'2019-03-10 23:48:09',	'2019-03-10 23:48:09'),
(673,	25,	'ARIYALUR',	'621802',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(674,	25,	'CHENNAI',	'600001',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(675,	25,	'COIMBATORE',	'624622',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(676,	25,	'CUDDALORE',	'607807',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(677,	25,	'DHARMAPURI',	'636807',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(678,	25,	'DINDIGUL',	'624304',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(679,	25,	'ERODE',	'638462',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(680,	25,	'KANCHIPURAM',	'603303',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(681,	25,	'KANYAKUMARI',	'629160',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(682,	25,	'KARUR',	'638151',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(683,	25,	'KRISHNAGIRI',	'635122',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(684,	25,	'MADURAI',	'625020',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(685,	25,	'NAGAPATTINAM',	'609301',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(686,	25,	'NAMAKKAL',	'638007',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(687,	25,	'NILGIRIS',	'643201',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(688,	25,	'PERAMBALUR',	'621106',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(689,	25,	'PUDUKKOTTAI',	'622422',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(690,	25,	'RAMANATHAPURAM',	'623403',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(691,	25,	'SALEM',	'636001',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(692,	25,	'SIVAGANGA',	'623701',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(693,	25,	'THANJAVUR',	'614803',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(694,	25,	'THENI',	'625513',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(695,	25,	'TIRUCHIRAPPALLI',	'621302',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(696,	25,	'TIRUNELVELI',	'627713',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(697,	25,	'TIRUPPUR',	'641604',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(698,	25,	'TIRUVALLUR',	'600087',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(699,	25,	'TIRUVANNAMALAI',	'632301',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(700,	25,	'TIRUVARUR',	'609403',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(701,	25,	'TUTICORIN',	'628502',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(702,	25,	'VELLORE',	'632403',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(703,	25,	'VILLUPURAM',	'607101',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(704,	25,	'VIRUDHUNAGAR',	'626101',	1,	1,	1,	'2019-03-10 23:48:57',	'2019-03-10 23:48:57'),
(705,	24,	'ADILABAD',	'504001',	1,	1,	1,	'2019-03-10 23:49:43',	'2019-03-10 23:49:43'),
(706,	24,	'HYDERABAD',	'500085',	1,	1,	1,	'2019-03-10 23:49:43',	'2019-03-10 23:49:43'),
(707,	24,	'JAYASHANKAR',	'506345',	1,	1,	1,	'2019-03-10 23:49:43',	'2019-03-10 23:49:43'),
(708,	24,	'K.V.RANGAREDDY',	'500060',	1,	1,	1,	'2019-03-10 23:49:43',	'2019-03-10 23:49:43'),
(709,	24,	'KARIM NAGAR',	'505001',	1,	1,	1,	'2019-03-10 23:49:43',	'2019-03-10 23:49:43'),
(710,	24,	'KHAMMAM',	'507001',	1,	1,	1,	'2019-03-10 23:49:43',	'2019-03-10 23:49:43'),
(711,	24,	'MAHABUB NAGAR',	'509357',	1,	1,	1,	'2019-03-10 23:49:43',	'2019-03-10 23:49:43'),
(712,	24,	'MAHABUBABAD',	'506103',	1,	1,	1,	'2019-03-10 23:49:43',	'2019-03-10 23:49:43'),
(713,	24,	'MEDAK',	'502110',	1,	1,	1,	'2019-03-10 23:49:43',	'2019-03-10 23:49:43'),
(714,	24,	'NALGONDA',	'508377',	1,	1,	1,	'2019-03-10 23:49:43',	'2019-03-10 23:49:43'),
(715,	24,	'NIZAMABAD',	'503302',	1,	1,	1,	'2019-03-10 23:49:43',	'2019-03-10 23:49:43'),
(716,	24,	'RAJANNA SIRCILLA',	'505302',	1,	1,	1,	'2019-03-10 23:49:43',	'2019-03-10 23:49:43'),
(717,	24,	'SIDDIPET',	'502301',	1,	1,	1,	'2019-03-10 23:49:43',	'2019-03-10 23:49:43'),
(718,	24,	'SURYAPET',	'508224',	1,	1,	1,	'2019-03-10 23:49:43',	'2019-03-10 23:49:43'),
(719,	24,	'WARANGAL',	'506001',	1,	1,	1,	'2019-03-10 23:49:43',	'2019-03-10 23:49:43'),
(720,	23,	'DHALAI',	'799285',	1,	1,	1,	'2019-03-10 23:50:20',	'2019-03-10 23:50:20'),
(721,	23,	'GOMATI',	'799013',	1,	1,	1,	'2019-03-10 23:50:20',	'2019-03-10 23:50:20'),
(722,	23,	'KHOWAI',	'799201',	1,	1,	1,	'2019-03-10 23:50:20',	'2019-03-10 23:50:20'),
(723,	23,	'NORTH TRIPURA',	'799290',	1,	1,	1,	'2019-03-10 23:50:20',	'2019-03-10 23:50:20'),
(724,	23,	'SIPAHIJALA',	'799132',	1,	1,	1,	'2019-03-10 23:50:20',	'2019-03-10 23:50:20'),
(725,	23,	'SOUTH TRIPURA',	'799142',	1,	1,	1,	'2019-03-10 23:50:20',	'2019-03-10 23:50:20'),
(726,	23,	'WEST TRIPURA',	'799207',	1,	1,	1,	'2019-03-10 23:50:20',	'2019-03-10 23:50:20'),
(727,	21,	'ALMORA',	'263629',	1,	1,	1,	'2019-03-10 23:54:04',	'2019-03-10 23:54:04'),
(728,	21,	'BAGESHWAR',	'263679',	1,	1,	1,	'2019-03-10 23:54:04',	'2019-03-10 23:54:04'),
(729,	21,	'CHAMOLI',	'246446',	1,	1,	1,	'2019-03-10 23:54:04',	'2019-03-10 23:54:04'),
(730,	21,	'CHAMPAWAT',	'262310',	1,	1,	1,	'2019-03-10 23:54:04',	'2019-03-10 23:54:04'),
(731,	21,	'DEHRADUN',	'248121',	1,	1,	1,	'2019-03-10 23:54:04',	'2019-03-10 23:54:04'),
(732,	21,	'HARIDWAR',	'249407',	1,	1,	1,	'2019-03-10 23:54:04',	'2019-03-10 23:54:04'),
(733,	21,	'NAINITAL',	'263139',	1,	1,	1,	'2019-03-10 23:54:04',	'2019-03-10 23:54:04'),
(734,	21,	'PAURI GARHWAL',	'246194',	1,	1,	1,	'2019-03-10 23:54:04',	'2019-03-10 23:54:04'),
(735,	21,	'PITHORAGARH',	'262547',	1,	1,	1,	'2019-03-10 23:54:04',	'2019-03-10 23:54:04'),
(736,	21,	'RUDRAPRAYAG',	'246448',	1,	1,	1,	'2019-03-10 23:54:04',	'2019-03-10 23:54:04'),
(737,	21,	'TEHRI GARHWAL',	'249122',	1,	1,	1,	'2019-03-10 23:54:04',	'2019-03-10 23:54:04'),
(738,	21,	'UDHAM SINGH NAGAR',	'263153',	1,	1,	1,	'2019-03-10 23:54:04',	'2019-03-10 23:54:04'),
(739,	21,	'UTTARKASHI',	'249195',	1,	1,	1,	'2019-03-10 23:54:04',	'2019-03-10 23:54:04');

DROP TABLE IF EXISTS `master_data`;
CREATE TABLE `master_data` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `datakey` varchar(100) NOT NULL,
  `datavalue` text NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `updated_by` (`updated_by`),
  KEY `datakey` (`datakey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `master_data` (`id`, `datakey`, `datavalue`, `updated_by`, `updated`) VALUES
(2,	'application_no_count',	'4',	0,	'2019-09-18 21:10:18'),
(4,	'gacode_head',	'dfcf',	1,	'2019-09-16 10:18:24'),
(5,	'gacode_body',	'sedcf',	1,	'2019-09-16 10:18:24'),
(6,	'gacode_key',	'edssdcs',	1,	'2019-09-16 10:18:24'),
(7,	'regotp_sms',	'',	1,	'2019-03-17 22:17:36'),
(8,	'regotp_email_sub',	'',	1,	'2019-03-17 22:17:36'),
(9,	'regotp_email',	'',	1,	'2019-03-17 22:17:36'),
(10,	'loginotp_sms',	'',	1,	'2019-03-17 22:13:52'),
(11,	'loginotp_email_sub',	'',	1,	'2019-03-17 22:13:52'),
(12,	'loginotp_email',	'',	1,	'2019-03-17 22:13:52'),
(21,	'sysid_sms',	'',	1,	'2019-03-17 23:54:17'),
(22,	'sysid_email_sub',	'',	1,	'2019-03-17 23:54:17'),
(23,	'sysid_email',	'',	1,	'2019-03-17 23:54:17');

DROP TABLE IF EXISTS `master_faq`;
CREATE TABLE `master_faq` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `question` varchar(200) NOT NULL,
  `ans` text NOT NULL,
  `cat_ids` varchar(500) NOT NULL,
  `disp_odr` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  KEY `disp_odr` (`disp_odr`),
  FULLTEXT KEY `question_ans` (`question`,`ans`),
  CONSTRAINT `faq_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `faq_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `master_faq` (`id`, `question`, `ans`, `cat_ids`, `disp_odr`, `status`, `created_by`, `updated_by`, `created`, `updated`) VALUES
(1,	'Faq1',	'<p>sdfvfs</p>',	'1',	1,	1,	1,	1,	'2019-09-16 12:39:24',	'2019-09-16 12:39:24');

DROP TABLE IF EXISTS `master_faq_cats`;
CREATE TABLE `master_faq_cats` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `master_faq_cats_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `master_faq_cats_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `master_faq_cats` (`id`, `title`, `status`, `created_by`, `updated_by`, `created`, `updated`) VALUES
(1,	'fAQ CAT1',	1,	1,	1,	'2019-09-16 12:38:47',	'2019-09-16 12:38:47');

DROP TABLE IF EXISTS `master_lead_remarks`;
CREATE TABLE `master_lead_remarks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` int(10) unsigned NOT NULL,
  `title` varchar(100) NOT NULL,
  `disp_odr` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `title` (`title`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  KEY `cat_id` (`cat_id`),
  CONSTRAINT `master_lead_remarks_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `master_lead_remarks_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `master_lead_remarks` (`id`, `cat_id`, `title`, `disp_odr`, `status`, `created_by`, `updated_by`, `created`, `updated`) VALUES
(1,	84,	'Disposition1',	1,	1,	1,	1,	'2019-09-18 22:05:57',	'2019-09-18 22:05:57'),
(2,	84,	'Disposition2',	2,	1,	1,	1,	'2019-09-18 22:11:53',	'2019-09-18 22:11:53');

DROP TABLE IF EXISTS `master_lead_remarks_cats`;
CREATE TABLE `master_lead_remarks_cats` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `disp_odr` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `title` (`title`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `master_lead_remarks_cats_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `master_lead_remarks_cats_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `master_lead_remarks_cats` (`id`, `title`, `disp_odr`, `status`, `created_by`, `updated_by`, `created`, `updated`) VALUES
(84,	'Category1',	1,	1,	1,	1,	'2019-04-14 15:08:56',	'2019-09-18 22:04:24'),
(85,	'Category2',	2,	1,	1,	1,	'2019-04-14 15:09:04',	'2019-09-18 22:04:35');

DROP TABLE IF EXISTS `master_lead_subremarks`;
CREATE TABLE `master_lead_subremarks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `remarks_id` int(10) unsigned NOT NULL,
  `title` varchar(100) NOT NULL,
  `disp_odr` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `title` (`title`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  KEY `remarks_id` (`remarks_id`),
  CONSTRAINT `master_lead_subremarks_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `master_lead_subremarks_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `master_lead_subremarks_ibfk_3` FOREIGN KEY (`remarks_id`) REFERENCES `master_lead_remarks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `master_lead_subremarks` (`id`, `remarks_id`, `title`, `disp_odr`, `status`, `created_by`, `updated_by`, `created`, `updated`) VALUES
(1,	1,	'Remarks1',	1,	1,	1,	1,	'2019-09-18 22:05:57',	'2019-09-18 22:05:57'),
(2,	1,	'Remarks2',	2,	1,	1,	1,	'2019-09-18 22:05:57',	'2019-09-18 22:05:57'),
(3,	1,	'Remarks3',	3,	1,	1,	1,	'2019-09-18 22:05:57',	'2019-09-18 22:05:57'),
(4,	1,	'Remarks4',	4,	1,	1,	1,	'2019-09-18 22:05:57',	'2019-09-18 22:05:57'),
(5,	2,	'Remarks2.1',	1,	1,	1,	1,	'2019-09-18 22:11:53',	'2019-09-18 22:11:53'),
(6,	2,	'Remarks2.2',	2,	1,	1,	1,	'2019-09-18 22:11:53',	'2019-09-18 22:11:53'),
(7,	2,	'Remarks2.3',	3,	1,	1,	1,	'2019-09-18 22:11:53',	'2019-09-18 22:11:53');

DROP TABLE IF EXISTS `master_programs`;
CREATE TABLE `master_programs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `eligibility` text NOT NULL,
  `highlights` text NOT NULL,
  `fee` decimal(14,2) NOT NULL,
  `image` varchar(100) NOT NULL,
  `brochure` varchar(100) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `master_programs` (`id`, `title`, `eligibility`, `highlights`, `fee`, `image`, `brochure`, `status`, `created_by`, `updated_by`, `created`, `updated`) VALUES
(1,	'Test Program1',	'',	'',	100.00,	'',	NULL,	1,	1,	1,	'2019-09-16 11:03:57',	'2019-09-16 11:03:57'),
(2,	'Test Program 2',	'',	'',	200.00,	'',	NULL,	1,	1,	1,	'2019-09-16 11:04:20',	'2019-09-18 09:53:33');

DROP TABLE IF EXISTS `master_states`;
CREATE TABLE `master_states` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `code` varchar(10) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `title` (`title`),
  KEY `code` (`code`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `master_states_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `master_states_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `master_states` (`id`, `title`, `code`, `status`, `created_by`, `updated_by`, `created`, `updated`) VALUES
(19,	'West Bengal',	'WB',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(21,	'Uttarakhand',	'UT',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(22,	'Uttar Pradesh',	'UP',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(23,	'Tripura',	'TR',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(24,	'Telangana',	'TS',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-03-13 00:47:17'),
(25,	'Tamil Nadu',	'TN',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(26,	'Sikkim',	'SK',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(27,	'Rajasthan',	'RJ',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(28,	'Punjab',	'PB',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(29,	'Puducherry',	'PY',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(30,	'Odisha',	'OR',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(31,	'Nagaland',	'NG',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(32,	'Mizoram',	'MZ',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(33,	'Meghalaya',	'ML',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(34,	'Manipur',	'MN',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(35,	'Maharashtra',	'MH',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(36,	'Madhya Pradesh',	'MP',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(37,	'Lakshadweep',	'LA',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(38,	'Kerala',	'KL',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(39,	'Karnataka',	'KA',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(40,	'Jharkhand',	'JH',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(41,	'Jammu and Kashmir',	'JK',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(42,	'Himachal Pradesh',	'HP',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(43,	'Haryana',	'HR',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(44,	'Gujarat',	'GJ',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(45,	'Goa',	'GA',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(46,	'Delhi',	'DL',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(47,	'Daman and Diu',	'DD',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(48,	'Dadra and Nagar Haveli',	'DN',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(49,	'Chhattisgarh',	'CH',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(50,	'Chandigarh',	'CT',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(51,	'Bihar',	'BR',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(52,	'Assam',	'AS',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(53,	'Arunachal Pradesh',	'AR',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(54,	'Andhra Pradesh',	'AP',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42'),
(55,	'Andaman and Nicobar',	'AN',	1,	1,	1,	'2019-02-07 07:55:42',	'2019-02-07 07:55:42');

DROP TABLE IF EXISTS `master_utm_sources`;
CREATE TABLE `master_utm_sources` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `medium` varchar(100) NOT NULL,
  `grp` varchar(100) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `title` (`title`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `master_utm_sources` (`id`, `title`, `medium`, `grp`, `status`, `created_by`, `updated_by`, `created`, `updated`) VALUES
(56,	'Google_Search',	'',	'Google Campaigns',	1,	1,	1,	'2019-01-25 02:51:13',	'2019-03-25 10:08:51'),
(57,	'Facebook',	'',	'Social Handles',	1,	1,	1,	'2019-01-25 02:55:22',	'2019-03-25 10:09:24'),
(58,	'College_Dunia',	'',	'Education Portals',	1,	1,	1,	'2019-02-01 11:26:14',	'2019-03-25 10:07:23'),
(59,	'College_Search',	'',	'Education Portals',	1,	1,	1,	'2019-02-01 11:26:21',	'2019-03-25 10:07:26'),
(60,	'Twigz_Network',	'',	'Education Portals',	1,	1,	1,	'2019-02-01 11:26:34',	'2019-03-25 10:09:15'),
(61,	'Google_Display',	'',	'Google Campaigns',	1,	1,	1,	'2019-02-01 11:26:50',	'2019-03-25 10:08:48'),
(63,	'Direct_Website',	'',	'Website & Microsites',	1,	0,	1,	'2019-02-20 10:03:25',	'2019-03-25 10:07:35'),
(65,	'SU_Microsite',	'',	'Website & Microsites',	1,	0,	1,	'2019-03-05 21:31:40',	'2019-03-25 10:07:51'),
(66,	'SU_Website',	'',	'Website & Microsites',	1,	0,	1,	'2019-03-06 08:54:33',	'2019-03-25 10:07:44'),
(67,	'SU_AMP_Pages',	'',	'Website & Microsites',	1,	0,	1,	'2019-03-11 23:13:30',	'2019-03-25 10:07:59'),
(68,	'SlotBooking',	'',	'Website & Microsites',	1,	0,	1,	'2019-03-12 17:40:19',	'2019-03-25 10:08:06'),
(69,	'Shiksha',	'',	'Education Portals',	1,	1,	1,	'2019-03-12 23:15:10',	'2019-03-25 10:08:26'),
(70,	'Slot_Booking',	'',	'Website & Microsites',	1,	1,	1,	'2019-03-12 23:15:10',	'2019-03-25 10:08:02'),
(71,	'GetMyUni',	'',	'Education Portals',	1,	1,	1,	'2019-03-12 23:15:10',	'2019-03-25 10:08:31'),
(72,	'WhatsApp',	'',	'Social Handles',	1,	1,	1,	'2019-03-12 23:15:10',	'2019-03-25 10:09:05'),
(73,	'SU_Blog',	'',	'Website & Microsites',	1,	1,	1,	'2019-03-12 23:15:10',	'2019-03-25 10:07:55'),
(74,	'SU_NxtStartup',	'',	'Website & Microsites',	1,	1,	1,	'2019-03-12 23:15:10',	'2019-03-25 10:07:47'),
(75,	'Google_Direct_Web',	'',	'Website & Microsites',	1,	0,	1,	'2019-03-13 12:00:40',	'2019-05-07 12:38:21'),
(76,	'aglasem',	'',	'Education Portals',	1,	0,	1,	'2019-03-16 22:14:58',	'2019-03-25 10:07:19'),
(77,	'Gmail_Ads',	'',	'Google Campaigns',	1,	0,	1,	'2019-03-28 01:35:57',	'2019-04-04 19:13:20'),
(78,	'LandingPages_2019',	'',	'Google Campaigns',	1,	0,	1,	'2019-04-01 18:34:07',	'2019-04-07 16:45:34'),
(79,	'Careers360',	'',	'Education Portals',	1,	1,	1,	'2019-04-04 15:25:16',	'2019-04-04 15:25:16'),
(80,	'BrowserPush_Notification',	'',	'Re-Marketing',	1,	0,	1,	'2019-04-09 11:22:06',	'2019-04-30 22:17:10'),
(81,	'Edu-Thrill',	'',	'Education Portals',	1,	0,	1,	'2019-04-15 12:56:57',	'2019-04-30 22:16:43'),
(82,	'youth4work',	'',	'Education Portals',	1,	0,	1,	'2019-04-23 14:29:56',	'2019-04-23 15:36:23'),
(83,	'Test_Leads',	'',	'Not Attributed Sources',	1,	0,	1,	'2019-04-24 16:48:09',	'2019-05-07 12:39:27'),
(84,	'AdmissionHelp',	'',	'Education Portals',	1,	0,	1,	'2019-04-25 16:35:55',	'2019-04-30 22:20:50'),
(85,	'SU_SMS',	'',	'Re-Marketing',	1,	0,	1,	'2019-04-26 17:18:18',	'2019-04-30 22:19:51'),
(86,	'College_Dunia_Shared',	'',	'Education Portals Shared Leads',	1,	0,	1,	'2019-04-28 15:42:51',	'2019-04-30 22:15:24'),
(87,	'Shiksha_Shared',	'',	'Education Portals Shared Leads',	1,	0,	1,	'2019-04-28 15:46:05',	'2019-04-30 22:15:50'),
(88,	'GetMyUni_Shared',	'',	'Education Portals Shared Leads',	1,	0,	1,	'2019-04-28 15:48:39',	'2019-04-30 22:15:36'),
(89,	'Bing_Search',	'',	'Bing Campaigns',	1,	0,	1,	'2019-04-30 16:06:46',	'2019-04-30 22:21:19'),
(90,	'SUAT_Website',	'',	'Website & Microsites',	1,	0,	1,	'2019-05-02 15:03:36',	'2019-05-06 09:07:48'),
(91,	'Instagram',	'',	'Social Handles',	1,	0,	1,	'2019-05-02 18:12:35',	'2019-05-15 02:14:34'),
(92,	'Google_Direct_LP',	'',	'Not Attributed Sources',	1,	1,	1,	'2019-05-06 00:14:05',	'2019-05-07 12:40:07'),
(94,	'YouTube',	'',	'Social Handles',	1,	0,	1,	'2019-05-24 22:54:08',	'2019-05-29 09:54:29'),
(95,	'Emailer',	'',	'Re-Marketing',	1,	0,	1,	'2019-05-27 16:42:31',	'2019-05-29 09:53:51'),
(96,	'SU_App',	'',	'Mobile Application',	1,	0,	1,	'2019-06-12 17:32:27',	'2019-06-15 15:17:21'),
(97,	'SMS_Campaign',	'',	'',	1,	0,	0,	'2019-07-16 00:13:52',	'2019-07-16 00:13:52');

DROP TABLE IF EXISTS `notifications`;
CREATE TABLE `notifications` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `msg` varchar(500) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `notifications_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `notifications_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `notifications` (`id`, `msg`, `status`, `created_by`, `updated_by`, `created`, `updated`) VALUES
(1,	'Hello',	1,	1,	1,	'2019-09-18 10:02:28',	'2019-09-18 10:02:28');

DROP TABLE IF EXISTS `system_modules`;
CREATE TABLE `system_modules` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `module_key` varchar(50) NOT NULL,
  `module` varchar(50) NOT NULL,
  `grp` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `system_modules` (`id`, `module_key`, `module`, `grp`) VALUES
(1,	'manage_users',	'Manage Users',	''),
(2,	'manage_masterdata',	'Manage Master Data',	''),
(4,	'manage_counselor',	'Manage Counselor',	'Leads'),
(10,	'manage_programs',	'Manage Center of Excellence',	''),
(20,	'manage_landing_pages',	'Manage Landing Pages',	''),
(30,	'manage_sources',	'Manage Sources',	''),
(50,	'manage_states_cities',	'Manage States & Cities',	''),
(55,	'manage_faq',	'Manage FAQ\'s',	''),
(59,	'lead_view',	'View Leads',	'Leads'),
(60,	'lead_add',	'Add Lead',	'Leads'),
(61,	'lead_edit',	'Edit Lead',	'Leads'),
(62,	'lead_delete',	'Delete Lead',	'Leads'),
(63,	'lead_download',	'Download Leads',	'Leads'),
(70,	'manage_issues',	'Patients Issues',	'Leads'),
(90,	'dashboard',	'Dashboard',	'Dashboard'),
(95,	'manage_notifications',	'Manage Notifications',	''),
(97,	'manage_templates',	'Manage Templates',	''),
(100,	'manage_files',	'Files Manager',	''),
(110,	'add_lead_remarks',	'Add Lead Remarks/Feedback',	'Leads'),
(119,	'view_lead_feedback',	'View Leads Feedback (ALL)',	'Leads'),
(120,	'view_lead_feedback_byyou',	'View Leads Feedback (By You/Your Team)',	'Leads'),
(121,	'manage_disposition',	'Manage Disposition',	''),
(140,	'lead_data_set',	'Leads Data Set',	'Leads'),
(150,	'callers_report',	'Callers Report (ALL)',	'Report'),
(151,	'callers_report_byyou',	'Callers Report (You/Callers Under You)',	'Report'),
(160,	'manage_campaigns',	'Manage Campaigns',	''),
(170,	'db_backup',	'Database Backup',	'');

DROP TABLE IF EXISTS `tmp_applicants`;
CREATE TABLE `tmp_applicants` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lpage_id` int(10) unsigned NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `mob` varchar(15) NOT NULL,
  `state_id` int(10) NOT NULL,
  `program_id` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  `utm_source` varchar(100) NOT NULL,
  `utm_campaign` varchar(200) NOT NULL,
  `utm_medium` varchar(200) NOT NULL,
  `utm_term` varchar(200) NOT NULL,
  `utm_content` varchar(200) NOT NULL,
  `utm_keyword` varchar(200) NOT NULL,
  `utm_placement` varchar(200) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `lpage_id` (`lpage_id`),
  KEY `state_id` (`state_id`),
  KEY `name` (`name`),
  KEY `email` (`email`),
  KEY `mob` (`mob`),
  KEY `created` (`created`),
  KEY `utm_source` (`utm_source`),
  KEY `program_id` (`program_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
  `type` enum('ADMIN','USER','PUBLISHER','CALLER','CALLER_MANAGER','REGIONAL_OFFICER') NOT NULL,
  `username` varchar(30) NOT NULL,
  `password` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `mobile` varchar(15) NOT NULL,
  `address` varchar(200) NOT NULL,
  `modules` varchar(200) NOT NULL,
  `data_set_id` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  `lead_restrict` tinyint(4) NOT NULL,
  `pass_text` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `username` (`username`),
  KEY `email` (`email`),
  KEY `type` (`type`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  KEY `parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `users` (`id`, `parent_id`, `type`, `username`, `password`, `email`, `name`, `mobile`, `address`, `modules`, `data_set_id`, `status`, `created_by`, `updated_by`, `created`, `updated`, `lead_restrict`, `pass_text`) VALUES
(1,	0,	'ADMIN',	'admin',	'c9dc2c598e5865ad03fc72f80d742a93515b15f0efd7cc20ce4e5850afe0af59',	'gaurav@sharda.ac.in',	'Super Admin',	'9560696566',	'',	'',	0,	1,	0,	1,	'2018-04-07 11:54:19',	'2019-03-30 11:18:52',	0,	''),
(2,	0,	'CALLER_MANAGER',	'',	'f480589d8f1b667416db73a0f300fb1bc2ea1c7ab497f1fe6a3ef5460886e3fb',	'test@test.com',	'Test',	'1213213333',	'',	'4',	1,	1,	1,	1,	'2019-09-16 10:23:46',	'2019-09-16 10:31:46',	0,	'');

-- 2019-10-13 10:20:13

Kontol Shell Bypass