--
-- Host: localhost    Database: SCHOOLMEALS_DB
-- ------------------------------------------------------


--
-- Table structure for table `districts`
--

CREATE TABLE `districts` (
  `id` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `districts`
--

INSERT INTO `districts` VALUES ('66682574301ad','Ajmer'),('66682589e3146','Alwar'),('6668259f03658','Banswara'),('666825b460fa0','Baran'),('6668263ed1102','Barmer'),('66682654d7298','Bharatpur'),('66682671f3382','Bhilwara'),('66682689469f7','Bikaner'),('666826a7222b6','Bundi'),('666826bea078b','Chittaurgarh'),('666826da03b8c','Churu'),('666826eccb296','Dausa'),('66682701941fb','Dhaulpur'),('66682724e7a0d','Dungarpur'),('6668278241237','Ganganagar'),('666827d9d9ad8','Hanumangarh'),('666827ec2ccc9','Jaipur'),('666827feaefa9','Jaisalmer'),('6668283f763c3','Jalor'),('666828520c6ce','Jhalawar'),('666828813714f','Jhunjhunun'),('66682897d990f','Jodhpur'),('666828a956d00','Karauli'),('666828c4a2ccc','Kota'),('666828f74312d','Nagaur'),('66682921472bc','Pali'),('66682957dfc60','Pratapgarh'),('66682a0b8a1fe','Rajsamand'),('66682a1d8a869','Sawaimadhopur'),('66682a301ace2','Sikar'),('66682a42c96f5','Sirohi'),('66682a74a0328','Tonk'),('66682a8cc1bb9','Udaipur'),('6819e704d830a','Nayagarh'),('6819e7104ad2f','Ganjam'),('6819e71e14f87','Puri'),('6819e72d3a556','Cuttack'),('6819e7437f8d9','Khordha');

--
-- Table structure for table `fps`
--

CREATE TABLE `fps` (
  `district` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `id` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `latitude` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `longitude` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `demand` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `uniqueid` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `active` varchar(10) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fps`
--

INSERT INTO `fps` VALUES ('Khordha','School1','21170612101','20.162042','85.967778','900','FPS_6819e7bb6c2','1'),('Khordha','School2','21170605301','20.155025','85.956762','150','FPS_6819e7bb6f2','1'),('Khordha','School3','21170607101','20.163537','85.953448','400','FPS_6819e7bb715','1'),('Khordha','School4','21170620101','20.173648','85.955042','350','FPS_6819e7bb78b','1'),('Khordha','School5','21170620151','20.179218','85.962089','100','FPS_6819e7bb7b4','1'),('Khordha','School6','21170623601','20.17346','85.956219','900','FPS_6819e7bb7e8','1'),('Khordha','School7','21170622001','20.175512','85.936163','700','FPS_6819e7bb820','1'),('Khordha','School8','21170609301','20.161686','85.932697','150','FPS_6819e7bb840','1'),('Khordha','School9','21170622002','20.160975','85.934238','150','FPS_6819e7bb85c','1'),('Khordha','School10','21170623271','20.155568','85.928646','200','FPS_6819e7bb889','1'),('Khordha','School11','21170605201','20.15123','85.91721','100','FPS_6819e7bb8ca','1'),('Khordha','School12','21170618701','20.15','85.92','800','FPS_6819e7bb8e9','1'),('Khordha','School13','21170619901','20.117237','85.897471','600','FPS_6819e7bb94f','1'),('Khordha','School14','21170620951','20.124033','85.875194','100','FPS_6819e7bb97a','1'),('Khordha','School15','21170608102','20.134049','85.89142','110','FPS_6819e7bb9c3','1'),('Khordha','School16','21170614202','20.135858','85.892645','900','FPS_6819e7bb9de','1'),('Khordha','School17','21170608001','20.133957','85.891328','450','FPS_6819e7bba0d','1'),('Khordha','School18','21170616901','20.131111','85.89419','900','FPS_6819e7bba2c','1'),('Khordha','School19','21170603901','20.115579','85.924376','160','FPS_6819e7bba4d','1'),('Khordha','School20','21170610302','20.125026','85.884682','120','FPS_6819e7bba72','1'),('Khordha','School21','21170605303','20.125032','85.884601','800','FPS_6819e7bba8f','1'),('Khordha','School22','21170617801','20.1277','85.886468','650','FPS_6819e7bbabe','1'),('Khordha','School23','21170609501','85.930735','20.141662','650','FPS_6819e7bbadc','1'),('Khordha','School24','21170623001','85.944144','20.144755','120','FPS_6819e7bbafb','1'),('Khordha','School25','21170601701','20.119816','85.940227','100','FPS_6819e7bbb28','1'),('Khordha','School26','21170621401','85.913811','20.139511','100','FPS_6819e7bbb4e','1'),('Khordha','School27','21170618901','85.913364','20.144241','100','FPS_6819e7bbb60','1'),('Khordha','School28','21170621701','85.908243','20.147446','100','FPS_6819e7bbb97','1'),('Khordha','School29','21170603902','85.902979','20.14408','100','FPS_6819e7bbbbf','1'),('Khordha','School30','21170611702','85.911986','20.121704','100','FPS_6819e7bbbe0','1'),('Khordha','School31','21170606801','85.924899','20.118753','100','FPS_6819e7bbc3e','1'),('Khordha','School32','21170600402','20.129321','85.911986','100','FPS_6819e7bbc5a','1'),('Khordha','School33','21170614501','85.913863','20.139538','100','FPS_6819e7bbc86','1'),('Khordha','School34','21170620901','20.17458','86.038779','150','FPS_6819e7bbca4','1'),('Khordha','School35','21170606901','20.163107','86.045774','150','FPS_6819e7bbcc8','1'),('Khordha','School36','21170612001','20.153203','86.046109','100','FPS_6819e7bc0d9','1'),('Khordha','School37','21170613902','20.16665','86.02744','100','FPS_6819e7bc10f','1'),('Khordha','School38','21170615301','20.165777','86.023647','300','FPS_6819e7bc14b','1'),('Khordha','School39','21170602401','20.177665','86.007523','200','FPS_6819e7bc169','1'),('Khordha','School40','21170613202','20.187293','86.009527','100','FPS_6819e7bc17d','1'),('Khordha','School41','21170604401','20.173565','86.018631','150','FPS_6819e7bc19b','1'),('Khordha','School42','21170617401','20.188351','86.001584','150','FPS_6819e7bc1b2','1'),('Khordha','School43','21170615601','20.173181','86.035282','450','FPS_6819e7bc1ca','1'),('Khordha','School44','21170622201','20.16388','86.030107','100','FPS_6819e7bc1e8','1'),('Khordha','School45','21170614301','20.175535','86.008123','100','FPS_6819e7bc204','1'),('Khordha','School46','21170607301','20.151389','86.018056','100','FPS_6819e7bc21b','1'),('Khordha','School47','21170610201','20.123282','86.051891','150','FPS_6819e7bc239','1'),('Khordha','School48','21170602501','85.976907','20.120058','100','FPS_6819e7bc251','1'),('Khordha','School49','21170617901','20.142915','85.970731','150','FPS_6819e7bc269','1'),('Khordha','School50','21170617102','20.124','85.97405','150','FPS_6819e7bc27e','1'),('Khordha','School51','21170603105','20.124001','85.97406','100','FPS_6819e7bc29c','1'),('Khordha','School52','21170600601','20.124','84.7781','100','FPS_6819e7bc2b8','1'),('Khordha','School53','21170618301','20.11933','86.00022','200','FPS_6819e7bc2e4','1'),('Khordha','School54','21170620301','20.1134','85.9547','250','FPS_6819e7bc307','1'),('Khordha','School55','21170602901','20.11843','86.00563','100','FPS_6819e7bc326','1'),('Khordha','School56','21170608901','20.143152','85.995731','150','FPS_6819e7bc34d','1'),('Khordha','School57','21170609601','20.120976','86.005645','100','FPS_6819e7bc378','1'),('Khordha','School58','21170600801','86.002238','20.134313','100','FPS_6819e7bc3a0','1'),('Khordha','School59','21170625101','20.125092','86.011607','100','FPS_6819e7bc3b8','1'),('Khordha','School60','21170609701','20.106756','86.204354','100','FPS_6819e7bc3ec','1'),('Khordha','School61','21170609801','20.10238','86.016781','150','FPS_6819e7bc3ff','1'),('Khordha','School62','21170619601','20.138586','85.989713','100','FPS_6819e7bc424','1'),('Khordha','School63','21170605801','20.138589','85.989715','250','FPS_6819e7bc43f','1'),('Khordha','School64','21170605901','20.105601','86.018533','100','FPS_6819e7bc457','1'),('Khordha','School65','21170616602','85.930735','20.141662','100','FPS_6819e7bc471','1'),('Khordha','School66','21170607601','85.944144','20.144755','100','FPS_6819e7bc48a','1'),('Khordha','School67','21170627501','20.119816','85.940227','100','FPS_6819e7bc4a7','1'),('Khordha','School68','21170610001','85.913811','20.139511','150','FPS_6819e7bc4bd','1'),('Khordha','School69','21170603201','85.913364','20.144241','100','FPS_6819e7bc4ce','1'),('Khordha','School70','21170622801','85.908243','20.147446','100','FPS_6819e7bc4ec','1'),('Khordha','School71','21170601801','85.902979','20.14408','100','FPS_6819e7bc506','1'),('Khordha','School72','21170623501','85.911986','20.121704','150','FPS_6819e7bc52d','1'),('Khordha','School73','21170607801','85.924899','20.118753','100','FPS_6819e7bc54b','1'),('Khordha','School74','21170619902','20.129321','85.911986','100','FPS_6819e7bc57b','1'),('Khordha','School75','21170620701','85.913863','20.139538','150','FPS_6819e7bc59c','1'),('Khordha','School76','21170601101','20.17458','86.038779','550','FPS_6819e7bc5bd','1'),('Khordha','School77','21170618801','20.163107','86.045774','350','FPS_6819e7bc5db','1'),('Khordha','School78','21170623201','20.153203','86.046109','400','FPS_6819e7bc5f6','1'),('Khordha','School79','21170609101','20.16665','86.02744','450','FPS_6819e7bc614','1'),('Khordha','School80','21170613801','20.165777','86.023647','250','FPS_6819e7bc62e','1'),('Khordha','School81','21170621301','20.177665','86.007523','250','FPS_6819e7bc64e','1'),('Khordha','School82','21170608701','20.187293','86.009527','110','FPS_6819e7bc668','1'),('Khordha','School83','21170619501','20.163537','85.953448','250','FPS_6819e7bc68a','1'),('Khordha','School84','21170615401','20.173648','85.955042','350','FPS_6819e7bc6ae','1'),('Khordha','School85','21170622301','20.179218','85.962089','350','FPS_6819e7bc6c8','1'),('Khordha','School86','21170604601','20.17346','85.956219','350','FPS_6819e7bc6e7','1'),('Khordha','School87','21170607501','20.175512','85.936163','250','FPS_6819e7bc70a','1'),('Khordha','School88','21170602701','20.161686','85.932697','450','FPS_6819e7bc72c','1'),('Khordha','School89','21170602802','20.160975','85.934238','450','FPS_6819e7bc75d','1'),('Khordha','School90','21170614401','20.155568','85.928646','500','FPS_6819e7bc77d','1'),('Khordha','School91','21170602101','20.15123','85.91721','500','FPS_6819e7bc7bb','1'),('Khordha','School92','21170602001','20.15','85.92','350','FPS_6819e7bc7da','1'),('Khordha','School93','21170606401','20.117237','85.897471','250','FPS_6819e7bc800','1'),('Khordha','School94','21170604901','20.124033','85.875194','400','FPS_6819e7bc829','1'),('Khordha','School95','21170600902','20.134049','85.89142','400','FPS_6819e7bc846','1'),('Khordha','School96','21170609001','20.135858','85.892645','350','FPS_6819e7bc863','1'),('Khordha','School97','21170601051','20.133957','85.891328','450','FPS_6819e7bc88b','1'),('Khordha','School98','21170622501','20.131111','85.89419','250','FPS_6819e7bc8ab','1'),('Khordha','School99','21170600651','20.115579','85.924376','200','FPS_6819e7bc8ca','1'),('Khordha','School100','21170615801','20.125026','85.884682','700','FPS_6819e7bc8eb','1'),('Khordha','School101','21170618101','20.125032','85.884601','250','FPS_6819e7bc90a','1'),('Khordha','School102','21170620351','20.1277','85.886468','450','FPS_6819e7bc929','1'),('Khordha','School103','21170616951','85.930735','20.141662','100','FPS_6819e7bc961','1'),('Khordha','School104','21170608051','85.944144','20.144755','100','FPS_6819e7bc989','1'),('Khordha','School105','21170623551','20.119816','85.940227','100','FPS_6819e7bc9a6','1'),('Khordha','School106','21170607202','85.913811','20.139511','250','FPS_6819e7bc9c4','1'),('Khordha','School107','21170612801','85.913364','20.144241','350','FPS_6819e7bc9dd','1'),('Khordha','School108','21170618302','85.908243','20.147446','100','FPS_6819e7bca1f','1'),('Khordha','School109','21170621175','85.902979','20.14408','120','FPS_6819e7bca56','1'),('Khordha','School110','21170619703','85.911986','20.121704','900','FPS_6819e7bca82','1'),('Khordha','School111','21170600101','85.924899','20.118753','500','FPS_6819e7bcaa1','1'),('Khordha','School112','21170602601','20.129321','85.911986','200','FPS_6819e7bcac3','1'),('Khordha','School113','21170613301','85.913863','20.139538','850','FPS_6819e7bcada','1'),('Khordha','School114','21170608401','20.17346','85.956219','350','FPS_6819e7bcaec','1'),('Khordha','School115','21170622251','20.175512','85.936163','100','FPS_6819e7bcb1b','1'),('Khordha','School116','21170609402','20.161686','85.932697','120','FPS_6819e7bcb2e','1'),('Khordha','School117','21170620302','20.160975','85.934238','100','FPS_6819e7bcb4a','1'),('Khordha','School118','21170621751','20.155568','85.928646','100','FPS_6819e7bcb6d','1'),('Khordha','School119','21170619704','20.15123','85.91721','400','FPS_6819e7bcb98','1'),('Khordha','School120','21170621102','20.15','85.92','110','FPS_6819e7bcbc5','1'),('Khordha','School121','21170621451','20.117237','85.897471','100','FPS_6819e7bcbe4','1'),('Khordha','School122','21170602151','85.913811','20.139511','350','FPS_6819e7bcc04','1'),('Khordha','School123','21170607103','85.913364','20.144241','700','FPS_6819e7bcc2b','1'),('Khordha','School124','21170608702','85.908243','20.147446','800','FPS_6819e7bcc61','1'),('Khordha','School125','21170602602','85.902979','20.14408','600','FPS_6819e7bcc98','1'),('Khordha','School126','21170702501','19.715076','85.190143','5.5','FPS_6819e7bccb6','1'),('Khordha','School127','21170702601','19.715159','85.167357','1.5','FPS_6819e7bccdd','1'),('Khordha','School128','21170702701','19.692915','85.177657','1.5','FPS_6819e7bcd02','1'),('Khordha','School129','21170702702','19.681031','85.180802','5.5','FPS_6819e7bcd33','1'),('Khordha','School130','21170702801','19.696544','85.190206','1.5','FPS_6819e7bcd61','1'),('Khordha','School131','21170703201','19.699469','85.190735','4.5','FPS_6819e7bcd7f','1'),('Khordha','School132','21170703302','19.707526','85.173638','5.5','FPS_6819e7bcd9b','1'),('Khordha','School133','21170703301','19.709213','85.17629','1.5','FPS_6819e7bcdbb','1'),('Khordha','School134','21170703601','19.72708','85.175214','1.5','FPS_6819e7bcdeb','1'),('Khordha','School135','21170702551','19.713474','85.186565','22.5','FPS_6819e7bce15','1'),('Khordha','School136','21171100201','19.744602','85.213657','3.5','FPS_6819e7bce47','1'),('Khordha','School137','21171101001','19.754689','85.198169','41','FPS_6819e7bce6d','1'),('Khordha','School138','21171100801','19.748256','85.206404','11.5','FPS_6819e7bce90','1'),('Khordha','School139','21171100301','19.745175','85.209046','3.5','FPS_6819e7bceb8','1'),('Khordha','School140','21171110301','19.738772','85.210088','1.5','FPS_6819e7bcedb','1'),('Khordha','School141','21171100802','19.743459','85.19755','1.5','FPS_6819e7bcef9','1'),('Khordha','School142','21171100151','19.750492','85.20464','3.5','FPS_6819e7bcf23','1'),('Khordha','School143','21170711301','19.731635','85.171237','7','FPS_6819e7bd00e','1'),('Khordha','School144','21170710401','20.288875','85.8302','1','FPS_6819e7bd034','1'),('Khordha','School145','21170710701','19.722289','85.192805','10.5','FPS_6819e7bd053','1'),('Khordha','School146','21170710801','19.737222','85.160576','12.5','FPS_6819e7bd074','1'),('Khordha','School147','21170711201','19.729787','85.196702','6.5','FPS_6819e7bd09b','1'),('Khordha','School148','21170711101','19.729113','85.202044','1','FPS_6819e7bd0be','1'),('Khordha','School149','21170711401','19.72498','85.165131','1','FPS_6819e7bd0ed','1'),('Khordha','School150','21170711501','19.740474','85.189259','4','FPS_6819e7bd118','1'),('Khordha','School151','21170710851','19.735699','85.158735','9','FPS_6819e7bd136','1'),('Khordha','School152','21170704301','19.898652','85.393101','5','FPS_6819e7bd154','1'),('Khordha','School153','21170704501','19.892735','85.400238','2','FPS_6819e7bd173','1'),('Khordha','School154','21170704701','19.88763','85.369008','4','FPS_6819e7bd194','1'),('Khordha','School155','21170704702','19.893014','85.401617','8.5','FPS_6819e7bd1ac','1'),('Khordha','School156','21170704801','19.892743','85.40064','1','FPS_6819e7bd1c8','1'),('Khordha','School157','21170704703','19.892679','85.400431','2','FPS_6819e7bd1e7','1'),('Khordha','School158','21170714002','19.892727','85.400745','27','FPS_6819e7bd201','1'),('Khordha','School159','21170714052','19.8548','85.381431','12.5','FPS_6819e7bd223','1'),('Khordha','School160','21170704351','19.89273','85.400612','7.5','FPS_6819e7bd241','1'),('Khordha','School161','21170707401','19.902433','85.416578','4','FPS_6819e7bd278','1'),('Khordha','School162','21170706852','19.890774','85.400162','31','FPS_6819e7bd29c','1'),('Khordha','School163','21170706701','19.883029','85.413767','3.5','FPS_6819e7bd2b6','1'),('Khordha','School164','21170706802','19.887802','85.406752','3','FPS_6819e7bd2e0','1'),('Khordha','School165','21170706501','19.884103','85.402191','3.5','FPS_6819e7bd302','1'),('Khordha','School166','21170708001','19.892626','85.416321','1.5','FPS_6819e7bd32c','1'),('Khordha','School167','21170706702','19.88923','85.41473','14','FPS_6819e7bd34a','1'),('Khordha','School168','21170708501','19.91564','85.404181','1.5','FPS_6819e7bd36a','1'),('Khordha','School169','21170706001','19.834901','85.334678','2.5','FPS_6819e7bd38c','1'),('Khordha','School170','21170706002','19.830883','85.326376','1','FPS_6819e7bd3ba','1'),('Khordha','School171','21170706202','19.842751','85.351772','3.5','FPS_6819e7bd3d9','1'),('Khordha','School172','21170706302','19.838821','85.356281','6.5','FPS_6819e7bd3f4','1'),('Khordha','School173','21170706301','19.838267','85.353593','16.5','FPS_6819e7bd424','1'),('Khordha','School174','21170704102','19.850232','85.346126','5','FPS_6819e7bd447','1'),('Khordha','School175','21170704201','19.855267','85.322439','9','FPS_6819e7bd481','1'),('Khordha','School176','21170704151','19.85308','85.340114','12','FPS_6819e7bd4a2','1'),('Khordha','School177','21170706205','19.85','85.34','18.5','FPS_6819e7bd4c7','1'),('Khordha','School178','21170706351','19.843779','85.353955','11','FPS_6819e7bd4f1','1'),('Khordha','School179','21170705601','19.831057','85.297244','5.5','FPS_6819e7bd50d','1'),('Khordha','School180','21170705301','19.833911','85.344471','1.5','FPS_6819e7bd52a','1'),('Khordha','School181','21170705501','19.815314','85.297227','3','FPS_6819e7bd54c','1'),('Khordha','School182','21170705751','19.82572','85.312099','28','FPS_6819e7bd566','1'),('Khordha','School183','21170703901','19.816877','85.3132','1.5','FPS_6819e7bd57b','1'),('Khordha','School184','21170703972','19.829365','85.312491','3.5','FPS_6819e7bd5a1','1'),('Khordha','School185','21170703902','19.80702','85.321112','20','FPS_6819e7bd5c2','1'),('Khordha','School186','21170705901','19.817478','85.339045','1','FPS_6819e7bd5d9','1'),('Khordha','School187','21170703951','19.807003','85.320931','9','FPS_6819e7bd5f1','1'),('Khordha','School188','21170700101','19.785422','85.237518','1','FPS_6819e7bd607','1'),('Khordha','School189','21170701101','19.793556','85.265003','1.5','FPS_6819e7bd629','1'),('Khordha','School190','21170709201','19.8056','85.262519','1','FPS_6819e7bd64f','1'),('Khordha','School191','21170701201','19.785164','85.247848','1','FPS_6819e7bd675','1'),('Khordha','School192','21170701301','19.788617','85.226879','1','FPS_6819e7bd693','1'),('Khordha','School193','21170701401','19.788649','85.215647','1.5','FPS_6819e7bd6b8','1'),('Khordha','School194','21170701701','19.784017','85.258423','2.5','FPS_6819e7bd6d0','1'),('Khordha','School195','21170700151','19.792946','85.235106','21','FPS_6819e7bd6f3','1'),('Khordha','School196','21170701901','19.79584','85.251109','1','FPS_6819e7bd716','1'),('Khordha','School197','21170712401','19.779916','85.231904','1.5','FPS_6819e7bd73b','1'),('Khordha','School198','21170712252','19.802447','85.305058','2.5','FPS_6819e7bd754','1'),('Khordha','School199','21170709101','19.820519','85.268352','3.5','FPS_6819e7bd77c','1'),('Khordha','School200','21170709451','19.792012','85.239047','9.5','FPS_6819e7bd79a','1'),('Khordha','School201','21170712251','19.804659','85.308772','11.5','FPS_6819e7bd7c1','1'),('Khordha','School202','21170709301','19.814527','85.27262','7.5','FPS_6819e7bd7d5','1'),('Khordha','School203','21170712201','19.804132','85.303782','12','FPS_6819e7bd7f7','1'),('Khordha','School204','21170709901','19.80253','85.27522','1.5','FPS_6819e7bd819','1'),('Khordha','School205','21170709452','19.795193','85.241034','1.5','FPS_6819e7bd848','1'),('Khordha','School206','21170712202','19.843729','85.329361','4.5','FPS_6819e7bd879','1'),('Khordha','School207','21170710101','19.81267','85.26075','2.5','FPS_6819e7bd89c','1'),('Khordha','School208','21170713201','19.774141','85.223799','1.5','FPS_6819e7bd8e1','1'),('Khordha','School209','21170713301','19.769593','85.234985','2','FPS_6819e7bd902','1'),('Khordha','School210','21170712701','19.753947','85.216539','1','FPS_6819e7bd928','1'),('Khordha','School211','21171100152','19.749072','85.218868','1','FPS_6819e7bd95c','1'),('Khordha','School212','21170713401','19.758458','85.228413','8','FPS_6819e7bd98e','1'),('Khordha','School213','21170713701','19.760377','85.21384','6.5','FPS_6819e7bd9c6','1'),('Khordha','School214','21170712501','19.774667','85.208519','6','FPS_6819e7bd9e7','1'),('Khordha','School215','21170713202','19.773892','85.223741','2.5','FPS_6819e7bda17','1'),('Khordha','School216','21170713271','19.773513','85.223507','7','FPS_6819e7bda3f','1'),('Khordha','School217','21170713901','19.873313','85.397482','3.5','FPS_6819e7bda63','1'),('Khordha','School218','21170713802','19.881266','85.381273','1','FPS_6819e7bda98','1'),('Khordha','School219','21170706401','19.847519','85.369234','5','FPS_6819e7bdab6','1'),('Khordha','School220','21170714072','19.854781','85.38142','2','FPS_6819e7bdadd','1'),('Khordha','School221','21170714003','19.887389','85.388372','18.5','FPS_6819e7bdb01','1'),('Khordha','School222','21170706203','19.844454','85.361087','3','FPS_6819e7bdb22','1'),('Khordha','School223','21170706204','19.862525','85.335337','1.5','FPS_6819e7bdb3e','1'),('Khordha','School224','21170704101','19.852443','85.339609','5.5','FPS_6819e7bdb5f','1'),('Khordha','School225','21170714051','19.881266','85.381273','8','FPS_6819e7bdb81','1'),('Khordha','School226','21170806001','20.133972','85.639608','22','FPS_6819e7bdb9a','1'),('Khordha','School227','21170801601','20.1073','85.672345','340','FPS_6819e7bdbb6','1'),('Khordha','School228','21170801901','20.079302','85.673683','35','FPS_6819e7bdbdf','1'),('Khordha','School229','21170805201','20.138572','85.644694','168','FPS_6819e7bdc07','1'),('Khordha','School230','21170802502','20.092165','85.661741','120','FPS_6819e7bdc29','1'),('Khordha','School231','21170805101','28.608537','80.60399','100','FPS_6819e7bdc5d','1'),('Khordha','School232','21170801404','20.103755','85.668006','75','FPS_6819e7bdc86','1'),('Khordha','School233','2117080141','20.101298','85.664665','107','FPS_6819e7bdc9c','1'),('Khordha','School234','21170806003','20.123402','85.64686','170','FPS_6819e7bdcb6','1'),('Khordha','School235','21170801703','20.070745','85.676517','650','FPS_6819e7bdccd','1'),('Khordha','School236','21170801701','20.070745','85.676517','300','FPS_6819e7bdcdf','1'),('Khordha','School237','21170801402','80.3473','20.1342','120','FPS_6819e7bdcfb','1'),('Khordha','School238','21170803702','20.252','85.6864','120','FPS_6819e7bdd10','1'),('Khordha','School239','21170803502','85.42','20.09','650','FPS_6819e7bdd25','1'),('Khordha','School240','21170803501','20.244084','85.701437','300','FPS_6819e7bdd4d','1'),('Khordha','School241','21170803701','20.246782','85.685296','300','FPS_6819e7bdd67','1'),('Khordha','School242','21170808101','20.307455','85.811141','400','FPS_6819e7bdd85','1'),('Khordha','School243','21170804202','85.686343','20.264055','80','FPS_6819e7bdda2','1'),('Khordha','School244','21170804001','20.23427','85.711923','45','FPS_6819e7bddc6','1'),('Khordha','School245','21170804201','85.68824','20.26273','120','FPS_6819e7bdde2','1'),('Khordha','School246','21170803602','20.282319','85.667362','57','FPS_6819e7bde09','1'),('Khordha','School247','21170803901','85.69953','20.22565','100','FPS_6819e7bde21','1'),('Khordha','School248','21170804902','12.7208','85.67222','200','FPS_6819e7bde39','1'),('Khordha','School249','21170809001','18.0233','85.666088','58','FPS_6819e7bde53','1'),('Khordha','School250','21170809101','11.711','85.666086','175','FPS_6819e7bde6a','1'),('Khordha','School251','21170809401','18.0233','85.688004','500','FPS_6819e7bde91','1'),('Khordha','School252','21170805801','14.4045','85.660273','350','FPS_6819e7bdeaa','1'),('Khordha','School253','21170808802','17.6803','85.664886','800','FPS_6819e7bdec5','1'),('Khordha','School254','21170809301','17.2995','85.676185','325','FPS_6819e7bdedd','1'),('Khordha','School255','21170809201','16.1808','85.679001','100','FPS_6819e7bdef0','1'),('Khordha','School256','21170809151','11.7111','85.679001','60','FPS_6819e7bdf0a','1'),('Khordha','School257','21170804901','12.5585','85.667173','118','FPS_6819e7bdf1f','1'),('Khordha','School258','21170808801','17.6803','85.664886','700','FPS_6819e7bdf31','1'),('Khordha','School259','21170807201','20.213266','85.706234','100','FPS_6819e7be01c','1'),('Khordha','School260','21170807202','20.201006','85.693131','800','FPS_6819e7be03a','1'),('Khordha','School261','21170808501','20.24336','85.72309','100','FPS_6819e7be062','1'),('Khordha','School262','21170807502','20.221135','85.711688','150','FPS_6819e7be094','1'),('Khordha','School263','21170808001','20.23508','85.727461','130','FPS_6819e7be0b3','1'),('Khordha','School264','21170808401','20.263056','85.733889','100','FPS_6819e7be0d5','1'),('Khordha','School265','21170806901','20.212104','85.712619','150','FPS_6819e7be0e6','1'),('Khordha','School266','21170808701','20.244353','85.723052','100','FPS_6819e7be0fc','1'),('Khordha','School267','21170807102','20.217509','85.717043','150','FPS_6819e7be110','1'),('Khordha','School268','21170801101','20.253924','85.667547','470','FPS_6819e7be124','1'),('Khordha','School269','21170801001','20.243923','85.667447','210','FPS_6819e7be137','1'),('Khordha','School270','21170801002','20.245758','85.668174','150','FPS_6819e7be151','1'),('Khordha','School271','21170800101','20.25569','85.647141','170','FPS_6819e7be16f','1'),('Khordha','School272','21170800701','20.248692','85.636148','700','FPS_6819e7be195','1'),('Khordha','School273','21170800601','20.238029','85.641855','60','FPS_6819e7be1b4','1'),('Khordha','School274','21170800901','20.263535','85.64272','100','FPS_6819e7be1d2','1'),('Khordha','School275','21170800801','20.258858','85.63514','55','FPS_6819e7be1ef','1'),('Khordha','School276','21170805704','20.269662','85.6345','85','FPS_6819e7be20d','1'),('Khordha','School277','21170803601','20.26161','85.663292','130','FPS_6819e7be227','1'),('Khordha','School278','21170803503','20.259848','85.666444','70','FPS_6819e7be24b','1'),('Khordha','School279','21170806601','85.799977','20.179046','173','FPS_6819e7be26c','1'),('Khordha','School280','21170806602','85.799019','20.177146','260','FPS_6819e7be293','1'),('Khordha','School281','21170809701','85.791836','20.189949','60','FPS_6819e7be2cf','1'),('Khordha','School282','21170810001','85.795618','20.196019','775','FPS_6819e7be2ec','1'),('Khordha','School283','21170809601','85.80348','20.211386','450','FPS_6819e7be318','1'),('Khordha','School284','21170810871','85.780278','20.205','414','FPS_6819e7be337','1'),('Khordha','School285','21170810802','85.764553','20.197082','255','FPS_6819e7be364','1'),('Khordha','School286','21170811101','85.756874','20.191857','113','FPS_6819e7be387','1'),('Khordha','School287','21170802672','20.159','85.70742','100','FPS_6819e7be3a4','1'),('Khordha','School288','21170804501','20.2005','85.6794','700','FPS_6819e7be3d2','1'),('Khordha','School289','21170806301','20.1762018','85.778789','637','FPS_6819e7be3f4','1'),('Khordha','School290','21170807902','20.168337','85.733652','639','FPS_6819e7be410','1'),('Khordha','School291','21170807701','20.170326','85.74343','341','FPS_6819e7be42d','1'),('Khordha','School292','21170807601','20.147621','85.7508','192','FPS_6819e7be457','1'),('Khordha','School293','21170806401','20.1733205','85.7692234','81','FPS_6819e7be474','1'),('Khordha','School294','21170806201','20.165745','85.788422','104','FPS_6819e7be48c','1'),('Khordha','School295','21170807901','20.168367','85.733622','29','FPS_6819e7be4b3','1'),('Khordha','School296','21170807803','20.1672364','85.7600803','157','FPS_6819e7be4c9','1'),('Khordha','School297','21170806302','20.1706939','85.62444','680','FPS_6819e7be4e3','1'),('Khordha','School298','21170807801','20.159146','85.760742','87','FPS_6819e7be4fd','1'),('Khordha','School299','21170807851','20.16889','85.748496','471','FPS_6819e7be51b','1'),('Khordha','School300','21171401453','20.150278','85.694444','48','FPS_6819e7be552','1'),('Khordha','School301','21171401273','20.151944','85.685','78','FPS_6819e7be591','1'),('Khordha','School302','21171401101','20.165','85.713611','183','FPS_6819e7be5ee','1'),('Khordha','School303','21171404201','20.151389','85.722778','88','FPS_6819e7be612','1'),('Khordha','School304','21171401454','20.15','85.694444','450','FPS_6819e7be65b','1'),('Khordha','School305','21171401401','20.15','85.716667','250','FPS_6819e7be69f','1'),('Khordha','School306','21171402273','20.150278','85.725278','500','FPS_6819e7be6c9','1'),('Khordha','School307','21171402173','20.135833','85.712222','268','FPS_6819e7be6ee','1'),('Khordha','School308','21471402305','20.150833','85.729444','500','FPS_6819e7be708','1'),('Khordha','School309','21171401204','20.162778','85.702778','500','FPS_6819e7be725','1'),('Khordha','School310','21171400901','20.18199','85.70234','132','FPS_6819e7be747','1'),('Khordha','School311','21171400872','20.16465','85.70911','288','FPS_6819e7be76b','1'),('Khordha','School312','21171400503','20.16642','85.71436','160','FPS_6819e7be78c','1'),('Khordha','School313','21171402202','20.16563','85.70043','136','FPS_6819e7be7b4','1'),('Khordha','School314','21171401002','20.16879','85.69085','305','FPS_6819e7be7ee','1'),('Khordha','School315','21171401174','20.16576','85.69478','190','FPS_6819e7be809','1'),('Khordha','School316','21171400601','20.1595','85.71124','115','FPS_6819e7be831','1'),('Khordha','School317','21171400801','20.167109','85.704604','190','FPS_6819e7be84f','1'),('Khordha','School318','21171400803','20.17251','85.70231','140','FPS_6819e7be872','1'),('Khordha','School319','21171400201','20.16822','85.71428','130','FPS_6819e7be898','1'),('Khordha','School320','21171404301','20.1795','85.70213','140','FPS_6819e7be8e3','1'),('Khordha','School321','21170909902','20.26','85.19','1.5','FPS_6819e7be92c','1'),('Khordha','School322','21170909101','20.033055','85.589091','1.5','FPS_6819e7be98f','1'),('Khordha','School323','21170909301','20.04109','85.583256','8.7','FPS_6819e7be9f0','1'),('Khordha','School324','21170902501','20.062496','85.589685','2.7','FPS_6819e7bea23','1'),('Khordha','School325','21170902551','26.911','75.78','100','FPS_6819e7bea50','1'),('Khordha','School326','21170902001','20.034345','85.615117','2.5','FPS_6819e7bea7f','1'),('Khordha','School327','21170909901','20.185649','85.627287','23.41','FPS_6819e7beaa9','1'),('Khordha','School328','21170909601','20.1048','85.3712','3.5','FPS_6819e7bead0','1'),('Khordha','School329','21170909501','20.039803','85.587049','60','FPS_6819e7beafa','1'),('Khordha','School330','21170907102','20.153626','85.61741','100','FPS_6819e7beb33','1'),('Khordha','School331','21170910705','20.092263','85.594793','2.5','FPS_6819e7beb64','1'),('Khordha','School332','21170910702','20.1','85.5844','3','FPS_6819e7beb7f','1'),('Khordha','School333','21170906601','20.145506','85.621514','0.5','FPS_6819e7bebb6','1'),('Khordha','School334','21170900401','20.115472','85.591751','1.5','FPS_6819e7bebdc','1'),('Khordha','School335','21170906701','20.194223','85.625725','3','FPS_6819e7bec01','1'),('Khordha','School336','21170910601','20.099651','85.603132','2.65','FPS_6819e7bec20','1'),('Khordha','School337','21170906901','20.12','85.58','6.8','FPS_6819e7bec4b','1'),('Khordha','School338','21170907101','20.194223','85.625725','2.5','FPS_6819e7bec72','1'),('Khordha','School339','21170906801','20.194223','85.625725','7.5','FPS_6819e7bec9c','1'),('Khordha','School340','21170910775','20.084023','85.591493','7.5','FPS_6819e7becc8','1'),('Khordha','School341','21170911901','28.608537','80.60399','100','FPS_6819e7beceb','1'),('Khordha','School342','21171500601','20.177935','85.623532','6','FPS_6819e7bed17','1'),('Khordha','School343','21171500801','20.18377','85.617208','15','FPS_6819e7bed3a','1'),('Khordha','School344','21171501201','20.1841','85.6203','17.28','FPS_6819e7bed5a','1'),('Khordha','School345','21171501401','20.184253','85.622981','3','FPS_6819e7bed81','1'),('Khordha','School346','21171500401','20.181123','85.622769','1.5','FPS_6819e7beda6','1'),('Khordha','School347','21171500303','20.242461','85.561473','3','FPS_6819e7bedcc','1'),('Khordha','School348','21171500301','20.171641','85.632732','0.5','FPS_6819e7bedfb','1'),('Khordha','School349','2117150901','20.175971','85.61277','5.5','FPS_6819e7bee1c','1'),('Khordha','School350','21171501101','20.166','85.7121','2.5','FPS_6819e7bee48','1'),('Khordha','School351','21171500501','20.1863','85.6223','3','FPS_6819e7bee69','1'),('Khordha','School352','21170911902','20.1569','85.6073','4.6','FPS_6819e7bee8d','1'),('Khordha','School353','21170907701','20.258461','85.581814','2.57','FPS_6819e7beeae','1'),('Khordha','School354','21170907301','20.1942','85.6257','5','FPS_6819e7beecf','1'),('Khordha','School355','21170913201','20.19','85.62','4','FPS_6819e7beeee','1'),('Khordha','School356','21170907702','20.2551','85.5828','11.27','FPS_6819e7bef1c','1'),('Khordha','School357','21170907601','20.233928','85.60062','4','FPS_6819e7bef3d','1'),('Khordha','School358','21170907351','20.1942','85.6257','6.6','FPS_6819e7bf03c','1'),('Khordha','School359','21170907901','20.25786','85.58854','2','FPS_6819e7bf05a','1'),('Khordha','School360','21170908001','26.91','75.8','100','FPS_6819e7bf08f','1'),('Khordha','School361','21170912501','20.2','85.56','5','FPS_6819e7bf0b2','1'),('Khordha','School362','21170908402','20.194','85.625','5','FPS_6819e7bf0da','1'),('Khordha','School363','21170909003','20.17','85.56','5','FPS_6819e7bf0f9','1'),('Khordha','School364','21170916001','20.194','85.625','1.25','FPS_6819e7bf115','1'),('Khordha','School365','21170909001','20.2025','85.865','2.7','FPS_6819e7bf12f','1'),('Khordha','School366','21170908401','20.176','85.56','3','FPS_6819e7bf14b','1'),('Khordha','School367','21170908901','20.187345','85.5885117','4','FPS_6819e7bf16a','1'),('Khordha','School368','21170908601','20.185649','85.627287','3','FPS_6819e7bf18e','1'),('Khordha','School369','21170913401','20.1048','85.3712','1','FPS_6819e7bf1b2','1'),('Khordha','School370','21170912201','20.039803','85.587049','0.8','FPS_6819e7bf1dd','1'),('Khordha','School371','21170909002','20.17','85.56','0.35','FPS_6819e7bf1f8','1'),('Khordha','School372','21170905801','20.22','85.56','0.75','FPS_6819e7bf217','1'),('Khordha','School373','21170904901','85.54887','20.13626','13.5','FPS_6819e7bf233','1'),('Khordha','School374','21170901101','85.53499','20.155525','9.07','FPS_6819e7bf250','1'),('Khordha','School375','21170904904','20.114212','85.553908','0.47','FPS_6819e7bf266','1'),('Khordha','School376','21170905001','20.130527','85.545286','0.85','FPS_6819e7bf282','1'),('Khordha','School377','21170904902','20.131458','85.553782','4.84','FPS_6819e7bf2a6','1'),('Khordha','School378','21170901001','20.15222','85.52978','2.1','FPS_6819e7bf2c1','1'),('Khordha','School379','21170904951','20.131458','85.553782','2.95','FPS_6819e7bf2e2','1'),('Khordha','School380','21170901201','20.13378','85.54586','1.53','FPS_6819e7bf2fe','1'),('Khordha','School381','21170900201','20.12389','85.627098','3.89','FPS_6819e7bf328','1'),('Khordha','School382','21170901601','20.063593','85.613038','3.31','FPS_6819e7bf347','1'),('Khordha','School383','21170902102','20.07538','85.60717','1.59','FPS_6819e7bf369','1'),('Khordha','School384','21170901602','20.06215','85.610229','5.3','FPS_6819e7bf38b','1'),('Khordha','School385','21170900103','20.185','85.627','32','FPS_6819e7bf3b3','1'),('Khordha','School386','21170900202','20.1263','85.6168','0.85','FPS_6819e7bf3d7','1'),('Khordha','School387','21107900501','20.104852','85.601593','1','FPS_6819e7bf3ff','1'),('Khordha','School388','21170910510','20.185646','85.62729','2.1','FPS_6819e7bf435','1'),('Khordha','School389','21170900301','20.1066533','85.63833','2.08','FPS_6819e7bf456','1'),('Khordha','School390','21170910201','20.08889','85.618271','7.33','FPS_6819e7bf470','1'),('Khordha','School391','21107902101','20.078118','85.604674','5.9','FPS_6819e7bf497','1'),('Khordha','School392','21170910251','20.088036','85.625639','2.4','FPS_6819e7bf4b6','1'),('Khordha','School393','21171501603','20.197698','85.620452','26.8','FPS_6819e7bf4dd','1'),('Khordha','School394','21171501902','20.186857','85.615904','7.5','FPS_6819e7bf4fc','1'),('Khordha','School395','21171500351','20.178228','85.636807','4.3','FPS_6819e7bf51d','1'),('Khordha','School396','21171500302','20.18','85.62','1.4','FPS_6819e7bf54d','1'),('Khordha','School397','21171501202','20.186857','85.615904','1.5','FPS_6819e7bf571','1'),('Khordha','School398','21171502101','20.185968','85.640415','8.75','FPS_6819e7bf58e','1'),('Khordha','School399','21170912701','20.219443','85.629505','1.86','FPS_6819e7bf5b4','1'),('Khordha','School400','21170913301','20.2087151','85.6259498','1.8','FPS_6819e7bf5ea','1'),('Khordha','School401','21171500101','20.183592','85.64972','10.5','FPS_6819e7bf60f','1'),('Khordha','School402','21171502102','20.185744','85.635008','1.5','FPS_6819e7bf630','1'),('Khordha','School403','21170912901','20.215563','85.64074','1.05','FPS_6819e7bf655','1'),('Khordha','School404','21171502001','20.187475','85.624238','0.5','FPS_6819e7bf679','1'),('Khordha','School405','21170903801','20.02771','85.54993','1.1','FPS_6819e7bf698','1'),('Khordha','School406','21170904601','20.04','85.53','10.05','FPS_6819e7bf6b7','1'),('Khordha','School407','21170904501','20.043152','85.512608','0.45','FPS_6819e7bf6d6','1'),('Khordha','School408','21170903901','20.0126','85.32','23.57','FPS_6819e7bf6f6','1'),('Khordha','School409','21170910901','20.0161128','85.5890247','1.1','FPS_6819e7bf713','1'),('Khordha','School410','21170911403','20.972','85.57895','2.5','FPS_6819e7bf738','1'),('Khordha','School411','hs_orabsingh','20.972','85.57895','2','FPS_6819e7bf762','1'),('Khordha','School412','21170908102','20.269913','85.57794','1.1','FPS_6819e7bf794','1'),('Khordha','School413','21170902651','20.268457','85.562542','4.87','FPS_6819e7bf7d3','1'),('Khordha','School414','21170902602','20.268341','85.562736','2.96','FPS_6819e7bf80e','1'),('Khordha','School415','21170902601','20.27506','85.563287','3.32','FPS_6819e7bf848','1'),('Khordha','School416','21170902901','20.2785912','85.5666502','1.87','FPS_6819e7bf8de','1'),('Khordha','School417','21170903101','20.284363','85.561838','0.8','FPS_6819e7bf977','1'),('Khordha','School418','21170902902','20.2790172','85.5627723','1.71','FPS_6819e7bf9b9','1'),('Khordha','School419','21170902801','20.279862','85.516321','5.58','FPS_6819e7bfa16','1'),('Khordha','School420','21170903002','20.1986','85.6195','12','FPS_6819e7bfb30','1'),('Khordha','School421','21170916101','20.300955','85.571662','0.81','FPS_6819e7bfb58','1'),('Khordha','School422','21170913103','20.220613','85.591721','3','FPS_6819e7bfc78','1'),('Khordha','School423','21170913101','20.242461','85.561473','8','FPS_6819e7bfce2','1'),('Khordha','School424','21170906502','20.2273518','85.5800868','2.5','FPS_6819e7bfd10','1'),('Khordha','School425','21170906401','20.2373166','85.57865','0.75','FPS_6819e7bfd43','1'),('Khordha','School426','21170906201','20.244733','85.571348','0.9','FPS_6819e7bfd67','1'),('Khordha','School427','21170906204','20.239059','85.562657','1','FPS_6819e7bfdb2','1'),('Khordha','School428','21170906202','20.13543','85.34037','14.6','FPS_6819e7bfe15','1'),('Khordha','School429','21170906272','20.242461','85.561473','0.9','FPS_6819e7bfe39','1'),('Khordha','School430','21170906301','20.240365','85.54765','2.5','FPS_6819e7bfe80','1'),('Khordha','School431','21170906351','20.239752','85.547165','5.5','FPS_6819e7bfead','1'),('Khordha','School432','21170905301','20.069629','85.567464','0.5','FPS_6819e7bff1d','1'),('Khordha','School433','21170905403','20.075229','85.565999','0.65','FPS_6819e7c0062','1'),('Khordha','School434','21170905701','20.062201','85.570296','0.65','FPS_6819e7c00a8','1'),('Khordha','School435','21170902201','20.061596','85.580389','1.2','FPS_6819e7c00dd','1'),('Khordha','School436','21170903501','20.061773','85.552113','1.73','FPS_6819e7c0101','1'),('Khordha','School437','21170903301','20.056733','85.54939','1.4','FPS_6819e7c01cc','1'),('Khordha','School438','21170903601','20.047642','85.555406','4','FPS_6819e7c01ec','1'),('Khordha','School439','21170905602','20.072478','85.561754','8.81','FPS_6819e7c020e','1'),('Khordha','School440','21170902203','20.061596','85.580389','0.94','FPS_6819e7c023b','1'),('Khordha','School441','21170903351','20.057115','85.54706','2.8','FPS_6819e7c025d','1'),('Khordha','School442','21170903602','20.050357','85.549872','3','FPS_6819e7c02a2','1'),('Khordha','School443','21170905601','20.080269','85.563467','5.2','FPS_6819e7c0315','1'),('Khordha','School444','21170904703','20.12613','85.5673','11.49','FPS_6819e7c0350','1'),('Khordha','School445','21170912001','20.17','85.59','1','FPS_6819e7c03bb','1'),('Khordha','School446','21170911951','32.18','76.64','100','FPS_6819e7c03e5','1'),('Khordha','School447','21170911702','20.15','85.57','4','FPS_6819e7c0464','1'),('Khordha','School448','21170912002','20.169','85.59','0.7','FPS_6819e7c0494','1'),('Khordha','School449','21170911501','20.169','85.578','0.71','FPS_6819e7c04ce','1'),('Khordha','School450','21170904801','20.136','85.5634','2.6','FPS_6819e7c04f1','1'),('Khordha','School451','21170908501','20.17','85.5','0.69','FPS_6819e7c0522','1'),('Khordha','School452','21170911701','20.161','85.579','0.66','FPS_6819e7c0543','1'),('Khordha','School453','21170911903','20.156','85.59','3','FPS_6819e7c094a','1'),('Khordha','School454','21171000102','19.715076','85.190143','840','FPS_6819e7c09a1','1'),('Khordha','School455','21171000101','19.715159','85.167357','700','FPS_6819e7c09e0','1'),('Khordha','School456','21171000701','19.692915','85.177657','510','FPS_6819e7c0a18','1'),('Khordha','School457','21171004502','19.681031','85.180802','78','FPS_6819e7c0a3b','1'),('Khordha','School458','21171000901','19.696544','85.190206','300','FPS_6819e7c0a66','1'),('Khordha','School459','21171000201','19.699469','85.190735','51','FPS_6819e7c0a92','1'),('Khordha','School460','21171001001','19.707526','85.173638','75','FPS_6819e7c0ab7','1'),('Khordha','School461','21171005101','19.709213','85.17629','136','FPS_6819e7c0adf','1'),('Khordha','School462','21171005102','19.72708','85.175214','183','FPS_6819e7c0b12','1'),('Khordha','School463','21171004201','19.713474','85.186565','120','FPS_6819e7c0b44','1'),('Khordha','School464','21171004501','19.744602','85.213657','81','FPS_6819e7c0b71','1'),('Khordha','School465','21171004801','19.754689','85.198169','27','FPS_6819e7c0b9a','1'),('Khordha','School466','21171001901','19.748256','85.206404','50','FPS_6819e7c0bcf','1'),('Khordha','School467','21171001801','19.745175','85.209046','56','FPS_6819e7c0c17','1'),('Khordha','School468','21171021601','19.738772','85.210088','12','FPS_6819e7c0c3d','1'),('Khordha','School469','21171001401','19.743459','85.19755','15','FPS_6819e7c0c6f','1'),('Khordha','School470','21171001701','19.750492','85.20464','30','FPS_6819e7c0ca1','1'),('Khordha','School471','21171001301','19.731635','85.171237','120','FPS_6819e7c0cdd','1'),('Khordha','School472','21171021701','20.288875','85.8302','10','FPS_6819e7c0d0f','1'),('Khordha','School473','21171001201','19.722289','85.192805','400','FPS_6819e7c0d34','1'),('Khordha','School474','21171001601','19.737222','85.160576','96','FPS_6819e7c0d5b','1'),('Khordha','School475','21171001203','19.729787','85.196702','30','FPS_6819e7c0d83','1'),('Khordha','School476','21171003173','19.729113','85.202044','4.4','FPS_6819e7c0db1','1'),('Khordha','School477','21171002802','19.72498','85.165131','675','FPS_6819e7c0dd7','1'),('Khordha','School478','21171002853','19.740474','85.189259','110','FPS_6819e7c0dfd','1'),('Khordha','School479','21171003304','19.735699','85.158735','160','FPS_6819e7c0e1d','1'),('Khordha','School480','21171003001','19.898652','85.393101','170','FPS_6819e7c0e3b','1'),('Khordha','School481','21171003101','19.892735','85.400238','250','FPS_6819e7c0e74','1'),('Khordha','School482','21171002804','19.88763','85.369008','204','FPS_6819e7c0ea7','1'),('Khordha','School483','21171002801','19.893014','85.401617','364','FPS_6819e7c0ecf','1'),('Khordha','School484','21171002803','19.892743','85.40064','150','FPS_6819e7c0ef4','1'),('Khordha','School485','21171003801','19.892679','85.400431','500','FPS_6819e7c0f40','1'),('Khordha','School486','21171004051','19.892727','85.400745','100','FPS_6819e7c1040','1'),('Khordha','School487','21171004001','19.8548','85.381431','98','FPS_6819e7c1071','1'),('Khordha','School488','21171003601','19.89273','85.400612','68','FPS_6819e7c10a8','1'),('Khordha','School489','21171015902','19.902433','85.416578','300','FPS_6819e7c10d6','1'),('Khordha','School490','21171015901','19.890774','85.400162','450','FPS_6819e7c1114','1'),('Khordha','School491','21171015701','19.883029','85.413767','15','FPS_6819e7c115a','1'),('Khordha','School492','21171015801','19.887802','85.406752','15','FPS_6819e7c118f','1'),('Khordha','School493','21171017001','19.884103','85.402191','950','FPS_6819e7c11b6','1'),('Khordha','School494','21171016202','19.892626','85.416321','93','FPS_6819e7c11f4','1'),('Khordha','School495','21171016701','19.88923','85.41473','583','FPS_6819e7c1236','1'),('Khordha','School496','21171016201','19.91564','85.404181','33','FPS_6819e7c127c','1'),('Khordha','School497','21171017302','19.834901','85.334678','36','FPS_6819e7c12a5','1'),('Khordha','School498','21171021305','19.830883','85.326376','10','FPS_6819e7c12f5','1'),('Khordha','School499','21171021301','19.842751','85.351772','150','FPS_6819e7c1323','1'),('Khordha','School500','21171021306','19.838821','85.356281','100','FPS_6819e7c135a','1'),('Khordha','School501','21171021202','19.838267','85.353593','150','FPS_6819e7c1385','1'),('Khordha','School502','21171020901','19.850232','85.346126','12','FPS_6819e7c13b2','1'),('Khordha','School503','21171021307','19.855267','85.322439','95','FPS_6819e7c13dc','1'),('Khordha','School504','21171021201','19.85308','85.340114','45','FPS_6819e7c1401','1'),('Khordha','School505','21171019901','19.85','85.34','35','FPS_6819e7c145a','1'),('Khordha','School506','21171021304','19.843779','85.353955','25','FPS_6819e7c148b','1'),('Khordha','School507','21171021302','19.831057','85.297244','30','FPS_6819e7c14c0','1'),('Khordha','School508','21171021001','19.833911','85.344471','15','FPS_6819e7c14f7','1'),('Khordha','School509','21171021303','19.815314','85.297227','60','FPS_6819e7c1530','1'),('Khordha','School510','21171006701','19.82572','85.312099','20','FPS_6819e7c1562','1'),('Khordha','School511','21171006703','19.816877','85.3132','100','FPS_6819e7c1588','1'),('Khordha','School512','21171007101','19.829365','85.312491','168','FPS_6819e7c15ad','1'),('Khordha','School513','21171006301','19.80702','85.321112','138','FPS_6819e7c15ca','1'),('Khordha','School514','21171005903','19.817478','85.339045','500','FPS_6819e7c15e5','1'),('Khordha','School515','21171005904','19.807003','85.320931','150','FPS_6819e7c15fd','1'),('Khordha','School516','21171015401','19.785422','85.237518','245','FPS_6819e7c161d','1'),('Khordha','School517','21171014502','19.793556','85.265003','200','FPS_6819e7c1640','1'),('Khordha','School518','21171014601','19.8056','85.262519','160','FPS_6819e7c165e','1'),('Khordha','School519','21171014501','19.785164','85.247848','25','FPS_6819e7c1685','1'),('Khordha','School520','21171015403','19.788617','85.226879','20','FPS_6819e7c16ad','1'),('Khordha','School521','21171015402','19.788649','85.215647','35','FPS_6819e7c16e1','1'),('Khordha','School522','21171018001','19.784017','85.258423','45','FPS_6819e7c1726','1'),('Khordha','School523','21171018002','19.792946','85.235106','85','FPS_6819e7c174e','1'),('Khordha','School524','21171008701','19.79584','85.251109','25','FPS_6819e7c1777','1'),('Khordha','School525','21171009301','19.779916','85.231904','500','FPS_6819e7c179d','1'),('Khordha','School526','21171008702','19.802447','85.305058','450','FPS_6819e7c17ba','1'),('Khordha','School527','21171008901','19.820519','85.268352','15','FPS_6819e7c17db','1'),('Khordha','School528','21171021501','19.792012','85.239047','10','FPS_6819e7c17fd','1'),('Khordha','School529','21171009201','19.804659','85.308772','25','FPS_6819e7c1822','1'),('Khordha','School530','21171008201','19.814527','85.27262','20','FPS_6819e7c1848','1'),('Khordha','School531','21171007601','19.804132','85.303782','15','FPS_6819e7c1883','1'),('Khordha','School532','21171008601','19.80253','85.27522','14','FPS_6819e7c18b1','1'),('Khordha','School533','21171009001','19.795193','85.241034','12','FPS_6819e7c18d2','1'),('Khordha','School534','21171008251','19.843729','85.329361','56','FPS_6819e7c1908','1'),('Khordha','School535','21171013302','19.81267','85.26075','230','FPS_6819e7c1945','1'),('Khordha','School536','21171013301','19.774141','85.223799','237','FPS_6819e7c1983','1'),('Khordha','School537','21171013972','19.769593','85.234985','200.1','FPS_6819e7c19a8','1'),('Khordha','School538','21171013001','19.753947','85.216539','123','FPS_6819e7c19c7','1'),('Khordha','School539','21171013601','19.749072','85.218868','84','FPS_6819e7c19e4','1'),('Khordha','School540','21171012801','19.758458','85.228413','57','FPS_6819e7c1a0c','1'),('Khordha','School541','21171013801','19.760377','85.21384','264','FPS_6819e7c1a31','1'),('Khordha','School542','21171013401','19.774667','85.208519','600','FPS_6819e7c1a57','1'),('Khordha','School543','21171010451','19.773892','85.223741','410','FPS_6819e7c1a83','1'),('Khordha','School544','21171010501','19.773513','85.223507','250','FPS_6819e7c1aa9','1'),('Khordha','School545','21171010701','19.873313','85.397482','225','FPS_6819e7c1ad1','1'),('Khordha','School546','21171010301','19.881266','85.381273','310','FPS_6819e7c1b00','1'),('Khordha','School547','21171009901','19.847519','85.369234','520','FPS_6819e7c1b37','1'),('Khordha','School548','21171010801','19.854781','85.38142','90','FPS_6819e7c1b68','1'),('Khordha','School549','21171010502','19.887389','85.388372','40','FPS_6819e7c1ba2','1'),('Khordha','School550','21171009801','19.844454','85.361087','45','FPS_6819e7c1bcc','1'),('Khordha','School551','21171010101','19.862525','85.335337','80','FPS_6819e7c1bf4','1'),('Khordha','School552','21171012202','19.852443','85.339609','125','FPS_6819e7c1c62','1'),('Khordha','School553','21171012201','19.881266','85.381273','182','FPS_6819e7c1ca4','1'),('Khordha','School554','21171012301','19.873313','85.397482','9.5','FPS_6819e7c1cd2','1'),('Khordha','School555','21171017301','19.881266','85.381273','51','FPS_6819e7c1cfa','1'),('Khordha','School556','21171017303','19.847519','85.369234','63','FPS_6819e7c1d25','1'),('Khordha','School557','21171011801','19.854781','85.38142','110','FPS_6819e7c1d61','1'),('Khordha','School558','21171011401','19.887389','85.388372','330','FPS_6819e7c1d95','1'),('Khordha','School559','21171010901','19.844454','85.361087','93.3','FPS_6819e7c1dd7','1'),('Khordha','School560','21171007502','19.862525','85.335337','160','FPS_6819e7c1dfd','1'),('Khordha','School561','21171017401','19.852443','85.339609','95','FPS_6819e7c1e2d','1'),('Khordha','School562','21171017402','19.881266','85.381273','56','FPS_6819e7c1e7a','1'),('Khordha','School563','21171017501','19.873313','85.397482','158','FPS_6819e7c1ea1','1'),('Khordha','School564','21171007571','19.881266','85.381273','100','FPS_6819e7c1ed8','1'),('Khordha','School565','21171007504','19.847519','85.369234','95','FPS_6819e7c1eff','1'),('Khordha','School566','21171007503','19.854781','85.38142','195','FPS_6819e7c1f3b','1'),('Khordha','School567','21171007303','19.887389','85.388372','95','FPS_6819e7c202e','1'),('Khordha','School568','21171007301','19.844454','85.361087','60','FPS_6819e7c2050','1'),('Khordha','School569','21171007501','19.862525','85.335337','160','FPS_6819e7c2075','1'),('Khordha','School570','21171007602','19.852443','85.339609','135','FPS_6819e7c20a4','1'),('Khordha','School571','21171018702','19.881266','85.381273','24','FPS_6819e7c20d1','1'),('Khordha','School572','21171019204','19.862525','85.335337','410','FPS_6819e7c2103','1'),('Khordha','School573','21171019202','19.852443','85.339609','134','FPS_6819e7c216c','1'),('Khordha','School574','21171019201','19.881266','85.381273','377','FPS_6819e7c219f','1'),('Khordha','School575','21171019203','19.881266','85.381273','270','FPS_6819e7c21c3','1'),('Khordha','School576','21171018601','19.862525','85.335337','480','FPS_6819e7c21e4','1'),('Khordha','School577','21171018501','19.852443','85.339609','120','FPS_6819e7c2202','1'),('Khordha','School578','21171019001','19.881266','85.381273','444','FPS_6819e7c2223','1'),('Khordha','School579','21171018701','19.881266','85.381273','209','FPS_6819e7c2258','1'),('Khordha','School580','21171007201','19.862525','85.335337','5','FPS_6819e7c2288','1'),('Khordha','School581','21171006801','19.852443','85.339609','167','FPS_6819e7c22ad','1'),('Khordha','School582','21171006101','19.881266','85.381273','180','FPS_6819e7c22cb','1'),('Khordha','School583','21171007001','19.881266','85.381273','1.38','FPS_6819e7c22ef','1'),('Khordha','School584','21171002203','19.862525','85.335337','10.8','FPS_6819e7c2310','1'),('Khordha','School585','21171002201','19.852443','85.339609','129','FPS_6819e7c232c','1'),('Khordha','School586','21171002202','19.881266','85.381273','106.5','FPS_6819e7c2342','1'),('Khordha','School587','21171002301','19.881266','85.381273','2.5','FPS_6819e7c235b','1'),('Khordha','School588','AKP1','20.376117','85.891463','350','FPS_6819e7c2374','1'),('Khordha','School589','akp2','20.376117','85.891463','195','FPS_6819e7c238f','1');

--
-- Table structure for table `fps_7yyscy76z37fws`
--

CREATE TABLE `fps_7yyscy76z37fws` (
  `district` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `id` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `latitude` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `longitude` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `demand` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `uniqueid` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `active` varchar(10) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fps_7yyscy76z37fws`
--

INSERT INTO `fps_7yyscy76z37fws` VALUES ('Ajmer','Xyz','15702','26.58542884','74.72220648','200','FPS_67d80ba8dc2','1'),('Ajmer','Xyz','15709','26.34616333','74.576395','40','FPS_67d80ba8dc8','1'),('Ajmer','Xyz','15710','26.36586765','74.55764074','50','FPS_67d80ba8dcf','1'),('Ajmer','Xyz','15711','26.4910416','74.7551718','30','FPS_67d80ba8dd9','1'),('Ajmer','Xyz','15712','26.48533375','74.78757091','80','FPS_67d80ba8ddd','1');

--
-- Table structure for table `fps_IO2L6LXC2rz1Sx`
--

CREATE TABLE `fps_IO2L6LXC2rz1Sx` (
  `district` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `id` varchar(100) NOT NULL,
  `latitude` varchar(100) NOT NULL,
  `longitude` varchar(100) NOT NULL,
  `demand` varchar(100) NOT NULL,
  `uniqueid` varchar(100) NOT NULL,
  `active` varchar(10) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `fps_IO2L6LXC2rz1Sx`
--


--
-- Table structure for table `fps_JVYiA1bt7f8Jzh`
--

CREATE TABLE `fps_JVYiA1bt7f8Jzh` (
  `district` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `id` varchar(100) NOT NULL,
  `latitude` varchar(100) NOT NULL,
  `longitude` varchar(100) NOT NULL,
  `demand` varchar(100) NOT NULL,
  `uniqueid` varchar(100) NOT NULL,
  `active` varchar(10) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `fps_JVYiA1bt7f8Jzh`
--

INSERT INTO `fps_JVYiA1bt7f8Jzh` VALUES ('Ajmer','Xyz','15702','26.58542884','74.72220648','200','FPS_67d80ba8dc2','1'),('Ajmer','Xyz','15709','26.34616333','74.576395','40','FPS_67d80ba8dc8','1'),('Ajmer','Xyz','15710','26.36586765','74.55764074','50','FPS_67d80ba8dcf','1'),('Ajmer','Xyz','15711','26.4910416','74.7551718','30','FPS_67d80ba8dd9','1'),('Ajmer','Xyz','15712','26.48533375','74.78757091','80','FPS_67d80ba8ddd','1');

--
-- Table structure for table `fps_qsooxvdolengmh`
--

CREATE TABLE `fps_qsooxvdolengmh` (
  `district` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `id` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `latitude` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `longitude` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `demand` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `uniqueid` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `active` varchar(10) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fps_qsooxvdolengmh`
--

INSERT INTO `fps_qsooxvdolengmh` VALUES ('Ajmer','Xyz','15702','26.58542884','74.72220648','200','FPS_67264da1c99','1'),('Ajmer','Xyz','15709','26.34616333','74.576395','40','FPS_67264da36ad','1'),('Ajmer','Xyz','15710','26.36586765','74.55764074','50','FPS_67264da3c98','1'),('Ajmer','Xyz','15711','26.4910416','74.7551718','30','FPS_67264da555b','1'),('Ajmer','Xyz','15712','26.48533375','74.78757091','80','FPS_67264da5d03','1');

--
-- Table structure for table `optimised_table`
--

CREATE TABLE `optimised_table` (
  `id` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `month` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `year` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `applicable` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `data` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `last_updated` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `rolled_out` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `cost` varchar(255) COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `optimised_table`
--

INSERT INTO `optimised_table` VALUES ('QsooxVdOlenGMH','nov','2024','july','9377.669612032016','2024-11-02 22:53:19','0',''),('7YySCY76z37fwS','march','','july','8343.39','2025-03-19 10:07:38','0',''),('IO2L6LXC2rz1Sx','may','2024','july','8221.469612032015','2025-05-06 09:56:24','0','0'),('JVYiA1bt7f8Jzh','may','','july','8221.469612032015','2025-05-02 09:30:53','0','0');

--
-- Table structure for table `optimised_table_leg1`
--

CREATE TABLE `optimised_table_leg1` (
  `id` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `month` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `year` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `applicable` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `data` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `last_updated` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `rolled_out` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `cost` varchar(255) COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `optimised_table_leg1`
--

INSERT INTO `optimised_table_leg1` VALUES ('vtqBEKb2ASz4qi','feb','2024','feb,april','1242.288','2024-02-18 16:03:52','1','231'),('BA4eWVHU9p5DTF','march','2024','april','87310008.33862533','2024-03-29 17:05:34','1','567'),('SIqdpnv7odgzlf','april','2024','','11625.86735','2024-04-22 00:48:50','1',''),('11O5OtEAWkLTCG','may','2024','','0.0','2024-05-15 17:58:29','0','');

--
-- Table structure for table `optimiseddata_7yyscy76z37fws`
--

CREATE TABLE `optimiseddata_7yyscy76z37fws` (
  `scenario` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `from` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `from_state` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `from_id` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `from_name` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `from_district` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `from_lat` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `from_long` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `to` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `to_state` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `to_id` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `to_name` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `to_district` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `to_lat` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `to_long` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `commodity` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `quantity` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `distance` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `approve_admin` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `approve_district` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `new_id_admin` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `new_id_district` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `new_name_admin` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `new_name_district` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reason_admin` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reason_district` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `new_distance_admin` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `new_distance_district` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `district_change_approve` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `optimiseddata_7yyscy76z37fws`
--

INSERT INTO `optimiseddata_7yyscy76z37fws` VALUES ('Optimized','Kitchen','Indonesia','NG19001','Fsd Ajmer','Ajmer','26.4016016','74.6224747','School','Indonesia','15709','Xyz','Ajmer','26.34616333','74.576395','Wheat','40','7.962',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Optimized','Kitchen','Indonesia','NG19001','Fsd Ajmer','Ajmer','26.4016016','74.6224747','School','Indonesia','15710','Xyz','Ajmer','26.36586765','74.55764074','Wheat','50','10.953',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Optimized','Kitchen','Indonesia','NG19001','Fsd Ajmer','Ajmer','26.4016016','74.6224747','School','Indonesia','15711','Xyz','Ajmer','26.4910416','74.7551718','Wheat','30','24.618',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Optimized','Kitchen','Indonesia','NG19001','Fsd Ajmer','Ajmer','26.4016016','74.6224747','School','Indonesia','15712','Xyz','Ajmer','26.48533375','74.78757091','Wheat','80','29.379',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Optimized','Kitchen','Indonesia','NG19002A','Fsd Kishangarh','Ajmer','26.5889508','74.8720944','School','Indonesia','15702','Xyz','Ajmer','26.58542884','74.72220648','Wheat','200','21.942',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `optimiseddata_IO2L6LXC2rz1Sx`
--

CREATE TABLE `optimiseddata_IO2L6LXC2rz1Sx` (
  `scenario` varchar(150) NOT NULL,
  `from` varchar(150) NOT NULL,
  `from_state` varchar(150) NOT NULL,
  `from_id` varchar(150) NOT NULL,
  `from_name` varchar(150) NOT NULL,
  `from_district` varchar(150) NOT NULL,
  `from_lat` varchar(150) NOT NULL,
  `from_long` varchar(150) NOT NULL,
  `to` varchar(150) NOT NULL,
  `to_state` varchar(150) NOT NULL,
  `to_id` varchar(150) NOT NULL,
  `to_name` varchar(150) NOT NULL,
  `to_district` varchar(150) NOT NULL,
  `to_lat` varchar(150) NOT NULL,
  `to_long` varchar(150) NOT NULL,
  `commodity` varchar(150) NOT NULL,
  `quantity` varchar(150) NOT NULL,
  `distance` varchar(150) NOT NULL,
  `approve_admin` varchar(100) DEFAULT NULL,
  `approve_district` varchar(100) DEFAULT NULL,
  `new_id_admin` varchar(100) DEFAULT NULL,
  `new_id_district` varchar(100) DEFAULT NULL,
  `new_name_admin` varchar(100) DEFAULT NULL,
  `new_name_district` varchar(10) DEFAULT NULL,
  `reason_admin` varchar(255) DEFAULT NULL,
  `reason_district` varchar(255) DEFAULT NULL,
  `new_distance_admin` varchar(100) DEFAULT NULL,
  `new_distance_district` varchar(100) DEFAULT NULL,
  `district_change_approve` varchar(100) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `optimiseddata_IO2L6LXC2rz1Sx`
--

INSERT INTO `optimiseddata_IO2L6LXC2rz1Sx` VALUES ('Optimized','Kitchen','Indonesia','NG19001','Fsd Ajmer','Ajmer','26.4016016','74.6224747','School','Indonesia','15711','Xyz','Ajmer','26.4910416','74.7551718','Wheat','30','24.618',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Optimized','Kitchen','Indonesia','NG19001','Fsd Ajmer','Ajmer','26.4016016','74.6224747','School','Indonesia','15712','Xyz','Ajmer','26.48533375','74.78757091','Wheat','80','29.379',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Optimized','Kitchen','Indonesia','NG19014','RSWC Ajmer      ','Ajmer','26.3926525','74.6149721','School','Indonesia','15709','Xyz','Ajmer','26.34616333','74.576395','Wheat','40','6.4414903008004',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Optimized','Kitchen','Indonesia','NG19014','RSWC Ajmer      ','Ajmer','26.3926525','74.6149721','School','Indonesia','15710','Xyz','Ajmer','26.36586765','74.55764074','Wheat','50','9.731',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Optimized','Kitchen','Indonesia','NG19002A','Fsd Kishangarh','Ajmer','26.5889508','74.8720944','School','Indonesia','15702','Xyz','Ajmer','26.58542884','74.72220648','Wheat','200','21.942',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `optimiseddata_JVYiA1bt7f8Jzh`
--

CREATE TABLE `optimiseddata_JVYiA1bt7f8Jzh` (
  `scenario` varchar(150) NOT NULL,
  `from` varchar(150) NOT NULL,
  `from_state` varchar(150) NOT NULL,
  `from_id` varchar(150) NOT NULL,
  `from_name` varchar(150) NOT NULL,
  `from_district` varchar(150) NOT NULL,
  `from_lat` varchar(150) NOT NULL,
  `from_long` varchar(150) NOT NULL,
  `to` varchar(150) NOT NULL,
  `to_state` varchar(150) NOT NULL,
  `to_id` varchar(150) NOT NULL,
  `to_name` varchar(150) NOT NULL,
  `to_district` varchar(150) NOT NULL,
  `to_lat` varchar(150) NOT NULL,
  `to_long` varchar(150) NOT NULL,
  `commodity` varchar(150) NOT NULL,
  `quantity` varchar(150) NOT NULL,
  `distance` varchar(150) NOT NULL,
  `approve_admin` varchar(100) DEFAULT NULL,
  `approve_district` varchar(100) DEFAULT NULL,
  `new_id_admin` varchar(100) DEFAULT NULL,
  `new_id_district` varchar(100) DEFAULT NULL,
  `new_name_admin` varchar(100) DEFAULT NULL,
  `new_name_district` varchar(10) DEFAULT NULL,
  `reason_admin` varchar(255) DEFAULT NULL,
  `reason_district` varchar(255) DEFAULT NULL,
  `new_distance_admin` varchar(100) DEFAULT NULL,
  `new_distance_district` varchar(100) DEFAULT NULL,
  `district_change_approve` varchar(100) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `optimiseddata_JVYiA1bt7f8Jzh`
--

INSERT INTO `optimiseddata_JVYiA1bt7f8Jzh` VALUES ('Optimized','Kitchen','Indonesia','NG19001','Fsd Ajmer','Ajmer','26.4016016','74.6224747','School','Indonesia','15711','Xyz','Ajmer','26.4910416','74.7551718','Wheat','30','24.618',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Optimized','Kitchen','Indonesia','NG19001','Fsd Ajmer','Ajmer','26.4016016','74.6224747','School','Indonesia','15712','Xyz','Ajmer','26.48533375','74.78757091','Wheat','80','29.379',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Optimized','Kitchen','Indonesia','NG19014','RSWC Ajmer      ','Ajmer','26.3926525','74.6149721','School','Indonesia','15709','Xyz','Ajmer','26.34616333','74.576395','Wheat','40','6.4414903008004',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Optimized','Kitchen','Indonesia','NG19014','RSWC Ajmer      ','Ajmer','26.3926525','74.6149721','School','Indonesia','15710','Xyz','Ajmer','26.36586765','74.55764074','Wheat','50','9.731',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Optimized','Kitchen','Indonesia','NG19002A','Fsd Kishangarh','Ajmer','26.5889508','74.8720944','School','Indonesia','15702','Xyz','Ajmer','26.58542884','74.72220648','Wheat','200','21.942',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `optimiseddata_qsooxvdolengmh`
--

CREATE TABLE `optimiseddata_qsooxvdolengmh` (
  `scenario` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `from` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `from_state` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `from_id` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `from_name` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `from_district` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `from_lat` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `from_long` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `to` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `to_state` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `to_id` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `to_name` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `to_district` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `to_lat` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `to_long` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `commodity` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `quantity` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `distance` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `approve_admin` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `approve_district` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `new_id_admin` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `new_id_district` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `new_name_admin` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `new_name_district` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reason_admin` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reason_district` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `new_distance_admin` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `new_distance_district` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `district_change_approve` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `optimiseddata_qsooxvdolengmh`
--

INSERT INTO `optimiseddata_qsooxvdolengmh` VALUES ('Optimized','Kitchen','Indonesia','NG19001','FSD Ajmer      ','Ajmer','26.4016016','74.6224747','School','Indonesia','15711','Xyz','Ajmer','26.4910416','74.7551718','Wheat','30','24.618',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Optimized','Kitchen','Indonesia','NG19001','FSD Ajmer      ','Ajmer','26.4016016','74.6224747','School','Indonesia','15712','Xyz','Ajmer','26.48533375','74.78757091','Wheat','80','29.379',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Optimized','Kitchen','Indonesia','NG19014','RSWC Ajmer      ','Ajmer','26.3926525','74.6149721','School','Indonesia','15709','Xyz','Ajmer','26.34616333','74.576395','Wheat','40','6.4414903008004',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Optimized','Kitchen','Indonesia','NG19014','RSWC Ajmer      ','Ajmer','26.3926525','74.6149721','School','Indonesia','15710','Xyz','Ajmer','26.36586765','74.55764074','Wheat','50','9.731',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Optimized','Kitchen','Indonesia','NG19002A','FSD Kishangarh      ','Ajmer','26.5889508','74.8720944','School','Indonesia','15702','Xyz','Ajmer','26.58542884','74.72220648','Wheat','200','27.723',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `timer`
--

CREATE TABLE `timer` (
  `deadline_date` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `deadline_time` varchar(255) COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `timer`
--

INSERT INTO `timer` VALUES ('2024-06-30','06:00');

--
-- Table structure for table `user_message`
--

CREATE TABLE `user_message` (
  `id` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `user_id` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `message` varchar(2000) COLLATE utf8mb4_general_ci NOT NULL,
  `date` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `acknowledged` varchar(10) COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_message`
--

INSERT INTO `user_message` VALUES ('cfd66d5488','658473c823921','hi','2024-03-24 02:58:28','no'),('a7a2704d9d','658556a9d53b1','hi','2024-03-24 02:58:28','yes'),('f98c91b890','65ccc9c29537f','hi','2024-03-24 02:58:28','no'),('8dda5e0b86','658556a9d53b1','hi','2024-03-24 02:58:48','yes'),('01eaec59a1','658473c823921','jjjj','2024-03-24 16:44:24','no'),('b825c17cb2','658473c823921','aa','2024-03-24 16:44:57','no'),('e761110826','658556a9d53b1','aa','2024-03-24 16:44:57','yes'),('cab3347a8d','65ccc9c29537f','aa','2024-03-24 16:44:57','no'),('839c71bdf7','658473c823921','hi','2024-03-28 00:56:54','no');

--
-- Table structure for table `warehouse`
--

CREATE TABLE `warehouse` (
  `district` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `id` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `warehousetype` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `type` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `latitude` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `longitude` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `storage` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `uniqueid` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `active` varchar(10) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `warehouse`
--

INSERT INTO `warehouse` VALUES ('Ganjam','Godown1','DP111403','PEG','Motorable','19.626168','85.128856','12500000','WH_6819e7640941','1'),('Nayagarh','Godown2','DW240706','OSWC','Motorable','20.0724','85.073185','50000000','WH_6819e7640e00','1'),('Cuttack','Godown3','DC070501','CWC','Motorable','20.460238','85.917387','17500000','WH_6819e76412da','1'),('Khordha','Godown4','DC190805','swc','Motorable','20.177776','85.702858','26280000','WH_6819e7641b39','1'),('Cuttack','Godown5','DG070401','RMC','Motorable','20.314095','85.929938','7500000','WH_6819e7641e17','1'),('Cuttack','Godown6','DG070601','RMC','Motorable','20.411305','85.605794','10000000','WH_6819e764205e','1'),('Cuttack','Godown7','DP070302','PEG','Motorable','20.441756','85.365724','12500000','WH_6819e7642237','1'),('Cuttack','Godown8','DP071202','PEG','Motorable','20.520595','86.101406','12500000','WH_6819e7642543','1'),('Khordha','Godown9','DP190402','PEG','Motorable','20.212652','85.41817','12500000','WH_6819e7642983','1'),('Nayagarh','Godown10','DP240701','Private','Motorable','20.003005','84.997048','10000000','WH_6819e7642cca','1'),('Nayagarh','Godown11','DP240704','Private','Motorable','20.073746','85.080996','26910000','WH_6819e7642fd5','1'),('Puri','Godown12','DP260702','PEG','Motorable','19.665264','85.387786','12500000','WH_6819e76433fc','1'),('Cuttack','Godown13','DS071802','OSCSC','Motorable','20.488367','85.938497','15000000','WH_6819e7643b49','1'),('Khordha','Godown14','DS190803','OSCSC','Motorable','20.16597','85.68981','5000000','WH_6819e7644486','1'),('Khordha','Godown15','DS191301','OSCSC','Motorable','20.302087','85.85965','12500000','WH_6819e7644c91','1'),('Puri','Godown16','DS261002','OSCSC','Motorable','19.803698','85.839174','13000000','WH_6819e7645101','1'),('Cuttack','Godown17','DW070201','OSWC','Motorable','20.374523','85.525343','5000000','WH_6819e7645630','1'),('Cuttack','Godown18','DW071806','OSWC','Motorable','20.492529','85.939185','30000000','WH_6819e764589d','1'),('Puri','Godown19','DW260802','OSWC','Motorable','20.046869','85.950053','25000000','WH_6819e7645db0','1'),('Puri','Godown20','DW261103','OSWC','Motorable','19.948831','85.818184','17500000','WH_6819e76460dc','1'),('Ganjam','Godown21','DC110104','CWC','Motorable','19.562981','84.661929','50000000','WH_6819e764661d','1'),('Ganjam','Godown22','DC112506','CWC','Motorable','19.292052','84.800017','20880000','WH_6819e7646fb3','1'),('Ganjam','Godown23','DG110403','RMC','Motorable','19.92966','84.58388','10000000','WH_6819e7647229','1'),('Ganjam','Godown24','DG110901','RMC','Motorable','19.3921182','84.5503042','12500000','WH_6819e7647740','1'),('Ganjam','Godown25','DG111102','RMC','Motorable','19.477165','84.741522','10000000','WH_6819e7647c51','1'),('Ganjam','Godown26','DG112005','RMC','Motorable','19.47457','84.63281','15000000','WH_6819e7647e87','1'),('Ganjam','Godown27','DP110302','PEG','Motorable','19.89294','84.61915','12500000','WH_6819e76481ab','1'),('Ganjam','Godown28','DP110608','Private','Motorable','19.334676','84.866846','15400000','WH_6819e76484f8','1'),('Ganjam','Godown29','DP111203','PEG','Motorable','19.9562916','84.8036','12500000','WH_6819e764875f','1'),('Ganjam','Godown30','DP111603','PEG','Motorable','19.128815','84.566828','12500000','WH_6819e76489fe','1'),('Ganjam','Godown31','DP111804','PEG','Motorable','19.558274','84.875269','12500000','WH_6819e7648c09','1'),('Ganjam','Godown32','DP111902','PEG','Motorable','19.227262','84.804275','12500000','WH_6819e7648d2c','1');

--
-- Table structure for table `warehouse_7yyscy76z37fws`
--

CREATE TABLE `warehouse_7yyscy76z37fws` (
  `district` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `id` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `warehousetype` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `type` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `latitude` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `longitude` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `storage` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `uniqueid` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `active` varchar(10) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `warehouse_7yyscy76z37fws`
--

INSERT INTO `warehouse_7yyscy76z37fws` VALUES ('Ajmer','Fsd Ajmer','NG19001','swc','motorable','26.4016016','74.6224747','202','WH_67d80b608541','1'),('Ajmer','Fsd Kishangarh','NG19002A','swc','motorable','26.5889508','74.8720944','200','WH_67d80b608683','1');

--
-- Table structure for table `warehouse_IO2L6LXC2rz1Sx`
--

CREATE TABLE `warehouse_IO2L6LXC2rz1Sx` (
  `district` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `id` varchar(100) NOT NULL,
  `warehousetype` varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  `latitude` varchar(100) NOT NULL,
  `longitude` varchar(100) NOT NULL,
  `storage` varchar(100) NOT NULL,
  `uniqueid` varchar(100) NOT NULL,
  `active` varchar(10) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `warehouse_IO2L6LXC2rz1Sx`
--

INSERT INTO `warehouse_IO2L6LXC2rz1Sx` VALUES ('Ajmer','Fsd Ajmer','NG19001','swc','motorable','26.4016016','74.6224747','202','WH_68146faaa819','1'),('Ajmer','Fsd Kishangarh','NG19002A','swc','motorable','26.5889508','74.8720944','200','WH_68146faaa905','1'),('Ajmer','RSWC Ajmer      ','NG19014','FCI','Motorable','26.3926525','74.6149721','200','WH_68146faaa9fe','1'),('Alwar','FSD Alwar      ','NG12001','FCI','Motorable','27.5391222','76.6188664','200','WH_68146faaaacf','1');

--
-- Table structure for table `warehouse_JVYiA1bt7f8Jzh`
--

CREATE TABLE `warehouse_JVYiA1bt7f8Jzh` (
  `district` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `id` varchar(100) NOT NULL,
  `warehousetype` varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  `latitude` varchar(100) NOT NULL,
  `longitude` varchar(100) NOT NULL,
  `storage` varchar(100) NOT NULL,
  `uniqueid` varchar(100) NOT NULL,
  `active` varchar(10) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `warehouse_JVYiA1bt7f8Jzh`
--

INSERT INTO `warehouse_JVYiA1bt7f8Jzh` VALUES ('Ajmer','Fsd Ajmer','NG19001','swc','motorable','26.4016016','74.6224747','202','WH_68146faaa819','1'),('Ajmer','Fsd Kishangarh','NG19002A','swc','motorable','26.5889508','74.8720944','200','WH_68146faaa905','1'),('Ajmer','RSWC Ajmer      ','NG19014','FCI','Motorable','26.3926525','74.6149721','200','WH_68146faaa9fe','1'),('Alwar','FSD Alwar      ','NG12001','FCI','Motorable','27.5391222','76.6188664','200','WH_68146faaaacf','1');

--
-- Table structure for table `warehouse_qsooxvdolengmh`
--

CREATE TABLE `warehouse_qsooxvdolengmh` (
  `district` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `id` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `warehousetype` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `type` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `latitude` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `longitude` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `storage` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `uniqueid` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `active` varchar(10) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `warehouse_qsooxvdolengmh`
--

INSERT INTO `warehouse_qsooxvdolengmh` VALUES ('Jhalawar','PWS Ramnath Devlal Goyal Aklera Jhalawar  ','NG16048','FCI','Motorable','24.41958','76.51253333','200','WH_672628171ae2','1'),('Pali','RSWC Pali      ','NG19022','FCI','Motorable','25.76781','73.32168667','200','WH_67262817b6e6','1'),('Udaipur','RSWC Udaipur      ','NG18016','FCI','Motorable','24.5747335','73.7376757','200','WH_672628199e76','1'),('Ajmer','FSD Ajmer      ','NG19001','FCI','Motorable','26.4016016','74.6224747','200','WH_6726281e7cb4','1'),('Ajmer','FSD Kishangarh      ','NG19002A','FCI','Motorable','26.5889508','74.8720944','200','WH_6726281f0d92','1'),('Ajmer','RSWC Ajmer      ','NG19014','FCI','Motorable','26.3926525','74.6149721','200','WH_6726281f80d0','1'),('Alwar','FSD Alwar      ','NG12001','FCI','Motorable','27.5391222','76.6188664','200','WH_6726281fa3c6','1');


