DROP TABLE IF EXISTS `regions`;
            CREATE TABLE `regions` (
              `regionid` varchar(250) NOT NULL,
              `regionname` varchar(250) DEFAULT NULL,
              `area` varchar(250) DEFAULT NULL,
              `SeqId` varchar(250) DEFAULT NULL,
              PRIMARY KEY (`regionid`)
            );insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1','LARKANA CITY','Local','1');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('101','LARKANA DIST','Local','2');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('10101','SIDE 1','Local','3');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010101','BAKRANI ROAD','Local','4');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010102','ALLAHABAD','Local','5');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010103','DARI MUHALLA','Local','6');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010104','CATTLE COLONY','Local','7');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010105','NAZAR MUHAALA','Local','8');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010106','STATION ROAD','Local','33');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010107','REHMAT PUR','Local','63');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010108','TANK CHOWK','Local','62');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010109','CMC','Local','64');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010110','LARKANA DOCTORS','Local','116');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('10102','SIDE 2','Local','65');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010201','CIVIL HOSPITAL','Local','66');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010202','S.ZED ROAD','Local','67');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010203','LAHORI MUHAALA','Local','68');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010204','MIROKHAN CHOWK','Local','69');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010205','LADIES JAIL ROAD','Local','70');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010206','GHINTI PHATAK','Local','71');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('10103','SIDE 3','Local','72');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010301','BUNDER ROAD','Local','73');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010302','GAJAN PUR','Local','74');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010303','EMPIRE ROAD','Local','75');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010304','MURAD WAHAN','Local','76');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010305','NEIDERO CHWOK','Local','77');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010306','PAKISTANI CHOWK','Local','78');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010307','OLD BUS STAND','Local','79');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010308','KAUSER MILL','Local','80');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('10104','WHOLE SALE REGION','Local','81');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('1010401','WHOLE SALE MARKET','Local','82');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2','OUTSTATIONS','UpCountry','9');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('201','SDKT ROUTE','UpCountry','10');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('20101','SDKT ROUTE','UpCountry','11');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2010101','SHAHDADKOT','UpCountry','12');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2010102','QAMBER','UpCountry','13');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2010103','MIROKHAN','UpCountry','14');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('202','NSB ROUTE','UpCountry','15');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('20201','NSB ROUTE','UpCountry','16');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2020101','NASIRABAD','UpCountry','17');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2020102','BADAH','UpCountry','18');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2020103','DOKRI','UpCountry','19');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2020104','WARAH','UpCountry','20');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2020105','WAGAN','UpCountry','21');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2020106','ARIJA','UpCountry','32');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('203','R.DERO ROUTE','UpCountry','22');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('20301','R.DERO ROUTE','UpCountry','23');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2030101','RATO DERO','UpCountry','24');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2030102','NEO-DERO','UpCountry','25');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2030103','MADEJI','UpCountry','26');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2030104','DAKHAN','UpCountry','27');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('204','AG-G.KERO ROUTE','UpCountry','120');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('20401','AG-G.KHERO ROUTE','UpCountry','121');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2040101','AG-G.KHERO','UpCountry','122');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2040102','AG-BANGULDERO','UpCountry','123');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2040103','AG-LASHARI','UpCountry','124');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2040104','AG-DHAMRAH','UpCountry','125');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('2040105','AG-SAJAWAL-ARZIBHUTT','UpCountry','126');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3','LARANA GEN','Local','34');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('301','LARKANA GEN','Local','35');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('30101','SIDE 1','Local','36');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010101','BAKRANI ROAD','Local','37');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010102','ALLAHABAD','Local','38');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010103','DARI MUHALLA','Local','39');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010104','CATTLE COLONY','Local','40');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010105','NAZAR MUHALA','Local','41');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010106','STATION ROAD','Local','42');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010107','TANK CHOWK','Local','43');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010108','REHMAT PUR','Local','44');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010109','CMC','Local','45');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('30102','SIDE 2','Local','46');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010201','CIVIL HOSPITAL','Local','47');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010202','S.ZED','Local','48');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010203','LAHORI MUHALLA','Local','49');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010204','LADIES JAIL ROAD','Local','50');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010205','MIROKHAN CHOWK','Local','51');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010206','GHINTI PHATAK','Local','52');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('30103','SIDE 3','Local','53');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010301','BUNDER ROAD','Local','54');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010302','GAJAN PUR','Local','55');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010303','EMPIRE ROAD','Local','56');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010304','MURAD WAHA','Local','57');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010305','NEODERO CHOWK','Local','58');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010306','PAKISTANI CHOWK','Local','59');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010307','OLD BUS TAND','Local','60');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010308','KAUSER MILL','Local','61');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('30104','WHOLE SALE REGION','Local','83');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('3010401','WHOLE SALE MARKET','Local','84');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4','GENERAL OUTSTATION','UpCountry','85');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('401','SDKT ROUTE','UpCountry','86');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('40101','SDKT ROUTE','UpCountry','87');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4010101','SHAHDADKOT CITY','UpCountry','88');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4010102','QAMBER','UpCountry','89');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4010103','MIROKHAN','UpCountry','90');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('402','NSB ROUTE','UpCountry','91');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('40201','NSB ROUTE','UpCountry','92');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4020101','NASEERABAD CITY','UpCountry','93');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4020102','BADAH','UpCountry','94');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4020103','DOKRI','UpCountry','95');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4020104','WARAH','UpCountry','96');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4020105','WAGAN','UpCountry','97');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4020106','ARIJA','UpCountry','98');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('403','R.DERO ROUTE','UpCountry','99');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('40301','R.DERO ROUTE','UpCountry','100');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4030101','RATODERO CITY','UpCountry','101');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4030102','NEODEROCITY','UpCountry','102');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4030103','MADEJI','UpCountry','103');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4030104','DAKHAN','UpCountry','104');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('404','DADU ROUTE','UpCountry','105');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('40401','DADU  ROUTE','UpCountry','106');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4040101','DADU CITY','Local','107');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4040102','MEHAR','UpCountry','108');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4040103','K.N.SHAH','UpCountry','109');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4040104','BHAN','UpCountry','110');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('4040105','SEHWAN','UpCountry','111');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('5','COUNTER SALES ABBOTT','Local','28');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('501','COUNTER SALES ABBOTT','Local','29');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('50101','COUNTER SALES ABBOTT','Local','30');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('5010101','COUNTER SALES ABBOTT','Local','31');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('6','COUNTER SALES GEN','Local','112');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('601','COUNTER SALES GEN','Local','113');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('60101','COUNTER SALES GEN','Local','114');insert  into `regions`(`regionid`,`regionname`,`area`,`SeqId`) values ('6010101','COUNTER GENERAL','Local','115');