INSERT INTO `customer_infos` (`id`, `sl_no`, `customer_code`, `customer_name`, `address`, `hourly_load`, `monthly_load`, `min_load`, `pf`, `df`, `daily_run`, `hourly_run`, `sec_dep_cash`, `sec_dep_bank`, `created_at`, `updated_at`) VALUES
(13094, '13094', '8-38-000619-00-07-0', 'OVI FILLING STAITON', 'AMIN BAZAR,SAVAR,.', 129.12, 74376.00, 44626.00, 2.0183, 0.80, 30, 24, 277450.00, 554900.00, NULL, NULL),
(13095, '13095', '8-38-000620-00-07-3', 'KIMBARLI  FASHIONS  LTD', 'S. PANISHAIL, ASHULIA,SAVAR,DHAKA..', 169.90, 56544.00, 33927.00, 1.0000, 0.80, 26, 16, 1566300.00, 4774700.00, NULL, NULL),
(13096, '13096', '8-38-000622-00-07-7', 'AMAN SPINNING MILLS LTD.', '742, ZIRABO,ASHULIA,SAVAR.', 917.46, 458000.00, 274800.01, 2.0183, 0.80, 26, 24, 12215900.00, 16032000.00, NULL, NULL),
(13097, '13097', '8-38-000624-00-07-1', 'SHAYA APPARELS LTD.', 'HATEM ALI COMPLEX,HEMAYETPUR,SAVAR.', 33.98, 11310.00, 6786.00, 1.6789, 0.80, 26, 16, 115000.00, 1897300.00, NULL, NULL),
(13098, '13098', '8-38-000625-00-07-3', 'ANUSHA CNG REF. STATION', 'HEMAYETPUR,SAVAR,.', 103.30, 39668.00, 23801.00, 2.0183, 0.80, 30, 16, 295950.00, 10849600.00, NULL, NULL),
(13099, '13099', '8-38-000626-00-07-5', 'M/S ALLIANCE KNIT COMPOSITE LT', 'ZIRABO, ASHULIA,SAVAR, DHAKA.,.', 350.00, 174720.00, 104832.00, 2.0183, 0.80, 26, 24, 3017750.00, 0.00, NULL, NULL),
(13100, '13100', '8-38-000632-00-07-8', 'TANZILA TEXTILE LTD.', 'BAROIPARA, SAVAR,DHAKA.,.', 350.00, 116479.00, 69888.01, 1.0000, 0.80, 26, 16, 1120550.00, 399150.00, NULL, NULL),
(13101, '13101', '8-38-000638-00-07-0', 'ALIF AMBERIDARY VILLAGE LTD.', 'TONGABARI,ASHULIA,SAVAR.', 206.60, 68757.00, 41254.00, 2.0183, 0.80, 26, 16, 1322900.00, 1893850.00, NULL, NULL),
(13102, '13102', '8-38-000642-00-07-9', 'M/S SN CORPORATION CNG FILLING', 'BOLIARPUR, SAVAR,DHAKA,.', 67.96, 26096.64, 15657.98, 2.0183, 0.80, 30, 16, 436450.00, 377100.00, NULL, NULL),
(13103, '13103', '8-38-000643-00-07-1', 'NOVO HEALTH CARE & PHARM.LTD.', 'NORSINGHAPUR,ASHULIA,SAVAR.', 122.33, 30534.00, 15267.01, 1.6789, 0.80, 26, 12, 851300.00, 774900.00, NULL, NULL),
(13104, '13104', '8-38-000644-00-07-3', 'AZAD CNG PETRO & CHEMICALS CO.', 'ZIRABO,ASHULIA,SAVAR,.', 95.14, 36536.00, 21922.00, 1.6789, 0.80, 30, 16, 272600.00, 0.00, NULL, NULL),
(13105, '13105', '8-38-000650-00-07-6', 'YOUNGONE HITECH SPORTSWARE IND', 'PLOT NO. # 1-4, 9-12, DEPZ,SAVAR, DHAKA.,.', 699.99, 232958.00, 139775.00, 2.0183, 0.80, 26, 16, 2921300.00, 0.00, NULL, NULL),
(13106, '13106', '8-38-000656-00-07-8', 'ANOWER CNG FILL.& SERVICE CNTR', 'ZAMGORA,ASHULIA,SAVAR.', 122.33, 35231.00, 17616.00, 1.6789, 0.80, 30, 12, 175250.00, 6093400.00, NULL, NULL),
(13107, '13107', '8-38-000656-00-07-8', 'ANOWER CNG FILL.& SERVICE CNTR', 'ZAMGORA,ASHULIA,SAVAR.', 122.33, 35231.00, 17616.00, 1.6789, 0.80, 30, 12, 175250.00, 6093400.00, NULL, NULL),
(13108, '13108', '8-38-000659-00-07-4', 'M/S. SIMTEX INDUSTRIES LTD.', 'KHAKGAN, BIRULIA,SAVAR, DHAKA.,.', 543.68, 180939.00, 108564.00, 2.0183, 0.80, 26, 16, 1739650.00, 455800.00, NULL, NULL),
(13109, '13109', '8-38-000660-00-07-7', 'M/S OTOBI LTD.', 'AKRAIN, BIRULIA, SAVAR,DHAKA,.', 361.55, 120324.00, 72195.00, 2.0183, 0.80, 26, 16, 897650.00, 0.00, NULL, NULL),
(13110, '13110', '8-38-000664-00-07-5', 'M/S MALIHA CNG FILLING STATION', 'ZAMGORA, ASHULIA,SAVAR, DHAKA.,.', 95.14, 36533.76, 21920.26, 1.6789, 0.80, 30, 16, 272600.00, 7322100.00, NULL, NULL),
(13111, '13111', '8-38-000665-00-07-7', 'HOUSE OF HALL ACCESSORIES LTD.', 'EAST NORSHINGAPUR,ASHULIA, SAVAR,DHAKA..', 81.55, 27141.00, 16285.00, 1.6789, 0.80, 26, 16, 325000.00, 44400.00, NULL, NULL),
(13112, '13112', '8-38-000671-00-07-0', 'M/S BNS FILLING STATION LTD.', 'ZIRABO, ASHULIA,SAVAR, DHAKA.,.', 26.39, 10136.00, 6082.01, 1.3394, 0.80, 30, 16, 400250.00, 390200.00, NULL, NULL),
(13113, '13113', '8-38-000677-00-07-2', 'M/S. BABYLON TRIMS LTD.', 'HARINDHARA, SAVAR,DHAKA.,.', 169.90, 56544.00, 33927.01, 1.0000, 0.80, 26, 16, 783150.00, 2580900.00, NULL, NULL),
(13114, '13114', '8-38-000679-00-07-6', 'M/S. SHARA FILLING STATION', '110, NOYABARI,SAVAR, DHAKA.,.', 129.12, 49584.00, 29751.00, 1.6789, 0.80, 30, 16, 184950.00, 4462200.00, NULL, NULL),
(13115, '13115', '8-38-000680-00-07-9', 'RAHIM AFROOZ ACCUMULATOR LTD.', 'W.PANISHAIL,ZIRANI BAZAR,SAVAR.', 350.00, 116478.00, 69888.00, 1.0000, 0.80, 26, 16, 2241050.00, 688950.00, NULL, NULL),
(13116, '13116', '8-38-000681-00-07-1', 'M/S. SOUTH BENGAL FILLING STA.', 'ZAMGORA, ASHULIA,SAVAR, DHAKA.,.', 107.04, 41104.00, 24662.00, 1.6789, 0.80, 30, 16, 171850.00, 1588150.00, NULL, NULL),
(13117, '13117', '8-38-000684-00-07-7', 'KNIT PLUS  LTD.', 'BELMA, ASHULIA,SAVAR, DHAKA.,.', 680.96, 226625.00, 135975.00, 1.0000, 0.80, 26, 16, 13585950.00, 20121300.00, NULL, NULL),
(13118, '13118', '8-38-000685-00-07-9', 'M/S. YASIN KNITEX IND LTD.', 'SOUTH PANISHAIL, SAVAR,DHAKA.,.', 815.52, 271405.06, 162843.04, 1.0000, 0.80, 26, 16, 4822400.00, 7212200.00, NULL, NULL),
(13119, '13119', '8-38-000690-00-07-0', 'TANIMA KNIT COMPOSITE LTD.', 'SOUTH DARIARPUR,,SAVAR, DHAKA.,.', 250.43, 125017.00, 75011.00, 1.0000, 0.80, 26, 24, 1477700.00, 1.00, NULL, NULL),
(13120, '13120', '8-38-000691-00-07-2', 'SIGMA FASHION\'S LTD.', 'TAJPUR ROAD, YOUSUF MARKET,ASHULIA, DHAKA.,.', 463.49, 154250.00, 92550.00, 2.0183, 0.80, 26, 16, 4272750.00, 6244001.00, NULL, NULL),
(13121, '13121', '8-38-000693-00-07-6', 'M/S THAT\'S IT PACKAGING LTD.', 'EAST NORSINGHAPUR, ASHULIA,SAVAR, DHAKA.,.', 350.00, 116479.00, 69888.01, 2.0183, 0.80, 26, 16, 3727350.00, 5365325.00, NULL, NULL),
(13122, '13122', '8-38-000697-00-07-4', 'SUPREME STITCH LIMITED.', 'KASHIMPUR,SAVAR,DHAKA.', 78.24, 26040.00, 15625.00, 2.0183, 0.80, 26, 16, 467700.00, 1301558.00, NULL, NULL),
(13123, '13123', '8-38-000705-00-07-3', 'M/S. HABIB CNG FILLING STATION', 'POLASHBARI, ASHULIA,SAVAR,DHAKA.', 87.33, 25151.00, 12576.00, 2.0183, 0.80, 30, 12, 420550.00, 0.00, NULL, NULL),
(13124, '13124', '8-38-000710-00-07-4', 'M/S. UNIFILL COMPOSITE DYEING', 'BHABANIPUR, KASHIMPUR,SAVAR, DHAKA.,.', 361.55, 120324.00, 72195.00, 1.8146, 0.80, 26, 16, 7590050.00, 11976200.00, NULL, NULL),
(13125, '13125', '8-38-000711-00-07-6', 'THE ACME LABORATORIES LIMITED', 'DHULIVITA, DHAMRAI,,DHAKA.,VAT REG NO # 17181000089.', 1981.04, 988938.00, 593363.01, 1.0000, 0.80, 26, 24, 15823050.00, 9721500.00, NULL, NULL),
(13126, '13126', '8-38-000713-00-07-0', 'GREENLIFE KNIT COMPOSITE LTD.', 'TONGABARI, ASHULIA, SAVAR,DHAKA,.', 361.21, 127724.00, 76634.01, 1.0000, 0.85, 26, 16, 1769000.00, 4157600.00, NULL, NULL),
(13127, '13127', '8-38-000714-00-07-2', 'INCEPTA VACCINE LTD.', 'BORO RANGAMATIA,DEWAN IDRIS ROAD, ASHULIA,SAVAR, DHAKA..', 530.62, 264890.00, 158934.01, 1.0000, 0.80, 26, 24, 7337500.00, 6823100.00, NULL, NULL),
(13128, '13128', '8-38-000716-00-07-6', 'SHINEST BUTTON', '477, NORTH GAZIRCHAT, ASHULIA,SAVAR, DHAKA.,.', 135.92, 45235.00, 27142.00, 2.0183, 0.80, 26, 16, 229800.00, 0.00, NULL, NULL),
(13129, '13129', '8-38-000727-00-07-9', 'M/S. SAYBOLT TEX LIMITED.', 'BAIPAIL, ASHULIA, SAVAR,DHAKA.,.', 142.72, 47497.00, 28498.01, 1.6789, 0.80, 26, 16, 657850.00, 918600.00, NULL, NULL),
(13130, '13130', '8-38-000728-00-07-1', 'M/S. F.F. ENTERPRISE', 'TATUIBARI, SAVAR,DHAKA.,.', 1.00, 21889.00, 13133.00, 1.6789, 0.80, 30, 16, 549400.00, 0.00, NULL, NULL),
(13131, '13131', '8-38-000730-00-07-6', 'NORBAN COMTEX LTD.', 'SARABO, KASHIMPUR,SAVAR, DHAKA.,.', 361.21, 120212.00, 72127.01, 1.0000, 0.80, 26, 16, 1664950.00, 2175800.00, NULL, NULL),
(13132, '13132', '8-38-000739-00-07-4', 'MAHMUD FASHION LTD', 'BOROIPARA, SAVAR,DHAKA.,.', 611.64, 152667.00, 76333.50, 1.0000, 0.80, 26, 12, 2460250.00, 1676150.00, NULL, NULL),
(13133, '13133', '8-38-000740-00-07-7', 'THE CIVIL ENGINEERS LTD.UNIT-2', 'BAGBARI, HEMAYETPUR, SAVAR,DHAKA,.', 122.33, 72518.00, 43512.01, 1.6789, 0.95, 26, 24, 7710980.00, 14329100.00, NULL, NULL),
(13134, '13134', '8-38-000741-00-07-9', 'DANA BOTTOMS LTD.', '77/20, DOGOR MORA, SAVAR,DHAKA,.', 212.38, 70679.00, 42408.00, 1.6789, 0.80, 26, 16, 679950.00, 0.00, NULL, NULL),
(13135, '13135', '8-38-000750-00-07-8', 'WINTER DRESS LTD.', 'KALMA,DAIRY FIRM, SAVAR,DHAKA.,.', 305.82, 101778.00, 61067.01, 1.6789, 0.80, 26, 16, 4248250.00, 1393900.00, NULL, NULL),
(13136, '13136', '8-38-000751-00-07-0', 'LABAID PHARMACEUTICALS LTD.', '15, GENDA, SAVAR,DHAKA.,.', 611.64, 152670.00, 76335.00, 1.6789, 0.80, 26, 12, 2114500.00, 2165000.00, NULL, NULL),
(13137, '13137', '8-38-000756-00-07-0', 'AMTRANET LIMITED', 'KASBA TOWER, RAJASON, SAVAR,DHAKA,.', 424.75, 106019.00, 53010.01, 1.0000, 0.80, 26, 12, 11061850.00, 20503800.00, NULL, NULL),
(13138, '13138', '8-38-000763-01-07-7', 'SHANTEX (PVT) LTD.', 'Plot no. 566, 567; Gouripur,,Ashulia, Dhaka.,.', 1060.15, 441024.00, 264614.40, 1.0000, 0.80, 26, 20, 12216400.00, 24432800.00, NULL, NULL),
(13139, '13139', '8-38-000806-00-07-7', 'DESIGNER WASHING & DYEING LTD.', 'GOHAILBARI, SHIMULIA, SAVAR, DHAKA,,.', 764.55, 254445.00, 152667.00, 1.0000, 0.80, 26, 16, 3524100.00, 0.00, NULL, NULL),
(13140, '13140', '8-38-000893-00-07-0', 'GRAMEEN FABRICS LTD.', 'SARABO, KASHIMPUR, GAZIPUR.,,.', 305.82, 108139.00, 64884.00, 1.0000, 0.85, 26, 16, NULL, 0.00, NULL, NULL),
(13141, '13141', '8-38-000896-00-07-6', 'THANBEE PRINT WORLD LTD.', 'SARDAGONJ, KASHIMPUR,,GAZIPUR.,.', 1049.99, 262077.00, 131038.50, 1.0000, 0.80, 26, 12, NULL, 0.00, NULL, NULL),
(13142, '13142', '8-38-000897-00-07-8', 'DAN FOODS LTD.', 'KHAGON, BIRULIA,,SAVAR, DHAKA.,.', 177.72, 102365.00, 61419.00, 1.0000, 0.80, 30, 24, 225200.00, 0.00, NULL, NULL),
(13143, '13143', '8-38-000904-00-07-5', 'DBL PHARMACEUTICALS LTD.', 'SURABARI, KASHIMPUR,,GAZIPUR.,.', 2022.19, 1164787.00, 698873.00, 1.0000, 0.80, 30, 24, NULL, 0.00, NULL, NULL),
(13144, '13144', '8-38-000927-00-07-3', 'LOTUS ENGINEERING IND. LTD.', 'GANAKBARI, ASHULIA, SAVAR, DHAKA,,.', 350.00, 174718.00, 104830.80, 1.0000, 0.80, 26, 24, 576600.00, 0.00, NULL, NULL),
(13145, '13145', '8-38-000929-00-07-7', 'MARK SWEATER LTD.', 'SURABARI, KASHIMPUR, GAZIPUR SADAR,,GAZIPUR.,.', 917.46, 152667.00, 76333.50, 1.0000, 0.80, 26, 8, NULL, 0.00, NULL, NULL),
(13146, '13146', '8-38-000932-00-07-4', 'M/S BIG BOSS CORPORATION LTD', '30, SARABO, KASHIMPUR, GAZIPUR,,.', 764.55, 202760.00, 101380.00, 1.0000, 0.85, 26, 12, 4913550.00, 3511201.00, NULL, NULL),
(13147, '13147', '8-38-000935-00-07-0', 'A R WET PROCESSING LTD.', 'AMTALA, KATGORA, ASHULIA,,SAVAR, DHAKA.,.', 122.33, 70462.00, 42278.00, 1.6789, 0.80, 30, 24, 4860300.00, 0.00, NULL, NULL),
(13148, '13148', '8-38-000947-00-07-5', 'BALY INTEGRATED SOLUTIONS LTD.', 'RAJFULBARIA,,SAVAR, DHAKA.,.', 375.20, 199005.00, 119403.00, 1.0000, 0.85, 26, 24, NULL, 0.00, NULL, NULL),
(13149, '13149', '8-39-000020-00-84-5', 'NUHA ENERGY & RESOURCE LTD.', 'KAMALPUR (DHAKA SHYLET ROAD),BHAIRAB,.', 84.95, 24465.73, 12232.87, 1.6780, 0.80, 30, 12, 368850.00, 0.00, NULL, NULL),
(13150, '13150', '8-39-000024-00-84-3', 'BELABO FILLING STATION', 'LAUHIPUR,BHAIRAB,KISHORGONJ.', 63.20, 30338.00, 18203.00, 1.3394, 0.80, 30, 20, 1.00, 0.00, NULL, NULL),
(13151, '13151', '8-39-000030-00-84-6', 'MEGHNA CNG FILLING', '470 BHAIRABPUR,BHAIRAB,.', 67.96, 26097.00, 15658.20, 2.0183, 0.80, 30, 16, 132570.00, 0.00, NULL, NULL),
(13152, '13152', '8-39-000034-00-84-4', 'ALIN FOOD PRODUCTS LTD.', '124/1, Laxmipur,Bhairab,Kishoregonj.', 509.70, 254443.74, 152666.24, 2.0183, 0.80, 26, 24, 3524100.00, 7048200.00, NULL, NULL),
(13153, '13153', '8-51-000001-00-72-6', 'THERMAX TEXTILE MILLS LTD.', '(SPINNING INIT) PROTAB MAHAL,GOTASHIA, MONOHARDI,NARSHINGDI.', 3757.30, 2569993.20, 1541995.92, 2.0183, 0.95, 30, 24, 24149800.00, 29698900.00, NULL, NULL),
(13154, '13154', '8-51-000003-00-72-0', 'ANOWER&BROTHERS CNG FIL.&CONV.', 'BUS STAND,MONOHORDI,NARSINGDI,.', 63.28, 24325.00, 14595.00, 2.0183, 0.80, 30, 16, 90750.00, 0.00, NULL, NULL),
(13155, '13155', '8-51-000004-00-72-2', 'M/S STAR FEEDS LTD.', 'DASDONA, MONOHORDI,,NARSINGDI,.', 203.88, 132115.00, 79269.00, 1.6789, 0.90, 30, 24, 552250.00, 985600.00, NULL, NULL),
(13156, '13156', '8-55-000059-00-60-0', 'TARASIMA APPARELS LTD.', 'GOLORA, SATURIA,MANIKGONJ.,.', 271.84, 96124.00, 57675.00, 2.0183, 0.85, 26, 16, 1994400.00, 0.00, NULL, NULL),
(13157, '13157', '8-55-000061-00-60-5', 'GOOD LUCK CNG CORPORATION', 'WEST SEOUTA TATI KALIANI,MANIKGONJ,.', 104.73, 34379.00, 20627.40, 2.0183, 0.80, 26, 16, 330726.00, 0.00, NULL, NULL),
(13158, '13158', '8-55-000069-00-60-1', 'GRAPHIPS TEXTILES', 'SREERAMPUR,SUTIPARA,DHAMRAI.', 713.58, 356221.03, 213732.62, 1.0000, 0.80, 26, 24, 5699550.00, 13288700.00, NULL, NULL),
(13159, '13159', '8-55-000076-00-60-6', 'NAFA APPAREL LIMITED', 'JOYPURA,DHAMRAI,MANIKGONJ.', 361.60, 95896.32, 47948.16, 1.0000, 0.85, 26, 12, 2346500.00, 4807300.00, NULL, NULL),
(13160, '13160', '8-55-000079-00-60-2', 'PAUL CNG LTD.', 'JOYPURA, PLOT-900,DHAMRAI,DHAKA.', 103.31, 59500.80, 35700.48, 2.0183, 0.80, 26, 24, 223968.00, 443876.00, NULL, NULL),
(13161, '13161', '8-55-000080-00-60-5', 'GLORIOUS GAS STATION(CNG&FUEL)', 'BATHULI,BELISHWAR,DHAMRAI.', 122.34, 70480.56, 42276.79, 1.6789, 0.80, 30, 24, 358300.00, 0.00, NULL, NULL),
(13162, '13162', '8-55-000082-00-60-9', 'AKASH CNG FILLING LTD.', 'SUTIPARA,DHAMRAI,DHAKA.', 103.29, 39663.36, 23798.02, 1.6789, 0.80, 30, 16, 549350.00, 0.00, NULL, NULL),
(13163, '13163', '8-55-000085-00-60-5', 'SOUTHERN AUTOBILES LTD.', 'KAMTA,SATURIA,MANIKGONJ.', 169.92, 42407.27, 21203.63, 2.0183, 0.80, 26, 12, 338000.00, 3445875.00, NULL, NULL),
(13164, '13164', '8-55-000087-00-60-9', 'M/S. DHAMRAI CNG & FILLING ST.', 'PLOT-281, DHULIVITA,DHAMRAI, DHAKA.,.', 63.20, 24270.00, 14562.00, 2.0183, 0.80, 30, 16, 672300.00, 5750000.00, NULL, NULL),
(13165, '13165', '8-55-000088-00-60-1', 'KAY & QUE(BD) LTD. CNG FILLING', '38, DAKSHIN PARA, DHAMRAI,DHAKA.,.', 122.32, 46975.00, 28185.00, 2.0183, 0.80, 30, 16, 392800.00, 785600.00, NULL, NULL),
(13166, '13166', '8-55-000093-00-60-2', 'M/S. PROTIK CERAMICS LTD.', 'DAUTIA, KALAMPUR,DHAMRAI, DHAKA.,.', 350.00, 174718.00, 104830.80, 1.0000, 0.80, 26, 24, 2419850.00, 2029100.00, NULL, NULL),
(13167, '13167', '8-55-000094-00-60-4', 'M/S.  AKIJ CNG STATION LTD', 'Uthuli,Shibaloy,Manikgonj,,.', 65.02, 24967.68, 14980.61, 2.0183, 0.80, 30, 16, 199030.00, 691600.00, NULL, NULL),
(13168, '13168', '8-55-000099-00-60-4', 'SARMANO ENERGY LTD.', 'PATURIA, UTHOLI, SHIBALYA,MANIKGONJ,.', 71.36, 27402.24, 16441.34, 1.6789, 0.80, 30, 16, 586395.25, 6693000.00, NULL, NULL),
(13169, '13169', '8-55-000099-00-60-4', 'SARMANO ENERGY LTD.', 'PATURIA, UTHOLI, SHIBALYA,MANIKGONJ,.', 71.36, 27402.24, 16441.34, 1.6789, 0.80, 30, 16, 586395.25, 6693000.00, NULL, NULL),
(13170, '13170', '8-55-000100-00-60-9', 'F 2 F CNG FILLING STATION', 'DOKHIN PARA, DHAMRAI,DHAKA,.', 103.30, 39667.08, 23800.25, 1.6789, 0.80, 30, 16, 549450.00, 434900.00, NULL, NULL),
(13171, '13171', '8-55-000102-00-60-3', 'BASE PAPERS LTD.', 'SRIRAMPUR, SHUAPUR ROAD,DHAMRAI,DHAKA,.', 1048.63, 348984.06, 209390.44, 1.0000, 0.80, 26, 16, 4833450.00, 7820534.00, NULL, NULL),
(13172, '13172', '8-55-000111-00-60-2', 'M/S. PROTIK BONE CHINA LTD.', 'DAUTIA, KALAMPUR, DHAMRAI, DHAKA.,,.', 12360.00, 174717.95, 104830.77, 1.0000, 0.80, 26, 24, 2795500.00, 5591000.00, NULL, NULL),
(13173, '13173', '8-55-005001-00-60-4', 'INCEPTA PHARMACEUTICALS LTD.', 'KRISHNOPURA, SAHABELISHOR,DHAMRAI, DHAKA,.', 194.70, 48597.12, 24298.56, 2.0183, 0.80, 26, 12, 673100.00, 2158800.00, NULL, NULL),
(13174, '13174', '8-55-005011-01-60-7', 'DEEP TEXTILE MILLS LTD. (GEN)', 'DAUTIA,KALAMPUR,DHAMRAI.', 521.59, 138327.21, 69163.61, 1.0000, 0.85, 26, 12, 1915850.01, 1170297.00, NULL, NULL),
(13175, '13175', '8-55-005022-01-60-0', 'MONNO FABRICS LIMITED(GEN)', 'GILAND,MANIKGONJ,.', 2099.97, 524154.00, 262077.00, 2.0183, 0.80, 26, 12, 8013300.00, 0.00, NULL, NULL),
(13176, '13176', '8-55-005025-01-60-6', 'AKIJ TEXTILE MILLS LTD. (GEN)', 'GOLRA, ZAGIR,MANIKGONJ,.', 2273.27, 1134818.53, 680891.12, 1.0000, 0.80, 26, 24, 25317840.00, 11189800.00, NULL, NULL),
(13177, '13177', '8-55-005026-01-60-8', 'AKIJ PART. & HARD BOARD MIL(G)', 'TARAGHAT,MANIKGONJ,.', 989.89, 329435.50, 190302.00, 2.0183, 0.80, 26, 16, 1519079.00, 554166.00, NULL, NULL),
(13178, '13178', '8-55-005033-00-60-1', 'AKIJ FOOD & BEVERAGE', 'KRISNA PURA, DHAMRI,MANIKGANJ.,.', 2169.30, 1082914.56, 649748.74, 1.0000, 0.80, 26, 24, 14998400.00, 17889700.00, NULL, NULL),
(13179, '13179', '8-55-005040-00-60-6', 'RISING SPINNING MILLS LTD.', 'NAYA DINGI BUS STATION,SATURIA,MANIKGONJ.', 3232.36, 1613597.00, 968158.20, 1.0000, 0.80, 26, 24, 22348350.00, 47556400.00, NULL, NULL),
(13180, '13180', '8-55-005040-01-60-8', 'Rising Spinning  Mills (By pas', 'Naya Dingi ,Bus Station,,.', 0.00, 0.00, 0.00, 1.0000, 0.00, 0, 0, NULL, 0.00, NULL, NULL),
(13181, '13181', '8-55-005045-00-60-6', 'THE IMMACULATE TEXTILE LTD.', 'PURBO PANCHAR,DHAMRAI,.', 523.36, 261261.31, 156756.79, 2.0183, 0.80, 26, 24, 7236050.00, 650200.00, NULL, NULL),
(13182, '13182', '8-55-005055-00-60-7', 'ALHAJ KARIM TEXTILES LTD.', 'KALAMPUR,DHAMRAI,.', 1750.21, 1048308.00, 628984.80, 1.0000, 0.80, 26, 24, 16775250.00, 12328100.00, NULL, NULL),
(13183, '13183', '8-55-005058-00-60-3', 'AZIZ POLYMAR IND.', 'CHARDAUTIA,KALAMPUR,DHAMRAI.', 36.99, 12307.53, 7384.52, 1.6789, 0.80, 26, 16, 327750.00, 0.00, NULL, NULL),
(13184, '13184', '8-55-005060-00-60-8', 'BUILD TRADE COLOR COAT LTD.', 'KALAMPUR,DHAMRAI,VAT REG. NO#17181006656.', 350.04, 92830.61, 46415.31, 2.0183, 0.85, 26, 12, 4452050.00, 0.00, NULL, NULL),
(13185, '13185', '8-55-005066-00-60-0', 'PEARL PAPER & BOARD MILLS LTD.', 'SRI RAM PUR,DHAMRAI.,.', 689.80, 344348.16, 206608.90, 1.0000, 0.80, 26, 24, 4769250.00, 4216662.00, NULL, NULL),
(13186, '13186', '8-55-005067-00-60-2', 'FUZI INK INDS.', 'CHUTU CHANDRAIL,DHAMRAI,MANIKGONJ.', 39.14, 19538.69, 11723.21, 2.0183, 0.80, 26, 24, 582200.00, 911300.00, NULL, NULL),
(13187, '13187', '8-55-005091-00-60-3', 'M/S SPECTRA OXYGEN LTD.', 'ISAIL, UTHULI,SIBALAYA, MANIKGONJ,.', 122.32, 40711.00, 24426.06, 1.6789, 0.80, 26, 16, 680700.00, 754400.00, NULL, NULL),
(13188, '13188', '8-55-005092-00-60-5', 'M/S M A H SPINNING MILLS  LTD.', 'Dautia, Kalampur, Dhamrai, Dhaka,,.', 1886.04, 941511.77, 564907.06, 1.0000, 0.80, 26, 24, 14028530.00, 0.00, NULL, NULL),
(13189, '13189', '8-60-000008-00-78-1', 'UTTARA SPINNING MILLS LTD.', 'GORAI,,MIRZAPUR,TANGAIL.', 937.85, 468176.25, 280905.75, 1.0000, 0.80, 26, 24, 6471936.00, 12629098.00, NULL, NULL),
(13190, '13190', '8-60-000013-01-78-4', 'A.G. TEXTILE MILLS LTD', 'GORAI,MIRZAPUR,TANGAIL.', 361.55, 214326.43, 150028.50, 2.0183, 0.95, 26, 24, 0.01, 0.00, NULL, NULL),
(13191, '13191', '8-60-000013-02-78-6', 'A.G. TEXTILE MILLS (STANDBY)', 'GORAI, MIRZAPUR,TANGAIL,.', 361.55, 71442.11, 0.01, 2.0183, 0.95, 26, 8, 0.01, 0.00, NULL, NULL),
(13192, '13192', '8-60-000015-00-78-6', 'ALAUDDIN TEXTILE MILLS LTD.', 'KHIDIRAMPUR,KOROTIA,TANGAIL.', 700.00, 349435.90, 209661.54, 1.0000, 0.80, 26, 24, 4839700.00, 8833700.00, NULL, NULL),
(13193, '13193', '8-60-000016-00-78-8', 'IMPRESS-NEWTEX COMP.TEX.LTD.', 'GORAI, MIRZAPUR, TANGAIL,,.', 1177.07, 697769.21, 418661.53, 1.0000, 0.95, 26, 24, 9126030.00, 16708450.00, NULL, NULL),
(13194, '13194', '8-60-000016-00-78-8', 'IMPRESS-NEWTEX COMP.TEX.LTD.', 'GORAI, MIRZAPUR, TANGAIL,,.', 1177.07, 697769.21, 418661.53, 1.0000, 0.95, 26, 24, 9126030.00, 16708450.00, NULL, NULL),
(13195, '13195', '8-60-000019-01-78-6', 'NAHEED COTTON MILLS LTD. (GEN)', 'GORAI,MIRZAPUR,TANGAIL.', 2543.39, 1133899.70, 680339.83, 1.0000, 0.80, 26, 24, 4796400.01, 28565362.00, NULL, NULL),
(13196, '13196', '8-60-000019-01-78-6', 'NAHEED COTTON MILLS LTD. (GEN)', 'GORAI,MIRZAPUR,TANGAIL.', 2543.39, 1133899.70, 680339.83, 1.0000, 0.80, 26, 24, 4796400.01, 28565362.00, NULL, NULL),
(13197, '13197', '8-60-000020-00-78-7', 'TECHNO TEXTILE MILLS LTD.', 'NORTH DARIAPUR,KALIAKAIR,GAZIPUR.', 22600.00, 379368.37, 227621.02, 1.0000, 0.95, 26, 24, 5254300.00, 10508600.00, NULL, NULL),
(13198, '13198', '8-60-000021-02-78-3', 'SQUARE PHARMACEUTICALS LTD', 'KALIAKAIR,GAZIPUR,VAT REG #000000151-0005.', 1355.80, 676820.02, 406092.01, 2.0183, 0.80, 26, 24, 9671690.00, 9972906.00, NULL, NULL),
(13199, '13199', '8-60-000021-03-78-5', 'SQUARE PHARMACUTICALS LTD.', 'KALIAKOIR,,GAZIPUR,VAT REG #000000151-0005.', 543.68, 90470.00, 1.00, 2.0183, 0.80, 26, 8, 955400.00, 2699000.00, NULL, NULL),
(13200, '13200', '8-60-000024-01-78-7', 'YOUTH SPINNING MILLS LTD.(GEN)', 'GORAI, MIRZAPUR,TANGAIL,.', 1327.44, 662655.99, 397593.59, 1.0000, 0.80, 26, 24, 24897150.00, 13417816.00, NULL, NULL),
(13201, '13201', '8-60-000025-00-78-7', 'DELSEY COTTON SPIN. MILLS', 'GORAI, MIRZAPUR,TANGAIL,.', 2468.66, 1232355.25, 739413.15, 2.0183, 0.80, 26, 24, 19717700.00, 32199343.00, NULL, NULL),
(13202, '13202', '8-60-000026-01-78-1', 'NEW AGE TEXTILES LTD. (GEN)', 'GORAI, MONI NAGAR,MIRZAPUR, TANGAIL,.', 835.14, 221482.00, 110740.62, 1.0000, 0.85, 26, 12, 3067550.00, 5381910.00, NULL, NULL),
(13203, '13203', '8-60-000027-00-78-1', 'MEGHNA INNOVA RUBBER CO. LTD.', 'GORAI, MOMIN NAGAR,MIRZAPUR,,TANGAIL.', 1276.97, 677307.69, 406384.61, 1.0000, 0.85, 26, 24, 9380750.00, 9704566.00, NULL, NULL),
(13204, '13204', '8-60-000030-00-78-8', 'UNIVERSAL YARN DYEING LTD.', '57-60, BSCIC,TANGAIL.,.', 226.99, 113312.22, 67987.33, 1.3394, 0.80, 26, 24, 2180150.00, 799986.00, NULL, NULL),
(13205, '13205', '8-60-000035-00-78-8', 'MASHAFI FLOWER MILLS LTD.', 'GORAI,MIRZAPUR,TANGAIL.', 107.04, 26716.58, 13358.29, 1.6789, 0.80, 26, 12, 99662.00, 247300.00, NULL, NULL),
(13206, '13206', '8-60-000037-00-78-2', 'UTTARA ROTORS YARN  MILLS', 'GORAI, MIRJAPUR,TANGAIL,.', 611.64, 305332.34, 183199.40, 1.6789, 0.80, 26, 24, 1139000.00, 2552600.00, NULL, NULL),
(13207, '13207', '8-60-000038-00-78-4', 'NAHEED COMPOSITE TEX.MILLS LTD', 'GORAI,MIRZAPUR,TANGAIL.', 3614.13, 1804175.00, 1082505.00, 1.0000, 0.80, 26, 24, 6729575.00, 21732450.00, NULL, NULL),
(13208, '13208', '8-60-000039-00-78-6', 'SOUTH EAST TEXTILE (PVT.) LTD.', 'GORNY, MIRZAPUR,TANGAIL,.', 479.12, 239177.00, 143506.20, 1.6789, 0.85, 26, 24, 253518.00, 2296280.00, NULL, NULL),
(13209, '13209', '8-60-000040-00-78-9', 'SQUARE PHARMACEUTICALS LTD.', 'SUTRAPUR, KALIAKOIR,,GAZIPUR.,VAT REG# 000000151-0005.', 3381.02, 1687809.40, 1012685.59, 1.6896, 0.80, 26, 24, 23376200.00, 46752400.00, NULL, NULL),
(13210, '13210', '8-60-000041-00-78-1', 'COMFIT COMPOSITE KNIT LTD', 'GORAI,MIRJAPUR,TANGAIL.', 2097.82, 1047233.38, 628340.03, 1.0000, 0.80, 26, 24, 14504183.00, 15599200.00, NULL, NULL),
(13211, '13211', '8-60-000042-00-78-3', 'TECHNO SPINNING MILLS LTD.', 'UTTAR DORIYAPUR,KALIAKOIR,GAZIPUR.', 1049.99, 524153.85, 314492.31, 1.0000, 0.80, 26, 24, 9588550.00, 19177100.00, NULL, NULL),
(13212, '13212', '8-60-000044-00-78-7', 'SCANDEX TEXTILE IND. LTD', 'NORTH GAJARIA,KALIAKOIR,GAZIPUR.', 1399.98, 371276.00, 185638.00, 2.0183, 0.85, 26, 12, 16110900.00, 16145000.00, NULL, NULL),
(13213, '13213', '8-60-000046-00-78-1', 'TANGAIL CNG REFUELLING', 'RABNA BY PASS,TANGAIL,.', 59.46, 19790.06, 11874.03, 1.6789, 0.80, 26, 16, 423566.00, 0.00, NULL, NULL),
(13214, '13214', '8-60-000047-00-78-3', 'SHIRIN SPINNING MILLS LTD.', 'GORAI,MIRZAPUR,TANGAIL.', 3149.96, 1572462.00, 943477.20, 2.0183, 0.80, 26, 24, 25159320.00, 41003114.00, NULL, NULL),
(13215, '13215', '8-60-000050-00-78-0', 'BENGAL NFK TEXTILE LTD.', 'BI-MILE, DEWHATA,MIRZAPUR,TANGAIL.', 1050.12, 524153.85, 314492.31, 2.0183, 0.80, 26, 24, 14913250.00, 25444500.00, NULL, NULL),
(13216, '13216', '8-60-000051-00-78-2', 'SHILA BRISTY CNG FELLING STAT.', 'SUTRAPUR,KALIAKOIR,GAZIPUR.', 55.76, 13909.58, 6954.79, 1.6789, 0.80, 26, 12, 143918.00, 239800.00, NULL, NULL),
(13217, '13217', '8-60-000052-00-78-4', 'HIGH WAY FILLING STATION', 'BOARD GHAR BAZAR,KALIAKOIR,GAZIPUR.', 108.75, 36187.53, 21712.52, 1.6789, 0.80, 26, 16, 134980.00, 269960.00, NULL, NULL),
(13218, '13218', '8-60-000055-00-78-0', 'IMPRESS-NEWTEX COMPOSITE TEX L', 'GORAI, MOMIN NAGAR,MIRZAPUR,TANGAIL.', 122.34, 30533.23, 15266.61, 1.6789, 0.80, 26, 12, 422900.00, 845800.00, NULL, NULL),
(13219, '13219', '8-60-000056-00-78-2', 'IMPRESS-NEWTEX COMPOSITE TEX L', 'GORAI, MOMIN NAGAR, MIRZAPUR, TANGAIL,,.', 95.15, 23748.07, 11874.03, 1.6789, 0.80, 26, 12, 174731.00, 657900.00, NULL, NULL),
(13220, '13220', '8-60-000057-00-78-4', 'NITOL GAS DISTRIBUTION CO.LTD', 'ELENGA FILLING STATION, ELENGA,RAZABARI, KALIHATI,TANGAIL.', 103.30, 34378.15, 20626.89, 2.0183, 0.80, 26, 16, 256461.00, 512922.00, NULL, NULL),
(13221, '13221', '8-60-000059-00-78-8', 'NITOL GAS DISTRIBUTION CO.LTD', 'HAMID FILLING STATION,PABNA BY PASS,,TANGAIL.', 103.29, 34378.15, 20626.89, 2.0183, 0.80, 26, 16, 256462.00, 512924.00, NULL, NULL),
(13222, '13222', '8-60-000061-00-78-3', 'MAA CNG FILLING STATION LTD', 'BAUAR KUMARJANI,MIRJAPUR,TANGAIL.', 101.27, 41314.47, 24788.68, 1.6789, 0.85, 30, 16, 154103.00, 486694.00, NULL, NULL),
(13223, '13223', '8-60-000062-00-78-5', 'NITOL GAS DIST. CO. LTD.', 'EXIST. ASHIAN HIGHWAY FIL.STN.,NAGAR JALFOL,ASHEKPUR,TANGAIL.', 48.94, 18789.68, 11273.80, 1.6789, 0.80, 30, 16, 361550.00, 723100.00, NULL, NULL),
(13224, '13224', '8-60-000067-00-78-5', 'NAVANA CNG LTD.', 'EXIST. JOGAJOG FILLING STATION,BUS TERMINAL,TANGAIL.', 103.29, 39667.11, 23800.27, 1.6789, 0.80, 30, 16, 295917.00, 591834.00, NULL, NULL),
(13225, '13225', '8-60-000068-00-78-7', 'HIGH PRESSURE CNG REFULL STATN', 'VATKURA,,TANGAIL,.', 2123.00, 50187.37, 30112.42, 1.6789, 0.85, 30, 16, 187200.00, 464800.00, NULL, NULL),
(13226, '13226', '8-60-000069-00-78-9', 'SABUR & CO. FILLING STATION', 'RASULPUR,RABNA,TANGAIL.', 95.16, 36535.49, 21921.29, 1.6789, 0.80, 30, 16, 102213.00, 0.00, NULL, NULL),
(13227, '13227', '8-60-000074-00-78-0', 'PERMESS SOUTH-EAST ASIA LTD.', 'GORAI, MIRZAPUR,,TANGAIL.,.', 95.14, 33668.70, 20201.22, 2.0183, 0.85, 26, 16, 125600.00, 292900.00, NULL, NULL),
(13228, '13228', '8-60-000075-00-78-2', 'BHUMI CNG AND FILLING STATION', 'NORTH DARIAPUR,KALIAKOIR,GAZIPUR.', 2400.00, 27727.83, 16636.70, 2.0183, 0.85, 30, 16, 0.00, 2851230.00, NULL, NULL),
(13229, '13229', '8-60-000077-00-78-6', 'AKIJ CNG STATION LTD.', 'NAGAR JALFOI (BYPASS),KAROTIA, TANGAIL.,.', 66.26, 27042.56, 16225.54, 2.0183, 0.85, 30, 16, 0.00, 805900.00, NULL, NULL),
(13230, '13230', '8-60-000078-00-78-8', 'ASUKA CNG & FILLING STATION', 'NORTH HIZOLTOLI, KALIAKAIR,GAZIPUR,.', 129.12, 52697.60, 31618.56, 1.6789, 0.85, 30, 16, 196600.00, 393200.00, NULL, NULL),
(13231, '13231', '8-60-000081-00-78-5', 'SEMCO CNG FILLING STATION', 'ELENGA, KALIHATI,TANGAIL,,.', 135.92, 55472.65, 33283.59, 1.6789, 0.85, 30, 16, 1536600.00, 1536600.00, NULL, NULL),
(13232, '13232', '8-60-000084-00-78-1', 'NASIR GLASS WARE&TUBE IND,LTD', 'GORAI, MIRZAPUR,TANGAIL,.', 850.21, 550932.05, 330559.23, 2.0183, 0.90, 30, 24, 23902700.00, 43695400.00, NULL, NULL),
(13233, '13233', '8-60-000089-00-78-1', 'M.H.JUTE MILLS LTD.', 'GORA, MIRZAPUR,TANGAIL,,.', 699.99, 174718.00, 87359.00, 2.0183, 0.80, 26, 12, 850850.00, 6541400.00, NULL, NULL),
(13234, '13234', '8-60-000090-00-78-4', 'M/S. G.M.S TEXTILES LTD.', 'TANSUTRAPUR, KALIAKOIR,,GAZIPUR.,.', 1400.00, 698872.00, 419323.00, 2.0183, 0.80, 26, 24, 921150.00, 28319600.00, NULL, NULL),
(13235, '13235', '8-60-000091-00-78-6', 'MAA CNG AND FILLING STATION', 'NORTH GAZARIA,KALIAKOIR,GAZIPUR.', 1920.00, 20877.42, 12526.45, 2.0183, 0.80, 30, 16, 213400.00, 0.00, NULL, NULL),
(13236, '13236', '8-60-000101-00-78-9', 'Petromax Cylinders Ltd.', 'Gorai,Mirzapur,Tangail,.', 22319.00, 167607.22, 83803.61, 1.0000, 0.85, 26, 12, NULL, 0.00, NULL, NULL),
(13237, '13237', '8-60-000105-00-78-7', 'M/s AB.R-SPININIG MILLS LTD.', 'GORAI, MOMIN NAGAR,,MIRZAPUR, TANGAIL.,.', 37080.00, 524153.85, 314492.31, 1.0000, 0.80, 26, 24, NULL, 0.00, NULL, NULL),
(13238, '13238', '8-60-000106-00-78-9', 'MONDOL SPINNING MILLS LIMITED', 'GORAI, MIRZAPUR, TANGAIL,,.', 126000.00, 2055121.52, 1233072.91, 1.0000, 0.80, 30, 24, 32881950.00, 4520900.00, NULL, NULL),
(13239, '13239', '8-60-005001-00-78-2', 'KUMUDINI WELFARE TRUST OF BENG', 'MIRZAPUR,TANGAIL.,.', 244.66, 86510.83, 51906.50, 1.6789, 0.85, 26, 16, 832250.00, 1664500.00, NULL, NULL),
(13240, '13240', '8-65-000070-01-63-3', 'GLOBAL HEAVY CHEMI. LTD.(MAIN)', 'HASNABAD, KERANIGANJ,ZINJIRA, DHAKA.,VAT.REG.000002908-0004.', 2295.02, 1569779.68, 941867.00, 1.0000, 0.95, 30, 24, 14559675.00, 19872250.00, NULL, NULL),
(13241, '13241', '8-70-000022-00-66-7', 'METROCEM CEMENT LTD.', 'WEST MUKTARPUR,MUNSHIGONJ.,.', 693.20, 474145.89, 355609.41, 1.6789, 0.95, 30, 24, 4564350.00, 4426800.00, NULL, NULL),
(13242, '13242', '8-70-000024-00-66-1', 'EAGLE FIBRE IND. LTD. (GEN)', 'MUKTERPUR, PANCHASAR,MUNSHIGANJ,.', 135.92, 33926.00, 16963.00, 2.0183, 0.80, 26, 12, 469900.00, 400000.00, NULL, NULL),
(13243, '13243', '8-70-000026-00-66-5', 'ASIAN SPECIALISED TEX.MILLS LT', 'WEST MUKTARPUR,PANCHASHAR,MUNSHIGONJ.', 679.60, 180231.00, 90115.50, 1.0000, 0.85, 26, 12, 2496200.00, 0.00, NULL, NULL),
(13244, '13244', '8-70-000031-00-66-6', 'MASTER FISHING NET IND. LTD.', 'DINGA VANGA, PANCHASAR,MUNSHIGANJ.,.', 63.88, 12623.25, 0.01, 1.6789, 0.95, 26, 8, 524550.00, 0.00, NULL, NULL),
(13245, '13245', '8-70-000035-00-66-4', 'MEGHNA FABRICS INDUSTRIES(GEN)', 'SARKAR PARA,PANCHASAR,MUNSHIGONJ.', 135.92, 67852.00, 40711.20, 2.0183, 0.80, 26, 24, 126550.00, 0.00, NULL, NULL),
(13246, '13246', '8-70-000038-00-66-0', 'CROWN POWER GENERAION LTD.', 'WEST MUKTERPUR,MUNSHIGANJ,.', 1189.31, 593702.00, 356221.20, 1.0000, 0.80, 26, 24, 8222800.00, 16445600.00, NULL, NULL),
(13247, '13247', '8-70-000039-00-66-2', 'BARNALI FABRICS LTD.', 'WEST MUKTARPUR,MUNSHIGONJ,.', 258.25, 128918.00, 77350.80, 1.6789, 0.80, 26, 24, 1785550.00, 961730.00, NULL, NULL),
(13248, '13248', '8-70-000040-00-66-5', 'MUNSHIGONJ FIBER', 'HAT LAXIMIGONJ,MUNSHIGONJ,.', 176.70, 44103.56, 22051.78, 1.0000, 0.80, 26, 12, 610850.00, 1221700.00, NULL, NULL),
(13249, '13249', '8-70-000043-00-66-1', 'PREMIER POWER GENERATION LTD.', 'WEST MUKTARPUR,MUNSHIGANJ,.', 1359.21, 678516.31, 407109.79, 1.0000, 0.80, 26, 24, 10109900.00, 14379300.00, NULL, NULL),
(13250, '13250', '8-70-000046-00-66-7', 'STAR FISHING & TOWAIN FACTORY', 'MOKTARPUR,PANCHOSAR,MUNSHIGANJ,.', 103.31, 17189.08, 0.01, 2.0183, 0.80, 26, 8, 714300.00, 0.00, NULL, NULL),
(13251, '13251', '8-70-000050-00-66-6', 'M/S ACTIVE FINE CHEMICALS LTD.', 'WEST MUKTARPUR,MUNSHIGONJ,.', 135.92, 45250.28, 27150.17, 1.6789, 0.80, 26, 16, 406300.00, 0.00, NULL, NULL),
(13252, '13252', '8-71-000001-00-69-1', 'AZAD CNG & FILLING STATION', 'DIGARKANDA,AMLITOLA,MUYMENSING.', 67.96, 11309.00, 0.01, 1.6789, 0.80, 26, 8, 155800.00, 171000.00, NULL, NULL),
(13253, '13253', '8-71-000002-00-69-3', 'M/S.NITOL GAS DISTRIBUTION', 'COMPANY LTD.,CHATRAPUR, SIKARIKANDA,,MYMENSINGH..', 71.35, 27411.00, 16446.60, 2.0183, 0.80, 30, 16, 204500.00, 409000.00, NULL, NULL),
(13254, '13254', '8-71-000003-00-69-5', 'Akij CNG Station Ltd.', 'Digharkanda, Amlitola,Dhaka- Mymensingh Road,Mymensingh..', 64.59, 24806.00, 14883.60, 2.0183, 0.80, 30, 16, 344000.00, 414800.00, NULL, NULL),
(13255, '13255', '8-73-000001-00-69-5', 'INTRACO NATURAL GAS STN.LTD.', 'VATI BARERA,DHAKA MYMENSINGH ROAD,MYMENSINGH.', 59.49, 22851.67, 13711.00, 1.6789, 0.80, 30, 16, 85250.00, 170500.00, NULL, NULL),
(13256, '13256', '8-73-000002-00-69-7', 'M/S.STAR FILLING AND CNG RE-', 'FUELING STATION,DIGHARKANDA AMLITOLA,,MYMENSINGH..', 2400.00, 26097.00, 15658.20, 2.0183, 0.80, 30, 16, 218170.92, 0.00, NULL, NULL),
(13257, '13257', '8-76-000001-00-93-2', 'M/S A.R kHAN PATHAN CNG REFUEL', 'HOSSENPUR, NETROKONA,NETROKONA,.', 170.00, 65280.00, 39168.00, 1.6789, 0.80, 30, 16, 628000.00, 1256000.00, NULL, NULL),
(13258, '13258', '8-77-000004-00-90-4', 'SONAR BANGLA FEELING STA.', 'BOAR BAZAR,CHODDOSOTO,KISHOREGONG,,.', 85.00, 41310.00, 24786.00, 2.0183, 0.90, 30, 18, 572100.00, 1144200.00, NULL, NULL),
(13259, '13259', '8-78-000001-00-69-5', 'MADANI CNG STATION', 'DARIRAMPUR TRISAL,,MYMENSINGH.,.', 2400.00, 26097.00, 15658.20, 2.0183, 0.80, 30, 16, 97350.00, 37912200.00, NULL, NULL),
(13260, '13260', '8-78-000002-00-69-7', 'M/S.AKIJ PARTICLE BOARD MILLS', 'Akij Economic Zone,Trishal,,Mymensingh.,VAT Reg. No : 000000884-0004.', 90000.00, 1272219.00, 0.00, 1.0000, 0.80, 26, 24, 18956100.00, 0.00, NULL, NULL),
(13261, '13261', '8-78-000003-00-69-9', 'M/S. DRESDEN TEXTILES LTD', 'GUZIAM, 12 NO. AMIRABARI, TRISHAL, MYMENSINGH,,.', 24000.00, 339258.16, 203554.90, 1.0000, 0.80, 26, 24, 4698750.00, 9397500.00, NULL, NULL),
(13262, '13262', '8-78-000004-00-69-1', 'M/S Akij Biax Films Ltd.', 'Akij Economic Zone , Raymoni, Trishal, Mymensingh,,.', 120000.00, 1696291.00, 1017774.60, 2.0183, 0.80, 26, 24, 23493650.00, 46987300.00, NULL, NULL),
(13263, '13263', '8-79-000002-00-96-6', 'SIRAJ CYCLE IND. LTD.', 'MULAID, MOUNA,SREEPUR, GAZIPUR.,.', 489.31, 129766.00, 64883.00, 2.0183, 0.85, 26, 12, 1934000.00, 3744000.00, NULL, NULL),
(13264, '13264', '8-79-000003-00-96-8', 'DIVINE SPINNING MILLS LIMITED', 'CAWA, SREEPUR,,GAZIPUR.,.', 1054.24, 526274.22, 315764.53, 1.0000, 0.80, 26, 24, 7841500.00, 15683000.88, NULL, NULL),
(13265, '13265', '8-79-000006-00-96-4', 'ARMADA SPINNING MILLS LIMITED', 'GORGORIA MASTER BARI, GILAR CHALA,,SREEPUR,GAZIPUR.', 1146.89, 679876.39, 407925.83, 1.5431, 0.95, 26, 24, 17858500.00, 35717000.00, NULL, NULL),
(13266, '13266', '8-79-000009-00-96-0', 'ECO COTTON MILLS (GEN)', 'GILAR CHALA, MOUNA,SREEPUR,GAZIPUR.', 1393.18, 695479.21, 417287.53, 2.0183, 0.80, 26, 24, 35384650.00, 2674100.00, NULL, NULL),
(13267, '13267', '8-79-000011-01-96-7', 'GULSHAN SPINNING MILLS LTD (G)', 'JOINA BAZAR,SREEPUR,GAZIPUR.', 543.69, 322299.43, 193379.66, 1.6788, 0.95, 26, 24, 2583750.00, 7590625.00, NULL, NULL),
(13268, '13268', '8-79-000011-01-96-7', 'GULSHAN SPINNING MILLS LTD (G)', 'JOINA BAZAR,SREEPUR,GAZIPUR.', 543.69, 322299.43, 193379.66, 1.6788, 0.95, 26, 24, 2583750.00, 7590625.00, NULL, NULL),
(13269, '13269', '8-79-000011-02-96-9', 'GULSHAN SPINING MILLS LTD.', 'JAINA BAZAR, SREEPUR,GAZIPUR.,.', 679.60, 339256.32, 203554.00, 1.6789, 0.80, 26, 24, 3263650.00, 854900.00, NULL, NULL),
(13270, '13270', '8-79-000011-03-96-1', 'GULSHAN SPINNING LTD.(UNIT-03)', 'JAINA BAZAR,SREEPUR,GAZIPUR.', 1446.20, 721942.00, 433165.20, 2.0183, 0.80, 26, 24, 6945100.00, 1819200.00, NULL, NULL),
(13271, '13271', '8-79-000012-00-96-7', 'MIRACLE INDUSTRIES LTD. (GEN)', 'GILAR CHALA,SREEPUR,GAZIPUR.', 312.62, 185320.00, 111192.00, 1.6789, 0.95, 15, 8, 2567000.00, 3758100.00, NULL, NULL),
(13272, '13272', '8-79-000016-00-96-5', 'OTTO SPINNING LIMITED. (GEN)', 'TELIHATI, SREEPUR,GAZIPUR,GAZIPUR.', 1705.80, 851544.00, 510926.40, 1.6788, 0.80, 26, 24, 16732000.00, 30347830.00, NULL, NULL),
(13273, '13273', '8-79-000020-00-96-4', 'IDEAL SPINNING MILLS LTD.(GEN)', 'JAMARDIA,VALUKA,MYMENSINGH.', 578.34, 288708.69, 173226.00, 2.0183, 0.80, 26, 24, 2414000.00, 2241700.00, NULL, NULL),
(13274, '13274', '8-79-000023-00-96-0', 'ARIF KNITSPIN LTD. (GEN)', 'JAMARDIA, SEED STORE,VALUKA,MYMENSINGH.', 2162.00, 1079270.00, 647562.00, 1.0000, 0.80, 26, 24, 10383000.00, 12764000.00, NULL, NULL),
(13275, '13275', '8-79-000024-00-96-2', 'RASEL SPINING MILLS LTD.', 'KATHALI, VALUKA,MYMENSING,.', 1221.58, 609814.52, 365888.71, 1.0000, 0.80, 26, 24, 9757050.00, 15316265.00, NULL, NULL),
(13276, '13276', '8-79-000025-01-96-6', 'SHEPHERD IND. LTD.', 'KATHALI, VALUKA,MYMENSHINGH.,.', 812.00, 405414.00, 243248.00, 1.6789, 0.80, 26, 24, 5615000.00, 11321000.00, NULL, NULL),
(13277, '13277', '8-79-000025-01-96-6', 'SHEPHERD IND. LTD.', 'KATHALI, VALUKA,MYMENSHINGH.,.', 812.00, 405414.00, 243248.00, 1.6789, 0.80, 26, 24, 5615000.00, 11321000.00, NULL, NULL),
(13278, '13278', '8-79-000026-00-96-6', 'M.L. DYEING LTD.', 'JAMARDIA, VALUKA,MYMENSINGH.,.', 424.75, 141358.00, 84814.80, 2.0183, 0.80, 26, 16, 1182000.00, 1309485.00, NULL, NULL),
(13279, '13279', '8-79-000027-00-96-8', 'OSHIN KNITWEARS LTD. (GEN1)', 'JAINA BAZAR, SHREEPUR,GAZIPUR,.', 1246.22, 622114.60, 373268.79, 1.6789, 0.80, 26, 24, 5201000.00, 9864000.00, NULL, NULL),
(13280, '13280', '8-79-000027-00-96-8', 'OSHIN KNITWEARS LTD. (GEN1)', 'JAINA BAZAR, SHREEPUR,GAZIPUR,.', 1246.22, 622114.60, 373268.79, 1.6789, 0.80, 26, 24, 5201000.00, 9864000.00, NULL, NULL),
(13281, '13281', '8-79-000027-02-96-2', 'M/S. OSHIN KNITE WEAR LTD.', 'JAINA BAZAR, SREEPUR,GAZIPUR.,,.', 349.99, 58240.00, 0.01, 1.6789, 0.80, 26, 8, 486900.00, 0.00, NULL, NULL),
(13282, '13282', '8-79-000028-01-96-2', 'SUNNY BREEDER\'S LTD.(GEN)', 'KATWALI, VALUKA,MYMENSING,.', 355.43, 177432.00, 106459.20, 1.6789, 0.80, 26, 24, 1594000.00, 0.00, NULL, NULL),
(13283, '13283', '8-79-000032-00-96-9', 'M/S PACIFIC COTTON LIMITED', 'HABIRBARI, SEEDSTORE,VALUKA,MYMENSING.', 700.00, 349440.00, 209664.00, 1.0000, 0.80, 26, 24, 10414000.00, 18221200.00, NULL, NULL),
(13284, '13284', '8-79-000033-00-96-1', 'HWA WELL TEXTILE (BD) LTD.', 'KASHAR GAR, VALUKA,MYMENSINGH.,.', 389.00, 194188.00, 116512.80, 1.6789, 0.80, 26, 24, 1869000.00, 1620000.00, NULL, NULL),
(13285, '13285', '8-79-000035-00-96-5', 'BELI YEARN DYEING LTD.', '154, LABAN KOTA, SEED STORE,VALUKA, MYMENSINGH.,.', 526.13, 262642.35, 157585.41, 1.0000, 0.80, 26, 24, 3637600.00, 7121200.00, NULL, NULL),
(13286, '13286', '8-79-000036-00-96-7', 'MULTAZIM SPINNING MILLS LTD.', 'VARADOBA, VALUKA,MYMENSINGH.,.', 4659.28, 2325911.50, 1395546.90, 2.0183, 0.80, 26, 24, 60496100.00, 118205300.00, NULL, NULL),
(13287, '13287', '8-79-000037-00-96-9', 'S Q HUES LTD.', 'HABIRBARI, JAMIRDIA,VALUKA, MYMENSINGH.,.', 815.52, 407109.00, 244265.40, 1.6789, 0.80, 26, 24, 6513750.00, 12303000.00, NULL, NULL),
(13288, '13288', '8-79-000037-00-96-9', 'S Q HUES LTD.', 'HABIRBARI, JAMIRDIA,VALUKA, MYMENSINGH.,.', 815.52, 407109.00, 244265.40, 1.6789, 0.80, 26, 24, 6513750.00, 12303000.00, NULL, NULL),
(13289, '13289', '8-79-000039-00-96-3', 'F.M. YARN DYEING LTD.', 'AKHALIA, HAZIR BAZAR,SEED STORE, VALUKA,MYMENSINGH..', 1574.98, 786320.75, 471792.47, 2.0183, 0.80, 26, 24, 7060400.00, 14145400.00, NULL, NULL),
(13290, '13290', '8-79-000040-00-96-6', 'IMPRENSIVE TEXTILE MILLS LTD.', 'MASTER BARI, VALUKA,MYMENSINGH.,.', 324.00, 161741.00, 97045.00, 1.6789, 0.80, 26, 24, 676100.00, 210200.00, NULL, NULL),
(13291, '13291', '8-79-000042-00-96-0', 'SQUARE FASHION LTD. (UNIT-2)', 'ROKEYAPUR, JAMIRDIA,HOBIR BARI, VALUKA,MYMENSINGH..', 1936.87, 966886.00, 580131.60, 1.6789, 0.80, 26, 24, 8084000.00, 12493700.00, NULL, NULL),
(13292, '13292', '8-79-000042-02-96-4', 'SQUARE FASHIONS LTD. (UNIT-2)', 'JAMIRDIA, VALUKA,,MYMENSINGH.,.', 543.68, 90468.84, 0.01, 1.6789, 0.80, 26, 8, 756400.00, 486900.00, NULL, NULL),
(13293, '13293', '8-79-000043-00-96-2', 'SQUARE FASHION LTD.', 'JAMIRDIA, VALUKA,MYMENSINGH.,.', 874.48, 436538.96, 261923.38, 1.6789, 0.80, 26, 24, 3650000.00, 6893200.00, NULL, NULL),
(13294, '13294', '8-79-000043-00-96-2', 'SQUARE FASHION LTD.', 'JAMIRDIA, VALUKA,MYMENSINGH.,.', 874.48, 436538.96, 261923.38, 1.6789, 0.80, 26, 24, 3650000.00, 6893200.00, NULL, NULL),
(13295, '13295', '8-79-000043-02-96-6', 'M/S.SQUARE FASHON LTD.', 'JAMIRDIAMASTERBARI, VALUKA,,MYMENSINGS.,.', 350.00, 58239.32, 0.01, 1.6789, 0.80, 26, 8, 486900.00, 0.00, NULL, NULL),
(13296, '13296', '8-79-000044-00-96-4', 'NRG SPINNING MILLS LIMITED', 'MASTERBARI,VALUKA,MAYMENSING.', 2509.35, 1252668.30, 751600.98, 2.0183, 0.80, 26, 24, 22664450.00, 27037200.00, NULL, NULL),
(13297, '13297', '8-79-000045-00-96-6', 'BADSHA TEXTILES LTD.', 'JAMIRDIA, MASTERBARI, VALUKA,,MYMENSINGH.,.', 4227.84, 2110539.12, 1266323.47, 2.0183, 0.80, 26, 24, 31472000.00, 62944000.00, NULL, NULL),
(13298, '13298', '8-79-000047-00-96-0', 'BEACON PHARMACEUTICALS LTD.', 'KATHALI, VALUKA,,MYMENSINGH.,VAT REG. NO-18091006844.', 1473.38, 367755.85, 183877.92, 2.0183, 0.80, 26, 12, 5480000.00, 10960000.00, NULL, NULL),
(13299, '13299', '8-79-000050-00-96-7', 'PA KNIT COMPOSITE LTD.', 'JAMIRDIA, HABIRBARI,VALUKA, MYMENSHINGH,.', 1321.26, 439716.27, 263829.76, 1.6789, 0.80, 26, 16, 7035500.00, 7291200.00, NULL, NULL),
(13300, '13300', '8-79-000051-00-96-9', 'AKBAR COTTON MILLS LTD.', 'JAMIRDIA,VALUKA,MYMENSINGH.', 1049.99, 524155.00, 314493.00, 2.0183, 0.80, 26, 24, 8386500.00, 15879824.00, NULL, NULL),
(13301, '13301', '8-79-000052-00-96-1', 'DADA ENGINEERING LTD.', 'JOYNA BAZAR,SREEPUR,GAZIPUR.', 483.87, 241551.81, 144931.08, 1.6789, 0.80, 26, 24, 2020000.00, 1725456.00, NULL, NULL),
(13302, '13302', '8-79-000054-00-96-5', 'PANDORA SWEATERS LTD.', 'GILAR CHALA,SREEPUR,GAZIPUR.', 273.54, 136552.00, 81931.20, 1.6789, 0.80, 26, 24, 1142000.00, 1791492.00, NULL, NULL),
(13303, '13303', '8-79-000055-00-96-7', 'SHEPHERD INDUSTRIES  LTD.', 'KATHALIA,BHALUKA,MYMENSING.', 350.00, 87358.97, 43679.48, 1.6789, 0.80, 26, 12, 1209950.00, 2419900.00, NULL, NULL),
(13304, '13304', '8-79-000056-00-96-9', 'NRG COMPSITE YEARN DYEING', 'JAMIRDIA, MASTERBARI,BHALIKA,MYMENSING.', 4694.19, 2343340.90, 1406004.54, 1.0000, 0.80, 26, 24, 32455300.00, 64910600.00, NULL, NULL),
(13305, '13305', '8-79-000059-00-96-5', 'PNR INDUSTRIES LTD.', 'KATHALI,VHALUKA,MYMENSING.', 237.89, 59370.00, 29685.00, 1.6789, 0.80, 26, 12, 822300.00, 538100.00, NULL, NULL),
(13306, '13306', '8-79-000060-00-96-8', 'H & S CERAMIC IND LTD.', 'HOBIRBARI, SIDSTORE,,VALUKA, MYMENSHING,,.', 225.97, 112407.54, 67444.52, 1.6789, 0.80, 26, 24, 3956800.00, 1683200.00, NULL, NULL),
(13307, '13307', '8-79-000061-00-96-0', 'HAMID TEX FASHION LTD.', 'HOBIRBARI, SIDSTORE,,VALUKA,,MYMENSHING.', 54.37, 18093.76, 10856.26, 1.6788, 0.80, 26, 16, 662000.00, 0.00, NULL, NULL),
(13308, '13308', '8-79-000062-00-96-2', 'RIDISHA SPINING LTD.', 'JAMIRDIA, SIDSTORE,VALUKA,MYMENSING.', 2869.91, 1432658.92, 859595.35, 2.0183, 0.80, 26, 24, 19842350.00, 31962000.00, NULL, NULL),
(13309, '13309', '8-79-000063-00-96-4', 'CONSUMER KNITEX LTD.', 'DHUMSUR, KATHALI,VHALUKA,MYMENSING.', 2783.54, 1389544.86, 833726.92, 2.0183, 0.80, 26, 24, 22232750.00, 34852800.00, NULL, NULL),
(13310, '13310', '8-79-000064-00-96-6', 'APPAREL WET PROCESSING LTD.', 'MEHARA BARI, SEED STORE,VALUKA,MYMENSING.', 258.25, 85945.60, 51567.36, 1.6788, 0.80, 26, 16, 3203550.00, 2380700.00, NULL, NULL),
(13311, '13311', '8-79-000065-00-96-8', 'RHYMER CHEMICAL IND. LTD.', 'KASORGHOR ROAD, HOBIRBARI,VHALUKA,MYMENSING.', 122.32, 61062.00, 36637.20, 1.6789, 0.80, 26, 24, 845750.00, 0.00, NULL, NULL),
(13312, '13312', '8-79-000066-00-96-0', 'BSB SPINING MILL\\S LTD.', 'VORADUBA, VHALUKA,,MYMENSINGH,.', 1209.69, 603884.00, 362330.40, 1.0000, 0.80, 26, 24, 8998000.00, 17996000.00, NULL, NULL),
(13313, '13313', '8-79-000067-00-96-2', 'ENVOY TEXTILE LTD.', 'JAMIRDIA,VHALUKA,MYMENSING.', 4254.37, 2450520.68, 1470312.41, 1.0000, 0.80, 30, 24, 33939750.00, 65619300.00, NULL, NULL),
(13314, '13314', '8-79-000068-00-96-4', 'ASHIQ COMPOSITE TEX.MILLS LTD.', 'KATHALI, VHALUKA,MYMENSING,.', 1606.07, 801750.14, 481050.08, 1.0000, 0.80, 26, 24, 11104350.00, 4010322.00, NULL, NULL),
(13315, '13315', '8-79-000069-00-96-6', 'NARISH POULTRY & HACHARY LTD.', 'JAMIRDIS,VHALUKA,MYMWNSING.', 1561.05, 779276.00, 467565.60, 2.0183, 0.80, 26, 24, 10793000.00, 17677000.00, NULL, NULL),
(13316, '13316', '8-79-000070-00-96-9', 'SQUARE TEXCOM LIMITED', 'SQUARE CENTRE,48 MOHAKHALI C/A,DHAKA-1212,.', 893.68, 446125.06, 267675.04, 2.0183, 0.80, 26, 24, 6647500.00, 14760300.00, NULL, NULL),
(13317, '13317', '8-79-000070-00-96-9', 'SQUARE TEXCOM LIMITED', 'SQUARE CENTRE,48 MOHAKHALI C/A,DHAKA-1212,.', 893.68, 446125.06, 267675.04, 2.0183, 0.80, 26, 24, 6647500.00, 14760300.00, NULL, NULL),
(13318, '13318', '8-79-000070-01-96-1', 'SQUARE TEXCOM LIMITED', 'SQUARE CENTRE,48 MOHAKHALI C/A,DHAKA-1212,.', 350.00, 58240.00, 0.01, 2.0183, 0.80, 26, 8, 806650.00, 0.00, NULL, NULL),
(13319, '13319', '8-79-000071-00-96-1', 'MONICO PHARMA LTD.', 'NOYONPUR,SREEPUR,GAZIPUR.', 81.56, 20356.00, 10178.00, 1.6789, 0.80, 26, 12, 227850.00, 148000.00, NULL, NULL),
(13320, '13320', '8-79-000072-00-96-3', 'MAHDEEN SWEATERS TLD.', 'JAMIRDIA,VHALUKA,MYMENSING.', 119.63, 29854.72, 14927.36, 1.6789, 0.80, 26, 12, 288000.00, 0.00, NULL, NULL),
(13321, '13321', '8-79-000073-00-96-5', 'ADVANCED COM. TEXTILES LTD.', 'KASHORGOR, MASTER BARI,VALUKA,MYMENSING.', 390.00, 103453.00, 51726.50, 2.0183, 0.85, 26, 12, 1432850.00, 864900.00, NULL, NULL),
(13322, '13322', '8-79-000074-00-96-7', 'SHEEMA SPINNING MILLS LTD.', 'VORADUBA,VHALUKA,MYMENSING.', 1400.00, 698871.80, 419323.08, 1.0000, 0.80, 26, 24, 10413500.00, 20922000.00, NULL, NULL),
(13323, '13323', '8-79-000075-00-96-9', 'ORCHARD SWEATERS LTD.', 'JAMIRDIA, MASTER BARI,BHALUKA,MYMENSING.', 96.00, 31948.80, 19169.28, 2.0183, 0.80, 26, 16, 268000.00, 238400.00, NULL, NULL),
(13324, '13324', '8-79-000076-00-96-1', 'TANIA COTTON MILLS LTD.', 'MAMARISHPUR, BHALUKA, MYMENSINGH,,.', 1050.00, 524160.00, 314496.00, 1.0000, 0.80, 26, 24, 7023850.00, 14990900.00, NULL, NULL),
(13325, '13325', '8-79-000080-00-96-0', 'PATRIOT SPINNING MILLS LTD.', 'VORADOBA,VALUKA,MYMENSING.', 1682.02, 839663.94, 503798.36, 1.0000, 0.80, 26, 24, 13434650.00, 23868000.00, NULL, NULL),
(13326, '13326', '8-79-000083-00-96-6', 'M/S. BASAR SPINNING MILLS LTD.', 'NISHINDA, VALUKA,,MYMENSINGH.,.', 1223.29, 610666.03, 366399.62, 1.0000, 0.80, 26, 24, 9099000.00, 28730700.00, NULL, NULL),
(13327, '13327', '8-79-000084-00-96-8', 'INDEX AGRO INDS. LTD.', 'DHAKA-MYMENSING ROAD,KHATHALI,9 NO WARD, VALIKA,MYMENSING.', 135.92, 45251.00, 27150.60, 1.6789, 0.80, 26, 16, 5638500.00, 11277000.00, NULL, NULL),
(13328, '13328', '8-79-000085-00-96-0', 'URBIE CNG FILLING STATION', 'KATHALI,BHALUKA,MYMENSING.', 101.26, 50549.00, 30329.40, 1.6789, 0.80, 26, 24, 700650.00, 804400.00, NULL, NULL),
(13329, '13329', '8-79-000086-00-96-2', 'M/S.AUTO CROP CARE LTD.', 'MAMARISHPUR,MALLIK BARI,,VALUKA,MYMENSINGH.,.', 174.99, 43692.86, 21846.43, 1.6789, 0.80, 26, 12, 1397800.00, 1565200.00, NULL, NULL),
(13330, '13330', '8-79-000087-00-96-4', 'AT&T SPINING MILLS LTD.', 'JAMIRDIA,MASTARBARI,,BHALUKA,MYMENSINGH.,.', 2038.81, 1017775.00, 610665.00, 2.0183, 0.80, 26, 24, 14096200.00, 28192400.00, NULL, NULL),
(13331, '13331', '8-79-000088-00-96-6', 'KALLOL THAI PRESIDENT FOODS', '(BD) LTD.,SHISHUPALLI ROAD, TANGRA, TELIHATI,,SREEPUR, GAZIPUR..', 169.90, 56548.69, 33929.21, 2.0183, 0.80, 26, 16, 783200.00, 2130400.00, NULL, NULL),
(13332, '13332', '8-79-000089-00-96-8', 'KAMAL YARN LIMITED', 'JAMIRDIA,MASTERBARI, VALUKA,MYMENSINGH..', 8691.28, 4338687.74, 2603212.64, 2.0183, 0.80, 26, 24, 64646450.00, 127444900.00, NULL, NULL),
(13333, '13333', '8-79-000089-00-96-8', 'KAMAL YARN LIMITED', 'JAMIRDIA,MASTERBARI, VALUKA,MYMENSINGH..', 8691.28, 4338687.74, 2603212.64, 2.0183, 0.80, 26, 24, 64646450.00, 127444900.00, NULL, NULL),
(13334, '13334', '8-79-000089-01-96-0', 'KAMAL YARN LIMITED (STAND BY)', 'JAMIRDIA MASTERBARI,,VALUKA,MYMENSINGH..', 543.68, 58240.00, 0.01, 2.0183, 0.80, 26, 8, 871000.00, 0.00, NULL, NULL),
(13335, '13335', '8-79-000090-00-96-1', 'NAVID WOOL WEARS LTD.', 'SHAITALIA,SREEPUR,GAZIPUR.', 75.09, 18744.00, 9372.00, 1.3395, 0.80, 26, 12, 543000.00, 0.00, NULL, NULL),
(13336, '13336', '8-79-000091-00-96-3', 'S.K. ZOHURUDDIN CNG F.STATION', 'VAGRAPARA, 9 NO. WARD,VALUKA POURASAVA, VALUKA,MYMENSINGH.', 65.18, 32564.35, 19538.61, 2.0183, 0.80, 26, 24, 272000.00, 0.00, NULL, NULL),
(13337, '13337', '8-79-000092-00-96-5', 'M/S. EXPERIENCE TEXTILE LTD.', 'VARADOBA, VALUKA,,MYMENSINGH.,.', 1249.80, 623895.20, 374337.12, 1.0000, 0.80, 26, 24, 9297000.00, 18594000.00, NULL, NULL),
(13338, '13338', '8-79-000093-00-96-7', 'SISU PALLI PLUS', 'SISU PALLI ROAD,TENGRA,SREEPUR,GAZIPUR,,.', 53.83, 8958.00, 0.01, 1.6789, 0.80, 26, 8, 133900.00, 0.00, NULL, NULL),
(13339, '13339', '8-79-000095-00-96-1', 'M/S.AKBAR COMPOSITE LTD.', 'JAMIRDIA, VALUKA, MYMENSINGH.,,.', 723.10, 360982.80, 216589.70, 2.0183, 0.80, 26, 24, 5775750.00, 13019300.00, NULL, NULL),
(13340, '13340', '8-79-000096-00-96-3', 'M/S. S.N.S CNG & CONVERSION', 'STATION.,VANDABO, VARADOBA, VALUKA,,MYMENSINGH..', 98.54, 37859.60, 22715.76, 1.6789, 0.80, 30, 16, 141250.00, 0.00, NULL, NULL),
(13341, '13341', '8-79-000097-00-96-5', 'M/S.PURBASHA CNG STATION LTD.', 'JAMIRDIA,MASTER BARI,,VALUKA, MYMENSINGH.,.', 72.37, 27794.00, 16676.40, 2.0183, 0.80, 30, 16, 385000.00, 0.00, NULL, NULL),
(13342, '13342', '8-79-000098-00-96-7', 'M/S.NOMAN COMPOSITE TEXTILE', 'LTD.,JAMIRDIA MASTERBARI VALUKA,,MYMENSINGH..', 2574.34, 1285110.00, 771066.00, 2.0183, 0.80, 26, 24, 5371800.00, 10743600.00, NULL, NULL),
(13343, '13343', '8-79-000099-00-96-9', 'M/S.SIMCO SPINNING&TEXTILESLTD', 'MALLIKBARI ROAD,DHAMSUR VALUKA,MYMENSINGH.,.', 1019.41, 508884.48, 305330.68, 1.0000, 0.80, 26, 24, 7048100.00, 8510000.00, NULL, NULL),
(13344, '13344', '8-79-000100-00-96-4', 'M/S.TM TEXTILES & GARMENTS LTD', 'KASHOR, HOBIRBARI,,VALUKA, MYMENSINGH,,.', 1497.29, 747450.04, 448470.02, 2.0183, 0.80, 26, 24, 10352200.00, 10020400.00, NULL, NULL),
(13345, '13345', '8-79-000102-00-96-8', 'M/S.AKIJ CERAMICS LTD.', 'MUKHOPUR,TRISAL,,MYMENSINGH.,.', 1885.00, 846270.00, 507762.00, 1.0000, 0.80, 30, 24, 28889300.00, 57778600.00, NULL, NULL),
(13346, '13346', '8-79-000103-00-96-0', 'PIONEER KNITWEARS (BD) LTD.', 'GAIRAPARA, JAMIRDIA, HOBIRBARI,VALUKA, MYMENSINGH.,.', 348.13, 173787.11, 104272.27, 2.0183, 0.80, 26, 24, 1561000.00, 0.00, NULL, NULL),
(13347, '13347', '8-79-000104-00-96-2', 'PIONEER KNITWEARS (BD) LTD.', 'DUBALIAPARA, JAMIRDIA,HOBIRBARI, VALUKA,MYMENSINGH..', 2404.10, 1200125.73, 720075.44, 1.0000, 0.80, 26, 24, 17881900.00, 30829800.00, NULL, NULL),
(13348, '13348', '8-79-000106-00-96-6', 'RAIDHA COLLECTIONS LTD.', 'JAMIRDIA, BHALUKA, MYMENSINGH,,.', 760.08, 379432.00, 227659.20, 1.6789, 0.80, 26, 24, 5654000.00, 21818300.00, NULL, NULL),
(13349, '13349', '8-79-000107-00-96-8', 'ORION KNIT TEXTILE LTD.', 'JAMIRDIA,HABIRBARI,VALUKA,,MYMENSINGH.,.', 262.50, 65519.23, 32759.61, 1.6789, 0.80, 26, 12, 4457950.00, 7648800.00, NULL, NULL),
(13350, '13350', '8-79-000108-00-96-0', 'BADSHA TEXTILES LTD.', 'JAMIRDIA,MASTERBARI,VALUKA,,MYMENSINGH.,.', 3920.18, 1956954.13, 1174172.48, 2.0183, 0.80, 26, 24, 29159000.00, 38318000.00, NULL, NULL),
(13351, '13351', '8-79-000109-00-96-2', 'PIONEER KNITWEARS (BD) LTD.', 'JAMIRDIA, HOBIRBARI,,VALUKA,,MYMENSINGH..', 84900.00, 1200125.73, 720075.44, 2.0183, 0.80, 26, 24, 16621750.00, 10151500.00, NULL, NULL),
(13352, '13352', '8-79-000110-00-96-5', 'PIONEER KNITWEARS (BD) LTD,S-2', 'GAIRAPARA, JAMIRDIA, HOBIRBARI,VALUKA, MYMENSINGH,.', 617.23, 308122.30, 184873.39, 2.0183, 0.80, 26, 24, 2767000.00, 0.00, NULL, NULL),
(13353, '13353', '8-79-000110-01-96-7', 'PIONEER KNITWEARS(BD) LTD, S-2', 'GAIRAPARA, JAMIRDIA, HOBIRBARI,VALUKA, MYMENSINGH,.', 479.63, 0.00, 0.00, 2.0183, 0.80, 26, 24, 0.00, 0.00, NULL, NULL);
INSERT INTO `customer_infos` (`id`, `sl_no`, `customer_code`, `customer_name`, `address`, `hourly_load`, `monthly_load`, `min_load`, `pf`, `df`, `daily_run`, `hourly_run`, `sec_dep_cash`, `sec_dep_bank`, `created_at`, `updated_at`) VALUES
(13354, '13354', '8-79-000111-00-96-7', 'GLORY SPINNING LTD.', 'PURURA,BHARADOBA,BHALUKA,,MYMENSINGH.,.', 1400.00, 698871.80, 419323.08, 1.0000, 0.80, 26, 24, 18224000.00, 36448000.00, NULL, NULL),
(13355, '13355', '8-79-000112-00-96-9', 'MATAM SPINNING MILLS LTD.', 'BHARADOBA, BHALUKA,,MYMENSINGH.,.', 2105.07, 1050852.00, 630511.00, 2.0183, 0.80, 26, 24, 14554350.00, 17674600.00, NULL, NULL),
(13356, '13356', '8-79-000114-00-96-3', 'M/S SHEPHERD TEXTILE (BD) LTD', 'KATHALIA, BHALUKA, MYMANSINGH,,.', 358.72, 179057.63, 107434.58, 2.0183, 0.80, 26, 24, 2864950.00, 15632000.00, NULL, NULL),
(13357, '13357', '8-79-000115-00-96-5', 'TAFRID COTTON MILLS LTD.', 'BHORADOBA,VALUKA,,MYMENSINGH.,.', 102000.00, 1441847.16, 865108.30, 2.0183, 0.80, 26, 24, 19969650.00, 39939200.00, NULL, NULL),
(13358, '13358', '8-79-000116-00-96-7', 'NICE DENIM MILLS LTD', 'MAWNA, SREEPUR,GAZIPUR,.', 6524.20, 3256878.30, 1954126.98, 2.0183, 0.80, 26, 18, 45107800.00, 145347400.00, NULL, NULL),
(13359, '13359', '8-79-000119-00-96-3', 'M/S M.G. COTTON MILLS LTD.', 'KASHOR, HOBIRBARI, BHALUKA, MYMENSINGH,,.', 1019.41, 508887.23, 305332.34, 1.6789, 0.80, 26, 24, 13554050.00, 17316100.00, NULL, NULL),
(13360, '13360', '8-79-000120-00-96-6', 'ILMEEYAT APPARELS LTD.', 'JAMIRDIA, MASTERBARI, BHALUKA, MYMENSINGH,,.', 700.00, 349436.00, 209661.60, 2.0183, 0.80, 26, 24, 5207000.00, 10414000.00, NULL, NULL),
(13361, '13361', '8-79-000121-00-96-8', 'EXCELLENT TILES INDUSTRIES LTD', 'PARAGAON, SEED STORE BAZAR, BHALUKA, MYMENSINGH,,.', 1057.92, 528113.66, 316868.20, 2.0183, 0.80, 26, 24, 6584070.00, 14628800.00, NULL, NULL),
(13362, '13362', '8-79-000122-00-96-0', 'M/S. NORTEX TEXTILE MILLS LTD.', 'NISHINDA, VORADOBA, BHALUKA,,MYMENSINGH,.', 916.02, 485857.44, 291514.46, 2.0183, 0.85, 26, 24, 12085000.00, 0.00, NULL, NULL),
(13363, '13363', '8-79-000126-00-96-8', 'M/S SQUARE APPARELS', 'ZAMIRDIA, BHALUKA, MYMENSINGH,,.', 37080.00, 524153.85, 314492.31, 1.6789, 0.80, 26, 24, 19217650.00, 15620000.00, NULL, NULL),
(13364, '13364', '8-79-000127-00-96-0', 'INTERNATIONAL BEVERAGE LTD.', 'Hobirbari, Bhaluka, Mymensingh,,.', 1019.41, 508889.23, 305333.54, 1.6789, 0.80, 26, 24, 7583000.00, 0.00, NULL, NULL),
(13365, '13365', '8-79-000136-00-96-9', 'M/S MAWNA FASHIONS LIMITED', 'Taper Bari, Sreepur, Gazipur,,.', 396.49, 98964.43, 49482.21, 1.6789, 0.80, 26, 12, 1474600.00, 0.00, NULL, NULL),
(13366, '13366', '8-79-000137-00-96-1', 'SULTANA SWEATERS LTD.', 'AKHALIA, HAZIR BAZAR, BHALUKA, MYMENSINGH,,.', 753.23, 376011.12, 0.00, 2.0183, 0.80, 26, 24, 25275000.00, 10415600.00, NULL, NULL),
(13367, '13367', '8-79-000138-00-96-3', 'TAIPEI BANGLA FABRICS LTE', 'HAJEER BAJAR, BHALUKA, MYMENSINGH,,.', 1019.40, 508887.24, 305332.34, 1.0000, 0.80, 26, 24, 7582500.00, 14096200.00, NULL, NULL),
(13368, '13368', '8-79-000148-00-96-4', 'GLORY TEXTILE & APPARELS LTD.', 'Kharuail, Bhaluka, Mymensingh.,,.', 1749.98, 464094.56, 232047.28, 2.0183, 0.85, 26, 12, 6915500.00, 13831000.00, NULL, NULL),
(13369, '13369', '8-79-000151-00-96-1', 'NRG HOMETEX LTD.', 'Jamirdia, Masterbari, Bhaluka, Mymensingh.,,.', 2468.75, 1232397.66, 739438.60, 2.0183, 0.80, 26, 24, 17068750.00, 34137500.00, NULL, NULL),
(13370, '13370', '8-79-000167-00-96-4', 'T.S. SWEATERS LIMITED', 'BERAIDERCHALA, SREEPUR, GAZIPUR.,,.', 350.00, 174717.95, 104830.77, 2.0183, 0.80, 26, 24, 2419850.00, 4839700.00, NULL, NULL),
(13371, '13371', '8-79-000168-00-96-6', 'AKIJ CERAMICS LTD. U-2 (T. W.)', 'MOKKHOPUR, TRISHAL, MYMENSINGH,,.', 2182.04, 1256853.60, 754112.16, 1.0000, 0.80, 30, 24, 20109700.00, 34814900.00, NULL, NULL),
(13372, '13372', '8-81-000001-00-91-9', 'M/S.SRABAN BADHAN RICE MILLS', 'BSIC I/A, NOWHATA, SHERPUR.,,.', 54.36, 9046.88, 4522.94, 1.6789, 0.80, 26, 8, 125300.00, 67600.00, NULL, NULL),
(13373, '13373', '8-81-000002-00-91-1', 'M/S. TAJ CNG FILLING STATION', 'NABI NAGAR,,SHERPUR.,.', 74.75, 28707.00, 17224.20, 1.6789, 0.80, 30, 16, 397600.00, 552400.00, NULL, NULL),
(13374, '13374', '8-82-000001-00-92-3', 'ALHAJ JUTE MILLS LTD.', 'SHARISHABARI,JAMALPUR,.', 305.82, 152667.00, 91620.00, 2.0183, 0.80, 26, 24, 647950.00, 1295900.00, NULL, NULL),
(13375, '13375', '8-83-000001-00-94-9', 'NOBAB ALI CNG RE-FUELLING', 'NOTUN BAZAR, POYARKANDI, MUKTAGASA,,MYMENSINGH,.', 59.46, 22835.00, 13701.00, 1.6789, 0.80, 30, 16, 245000.00, 414114.00, NULL, NULL),
(13376, '13376', '8-84-000001-00-97-7', 'DELTA SPINNERS LTD.', 'KALTA PARA, BISHKA,GOURIPUR, MYMENSINGH.,.', 582.00, 789734.00, 473840.40, 1.6789, 0.80, 26, 24, 3301100.00, 0.00, NULL, NULL),
(13377, '13377', '8-84-000002-00-97-9', 'M/S. SARMANO ENERGY LTD.', 'CHAR-RAGHURAMPUR,SHAMBHUGONJ,BAZAR, MYMENSINGH.,KISHORGONJ ROAD,.', 71.35, 27402.00, 16441.20, 1.6789, 0.80, 30, 16, 759050.00, 651000.00, NULL, NULL),
(13378, '13378', '8-84-000007-00-97-9', 'M/S.TALLU SPINNING MILLS LTD.', 'KALTAPARA BAZAR,GOURIPUR,,MYMENSINGH.,.', 1087.36, 542834.00, 325700.00, 2.3578, 0.80, 26, 24, 2269050.00, 4050000.00, NULL, NULL),
(13379, '13379', '8-90-000004-00-01-5', 'TAZ MELAMINE IND.(PVT LTD).', '130, SOUTH KAMRANGIRCHAR,,HAJURPARA, THANA ROAD,,K.CHAR, DHAKA..', 103.30, 25796.00, 12898.00, 2.0183, 0.80, 26, 12, 262200.00, 0.00, NULL, NULL),
(13380, '13380', '8-90-000005-00-01-7', 'PANNA BATTERY LTD.', '425, WEST RASUL PUR,KAMRANGIR CHAR,DHAKA..', 690.00, 182988.00, 91494.00, 1.0000, 0.85, 26, 12, 3781800.00, 7669200.00, NULL, NULL),
(13381, '13381', '8-90-000006-00-01-9', 'MATADOR BALLPEN INDUSTRIES LTD', 'DAG-34,RAHAMATULLAH ROAD,,WEST RASULPUR,KAMRANGIRCHAR,DHAKA..', 263.35, 65731.26, 32865.63, 1.0000, 0.80, 26, 12, 1820800.00, 3641600.00, NULL, NULL),
(13382, '13382', '8-90-000007-00-01-1', 'R.S.CNG FILLING STATION LTD.', 'SOUTH SONATENGOR BERIBAD,,HAZARIBAGH,DHAKA..', 76.00, 23256.00, 11628.00, 1.6789, 0.85, 30, 12, 644200.00, 1288400.00, NULL, NULL),
(13383, '13383', '8-90-000007-00-01-1', 'R.S.CNG FILLING STATION LTD.', 'SOUTH SONATENGOR BERIBAD,,HAZARIBAGH,DHAKA..', 76.00, 23256.00, 11628.00, 1.6789, 0.85, 30, 12, 644200.00, 1288400.00, NULL, NULL),
(13384, '13384', '8-90-000007-00-01-1', 'R.S.CNG FILLING STATION LTD.', 'SOUTH SONATENGOR BERIBAD,,HAZARIBAGH,DHAKA..', 76.00, 23256.00, 11628.00, 1.6789, 0.85, 30, 12, 644200.00, 1288400.00, NULL, NULL),
(13385, '13385', '8-91-000002-00-06-3', 'VERITAS PHARMACEUTICALS LTD.', 'VANNARA,MOUCHAK,KALIAKAIR,GAZIPUR,.', 350.00, 58239.31, 29119.66, 2.0183, 0.80, 26, 8, 945400.00, 1890800.00, NULL, NULL),
(13386, '13386', '8-91-000003-00-06-5', 'LIBERTY KNITWEAR LIMITED', 'CHANDRA PALLI BIDYUT,KALIAKOIR,GAZIPUR.', 1446.20, 721941.36, 433164.81, 1.0000, 0.80, 26, 24, 26217350.00, 44579900.00, NULL, NULL),
(13387, '13387', '8-91-000005-00-06-9', 'TUSUKA WASHING LTD.', 'NEELNAGAR, KONABARI, GAZIPUR,,.', 350.00, 145598.30, 87358.97, 1.0000, 0.80, 26, 20, 2802000.00, 4868900.00, NULL, NULL),
(13388, '13388', '8-91-000006-00-06-1', 'JAMUNA ELECTRONICS&AUTOMOBILES', 'Sinabaho, Kaliakair, Gazipur,,.', 6720.00, 308194.83, 154097.42, 2.0183, 0.95, 26, 12, 4268500.00, 0.00, NULL, NULL),
(13389, '13389', '8-91-000007-00-06-3', 'APEX FASHION WEAR LTD', 'KALAMPUR, CHANDRA,KALIAKAIR,GAZIPUR.', 83880.00, 1185707.26, 711424.36, 2.0183, 0.80, 26, 24, 9912550.00, 19825100.00, NULL, NULL),
(13390, '13390', '8-91-000034-00-06-0', 'LOGOS APPARELS LTD (DYEING UN)', 'Zogirchala, Mouchak, Kaliakair, Gazipur,,.', 1049.98, 371275.64, 222765.38, 2.0183, 0.85, 26, 16, 5532500.00, 11065000.00, NULL, NULL),
(13391, '13391', '8-91-000055-00-06-4', 'RAHAMAT SPINNING MILLS. LTD.', 'JUGIRCHALA, MOUCHAK, KALIAKAIR, GAZIPUR.,,.', 1401.68, 958750.89, 575250.53, 2.0183, 0.95, 30, 24, 9223250.00, 19214300.00, NULL, NULL),
(13392, '13392', '8-91-000055-00-06-4', 'RAHAMAT SPINNING MILLS. LTD.', 'JUGIRCHALA, MOUCHAK, KALIAKAIR, GAZIPUR.,,.', 1401.68, 958750.89, 575250.53, 2.0183, 0.95, 30, 24, 9223250.00, 19214300.00, NULL, NULL),
(13393, '13393', '8-91-000055-01-06-6', 'RAHAMAT SPINNING MILLS LTD.', 'JUGIRCHALA, MOUCHAK, KALIAKOIR, GAZIPUR.,,.', 350.00, 39899.53, 0.00, 2.0183, 0.95, 15, 8, 383900.00, 0.00, NULL, NULL),
(13394, '13394', '8-91-000057-00-06-8', 'TROPICAL KNITEX LTD', 'CHANDRA,KALIAKOIR,GAZIPUR.,,.', 1249.99, 624000.00, 374400.00, 1.0000, 0.80, 26, 24, 9299000.00, 0.00, NULL, NULL),
(13395, '13395', '9-01-000160-00-11-1', 'THE CAPITAL FANS COMPANY', '4203, MATUAIL, SOUTHPARA,DEMRA, DHAKA.,.', 18.41, 6508.34, 3905.00, 1.6789, 0.85, 26, 16, 665550.00, 0.00, NULL, NULL),
(13396, '13396', '9-06-000036-00-03-1', 'KHAZA LIMES', 'ATTI SHARULIA,DEMRA, DHAKA.,.', 70.80, 29053.00, 21789.75, 1.5431, 0.85, 25, 12, 183312.00, 0.00, NULL, NULL),
(13397, '13397', '9-06-000055-00-03-1', 'SURMA LIMES', 'NAYA ATI, SARULIA,,SIDDIRGONJ,,NARAYANGONJ..', 195.38, 90033.89, 54020.33, 2.0183, 0.80, 24, 24, 341700.00, 0.00, NULL, NULL),
(13398, '13398', '9-06-000057-00-03-5', 'JAMUNA LIMES', 'MIJIMIJI,SIDDIRGONJ,NARAYANGONJ.', 237.86, 109606.48, 65763.89, 1.5431, 0.80, 24, 24, 1926900.00, 0.00, NULL, NULL),
(13399, '13399', '9-06-000061-00-03-4', 'BHAI BHAI LIMES INDUSTRY', 'VILLAGE-MIJMIJI,SIDDIRGONJ,,NARAYANGONJ..', 260.80, 120175.67, 72105.40, 2.0183, 0.80, 24, 24, 704250.00, 0.00, NULL, NULL),
(13400, '13400', '9-06-000065-00-03-2', 'MEGHNA LIMES', 'ATI, SIDDIRGONJ,NARAYANGONJ,.', 178.39, 82204.86, 49322.92, 2.0183, 0.80, 24, 24, 585250.00, 0.00, NULL, NULL),
(13401, '13401', '9-06-000073-00-03-9', 'ZAZIRA LIMES', 'PAINADI, SIDDERGONJ,,NARAYANGONJ.,.', 178.39, 82204.86, 49322.91, 2.0183, 0.80, 24, 24, 444378.00, 0.00, NULL, NULL),
(13402, '13402', '9-06-000083-00-03-0', 'ARAFAT LIMES', 'NAYA ATI,SIDDIRGONJ,NARAYANGONJ.', 141.58, 65241.95, 39145.17, 2.0183, 0.80, 24, 24, 98710.00, 121617.60, NULL, NULL),
(13403, '13403', '9-06-000100-00-03-8', 'RONY LIMES', 'NAYA ATI SARULIA,SHIDHERGONJ,NARAYANGONJ.', 203.88, 93948.41, 56369.04, 2.0183, 0.80, 24, 24, 148060.00, 134270.00, NULL, NULL),
(13404, '13404', '9-06-000101-00-03-0', 'DHAKA LIMES', 'PAINADI, SARULIA,,DEMRA,DHAKA..', 144.41, 66546.79, 39928.07, 1.6789, 0.80, 24, 24, 1170000.00, 0.00, NULL, NULL),
(13405, '13405', '9-06-000138-00-03-7', 'HAROON LIMES', 'ATI, SARULIA,,SHIDHIR GONJ,,NARAYANGONJ..', 207.27, 95514.21, 57308.52, 2.0183, 0.80, 24, 24, 244684.00, 0.00, NULL, NULL),
(13406, '13406', '9-06-000140-00-03-2', 'RAHMAN LIMES', 'WAPDA COLONY ROAD,ATI, MIZMIZI, SIDDIRGONJ,NARAYANGONJ..', 186.89, 86119.37, 51671.62, 2.0183, 0.80, 24, 24, 444245.00, 0.00, NULL, NULL),
(13407, '13407', '9-06-000167-00-03-8', 'FAYSHAL LIMES', 'NAYA ATI, SIDDIRGONJ,,NARAYANGONJ.,.', 191.13, 88076.64, 52845.98, 2.0183, 0.80, 24, 24, 0.00, 0.00, NULL, NULL),
(13408, '13408', '9-06-000169-00-03-2', 'MADINA LIMES', 'NAYA ATI, SIDDIRGONJ,,NARAYANGONJ.,.', 178.39, 82204.86, 49322.91, 2.0183, 0.80, 24, 24, 183190.00, 167760.00, NULL, NULL),
(13409, '13409', '9-06-000238-00-03-9', 'ASHRAF ALI LIMES', 'ATI, SIDDIRGONJ,,NARAYANGONJ.,.', 178.39, 82204.86, 49322.92, 2.0183, 0.80, 24, 24, 554100.00, 0.00, NULL, NULL),
(13410, '13410', '9-06-000278-00-03-3', 'SHARIF LIMES', 'SIDDIRGONJ,NARAYANGONJ,.', 195.38, 90033.89, 54020.33, 2.0183, 0.80, 24, 24, 148060.00, 300000.00, NULL, NULL),
(13411, '13411', '9-07-000088-00-11-9', 'RETA MOLDING WORKS', '951, NEW ALI BAHAR, FARIDABAD,SHAMPUR,DHAKA.', 22.65, 6000.70, 3003.85, 1.6789, 0.85, 26, 12, 306900.00, 0.00, NULL, NULL),
(13412, '13412', '9-32-000114-00-06-8', 'FARID & CO.', 'MOUCHAK, KALIAKOIR,GAZIPUR.,.', 87.78, 40450.01, 24270.01, 2.0183, 0.80, 24, 24, 344100.00, 367050.00, NULL, NULL),
(13413, '13413', '9-38-000376-00-37-9', 'HABIB FOOD PRODUCTS', 'JINIRA,KALMA,SAVAR.', 23.96, 5980.00, 2990.00, 1.2037, 0.80, 26, 12, 169950.00, 0.00, NULL, NULL),
(13414, '13414', '9-41-000050-00-27-5', 'M/S A SIX LTD.', 'DAG NO-1004,UTTAR KHAN,BALUR MUD,DHAKA-1230..', 27.18, 6785.16, 3392.58, 1.3394, 0.80, 26, 12, 936400.00, 0.00, NULL, NULL),
(13415, '13415', '9-77-000013-00-90-5', 'TUNNI MUNNI CHANACHUR KARKHANA', '1008 CHAR SALAKIA,KISHOREGONJ,.', 21.95, 5478.72, 2739.36, 1.2716, 0.80, 26, 12, 148522.24, 0.00, NULL, NULL),
(13416, '13416', '9-77-000035-00-90-1', 'ASIA BREAD & BISCUIT FACTORY', 'A-34/35, BISIC COMMERCIAL AREA,MARIA, KISHORGONJ.,.', 26.78, 6684.29, 3342.14, 1.2037, 0.80, 26, 12, 408060.00, 0.00, NULL, NULL),
(13417, '13417', '9-77-000042-00-90-6', 'HASNARA BREAD & BISCUIT FACT.', '2030, BATTRISH,PASHU HOSPITAL ROAD,KISHORGONJ.', 11.98, 2990.00, 1495.10, 1.2037, 0.80, 26, 12, 73825.00, 0.00, NULL, NULL),
(13418, '13418', '9-77-000044-00-90-0', 'MRS. SABBIR BREAD & BIS. FAC.', 'PLOT# A-61, BISIC I/A, KISHORGONJ,MARIA, KISHORGONJ.,.', 11.77, 2937.79, 1468.90, 1.2037, 0.80, 26, 12, 145250.00, 0.00, NULL, NULL),
(13419, '13419', '9-77-000058-00-90-9', 'ISLAM FOOD PRODUCTS', 'PLOT-62,63,,BISIC SHILPI NAGARI,KISHORGONJ..', 24.38, 6085.25, 3042.63, 1.2037, 0.80, 26, 12, 344350.00, 0.00, NULL, NULL),
(13420, '13420', '9-77-000061-00-90-6', 'M.M KHAN FOODS', 'PLOT-17,18,19 BSCIC I/A,MARIA,KISHORGONJ.', 22.68, 7547.90, 4528.74, 1.2037, 0.80, 26, 16, 428950.00, 0.00, NULL, NULL),
(13421, '13421', '9-77-000074-00-90-3', 'MUNMUN BAKERY', 'PLOT-M-2, BISIC S/N,MARIYA,KISHORGONJ.', 8.50, 2121.60, 1060.80, 1.2037, 0.80, 26, 12, 104750.00, 0.00, NULL, NULL),
(13422, '13422', '9-77-000091-00-90-9', 'M/S. NEW SRABON AGRO FOODS LTD', 'PLOT NO-30,31,32,33,BISIC,SILPA NAGAR, KISHOREGONJ.,.', 6.79, 1697.00, 848.00, 1.2037, 0.80, 26, 12, 83800.00, 0.00, NULL, NULL);

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

