September 1, 2022 at 6:12 AM
All Rows - 152,000Links: warmup.net.pk | wiss.pkDate Dump - 01.09.2022Format files - SQL
SAMPLE
CREATE TABLE `area` (`area_id` int NOT NULL,`title` varchar(50) DEFAULT NULL,`status` int DEFAULT NULL,`zone_id` int DEFAULT NULL,`manager_id` int DEFAULT NULL,`total_houses` varchar(50) DEFAULT NULL,`staff_id` int DEFAULT NULL,`tech_staff` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,`recovery_staff` varchar(50) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1;CREATE TABLE `api_sms` (`api_id` int NOT NULL,`api_key_variable` varchar(50) DEFAULT NULL,`api_key` varchar(300) DEFAULT NULL,`api_mask_variable` varchar(50) DEFAULT NULL,`api_mask` varchar(20) DEFAULT NULL,`api_secret_variable` varchar(50) DEFAULT NULL,`api_secret` varchar(400) DEFAULT NULL,`api_url` text,`api_message_variable` varchar(50) DEFAULT NULL,`api_mobile_variable` varchar(50) DEFAULT NULL,`api_status` int DEFAULT NULL,`api_successfull` varchar(150) DEFAULT NULL,`cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,`manager_id` int DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;CREATE TABLE `city` (`city_id` int NOT NULL,`title` varchar(50) DEFAULT NULL,`status` int DEFAULT NULL,`country_id` int DEFAULT NULL,`manager_id` int DEFAULT NULL,`total_houses` varchar(50) DEFAULT NULL)CREATE TABLE `community` (`id` int NOT NULL,`name` text NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1;INSERT INTO `radacct` (`radacctid`, `acctsessionid`, `acctuniqueid`, `username`, `realm`, `nasipaddress`, `nasportid`, `nasporttype`, `acctstarttime`, `acctupdatetime`, `acctstoptime`, `acctinterval`, `acctsessiontime`, `acctauthentic`, `connectinfo_start`, `connectinfo_stop`, `acctinputoctets`, `acctoutputoctets`, `calledstationid`, `callingstationid`, `acctterminatecause`, `servicetype`, `framedprotocol`, `framedipaddress`, `framedipv6address`, `framedipv6prefix`, `framedinterfaceid`, `delegatedipv6prefix`) VALUES(276474, '81c0002f', '61be7abf2f55f44ec1cc1810abb199cd', 'wiss_asadj', '', '202.69.62.26', 'Bani-Tower', 'Ethernet', '2022-07-08 15:02:35', '2022-07-09 10:26:11', '2022-07-09 10:27:56', 120, 2986, 'RADIUS', '', '', 28762319, 371371251, 'service1', 'C8:3A:35:50:C3:50', 'NAS-Request', 'Framed-User', 'PPP', '80.80.80.251', '', '', '', ''),(276475, '81c00031', '70c2c1d30b13e397b9a202b7866d91e1', 'wiss_zamanj', '', '202.69.62.26', 'Bani-Tower', 'Ethernet', '2022-07-08 15:02:35', '2022-07-09 10:26:11', '2022-07-09 10:27:57', 120, 2986, 'RADIUS', '', '', 6487353, 80297218, 'service1', '04:95:E6:D1:2B:88', 'NAS-Request', 'Framed-User', 'PPP', '60.60.60.250', '', '', '', ''),(276476, '81c00032', '00b07aafde3dfce4c215a65dfdf73c43', 'wiss_islam', '', '202.69.62.26', 'Bani-Tower', 'Ethernet', '2022-07-08 15:02:35', '2022-07-09 10:26:11', '2022-07-09 10:27:57', 120, 2986, 'RADIUS', '', '', 37303024, 576617355, 'service1', '14:4D:67:A5:3F:31', 'NAS-Request', 'Framed-User', 'PPP', '60.60.60.251', '', '', '', ''),(276477, '81c0002e', 'b972bd477e02863b08b6cde456bae5b7', 'wiss_adilbutt', '', '202.69.62.26', 'lan', 'Ethernet', '2022-07-08 15:02:35', '2022-07-09 10:26:11', '2022-07-09 10:27:56', 120, 2986, 'RADIUS', '', '', 1854671, 14082586, 'service4', 'C0:A5:DD:07:0E:E9', 'NAS-Request', 'Framed-User', 'PPP', '60.60.60.249', '', '', '', ''),(276478, '81c0002b', '4a0a0fb7c35b6a9a8402462bcb17a9e5', 'wiss_zarakj', '', '202.69.62.26', 'Bani-Tower', 'Ethernet', '2022-07-08 15:02:35', '2022-07-09 10:26:11', '2022-07-09 10:27:55', 120, 2985, 'RADIUS', '', '', 19457089, 367814056, 'service1', 'CC:2D:21:D2:FB:50', 'NAS-Request', 'Framed-User', 'PPP', '60.60.60.247', '', '', '', ''),(276479, '81c0002c', '08e67fd03ae32059ebcdd6ad9952e77a', 'wiss_tanzam', '', '202.69.62.26', 'olt-0ut', 'Ethernet', '2022-07-08 15:02:35', '2022-07-09 10:26:11', '2022-07-09 10:27:56', 120, 2986, 'RADIUS', '', '', 12920992, 208398918, 'service3', 'C8:E7:D8:9C:6F:95', 'NAS-Request', 'Framed-User', 'PPP', '60.60.60.248', '', '', '', ''),(276480, '81c00030', '3fb00fc24940d2eb017e808d85aaf642', 'wiss_zubairj', '', '202.69.62.26', 'Bani-Tower', 'Ethernet', '2022-07-08 15:02:35', '2022-07-09 10:26:11', '2022-07-09 10:27:57', 120, 2986, 'RADIUS', '', '', 8695010, 133616565, 'service1', '04:95:E6:79:53:C8', 'NAS-Request', 'Framed-User', 'PPP', '40.40.40.246', '', '', '', ''),(276481, '81c0002d', 'f3c39c732cef4a7ebdea9b7ee0580b5c', 'wiss_muneeb', '', '202.69.62.26', 'olt-0ut', 'Ethernet', '2022-07-08 15:02:35', '2022-07-09 10:26:11', '2022-07-09 10:27:55', 120, 2985, 'RADIUS', '', '', 4027363, 60715797, 'service3', 'C0:A5:DD:06:B2:05', 'NAS-Request', 'Framed-User', 'PPP', '60.60.60.246', '', '', '', ''),(276482, '81c00033', '34f7a31423abdddb94b165c51a8e4db2', 'wiss_sajjad', '', '202.69.62.26', 'olt-0ut', 'Ethernet', '2022-07-08 15:02:35', '2022-07-09 10:26:11', '2022-07-09 10:27:58', 120, 2987, 'RADIUS', '', '', 28469141, 409920444, 'service3', 'D8:32:14:12:DB:80', 'NAS-Request', 'Framed-User', 'PPP', '40.40.40.245', '', '', '', ''),(276489, '81c00043', '480d831a3793d6d56f8ac5709b3fa36c', 'wiss_shahbaz1', '', '202.69.62.26', 'olt-0ut', 'Ethernet', '2022-07-08 15:02:37', '2022-07-09 10:26:13', '2022-07-09 10:27:55', 120, 2983, 'RADIUS', '', '', 52220418, 608263326, 'service3', 'C8:3A:35:1C:C8:88', 'NAS-Request', 'Framed-User', 'PPP', '30.30.30.252', '', '', '', ''),(276490, '81c00042', '32833465e80035b9f32184836ec61983', 'sk_islam', '', '202.69.62.26', 'Bani-Tower', 'Ethernet', '2022-07-08 15:02:37', '2022-07-09 10:26:13', '2022-07-09 10:27:55', 120, 2983, 'RADIUS', '', '', 9707337, 209534383, 'service1', 'B4:0F:3B:C0:B2:90', 'NAS-Request', 'Framed-User', 'PPP', '80.80.80.250', '', '', '', ''),(276491, '81c00041', '12eba852fce395eb98d310ca6dc40b9b', 'wiss_akbar', '', '202.69.62.26', 'lan', 'Ethernet', '2022-07-08 15:02:37', '2022-07-09 10:26:13', '2022-07-09 10:27:58', 120, 2986, 'RADIUS', '', '', 10370946, 92727284, 'service4', 'C8:3A:35:1B:66:10', 'NAS-Request', 'Framed-User', 'PPP', '20.20.10.252', '', '', '', ''),(276492, '81c00045', '5492e5d5057a841a63751beb68de6b27', 'wiss_mehboobj', '', '202.69.62.26', 'Bani-Tower', 'Ethernet', '2022-07-08 15:02:37', '2022-07-09 10:26:13', '2022-07-09 10:27:57', 120, 2983, 'RADIUS', '', '', 57034, 56686, 'service1', '58:D9:D5:0D:B8:D0', 'NAS-Request', 'Framed-User', 'PPP', '30.30.30.251', '', '', '', ''),(276493, '81c00044', 'de9e44806be683eb4e402f7c256c9fa1', 'wiss_ahtsham', '', '202.69.62.26', 'Bani-Tower', 'Ethernet', '2022-07-08 15:02:37', '2022-07-09 10:26:13', '2022-07-09 10:27:55', 120, 2982, 'RADIUS', '', '', 107212595, 847946231, 'service1', 'C8:3A:35:19:B4:18', 'NAS-Request', 'Framed-User', 'PPP', '15.15.15.254', '', '', '', ''),(276494, '81c00046', 'c9189d0fe74177c1bff6b031cb81c422', 'wiss_zubair', '', '202.69.62.26', 'Bani-Tower', 'Ethernet', '2022-07-08 15:02:37', '2022-07-09 10:26:13', '2022-07-09 10:27:57', 120, 2983, 'RADIUS', '', '', 37153030, 353707276, 'service1', '38:6B:1C:7F:31:D3', 'NAS-Request', 'Framed-User', 'PPP', '80.80.80.249', '', '', '', ''),(276498, '81c00052', '06dc8ea57b23dd9c22df1ee99a440e26', 'wiss_shafiquej', '', '202.69.62.26', 'Bani-Tower', 'Ethernet', '2022-07-08 15:02:39', '2022-07-09 10:26:15', '2022-07-09 10:27:58', 120, 2984, 'RADIUS', '', '', 80775865, 273072423, 'service1', '50:0F:F5:D4:B8:58', 'NAS-Request', 'Framed-User', 'PPP', '40.40.40.243', '', '', '', ''),(276499, '81c00053', '302fc5ba002c9f0f66d4c913221e988a', 'wiss_sarwarq', '', '202.69.62.26', 'Bani-Tower', 'Ethernet', '2022-07-08 15:02:39', '2022-07-09 10:26:15', '2022-07-09 10:27:58', 120, 2984, 'RADIUS', '', '', 631037, 4189427, 'service1', '50:0F:F5:6A:7A:A8', 'NAS-Request', 'Framed-User', 'PPP', '10.10.10.254', '', '', '', ''),(276500, '81c00050', '9268a3d7cdd9dcc97f98bfe6afb63acb', 'wiss_arslanj', '', '202.69.62.26', 'Bani-Tower', 'Ethernet', '2022-07-08 15:02:39', '2022-07-09 10:26:15', '2022-07-09 10:27:59', 120, 2985, 'RADIUS', '', '', 9761349, 211133505, 'service1', 'F4:F2:6D:FD:D2:85', 'NAS-Request', 'Framed-User', 'PPP', '60.60.60.245', '', '', '', ''),(276501, '81c00054', '964b7f57b74e261fcfc36d69f63948ba', 'wiss_naeemj', '', '202.69.62.26', 'Bani-Tower', 'Ethernet', '2022-07-08 15:02:39', '2022-07-09 10:26:15', '2022-07-09 10:27:58', 120, 2984, 'RADIUS', '', '', 90547182, 340162952, 'service1', 'C8:3A:35:24:71:A8', 'NAS-Request', 'Framed-User', 'PPP', '40.40.40.242', '', '', '', ''),(276502, '81c00055', 'c9a3df74f704d56275d7138aae9a9001', 'wiss_abdullahj', '', '202.69.62.26', 'Bani-Tower', 'Ethernet', '2022-07-08 15:02:39', '2022-07-09 10:26:15', '2022-07-09 10:27:59', 120, 2984, 'RADIUS', '', '', 43994605, 625127588, 'service1', 'C8:3A:35:18:E1:28', 'NAS-Request', 'Framed-User', 'PPP', '40.40.40.244', '', '', '', ''),(276503, '81c0004f', 'b5a4834bfeea5a4ff12c579c69391450', 'fiber_sohaib', '', '202.69.62.26', 'olt-0ut', 'Ethernet', '2022-07-08 15:02:39', '2022-07-09 10:26:15', '2022-07-09 10:27:58', 120, 2984, 'RADIUS', '', '', 25173349, 591358182, 'service3', '4C:B1:6C:B9:24:4D', 'NAS-Request', 'Framed-User', 'PPP', '60.60.60.244', '', '', '', ''),(276504, '81c00051', '8b09fb3bee19a0a9d986b30197b7de9f', 'wiss_haqnawazj', '', '202.69.62.26', 'Bani-Tower', 'Ethernet', '2022-07-08 15:02:39', '2022-07-09 10:26:15', '2022-07-09 10:27:55', 120, 2981, 'RADIUS', '', '', 77842690, 265153938, 'service1', '38:6B:1C:21:10:9B', 'NAS-Request', 'Framed-User', 'PPP', '80.80.80.247', '', '', '', ''),(276508, '81c0005c', 'f9434d7e85a82739215614df3781417e', 'fiber_safeerm', '', '202.69.62.26', 'olt-0ut', 'Ethernet', '2022-07-08 15:02:40', '2022-07-09 10:26:16', '2022-07-09 10:27:59', 120, 2984, 'RADIUS', '', '', 38595945, 360409732, 'service3', '78:1D:BA:F9:34:47', 'NAS-Request', 'Framed-User', 'PPP', '60.60.60.242', '', '', '', ''),(276509, '81c0005d', '7bbf71a43d0c5df47fa821e0e5581512', 'wiss_mohsinj', '', '202.69.62.26', 'Bani-Tower', 'Ethernet', '2022-07-08 15:02:40', '2022-07-09 10:26:16', '2022-07-09 10:27:59', 120, 2984, 'RADIUS', '', '', 47997176, 687955839, 'service1', 'C8:3A:35:77:3E:A3', 'NAS-Request', 'Framed-User', 'PPP', '60.60.60.241', '', '', '', ''),(27


