-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `real_estate`
--

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

--
-- Table structure for table `agent_accounts`
--

CREATE TABLE `agent_accounts` (
  `id` int(11) NOT NULL,
  `business_name` varchar(255) NOT NULL,
  `person_name` varchar(255) NOT NULL,
  `bussiness_mobile` varchar(255) NOT NULL,
  `bussiness_email` varchar(255) NOT NULL,
  `business_type` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `register_date` date NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL,
  `NAME` varchar(255) NOT NULL,
  `ISO` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `NAME`, `ISO`) VALUES
(1, 'Inida', 'ind'),
(2, 'Afghanistan', 'AF'),
(3, 'Albania', 'AL'),
(4, 'Algeria', 'DZ'),
(5, 'American Samoa', 'AS'),
(6, 'Andorra', 'AD'),
(7, 'Angola', 'AO'),
(8, 'Anguilla', 'AI'),
(9, 'Antarctica', 'AQ'),
(10, 'Antigua and Barbuda', 'AG'),
(11, 'Argentina', 'AR'),
(12, 'Armenia', 'AM'),
(13, 'Aruba', 'AW'),
(14, 'Australia', 'AU'),
(15, 'Austria', 'AT'),
(16, 'Azerbaijan', 'AZ'),
(17, 'Bahamas', 'BS'),
(18, 'Bahrain', 'BH'),
(19, 'Bangladesh', 'BD'),
(20, 'Barbados', 'BB'),
(21, 'Belarus', 'BY'),
(22, 'Belgium', 'BE'),
(23, 'Belize', 'BZ'),
(24, 'Benin', 'BJ'),
(25, 'Bermuda', 'BM'),
(26, 'Bhutan', 'BT'),
(27, 'Bosnia and Herzegovina', 'BA'),
(28, 'Botswana', 'BW'),
(29, 'Bouvet Island', 'BV'),
(30, 'Brazil', 'BR'),
(31, 'British Indian Ocean Territory', 'IO'),
(32, 'Brunei Darussalam', 'BN'),
(33, 'Bulgaria', 'BG'),
(34, 'Burkina Faso', 'BF'),
(35, 'Burundi', 'BI'),
(36, 'Cambodia', 'KH'),
(37, 'Cameroon', 'CM'),
(38, 'Canada', 'CA'),
(39, 'Cape Verde', 'CV'),
(40, 'Cayman Islands', 'KY'),
(41, 'Central African Republic', 'CF'),
(42, 'Chad', 'TD'),
(43, 'Chile', 'CL'),
(44, 'China', 'CN'),
(45, 'Christmas Island', 'CX'),
(46, 'Cocos (Keeling) Islands', 'CC'),
(47, 'Colombia', 'CO'),
(48, 'Comoros', 'KM'),
(49, 'Congo', 'CG'),
(50, 'Cook Islands', 'CK'),
(51, 'Costa Rica', 'CR'),
(52, 'Croatia', 'HR'),
(53, 'Cuba', 'CU'),
(54, 'Cyprus', 'CY'),
(55, 'Czech Republic', 'CZ'),
(56, 'Denmark', 'DK'),
(57, 'Djibouti', 'DJ'),
(58, 'Dominica', 'DM'),
(59, 'Dominican Republic', 'DO'),
(60, 'Ecuador', 'EC'),
(61, 'Egypt', 'EG'),
(62, 'El Salvador', 'SV'),
(63, 'Equatorial Guinea', 'GQ'),
(64, 'Eritrea', 'ER'),
(65, 'Estonia', 'EE'),
(66, 'Ethiopia', 'ET'),
(67, 'Falkland Islands (Malvinas)', 'FK'),
(68, 'Faroe Islands', 'FO'),
(69, 'Fiji', 'FJ'),
(70, 'Finland', 'FI'),
(71, 'France', 'FR'),
(72, 'French Guiana', 'GF'),
(73, 'French Polynesia', 'PF'),
(74, 'French Southern Territories', 'TF'),
(75, 'Gabon', 'GA'),
(76, 'Gambia', 'GM'),
(77, 'Georgia', 'GE'),
(78, 'Germany', 'DE'),
(79, 'Ghana', 'GH'),
(80, 'Gibraltar', 'GI'),
(81, 'Greece', 'GR'),
(82, 'Greenland', 'GL'),
(83, 'Grenada', 'GD'),
(84, 'Guadeloupe', 'GP'),
(85, 'Guam', 'GU'),
(86, 'Guatemala', 'GT'),
(87, 'Guernsey', 'GG'),
(88, 'Guinea', 'GN'),
(89, 'Guinea-Bissau', 'GW'),
(90, 'Guyana', 'GY'),
(91, 'Haiti', 'HT'),
(92, 'Heard Island and McDonald Islands', 'HM'),
(93, 'Holy See (Vatican City State)', 'VA'),
(94, 'Honduras', 'HN'),
(95, 'Hong Kong', 'HK'),
(96, 'Hungary', 'HU'),
(97, 'Iceland', 'IS'),
(98, 'India', 'IN'),
(99, 'Indonesia', 'ID'),
(100, 'Iran', 'IR'),
(101, 'Iraq', 'IQ'),
(102, 'Ireland', 'IE'),
(103, 'Isle of Man', 'IM'),
(104, 'Israel', 'IL'),
(105, 'Italy', 'IT'),
(106, 'Jamaica', 'JM'),
(107, 'Japan', 'JP'),
(108, 'Jersey', 'JE'),
(109, 'Jordan', 'JO'),
(110, 'Kazakhstan', 'KZ'),
(111, 'Kenya', 'KE'),
(112, 'Kiribati', 'KI'),
(113, 'Kuwait', 'KW'),
(114, 'Kyrgyzstan', 'KG'),
(115, 'Lao Peoples Democratic Republic', 'LA'),
(116, 'Latvia', 'LV'),
(117, 'Lebanon', 'LB'),
(118, 'Lesotho', 'LS'),
(119, 'Liberia', 'LR'),
(120, 'Libya', 'LY'),
(121, 'Liechtenstein', 'LI'),
(122, 'Lithuania', 'LT'),
(123, 'Luxembourg', 'LU'),
(124, 'Macao', 'MO'),
(125, 'Madagascar', 'MG'),
(126, 'Malawi', 'MW'),
(127, 'Malaysia', 'MY'),
(128, 'Maldives', 'MV'),
(129, 'Mali', 'ML'),
(130, 'Malta', 'MT'),
(131, 'Marshall Islands', 'MH'),
(132, 'Martinique', 'MQ'),
(133, 'Mauritania', 'MR'),
(134, 'Mauritius', 'MU'),
(135, 'Mayotte', 'YT'),
(136, 'Mexico', 'MX'),
(137, 'Monaco', 'MC'),
(138, 'Mongolia', 'MN'),
(139, 'Montenegro', 'ME'),
(140, 'Montserrat', 'MS'),
(141, 'Morocco', 'MA'),
(142, 'Mozambique', 'MZ'),
(143, 'Myanmar', 'MM'),
(144, 'Namibia', 'NA'),
(145, 'Nauru', 'NR'),
(146, 'Nepal', 'NP'),
(147, 'Netherlands', 'NL'),
(148, 'New Caledonia', 'NC'),
(149, 'New Zealand', 'NZ'),
(150, 'Nicaragua', 'NI'),
(151, 'Niger', 'NE'),
(152, 'Nigeria', 'NG'),
(153, 'Niue', 'NU'),
(154, 'Norfolk Island', 'NF'),
(155, 'Northern Mariana Islands', 'MP'),
(156, 'Norway', 'NO'),
(157, 'Oman', 'OM'),
(158, 'Pakistan', 'PK'),
(159, 'Palau', 'PW'),
(160, 'Panama', 'PA'),
(161, 'Papua New Guinea', 'PG'),
(162, 'Paraguay', 'PY'),
(163, 'Peru', 'PE'),
(164, 'Philippines', 'PH'),
(165, 'Pitcairn', 'PN'),
(166, 'Poland', 'PL'),
(167, 'Portugal', 'PT'),
(168, 'Puerto Rico', 'PR'),
(169, 'Qatar', 'QA'),
(170, 'Romania', 'RO'),
(171, 'Russian Federation', 'RU'),
(172, 'Rwanda', 'RW'),
(173, 'Saint Kitts and Nevis', 'KN'),
(174, 'Saint Lucia', 'LC'),
(175, 'Saint Martin (French part)', 'MF'),
(176, 'Saint Pierre and Miquelon', 'PM'),
(177, 'Saint Vincent and the Grenadines', 'VC'),
(178, 'Samoa', 'WS'),
(179, 'San Marino', 'SM'),
(180, 'Sao Tome and Principe', 'ST'),
(181, 'Saudi Arabia', 'SA'),
(182, 'Senegal', 'SN'),
(183, 'Serbia', 'RS'),
(184, 'Seychelles', 'SC'),
(185, 'Sierra Leone', 'SL'),
(186, 'Singapore', 'SG'),
(187, 'Sint Maarten (Dutch part)', 'SX'),
(188, 'Slovakia', 'SK'),
(189, 'Slovenia', 'SI'),
(190, 'Solomon Islands', 'SB'),
(191, 'Somalia', 'SO'),
(192, 'South Africa', 'ZA'),
(193, 'South Georgia and the South Sandwich Islands', 'GS'),
(194, 'South Sudan', 'SS'),
(195, 'Spain', 'ES'),
(196, 'Sri Lanka', 'LK'),
(197, 'State of Palestine', 'PS'),
(198, 'Sudan', 'SD'),
(199, 'Suriname', 'SR'),
(200, 'Svalbard and Jan Mayen', 'SJ'),
(201, 'Swaziland', 'SZ'),
(202, 'Sweden', 'SE'),
(203, 'Switzerland', 'CH'),
(204, 'Syrian Arab Republic', 'SY'),
(205, 'Tajikistan', 'TJ'),
(206, 'Thailand', 'TH'),
(207, 'Timor-Leste', 'TL'),
(208, 'Togo', 'TG'),
(209, 'Tokelau', 'TK'),
(210, 'Tonga', 'TO'),
(211, 'Trinidad and Tobago', 'TT'),
(212, 'Tunisia', 'TN'),
(213, 'Turkey', 'TR'),
(214, 'Turkmenistan', 'TM'),
(215, 'Turks and Caicos Islands', 'TC'),
(216, 'Tuvalu', 'TV'),
(217, 'Uganda', 'UG'),
(218, 'Ukraine', 'UA'),
(219, 'United Arab Emirates', 'AE'),
(220, 'United Kingdom', 'GB'),
(221, 'United States', 'US'),
(222, 'United States Minor Outlying Islands', 'UM'),
(223, 'Uruguay', 'UY'),
(224, 'Uzbekistan', 'UZ'),
(225, 'Vanuatu', 'VU'),
(226, 'Viet Nam', 'VN'),
(227, 'Wallis and Futuna', 'WF'),
(228, 'Western Sahara', 'EH'),
(229, 'Yemen', 'YE'),
(230, 'Zambia', 'ZM'),
(231, 'Zimbabwe', 'ZW');

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

