Advertisement
Virajsinh

state_dist_sub_dist_language.sql

Apr 11th, 2023 (edited)
1,270
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 47.11 KB | Source Code | 0 0
  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