-- Table structure for table `organization_info` 


CREATE TABLE `organization_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `organization_name` varchar(100) DEFAULT NULL,
  `organization_phone` varchar(20) DEFAULT NULL,
  `organization_email` varchar(100) DEFAULT NULL,
  `copyright_year` varchar(4) DEFAULT NULL,
  `operator_id` varchar(4) DEFAULT NULL,
  `gift_amount` int(4) DEFAULT NULL,
  `administrator1` varchar(100) DEFAULT NULL,
  `is_show` int(1) DEFAULT '0',
  `phone1` varchar(15) DEFAULT NULL,
  `administrator2` varchar(100) DEFAULT NULL,
  `phone2` varchar(15) DEFAULT NULL,
  `logo` text,
  `icon` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

INSERT INTO `organization_info` (`id`,`organization_name`,`organization_phone`,`organization_email`,`copyright_year`,`operator_id`,`gift_amount`,`administrator1`,`is_show`,`phone1`,`administrator2`,`phone2`,`logo`,`icon`,`created_at`,`updated_at`,`parent_id`,`created_by`) VALUES 
(23,'Nexdecade Technology  Ltd','012313133333','no-reply@nexdecade.com','2015','1009',300,'Admin123',1,'0114542313','Admin457','0114542313','public/uploads/organization/logo.jpeg','public/uploads/organization/favicon.png','NULL','2016-06-16 10:35:25',1,1);

-- Table structure for table `ownership_transfers` 


CREATE TABLE `ownership_transfers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `old_id` int(11) DEFAULT NULL,
  `pairing_id` int(8) DEFAULT NULL,
  `subscriber_id` int(11) DEFAULT NULL,
  `lco_id` int(11) DEFAULT NULL,
  `stb_id` int(11) DEFAULT NULL,
  `card_id` int(11) DEFAULT NULL,
  `is_cas_pairing` tinyint(1) DEFAULT '0',
  `free_stb` tinyint(1) DEFAULT '0',
  `free_card` tinyint(1) DEFAULT '0',
  `free_subscription_fee` tinyint(1) DEFAULT '0',
  `remarks` text,
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `NewIndex1` (`subscriber_id`,`lco_id`,`stb_id`,`card_id`,`created_by`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

INSERT INTO `ownership_transfers` (`id`,`old_id`,`pairing_id`,`subscriber_id`,`lco_id`,`stb_id`,`card_id`,`is_cas_pairing`,`free_stb`,`free_card`,`free_subscription_fee`,`remarks`,`parent_id`,`created_by`,`created_at`,`updated_at`,`updated_by`) VALUES 
(1,53,1000055,416,1,127,66,0,1,1,0,'NULL',1,1,'2016-04-13 16:02:09','NULL',NULL),
(2,56,1000057,411,207,117,65,0,0,0,0,'NULL',207,207,'2016-04-13 16:22:53','NULL',NULL),
(3,53,1000068,370,1,127,66,0,1,1,0,'NULL',1,1,'2016-04-30 16:29:01','NULL',NULL),
(4,67,1000068,370,1,136,81,0,1,1,1,'NULL',1,1,'2016-04-30 16:29:02','NULL',NULL),
(5,6,1000070,341,207,93,39,0,0,0,0,'NULL',207,207,'2016-04-30 17:01:24','NULL',NULL),
(6,44,1000073,398,1,112,59,0,1,1,1,'NULL',1,507,'2016-05-02 14:49:40','NULL',NULL),
(7,6,1000075,339,207,93,39,0,0,0,0,'NULL',207,207,'2016-05-02 16:19:04','NULL',NULL),
(8,58,1000079,398,1,123,69,0,1,1,1,'NULL',1,1,'2016-05-03 12:25:27','NULL',NULL),
(9,69,1000080,343,207,95,42,0,0,0,0,'NULL',207,207,'2016-05-03 13:52:34','NULL',NULL),
(10,11,1000080,343,207,100,45,0,0,0,0,'NULL',207,207,'2016-05-03 13:52:34','NULL',NULL);

-- Table structure for table `package_programs` 


CREATE TABLE `package_programs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `package_id` int(11) NOT NULL,
  `program_id` int(11) NOT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_package_program_programs1_idx` (`package_id`),
  KEY `fk_package_program_packages1_idx` (`program_id`)
) ENGINE=InnoDB AUTO_INCREMENT=865 DEFAULT CHARSET=utf8;

INSERT INTO `package_programs` (`id`,`package_id`,`program_id`,`is_active`,`parent_id`,`created_by`,`created_at`,`updated_at`) VALUES 
(647,3,1,1,1,1,'2016-02-24 15:09:47','NULL'),
(648,3,2,1,1,1,'2016-02-24 15:09:47','NULL'),
(649,2,3,1,1,1,'2016-02-24 15:34:04','NULL'),
(650,2,4,1,1,1,'2016-02-24 15:34:04','NULL'),
(651,2,5,1,1,1,'2016-02-24 15:34:04','NULL'),
(652,2,8,1,1,1,'2016-02-24 15:34:04','NULL'),
(653,2,9,1,1,1,'2016-02-24 15:34:04','NULL'),
(654,2,10,1,1,1,'2016-02-24 15:34:04','NULL'),
(655,2,11,1,1,1,'2016-02-24 15:34:04','NULL'),
(656,2,12,1,1,1,'2016-02-24 15:34:04','NULL'),
(657,2,13,1,1,1,'2016-02-24 15:34:04','NULL'),
(658,2,14,1,1,1,'2016-02-24 15:34:04','NULL'),
(659,2,15,1,1,1,'2016-02-24 15:34:04','NULL'),
(660,2,16,1,1,1,'2016-02-24 15:34:04','NULL'),
(661,2,17,1,1,1,'2016-02-24 15:34:04','NULL'),
(662,2,18,1,1,1,'2016-02-24 15:34:04','NULL'),
(663,2,19,1,1,1,'2016-02-24 15:34:04','NULL'),
(664,2,20,1,1,1,'2016-02-24 15:34:04','NULL'),
(665,2,21,1,1,1,'2016-02-24 15:34:04','NULL'),
(666,2,22,1,1,1,'2016-02-24 15:34:04','NULL'),
(667,2,23,1,1,1,'2016-02-24 15:34:04','NULL'),
(668,2,24,1,1,1,'2016-02-24 15:34:04','NULL'),
(669,2,25,1,1,1,'2016-02-24 15:34:04','NULL'),
(670,2,26,1,1,1,'2016-02-24 15:34:04','NULL'),
(671,2,27,1,1,1,'2016-02-24 15:34:04','NULL'),
(672,2,28,1,1,1,'2016-02-24 15:34:04','NULL'),
(673,2,29,1,1,1,'2016-02-24 15:34:04','NULL'),
(674,2,30,1,1,1,'2016-02-24 15:34:04','NULL'),
(675,2,31,1,1,1,'2016-02-24 15:34:04','NULL'),
(676,2,32,1,1,1,'2016-02-24 15:34:04','NULL'),
(677,2,33,1,1,1,'2016-02-24 15:34:04','NULL'),
(678,2,34,1,1,1,'2016-02-24 15:34:04','NULL'),
(679,2,35,1,1,1,'2016-02-24 15:34:04','NULL'),
(680,2,36,1,1,1,'2016-02-24 15:34:04','NULL'),
(681,2,37,1,1,1,'2016-02-24 15:34:04','NULL'),
(682,2,38,1,1,1,'2016-02-24 15:34:04','NULL'),
(683,2,39,1,1,1,'2016-02-24 15:34:04','NULL'),
(684,2,40,1,1,1,'2016-02-24 15:34:04','NULL'),
(685,2,41,1,1,1,'2016-02-24 15:34:04','NULL'),
(686,2,42,1,1,1,'2016-02-24 15:34:04','NULL'),
(687,2,43,1,1,1,'2016-02-24 15:34:04','NULL'),
(688,2,44,1,1,1,'2016-02-24 15:34:04','NULL'),
(689,2,7,1,1,1,'2016-02-24 15:34:05','NULL'),
(690,4,1,1,1,1,'2016-02-24 15:43:09','NULL'),
(695,6,1,1,207,207,'2016-02-29 11:34:03','NULL'),
(696,6,2,1,207,207,'2016-02-29 11:34:03','NULL'),
(697,6,3,1,207,207,'2016-02-29 11:34:03','NULL'),
(698,6,4,1,207,207,'2016-02-29 11:34:03','NULL'),
(699,6,5,1,207,207,'2016-02-29 11:34:03','NULL'),
(700,6,6,1,207,207,'2016-02-29 11:34:03','NULL'),
(701,6,7,1,207,207,'2016-02-29 11:34:03','NULL'),
(702,1,6,1,1,1,'2016-03-05 16:19:59','NULL'),
(703,1,2,1,1,1,'2016-03-05 16:19:59','NULL'),
(704,1,5,1,1,1,'2016-03-05 16:19:59','NULL'),
(705,1,11,1,1,1,'2016-03-05 16:19:59','NULL'),
(815,21,2,1,1,507,'2016-05-02 12:27:58','NULL'),
(816,21,3,1,1,507,'2016-05-02 12:27:58','NULL'),
(817,21,4,1,1,507,'2016-05-02 12:27:58','NULL'),
(818,21,5,1,1,507,'2016-05-02 12:27:58','NULL'),
(819,21,6,1,1,507,'2016-05-02 12:27:58','NULL'),
(859,30,3,1,1,1,'2016-05-03 11:48:38','NULL'),
(860,30,4,1,1,1,'2016-05-03 11:48:38','NULL'),
(861,30,5,1,1,1,'2016-05-03 11:48:38','NULL'),
(862,30,6,1,1,1,'2016-05-03 11:48:38','NULL'),
(863,30,7,1,1,1,'2016-05-03 11:48:38','NULL'),
(864,31,3,1,1,1,'2016-05-03 11:49:27','NULL');

-- Table structure for table `packages` 


CREATE TABLE `packages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `package_name` varchar(40) DEFAULT NULL,
  `limit_flag` tinyint(1) DEFAULT NULL,
  `duration` int(10) DEFAULT NULL,
  `price` decimal(20,0) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1' COMMENT 'is_active',
  `last_editor` varchar(50) DEFAULT NULL,
  `last_edit_time` datetime DEFAULT NULL,
  `match_flag` tinyint(1) DEFAULT NULL,
  `is_add_on` tinyint(1) DEFAULT '0',
  `token` varchar(40) NOT NULL,
  `is_deleted` tinyint(1) DEFAULT '0',
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

INSERT INTO `packages` (`id`,`package_name`,`limit_flag`,`duration`,`price`,`is_active`,`last_editor`,`last_edit_time`,`match_flag`,`is_add_on`,`token`,`is_deleted`,`parent_id`,`created_by`,`created_at`,`updated_at`) VALUES 
(1,'Package-01',0,30,'200',1,'superadmin','2016-03-05 16:19:59',0,0,'0cbc6611f5540bd0809a388dc95a615b',0,NULL,1,'2015-12-30 17:28:28','2016-03-05 16:19:59'),
(2,'Package-02',0,30,'300',1,'superadmin','2016-02-24 15:34:04',0,0,'c454552d52d55d3ef56408742887362b',0,NULL,1,'2016-01-03 12:27:33','2016-02-24 15:34:04'),
(3,'Package-03',0,20,'300',1,'superadmin','2016-02-24 15:09:47',0,0,'c77fc369f622816e0689bf3b8ce5d7fa',0,1,1,'2016-02-24 13:41:20','2016-02-24 15:09:47'),
(4,'Add-on-01',0,1,'10',1,'NULL','NULL',0,1,'33cf07b9fa8d1d81d6347bd32f26440f',0,1,1,'2016-02-24 15:43:09','NULL'),
(5,'New Package',0,30,'200',1,'NULL','NULL',0,0,'0264240156f432b753b0ef0b37e3fadb',1,207,207,'2016-02-29 11:28:22','NULL'),
(6,'New AddOn Package',0,30,'200',1,'NULL','NULL',0,1,'ac8ad1a23fed5486c71540dc80c62db3',0,207,207,'2016-02-29 11:34:03','NULL'),
(7,'Package Name-3',0,10,'500',1,'superadmin','2016-04-28 11:51:45',0,0,'8575f098c7b54929909a2b5606d85aba',1,1,1,'2016-04-28 11:51:23','2016-04-28 11:51:45'),
(8,'Add Add-on-Package -1',0,40,'200',1,'NULL','NULL',0,1,'fae2259f4d8080440e51f2f384a11f40',1,1,1,'2016-04-28 11:52:23','NULL'),
(9,'Add Add-on-Package -1',0,40,'200',1,'NULL','NULL',0,1,'fae2259f4d8080440e51f2f384a11f40',1,1,1,'2016-04-28 11:52:29','NULL'),
(10,'Add Add-on-Package',0,20,'200',1,'superadmin','2016-04-28 11:53:20',0,1,'c7ab92144b24545c286ff1bf08ea9fba',1,1,1,'2016-04-28 11:53:05','2016-04-28 11:53:20'),
(11,'Demo Package',0,30,'400',1,'superadmin','2016-04-30 15:07:38',0,0,'28ad29fc7164e3f2bf91ae606ac0ab45',1,1,1,'2016-04-30 15:07:17','2016-04-30 15:07:38'),
(12,'Add Add-on-Package',0,30,'400',1,'NULL','NULL',0,1,'c7ab92144b24545c286ff1bf08ea9fba',1,1,1,'2016-04-30 15:23:07','NULL'),
(13,'Add Add-on-Package',0,30,'400',1,'NULL','NULL',0,1,'c7ab92144b24545c286ff1bf08ea9fba',1,1,1,'2016-04-30 15:23:17','NULL'),
(14,'Add Add-on-Package',0,30,'400',1,'NULL','NULL',0,1,'c7ab92144b24545c286ff1bf08ea9fba',1,1,1,'2016-04-30 15:23:19','NULL'),
(15,'Add-on Package',0,40,'400',1,'superadmin','2016-04-30 15:57:04',0,1,'b0d17c7bbbe2a8ffb9a94ff56375fa83',1,1,1,'2016-04-30 15:24:02','2016-04-30 15:57:04'),
(16,'Package Name',0,30,'4000',1,'NULL','NULL',0,0,'c51580d4c2b33fb5b81d80f81d889a3c',1,1,1,'2016-04-30 15:44:21','NULL'),
(17,'Add-on-Package  Close',0,50,'30000',1,'NULL','NULL',0,1,'afe2c9af010c97ac7a50112ac2631df8',1,1,1,'2016-04-30 15:44:58','NULL'),
(18,'STB TV',0,50,'400',1,'NULL','NULL',0,1,'306a68113c023340930306bf800d604b',1,1,1,'2016-04-30 15:57:25','NULL'),
(19,'Finacl-Check-Package',0,20,'400',1,'superadmin','2016-05-02 11:07:35',0,0,'61ef4671e5f5f2b44974896c4a9472b0',1,1,1,'2016-05-02 11:07:17','2016-05-02 11:07:35'),
(20,'Final-Package-Name',0,30,'300',1,'superadmin','2016-05-02 11:08:45',0,1,'f80534101f7c202543cec35f51dc20fa',1,1,1,'2016-05-02 11:08:31','2016-05-02 11:08:45'),
(21,'User Package',0,40,'400',1,'finalcheck','2016-05-02 12:27:58',0,0,'d9bd1003fa3e7f01b7d4ed6894ef41d6',0,1,507,'2016-05-02 12:27:45','2016-05-02 12:27:58'),
(22,'User Add-on Package',0,20,'30',1,'finalcheck','2016-05-02 12:28:42',0,1,'f8e3119cdd56014614c68daac2bc3c35',1,1,507,'2016-05-02 12:28:31','2016-05-02 12:28:42'),
(23,'Master Package',0,40,'500',1,'superadmin','2016-05-03 11:43:58',0,0,'7e481258277c2def478aa7e70d91d4e6',1,1,1,'2016-05-03 11:43:40','2016-05-03 11:43:58'),
(24,'Master Add-On Package',0,30,'500',1,'NULL','NULL',0,1,'c2d775bbe1233653acc56ddabfa0f9f3',1,1,1,'2016-05-03 11:44:45','NULL'),
(25,'Master Add-On Package',0,30,'500',1,'NULL','NULL',0,1,'c2d775bbe1233653acc56ddabfa0f9f3',1,1,1,'2016-05-03 11:44:55','NULL'),
(26,'Add Add-on-Package',0,40,'300',1,'NULL','NULL',0,1,'c7ab92144b24545c286ff1bf08ea9fba',1,1,1,'2016-05-03 11:45:49','NULL'),
(27,'Add Add-on-Package',0,40,'300',1,'NULL','NULL',0,1,'c7ab92144b24545c286ff1bf08ea9fba',1,1,1,'2016-05-03 11:46:02','NULL'),
(28,'Add Add-on-Package',0,40,'300',1,'NULL','NULL',0,1,'c7ab92144b24545c286ff1bf08ea9fba',1,1,1,'2016-05-03 11:46:32','NULL'),
(29,'Add Add-on-Package',0,40,'300',1,'NULL','NULL',0,1,'c7ab92144b24545c286ff1bf08ea9fba',1,1,1,'2016-05-03 11:46:43','NULL'),
(30,'Master Add Add-on-Package',0,50,'400',1,'NULL','NULL',0,1,'6a63456adba7162791170c633d766b10',0,1,1,'2016-05-03 11:48:38','NULL'),
(31,'Tset',0,1,'30',1,'NULL','NULL',0,1,'2177c92116e777e4b802dcc9fbd9c37a',0,1,1,'2016-05-03 11:49:27','NULL');

-- Table structure for table `pair_stb_ic_logs` 


CREATE TABLE `pair_stb_ic_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lco_id` int(11) DEFAULT NULL,
  `subscriber_id` int(11) DEFAULT NULL,
  `pairing_id` varchar(20) DEFAULT NULL,
  `condition` tinyint(4) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `type` enum('USER','SYSTEM') DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Table structure for table `payment_types` 


CREATE TABLE `payment_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_type` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO `payment_types` (`id`,`payment_type`) VALUES 
(1,'VISA'),
(2,'MASTERCARD'),
(3,'AMEX');

-- Table structure for table `plaas_menus` 


CREATE TABLE `plaas_menus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module_id` int(11) DEFAULT '1',
  `menu_name` varchar(100) DEFAULT NULL,
  `route` varchar(100) DEFAULT NULL,
  `display_order` int(11) DEFAULT NULL,
  `parent` int(11) DEFAULT NULL,
  `menu_type` enum('MSO','LCO','Subscriber','Group') DEFAULT NULL,
  `visible` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=183 DEFAULT CHARSET=latin1;

INSERT INTO `plaas_menus` (`id`,`module_id`,`menu_name`,`route`,`display_order`,`parent`,`menu_type`,`visible`) VALUES 
(1,1,'Administration','#',1,NULL,'MSO',1),
(2,1,'User Role','user-role',1,1,'MSO',1),
(3,1,'Permissions','permissions',2,1,'MSO',1),
(4,1,'Mso Users','mso',3,1,'MSO',1),
(5,1,'System Settings','#',2,NULL,'MSO',1),
(6,1,'Geo Location Manage','location',1,5,'MSO',1),
(7,1,'System Info','organization',2,5,'MSO',1),
(8,1,'Business Region','region',3,5,'MSO',1),
(9,1,'Package-Plan','#',3,NULL,'MSO',1),
(10,1,'Program Manage','program',1,9,'MSO',1),
(11,1,'Package Manage','package',2,9,'MSO',1),
(12,1,'Add-On Packages','#',4,NULL,'MSO',1),
(13,1,'Package List','add-on-package',1,12,'MSO',1),
(14,1,'Add-On Subscriber List','add-on-package-subscriber',2,12,'MSO',1),
(16,1,'NVOD Packages','#',5,NULL,'MSO',1),
(17,1,'Create NVOD Channel','create-nvod-channel',1,16,'MSO',1),
(18,1,'Configure NVOD','configure-nvod',2,16,'MSO',1),
(19,1,'Equipment Management','#',7,NULL,'MSO',1),
(20,1,'STB Provider','stb-provider',1,19,'MSO',1),
(21,1,'IC or Smart card Provider','icsmartcard-provider',2,19,'MSO',1),
(22,1,'Set-Top Box','set-top-box',3,19,'MSO',1),
(23,1,'IC or Smart Card','icsmart-card',4,19,'MSO',1),
(24,1,'FOC Subscriber','#',8,NULL,'MSO',1),
(25,1,'Subscriber Lists','foc-subscriber',1,24,'MSO',1),
(26,1,'LCO','#',9,NULL,'MSO',1),
(27,1,'LCO Manage','lco',1,26,'MSO',1),
(28,1,'LCO Users','lco-users',2,26,'MSO',1),
(29,1,'LCO Subscribers','lco-subscribers',3,26,'MSO',1),
(30,1,'Assign STB','lco-assign-stb',4,26,'MSO',1),
(31,1,'Assign Card','lco-assign-card',5,26,'MSO',1),
(32,1,'Scratch Card','#',10,NULL,'MSO',1),
(33,1,'Generate Card / List','scratch-card-generate',1,32,'MSO',1),
(34,1,'Card Distributor','scratch-card-distributor',2,32,'MSO',0),
(35,1,'Distribution List','scratch-card-distribution',3,32,'MSO',1),
(36,1,'Card Report','scratch-card-report',4,32,'MSO',0),
(37,1,'Payments','#',11,NULL,'MSO',1),
(38,1,'Bank','bank-payment',2,37,'MSO',1),
(39,1,'Online (Debit/Credit Card)','payments-online',3,37,'MSO',1),
(40,1,'Scratch-Card','payments-scratch-card',4,37,'MSO',1),
(41,1,'Bkash','payments-bkash',6,37,'MSO',1),
(42,1,'Gift Voucher','payments-gift-voucher',7,37,'MSO',1),
(43,1,'Refund','payments-refund',8,37,'MSO',1),
(44,1,'Tools','#',12,NULL,'MSO',1),
(45,1,'Conditional Mail','tools-conditional-mail',1,44,'MSO',1),
(46,1,'Conditional Search','tools-conditional-search',2,44,'MSO',1),
(47,1,'Pair STB and IC','tools-pair-stb-ic',3,44,'MSO',1),
(48,1,'Scrolling OSD','tools-scrolling-osd',4,44,'MSO',1),
(49,1,'Force OSD','tools-force-osd',5,44,'MSO',1),
(50,1,'Conditional Limited','tools-conditional-limited',6,44,'MSO',1),
(51,1,'ECM Finger Print','tools-ecm-fingerprint',7,44,'MSO',1),
(52,1,'EMM Finger Print','tools-emm-fingerprint',8,44,'MSO',1),
(53,1,'Temporary Authorization','tools-temporary-authorization',9,44,'MSO',1),
(54,1,'Reports','#',13,NULL,'MSO',1),
(55,1,'Active Subscriber','reports-active-subscriber',1,54,'MSO',1),
(56,1,'Assigned Package','reports-assigned-package',2,54,'MSO',1),
(57,1,'STB Status','reports-stb-status',3,54,'MSO',1),
(58,1,'SmartCard Status','reports-smartcard-status',4,54,'MSO',1),
(59,1,'Client Statement','client-statements',5,54,'MSO',1),
(60,1,'Recharge History','reports-recharge-history',6,54,'MSO',1),
(61,1,'Scratch Card Status','reports-scratch-card-status',7,54,'MSO',1),
(62,1,'Conditional Log','reports-system-log',8,54,'MSO',1),
(63,1,'System Settings','#',1,NULL,'LCO',1),
(64,1,'Bank Accounts','bank-accounts',1,63,'LCO',1),
(65,1,'LCO','#',2,NULL,'LCO',1),
(66,1,'LCO User','lco',1,65,'LCO',1),
(67,1,'LCO Role Permisions','permissions',3,65,'LCO',1),
(68,1,'Bill Collector','collector',4,65,'LCO',1),
(69,1,'Assign Money Receipt','assign-money-receipt',5,65,'LCO',1),
(70,1,'Subscriber Manage','#',3,NULL,'LCO',1),
(71,1,'Subscriber List','subscriber',1,70,'LCO',1),
(72,1,'Recharge Account','subscriber-recharge',2,70,'LCO',1),
(73,1,'Package-Plan','#',4,NULL,'LCO',1),
(74,1,'Packages','package',1,73,'LCO',1),
(75,1,'Add-On Package','#',5,NULL,'LCO',1),
(76,1,'Package List','add-on-package',1,75,'LCO',1),
(77,1,'Assign package','add-on-package-assign',2,75,'LCO',1),
(78,1,'Add-On Subscriber List','add-on-package-subscriber',3,75,'LCO',1),
(79,1,'NVOD Packages','#',6,NULL,'LCO',1),
(80,1,'Assign NVOD','assign-nvod',1,79,'LCO',1),
(81,1,'Show NVOD Time-table','nvod-time-table',2,79,'LCO',1),
(82,1,'NVOD Subscriber List','nvod-subscriber-list',3,79,'LCO',1),
(83,1,'Scratch Card','#',7,NULL,'LCO',1),
(84,1,'Generate Card / List','scratch-card-generate',1,83,'LCO',0),
(85,1,'Card Distributor','scratch-card-distributor',3,83,'LCO',0),
(86,1,'Card Distribution','scratch-card-distribution',3,83,'LCO',0),
(87,1,'Card Report','scratch-card-report',4,83,'LCO',0),
(88,1,'Payments','#',8,NULL,'LCO',1),
(89,1,'Cash','cash',1,88,'LCO',0),
(90,1,'Bank','bank-payment',2,88,'LCO',1),
(91,1,'Online (Debit/Credit Card)','payments-online',3,88,'LCO',1),
(92,1,'Scratch-Card','payments-scratch-card',4,88,'LCO',1),
(93,1,'POS','pos-payment',5,88,'LCO',1),
(94,1,'Bkash','payments-bkash',6,88,'LCO',1),
(95,1,'Gift Voucher','payments-gift-voucher',7,88,'LCO',1),
(96,1,'Refund','payments-refund',8,88,'LCO',1),
(97,1,'Parking Zone','#',9,NULL,'LCO',1),
(98,1,'Park Subscriber','park-subscriber',1,97,'LCO',1),
(99,1,'Tools','#',10,NULL,'LCO',1),
(100,1,'Conditional Mail','tools-conditional-mail',1,99,'LCO',1),
(101,1,'Conditional Search','tools-conditional-search',2,99,'LCO',1),
(102,1,'Pair STB and IC','tools-pair-stb-ic',3,99,'LCO',1),
(103,1,'Force OSD','tools-force-osd',4,99,'LCO',1),
(104,1,'Conditional Limited','tools-conditional-limited',5,99,'LCO',1),
(105,1,'ECM Finger Print','tools-ecm-fingerprint',6,99,'LCO',1),
(106,1,'EMM Finger Print','tools-emm-fingerprint',7,99,'LCO',1),
(107,1,'Temporary Authorization','tools-temporary-authorization',8,99,'LCO',1),
(108,1,'Reports','#',11,NULL,'LCO',1),
(109,1,'Active Subscriber','reports-active-subscriber',1,108,'LCO',1),
(110,1,'Assigned Package','reports-assigned-package',2,108,'LCO',1),
(111,1,'STB Status','reports-stb-status',3,108,'LCO',1),
(112,1,'SmartCard Status','reports-smartcard-status',4,108,'LCO',1),
(113,1,'Subscriber Transaction','reports-subscriber-transaction',5,108,'LCO',1),
(114,1,'Recharge History','reports-recharge-history',6,108,'LCO',1),
(115,1,'Scratch Card Status','reports-scratch-card-status',7,108,'LCO',1),
(117,1,'Bank Accounts','bank-accounts',4,5,'MSO',1),
(118,1,'POS','pos-settings',5,5,'MSO',1),
(119,1,'POS ','pos-settings',2,63,'LCO',1),
(120,1,'Bill Collector','collector',6,5,'MSO',1),
(121,1,'Assign Money Receipt','assign-money-receipt',7,5,'MSO',1),
(122,1,'Cash','cash',1,37,'MSO',1),
(123,1,'POS','pos-payment',5,37,'MSO',1),
(124,1,'Collection Statement','collection-statement',9,54,'MSO',1),
(125,1,'Foc Client Statement','foc-client-statement',10,54,'MSO',1),
(126,1,'Foc Collection','foc-collection',11,54,'MSO',1),
(127,1,'Bank Statement','bank-statement',12,54,'MSO',1),
(128,1,'POS Statement','pos-statement',13,54,'MSO',1),
(129,1,'Collector Statement','collector-statement',14,54,'MSO',1),
(130,1,'Cash Statement','cash-statement',15,54,'MSO',1),
(131,1,'Cash Statement','cash-statement',8,108,'LCO',1),
(132,1,'Bank Statement','bank-statement',9,108,'LCO',1),
(133,1,'POS Statement','pos-statement',10,108,'LCO',1),
(134,1,'Collector Statement','collector-statement',11,108,'LCO',1),
(135,1,'User Role','user-role',2,65,'LCO',1),
(136,1,'Notification Report','notification-report',16,54,'MSO',1),
(137,1,'Parking Zone','#',11,NULL,'MSO',1),
(138,1,'Park Subscriber','park-subscriber',1,137,'MSO',1),
(139,1,'Assign From Parking','assign-from-parking',2,137,'MSO',1),
(140,1,'Ownership Transfer','ownership-transfer',3,137,'MSO',1),
(141,1,'Assign From Parking Zone','assign-from-parking',2,97,'LCO',1),
(142,1,'Ownership Transfer','ownership-transfer',3,97,'LCO',1),
(143,1,'Parking Report','parking-report',17,54,'MSO',1),
(144,1,'Parking Report','parking-report',12,108,'LCO',1),
(145,1,'Reassign Pairing Report','reassign-pairing-report',18,54,'MSO',1),
(146,1,'Reassign Pairing Report','reassign-pairing-report',13,108,'LCO',1),
(147,1,'Ownership Transfer Report','ownership-transfer-report',19,54,'MSO',1),
(148,1,'Ownership Transfer Report','ownership-transfer-report',14,108,'LCO',1),
(150,1,'Group Accounts','#',7,NULL,'MSO',1),
(151,1,'Groups','groups',1,150,'MSO',1),
(152,1,'Assign LCO','assign-lco',2,150,'MSO',1),
(153,1,'Settings','#',1,NULL,'Group',1),
(154,1,'Users','groups',1,153,'Group',1),
(155,1,'My LCO','#',2,NULL,'Group',1),
(156,1,'LCO Users','lco-users',2,155,'Group',1),
(157,1,'User Role','user-role',2,153,'Group',1),
(158,1,'Permissions','permissions',3,153,'Group',1),
(159,1,'LCO','lco',1,155,'Group',1),
(160,1,'LCO Subscribers','lco-subscribers',3,155,'Group',1),
(161,1,'Profile','profile',1,NULL,'Subscriber',1),
(162,1,'Subscriber Packages','subscriber-packages',2,NULL,'Subscriber',1),
(163,1,'Subscriber Addon Packages','subscriber-addon-packages',3,NULL,'Subscriber',1),
(164,1,'User Documents','user-documents',4,NULL,'Subscriber',1),
(165,1,'Subscription Info','subscription-info',5,NULL,'Subscriber',1),
(166,1,'Recharge','#',6,NULL,'Subscriber',1),
(167,1,'Scratch Recharge','subscription-scratch-recharge',1,166,'Subscriber',1),
(168,1,'Online Recharge','subscription-online-recharge',2,166,'Subscriber',1),
(169,1,'My Transactions','my-transactions',7,NULL,'Subscriber',1),
(170,1,'Scratch Card','#',3,NULL,'Group',1),
(171,1,'Card Distributor','scratch-card-distributor',1,170,'Group',0),
(172,1,'Distribution List','scratch-card-distribution',2,170,'Group',1),
(173,1,'Payments','#',4,NULL,'Group',1),
(174,1,'Scratch-Card','payments-scratch-card',1,173,'Group',1),
(178,1,'System Backup','backup',8,5,'MSO',1),
(181,1,'Available Card List','scratch-card-available',1,170,'Group',1),
(182,1,'Available Card List','scratch-card-available',1,83,'LCO',1);

-- Table structure for table `plaas_modules` 


CREATE TABLE `plaas_modules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module_code` varchar(5) NOT NULL,
  `module_name` varchar(100) NOT NULL,
  `module_description` varchar(300) DEFAULT NULL,
  `created_by` int(4) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_by` int(4) DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  `is_active` int(1) NOT NULL DEFAULT '1',
  `route` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO `plaas_modules` (`id`,`module_code`,`module_name`,`module_description`,`created_by`,`created_at`,`updated_by`,`updated_at`,`is_active`,`route`) VALUES 