--
-- Table structure for table `district`
--

CREATE TABLE `district` (
  `id` int(11) NOT NULL,
  `district` varchar(30) NOT NULL DEFAULT '',
  `stateid` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `district`
--

INSERT INTO `district` (`id`, `district`, `stateid`) VALUES
(1, 'Araria', 4),
(2, 'Arwal', 4),
(3, 'Aurangabad', 4),
(4, 'Banka', 4),
(5, 'Begusarai', 4),
(6, 'Kaimur', 4),
(7, 'Bhagalpur', 4),
(8, 'Bhojpur ', 4),
(9, 'Buxar', 4),
(10, 'Darbhanga ', 4),
(11, 'East Champaran ', 4),
(12, 'Gaya', 4),
(13, 'Gopalganj', 4),
(14, 'Jamui', 4),
(15, 'Jehanabad', 4),
(16, 'Katihar', 4),
(17, 'Khagaria', 4),
(18, 'Kishanganj', 4),
(19, 'Lakhisarai', 4),
(20, 'Madhepura', 4),
(21, 'Madhubani', 4),
(22, 'Munger', 4),
(23, 'Muzaffarpur', 4),
(24, 'Nalanda', 4),
(25, 'Nawada', 4),
(26, 'Patna', 4),
(27, 'Purnea', 4),
(28, 'Rohtas', 4),
(29, 'Saharsa', 4),
(30, 'Samastipur', 4),
(31, 'Saran', 4),
(32, 'Sheikhpura', 4),
(33, 'Sheohar', 4),
(34, 'Sitamarhi', 4),
(35, 'Siwan', 4),
(36, 'Supaul', 4),
(37, 'Vaishali', 4),
(38, 'West Champaran', 4),
(39, 'Ranchi', 11),
(40, 'Deoghar', 11),
(41, 'Palamu', 11),
(42, 'Garhwa', 11),
(43, 'Latehar', 11),
(44, 'Chatara', 11),
(45, 'Hazaribagh', 11),
(46, 'Koderma', 11),
(47, 'Dhanbad', 11),
(48, 'Giridih', 11),
(49, 'Ramgarh', 11),
(50, 'Bokaro', 11),
(51, 'Lohardaga', 11),
(52, 'Gumla', 11),
(53, 'Simdega', 11),
(54, 'West Singhbhum', 11),
(55, 'Saraikela Kharsawan', 11),
(56, 'Dumka', 11),
(57, 'Jamtara', 11),
(58, 'Sahebganj', 11),
(59, 'Pakur', 11),
(60, 'Godda', 11),
(61, 'East Singhbhum', 11),
(62, 'Khunti', 11),
(63, 'Agra', 27),
(64, 'Aligarh', 27),
(65, 'Allahabad', 27),
(66, 'Ambedkar Nagar', 27),
(67, 'Faizabad', 27),
(69, 'Azamgarh', 27),
(70, 'Ballia', 27),
(71, 'Etawah', 27),
(72, 'Chitrakoot', 27),
(73, 'Chandauli', 27),
(74, 'Rangareddy', 1),
(75, 'East Godavari', 1),
(76, 'Guntur', 1),
(77, 'Krishna', 1),
(78, 'Visakhapatnam', 1),
(79, 'Chittoor', 1),
(80, 'Anantapur', 1),
(81, 'Kurnool', 1),
(82, 'Mahbubnagar', 1),
(83, 'Hyderabad', 1),
(84, 'West Godavari', 1),
(85, 'Karimnagar', 1),
(86, 'Warangal', 1),
(87, 'Nalgonda', 1),
(88, 'Prakasam', 1),
(89, 'Medak', 1),
(90, 'Sri Potti Sriramulu Nellore', 1),
(91, 'YSR', 1),
(92, 'Khammam', 1),
(93, 'Adilabad', 1),
(94, 'Srikakulam', 1),
(95, 'Nizamabad', 1),
(96, 'Vizianagaram', 1),
(97, 'Papumpare', 2),
(98, 'Changlang', 2),
(99, 'Lohit', 2),
(100, 'West Siang', 2),
(101, 'Tirap', 2),
(102, 'East Siang', 2),
(103, 'Kurung Kumey', 2),
(104, 'West Kameng', 2),
(105, 'Upper Subansiri', 2),
(106, 'Lower Subansiri', 2),
(107, 'East Kameng', 2),
(108, 'Lower Dibang Valley', 2),
(109, 'Tawang', 2),
(110, 'Upper Siang', 2),
(111, 'Anjaw', 2),
(112, 'Dibang Valley', 2),
(113, 'Nagaon', 3),
(114, 'Dhubri', 3),
(115, 'Sonitpur', 3),
(116, 'Cachar', 3),
(117, 'Barpeta', 3),
(118, 'Kamrup', 3),
(119, 'Tinsukia', 3),
(120, 'Dibrugarh', 3),
(121, 'Kamrup Metropolitan', 3),
(122, 'Karimganj', 3),
(123, 'Sivasagar', 3),
(124, 'Jorhat', 3),
(125, 'Golaghat', 3),
(126, 'Lakhimpur', 3),
(127, 'Goalpara', 3),
(128, 'Morigaon', 3),
(129, 'Karbi Anglong', 3),
(130, 'Baksa', 3),
(131, 'Darrang', 3),
(132, 'Kokrajhar', 3),
(133, 'Udalguri', 3),
(134, 'Nalbari', 3),
(135, 'Bongaigaon', 3),
(136, 'Dhemaji', 3),
(137, 'Hailakandi', 3),
(138, 'Chirang', 3),
(139, 'Dima Hasao', 3),
(140, 'Raipur', 5),
(141, 'Durg', 5),
(142, 'Bilaspur', 5),
(143, 'Surguja', 5),
(144, 'Janjgir Champa', 5),
(145, 'Rajnandgaon', 5),
(146, 'Raigarh', 5),
(147, 'Bastar', 5),
(148, 'Korba', 5),
(149, 'Mahasamund', 5),
(150, 'Jashpur', 5),
(151, 'Kabirdham', 5),
(152, 'Dhamtari', 5),
(153, 'Kanker', 5),
(154, 'Korea', 5),
(155, 'Dantewada', 5),
(156, 'Bijapur', 5),
(157, 'Narayanpur', 5),
(158, 'North West Delhi', 30),
(159, 'South Delhi', 30),
(160, 'West Delhi', 30),
(161, 'South West Delhi', 30),
(162, 'North East Delhi', 30),
(163, 'East Delhi', 30),
(164, 'North Delhi', 30),
(165, 'Central Delhi', 30),
(166, 'New Delhi', 30),
(167, 'North Goa', 6),
(168, 'South Goa', 6),
(169, 'Ahmadabad', 7),
(170, 'Surat', 7),
(171, 'Vadodara', 7),
(172, 'Rajkot', 7),
(173, 'Banaskantha', 7),
(174, 'Bhavnagar', 7),
(175, 'Junagadh', 7),
(176, 'Sabarkantha', 7),
(177, 'PanchMahal', 7),
(178, 'Kheda', 7),
(179, 'Jamnagar', 7),
(180, 'Dohad', 7),
(181, 'Anand', 7),
(182, 'Kachchh', 7),
(183, 'Mahesana', 7),
(184, 'Surendranagar', 7),
(185, 'Valsad', 7),
(186, 'Bharuch', 7),
(187, 'Amreli', 7),
(188, 'Gandhinagar', 7),
(189, 'Patan', 7),
(190, 'Navsari', 7),
(191, 'Tapi', 7),
(192, 'Narmada', 7),
(193, 'Porbandar', 7),
(194, 'The Dangs', 7),
(195, 'Faridabad', 8),
(196, 'Hisar', 8),
(197, 'Bhiwani', 8),
(198, 'Gurgaon', 8),
(199, 'Karnal', 8),
(200, 'Sonipat', 8),
(201, 'Jind', 8),
(202, 'Sirsa', 8),
(203, 'Yamunanagar', 8),
(204, 'Panipat', 8),
(205, 'Ambala', 8),
(206, 'Mewat', 8),
(207, 'Kaithal', 8),
(208, 'Rohtak', 8),
(209, 'Palwal', 8),
(210, 'Kurukshetra', 8),
(211, 'Jhajjar', 8),
(212, 'Fatehabad', 8),
(213, 'Mahendragarh', 8),
(214, 'Rewari', 8),
(215, 'Panchkula', 8),
(216, 'Kangra', 9),
(217, 'Mandi', 9),
(218, 'Shimla', 9),
(219, 'Solan', 9),
(220, 'Sirmaur', 9),
(221, 'Una', 9),
(222, 'Chamba', 9),
(223, 'Hamirpur', 9),
(224, 'Kullu', 9),
(225, 'Bilaspur', 9),
(226, 'Kinnaur', 9),
(227, 'Lahul and Spiti', 9),
(228, 'Jammu', 10),
(229, 'Srinagar', 10),
(230, 'Anantnag', 10),
(231, 'Baramula', 10),
(232, 'Badgam', 10),
(233, 'Rajouri', 10),
(234, 'Kathua', 10),
(235, 'Pulwama', 10),
(236, 'Udhampur', 10),
(237, 'Punch', 10),
(238, 'Kulgam', 10),
(239, 'Doda', 10),
(240, 'Bandipora', 10),
(241, 'Samba', 10),
(242, 'Reasi', 10),
(243, 'Ganderbal', 10),
(244, 'Ramban', 10),
(245, 'Shupiyan', 10),
(246, 'Kishtwar', 10),
(247, 'Kargil', 10),
(248, 'Leh', 10),
(249, 'Bangalore', 12),
(250, 'Belgaum', 12),
(251, 'Mysore', 12),
(252, 'Tumkur', 12),
(253, 'Bellary', 12),
(254, 'Bijapur', 12),
(255, 'Dakshina Kannada', 12),
(256, 'Davanagere', 12),
(257, 'Raichur', 12),
(258, 'Bagalkot', 12),
(259, 'Dharwad', 12),
(260, 'Mandya', 12),
(261, 'Hassan', 12),
(262, 'Shimoga', 12),
(263, 'Bidar', 12),
(264, 'Chitradurga', 12),
(265, 'Haveri', 12),
(266, 'Kolar', 12),
(267, 'Uttara Kannada', 12),
(268, 'Koppal', 12),
(269, 'Chikkaballapura', 12),
(270, 'Udupi', 12),
(271, 'Yadgir', 12),
(272, 'Chikmagalur', 12),
(273, 'Ramanagara', 12),
(274, 'Gadag', 12),
(275, 'Chamarajanagar', 12),
(276, 'Bangalore Rural', 12),
(277, 'Kodagu', 12),
(278, 'Malappuram', 13),
(279, 'Thiruvananthapuram', 13),
(280, 'Ernakulam', 13),
(281, 'Thrissur', 13),
(282, 'Kozhikode', 13),
(283, 'Palakkad', 13),
(284, 'Kollam', 13),
(285, 'Kannur', 13),
(286, 'Alappuzha', 13),
(287, 'Kottayam', 13),
(288, 'Kasaragod', 13),
(289, 'Pathanamthitta', 13),
(290, 'Idukki', 13),
(291, 'Wayanad', 13),
(292, 'Indore', 14),
(293, 'Jabalpur', 14),
(294, 'Sagar', 14),
(295, 'Bhopal', 14),
(296, 'Rewa', 14),
(297, 'Satna', 14),
(298, 'Dhar', 14),
(299, 'Chhindwara', 14),
(300, 'Gwalior', 14),
(301, 'Ujjain', 14),
(302, 'Morena', 14),
(303, 'West Nimar', 14),
(304, 'Chhattarpur', 14),
(305, 'Shivpuri', 14),
(306, 'Bhind', 14),
(307, 'Balaghat', 14),
(308, 'Betul', 14),
(309, 'Dewas', 14),
(310, 'Rajgarh', 14),
(311, 'Ratlam', 14),
(312, 'Vidisha', 14),
(313, 'Tikamgarh', 14),
(314, 'Barwani', 14),
(315, 'Seoni', 14),
(316, 'Raisen', 14),
(317, 'Sehore', 14),
(318, 'Mandsaur', 14),
(319, 'Katni', 14),
(320, 'East Nimar', 14),
(321, 'Damoh', 14),
(322, 'Hoshangabad', 14),
(323, 'Singrauli', 14),
(324, 'Sidhi', 14),
(325, 'Guna', 14),
(326, 'Shahdol', 14),
(327, 'Mandla', 14),
(328, 'Jhabua', 14),
(329, 'Panna', 14),
(330, 'Ashoknagar', 14),
(331, 'Neemuch', 14),
(332, 'Datia', 14),
(333, 'Burhanpur', 14),
(334, 'Anuppur', 14),
(335, 'Alirajpur', 14),
(336, 'Dindori', 14),
(337, 'Sheopur', 14),
(338, 'Umaria', 14),
(339, 'Harda', 14),
(340, 'Thane', 15),
(341, 'Pune', 15),
(342, 'Mumbai Suburban', 15),
(343, 'Nashik', 15),
(344, 'agpur', 15),
(345, 'Nagpur', 15),
(346, 'Ahmadnagar', 15),
(347, 'Solapur', 15),
(348, 'Jalgaon', 15),
(349, 'Kolhapur', 15),
(350, 'Aurangabad', 15),
(351, 'Nanded', 15),
(352, 'Mumbai City', 15),
(353, 'Satara', 15),
(354, 'Amravati', 15),
(355, 'Sangli', 15),
(356, 'Yavatmal', 15),
(357, 'Raigarh', 15),
(358, 'Buldana', 15),
(359, 'Bid', 15),
(360, 'Latur', 15),
(361, 'Chandrapur', 15),
(362, 'Dhule', 15),
(363, 'Jalna', 15),
(364, 'Parbhani', 15),
(365, 'Akola', 15),
(366, 'Osmanabad', 15),
(367, 'Nandurbar', 15),
(368, 'Ratnagiri', 15),
(369, 'Gondiya', 15),
(370, 'Wardha', 15),
(371, 'Bhandara', 15),
(372, 'Washim', 15),
(373, 'Hingoli', 15),
(374, 'Gadchiroli', 15),
(375, 'Sindhudurg', 15),
(376, 'Imphal West', 16),
(377, 'Senapati', 16),
(378, 'Imphal East', 16),
(379, 'Thoubal', 16),
(380, 'Churachandpur', 16),
(381, 'Bishnupur', 16),
(382, 'Ukhrul', 16),
(383, 'Chandel', 16),
(384, 'Tamenglong', 16),
(385, 'East Khasi Hills', 17),
(386, 'West Garo Hills', 17),
(387, 'Jaintia Hills', 17),
(388, 'West Khasi Hills', 17),
(389, 'East Garo Hills', 17),
(390, 'Ri Bhoi', 17),
(391, 'South Garo Hills', 17),
(392, 'Aizawl', 18),
(393, 'Lunglei', 18),
(394, 'Champhai', 18),
(395, 'Lawngtlai', 18),
(396, 'Mamit', 18),
(397, 'Kolasib', 18),
(398, 'Serchhip', 18),
(399, 'Saiha', 18),
(400, 'Dimapur', 19),
(401, 'Kohima', 19),
(402, 'Mon', 19),
(403, 'Tuensang', 19),
(404, 'Mokokchung', 19),
(405, 'Wokha', 19),
(406, 'Phek', 19),
(407, 'Zunheboto', 19),
(408, 'Peren', 19),
(409, 'Kiphire', 19),
(410, 'Longleng', 19),
(411, 'Ganjam', 20),
(412, 'Cuttack', 20),
(413, 'Mayurbhanj', 20),
(414, 'Baleshwar', 20),
(415, 'Khordha', 20),
(416, '	Sundargarh', 20),
(417, 'Jajapur', 20),
(418, 'Kendujhar', 20),
(419, 'Puri', 20),
(420, 'Balangir', 20),
(421, 'Kalahandi', 20),
(422, 'Bhadrak', 20),
(423, 'Bargarh', 20),
(424, 'Kendrapara', 20),
(425, 'Koraput', 20),
(426, 'Anugul', 20),
(427, 'Nabarangapur	', 20),
(428, 'Dhenkanal', 20),
(429, 'Jagatsinghapur', 20),
(430, 'Sambalpur', 20),
(431, 'Rayagada', 20),
(432, 'Nayagarh', 20),
(433, 'Kandhamal', 20),
(434, 'Malkangiri', 20),
(435, 'Nuapada', 20),
(436, 'Subarnapur', 20),
(437, 'Jharsuguda', 20),
(438, 'Gajapati', 20),
(439, 'Baudh', 20),
(440, 'Debagarh', 20),
(441, 'Ludhiana', 21),
(442, 'Amritsar', 21),
(443, 'Gurdaspur', 21),
(444, 'Jalandhar', 21),
(445, 'Firozpur', 21),
(446, 'Patiala', 21),
(447, 'Sangrur', 21),
(448, 'Hoshiarpur', 21),
(449, 'Bathinda', 21),
(450, 'Tarn Taran', 21),
(451, 'Moga', 21),
(452, 'Mohali', 21),
(453, 'Muktsar', 21),
(454, 'Kapurthala', 21),
(455, 'Mansa', 21),
(456, 'Rupnagar', 21),
(457, 'Faridkot', 21),
(458, 'Shahid Bhagat Singh Nagar', 21),
(459, 'Fatehgarh Sahib', 21),
(460, 'Barnala', 21),
(461, 'Jaipur', 22),
(462, 'Jodhpur', 22),
(463, 'Alwar', 22),
(464, 'Nagaur', 22),
(465, 'Udaipur', 22),
(466, 'Sikar', 22),
(467, 'Barmer', 22),
(468, 'Ajmer', 22),
(469, 'Bharatpur', 22),
(470, 'Bhilwara', 22),
(471, 'Bikaner', 22),
(472, 'Jhunjhunun', 22),
(473, 'Churu', 22),
(474, 'Pali', 22),
(475, 'Ganganagar', 22),
(476, 'Kota', 22),
(477, 'Jalor', 22),
(478, 'Banswara', 22),
(479, 'Hanumangarh', 22),
(480, 'Dausa', 22),
(481, 'Chittaurgarh', 22),
(482, 'Karauli', 22),
(483, 'Tonk', 22),
(484, 'Jhalawar', 22),
(485, 'Dungarpur', 22),
(486, 'Sawai Madhopur', 22),
(487, 'Baran', 22),
(488, 'Dhaulpur', 22),
(489, 'Rajsamand', 22),
(490, 'Bundi', 22),
(491, 'Sirohi', 22),
(492, 'Pratapgarh', 22),
(493, 'Jaisalmer', 22),
(494, 'East Sikkim', 23),
(495, 'South Sikkim', 23),
(496, 'West Sikkim', 23),
(497, 'North Sikkim', 23),
(498, 'Chennai', 24),
(499, 'Kancheepuram', 24),
(500, 'Vellore', 24),
(501, 'Thiruvallur', 24),
(502, 'Salem', 24),
(503, 'Viluppuram', 24),
(504, 'Coimbatore', 24),
(505, 'Tirunelveli', 24),
(506, 'Madurai', 24),
(507, 'Tiruchirappalli', 24),
(508, 'Cuddalore', 24),
(509, 'Tiruppur', 24),
(510, 'Tiruvannamalai', 24),
(511, 'Thanjavur', 24),
(512, 'Erode', 24),
(513, 'Dindigul', 24),
(514, 'Virudhunagar', 24),
(515, 'Krishnagiri', 24),
(516, 'Kanniyakumari', 24),
(517, 'Thoothukkudi', 24),
(518, 'Namakkal', 24),
(519, 'Pudukkottai', 24),
(520, 'Nagapattinam', 24),
(521, 'Dharmapuri', 24),
(522, 'Ramanathapuram', 24),
(523, 'Sivaganga', 24),
(524, 'Thiruvarur', 24),
(525, 'Theni', 24),
(526, 'Karur', 24),
(527, 'Ariyalur', 24),
(528, 'The Nilgiris', 24),
(529, 'Perambalur', 24),
(530, 'Adilabad', 25),
(531, 'Bhadradri Kothagudem', 25),
(532, 'Hyderabad', 25),
(533, 'Jagtial', 25),
(534, 'Jangaon', 25),
(535, 'Jayashankar Bhupalapally', 25),
(536, 'Jogulamba Gadwal', 25),
(537, 'Kamareddy', 25),
(538, 'Karimnagar', 25),
(539, 'Khammam', 25),
(540, 'Kumarambheem Asifabad', 25),
(541, 'Mahabubabad', 25),
(542, 'Mahabubnagar', 25),
(543, 'Mancherial', 25),
(544, 'Medak', 25),
(545, 'Medchal?Malkajgiri[2]', 25),
(546, 'Nagarkurnool', 25),
(547, 'Nalgonda', 25),
(548, 'Nirmal', 25),
(549, 'Nizamabad', 25),
(550, 'Peddapalli', 25),
(551, 'Rajanna Sircilla', 25),
(552, 'Ranga Reddy', 25),
(553, 'Sangareddy', 25),
(554, 'Siddipet', 25),
(555, 'Suryapet', 25),
(556, 'Vikarabad[3]', 25),
(557, 'Wanaparthy', 25),
(558, 'Warangal Rural', 25),
(559, 'Warangal Urban', 25),
(560, 'Yadadri Bhuvanagiri', 25),
(561, 'West Tripura', 26),
(562, 'South Tripura', 26),
(563, 'North Tripura', 26),
(564, 'Dhalai', 26),
(565, 'Moradabad', 27),
(566, 'Ghaziabad', 27),
(568, 'Lucknow', 27),
(569, 'Kanpur Nagar', 27),
(570, 'Jaunpur', 27),
(571, 'Sitapur', 27),
(572, 'Bareilly', 27),
(573, 'Gorakhpur', 27),
(575, 'Muzaffarnagar', 27),
(576, 'Hardoi', 27),
(577, 'Kheri', 27),
(578, 'Sultanpur', 27),
(579, 'Bijnor', 27),
(580, 'Budaun', 27),
(581, 'Varanasi', 27),
(583, 'Ghazipur', 27),
(584, 'Kushinagar', 27),
(585, 'Bulandshahar', 27),
(586, 'Bahraich', 27),
(587, 'Saharanpur', 27),
(588, 'Meerut', 27),
(589, 'Gonda', 27),
(590, 'Rae Bareli', 27),
(591, 'Barabanki', 27),
(593, 'Pratapgarh', 27),
(594, 'Unnao', 27),
(595, 'Deoria', 27),
(596, 'Shahjahanpur', 27),
(597, 'Maharajganj', 27),
(598, 'Fatehpur', 27),
(599, 'Siddharth Nagar', 27),
(600, 'Mathura', 27),
(601, 'Firozabad', 27),
(602, 'Mirzapur', 27),
(604, 'Basti', 27),
(606, 'Rampur', 27),
(607, 'Mau', 27),
(608, 'Balrampur', 27),
(609, 'Pilibhit', 27),
(610, 'Jhansi', 27),
(612, 'Farrukhabad', 27),
(613, 'Mainpuri', 27),
(614, 'Sonbhadra', 27),
(615, 'Jyotiba Phule Nagar', 27),
(616, 'Banda', 27),
(617, 'Ramabai Nagar', 27),
(618, 'Etah', 27),
(619, 'Sant Kabir Nagar', 27),
(620, 'Jalaun', 27),
(621, 'Kannauj', 27),
(622, 'Gautam Buddha Nagar', 27),
(623, 'Kaushambi', 27),
(625, 'Sant Ravidas Nagar', 27),
(626, 'Mahamaya Nagar', 27),
(627, 'Kanshiram Nagar', 27),
(628, 'Auraiya', 27),
(629, 'Baghpat', 27),
(630, 'Lalitpur', 27),
(631, 'Shrawasti', 27),
(632, 'Hamirpur', 27),
(634, 'Mahoba', 27),
(635, 'Haridwar', 28),
(636, 'Dehradun', 28),
(637, 'Udham Singh Nagar', 28),
(638, 'Nainital', 28),
(639, 'Pauri Garhwal', 28),
(640, 'Almora', 28),
(641, 'Tehri Garhwal', 28),
(642, 'Pithoragarh', 28),
(643, 'Chamoli', 28),
(644, 'Uttarkashi', 28),
(645, 'Bageshwar', 28),
(646, 'Champawat', 28),
(647, 'Rudraprayag', 28),
(648, 'North Twenty Four Parganas', 29),
(649, 'South Twenty Four Parganas', 29),
(650, 'Barddhaman', 29),
(651, 'Murshidabad', 29),
(652, 'Paschim Medinipur', 29),
(653, 'Hugli', 29),
(654, 'Nadia', 29),
(655, 'Purba Medinipur', 29),
(656, 'Haora', 29),
(657, 'Kolkata', 29),
(658, 'Maldah', 29),
(659, 'Jalpaiguri', 29),
(660, 'Bankura', 29),
(661, 'Birbhum', 29),
(662, 'Uttar Dinajpur', 29),
(663, 'Puruliya', 29),
(664, 'Koch Bihar', 29),
(665, 'Darjiling', 29),
(666, 'Dakshin Dinajpur', 29);

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

--
-- Table structure for table `master_amenities`
--

CREATE TABLE `master_amenities` (
  `id` int(11) NOT NULL,
  `amenities_name` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master_amenities`
--

INSERT INTO `master_amenities` (`id`, `amenities_name`, `status`, `created_at`) VALUES
(1, 'parking', 1, '2024-12-13 17:04:40'),
(3, 'gym', 0, '2024-12-13 17:13:05'),
(4, 'pool', 0, '2024-12-13 17:13:14'),
(5, 'Meal and shelter facilities', 1, '2024-12-13 17:14:47'),
(6, 'Toilets', 1, '2024-12-13 17:14:56');

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

--
-- Table structure for table `master_category`
--

CREATE TABLE `master_category` (
  `id` int(11) NOT NULL,
  `property_category_name` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master_category`
--

INSERT INTO `master_category` (`id`, `property_category_name`, `status`, `created_at`) VALUES
(1, 'Residental', 1, '2024-12-13 12:38:18'),
(3, 'Commercial', 1, '2024-12-13 13:35:59');

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

--
-- Table structure for table `master_property_type`
--

CREATE TABLE `master_property_type` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `property_type_name` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master_property_type`
--

INSERT INTO `master_property_type` (`id`, `category_id`, `property_type_name`, `status`, `created_at`) VALUES
(1, 1, 'Rent', 1, '2024-12-13 15:55:42'),
(2, 1, 'sell', 1, '2024-12-13 15:55:54'),
(3, 1, 'pg-co-living', 1, '2024-12-13 15:56:12'),
(4, 3, 'Office', 1, '2024-12-13 15:56:57'),
(5, 3, 'Retail Shop', 1, '2024-12-13 15:57:08'),
(6, 3, 'Showroom', 1, '2024-12-13 15:57:19'),
(7, 3, 'Warehouse', 1, '2024-12-13 15:57:33'),
(8, 3, 'Plot', 1, '2024-12-13 15:57:46'),
(10, 3, 'Others', 1, '2024-12-13 16:19:45');

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

--
-- Table structure for table `role`
--

CREATE TABLE `role` (
  `id` int(11) NOT NULL,
  `role_name` varchar(255) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `role`
--

INSERT INTO `role` (`id`, `role_name`, `status`) VALUES
(1, 'superadmin', 1);

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

--
-- Table structure for table `state`
--

CREATE TABLE `state` (
  `id` int(11) NOT NULL,
  `state` varchar(30) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `state`
--

INSERT INTO `state` (`id`, `state`) VALUES
(1, 'Andhra Pradesh'),
(2, 'Arunachal Pradesh'),
(3, 'Assam'),
(4, 'Bihar'),
(5, 'Chhattisgarh'),
(6, 'Goa'),
(7, 'Gujarat'),
(8, 'Haryana'),
(9, 'Himachal Pradesh'),
(10, 'Jammu & Kashmir'),
(11, 'Jharkhand'),
(12, 'Karnataka'),
(13, 'Kerala'),
(14, 'Madhya Pradesh'),
(15, 'Maharashtra'),
(16, 'Manipur'),
(17, 'Meghalaya'),
(18, 'Mizoram'),
(19, 'Nagaland'),
(20, 'Odisha (Orissa)'),
(21, 'Punjab'),
(22, 'Rajasthan'),
(23, 'Sikkim'),
(24, 'Tamil Nadu'),
(25, 'Telangana'),
(26, 'Tripura'),
(27, 'Uttar Pradesh'),
(28, 'Uttarakhand'),
(29, 'West Bengal'),
(30, 'Delhi');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `agent_accounts`
--
ALTER TABLE `agent_accounts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `state`
--
ALTER TABLE `state`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
COMMIT;