--
-- Table structure for table `diagrams`
--

CREATE TABLE `diagrams` (
  `id` bigint UNSIGNED NOT NULL,
  `station_id` bigint UNSIGNED NOT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kind` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `diagrams`
--

INSERT INTO `diagrams` (`id`, `station_id`, `link`, `kind`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 15, 'pfd_vst0080_shiddhirganjegcbrms.pdf', 'pfd', 6, '2022-12-22 02:52:00', '2022-12-22 02:52:00'),
(2, 1, 'pfd_vst4240_aminbazardrs.pdf', 'pfd', 6, '2022-12-22 01:57:14', '2022-12-22 01:57:14'),
(3, 2, 'pfd_vst5020_demradrs.pdf', 'pfd', 6, '2022-12-22 02:43:22', '2022-12-22 02:43:22'),
(4, 16, 'pfd_vst4020_dhonuatbs.pdf', 'pfd', 6, '2022-12-22 03:07:35', '2022-12-22 03:07:35'),
(5, 7, 'pfd_vst7390_haripurundergroundvs.pdf', 'pfd', 6, '2022-12-22 03:26:26', '2022-12-22 03:26:26'),
(6, 17, 'pfd_vst4090_tongidrs.pdf', 'pfd', 6, '2022-12-25 16:35:33', '2022-12-25 16:35:33'),
(7, 3, 'pfd_vst0030_citycentraldrs.pdf', 'pfd', 6, '2022-12-22 02:35:36', '2022-12-22 02:35:36'),
(8, 4, 'pfd_vst0060_demracgs.pdf', 'pfd', 6, '2022-12-22 02:47:46', '2022-12-22 02:47:46'),
(9, 5, 'pfd_vst1280_horipuregcb412rms.pdf', 'pfd', 6, '2022-12-22 03:00:25', '2022-12-22 03:00:25'),
(10, 18, 'pfd_vst0020_tejgoantbs.pdf', 'pfd', 6, '2022-12-25 20:55:37', '2022-12-25 20:55:37'),
(11, 6, 'pfd_vst1100_horipurtbsdrs.pdf', 'pfd', 6, '2022-12-22 03:33:31', '2022-12-22 03:33:31'),
(12, 10, 'pfd_vst6070_hazaribagdrs.pdf', 'pfd', 6, '2022-12-22 02:38:00', '2022-12-22 02:38:00'),
(13, 11, 'pfd_vst0050_doniatbs.pdf', 'pfd', 6, '2022-12-22 02:40:48', '2022-12-22 02:40:48'),
(14, 12, 'pfd_vst1030_sonargaontbs.pdf', 'pfd', 6, '2022-12-22 03:36:15', '2022-12-22 03:36:15'),
(15, 13, 'pfd_vst3070_monohordidrs.pdf', 'pfd', 6, '2022-12-22 03:03:33', '2022-12-22 03:03:33'),
(16, 22, 'pfd_vst0070_nondiparadrs.pdf', 'pfd', 6, '2022-12-28 00:18:34', '2022-12-28 00:18:34'),
(17, 92, 'pfd_vst7400_joydebpurnewcgs.pdf', 'pfd', 6, '2022-12-28 00:19:46', '2022-12-28 00:19:46'),
(18, 101, 'pfd_vst1090_gazariatbs&drs.pdf', 'pfd', 6, '2022-12-28 00:20:54', '2022-12-28 00:20:54'),
(20, 176, 'pfd_vst7410_dighiborabougvs.pdf', 'pfd', 6, '2022-12-28 00:33:52', '2022-12-28 00:33:52'),
(21, 167, 'pfd_vst7190_cityeconomiczonedrs.pdf', 'pfd', 6, '2022-12-28 00:34:23', '2022-12-28 00:34:23'),
(22, 173, 'pfd_vst7350_kanchpurbscicdrs.pdf', 'pfd', 6, '2022-12-28 00:34:49', '2022-12-28 00:34:49'),
(23, 99, 'pfd_vst1070_lakkhankholadrs.pdf', 'pfd', 6, '2022-12-28 00:35:11', '2022-12-28 00:35:11'),
(24, 38, 'pfd_vst4030_ashuliatbs.pdf', 'pfd', 6, '2022-12-28 00:35:27', '2022-12-28 00:35:27'),
(25, 39, 'pfd_vst4040_tongitbs.pdf', 'pfd', 6, '2022-12-28 00:35:48', '2022-12-28 00:35:48'),
(26, 116, 'pfd_vst1250_meghnaghat450mwpprms.pdf', 'pfd', 6, '2022-12-28 00:36:14', '2022-12-28 00:36:14'),
(27, 117, 'pfd_vst1260_summit335mwpprms.pdf', 'pfd', 6, '2022-12-28 00:36:39', '2022-12-28 00:36:39'),
(28, 102, 'pfd_vst1110_meghnaghattbs.pdf', 'pfd', 6, '2022-12-28 00:37:00', '2022-12-28 00:37:00'),
(29, 58, 'pfd_vst4260_dhamraidrs.pdf', 'pfd', 6, '2022-12-28 00:37:24', '2022-12-28 00:37:24'),
(30, 57, 'pfd_vst4250_savardrs.pdf', 'pfd', 6, '2022-12-28 00:37:50', '2022-12-28 00:37:50'),
(31, 161, 'pfd_vst7070_narsingdivs-12.pdf', 'pfd', 6, '2022-12-28 00:39:43', '2022-12-28 00:39:43'),
(32, 95, 'pfd_vst1020_dighiborabocgs.pdf', 'pfd', 6, '2022-12-28 00:40:04', '2022-12-28 00:40:04'),
(33, 65, 'pfd_vst4330_zirabodrs.pdf', 'pfd', 6, '2022-12-28 00:40:27', '2022-12-28 00:40:27'),
(34, 98, 'pfd_vst1060_araihajardrs.pdf', 'pfd', 6, '2022-12-28 00:40:44', '2022-12-28 00:40:44'),
(35, 19, 'pfd_vst3040_narshingditbs&drs.pdf', 'pfd', 6, '2022-12-28 00:41:08', '2022-12-28 00:41:08'),
(36, 100, 'pfd_vst1080_bhultatbs&drs.pdf', 'pfd', 6, '2022-12-28 00:41:53', '2022-12-28 00:41:53'),
(37, 66, 'pfd_vst4340_depzdrs.pdf', 'pfd', 6, '2022-12-28 00:42:17', '2022-12-28 00:42:17'),
(38, 130, 'pfd_vst3060_shibpurdrs.pdf', 'pfd', 6, '2022-12-28 00:42:57', '2022-12-28 00:42:57'),
(39, 142, 'pfd_vst3320_summit10mwpprms.pdf', 'pfd', 6, '2022-12-28 00:44:17', '2022-12-28 00:44:17'),
(40, 128, 'pfd_vst3030_madhobditbs&drs.pdf', 'pfd', 6, '2022-12-28 00:46:33', '2022-12-28 00:46:33'),
(41, 141, 'pfd_vst3310_summit27mwpprms.pdf', 'pfd', 6, '2022-12-28 00:46:51', '2022-12-28 00:46:51'),
(42, 132, 'pfd_vst3110_gpsunit-1&2rms.pdf', 'pfd', 6, '2022-12-28 00:47:11', '2022-12-28 00:47:11'),
(43, 133, 'pfd_vst3120_gpsunit-3rms.pdf', 'pfd', 6, '2022-12-28 00:47:27', '2022-12-28 00:47:27'),
(44, 134, 'pfd_vst3130_gpsunit-4rms.pdf', 'pfd', 6, '2022-12-28 00:47:42', '2022-12-28 00:47:42'),
(45, 135, 'pfd_vst3145_gpsunit-5rms.pdf', 'pfd', 6, '2022-12-28 00:48:13', '2022-12-28 00:48:13'),
(46, 136, 'pfd_vst3150_gpsunit-7rms.pdf', 'pfd', 6, '2022-12-28 00:48:34', '2022-12-28 00:48:34'),
(47, 138, 'pfd_vst3170_regentpowerrms.pdf', 'pfd', 6, '2022-12-28 00:48:50', '2022-12-28 00:48:50'),
(48, 139, 'pfd_vst3180_capitalpaperdrs.pdf', 'pfd', 6, '2022-12-28 00:49:09', '2022-12-28 00:49:09'),
(49, 140, 'pfd_vst3190_deshbondhudrs.pdf', 'pfd', 6, '2022-12-28 00:49:32', '2022-12-28 00:49:32'),
(50, 131, 'pfd_vst3100_ghorashaldrs.pdf', 'pfd', 6, '2022-12-28 00:49:47', '2022-12-28 00:49:47'),
(51, 168, 'pfd_vst7200_narsingdivs-11.pdf', 'pfd', 6, '2022-12-28 00:50:34', '2022-12-28 00:50:34'),
(52, 170, 'pfd_vst7220_khatihatavs.pdf', 'pfd', 6, '2022-12-28 00:50:53', '2022-12-28 00:50:53'),
(53, 160, 'pfd_vst7060_ashugonjvs-3.pdf', 'pfd', 6, '2022-12-28 00:51:11', '2022-12-28 00:51:11'),
(54, 124, 'pfd_vst2010_b.bariadrs.pdf', 'pfd', 6, '2022-12-28 00:51:26', '2022-12-28 00:51:26'),
(55, 163, 'pfd_vst7110_ghaturaintake.pdf', 'pfd', 6, '2022-12-28 00:51:44', '2022-12-28 00:51:44'),
(56, 126, 'pfd_vst3010_gpsrms.pdf', 'pfd', 6, '2022-12-28 00:52:04', '2022-12-28 00:52:04'),
(57, 41, 'pfd_vst4070_elengatbs.pdf', 'pfd', 6, '2022-12-28 00:52:20', '2022-12-28 00:52:20'),
(58, 169, 'pfd_vst7210_shahjibazarims.pdf', 'pfd', 6, '2022-12-28 00:52:35', '2022-12-28 00:52:35'),
(59, 94, 'pfd_vst1010_tarabotbs&drs.pdf', 'pfd', 6, '2022-12-28 00:53:10', '2022-12-28 00:53:10'),
(60, 147, 'pfd_vst5070_kadamtolitbs.pdf', 'pfd', 6, '2022-12-28 00:53:29', '2022-12-28 00:53:29'),
(61, 46, 'pfd_vst4130_gararanvs.pdf', 'pfd', 6, '2022-12-28 00:53:44', '2022-12-28 00:53:44'),
(62, 28, 'pfd_vst6120_agargaondrs.pdf', 'pfd', 6, '2022-12-28 00:54:00', '2022-12-28 00:54:00'),
(63, 29, 'pfd_vst6130_mirpur-10drs.pdf', 'pfd', 6, '2022-12-28 00:54:51', '2022-12-28 00:54:51'),
(64, 30, 'pfd_vst6140_mirpurmazarroaddrs.pdf', 'pfd', 6, '2022-12-28 00:55:18', '2022-12-28 00:55:18'),
(65, 27, 'pfd_vst6110_dhakacantonmentdrs.pdf', 'pfd', 6, '2022-12-28 00:55:38', '2022-12-28 00:55:38'),
(66, 31, 'pfd_vst6150_mirpurcantonmentdrs.pdf', 'pfd', 6, '2022-12-28 00:55:56', '2022-12-28 00:55:56'),
(67, 33, 'pfd_vst7280_mirpurdohsdrs.pdf', 'pfd', 6, '2022-12-28 00:56:17', '2022-12-28 00:56:17'),
(68, 35, 'pfd_vst7300_kamarparadrs.pdf', 'pfd', 6, '2022-12-28 00:57:14', '2022-12-28 00:57:14'),
(69, 26, 'pfd_vst6090_baridharadohsdrs.pdf', 'pfd', 6, '2022-12-28 00:57:43', '2022-12-28 00:57:43'),
(70, 20, 'pfd_vst0010_gulshandrs.pdf', 'pfd', 6, '2022-12-28 00:58:04', '2022-12-28 00:58:04'),
(71, 21, 'pfd_vst0040_postogoladrs.pdf', 'pfd', 6, '2022-12-28 00:58:26', '2022-12-28 00:58:26'),
(72, 23, 'pfd_vst6050_zinziradrs.pdf', 'pfd', 6, '2022-12-28 00:58:41', '2022-12-28 00:58:41'),
(73, 25, 'pfd_vst6080_joarshaharadrs.pdf', 'pfd', 6, '2022-12-29 21:33:52', '2022-12-29 21:33:52'),
(74, 32, 'pfd_vst6160_uttaradrs.pdf', 'pfd', 6, '2022-12-29 21:34:20', '2022-12-29 21:34:20'),
(75, 14, 'pfd_vst5060_shiddhirgonjcgs.pdf', 'pfd', 6, '2022-12-29 21:42:18', '2022-12-29 21:42:18'),
(76, 149, 'EnLHUQja3e1iDfVz9HSQNIbLoWlSb99EXbkOY5Uu.pdf', 'pfd', 6, '2022-12-29 21:43:14', '2023-12-12 02:12:53'),
(77, 150, 'pfd_vst5100_godnaildrs.pdf', 'pfd', 6, '2022-12-29 21:44:25', '2022-12-29 21:44:25'),
(78, 174, 'pfd_vst7360_adamjeedrs.pdf', 'pfd', 6, '2022-12-29 21:44:53', '2022-12-29 21:44:53'),
(79, 73, 'pfd_vst6220_elengacgs(proposed)elenga-manikgonj-dhamraiproject.pdf', 'pfd', 6, '2022-12-29 22:28:42', '2022-12-29 22:28:42'),
(80, 12, 'layout_vst1030_sonargaontbs.pdf', 'layout', 6, '2022-12-29 23:08:05', '2022-12-29 23:08:05'),
(81, 62, 'layout_vst4300_manikganjdrs.pdf', 'layout', 6, '2023-01-01 18:16:56', '2023-01-01 18:16:56'),
(82, 173, 'layout_vst7350_kanchpurbscicdrs.pdf', 'layout', 6, '2023-01-04 03:05:33', '2023-01-04 03:05:33'),
(83, 96, 'layout_vst1040_kanchandrs.pdf', 'layout', 6, '2023-01-04 03:05:58', '2023-01-04 03:05:58'),
(84, 100, 'layout_vst1080_bhultatbs&drs.pdf', 'layout', 6, '2023-01-04 03:06:19', '2023-01-04 03:06:19'),
(85, 99, 'layout_vst1070_lakkhankholadrs.pdf', 'layout', 6, '2023-01-04 03:06:36', '2023-01-04 03:06:36'),
(86, 116, 'layout_vst1250_meghnaghat450mwpprms.pdf', 'layout', 6, '2023-01-04 03:07:01', '2023-01-04 03:07:01'),
(87, 147, 'layout_vst5070_kadamtolitbs.pdf', 'layout', 6, '2023-01-04 03:07:42', '2023-01-04 03:07:42'),
(88, 10, 'layout_vst6070_hazaribagdrs.pdf', 'layout', 6, '2023-01-04 03:08:47', '2023-01-04 03:08:47'),
(89, 43, 'layout_vst4100_kaliganjdrs.pdf', 'layout', 6, '2023-01-04 03:10:03', '2023-01-04 03:10:03'),
(91, 89, 'layout_vst7320_tongi80mwpprms.pdf', 'layout', 6, '2023-01-04 03:11:00', '2023-01-04 03:11:00'),
(92, 32, 'layout_vst6160_uttaradrs.pdf', 'layout', 6, '2023-01-24 01:09:24', '2023-01-24 01:09:24'),
(93, 101, 'layout_vst1090_gazariatbs&drs.pdf', 'layout', 6, '2023-01-24 01:48:08', '2023-01-24 01:48:08'),
(94, 155, 'layout_vst5150_munshigonjdrs.pdf', 'layout', 6, '2023-01-24 01:57:03', '2023-01-24 01:57:03'),
(95, 154, 'layout_vst5140_muktarpurdrs.pdf', 'layout', 6, '2023-01-24 01:59:20', '2023-01-24 01:59:20'),
(96, 131, 'layout_vst3100_ghorashaldrs.pdf', 'layout', 6, '2023-01-24 02:12:16', '2023-01-24 02:12:16'),
(97, 151, 'layout_vst5110_pagladrs.pdf', 'layout', 6, '2023-01-24 03:21:11', '2023-01-24 03:21:11'),
(98, 152, 'layout_vst5120_fatulladrs.pdf', 'layout', 6, '2023-01-24 03:35:10', '2023-01-24 03:35:10'),
(99, 157, 'layout_vst6020_dholessordrs(proposed).pdf', 'layout', 6, '2023-01-24 03:39:39', '2023-01-24 03:39:39'),
(100, 98, 'layout_vst1060_araihajardrs.pdf', 'layout', 6, '2023-01-24 03:48:18', '2023-01-24 03:48:18'),
(101, 2, 'layout_vst5020_demradrs.pdf', 'layout', 6, '2023-01-24 03:59:18', '2023-01-24 03:59:18'),
(102, 14, 'layout_vst5060_shiddhirgonjcgs.pdf', 'layout', 6, '2023-01-24 04:02:19', '2023-01-24 04:02:19'),
(103, 150, 'layout_vst5100_godnaildrs.pdf', 'layout', 6, '2023-01-24 04:11:14', '2023-01-24 04:11:14'),
(104, 149, 'layout/lyducv2eyGfMI7ZpUeVySjBxRzko9vBDH2c3gV6T.pdf', 'layout', 6, '2023-01-24 04:23:21', '2023-12-12 02:15:18'),
(105, 153, 'layout_vst5130_ponchobotidrs.pdf', 'layout', 6, '2023-01-28 16:08:43', '2023-01-28 16:08:43'),
(106, 21, 'layout_vst0040_postogoladrs.pdf', 'layout', 6, '2023-01-28 16:11:22', '2023-01-28 16:11:22'),
(107, 11, 'layout_vst0050_doniatbs&drs.pdf', 'layout', 6, '2023-01-28 16:13:35', '2023-01-28 16:13:35'),
(108, 3, 'layout_vst0030_citycentraldrs.pdf', 'layout', 6, '2023-01-28 16:15:19', '2023-01-28 16:15:19'),
(109, 159, 'layout_vst6040_pangaonvalvestation.pdf', 'layout', 6, '2023-01-28 16:22:46', '2023-01-28 16:22:46'),
(110, 30, 'layout_vst6140_mirpurmazarroaddrs.pdf', 'layout', 6, '2023-02-07 15:33:48', '2023-02-07 15:33:48'),
(111, 23, 'layout_vst6050_zinziradrs.pdf', 'layout', 6, '2023-02-07 15:42:50', '2023-02-07 15:42:50'),
(112, 18, 'layout_vst0020_tejgoantbs.pdf', 'layout', 6, '2023-02-07 15:49:13', '2023-02-07 15:49:13'),
(113, 20, 'layout_vst0010_gulshandrs.pdf', 'layout', 6, '2023-02-07 16:06:17', '2023-02-07 16:06:17'),
(114, 25, 'layout_vst6080_joarshaharadrs.pdf', 'layout', 6, '2023-02-07 16:07:55', '2023-02-07 16:07:55'),
(115, 26, 'layout_vst6090_baridharadohsdrs.pdf', 'layout', 6, '2023-02-07 16:08:25', '2023-02-07 16:08:25'),
(116, 27, 'layout_vst6110_dhakacantonmentdrs.pdf', 'layout', 6, '2023-02-07 16:10:32', '2023-02-07 16:10:32'),
(117, 28, 'layout_vst6120_agargaondrs.pdf', 'layout', 6, '2023-02-07 16:10:54', '2023-02-07 16:10:54'),
(118, 29, 'layout_vst6130_mirpur-10drs.pdf', 'layout', 6, '2023-02-07 16:11:17', '2023-02-07 16:11:17'),
(119, 31, 'layout_vst6150_mirpurcantonmentdrs.pdf', 'layout', 6, '2023-02-07 16:11:35', '2023-02-07 16:11:35'),
(120, 38, 'layout_vst4030_ashuliatbs.pdf', 'layout', 6, '2023-02-07 16:13:17', '2023-02-07 16:13:17'),
(121, 39, 'layout_vst4040_tongitbs.pdf', 'layout', 6, '2023-02-07 16:13:41', '2023-02-07 16:13:41'),
(122, 61, 'layout_vst4290_manikganjbscicdrs.pdf', 'layout', 6, '2023-02-07 16:14:41', '2023-02-07 16:14:41'),
(123, 37, 'layout_vst4010_joydebpurcgs.pdf', 'layout', 6, '2023-02-07 16:15:58', '2023-02-07 16:15:58'),
(124, 1, 'layout_vst4240_aminbazardrs.pdf', 'layout', 6, '2023-02-07 16:16:25', '2023-02-07 16:16:25'),
(125, 57, 'layout_vst4250_savardrs.pdf', 'layout', 6, '2023-02-07 16:16:45', '2023-02-07 16:16:45'),
(126, 59, 'layout_vst4270_kalampurdrs.pdf', 'layout', 6, '2023-02-07 16:17:05', '2023-02-07 16:17:05'),
(127, 60, 'layout_vst4280_akijdrs.pdf', 'layout', 6, '2023-02-07 16:17:27', '2023-02-07 16:17:27'),
(128, 58, 'layout_vst4260_dhamraidrs.pdf', 'layout', 6, '2023-02-07 16:18:00', '2023-02-07 16:18:00'),
(129, 63, 'layout_vst4310_munnudrs.pdf', 'layout', 6, '2023-02-07 17:26:41', '2023-02-07 17:26:41'),
(130, 64, 'pfd_vst4320_tepradrs.pdf', 'pfd', 6, '2023-02-07 17:27:20', '2023-04-01 19:19:48'),
(131, 66, 'layout_vst4340_depzdrs.pdf', 'layout', 6, '2023-02-07 17:28:39', '2023-02-07 17:28:39'),
(132, 65, 'layout_vst4330_zirabodrs.pdf', 'layout', 6, '2023-02-07 17:31:54', '2023-02-07 17:31:54'),
(133, 51, 'layout_vst4180_konabaridrs.pdf', 'layout', 6, '2023-02-07 17:32:14', '2023-02-07 17:32:14'),
(134, 177, 'layout_vst4185_konabaribscic.pdf', 'layout', 6, '2023-02-07 17:36:12', '2023-02-07 17:36:12'),
(135, 52, 'layout_vst4190_chandradrs.pdf', 'layout', 6, '2023-02-07 17:36:34', '2023-02-07 17:36:34'),
(136, 67, 'layout_vst4350_beximcodrs.pdf', 'layout', 6, '2023-02-07 17:36:51', '2023-02-07 17:36:51'),
(137, 54, 'layout/1N3UiiRnXnd3noNiORcA5MPXAQhnkdvdhYhlv5SJ.pdf', 'layout', 6, '2023-02-07 17:37:11', '2023-08-30 22:47:23'),
(138, 56, 'layout_vst4230_tangaildrs.pdf', 'layout', 6, '2023-02-07 17:37:49', '2023-02-07 17:37:49'),
(139, 42, 'layout_vst4080_gopalpurdrs.pdf', 'layout', 6, '2023-02-07 17:38:07', '2023-02-07 17:38:07'),
(140, 41, 'layout_vst4070_elengatbs.pdf', 'layout', 6, '2023-02-07 17:39:03', '2023-02-07 17:39:03'),
(141, 53, 'layout_vst4200_cadetcollegedrs.pdf', 'layout', 6, '2023-02-07 17:41:24', '2023-02-07 17:41:24'),
(142, 55, 'layout_vst4220_korotiadrs.pdf', 'layout', 6, '2023-02-07 17:41:37', '2023-02-07 17:41:37'),
(143, 16, 'layout_vst4020_dhonuatbs.pdf', 'layout', 6, '2023-02-07 17:42:11', '2023-02-07 17:42:11'),
(144, 71, 'layout/lOHmrzfizi0W38EUBGMBNu1mIKrxoRgsDDENeCj8.pdf', 'layout', 6, '2023-02-07 17:44:39', '2023-08-30 22:53:10'),
(145, 161, 'layout_vst7070_narsingdivs-12.pdf', 'layout', 6, '2023-02-07 17:45:57', '2023-02-07 17:45:57'),
(146, 176, 'layout_vst7410_dighiborabougvs.pdf', 'layout', 6, '2023-02-07 18:28:06', '2023-02-07 18:28:06'),
(147, 128, 'layout_vst3030_madhobditbs&drs.pdf', 'layout', 6, '2023-02-07 18:33:32', '2023-02-07 18:33:32'),
(148, 102, 'layout_vst1110_meghnaghattbs.pdf', 'layout', 6, '2023-02-07 18:35:37', '2023-02-07 18:35:37'),
(149, 19, 'layout_vst3040_narshingditbs&drs.pdf', 'layout', 6, '2023-02-07 18:47:54', '2023-02-07 18:47:54'),
(151, 86, 'layout_vst7170_valukam&r.pdf', 'layout', 6, '2023-02-07 18:54:56', '2023-02-07 18:54:56'),
(152, 159, 'pfd_vst6040_pangaonvs.pdf', 'pfd', 6, '2023-02-07 19:04:49', '2023-02-07 19:04:49'),
(153, 60, 'pfd_vst4280_akijdrs.pdf', 'pfd', 6, '2023-02-07 19:10:11', '2023-02-07 19:10:11'),
(154, 59, 'pfd_vst4270_kalampurdrs.pdf', 'pfd', 6, '2023-02-07 19:10:43', '2023-02-07 19:10:43'),
(155, 61, 'pfd_vst4290_manikganjbscicdrs.pdf', 'pfd', 6, '2023-02-07 19:11:21', '2023-02-07 19:11:21'),
(156, 62, 'pfd_vst4300_manikganjdrs.pdf', 'pfd', 6, '2023-02-07 19:11:48', '2023-02-07 19:11:48'),
(157, 63, 'pfd_vst4310_munnudrs.pdf', 'pfd', 6, '2023-02-07 19:12:16', '2023-02-07 19:12:16'),
(158, 179, 'pfd_vst4315_munnurms.pdf', 'pfd', 6, '2023-02-07 19:16:42', '2023-02-07 19:16:42'),
(159, 64, 'pfd_vst4320_tepradrs.pdf', 'pfd', 6, '2023-02-15 18:25:14', '2023-02-15 18:25:14'),
(160, 153, 'pfd_vst5130_ponchobotidrs.pdf', 'pfd', 6, '2023-02-22 20:32:02', '2023-02-22 20:32:02'),
(161, 180, 'pfd_vs-xabc_firingibazarmlv.pdf', 'pfd', 6, '2023-03-27 23:28:51', '2023-03-27 23:28:51'),
(162, 154, 'pfd_vst5140_muktarpurdrs.pdf', 'pfd', 6, '2023-03-27 23:33:44', '2023-03-27 23:33:44'),
(163, 155, 'pfd_vst5150_munshigonjdrs.pdf', 'pfd', 6, '2023-03-28 18:11:35', '2023-03-28 18:11:35'),
(164, 181, 'pfd_vst1410_kashipurdrs.pdf', 'pfd', 6, '2023-03-28 18:12:22', '2023-03-28 18:12:22'),
(165, 125, 'pfd_vst2020_bhairabdrs.pdf', 'pfd', 6, '2023-03-28 18:13:21', '2023-03-28 18:13:21'),
(166, 151, 'pfd_vst5110_pagladrs.pdf', 'pfd', 6, '2023-03-28 22:36:23', '2023-03-28 22:36:23'),
(167, 152, 'pfd_vst5120_fatulladrs.pdf', 'pfd', 6, '2023-03-28 22:36:54', '2023-03-28 22:36:54'),
(168, 67, 'pfd_vst4350_beximcodrs.pdf', 'pfd', 6, '2023-03-28 22:39:14', '2023-03-28 22:39:14'),
(169, 4, 'layout_vst0060_demracgs.pdf', 'layout', 6, '2023-03-28 22:41:52', '2023-03-28 22:41:52'),
(170, 64, 'layout_vst4320_tepradrs.pdf', 'layout', 6, '2023-04-01 19:20:28', '2023-04-01 19:20:28'),
(171, 7, 'layout_vst7390_horipurundergroundvs.pdf', 'layout', 6, '2023-04-24 17:19:57', '2023-04-24 17:19:57'),
(178, 224, 'CMjAAJnWJcDU1KKEcxyGvTapZOTJyRl3VCmkX2sD.pdf', 'pfd', 41, '2023-08-21 07:23:45', '2023-08-21 07:23:45'),
(179, 188, 'RwSa0EeODAjRkt4EnavcqW8dBOnUmxweJL71sp21.pdf', 'pfd', 41, '2023-08-21 07:30:19', '2023-08-21 07:30:19'),
(180, 178, 'T42EaVBGZILOY7wSSiCvyQ0Xn0EsaziTzcBNn833.pdf', 'pfd', 41, '2023-08-21 07:31:12', '2023-08-21 07:31:12'),
(181, 223, 'tqTMlA1t3DZ4NL6kGIwWG3uDAoiLjOBOfHUhYuhR.pdf', 'pfd', 41, '2023-08-21 07:31:51', '2023-08-21 07:31:51'),
(182, 222, 'DTtYBmH1LD7XRKdA3P1Kt3da4BR3c9boZRHsVxtv.pdf', 'pfd', 41, '2023-08-21 07:32:56', '2023-08-21 07:32:56'),
(183, 86, 'VGPa9D1j7n93lh2fFTM74vAXU43XiDNKibxTYnvD.pdf', 'pfd', 41, '2023-08-21 07:34:05', '2023-08-21 07:34:05'),
(184, 51, 'TuYFvcpMG09nqP9Me6HPVIoKNDE4QNjT8KnyPwwY.pdf', 'pfd', 6, '2023-08-30 04:26:15', '2023-08-30 04:26:15'),
(185, 52, 'gIRIWtto1Oh4Bs2GfWf4OAOVa4y5a5RVIRDlJjcM.pdf', 'pfd', 6, '2023-08-30 22:21:45', '2023-08-30 22:21:45'),
(186, 199, 'N90IaDe9LWI2Godt06M2MzM0OPoLOANzkAYWWdKF.pdf', 'pfd', 6, '2023-08-30 22:26:51', '2023-08-30 22:26:51'),
(187, 200, '6jIloBcIuGaZ1dgNxAtmbTAChIIteI5gsFDK1ZjX.pdf', 'pfd', 6, '2023-08-30 22:27:46', '2023-08-30 22:27:46'),
(188, 56, '3lTd3da0wxSiU81KEDBqrPBOQNwQ7bsG5vUFPzIq.pdf', 'pfd', 6, '2023-08-30 22:28:45', '2023-08-30 22:28:45'),
(189, 53, 'N3JDwk5Ox7Au2j5eSL9TlNTRzvyt9WGj4KX3ESZO.pdf', 'pfd', 6, '2023-08-30 22:30:22', '2023-08-30 22:30:22'),
(190, 54, 'HafSsHRcezbHVD5mgHkEdM63PNwaowp5ATdOwmDO.pdf', 'pfd', 6, '2023-08-30 22:31:36', '2023-08-30 22:31:36'),
(191, 55, '6kOme9xhea58Qu2T9yDfnTspqueat8YSbvZGR6OI.pdf', 'pfd', 6, '2023-08-30 22:32:13', '2023-08-30 22:32:13'),
(192, 22, 'layout/KrDk86qr1pGjcIB1cBivnMdKR1PV0FdWOJ9j9Aii.pdf', 'layout', 6, '2023-08-30 22:42:00', '2023-08-30 22:43:43'),
(193, 169, 'layout/LVY17WiDVuHEc7fhw4IPFUDNdU99iFIhdYH3WbuY.pdf', 'layout', 6, '2023-08-30 22:49:31', '2023-08-30 22:49:31'),
(194, 237, '5ODg4MZJVGltzIdZwbXUCKhBcLoVFyvuRCae0od7.pdf', 'pfd', 6, '2023-10-03 05:32:12', '2024-10-24 14:50:18'),
(195, 178, 'layout/y47ILVls9YDmnMiS1BRHGXxOiifaL4mmzltmTFtA.pdf', 'layout', 6, '2023-10-18 22:51:28', '2023-10-18 22:51:28'),
(196, 157, 'IUGecbs4Qdiu5GPGlZFhUPKqZoOK6gg5dQDJYp6X.pdf', 'pfd', 6, '2023-10-19 01:44:55', '2024-10-24 14:49:36'),
(197, 119, 'qIWDuVGd8Nsbda2UG0lAX6i0vGVIO0LfRuNOVS8p.pdf', 'pfd', 6, '2023-12-11 03:53:39', '2024-10-23 05:49:48'),
(198, 37, 'Vpvoe4BxT5G4VUuM4EVbTDCo2GLtskD9WDHj1On4.pdf', 'pfd', 6, '2024-06-05 17:27:11', '2024-06-05 17:27:11'),
(199, 183, 'T2Pt5pFCytaymKJxFN5EF5F70zy6KxZXYDCmfxrQ.pdf', 'pfd', 6, '2024-07-31 02:11:41', '2024-07-31 02:11:41'),
(200, 40, '8uR4QsUocMauPtf2rXSNdJcxbc96biHM4jpq11d9.pdf', 'pfd', 6, '2024-07-31 02:13:20', '2024-07-31 02:13:20'),
(201, 42, 'dO6gLSxFkZjXPQCiakztUECWnvKiUGk55hapv22q.pdf', 'pfd', 6, '2024-07-31 02:14:31', '2024-07-31 02:14:31'),
(204, 71, 'TPK9mIT5y1PwAhE5qs3B9zYVt7u7epeYy2cOR6ZC.pdf', 'pfd', 6, '2024-07-31 02:16:44', '2024-07-31 02:16:44'),
(205, 190, 'lRTXrDagF1xREWc1xUzTUl9788ENTb5aTehycB5c.pdf', 'pfd', 6, '2024-07-31 02:16:58', '2024-07-31 02:16:58'),
(206, 192, 'Xc8NWMu8ebrsh6ZmWRpGhc1yyEYnXUP6kH63ORJU.pdf', 'pfd', 6, '2024-07-31 02:17:20', '2024-07-31 02:17:20'),
(207, 193, 'tljL9J8bZoMNg3uZm574N6Em9rmoMHxrWWeHC7zG.pdf', 'pfd', 6, '2024-07-31 02:17:42', '2024-07-31 02:17:42'),
(208, 274, 'atyDfvHR1K1PEouEryy4eVjRY9qUgtRfSUodLu2t.pdf', 'pfd', 6, '2024-08-18 01:45:34', '2024-08-18 01:45:34'),
(209, 195, 'P3etJXisPgmoVsrSRPQxhT6nboAAQsQKc5WLvmhd.pdf', 'pfd', 6, '2024-08-18 01:47:16', '2024-08-18 01:47:16'),
(210, 300, 'kt47S3XKSqAOoCEqpTvTuIfF8khSN2uf8MtvVTbw.pdf', 'pfd', 6, '2024-08-18 01:50:07', '2024-08-18 01:50:07'),
(211, 78, 'T9u2iGevei8FmWD9LSC2jIp6nEQcJXAPPX5jF9Wg.pdf', 'pfd', 6, '2024-08-18 01:51:36', '2024-08-18 01:51:36'),
(212, 225, 'OtysuYx2CmSvDFs5Bhe2KKFZ0K1XxPWF3mQvSTy1.pdf', 'pfd', 6, '2024-08-18 01:53:06', '2024-08-18 01:53:06'),
(213, 77, '8kcOY0cj38it3d8E1wKqzIetLg72fOkDUaZdVM30.pdf', 'pfd', 6, '2024-08-18 01:53:18', '2024-08-18 01:53:18');

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

--
-- Table structure for table `documents`
--

CREATE TABLE `documents` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Information',
  `published_at` date DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `documents`
--

INSERT INTO `documents` (`id`, `user_id`, `type`, `published_at`, `name`, `link`, `created_at`, `updated_at`) VALUES
(1, 6, 'Manual', '2014-08-18', '20140818 Commercial Gas rules', 'documents/20140818 Commercial Gas rules.pdf', '2024-10-26 10:27:20', '2024-10-26 10:27:20'),
(2, 6, 'Manual', '2014-08-18', '20140818 Domestic Gas rules', 'documents/20140818 Domestic Gas rules.pdf', '2024-10-26 10:27:20', '2024-10-26 10:27:20'),
(3, 6, 'Manual', '2014-08-18', '20141223 EVC Installation Guide', 'documents/20141223 EVC Installation Guide.pdf', '2024-10-26 10:27:20', '2024-10-26 10:27:20');

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

--
-- Table structure for table `drawings`
--

CREATE TABLE `drawings` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'distribution',
  `division` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `department` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `section` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `area` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `physical_storage` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `coordinates` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `drawings`
--

INSERT INTO `drawings` (`id`, `user_id`, `type`, `division`, `department`, `section`, `area`, `drawing_no`, `physical_storage`, `coordinates`, `link`, `created_at`, `updated_at`) VALUES
(2, 6, 'keymap', 'Dhaka Metro South', 'MDMD-1', 'Zone-1 (Demra, Zatrabari)', 'Dhaka', 'AMFM & IWM', 'Digital', NULL, 'drawings/AMFM & IWM.pdf', '2024-10-26 19:45:39', '2024-10-26 19:45:39'),
(4, 6, 'distribution', 'Narayanganj', 'Narsingdi', 'Narsingdi', 'Monohordi', 'dn-phase-4-113-ka-2001-2002', 'A-3/2', NULL, 'drawings/dn-phase-4-113-ka-2001-2002.pdf', '2024-10-28 06:34:19', '2024-10-28 06:34:19'),
(5, 6, 'distribution', 'Narayanganj', 'Narsingdi', 'Narsingdi', 'Gopaldi', 'dn-phase-4-804-gha-2003-04', 'A-3/2', NULL, 'drawings/dn-phase-4-804-gha-2003-04.pdf', '2024-10-28 07:13:09', '2024-10-28 07:13:09');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `issues`
--

CREATE TABLE `issues` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `coordinates` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comments` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reply` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `line_colors`
--

CREATE TABLE `line_colors` (
  `id` bigint UNSIGNED NOT NULL,
  `dia` decimal(4,2) NOT NULL,
  `color` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `line_colors`
--

INSERT INTO `line_colors` (`id`, `dia`, `color`, `created_at`, `updated_at`) VALUES
(1, 16.00, '93c400', '2023-01-28 19:43:44', '2023-01-28 19:43:44'),
(2, 14.00, 'cf5157', '2023-01-28 19:44:33', '2023-01-28 19:44:33'),
(3, 12.00, '2c7822', '2023-01-29 02:44:20', '2023-01-29 02:44:20'),
(4, 10.00, '8d9e0e', '2023-01-29 02:45:28', '2023-01-29 02:45:28'),
(5, 8.00, '3d32d4', '2023-01-29 02:45:43', '2023-01-29 02:45:43'),
(6, 6.00, '1dff1b', '2023-01-29 02:45:54', '2023-01-29 02:45:54'),
(7, 4.00, 'c128c0', '2023-01-29 02:46:05', '2023-01-29 02:46:05'),
(8, 3.00, 'd9933d', '2023-01-29 02:46:15', '2023-01-29 02:46:15'),
(9, 2.00, '7e76bf', '2023-01-29 02:46:31', '2023-01-29 02:46:31'),
(10, 1.00, 'ce2f32', '2023-01-29 02:46:44', '2023-03-06 20:11:45'),
(11, 0.75, '5eba3a', '2023-01-29 02:47:06', '2023-01-29 02:47:06'),
(12, 0.50, 'f57be0', '2023-01-29 02:47:21', '2023-01-29 05:02:43'),
(13, 18.00, 'dee037', '2023-01-29 02:47:39', '2023-01-29 02:47:39'),
(14, 20.00, 'f2c93a', '2023-01-29 02:47:54', '2023-01-29 02:47:54'),
(15, 22.00, 'fdaf35', '2023-01-29 02:48:11', '2023-01-29 02:48:11'),
(16, 24.00, 'fe8f29', '2023-01-29 02:48:26', '2023-01-29 02:48:26'),
(17, 30.00, 'f66d19', '2023-01-29 02:48:39', '2023-01-29 02:48:39'),
(18, 36.00, 'e94d0d', '2023-01-29 02:48:54', '2023-01-29 02:48:54'),
(19, 40.00, 'd63506', '2023-01-29 02:49:08', '2023-01-29 02:49:08'),
(20, 42.00, 'bd2002', '2023-01-29 02:49:20', '2023-01-29 02:49:20'),
(21, 46.00, '9d1001', '2023-01-29 02:49:33', '2023-01-29 05:06:58'),
(22, 32.00, 'fe00d3', '2023-01-29 14:35:14', '2023-01-29 14:36:28'),
(23, 50.00, '0000ff', '2023-01-29 16:12:24', '2023-01-29 16:12:36');

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

--
-- Table structure for table `login_histories`
--

CREATE TABLE `login_histories` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unknown',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2024_10_12_105755_create_options_table', 1),
(5, '2024_10_13_094210_create_line_colors_table', 1),
(6, '2024_10_13_094238_create_stations_table', 1),
(7, '2024_10_13_094303_create_cpstations_table', 1),
(8, '2024_10_13_100754_create_diagrams_table', 1),
(9, '2024_10_13_100823_create_issues_table', 1),
(10, '2024_10_13_100847_create_customer_infos_table', 1),
(12, '2024_10_25_085758_create_login_histories_table', 1),
(13, '2024_10_26_120147_create_documents_table', 1),
(14, '2024_10_26_120905_create_drawings_table', 1);

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

--
-- Table structure for table `options`
--

CREATE TABLE `options` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `field` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `options`
--

INSERT INTO `options` (`id`, `user_id`, `field`, `value`, `created_at`, `updated_at`) VALUES
(2, 2, 'basemap', 'roadmap', '2022-11-19 12:57:58', '2024-09-23 03:00:31'),
(3, 6, 'basemap', 'roadmap', '2022-12-16 23:10:22', '2024-10-21 19:03:50'),
(5, 6, 'pagesize', 'a3', '2023-01-15 13:44:55', '2023-05-17 19:00:35'),
(14, 2, 'pagesize', 'a4', '2023-01-21 19:46:57', '2023-01-21 19:46:57'),
(16, 10, 'basemap', 'roadmap', '2023-01-22 16:19:31', '2024-09-08 01:58:29'),
(45, 10, 'pagesize', 'a3', '2023-01-28 18:09:00', '2023-03-14 16:02:52'),
(55, 12, 'basemap', 'roadmap', '2023-01-29 17:13:04', '2024-07-31 03:58:41'),
(84, 14, 'basemap', 'hybrid', '2023-01-30 20:40:09', '2024-06-02 03:16:20'),
(97, 17, 'basemap', 'osmcolor', '2023-02-11 21:56:59', '2024-07-18 03:58:31'),
(99, 17, 'pagesize', 'a3', '2023-02-11 21:59:10', '2023-05-20 17:09:31'),
(101, 18, 'basemap', 'roadmap', '2023-02-14 16:03:02', '2024-08-15 04:17:19'),
(107, 12, 'pagesize', 'a4', '2023-03-06 20:09:56', '2023-03-06 20:09:56'),
(153, 28, 'basemap', 'hybrid', '2023-03-27 19:17:02', '2023-03-27 20:26:11'),
(155, 28, 'pagesize', 'a4', '2023-03-27 19:19:20', '2023-03-27 19:19:20'),
(225, 37, 'basemap', 'hybrid', '2023-05-16 22:13:57', '2024-08-27 04:23:28'),
(235, 40, 'basemap', 'roadmap', '2023-05-24 20:07:36', '2023-11-18 23:14:17'),
(239, 44, 'basemap', 'hybrid', '2023-07-18 21:17:34', '2024-05-14 22:13:53'),
(268, 59, 'basemap', 'osmcolor', '2024-01-10 00:54:56', '2024-03-06 04:10:29'),
(298, 62, 'basemap', 'roadmap', '2024-06-02 03:57:39', '2024-06-06 04:43:09'),
(305, 67, 'basemap', 'satellite', '2024-09-15 04:31:11', '2024-09-15 04:41:00'),
(367, 6, 'legend', 'stationpoint', '2024-10-23 10:44:27', '2024-10-23 10:44:27'),
(368, 6, 'documents_list_view', 'false', '2024-10-26 16:14:26', '2024-10-28 06:51:31'),
(369, 67, 'documents_list_view', 'false', '2024-10-26 16:42:00', '2024-10-26 16:42:00'),
(370, 6, 'drawings_list_view', 'true', '2024-10-26 17:09:53', '2024-10-28 07:13:48'),
(371, 6, 'legend', 'line1', '2024-10-26 20:02:27', '2024-10-26 20:02:27'),
(373, 6, 'legend', 'valvepoint', '2024-10-26 20:10:27', '2024-10-26 20:10:27'),
(380, 6, 'legend', 'line16', '2024-10-28 06:45:52', '2024-10-28 06:45:52'),
(381, 6, 'legend', 'line8', '2024-10-28 06:45:58', '2024-10-28 06:45:58'),
(382, 6, 'legend', 'line6', '2024-10-28 06:45:59', '2024-10-28 06:45:59'),
(383, 6, 'legend', 'line4', '2024-10-28 06:46:00', '2024-10-28 06:46:00'),
(384, 6, 'legend', 'line3', '2024-10-28 06:46:01', '2024-10-28 06:46:01'),
(385, 6, 'legend', 'line2', '2024-10-28 06:46:02', '2024-10-28 06:46:02'),
(386, 6, 'legend', 'line0.75', '2024-10-28 06:46:07', '2024-10-28 06:46:07'),
(388, 67, 'drawings_list_view', 'false', '2024-10-28 07:28:00', '2024-10-28 07:28:00');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('CXCtjXd3DjqkrAxFsK0tfXw8VetsZEJxth0cQw1Y', 6, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiSGhNVkpCWWZLcWRqTkxjbVdpRFlWblB5SWpmUTRYU3FwQTdJQ1VWWiI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6NjtzOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozMDoiaHR0cHM6Ly9naXMtdGl0YXNnYXMudGVzdC9ob21lIjt9fQ==', 1730133951),
('hf3RPw2TUNH3a5FtKbLsSCP1msoRANlANjuax6o5', 6, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoicFVMS0FETUN5b3Y1ZXRMZXBUWkJ6VkRMUlMyWUhYRFhFM3lrN0lQTiI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6NjtzOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozMDoiaHR0cHM6Ly9naXMtdGl0YXNnYXMudGVzdC9ob21lIjt9czozMToibG9nLXZpZXdlcjpzaG9ydGVyLXN0YWNrLXRyYWNlcyI7YjowO30=', 1730110773);

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

--
-- Table structure for table `stations`
--

CREATE TABLE `stations` (
  `id` bigint UNSIGNED NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'TGTDPLC',
  `department` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `section` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lat` decimal(8,6) DEFAULT NULL,
  `lng` decimal(8,6) DEFAULT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stations`
--

INSERT INTO `stations` (`id`, `code`, `name`, `type`, `company`, `department`, `section`, `lat`, `lng`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'VST4240', 'Amin Bazar DRS', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.789070, 90.318321, 6, '2022-12-18 07:01:26', '2022-12-21 18:38:19'),
(2, 'VST5020', 'Demra DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Demra', 23.713081, 90.503120, 6, '2022-12-18 07:01:26', '2022-12-21 21:44:37'),
(3, 'VST0030', 'City Central DRS', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.725500, 90.406611, 6, '2022-12-18 07:01:26', '2022-12-21 21:42:43'),
(4, 'VST0060', 'Demra CGS', 'CGS', 'TGTDCL', 'SOD-South', 'Demra', 23.713014, 90.503867, 6, '2022-12-18 12:55:31', '2022-12-21 21:46:28'),
(5, '04-037-0014', 'EGCB 412MW Horipur', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.686751, 90.536978, 6, '2022-12-19 00:48:30', '2023-12-14 01:01:21'),
(6, 'VST1100', 'Horipur TBS', 'TBS', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.686346, 90.536347, 6, '2022-12-21 17:20:31', '2023-12-12 03:12:06'),
(7, 'VST7390', 'Horipur UG VS', 'VS', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.686602, 90.536322, 6, '2022-12-21 21:11:49', '2024-04-22 22:49:08'),
(10, 'VST6070', 'Hazaribag DRS', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.731737, 90.361847, 6, '2022-12-21 21:16:19', '2023-03-26 19:02:59'),
(11, 'VST0050', 'Donia TBS', 'TBS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.699898, 90.457803, 6, '2022-12-21 21:25:48', '2023-12-12 03:16:52'),
(12, 'VST1030', 'Sonargaon TBS', 'TBS', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.639840, 90.602332, 6, '2022-12-21 21:30:37', '2022-12-21 21:30:37'),
(13, 'VST3070', 'Monohordi DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Ghorashal', 24.132110, 90.702500, 6, '2022-12-21 21:32:47', '2022-12-21 21:32:47'),
(14, 'VST5060', 'Shiddhirgonj CGS', 'CGS', 'TGTDCL', 'SOD-South', 'Demra', 23.682270, 90.521582, 6, '2022-12-21 21:35:49', '2022-12-21 21:35:49'),
(15, '04-034-0003', 'Siddhirganj Power Station (SPS) 2 x 120 MW', 'BULK', 'TGTDCL', 'SOD-South', 'Demra', 23.683596, 90.525297, 6, '2022-12-21 21:39:17', '2024-04-22 01:28:59'),
(16, 'VST4020', 'Dhonua TBS', 'TBS', 'TGTDCL', 'SOD-North', 'Gazipur', 24.244419, 90.403222, 6, '2022-12-22 03:07:12', '2023-02-07 17:43:47'),
(17, 'VST4090', 'Tongi DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.893900, 90.404100, 6, '2022-12-25 16:30:56', '2022-12-28 00:39:02'),
(18, 'VST0020', 'Tejgoan TBS', 'TBS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.773180, 90.416910, 6, '2022-12-25 20:54:49', '2023-03-26 18:54:07'),
(19, 'VST3040', 'Narshingdi DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.932097, 90.701858, 6, '2022-12-27 17:16:44', '2023-12-12 03:09:44'),
(20, 'VST0010', 'Gulshan DRS', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.792371, 90.415071, 6, '2022-12-27 20:54:26', '2023-03-29 17:53:13'),
(21, 'VST0040', 'Postogola DRS', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.694333, 90.433389, 6, '2022-12-27 20:55:42', '2022-12-27 20:55:42'),
(22, 'VST0070', 'Nondipara TBS', 'TBS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.745472, 90.444417, 6, NULL, '2023-12-12 03:16:30'),
(23, 'VST6050', 'Zinzira DRS', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.703952, 90.397779, 6, NULL, '2022-12-28 03:06:03'),
(25, 'VST6080', 'Joarshahara DRS', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.830274, 90.419001, 6, NULL, NULL),
(26, 'VST6090', 'Baridhara DOHS DRS', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.816170, 90.416125, 6, NULL, '2022-12-28 03:41:45'),
(27, 'VST6110', 'Dhaka Cantonment DRS', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.797693, 90.394286, 6, NULL, NULL),
(28, 'VST6120', 'Agargaon DRS', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.776325, 90.380349, 6, NULL, NULL),
(29, 'VST6130', 'Mirpur-10 DRS', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.807010, 90.368860, 6, NULL, '2022-12-28 00:54:34'),
(30, 'VST6140', 'Mirpur Mazar Road DRS', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.793118, 90.350324, 6, NULL, '2023-02-07 15:37:26'),
(31, 'VST6150', 'Mirpur Cantonment DRS', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.832854, 90.363516, 6, NULL, NULL),
(32, 'VST6160', 'Uttara DRS', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.874366, 90.399421, 6, NULL, NULL),
(33, 'VST7280', 'Mirpur DOHS DRS', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.836655, 90.365855, 6, NULL, '2022-12-28 03:38:28'),
(35, 'VST7300', 'Kamarpara FRS', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.880721, 90.391701, 6, NULL, '2024-08-15 03:20:19'),
(36, 'VST7340', 'Majher Char DRS', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.730485, 90.350185, 6, NULL, NULL),
(37, 'VST4010', 'Joydebpur CGS', 'CGS', 'TGTDCL', 'SOD-North', 'Gazipur', 24.008561, 90.415557, 6, NULL, '2023-03-26 19:08:55'),
(38, 'VST4030', 'Ashulia TBS', 'TBS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.894400, 90.332200, 6, NULL, NULL),
(39, 'VST4040', 'Tongi TBS', 'TBS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.904900, 90.405300, 6, NULL, NULL),
(40, 'VST4060', 'Ghatail DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 24.482000, 89.998600, 6, NULL, '2023-12-12 00:57:33'),
(41, 'VST4070', 'Elenga TBS', 'TBS', 'TGTDCL', 'SOD-North', 'Gazipur', 24.338500, 89.925700, 6, NULL, NULL),
(42, 'VST4080', 'Gopalpur TBS', 'TBS', 'TGTDCL', 'SOD-North', 'Gazipur', 24.544408, 89.920896, 6, NULL, '2024-04-21 23:49:52'),
(43, 'VST4100', 'Kaliganj DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.925400, 90.557700, 6, NULL, NULL),
(44, 'VST4110', 'Pubail VS', 'VS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.933800, 90.469800, 6, NULL, NULL),
(45, 'VST4120', 'Kamta TBS', 'TBS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.883400, 90.489300, 6, NULL, '2023-12-12 00:59:41'),
(46, 'VST4130', 'Gararan IMS', 'IMS', 'TGTDCL', 'SOD-North', 'Gazipur', 24.227225, 90.487752, 6, NULL, '2023-03-27 21:14:24'),
(47, 'VST4140', 'Rajendrapur VS', 'VS', 'TGTDCL', 'SOD-North', 'Gazipur', 24.102200, 90.470000, 6, NULL, '2023-10-18 22:11:59'),
(48, 'VST4150', 'Bilashpur VS', 'VS', 'TGTDCL', 'SOD-North', 'Gazipur', 24.007600, 90.424800, 6, NULL, NULL),
(49, 'VST4160', 'Dhirasram VS', 'VS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.955800, 90.412500, 6, NULL, NULL),
(50, 'VST4170', 'Arichpur VS', 'VS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.882527, 90.404681, 6, NULL, '2023-03-26 19:06:19'),
(51, 'VST4180', 'Konabari DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 24.009859, 90.323507, 6, NULL, '2023-06-26 20:16:04'),
(52, 'VST4190', 'Chandra DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 24.044147, 90.246102, 6, NULL, '2023-06-26 20:11:57'),
(53, 'VST4200', 'Mirzapur Cadet College DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 24.090200, 90.173000, 6, NULL, '2023-08-30 22:44:47'),
(54, 'VST4210', 'Kumudini DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 24.101373, 90.095154, 6, NULL, '2023-06-26 20:07:11'),
(55, 'VST4220', 'Korotia DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 24.218292, 89.978827, 6, NULL, '2023-06-26 20:08:02'),
(56, 'VST4230', 'Tangail DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 24.243426, 89.936373, 6, NULL, '2023-06-26 20:08:39'),
(57, 'VST4250', 'Savar DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.872600, 90.273300, 6, NULL, NULL),
(58, 'VST4260', 'Dhamrai DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.907700, 90.219100, 6, NULL, NULL),
(59, 'VST4270', 'Kalampur DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.920057, 90.149200, 6, NULL, '2023-03-06 18:23:05'),
(60, 'VST4280', 'AKIJ DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.910700, 90.069500, 6, NULL, NULL),
(61, 'VST4290', 'Manikganj BSCIC DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.892800, 90.035200, 6, NULL, NULL),
(62, 'VST4300', 'Manikganj DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.878092, 90.017717, 6, NULL, '2023-01-01 18:10:13'),
(63, 'VST4310', 'Munnu DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.847646, 89.960843, 6, NULL, '2023-02-07 19:13:58'),
(64, 'VST4320', 'Tepra DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.845479, 89.835469, 6, NULL, '2023-01-24 20:01:23'),
(65, 'VST4330', 'Zirabo DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.913100, 90.318400, 6, NULL, NULL),
(66, 'VST4340', 'DEPZ DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.951900, 90.273400, 6, NULL, NULL),
(67, 'VST4350', 'Beximco DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.982300, 90.267500, 6, NULL, NULL),
(71, 'VST6200', 'Sarisabari TBS', 'TBS', 'TGTDCL', 'SOD-North', 'Mymensingh', 24.778543, 89.871560, 6, NULL, '2024-04-22 00:16:10'),
(73, 'VST6220', 'Elenga-Manikgonj-Dhamrai Project', 'PROP', 'TGTDCL', 'SOD-North', 'Gazipur', 24.338740, 89.926080, 6, NULL, '2024-04-21 22:47:31'),
(77, 'xxxx', 'Char Raghurampur Scraper Station', 'VS', 'TGTDCL', 'SOD-North', 'Mymensingh', 24.758859, 90.455447, 6, NULL, '2023-07-11 22:59:30'),
(78, '04-071-0001', 'Rural Power Company Ltd (RPCL)', 'BULK', 'TGTDCL', 'SOD-North', 'Mymensingh', 24.763216, 90.419037, 6, NULL, '2024-04-21 23:58:14'),
(79, 'VST7030', 'Potka VS', 'VS', 'TGTDCL', 'SOD-North', 'Gazipur', 24.192526, 90.493206, 6, NULL, NULL),
(86, 'VST7170', 'Valuka DRS', 'TBS', 'TGTDCL', 'SOD-North', 'Mymensingh', 24.406840, 90.394240, 6, NULL, '2024-04-21 23:55:53'),
(89, '04-003-0001', 'Tongi Power Plant 80MW ', 'BULK', 'TGTDCL', 'SOD-North', 'Gazipur', 23.896622, 90.411923, 6, NULL, '2024-04-22 01:29:36'),
(94, 'VST1010', 'Tarabo TBS', 'TBS', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.717692, 90.507614, 6, NULL, '2023-12-12 03:12:32'),
(95, 'VST1020', 'Dighiborabo CGS', 'CGS', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.723785, 90.516828, 6, NULL, '2023-03-06 18:16:48'),
(96, 'VST1040', 'Kanchan DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.820822, 90.555971, 6, NULL, NULL),
(98, 'VST1060', 'Araihajar DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.791020, 90.629687, 6, NULL, '2023-03-26 18:49:33'),
(99, 'VST1070', 'Lakkhankhola DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.660272, 90.525146, 6, NULL, '2023-03-27 17:55:02'),
(100, 'VST1080', 'Bhulta TBS', 'TBS', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.785684, 90.557369, 6, NULL, '2023-12-12 03:11:14'),
(101, 'VST1090', 'Gazaria TBS', 'TBS', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.575660, 90.642523, 6, NULL, '2023-12-12 03:11:40'),
(102, 'VST1110', 'Meghnaghat TBS', 'TBS', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.613816, 90.605399, 6, NULL, '2023-02-07 18:35:17'),
(103, '04-037-0005', 'Rahim Energy Ltd (SPP)', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.701497, 90.532027, 6, NULL, '2023-12-14 01:42:57'),
(104, '04-037-0004', 'Heidelberg Cement Bangladesh Ltd 10 MW', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.712710, 90.514045, 6, NULL, '2024-04-22 01:47:36'),
(105, '04-037-0007', 'Unique Power Plant-1 27.65 MW', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.613400, 90.610326, 6, NULL, '2024-04-22 01:53:44'),
(106, '03-037-0008', 'Unique Power Plant-2 (Boiler)', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.624434, 90.622315, 6, NULL, '2023-12-14 02:32:35'),
(108, '04-037-0008', 'Unique Power Plant-2 10 MW', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.625063, 90.621296, 6, NULL, '2024-04-22 01:54:37'),
(109, '04-037-0009', 'Partex Energy 10.5 MW', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.804615, 90.543401, 6, NULL, '2024-04-22 01:55:32'),
(110, '04-037-0010', 'City Suger Ind. Power Ltd (CSI) 22 MW', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.752061, 90.517938, 6, NULL, '2024-04-22 01:56:25'),
(111, '04-037-0011', 'Abdul Monem (AM) Energy Ltd 10 MW', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.621585, 90.623526, 6, NULL, '2024-04-22 01:56:55'),
(112, '04-037-0013', 'Everest Power Generation Co Ltd', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.623815, 90.621167, 6, NULL, '2023-12-14 02:32:04'),
(113, '04-037-0015', 'MPP Power Plant Ltd', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.628493, 90.620151, 6, NULL, '2023-12-14 01:02:13'),
(114, '08-037-0556', 'Bashundhara Multi Papers Ind', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.614356, 90.619342, 6, NULL, '2023-12-14 01:49:32'),
(115, '08-037-0024', 'Meghna Suger Refinary Ltd', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.622761, 90.623712, 6, NULL, '2023-12-14 01:45:33'),
(116, '04-037-0006', 'Meghnaghat Power Ltd 450MW', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.613280, 90.600774, 6, NULL, '2023-12-11 03:58:30'),
(117, '04-037-0016', 'Summit Meghnaghat Power Co Ltd 335MW', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.613225, 90.600123, 6, NULL, '2023-12-11 04:00:17'),
(118, '04-037-0012', 'Summit Purbanchol 33 MW, Rupgonj', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.755117, 90.550219, 6, NULL, '2024-04-22 01:34:41'),
(119, '04-037-0003', 'Haripur Power Ltd 360 MW', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.679096, 90.535137, 6, NULL, '2023-12-11 03:55:32'),
(120, '04-037-0001', 'Horipur Power Plant 100 MW', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.684355, 90.531591, 6, NULL, '2024-04-22 01:26:30'),
(121, '08-037-0017', 'City Seed Crushing Ltd (Unit-2)', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.749768, 90.515371, 6, NULL, '2023-12-14 01:41:05'),
(122, '08-037-0018', 'City Edible Oil Ltd', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.750541, 90.518228, 6, NULL, '2023-12-14 01:41:50'),
(123, '04-070-0002', 'Samuda Power Ltd', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.598481, 90.610074, 6, NULL, '2023-12-14 01:17:06'),
(124, 'VST2010', 'Brahmanbaria DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 23.997302, 91.108573, 6, NULL, '2023-12-12 02:08:59'),
(125, 'VST2020', 'Bhairab DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 24.048153, 90.991983, 6, NULL, '2023-12-06 23:08:11'),
(127, '05-035-0003', 'Ghorashal Polash Fertilizer (GPF) PLC', 'BULK', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.986680, 90.640600, 6, NULL, '2024-04-22 01:18:55'),
(128, 'VST3030', 'Madhobdi DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.856105, 90.655677, 6, NULL, '2023-12-12 03:09:19'),
(129, '04-036-0003', 'Doreen Power Generations Ltd, Narsingdi', 'BULK', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.918652, 90.692948, 6, NULL, '2023-12-14 01:09:52'),
(130, 'VST3060', 'Shibpur DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Ghorashal', 24.044896, 90.727482, 6, NULL, '2023-03-26 18:19:50'),
(131, 'VST3100', 'Ghorashal DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.980759, 90.644706, 6, NULL, '2023-03-06 20:22:47'),
(132, '04-035-0001', 'GPS Unit-1&2 110 MW', 'BULK', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.980862, 90.644735, 6, NULL, '2023-12-11 03:30:25'),
(133, '04-035-0002', 'GPS Unit-3 416 MW Repowering', 'BULK', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.980932, 90.644751, 6, NULL, '2024-04-22 01:12:36'),
(134, '04-035-0008', 'GPS Unit-4 409 MW Repowering', 'BULK', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.980974, 90.644758, 6, NULL, '2024-04-22 01:13:05'),
(135, '04-035-0009', 'GPS Unit-5 210 MW', 'BULK', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.981029, 90.644765, 6, NULL, '2024-04-22 01:14:13'),
(136, '04-035-0007', 'GPS Unit-7 365 MW', 'BULK', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.981134, 90.644792, 6, NULL, '2023-12-11 03:32:45'),
(138, '04-035-0006', 'Regent Energy & Power Ltd 108 MW', 'BULK', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.981111, 90.644642, 6, NULL, '2024-04-22 01:16:17'),
(139, 'VST3180', 'Capital Paper DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.980817, 90.644593, 6, NULL, '2023-03-06 20:22:09'),
(140, 'VST3190', 'Deshbondhu DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.981189, 90.645078, 6, NULL, '2023-03-06 20:21:27'),
(141, '04-036-0002', 'Madhobdi Rural Power Co Ltd 27MW', 'BULK', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.856012, 90.655630, 6, '2023-03-26 18:42:20', '2023-12-11 03:37:16'),
(142, '04-036-0001', 'Madhobdi Rural Power Co Ltd 10MW', 'BULK', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.855986, 90.655763, 6, '2023-03-26 18:43:24', '2023-12-11 03:36:44'),
(143, 'VST4050', 'Saoraid TBS', 'TBS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.998000, 90.634800, 6, NULL, '2023-12-06 04:55:34'),
(147, 'VST5070', 'Kadamtoli TBS', 'TBS', 'TGTDCL', 'SOD-South', 'Demra', 23.675319, 90.446883, 6, NULL, '2023-02-07 13:24:39'),
(149, 'VST5090', 'Godnail TBS', 'TBS', 'TGTDCL', 'SOD-South', 'Demra', 23.644308, 90.511191, 6, NULL, NULL),
(150, 'VST5100', 'Godnail VS', 'VS', 'TGTDCL', 'SOD-South', 'Demra', 23.644401, 90.508944, 6, NULL, '2023-12-12 02:10:26'),
(151, 'VST5110', 'Pagla DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Demra', 23.666471, 90.467442, 6, NULL, '2023-12-12 03:06:10'),
(152, 'VST5120', 'Fatulla DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Demra', 23.642270, 90.478610, 6, NULL, NULL),
(153, 'VST5130', 'Ponchoboti DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Demra', 23.625523, 90.476336, 6, NULL, NULL),
(154, 'VST5140', 'Muktarpur DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Demra', 23.578415, 90.511888, 6, NULL, NULL),
(155, 'VST5150', 'Munshigonj DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Demra', 23.561596, 90.510591, 6, NULL, '2023-03-19 17:43:56'),
(157, 'VST6020', 'Dholessor DRS', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.673739, 90.439020, 6, NULL, '2023-10-19 01:43:46'),
(159, 'VST6040', 'Pangaon VS', 'VS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.663366, 90.449566, 6, NULL, '2023-12-06 23:01:31'),
(160, 'VST7060', 'Ashugonj VS-3', 'VS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 24.036711, 91.007071, 6, NULL, '2023-12-06 23:02:30'),
(161, 'VST7070', 'Narsingdi VS-12', 'VS', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.932157, 90.702078, 6, NULL, '2023-02-07 18:26:32'),
(163, 'VST7110', 'Ghatura IMS', 'IMS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 23.997220, 91.108350, 6, NULL, '2023-12-06 23:06:30'),
(167, 'VST7190', 'City Economic Zone DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.750437, 90.517097, 6, NULL, '2022-12-28 03:31:01'),
(168, 'VST7200', 'Narsingdi VS-11', 'VS', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.933241, 90.751824, 6, NULL, '2022-12-28 03:33:48'),
(169, 'VST7210', 'Shahjibazar IMS', 'IMS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 24.234654, 91.373327, 6, NULL, '2023-12-06 23:09:00'),
(170, 'VST7220', 'Khatihata VS', 'VS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 24.048900, 91.115800, 6, NULL, '2023-12-06 23:07:08'),
(173, 'VST7350', 'Kanchpur BSCIC DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.700242, 90.529562, 6, NULL, '2022-12-28 01:42:29'),
(174, 'VST7360', 'Adamjee EPZ DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Demra', 23.679865, 90.517816, 6, NULL, '2022-12-29 21:45:08'),
(176, 'VST7410', 'Dighiborabo UG VS', 'VS', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.723617, 90.516982, 6, NULL, '2023-03-06 18:16:07'),
(178, 'VST6260', 'Trishal TBS', 'TBS', 'TGTDCL', 'SOD-North', 'Mymensingh', 24.581820, 90.397637, 6, '2023-02-07 18:54:18', '2024-04-21 23:54:50'),
(179, 'VST4315', 'Munnu RMS', 'IND', 'TGTDCL', 'SOD-North', 'Gazipur', 23.847655, 89.960776, 6, '2023-02-07 19:16:26', '2023-02-07 19:16:26'),
(180, 'xxxx', 'Firingibazar VS', 'VS', 'TGTDCL', 'SOD-South', 'Demra', 23.569013, 90.505518, 6, '2023-03-19 17:41:38', '2023-12-12 03:07:16'),
(181, 'VST1410', 'Kashipur FRS', 'DRS', 'TGTDCL', 'SOD-South', 'Demra', 23.605306, 90.483795, 6, '2023-03-21 18:01:50', '2024-08-15 03:20:51'),
(182, 'VSTxxxx', 'Talshohor VS', 'VS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 24.027199, 91.017996, 6, '2023-03-26 16:47:11', '2023-12-06 23:07:43'),
(183, 'VSTxxxx', 'Kishoregonj DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Ghorashal', 24.421807, 90.779683, 6, '2023-03-26 18:25:53', '2024-07-31 02:11:11'),
(184, 'VSTxxxx', 'Methikanda VS', 'VS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 23.992712, 90.865785, 6, '2023-03-26 18:33:57', '2023-12-06 23:08:28'),
(187, 'xxxx', 'Japan Economic Zone TBS', 'TBS', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.830076, 90.619022, 6, '2023-03-26 18:48:47', '2023-12-12 03:08:41'),
(188, 'VSTxxxx', 'Netrokona DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Mymensingh', 24.865395, 90.729093, 6, '2023-03-26 19:16:17', '2023-07-11 23:03:00'),
(189, 'VSTxxxx', 'Tarakandi VS', 'VS', 'TGTDCL', 'SOD-North', 'Mymensingh', 24.684345, 89.829412, 6, '2023-03-26 19:20:35', '2023-03-26 19:20:35'),
(190, 'VSTxxxx', 'Jamalpur EZ DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Mymensingh', 24.788654, 89.934276, 6, '2023-03-26 19:25:24', '2024-08-20 04:41:48'),
(192, 'VST7040', 'Jamalpur DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Mymensingh', 24.897886, 89.947080, 6, '2023-03-26 19:29:25', '2023-03-27 21:17:57'),
(193, 'VST7050', 'Sherpur DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Mymensingh', 25.008773, 90.019902, 6, '2023-03-26 19:32:04', '2023-03-26 19:32:04'),
(194, '08-003-0657', 'Seven Circle (Bangladesh) Ltd', 'BULK', 'TGTDCL', 'SOD-North', 'Gazipur', 23.934834, 90.611766, 6, '2023-03-27 05:07:16', '2023-12-14 01:24:51'),
(195, 'VST4320', 'Abdullahpur VS', 'VS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.881516, 90.404678, 6, '2023-04-03 15:47:23', '2023-04-03 15:47:23'),
(197, '7-39-000030-00-84-4', 'Meghna CNG Filling', 'CNG', 'TGTDCL', 'Narsingdi', 'Bhairab', 24.064221, 90.978191, 6, '2023-05-06 20:53:04', '2023-08-06 03:30:12'),
(198, '3-06-000679-00-03-1', 'Newtop Textile', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.674882, 90.526949, 12, '2023-06-19 19:21:06', '2023-06-26 21:19:29'),
(199, '04-032-0001', 'A A Power Generation Co Ltd 12.8 MW', 'BULK', 'TGTDCL', 'SOD-North', 'Gazipur', 24.005633, 90.324172, 6, '2023-06-26 20:23:36', '2024-04-22 01:20:23'),
(200, '04-038-0003', 'United Power Generation & Dist', 'BULK', 'TGTDCL', 'SOD-North', 'Gazipur', 23.947927, 90.274638, 6, '2023-06-26 20:26:29', '2023-12-12 23:24:39'),
(201, 'xxx', 'Ananta Apparels Ltd', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.680720, 90.517856, 6, '2023-06-26 20:31:23', '2023-06-26 20:37:03'),
(202, 'xxxx', 'Remi Holdings 1', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.680779, 90.517850, 6, '2023-06-26 20:33:59', '2023-06-26 20:37:57'),
(203, 'xxxx', 'Remi Holdings 2', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.680762, 90.517850, 6, '2023-06-26 20:34:28', '2023-06-26 20:34:28'),
(204, 'xxxx', 'Supreme Knit Wire', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.680274, 90.518083, 6, '2023-06-26 20:36:01', '2023-06-26 20:36:32'),
(205, 'xxxx', 'Epic Garments Ltd', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.680778, 90.520109, 6, '2023-06-26 20:57:20', '2023-06-26 20:57:20'),
(206, 'xxxx', 'Yassma Knitting & Dyeing', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.678393, 90.521520, 6, '2023-06-26 20:59:22', '2023-06-26 20:59:48'),
(207, 'xxxx', 'Scandex', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.678245, 90.521750, 6, '2023-06-26 21:00:39', '2023-06-26 21:01:13'),
(208, 'xxxx', 'R-pac', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.680897, 90.521734, 6, '2023-06-26 21:02:07', '2023-06-26 21:02:33'),
(209, 'xxxx', 'UHM Limited', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.677902, 90.523084, 6, '2023-06-26 21:03:29', '2023-06-26 21:05:32'),
(210, 'xxxx', 'Simba Fashions Ltd - 2', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.678774, 90.525314, 6, '2023-06-26 21:06:44', '2023-06-26 21:07:03'),
(211, 'xxxx', 'Ayesa Fashion', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.677946, 90.523465, 6, '2023-06-26 21:08:13', '2023-06-26 21:08:29'),
(212, 'xxxx', 'Wun Tung', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.678757, 90.525495, 6, '2023-06-26 21:09:22', '2023-06-26 21:09:41'),
(213, 'xxxx', 'DNV Clothing', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.676941, 90.526939, 6, '2023-06-26 21:10:27', '2023-06-26 21:10:55'),
(214, '3-06-000667-00-03-6', 'Maruhisa Pacific', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.674901, 90.528756, 6, '2023-06-26 21:11:52', '2023-08-03 03:47:36'),
(215, '3-06-000637-00-03-3', 'Fem Wendler', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.674533, 90.529300, 6, '2023-06-26 21:13:46', '2023-08-06 03:39:18'),
(216, 'xxxx', 'Yester Accessories', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.674260, 90.529297, 6, '2023-06-26 21:14:49', '2023-06-26 21:15:09'),
(217, 'xxxx', 'Simba Fashion - 1', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.672911, 90.529142, 6, '2023-06-26 21:16:01', '2023-06-26 21:16:20'),
(218, 'xxxx', 'French Fashion', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.673760, 90.527241, 6, '2023-06-26 21:17:26', '2023-06-26 21:17:45'),
(219, 'xxxx', 'Simba Fashion - 3', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.673967, 90.527218, 6, '2023-06-26 21:18:24', '2023-06-26 21:18:41'),
(220, 'xxxx', 'Ananta Huaxiang', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.676831, 90.523606, 6, '2023-06-26 21:21:00', '2023-06-26 21:21:18'),
(221, 'xxxx', 'Universal Menswear', 'IND', 'TGTDCL', 'Narayangonj', 'Narayangonj', 23.677288, 90.519358, 6, '2023-06-26 21:22:46', '2023-06-26 21:22:46'),
(222, 'xxxx', 'Gafargaon DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Mymensingh', 24.455981, 90.542089, 6, '2023-07-08 20:44:17', '2023-12-12 01:02:27'),
(223, 'xxxx', 'Akij EZ DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Mymensingh', 24.511269, 90.393682, 6, '2023-07-10 04:45:31', '2023-07-10 04:45:31'),
(224, 'VST7090', 'Mymensingh DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Mymensingh', 24.721340, 90.410236, 6, '2023-07-11 22:57:35', '2024-04-21 23:55:20'),
(225, 'VST7010', 'Char Raghurampur DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Mymensingh', 24.758798, 90.455666, 6, '2023-07-11 23:00:17', '2023-07-11 23:00:17'),
(227, '332-****', 'Sun Yad Packaging Ltd', 'CAP', 'TGTDCL', 'Gazipur', 'Joydebpur', 24.038575, 90.388747, 44, '2023-07-18 21:22:14', '2023-07-18 21:22:14'),
(229, '736', 'NN CNG', 'CNG', 'TGTDCL', 'Narsingdi', 'Narsingdi', 23.854191, 90.661769, 46, '2023-07-24 20:00:26', '2023-07-24 20:00:26'),
(230, '08-032-0669', 'Israq spinning Mills Ltd', 'BULK', 'TGTDCL', 'SOD-North', 'Gazipur', 24.179793, 90.437712, 46, '2023-07-24 20:12:32', '2023-12-12 23:16:47'),
(231, '3-37-000641-00-04-9	', 'Meghna Ceramics Ind. Ltd', 'IND', 'TGTDCL', 'Sonargaon', 'Meghnaghat', 23.619585, 90.603204, 47, '2023-07-25 22:51:05', '2023-08-22 03:19:26'),
(232, 'xxxx', 'Keranigonj BSCIC DRS (Under Construction)', 'DRS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.666778, 90.305997, 6, '2023-08-01 18:28:39', '2023-12-12 03:15:27'),
(233, '8-79-000098-00-96-7', 'NOMAN COMPOSITE TEXTILE', 'IND', 'TGTDCL', 'Gazipur', 'Gazipur', 24.298859, 90.398305, 2, '2023-08-03 04:02:59', '2023-08-03 04:07:50'),
(234, '3-39-000013-00-84-0', 'BANGA BAKERS LTD', 'IND', 'TGTDCL', 'Narsingdi', 'Bhairab', 24.062207, 90.979815, 6, '2023-08-06 03:28:29', '2023-08-06 03:28:29'),
(235, '8-32-000778-00-06-2', 'GENESIS FASHIONS LTD.', 'CAP', 'TGTDCL', 'Gazipur', 'Joydebpur', 23.985733, 90.356804, 2, '2023-08-13 02:16:24', '2023-08-13 02:16:24'),
(236, '04-038-0004', 'Summit Uttaranchol 33 MW, Gazipur', 'BULK', 'TGTDCL', 'SOD-North', 'Gazipur', 24.248104, 90.400802, 6, '2023-08-22 04:14:58', '2024-04-22 01:35:14'),
(237, 'xxxx', 'Banga Bhaban RMS', 'COM', 'TGTDCL', 'MDMD-South', 'MDMD-2', 23.721742, 90.420875, 6, '2023-08-24 05:59:22', '2023-08-24 05:59:22'),
(238, 'xxxx', 'Latif Bawani Jute Mills RMS', 'COM', 'TGTDCL', 'MDMD-1', 'MDMD-1', 23.721668, 90.495885, 6, '2023-08-30 01:55:38', '2023-08-30 02:26:27'),
(239, 'xxxx', 'Jashim Uddin Knit composite', 'IND', 'TGTDCL', 'Narayangonj', 'Fatullah', 23.641989, 90.488519, 6, '2023-09-10 00:32:43', '2023-09-10 00:32:43'),
(240, 'xxxx', 'Abloom Design', 'IND', 'TGTDCL', 'Narayangonj', 'Fatullah', 23.648802, 90.504285, 6, '2023-09-10 00:36:25', '2023-09-10 00:36:25'),
(241, 'xxxx', 'Sayedpur TBS', 'PROP', 'TGTDCL', 'SOD-South', 'Demra', 23.589402, 90.506916, 39, '2023-09-26 04:55:22', '2024-04-21 22:49:49'),
(242, 'xxxx', 'Dhonokunda VS', 'VS', 'TGTDCL', 'SOD-South', 'Demra', 23.680520, 90.513976, 6, '2023-10-04 00:35:22', '2023-10-04 00:35:22'),
(243, '04-032-0002', 'ASM Chemical Industries Ltd.', 'BULK', 'TGTDCL', 'SOD-North', 'Gazipur', 24.228345, 90.420289, 6, '2023-12-11 03:05:50', '2023-12-12 23:17:14'),
(244, '04-032-0008', 'Mosharaf Comp. Textile Mills', 'BULK', 'TGTDCL', 'SOD-North', 'Gazipur', 24.158871, 90.409828, 6, '2023-12-11 03:18:32', '2023-12-11 03:18:32'),
(245, '04-034-0002', 'Siddhirganj Power Station (SPS) 210 MW ', 'BULK', 'TGTDCL', 'SOD-South', 'Demra', 23.682927, 90.525144, 6, '2023-12-11 03:23:23', '2024-04-22 01:27:48'),
(246, '04-034-0004', 'EGCB Siddhirganj 335 MW CCPP', 'BULK', 'TGTDCL', 'SOD-South', 'Demra', 23.683959, 90.516352, 6, '2023-12-11 03:26:16', '2024-04-22 01:30:46'),
(247, '04-037-0002', 'NEPC Consortium Power Ltd', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.684380, 90.531576, 6, '2023-12-11 03:42:31', '2023-12-11 03:42:31'),
(248, 'xx', 'Shibbari VS', 'VS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.997114, 90.417376, 37, '2023-12-11 06:20:31', '2023-12-11 06:20:31'),
(254, 'xxxx', 'Valuka VS (Flare Station)', 'VS', 'TGTDCL', 'SOD-North', 'Mymensingh', 24.404529, 90.394430, 6, '2023-12-12 01:09:46', '2023-12-12 01:09:46'),
(255, 'xxxx', 'Kamta VS', 'VS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.886553, 90.487196, 6, '2023-12-12 01:21:18', '2023-12-12 01:21:18'),
(256, 'xxxx', 'Kotiadi VS', 'VS', 'TGTDCL', 'SOD-North', 'Mymensingh', 24.333781, 90.756516, 6, '2023-12-12 01:25:11', '2023-12-12 01:25:11'),
(257, 'xxxx', 'Bhadam VS', 'VS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.901074, 90.355642, 6, '2023-12-12 02:06:28', '2023-12-12 02:06:28'),
(258, 'xxxx', 'Ashulia VS', 'VS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.893676, 90.337347, 6, '2023-12-12 02:08:02', '2023-12-12 02:08:02'),
(259, 'xxxx', 'Jurain North VS', 'VS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.693683, 90.434384, 6, '2023-12-12 03:19:43', '2023-12-12 03:19:43'),
(260, 'xxxx', 'Jurain South VS', 'VS', 'TGTDCL', 'SOD-MD', 'Station Control', 23.693334, 90.434681, 6, '2023-12-12 03:20:26', '2023-12-12 03:20:26'),
(261, 'xxxx', 'SPAR-1 VS', 'VS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 24.037271, 91.001990, 6, '2023-12-12 04:33:57', '2023-12-12 04:33:57'),
(262, 'xxxx', 'Ashuganj VS-4', 'VS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 24.039625, 91.000351, 6, '2023-12-12 05:42:20', '2023-12-12 05:42:53'),
(263, 'xxxx', 'Bhairab VS-5', 'VS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 24.047289, 90.991758, 6, '2023-12-12 05:43:58', '2023-12-12 05:43:58'),
(264, 'xxxx', 'Jagannathpur VS', 'VS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 24.053971, 90.971628, 6, '2023-12-12 05:45:00', '2023-12-17 03:15:18'),
(265, 'xxxx', 'Ramnagar VS', 'VS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 24.039880, 90.963149, 6, '2023-12-12 05:46:12', '2023-12-12 05:46:12'),
(266, 'xxxx', 'Daulotkandi VS (GTCL)', 'VS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 24.022154, 90.952345, 6, '2023-12-12 05:47:06', '2023-12-12 05:47:06'),
(267, 'xxxx', 'Shahbazpur (North) VS', 'VS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 24.039880, 91.167563, 6, '2023-12-12 05:47:58', '2024-08-18 01:32:58'),
(268, 'xxxx', 'Madhobpur VS', 'VS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 24.094846, 91.293597, 6, '2023-12-12 05:49:35', '2023-12-12 05:49:35'),
(269, 'xxxx', 'Amirganj VS-10', 'VS', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.933191, 90.754339, 6, '2023-12-12 05:51:10', '2023-12-12 05:53:06'),
(271, 'xxxx', 'Itakhola VS', 'VS', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.981775, 90.722364, 6, '2023-12-12 05:54:17', '2023-12-12 05:54:17'),
(272, '04-038-0001', 'REB Ashulia  10 MW PP', 'BULK', 'TGTDCL', 'SOD-North', 'Gazipur', 23.890110, 90.323431, 6, '2023-12-14 01:03:57', '2024-04-21 23:45:55'),
(273, '04-038-0002', 'REB Ashulia 33.75 MW PP', 'BULK', 'TGTDCL', 'SOD-North', 'Gazipur', 23.889928, 90.322962, 6, '2023-12-14 01:05:02', '2024-04-21 23:47:08'),
(274, '04-060-0001', 'Doreen Power Generations Ltd, Tangail', 'BULK', 'TGTDCL', 'SOD-North', 'Gazipur', 24.322531, 89.922908, 6, '2023-12-14 01:11:59', '2023-12-14 01:11:59'),
(276, '04-070-0001', 'Shah Cement Ind Ltd 15.2 MW', 'BULK', 'TGTDCL', 'SOD-South', 'Demra', 23.568442, 90.524404, 6, '2023-12-14 01:15:44', '2024-04-22 01:55:03'),
(279, '08-003-0839', 'Packmat Industries Ltd', 'BULK', 'TGTDCL', 'SOD-North', 'Gazipur', 24.012677, 90.655060, 6, '2023-12-14 01:28:51', '2023-12-14 01:28:51'),
(280, '08-032-0741', 'Anwer Ispat Limited', 'BULK', 'TGTDCL', 'SOD-North', 'Gazipur', 23.930931, 90.385734, 6, '2023-12-14 01:31:47', '2023-12-14 01:31:47'),
(281, '08-032-0846', 'Paramount Textile Limited', 'BULK', 'TGTDCL', 'SOD-North', 'Gazipur', 24.190982, 90.424025, 6, '2023-12-14 01:35:51', '2023-12-14 01:35:51'),
(282, '08-032-1334', 'Nice Spun Mills Limited', 'BULK', 'TGTDCL', 'SOD-North', 'Gazipur', 24.239167, 90.389753, 6, '2023-12-14 01:37:42', '2023-12-14 01:37:42'),
(283, '08-036-0244', 'Pakiza Cotton Spinning Mills', 'BULK', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.864286, 90.669957, 6, '2023-12-14 01:40:17', '2023-12-14 01:40:17'),
(284, '08-037-0022', 'Rahim Energy Ltd (CPP)', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.701181, 90.533314, 6, '2023-12-14 01:44:36', '2023-12-14 01:44:36'),
(285, '08-037-0378', 'Chaity Composite Ltd', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.649920, 90.586599, 6, '2023-12-14 01:47:49', '2023-12-14 01:47:49'),
(286, '08-037-0554', 'UCI Power Plant Ltd', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.610731, 90.611206, 6, '2023-12-14 01:54:31', '2023-12-14 01:54:31'),
(288, 'xxxx', 'Jagannathpur VS-7', 'VS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 24.053741, 90.970584, 6, '2023-12-17 03:15:03', '2023-12-17 03:15:03'),
(290, '3-06-000201-00-03-0', 'Unity Composite ', 'IND', 'TGTDCL', 'Narayanganj ', 'Fatullah ', 23.643854, 90.496700, 6, '2024-02-08 00:34:19', '2024-02-08 00:34:19'),
(291, '3-03-000706-00-05-8', 'Rashik Textile ', 'IND', 'TGTDCL', 'Gazipur ', 'Tongi', 23.892062, 90.413374, 6, '2024-02-14 23:37:24', '2024-02-14 23:37:24'),
(292, 'Nassa Taipei Spinner Ltd.', '8-37-0000415-00-04-0', 'CAP', 'TGTDCL', 'Sonargaon', 'Sonargaon', 23.715884, 90.517063, 6, '2024-02-17 21:51:22', '2024-02-17 21:56:17'),
(293, 'xxxx', 'Machine Tools Factory DRS', 'DRS', 'TGTDCL', 'SOD-North', 'Gazipur', 24.025167, 90.420066, 37, '2024-03-05 04:07:50', '2024-08-18 01:30:13'),
(295, 'xxxx', 'Narsingdi VS-13', 'VS', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.929982, 90.701864, 6, '2024-03-24 23:47:26', '2024-03-24 23:48:24'),
(296, 'xxxx', 'Rupgonj IMS', 'IMS', 'TGTDCL', 'SOD-North', 'Gazipur', 23.849845, 90.518135, 6, '2024-04-21 05:39:14', '2024-04-21 05:39:14'),
(297, 'xxxx', 'Kamartek IMS', 'IMS', 'TGTDCL', 'SOD-South', 'Ghorashal', 24.022448, 90.816582, 6, '2024-04-21 05:40:53', '2024-04-21 05:40:53'),
(298, 'xxxx', 'Suhilpur VS', 'VS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 24.021035, 91.114464, 6, '2024-04-21 05:42:47', '2024-04-22 01:08:41'),
(299, '08-038-0466', 'Matin Spinning Mills PLC', 'BULK', 'TGTDCL', 'SOD-North', 'Gazipur', 23.978293, 90.299023, 6, '2024-04-21 23:02:55', '2024-04-22 01:52:21'),
(300, '05-085-0001', 'Jamuna Fertilizer Company Ltd', 'BULK', 'TGTDCL', 'SOD-North', 'Mymensingh', 24.683843, 89.828620, 6, '2024-04-22 00:06:44', '2024-04-22 01:52:46'),
(301, 'xxxx', 'Murapara DRS', 'DRS', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.784753, 90.521995, 6, '2024-04-22 00:26:17', '2024-04-22 00:26:17'),
(302, '04-035-0003', 'GPS Unit-6 210 MW', 'BULK', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.981072, 90.644776, 6, '2024-04-22 01:15:00', '2024-04-22 01:49:02'),
(303, '04-037-0028', 'Summit Meghnaghat-2 583 MW', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.611684, 90.593530, 6, '2024-04-22 01:37:25', '2024-04-22 01:50:41'),
(304, '04-037-0029', 'Unique Meghnaghat 584 MW', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.612431, 90.592114, 6, '2024-04-22 01:39:30', '2024-04-22 01:50:50'),
(305, '04-037-0030', 'Reliance Bangladesh LNG & Power Limited 718 MW', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.608578, 90.596073, 6, '2024-04-22 01:41:48', '2024-04-22 01:50:27'),
(306, '08-079-0177', 'Kamal Yarn Limited', 'BULK', 'TGTDCL', 'SOD-North', 'Gazipur', 24.303269, 90.390744, 6, '2024-04-22 02:00:25', '2024-04-22 02:00:25'),
(307, '08-037-0023', 'Delta Agro Food Ind Ltd', 'BULK', 'TGTDCL', 'SOD-South', 'Demra', 23.587499, 90.507571, 6, '2024-04-22 02:01:41', '2024-04-22 02:01:41'),
(308, '08-060-0203', 'Shah Fatehullah Textile', 'BULK', 'TGTDCL', 'SOD-South', 'Demra', 23.641762, 90.480716, 6, '2024-04-22 02:04:06', '2024-04-22 02:04:06'),
(309, '08-032-1031', 'Talha Fabrics Ltd', 'BULK', 'TGTDCL', 'SOD-North', 'Gazipur', 24.086935, 90.360011, 6, '2024-04-22 02:05:46', '2024-04-22 02:05:46'),
(310, '08-037-0656', 'Dhaka Salt and Chemicals Ltd', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.592724, 90.598235, 6, '2024-04-22 02:07:35', '2024-04-22 02:07:35'),
(311, '08-037-0543', 'Creative Paper Mills Ltd.', 'BULK', 'TGTDCL', 'SOD-South', 'Sonargaon', 23.762458, 90.510821, 6, '2024-04-22 02:09:51', '2024-04-22 02:09:51'),
(312, 'xxxx', 'Shahbazpur (South) VS', 'VS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 24.043049, 91.164342, 6, '2024-04-22 22:27:34', '2024-08-18 01:33:30'),
(313, 'xxxx', 'SPAR-2 VS', 'VS', 'TGTDCL', 'SOD-South', 'Brahmanbaria', 24.035931, 90.999659, 6, '2024-04-22 22:34:19', '2024-04-22 22:47:48'),
(314, 'xxxx', 'Shibpur VS', 'VS', 'TGTDCL', 'SOD-South', 'Ghorashal', 24.045034, 90.727553, 6, '2024-04-22 22:36:31', '2024-04-22 22:45:44'),
(315, 'xxxx', 'GPF VS', 'VS', 'TGTDCL', 'SOD-South', 'Ghorashal', 23.986463, 90.641300, 6, '2024-04-22 22:44:37', '2024-04-22 22:44:37'),
(316, 'xxxx', 'Monohordi VS', 'VS', 'TGTDCL', 'SOD-South', 'Ghorashal', 24.132031, 90.703058, 6, '2024-04-22 22:46:57', '2024-04-22 22:46:57');

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

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

--
-- Indexes for table `diagrams`
--
ALTER TABLE `diagrams`
  ADD PRIMARY KEY (`id`),
  ADD KEY `diagrams_station_id_foreign` (`station_id`);

--
-- Indexes for table `documents`
--
ALTER TABLE `documents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `documents_user_id_foreign` (`user_id`);

--
-- Indexes for table `drawings`
--
ALTER TABLE `drawings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `drawings_user_id_foreign` (`user_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `issues`
--
ALTER TABLE `issues`
  ADD PRIMARY KEY (`id`),
  ADD KEY `issues_user_id_foreign` (`user_id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

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

--
-- Indexes for table `login_histories`
--
ALTER TABLE `login_histories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `login_histories_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `options`
--
ALTER TABLE `options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `options_user_id_foreign` (`user_id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cpstations`
--
ALTER TABLE `cpstations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=239;

--
-- AUTO_INCREMENT for table `customer_infos`
--
ALTER TABLE `customer_infos`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13423;

--
-- AUTO_INCREMENT for table `diagrams`
--
ALTER TABLE `diagrams`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=214;

--
-- AUTO_INCREMENT for table `documents`
--
ALTER TABLE `documents`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `drawings`
--
ALTER TABLE `drawings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `issues`
--
ALTER TABLE `issues`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `line_colors`
--
ALTER TABLE `line_colors`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `login_histories`
--
ALTER TABLE `login_histories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `options`
--
ALTER TABLE `options`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=389;

--
-- AUTO_INCREMENT for table `stations`
--
ALTER TABLE `stations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=319;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `diagrams`
--
ALTER TABLE `diagrams`
  ADD CONSTRAINT `diagrams_station_id_foreign` FOREIGN KEY (`station_id`) REFERENCES `stations` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `documents`
--
ALTER TABLE `documents`
  ADD CONSTRAINT `documents_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `drawings`
--
ALTER TABLE `drawings`
  ADD CONSTRAINT `drawings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `issues`
--
ALTER TABLE `issues`
  ADD CONSTRAINT `issues_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `login_histories`
--
ALTER TABLE `login_histories`
  ADD CONSTRAINT `login_histories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `options`
--
ALTER TABLE `options`
  ADD CONSTRAINT `options_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

