API tools faq
paste
Advertisement
Virajsinh

state_dist_sub_dist_language.sql

Virajsinh
Apr 11th, 2023 (edited)
1,276
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 47.11 KB | Source Code | 0 0
raw download clone embed print report
  1. -- FILE_NAME : state_dist_sub_dist_language.sql
  2.  
  3. -- phpMyAdmin SQL Dump
  4. -- version 5.2.0
  5. -- https://www.phpmyadmin.net/
  6. --
  7. -- Host: localhost
  8. -- Generation Time: Apr 11, 2023 at 07:12 AM
  9. -- Server version: 10.4.21-MariaDB
  10. -- PHP Version: 7.4.29
  11.  
  12. -- Reference Link https://www.viewvillage.in/districts/gujarat-24
  13. -- Reference Link https://www.mapsofindia.com/villages/gujarat/
  14. -- Reference Link https://villageinfo.in/gujarat.html
  15.  
  16. START TRANSACTION;
  17. -- --------------------------------------------------------
  18.  
  19. --
  20. -- Table structure for table `tbl_state`
  21. --
  22.  
  23. CREATE TABLE `tbl_state` (
  24.   `state_id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  25.   `state_code` varchar(2) NOT NULL,
  26.   `state_name` varchar(35) NOT NULL,
  27.   `state_name_guj` varchar(255) DEFAULT NULL,
  28.   `state_name_hin` varchar(255) DEFAULT NULL,
  29.   `status` enum('active','inactive') NOT NULL DEFAULT 'inactive',
  30.   `created_by` int(11) DEFAULT NULL,
  31.   `updated_by` int(11) DEFAULT NULL,
  32.   `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  33.   `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
  34. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  35.  
  36. --
  37. -- Dumping data for table `tbl_state`
  38. --
  39.  
  40. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`, `state_name_guj`, `state_name_hin`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
  41. (NULL, 'AN', 'Andaman and Nicobar Islands', 'આંદામાન અને નિકોબાર ટાપુઓ', 'अंडमान व नोकोबार द्वीप समूह', 'inactive', NULL, NULL, current_timestamp(), NULL),
  42. (NULL, 'AP', 'Andhra Pradesh', 'આંધ્ર પ્રદેશ', 'आंध्र प्रदेश', 'inactive', NULL, NULL, current_timestamp(), NULL),
  43. (NULL, 'AR', 'Arunachal Pradesh', 'અરુણાચલ પ્રદેશ', 'अरुणाचल प्रदेश', 'inactive', NULL, NULL, current_timestamp(), NULL),
  44. (NULL, 'AS', 'Assam', 'આસામ', 'असम', 'inactive', NULL, NULL, current_timestamp(), NULL),
  45. (NULL, 'BR', 'Bihar', 'બિહાર', 'बिहार', 'inactive', NULL, NULL, current_timestamp(), NULL),
  46. (NULL, 'CG', 'Chandigarh', 'ચંડીગઢ', 'चंडीगढ़', 'inactive', NULL, NULL, current_timestamp(), NULL),
  47. (NULL, 'CH', 'Chhattisgarh', 'છત્તીસગઢ', 'छत्तीसगढ', 'inactive', NULL, NULL, current_timestamp(), NULL),
  48. (NULL, 'DN', 'Dadra and Nagar Haveli', 'દાદરા અને નગર હવેલી', 'दादरा और नगर हवेली', 'inactive', NULL, NULL, current_timestamp(), NULL),
  49. (NULL, 'DD', 'Daman and Diu', 'દમણ અને દીવ', 'दमन और दीव', 'inactive', NULL, NULL, current_timestamp(), NULL),
  50. (NULL, 'DL', 'Delhi', 'દિલ્હી', 'दिल्ली', 'inactive', NULL, NULL, current_timestamp(), NULL),
  51. (NULL, 'GA', 'Goa', 'ગોવા', 'गोवा', 'inactive', NULL, NULL, current_timestamp(), NULL),
  52. (NULL, 'GJ', 'Gujarat', 'ગુજરાત', 'गुजरात', 'active', NULL, NULL, current_timestamp(), NULL),
  53. (NULL, 'HR', 'Haryana', 'હરિયાણા', 'हरयाणा', 'inactive', NULL, NULL, current_timestamp(), NULL),
  54. (NULL, 'HP', 'Himachal Pradesh', 'હિમાચલ પ્રદેશ', 'हिमाचल प्रदेश', 'inactive', NULL, NULL, current_timestamp(), NULL),
  55. (NULL, 'JK', 'Jammu and Kashmir', 'જમ્મુ અને કાશ્મીર', 'जम्मू और कश्मीर', 'inactive', NULL, NULL, current_timestamp(), NULL),
  56. (NULL, 'JH', 'Jharkhand', 'ઝારખંડ', 'झारखंड', 'inactive', NULL, NULL, current_timestamp(), NULL),
  57. (NULL, 'KA', 'Karnataka', 'કર્ણાટક', 'कर्नाटक', 'inactive', NULL, NULL, current_timestamp(), NULL),
  58. (NULL, 'KL', 'Kerala', 'કેરળ', 'केरल', 'inactive', NULL, NULL, current_timestamp(), NULL),
  59. (NULL, 'LA', 'Ladakh', 'લદ્દાખ', 'लद्दाख', 'inactive', NULL, NULL, current_timestamp(), NULL),
  60. (NULL, 'LD', 'Lakshadweep', 'લક્ષદ્વીપ', 'लक्षद्वीप', 'inactive', NULL, NULL, current_timestamp(), NULL),
  61. (NULL, 'MP', 'Madhya Pradesh', 'મધ્યપ્રદેશ', 'मध्य प्रदेश', 'inactive', NULL, NULL, current_timestamp(), NULL),
  62. (NULL, 'MH', 'Maharashtra', 'મહારાષ્ટ્ર', 'महाराष्ट्र', 'inactive', NULL, NULL, current_timestamp(), NULL),
  63. (NULL, 'MN', 'Manipur', 'મણિપુર', 'मणिपुर', 'inactive', NULL, NULL, current_timestamp(), NULL),
  64. (NULL, 'ML', 'Meghalaya', 'મેઘાલય', 'मेघालय', 'inactive', NULL, NULL, current_timestamp(), NULL),
  65. (NULL, 'MZ', 'Mizoram', 'મિઝોરમ', 'मिजोरम', 'inactive', NULL, NULL, current_timestamp(), NULL),
  66. (NULL, 'NL', 'Nagaland', 'નાગાલેન્ડ', 'नागालैंड', 'inactive', NULL, NULL, current_timestamp(), NULL),
  67. (NULL, 'OR', 'Odisha', 'ઓડિશા', 'ओडिशा', 'inactive', NULL, NULL, current_timestamp(), NULL),
  68. (NULL, 'PY', 'Puducherry', 'પુડુચેરી', 'पुदुचेरी', 'inactive', NULL, NULL, current_timestamp(), NULL),
  69. (NULL, 'PB', 'Punjab', 'પંજાબ', 'पंजाब', 'inactive', NULL, NULL, current_timestamp(), NULL),
  70. (NULL, 'RJ', 'Rajasthan', 'રાજસ્થાન', 'राजस्थान', 'inactive', NULL, NULL, current_timestamp(), NULL),
  71. (NULL, 'SK', 'Sikkim', 'સિક્કિમ', 'सिक्किम', 'inactive', NULL, NULL, current_timestamp(), NULL),
  72. (NULL, 'TN', 'Tamil Nadu', 'તમિલનાડુ', 'तमिलनाडु', 'inactive', NULL, NULL, current_timestamp(), NULL),
  73. (NULL, 'TS', 'Telangana', 'તેલંગાણા', 'तेलंगाना', 'inactive', NULL, NULL, current_timestamp(), NULL),
  74. (NULL, 'TR', 'Tripura', 'ત્રિપુરા', 'त्रिपुरा', 'inactive', NULL, NULL, current_timestamp(), NULL),
  75. (NULL, 'UP', 'Uttar Pradesh', 'ઉત્તર પ્રદેશ', 'उत्तर प्रदेश', 'inactive', NULL, NULL, current_timestamp(), NULL),
  76. (NULL, 'UK', 'Uttarakhand', 'ઉત્તરાખંડ', 'उत्तराखंड', 'inactive', NULL, NULL, current_timestamp(), NULL),
  77. (NULL, 'WB', 'West Bengal', 'પશ્ચિમ બંગાળ', 'पश्चिम बंगाल', 'inactive', NULL, NULL, current_timestamp(), NULL);
  78.  
  79. -- --------------------------------------------------------
  80.  
  81. --
  82. -- Table structure for table `tbl_dist`
  83. --
  84.  
  85. CREATE TABLE `tbl_dist` (
  86.   `dist_id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  87.   `state_id` int(11) NOT NULL,
  88.   `dist_name` varchar(35) NOT NULL,
  89.   `dist_name_guj` varchar(255) DEFAULT NULL,
  90.   `dist_name_hin` varchar(255) DEFAULT NULL,
  91.   `status` enum('active','inactive') NOT NULL,
  92.   `created_by` int(11) DEFAULT NULL,
  93.   `updated_by` int(11) DEFAULT NULL,
  94.   `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  95.   `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
  96. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  97.  
  98. --
  99. -- Dumping data for table `tbl_dist`
  100. --
  101.  
  102. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `dist_name_guj`, `dist_name_hin`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
  103. (NULL, 12, 'Ahmedabad', 'અમદાવાદ', 'अहमदाबाद', 'active', NULL, NULL, current_timestamp(), NULL),
  104. (NULL, 12, 'Amreli', 'અમરેલી', 'अमरेली', 'active', NULL, NULL, current_timestamp(), NULL),
  105. (NULL, 12, 'Anand', 'આણંદ', 'आणंद', 'active', NULL, NULL, current_timestamp(), NULL),
  106. (NULL, 12, 'Aravalli', 'અરવલ્લી', 'अरवल्ली', 'active', NULL, NULL, current_timestamp(), NULL),
  107. (NULL, 12, 'Banaskantha', 'બનાસકાંઠા', 'बनासकांठा', 'active', NULL, NULL, current_timestamp(), NULL),
  108. (NULL, 12, 'Bharuch', 'ભરૂચ', 'भरूच', 'active', NULL, NULL, current_timestamp(), NULL),
  109. (NULL, 12, 'Bhavnagar', 'ભાવનગર', 'भावनगर', 'active', NULL, NULL, current_timestamp(), NULL),
  110. (NULL, 12, 'Botad', 'બોટાદ', 'बोटाद', 'active', NULL, NULL, current_timestamp(), NULL),
  111. (NULL, 12, 'Chhota Udaipur', 'છોટા ઉદેપુર', 'छोटा उदयपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  112. (NULL, 12, 'Dahod', 'દાહોદ', 'दाहोद', 'active', NULL, NULL, current_timestamp(), NULL),
  113. (NULL, 12, 'Dang', 'ડાંગ', 'डांग', 'active', NULL, NULL, current_timestamp(), NULL),
  114. (NULL, 12, 'Devbhoomi Dwarka', 'દેવભૂમિ દ્વારકા', 'देवभूमि द्वारका', 'active', NULL, NULL, current_timestamp(), NULL),
  115. (NULL, 12, 'Gandhinagar', 'ગાંધીનગર', 'गांधीनगर', 'active', NULL, NULL, current_timestamp(), NULL),
  116. (NULL, 12, 'Gir Somnath', 'ગીર સોમનાથ', 'गीर सोमनाथ', 'active', NULL, NULL, current_timestamp(), NULL),
  117. (NULL, 12, 'Jamnagar', 'જામનગર', 'जामनगर', 'active', NULL, NULL, current_timestamp(), NULL),
  118. (NULL, 12, 'Junagadh', 'જુનાગઢ', 'जूनागढ़', 'active', NULL, NULL, current_timestamp(), NULL),
  119. (NULL, 12, 'Kachchh', 'કચ્છ', 'कच्छ', 'active', NULL, NULL, current_timestamp(), NULL),
  120. (NULL, 12, 'Kheda', 'ખેડા', 'खेड़ा', 'active', NULL, NULL, current_timestamp(), NULL),
  121. (NULL, 12, 'Mahisagar', 'મહીસાગર', 'महीसागर', 'active', NULL, NULL, current_timestamp(), NULL),
  122. (NULL, 12, 'Mehsana', 'મહેસાણા', 'मेहसाणा', 'active', NULL, NULL, current_timestamp(), NULL),
  123. (NULL, 12, 'Morbi', 'મોરબી', 'मोरबी', 'active', NULL, NULL, current_timestamp(), NULL),
  124. (NULL, 12, 'Narmada', 'નર્મદા', 'नर्मदा', 'active', NULL, NULL, current_timestamp(), NULL),
  125. (NULL, 12, 'Navsari', 'નવસારી', 'नवसारी', 'active', NULL, NULL, current_timestamp(), NULL),
  126. (NULL, 12, 'Panchmahal', 'પંચમહાલ', 'पंच महल', 'active', NULL, NULL, current_timestamp(), NULL),
  127. (NULL, 12, 'Patan', 'પાટણ', 'पाटन', 'active', NULL, NULL, current_timestamp(), NULL),
  128. (NULL, 12, 'Porbandar', 'પોરબંદર', 'पोरबंदर', 'active', NULL, NULL, current_timestamp(), NULL),
  129. (NULL, 12, 'Rajkot', 'રાજકોટ', 'राजकोट', 'active', NULL, NULL, current_timestamp(), NULL),
  130. (NULL, 12, 'Sabarkantha', 'સાબરકાંઠા', 'साबरकांठा', 'active', NULL, NULL, current_timestamp(), NULL),
  131. (NULL, 12, 'Surat', 'સુરત', 'सूरत', 'active', NULL, NULL, current_timestamp(), NULL),
  132. (NULL, 12, 'Surendranagar', 'સુરેન્દ્રનગર', 'सुरेन्द्रनगर', 'active', NULL, NULL, current_timestamp(), NULL),
  133. (NULL, 12, 'Tapi', 'તાપી', 'तापी', 'active', NULL, NULL, current_timestamp(), NULL),
  134. (NULL, 12, 'Vadodara', 'વડોદરા', 'वडोदरा', 'active', NULL, NULL, current_timestamp(), NULL),
  135. (NULL, 12, 'Valsad', 'વલસાડ', 'वलसाड', 'active', NULL, NULL, current_timestamp(), NULL);
  136.  
  137. -- --------------------------------------------------------
  138.  
  139. --
  140. -- Table structure for table `tbl_sub_dist`
  141. --
  142.  
  143. CREATE TABLE `tbl_sub_dist` (
  144.   `sub_dist_id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  145.   `dist_id` int(11) NOT NULL,
  146.   `sub_dist_name` varchar(35) NOT NULL,
  147.   `sub_dist_name_guj` varchar(255) DEFAULT NULL,
  148.   `sub_dist_name_hin` varchar(255) DEFAULT NULL,
  149.   `status` enum('active','inactive') NOT NULL,
  150.   `created_by` int(11) DEFAULT NULL,
  151.   `updated_by` int(11) DEFAULT NULL,
  152.   `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  153.   `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
  154. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  155.  
  156. --
  157. -- Dumping data for table `tbl_sub_dist`
  158. --
  159.  
  160. INSERT INTO `tbl_sub_dist` (`sub_dist_id`, `dist_id`, `sub_dist_name`, `sub_dist_name_guj`, `sub_dist_name_hin`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
  161. (NULL, 1, 'Ahmedabad', 'અમદાવાદ', 'अहमदाबाद', 'active', NULL, NULL, current_timestamp(), NULL),
  162. (NULL, 1, 'Barwala', 'બરવાળા', 'बरवाळा', 'active', NULL, NULL, current_timestamp(), NULL),
  163. (NULL, 1, 'Bavla', 'બાવળા', 'बावळा', 'active', NULL, NULL, current_timestamp(), NULL),
  164. (NULL, 1, 'Daskroi', 'દસક્રોઈ', 'दसक्रोई', 'active', NULL, NULL, current_timestamp(), NULL),
  165. (NULL, 1, 'Detroj-Rampura', 'દેત્રોજ - રામપુરા', 'देट्रोज - रामपुरा', 'active', NULL, NULL, current_timestamp(), NULL),
  166. (NULL, 1, 'Dhandhuka', 'ધંધુકા', 'धंधुका', 'active', NULL, NULL, current_timestamp(), NULL),
  167. (NULL, 1, 'Dholera', 'ધોલેરા', 'धोलेरा', 'active', NULL, NULL, current_timestamp(), NULL),
  168. (NULL, 1, 'Dholka', 'ધોળકા', 'धोळका', 'active', NULL, NULL, current_timestamp(), NULL),
  169. (NULL, 1, 'Ghatlodiya', 'ઘાટલોડિયા', 'घाटलोडिया', 'active', NULL, NULL, current_timestamp(), NULL),
  170. (NULL, 1, 'Mandal', 'માંડલ', 'मांडल', 'active', NULL, NULL, current_timestamp(), NULL),
  171. (NULL, 1, 'Maninagar', 'મણીનગર', 'मणिनगर', 'active', NULL, NULL, current_timestamp(), NULL),
  172. (NULL, 1, 'Ranpur', 'રાણપુર', 'राणपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  173. (NULL, 1, 'Sabarmati', 'સાબરમતી', 'साबरमती', 'active', NULL, NULL, current_timestamp(), NULL),
  174. (NULL, 1, 'Sanand', 'સાણંદ', 'साणंद', 'active', NULL, NULL, current_timestamp(), NULL),
  175. (NULL, 1, 'Vatva', 'વટવા', 'वटवा', 'active', NULL, NULL, current_timestamp(), NULL),
  176. (NULL, 1, 'Vejalpur', 'વેજલપુર', 'वेजलपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  177. (NULL, 1, 'Viramgam', 'વિરમગામ', 'वीरमगाम', 'active', NULL, NULL, current_timestamp(), NULL),
  178.  
  179. (NULL, 2, 'Amreli', 'અમરેલી', 'अमरेली', 'active', NULL, NULL, current_timestamp(), NULL),
  180. (NULL, 2, 'Babra', 'બાબરા', 'बाबरा', 'active', NULL, NULL, current_timestamp(), NULL),
  181. (NULL, 2, 'Bagasara', 'બગસરા', 'बगसरा', 'active', NULL, NULL, current_timestamp(), NULL),
  182. (NULL, 2, 'Dhari', 'ધારી', 'धारी', 'active', NULL, NULL, current_timestamp(), NULL),
  183. (NULL, 2, 'Jafrabad', 'જાફરાબાદ', 'जाफराबाद', 'active', NULL, NULL, current_timestamp(), NULL),
  184. (NULL, 2, 'Khambha', 'ખાંભા', 'खांभा', 'active', NULL, NULL, current_timestamp(), NULL),
  185. (NULL, 2, 'Kunkavav Vadia', 'કુંકાવાવ વડિયા', 'कुंकावाव वडिया', 'active', NULL, NULL, current_timestamp(), NULL),
  186. (NULL, 2, 'Lathi', 'લાઠી', 'लाठी', 'active', NULL, NULL, current_timestamp(), NULL),
  187. (NULL, 2, 'Lilia', 'લીલીયા', 'लिलिया', 'active', NULL, NULL, current_timestamp(), NULL),
  188. (NULL, 2, 'Rajula', 'રાજુલા', 'राजुला', 'active', NULL, NULL, current_timestamp(), NULL),
  189. (NULL, 2, 'Savarkundla', 'સાવરકુંડલા', 'सावरकुंडला', 'active', NULL, NULL, current_timestamp(), NULL),
  190.  
  191. (NULL, 3, 'Anand City', 'આણંદ શહેર', 'आणंद शहर', 'active', NULL, NULL, current_timestamp(), NULL),
  192. (NULL, 3, 'Anand Rural', 'આણંદ ગ્રામ્ય', 'आणंद ग्रामीण', 'active', NULL, NULL, current_timestamp(), NULL),
  193. (NULL, 3, 'Anklav', 'આંકલાવ', 'आंकलाव', 'active', NULL, NULL, current_timestamp(), NULL),
  194. (NULL, 3, 'Borsad', 'બોરસદ', 'बोरसद', 'active', NULL, NULL, current_timestamp(), NULL),
  195. (NULL, 3, 'Khambhat', 'ખંભાત', 'खंभात', 'active', NULL, NULL, current_timestamp(), NULL),
  196. (NULL, 3, 'Petlad', 'પેટલાદ', 'पेटलाड', 'active', NULL, NULL, current_timestamp(), NULL),
  197. (NULL, 3, 'Sojitra', 'સોજીત્રા', 'सोजित्रा', 'active', NULL, NULL, current_timestamp(), NULL),
  198. (NULL, 3, 'Tarapur', 'તારાપુર', 'तारापुर', 'active', NULL, NULL, current_timestamp(), NULL),
  199. (NULL, 3, 'Umreth', 'ઉમરેઠ', 'उमरेठ', 'active', NULL, NULL, current_timestamp(), NULL),
  200.  
  201. (NULL, 4, 'Bayad', 'બાયડ', 'बायड', 'active', NULL, NULL, current_timestamp(), NULL),
  202. (NULL, 4, 'Bhiloda', 'ભિલોડા', 'भिलोड़ा', 'active', NULL, NULL, current_timestamp(), NULL),
  203. (NULL, 4, 'Dhansura', 'ધનસુરા', 'धनसुरा', 'active', NULL, NULL, current_timestamp(), NULL),
  204. (NULL, 4, 'Malpur', 'માલપુર', 'मालपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  205. (NULL, 4, 'Meghraj', 'મેઘરજ', 'मेधरज', 'active', NULL, NULL, current_timestamp(), NULL),
  206. (NULL, 4, 'Modasa', 'મોડાસા', 'मोडासा', 'active', NULL, NULL, current_timestamp(), NULL),
  207.  
  208. (NULL, 5, 'Amirgadh', 'અમીરગઢ', 'अमीरगढ़', 'active', NULL, NULL, current_timestamp(), NULL),
  209. (NULL, 5, 'Bhabhar', 'ભાભર', 'भाभर', 'active', NULL, NULL, current_timestamp(), NULL),
  210. (NULL, 5, 'Danta', 'દાંતા', 'दांता', 'active', NULL, NULL, current_timestamp(), NULL),
  211. (NULL, 5, 'Dantiwada', 'દાંતીવાડા', 'दांतिवाडा', 'active', NULL, NULL, current_timestamp(), NULL),
  212. (NULL, 5, 'Deesa', 'ડીસા', 'दीसा', 'active', NULL, NULL, current_timestamp(), NULL),
  213. (NULL, 5, 'Deodar', 'દિયોદર', 'दियोदर', 'active', NULL, NULL, current_timestamp(), NULL),
  214. (NULL, 5, 'Dhanera', 'ધાનેરા', 'धानेरा', 'active', NULL, NULL, current_timestamp(), NULL),
  215. (NULL, 5, 'Kankrej', 'कांकरेज', 'કાંકરેજ', 'active', NULL, NULL, current_timestamp(), NULL),
  216. (NULL, 5, 'Lakhani', 'લાખની', 'लाखनी', 'active', NULL, NULL, current_timestamp(), NULL),
  217. (NULL, 5, 'Palanpur', 'પાલનપુર', 'पालनपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  218. (NULL, 5, 'Suigam', 'સુઇગામ', 'सुईगाम', 'active', NULL, NULL, current_timestamp(), NULL),
  219. (NULL, 5, 'Tharad', 'થરાદ', 'थराड', 'active', NULL, NULL, current_timestamp(), NULL),
  220. (NULL, 5, 'Vadgam', 'વડગામ', 'वडगाम', 'active', NULL, NULL, current_timestamp(), NULL),
  221. (NULL, 5, 'Vav', 'વાવ', 'वाव', 'active', NULL, NULL, current_timestamp(), NULL),
  222.  
  223. (NULL, 6, 'Amod', 'આમોદ', 'आमोद', 'active', NULL, NULL, current_timestamp(), NULL),
  224. (NULL, 6, 'Ankleshwar', 'અંકલેશ્વર', 'अंकलेश्वर', 'active', NULL, NULL, current_timestamp(), NULL),
  225. (NULL, 6, 'Bharuch', 'ભરૂચ', 'भरूच', 'active', NULL, NULL, current_timestamp(), NULL),
  226. (NULL, 6, 'Hansot', 'હાંસોટ', 'हांसोट', 'active', NULL, NULL, current_timestamp(), NULL),
  227. (NULL, 6, 'Jambusar', 'જંબુસર', 'जंबुसर', 'active', NULL, NULL, current_timestamp(), NULL),
  228. (NULL, 6, 'Jhagadia', 'ઝઘડિયા', 'झघडिया', 'active', NULL, NULL, current_timestamp(), NULL),
  229. (NULL, 6, 'Netrang', 'નેત્રંગ', 'नेत्रंग', 'active', NULL, NULL, current_timestamp(), NULL),
  230. (NULL, 6, 'Vagra', 'વાગરા', 'वागरा', 'active', NULL, NULL, current_timestamp(), NULL),
  231. (NULL, 6, 'Valia', 'વાલિયા', 'वालिया', 'active', NULL, NULL, current_timestamp(), NULL),
  232.  
  233. (NULL, 7, 'Bhavnagar', 'ભાવનગર', 'भावनगर', 'active', NULL, NULL, current_timestamp(), NULL),
  234. (NULL, 7, 'Gariadhar', 'ગારીયાધાર', 'गारियाधार', 'active', NULL, NULL, current_timestamp(), NULL),
  235. (NULL, 7, 'Ghogha', 'ઘોઘા', 'घोघा', 'active', NULL, NULL, current_timestamp(), NULL),
  236. (NULL, 7, 'Jesar', 'જેસર', 'जेसर', 'active', NULL, NULL, current_timestamp(), NULL),
  237. (NULL, 7, 'Mahuva', 'મહુવા', 'महुवा', 'active', NULL, NULL, current_timestamp(), NULL),
  238. (NULL, 7, 'Palitana', 'પાલીતાણા', 'पालिताना', 'active', NULL, NULL, current_timestamp(), NULL),
  239. (NULL, 7, 'Sihor', 'સિહોર', 'सीहोर', 'active', NULL, NULL, current_timestamp(), NULL),
  240. (NULL, 7, 'Talaja', 'તળાજા', 'तळाजा', 'active', NULL, NULL, current_timestamp(), NULL),
  241. (NULL, 7, 'Umrala', 'ઉમરાળા', 'उमराळा', 'active', NULL, NULL, current_timestamp(), NULL),
  242. (NULL, 7, 'Vallabhipur', 'વલ્લભીપુર', 'वल्लभीपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  243.  
  244. (NULL, 8, 'Barwala', 'બરવાળા', 'बरवाळा', 'active', NULL, NULL, current_timestamp(), NULL),
  245. (NULL, 8, 'Botad', 'બોટાદ', 'बोटाड', 'active', NULL, NULL, current_timestamp(), NULL),
  246. (NULL, 8, 'Gadhada', 'ગઢડા', 'गढडा', 'active', NULL, NULL, current_timestamp(), NULL),
  247. (NULL, 8, 'Ranpur', 'રાણપુર', 'राणपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  248.  
  249. (NULL, 9, 'Bodeli', 'બોડેલી', 'बोडेली', 'active', NULL, NULL, current_timestamp(), NULL),
  250. (NULL, 9, 'Chhota Udepur', 'છોટા ઉદેપુર', 'छोटा उदयपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  251. (NULL, 9, 'Jetpur Pavi', 'જેતપુર પાવી', 'जेतपुर पावी', 'active', NULL, NULL, current_timestamp(), NULL),
  252. (NULL, 9, 'Kavant', 'કવાંટ', 'कवांट', 'active', NULL, NULL, current_timestamp(), NULL),
  253. (NULL, 9, 'Nasvadi', 'નસવાડી', 'नसवाडी', 'active', NULL, NULL, current_timestamp(), NULL),
  254. (NULL, 9, 'Sankheda', 'સંખેડા', 'संखेड़ा', 'active', NULL, NULL, current_timestamp(), NULL),
  255.  
  256. (NULL, 10, 'Dahod', 'દાહોદ', 'दाहोद', 'active', NULL, NULL, current_timestamp(), NULL),
  257. (NULL, 10, 'Devgadh Baria', 'દેવગઢ બારીયા', 'देवगढ़ बारिया', 'active', NULL, NULL, current_timestamp(), NULL),
  258. (NULL, 10, 'Dhanpur', 'ધાનપુર', 'धानपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  259. (NULL, 10, 'Fatepura', 'ફતેપુરા', 'फतेपुरा', 'active', NULL, NULL, current_timestamp(), NULL),
  260. (NULL, 10, 'Garbada', 'ગરબાડા', 'गरबाडा', 'active', NULL, NULL, current_timestamp(), NULL),
  261. (NULL, 10, 'Jhalod', 'ઝાલોદ', 'ज़ालोद', 'active', NULL, NULL, current_timestamp(), NULL),
  262. (NULL, 10, 'Limkheda', 'લીમખેડા', 'लिमखेड़ा', 'active', NULL, NULL, current_timestamp(), NULL),
  263. (NULL, 10, 'Sanjeli', 'સંજેલી', 'संजेली', 'active', NULL, NULL, current_timestamp(), NULL),
  264. (NULL, 10, 'Singvad', 'સિંગવડ', 'सिंगवाड़', 'active', NULL, NULL, current_timestamp(), NULL),
  265.  
  266. (NULL, 11, 'Ahwa', 'આહવા', 'आहावा', 'active', NULL, NULL, current_timestamp(), NULL),
  267. (NULL, 11, 'Subir', 'સુબીર', 'सुबीर', 'active', NULL, NULL, current_timestamp(), NULL),
  268. (NULL, 11, 'Waghai', 'વાઘાઈ', 'वाघाई', 'active', NULL, NULL, current_timestamp(), NULL),
  269.  
  270. (NULL, 12, 'Bhanvad', 'ભાણવડ', 'भाणवड', 'active', NULL, NULL, current_timestamp(), NULL),
  271. (NULL, 12, 'Kalyanpur', 'કલ્યાણપુર', 'कल्याणपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  272. (NULL, 12, 'Khambhalia', 'ખંભાળિયા', 'खंभाळिया', 'active', NULL, NULL, current_timestamp(), NULL),
  273. (NULL, 12, 'Okhamandal', 'ઓખામંડળ', 'ओखामंडल', 'active', NULL, NULL, current_timestamp(), NULL),
  274.  
  275. (NULL, 13, 'Dehgam', 'દેહગામ', 'देहगाम', 'active', NULL, NULL, current_timestamp(), NULL),
  276. (NULL, 13, 'Gandhinagar', 'ગાંધીનગર', 'गांधीनगर', 'active', NULL, NULL, current_timestamp(), NULL),
  277. (NULL, 13, 'Kalol', 'કલોલ', 'कलोल', 'active', NULL, NULL, current_timestamp(), NULL),
  278. (NULL, 13, 'Mansa', 'માણસા', 'मााणसा', 'active', NULL, NULL, current_timestamp(), NULL),
  279.  
  280. (NULL, 14, 'Gir-Gadhada', 'ગીર - ગઢડા', 'गीर - गढडा', 'active', NULL, NULL, current_timestamp(), NULL),
  281. (NULL, 14, 'Kodinar', 'કોડીનાર', 'कोडिनार', 'active', NULL, NULL, current_timestamp(), NULL),
  282. (NULL, 14, 'Patan-Veraval', 'પાટણ - વેરાવળ', 'पाटण - वेरावल', 'active', NULL, NULL, current_timestamp(), NULL),
  283. (NULL, 14, 'Sutrapada', 'સુત્રાપાડા', 'सुत्रापाड़ा', 'active', NULL, NULL, current_timestamp(), NULL),
  284. (NULL, 14, 'Talala', 'તાલાળા', 'तलाला', 'active', NULL, NULL, current_timestamp(), NULL),
  285. (NULL, 14, 'Una', 'ઉના', 'उना', 'active', NULL, NULL, current_timestamp(), NULL),
  286.  
  287. (NULL, 15, 'Dhrol', 'ધ્રોલ', 'ध्रोल', 'active', NULL, NULL, current_timestamp(), NULL),
  288. (NULL, 15, 'Jamjodhpur', 'જામજોધપુર', 'जामजोधपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  289. (NULL, 15, 'Jamnagar City', 'જામનગર શહેર', 'जामनगर शहर', 'active', NULL, NULL, current_timestamp(), NULL),
  290. (NULL, 15, 'Jamnagar Rural', 'જામનગર ગ્રામ્ય', 'जामनगर ग्रामीण', 'active', NULL, NULL, current_timestamp(), NULL),
  291. (NULL, 15, 'Jodiya', 'જોડીયા', 'जोडिया', 'active', NULL, NULL, current_timestamp(), NULL),
  292. (NULL, 15, 'Kalavad', 'કાલાવડ', 'कालावड', 'active', NULL, NULL, current_timestamp(), NULL),
  293. (NULL, 15, 'Lalpur', 'લાલપુર', 'लालपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  294.  
  295. (NULL, 16, 'Bhesan', 'ભેસાણ', 'भेसाण', 'active', NULL, NULL, current_timestamp(), NULL),
  296. (NULL, 16, 'Junagadh City', 'જૂનાગઢ શહેર', 'जूनागढ़ शहर', 'active', NULL, NULL, current_timestamp(), NULL),
  297. (NULL, 16, 'Junagadh Rural', 'જૂનાગઢ ગ્રામ્ય', 'जूनागढ़ ग्रामीण', 'active', NULL, NULL, current_timestamp(), NULL),
  298. (NULL, 16, 'Keshod', 'કેશોદ', 'केशोद', 'active', NULL, NULL, current_timestamp(), NULL),
  299. (NULL, 16, 'Malia Hatina', 'માળીયા હાટીના', 'माळिया हाटीना', 'active', NULL, NULL, current_timestamp(), NULL),
  300. (NULL, 16, 'Manavadar', 'માણાવદર', 'माणावदर', 'active', NULL, NULL, current_timestamp(), NULL),
  301. (NULL, 16, 'Mangrol', 'માંગરોળ', 'मांगरोल', 'active', NULL, NULL, current_timestamp(), NULL),
  302. (NULL, 16, 'Mendarda', 'મેંદરડા', 'मेंदरडा', 'active', NULL, NULL, current_timestamp(), NULL),
  303. (NULL, 16, 'Vanthali', 'વંથલી', 'वंथली', 'active', NULL, NULL, current_timestamp(), NULL),
  304. (NULL, 16, 'Visavadar', 'વિસાવદર', 'विसावदर', 'active', NULL, NULL, current_timestamp(), NULL),
  305.  
  306. (NULL, 17, 'Abdasa', 'અબડાસા', 'अबडासा', 'active', NULL, NULL, current_timestamp(), NULL),
  307. (NULL, 17, 'Anjar', 'અંજાર', 'अंजार', 'active', NULL, NULL, current_timestamp(), NULL),
  308. (NULL, 17, 'Bhachau', 'ભચાઉ', 'भचाउ', 'active', NULL, NULL, current_timestamp(), NULL),
  309. (NULL, 17, 'Bhuj', 'ભુજ', 'भुज', 'active', NULL, NULL, current_timestamp(), NULL),
  310. (NULL, 17, 'Gandhidham', 'ગાંધીધામ', 'गांधीधाम', 'active', NULL, NULL, current_timestamp(), NULL),
  311. (NULL, 17, 'Lakhpat', 'લખપત', 'लखपत', 'active', NULL, NULL, current_timestamp(), NULL),
  312. (NULL, 17, 'Mandvi', 'માંડવી', 'मांडवी', 'active', NULL, NULL, current_timestamp(), NULL),
  313. (NULL, 17, 'Mundra', 'મુંદ્રા', 'मुंद्रा', 'active', NULL, NULL, current_timestamp(), NULL),
  314. (NULL, 17, 'Nakhatrana', 'નખત્રાણા', 'नखत्राणा', 'active', NULL, NULL, current_timestamp(), NULL),
  315. (NULL, 17, 'Rapar', 'રાપર', 'रापर', 'active', NULL, NULL, current_timestamp(), NULL),
  316.  
  317. (NULL, 18, 'Galteshwar', 'ગલતેશ્વર', 'गलतेश्वर', 'active', NULL, NULL, current_timestamp(), NULL),
  318. (NULL, 18, 'Kapadvanj', 'કપડવંજ', 'कपड़वंज', 'active', NULL, NULL, current_timestamp(), NULL),
  319. (NULL, 18, 'Kathlal', 'કાથલાલ', 'काथलाल', 'active', NULL, NULL, current_timestamp(), NULL),
  320. (NULL, 18, 'Kheda', 'ખેડા', 'खेड़ा', 'active', NULL, NULL, current_timestamp(), NULL),
  321. (NULL, 18, 'Mahudha', 'મહુધા', 'महुधा', 'active', NULL, NULL, current_timestamp(), NULL),
  322. (NULL, 18, 'Matar', 'માતર', 'मातर', 'active', NULL, NULL, current_timestamp(), NULL),
  323. (NULL, 18, 'Mehmedabad', 'મહેમદાવાદ', 'मेहमदाबाद', 'active', NULL, NULL, current_timestamp(), NULL),
  324. (NULL, 18, 'Nadiad City', 'નડિયાદ શહેર', 'नडियाद शहर', 'active', NULL, NULL, current_timestamp(), NULL),
  325. (NULL, 18, 'Nadiad', 'નડિયાદ', 'नडियाद', 'active', NULL, NULL, current_timestamp(), NULL),
  326. (NULL, 18, 'Thasra', 'થસરા', 'थसरा', 'active', NULL, NULL, current_timestamp(), NULL),
  327. (NULL, 18, 'Vaso', 'વાસો', 'वासो', 'active', NULL, NULL, current_timestamp(), NULL),
  328.  
  329. (NULL, 19, 'Balasinor', 'બાલાસિનોર', 'बालासिनोर', 'active', NULL, NULL, current_timestamp(), NULL),
  330. (NULL, 19, 'Kadana', 'કડાણા', 'कडाणा', 'active', NULL, NULL, current_timestamp(), NULL),
  331. (NULL, 19, 'Khanpur', 'ખાનપુર', 'खानपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  332. (NULL, 19, 'Lunawada', 'લુણાવાડા', 'लुणावाडा', 'active', NULL, NULL, current_timestamp(), NULL),
  333. (NULL, 19, 'Santrampur', 'સંતરામપુર', 'संतरामपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  334. (NULL, 19, 'Virpur', 'વિરપુર', 'वीरपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  335.  
  336. (NULL, 20, 'Becharaji', 'બેચરાજી', 'बेचराजी', 'active', NULL, NULL, current_timestamp(), NULL),
  337. (NULL, 20, 'Jotana', 'જોટાણા', 'जोटाणा', 'active', NULL, NULL, current_timestamp(), NULL),
  338. (NULL, 20, 'Kadi', 'કડી', 'कडी', 'active', NULL, NULL, current_timestamp(), NULL),
  339. (NULL, 20, 'Kheralu', 'ખેરાલુ', 'खेरालू', 'active', NULL, NULL, current_timestamp(), NULL),
  340. (NULL, 20, 'Mehsana', 'મહેસાણા', 'मेहसाणा', 'active', NULL, NULL, current_timestamp(), NULL),
  341. (NULL, 20, 'Satlasana', 'સતલાસણા', 'सतलासणा', 'active', NULL, NULL, current_timestamp(), NULL),
  342. (NULL, 20, 'Unjha', 'ઊંઝા', 'उंझा', 'active', NULL, NULL, current_timestamp(), NULL),
  343. (NULL, 20, 'Vadnagar', 'વડનગર', 'वडनगर', 'active', NULL, NULL, current_timestamp(), NULL),
  344. (NULL, 20, 'Vijapur', 'વિજાપુર', 'विजापुर', 'active', NULL, NULL, current_timestamp(), NULL),
  345. (NULL, 20, 'Visnagar', 'વિસનગર', 'विसनगर', 'active', NULL, NULL, current_timestamp(), NULL),
  346.  
  347. (NULL, 21, 'Halvad', 'હળવદ', 'हळवद', 'active', NULL, NULL, current_timestamp(), NULL),
  348. (NULL, 21, 'Maliya', 'માળીયા', 'माळीया  ', 'active', NULL, NULL, current_timestamp(), NULL),
  349. (NULL, 21, 'Morbi', 'મોરબી', 'मोरबी', 'active', NULL, NULL, current_timestamp(), NULL),
  350. (NULL, 21, 'Tankara', 'ટંકારા', 'टंकारा', 'active', NULL, NULL, current_timestamp(), NULL),
  351. (NULL, 21, 'Wankaner', 'વાંકાનેર', 'वांकानेर', 'active', NULL, NULL, current_timestamp(), NULL),
  352.  
  353. (NULL, 22, 'Dediapada', 'ડેડીયાપાડા', 'डेडीयापाड़ा', 'active', NULL, NULL, current_timestamp(), NULL),
  354. (NULL, 22, 'Garudeshwar', 'ગરુડેશ્વર', 'गरुड़ेश्वर', 'active', NULL, NULL, current_timestamp(), NULL),
  355. (NULL, 22, 'Nandod', 'નાંદોદ', 'नांदोद', 'active', NULL, NULL, current_timestamp(), NULL),
  356. (NULL, 22, 'Narmada', 'નર્મદા', 'नर्मदा', 'active', NULL, NULL, current_timestamp(), NULL),
  357. (NULL, 22, 'Rajpipla', 'રાજપીપળા', 'राजपिपला', 'active', NULL, NULL, current_timestamp(), NULL),
  358. (NULL, 22, 'Sagbara', 'સાગબારા', 'सागबारा', 'active', NULL, NULL, current_timestamp(), NULL),
  359. (NULL, 22, 'Tilakwada', 'તિલકવાડા', 'तिलकवाड़ा', 'active', NULL, NULL, current_timestamp(), NULL),
  360.  
  361. (NULL, 23, 'Bansda', 'વાંસદા', 'वांसदा ', 'active', NULL, NULL, current_timestamp(), NULL),
  362. (NULL, 23, 'Chikhli', 'ચીખલી', 'चिखली', 'active', NULL, NULL, current_timestamp(), NULL),
  363. (NULL, 23, 'Gandevi', 'ગણદેવી', 'गणदेवी', 'active', NULL, NULL, current_timestamp(), NULL),
  364. (NULL, 23, 'Jalalpore', 'જલાલપોર', 'जलालपोर', 'active', NULL, NULL, current_timestamp(), NULL),
  365. (NULL, 23, 'Khergam', 'ખેરગામ', 'खेरगाम', 'active', NULL, NULL, current_timestamp(), NULL),
  366. (NULL, 23, 'Navsari', 'નવસારી', 'नवसारी', 'active', NULL, NULL, current_timestamp(), NULL),
  367.  
  368. (NULL, 24, 'Ghoghamba', 'ઘોઘંબા', 'घोघंबा', 'active', NULL, NULL, current_timestamp(), NULL),
  369. (NULL, 24, 'Godhra', 'ગોધરા', 'गोधरा', 'active', NULL, NULL, current_timestamp(), NULL),
  370. (NULL, 24, 'Halol', 'હાલોલ', 'हालोल', 'active', NULL, NULL, current_timestamp(), NULL),
  371. (NULL, 24, 'Jambughoda', 'જાંબુઘોડા', 'जांबुघोडा', 'active', NULL, NULL, current_timestamp(), NULL),
  372. (NULL, 24, 'Kalol', 'કલોલ', 'कलोल', 'active', NULL, NULL, current_timestamp(), NULL),
  373. (NULL, 24, 'Morwa Hadaf', 'મોરવા હડફ', 'मोरवा हदफ', 'active', NULL, NULL, current_timestamp(), NULL),
  374. (NULL, 24, 'Panchmahal', 'પંચમહાલ', 'पंचमहाल', 'active', NULL, NULL, current_timestamp(), NULL),
  375. (NULL, 24, 'Shehera', 'શહેરા', 'शहेरा', 'active', NULL, NULL, current_timestamp(), NULL),
  376.  
  377. (NULL, 25, 'Chanasma', 'ચાણસ્મા', 'चाणस्मा', 'active', NULL, NULL, current_timestamp(), NULL),
  378. (NULL, 25, 'Harij', 'હારીજ', 'हारीज', 'active', NULL, NULL, current_timestamp(), NULL),
  379. (NULL, 25, 'Patan', 'પાટણ', 'पाटण', 'active', NULL, NULL, current_timestamp(), NULL),
  380. (NULL, 25, 'Radhanpur', 'રાધનપુર', 'राधनपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  381. (NULL, 25, 'Sami', 'સમી', 'समी', 'active', NULL, NULL, current_timestamp(), NULL),
  382. (NULL, 25, 'Santalpur', 'સાંતલપુર', 'सांतलपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  383. (NULL, 25, 'Sarasvati', 'સરસ્વતી', 'सरस्वती', 'active', NULL, NULL, current_timestamp(), NULL),
  384. (NULL, 25, 'Shankheshwar', 'શંખેશ્વર', 'शंखेश्वर', 'active', NULL, NULL, current_timestamp(), NULL),
  385. (NULL, 25, 'Sidhpur', 'સિદ્ધપુર', 'सिद्धपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  386.  
  387. (NULL, 26, 'Kutiyana', 'કુતિયાણા', 'कुतियाणा', 'active', NULL, NULL, current_timestamp(), NULL),
  388. (NULL, 26, 'Porbandar', 'પોરબંદર', 'पोरबंदर', 'active', NULL, NULL, current_timestamp(), NULL),
  389. (NULL, 26, 'Ranavav', 'રાણાવાવ', 'राणावव', 'active', NULL, NULL, current_timestamp(), NULL),
  390.  
  391. (NULL, 27, 'Dhoraji', 'ધોરાજી', 'धोराजी', 'active', NULL, NULL, current_timestamp(), NULL),
  392. (NULL, 27, 'Gondal', 'ગોંડલ', 'गोंडल', 'active', NULL, NULL, current_timestamp(), NULL),
  393. (NULL, 27, 'Jamkandorna', 'જામકંડોરણા', 'जामकंडोरणा', 'active', NULL, NULL, current_timestamp(), NULL),
  394. (NULL, 27, 'Jasdan', 'જસદણ', 'जसदण', 'active', NULL, NULL, current_timestamp(), NULL),
  395. (NULL, 27, 'Jetpur', 'જેતપુર', 'जेतपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  396. (NULL, 27, 'Kotada Sangani', 'કોટડા સાંગાણી', 'कोटडा सांगाणी', 'active', NULL, NULL, current_timestamp(), NULL),
  397. (NULL, 27, 'Lodhika', 'લોધીકા', 'लोधिका', 'active', NULL, NULL, current_timestamp(), NULL),
  398. (NULL, 27, 'Paddhari', 'પડધરી', 'पड़धरी', 'active', NULL, NULL, current_timestamp(), NULL),
  399. (NULL, 27, 'Rajkot', 'રાજકોટ', 'राजकोट', 'active', NULL, NULL, current_timestamp(), NULL),
  400. (NULL, 27, 'Rajkot East', 'રાજકોટ પૂર્વ', 'राजकोट पूर्व', 'active', NULL, NULL, current_timestamp(), NULL),
  401. (NULL, 27, 'Rajkot South', 'રાજકોટ દક્ષિણ', 'राजकोट दक्षिण', 'active', NULL, NULL, current_timestamp(), NULL),
  402. (NULL, 27, 'Rajkot West', 'રાજકોટ પશ્ચિમ', 'राजकोट पश्चिम', 'active', NULL, NULL, current_timestamp(), NULL),
  403. (NULL, 27, 'Upleta', 'ઉપલેટા', 'उपलेटा', 'active', NULL, NULL, current_timestamp(), NULL),
  404. (NULL, 27, 'Vinchchiya', 'વિંછીયા', 'विंछीया', 'active', NULL, NULL, current_timestamp(), NULL),
  405.  
  406. (NULL, 28, 'Himatnagar', 'હિમતનગર', 'हिमतनगर', 'active', NULL, NULL, current_timestamp(), NULL),
  407. (NULL, 28, 'Idar', 'ઇડર', 'इडर', 'active', NULL, NULL, current_timestamp(), NULL),
  408. (NULL, 28, 'Khedbrahma', 'ખેડબ્રહ્મા', 'खेडब्रह्मा', 'active', NULL, NULL, current_timestamp(), NULL),
  409. (NULL, 28, 'Poshina', 'પોશીના', 'पोशिना', 'active', NULL, NULL, current_timestamp(), NULL),
  410. (NULL, 28, 'Prantij', 'પ્રાંતિજ', 'प्रांतिज', 'active', NULL, NULL, current_timestamp(), NULL),
  411. (NULL, 28, 'Sabarkantha', 'સાબરકાંઠા', 'साबरकांठा', 'active', NULL, NULL, current_timestamp(), NULL),
  412. (NULL, 28, 'Talod', 'તલોદ', 'तलोद', 'active', NULL, NULL, current_timestamp(), NULL),
  413. (NULL, 28, 'Vadali', 'વડાલી', 'वडाली', 'active', NULL, NULL, current_timestamp(), NULL),
  414. (NULL, 28, 'Vijaynagar', 'વિજયનગર', 'विजयनगर', 'active', NULL, NULL, current_timestamp(), NULL),
  415.  
  416. (NULL, 29, 'Adajan', 'અડાજણ', 'अडाजण', 'active', NULL, NULL, current_timestamp(), NULL),
  417. (NULL, 29, 'Bardoli', 'બારડોલી', 'बारडोली', 'active', NULL, NULL, current_timestamp(), NULL),
  418. (NULL, 29, 'Choryasi', 'ચોર્યાસી', 'चोर्यासी', 'active', NULL, NULL, current_timestamp(), NULL),
  419. (NULL, 29, 'Kamrej', 'કામરેજ', 'कामरेज', 'active', NULL, NULL, current_timestamp(), NULL),
  420. (NULL, 29, 'Katargam', 'કતારગામ', 'कतारगाम', 'active', NULL, NULL, current_timestamp(), NULL),
  421. (NULL, 29, 'Mahuva', 'મહુવા', 'महुवा', 'active', NULL, NULL, current_timestamp(), NULL),
  422. (NULL, 29, 'Majura', 'મજુરા', 'मजूरा', 'active', NULL, NULL, current_timestamp(), NULL),
  423. (NULL, 29, 'Mandvi', 'માંડવી', 'मांडवी', 'active', NULL, NULL, current_timestamp(), NULL),
  424. (NULL, 29, 'Mangrol', 'માંગરોળ', 'मांगरोल', 'active', NULL, NULL, current_timestamp(), NULL),
  425. (NULL, 29, 'Olpad', 'ઓલપાડ', 'ओलपाड', 'active', NULL, NULL, current_timestamp(), NULL),
  426. (NULL, 29, 'Palsana', 'પલસાણા', 'पलसाना', 'active', NULL, NULL, current_timestamp(), NULL),
  427. (NULL, 29, 'Puna', 'પુના', 'पुना', 'active', NULL, NULL, current_timestamp(), NULL),
  428. (NULL, 29, 'Surat', 'સુરત', 'सुरत', 'active', NULL, NULL, current_timestamp(), NULL),
  429. (NULL, 29, 'Udhna', 'ઉધના', 'उधना', 'active', NULL, NULL, current_timestamp(), NULL),
  430. (NULL, 29, 'Umarpada', 'ઉમરપાડા', 'उमरपाड़ा', 'active', NULL, NULL, current_timestamp(), NULL),
  431.  
  432. (NULL, 30, 'Chotila', 'ચોટીલા', 'चोटिला', 'active', NULL, NULL, current_timestamp(), NULL),
  433. (NULL, 30, 'Chuda', 'ચુડા', 'चुडा', 'active', NULL, NULL, current_timestamp(), NULL),
  434. (NULL, 30, 'Dasada', 'દસાડા', 'दसाडा ', 'active', NULL, NULL, current_timestamp(), NULL),
  435. (NULL, 30, 'Dhrangadhra', 'ધ્રાંગધ્રા', 'ध्रांगधरा', 'active', NULL, NULL, current_timestamp(), NULL),
  436. (NULL, 30, 'Lakhtar', 'લખતર', 'लखतर', 'active', NULL, NULL, current_timestamp(), NULL),
  437. (NULL, 30, 'Limbdi', 'લીંબડી', 'लीमड़ी ', 'active', NULL, NULL, current_timestamp(), NULL),
  438. (NULL, 30, 'Muli', 'મુળી', 'मूली', 'active', NULL, NULL, current_timestamp(), NULL),
  439. (NULL, 30, 'Sayla', 'સાયલા', 'सायला', 'active', NULL, NULL, current_timestamp(), NULL),
  440. (NULL, 30, 'Surendranagar', 'સુરેન્દ્રનગર', 'सुरेन्द्रनगर', 'active', NULL, NULL, current_timestamp(), NULL),
  441. (NULL, 30, 'Thangadh', 'થાનગઢ', 'थानगढ़', 'active', NULL, NULL, current_timestamp(), NULL),
  442. (NULL, 30, 'Wadhwan', 'વઢવાણ', 'वढवान', 'active', NULL, NULL, current_timestamp(), NULL),
  443.  
  444. (NULL, 31, 'Dolvan', 'ડોલવણ', 'डोलवन', 'active', NULL, NULL, current_timestamp(), NULL),
  445. (NULL, 31, 'Kukarmunda', 'કુકરમુંડા', 'कुकरमुंडा', 'active', NULL, NULL, current_timestamp(), NULL),
  446. (NULL, 31, 'Nizar', 'નિઝર', 'नीझर', 'active', NULL, NULL, current_timestamp(), NULL),
  447. (NULL, 31, 'Songadh', 'સોનગઢ', 'सोनगढ़', 'active', NULL, NULL, current_timestamp(), NULL),
  448. (NULL, 31, 'Tapi', 'તાપી', 'तापी', 'active', NULL, NULL, current_timestamp(), NULL),
  449. (NULL, 31, 'Uchhal', 'ઉચ્છલ', 'उच्छल', 'active', NULL, NULL, current_timestamp(), NULL),
  450. (NULL, 31, 'Valod', 'વાલોડ', 'वालोद /वलोद', 'active', NULL, NULL, current_timestamp(), NULL),
  451. (NULL, 31, 'Vyara', 'વ્યારા', 'व्यारा', 'active', NULL, NULL, current_timestamp(), NULL),
  452.  
  453. (NULL, 32, 'Dabhoi', 'ડભોઇ', 'दभोई', 'active', NULL, NULL, current_timestamp(), NULL),
  454. (NULL, 32, 'Desar', 'દેસર', 'देसर', 'active', NULL, NULL, current_timestamp(), NULL),
  455. (NULL, 32, 'Karjan', 'કરજણ', 'करजण', 'active', NULL, NULL, current_timestamp(), NULL),
  456. (NULL, 32, 'Padra', 'પાદરા', 'पादरा', 'active', NULL, NULL, current_timestamp(), NULL),
  457. (NULL, 32, 'Savli', 'સાવલી', 'सावली', 'active', NULL, NULL, current_timestamp(), NULL),
  458. (NULL, 32, 'Sinor', 'સિનોર', 'सिनोर', 'active', NULL, NULL, current_timestamp(), NULL),
  459. (NULL, 32, 'Vadodara East', 'વડોદરા પૂર્વ', 'वडोदरा पूर्व', 'active', NULL, NULL, current_timestamp(), NULL),
  460. (NULL, 32, 'Vadodara North', 'વડોદરા ઉત્તર', 'वडोदरा उत्तर', 'active', NULL, NULL, current_timestamp(), NULL),
  461. (NULL, 32, 'Vadodara Rural', 'વડોદરા ગ્રામ્ય', 'वडोदरा ग्रामीण', 'active', NULL, NULL, current_timestamp(), NULL),
  462. (NULL, 32, 'Vadodara South', 'વડોદરા દક્ષિણ', 'वडोदरा दक्षिण', 'active', NULL, NULL, current_timestamp(), NULL),
  463. (NULL, 32, 'Vadodara West', 'વડોદરા પશ્ચિમ', 'वडोदरा पश्चिम', 'active', NULL, NULL, current_timestamp(), NULL),
  464. (NULL, 32, 'Vaghodia', 'વાઘોડિયા', 'वाघोडिया', 'active', NULL, NULL, current_timestamp(), NULL),
  465.  
  466. (NULL, 33, 'Dharampur', 'ધરમપુર', 'धरमपुर', 'active', NULL, NULL, current_timestamp(), NULL),
  467. (NULL, 33, 'Kaprada', 'કપરાડા', 'कपराडा', 'active', NULL, NULL, current_timestamp(), NULL),
  468. (NULL, 33, 'Pardi', 'પારડી', 'पारदी', 'active', NULL, NULL, current_timestamp(), NULL),
  469. (NULL, 33, 'Umargam (Umbergaon)', 'ઉમરગામ', 'उमरगाम', 'active', NULL, NULL, current_timestamp(), NULL),
  470. (NULL, 33, 'Valsad', 'વલસાડ', 'वलसाड', 'active', NULL, NULL, current_timestamp(), NULL),
  471. (NULL, 33, 'Vapi', 'વાપી', 'वापी', 'active', NULL, NULL, current_timestamp(), NULL);
  472.  
  473. ALTER TABLE `tbl_state` ADD INDEX(`status`);
  474. ALTER TABLE `tbl_state` ADD INDEX(`state_id`, `state_code`, `state_name`, `status`);
  475.  
  476. ALTER TABLE `tbl_dist` ADD INDEX(`state_id`);
  477. ALTER TABLE `tbl_dist` ADD INDEX(`status`);
  478. ALTER TABLE `tbl_dist` ADD INDEX(`dist_id`, `state_id`, `dist_name`, `status`);
  479.  
  480. ALTER TABLE `tbl_sub_dist` ADD INDEX(`dist_id`);
  481. ALTER TABLE `tbl_sub_dist` ADD INDEX(`status`);
  482. ALTER TABLE `tbl_sub_dist` ADD INDEX(`sub_dist_id`, `dist_id`, `sub_dist_name`, `status`);
  483. -- --------------------------------------------------------
  484.  
  485. --
  486. -- Table structure for table `tbl_languages`
  487. --
  488.  
  489. CREATE TABLE `tbl_languages` (
  490.   `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  491.   `title` varchar(30) NOT NULL,
  492.   `language` varchar(10) NOT NULL,
  493.   `code` varchar(2) NOT NULL COMMENT 'ISO 639-1 codes',
  494.   `status` enum('active','inactive') NOT NULL DEFAULT 'inactive',
  495.   `is_default` tinyint(1) NOT NULL DEFAULT '0',
  496.   `created_by` int(11) NOT NULL DEFAULT 0,
  497.   `updated_by` int(11) NOT NULL DEFAULT 0,
  498.   `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  499.   `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
  500. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  501.  
  502. --
  503. -- Dumping data for table `tbl_languages`
  504. --
  505.  
  506. INSERT INTO `tbl_languages` (`id`, `title`, `language`, `code`, `status`, `is_default`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
  507. (1, 'English','english', 'en', 'active', 0, 0, 0, current_timestamp(), NULL),
  508. (2, 'हिंदी','hindi', 'hi', 'active', 0, 0, 0, current_timestamp(), NULL),
  509. (3, 'ગુજરાતી','gujarati', 'gu', 'active', 0, 0, 0, current_timestamp(), NULL);
  510.  
  511. --------------------------------------------------------
  512.  
  513. CREATE TABLE `tbl_village` (
  514.     `village_id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  515.     `sub_dist_id` int(11) NOT NULL,
  516.     `village_name` varchar(50) NOT NULL,
  517.     `village_name_guj` varchar(255) DEFAULT NULL,
  518.     `village_name_hin` varchar(255) DEFAULT NULL,
  519.     `status` enum('active','inactive') NOT NULL,
  520.     `created_by` int(11) NULL DEFAULT 0,
  521.     `updated_by` int(11) NULL DEFAULT 0,
  522.     `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  523.     `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
  524. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  525.  
  526. --
  527. -- Dumping data for table `tbl_village`
  528. --
  529.  
  530. COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!