(1,'NULL','Test','NULL',NULL,'2016-01-13 12:40:46',NULL,'NULL',1,'test');

-- Table structure for table `plaas_role_menu_privileges` 


CREATE TABLE `plaas_role_menu_privileges` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) DEFAULT NULL,
  `module_id` int(11) DEFAULT NULL,
  `menu_id` int(11) DEFAULT NULL,
  `view` tinyint(1) DEFAULT '0',
  `create` tinyint(1) DEFAULT '0',
  `edit` tinyint(1) DEFAULT '0',
  `delete` tinyint(1) DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=831 DEFAULT CHARSET=latin1;

INSERT INTO `plaas_role_menu_privileges` (`id`,`role_id`,`module_id`,`menu_id`,`view`,`create`,`edit`,`delete`,`created_at`,`updated_at`,`created_by`,`parent_id`,`updated_by`) VALUES 
(396,4,1,63,1,1,1,1,'2016-02-11 13:40:25','2016-03-05 14:52:10',207,207,207),
(397,4,1,64,1,1,0,1,'2016-02-11 13:40:25','2016-03-06 12:00:42',207,207,207),
(398,4,1,65,1,0,0,1,'2016-02-11 16:49:55','2016-03-05 14:53:54',207,207,207),
(399,4,1,68,1,0,1,1,'2016-02-11 16:49:55','2016-03-06 12:09:49',207,207,207),
(400,4,1,69,1,0,0,1,'2016-02-11 16:49:55','2016-03-05 14:53:54',207,207,207),
(401,4,1,70,1,1,1,1,'2016-02-11 16:52:06','2016-03-05 15:03:15',207,207,207),
(402,4,1,71,1,1,1,1,'2016-02-11 16:52:06','2016-03-05 15:03:15',207,207,207),
(403,4,1,72,1,1,1,1,'2016-02-11 16:52:06','2016-03-05 15:03:15',207,207,207),
(404,4,1,73,1,1,1,1,'2016-02-11 16:53:21','2016-03-06 12:29:54',207,207,207),
(405,4,1,74,1,1,1,1,'2016-02-11 16:53:21','2016-03-06 12:29:54',207,207,207),
(406,4,1,75,1,0,0,0,'2016-02-11 16:57:32','2016-03-05 13:31:17',207,207,207),
(407,4,1,76,1,0,0,0,'2016-02-11 16:57:32','2016-03-05 13:31:17',207,207,207),
(408,4,1,77,1,0,0,0,'2016-02-11 16:57:32','2016-03-05 13:31:17',207,207,207),
(409,4,1,78,1,0,0,0,'2016-02-11 16:57:32','2016-03-05 13:31:17',207,207,207),
(410,4,1,83,1,1,1,1,'2016-02-11 17:04:17','2016-02-15 15:25:59',207,207,207),
(411,4,1,84,1,1,1,1,'2016-02-11 17:04:17','2016-02-15 15:25:59',207,207,207),
(412,4,1,86,1,1,1,1,'2016-02-11 17:04:17','2016-02-15 15:25:59',207,207,207),
(413,4,1,85,1,1,1,1,'2016-02-11 17:04:17','2016-02-15 15:25:59',207,207,207),
(414,4,1,87,1,1,1,1,'2016-02-11 17:04:17','2016-02-15 15:25:59',207,207,207),
(415,4,1,88,1,1,1,1,'2016-02-11 17:06:24','2016-05-02 16:28:16',207,207,207),
(416,4,1,89,1,1,1,1,'2016-02-11 17:06:24','2016-05-02 16:28:16',207,207,207),
(417,4,1,90,1,1,1,1,'2016-02-11 17:06:24','2016-05-02 16:28:16',207,207,207),
(418,4,1,91,1,1,1,1,'2016-02-11 17:06:24','2016-05-02 16:28:16',207,207,207),
(419,4,1,92,1,1,1,1,'2016-02-11 17:06:24','2016-05-02 16:28:16',207,207,207),
(420,4,1,93,1,1,1,1,'2016-02-11 17:06:24','2016-05-02 16:28:16',207,207,207),
(421,4,1,94,1,1,1,1,'2016-02-11 17:06:24','2016-05-02 16:28:16',207,207,207),
(422,4,1,95,1,1,1,1,'2016-02-11 17:06:24','2016-05-02 16:28:16',207,207,207),
(423,4,1,96,1,1,1,1,'2016-02-11 17:06:24','2016-05-02 16:28:16',207,207,207),
(424,4,1,99,0,0,0,0,'2016-02-11 17:07:35','2016-02-11 17:09:07',207,207,207),
(425,4,1,100,0,0,0,0,'2016-02-11 17:07:35','2016-02-11 17:09:07',207,207,207),
(426,4,1,101,0,0,0,0,'2016-02-11 17:07:35','2016-02-11 17:09:07',207,207,207),
(427,4,1,102,0,0,0,0,'2016-02-11 17:07:35','2016-02-11 17:09:07',207,207,207),
(428,4,1,103,0,0,0,0,'2016-02-11 17:07:35','2016-02-11 17:09:07',207,207,207),
(429,4,1,104,0,0,0,0,'2016-02-11 17:07:35','2016-02-11 17:09:07',207,207,207),
(430,4,1,105,0,0,0,0,'2016-02-11 17:07:35','2016-02-11 17:09:07',207,207,207),
(431,4,1,106,0,0,0,0,'2016-02-11 17:07:35','2016-02-11 17:09:07',207,207,207),
(432,4,1,107,0,0,0,0,'2016-02-11 17:07:35','2016-02-11 17:09:07',207,207,207),
(433,2,1,4,1,1,1,1,'2016-02-14 13:31:06','2016-02-14 13:31:20',1,1,1),
(434,2,1,1,1,1,1,1,'2016-02-14 13:31:20','NULL',1,1,NULL),
(435,2,1,2,1,1,1,1,'2016-02-14 13:31:20','NULL',1,1,NULL),
(436,2,1,3,1,1,1,1,'2016-02-14 13:31:20','NULL',1,1,NULL),
(437,2,1,5,1,1,1,1,'2016-02-14 13:32:05','NULL',1,1,NULL),
(438,2,1,6,1,1,1,1,'2016-02-14 13:32:05','NULL',1,1,NULL),
(439,2,1,7,1,1,1,1,'2016-02-14 13:32:05','NULL',1,1,NULL),
(440,2,1,8,1,1,1,1,'2016-02-14 13:32:05','NULL',1,1,NULL),
(441,2,1,117,1,1,1,1,'2016-02-14 13:32:05','NULL',1,1,NULL),
(442,2,1,9,1,1,1,1,'2016-02-14 13:32:42','NULL',1,1,NULL),
(443,2,1,10,1,1,1,1,'2016-02-14 13:32:42','NULL',1,1,NULL),
(444,2,1,11,1,1,1,1,'2016-02-14 13:32:42','NULL',1,1,NULL),
(445,2,1,12,1,1,1,0,'2016-02-14 13:33:31','2016-02-14 13:34:03',1,1,1),
(446,2,1,13,1,1,1,0,'2016-02-14 13:33:31','2016-02-14 13:34:03',1,1,1),
(447,2,1,14,1,1,1,0,'2016-02-14 13:33:31','2016-02-14 13:34:03',1,1,1),
(448,2,1,19,1,1,1,1,'2016-02-14 13:34:47','NULL',1,1,NULL),
(449,2,1,20,1,1,1,1,'2016-02-14 13:34:47','NULL',1,1,NULL),
(450,2,1,21,1,1,1,1,'2016-02-14 13:34:47','NULL',1,1,NULL),
(451,2,1,22,1,1,1,1,'2016-02-14 13:34:47','NULL',1,1,NULL),
(452,2,1,23,1,1,1,1,'2016-02-14 13:34:47','NULL',1,1,NULL),
(453,2,1,24,1,1,1,1,'2016-02-14 13:38:09','NULL',1,1,NULL),
(454,2,1,25,1,1,1,1,'2016-02-14 13:38:09','NULL',1,1,NULL),
(455,2,1,26,1,1,1,1,'2016-02-14 13:38:25','NULL',1,1,NULL),
(456,2,1,27,1,1,1,1,'2016-02-14 13:38:25','NULL',1,1,NULL),
(457,2,1,28,1,1,1,1,'2016-02-14 13:38:25','NULL',1,1,NULL),
(458,2,1,29,1,1,1,1,'2016-02-14 13:38:25','NULL',1,1,NULL),
(459,2,1,30,1,1,1,1,'2016-02-14 13:38:25','NULL',1,1,NULL),
(460,2,1,31,1,1,1,1,'2016-02-14 13:38:25','NULL',1,1,NULL),
(461,2,1,32,1,1,1,1,'2016-02-14 13:42:46','NULL',1,1,NULL),
(462,2,1,33,1,1,1,1,'2016-02-14 13:42:46','NULL',1,1,NULL),
(463,2,1,34,1,1,1,1,'2016-02-14 13:42:46','NULL',1,1,NULL),
(464,2,1,35,1,1,1,1,'2016-02-14 13:42:46','NULL',1,1,NULL),
(465,2,1,36,1,1,1,1,'2016-02-14 13:42:46','NULL',1,1,NULL),
(466,2,1,37,0,0,0,0,'2016-02-14 13:44:47','2016-02-14 13:44:50',1,1,1),
(467,2,1,38,0,0,0,0,'2016-02-14 13:44:47','2016-02-14 13:44:50',1,1,1),
(468,2,1,39,0,0,0,0,'2016-02-14 13:44:47','2016-02-14 13:44:50',1,1,1),
(469,2,1,40,0,0,0,0,'2016-02-14 13:44:47','2016-02-14 13:44:50',1,1,1),
(470,2,1,41,0,0,0,0,'2016-02-14 13:44:47','2016-02-14 13:44:50',1,1,1),
(471,2,1,42,0,0,0,0,'2016-02-14 13:44:47','2016-02-14 13:44:50',1,1,1),
(472,2,1,43,0,0,0,0,'2016-02-14 13:44:48','2016-02-14 13:44:50',1,1,1),
(473,2,1,54,0,0,0,0,'2016-02-14 13:45:00','2016-02-14 13:51:56',1,1,1),
(474,2,1,55,0,0,0,0,'2016-02-14 13:45:00','2016-02-14 13:52:19',1,1,1),
(475,2,1,56,0,0,0,0,'2016-02-14 13:45:00','2016-02-14 13:52:20',1,1,1),
(476,2,1,57,0,0,0,0,'2016-02-14 13:45:00','2016-02-14 13:52:21',1,1,1),
(477,2,1,58,0,0,0,0,'2016-02-14 13:45:00','2016-02-14 13:52:22',1,1,1),
(478,2,1,59,0,0,0,0,'2016-02-14 13:45:00','2016-02-14 13:52:24',1,1,1),
(479,2,1,60,0,0,0,0,'2016-02-14 13:45:00','2016-02-14 13:52:26',1,1,1),
(480,2,1,61,0,0,0,0,'2016-02-14 13:45:00','2016-02-14 13:51:56',1,1,1),
(481,2,1,62,0,0,0,0,'2016-02-14 13:45:00','2016-02-14 13:52:09',1,1,1),
(486,4,1,119,1,0,1,1,'2016-02-29 15:45:07','2016-03-06 12:04:35',207,207,207),
(494,7,1,70,1,1,1,1,'2016-03-27 11:00:59','NULL',207,207,NULL),
(495,7,1,71,1,1,1,1,'2016-03-27 11:00:59','NULL',207,207,NULL),
(496,7,1,72,1,1,1,1,'2016-03-27 11:00:59','NULL',207,207,NULL),
(497,7,1,88,1,1,1,1,'2016-03-27 11:01:08','NULL',207,207,NULL),
(498,7,1,89,1,1,1,1,'2016-03-27 11:01:08','NULL',207,207,NULL),
(499,7,1,90,1,1,1,1,'2016-03-27 11:01:08','2016-03-27 11:01:24',207,207,207),
(500,7,1,91,1,1,1,1,'2016-03-27 11:01:08','NULL',207,207,NULL),
(501,7,1,92,0,0,0,0,'2016-03-27 11:01:08','2016-03-27 11:01:27',207,207,207),
(502,7,1,93,1,1,1,1,'2016-03-27 11:01:08','NULL',207,207,NULL),
(503,7,1,94,1,1,1,1,'2016-03-27 11:01:08','NULL',207,207,NULL),
(504,7,1,95,0,0,0,0,'2016-03-27 11:01:08','2016-03-27 11:01:34',207,207,207),
(505,7,1,96,0,0,0,0,'2016-03-27 11:01:08','2016-03-27 11:01:35',207,207,207),
(506,8,1,1,0,0,0,0,'2016-03-27 15:38:57','2016-03-27 15:39:05',1,1,1),
(507,8,1,2,0,0,0,0,'2016-03-27 15:38:57','2016-03-27 15:39:05',1,1,1),
(508,8,1,3,0,0,0,0,'2016-03-27 15:38:57','2016-03-27 15:39:05',1,1,1),
(509,8,1,4,0,0,0,0,'2016-03-27 15:38:57','2016-03-27 15:39:05',1,1,1),
(510,8,1,9,1,1,1,1,'2016-03-27 15:39:11','NULL',1,1,NULL),
(511,8,1,10,1,1,1,1,'2016-03-27 15:39:11','NULL',1,1,NULL),
(512,8,1,11,1,1,1,1,'2016-03-27 15:39:11','NULL',1,1,NULL),
(513,7,1,63,0,0,0,0,'2016-03-27 15:56:34','2016-03-27 15:56:36',207,207,207),
(514,7,1,64,0,0,0,0,'2016-03-27 15:56:34','2016-03-27 15:56:37',207,207,207),
(515,7,1,119,0,0,0,0,'2016-03-27 15:56:34','2016-03-27 15:56:37',207,207,207),
(543,8,1,137,1,1,1,1,'2016-04-24 14:25:00','NULL',1,1,NULL),
(544,8,1,138,1,1,1,1,'2016-04-24 14:25:00','NULL',1,1,NULL),
(545,8,1,139,1,1,1,1,'2016-04-24 14:25:00','NULL',1,1,NULL),
(546,8,1,140,1,1,1,1,'2016-04-24 14:25:00','NULL',1,1,NULL),
(547,4,1,79,0,0,0,0,'2016-04-24 14:41:48','2016-04-24 14:41:56',207,207,207),
(548,4,1,80,0,0,0,0,'2016-04-24 14:41:48','2016-04-24 14:41:56',207,207,207),
(549,4,1,81,0,0,0,0,'2016-04-24 14:41:48','2016-04-24 14:41:56',207,207,207),
(550,4,1,82,0,0,0,0,'2016-04-24 14:41:48','2016-04-24 14:41:56',207,207,207),
(551,2,1,118,0,0,0,0,'2016-04-24 15:52:50','2016-04-24 15:52:57',1,1,1),
(555,15,1,153,1,1,1,1,'2016-04-28 11:10:27','2016-05-07 16:53:39',490,490,490),
(556,15,1,154,1,1,1,1,'2016-04-28 11:10:27','2016-05-07 16:53:39',490,490,490),
(557,15,1,157,1,1,1,1,'2016-04-28 11:10:27','2016-05-07 16:53:40',490,490,490),
(558,15,1,158,1,1,1,1,'2016-04-28 11:10:27','2016-05-07 16:53:40',490,490,490),
(559,15,1,155,1,1,1,1,'2016-04-28 11:10:28','NULL',490,490,NULL),
(560,15,1,156,1,1,1,1,'2016-04-28 11:10:28','2016-05-07 16:53:41',490,490,490),
(646,20,1,63,1,1,1,1,'2016-04-30 16:35:15','NULL',207,207,NULL),
(647,20,1,64,1,1,1,1,'2016-04-30 16:35:15','NULL',207,207,NULL),
(648,20,1,119,1,1,1,1,'2016-04-30 16:35:15','NULL',207,207,NULL),
(649,20,1,65,1,1,1,1,'2016-04-30 16:35:17','NULL',207,207,NULL),
(650,20,1,135,1,1,1,1,'2016-04-30 16:35:17','NULL',207,207,NULL),
(651,20,1,68,1,1,1,1,'2016-04-30 16:35:17','NULL',207,207,NULL),
(652,20,1,69,1,1,1,1,'2016-04-30 16:35:17','NULL',207,207,NULL),
(653,20,1,70,1,1,1,1,'2016-04-30 16:35:18','NULL',207,207,NULL),
(654,20,1,71,1,1,1,1,'2016-04-30 16:35:18','NULL',207,207,NULL),
(655,20,1,72,1,1,1,1,'2016-04-30 16:35:18','NULL',207,207,NULL),
(656,20,1,73,1,1,1,1,'2016-04-30 16:35:20','NULL',207,207,NULL),
(657,20,1,74,1,1,1,1,'2016-04-30 16:35:20','NULL',207,207,NULL),
(658,20,1,75,1,1,1,1,'2016-04-30 16:45:05','NULL',207,207,NULL),
(659,20,1,76,1,1,1,1,'2016-04-30 16:45:05','NULL',207,207,NULL),
(660,20,1,77,1,1,1,1,'2016-04-30 16:45:05','NULL',207,207,NULL),
(661,20,1,78,1,1,1,1,'2016-04-30 16:45:05','NULL',207,207,NULL),
(662,21,1,63,1,1,1,1,'2016-04-30 17:34:04','NULL',207,207,NULL),
(663,21,1,64,1,1,1,1,'2016-04-30 17:34:04','NULL',207,207,NULL),
(664,21,1,119,1,1,1,1,'2016-04-30 17:34:04','NULL',207,207,NULL),
(665,21,1,65,1,1,1,1,'2016-04-30 17:34:05','NULL',207,207,NULL),
(666,21,1,135,1,1,1,1,'2016-04-30 17:34:05','NULL',207,207,NULL),
(667,21,1,68,1,1,1,1,'2016-04-30 17:34:05','NULL',207,207,NULL),
(668,21,1,69,1,1,1,1,'2016-04-30 17:34:05','NULL',207,207,NULL),
(669,21,1,70,1,1,1,1,'2016-04-30 17:34:06','NULL',207,207,NULL),
(670,21,1,71,1,1,1,1,'2016-04-30 17:34:06','NULL',207,207,NULL),
(671,21,1,72,1,1,1,1,'2016-04-30 17:34:06','NULL',207,207,NULL),
(672,21,1,73,1,1,1,1,'2016-04-30 17:34:08','NULL',207,207,NULL),
(673,21,1,74,1,1,1,1,'2016-04-30 17:34:08','NULL',207,207,NULL),
(674,22,1,1,1,1,1,1,'2016-05-02 12:15:49','NULL',1,1,NULL),
(675,22,1,2,1,1,1,1,'2016-05-02 12:15:49','NULL',1,1,NULL),
(676,22,1,3,1,1,1,1,'2016-05-02 12:15:49','NULL',1,1,NULL),
(677,22,1,4,1,1,1,1,'2016-05-02 12:15:49','NULL',1,1,NULL),
(678,22,1,5,0,0,0,0,'2016-05-02 12:15:50','2016-05-02 12:24:35',1,1,1),
(679,22,1,6,0,0,0,0,'2016-05-02 12:15:50','2016-05-02 12:24:35',1,1,1),
(680,22,1,7,0,0,0,0,'2016-05-02 12:15:50','2016-05-02 12:24:35',1,1,1),
(681,22,1,8,0,0,0,0,'2016-05-02 12:15:50','2016-05-02 12:24:35',1,1,1),
(682,22,1,117,0,0,0,0,'2016-05-02 12:15:50','2016-05-02 12:24:35',1,1,1),
(683,22,1,118,0,0,0,0,'2016-05-02 12:15:50','2016-05-02 12:24:35',1,1,1),
(684,22,1,120,0,0,0,0,'2016-05-02 12:15:50','2016-05-02 12:24:35',1,1,1),
(685,22,1,121,0,0,0,0,'2016-05-02 12:15:50','2016-05-02 12:24:35',1,1,1),
(686,22,1,9,1,1,1,1,'2016-05-02 12:15:52','NULL',1,1,NULL),
(687,22,1,10,1,1,1,1,'2016-05-02 12:15:52','NULL',1,1,NULL),
(688,22,1,11,1,1,1,1,'2016-05-02 12:15:52','NULL',1,1,NULL),
(689,22,1,12,1,1,1,1,'2016-05-02 12:15:54','NULL',1,1,NULL),
(690,22,1,13,1,1,1,1,'2016-05-02 12:15:54','NULL',1,1,NULL),
(691,22,1,14,1,1,1,1,'2016-05-02 12:15:54','NULL',1,1,NULL),
(692,22,1,16,1,1,1,1,'2016-05-02 12:15:55','NULL',1,1,NULL),
(693,22,1,17,1,1,1,1,'2016-05-02 12:15:55','NULL',1,1,NULL),
(694,22,1,18,1,1,1,1,'2016-05-02 12:15:55','NULL',1,1,NULL),
(695,22,1,19,1,1,1,1,'2016-05-02 12:15:56','NULL',1,1,NULL),
(696,22,1,20,1,1,1,1,'2016-05-02 12:15:57','NULL',1,1,NULL),
(697,22,1,21,1,1,1,1,'2016-05-02 12:15:57','NULL',1,1,NULL),
(698,22,1,22,1,1,1,1,'2016-05-02 12:15:57','NULL',1,1,NULL),
(699,22,1,23,1,1,1,1,'2016-05-02 12:15:57','NULL',1,1,NULL),
(700,22,1,24,1,1,1,1,'2016-05-02 12:15:58','NULL',1,1,NULL),
(701,22,1,25,1,1,1,1,'2016-05-02 12:15:58','NULL',1,1,NULL),
(702,22,1,26,1,1,1,1,'2016-05-02 12:16:00','NULL',1,1,NULL),
(703,22,1,27,1,1,1,1,'2016-05-02 12:16:00','NULL',1,1,NULL),
(704,22,1,28,1,1,1,1,'2016-05-02 12:16:00','NULL',1,1,NULL),
(705,22,1,29,1,1,1,1,'2016-05-02 12:16:00','NULL',1,1,NULL),
(706,22,1,30,1,1,1,1,'2016-05-02 12:16:00','NULL',1,1,NULL),
(707,22,1,31,1,1,1,1,'2016-05-02 12:16:00','NULL',1,1,NULL),
(708,22,1,32,1,1,1,1,'2016-05-02 12:16:01','NULL',1,1,NULL),
(709,22,1,33,1,1,1,1,'2016-05-02 12:16:01','NULL',1,1,NULL),
(710,22,1,34,1,1,1,1,'2016-05-02 12:16:01','NULL',1,1,NULL),
(711,22,1,35,1,1,1,1,'2016-05-02 12:16:01','NULL',1,1,NULL),
(712,22,1,36,1,1,1,1,'2016-05-02 12:16:02','NULL',1,1,NULL),
(713,22,1,37,1,1,1,1,'2016-05-02 12:16:03','NULL',1,1,NULL),
(714,22,1,122,1,1,1,1,'2016-05-02 12:16:03','NULL',1,1,NULL),
(715,22,1,38,1,1,1,1,'2016-05-02 12:16:03','NULL',1,1,NULL),
(716,22,1,39,1,1,1,1,'2016-05-02 12:16:03','NULL',1,1,NULL),
(717,22,1,40,1,1,1,1,'2016-05-02 12:16:03','NULL',1,1,NULL),
(718,22,1,123,1,1,1,1,'2016-05-02 12:16:03','NULL',1,1,NULL),
(719,22,1,41,1,1,1,1,'2016-05-02 12:16:03','NULL',1,1,NULL),
(720,22,1,42,1,1,1,1,'2016-05-02 12:16:03','NULL',1,1,NULL),
(721,22,1,43,1,1,1,1,'2016-05-02 12:16:03','NULL',1,1,NULL),
(722,22,1,44,1,1,1,1,'2016-05-02 12:16:05','NULL',1,1,NULL),
(723,22,1,45,1,1,1,1,'2016-05-02 12:16:05','NULL',1,1,NULL),
(724,22,1,46,1,1,1,1,'2016-05-02 12:16:05','NULL',1,1,NULL),
(725,22,1,47,1,1,1,1,'2016-05-02 12:16:05','NULL',1,1,NULL),
(726,22,1,48,1,1,1,1,'2016-05-02 12:16:05','NULL',1,1,NULL),
(727,22,1,49,1,1,1,1,'2016-05-02 12:16:05','NULL',1,1,NULL),
(728,22,1,50,1,1,1,1,'2016-05-02 12:16:05','NULL',1,1,NULL),
(729,22,1,51,1,1,1,1,'2016-05-02 12:16:05','NULL',1,1,NULL),
(730,22,1,52,1,1,1,1,'2016-05-02 12:16:05','NULL',1,1,NULL),
(731,22,1,53,1,1,1,1,'2016-05-02 12:16:05','NULL',1,1,NULL),
(732,22,1,54,1,1,1,1,'2016-05-02 12:16:07','NULL',1,1,NULL),
(733,22,1,55,1,1,1,1,'2016-05-02 12:16:07','NULL',1,1,NULL),
(734,22,1,56,1,1,1,1,'2016-05-02 12:16:07','NULL',1,1,NULL),
(735,22,1,57,1,1,1,1,'2016-05-02 12:16:07','NULL',1,1,NULL),
(736,22,1,58,1,1,1,1,'2016-05-02 12:16:07','NULL',1,1,NULL),
(737,22,1,59,1,1,1,1,'2016-05-02 12:16:07','NULL',1,1,NULL),
(738,22,1,60,1,1,1,1,'2016-05-02 12:16:07','NULL',1,1,NULL),
(739,22,1,61,1,1,1,1,'2016-05-02 12:16:07','NULL',1,1,NULL),
(740,22,1,62,1,1,1,1,'2016-05-02 12:16:07','NULL',1,1,NULL),
(741,22,1,124,1,1,1,1,'2016-05-02 12:16:07','NULL',1,1,NULL),
(742,22,1,125,1,1,1,1,'2016-05-02 12:16:07','NULL',1,1,NULL),
(743,22,1,126,1,1,1,1,'2016-05-02 12:16:07','NULL',1,1,NULL),
(744,22,1,127,1,1,1,1,'2016-05-02 12:16:07','NULL',1,1,NULL),
(745,22,1,128,1,1,1,1,'2016-05-02 12:16:07','NULL',1,1,NULL),
(746,22,1,129,1,1,1,1,'2016-05-02 12:16:08','NULL',1,1,NULL),
(747,22,1,130,1,1,1,1,'2016-05-02 12:16:08','NULL',1,1,NULL),
(748,22,1,136,1,1,1,1,'2016-05-02 12:16:08','NULL',1,1,NULL),
(749,22,1,143,1,1,1,1,'2016-05-02 12:16:08','NULL',1,1,NULL),
(750,22,1,145,1,1,1,1,'2016-05-02 12:16:08','NULL',1,1,NULL),
(751,22,1,147,1,1,1,1,'2016-05-02 12:16:08','NULL',1,1,NULL),
(752,22,1,137,1,1,1,1,'2016-05-02 12:16:11','NULL',1,1,NULL),
(753,22,1,138,1,1,1,1,'2016-05-02 12:16:11','NULL',1,1,NULL),
(754,22,1,139,1,1,1,1,'2016-05-02 12:16:11','NULL',1,1,NULL),
(755,22,1,140,1,1,1,1,'2016-05-02 12:16:11','NULL',1,1,NULL),
(756,22,1,150,1,1,1,1,'2016-05-02 12:16:12','NULL',1,1,NULL),
(757,22,1,151,1,1,1,1,'2016-05-02 12:16:12','NULL',1,1,NULL),
(758,22,1,152,1,1,1,1,'2016-05-02 12:16:12','NULL',1,1,NULL),
(759,24,1,68,1,1,1,1,'2016-05-02 15:32:34','NULL',207,207,NULL),
(760,24,1,69,1,1,1,1,'2016-05-02 15:32:36','NULL',207,207,NULL),
(761,24,1,71,1,1,1,1,'2016-05-02 15:32:40','NULL',207,207,NULL),
(762,24,1,72,1,1,1,1,'2016-05-02 15:32:42','NULL',207,207,NULL),
(763,24,1,73,1,1,1,1,'2016-05-02 15:32:45','NULL',207,207,NULL),
(764,24,1,74,1,1,1,1,'2016-05-02 15:32:45','NULL',207,207,NULL),
(765,24,1,75,1,1,1,1,'2016-05-02 15:32:47','NULL',207,207,NULL),
(766,24,1,76,1,1,1,1,'2016-05-02 15:32:47','NULL',207,207,NULL),
(767,24,1,77,1,1,1,1,'2016-05-02 15:32:47','NULL',207,207,NULL),
(768,24,1,78,1,1,1,1,'2016-05-02 15:32:47','NULL',207,207,NULL),
(769,24,1,83,1,1,1,1,'2016-05-02 15:32:50','NULL',207,207,NULL),
(770,24,1,84,1,1,1,1,'2016-05-02 15:32:50','NULL',207,207,NULL),
(771,24,1,86,1,1,1,1,'2016-05-02 15:32:50','NULL',207,207,NULL),
(772,24,1,85,1,1,1,1,'2016-05-02 15:32:50','NULL',207,207,NULL),
(773,24,1,87,1,1,1,1,'2016-05-02 15:32:50','NULL',207,207,NULL),
(774,24,1,88,1,1,1,1,'2016-05-02 15:32:52','NULL',207,207,NULL),
(775,24,1,89,1,1,1,1,'2016-05-02 15:32:52','NULL',207,207,NULL),
(776,24,1,90,1,1,1,1,'2016-05-02 15:32:52','NULL',207,207,NULL),
(777,24,1,91,1,1,1,1,'2016-05-02 15:32:52','NULL',207,207,NULL),
(778,24,1,92,1,1,1,1,'2016-05-02 15:32:52','NULL',207,207,NULL),
(779,24,1,93,1,1,1,1,'2016-05-02 15:32:52','NULL',207,207,NULL),
(780,24,1,94,1,1,1,1,'2016-05-02 15:32:52','NULL',207,207,NULL),
(781,24,1,95,1,1,1,1,'2016-05-02 15:32:52','NULL',207,207,NULL),
(782,24,1,96,1,1,1,1,'2016-05-02 15:32:52','NULL',207,207,NULL),
(783,15,1,159,1,1,1,1,'2016-05-03 11:27:34','NULL',496,496,NULL),
(784,15,1,160,1,1,1,1,'2016-05-03 11:27:37','NULL',496,496,NULL),
(785,25,1,9,1,1,1,1,'2016-05-03 11:32:27','NULL',1,1,NULL),
(786,25,1,10,1,1,1,1,'2016-05-03 11:32:27','NULL',1,1,NULL),
(787,25,1,11,1,1,1,1,'2016-05-03 11:32:27','NULL',1,1,NULL),
(788,25,1,12,1,1,1,1,'2016-05-03 11:32:31','NULL',1,1,NULL),
(789,25,1,13,1,1,1,1,'2016-05-03 11:32:31','NULL',1,1,NULL),
(790,25,1,14,1,1,1,1,'2016-05-03 11:32:31','NULL',1,1,NULL),
(791,25,1,16,1,1,1,1,'2016-05-03 11:32:33','NULL',1,1,NULL),
(792,25,1,17,1,1,1,1,'2016-05-03 11:32:33','NULL',1,1,NULL),
(793,25,1,18,1,1,1,1,'2016-05-03 11:32:33','NULL',1,1,NULL),
(794,25,1,19,1,1,1,1,'2016-05-03 11:32:34','NULL',1,1,NULL),
(795,25,1,20,1,1,1,1,'2016-05-03 11:32:34','NULL',1,1,NULL),
(796,25,1,21,1,1,1,1,'2016-05-03 11:32:34','NULL',1,1,NULL),
(797,25,1,22,1,1,1,1,'2016-05-03 11:32:34','NULL',1,1,NULL),
(798,25,1,23,1,1,1,1,'2016-05-03 11:32:34','NULL',1,1,NULL),
(799,25,1,24,1,1,1,1,'2016-05-03 11:32:37','NULL',1,1,NULL),
(800,25,1,25,1,1,1,1,'2016-05-03 11:32:37','NULL',1,1,NULL),
(801,25,1,26,1,1,1,1,'2016-05-03 11:32:38','NULL',1,1,NULL),
(802,25,1,27,1,1,1,1,'2016-05-03 11:32:38','NULL',1,1,NULL),
(803,25,1,28,1,1,1,1,'2016-05-03 11:32:38','NULL',1,1,NULL),
(804,25,1,29,1,1,1,1,'2016-05-03 11:32:38','NULL',1,1,NULL),
(805,25,1,30,1,1,1,1,'2016-05-03 11:32:38','NULL',1,1,NULL),
(806,25,1,31,1,1,1,1,'2016-05-03 11:32:38','NULL',1,1,NULL),
(807,25,1,32,1,1,1,1,'2016-05-03 11:32:40','NULL',1,1,NULL),
(808,25,1,33,1,1,1,1,'2016-05-03 11:32:40','NULL',1,1,NULL),
(809,25,1,34,1,1,1,1,'2016-05-03 11:32:40','NULL',1,1,NULL),
(810,25,1,35,1,1,1,1,'2016-05-03 11:32:40','NULL',1,1,NULL),
(811,25,1,36,1,1,1,1,'2016-05-03 11:32:40','NULL',1,1,NULL),
(812,25,1,37,1,1,1,1,'2016-05-03 11:32:42','NULL',1,1,NULL),
(813,25,1,122,1,1,1,1,'2016-05-03 11:32:42','NULL',1,1,NULL),
(814,25,1,38,1,1,1,1,'2016-05-03 11:32:42','NULL',1,1,NULL),
(815,25,1,39,1,1,1,1,'2016-05-03 11:32:42','NULL',1,1,NULL),
(816,25,1,40,1,1,1,1,'2016-05-03 11:32:42','NULL',1,1,NULL),
(817,25,1,123,1,1,1,1,'2016-05-03 11:32:42','NULL',1,1,NULL),
(818,25,1,41,1,1,1,1,'2016-05-03 11:32:42','NULL',1,1,NULL),
(819,25,1,42,1,1,1,1,'2016-05-03 11:32:42','NULL',1,1,NULL),
(820,25,1,43,1,1,1,1,'2016-05-03 11:32:42','NULL',1,1,NULL),
(821,25,1,137,1,1,1,1,'2016-05-03 11:32:48','NULL',1,1,NULL),
(822,25,1,138,1,1,1,1,'2016-05-03 11:32:48','NULL',1,1,NULL),
(823,25,1,139,1,1,1,1,'2016-05-03 11:32:48','NULL',1,1,NULL),
(824,25,1,140,1,1,1,1,'2016-05-03 11:32:48','NULL',1,1,NULL),
(825,25,1,150,1,1,1,1,'2016-05-03 11:32:50','NULL',1,1,NULL),
(826,25,1,151,1,1,1,1,'2016-05-03 11:32:50','NULL',1,1,NULL),
(827,25,1,152,1,1,1,1,'2016-05-03 11:32:50','NULL',1,1,NULL),
(828,15,1,170,1,1,1,1,'2016-05-07 16:53:42','NULL',490,490,NULL),
(829,15,1,171,1,1,1,1,'2016-05-07 16:53:42','NULL',490,490,NULL),
(830,15,1,172,1,1,1,1,'2016-05-07 16:53:42','NULL',490,490,NULL);

