-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `crm_crm`
--

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

--
-- Table structure for table `rad_acct`
--

CREATE TABLE `rad_acct` (
  `id` bigint(20) NOT NULL,
  `acctsessionid` varchar(64) NOT NULL DEFAULT '',
  `username` varchar(64) NOT NULL DEFAULT '',
  `realm` varchar(128) NOT NULL DEFAULT '',
  `nasid` varchar(32) NOT NULL DEFAULT '',
  `nasipaddress` varchar(15) NOT NULL DEFAULT '',
  `nasportid` varchar(32) DEFAULT NULL,
  `nasporttype` varchar(32) DEFAULT NULL,
  `framedipaddress` varchar(15) NOT NULL DEFAULT '',
  `acctsessiontime` bigint(20) NOT NULL DEFAULT 0,
  `acctinputoctets` bigint(20) NOT NULL DEFAULT 0,
  `acctoutputoctets` bigint(20) NOT NULL DEFAULT 0,
  `acctstatustype` varchar(32) DEFAULT NULL,
  `macaddr` varchar(50) NOT NULL,
  `dateAdded` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_appconfig`
--

CREATE TABLE `tbl_appconfig` (
  `id` int(11) NOT NULL,
  `setting` mediumtext NOT NULL,
  `value` mediumtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_appconfig`
--

INSERT INTO `tbl_appconfig` (`id`, `setting`, `value`) VALUES
(1, 'CompanyName', 'Alif Network'),
(2, 'currency_code', 'Taka.'),
(3, 'language', 'english'),
(4, 'show-logo', '1'),
(5, 'nstyle', 'blue'),
(6, 'timezone', 'Asia/Dhaka'),
(7, 'dec_point', ','),
(8, 'thousands_sep', ','),
(9, 'rtl', '0'),
(10, 'address', 'Collegepara\r\nAkhaura'),
(11, 'phone', '01577302042'),
(12, 'date_format', 'd M Y'),
(13, 'note', 'Thank you...'),
(14, 'docs_clicked', 'yes'),
(15, 'api_key', '4b93b11b0c2d7d2ecf9dbbf105e995765c1a1f61'),
(16, 'payment_gateway', ''),
(17, 'country_code_phone', '880'),
(18, 'radius_plan', 'Radius Plan'),
(19, 'hotspot_plan', 'Hotspot Plan'),
(20, 'pppoe_plan', 'PPPOE Plan'),
(21, 'vpn_plan', 'VPN Plan'),
(22, 'csrf_token', '9aec91491c72955da83400fab800777e'),
(23, 'CompanyFooter', 'AlifNetwork'),
(24, 'printer_cols', '37'),
(25, 'theme', 'default'),
(26, 'payment_usings', ''),
(27, 'reset_day', '28'),
(28, 'dashboard_cr', ''),
(29, 'url_canonical', 'yes'),
(30, 'general', ''),
(31, 'login_page_type', 'default'),
(32, 'login_Page_template', 'moon'),
(33, 'login_page_head', ''),
(34, 'login_page_description', ''),
(35, 'disable_registration', 'no'),
(36, 'registration_username', 'username'),
(37, 'photo_register', 'no'),
(38, 'sms_otp_registration', 'no'),
(39, 'phone_otp_type', 'sms'),
(40, 'reg_nofify_admin', 'no'),
(41, 'man_fields_email', 'no'),
(42, 'man_fields_fname', 'yes'),
(43, 'man_fields_address', 'yes'),
(44, 'session_timeout_duration', '5'),
(45, 'single_session', 'no'),
(46, 'csrf_enabled', 'no'),
(47, 'disable_voucher', 'yes'),
(48, 'voucher_format', 'up'),
(49, 'voucher_redirect', ''),
(50, 'radius_enable', '0'),
(51, 'extend_expired', '0'),
(52, 'extend_days', ''),
(53, 'extend_confirmation', ''),
(54, 'enable_balance', 'yes'),
(55, 'allow_balance_transfer', 'yes'),
(56, 'minimum_transfer', ''),
(57, 'allow_balance_custom', 'yes'),
(58, 'telegram_bot', ''),
(59, 'telegram_target_id', ''),
(60, 'sms_url', 'https://crm.amaxsolutions.online/sms-proxy.php?secret=mysecuretoken123&to=[number]&msg=[text]'),
(61, 'mikrotik_sms_command', '/tool sms send'),
(62, 'wa_url', ''),
(63, 'smtp_host', ''),
(64, 'smtp_port', ''),
(65, 'smtp_user', ''),
(66, 'smtp_pass', ''),
(67, 'smtp_ssltls', ''),
(68, 'mail_from', ''),
(69, 'mail_reply_to', ''),
(70, 'user_notification_expired', 'sms'),
(71, 'user_notification_payment', 'none'),
(72, 'user_notification_reminder', 'none'),
(73, 'notification_reminder_1day', 'yes'),
(74, 'notification_reminder_3days', 'no'),
(75, 'notification_reminder_7days', 'no'),
(76, 'tawkto', ''),
(77, 'tawkto_api_key', ''),
(78, 'http_proxy', ''),
(79, 'http_proxyauth', ''),
(80, 'enable_tax', 'no'),
(81, 'tax_rate', '0.5'),
(82, 'custom_tax_rate', ''),
(83, 'github_username', ''),
(84, 'github_token', ''),
(85, 'man_fields_custom', 'no'),
(86, 'enable_session_timeout', '0'),
(87, 'hide_mrc', 'no'),
(88, 'hide_tms', 'no'),
(89, 'hide_al', 'no'),
(90, 'hide_uet', 'no'),
(91, 'hide_vs', 'no'),
(92, 'hide_pg', 'no'),
(93, 'hide_aui', 'no'),
(94, 'new_version_notify', 'enable'),
(95, 'router_check', '0'),
(96, 'allow_phone_otp', 'no'),
(97, 'allow_email_otp', 'no'),
(98, 'show_bandwidth_plan', 'no'),
(99, 'hs_auth_method', 'api'),
(100, 'frrest_interim_update', '0'),
(101, 'check_customer_online', 'yes'),
(102, 'extend_expiry', 'yes'),
(103, 'save', 'save'),
(104, 'speedtest_mode', '1'),
(105, 'speedtest_template', 'a');

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

--
-- Table structure for table `tbl_bandwidth`
--

CREATE TABLE `tbl_bandwidth` (
  `id` int(10) UNSIGNED NOT NULL,
  `name_bw` varchar(255) NOT NULL,
  `rate_down` int(10) UNSIGNED NOT NULL,
  `rate_down_unit` enum('Kbps','Mbps') NOT NULL,
  `rate_up` int(10) UNSIGNED NOT NULL,
  `rate_up_unit` enum('Kbps','Mbps') NOT NULL,
  `burst` varchar(128) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_bandwidth`
--

INSERT INTO `tbl_bandwidth` (`id`, `name_bw`, `rate_down`, `rate_down_unit`, `rate_up`, `rate_up_unit`, `burst`) VALUES
(1, '30m', 30, 'Mbps', 30, 'Mbps', '50M/50M 40M/40M 12/12 8 25M/25M'),
(2, '50M', 50, 'Mbps', 50, 'Mbps', '40M/40M 45M/45M 12/12 8 40M/40M'),
(3, 'Expired', 1, 'Kbps', 1, 'Kbps', '');

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

--
-- Table structure for table `tbl_coupons`
--

CREATE TABLE `tbl_coupons` (
  `id` int(11) NOT NULL,
  `code` varchar(50) NOT NULL,
  `type` enum('fixed','percent') NOT NULL,
  `value` decimal(10,2) NOT NULL,
  `description` text NOT NULL,
  `max_usage` int(11) NOT NULL DEFAULT 1,
  `usage_count` int(11) NOT NULL DEFAULT 0,
  `status` enum('active','inactive') NOT NULL,
  `min_order_amount` decimal(10,2) NOT NULL,
  `max_discount_amount` decimal(10,2) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_customers`
--

CREATE TABLE `tbl_customers` (
  `id` int(11) NOT NULL,
  `username` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL,
  `photo` varchar(128) NOT NULL DEFAULT '/user.default.jpg',
  `pppoe_username` varchar(32) NOT NULL DEFAULT '' COMMENT 'For PPPOE Login',
  `pppoe_password` varchar(45) NOT NULL DEFAULT '' COMMENT 'For PPPOE Login',
  `pppoe_ip` varchar(32) NOT NULL DEFAULT '' COMMENT 'For PPPOE Login',
  `fullname` varchar(45) NOT NULL,
  `address` mediumtext DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `district` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `phonenumber` varchar(20) DEFAULT '0',
  `email` varchar(128) NOT NULL DEFAULT '1',
  `coordinates` varchar(50) NOT NULL DEFAULT '' COMMENT 'Latitude and Longitude coordinates',
  `account_type` enum('Business','Personal') DEFAULT 'Personal' COMMENT 'For selecting account type',
  `balance` decimal(15,2) NOT NULL DEFAULT 0.00 COMMENT 'For Money Deposit',
  `service_type` enum('Hotspot','PPPoE','VPN','Others') DEFAULT 'Others' COMMENT 'For selecting user type',
  `auto_renewal` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Auto renewall using balance',
  `status` enum('Active','Banned','Disabled','Inactive','Limited','Suspended') NOT NULL DEFAULT 'Active',
  `created_by` int(11) NOT NULL DEFAULT 0,
  `reseller_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Assigned reseller id',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `last_login` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_customers`
--

INSERT INTO `tbl_customers` (`id`, `username`, `password`, `photo`, `pppoe_username`, `pppoe_password`, `pppoe_ip`, `fullname`, `address`, `city`, `district`, `state`, `zip`, `phonenumber`, `email`, `coordinates`, `account_type`, `balance`, `service_type`, `auto_renewal`, `status`, `created_by`, `reseller_id`, `created_at`, `last_login`) VALUES
(1, '01577302042', '715517', '/user.default.jpg', 'testapi', 'testapi', '', 'Alif Ahammad', 'Brahmanbaria', '', '', '', '', '8801577302042', 'alifahmud123123@gmail.com', 'a', 'Personal', 25.00, 'PPPoE', 1, 'Active', 1, 0, '2026-04-29 19:59:18', '2026-05-04 23:11:04'),
(7, '01683194881', '41913', '/user.default.jpg', '220061', '41913', '', 'Fariya', 'A2, Shiuli apas building', '', '', '', '', '8801683194881', '', '23.86660065389859,91.21128372734326', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-05-11 15:01:48', '2026-05-11 22:05:18'),
(8, '01778359510', '41913', '/user.default.jpg', '220062', '41913', '', 'Aiyub Sharkar', '', '', '', '', '', '8801776349920', '', '23.86884179501029,91.21227154113953', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-05-14 11:51:59', NULL),
(9, '01794828150', '41913', '/user.default.jpg', '220063', '41913', '', 'Rony, sani bhai', '', '', '', '', '', '8801794828150', '', '', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-06-06 16:41:58', NULL),
(10, '01788524774', '706466', '/user.default.jpg', '220064', '41913', '', 'Ujjol', 'Radhanagar, Adarshapara', '', '', '', '', '8801788524774', '', '23.86629969995439,91.2101322412491', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-06-15 08:35:18', NULL),
(11, '01711384968', '41913', '/user.default.jpg', '220065', '41913', '', 'Alamin Uncle', 'Dashpara', '', '', '', '', '8801711384968', '', '23.86326643607457,91.20996452457635', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-06-16 12:31:06', '2026-06-23 16:50:19'),
(12, 'Hridoy', '41913', '/user.default.jpg', '220066', '41913', '', 'Hridoy', '', '', '', '', '', '8801708052727', '', '23.868912926503544,91.21271427055821', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-06-16 13:09:59', NULL),
(13, '01837230510', '41913', '/user.default.jpg', '220067', '41913', '', 'Piyash Chowdhuri', 'Dashpara', '', '', '', '', '8801837230510', '', '', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-06-19 15:12:37', NULL),
(14, '01926403967', '41913', '/user.default.jpg', '220068', '41913', '', 'Ifran', 'Cp', '', '', '', '', '8801926403967', '', '', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-06-23 12:59:54', '2026-06-23 19:31:15'),
(15, '01760132069', '41913', '/user.default.jpg', '220069', '41913', '', 'Shayan Ahmed police', 'Ononna Vila, Office er pashe Cp', '', '', '', '', '8801760132069', '', '23.86654594376209,91.21169971446764', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-06-25 12:30:03', NULL),
(16, '01763830045', '41913', '/user.default.jpg', '220059', '41913', '', 'Maruf', '', '', '', '', '', '8801763830045', '', '23.8666023593981,91.21129265825087', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-06-27 11:38:11', NULL),
(17, '01931265995', '206516', '/user.default.jpg', '220058', '41913', '', 'Khairul', 'Choton nehal, goru bazar', '', '', '', '', '8801931265995', '', '23.867698780139236,91.21400101895198', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-06-27 11:40:12', NULL),
(18, '01995450164', '362637', '/user.default.jpg', '220056', '41913', '', 'Ovi', 'Upazilar shamne', '', '', '', '', '8801995450164', '', '23.86612479949624,91.21157335786134', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-06-27 11:41:20', NULL),
(19, '01929503633', '896035', '/user.default.jpg', '220055', '41913', '', 'Alamin bhai cp', 'Cp, ifran er barir pashe', '', '', '', '', '8801929503633', '', '23.868552363014075,91.21243478983702', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-06-27 11:42:37', NULL),
(20, '01733965058', '866160', '/user.default.jpg', '220070', '41913', '', 'Sonjoy sir', 'Radhanagar', '', '', '', '', '8801733965058', '', '', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-03 11:15:37', NULL),
(21, '01988239494', '160890', '/user.default.jpg', '220071', '41913', '', 'Kawser bhai cp', 'Cp', '', '', '', '', '8801988239494', '', '', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-06 14:46:56', NULL),
(22, '01928895805', '237370', '/user.default.jpg', '220072', '41913', '', 'DJ Tarek', 'Dj tarek', '', '', '', '', '8801928895805', '', '23.866368379986447,91.21146261692047', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-10 14:30:45', NULL),
(23, '01762383092', '177716', '/user.default.jpg', '220073', '41913', '', 'Nasir Shikder', 'Shaplo bhai er barir dike, 3 Purbe', '', '', '', '', '8801762383092', '', '23.86739734967716,91.2138605117798', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-15 15:44:22', NULL),
(24, '01712520008', '489220', '/user.default.jpg', '220074', '41913', '', 'Sarwar alom', 'Bashar pashe', '', '', '', '', '8801712520008', '', '23.86928234207311,91.21243491768838', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-15 17:19:54', NULL),
(25, '01603184009', '492654', '/user.default.jpg', '220057', '41913', '', 'Sultana', 'Selfy Fasion, Upozila,', '', '', '', '', '8801603184009', '', '23.865903294347778,91.21179399867653', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:00:22', NULL),
(26, '01324945221', '604593', '/user.default.jpg', '', '', '', 'Sakib Al Hasan exp 02 tarikh', 'khalajura, Siyam er barir pisone', '', '', '', '', '8801324945221', '', '23.869868023981308,91.21725982086427', 'Personal', 0.00, 'Others', 1, 'Active', 1, 0, '2026-07-21 14:03:48', NULL),
(27, '01908312932', '909825', '/user.default.jpg', '', '', '', 'hridoy bhuiyan CP', 'Emon er barir shathe', '', '', '', '', '8801908312932', '', '23.868935959915135,91.21268898349018', 'Personal', 0.00, 'Others', 1, 'Active', 1, 0, '2026-07-21 14:04:34', NULL),
(28, '01774575903', '192761', '/user.default.jpg', '', '', '', 'Shorif EXp 28th tarikh', '', '', '', '', '', '8801774575903', '', '23.866445376697815,91.21196837738309', 'Personal', 0.00, 'Others', 1, 'Active', 1, 0, '2026-07-21 14:05:27', NULL),
(29, '01781714327', '906094', '/user.default.jpg', '', '', '', 'Israt exp 24th', 'office 2nd floor', '', '', '', '', '8801781714327', '', '23.86654391249213,91.21133489640876', 'Personal', 0.00, 'Others', 1, 'Active', 1, 0, '2026-07-21 14:06:58', NULL),
(30, '01704494663', '825111', '/user.default.jpg', '', '', '', 'Md Alamin exp 12th', 'Muhammadali nich tala', '', '', '', '', '8801704494663', '', '23.86816236464006,91.2125263089684', 'Personal', 0.00, 'Others', 1, 'Active', 1, 0, '2026-07-21 14:07:54', NULL),
(31, '01610619055', '786887', '/user.default.jpg', '', '', '', 'Redoan', 'Office tala exp 31th', '', '', '', '', '8801610619055', '', '23.86654391249213,91.21172014711681', 'Personal', 0.00, 'Others', 1, 'Active', 1, 0, '2026-07-21 14:08:32', NULL),
(32, '01301056896', '334417', '/user.default.jpg', '', '', '', 'Rony exp 30th', 'Upozilar Pisone', '', '', '', '', '8801301056896', '', '23.86457180135065,91.2116239248744', 'Personal', 0.00, 'Others', 1, 'Active', 1, 0, '2026-07-21 14:09:33', NULL),
(33, '01735378333', '490737', '/user.default.jpg', '', '', '', 'Fahim Shohag bhai EXP 26th', 'Shohag bhai  CP Emon', '', '', '', '', '8801735378333', '', '23.868928248150873,91.21256804095829', 'Personal', 0.00, 'Others', 1, 'Active', 1, 0, '2026-07-21 14:11:37', NULL),
(34, 'HujurPhermasydokan', '35569', '/user.default.jpg', '220054', '41913', '', 'Hujur Phermasy dokan', 'Hujur Phermasy dokan', '', '', '', '', 'Hujur Phermasy dokan', '', '23.86854542614288,91.21238600124013', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:13:11', NULL),
(35, 'Tailour', '152693', '/user.default.jpg', '', '', '', 'Tailour exp 14th', 'Tailour office', '', '', '', '', 'Tailour', '', '23.866558208032874,91.2116734688531', 'Personal', 0.00, 'Others', 1, 'Active', 1, 0, '2026-07-21 14:13:54', NULL),
(36, '01790769432', '374590', '/user.default.jpg', '220053', '41913', '', 'Jahidul', 'Cp', '', '', '', '', '8801790769432', '', '23.868303133646194,91.21313373247781', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:14:43', NULL),
(37, '01942946584', '530694', '/user.default.jpg', '220052', '41913', '', 'Arafat', 'Foysal Bhai er office er pashe.', '', '', '', '', '8801942946584', '', '', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:16:47', NULL),
(38, '01727735121', '553654', '/user.default.jpg', '220049', '41913', '', 'Sk Monir', 'Shiuliapa 5C', '', '', '', '', '8801727735121', '', '', 'Personal', 0.00, 'Hotspot', 1, 'Active', 1, 0, '2026-07-21 14:17:41', NULL),
(39, '01718024672', '908875', '/user.default.jpg', '220050', '41913', '', 'Faruk', 'Shawon er barir pashe', '', '', '', '', '8801718024672', '', '23.867640870285456,91.21405112422275', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:18:25', NULL),
(40, 'SobujEXP20th', '271092', '/user.default.jpg', '', '', '', 'Sobuj_Bashir EXP 20th', 'TNT', '', '', '', '', 'Sobuj EXP 20th', '', '23.863728005127907,91.21256842356338', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:20:41', NULL),
(41, '01872073874', '468238', '/user.default.jpg', '220048', '41913', '', 'Anis', 'Cp, Bashar pashe', '', '', '', '', '8801872073874', '', '23.868891809345566,91.21343467372036', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:21:41', NULL),
(42, '01765080150', '380507', '/user.default.jpg', '220047', '41913', '', 'Srabon', 'juyel Bhai er bari', '', '', '', '', '8801765080150', '', '23.86752313422229,91.211068547936', 'Personal', 0.00, 'Hotspot', 1, 'Active', 1, 0, '2026-07-21 14:22:35', NULL),
(43, '01787141848', '790785', '/user.default.jpg', '220046', '41913', '', 'Laboni', 'upazilar shamne', '', '', '', '', '8801787141848', '', '23.86617897324727,91.21154073713605', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:28:12', NULL),
(44, 'ChotonNehalFarm', '532039', '/user.default.jpg', '220041', '41913', '', 'Choton Nehal', 'Choton Nehal Farm', '', '', '', '', 'Choton Nehal Farm', '', '23.86792731493482,91.2127829280365', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:31:03', NULL),
(45, '01941162900', '705828', '/user.default.jpg', '220040', '41913', '', 'Afram', 'Gorubajar Chipa', '', '', '', '', '8801941162900', '', '23.86705416264187,91.21406968264274', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:31:49', NULL),
(46, '01842691105', '714360', '/user.default.jpg', '220039', '41913', '', 'Mainuddin', 'Niaz bhai er barir pisone', '', '', '', '', '8801842691105', '', '23.868062756966097,91.21282805296711', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:32:40', NULL),
(47, 'Arafat', '318262', '/user.default.jpg', '220036', '41913', '', 'Arafat', 'Mohammad ali 3tala', '', '', '', '', 'Arafat', '', '23.86805294566356,91.21253849480689', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:33:30', NULL),
(48, 'ShirinAntie', '1671', '/user.default.jpg', '220035', '41913', '', 'Shirin Antie', 'Shirin Antie Sojib er bashar pisone', '', '', '', '', 'Shirin Antie', '', '23.868437080598138,91.21181549748988', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:34:16', NULL),
(49, 'TusharBhai', '837524', '/user.default.jpg', '220034', '41913', '', 'Tushar Bhai', 'Tushar Bhai GB', '', '', '', '', 'Tushar Bhai', '', '23.867495616468133,91.21353376995437', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:34:54', NULL),
(50, 'FoysalAliKAKA', '900352', '/user.default.jpg', '220033', '41913', '', 'Foysal Ali KAKA', 'GB', '', '', '', '', 'Foysal Ali KAKA', '', '23.866376696706595,91.21245111078528', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:36:30', NULL),
(51, 'BabulHasanAuto', '44254', '/user.default.jpg', '220032', '41913', '', 'Babul Hasan Auto', 'Office er Pisone', '', '', '', '', 'Babul Hasan Auto', '', '23.866308016678968,91.2119039501807', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:37:49', NULL),
(52, 'Asib', '24769', '/user.default.jpg', '220031', '41913', '', 'Asib', 'Humayun Sir', '', '', '', '', 'Asib', '', '23.867081623032025,91.21105220984128', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:38:35', NULL),
(53, 'Sakib', '75585', '/user.default.jpg', '220030', '41913', '', 'Sakib', 'GB Foysal Bhai office', '', '', '', '', 'Sakib', '', '23.86652386807175,91.2124831447698', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:39:11', NULL),
(54, 'Rohantayiba', '936896', '/user.default.jpg', '220029', '41913', '', 'Rohan tayiba', 'Afu Mia 4th Floor', '', '', '', '', 'Rohan tayiba', '', '23.867971250324153,91.2113462111823', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:42:11', NULL),
(55, 'Ibrahim', '690398', '/user.default.jpg', '220028', '41913', '', 'Ibrahim', '220028', '', '', '', '', 'Ibrahim', '', '23.867564295865925,91.21320050974889', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:42:42', NULL),
(56, 'Hosna', '231820', '/user.default.jpg', '220027', '41913', '', 'Hosna', 'GBHosna', '', '', '', '', 'Hosna', '', '23.868231465263058,91.21363116434527', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:43:18', NULL),
(57, 'Noyon', '480038', '/user.default.jpg', '220026', '41913', '', 'Noyon', 'Cp Robin Bhai', '', '', '', '', 'Noyon', '', '23.868097096519147,91.21268309728066', 'Personal', 0.00, 'Hotspot', 1, 'Active', 1, 0, '2026-07-21 14:44:17', NULL),
(58, 'Yeasin', '668946', '/user.default.jpg', '', '', '', 'Yeasin EXP 05th', 'Yeasin', '', '', '', '', 'Yeasin', '', '23.869163534400386,91.21294371608131', 'Personal', 0.00, 'Others', 1, 'Active', 1, 0, '2026-07-21 14:45:01', NULL),
(59, 'Nur', '322277', '/user.default.jpg', '220025', '41913', '', 'Nur', 'Nur Mohammad Ali House', '', '', '', '', 'Nur', '', '', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:45:34', NULL),
(60, 'Siyam', '899165', '/user.default.jpg', '220024', '41913', '', 'Siyam', 'Siyam', '', '', '', '', 'Siyam', '', '23.869153723181242,91.21285731543595', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:46:00', NULL),
(61, 'Shawon', '150178', '/user.default.jpg', '220023', '41913', '', 'Shawon', 'Shawon', '', '', '', '', 'Shawon', '', '', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:46:45', NULL),
(62, 'Shifat', '729665', '/user.default.jpg', '220045', '41913', '', 'Shifat EXP 01th', 'Shifat', '', '', '', '', 'Shifat', '', '', 'Personal', 0.00, 'Others', 1, 'Active', 1, 0, '2026-07-21 14:47:29', NULL),
(63, 'Sojib', '843217', '/user.default.jpg', '220022', '41913', '', 'Sojib EXP 01th', 'Sojib', '', '', '', '', 'Sojib', '', '', 'Personal', 0.00, 'Others', 1, 'Active', 1, 0, '2026-07-21 14:48:02', NULL),
(64, 'RobinBhai', '783941', '/user.default.jpg', '220021', '41913', '', 'Robin Bhai', 'Robin Bhai', '', '', '', '', 'Robin Bhai', '', '', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-21 14:48:29', NULL),
(65, '01830932211', '373468', '/user.default.jpg', '220075', '41913', '', 'Foysal', 'Shiuli apa, lift er 4, D1', '', '', '', '', '‪01830932211‬', '', '23.866601401252314,91.21130704879761', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-07-26 13:42:13', NULL),
(66, '01637095906', '544409', '/user.default.jpg', '236041', '3600041', '', 'Ayat Misbah', 'Office er pisone 4tala', '', '', '', '', '8801637095906', '', '', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-08-03 12:00:12', NULL),
(67, '01797480075', '625116', '/user.default.jpg', '220076', '41913', '', 'Shopon Khan', 'Office 2nd floor', '', '', '', '', '8801797480075', '', '23.866510645651235,91.21170401573183', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-08-03 13:00:06', NULL),
(68, '01715911603', '964981', '/user.default.jpg', 'usertest', 'usertest', '', 'Mojammel Hossain', 'Bhuiyan bari\r\nMaldarpara', '', '', '', '', '8801715911603', 'abulhossain9h@gmail.com', '23.866681272260756,91.21165660096864', 'Personal', 0.00, 'PPPoE', 1, 'Active', 1, 0, '2026-08-03 16:23:30', NULL);

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

--
-- Table structure for table `tbl_customers_fields`
--

CREATE TABLE `tbl_customers_fields` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `field_name` varchar(255) NOT NULL,
  `field_value` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_customers_inbox`
--

CREATE TABLE `tbl_customers_inbox` (
  `id` int(10) UNSIGNED NOT NULL,
  `customer_id` int(11) NOT NULL,
  `date_created` datetime NOT NULL,
  `date_read` datetime DEFAULT NULL,
  `subject` varchar(64) NOT NULL,
  `body` text DEFAULT NULL,
  `from` varchar(8) NOT NULL DEFAULT 'System' COMMENT 'System or Admin or Else',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'other than admin is 0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_logs`
--

CREATE TABLE `tbl_logs` (
  `id` int(11) NOT NULL,
  `date` datetime DEFAULT NULL,
  `type` varchar(50) NOT NULL,
  `description` mediumtext NOT NULL,
  `userid` int(11) NOT NULL,
  `ip` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_logs`
--

INSERT INTO `tbl_logs` (`id`, `date`, `type`, `description`, `userid`, `ip`) VALUES
(1, '2026-02-14 16:05:32', 'SuperAdmin', 'admin Login Successful', 1, '203.31.169.43'),
(2, '2026-02-14 16:06:36', 'SuperAdmin', 'admin Login Successful', 1, '203.31.169.43'),
(3, '2026-04-30 01:34:50', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.223'),
(4, '2026-04-30 01:57:38', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.223'),
(5, '2026-04-30 02:04:26', 'SuperAdmin', '[admin]: Recharge 01641267344 [api test][Taka. 525]', 1, '103.107.78.223'),
(6, '2026-04-30 02:09:24', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.223'),
(7, '2026-05-04 23:08:36', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.223'),
(8, '2026-05-04 23:11:04', 'User', '01641267344 Login Successful', 1, '103.107.78.223'),
(9, '2026-05-04 23:25:39', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.223'),
(10, '2026-05-04 23:49:18', 'SuperAdmin', 'admin Failed Login', 0, '103.107.78.223'),
(11, '2026-05-04 23:49:27', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.223'),
(12, '2026-05-10 18:34:21', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.202'),
(13, '2026-05-10 18:34:35', 'User', 'Admin admin Deactivate api test for 01641267344', 1, '103.107.78.202'),
(14, '2026-05-10 18:35:37', 'SuperAdmin', '[admin]: Recharge 01641267344 [api test][Taka. 525]', 1, '103.107.78.202'),
(15, '2026-05-11 21:05:14', 'SuperAdmin', '[admin]: Recharge 01776349920 [50Mbps][Taka. 525]', 1, '103.230.106.30'),
(16, '2026-05-11 21:47:31', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.202'),
(17, '2026-05-11 21:47:45', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.202'),
(18, '2026-05-11 21:48:15', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.202'),
(19, '2026-05-11 22:05:18', 'User', '01776349920 Login Successful', 7, '103.107.78.223'),
(20, '2026-05-12 00:44:58', 'SuperAdmin', 'admin Failed Login', 0, '103.107.78.202'),
(21, '2026-05-12 00:45:06', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.202'),
(22, '2026-05-12 01:13:30', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.202'),
(23, '2026-05-12 01:33:48', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.202'),
(24, '2026-05-12 01:34:47', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.202'),
(25, '2026-05-12 01:55:09', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.202'),
(26, '2026-05-12 02:01:45', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.202'),
(27, '2026-05-12 02:04:52', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.202'),
(28, '2026-05-14 17:53:04', 'SuperAdmin', '[admin]: Recharge 01778359510 [50Mbps][Taka. 525]', 1, '103.230.107.34'),
(29, '2026-05-20 13:41:36', 'SuperAdmin', 'admin Failed Login', 0, '103.107.78.220'),
(30, '2026-05-20 13:41:45', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.220'),
(31, '2026-05-27 18:32:16', 'SuperAdmin', 'admin Failed Login', 0, '103.230.105.6'),
(32, '2026-05-27 18:32:25', 'SuperAdmin', 'admin Login Successful', 1, '103.230.105.6'),
(33, '2026-05-27 20:34:39', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.223'),
(34, '2026-05-27 20:56:08', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.223'),
(35, '2026-06-01 03:27:32', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.223'),
(36, '2026-06-04 18:09:34', 'SuperAdmin', 'admin Failed Login', 0, '103.107.78.223'),
(37, '2026-06-04 18:09:41', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.223'),
(38, '2026-06-05 20:57:58', 'SuperAdmin', 'admin Failed Login', 0, '103.107.78.223'),
(39, '2026-06-05 20:58:11', 'SuperAdmin', 'admin Failed Login', 0, '103.107.78.223'),
(40, '2026-06-06 22:45:58', 'SuperAdmin', '[admin]: Recharge 01794828150 [50Mbps][Taka. 525]', 1, '103.230.105.45'),
(41, '2026-06-11 23:45:59', 'SuperAdmin', 'admin Failed Login', 0, '103.107.78.223'),
(42, '2026-06-11 23:46:31', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.223'),
(43, '2026-06-15 14:36:19', 'SuperAdmin', '[admin]: Recharge 01788524774 [50Mbps][Taka. 525]', 1, '103.107.78.223'),
(44, '2026-06-16 18:33:18', 'SuperAdmin', '[admin]: Recharge 01711384968 [50Mbps][Taka. 525]', 1, '103.107.78.223'),
(45, '2026-06-16 19:10:38', 'SuperAdmin', '[admin]: Recharge Hridoy [50Mbps][Taka. 525]', 1, '103.107.78.223'),
(46, '2026-06-16 19:58:48', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.223'),
(47, '2026-06-19 21:11:09', 'SuperAdmin', 'admin Failed Login', 0, '103.107.78.221'),
(48, '2026-06-19 21:11:16', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.221'),
(49, '2026-06-19 21:13:39', 'SuperAdmin', '[admin]: Recharge 01837230510 [50Mbps][Taka. 525]', 1, '103.107.78.221'),
(50, '2026-06-21 15:15:55', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.221'),
(51, '2026-06-22 23:15:08', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.221'),
(52, '2026-06-23 16:49:53', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.220'),
(53, '2026-06-23 16:50:19', 'User', '01711384968 Login Successful', 11, '103.107.78.221'),
(54, '2026-06-23 17:17:25', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.221'),
(55, '2026-06-23 17:26:00', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.221'),
(56, '2026-06-23 17:27:30', 'SuperAdmin', '[admin]: Recharge 01778359510 [50Mbps][Taka. 525]', 1, '103.107.78.221'),
(57, '2026-06-23 17:28:55', 'SuperAdmin', '[admin]: Recharge 01776349920 [50Mbps][Taka. 525]', 1, '103.107.78.221'),
(58, '2026-06-23 17:35:09', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.221'),
(59, '2026-06-23 17:35:25', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.221'),
(60, '2026-06-23 17:35:48', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.221'),
(61, '2026-06-23 17:35:54', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.221'),
(62, '2026-06-23 17:47:47', 'SuperAdmin', '[admin]: Created Agent <b>test</b>', 1, '103.107.78.221'),
(63, '2026-06-23 17:48:03', 'Agent', 'test Login Successful', 2, '103.107.78.221'),
(64, '2026-06-23 17:48:53', 'SuperAdmin', '[admin]: $username User Updated Successfully', 1, '103.107.78.221'),
(65, '2026-06-23 17:49:36', 'Sales', 'test Login Successful', 2, '103.107.78.221'),
(66, '2026-06-23 18:58:00', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.221'),
(67, '2026-06-23 19:02:23', 'SuperAdmin', '[admin]: Edit Plan for Customer 01778359510 to [50Mbps][Taka. 0]', 1, '103.107.78.221'),
(68, '2026-06-23 19:02:57', 'SuperAdmin', '[admin]: Recharge 01926403967 [50Mbps][Taka. 525]', 1, '103.107.78.221'),
(69, '2026-06-23 19:03:40', 'SuperAdmin', '[admin]: Delete Plan for Customer 01778359510  [][Taka. 0]', 1, '103.107.78.221'),
(70, '2026-06-23 19:04:01', 'SuperAdmin', '[admin]: Edit Plan for Customer 01926403967 to [50Mbps][Taka. 0]', 1, '103.107.78.221'),
(71, '2026-06-23 19:04:14', 'SuperAdmin', '[admin]: Recharge 01926403967 [50Mbps][Taka. 525]', 1, '103.107.78.221'),
(72, '2026-06-23 19:21:41', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.221'),
(73, '2026-06-23 19:24:43', 'SuperAdmin', '[admin]: Created Reseller <b>testa</b>', 1, '103.107.78.221'),
(74, '2026-06-23 19:25:02', 'Reseller', 'testa Login Successful', 3, '103.107.78.221'),
(75, '2026-06-23 19:31:15', 'User', '01926403967 Login Successful', 14, '103.107.78.221'),
(76, '2026-06-25 18:30:50', 'SuperAdmin', '[admin]: Recharge 01760132069 [50Mbps][Taka. 525]', 1, '103.107.78.223'),
(77, '2026-06-27 17:38:34', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.223'),
(78, '2026-06-27 19:28:33', 'SuperAdmin', '[admin]: Edit Plan for Customer 01683194881 to [50Mbps][Taka. 0]', 1, '103.107.78.223'),
(79, '2026-06-27 19:28:45', 'SuperAdmin', '[admin]: Edit Plan for Customer 01794828150 to [50Mbps][Taka. 0]', 1, '103.107.78.223'),
(80, '2026-06-27 19:28:56', 'SuperAdmin', '[admin]: Edit Plan for Customer 01788524774 to [50Mbps][Taka. 0]', 1, '103.107.78.223'),
(81, '2026-06-27 19:29:03', 'SuperAdmin', '[admin]: Edit Plan for Customer 01711384968 to [50Mbps][Taka. 0]', 1, '103.107.78.223'),
(82, '2026-06-27 19:29:12', 'SuperAdmin', '[admin]: Edit Plan for Customer Hridoy to [50Mbps][Taka. 0]', 1, '103.107.78.223'),
(83, '2026-06-27 19:30:34', 'SuperAdmin', '[admin]: Edit Plan for Customer 01760132069 to [50Mbps][Taka. 0]', 1, '103.107.78.223'),
(84, '2026-06-27 19:30:49', 'SuperAdmin', '[admin]: Edit Plan for Customer 01837230510 to [50Mbps][Taka. 0]', 1, '103.107.78.223'),
(85, '2026-06-28 21:42:22', 'SuperAdmin', '[admin]: Delete Plan for Customer 01577302042  [][Taka. 0]', 1, '58.145.186.218'),
(86, '2026-07-02 18:26:11', 'SuperAdmin', 'admin Login Successful', 1, '103.230.107.46'),
(87, '2026-07-03 17:16:13', 'SuperAdmin', '[admin]: Recharge 01733965058 [50Mbps][Taka. 525]', 1, '103.230.104.18'),
(88, '2026-07-03 17:32:18', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.220'),
(89, '2026-07-03 17:39:41', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.220'),
(90, '2026-07-03 18:07:28', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.220'),
(91, '2026-07-04 03:54:47', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.220'),
(92, '2026-07-04 03:57:48', 'SuperAdmin', '[admin]: Recharge 01577302042 [50Mbps][Taka. 525]', 1, '103.107.78.220'),
(93, '2026-07-04 03:58:32', 'SuperAdmin', '[admin]: Delete Plan for Customer 01577302042  [][Taka. 0]', 1, '103.107.78.220'),
(94, '2026-07-04 03:58:56', 'SuperAdmin', '[admin]: Recharge 01577302042 [50Mbps][Taka. 0]', 1, '103.107.78.220'),
(95, '2026-07-04 03:59:42', 'User', 'Admin admin Deactivate 50Mbps for 01577302042', 1, '103.107.78.220'),
(96, '2026-07-04 04:40:34', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.220'),
(97, '2026-07-04 04:42:28', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.220'),
(98, '2026-07-04 04:43:40', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.220'),
(99, '2026-07-04 04:44:07', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.220'),
(100, '2026-07-04 04:44:43', 'SuperAdmin', '[admin]: Recharge 01577302042 [50Mbps][Taka. 0]', 1, '103.107.78.220'),
(101, '2026-07-06 20:47:42', 'SuperAdmin', '[admin]: Recharge 01988239494 [50Mbps][Taka. 525]', 1, '103.230.107.43'),
(102, '2026-07-07 11:28:55', 'SuperAdmin', '[admin]: Recharge 01794828150 [50Mbps][Taka. 525]', 1, '103.107.78.220'),
(103, '2026-07-10 20:31:11', 'SuperAdmin', '[admin]: Recharge 01928895805 [50Mbps][Taka. 525]', 1, '103.230.106.52'),
(104, '2026-07-11 12:48:52', 'SuperAdmin', 'admin Failed Login', 0, '103.107.78.221'),
(105, '2026-07-11 12:49:02', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.221'),
(106, '2026-07-14 23:30:28', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.221'),
(107, '2026-07-14 23:31:24', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.221'),
(108, '2026-07-14 23:33:44', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.221'),
(109, '2026-07-14 23:34:30', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.221'),
(110, '2026-07-14 23:39:06', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.221'),
(111, '2026-07-15 11:12:00', 'SuperAdmin', '[admin]: Recharge 01788524774 [50Mbps][Taka. 525]', 1, '103.107.78.221'),
(112, '2026-07-15 21:49:35', 'SuperAdmin', '[admin]: Recharge 01762383092 [50Mbps][Taka. 525]', 1, '103.230.107.17'),
(113, '2026-07-15 23:20:09', 'SuperAdmin', '[admin]: Recharge 01712520008 [50Mbps][Taka. 525]', 1, '103.107.78.221'),
(114, '2026-07-16 16:18:08', 'SuperAdmin', '[admin]: Recharge Hridoy [50Mbps][Taka. 525]', 1, '103.230.107.45'),
(115, '2026-07-16 20:51:22', 'SuperAdmin', '[admin]: Recharge 01711384968 [50Mbps][Taka. 525]', 1, '103.230.107.45'),
(116, '2026-07-19 03:46:03', 'SuperAdmin', 'admin Login Successful', 1, '103.230.106.38'),
(117, '2026-07-19 18:35:55', 'SuperAdmin', '[admin]: Recharge 01837230510 [50Mbps][Taka. 525]', 1, '103.107.78.221'),
(118, '2026-07-21 20:01:42', 'SuperAdmin', '[admin]: Edit Plan for Customer 01683194881 to [50Mbps][Taka. 0]', 1, '103.107.78.221'),
(119, '2026-07-21 20:49:38', 'SuperAdmin', '[admin]: Delete Plan for Customer 01577302042  [][Taka. 0]', 1, '103.107.78.221'),
(120, '2026-07-22 22:35:02', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.221'),
(121, '2026-07-22 22:36:02', 'SuperAdmin', '[admin]: Recharge ShirinAntie [50Mbps][Taka. 525]', 1, '103.107.78.221'),
(122, '2026-07-22 22:37:43', 'SuperAdmin', '[admin]: Edit Plan for Customer ShirinAntie to [50Mbps][Taka. 0]', 1, '103.107.78.221'),
(123, '2026-07-22 22:43:28', 'SuperAdmin', '[admin]: Recharge 01577302042 [50Mbps][Taka. 525]', 1, '103.107.78.221'),
(124, '2026-07-22 22:48:59', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.221'),
(125, '2026-07-23 22:37:24', 'SuperAdmin', '[admin]: Recharge ChotonNehalFarm [50Mbps][Taka. 525]', 1, '103.230.105.49'),
(126, '2026-07-24 00:32:29', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.221'),
(127, '2026-07-24 00:33:49', 'SuperAdmin', '[admin]: Recharge Rohantayiba [50Mbps][Taka. 525]', 1, '103.107.78.221'),
(128, '2026-07-24 00:34:48', 'SuperAdmin', '[admin]: Edit Plan for Customer Rohantayiba to [50Mbps][Taka. 0]', 1, '103.107.78.221'),
(129, '2026-07-25 17:58:14', 'SuperAdmin', '[admin]: Recharge 01760132069 [50Mbps][Taka. 525]', 1, '103.230.104.36'),
(130, '2026-07-26 19:38:32', 'SuperAdmin', 'admin Failed Login', 0, '103.107.78.221'),
(131, '2026-07-26 19:38:39', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.221'),
(132, '2026-07-26 19:42:46', 'SuperAdmin', '[admin]: Recharge 01830932211 [50Mbps][Taka. 525]', 1, '103.230.105.30'),
(133, '2026-07-26 19:43:38', 'SuperAdmin', '[admin]: Edit Plan for Customer 01830932211 to [50Mbps][Taka. 0]', 1, '103.230.105.30'),
(134, '2026-07-29 19:55:48', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.221'),
(135, '2026-08-02 20:05:51', 'SuperAdmin', 'admin Failed Login', 0, '103.153.66.53'),
(136, '2026-08-02 20:05:59', 'SuperAdmin', 'admin Login Successful', 1, '103.153.66.53'),
(137, '2026-08-02 20:06:27', 'SuperAdmin', '[admin]: Recharge 01733965058 [50Mbps][Taka. 525]', 1, '103.153.66.53'),
(138, '2026-08-02 20:06:50', 'User', '01733965058 Failed Login', 0, '103.153.66.53'),
(139, '2026-08-03 12:21:00', 'SuperAdmin', '[admin]: Recharge 01683194881 [50Mbps][Taka. 525]', 1, '103.107.78.221'),
(140, '2026-08-03 18:01:20', 'SuperAdmin', '[admin]: Recharge 01637095906 [50Mbps][Taka. 525]', 1, '103.230.104.16'),
(141, '2026-08-03 18:03:17', 'SuperAdmin', '[admin]: Edit Plan for Customer 01637095906 to [50Mbps][Taka. 0]', 1, '103.230.104.16'),
(142, '2026-08-03 19:00:42', 'SuperAdmin', '[admin]: Recharge 01797480075 [50Mbps][Taka. 525]', 1, '103.230.104.16'),
(143, '2026-08-03 22:10:16', 'SuperAdmin', '[admin]: Recharge ShirinAntie [50Mbps][Taka. 525]', 1, '103.107.78.221'),
(144, '2026-08-03 22:11:11', 'SuperAdmin', '[admin]: Settings Saved Successfully', 1, '103.107.78.221'),
(145, '2026-08-03 23:00:59', 'SuperAdmin', '[admin]: $username User Updated Successfully', 1, '103.107.78.223'),
(146, '2026-08-03 23:01:12', 'Agent', 'test Login Successful', 2, '103.107.78.223'),
(147, '2026-08-03 23:02:02', 'SuperAdmin', '[admin]: $username User Updated Successfully', 1, '103.107.78.223'),
(148, '2026-08-05 20:28:43', 'SuperAdmin', 'admin Login Successful', 1, '103.107.78.223');

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

--
-- Table structure for table `tbl_manual_payments`
--

CREATE TABLE `tbl_manual_payments` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `sender_number` varchar(20) NOT NULL,
  `trxid` varchar(100) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `note` text DEFAULT NULL,
  `status` enum('Pending','Approved','Rejected') DEFAULT 'Pending',
  `submitted_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_manual_payments`
--

INSERT INTO `tbl_manual_payments` (`id`, `user_id`, `invoice_id`, `sender_number`, `trxid`, `amount`, `note`, `status`, `submitted_at`) VALUES
(1, 1, 1, '01546546514', 'sdfgvdghsa', 525.00, '', 'Pending', '2026-05-11 23:23:57'),
(2, 1, 1, '01111111111', '1242', 52000.00, '', 'Approved', '2026-05-11 23:27:21'),
(3, 1, 2, '0111111111152', 'sdfgvdghsa', 50000.00, '', 'Pending', '2026-05-11 23:28:11');

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

--
-- Table structure for table `tbl_message_logs`
--

CREATE TABLE `tbl_message_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `message_type` varchar(50) DEFAULT NULL,
  `recipient` varchar(255) DEFAULT NULL,
  `message_content` text DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `error_message` text DEFAULT NULL,
  `sent_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_message_logs`
--

INSERT INTO `tbl_message_logs` (`id`, `message_type`, `recipient`, `message_content`, `status`, `error_message`, `sent_at`) VALUES
(1, 'SMS HTTP Response', '01577302042', 'PHPNuxBill Test SMS', 'Success', 'OK', '2026-05-11 19:55:30'),
(2, 'SMS HTTP Response', '8801577302042', 'Use placeholders:\r\nAlif Ahammad - Customer Name\r\n01577302042 - Customer Username\r\n8801577302042 - Customer Phone\r\nAlif Network - Your Company Name\r\n?_route=home&recharge=1&uid=1.1781035078.e587ab791d9c31b89bf3e5e6f959601b607e4eb0', 'Success', 'OK', '2026-05-11 19:58:00'),
(3, 'SMS HTTP Response', '8801577302042', 'Hi hlw its test', 'Success', 'OK', '2026-05-11 19:59:07'),
(4, 'SMS HTTP Response', '01577302042', 'PHPNuxBill Test SMS', 'Success', 'OK', '2026-05-11 20:02:06'),
(5, 'SMS HTTP Response', '8801778359510', 'Welcome aboard, Jisan Mulla! \r\nWe\'re excited to have you as a new Alif Network customer. \r\nYour account is all set up and ready to go.\r\n\r\nHere\'s a quick overview:\r\n\r\nPortal: https://crm.amaxsolutions.online/?_route=login\r\nYour login is  [[Username]]\r\nYour temporary password is  [[Password]] (please change this on your first login)\r\n\r\nNeed help? Reach out to our support team at anytime.\r\n\r\nWe\'re here to ensure you have an amazing experience with our services. Let us know how we can best support you.\r\n\r\nWelcome to the Alif Network family!', 'Success', 'OK', '2026-05-14 11:52:04'),
(6, 'Email', 'alifahmud123123@gmail.com', 'PHPNuxBill Test Email Body', 'Success', NULL, '2026-05-31 21:28:07'),
(7, 'SMS HTTP Response', '8801794828150', 'Welcome aboard, Rony, sani bhai! \r\nWe\'re excited to have you as a new Alif Network customer. \r\nYour account is all set up and ready to go.\r\n\r\nHere\'s a quick overview:\r\n\r\nPortal: https://crm.amaxsolutions.online/?_route=login\r\nYour login is  [[Username]]\r\nYour temporary password is  [[Password]] (please change this on your first login)\r\n\r\nNeed help? Reach out to our support team at anytime.\r\n\r\nWe\'re here to ensure you have an amazing experience with our services. Let us know how we can best support you.\r\n\r\nWelcome to the Alif Network family!', 'Success', 'OK', '2026-06-06 16:42:01'),
(8, 'SMS HTTP Response', '8801711384968', 'Welcome aboard, Alamin Uncle! \r\nWe\'re excited to have you as a new Alif Network customer. \r\nYour account is all set up and ready to go.\r\n\r\nHere\'s a quick overview:\r\n\r\nPortal: https://crm.amaxsolutions.online/?_route=login\r\nYour login is  [[Username]]\r\nYour temporary password is  [[Password]] (please change this on your first login)\r\n\r\nNeed help? Reach out to our support team at anytime.\r\n\r\nWe\'re here to ensure you have an amazing experience with our services. Let us know how we can best support you.\r\n\r\nWelcome to the Alif Network family!', 'Success', 'OK', '2026-06-16 12:31:07'),
(9, 'SMS HTTP Response', '8801837230510', 'Welcome aboard, Piyash Chowdhuri! \r\nWe\'re excited to have you as a new Alif Network customer. \r\nYour account is all set up and ready to go.\r\n\r\nHere\'s a quick overview:\r\n\r\nPortal: https://crm.amaxsolutions.online/?_route=login\r\nYour login is  [[Username]]\r\nYour temporary password is  [[Password]] (please change this on your first login)\r\n\r\nNeed help? Reach out to our support team at anytime.\r\n\r\nWe\'re here to ensure you have an amazing experience with our services. Let us know how we can best support you.\r\n\r\nWelcome to the Alif Network family!', 'Success', 'OK', '2026-06-19 15:12:39'),
(10, 'SMS HTTP Response', '8801577302042', 'Hello Alif Ahammad, your internet package api test has been expired.', 'Success', 'OK', '2026-06-23 11:25:13'),
(11, 'SMS HTTP Response', '8801778359510', 'Hello Jisan Mulla, your internet package 50Mbps has been expired.', 'Success', 'OK', '2026-06-23 11:25:15'),
(12, 'SMS HTTP Response', '8801776349920', 'Hello Aiyub Sharkar, your internet package 50Mbps has been expired.', 'Success', 'OK', '2026-06-23 11:25:16'),
(13, 'SMS HTTP Response', '8801733965058', 'Sonjoy sir! \r\n[[Username]]\r\n866160\r\nhttps://crm.amaxsolutions.online/?_route=login\r\nAlif Network', 'Success', 'Unauthorized', '2026-07-03 11:15:37'),
(14, 'SMS HTTP Response', '8801794828150', 'Hello Rony, sani bhai, your internet package 50Mbps has been expired.', 'Success', 'Unauthorized', '2026-07-06 05:00:13'),
(15, 'SMS HTTP Response', '01577302042', 'PHPNuxBill Test SMS', 'Success', 'OK', '2026-07-14 17:37:29'),
(16, 'SMS HTTP Response', '8801788524774', '[[company_name]] Hello Ujjol, your internet package 50Mbps has been expired.', 'Success', 'Unauthorized', '2026-07-15 05:00:15'),
(17, 'SMS HTTP Response', '8801711384968', '[[company_name]] Hello Alamin Uncle, your internet package 50Mbps has been expired.', 'Success', 'Unauthorized', '2026-07-16 05:00:06'),
(18, 'SMS HTTP Response', '8801708052727', '[[company_name]] Hello Hridoy, your internet package 50Mbps has been expired.', 'Success', 'Unauthorized', '2026-07-16 05:00:07'),
(19, 'SMS HTTP Response', '8801837230510', '[[company_name]] Hello Piyash Chowdhuri, your internet package 50Mbps has been expired.', 'Success', 'Unauthorized', '2026-07-19 05:00:14'),
(20, 'SMS HTTP Response', '8801760132069', '[[company_name]] Hello Shayan Ahmed police, your internet package 50Mbps has been expired.', 'Success', 'OK', '2026-07-25 05:00:15'),
(21, 'SMS HTTP Response', 'Shirin Antie', '[[company_name]] Hello Shirin Antie, your internet package 50Mbps has been expired.', 'Success', 'FAILED', '2026-08-02 05:00:16'),
(22, 'SMS HTTP Response', '8801733965058', '[[company_name]] Hello Sonjoy sir, your internet package 50Mbps has been expired.', 'Success', 'OK', '2026-08-02 11:20:13'),
(23, 'SMS HTTP Response', '8801683194881', '[[company_name]] Hello Fariya, your internet package 50Mbps has been expired.', 'Success', 'OK', '2026-08-03 05:00:07');

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

--
-- Table structure for table `tbl_meta`
--

CREATE TABLE `tbl_meta` (
  `id` int(10) UNSIGNED NOT NULL,
  `tbl` varchar(32) NOT NULL COMMENT 'Table name',
  `tbl_id` int(11) NOT NULL COMMENT 'table value id',
  `name` varchar(32) NOT NULL,
  `value` mediumtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='This Table to add additional data for any table';

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

--
-- Table structure for table `tbl_odps`
--

CREATE TABLE `tbl_odps` (
  `id` int(11) NOT NULL,
  `name` varchar(32) NOT NULL,
  `port_amount` int(11) NOT NULL,
  `attenuation` decimal(15,2) NOT NULL DEFAULT 0.00,
  `address` mediumtext NOT NULL,
  `coordinates` varchar(50) NOT NULL,
  `coverage` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `tbl_payment_gateway`
--

CREATE TABLE `tbl_payment_gateway` (
  `id` int(11) NOT NULL,
  `username` varchar(32) NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `gateway` varchar(32) NOT NULL COMMENT 'xendit | midtrans',
  `gateway_trx_id` varchar(512) NOT NULL DEFAULT '',
  `plan_id` int(11) NOT NULL,
  `plan_name` varchar(40) NOT NULL,
  `routers_id` int(11) NOT NULL,
  `routers` varchar(32) NOT NULL,
  `price` varchar(40) NOT NULL,
  `pg_url_payment` varchar(512) NOT NULL DEFAULT '',
  `payment_method` varchar(32) NOT NULL DEFAULT '',
  `payment_channel` varchar(32) NOT NULL DEFAULT '',
  `pg_request` text DEFAULT NULL,
  `pg_paid_response` text DEFAULT NULL,
  `expired_date` datetime DEFAULT NULL,
  `created_date` datetime NOT NULL,
  `paid_date` datetime DEFAULT NULL,
  `trx_invoice` varchar(25) NOT NULL DEFAULT '' COMMENT 'from tbl_transactions',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 unpaid 2 paid 3 failed 4 canceled'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_payment_gateway`
--

INSERT INTO `tbl_payment_gateway` (`id`, `username`, `user_id`, `gateway`, `gateway_trx_id`, `plan_id`, `plan_name`, `routers_id`, `routers`, `price`, `pg_url_payment`, `payment_method`, `payment_channel`, `pg_request`, `pg_paid_response`, `expired_date`, `created_date`, `paid_date`, `trx_invoice`, `status`) VALUES
(1, '01641267344', 1, 'config', '', 1, '50Mbps', 1, 'testa', '525', '', '', '', NULL, NULL, NULL, '2026-05-11 23:27:21', NULL, '', 4),
(2, '01641267344', 1, 'config', '', 1, '50Mbps', 1, 'testa', '525', '', '', '', NULL, NULL, NULL, '2026-05-11 23:28:11', NULL, '', 2),
(3, '01577302042', 0, '01715911603', '', 0, 'Send Balance', 0, 'balance', '525', 'balance', 'Customer', 'Balance', NULL, NULL, '2026-08-03 22:26:08', '2026-08-03 22:26:08', '2026-08-03 22:26:08', '', 2),
(4, '01715911603', 0, '01577302042', '', 0, 'Receive Balance', 0, 'balance', '525', 'balance', 'Customer', 'Balance', NULL, NULL, '2026-08-03 22:26:08', '2026-08-03 22:26:08', '2026-08-03 22:26:08', '', 2),
(5, '01715911603', 0, '01577302042', '', 0, 'Send Balance', 0, 'balance', '525', 'balance', 'Customer', 'Balance', NULL, NULL, '2026-08-03 22:27:19', '2026-08-03 22:27:19', '2026-08-03 22:27:19', '', 2),
(6, '01577302042', 0, '01715911603', '', 0, 'Receive Balance', 0, 'balance', '525', 'balance', 'Customer', 'Balance', NULL, NULL, '2026-08-03 22:27:19', '2026-08-03 22:27:19', '2026-08-03 22:27:19', '', 2),
(7, '01577302042', 1, '01715911603', '', 1, '50Mbps', 1, 'testa', '525', 'balance', 'Balance', 'Send Plan', NULL, NULL, '2026-08-03 22:28:09', '2026-08-03 22:28:09', '2026-08-03 22:28:09', 'INV-42', 2),
(8, '01715911603', 68, '01577302042', '', 1, '50Mbps', 1, 'testa', '525', 'balance', 'Balance', 'Received Plan', NULL, NULL, '2026-08-03 22:28:09', '2026-08-03 22:28:09', '2026-08-03 22:28:09', 'INV-42', 2),
(9, '01577302042', 1, 'config', '', 0, 'Custom', 0, 'Custom Balance', '1000', '', '', '', NULL, NULL, NULL, '2026-08-03 22:34:28', NULL, '', 4);

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

--
-- Table structure for table `tbl_plans`
--

CREATE TABLE `tbl_plans` (
  `id` int(11) NOT NULL,
  `name_plan` varchar(40) NOT NULL,
  `id_bw` int(11) NOT NULL,
  `price` varchar(40) NOT NULL,
  `price_old` varchar(40) NOT NULL DEFAULT '',
  `type` enum('Hotspot','PPPOE','VPN','Balance') NOT NULL,
  `typebp` enum('Unlimited','Limited') DEFAULT NULL,
  `limit_type` enum('Time_Limit','Data_Limit','Both_Limit') DEFAULT NULL,
  `time_limit` int(10) UNSIGNED DEFAULT NULL,
  `time_unit` enum('Mins','Hrs') DEFAULT NULL,
  `data_limit` int(10) UNSIGNED DEFAULT NULL,
  `data_unit` enum('MB','GB') DEFAULT NULL,
  `validity` int(11) NOT NULL,
  `validity_unit` enum('Mins','Hrs','Days','Months','Period') NOT NULL,
  `shared_users` int(11) DEFAULT NULL,
  `routers` varchar(32) NOT NULL,
  `is_radius` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1 is radius',
  `pool` varchar(40) DEFAULT NULL,
  `plan_expired` int(11) NOT NULL DEFAULT 0,
  `expired_date` tinyint(1) NOT NULL DEFAULT 20,
  `enabled` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0 disabled\r\n',
  `allow_purchase` enum('yes','no') DEFAULT 'yes' COMMENT 'allow to show package in buy package page',
  `prepaid` enum('yes','no') DEFAULT 'yes' COMMENT 'is prepaid',
  `plan_type` enum('Business','Personal') DEFAULT 'Personal' COMMENT 'For selecting account type',
  `device` varchar(32) NOT NULL DEFAULT '',
  `on_login` text DEFAULT NULL,
  `on_logout` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_plans`
--

INSERT INTO `tbl_plans` (`id`, `name_plan`, `id_bw`, `price`, `price_old`, `type`, `typebp`, `limit_type`, `time_limit`, `time_unit`, `data_limit`, `data_unit`, `validity`, `validity_unit`, `shared_users`, `routers`, `is_radius`, `pool`, `plan_expired`, `expired_date`, `enabled`, `allow_purchase`, `prepaid`, `plan_type`, `device`, `on_login`, `on_logout`) VALUES
(1, '50Mbps', 1, '525', '', 'PPPOE', NULL, NULL, NULL, NULL, NULL, NULL, 30, 'Days', NULL, 'testa', 0, 'apitst', 0, 0, 1, 'yes', 'yes', 'Personal', 'MikrotikPppoe', '', ''),
(2, '60Mbps', 2, '630', '', 'PPPOE', NULL, NULL, NULL, NULL, NULL, NULL, 30, 'Days', NULL, 'testa', 0, 'apitst', 0, 0, 1, 'yes', 'yes', 'Personal', 'MikrotikPppoe', NULL, NULL),
(3, '525', 0, '525', '', 'Balance', NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Months', NULL, '', 0, '', 0, 20, 1, 'yes', 'yes', 'Personal', '', NULL, NULL),
(4, '1050', 0, '1050', '', 'Balance', NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Months', NULL, '', 0, '', 0, 20, 1, 'yes', 'yes', 'Personal', '', NULL, NULL);

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

--
-- Table structure for table `tbl_pool`
--

CREATE TABLE `tbl_pool` (
  `id` int(11) NOT NULL,
  `pool_name` varchar(40) NOT NULL,
  `local_ip` varchar(40) NOT NULL DEFAULT '',
  `range_ip` varchar(40) NOT NULL,
  `routers` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_pool`
--

INSERT INTO `tbl_pool` (`id`, `pool_name`, `local_ip`, `range_ip`, `routers`) VALUES
(1, 'apitst', '10.4.0.1', '10.4.0.2-10.4.0.254', 'testa');

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

--
-- Table structure for table `tbl_port_pool`
--

CREATE TABLE `tbl_port_pool` (
  `id` int(10) NOT NULL,
  `public_ip` varchar(40) NOT NULL,
  `port_name` varchar(40) NOT NULL,
  `range_port` varchar(40) NOT NULL,
  `routers` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_reseller_commissions`
--

CREATE TABLE `tbl_reseller_commissions` (
  `id` int(11) NOT NULL,
  `reseller_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL DEFAULT 0,
  `transaction_id` int(11) NOT NULL DEFAULT 0,
  `plan_id` int(11) NOT NULL DEFAULT 0,
  `commission_percent` decimal(8,2) NOT NULL DEFAULT 0.00,
  `commission_amount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `routers` varchar(32) NOT NULL DEFAULT '',
  `gateway` varchar(64) NOT NULL DEFAULT '',
  `channel` varchar(64) NOT NULL DEFAULT '',
  `note` varchar(256) NOT NULL DEFAULT '',
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_routers`
--

CREATE TABLE `tbl_routers` (
  `id` int(11) NOT NULL,
  `name` varchar(32) NOT NULL,
  `ip_address` varchar(128) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(60) NOT NULL,
  `description` varchar(256) DEFAULT NULL,
  `coordinates` varchar(50) NOT NULL DEFAULT '',
  `status` enum('Online','Offline') DEFAULT 'Online',
  `last_seen` datetime DEFAULT NULL,
  `coverage` varchar(8) NOT NULL DEFAULT '0',
  `enabled` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0 disabled'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_routers`
--

INSERT INTO `tbl_routers` (`id`, `name`, `ip_address`, `username`, `password`, `description`, `coordinates`, `status`, `last_seen`, `coverage`, `enabled`) VALUES
(1, 'testa', '10.8.0.6', 'admin', 'Muntaha@41913', '', '23.869051778438408,91.21345451384532', 'Online', NULL, '0222', 1);

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

--
-- Table structure for table `tbl_transactions`
--

CREATE TABLE `tbl_transactions` (
  `id` int(11) NOT NULL,
  `invoice` varchar(25) NOT NULL,
  `username` varchar(32) NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `plan_name` varchar(40) NOT NULL,
  `price` varchar(40) NOT NULL,
  `recharged_on` date NOT NULL,
  `recharged_time` time NOT NULL DEFAULT '00:00:00',
  `expiration` date NOT NULL,
  `time` time NOT NULL,
  `method` varchar(128) NOT NULL,
  `routers` varchar(32) NOT NULL,
  `type` enum('Hotspot','PPPOE','VPN','Balance') NOT NULL,
  `note` varchar(256) NOT NULL DEFAULT '' COMMENT 'for note',
  `admin_id` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_transactions`
--

INSERT INTO `tbl_transactions` (`id`, `invoice`, `username`, `user_id`, `plan_name`, `price`, `recharged_on`, `recharged_time`, `expiration`, `time`, `method`, `routers`, `type`, `note`, `admin_id`) VALUES
(1, 'INV-1', '01641267344', 1, 'api test', '525', '2026-04-30', '02:04:26', '2026-05-30', '02:04:26', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(2, 'INV-2', '01641267344', 1, 'api test', '525', '2026-05-10', '18:35:36', '2026-06-09', '18:35:36', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(3, 'INV-3', '01776349920', 7, '50Mbps', '525', '2026-05-11', '21:05:14', '2026-06-10', '21:05:14', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(4, 'INV-4', '01778359510', 8, '50Mbps', '525', '2026-05-14', '17:53:04', '2026-06-13', '17:53:04', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(5, 'INV-5', '01794828150', 9, '50Mbps', '525', '2026-06-06', '22:45:58', '2026-07-06', '22:45:58', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(6, 'INV-6', '01788524774', 10, '50Mbps', '525', '2026-06-15', '14:36:19', '2026-07-15', '14:36:19', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(7, 'INV-7', '01711384968', 11, '50Mbps', '525', '2026-06-16', '18:33:17', '2026-07-16', '18:33:17', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(8, 'INV-8', 'Hridoy', 12, '50Mbps', '525', '2026-06-16', '19:10:37', '2026-07-16', '19:10:37', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(9, 'INV-9', '01837230510', 13, '50Mbps', '525', '2026-06-19', '21:13:38', '2026-07-19', '21:13:38', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(10, 'INV-10', '01778359510', 8, '50Mbps', '525', '2026-06-23', '17:27:30', '2026-07-23', '17:27:30', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(11, 'INV-11', '01776349920', 7, '50Mbps', '525', '2026-06-23', '17:28:55', '2026-07-23', '17:28:55', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(12, 'INV-12', '01926403967', 14, '50Mbps', '525', '2026-06-23', '19:02:56', '2026-07-23', '19:02:56', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(13, 'INV-13', '01926403967', 14, '50Mbps', '525', '2026-06-23', '19:04:14', '2026-08-09', '11:00:00', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(14, 'INV-14', '01760132069', 15, '50Mbps', '525', '2026-06-25', '18:30:50', '2026-07-25', '18:30:50', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(15, 'INV-15', '01733965058', 20, '50Mbps', '525', '2026-07-03', '17:16:13', '2026-08-02', '17:16:13', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(16, 'INV-16', '01577302042', 1, '50Mbps', '525', '2026-07-04', '03:57:48', '2026-08-03', '03:57:48', 'Bkash - Administrator', 'testa', 'PPPOE', '', 1),
(17, 'INV-17', '01577302042', 1, '50Mbps', '0', '2026-07-04', '03:58:56', '2026-08-03', '03:58:56', 'Recharge Zero - Administrator', 'testa', 'PPPOE', '', 1),
(18, 'INV-18', '01577302042', 1, '50Mbps', '0', '2026-07-04', '04:44:43', '2026-08-03', '04:44:43', 'Recharge Zero - Administrator', 'testa', 'PPPOE', '', 1),
(19, 'INV-19', '01988239494', 21, '50Mbps', '525', '2026-07-06', '20:47:40', '2026-08-05', '20:47:40', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(20, 'INV-20', '01794828150', 9, '50Mbps', '525', '2026-07-07', '11:28:54', '2026-08-06', '11:28:54', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(21, 'INV-21', '01928895805', 22, '50Mbps', '525', '2026-07-10', '20:31:10', '2026-08-09', '20:31:10', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(22, 'INV-22', '01788524774', 10, '50Mbps', '525', '2026-07-15', '11:12:00', '2026-08-14', '11:12:00', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(23, 'INV-23', '01762383092', 23, '50Mbps', '525', '2026-07-15', '21:49:34', '2026-08-14', '21:49:34', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(24, 'INV-24', '01712520008', 24, '50Mbps', '525', '2026-07-15', '23:20:09', '2026-08-14', '23:20:09', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(25, 'INV-25', 'Hridoy', 12, '50Mbps', '525', '2026-07-16', '16:18:08', '2026-08-15', '16:18:08', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(26, 'INV-26', '01711384968', 11, '50Mbps', '525', '2026-07-16', '20:51:21', '2026-08-15', '20:51:21', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(27, 'INV-27', '01837230510', 13, '50Mbps', '525', '2026-07-19', '18:35:54', '2026-08-18', '18:35:54', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(28, 'INV-28', '01577302042', 1, 'Balance', '100', '2026-07-21', '20:50:30', '2026-07-21', '20:50:30', 'Deposit - Administrator', 'balance', 'Balance', '', 1),
(29, 'INV-29', 'ShirinAntie', 48, '50Mbps', '525', '2026-07-22', '22:36:02', '2026-08-21', '22:36:02', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(30, 'INV-30', '01577302042', 1, 'Balance', '450', '2026-07-22', '22:40:33', '2026-07-22', '22:40:33', 'Deposit - Administrator', 'balance', 'Balance', '', 1),
(31, 'INV-31', '01577302042', 1, '50Mbps', '525', '2026-07-22', '22:43:28', '2026-08-21', '22:43:28', 'Recharge Balance - Administrator', 'testa', 'PPPOE', '', 1),
(32, 'INV-32', 'ChotonNehalFarm', 44, '50Mbps', '525', '2026-07-23', '22:37:23', '2026-08-22', '22:37:23', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(33, 'INV-33', 'Rohantayiba', 54, '50Mbps', '525', '2026-07-24', '00:33:48', '2026-08-23', '00:33:48', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(34, 'INV-34', '01760132069', 15, '50Mbps', '525', '2026-07-25', '17:58:14', '2026-08-24', '17:58:14', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(35, 'INV-35', '01830932211', 65, '50Mbps', '525', '2026-07-26', '19:42:46', '2026-08-25', '19:42:46', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(36, 'INV-36', '01733965058', 20, '50Mbps', '525', '2026-08-02', '20:06:27', '2026-09-01', '20:06:27', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(37, 'INV-37', '01683194881', 7, '50Mbps', '525', '2026-08-03', '12:20:59', '2026-09-02', '12:20:59', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(38, 'INV-38', '01637095906', 66, '50Mbps', '525', '2026-08-03', '18:01:20', '2026-09-02', '18:01:20', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(39, 'INV-39', '01797480075', 67, '50Mbps', '525', '2026-08-03', '19:00:42', '2026-09-02', '19:00:42', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(40, 'INV-40', 'ShirinAntie', 48, '50Mbps', '525', '2026-08-03', '22:10:16', '2026-09-02', '22:10:16', 'Cash - Administrator', 'testa', 'PPPOE', '', 1),
(41, 'INV-41', '01577302042', 1, '525', '525', '2026-08-03', '22:25:25', '2026-08-03', '22:25:25', 'Deposit - Administrator', 'balance', 'Balance', '', 1),
(42, 'INV-42', '01715911603', 68, '50Mbps', '525', '2026-08-03', '22:28:08', '2026-09-02', '22:28:08', '01577302042 - Balance', 'testa', 'PPPOE', '', 1);

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

--
-- Table structure for table `tbl_users`
--

CREATE TABLE `tbl_users` (
  `id` int(10) UNSIGNED NOT NULL,
  `root` int(11) NOT NULL DEFAULT 0 COMMENT 'for sub account',
  `photo` varchar(128) NOT NULL DEFAULT '/admin.default.png',
  `username` varchar(45) NOT NULL DEFAULT '',
  `fullname` varchar(45) NOT NULL DEFAULT '',
  `password` varchar(64) NOT NULL,
  `phone` varchar(32) NOT NULL DEFAULT '',
  `email` varchar(128) NOT NULL DEFAULT '',
  `city` varchar(64) NOT NULL DEFAULT '' COMMENT 'kota',
  `subdistrict` varchar(64) NOT NULL DEFAULT '' COMMENT 'kecamatan',
  `ward` varchar(64) NOT NULL DEFAULT '' COMMENT 'kelurahan',
  `commission_percentage` decimal(8,2) NOT NULL DEFAULT 0.00,
  `wallet_balance` decimal(15,2) NOT NULL DEFAULT 0.00,
  `user_type` enum('SuperAdmin','Admin','Report','Agent','Sales','Reseller') NOT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  `data` text DEFAULT NULL COMMENT 'to put additional data',
  `last_login` datetime DEFAULT NULL,
  `login_token` varchar(40) DEFAULT NULL,
  `creationdate` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_users`
--

INSERT INTO `tbl_users` (`id`, `root`, `photo`, `username`, `fullname`, `password`, `phone`, `email`, `city`, `subdistrict`, `ward`, `commission_percentage`, `wallet_balance`, `user_type`, `status`, `data`, `last_login`, `login_token`, `creationdate`) VALUES
(1, 0, '/admin.default.png', 'admin', 'Administrator', 'd033e22ae348aeb5660fc2140aec35850c4da997', '', '', '', '', '', 0.00, 0.00, 'SuperAdmin', 'Active', NULL, '2026-08-05 20:28:43', 'd6cf6d2e938707fd937d19709d95d82c9dd3d3b8', '2014-06-23 01:43:07'),
(2, 2, '/admin.default.png', 'test', 'test', '51abb9636078defbf888d8457a7c76f85c8f114c', '01641267344', 'test', 'test', 'test', 'test', 0.00, 0.00, 'Report', 'Active', NULL, '2026-08-03 23:01:12', 'd5154a03ab52966f60d79af6f90920c38994dc5c', '2026-06-23 17:47:47'),
(3, 0, '/admin.default.png', 'testa', 'testatesta', 'd1ef2f388f165acbae656604af40edf83fd8b299', '01641267344', 'abulhossain9h@gmail.com', 'Brahmanbaria', 'testa', 'testa', 0.00, 0.00, 'Reseller', 'Active', NULL, '2026-06-23 19:25:02', '8d2a642fe14657de3d7a452f292d7aba62df24db', '2026-06-23 19:24:43');

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

--
-- Table structure for table `tbl_user_recharges`
--

CREATE TABLE `tbl_user_recharges` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `username` varchar(32) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `namebp` varchar(40) NOT NULL,
  `recharged_on` date NOT NULL,
  `recharged_time` time NOT NULL DEFAULT '00:00:00',
  `expiration` date NOT NULL,
  `time` time NOT NULL,
  `status` varchar(20) NOT NULL,
  `method` varchar(128) NOT NULL DEFAULT '',
  `routers` varchar(32) NOT NULL,
  `type` varchar(15) NOT NULL,
  `admin_id` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_user_recharges`
--

INSERT INTO `tbl_user_recharges` (`id`, `customer_id`, `username`, `plan_id`, `namebp`, `recharged_on`, `recharged_time`, `expiration`, `time`, `status`, `method`, `routers`, `type`, `admin_id`) VALUES
(2, 7, '01683194881', 1, '50Mbps', '2026-08-03', '12:20:59', '2026-09-02', '12:20:59', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(4, 9, '01794828150', 1, '50Mbps', '2026-07-07', '11:28:54', '2026-08-06', '11:28:54', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(5, 10, '01788524774', 1, '50Mbps', '2026-07-15', '11:12:00', '2026-08-14', '11:12:00', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(6, 11, '01711384968', 1, '50Mbps', '2026-07-16', '20:51:21', '2026-08-15', '20:51:21', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(7, 12, 'Hridoy', 1, '50Mbps', '2026-07-16', '16:18:08', '2026-08-15', '16:18:08', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(8, 13, '01837230510', 1, '50Mbps', '2026-07-19', '18:35:54', '2026-08-18', '18:35:54', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(9, 14, '01926403967', 1, '50Mbps', '2026-06-23', '19:04:14', '2026-08-09', '11:00:00', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(10, 15, '01760132069', 1, '50Mbps', '2026-07-25', '17:58:14', '2026-08-24', '17:58:14', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(11, 20, '01733965058', 1, '50Mbps', '2026-08-02', '20:06:27', '2026-09-01', '20:06:27', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(14, 21, '01988239494', 1, '50Mbps', '2026-07-06', '20:47:40', '2026-08-05', '20:47:40', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(15, 22, '01928895805', 1, '50Mbps', '2026-07-10', '20:31:10', '2026-08-09', '20:31:10', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(16, 23, '01762383092', 1, '50Mbps', '2026-07-15', '21:49:34', '2026-08-14', '21:49:34', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(17, 24, '01712520008', 1, '50Mbps', '2026-07-15', '23:20:09', '2026-08-14', '23:20:09', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(18, 48, 'ShirinAntie', 1, '50Mbps', '2026-08-03', '22:10:16', '2026-09-02', '22:10:16', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(19, 1, '01577302042', 1, '50Mbps', '2026-07-22', '22:43:28', '2026-08-21', '22:43:28', 'on', 'Recharge Balance - Administrator', 'testa', 'PPPOE', 1),
(20, 44, 'ChotonNehalFarm', 1, '50Mbps', '2026-07-23', '22:37:23', '2026-08-22', '22:37:23', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(21, 54, 'Rohantayiba', 1, '50Mbps', '2026-07-24', '00:33:48', '2026-08-10', '11:00:00', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(22, 65, '01830932211', 1, '50Mbps', '2026-07-26', '19:42:46', '2026-08-12', '11:00:00', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(23, 66, '01637095906', 1, '50Mbps', '2026-08-03', '18:01:20', '2026-09-17', '11:00:00', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(24, 67, '01797480075', 1, '50Mbps', '2026-08-03', '19:00:42', '2026-09-02', '19:00:42', 'on', 'Cash - Administrator', 'testa', 'PPPOE', 1),
(25, 68, '01715911603', 1, '50Mbps', '2026-08-03', '22:28:08', '2026-09-02', '22:28:08', 'on', '01577302042 - Balance', 'testa', 'PPPOE', 1);

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

--
-- Table structure for table `tbl_voucher`
--

CREATE TABLE `tbl_voucher` (
  `id` int(11) NOT NULL,
  `type` enum('Hotspot','PPPOE') NOT NULL,
  `routers` varchar(32) NOT NULL,
  `id_plan` int(11) NOT NULL,
  `code` varchar(55) NOT NULL,
  `user` varchar(45) NOT NULL,
  `status` varchar(25) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `used_date` datetime DEFAULT NULL,
  `generated_by` int(11) NOT NULL DEFAULT 0 COMMENT 'id admin'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_widgets`
--

CREATE TABLE `tbl_widgets` (
  `id` int(11) NOT NULL,
  `orders` int(11) NOT NULL DEFAULT 99,
  `position` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1. top 2. left 3. right 4. bottom',
  `user` enum('Admin','Agent','Sales','Customer') NOT NULL DEFAULT 'Admin',
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `title` varchar(64) NOT NULL,
  `widget` varchar(64) NOT NULL DEFAULT '',
  `content` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_widgets`
--

INSERT INTO `tbl_widgets` (`id`, `orders`, `position`, `user`, `enabled`, `title`, `widget`, `content`) VALUES
(1, 1, 1, 'Admin', 1, 'Top Widget', 'top_widget', ''),
(2, 2, 1, 'Admin', 1, 'Default Info', 'default_info_row', ''),
(3, 1, 2, 'Admin', 1, 'Graph Monthly Registered Customers', 'graph_monthly_registered_customers', ''),
(4, 2, 2, 'Admin', 1, 'Graph Monthly Sales', 'graph_monthly_sales', ''),
(5, 3, 2, 'Admin', 1, 'Voucher Stocks', 'voucher_stocks', ''),
(6, 4, 2, 'Admin', 1, 'Customer Expired', 'customer_expired', ''),
(7, 1, 3, 'Admin', 1, 'Cron Monitor', 'cron_monitor', ''),
(8, 2, 3, 'Admin', 1, 'Mikrotik Cron Monitor', 'mikrotik_cron_monitor', ''),
(9, 3, 3, 'Admin', 1, 'Info Payment Gateway', 'info_payment_gateway', ''),
(10, 4, 3, 'Admin', 1, 'Graph Customers Insight', 'graph_customers_insight', ''),
(11, 5, 3, 'Admin', 1, 'Activity Log', 'activity_log', ''),
(30, 1, 1, 'Agent', 1, 'Top Widget', 'top_widget', ''),
(31, 2, 1, 'Agent', 1, 'Default Info', 'default_info_row', ''),
(32, 1, 2, 'Agent', 1, 'Graph Monthly Registered Customers', 'graph_monthly_registered_customers', ''),
(33, 2, 2, 'Agent', 1, 'Graph Monthly Sales', 'graph_monthly_sales', ''),
(34, 3, 2, 'Agent', 1, 'Voucher Stocks', 'voucher_stocks', ''),
(35, 4, 2, 'Agent', 1, 'Customer Expired', 'customer_expired', ''),
(36, 1, 3, 'Agent', 1, 'Cron Monitor', 'cron_monitor', ''),
(37, 2, 3, 'Agent', 1, 'Mikrotik Cron Monitor', 'mikrotik_cron_monitor', ''),
(38, 3, 3, 'Agent', 1, 'Info Payment Gateway', 'info_payment_gateway', ''),
(39, 4, 3, 'Agent', 1, 'Graph Customers Insight', 'graph_customers_insight', ''),
(40, 5, 3, 'Agent', 1, 'Activity Log', 'activity_log', ''),
(41, 1, 1, 'Sales', 1, 'Top Widget', 'top_widget', ''),
(42, 2, 1, 'Sales', 1, 'Default Info', 'default_info_row', ''),
(43, 1, 2, 'Sales', 1, 'Graph Monthly Registered Customers', 'graph_monthly_registered_customers', ''),
(44, 2, 2, 'Sales', 1, 'Graph Monthly Sales', 'graph_monthly_sales', ''),
(45, 3, 2, 'Sales', 1, 'Voucher Stocks', 'voucher_stocks', ''),
(46, 4, 2, 'Sales', 1, 'Customer Expired', 'customer_expired', ''),
(47, 1, 3, 'Sales', 1, 'Cron Monitor', 'cron_monitor', ''),
(48, 2, 3, 'Sales', 1, 'Mikrotik Cron Monitor', 'mikrotik_cron_monitor', ''),
(49, 3, 3, 'Sales', 1, 'Info Payment Gateway', 'info_payment_gateway', ''),
(50, 4, 3, 'Sales', 1, 'Graph Customers Insight', 'graph_customers_insight', ''),
(51, 5, 3, 'Sales', 1, 'Activity Log', 'activity_log', ''),
(60, 1, 2, 'Customer', 1, 'Account Info', 'account_info', ''),
(61, 3, 1, 'Customer', 1, 'Active Internet Plan', 'active_internet_plan', ''),
(62, 4, 1, 'Customer', 1, 'Balance Transfer', 'balance_transfer', ''),
(63, 1, 1, 'Customer', 1, 'Unpaid Order', 'unpaid_order', ''),
(64, 2, 1, 'Customer', 1, 'Announcement', 'announcement', ''),
(66, 2, 2, 'Customer', 1, 'Voucher Activation', 'voucher_activation', '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `rad_acct`
--
ALTER TABLE `rad_acct`
  ADD PRIMARY KEY (`id`),
  ADD KEY `username` (`username`),
  ADD KEY `framedipaddress` (`framedipaddress`),
  ADD KEY `acctsessionid` (`acctsessionid`),
  ADD KEY `nasipaddress` (`nasipaddress`);

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

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

--
-- Indexes for table `tbl_coupons`
--
ALTER TABLE `tbl_coupons`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`);

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

--
-- Indexes for table `tbl_customers_fields`
--
ALTER TABLE `tbl_customers_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_id` (`customer_id`);

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

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

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

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

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

--
-- Indexes for table `tbl_odps`
--
ALTER TABLE `tbl_odps`
  ADD PRIMARY KEY (`id`) USING BTREE;

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `rad_acct`
--
ALTER TABLE `rad_acct`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_appconfig`
--
ALTER TABLE `tbl_appconfig`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=106;

--
-- AUTO_INCREMENT for table `tbl_bandwidth`
--
ALTER TABLE `tbl_bandwidth`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_coupons`
--
ALTER TABLE `tbl_coupons`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_customers`
--
ALTER TABLE `tbl_customers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;

--
-- AUTO_INCREMENT for table `tbl_customers_fields`
--
ALTER TABLE `tbl_customers_fields`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_customers_inbox`
--
ALTER TABLE `tbl_customers_inbox`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_logs`
--
ALTER TABLE `tbl_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=149;

--
-- AUTO_INCREMENT for table `tbl_manual_payments`
--
ALTER TABLE `tbl_manual_payments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_message_logs`
--
ALTER TABLE `tbl_message_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `tbl_meta`
--
ALTER TABLE `tbl_meta`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_odps`
--
ALTER TABLE `tbl_odps`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_payment_gateway`
--
ALTER TABLE `tbl_payment_gateway`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `tbl_plans`
--
ALTER TABLE `tbl_plans`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tbl_pool`
--
ALTER TABLE `tbl_pool`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_port_pool`
--
ALTER TABLE `tbl_port_pool`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_reseller_commissions`
--
ALTER TABLE `tbl_reseller_commissions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_routers`
--
ALTER TABLE `tbl_routers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_transactions`
--
ALTER TABLE `tbl_transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `tbl_users`
--
ALTER TABLE `tbl_users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_user_recharges`
--
ALTER TABLE `tbl_user_recharges`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `tbl_voucher`
--
ALTER TABLE `tbl_voucher`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_widgets`
--
ALTER TABLE `tbl_widgets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;
COMMIT;

