INSERT INTO `number_plan` VALUES (999982,'09678999981','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee'),(999983,'09678999982','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee'),(999984,'09678999983','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee'),(999985,'09678999984','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee'),(999986,'09678999985','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee'),(999987,'09678999986','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee'),(999988,'09678999987','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee'),(999989,'09678999988','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee'),(999990,'09678999989','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee'),(999991,'09678999990','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee'),(999992,'09678999991','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee'),(999993,'09678999992','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee'),(999994,'09678999993','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee'),(999995,'09678999994','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee'),(999996,'09678999995','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee'),(999997,'09678999996','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee'),(999998,'09678999997','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee'),(999999,'09678999998','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee'),(1000000,'09678999999','reserved',NULL,'Reserved for Dial App','Hold','Link3 Employee');

--
-- Table structure for table `number_plan_test`
--

CREATE TABLE `number_plan_test` (
  `nu_id` int(11) NOT NULL AUTO_INCREMENT,
  `number` varchar(11) NOT NULL,
  `status` enum('free','reserved','assigned') NOT NULL DEFAULT 'free',
  `service_order` varchar(100) DEFAULT NULL,
  `customer` varchar(250) DEFAULT NULL,
  `category` enum('Titanium','Platinum','Gold','Silver','Hold') NOT NULL DEFAULT 'Hold',
  `remark` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`nu_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `number_plan_test`
--


--
-- Table structure for table `operator_bill`
--

CREATE TABLE `operator_bill` (
  `op_bill_id` int(11) NOT NULL AUTO_INCREMENT,
  `year` int(11) NOT NULL,
  `month` int(11) NOT NULL,
  `operator` varchar(100) NOT NULL,
  `softex` varchar(200) NOT NULL,
  `s_count` int(10) NOT NULL,
  `mnh` varchar(200) NOT NULL,
  `m_count` int(10) NOT NULL,
  `BTCL` varchar(200) NOT NULL,
  `b_count` int(10) NOT NULL,
  `total_minutes` varchar(200) NOT NULL,
  `revenue` varchar(200) NOT NULL,
  `revenue_vat` varchar(200) NOT NULL,
  PRIMARY KEY (`op_bill_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `operator_bill`
--


--
-- Table structure for table `operator_bill_mnp`
--

CREATE TABLE `operator_bill_mnp` (
  `op_bill_id` int(11) NOT NULL AUTO_INCREMENT,
  `year` int(11) NOT NULL,
  `month` int(11) NOT NULL,
  `operator` varchar(100) NOT NULL,
  `softex` varchar(200) NOT NULL,
  `s_count` int(10) NOT NULL,
  `mnh` varchar(200) NOT NULL,
  `m_count` int(10) NOT NULL,
  `BTCL` varchar(200) NOT NULL,
  `b_count` int(10) NOT NULL,
  `total_minutes` varchar(200) NOT NULL,
  `revenue` varchar(200) NOT NULL,
  `revenue_vat` varchar(200) NOT NULL,
  PRIMARY KEY (`op_bill_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `operator_bill_mnp`
--


--
-- Table structure for table `operator_info`
--

CREATE TABLE `operator_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `operator_name` varchar(200) DEFAULT NULL,
  `operator_address` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `operator_info`
--

INSERT INTO `operator_info` VALUES (1,'Teletalk','Name: Teletalk Bangladesh Ltd. <br> Atten: GM, Finance And Accounts <br> Address: Rajuk Commercial Complex, Holding # 3/A, 5/A, 7/A, Road # 17, Gulshan-1'),(2,'Airtel','Name: Robi Axiata  Limited (Airtel) <br> Atten: Md. Altafur Rahman (FAMR|Finance) <br> Address: 53 Gulshan South Avenue, Gulshan-1 <br> BIN: 0000001780101'),(3,'GP','Name: GrameenPhone Ltd. <br> Atten: Mohammed Atahar Ali (GM,Finance) <br> Address: GP House Bashundhara, Baridhara, Dhaka-1229 <br> BIN : 000000081-0001'),(4,'Robi','Name: Robi Axiata  Limited <br> Atten: Md. Altafur Rahman (FAMR|Finance) <br> Address: 53 Gulshan South Avenue, Gulshan-1 <br> BIN: 0000001780101'),(5,'Banglalink','Name: Banglalink Digital Communication Limited<br> Att: Revenue Operation Management. <br> Address: Tigers Den, House 4 (SWH), Bir Uttam Mir Shawkat Sharak, Gulshan-1 <br> BIN : 000000036-0101'),(8,'BTCL','Name : Bangladesh Telecommunication Company Limited <br> Attention: Deputy General Manager (F & R) <br> Address : Korail, Banani, Dhaka.');

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `payid` int(11) NOT NULL AUTO_INCREMENT,
  `datetime` datetime DEFAULT NULL,
  `customerid` varchar(20) DEFAULT NULL,
  `platform` varchar(20) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `insert_by` varchar(20) DEFAULT NULL,
  `remarks` longtext DEFAULT NULL,
  PRIMARY KEY (`payid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `payment`
--


--
-- Table structure for table `service_order`
--

CREATE TABLE `service_order` (
  `so_id` int(11) NOT NULL AUTO_INCREMENT,
  `client_name` varchar(50) NOT NULL,
  `client_site_name` varchar(200) DEFAULT NULL,
  `tki_id` varchar(255) NOT NULL,
  `client_id` varchar(255) NOT NULL,
  `service_order_date` date NOT NULL,
  `target_date` date NOT NULL,
  `customer_type` varchar(50) NOT NULL,
  `subscription_type` varchar(50) NOT NULL,
  `site_address` varchar(150) NOT NULL,
  `billing_address` varchar(150) NOT NULL,
  `zone` varchar(50) NOT NULL,
  `hardware_otc` int(11) NOT NULL DEFAULT 0,
  `OTC` int(11) NOT NULL DEFAULT 0,
  `MRC` int(11) NOT NULL DEFAULT 0,
  `credit_limit` int(11) NOT NULL DEFAULT 0,
  `DID` varchar(500) NOT NULL,
  `number_quantity` int(11) NOT NULL,
  `channel` int(11) NOT NULL,
  `domestic_rate` varchar(10) NOT NULL,
  `domestic_pulse` varchar(10) NOT NULL,
  `international_pulse` int(11) NOT NULL,
  `call_type` enum('NWD','ISD') DEFAULT NULL,
  `bill_date` int(11) NOT NULL,
  `id_client` varchar(500) NOT NULL,
  `subscription_form` varchar(200) DEFAULT NULL,
  `bill_from` enum('id','did','reseller') NOT NULL DEFAULT 'id',
  `access_engineer` varchar(50) NOT NULL,
  `remark` varchar(250) DEFAULT NULL,
  `commission_date` date NOT NULL,
  `job_done_report` varchar(200) DEFAULT NULL,
  `status` enum('Active','Locked','Temporary Stopped','Terminate') NOT NULL,
  `SIP` enum('Proxy','Trunk') NOT NULL DEFAULT 'Proxy',
  `client_name_bill` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`so_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1093 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `service_order`
--

INSERT INTO `service_order` VALUES (80,'87','Dhaka Bank Limited_Companigonj Branch','https://office.link3.net/mis2/ClientSide/modules/workflow/PreSales/ReplyIns.aspx?invoiceno=a','12157','2016-09-28','2016-09-28','Corporate','Postpaid','Dhaka Bank Limited_Companigonj Branch, Comilla','Dhaka Bank Limited_Companigonj Branch','South - East',0,0,100,0,'09678543543',2,2,'40','1',60,'ISD',1,'26',NULL,'id','K M Muminul Haque',NULL,'2016-09-28',NULL,'Active','Proxy','Dhaka Bank Ltd.'),(1092,'87','Dhaka Bank Meherpur Branch','12131546','6465456456','2022-12-11','2022-12-20','Corporate','Prepaid','fdsafsdf, Dhaka','asdasd, Dhaka','Central Zone',0,0,100,500,'09678123123',1,1,'40','1',60,'NWD',1,'65',NULL,'id','MD Salekin Ferdouas','565656','2022-12-11',NULL,'Active','Proxy',NULL);

--
-- Table structure for table `service_order_website`
--

CREATE TABLE `service_order_website` (
  `web_so_id` int(11) NOT NULL AUTO_INCREMENT,
  `client_name` varchar(50) NOT NULL,
  `website_url` varchar(200) DEFAULT NULL,
  `ip_address` varchar(150) NOT NULL,
  `platform` varchar(50) DEFAULT NULL,
  `service_order_no` varchar(150) NOT NULL,
  `service_order_date` date NOT NULL,
  `target_date` date NOT NULL,
  `customer_type` varchar(50) NOT NULL,
  `site_address` varchar(150) NOT NULL,
  `billing_address` varchar(150) NOT NULL,
  `access_engineer` tinyint(4) DEFAULT NULL,
  `OTC` int(11) NOT NULL,
  `MRC` int(11) NOT NULL DEFAULT 0,
  `bill_date` int(11) NOT NULL,
  `remark` varchar(250) DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `technical_info` text DEFAULT NULL,
  PRIMARY KEY (`web_so_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `service_order_website`
--


--
-- Table structure for table `softex_igw_invoice_amount`
--

CREATE TABLE `softex_igw_invoice_amount` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `operator` varchar(50) DEFAULT NULL,
  `bill_amount` varchar(200) DEFAULT NULL,
  `due` varchar(200) DEFAULT NULL,
  `total_due` varchar(200) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `month` int(11) DEFAULT NULL,
  `year` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `softex_igw_invoice_amount`
--


--
-- Table structure for table `softex_invoice_address`
--

CREATE TABLE `softex_invoice_address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `operator` varchar(50) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `operator_name` varchar(100) DEFAULT NULL,
  `ref` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `softex_invoice_address`
--


--
-- Table structure for table `softex_invoice_amount`
--

CREATE TABLE `softex_invoice_amount` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `operator` varchar(50) DEFAULT NULL,
  `bill_amount` varchar(200) DEFAULT NULL,
  `due` varchar(200) DEFAULT NULL,
  `total_due` varchar(200) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `month` int(11) DEFAULT NULL,
  `year` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `softex_invoice_amount`
--


--
-- Table structure for table `softex_iog_invoice_amount`
--

CREATE TABLE `softex_iog_invoice_amount` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `operator_iog` varchar(50) DEFAULT NULL,
  `bill_amount` varchar(200) DEFAULT NULL,
  `due` varchar(200) DEFAULT NULL,
  `total_due` varchar(200) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `month` int(11) DEFAULT NULL,
  `year` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `softex_iog_invoice_amount`
--


--
-- Table structure for table `tbl_ritt_recharge_verification`
--

CREATE TABLE `tbl_ritt_recharge_verification` (
  `sl` int(10) NOT NULL AUTO_INCREMENT,
  `account_id` varchar(20) DEFAULT NULL,
  `phone_no` varchar(13) NOT NULL,
  `phone_type` varchar(10) NOT NULL,
  `req_amount` int(10) NOT NULL,
  `prev_amount` float DEFAULT NULL,
  `reference` varchar(50) NOT NULL,
  `reference_time` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` char(10) NOT NULL DEFAULT 'U',
  `ssl_response_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `transaction_id` varchar(50) DEFAULT NULL,
  `service_type` varchar(30) DEFAULT NULL,
  `verify_ip_address` varchar(50) DEFAULT NULL,
  `recharge_ip_address` varchar(20) DEFAULT NULL,
  `current_balance` float DEFAULT NULL,
  PRIMARY KEY (`reference`),
  UNIQUE KEY `transaction_id` (`transaction_id`),
  KEY `sl` (`sl`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_ritt_recharge_verification`
--


--
-- Table structure for table `tbl_ritt_successfull_recharge`
--

CREATE TABLE `tbl_ritt_successfull_recharge` (
  `sl` int(10) NOT NULL AUTO_INCREMENT,
  `account_id` varchar(30) DEFAULT NULL,
  `phone_no` varchar(11) NOT NULL,
  `phone_type` char(8) NOT NULL,
  `prev_amount` float DEFAULT NULL,
  `recharge_amount` int(10) NOT NULL,
  `current_balance` float DEFAULT NULL,
  `ssl_transaction_id` varchar(50) NOT NULL,
  `reference_number` varchar(50) NOT NULL,
  `ssl_response_time` timestamp NOT NULL DEFAULT current_timestamp(),
  `recharge_status` varchar(5) DEFAULT 'N',
  `recharge_time` datetime DEFAULT '0000-00-00 00:00:00',
  `service_type` varchar(20) DEFAULT NULL,
  `ip_address` varchar(30) DEFAULT NULL,
  `contact_number` varchar(20) DEFAULT NULL,
  `sms_notify` varchar(5) DEFAULT 'N',
  PRIMARY KEY (`ssl_transaction_id`),
  KEY `sl` (`sl`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_ritt_successfull_recharge`
--


--
-- Table structure for table `test_number`
--

CREATE TABLE `test_number` (
  `testnumber` varchar(100) NOT NULL DEFAULT '',
  `check_number` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `test_number`
--

INSERT INTO `test_number` VALUES ('016596',NULL),('09617000017',NULL),('09617000100',NULL),('09617000200',NULL),('09617000442',NULL),('09617000444',NULL),('09617000555',NULL),('09617000666',NULL),('09617000800',NULL),('09617001103',NULL),('09617001106',NULL),('09617001112',NULL),('09617001118',NULL),('09617001119',NULL),('09617001120',NULL),('09617001122',NULL),('09617001123',NULL),('09617001124',NULL),('09617001125',NULL),('09617001126',NULL),('09617001127',NULL),('09617001128',NULL),('09617001129',NULL),('09617001130',NULL),('09617001131',NULL),('09617001132',NULL),('09617001133',NULL),('09617001134',NULL),('09617001135',NULL),('09617001136',NULL),('09617001137',NULL),('09617001138',NULL),('09617001139',NULL),('09617001140',NULL),('09617001141',NULL),('09617001142',NULL),('09617001143',NULL),('09617001144',NULL),('09617001145',NULL),('09617001146',NULL),('09617001147',NULL),('09617001148',NULL),('09617001149',NULL),('09617001150',NULL),('09617001151',NULL),('09617001152',NULL),('09617001153',NULL),('09617001154',NULL),('09617001155',NULL),('09617001156',NULL),('09617001157',NULL),('09617001158',NULL),('09617001159',NULL),('09617001160',NULL),('09617001161',NULL),('09617001162',NULL),('09617001163',NULL),('09617001164',NULL),('09617001165',NULL),('09617001166',NULL),('09617001167',NULL),('09617001168',NULL),('09617001169',NULL),('09617001170',NULL),('09617001171',NULL),('09617001172',NULL),('09617001173',NULL),('09617001174',NULL),('09617001175',NULL),('09617001176',NULL),('09617001300',NULL),('09617001301',NULL),('09617001343',NULL),('09617001400',NULL),('09617001401',NULL),('09617001418',NULL),('09617001450',NULL),('09617001466',NULL),('09617001477',NULL),('09617001501',NULL),('09617001520',NULL),('09617001524',NULL),('09617001543',NULL),('09617001560',NULL),('09617001562',NULL),('09617001566',NULL),('09617001574',NULL),('09617001580',NULL),('09617001593',NULL),('09617001600',NULL),('09617001614',NULL),('09617001620',NULL),('09617001633',NULL),('09617001640',NULL),('09617001641',NULL),('09617001660',NULL),('09617001668',NULL),('09617001681',NULL),('09617001683',NULL),('09617001690',NULL),('09617001703',NULL),('09617001722',NULL),('09617001765',NULL),('09617001783',NULL),('09617001800',NULL),('09617001815',NULL),('09617001860',NULL),('09617002015',NULL),('09617002100',NULL),('09617002101',NULL),('09617003003',NULL),('09617003100',NULL),('09617006100',NULL),('09617006101',NULL),('09617007000',NULL),('09617007007',NULL),('09617009101',NULL),('09617010100',NULL),('09617011100',NULL),('09617012101',NULL),('09617013101',NULL),('09617015101',NULL),('09617016205',NULL),('09617016579',NULL),('09617017100',NULL),('09617017101',NULL),('09617018100',NULL),('09617019101',NULL),('09617023101',NULL),('09617024101',NULL),('09617025101',NULL),('09617026101',NULL),('09617027100',NULL),('09617027101',NULL),('09617028100',NULL),('09617028101',NULL),('09617030101',NULL),('09617031100',NULL),('09617032101',NULL),('09617034101',NULL),('09617036101',NULL),('09617037101',NULL),('09617038100',NULL),('09617038101',NULL),('09617040100',NULL),('09617040101',NULL),('09617041101',NULL),('09617043101',NULL),('09617043448',NULL),('09617045100',NULL),('09617045101',NULL),('09617046100',NULL),('09617046101',NULL),('09617047101',NULL),('09617048101',NULL),('09617049100',NULL),('09617049101',NULL),('09617050101',NULL),('09617051101',NULL),('09617052100',NULL),('09617052101',NULL),('09617053100',NULL),('09617053101',NULL),('09617054101',NULL),('09617055101',NULL),('09617056156',NULL),('09617057101',NULL),('09617058101',NULL),('09617059101',NULL),('09617060101',NULL),('09617061101',NULL),('09617063101',NULL),('09617064100',NULL),('09617065100',NULL),('09617065101',NULL),('09617066101',NULL),('09617067100',NULL),('09617067101',NULL),('09617068101',NULL),('09617070100',NULL),('09617071101',NULL),('09617073101',NULL),('09617074100',NULL),('09617076101',NULL),('09617077100',NULL),('09617077101',NULL),('09617078101',NULL),('09617079101',NULL),('09617080100',NULL),('09617080101',NULL),('09617081101',NULL),('09617084100',NULL),('09617084101',NULL),('09617085100',NULL),('09617085101',NULL),('09617085120',NULL),('09617087101',NULL),('09617087550',NULL),('09617088101',NULL),('09617089100',NULL),('09617090084',NULL),('09617090101',NULL),('09617096160',NULL),('09617096180',NULL),('09617099788',NULL),('09617100100',NULL),('09617102100',NULL),('09617103100',NULL),('09617104100',NULL),('09617104101',NULL),('09617105100',NULL),('09617106100',NULL),('09617106101',NULL),('09617107100',NULL),('09617107101',NULL),('09617107107',NULL),('09617108100',NULL),('09617110011',NULL),('09617110100',NULL),('09617111100',NULL),('09617111101',NULL),('09617111555',NULL),('09617111888',NULL),('09617112100',NULL),('09617112101',NULL),('09617112211',NULL),('09617112217',NULL),('09617112218',NULL),('09617112222',NULL),('09617112235',NULL),('09617112238',NULL),('09617112239',NULL),('09617112241',NULL),('09617112247',NULL),('09617112248',NULL),('09617112251',NULL),('09617112253',NULL),('09617112257',NULL),('09617112258',NULL),('09617112260',NULL),('09617112261',NULL),('09617112265',NULL),('09617112266',NULL),('09617112270',NULL),('09617112271',NULL),('09617112277',NULL),('09617112286',NULL),('09617112300',NULL),('09617112303',NULL),('09617112304',NULL),('09617112305',NULL),('09617112306',NULL),('09617112323',NULL),('09617112324',NULL),('09617112330',NULL),('09617112331',NULL),('09617112332',NULL),('09617112333',NULL),('09617112352',NULL),('09617113100',NULL),('09617113101',NULL),('09617113300',NULL),('09617114100',NULL),('09617115100',NULL),('09617116100',NULL),('09617116101',NULL),('09617117100',NULL),('09617117101',NULL),('09617118100',NULL),('09617118101',NULL),('09617119100',NULL),('09617119101',NULL),('09617120100',NULL),('09617120101',NULL),('09617121100',NULL),('09617122100',NULL),('09617123100',NULL),('09617123101',NULL),('09617124100',NULL),('09617124101',NULL),('09617125100',NULL),('09617125101',NULL),('09617126100',NULL),('09617127100',NULL),('09617128100',NULL),('09617128101',NULL),('09617146148',NULL),('09617150150',NULL),('09617151151',NULL),('09617161504',NULL),('09617167016',NULL),('09617170170',NULL),('09617171007',NULL),('09617171015',NULL),('09617171025',NULL),('09617171026',NULL),('09617171090',NULL),('09617171093',NULL),('09617171096',NULL),('09617171097',NULL),('09617171107',NULL),('09617171109',NULL),('09617171110',NULL),('09617171111',NULL),('09617171112',NULL),('09617171113',NULL),('09617171114',NULL),('09617171115',NULL),('09617171116',NULL),('09617171124',NULL),('09617171125',NULL),('09617171133',NULL),('09617171137',NULL),('09617171138',NULL),('09617171139',NULL),('09617171140',NULL),('09617171141',NULL),('09617171142',NULL),('09617171144',NULL),('09617171149',NULL),('09617171150',NULL),('09617171152',NULL),('09617171154',NULL),('09617171155',NULL),('09617171157',NULL),('09617171158',NULL),('09617171170',NULL),('09617171171',NULL),('09617171172',NULL),('09617171173',NULL),('09617171174',NULL),('09617171175',NULL),('09617171176',NULL),('09617171179',NULL),('09617171190',NULL),('09617171193',NULL),('09617171194',NULL),('09617171196',NULL),('09617171230',NULL),('09617171234',NULL),('09617171250',NULL),('09617171251',NULL),('09617171275',NULL),('09617171283',NULL),('09617171285',NULL),('09617171288',NULL),('09617171289',NULL),('09617171290',NULL),('09617171310',NULL),('09617171350',NULL),('09617171380',NULL),('09617171381',NULL),('09617171382',NULL),('09617171383',NULL),('09617171384',NULL),('09617171385',NULL),('09617171387',NULL),('09617171388',NULL),('09617171418',NULL),('09617171441',NULL),('09617171444',NULL),('09617171611',NULL),('09617171701',NULL),('09617171702',NULL),('09617171711',NULL),('09617171712',NULL),('09617171717',NULL),('09617171819',NULL),('09617171820',NULL),('09617171821',NULL),('09617171822',NULL),('09617171850',NULL),('09617171971',NULL),('09617172727',NULL),('09617173001',NULL),('09617173003',NULL),('09617173004',NULL),('09617173005',NULL),('09617173006',NULL),('09617173007',NULL),('09617173009',NULL),('09617173010',NULL),('09617173011',NULL),('09617173012',NULL),('09617173013',NULL),('09617173014',NULL),('09617173016',NULL),('09617173018',NULL),('09617173102',NULL),('09617173105',NULL),('09617173106',NULL),('09617173107',NULL),('09617173109',NULL),('09617173111',NULL),('09617173113',NULL),('09617173770',NULL),('09617175001',NULL),('09617175002',NULL),('09617175003',NULL),('09617175006',NULL),('09617175058',NULL),('09617175068',NULL),('09617175101',NULL),('09617175102',NULL),('09617175104',NULL),('09617175107',NULL),('09617175555',NULL),('09617175605',NULL),('09617175708',NULL),('09617176003',NULL),('09617176004',NULL),('09617176005',NULL),('09617176006',NULL),('09617176033',NULL),('09617176035',NULL),('09617176037',NULL),('09617181818',NULL),('09617212121',NULL),('09617220022',NULL),('09617222444',NULL),('09617222445',NULL),('09617222555',NULL),('09617223311',NULL),('09617223322',NULL),('09617223344',NULL),('09617223360',NULL),('09617224466',NULL),('09617224467',NULL),('09617224468',NULL),('09617225588',NULL),('09617246246',NULL),('09617282828',NULL),('09617284777',NULL),('096172847777',NULL),('09617300400',NULL),('09617300700',NULL),('09617300800',NULL),('09617305618',NULL),('09617330330',NULL),('09617333000',NULL),('09617333402',NULL),('09617333406',NULL),('09617333410',NULL),('09617333411',NULL),('09617333415',NULL),('09617333416',NULL),('09617333425',NULL),('09617333435',NULL),('09617333436',NULL),('09617333440',NULL),('09617333441',NULL),('09617333445',NULL),('09617333446',NULL),('09617333455',NULL),('09617333465',NULL),('09617333466',NULL),('09617333471',NULL),('09617333476',NULL),('09617333480',NULL),('09617333481',NULL),('09617333485',NULL),('09617333486',NULL),('09617333490',NULL),('09617333491',NULL),('09617333495',NULL),('09617333496',NULL),('09617333500',NULL),('09617333515',NULL),('09617333516',NULL),('09617333520',NULL),('09617333521',NULL),('09617333522',NULL),('09617333523',NULL),('09617333530',NULL),('09617333531',NULL),('09617333536',NULL),('09617333540',NULL),('09617333545',NULL),('09617333546',NULL),('09617333550',NULL),('09617333551',NULL),('09617333557',NULL),('09617333560',NULL),('09617333561',NULL),('09617333562',NULL),('09617333566',NULL),('09617333575',NULL),('09617333576',NULL),('09617333578',NULL),('09617333586',NULL),('09617333590',NULL),('09617333591',NULL),('09617333601',NULL),('09617333605',NULL),('09617333606',NULL),('09617333608',NULL),('09617333609',NULL),('09617333610',NULL),('09617333613',NULL),('09617333614',NULL),('09617333616',NULL),('09617333621',NULL),('09617333625',NULL),('09617333627',NULL),('09617333628',NULL),('09617333629',NULL),('09617333631',NULL),('09617333632',NULL),('09617333633',NULL),('09617333635',NULL),('09617333636',NULL),('09617333639',NULL),('09617333642',NULL),('09617333644',NULL),('09617333645',NULL),('09617333647',NULL),('09617333648',NULL),('09617333649',NULL),('09617333650',NULL),('09617333999',NULL),('09617334702',NULL),('09617334703',NULL),('09617334704',NULL),('09617334720',NULL),('09617334721',NULL),('09617386784',NULL),('09617400500',NULL),('09617404040',NULL),('09617410018',NULL),('09617410061',NULL),('09617410108',NULL),('09617410110',NULL),('09617410111',NULL),('09617410129',NULL),('09617410130',NULL),('09617410133',NULL),('09617410178',NULL),('09617410271',NULL),('09617410431',NULL),('09617410495',NULL),('09617410786',NULL),('09617410801',NULL),('09617410888',NULL),('09617410901',NULL),('09617410902',NULL),('09617410903',NULL),('09617410904',NULL),('09617410905',NULL),('09617410906',NULL),('09617410907',NULL),('09617410908',NULL),('09617410909',NULL),('09617410910',NULL),('09617410911',NULL),('09617410912',NULL),('09617410913',NULL),('09617410914',NULL),('09617410915',NULL),('09617410916',NULL),('09617410917',NULL),('09617410918',NULL),('09617410919',NULL),('09617410920',NULL),('09617410921',NULL),('09617410922',NULL),('09617410923',NULL),('09617410924',NULL),('09617410925',NULL),('09617410926',NULL),('09617410927',NULL),('09617410928',NULL),('09617410929',NULL),('09617410930',NULL),('09617410999',NULL),('09617443355',NULL),('09617444000',NULL),('09617444111',NULL),('09617444222',NULL),('09617444444',NULL),('09617444555',NULL),('09617444777',NULL),('09617444999',NULL),('09617445006',NULL),('09617445008',NULL),('09617445009',NULL),('09617445010',NULL),('09617445011',NULL),('09617445012',NULL),('09617445014',NULL),('09617445016',NULL),('09617445018',NULL),('09617445019',NULL),('09617445021',NULL),('09617445022',NULL),('09617445024',NULL),('09617445026',NULL),('09617445030',NULL),('09617445031',NULL),('09617445032',NULL),('09617445033',NULL),('09617445034',NULL),('09617445035',NULL),('09617445036',NULL),('09617445039',NULL),('09617445041',NULL),('09617445044',NULL),('09617445045',NULL),('09617445046',NULL),('09617445047',NULL),('09617445048',NULL),('09617445049',NULL),('09617445050',NULL),('09617445051',NULL),('09617445052',NULL),('09617445054',NULL),('09617445062',NULL),('09617445063',NULL),('09617445064',NULL),('09617445065',NULL),('09617445067',NULL),('09617445068',NULL),('09617445069',NULL),('09617445071',NULL),('09617445074',NULL),('09617445075',NULL),('09617445077',NULL),('09617445079',NULL),('09617445080',NULL),('09617445081',NULL),('09617445082',NULL),('09617445083',NULL),('09617445085',NULL),('09617445086',NULL),('09617445089',NULL),('09617445090',NULL),('09617445092',NULL),('09617445093',NULL),('09617445096',NULL),('09617445098',NULL),('09617445100',NULL),('09617445101',NULL),('09617445102',NULL),('09617445103',NULL),('09617445105',NULL),('09617445106',NULL),('09617445107',NULL),('09617445108',NULL),('09617445109',NULL),('09617445110',NULL),('09617445111',NULL),('09617445113',NULL),('09617445114',NULL),('09617445115',NULL),('09617445118',NULL),('09617445120',NULL),('09617445122',NULL),('09617445123',NULL),('09617445125',NULL),('09617445126',NULL),('09617445127',NULL),('09617445129',NULL),('09617445130',NULL),('09617445131',NULL),('09617445137',NULL),('09617445139',NULL),('09617445140',NULL),('09617445142',NULL),('09617445144',NULL),('09617445148',NULL),('09617445149',NULL),('09617445150',NULL),('09617445151',NULL),('09617445155',NULL),('09617445156',NULL),('09617445158',NULL),('09617445161',NULL),('09617445162',NULL),('09617445163',NULL),('09617445164',NULL),('09617445168',NULL),('09617445169',NULL),('09617445170',NULL),('09617445171',NULL),('09617445172',NULL),('09617445173',NULL),('09617445174',NULL),('09617445175',NULL),('09617445176',NULL),('09617445177',NULL),('09617445178',NULL),('09617445179',NULL),('09617445180',NULL),('09617445181',NULL),('09617445184',NULL),('09617445185',NULL),('09617445187',NULL),('09617445188',NULL),('09617445189',NULL),('09617445191',NULL),('09617445192',NULL),('09617445193',NULL),('09617445200',NULL),('09617445204',NULL),('09617445205',NULL),('09617445207',NULL),('09617445208',NULL),('09617445209',NULL),('09617445211',NULL),('09617445212',NULL),('09617445213',NULL),('09617445214',NULL),('09617445215',NULL),('09617445216',NULL),('09617445217',NULL),('09617445218',NULL),('09617445219',NULL),('09617445220',NULL),('09617445223',NULL),('09617445225',NULL),('09617445226',NULL),('09617445229',NULL),('09617445231',NULL),('09617445232',NULL),('09617445233',NULL),('09617445234',NULL),('09617445235',NULL),('09617445236',NULL),('09617445238',NULL),('09617445243',NULL),('09617445244',NULL),('09617445245',NULL),('09617445246',NULL),('09617445247',NULL),('09617445249',NULL),('09617446688',NULL),('09617454545',NULL),('09617456239',NULL),('09617456242',NULL),('09617494916',NULL),('09617500500',NULL),('09617502502',NULL),('09617506070',NULL),('09617530358',NULL),('09617550550',NULL),('09617555111',NULL),('09617555121',NULL),('09617555555',NULL),('09617555777',NULL),('09617555888',NULL),('09617555999',NULL),('09617578493',NULL),('09617581136',NULL),('09617600700',NULL),('09617600900',NULL),('09617606061',NULL),('09617612552',NULL),('09617616326',NULL),('09617617617',NULL),('09617617618',NULL),('09617654321',NULL),('09617654958',NULL),('09617666111',NULL),('09617666222',NULL),('09617667788',NULL),('09617707707',NULL),('09617711330',NULL),('09617711333',NULL),('09617711334',NULL),('09617711335',NULL),('09617716205',NULL),('09617717171',NULL),('09617717173',NULL),('09617717174',NULL),('09617745745',NULL),('09617749772',NULL),('09617766550',NULL),('09617766551',NULL),('09617766552',NULL),('09617766553',NULL),('09617766555',NULL),('09617771888',NULL),('09617774444',NULL),('09617775555',NULL),('09617776243',NULL),('09617776661',NULL),('09617777111',NULL),('09617777889',NULL),('09617778877',NULL),('09617786786',NULL),('09617786787',NULL),('09617816205',NULL),('09617844932',NULL),('09617865727',NULL),('09617878787',NULL),('09617888555',NULL),('09617888777',NULL),('09617888811',NULL),('09617893080',NULL),('09617900600',NULL),('09617901100',NULL),('09617901102',NULL),('09617903334',NULL),('09617904100',NULL),('09617904101',NULL),('09617905100',NULL),('09617906100',NULL),('09617906101',NULL),('09617906108',NULL),('09617907100',NULL),('09617908100',NULL),('09617909100',NULL),('09617909101',NULL),('09617909102',NULL),('09617909103',NULL),('09617909104',NULL),('09617909105',NULL),('09617909106',NULL),('09617909107',NULL),('09617909108',NULL),('09617909109',NULL),('09617909120',NULL),('09617909124',NULL),('09617909130',NULL),('09617909141',NULL),('09617909153',NULL),('09617909154',NULL),('09617909223',NULL),('09617910100',NULL),('09617910930',NULL),('09617911100',NULL),('09617911130',NULL),('09617912100',NULL),('09617913101',NULL),('09617914100',NULL),('09617915101',NULL),('09617916101',NULL),('09617916205',NULL),('09617917100',NULL),('09617951101',NULL),('09617953101',NULL),('09617954101',NULL),('09617955100',NULL),('09617955101',NULL),('09617956101',NULL),('09617958100',NULL),('09617958101',NULL),('09617959101',NULL),('09617960100',NULL),('09617961101',NULL),('09617962101',NULL),('09617999333',NULL),('09617999602',NULL),('','09617000100'),('','09617000555'),('','09617000666'),('','09617002015'),('','09617003003'),('','09617087550'),('','09617090084'),('','09617099788'),('','09617111555'),('','09617150150'),('','09617151151'),('','09617161504'),('','09617167016'),('','09617170170'),('','09617171015'),('','09617171109'),('','09617171193'),('','09617171230'),('','09617171234'),('','09617171250'),('','09617171251'),('','09617171275'),('','09617171283'),('','09617171285'),('','09617171288'),('','09617171289'),('','09617171290'),('','09617171418'),('','09617171441'),('','09617171611'),('','09617171702'),('','09617171711'),('','09617171712'),('','09617171717'),('','09617171850'),('','09617171971'),('','09617172727'),('','09617173770'),('','09617212121'),('','09617220022'),('','09617223360'),('','09617246246'),('','09617282828'),('','09617284777'),('','09617300400'),('','09617386784'),('','09617400500'),('','09617404040'),('','09617443355'),('','09617444000'),('','09617444111'),('','09617444555'),('','09617444999'),('','09617456239'),('','09617456242'),('','09617494916'),('','09617502502'),('','09617530358'),('','09617550550'),('','09617555888'),('','09617555999'),('','09617578493'),('','09617581136'),('','09617600700'),('','09617612552'),('','09617616326'),('','09617617618'),('','09617654321'),('','09617666111'),('','09617707707'),('','09617717171'),('','09617717173'),('','09617717174'),('','09617749772'),('','09617766550'),('','09617766551'),('','09617766552'),('','09617766553'),('','09617766555'),('','09617771888'),('','09617774444'),('','09617776243'),('','09617776661'),('','09617777111'),('','09617777889'),('','09617778877'),('','09617786786'),('','09617786787'),('','09617844932'),('','09617878787'),('','09617888811');

--
-- Table structure for table `zone_list`
--

CREATE TABLE `zone_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `district` varchar(50) DEFAULT NULL,
  `zone` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `zone_list`
--

INSERT INTO `zone_list` VALUES (1,'chittagong','South - East'),(2,'coxsbazar','South - East'),(3,'noakhali','South - East'),(4,'comilla','South - East'),(5,'chadpur','South - East'),(6,'brahmanbaria','South - East'),(7,'barisal','South - West'),(8,'faridpur','South - West'),(9,'jessore','South - West'),(10,'satkhira','South - West'),(11,'madaripur','South - West'),(12,'kushtia','South - West'),(13,'rajbari','South - West'),(14,'gopalganj','South - West'),(15,'jhalkati','South - West'),(16,'jhenaidah','South - West'),(17,'chuadanga','South - West'),(18,'meherpur','South - West'),(19,'khulna','South - West'),(20,'shariatpur','South - West'),(21,'sylhet','North - East'),(22,'moulovibazar','North - East'),(23,'mymensingh','North - East'),(24,'kishoreganj','North - East'),(25,'habiganj','North - East'),(26,'tangail','North - East'),(27,'jamalpur','North - East'),(28,'dinajpur','North - West'),(29,'sirajganj','North - West'),(30,'rangpur','North - West'),(31,'rajshahi','North - West'),(32,'jaypurhat','North - West'),(33,'pabna','North - West'),(34,'gaibandha','North - West'),(35,'bogra','North - West'),(36,'dhaka','Central Zone'),(37,'chandpur','South - East'),(38,'narsingdi','North - East'),(39,'branch','Need to Check'),(40,'bagerhat','South - West'),(41,'narayanganj','Central Zone'),(42,'gazipur','Central Zone'),(43,'chattogram','South - East'),(44,'manikganj','North - East'),(45,'feni','South - East'),(46,'bhola','South - West'),(47,'munshiganj','North - East'),(48,'savar','Central Zone'),(49,'zinzira','Central Zone'),(50,'Tongi','Central Zone'),(51,'Lakshmipur','South - East'),(52,'khagrachari','South - East'),(53,'rangamati','South - East'),(54,'bandarban','South - East'),(55,'sunamganj','North - East'),(56,'Moulvi Bazar','North - East'),(57,'sherpur','North - East'),(58,'netrokona','North - East'),(59,'magura','South - West'),(60,'narail','South - West'),(61,'jhalakathi','South - West'),(62,'pirojpur','South - West'),(63,'barguna','South - West'),(64,'patuakhali','South - West'),(65,'gopalgonj','South - West'),(66,'panchagarh','North - West'),(67,'thakurgaon','North - West'),(68,'nilphamari','North - West'),(69,'lalmonirhat','North - West'),(70,'kurigram','North - West'),(71,'jaipurhat','North - West'),(72,'natore','North - West'),(73,'naogaon','North - West'),(74,'nawabganj','North - West'),(75,'cumilla','South - East');