-- Table structure for table `plaas_role_module_privileges` 


CREATE TABLE `plaas_role_module_privileges` (
  `id` int(11) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `module_id` int(11) DEFAULT NULL,
  `view` tinyint(1) DEFAULT NULL,
  `insert` tinyint(1) DEFAULT NULL,
  `update` tinyint(1) DEFAULT NULL,
  `delete` tinyint(1) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Table structure for table `pos_machines` 


CREATE TABLE `pos_machines` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bank_account_id` int(11) DEFAULT NULL,
  `pos_machine_id` varchar(100) DEFAULT NULL,
  `collector_id` int(11) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '0',
  `charge_interest` varchar(100) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `token` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

INSERT INTO `pos_machines` (`id`,`bank_account_id`,`pos_machine_id`,`collector_id`,`is_active`,`charge_interest`,`parent_id`,`created_by`,`updated_by`,`created_at`,`updated_at`,`token`) VALUES 
(1,1,'1100121',11,0,'10',1,1,NULL,'2016-02-28 17:21:10','NULL','824e20829f710fc84173ec9df0b52c0f'),
(2,NULL,'2432423',NULL,0,'10',207,207,NULL,'2016-02-29 11:15:20','2016-03-06 10:45:14','42c2ab9af91ae57d11dd17e4bd639542'),
(3,1,'01738725242',1,0,'10',207,412,NULL,'2016-03-06 11:59:37','2016-03-09 11:31:01','a6153088ebc31e47ceb4d9ccb605b0f0'),
(4,1,'33',11,0,'NULL',1,1,NULL,'2016-03-16 12:47:25','NULL','182be0c5cdcd5072bb1864cdee4d3d6e'),
(5,7,'3454',11,0,'NULL',1,1,NULL,'2016-04-28 11:43:55','NULL','5abdf8b8520b71f3a528c7547ee92428'),
(6,NULL,'4382',NULL,0,'15',1,1,NULL,'2016-04-30 14:51:44','2016-04-30 14:52:36','9bab7341f4429f78ade492da0318aa42'),
(7,9,'4383',15,0,'15',207,207,NULL,'2016-04-30 16:32:24','2016-04-30 16:32:38','6de4bfe9504589a457d6e92fae4f9613'),
(8,10,'130',18,0,'15',207,207,NULL,'2016-04-30 17:31:47','NULL','9b8619251a19057cff70779273e95aa6'),
(9,11,'1234',11,0,'10',1,1,NULL,'2016-05-02 11:00:48','2016-05-02 11:00:58','81dc9bdb52d04dc20036dbd8313ed055'),
(10,12,'130316',1,0,'10',207,207,NULL,'2016-05-02 15:28:46','NULL','0b2dbba84cd425084862e30873efee1a'),
(11,12,'123567',21,0,'10',207,207,NULL,'2016-05-02 16:04:28','NULL','0d2c260ea50b5190eb8f243c31c856b9');

-- Table structure for table `post_codes` 


CREATE TABLE `post_codes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `country_id` int(11) DEFAULT NULL,
  `division_id` int(11) DEFAULT NULL,
  `district_id` int(11) DEFAULT NULL,
  `post_code` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO `post_codes` (`id`,`country_id`,`division_id`,`district_id`,`post_code`) VALUES 
(1,6,13,8,'1200');

-- Table structure for table `priorities` 


CREATE TABLE `priorities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `value` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO `priorities` (`id`,`name`,`value`) VALUES 
(1,'HIGH','1'),
(2,'MEDIUM','MEDIUM'),
(3,'LOW','LOW');

-- Table structure for table `programs` 


CREATE TABLE `programs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lcn` int(10) DEFAULT NULL,
  `program_service_id` varchar(20) DEFAULT '0',
  `program_name` varchar(100) DEFAULT NULL,
  `fingerprint` tinyint(1) DEFAULT '0',
  `display_position` varchar(64) DEFAULT NULL,
  `font_type` int(11) DEFAULT NULL,
  `font_color` int(11) unsigned DEFAULT NULL,
  `font_size` int(11) unsigned DEFAULT NULL,
  `background_color` int(11) DEFAULT NULL,
  `visible_level` char(1) DEFAULT NULL,
  `program_type` varchar(64) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  `last_editor` varchar(50) DEFAULT NULL,
  `last_edit_time` datetime DEFAULT NULL,
  `network_id` varchar(64) DEFAULT NULL,
  `transport_stream_id` varchar(64) DEFAULT NULL,
  `service_id` varchar(64) DEFAULT NULL,
  `position_x` smallint(6) DEFAULT NULL,
  `position_y` smallint(6) DEFAULT NULL,
  `color_type` int(11) DEFAULT '3',
  `show_time` int(11) DEFAULT NULL,
  `stop_time` int(11) DEFAULT NULL,
  `over_flag` tinyint(4) DEFAULT NULL,
  `show_background_flag` tinyint(4) DEFAULT NULL,
  `show_stb_number_flag` tinyint(4) DEFAULT NULL,
  `program_status` tinyint(1) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;

INSERT INTO `programs` (`id`,`lcn`,`program_service_id`,`program_name`,`fingerprint`,`display_position`,`font_type`,`font_color`,`font_size`,`background_color`,`visible_level`,`program_type`,`status`,`last_editor`,`last_edit_time`,`network_id`,`transport_stream_id`,`service_id`,`position_x`,`position_y`,`color_type`,`show_time`,`stop_time`,`over_flag`,`show_background_flag`,`show_stb_number_flag`,`program_status`,`created_at`,`updated_at`,`parent_id`,`created_by`) VALUES 
(1,NULL,'NULL','Dangal',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2016-02-24 13:11:29','2016-02-24 15:16:30',1,1),
(2,NULL,'NULL','DD Sports',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2016-02-24 13:11:42','2016-02-24 15:16:27',1,1),
(3,NULL,'NULL','R-Vision',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2016-02-24 13:11:52','2016-02-24 15:16:22',1,1),
(4,NULL,'NULL','DD Bangla',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2016-02-24 13:12:06','2016-02-24 15:16:19',1,1),
(5,NULL,'NULL','INDEPENDENT',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 18:37:20','2016-02-24 15:16:00',1,1),
(6,NULL,'NULL','TRACE SPORT STARS',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 18:37:29','2016-02-24 15:15:57',1,1),
(7,NULL,'NULL','MUSIC INDIA',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:15','2016-02-24 15:15:54',1,1),
(8,NULL,'NULL','SRI TV',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:15','2016-02-24 15:15:51',1,1),
(9,NULL,'NULL','THAI TV',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:15','2016-02-24 15:15:48',1,1),
(10,NULL,'NULL','DAN',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:15','2016-02-24 15:15:33',1,1),
(11,NULL,'NULL','Mohona',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:15','2016-02-24 15:15:29',1,1),
(12,NULL,'NULL','Music TV',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:15','2016-02-24 15:15:25',1,1),
(13,NULL,'NULL','DD NEWS',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:15','2016-02-24 15:15:21',1,1),
(14,NULL,'NULL','RUPUSHI BANGLA',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:15','2016-02-24 15:15:18',1,1),
(15,NULL,'NULL','MONORONJON MUSIC',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:15','2016-02-24 15:15:01',1,1),
(16,NULL,'NULL','MUSIC F',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:16','2016-02-24 15:14:57',1,1),
(17,NULL,'NULL','DHOOM',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:16','2016-02-24 15:14:54',1,1),
(18,NULL,'NULL','R PLUS',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:16','2016-02-24 15:14:50',1,1),
(19,NULL,'NULL','AAKASH BANGLA',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:16','2016-02-24 15:14:47',1,1),
(20,NULL,'NULL','IBC 24',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:16','2016-02-24 15:14:33',1,1),
(21,NULL,'NULL','SANGEET BANGLA',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:16','2016-02-24 15:14:29',1,1),
(22,NULL,'NULL','NEWS TIME',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:16','2016-02-24 15:14:25',1,1),
(23,NULL,'NULL','PTC NEWS',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:16','2016-02-24 15:14:21',1,1),
(24,NULL,'NULL','ONKAR ONLY TRUTH',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:16','2016-02-24 15:14:17',1,1),
(25,NULL,'NULL','GREEN TV',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:16','2016-02-24 15:14:01',1,1),
(26,NULL,'NULL','TV9 TELEGU',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:16','2016-02-24 15:13:58',1,1),
(27,NULL,'NULL','MAHA MOVIE',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:17','2016-02-24 15:13:54',1,1),
(28,NULL,'NULL','FASHION TV SD',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:17','2016-02-24 15:13:51',1,1),
(29,NULL,'NULL','NEWS TIME 24X7',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:17','2016-02-24 15:13:47',1,1),
(30,NULL,'NULL','TV 5',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:17','2016-02-24 15:13:36',1,1),
(31,NULL,'NULL','DIVYA',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:17','2016-02-24 15:13:29',1,1),
(32,NULL,'NULL','PRAG TV',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:17','2016-02-24 15:13:22',1,1),
(33,NULL,'NULL','MUNSIF',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:17','2016-02-24 15:13:14',1,1),
(34,NULL,'NULL','Outernet',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:17','2016-02-24 15:13:05',1,1),
(35,NULL,'NULL','24 Ghanta',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:17','2016-02-24 15:12:59',1,1),
(36,NULL,'NULL','Music Choice',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:17','2016-02-24 15:12:53',1,1),
(37,NULL,'NULL','SkySports31',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:17','2016-02-24 15:12:46',1,1),
(38,NULL,'NULL','SkySports32',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:17','2016-02-24 15:12:41',1,1),
(39,NULL,'NULL','SkySports33',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:17','2016-02-24 15:12:35',1,1),
(40,NULL,'NULL','DD National',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:17','2016-02-24 15:12:29',1,1),
(41,NULL,'NULL','SkySports35',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:18','2016-02-24 15:12:25',1,1),
(42,NULL,'NULL','SkySports36',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:18','2016-02-24 15:12:20',1,1),
(43,NULL,'NULL','SkySports37',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:18','2016-02-24 15:12:15',1,1),
(44,NULL,'NULL','SkySports38',0,'4',NULL,NULL,8,-1,'1','2',1,'NULL','NULL','NULL','NULL','NULL',NULL,NULL,3,NULL,NULL,1,1,1,0,'2015-12-29 19:26:18','2016-02-24 15:12:05',1,1);

-- Table structure for table `references` 


CREATE TABLE `references` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO `references` (`id`,`name`,`created_by`,`parent_id`,`created_at`,`updated_at`) VALUES 
(1,'Mr ABC',NULL,NULL,'NULL','NULL');

-- Table structure for table `region_level_1` 


CREATE TABLE `region_level_1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `region_l1_name` varchar(50) DEFAULT NULL,
  `region_l1_code` int(11) DEFAULT '0',
  `region_l2_code` int(11) DEFAULT '0',
  `region_l3_code` int(11) DEFAULT '0',
  `region_l4_code` int(11) DEFAULT '0',
  `hex_code` varchar(200) DEFAULT '0',
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

INSERT INTO `region_level_1` (`id`,`region_l1_name`,`region_l1_code`,`region_l2_code`,`region_l3_code`,`region_l4_code`,`hex_code`,`parent_id`,`created_by`,`is_active`,`created_at`,`updated_at`) VALUES 
(1,'Imrans',1,NULL,NULL,NULL,'0x01000000000000',NULL,1,1,'2015-11-22 17:40:46','2016-04-20 13:21:40'),
(2,'Barisal',2,NULL,NULL,NULL,'0x02000000000000',1,1,1,'2015-11-24 14:43:31','2016-01-10 17:24:46'),
(3,'Comilla',3,NULL,NULL,NULL,'0x03000000000000',1,1,1,'2015-11-25 18:10:19','NULL'),
(4,'Khulna',4,NULL,NULL,NULL,'0x04000000000000',1,1,1,'2015-11-25 18:10:59','NULL'),
(5,'FOC',5,NULL,NULL,NULL,'0x05000000000000',1,1,1,'2015-12-27 11:49:30','NULL'),
(6,'Noakhali',6,NULL,NULL,NULL,'0x06000000000000',1,1,1,'2016-02-10 13:58:48','NULL'),
(7,'New region',7,NULL,NULL,NULL,'0x07000000000000',1,1,1,'2016-03-06 12:43:43','NULL'),
(8,'Faridpur',8,NULL,NULL,NULL,'0x08000000000000',1,1,1,'2016-03-08 15:19:09','NULL'),
(9,'Hello',9,NULL,NULL,NULL,'0x09000000000000',1,1,1,'2016-04-18 17:27:11','NULL'),
(10,'Dhanmondi',10,NULL,NULL,NULL,'0x0A000000000000',1,1,1,'2016-04-28 11:41:38','NULL'),
(11,'Rayer Bazar',11,NULL,NULL,NULL,'0x0B000000000000',1,1,1,'2016-04-28 11:42:01','NULL'),
(13,'Test',13,NULL,NULL,NULL,'0x0D000000000000',1,1,1,'2016-04-30 15:28:18','NULL'),
(14,'Final Test',14,NULL,NULL,NULL,'0x0E000000000000',1,1,1,'2016-04-30 15:30:15','NULL'),
(15,'Magura',15,NULL,NULL,NULL,'0x0F000000000000',1,1,1,'2016-04-30 15:33:54','NULL'),
(16,'Banani',16,NULL,NULL,NULL,'0x10000000000000',1,1,1,'2016-05-02 10:55:47','NULL'),
(17,'Final Check',17,NULL,NULL,NULL,'0x11000000000000',1,1,1,'2016-05-02 11:09:27','NULL'),
(18,'Magura',18,NULL,NULL,NULL,'0x12000000000000',1,1,1,'2016-05-03 11:36:51','NULL');

-- Table structure for table `region_level_2` 


CREATE TABLE `region_level_2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `region_l2_name` varchar(50) DEFAULT NULL,
  `region_l1_code` int(11) DEFAULT '0',
  `region_l2_code` int(11) DEFAULT '0',
  `region_l3_code` int(11) DEFAULT '0',
  `region_l4_code` int(11) DEFAULT '0',
  `hex_code` varchar(200) DEFAULT '0',
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

INSERT INTO `region_level_2` (`id`,`region_l2_name`,`region_l1_code`,`region_l2_code`,`region_l3_code`,`region_l4_code`,`hex_code`,`parent_id`,`created_by`,`is_active`,`created_at`,`updated_at`) VALUES 
(1,'Imran-01',1,1,NULL,NULL,'0x01000100000000',1,1,1,'2015-11-22 17:44:16','2015-12-26 15:04:56'),
(2,'Panthapath',1,2,NULL,NULL,'0x01000200000000',1,1,1,'2015-11-22 17:45:46','NULL'),
(3,'Mirpur',1,3,NULL,NULL,'0x01000300000000',1,1,1,'2015-11-22 18:00:42','2015-11-22 18:00:54'),
(4,'Bhola',2,4,NULL,NULL,'0x02000400000000',1,1,1,'2015-11-24 14:43:42','NULL'),
(5,'Miapara',4,5,NULL,NULL,'0x04000500000000',1,1,1,'2015-11-25 18:11:11','NULL'),
(6,'Noakhali',6,6,NULL,NULL,'0x06000600000000',1,1,1,'2016-02-10 13:59:09','NULL'),
(7,'Dhaka',5,7,NULL,NULL,'0x05000700000000',1,1,1,'2016-02-11 13:43:24','NULL'),
(8,'Hello1',9,8,NULL,NULL,'0x09000800000000',1,1,1,'2016-04-18 17:27:26','NULL'),
(9,'School Road',11,9,NULL,NULL,'0x0B000900000000',1,1,1,'2016-04-28 11:42:14','NULL'),
(10,'Sub New Region',7,10,NULL,NULL,'0x07000A00000000',1,1,1,'2016-04-30 14:38:35','NULL'),
(11,'Sub Sub New Region',7,11,NULL,NULL,'0x07000B00000000',1,1,1,'2016-04-30 14:38:51','NULL'),
(12,'sdfsdfc',7,12,NULL,NULL,'0x07000C00000000',1,1,1,'2016-04-30 14:39:23','NULL'),
(13,'rfthrthrt',7,13,NULL,NULL,'0x07000D00000000',1,1,1,'2016-04-30 14:40:20','NULL'),
(14,'ergtrgrt',7,14,NULL,NULL,'0x07000E00000000',1,1,1,'2016-04-30 14:40:35','NULL'),
(17,'Test1',13,17,NULL,NULL,'0x0D001100000000',1,1,1,'2016-04-30 15:28:33','NULL'),
(18,'Final Test-2',14,18,NULL,NULL,'0x0E001200000000',1,1,1,'2016-04-30 15:30:33','NULL'),
(19,'Kaligong',15,19,NULL,NULL,'0x0F001300000000',1,1,1,'2016-04-30 15:34:06','NULL'),
(20,'Banani Bazar',16,20,NULL,NULL,'0x10001400000000',1,1,1,'2016-05-02 10:56:03','NULL'),
(21,'Bus Stand',16,21,NULL,NULL,'0x10001500000000',1,1,1,'2016-05-02 10:56:36','NULL'),
(22,'Main Road',16,22,NULL,NULL,'0x10001600000000',1,1,1,'2016-05-02 10:57:20','NULL'),
(26,'Final L-2',17,26,NULL,NULL,'0x11001A00000000',1,1,1,'2016-05-02 11:09:40','NULL'),
(27,'Mohammadpur',18,27,NULL,NULL,'0x12001B00000000',1,1,1,'2016-05-03 11:37:14','NULL');

-- Table structure for table `region_level_3` 


CREATE TABLE `region_level_3` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `region_l3_name` varchar(50) DEFAULT NULL,
  `region_l1_code` int(11) DEFAULT '0',
  `region_l2_code` int(11) DEFAULT '0',
  `region_l3_code` int(11) DEFAULT '0',
  `region_l4_code` int(11) DEFAULT '0',
  `hex_code` varchar(200) DEFAULT '0',
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

INSERT INTO `region_level_3` (`id`,`region_l3_name`,`region_l1_code`,`region_l2_code`,`region_l3_code`,`region_l4_code`,`hex_code`,`parent_id`,`created_by`,`is_active`,`created_at`,`updated_at`) VALUES 
(1,'Imran-DOHS',1,1,1,NULL,'0x01000100010000',1,1,1,'2015-11-22 17:44:21','2016-01-25 12:05:22'),
(2,'Borhanuddin',2,4,2,NULL,'0x02000400020000',1,1,1,'2015-11-24 14:44:08','NULL'),
(3,'Master Para',4,5,3,NULL,'0x04000500030000',1,1,1,'2015-11-25 18:31:52','NULL'),
(4,'test',1,2,4,NULL,'0x01000200040000',1,1,1,'2015-12-15 13:33:32','NULL'),
(5,'Laxmipur',6,6,5,NULL,'0x06000600050000',1,1,1,'2016-02-10 13:59:19','NULL'),
(6,'Mohakhali',5,7,6,NULL,'0x05000700060000',1,1,1,'2016-02-11 13:43:33','NULL'),
(7,'Comissionar Goli',11,9,7,NULL,'0x0B000900070000',1,1,1,'2016-04-28 11:42:44','NULL'),
(8,'dfgdfg',7,11,8,NULL,'0x07000B00080000',1,1,1,'2016-04-30 14:40:01','NULL'),
(9,'drtgrtgrt',7,12,9,NULL,'0x07000C00090000',1,1,1,'2016-04-30 14:40:13','NULL'),
(18,'Test2',13,17,18,NULL,'0x0D001100120000',1,1,1,'2016-04-30 15:29:06','NULL'),
(19,'Test1.1',13,17,19,NULL,'0x0D001100130000',1,1,1,'2016-04-30 15:29:22','NULL'),
(20,'Final Test-3',14,18,20,NULL,'0x0E001200140000',1,1,1,'2016-04-30 15:30:42','NULL'),
(21,'Final Test-4',14,18,21,NULL,'0x0E001200150000',1,1,1,'2016-04-30 15:30:50','NULL'),
(22,'Tal',14,18,22,NULL,'0x0E001200160000',1,1,1,'2016-04-30 15:31:33','NULL'),
(23,'ESD',14,18,23,NULL,'0x0E001200170000',1,1,1,'2016-04-30 15:31:54','NULL'),
(24,'ESDS',14,18,24,NULL,'0x0E001200180000',1,1,1,'2016-04-30 15:32:09','NULL'),
(25,'Bathpukur',15,19,25,NULL,'0x0F001300190000',1,1,1,'2016-04-30 15:34:18','NULL'),
(26,'Sub Road',16,21,26,NULL,'0x100015001A0000',1,1,1,'2016-05-02 10:57:29','NULL'),
(27,'BSD',16,21,27,NULL,'0x100015001B0000',1,1,1,'2016-05-02 11:04:13','NULL'),
(28,'Final L-3',17,26,28,NULL,'0x11001A001C0000',1,1,1,'2016-05-02 11:09:48','NULL'),
(29,'L-3',16,20,29,NULL,'0x100014001D0000',1,1,1,'2016-05-02 11:16:21','NULL'),
(30,'L3',17,26,30,NULL,'0x11001A001E0000',1,1,1,'2016-05-02 11:16:46','NULL'),
(31,'Adarshapara',18,27,31,NULL,'0x12001B001F0000',1,1,1,'2016-05-03 11:37:25','NULL');

-- Table structure for table `region_level_4` 


CREATE TABLE `region_level_4` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `region_l4_name` varchar(50) DEFAULT NULL,
  `region_l1_code` int(11) DEFAULT '0',
  `region_l2_code` int(11) DEFAULT '0',
  `region_l3_code` int(11) DEFAULT '0',
  `region_l4_code` int(11) DEFAULT '0',
  `hex_code` varchar(200) DEFAULT '0',
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

INSERT INTO `region_level_4` (`id`,`region_l4_name`,`region_l1_code`,`region_l2_code`,`region_l3_code`,`region_l4_code`,`hex_code`,`parent_id`,`created_by`,`is_active`,`created_at`,`updated_at`) VALUES 
(1,'Imran-Road-20',1,1,1,1,'0x01000100010001',1,1,1,'2015-11-22 17:44:28','2015-12-26 15:05:09'),
(2,'Imran-Road-32',1,1,1,2,'0x01000100010002',1,1,1,'2015-11-22 17:44:33','2015-12-26 15:05:15'),
(3,'Kunjerhat',2,4,2,3,'0x02000400020003',1,1,1,'2015-11-24 14:44:15','NULL'),
(4,'Road 22',4,5,3,4,'0x04000500030004',1,1,1,'2015-11-25 18:32:09','NULL'),
(5,'Shakor Ghat',6,6,5,5,'0x06000600050005',1,1,1,'2016-02-10 13:59:29','NULL'),
(6,'Dohs',5,7,6,6,'0x05000700060006',1,1,1,'2016-02-11 13:43:40','NULL'),
(7,'Road 24',11,9,7,7,'0x0B000900070007',1,1,1,'2016-04-28 11:42:56','NULL'),
(8,'rrr',7,11,8,8,'0x07000B00080008',1,1,1,'2016-04-30 14:40:59','NULL'),
(10,'Test3',13,17,18,10,'0x0D00110012000A',1,1,1,'2016-04-30 15:29:28','NULL'),
(11,'Test1.1.2',13,17,19,11,'0x0D00110013000B',1,1,1,'2016-04-30 15:29:35','NULL'),
(12,'ee',13,17,19,12,'0x0D00110013000C',1,1,1,'2016-04-30 15:31:14','NULL'),
(13,'Final Test-4.1',14,18,21,13,'0x0E00120015000D',1,1,1,'2016-04-30 15:31:12','NULL'),
(14,'Dal',14,18,22,14,'0x0E00120016000E',1,1,1,'2016-04-30 15:31:43','NULL'),
(15,'ADS',14,18,22,15,'0x0E00120016000F',1,1,1,'2016-04-30 15:31:49','NULL'),
(16,'Shimakhali',15,19,25,16,'0x0F001300190010',1,1,1,'2016-04-30 15:34:26','NULL'),
(17,'Road-20',16,21,26,17,'0x100015001A0011',1,1,1,'2016-05-02 10:57:39','NULL'),
(18,'Final L-4',17,26,28,18,'0x11001A001C0012',1,1,1,'2016-05-02 11:09:57','NULL'),
(19,'l4',17,26,30,19,'0x11001A001E0013',1,1,1,'2016-05-02 11:17:08','NULL'),
(20,'Master Para',18,27,31,20,'0x12001B001F0014',1,1,1,'2016-05-03 11:37:39','NULL');

-- Table structure for table `roads` 


CREATE TABLE `roads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `road_name` varchar(100) NOT NULL,
  `road_code` varchar(10) DEFAULT NULL,
  `country_id` int(11) DEFAULT NULL,
  `division_id` int(11) DEFAULT NULL,
  `district_id` int(11) NOT NULL,
  `area_id` int(11) DEFAULT NULL,
  `sub_area_id` int(11) DEFAULT NULL,
  `lat` varchar(255) DEFAULT NULL,
  `lon` varchar(255) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_areas` (`country_id`),
  KEY `FK_area_division1` (`division_id`),
  KEY `FK_areas_district` (`district_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

INSERT INTO `roads` (`id`,`road_name`,`road_code`,`country_id`,`division_id`,`district_id`,`area_id`,`sub_area_id`,`lat`,`lon`,`parent_id`,`created_by`,`created_at`,`updated_at`) VALUES 
(1,'Road-02','ROA',6,13,8,1,1,'NULL','NULL',1,1,'2015-11-24 17:44:55','NULL'),
(2,'Road-03','ROA',6,13,8,1,1,'NULL','NULL',1,1,'2015-11-24 17:45:06','NULL'),
(3,'8/A','8/A',12,21,10,4,2,'NULL','NULL',1,1,'2016-02-10 13:55:11','NULL'),
(4,'Road 29','ROA',6,13,8,1,1,'NULL','NULL',1,320,'2016-02-10 16:27:30','NULL'),
(5,'R50','R50',6,13,8,1,1,'NULL','NULL',1,1,'2016-02-11 13:42:49','NULL'),
(6,'Road 30','ROA',6,13,8,1,1,'NULL','NULL',1,1,'2016-03-08 15:18:44','NULL'),
(7,'28','28',6,14,9,3,3,'NULL','NULL',1,1,'2016-04-30 14:37:22','NULL'),
(8,'Nangna','NAN',7,20,11,5,4,'NULL','NULL',1,1,'2016-05-02 10:51:57','NULL'),
(9,'Road','ROA',15,22,12,6,5,'NULL','NULL',1,507,'2016-05-02 12:23:43','NULL'),
(10,'30','30',6,13,8,2,6,'NULL','NULL',1,1,'2016-05-03 11:36:25','NULL');

-- Table structure for table `roles` 


CREATE TABLE `roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_type` enum('MSO','LCO','Staff','Subscriber','Group') DEFAULT NULL,
  `role_type` enum('admin','staff','subscriber') DEFAULT NULL,
  `role_name` varchar(45) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `default_role` tinyint(1) DEFAULT '0',
  `status` tinyint(1) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;

INSERT INTO `roles` (`id`,`user_type`,`role_type`,`role_name`,`parent_id`,`created_by`,`default_role`,`status`,`created_at`,`updated_at`,`updated_by`) VALUES 
(1,'MSO','admin','Admin',1,1,1,1,'NULL','2016-02-29 15:46:09',1),
(2,'MSO','staff','Staff',1,1,1,1,'NULL','2016-04-19 12:55:58',1),
(3,'LCO','admin','Admin',1,1,1,1,'NULL','NULL',NULL),
(4,'LCO','staff','Staff',1,1,1,1,'NULL','NULL',NULL),
(5,'Subscriber','subscriber','Subscriber',1,1,1,1,'NULL','NULL',NULL),
(7,'LCO','staff','Faysal',207,207,0,1,'2016-03-27 11:00:46','NULL',NULL),
(8,'MSO','staff','msousers',1,1,0,1,'2016-03-27 14:27:53','2016-04-19 12:56:06',1),
(15,'Group','staff','User',490,490,0,1,'2016-04-28 11:10:19','NULL',NULL),
(20,'LCO','staff','LCO User',207,207,0,1,'2016-04-30 16:35:10','NULL',NULL),
(21,'LCO','staff','Master User',207,207,0,1,'2016-04-30 17:34:00','NULL',NULL),
(22,'MSO','staff','S.Admin',1,1,0,1,'2016-05-02 10:47:47','2016-05-02 12:15:38',1),
(23,'MSO','staff','User Role',1,507,0,1,'2016-05-02 12:19:48','NULL',NULL),
(24,'LCO','staff','LCO S.Admin',207,207,0,1,'2016-05-02 15:32:22','NULL',NULL),
(25,'MSO','staff','Master role',1,1,0,1,'2016-05-03 11:32:15','NULL',NULL);

-- Table structure for table `scratch_card_detail` 


CREATE TABLE `scratch_card_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `card_info_id` int(11) DEFAULT NULL,
  `card_no` varchar(100) DEFAULT NULL,
  `serial_no` varchar(8) DEFAULT NULL,
  `parent_id` int(5) DEFAULT NULL,
  `subscriber_id` int(11) DEFAULT '0',
  `user_type` enum('MSO','LCO','Group') DEFAULT NULL,
  `group_id` int(10) DEFAULT '0',
  `lco_id` int(5) DEFAULT '0',
  `distributor_id` int(5) DEFAULT '0',
  `used_date` varchar(20) DEFAULT NULL,
  `ip_location` varchar(250) DEFAULT NULL,
  `is_used` int(1) DEFAULT '0',
  `is_active` int(1) DEFAULT '1',
  `is_suspended` int(1) DEFAULT '0',
  `updated_by` int(5) DEFAULT NULL,
  `created_by` int(5) DEFAULT NULL,
  `updated_at` varchar(20) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

INSERT INTO `scratch_card_detail` (`id`,`card_info_id`,`card_no`,`serial_no`,`parent_id`,`subscriber_id`,`user_type`,`group_id`,`lco_id`,`distributor_id`,`used_date`,`ip_location`,`is_used`,`is_active`,`is_suspended`,`updated_by`,`created_by`,`updated_at`,`created_at`) VALUES 
(1,1,'1247499649051724','00000001',1,339,'NULL',490,207,NULL,'2016-06-27 14:11:01','NULL',1,1,NULL,207,1,'2016-06-27 14:11:01','2016-06-26 12:46:59'),
(2,1,'1208975441516441','00000002',1,NULL,'NULL',490,207,NULL,'NULL','NULL',NULL,1,NULL,207,1,'2016-06-26 15:16:19','2016-06-26 12:46:59'),
(3,1,'1207282969633679','00000003',1,NULL,'NULL',490,207,NULL,'NULL','NULL',NULL,1,NULL,1,1,'2016-06-27 09:33:31','2016-06-26 12:46:59'),
(4,1,'1243921274821372','00000004',1,NULL,'NULL',490,207,NULL,'NULL','NULL',NULL,1,NULL,490,1,'2016-06-27 10:06:47','2016-06-26 12:46:59'),
(5,1,'1279119279495832','00000005',1,NULL,'NULL',490,207,NULL,'NULL','NULL',NULL,1,NULL,1,1,'2016-06-26 12:47:34','2016-06-26 12:46:59'),
(6,1,'1203514370263637','00000006',1,NULL,'NULL',NULL,NULL,NULL,'NULL','NULL',NULL,1,NULL,NULL,1,'NULL','2016-06-26 12:46:59'),
(7,1,'1247066972438099','00000007',1,NULL,'NULL',NULL,NULL,NULL,'NULL','NULL',NULL,1,NULL,NULL,1,'NULL','2016-06-26 12:46:59'),
(8,1,'1210925302731494','00000008',1,NULL,'NULL',NULL,NULL,NULL,'NULL','NULL',NULL,1,NULL,NULL,1,'NULL','2016-06-26 12:46:59'),
(9,1,'1214544784113901','00000009',1,NULL,'NULL',NULL,NULL,NULL,'NULL','NULL',NULL,1,NULL,NULL,1,'NULL','2016-06-26 12:46:59'),
(10,1,'1232516419722684','00000010',1,NULL,'NULL',NULL,NULL,NULL,'NULL','NULL',NULL,1,NULL,NULL,1,'NULL','2016-06-26 12:46:59');

-- Table structure for table `scratch_card_info` 


CREATE TABLE `scratch_card_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `prefix` int(2) DEFAULT NULL,
  `length` int(11) DEFAULT NULL,
  `batch_no` bigint(12) DEFAULT NULL,
  `value` float DEFAULT NULL,
  `number_of_cards` int(11) DEFAULT NULL,
  `active_from_date` varchar(20) DEFAULT NULL,
  `is_active` int(1) DEFAULT '1',
  `is_suspended` int(1) DEFAULT '0',
  `created_by` int(5) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `parent_id` int(5) DEFAULT NULL,
  `updated_by` int(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO `scratch_card_info` (`id`,`date`,`prefix`,`length`,`batch_no`,`value`,`number_of_cards`,`active_from_date`,`is_active`,`is_suspended`,`created_by`,`created_at`,`updated_at`,`parent_id`,`updated_by`) VALUES 
(1,'0000-00-00 00:00:00',12,16,201606250001,'250',10,'2016-06-26',1,NULL,1,'2016-06-26 12:46:59','NULL',1,NULL);

-- Table structure for table `scrolling_osd_logs` 


CREATE TABLE `scrolling_osd_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lco_id` int(11) DEFAULT NULL,
  `subscriber_id` int(11) DEFAULT NULL,
  `stb_id` int(11) DEFAULT NULL,
  `smart_card_id` int(11) DEFAULT NULL,
  `region_code` varchar(100) DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  `settings_id` int(11) DEFAULT NULL,
  `display_times` varchar(10) DEFAULT NULL,
  `content` text,
  `start_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `condition_return_code` varchar(100) DEFAULT NULL,
  `is_stoped` tinyint(1) DEFAULT '0',
  `created_by` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `stopped_editor` int(11) DEFAULT NULL,
  `stopped_edit_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

INSERT INTO `scrolling_osd_logs` (`id`,`lco_id`,`subscriber_id`,`stb_id`,`smart_card_id`,`region_code`,`group_id`,`settings_id`,`display_times`,`content`,`start_time`,`end_time`,`condition_return_code`,`is_stoped`,`created_by`,`parent_id`,`created_at`,`updated_at`,`stopped_editor`,`stopped_edit_time`) VALUES 
(1,NULL,NULL,NULL,NULL,'NULL',NULL,NULL,'2','Helloworld','2016-02-24 17:23:13','2016-03-02 23:59:59','4611686018427388149',0,1,1,'2016-02-24 17:23:40','NULL',NULL,'NULL'),
(2,NULL,NULL,NULL,NULL,'NULL',NULL,NULL,'2','Helloworld','2016-02-24 17:23:13','2016-03-02 23:59:59','4611686018427388150',0,1,1,'2016-02-24 17:24:49','NULL',NULL,'NULL'),
(3,NULL,NULL,NULL,NULL,'NULL',NULL,NULL,'2','ALL Subscriber','2016-02-24 17:32:20','2016-03-02 23:59:59','4611686018427388151',0,1,1,'2016-02-24 17:32:46','NULL',NULL,'NULL'),
(4,NULL,343,NULL,78,'NULL',NULL,NULL,'2','Hello','2016-02-24 17:41:41','2016-03-02 23:59:59','4611686018427388152',0,1,1,'2016-02-24 17:42:07','NULL',NULL,'NULL'),
(5,207,NULL,NULL,NULL,'NULL',NULL,NULL,'2','Hello','2016-02-24 17:41:41','2016-03-02 23:59:59','4611686018427388153',0,1,1,'2016-02-24 17:44:02','NULL',NULL,'NULL'),
(6,NULL,343,2147483647,NULL,'NULL',NULL,NULL,'2','Hello','2016-02-24 17:41:41','2016-03-02 23:59:59','4611686018427388154',0,1,1,'2016-02-24 17:45:00','NULL',NULL,'NULL'),
(7,NULL,NULL,NULL,NULL,'NULL',NULL,NULL,'2','All Subscribers','2016-02-24 17:50:27','2016-03-02 23:59:59','4611686018427388155',0,1,1,'2016-02-24 17:50:53','NULL',NULL,'NULL'),
(8,NULL,343,NULL,78,'NULL',NULL,NULL,'2','To Jahirul Islam with IC','2016-02-24 17:50:27','2016-03-02 23:59:59','4611686018427388156',0,1,1,'2016-02-24 17:51:49','NULL',NULL,'NULL'),
(9,NULL,343,2147483647,NULL,'NULL',NULL,NULL,'2','To Jahirul Islam with STB','2016-02-24 17:50:27','2016-03-02 23:59:59','4611686018427388157',0,1,1,'2016-02-24 17:52:31','NULL',NULL,'NULL'),
(10,NULL,NULL,NULL,NULL,'0x01000000000000',NULL,NULL,'2','To Business Address (Imran)','2016-02-24 17:54:52','2016-03-02 23:59:59','4611686018427388159',0,1,1,'2016-02-24 17:55:20','NULL',NULL,'NULL'),
(11,NULL,NULL,NULL,NULL,'0x01000100010001',NULL,NULL,'2','To Business Address (Imran-Imran-01-Imran-DOHS-Imran-Road-20)','2016-02-24 17:54:52','2016-03-02 23:59:59','4611686018427388160',1,1,1,'2016-02-24 17:56:27','2016-06-23 14:55:03',1,'2016-06-23 14:55:03');

-- Table structure for table `scrolling_osd_settings` 


CREATE TABLE `scrolling_osd_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `priority` varchar(10) DEFAULT NULL,
  `position` varchar(10) DEFAULT NULL,
  `size` varchar(10) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `color_type` varchar(20) DEFAULT NULL,
  `font` varchar(20) DEFAULT NULL,
  `back_color` varchar(20) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO `scrolling_osd_settings` (`id`,`name`,`priority`,`position`,`size`,`type`,`color_type`,`font`,`back_color`,`created_by`,`parent_id`,`created_at`,`updated_at`) VALUES 
(1,'Test Settings-1','1','NULL','18','NULL','3','-1','-2139062017',1,1,'2016-02-29 13:22:44','NULL'),
(2,'Test Settings-12','1','NULL','18','NULL','3','-1','-2139062017',1,1,'2016-02-29 13:23:01','NULL');

-- Table structure for table `set_top_boxes` 


CREATE TABLE `set_top_boxes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `internal_card_number` varchar(255) DEFAULT '0',
  `external_card_number` varchar(255) DEFAULT NULL,
  `stb_card_provider` int(11) DEFAULT NULL,
  `price` decimal(10,0) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `subscriber_id` int(11) DEFAULT NULL,
  `lco_id` int(11) DEFAULT NULL,
  `is_used` tinyint(1) DEFAULT '0',
  `used_date` datetime DEFAULT NULL COMMENT 'assigned to subscriber',
  `lco_assigned_date` datetime DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `NewIndex1` (`stb_card_provider`,`created_by`,`subscriber_id`,`lco_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Table structure for table `sizes` 


CREATE TABLE `sizes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `value` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

INSERT INTO `sizes` (`id`,`name`,`value`) VALUES 
(1,'8','8'),
(2,'12','12'),
(3,'16','16'),
(4,'18','18'),
(5,'20','20'),
(6,'22','22'),
(7,'24','24'),
(8,'26','26'),
(9,'28','28'),
(10,'36','36'),
(11,'48','48'),
(12,'72','72');

-- Table structure for table `smart_card_providers` 


CREATE TABLE `smart_card_providers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stb_type` varchar(100) DEFAULT NULL,
  `stb_provider` varchar(255) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `address1` varchar(250) DEFAULT NULL,
  `address2` varchar(250) DEFAULT NULL,
  `country` varchar(25) DEFAULT NULL,
  `state` varchar(25) DEFAULT NULL,
  `city` varchar(25) DEFAULT NULL,
  `zip` varchar(25) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

INSERT INTO `smart_card_providers` (`id`,`stb_type`,`stb_provider`,`description`,`address1`,`address2`,`country`,`state`,`city`,`zip`,`email`,`phone`,`parent_id`,`created_by`,`created_at`,`updated_at`,`updated_by`) VALUES 
(1,'CARD TYPE 1','CARD Provider 1','NULL','Card Address Line 1','NULL','NULL','NULL','NULL','NULL','NULL','2147483647',1,1,'2016-02-15 15:20:50','2016-04-30 15:51:35',1),
(2,'CARD TYPE 2','CARD Provider 2','NULL','Card - Address-Address Line 1','NULL','NULL','NULL','NULL','NULL','NULL','2147483647',1,1,'2016-02-15 15:21:27','NULL',NULL),
(3,'Original IC','Original IC','NULL','Address Line 1','NULL','NULL','NULL','NULL','NULL','NULL','1234567890',1,1,'2016-02-16 13:32:55','NULL',NULL),
(4,'Type','IC or Smartcard Supplier','NULL','Address','NULL','Bangladesh','NULL','City','1200','NULL','01738724252',1,1,'2016-03-05 16:28:26','2016-03-05 16:31:14',1),
(5,'IC Provider Type','IC or Smartcard Supplier','Description','Dhaka','Dhaka','India','State','City','1200','final@gmail.com','01738725242',1,1,'2016-04-28 11:56:28','2016-04-28 11:56:40',1),
(6,'Type','Smartcard Supplier-2','NULL','Dhaka','NULL','Bangladesh','NULL','NULL','NULL','NULL','78236326844',1,1,'2016-04-30 15:28:30','2016-04-30 15:28:42',1),
(7,'Regular','Shakil Hasan','NULL','Dhaka','NULL','NULL','NULL','NULL','NULL','NULL','01827464748',1,1,'2016-04-30 15:52:10','2016-04-30 15:52:17',1),
(8,'Final Type','Final Supplier','Description','Dhaka','Dhkaa','Bangladesh','Dhaka','Dhaka','1200','final1@gmail.com','01738725242',1,1,'2016-05-02 11:18:23','2016-05-02 11:19:17',1),
(9,'User IC Type','User IC or Smartcard Supplier','Description','Dhaka','Dhkaa','Bangladesh','Dhaka','Dhaka','1200','useric@gmail.com','0823734744',1,507,'2016-05-02 12:31:21','NULL',NULL),
(10,'Master Type','Master Supplier','Description','Dhaka','Dhkaa','Bangladesh','Dhaka','Dhaka','1200','mastersupplier@gmail.com','02635464848',1,1,'2016-05-03 11:51:25','2016-05-03 11:51:33',1);

-- Table structure for table `smart_cards` 


CREATE TABLE `smart_cards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `internal_card_number` varchar(255) DEFAULT NULL,
  `external_card_number` varchar(255) DEFAULT NULL,
  `smart_card_provider` int(11) DEFAULT NULL,
  `price` decimal(10,0) DEFAULT NULL,
  `subscriber_id` int(11) DEFAULT NULL,
  `lco_id` int(11) DEFAULT NULL,
  `is_used` tinyint(1) NOT NULL DEFAULT '0',
  `used_date` datetime DEFAULT NULL,
  `lco_assigned_date` datetime DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `NewIndex1` (`smart_card_provider`,`subscriber_id`,`lco_id`,`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Table structure for table `stb_providers` 


CREATE TABLE `stb_providers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stb_type` varchar(100) DEFAULT NULL,
  `stb_provider` varchar(255) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `address1` varchar(250) DEFAULT NULL,
  `address2` varchar(250) DEFAULT NULL,
  `country` varchar(25) DEFAULT NULL,
  `state` varchar(25) DEFAULT NULL,
  `city` varchar(25) DEFAULT NULL,
  `zip` varchar(25) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

INSERT INTO `stb_providers` (`id`,`stb_type`,`stb_provider`,`description`,`address1`,`address2`,`country`,`state`,`city`,`zip`,`email`,`phone`,`parent_id`,`created_by`,`created_at`,`updated_at`,`updated_by`) VALUES 
(1,'STB TYPE 1','STB Provider 1','NULL','Address Line 1','NULL','NULL','NULL','NULL','NULL','NULL','1122334455',1,1,'2016-02-15 15:19:33','2016-04-30 15:57:53',1),
(2,'STB TYPE 2','STB Provider 2','NULL','Address Line -Address Line 1','NULL','Bangladesh','NULL','NULL','NULL','NULL','2147483647',1,1,'2016-02-15 15:20:09','NULL',NULL),
(3,'Original','Original','NULL','Address Line 1','NULL','NULL','NULL','NULL','NULL','NULL','1122334456',1,1,'2016-02-16 13:32:34','NULL',NULL),
(4,'Type','Demo provider','NULL','Address','NULL','NULL','NULL','NULL','NULL','NULL','1738725242',1,1,'2016-03-05 16:25:24','NULL',NULL),
(5,'Demo Type','Demo Supplier','Description','Dhaka','Dhaka','Bangladesh','Dhaka','Dhaka','1200','demosupplier@gmail.com','1738725242',1,1,'2016-04-28 11:54:56','2016-04-28 11:55:23',1),
(6,'Regular','Sumon Mia','Regular Provider','Dhaka','Dhka','Bangladesh','Dhaka','Dhaka','1200','sumon.mia@gmail.com','0191673547',1,1,'2016-04-30 15:27:09','2016-04-30 15:54:20',1),
(7,'Demo type','Demo Supplier','NULL','Dhaka','NULL','NULL','NULL','NULL','NULL','NULL','72378236236',1,1,'2016-04-30 15:58:20','NULL',NULL),
(8,'Final Type','Final Provider','Description','Dhaka','Dhkaa','Bangladesh','Dhaka','Dhaka','1200','final1@gmail.com','01948725363',1,1,'2016-05-02 11:12:58','2016-05-02 11:13:34',1),
(9,'User STB Type','User  STB Supplier','Description','Dhaka','Dhkaa','Bangladesh','Dhaka','Dhaka','1200','userstb@gmail.com','01735464646',1,507,'2016-05-02 12:30:21','2016-05-02 12:30:32',507),
(10,'Master Type','Master Supplier','Description','Dhaka','Dhkaa','Bangladesh','Dhaka','Dhaka','1200','mastersupplier@gmail.com','0263547484',1,1,'2016-05-03 11:50:20','NULL',NULL);

-- Table structure for table `sub_areas` 


CREATE TABLE `sub_areas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sub_area_name` varchar(100) NOT NULL,
  `sub_area_code` varchar(10) DEFAULT NULL,
  `country_id` int(11) DEFAULT NULL,
  `division_id` int(11) DEFAULT NULL,
  `district_id` int(11) NOT NULL,
  `area_id` int(11) DEFAULT NULL,
  `lat` varchar(255) DEFAULT NULL,
  `lon` varchar(255) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_areas` (`country_id`),
  KEY `FK_area_division1` (`division_id`),
  KEY `FK_areas_district` (`district_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

INSERT INTO `sub_areas` (`id`,`sub_area_name`,`sub_area_code`,`country_id`,`division_id`,`district_id`,`area_id`,`lat`,`lon`,`parent_id`,`created_by`,`created_at`,`updated_at`) VALUES 
(1,'DOHS','DOH',6,13,8,1,'NULL','NULL',1,1,'2015-11-24 17:37:33','NULL'),
(2,'Demo Sub Area','DEM',12,21,10,4,'NULL','NULL',1,1,'2016-02-10 13:54:43','NULL'),
(3,'Sub Area','SUB',6,14,9,3,'NULL','NULL',1,1,'2016-04-30 14:37:07','NULL'),
(4,'Birampur','BIR',7,20,11,5,'NULL','NULL',1,1,'2016-05-02 10:51:41','NULL'),
(5,'UAE-Aub_Area','UAE',15,22,12,6,'NULL','NULL',1,507,'2016-05-02 12:23:26','NULL'),
(6,'Babu Bazar','BAB',6,13,8,2,'NULL','NULL',1,1,'2016-05-03 11:36:12','NULL');

-- Table structure for table `subscriber_parking_reassign_logs` 


CREATE TABLE `subscriber_parking_reassign_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pairing_id` int(8) DEFAULT NULL,
  `subscriber_id` int(11) DEFAULT NULL,
  `lco_id` int(11) DEFAULT NULL,
  `stb_id` int(11) DEFAULT NULL,
  `card_id` int(11) DEFAULT NULL,
  `stb_card_pairing_id` int(11) DEFAULT NULL,
  `parking_date` datetime DEFAULT NULL,
  `is_cas_pairing` tinyint(1) DEFAULT '0',
  `free_stb` tinyint(1) DEFAULT '0',
  `free_card` tinyint(1) DEFAULT '0',
  `free_subscription_fee` tinyint(1) DEFAULT '0',
  `status` tinyint(1) DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

INSERT INTO `subscriber_parking_reassign_logs` (`id`,`pairing_id`,`subscriber_id`,`lco_id`,`stb_id`,`card_id`,`stb_card_pairing_id`,`parking_date`,`is_cas_pairing`,`free_stb`,`free_card`,`free_subscription_fee`,`status`,`created_at`,`updated_at`,`created_by`,`updated_by`,`parent_id`) VALUES 
(1,1000054,398,1,123,69,58,'2016-04-16 16:20:03',0,1,1,1,0,'2016-04-16 16:20:03','NULL',1,NULL,1),
(2,1000066,370,1,136,81,67,'2016-04-30 16:28:00',0,1,1,1,0,'2016-04-30 16:28:00','NULL',1,NULL,1),
(3,1000001,343,207,95,42,69,'2016-04-30 17:00:40',0,0,0,0,0,'2016-04-30 17:00:40','NULL',207,NULL,207),
(4,1000071,401,1,131,78,72,'2016-05-02 14:49:23',0,1,1,1,0,'2016-05-02 14:49:23','NULL',507,NULL,1),
(5,1000002,366,207,96,43,74,'2016-05-02 16:18:53',0,0,0,0,0,'2016-05-02 16:18:53','NULL',207,NULL,207),
(6,1000050,403,1,122,64,78,'2016-05-03 12:25:12',0,0,0,0,0,'2016-05-03 12:25:12','NULL',1,NULL,1),
(7,1000017,343,207,105,51,79,'2016-05-03 13:52:07',0,0,0,0,0,'2016-05-03 13:52:07','NULL',207,NULL,207);

-- Table structure for table `subscriber_parkings` 


CREATE TABLE `subscriber_parkings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pairing_id` int(8) DEFAULT NULL,
  `subscriber_id` int(11) DEFAULT NULL,
  `lco_id` int(11) DEFAULT NULL,
  `stb_id` int(11) DEFAULT NULL,
  `card_id` int(11) DEFAULT NULL,
  `stb_card_pairing_id` int(11) DEFAULT NULL,
  `parking_date` datetime DEFAULT NULL,
  `is_cas_pairing` tinyint(1) DEFAULT '0',
  `free_stb` tinyint(1) DEFAULT '0',
  `free_card` tinyint(1) DEFAULT '0',
  `free_subscription_fee` tinyint(1) DEFAULT '0',
  `status` tinyint(1) DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

INSERT INTO `subscriber_parkings` (`id`,`pairing_id`,`subscriber_id`,`lco_id`,`stb_id`,`card_id`,`stb_card_pairing_id`,`parking_date`,`is_cas_pairing`,`free_stb`,`free_card`,`free_subscription_fee`,`status`,`created_at`,`updated_at`,`created_by`,`updated_by`,`parent_id`) VALUES 
(5,1000054,370,1,123,69,54,'2016-04-16 00:00:00',0,1,1,1,1,'2016-04-16 12:24:46','2016-04-16 16:32:36',1,1,1),
(6,1000066,510,1,136,81,66,'2016-04-30 00:00:00',0,1,1,1,1,'2016-04-30 16:27:37','2016-04-30 16:00:00',1,1,1),
(7,1000001,339,207,95,42,1,'2016-04-30 00:00:00',0,0,0,0,1,'2016-04-30 17:00:29','2016-04-30 17:00:40',207,207,207),
(8,1000071,520,1,131,78,71,'2016-05-02 00:00:00',0,1,1,1,1,'2016-05-02 14:49:12','2016-05-02 14:00:23',507,1,1),
(9,1000002,340,207,96,43,2,'2016-05-02 00:00:00',0,0,0,0,1,'2016-05-02 16:18:43','2016-05-02 16:00:53',207,207,207),
(10,1000050,398,1,122,64,50,'2016-05-03 00:00:00',0,0,0,0,1,'2016-05-03 12:24:56','2016-05-03 12:00:12',1,1,1),
(11,1000017,339,207,105,51,17,'2016-05-03 00:00:00',0,0,0,0,1,'2016-05-03 13:51:56','2016-05-03 13:00:07',207,207,207);

-- Table structure for table `subscriber_profiles` 


CREATE TABLE `subscriber_profiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subscriber_name` varchar(64) DEFAULT NULL,
  `address1` text,
  `address2` text,
  `country_id` int(11) DEFAULT NULL,
  `division_id` int(11) DEFAULT NULL,
  `district_id` int(11) DEFAULT NULL,
  `area_id` int(11) DEFAULT NULL,
  `post_code` varchar(10) DEFAULT NULL,
  `sub_area_id` int(11) DEFAULT NULL,
  `road_id` int(11) DEFAULT NULL,
  `contact` varchar(11) DEFAULT NULL,
  `is_same_as_contact` tinyint(1) DEFAULT '0',
  `billing_contact` varbinary(11) DEFAULT NULL,
  `photo` text,
  `identity_type` varchar(10) DEFAULT NULL,
  `identity_number` varchar(20) DEFAULT NULL,
  `identity_attachment` text,
  `subscription_copy` text,
  `region_l1_code` varchar(20) DEFAULT '0',
  `region_l2_code` varchar(20) DEFAULT '0',
  `region_l3_code` varchar(20) DEFAULT '0',
  `region_l4_code` varchar(20) DEFAULT '0',
  `lat` varchar(100) DEFAULT NULL,
  `long` varchar(100) DEFAULT NULL,
  `is_foc` tinyint(1) DEFAULT '0',
  `foc_control_room` tinyint(1) DEFAULT '0',
  `foc_others` tinyint(1) DEFAULT '0',
  `reference_type` varchar(10) DEFAULT NULL COMMENT 'LCO or Others',
  `reference_id` int(11) DEFAULT NULL,
  `remarks` text,
  `is_hide` tinyint(1) DEFAULT '0' COMMENT 'show_every_one',
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `token` varchar(60) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=266 DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

INSERT INTO `subscriber_profiles` (`id`,`subscriber_name`,`address1`,`address2`,`country_id`,`division_id`,`district_id`,`area_id`,`post_code`,`sub_area_id`,`road_id`,`contact`,`is_same_as_contact`,`billing_contact`,`photo`,`identity_type`,`identity_number`,`identity_attachment`,`subscription_copy`,`region_l1_code`,`region_l2_code`,`region_l3_code`,`region_l4_code`,`lat`,`long`,`is_foc`,`foc_control_room`,`foc_others`,`reference_type`,`reference_id`,`remarks`,`is_hide`,`parent_id`,`created_by`,`token`,`created_at`,`updated_at`,`updated_by`) VALUES 
(129,'Md. Rakib','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01916687307',1,'01916687307','public/uploads/subscribers/339/photo/photo_160512120706.jpeg','Passport','1990765678901','public/uploads/subscribers/339/identity/identity160512120710.jpeg','public/uploads/subscribers/339/subscription-copy/subscription-copy160512120713.jpeg','1','1','1','2','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'2bfb3dce9ae098696ea81ea69ec4154b','2016-02-11 10:39:18','2016-05-12 12:07:13',NULL),
(130,'Mehedi Hasan','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01738725242',1,'01738725242','NULL','NULL','345464574575','NULL','NULL','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'0b2a65bdfa4edee6683bcc255eb0c84d','2016-02-11 10:43:04','2016-02-11 10:43:31',NULL),
(131,'Tarikul Islam','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01738725242',1,'01738725242','NULL','Nation ID','34534534534','NULL','NULL','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,324,'cf54daf9a8c00645344b3d7679d6a53f','2016-02-11 11:55:48','2016-02-16 17:07:18',NULL),
(132,'jahirul Islam','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01837437859',1,'01837437859','NULL','NULL','2353253252','NULL','NULL','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'d136a174bdf93371f25a950a877db6de','2016-02-11 12:48:20','2016-02-11 12:48:45',NULL),
(154,'Ronty','asdf','NULL',6,13,8,NULL,'NULL',NULL,NULL,'1234',0,'NULL','NULL','NULL','NULL','NULL','NULL','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'c07a42ea1f98315313aff8a6043f0b04','2016-02-24 12:13:18','2016-06-27 11:01:52',NULL),
(155,'test','NULL','NULL',6,13,8,NULL,'NULL',NULL,NULL,'23424',0,'NULL','NULL','NULL','NULL','NULL','NULL','1','1','1','NULL','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'c3da0457a3e5c6531b206fbc962217cc','2016-02-24 12:17:15','NULL',NULL),
(156,'test2','NULL','NULL',6,13,8,NULL,'NULL',NULL,NULL,'23422',0,'NULL','NULL','NULL','NULL','NULL','NULL','1','1','1','NULL','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'6c9b3456aa05963299cac865445a5c52','2016-02-24 12:19:52','NULL',NULL),
(157,'test3','NULL','NULL',6,13,8,NULL,'NULL',NULL,NULL,'2342424',0,'NULL','NULL','NULL','NULL','NULL','NULL','1','1','1','NULL','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'08ea01dc3fd25bccdf3d3613b70959b6','2016-02-24 12:24:00','NULL',NULL),
(158,'Foc','NULL','NULL',6,13,8,1,'NULL',1,NULL,'12345678901',1,'12345678901','public/uploads/subscribers/370/photo/photo_160418182934.jpeg','Nation ID','22113311223344455555','public/uploads/subscribers/370/identity/identity160418182939.jpeg','public/uploads/subscribers/370/subscription-copy/subscription-copy160418182950.jpeg','5','7','6','6','NULL','NULL',1,1,0,'LCO',207,'NEW FOC',0,1,1,'3b1cb82291a37b311409f28352e2b183','2016-02-28 10:34:22','2016-04-28 16:34:48',1),
(182,'Test4','NULL','NULL',6,13,8,NULL,'NULL',NULL,NULL,'23444444444',0,'NULL','NULL','NULL','NULL','NULL','NULL','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'1f6354f97c730eeb4cd210683ea59170','2016-02-28 16:37:57','2016-02-28 16:38:03',NULL),
(183,'Test5','NULL','NULL',6,13,8,NULL,'NULL',NULL,NULL,'322222222',0,'NULL','NULL','NULL','NULL','NULL','NULL','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'b4821004ef676fd5e85ce1e6dfc54f32','2016-02-28 16:40:14','2016-02-28 16:40:19',NULL),
(184,'New Subscriber','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01738725242',1,'01738725242','NULL','NULL','2354353456345','NULL','NULL','1','1','1','2','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'de6128cf4b9b4b4fb6019846bfa76acc','2016-02-29 10:52:59','2016-02-29 10:56:45',NULL),
(185,'Ashis Kumer Khan','Dhaka','Panthapath',6,13,8,1,'NULL',1,1,'01744556699',1,'01744556699','NULL','Nation ID','35453453463463636','NULL','NULL','5','7','6','6','NULL','NULL',1,0,1,'LCO',NULL,'NULL',0,1,1,'f1d444bdfe2e6b011e0bcb76934653b5','2016-02-29 12:55:54','2016-02-29 12:56:52',NULL),
(186,'New FOC','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01738725242',1,'01738725242','NULL','Nation ID','01738725242','NULL','NULL','2','4','2','3','NULL','NULL',1,1,1,'LCO',207,'Remarks',0,1,1,'99f1c2fffb974f69d7a1677501125a67','2016-03-03 11:51:13','2016-03-03 11:59:07',NULL),
(187,'New FOC SB','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01738724232',1,'01738724232','NULL','Nation ID','01738724232','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL',1,1,1,'OTHER',1,'asdfasd',0,1,1,'fb906f9618934bb95415b1dc81b3ee7e','2016-03-03 12:01:19','NULL',NULL),
(188,'Test FOC','NULL','NULL',NULL,NULL,NULL,NULL,'NULL',NULL,NULL,'1234',0,'NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL',1,0,0,'NULL',NULL,'NULL',0,1,1,'15702c416f7e277acec2270250106c5c','2016-03-03 12:03:24','NULL',NULL),
(189,'TestFoc2','NULL','NULL',NULL,NULL,NULL,NULL,'NULL',NULL,NULL,'1234',0,'NULL','public/uploads/subscribers/402/photo/photo_1456985721.jpeg','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL',1,0,0,'NULL',NULL,'NULL',0,1,1,'f2e58276a607a601fbf52b89156f6f14','2016-03-03 12:05:54','2016-03-03 12:15:21',NULL),
(190,'Sayem','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01738725242',1,'01738725242','public/uploads/subscribers/403/photo/photo_160303123029.jpeg','NULL','NULL','public/uploads/subscribers/403/identity/identity160303123037.jpeg','public/uploads/subscribers/403/subscription-copy/subscription-copy160303123048.jpeg','NULL','NULL','NULL','NULL','NULL','NULL',1,0,0,'NULL',NULL,'NULL',0,1,1,'d465cc58c3b295d571fbd53205b389a4','2016-03-03 12:30:16','2016-03-03 12:30:48',NULL),
(191,'MD. Sumon','Dhanmondi','Dhanmondi',6,13,8,1,'NULL',1,1,'01916685171',1,'01916685171','public/uploads/subscribers/411/photo/photo_160308160738.jpeg','NULL','4534545645756775','public/uploads/subscribers/411/identity/identity160308160756.jpeg','public/uploads/subscribers/411/subscription-copy/subscription-copy160308160801.jpeg','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'0761db73a056d146033f6893a5a77fbf','2016-03-06 10:48:04','2016-03-08 16:08:01',NULL),
(192,'MD Rasel','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01738725242',1,'01738725242','public/uploads/subscribers/413/photo/photo_160306114626.jpeg','NULL','NID-2342343434534','public/uploads/subscribers/413/identity/identity160306114629.jpeg','public/uploads/subscribers/413/subscription-copy/subscription-copy160306114633.jpeg','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'396b232dc677e7f25db193d722ab5443','2016-03-06 11:46:11','2016-03-06 11:46:33',NULL),
(193,'MD. Rase','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01738275242',1,'01738275242','NULL','NULL','NID-23423234234','NULL','NULL','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,412,'d254b27db79e844b81f61e62d29d3a32','2016-03-06 12:13:27','2016-03-06 12:13:47',NULL),
(194,'Kalpo Mondol','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01738725242',1,'01738725242','public/uploads/subscribers/415/photo/photo_160310123412.jpeg','NULL','235435325','public/uploads/subscribers/415/identity/identity160310123417.jpeg','public/uploads/subscribers/415/subscription-copy/subscription-copy160310123422.jpeg','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'2a9d2c073b1939be2cd40b8daecbb136','2016-03-10 12:31:47','2016-03-10 12:39:35',NULL),
(195,'Fresh FOC','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01673926252',1,'01673926252','NULL','Nation ID','NID-32233454','NULL','NULL','2','4','2','3','NULL','NULL',1,0,0,'OTHER',1,'Remarks',0,1,1,'10432a76f713cc238c143ab6a784d1d4','2016-03-15 11:48:08','2016-03-15 11:48:37',NULL),
(196,'Jimy Gomz','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01738725242',1,'01738725242','public/uploads/subscribers/421/photo/photo_160419115832.jpeg','NULL','34534533','public/uploads/subscribers/421/identity/identity160419115835.jpeg','public/uploads/subscribers/421/subscription-copy/subscription-copy160419115839.jpeg','1','1','1','NULL','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'df2cf816453dd1ebf45a4874a5e8d276','2016-04-19 11:55:15','2016-04-19 11:58:39',NULL),
(224,'Subscriber - 1','Dhaka','Dhaka',NULL,13,8,1,'NULL',1,NULL,'01738725242',1,'01738725242','NULL','NID','34543533454','NULL','NULL','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'a8b1f9e061a7d8e96881b7d68212f1ff','2016-04-23 17:35:44','NULL',NULL),
(225,'Subscriber - 2','Dhaka','Dhaka',6,13,8,NULL,'NULL',NULL,NULL,'01672927910',1,'01672927910','NULL','NID','343463664','NULL','NULL','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'9bf917e50f3817e99f24c09b6cfc7298','2016-04-23 17:35:45','NULL',NULL),
(226,'Subscriber-3','Jessore','Jesore',6,NULL,NULL,NULL,'NULL',NULL,NULL,'01718772581',1,'01718772581','NULL','NID','4564564','NULL','NULL','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'ae6832e88460e984111c123f6a7cd50c','2016-04-23 17:35:45','NULL',NULL),
(227,'Subscriber - 1','Dhaka','Dhaka',NULL,13,8,1,'NULL',1,NULL,'01738725242',1,'01738725242','NULL','NID','34543533454','NULL','NULL','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'5ddf177e6829d2b3f6472b6d1d520cac','2016-04-23 17:40:14','NULL',NULL),
(228,'Subscriber - 2','Dhaka','Dhaka',6,13,8,NULL,'NULL',NULL,NULL,'01672927910',1,'01672927910','NULL','NID','343463664','NULL','NULL','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'5bb136447148ae12b01a1a6a9972de32','2016-04-23 17:40:14','NULL',NULL),
(229,'Subscriber-3','Jessore','Jesore',6,NULL,NULL,NULL,'NULL',NULL,NULL,'01718772581',1,'01718772581','public/uploads/subscribers/482/photo/photo_160423174629.jpeg','NID','4564564','public/uploads/subscribers/482/identity/identity160423174633.jpeg','public/uploads/subscribers/482/subscription-copy/subscription-copy160423174637.jpeg','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'a576cd3a9991244ec091edc2fa4e6310','2016-04-23 17:40:14','2016-04-23 17:46:37',NULL),
(230,'Muntasir Rafi','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01738725242',1,'01738725242','public/uploads/subscribers/483/photo/photo_160423174217.jpeg','NULL','5334664643','public/uploads/subscribers/483/identity/identity160423174222.jpeg','public/uploads/subscribers/483/subscription-copy/subscription-copy160423174320.jpeg','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'36d92f73a18192e041aa28251e795d60','2016-04-23 17:41:36','2016-04-23 17:43:20',NULL),
(231,'Rabiul Islam','Dhaka','Dhaka',6,13,8,1,'NULL',1,4,'01817645674',1,'01817645674','public/uploads/subscribers/484/photo/photo_160423174448.jpeg','NULL','34534534','public/uploads/subscribers/484/identity/identity160423174449.jpeg','public/uploads/subscribers/484/subscription-copy/subscription-copy160423174453.jpeg','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'73e618efd529dfcca223629c9f3ae8ed','2016-04-23 17:44:16','2016-04-23 17:44:53',NULL),
(232,'Final LCO','Dhaka','Dhaka',6,13,8,1,'NULL',1,4,'01916687307',1,'01916687307','NULL','NULL','4422442233','NULL','NULL','1','1','1','NULL','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'ef1f3a09873d3f8af34431798058a257','2016-04-23 17:55:48','NULL',NULL),
(233,'Final Check','Dhaka','Dhaka',6,13,8,1,'NULL',1,2,'01916687307',1,'01916687307','NULL','NULL','3242434553','NULL','NULL','1','1','1','NULL','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'3e9cee443ba25b5eb5871cbd5b79cbd5','2016-04-23 17:56:53','NULL',NULL),
(234,'Final','Dhaka','Dhaka',6,13,8,1,'NULL',1,2,'01916687307',1,'01916687307','public/uploads/subscribers/487/photo/photo_160423180038.jpeg','NULL','345435345','public/uploads/subscribers/487/identity/identity160423180044.jpeg','public/uploads/subscribers/487/subscription-copy/subscription-copy160423180048.jpeg','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'df94861d63a977e18f5504eda3edd720','2016-04-23 18:00:14','2016-04-23 18:00:48',NULL),
(235,'Milon Kumar','Dhak','Dhaka',6,13,8,1,'NULL',1,NULL,'01738725242',1,'01738725242','public/uploads/subscribers/493/photo/photo_160428121043.jpeg','Nation ID','3433534','public/uploads/subscribers/493/identity/identity160428121047.jpeg','public/uploads/subscribers/493/subscription-copy/subscription-copy160428121052.jpeg','5','7','6','6','NULL','NULL',1,0,0,'LCO',448,'Remarks',0,1,1,'ee47d2165c01bc9c5be786a8ceb25be4','2016-04-28 12:09:23','2016-04-28 12:11:34',1),
(236,'Master Check','Dhaka','Dhaka',6,13,8,1,'NULL',1,NULL,'01672927910',1,'01672927910','public/uploads/subscribers/494/photo/photo_160428121611.jpeg','Nation ID','34334335','public/uploads/subscribers/494/identity/identity160428121614.jpeg','public/uploads/subscribers/494/subscription-copy/subscription-copy160428121617.jpeg','1','1','1','1','NULL','NULL',1,1,1,'LCO',448,'Remarks',0,1,1,'33214bc720e2fa9ed3cc8d1f2c7298e2','2016-04-28 12:14:54','2016-04-28 12:16:47',1),
(237,'New FOC','Dhaka','Dhaka',6,13,8,1,'NULL',1,5,'01738275242',1,'01738275242','public/uploads/subscribers/497/photo/photo_160428170510.jpeg','Nation ID','32454768768','public/uploads/subscribers/497/identity/identity160428170517.jpeg','public/uploads/subscribers/497/subscription-copy/subscription-copy160428170524.jpeg','2','4','2','3','NULL','NULL',1,0,0,'LCO',448,'NULL',0,1,1,'78f069cbb2eb3ed344c2557615da47bc','2016-04-28 17:04:03','2016-04-28 17:05:24',NULL),
(238,'Jhangir Alam','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01738725242',1,'01738725242','NULL','Passport','23423423','NULL','NULL','2','4','2','3','NULL','NULL',1,0,0,'OTHER',1,'Remarks',0,1,1,'89dced072ee8156b591a9d8f77a81462','2016-04-30 12:21:57','2016-04-30 12:22:38',NULL),
(239,'Masud Alam','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01738725242',1,'01738725242','NULL','Nation ID','2352534645645','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL',1,0,0,'LCO',207,'asfasd',0,1,1,'aedf064b4d731e44eb23d534b37301b4','2016-04-30 12:28:26','NULL',NULL),
(240,'Ezaz  Ahmed','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01738735343',1,'01738735343','NULL','Nation ID','23423523523','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL',1,0,0,'OTHER',1,'sdfsd',0,1,1,'c0fdbc3c72c308f60b61c8167d9719af','2016-04-30 12:31:41','NULL',NULL),
(241,'Masusm Ahmed','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01738625242',1,'01738625242','NULL','Nation ID','345346436464','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL',1,0,0,'LCO',446,'qwdrqw',0,1,1,'a684b11c139019ec8ccc5a545a7993e2','2016-04-30 12:33:29','NULL',NULL),
(242,'Ahmed Ali','NULL','NULL',NULL,NULL,NULL,NULL,'NULL',NULL,NULL,'01738274743',0,'NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL',1,0,0,'NULL',NULL,'NULL',0,1,1,'ef4fa124a77fe6ee2fda67e746ce5a61','2016-04-30 12:35:01','NULL',NULL),
(245,'Demo FOC','Dhaka','Dhaka',NULL,NULL,NULL,NULL,'NULL',NULL,NULL,'01738635333',0,'NULL','NULL','NULL','NULL','NULL','NULL','2','4','2','3','NULL','NULL',1,0,0,'NULL',NULL,'NULL',0,1,1,'b18d26f34fdda7773d4c6e804dcee1ba','2016-04-30 12:46:12','2016-04-30 12:47:01',NULL),
(246,'Jalal Uddin','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'0182656788',1,'0182656788','NULL','Nation ID','dfgerger','NULL','NULL','2','4','2','3','NULL','NULL',1,0,0,'LCO',207,'NULL',0,1,1,'7046a73fb9c657eee99f4a78f452d8af','2016-04-30 16:00:45','2016-04-30 16:01:30',NULL),
(247,'Mamun Mollik','Dhaka','NULL',NULL,NULL,NULL,NULL,'NULL',NULL,NULL,'544657757',0,'NULL','NULL','NULL','NULL','NULL','NULL','2','4','2','3','NULL','NULL',1,0,0,'NULL',NULL,'NULL',0,1,1,'a541e55ef5bad98e0d64d5b82b2f1538','2016-04-30 16:04:35','2016-04-30 16:05:13',NULL),
(248,'Humaion Kabir','NULL','NULL',NULL,NULL,NULL,NULL,'NULL',NULL,NULL,'34543234234',0,'NULL','public/uploads/subscribers/510/photo/photo_160430160711.jpeg','NULL','NULL','public/uploads/subscribers/510/identity/identity160430160716.jpeg','public/uploads/subscribers/510/subscription-copy/subscription-copy160430160719.jpeg','4','5','3','4','NULL','NULL',1,0,0,'NULL',NULL,'NULL',0,1,1,'b208ce89d02ca787700801c9c5f4f843','2016-04-30 16:06:11','2016-04-30 16:08:09',1),
(249,'Sadikur Rahman','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'0173938383',1,'0173938383','NULL','NULL','32445455','NULL','NULL','1','1','1','2','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'5956721177e65aa6d8c01e06a7f1b4b0','2016-04-30 16:46:31','2016-04-30 16:46:54',NULL),
(250,'Final FOC','Dhaka','Dhaka',6,13,8,1,'NULL',1,NULL,'01738726252',1,'01738726252','public/uploads/subscribers/517/photo/photo_160502114337.jpeg','Nation ID','2323235','public/uploads/subscribers/517/identity/identity160502114340.jpeg','public/uploads/subscribers/517/subscription-copy/subscription-copy160502114343.jpeg','2','4','2','3','NULL','NULL',1,1,1,'LCO',207,'Remarks',0,1,1,'ee0ff35a647c9babd96d55c87a7c7d40','2016-05-02 11:42:32','2016-05-02 11:44:21',1),
(251,'User FOC SUBS','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01727346445',1,'01727346445','public/uploads/subscribers/520/photo/photo_160502124101.jpeg','Nation ID','3453454353','public/uploads/subscribers/520/identity/identity160502124104.jpeg','public/uploads/subscribers/520/subscription-copy/subscription-copy160502124107.jpeg','2','4','2','3','NULL','NULL',1,1,0,'OTHER',1,'Remarks',0,1,507,'7813d2045378cb56f3dac506dfdd4a2e','2016-05-02 12:40:06','2016-05-02 12:41:07',NULL),
(252,'Ali Haider','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'024567894',1,'024567894','public/uploads/subscribers/523/photo/photo_160502153821.jpeg','NULL','64446776','public/uploads/subscribers/523/identity/identity160502153824.jpeg','public/uploads/subscribers/523/subscription-copy/subscription-copy160502153828.jpeg','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'71306acc3624add5375eb3f8086a9d4f','2016-05-02 15:36:11','2016-05-02 15:38:28',NULL),
(254,'Import Test','Dhaka','Dhaka',6,13,8,NULL,'NULL',NULL,NULL,'NULL',1,'NULL','NULL','NULL','NULL','NULL','NULL','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'be39689a5d48bcf201213dea0e257773','2016-05-02 15:47:14','NULL',NULL),
(255,'Mahfuz Ullah','Dhaka','Dhaka',6,13,8,1,'NULL',1,2,'01738747755',1,'01738747755','public/uploads/subscribers/526/photo/photo_160502162426.jpeg','NULL','23423423','public/uploads/subscribers/526/identity/identity160502162429.jpeg','public/uploads/subscribers/526/subscription-copy/subscription-copy160502162432.jpeg','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,522,'48cb55785f1c711f2c775b0fa1a9c05d','2016-05-02 16:22:49','2016-05-02 16:24:32',NULL),
(256,'Pervez Hasan','Dhaka','Dhaka',6,13,8,NULL,'NULL',NULL,NULL,'NULL',1,'NULL','NULL','NULL','NULL','NULL','NULL','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,522,'5c8228dd65286445cf2d95abe85ef709','2016-05-02 16:50:43','NULL',NULL),
(257,'Pervez Hasan','Dhaka','Dhaka',6,13,8,NULL,'NULL',NULL,NULL,'NULL',1,'NULL','NULL','NULL','NULL','NULL','NULL','1','1','1','2','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,522,'54b0aceac372b448b03bad1ecd13a524','2016-05-02 17:11:59','NULL',NULL),
(258,'Pervez Hasan','Dhaka','Dhaka',6,13,8,NULL,'NULL',NULL,NULL,'NULL',1,'NULL','NULL','NULL','NULL','NULL','NULL','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'cb57ff52c28cd248d6c9a2a254716477','2016-05-02 17:12:31','NULL',NULL),
(259,'Master FOC','Dhaka','Dhaka',6,13,8,2,'NULL',6,10,'01625437484',1,'01625437484','public/uploads/subscribers/532/photo/photo_160503115757.jpeg','Nation ID','223343535','public/uploads/subscribers/532/identity/identity160503115800.jpeg','public/uploads/subscribers/532/subscription-copy/subscription-copy160503115803.jpeg','2','4','2','3','NULL','NULL',1,1,1,'OTHER',1,'Remarks',0,1,1,'c8af0010c5fd1970cc8edc4d923c2ac3','2016-05-03 11:57:03','2016-05-03 11:58:03',NULL),
(260,'New Subscriber','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'02928383344',1,'02928383344','NULL','NULL','2we23e2323432432','NULL','NULL','1','1','1','1','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,536,'a7e3838bca648a2584e372b0c98f9bb3','2016-05-03 14:02:56','2016-05-03 14:03:17',NULL),
(261,'New Subscriber','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01724364747',1,'01724364747','NULL','NULL','232424','NULL','NULL','2','4','2','3','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,538,539,'fdb62d3eca01895e40c729148e285240','2016-05-04 16:41:11','2016-05-04 16:41:32',NULL),
(262,'Testify','NULL','NULL',NULL,NULL,NULL,NULL,'NULL',NULL,NULL,'30838377333',0,'NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL',1,0,0,'NULL',NULL,'NULL',0,1,1,'cca4bf6d71090e18f1f442d734b28c7f','2016-05-04 16:45:23','NULL',NULL),
(263,'New FOC Subscriber','Dhaka','Dhaka',6,13,8,1,'NULL',1,1,'01828373474',1,'01828373474','NULL','Nation ID','2132134123412','NULL','NULL','2','4','2','3','NULL','NULL',1,1,1,'LCO',445,'Remarks',0,1,1,'82a75d382c7fb780a9ca974ffde4269e','2016-05-04 16:47:39','2016-05-04 16:48:08',NULL),
(264,'LofinCheck','NULL','NULL',NULL,NULL,NULL,NULL,'NULL',NULL,NULL,'8374364656',0,'NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL',1,0,0,'NULL',NULL,'NULL',0,1,1,'15d9eefe80665d4cfc0a8c39b90f8606','2016-05-04 16:53:24','NULL',NULL),
(265,'Checking Subscriber','NULL','NULL',6,13,8,NULL,'NULL',NULL,NULL,'01982727626',0,'NULL','NULL','NULL','NULL','NULL','NULL','1','1','1','NULL','NULL','NULL',0,0,0,'NULL',NULL,'NULL',0,207,207,'7243b8d1aacc08c1a9098b89810345d4','2016-06-16 10:36:13','2016-06-16 15:20:41',NULL);

-- Table structure for table `subscriber_stb_smartcards` 


CREATE TABLE `subscriber_stb_smartcards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pairing_id` int(8) DEFAULT NULL,
  `subscriber_id` int(11) DEFAULT NULL,
  `lco_id` int(11) DEFAULT NULL,
  `stb_id` int(11) DEFAULT NULL,
  `card_id` int(11) DEFAULT NULL,
  `is_cas_pairing` tinyint(1) DEFAULT '0',
  `free_stb` tinyint(1) DEFAULT '0',
  `free_card` tinyint(1) DEFAULT '0',
  `free_subscription_fee` tinyint(1) DEFAULT '0',
  `remarks` text,
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `NewIndex1` (`subscriber_id`,`lco_id`,`stb_id`,`card_id`,`created_by`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

INSERT INTO `subscriber_stb_smartcards` (`id`,`pairing_id`,`subscriber_id`,`lco_id`,`stb_id`,`card_id`,`is_cas_pairing`,`free_stb`,`free_card`,`free_subscription_fee`,`remarks`,`parent_id`,`created_by`,`created_at`,`updated_at`,`updated_by`) VALUES 
(1,1000001,339,207,93,39,0,0,0,0,'NULL',207,207,'2016-06-25 15:09:34','NULL',NULL),
(2,1000002,340,207,94,41,0,0,0,0,'NULL',207,207,'2016-06-25 15:10:06','NULL',NULL),
(3,1000003,367,207,98,44,0,0,0,0,'NULL',207,207,'2016-06-25 15:10:37','NULL',NULL),
(4,1000004,366,207,96,42,0,0,0,0,'NULL',207,207,'2016-06-25 15:25:16','NULL',NULL);

-- Table structure for table `types` 


CREATE TABLE `types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `value` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

INSERT INTO `types` (`id`,`name`,`value`) VALUES 
(1,'Arial','NULL'),
(2,'Microsoft Sans Serif','1'),
(3,'Microsoft Ya Hei','2'),
(4,'STSong','3'),
(5,'KaiTi','4');

-- Table structure for table `user_addon_packages` 


CREATE TABLE `user_addon_packages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `package_id` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `user_stb_smart_id` int(11) DEFAULT NULL,
  `package_start_date` datetime DEFAULT NULL,
  `package_expire_date` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `no_of_days` int(11) DEFAULT NULL,
  `user_package_type_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `update_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

INSERT INTO `user_addon_packages` (`id`,`user_id`,`package_id`,`status`,`user_stb_smart_id`,`package_start_date`,`package_expire_date`,`created_by`,`no_of_days`,`user_package_type_id`,`created_at`,`updated_at`,`parent_id`,`update_by`) VALUES 
(3,411,4,1,47,'2016-04-06 10:26:26','2016-04-07 23:59:59',207,1,1,'2016-04-06 10:26:36','NULL',207,NULL),
(4,411,6,1,47,'2016-04-07 13:38:38','2016-05-07 23:59:59',411,30,1,'2016-04-07 13:38:39','NULL',411,NULL),
(5,421,6,1,59,'2016-04-19 12:08:08','2016-05-19 23:59:59',207,30,1,'2016-04-19 12:08:45','NULL',207,NULL),
(6,514,6,1,68,'2016-04-30 16:53:53','2016-05-30 23:59:59',207,30,1,'2016-04-30 16:53:12','NULL',207,NULL),
(9,529,4,1,76,'2016-05-03 15:33:33','2016-05-04 23:59:59',529,1,1,'2016-05-03 15:33:47','NULL',529,NULL);

-- Table structure for table `user_package_assign_types` 


CREATE TABLE `user_package_assign_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(200) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

INSERT INTO `user_package_assign_types` (`id`,`type`,`created_at`,`created_by`) VALUES 
(1,'Package Assign','2015-12-13 15:00:00',1),
(2,'Package Migrate','2015-12-13 15:00:00',1),
(3,'Charge Fee','2015-12-13 15:00:00',1),
(4,'Cash Receive','2015-12-13 15:00:00',1),
(5,'Package Reassign','2015-12-13 15:00:00',1),
(6,'Bank Receive','NULL',NULL),
(7,'POS Receive','NULL',NULL),
(8,'Scratch Card Receive','NULL',NULL),
(9,'Bkash Receive','NULL',NULL);

-- Table structure for table `user_packages` 


CREATE TABLE `user_packages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `user_stb_smart_id` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `charge_type` tinyint(1) DEFAULT '0',
  `package_start_date` datetime DEFAULT NULL,
  `package_expire_date` datetime DEFAULT NULL,
  `no_of_days` int(11) DEFAULT NULL,
  `user_package_type_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_user_packages_users1_idx` (`user_id`),
  KEY `fk_user_packages_packages1_idx` (`package_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Table structure for table `user_packages_history` 


CREATE TABLE `user_packages_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `package_assign_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `user_stb_smart_id` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `charge_type` tinyint(1) DEFAULT '0',
  `package_start_date` datetime DEFAULT NULL,
  `package_expire_date` datetime DEFAULT NULL,
  `no_of_days` int(11) DEFAULT NULL,
  `user_package_type_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Table structure for table `user_types` 


CREATE TABLE `user_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_type` varchar(10) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

INSERT INTO `user_types` (`id`,`user_type`,`is_active`) VALUES 
(1,'MSO',1),
(2,'LCO',1),
(3,'Subscriber',1);

-- Table structure for table `users` 


CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `profile_id` int(11) NOT NULL,
  `username` varchar(40) DEFAULT NULL,
  `email` varchar(300) DEFAULT NULL,
  `password` varchar(40) DEFAULT NULL,
  `user_type` enum('MSO','LCO','Subscriber','Group') DEFAULT NULL,
  `role_id` int(11) NOT NULL,
  `user_status` tinyint(1) DEFAULT NULL,
  `is_remote_access_enabled` tinyint(1) DEFAULT '0',
  `is_first_loggedin` tinyint(1) DEFAULT '0',
  `is_iptv` tinyint(1) DEFAULT '0' COMMENT '0 = DVB , 1 = IPTV',
  `clientType` varchar(20) DEFAULT NULL,
  `macAddress` varchar(20) DEFAULT NULL,
  `imeiNumber` varchar(20) DEFAULT NULL,
  `operatorId` varchar(20) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `token` varchar(40) DEFAULT NULL,
  `iptv_token` varchar(100) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_users_profiles1_idx` (`profile_id`),
  KEY `fk_users_roles1_idx` (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=555 DEFAULT CHARSET=utf8;

INSERT INTO `users` (`id`,`profile_id`,`username`,`email`,`password`,`user_type`,`role_id`,`user_status`,`is_remote_access_enabled`,`is_first_loggedin`,`is_iptv`,`clientType`,`macAddress`,`imeiNumber`,`operatorId`,`parent_id`,`created_by`,`token`,`iptv_token`,`created_at`,`updated_at`,`updated_by`) VALUES 
(1,12,'superadmin','superadmin@gmail.com','81dc9bdb52d04dc20036dbd8313ed055','MSO',1,1,0,1,0,'NULL','NULL','NULL','NULL',1,1,'763245cd2b1285cfda412dc1f6dc64b2','NULL','2015-12-05 15:01:51','2015-12-31 14:32:42',NULL),
(207,52,'lco_admin','lco_admin@mail.com','81dc9bdb52d04dc20036dbd8313ed055','LCO',3,1,0,1,0,'NULL','NULL','NULL','NULL',1,1,'0d88553fba6291b47d4a4acc6d1dd666','NULL','2015-12-05 15:52:40','2015-12-31 14:31:49',NULL),
(320,31,'testuser','testmsouser@mail.com','25d55ad283aa400af464c76d713c07ad','MSO',2,1,0,1,0,'NULL','NULL','NULL','NULL',1,1,'7baffdf1675b00f147ebee55e97d4173','NULL','2016-02-10 13:45:04','2016-02-14 13:12:56',NULL),
(322,102,'faysalahmed','faysal@gmail.com','ab8d9b7ca79e4f8420c47774f48e5cf5','LCO',3,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'5acda3a978be2182af59d7e46f1e641d','NULL','2016-02-10 15:48:58','2016-02-10 16:20:06',NULL),
(323,103,'usermsolco','usermsolco@mail.com','25d55ad283aa400af464c76d713c07ad','LCO',3,1,0,1,0,'NULL','NULL','NULL','NULL',1,320,'9d7340e41bf2e0e6e11a225edf0522da','NULL','2016-02-10 16:45:21','2016-05-12 12:55:48',NULL),
(324,104,'demolcouser','demolcouser@gmail.com','25d55ad283aa400af464c76d713c07ad','LCO',4,1,0,1,0,'NULL','NULL','NULL','NULL',207,207,'93eed58ae5a44eede12bbaa83b9c192a','NULL','2016-02-10 17:29:30','2016-02-10 17:32:09',NULL),
(339,129,'rakib','rakib@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,1,0,'NULL','NULL','NULL','NULL',207,207,'2bfb3dce9ae098696ea81ea69ec4154b','NULL','2016-02-11 10:39:18','2016-05-07 16:15:51',NULL),
(340,130,'mehedi','mehedi@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'0b2a65bdfa4edee6683bcc255eb0c84d','NULL','2016-02-11 10:43:04','2016-02-11 10:43:19',NULL),
(341,131,'tarikul','tarikul@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'cf54daf9a8c00645344b3d7679d6a53f','NULL','2016-02-11 11:55:48','2016-02-11 11:56:14',NULL),
(343,132,'jahir','jahir@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'d136a174bdf93371f25a950a877db6de','NULL','2016-02-11 12:48:20','2016-02-11 12:48:33',NULL),
(344,32,'kalpomondol','kalpo@gmail.com','25d55ad283aa400af464c76d713c07ad','MSO',2,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'2038522d9ccec21a8c71c34f749bd09f','NULL','2016-02-11 13:37:09','2016-02-11 13:41:38',NULL),
(366,154,'ronty','ronty@email.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,1,0,'NULL','NULL','NULL','NULL',207,207,'c07a42ea1f98315313aff8a6043f0b04','NULL','2016-02-24 12:13:18','2016-06-27 11:01:46',NULL),
(367,155,'test@email.com','test@email.com','93942e96f5acd83e2e047ad8fe03114d','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'c3da0457a3e5c6531b206fbc962217cc','NULL','2016-02-24 12:17:15','NULL',NULL),
(368,156,'test2@email.com','test2@email.com','cc17e134d4bee8f5646851d4141ff372','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'6c9b3456aa05963299cac865445a5c52','NULL','2016-02-24 12:19:52','NULL',NULL),
(369,157,'test3@gmail.com','test3@gmail.com','19f84906f4412abf6066aaa92fe9d6c1','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'08ea01dc3fd25bccdf3d3613b70959b6','NULL','2016-02-24 12:24:00','NULL',NULL),
(370,158,'foc@test.com','foc@test.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'3b1cb82291a37b311409f28352e2b183','NULL','2016-02-28 10:34:22','2016-04-28 16:31:29',1),
(394,182,'test4@email.com','test4@email.com','745afdf2f65ee492b82e70c8545c6a80','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'1f6354f97c730eeb4cd210683ea59170','NULL','2016-02-28 16:37:57','NULL',NULL),
(395,183,'test5@email.com','test5@email.com','513b8bc2782783e48cfaedb93a04c041','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'b4821004ef676fd5e85ce1e6dfc54f32','NULL','2016-02-28 16:40:14','NULL',NULL),
(396,184,'newsubs','newsubs@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'de6128cf4b9b4b4fb6019846bfa76acc','NULL','2016-02-29 10:52:59','2016-02-29 10:55:44',NULL),
(397,105,'newlcouser','newlcouser@gmail.com','25d55ad283aa400af464c76d713c07ad','LCO',4,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'af78451af80a55110e2b1198b0a40873','NULL','2016-02-29 11:07:52','2016-02-29 11:12:13',NULL),
(398,185,'ashis@plaastech.com','ashis@plaastech.com','cb02eeb3a1af2a9863b8d3a061fab6ae','Subscriber',5,1,1,0,0,'NULL','NULL','NULL','NULL',1,1,'f1d444bdfe2e6b011e0bcb76934653b5','NULL','2016-02-29 12:55:54','2016-02-29 12:56:27',1),
(399,186,'newfoc@gmail.com','newfoc@gmail.com','3fe19f1d30a9954fc1915f26b9b16d5e','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'99f1c2fffb974f69d7a1677501125a67','NULL','2016-03-03 11:51:13','NULL',NULL),
(400,187,'chklco111@mail.com','chklco111@mail.com','d6078faf86530c79126d73d7ca00fa72','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'fb906f9618934bb95415b1dc81b3ee7e','NULL','2016-03-03 12:01:19','NULL',NULL),
(401,188,'test4foc@email.com','test4foc@email.com','6703c9f1dfdb4336c6c92a6d4ac59346','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'15702c416f7e277acec2270250106c5c','NULL','2016-03-03 12:03:24','NULL',NULL),
(402,189,'testfoc2@gmail.com','testfoc2@gmail.com','cff4ef82212f9cbbf35ffdb4aada659d','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'f2e58276a607a601fbf52b89156f6f14','NULL','2016-03-03 12:05:55','NULL',NULL),
(403,190,'sayem@mail.com','sayem@mail.com','a2a7d685e3908eba698fc038ffeddb8e','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'d465cc58c3b295d571fbd53205b389a4','NULL','2016-03-03 12:30:16','NULL',NULL),
(404,106,'newlco@gmail.com','newlco@gmail.com','c980ab83f119607d4285d98b1a7ce817','LCO',3,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'6ead0500c98f12a66ecfbd8c41ec1cc9','NULL','2016-03-03 14:06:17','NULL',NULL),
(405,107,'anotherlco1@mail.com','anotherlco1@mail.com','fdc8315287956316586c3a458dfa1cd4','LCO',3,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'9e472441e09338de3a42109ad85c40c7','NULL','2016-03-03 14:11:04','NULL',NULL),
(406,33,'mewmso@gmail.com','mewmso@gmail.com','ae209287874b071d9a85810af58dd48a','MSO',2,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'8f7738391117f16aa2a74c082a3be655','NULL','2016-03-03 14:12:40','NULL',NULL),
(407,34,'mewan@mail.com','mewan@mail.com','151cd4e9413247e3d34c528a05089da3','MSO',2,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'e730e6af34bc20c605dfb7bbfa6790c8','NULL','2016-03-03 14:17:51','NULL',NULL),
(408,35,'faysal3@gmail.com','faysal3@gmail.com','079f767518fed39db89dc661135b3646','MSO',2,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'f7556243ccd6370ce11fd5a7d985c547','NULL','2016-03-03 14:26:22','NULL',NULL),
(409,36,'test_mso_user@gmail.com','test_mso_user@gmail.com','e49391081f9b6b029ba36c1892d0b526','MSO',2,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'3ac600cc80ead586a505849d4b169db3','NULL','2016-03-03 14:53:36','NULL',NULL),
(410,108,'newlco1@gmail.com','newlco1@gmail.com','1a8d49dfa5d55903e835878c66644e94','LCO',4,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'affd5428bb95a61f241efaf80363848c','NULL','2016-03-05 11:32:59','2016-03-05 11:33:17',NULL),
(411,191,'mdsumon@gmail.com','tarikulislam@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,1,0,'NULL','NULL','NULL','NULL',207,207,'0761db73a056d146033f6893a5a77fbf','NULL','2016-03-06 10:48:04','2016-04-03 17:26:46',NULL),
(412,109,'testlcouser@mail.com','testlcouser@mail.com','25d55ad283aa400af464c76d713c07ad','LCO',4,1,0,1,0,'NULL','NULL','NULL','NULL',207,207,'1a3ae55c7a5cd2c46b901d9304fdd016','NULL','2016-03-06 11:11:48','2016-03-06 11:16:59',NULL),
(413,192,'md.rasel@gmail.com','md.rasel@gmail.com','b70bff983d41230a6e2e155599f7b4ec','Subscriber',5,1,0,1,0,'NULL','NULL','NULL','NULL',207,207,'396b232dc677e7f25db193d722ab5443','NULL','2016-03-06 11:46:11','2016-04-03 15:14:07',NULL),
(414,193,'md.rasel1@gmail.com','md.rasel1@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'d254b27db79e844b81f61e62d29d3a32','NULL','2016-03-06 12:13:27','2016-03-06 12:13:39',NULL),
(415,194,'kalpomondol@gmail.com','kalpomondol@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'2a9d2c073b1939be2cd40b8daecbb136','NULL','2016-03-10 12:31:47','2016-03-10 12:32:41',NULL),
(416,195,'freshfoc@gmail.com','freshfoc@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'10432a76f713cc238c143ab6a784d1d4','NULL','2016-03-15 11:48:08','2016-03-15 11:48:20',1),
(418,38,'newmsouser','newmsouser@email.com','25d55ad283aa400af464c76d713c07ad','MSO',8,1,0,1,0,'NULL','NULL','NULL','NULL',1,1,'e7ff7844707b7dba77733752fbc2b7ad','NULL','2016-03-27 15:48:39','2016-03-27 15:49:20',NULL),
(419,110,'newlcouser@email.com','newlcouser@email.com','d4452df49e2ff94aacc06b52c04b1d19','LCO',7,1,0,1,0,'NULL','NULL','NULL','NULL',207,207,'90db840a93b64e6c0f7fbe1b37490142','NULL','2016-03-27 15:58:27','2016-03-27 16:00:21',NULL),
(420,111,'demolco','demolco@mail.com','25d55ad283aa400af464c76d713c07ad','LCO',4,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'3888541ed1ff90d29392fc39b7266453','NULL','2016-04-19 11:37:08','2016-04-19 11:39:34',NULL),
(421,196,'jimygomz','jimygomz@mail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'df2cf816453dd1ebf45a4874a5e8d276','NULL','2016-04-19 11:55:15','2016-04-19 11:55:27',NULL),
(423,113,'abcd','abcd@test.com','e2fc714c4727ee9395f324cd2e7f331f','LCO',3,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'b838c0a2c0e08ff65703d1383c3ef97d','NULL','2016-04-21 11:29:28','NULL',NULL),
(442,132,'kamrul','kamrul@gmail.com','25d55ad283aa400af464c76d713c07ad','LCO',3,1,0,1,0,'NULL','NULL','NULL','NULL',1,1,'ab12db90a3797b705f4423116071dd0f','NULL','2016-04-23 15:32:48','2016-04-23 15:34:41',NULL),
(443,133,'momin','mominul@gmail.com','25d55ad283aa400af464c76d713c07ad','LCO',4,1,0,1,0,'NULL','NULL','NULL','NULL',442,442,'d8a03fcd0bad122b73da0341328fa12c','NULL','2016-04-23 15:35:43','2016-04-23 15:39:32',NULL),
(444,134,'nayan','nayan@gmail.com','25d55ad283aa400af464c76d713c07ad','LCO',3,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'ae182cb0d887d2b826c748f0045df444','NULL','2016-04-23 15:41:52','NULL',NULL),
(445,135,'momin123','monin19@mail.com','25d55ad283aa400af464c76d713c07ad','LCO',3,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'26957acc0ad5b248c683a3969a9e65bf','NULL','2016-04-23 15:41:52','NULL',NULL),
(446,136,'kmamun','kmamum@yahoo.com','25d55ad283aa400af464c76d713c07ad','LCO',3,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'ff98f44e4b094efdacb9dd75af9e25e7','NULL','2016-04-23 15:41:53','NULL',NULL),
(447,137,'nazim','nazim@gmail.com','25d55ad283aa400af464c76d713c07ad','LCO',3,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'ea84cdc7edb6d4c7b4fc4fed3a9ab739','NULL','2016-04-23 15:51:11','NULL',NULL),
(448,138,'sumon','sumon@mail.com','25d55ad283aa400af464c76d713c07ad','LCO',3,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'dbe60666bc570ffaf7bd742c54dd8c6a','NULL','2016-04-23 15:51:11','NULL',NULL),
(449,139,'jalal','jalal88@yahoo.com','25d55ad283aa400af464c76d713c07ad','LCO',3,1,0,1,0,'NULL','NULL','NULL','NULL',1,1,'e8be7890fffb828a1a227544d2e0d809','NULL','2016-04-23 15:51:11','2016-05-05 17:59:34',NULL),
(477,224,'sub1','sib1@gmail.com','1b52eb8ef2c1875cfdf3ffbe9e3c05da','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'a8b1f9e061a7d8e96881b7d68212f1ff','NULL','2016-04-23 17:35:44','NULL',NULL),
(478,225,'sub2','sub2@gmail.com','5fbef65269a99bddc2106251dd89b1dc','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'9bf917e50f3817e99f24c09b6cfc7298','NULL','2016-04-23 17:35:45','NULL',NULL),
(479,226,'sub3','sub3@gmail.com','8c8a5d351a982bd6165bb1fc6c041410','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'ae6832e88460e984111c123f6a7cd50c','NULL','2016-04-23 17:35:45','NULL',NULL),
(480,227,'sub5','sib5@gmail.com','b11aac2c5399f4d098215c166dc5b5d9','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'5ddf177e6829d2b3f6472b6d1d520cac','NULL','2016-04-23 17:40:14','NULL',NULL),
(481,228,'sub6','sub6@gmail.com','a37a8649bcf2beebd3c4ea73609638cb','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'5bb136447148ae12b01a1a6a9972de32','NULL','2016-04-23 17:40:14','NULL',NULL),
(482,229,'sub7','sub7@gmail.com','daf406525f731d784bcf209d3658d426','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'a576cd3a9991244ec091edc2fa4e6310','NULL','2016-04-23 17:40:14','NULL',NULL),
(483,230,'rafi345','rafi345@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'36d92f73a18192e041aa28251e795d60','NULL','2016-04-23 17:41:36','2016-04-23 17:41:52',NULL),
(484,231,'rabiul','rabiul@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'73e618efd529dfcca223629c9f3ae8ed','NULL','2016-04-23 17:44:16','2016-04-23 17:44:31',NULL),
(485,232,'finallco@gmail.com','finallco@gmail.com','c539d6640aeeee6c8e10825794278c63','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'ef1f3a09873d3f8af34431798058a257','NULL','2016-04-23 17:55:48','NULL',NULL),
(486,233,'finalcheck@gmail.com','finalcheck@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'3e9cee443ba25b5eb5871cbd5b79cbd5','NULL','2016-04-23 17:56:53','2016-04-23 17:57:23',NULL),
(487,234,'final','final@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'df94861d63a977e18f5504eda3edd720','NULL','2016-04-23 18:00:14','2016-04-23 18:00:27',NULL),
(489,2,'test_group@email.com','test_group@email.com','25d55ad283aa400af464c76d713c07ad','Group',3,1,0,1,0,'NULL','NULL','NULL','NULL',1,1,'d693e597cc2cd7e0524b3937e8422686','NULL','2016-04-26 17:41:41','2016-04-27 11:22:49',NULL),
(490,3,'demogroup','demogroup@gmail.com','25d55ad283aa400af464c76d713c07ad','Group',3,1,0,1,0,'NULL','NULL','NULL','NULL',1,1,'ef0f6939051d44fc7b4b270ebfa6b39c','NULL','2016-04-27 11:55:23','2016-04-27 12:01:50',NULL),
(492,5,'groupuser','groupuser@gmail.com','25d55ad283aa400af464c76d713c07ad','Group',15,1,0,1,0,'NULL','NULL','NULL','NULL',490,490,'b61866b11f72c6ab2446942c5a8ffab9','NULL','2016-04-28 11:12:16','2016-05-07 16:52:28',NULL),
(493,235,'milon','milon@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,1,0,'NULL','NULL','NULL','NULL',1,1,'ee47d2165c01bc9c5be786a8ceb25be4','NULL','2016-04-28 12:09:24','2016-06-16 12:29:08',1),
(494,236,'mastercheck','mastercheck@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,1,0,'NULL','NULL','NULL','NULL',1,1,'33214bc720e2fa9ed3cc8d1f2c7298e2','NULL','2016-04-28 12:14:54','2016-06-14 15:52:53',1),
(495,140,'sumonkumar','sumonkumar@gmail.com','25d55ad283aa400af464c76d713c07ad','LCO',3,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'d65319ed36676d63c2b8507e6d964834','NULL','2016-04-28 12:23:34','2016-04-28 12:23:58',NULL),
(496,6,'newgroup','newgroup@gmail.com','25d55ad283aa400af464c76d713c07ad','Group',3,1,0,1,0,'NULL','NULL','NULL','NULL',1,1,'bbc4220555734806f6d424030171bda1','NULL','2016-04-28 16:39:53','2016-05-03 11:24:26',NULL),
(497,237,'newfoc1','newfoc1@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'78f069cbb2eb3ed344c2557615da47bc','NULL','2016-04-28 17:04:03','2016-04-28 17:04:16',1),
(498,238,'jhangiralam','jhangiralam@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'89dced072ee8156b591a9d8f77a81462','NULL','2016-04-30 12:21:57','2016-04-30 12:22:11',1),
(499,239,'masud','masud@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'aedf064b4d731e44eb23d534b37301b4','NULL','2016-04-30 12:28:26','2016-04-30 12:28:38',1),
(500,240,'ezaz','ezaz@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'c0fdbc3c72c308f60b61c8167d9719af','NULL','2016-04-30 12:31:42','2016-04-30 12:31:53',1),
(501,241,'masum','masum@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'a684b11c139019ec8ccc5a545a7993e2','NULL','2016-04-30 12:33:29','2016-04-30 12:33:40',1),
(502,242,'ahmed','ahmed@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'ef4fa124a77fe6ee2fda67e746ce5a61','NULL','2016-04-30 12:35:01','2016-04-30 12:35:15',1),
(505,245,'demofoc','demofoc@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'b18d26f34fdda7773d4c6e804dcee1ba','NULL','2016-04-30 12:46:12','2016-04-30 12:46:25',1),
(506,39,'mominul.islam@gmail.com','mominul.islam@gmail.com','5630ee2765dbe8aad6b5e94198641e7b','MSO',2,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'30523f710e73641806693bbaf42c338b','NULL','2016-04-30 14:34:34','2016-04-30 15:41:55',NULL),
(507,40,'finalcheck','finalcheck1@gmail.com','25d55ad283aa400af464c76d713c07ad','MSO',22,1,0,1,0,'NULL','NULL','NULL','NULL',1,1,'a2341dd4b2757255579a2e528f2db08f','NULL','2016-04-30 15:42:53','2016-05-02 12:16:54',NULL),
(508,246,'jalalonline','jalalonline@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'7046a73fb9c657eee99f4a78f452d8af','NULL','2016-04-30 16:00:45','2016-04-30 16:00:59',1),
(509,247,'mamun@gmail.com','mamun@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'a541e55ef5bad98e0d64d5b82b2f1538','NULL','2016-04-30 16:04:35','2016-04-30 16:04:50',1),
(510,248,'humaion@gmail.com','humaion@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'b208ce89d02ca787700801c9c5f4f843','NULL','2016-04-30 16:06:11','2016-04-30 16:07:41',1),
(511,41,'check@gmail.com','check@gmail.com','4ba4a30b1efff2cd600744948a622f3a','MSO',2,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'963b6f463033d28d11b9951dbc632ba2','NULL','2016-04-30 16:10:53','NULL',NULL),
(512,141,'sabuj@gmail.com','sabuj@gmail.com','0393de5bee9ad0508962d9653e4f2e87','LCO',3,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'1fabb986f960f425d75f0a65df2fc85f','NULL','2016-04-30 16:12:54','2016-04-30 16:14:02',NULL),
(513,142,'parvez','parvez@gmail.com','25d55ad283aa400af464c76d713c07ad','LCO',4,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'3bb8be15eda7948e134d7d2fe58db949','NULL','2016-04-30 16:33:35','2016-04-30 16:34:26',NULL),
(514,249,'sadeek','sadeek@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'5956721177e65aa6d8c01e06a7f1b4b0','NULL','2016-04-30 16:46:31','2016-04-30 16:46:44',NULL),
(515,143,'rubelmia','rubelmia@gmail.com','4984bdca22918635de426b47b6524151','LCO',20,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'7fc754271bf7fdb348d76809be9bf57a','NULL','2016-04-30 17:32:30','2016-04-30 17:33:25',NULL),
(516,42,'shariful','shariful@gmail.com','25d55ad283aa400af464c76d713c07ad','MSO',22,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'679c7afbdcfb75de74db28b9e60b97ff','NULL','2016-05-02 10:48:41','2016-05-02 10:49:06',NULL),
(517,250,'finalfoc','finalfoc@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'ee0ff35a647c9babd96d55c87a7c7d40','NULL','2016-05-02 11:42:32','2016-05-02 11:44:15',1),
(518,144,'importlco','importlco@gmail.com','727875a480e046bd0b7334f8d743b83a','LCO',3,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'8ba3cefa3854c7499362779f89b6d728','NULL','2016-05-02 12:03:37','NULL',NULL),
(519,43,'shamim','shamim@gmail.com','25d55ad283aa400af464c76d713c07ad','MSO',23,1,0,1,0,'NULL','NULL','NULL','NULL',1,507,'975458731c7859c2d20a19201aac5809','NULL','2016-05-02 12:21:04','2016-05-02 14:41:50',NULL),
(520,251,'userfocsubs','userfocsubs@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,507,'7813d2045378cb56f3dac506dfdd4a2e','NULL','2016-05-02 12:40:06','2016-05-02 12:40:19',507),
(521,145,'userlco','userlco@gmail.com','25d55ad283aa400af464c76d713c07ad','LCO',3,1,0,0,0,'NULL','NULL','NULL','NULL',1,507,'6d3da4a357473df505c7efaa384b3304','NULL','2016-05-02 12:42:04','2016-05-02 12:42:16',NULL),
(522,146,'ruhul','ruhul@gmail.com','25d55ad283aa400af464c76d713c07ad','LCO',4,1,0,1,0,'NULL','NULL','NULL','NULL',207,207,'8e7f0cffd40004e4898843faabae9ab4','NULL','2016-05-02 15:30:04','2016-05-02 16:20:04',NULL),
(523,252,'alihaider','alihaider@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'71306acc3624add5375eb3f8086a9d4f','NULL','2016-05-02 15:36:11','2016-05-02 15:36:26',NULL),
(525,254,'import','import@gmail.com','93473a7344419b15c4219cc2b6c64c6f','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'be39689a5d48bcf201213dea0e257773','NULL','2016-05-02 15:47:14','NULL',NULL),
(526,255,'mahfuz','mahfuz@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'48cb55785f1c711f2c775b0fa1a9c05d','NULL','2016-05-02 16:22:49','2016-05-02 16:23:02',NULL),
(527,256,'pervez','pervez@gmail.com','d5528ea18cb78d6ba8b2828944a644f0','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,522,'5c8228dd65286445cf2d95abe85ef709','NULL','2016-05-02 16:50:43','NULL',NULL),
(528,257,'pervez1','pervez1@gmail.com','39d1cb57e97b449b83d6bd5da7683ec2','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,522,'54b0aceac372b448b03bad1ecd13a524','NULL','2016-05-02 17:11:59','NULL',NULL),
(529,258,'pervez12','pervez12@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,1,0,'NULL','NULL','NULL','NULL',207,207,'cb57ff52c28cd248d6c9a2a254716477','NULL','2016-05-02 17:12:31','2016-05-02 17:13:57',NULL),
(530,7,'tarikul1','tarikul1@gmail.com','25d55ad283aa400af464c76d713c07ad','Group',15,1,0,1,0,'NULL','NULL','NULL','NULL',496,496,'15ef79047a9b15145cbf25fcffe566ec','NULL','2016-05-03 11:26:00','2016-05-03 11:26:51',NULL),
(531,44,'mastermsouser','mastermsouser@gmail.com','25d55ad283aa400af464c76d713c07ad','MSO',25,1,0,1,0,'NULL','NULL','NULL','NULL',1,1,'adfced3e5666fbc2bf6a9515e9e281e1','NULL','2016-05-03 11:33:44','2016-05-03 13:42:23',NULL),
(532,259,'masterfoc','masterfoc@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'c8af0010c5fd1970cc8edc4d923c2ac3','NULL','2016-05-03 11:57:03','2016-05-03 11:57:14',1),
(533,147,'masterlco','masterlco@gmail.com','25d55ad283aa400af464c76d713c07ad','LCO',3,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'3eb8803999a3cc67b820e97cfdb35c5a','NULL','2016-05-03 12:12:19','2016-05-03 12:12:31',NULL),
(534,148,'importlco12','masterimplco@mail.com','25d55ad283aa400af464c76d713c07ad','LCO',3,1,0,1,0,'NULL','NULL','NULL','NULL',1,1,'cf29fe3245a8e4fb7178d83f8958bdf1','NULL','2016-05-03 12:16:18','2016-05-04 16:01:26',NULL),
(535,8,'mastergroup','mastergroup@gmail.com','25d55ad283aa400af464c76d713c07ad','Group',3,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'1f784c27fc9e0b2c2e882f6db8964d89','NULL','2016-05-03 12:26:07','2016-05-03 12:26:20',NULL),
(536,149,'masterlcouser','masterlcouser@mail.com','25d55ad283aa400af464c76d713c07ad','LCO',4,1,0,1,0,'NULL','NULL','NULL','NULL',207,207,'a8dd68b0211103def1f271dcb8db3ea1','NULL','2016-05-03 13:43:58','2016-05-03 14:01:14',NULL),
(537,260,'newsubscriber','newsubscriber@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,1,0,'NULL','NULL','NULL','NULL',207,207,'a7e3838bca648a2584e372b0c98f9bb3','NULL','2016-05-03 14:02:56','2016-05-04 16:51:59',NULL),
(538,150,'logincheck','logincheck@gmail.com','25d55ad283aa400af464c76d713c07ad','LCO',3,1,0,1,0,'NULL','NULL','NULL','NULL',1,1,'0c655d9d8a43c6c1492d2a120efd59b0','NULL','2016-05-04 16:34:13','2016-05-04 16:36:15',NULL),
(539,151,'asif','asif@gmail.com','25d55ad283aa400af464c76d713c07ad','LCO',4,1,0,1,0,'NULL','NULL','NULL','NULL',538,538,'7cf3bd8d27d8db00d470e55a7e44d90c','NULL','2016-05-04 16:37:28','2016-05-04 16:38:43',NULL),
(540,152,'testcheck','testcheck@gmail.com','25d55ad283aa400af464c76d713c07ad','LCO',4,1,1,0,0,'NULL','NULL','NULL','NULL',538,538,'2341006726eb0f42d6195319921e54b5','NULL','2016-05-04 16:39:51','2016-05-04 16:40:19',NULL),
(541,261,'subscriber','subscriber@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,1,0,0,'NULL','NULL','NULL','NULL',538,538,'fdb62d3eca01895e40c729148e285240','NULL','2016-05-04 16:41:11','2016-05-04 16:41:25',NULL),
(542,262,'testify@email.com','testify@email.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,1,0,0,'NULL','NULL','NULL','NULL',1,1,'cca4bf6d71090e18f1f442d734b28c7f','NULL','2016-05-04 16:45:23','2016-05-04 16:45:38',1),
(543,263,'newfocsubs','newfocsubs@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'82a75d382c7fb780a9ca974ffde4269e','NULL','2016-05-04 16:47:39','2016-05-04 16:50:10',1),
(544,264,'logincheck2','logincheck2@gmail.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,1,0,'NULL','NULL','NULL','NULL',1,1,'15d9eefe80665d4cfc0a8c39b90f8606','NULL','2016-05-04 16:53:24','2016-05-04 16:54:43',1),
(545,9,'testnewgroup','testnewgroup@gmail.com','25d55ad283aa400af464c76d713c07ad','Group',3,1,0,1,0,'NULL','NULL','NULL','NULL',1,1,'800fa235df63f4a78c13f25125ced96f','NULL','2016-05-04 16:56:53','2016-05-09 13:51:53',NULL),
(551,153,'sadeek','sadeek@gmail.com','42271bc9000892281f359af806989b97','LCO',3,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'1b59d653277a115ce1ac7ff046077905','NULL','2016-05-08 11:27:27','NULL',NULL),
(552,154,'sadeek-1','sadeek2@gmail.com','7a6ebc7e894d3607c9f75b990b19f70c','LCO',3,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'11ad849a033830510a55201994b5f5af','NULL','2016-05-08 11:27:27','NULL',NULL),
(553,155,'sadeek-2','sadeek1@gmail.com','b7c42c8b5082efea2287d6a3b34c6e3e','LCO',3,1,0,0,0,'NULL','NULL','NULL','NULL',1,1,'1cfd76332c85fbaabc2b2bc30d2986c5','NULL','2016-05-08 11:27:27','NULL',NULL),
(554,265,'checking_subscriber','checking_subscriber@email.com','25d55ad283aa400af464c76d713c07ad','Subscriber',5,1,0,0,0,'NULL','NULL','NULL','NULL',207,207,'7243b8d1aacc08c1a9098b89810345d4','NULL','2016-06-16 10:36:13','2016-06-16 10:36:29',NULL);

--
-- PROCEDURES
--

DELIMITER $$
CREATE DEFINER=`root`@`%` PROCEDURE `GetRegions`()
BEGIN
	select id,name,region_l1_code, region_l2_code,region_l3_code,region_l4_code,hex_code 
	from
	(
		select a.region_l1_name name,a.id,a.region_l1_code,a.region_l2_code,a.region_l3_code,a.region_l4_code,a.hex_code 
		from region_level_1 a
		union
		select b.region_l2_name name,b.id,b.region_l1_code,b.region_l2_code,b.region_l3_code,b.region_l4_code,b.hex_code  
		from region_level_2 b
		union
		select d.region_l3_name name,d.id,d.region_l1_code,d.region_l2_code,d.region_l3_code,d.region_l4_code,d.hex_code 
		from region_level_3 d
		union
		select e.region_l4_name name,e.id,e.region_l1_code,e.region_l2_code,e.region_l3_code,e.region_l4_code,e.hex_code 
		from region_level_4 e
	) c
	order by region_l1_code,region_l2_code,region_l3_code,region_l4_code;
    END$$

DELIMITER ;

--
-- Views
--

-- Structure for view `view_collector_statements` 


CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `view_collector_statements` AS (select `billing_lco_collector`.`id` AS `id`,`billing_lco_collector`.`name` AS `name`,`GetUserPackageAssignTypeName`(`billing_subscriber_transactions`.`user_package_assign_type_id`) AS `description`,`billing_lco_collector`.`lco_id` AS `lco_id`,`billing_cash_transection`.`subscriber_transection_id` AS `subscriber_transection_id`,`billing_subscriber_transactions`.`credit` AS `credit`,`billing_subscriber_transactions`.`debit` AS `debit`,`billing_subscriber_transactions`.`balance` AS `balance`,`billing_subscriber_transactions`.`transaction_date` AS `transaction_date` from ((`billing_lco_collector` join `billing_cash_transection` on((`billing_lco_collector`.`id` = `billing_cash_transection`.`collector_id`))) join `billing_subscriber_transactions` on((`billing_cash_transection`.`subscriber_transection_id` = `billing_subscriber_transactions`.`id`))) where ((`billing_subscriber_transactions`.`demo` <> '1') and (`billing_subscriber_transactions`.`user_package_assign_type_id` in (4,7)))) union (select `billing_lco_collector`.`id` AS `id`,`billing_lco_collector`.`name` AS `name`,`GetUserPackageAssignTypeName`(`billing_subscriber_transactions`.`user_package_assign_type_id`) AS `description`,`billing_lco_collector`.`lco_id` AS `lco_id`,`billing_pos_transactions`.`subscriber_transaction_id` AS `subscriber_transaction_id`,`billing_subscriber_transactions`.`credit` AS `credit`,`billing_subscriber_transactions`.`debit` AS `debit`,`billing_subscriber_transactions`.`balance` AS `balance`,`billing_subscriber_transactions`.`transaction_date` AS `transaction_date` from ((`billing_lco_collector` join `billing_pos_transactions` on((`billing_lco_collector`.`id` = `billing_pos_transactions`.`collector_id`))) join `billing_subscriber_transactions` on((`billing_pos_transactions`.`subscriber_transaction_id` = `billing_subscriber_transactions`.`id`))) where ((`billing_subscriber_transactions`.`demo` <> '1') and (`billing_subscriber_transactions`.`user_package_assign_type_id` in (4,7))));

-- Structure for view `sub_menus` 


CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `sub_menus` AS (select `m2`.`id` AS `sub_menu_id`,`m2`.`menu_type` AS `sub_menu_type`,`m2`.`menu_name` AS `sub_menu`,`m2`.`route` AS `route`,`m2`.`display_order` AS `m2_display`,`m2`.`parent` AS `parent`,`m2`.`visible` AS `visible` from `plaas_menus` `m2` where ((`m2`.`parent` <> 0) and (`m2`.`visible` = 1)) order by `m2`.`display_order`);

INSERT INTO `sub_menus` (`sub_menu_id`,`sub_menu_type`,`sub_menu`,`route`,`m2_display`,`parent`,`visible`) VALUES 
(76,'LCO','Package List','add-on-package',1,75,1),
(182,'LCO','Available Card List','scratch-card-available',1,83,1),
(181,'Group','Available Card List','scratch-card-available',1,170,1),
(33,'MSO','Generate Card / List','scratch-card-generate',1,32,1),
(100,'LCO','Conditional Mail','tools-conditional-mail',1,99,1),
(174,'Group','Scratch-Card','payments-scratch-card',1,173,1),
(159,'Group','LCO','lco',1,155,1),
(45,'MSO','Conditional Mail','tools-conditional-mail',1,44,1),
(71,'LCO','Subscriber List','subscriber',1,70,1),
(98,'LCO','Park Subscriber','park-subscriber',1,97,1),
(167,'Subscriber','Scratch Recharge','subscription-scratch-recharge',1,166,1),
(138,'MSO','Park Subscriber','park-subscriber',1,137,1),
(55,'MSO','Active Subscriber','reports-active-subscriber',1,54,1),
(154,'Group','Users','groups',1,153,1),
(151,'MSO','Groups','groups',1,150,1),
(64,'LCO','Bank Accounts','bank-accounts',1,63,1),
(66,'LCO','LCO User','lco',1,65,1),
(74,'LCO','Packages','package',1,73,1),
(122,'MSO','Cash','cash',1,37,1),
(10,'MSO','Program Manage','program',1,9,1),
(80,'LCO','Assign NVOD','assign-nvod',1,79,1),
(13,'MSO','Package List','add-on-package',1,12,1),
(6,'MSO','Geo Location Manage','location',1,5,1),
(17,'MSO','Create NVOD Channel','create-nvod-channel',1,16,1),
(20,'MSO','STB Provider','stb-provider',1,19,1),
(2,'MSO','User Role','user-role',1,1,1),
(109,'LCO','Active Subscriber','reports-active-subscriber',1,108,1),
(27,'MSO','LCO Manage','lco',1,26,1),
(25,'MSO','Subscriber Lists','foc-subscriber',1,24,1),
(156,'Group','LCO Users','lco-users',2,155,1),
(152,'MSO','Assign LCO','assign-lco',2,150,1),
(7,'MSO','System Info','organization',2,5,1),
(3,'MSO','Permissions','permissions',2,1,1),
(81,'LCO','Show NVOD Time-table','nvod-time-table',2,79,1),
(119,'LCO','POS ','pos-settings',2,63,1),
(135,'LCO','User Role','user-role',2,65,1),
(77,'LCO','Assign package','add-on-package-assign',2,75,1),
(11,'MSO','Package Manage','package',2,9,1),
(72,'LCO','Recharge Account','subscriber-recharge',2,70,1),
(141,'LCO','Assign From Parking Zone','assign-from-parking',2,97,1),
(56,'MSO','Assigned Package','reports-assigned-package',2,54,1),
(90,'LCO','Bank','bank-payment',2,88,1),
(21,'MSO','IC or Smart card Provider','icsmartcard-provider',2,19,1),
(101,'LCO','Conditional Search','tools-conditional-search',2,99,1),
(172,'Group','Distribution List','scratch-card-distribution',2,170,1),
(38,'MSO','Bank','bank-payment',2,37,1),
(18,'MSO','Configure NVOD','configure-nvod',2,16,1),
(46,'MSO','Conditional Search','tools-conditional-search',2,44,1),
(14,'MSO','Add-On Subscriber List','add-on-package-subscriber',2,12,1),
(168,'Subscriber','Online Recharge','subscription-online-recharge',2,166,1),
(139,'MSO','Assign From Parking','assign-from-parking',2,137,1),
(157,'Group','User Role','user-role',2,153,1),
(28,'MSO','LCO Users','lco-users',2,26,1),
(110,'LCO','Assigned Package','reports-assigned-package',2,108,1),
(102,'LCO','Pair STB and IC','tools-pair-stb-ic',3,99,1),
(82,'LCO','NVOD Subscriber List','nvod-subscriber-list',3,79,1),
(91,'LCO','Online (Debit/Credit Card)','payments-online',3,88,1),
(111,'LCO','STB Status','reports-stb-status',3,108,1),
(140,'MSO','Ownership Transfer','ownership-transfer',3,137,1),
(78,'LCO','Add-On Subscriber List','add-on-package-subscriber',3,75,1),
(4,'MSO','Mso Users','mso',3,1,1),
(8,'MSO','Business Region','region',3,5,1),
(22,'MSO','Set-Top Box','set-top-box',3,19,1),
(29,'MSO','LCO Subscribers','lco-subscribers',3,26,1),
(35,'MSO','Distribution List','scratch-card-distribution',3,32,1),
(39,'MSO','Online (Debit/Credit Card)','payments-online',3,37,1),
(160,'Group','LCO Subscribers','lco-subscribers',3,155,1),
(158,'Group','Permissions','permissions',3,153,1),
(57,'MSO','STB Status','reports-stb-status',3,54,1),
(47,'MSO','Pair STB and IC','tools-pair-stb-ic',3,44,1),
(142,'LCO','Ownership Transfer','ownership-transfer',3,97,1),
(67,'LCO','LCO Role Permisions','permissions',3,65,1),
(58,'MSO','SmartCard Status','reports-smartcard-status',4,54,1),
(112,'LCO','SmartCard Status','reports-smartcard-status',4,108,1),
(68,'LCO','Bill Collector','collector',4,65,1),
(23,'MSO','IC or Smart Card','icsmart-card',4,19,1),
(117,'MSO','Bank Accounts','bank-accounts',4,5,1),
(30,'MSO','Assign STB','lco-assign-stb',4,26,1),
(92,'LCO','Scratch-Card','payments-scratch-card',4,88,1),
(103,'LCO','Force OSD','tools-force-osd',4,99,1),
(40,'MSO','Scratch-Card','payments-scratch-card',4,37,1),
(48,'MSO','Scrolling OSD','tools-scrolling-osd',4,44,1),
(118,'MSO','POS','pos-settings',5,5,1),
(123,'MSO','POS','pos-payment',5,37,1),
(69,'LCO','Assign Money Receipt','assign-money-receipt',5,65,1),
(31,'MSO','Assign Card','lco-assign-card',5,26,1),
(93,'LCO','POS','pos-payment',5,88,1),
(59,'MSO','Client Statement','client-statements',5,54,1),
(104,'LCO','Conditional Limited','tools-conditional-limited',5,99,1),
(113,'LCO','Subscriber Transaction','reports-subscriber-transaction',5,108,1),
(49,'MSO','Force OSD','tools-force-osd',5,44,1),
(60,'MSO','Recharge History','reports-recharge-history',6,54,1),
(105,'LCO','ECM Finger Print','tools-ecm-fingerprint',6,99,1),
(50,'MSO','Conditional Limited','tools-conditional-limited',6,44,1),
(41,'MSO','Bkash','payments-bkash',6,37,1),
(114,'LCO','Recharge History','reports-recharge-history',6,108,1),
(94,'LCO','Bkash','payments-bkash',6,88,1),
(120,'MSO','Bill Collector','collector',6,5,1),
(42,'MSO','Gift Voucher','payments-gift-voucher',7,37,1),
(95,'LCO','Gift Voucher','payments-gift-voucher',7,88,1),
(61,'MSO','Scratch Card Status','reports-scratch-card-status',7,54,1),
(121,'MSO','Assign Money Receipt','assign-money-receipt',7,5,1),
(51,'MSO','ECM Finger Print','tools-ecm-fingerprint',7,44,1),
(106,'LCO','EMM Finger Print','tools-emm-fingerprint',7,99,1),
(115,'LCO','Scratch Card Status','reports-scratch-card-status',7,108,1),
(43,'MSO','Refund','payments-refund',8,37,1),
(52,'MSO','EMM Finger Print','tools-emm-fingerprint',8,44,1),
(178,'MSO','System Backup','backup',8,5,1),
(62,'MSO','Conditional Log','reports-system-log',8,54,1),
(131,'LCO','Cash Statement','cash-statement',8,108,1),
(107,'LCO','Temporary Authorization','tools-temporary-authorization',8,99,1),
(96,'LCO','Refund','payments-refund',8,88,1),
(53,'MSO','Temporary Authorization','tools-temporary-authorization',9,44,1),
(124,'MSO','Collection Statement','collection-statement',9,54,1),
(132,'LCO','Bank Statement','bank-statement',9,108,1),
(133,'LCO','POS Statement','pos-statement',10,108,1),
(125,'MSO','Foc Client Statement','foc-client-statement',10,54,1),
(134,'LCO','Collector Statement','collector-statement',11,108,1),
(126,'MSO','Foc Collection','foc-collection',11,54,1),
(144,'LCO','Parking Report','parking-report',12,108,1),
(127,'MSO','Bank Statement','bank-statement',12,54,1),
(146,'LCO','Reassign Pairing Report','reassign-pairing-report',13,108,1),
(128,'MSO','POS Statement','pos-statement',13,54,1),
(148,'LCO','Ownership Transfer Report','ownership-transfer-report',14,108,1),
(129,'MSO','Collector Statement','collector-statement',14,54,1),
(130,'MSO','Cash Statement','cash-statement',15,54,1),
(136,'MSO','Notification Report','notification-report',16,54,1),
(143,'MSO','Parking Report','parking-report',17,54,1),
(145,'MSO','Reassign Pairing Report','reassign-pairing-report',18,54,1),
(147,'MSO','Ownership Transfer Report','ownership-transfer-report',19,54,1);

-- Structure for view `main_menus` 


CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `main_menus` AS (select `m1`.`id` AS `main_menu_id`,`m1`.`menu_type` AS `main_menu_type`,`m1`.`menu_name` AS `main_menu`,`m1`.`display_order` AS `display_order`,`m1`.`visible` AS `visible`,`m1`.`route` AS `route` from `plaas_menus` `m1` where ((`m1`.`parent` = 0) and (`m1`.`visible` = 1)) order by `m1`.`display_order`);

INSERT INTO `main_menus` (`main_menu_id`,`main_menu_type`,`main_menu`,`display_order`,`visible`,`route`) VALUES 
(1,'MSO','Administration',1,1,'#'),
(63,'LCO','System Settings',1,1,'#'),
(153,'Group','Settings',1,1,'#'),
(161,'Subscriber','Profile',1,1,'profile'),
(65,'LCO','LCO',2,1,'#'),
(162,'Subscriber','Subscriber Packages',2,1,'subscriber-packages'),
(5,'MSO','System Settings',2,1,'#'),
(155,'Group','My LCO',2,1,'#'),
(70,'LCO','Subscriber Manage',3,1,'#'),
(9,'MSO','Package-Plan',3,1,'#'),
(170,'Group','Scratch Card',3,1,'#'),
(163,'Subscriber','Subscriber Addon Packages',3,1,'subscriber-addon-packages'),
(173,'Group','Payments',4,1,'#'),
(73,'LCO','Package-Plan',4,1,'#'),
(164,'Subscriber','User Documents',4,1,'user-documents'),
(12,'MSO','Add-On Packages',4,1,'#'),
(16,'MSO','NVOD Packages',5,1,'#'),
(75,'LCO','Add-On Package',5,1,'#'),
(165,'Subscriber','Subscription Info',5,1,'subscription-info'),
(166,'Subscriber','Recharge',6,1,'#'),
(79,'LCO','NVOD Packages',6,1,'#'),
(19,'MSO','Equipment Management',7,1,'#'),
(83,'LCO','Scratch Card',7,1,'#'),
(150,'MSO','Group Accounts',7,1,'#'),
(169,'Subscriber','My Transactions',7,1,'my-transactions'),
(88,'LCO','Payments',8,1,'#'),
(24,'MSO','FOC Subscriber',8,1,'#'),
(26,'MSO','LCO',9,1,'#'),
(97,'LCO','Parking Zone',9,1,'#'),
(32,'MSO','Scratch Card',10,1,'#'),
(99,'LCO','Tools',10,1,'#'),
(37,'MSO','Payments',11,1,'#'),
(137,'MSO','Parking Zone',11,1,'#'),
(108,'LCO','Reports',11,1,'#'),
(44,'MSO','Tools',12,1,'#'),
(54,'MSO','Reports',13,1,'#');

-- Structure for view `getmenus` 


CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `getmenus` AS (select `main_menus`.`main_menu_id` AS `main_menu_id`,`main_menus`.`main_menu_type` AS `main_menu_type`,`main_menus`.`main_menu` AS `main_menu`,`main_menus`.`display_order` AS `display_order`,`main_menus`.`route` AS `main_menu_route`,`sub_menus`.`sub_menu_id` AS `sub_menu_id`,`sub_menus`.`sub_menu_type` AS `sub_menu_type`,`sub_menus`.`sub_menu` AS `sub_menu`,`sub_menus`.`route` AS `route`,`sub_menus`.`m2_display` AS `m2_display`,`sub_menus`.`parent` AS `parent`,`main_menus`.`visible` AS `main_menu_visible`,`sub_menus`.`visible` AS `sub_menu_visible` from (`main_menus` left join `sub_menus` on((`main_menus`.`main_menu_id` = `sub_menus`.`parent`))));

INSERT INTO `getmenus` (`main_menu_id`,`main_menu_type`,`main_menu`,`display_order`,`main_menu_route`,`sub_menu_id`,`sub_menu_type`,`sub_menu`,`route`,`m2_display`,`parent`,`main_menu_visible`,`sub_menu_visible`) VALUES 
(161,'Subscriber','Profile',1,'profile',NULL,'NULL','NULL','NULL',NULL,NULL,1,0),
(153,'Group','Settings',1,'#',154,'Group','Users','groups',1,153,1,1),
(63,'LCO','System Settings',1,'#',64,'LCO','Bank Accounts','bank-accounts',1,63,1,1),
(1,'MSO','Administration',1,'#',2,'MSO','User Role','user-role',1,1,1,1),
(153,'Group','Settings',1,'#',157,'Group','User Role','user-role',2,153,1,1),
(63,'LCO','System Settings',1,'#',119,'LCO','POS ','pos-settings',2,63,1,1),
(1,'MSO','Administration',1,'#',3,'MSO','Permissions','permissions',2,1,1,1),
(1,'MSO','Administration',1,'#',4,'MSO','Mso Users','mso',3,1,1,1),
(153,'Group','Settings',1,'#',158,'Group','Permissions','permissions',3,153,1,1),
(162,'Subscriber','Subscriber Packages',2,'subscriber-packages',NULL,'NULL','NULL','NULL',NULL,NULL,1,0),
(5,'MSO','System Settings',2,'#',6,'MSO','Geo Location Manage','location',1,5,1,1),
(65,'LCO','LCO',2,'#',66,'LCO','LCO User','lco',1,65,1,1),
(155,'Group','My LCO',2,'#',159,'Group','LCO','lco',1,155,1,1),
(155,'Group','My LCO',2,'#',156,'Group','LCO Users','lco-users',2,155,1,1),
(5,'MSO','System Settings',2,'#',7,'MSO','System Info','organization',2,5,1,1),
(65,'LCO','LCO',2,'#',135,'LCO','User Role','user-role',2,65,1,1),
(155,'Group','My LCO',2,'#',160,'Group','LCO Subscribers','lco-subscribers',3,155,1,1),
(5,'MSO','System Settings',2,'#',8,'MSO','Business Region','region',3,5,1,1),
(65,'LCO','LCO',2,'#',67,'LCO','LCO Role Permisions','permissions',3,65,1,1),
(5,'MSO','System Settings',2,'#',117,'MSO','Bank Accounts','bank-accounts',4,5,1,1),
(65,'LCO','LCO',2,'#',68,'LCO','Bill Collector','collector',4,65,1,1),
(65,'LCO','LCO',2,'#',69,'LCO','Assign Money Receipt','assign-money-receipt',5,65,1,1),
(5,'MSO','System Settings',2,'#',118,'MSO','POS','pos-settings',5,5,1,1),
(5,'MSO','System Settings',2,'#',120,'MSO','Bill Collector','collector',6,5,1,1),
(5,'MSO','System Settings',2,'#',121,'MSO','Assign Money Receipt','assign-money-receipt',7,5,1,1),
(5,'MSO','System Settings',2,'#',178,'MSO','System Backup','backup',8,5,1,1),
(163,'Subscriber','Subscriber Addon Packages',3,'subscriber-addon-packages',NULL,'NULL','NULL','NULL',NULL,NULL,1,0),
(170,'Group','Scratch Card',3,'#',181,'Group','Available Card List','scratch-card-available',1,170,1,1),
(70,'LCO','Subscriber Manage',3,'#',71,'LCO','Subscriber List','subscriber',1,70,1,1),
(9,'MSO','Package-Plan',3,'#',10,'MSO','Program Manage','program',1,9,1,1),
(70,'LCO','Subscriber Manage',3,'#',72,'LCO','Recharge Account','subscriber-recharge',2,70,1,1),
(170,'Group','Scratch Card',3,'#',172,'Group','Distribution List','scratch-card-distribution',2,170,1,1),
(9,'MSO','Package-Plan',3,'#',11,'MSO','Package Manage','package',2,9,1,1),
(164,'Subscriber','User Documents',4,'user-documents',NULL,'NULL','NULL','NULL',NULL,NULL,1,0),
(73,'LCO','Package-Plan',4,'#',74,'LCO','Packages','package',1,73,1,1),
(12,'MSO','Add-On Packages',4,'#',13,'MSO','Package List','add-on-package',1,12,1,1),
(173,'Group','Payments',4,'#',174,'Group','Scratch-Card','payments-scratch-card',1,173,1,1),
(12,'MSO','Add-On Packages',4,'#',14,'MSO','Add-On Subscriber List','add-on-package-subscriber',2,12,1,1),
(165,'Subscriber','Subscription Info',5,'subscription-info',NULL,'NULL','NULL','NULL',NULL,NULL,1,0),
(16,'MSO','NVOD Packages',5,'#',17,'MSO','Create NVOD Channel','create-nvod-channel',1,16,1,1),
(75,'LCO','Add-On Package',5,'#',76,'LCO','Package List','add-on-package',1,75,1,1),
(16,'MSO','NVOD Packages',5,'#',18,'MSO','Configure NVOD','configure-nvod',2,16,1,1),
(75,'LCO','Add-On Package',5,'#',77,'LCO','Assign package','add-on-package-assign',2,75,1,1),
(75,'LCO','Add-On Package',5,'#',78,'LCO','Add-On Subscriber List','add-on-package-subscriber',3,75,1,1),
(166,'Subscriber','Recharge',6,'#',167,'Subscriber','Scratch Recharge','subscription-scratch-recharge',1,166,1,1),
(79,'LCO','NVOD Packages',6,'#',80,'LCO','Assign NVOD','assign-nvod',1,79,1,1),
(166,'Subscriber','Recharge',6,'#',168,'Subscriber','Online Recharge','subscription-online-recharge',2,166,1,1),
(79,'LCO','NVOD Packages',6,'#',81,'LCO','Show NVOD Time-table','nvod-time-table',2,79,1,1),
(79,'LCO','NVOD Packages',6,'#',82,'LCO','NVOD Subscriber List','nvod-subscriber-list',3,79,1,1),
(169,'Subscriber','My Transactions',7,'my-transactions',NULL,'NULL','NULL','NULL',NULL,NULL,1,0),
(19,'MSO','Equipment Management',7,'#',20,'MSO','STB Provider','stb-provider',1,19,1,1),
(83,'LCO','Scratch Card',7,'#',182,'LCO','Available Card List','scratch-card-available',1,83,1,1),
(150,'MSO','Group Accounts',7,'#',151,'MSO','Groups','groups',1,150,1,1),
(150,'MSO','Group Accounts',7,'#',152,'MSO','Assign LCO','assign-lco',2,150,1,1),
(19,'MSO','Equipment Management',7,'#',21,'MSO','IC or Smart card Provider','icsmartcard-provider',2,19,1,1),
(19,'MSO','Equipment Management',7,'#',22,'MSO','Set-Top Box','set-top-box',3,19,1,1),
(19,'MSO','Equipment Management',7,'#',23,'MSO','IC or Smart Card','icsmart-card',4,19,1,1),
(24,'MSO','FOC Subscriber',8,'#',25,'MSO','Subscriber Lists','foc-subscriber',1,24,1,1),
(88,'LCO','Payments',8,'#',90,'LCO','Bank','bank-payment',2,88,1,1),
(88,'LCO','Payments',8,'#',91,'LCO','Online (Debit/Credit Card)','payments-online',3,88,1,1),
(88,'LCO','Payments',8,'#',92,'LCO','Scratch-Card','payments-scratch-card',4,88,1,1),
(88,'LCO','Payments',8,'#',93,'LCO','POS','pos-payment',5,88,1,1),
(88,'LCO','Payments',8,'#',94,'LCO','Bkash','payments-bkash',6,88,1,1),
(88,'LCO','Payments',8,'#',95,'LCO','Gift Voucher','payments-gift-voucher',7,88,1,1),
(88,'LCO','Payments',8,'#',96,'LCO','Refund','payments-refund',8,88,1,1),
(26,'MSO','LCO',9,'#',27,'MSO','LCO Manage','lco',1,26,1,1),
(97,'LCO','Parking Zone',9,'#',98,'LCO','Park Subscriber','park-subscriber',1,97,1,1),
(26,'MSO','LCO',9,'#',28,'MSO','LCO Users','lco-users',2,26,1,1),
(97,'LCO','Parking Zone',9,'#',141,'LCO','Assign From Parking Zone','assign-from-parking',2,97,1,1),
(26,'MSO','LCO',9,'#',29,'MSO','LCO Subscribers','lco-subscribers',3,26,1,1),
(97,'LCO','Parking Zone',9,'#',142,'LCO','Ownership Transfer','ownership-transfer',3,97,1,1),
(26,'MSO','LCO',9,'#',30,'MSO','Assign STB','lco-assign-stb',4,26,1,1),
(26,'MSO','LCO',9,'#',31,'MSO','Assign Card','lco-assign-card',5,26,1,1),
(99,'LCO','Tools',10,'#',100,'LCO','Conditional Mail','tools-conditional-mail',1,99,1,1),
(32,'MSO','Scratch Card',10,'#',33,'MSO','Generate Card / List','scratch-card-generate',1,32,1,1),
(99,'LCO','Tools',10,'#',101,'LCO','Conditional Search','tools-conditional-search',2,99,1,1),
(32,'MSO','Scratch Card',10,'#',35,'MSO','Distribution List','scratch-card-distribution',3,32,1,1),
(99,'LCO','Tools',10,'#',102,'LCO','Pair STB and IC','tools-pair-stb-ic',3,99,1,1),
(99,'LCO','Tools',10,'#',103,'LCO','Force OSD','tools-force-osd',4,99,1,1),
(99,'LCO','Tools',10,'#',104,'LCO','Conditional Limited','tools-conditional-limited',5,99,1,1),
(99,'LCO','Tools',10,'#',105,'LCO','ECM Finger Print','tools-ecm-fingerprint',6,99,1,1),
(99,'LCO','Tools',10,'#',106,'LCO','EMM Finger Print','tools-emm-fingerprint',7,99,1,1),
(99,'LCO','Tools',10,'#',107,'LCO','Temporary Authorization','tools-temporary-authorization',8,99,1,1),
(37,'MSO','Payments',11,'#',122,'MSO','Cash','cash',1,37,1,1),
(108,'LCO','Reports',11,'#',109,'LCO','Active Subscriber','reports-active-subscriber',1,108,1,1),
(137,'MSO','Parking Zone',11,'#',138,'MSO','Park Subscriber','park-subscriber',1,137,1,1),
(108,'LCO','Reports',11,'#',110,'LCO','Assigned Package','reports-assigned-package',2,108,1,1),
(137,'MSO','Parking Zone',11,'#',139,'MSO','Assign From Parking','assign-from-parking',2,137,1,1),
(37,'MSO','Payments',11,'#',38,'MSO','Bank','bank-payment',2,37,1,1),
(108,'LCO','Reports',11,'#',111,'LCO','STB Status','reports-stb-status',3,108,1,1),
(137,'MSO','Parking Zone',11,'#',140,'MSO','Ownership Transfer','ownership-transfer',3,137,1,1),
(37,'MSO','Payments',11,'#',39,'MSO','Online (Debit/Credit Card)','payments-online',3,37,1,1),
(37,'MSO','Payments',11,'#',40,'MSO','Scratch-Card','payments-scratch-card',4,37,1,1),
(108,'LCO','Reports',11,'#',112,'LCO','SmartCard Status','reports-smartcard-status',4,108,1,1),
(108,'LCO','Reports',11,'#',113,'LCO','Subscriber Transaction','reports-subscriber-transaction',5,108,1,1),
(37,'MSO','Payments',11,'#',123,'MSO','POS','pos-payment',5,37,1,1),
(108,'LCO','Reports',11,'#',114,'LCO','Recharge History','reports-recharge-history',6,108,1,1),
(37,'MSO','Payments',11,'#',41,'MSO','Bkash','payments-bkash',6,37,1,1),
(108,'LCO','Reports',11,'#',115,'LCO','Scratch Card Status','reports-scratch-card-status',7,108,1,1),
(37,'MSO','Payments',11,'#',42,'MSO','Gift Voucher','payments-gift-voucher',7,37,1,1),
(37,'MSO','Payments',11,'#',43,'MSO','Refund','payments-refund',8,37,1,1),
(108,'LCO','Reports',11,'#',131,'LCO','Cash Statement','cash-statement',8,108,1,1),
(108,'LCO','Reports',11,'#',132,'LCO','Bank Statement','bank-statement',9,108,1,1),
(108,'LCO','Reports',11,'#',133,'LCO','POS Statement','pos-statement',10,108,1,1),
(108,'LCO','Reports',11,'#',134,'LCO','Collector Statement','collector-statement',11,108,1,1),
(108,'LCO','Reports',11,'#',144,'LCO','Parking Report','parking-report',12,108,1,1),
(108,'LCO','Reports',11,'#',146,'LCO','Reassign Pairing Report','reassign-pairing-report',13,108,1,1),
(108,'LCO','Reports',11,'#',148,'LCO','Ownership Transfer Report','ownership-transfer-report',14,108,1,1),
(44,'MSO','Tools',12,'#',45,'MSO','Conditional Mail','tools-conditional-mail',1,44,1,1),
(44,'MSO','Tools',12,'#',46,'MSO','Conditional Search','tools-conditional-search',2,44,1,1),
(44,'MSO','Tools',12,'#',47,'MSO','Pair STB and IC','tools-pair-stb-ic',3,44,1,1),
(44,'MSO','Tools',12,'#',48,'MSO','Scrolling OSD','tools-scrolling-osd',4,44,1,1),
(44,'MSO','Tools',12,'#',49,'MSO','Force OSD','tools-force-osd',5,44,1,1),
(44,'MSO','Tools',12,'#',50,'MSO','Conditional Limited','tools-conditional-limited',6,44,1,1),
(44,'MSO','Tools',12,'#',51,'MSO','ECM Finger Print','tools-ecm-fingerprint',7,44,1,1),
(44,'MSO','Tools',12,'#',52,'MSO','EMM Finger Print','tools-emm-fingerprint',8,44,1,1),
(44,'MSO','Tools',12,'#',53,'MSO','Temporary Authorization','tools-temporary-authorization',9,44,1,1),
(54,'MSO','Reports',13,'#',55,'MSO','Active Subscriber','reports-active-subscriber',1,54,1,1),
(54,'MSO','Reports',13,'#',56,'MSO','Assigned Package','reports-assigned-package',2,54,1,1),
(54,'MSO','Reports',13,'#',57,'MSO','STB Status','reports-stb-status',3,54,1,1),
(54,'MSO','Reports',13,'#',58,'MSO','SmartCard Status','reports-smartcard-status',4,54,1,1),
(54,'MSO','Reports',13,'#',59,'MSO','Client Statement','client-statements',5,54,1,1),
(54,'MSO','Reports',13,'#',60,'MSO','Recharge History','reports-recharge-history',6,54,1,1),
(54,'MSO','Reports',13,'#',61,'MSO','Scratch Card Status','reports-scratch-card-status',7,54,1,1),
(54,'MSO','Reports',13,'#',62,'MSO','Conditional Log','reports-system-log',8,54,1,1),
(54,'MSO','Reports',13,'#',124,'MSO','Collection Statement','collection-statement',9,54,1,1),
(54,'MSO','Reports',13,'#',125,'MSO','Foc Client Statement','foc-client-statement',10,54,1,1),
(54,'MSO','Reports',13,'#',126,'MSO','Foc Collection','foc-collection',11,54,1,1),
(54,'MSO','Reports',13,'#',127,'MSO','Bank Statement','bank-statement',12,54,1,1),
(54,'MSO','Reports',13,'#',128,'MSO','POS Statement','pos-statement',13,54,1,1),
(54,'MSO','Reports',13,'#',129,'MSO','Collector Statement','collector-statement',14,54,1,1),
(54,'MSO','Reports',13,'#',130,'MSO','Cash Statement','cash-statement',15,54,1,1),
(54,'MSO','Reports',13,'#',136,'MSO','Notification Report','notification-report',16,54,1,1),
(54,'MSO','Reports',13,'#',143,'MSO','Parking Report','parking-report',17,54,1,1),
(54,'MSO','Reports',13,'#',145,'MSO','Reassign Pairing Report','reassign-pairing-report',18,54,1,1),
(54,'MSO','Reports',13,'#',147,'MSO','Ownership Transfer Report','ownership-transfer-report',19,54,1,1);

--
-- Triggers
--

DELIMITER $$

CREATE DEFINER=`root`@`%` TRIGGER `GetPairingID_copy` BEFORE INSERT ON `ownership_transfers` FOR EACH ROW BEGIN
	begin
	  SET NEW.pairing_id = 1000000+GetAutoID('subscriber_stb_smartcards');
	end;
    END$$

CREATE DEFINER=`root`@`%` TRIGGER `gen_region_level_1_codeTr` BEFORE INSERT ON `region_level_1` FOR EACH ROW BEGIN	
  begin
  SET NEW.region_l1_code = NEW.id;
  end;
END$$

CREATE DEFINER=`root`@`%` TRIGGER `gen_region_level_2_codeTr` BEFORE INSERT ON `region_level_2` FOR EACH ROW BEGIN	
  begin
  SET NEW.region_l2_code = NEW.id;
  end;
END$$

CREATE DEFINER=`root`@`%` TRIGGER `gen_region_level_3_codeTr` BEFORE INSERT ON `region_level_3` FOR EACH ROW BEGIN	
  begin
  SET NEW.region_l3_code = NEW.id;
  end;
END$$

CREATE DEFINER=`root`@`%` TRIGGER `gen_region_level_4_codeTr` BEFORE INSERT ON `region_level_4` FOR EACH ROW BEGIN	
  begin
  SET NEW.region_l4_code = NEW.id;
  end;
END$$

CREATE DEFINER=`root`@`%` TRIGGER `set_card_serial_padding` BEFORE INSERT ON `scratch_card_detail` FOR EACH ROW BEGIN
	DECLARE temp VARCHAR(8);
	
	SET NEW.serial_no = LPAD(NEW.id,8,'0');
    END$$

CREATE DEFINER=`root`@`%` TRIGGER `gen_batch_number_Tr` BEFORE INSERT ON `scratch_card_info` FOR EACH ROW BEGIN	
  begin
  
  SET NEW.batch_no = cast(concat(DATE_FORMAT(now(),'%Y%m%d'),lpad(NEW.id,4,0))as signed integer);
  
  end;
END$$

CREATE DEFINER=`root`@`%` TRIGGER `GetPairingID` BEFORE INSERT ON `subscriber_stb_smartcards` FOR EACH ROW BEGIN
	begin
	  SET NEW.pairing_id = 1000000+GetAutoID('subscriber_stb_smartcards');
	end;
    END$$

CREATE DEFINER=`root`@`%` TRIGGER `user_packages_insTr` AFTER INSERT ON `user_packages` FOR EACH ROW BEGIN	
		
	  If (NEW.id>0) then				
		  Begin
		  insert into user_packages_history(package_assign_id,user_id,package_id,user_stb_smart_id,status,charge_type,package_start_date,package_expire_date,no_of_days,created_at,updated_at,created_by,user_package_type_id)
		  values (NEW.id,NEW.user_id,NEW.package_id,NEW.user_stb_smart_id,NEW.status,NEW.charge_type,NEW.package_start_date,NEW.package_expire_date,NEW.no_of_days,NEW.created_at,NEW.updated_at,NEW.created_by,NEW.user_package_type_id);
		  end;				
	  End If; 
END$$

CREATE DEFINER=`root`@`%` TRIGGER `user_packages_updTr` AFTER UPDATE ON `user_packages` FOR EACH ROW BEGIN	
			  
		  Begin
		  insert into user_packages_history(package_assign_id,user_id,package_id,user_stb_smart_id,status,charge_type,package_start_date,package_expire_date,no_of_days,created_at,updated_at,created_by,user_package_type_id)
		  values (OLD.id,OLD.user_id,OLD.package_id,OLD.user_stb_smart_id,OLD.status,NEW.charge_type,NEW.package_start_date,NEW.package_expire_date,NEW.no_of_days,OLD.created_at,OLD.updated_at,OLD.created_by,NEW.user_package_type_id);
		  end;				
	  
END$$

DELIMITER ;

