📄 initial.sql
字号:
('15950596760', '15950596569', '主叫', '本地', '2008-12-21 17:58:40', '00:00:45'),
('15950596760', '15950596569', '主叫', '本地', '2008-12-21 18:10:39', '00:00:33'),
('15950596760', '15950596569', '主叫', '本地', '2008-12-21 22:32:21', '00:01:01'),
('15950596760', '15950596569', '主叫', '本地', '2008-12-22 13:13:04', '00:01:40'),
('15950596760', '15950596569', '主叫', '本地', '2008-12-22 13:31:31', '00:00:38'),
('15950596760', '15950596569', '被叫', '本地', '2008-12-24 15:20:13', '00:01:04'),
('15950596760', '15950596569', '主叫', '本地', '2008-12-24 17:26:48', '00:00:58'),
('15950596760', '15950596569', '被叫', '本地', '2008-12-25 16:49:18', '00:00:32'),
('15950596760', '15950596569', '主叫', '本地', '2008-12-26 22:04:25', '00:02:15'),
('15950596760', '15950596569', '被叫', '本地', '2008-12-26 22:36:09', '00:02:12'),
('15950596760', '15950596569', '主叫', '本地', '2008-12-28 16:03:23', '00:02:19'),
('15950596760', '15951708679', '被叫', '本地', '2008-12-28 17:03:00', '00:01:28'),
('15950596760', '13705191452', '主叫', '本地', '2008-12-28 17:05:00', '00:02:06'),
('15950596760', '15950596717', '被叫', '本地', '2008-12-29 17:24:02', '00:00:43');
/* Data for the `chargeingcard` table (Records 1 - 61) */
INSERT INTO `mobile`.`chargeingcard` (`CARDNUM`, `CARDCODE`, `MONEY`) VALUES
('', '', NULL),
('1839754937222587', '123460', 30),
('1839754937222588', '123461', 30),
('1839754937222589', '123462', 30),
('1839754937222590', '123463', 30),
('1839754937222591', '123464', 30),
('1839754937222592', '123465', 30),
('1839754937222593', '123466', 30),
('1839754937222594', '123467', 30),
('1839754937222595', '123468', 30),
('1839754937222596', '123469', 30),
('1839754937222597', '123470', 30),
('1839754937222598', '123471', 30),
('1839754937222599', '123472', 30),
('1839754937222600', '123473', 30),
('1839754937222601', '123474', 30),
('1839754937222602', '123475', 30),
('1839754937222603', '123476', 30),
('1839754937222604', '123477', 30),
('1839754937222605', '123478', 30),
('1839754937222606', '123479', 30),
('1839754937222607', '123480', 30),
('1839754937222608', '123481', 30),
('1839754937222609', '123482', 30),
('1839754937222610', '123483', 30),
('1839754937222611', '123484', 30),
('1839754937222612', '123485', 30),
('1839754937222613', '123486', 30),
('1839754937222614', '123487', 50),
('1839754937222615', '123488', 50),
('1839754937222616', '123489', 50),
('1839754937222617', '123490', 50),
('1839754937222618', '123491', 50),
('1839754937222619', '123492', 50),
('1839754937222620', '123493', 50),
('1839754937222621', '123494', 50),
('1839754937222622', '123495', 50),
('1839754937222623', '123496', 50),
('1839754937222624', '123497', 50),
('1839754937222625', '123498', 50),
('1839754937222626', '123499', 50),
('1839754937222627', '123500', 50),
('1839754937222628', '123501', 50),
('1839754937222629', '123502', 50),
('1839754937222630', '123503', 50),
('1839754937222631', '123504', 50),
('1839754937222632', '123505', 50),
('1839754937222633', '123506', 50),
('1839754937222634', '123507', 50),
('1839754937222635', '123508', 50),
('1839754937222636', '123509', 50),
('1839754937222637', '123510', 50),
('1839754937222638', '123511', 50),
('1839754937222639', '123512', 50),
('1839754937222640', '123513', 50),
('1839754937222641', '123514', 50),
('1839754937222642', '123515', 50),
('1839754937222643', '123516', 50),
('1839754937222644', '123517', 50),
('1839754937222645', '123518', 50),
('1839754937222646', '123519', 50);
/* Data for the `clerk` table (Records 1 - 1) */
INSERT INTO `mobile`.`clerk` (`KNO`, `KCODE`, `KNAME`, `KSEX`, `WTIME`, `AREANO`, `KPHO`, `GRADE`) VALUES
('1005', 'ffff', '吴立', '男', '2008-12-25 20:26:37', 11, '15923814321', 0);
/* Data for the `clien` table (Records 1 - 3) */
INSERT INTO `mobile`.`clien` (`TNO`, `TCODE`, `TNAME`, `TSEX`, `TIDNO`, `TEMAIL`, `TADD`, `AREANO`, `REGTIME`) VALUES
('15912398618', '1111', '网名', '男', '123456789012345678', 'fk@12.cm', '就挖了', 11, '2008-12-25 20:11:38'),
('15950596760', '222', '方超', '男', '320121198710011111', 'daqing@gmail.com', '南京大学', 25, '2006-12-16 13:10:30'),
('15988880001', '11', '陶比', '男', '32025252525252525', 'taobi@nju.edu.cn', '上述', 11, '2008-12-25 22:11:35');
/* Data for the `countinfo` table (Records 1 - 1) */
INSERT INTO `mobile`.`countinfo` (`TNO`, `MONEY`, `FREECALL`, `FREEMES`, `FREEGPRS`, `AVAILABLETIME`) VALUES
('15950596760', 123210, 90, 80, 1000, '2008-12-30');
/* Data for the `gprs` table (Records 1 - 500) */
INSERT INTO `mobile`.`gprs` (`TNO`, `TIME1`, `BYTES`) VALUES
('15950596760', '2009-01-01 11:34:52', 48494),
('15950596760', '2009-01-01 11:40:23', 43169),
('15950596760', '2009-01-01 13:30:05', 37525),
('15950596760', '2009-01-01 17:50:47', 13028),
('15950596760', '2009-01-02 08:51:33', 88187),
('15950596760', '2009-01-02 09:29:07', 20248),
('15950596760', '2009-01-02 09:34:05', 11908),
('15950596760', '2009-01-02 09:40:13', 9956),
('15950596760', '2009-01-02 10:26:07', 41419),
('15950596760', '2009-01-02 11:05:34', 12121),
('15950596760', '2009-01-02 11:18:30', 176596),
('15950596760', '2009-01-02 12:14:39', 32084),
('15950596760', '2009-01-03 00:22:15', 448215),
('15950596760', '2009-01-03 08:55:40', 140187),
('15950596760', '2009-01-03 09:37:48', 95199),
('15950596760', '2009-01-03 12:39:16', 42289),
('15950596760', '2009-01-03 14:41:59', 70640),
('15950596760', '2009-01-04 00:29:58', 825562),
('15950596760', '2009-01-04 08:00:54', 36965),
('15950596760', '2009-01-04 13:38:18', 90460),
('15950596760', '2009-01-04 13:51:57', 664994),
('15950596760', '2009-01-05 00:36:55', 286589),
('15950596760', '2009-01-05 01:07:50', 245538),
('15950596760', '2009-01-05 01:32:05', 43140),
('15950596760', '2009-01-05 13:16:22', 98929),
('15950596760', '2009-01-05 13:35:07', 294637),
('15950596760', '2009-01-05 13:49:18', 291870),
('15950596760', '2009-01-05 14:00:08', 16069),
('15950596760', '2009-01-06 00:34:37', 875584),
('15950596760', '2009-01-06 01:05:56', 694255),
('15950596760', '2009-01-06 10:15:19', 388917),
('15950596760', '2009-01-06 11:36:49', 46434),
('15950596760', '2009-01-07 00:48:56', 15291),
('15950596760', '2009-01-07 00:50:42', 1337976),
('15950596760', '2009-01-07 10:42:27', 28319),
('15950596760', '2009-01-07 17:16:55', 46273),
('15950596760', '2009-01-08 01:53:27', 1359426),
('15950596760', '2009-01-08 18:06:01', 125441),
('15950596760', '2009-01-09 01:08:12', 401354),
('15950596760', '2009-01-09 01:27:38', 1806500),
('15950596760', '2009-01-09 13:59:54', 76163),
('15950596760', '2009-01-09 18:03:48', 16694),
('15950596760', '2009-01-10 00:32:39', 1368707),
('15950596760', '2009-01-10 01:25:10', 314258),
('15950596760', '2009-01-10 08:07:33', 76650),
('15950596760', '2009-01-10 09:03:54', 16408),
('15950596760', '2009-01-10 09:50:53', 23913),
('15950596760', '2009-01-10 11:03:42', 229636),
('15950596760', '2009-01-10 12:03:18', 51694),
('15950596760', '2009-01-10 12:55:51', 7544),
('15950596760', '2009-01-10 16:06:16', 33487),
('15950596760', '2009-01-11 00:26:36', 224466),
('15950596760', '2009-01-11 09:36:13', 46490),
('15950596760', '2009-01-11 09:45:47', 12079),
('15950596760', '2009-01-11 09:59:27', 112292),
('15950596760', '2009-01-11 16:24:54', 131012),
('15950596760', '2009-01-12 11:01:20', 20869),
('15950596760', '2009-01-12 17:52:34', 17242),
('15950596760', '2009-01-12 18:01:37', 19219),
('15950596760', '2009-01-13 02:08:47', 334493),
('15950596760', '2009-01-13 17:43:52', 89228),
('15950596760', '2009-01-13 17:51:45', 50623),
('15950596760', '2009-01-14 00:12:38', 227537),
('15950596760', '2009-01-14 00:36:00', 47657),
('15950596760', '2009-01-14 00:42:01', 69807),
('15950596760', '2009-01-14 08:05:52', 280023),
('15950596760', '2009-01-14 10:09:46', 17845),
('15950596760', '2009-01-14 11:21:10', 147986),
('15950596760', '2009-01-14 13:33:57', 115535),
('15950596760', '2009-01-15 02:12:04', 609125),
('15950596760', '2009-01-15 10:33:44', 20883),
('15950596760', '2009-01-15 10:37:19', 51330),
('15950596760', '2009-01-15 11:32:02', 42493),
('15950596760', '2009-01-15 11:43:34', 40787),
('15950596760', '2009-01-15 11:53:36', 6261),
('15950596760', '2009-01-16 10:18:52', 17756),
('15950596760', '2009-01-16 18:19:05', 92510),
('15950596760', '2009-01-17 00:53:37', 1255484),
('15950596760', '2009-01-17 09:49:11', 117707),
('15950596760', '2009-01-17 12:37:10', 34016),
('15950596760', '2009-01-17 12:42:45', 50100),
('15950596760', '2009-01-18 01:00:26', 42271),
('15950596760', '2009-01-18 09:57:11', 20905),
('15950596760', '2009-01-18 10:35:53', 40699),
('15950596760', '2009-01-18 10:43:54', 270870),
('15950596760', '2009-01-18 11:41:29', 114239),
('15950596760', '2009-01-18 11:57:23', 33677),
('15950596760', '2009-01-18 12:08:45', 51418),
('15950596760', '2009-01-18 13:42:19', 112543),
('15950596760', '2009-01-18 15:13:09', 29887),
('15950596760', '2009-01-19 00:51:22', 36722),
('15950596760', '2009-01-19 01:11:54', 398124),
('15950596760', '2009-01-19 01:26:39', 20280),
('15950596760', '2009-01-19 10:27:43', 18415),
('15950596760', '2009-01-19 10:35:25', 209834),
('15950596760', '2009-01-19 11:06:15', 35977),
('15950596760', '2009-01-19 11:12:20', 160137),
('15950596760', '2009-01-19 11:23:41', 47526),
('15950596760', '2009-01-19 17:30:16', 76853),
('15950596760', '2009-01-20 01:38:08', 44278),
('15950596760', '2009-01-20 01:41:15', 123123),
('15950596760', '2009-01-20 01:41:50', 12295),
('15950596760', '2009-01-20 01:43:35', 19366),
('15950596760', '2009-01-20 01:46:45', 48617),
('15950596760', '2009-01-20 01:50:38', 67381),
('15950596760', '2009-01-20 01:54:06', 173631),
('15950596760', '2009-01-20 01:57:43', 94064),
('15950596760', '2009-01-20 02:04:03', 17285),
('15950596760', '2009-01-20 10:18:52', 15850),
('15950596760', '2009-01-20 10:42:51', 42939),
('15950596760', '2009-01-20 11:02:50', 41120),
('15950596760', '2009-01-20 11:23:03', 7677),
('15950596760', '2009-01-21 00:05:10', 48350),
('15950596760', '2009-01-21 00:14:09', 976809),
('15950596760', '2009-01-21 07:53:12', 17306),
('15950596760', '2009-01-21 09:01:27', 36667),
('15950596760', '2009-01-21 09:07:47', 36851),
('15950596760', '2009-01-21 12:45:10', 47655),
('15950596760', '2009-01-22 00:18:25', 18774),
('15950596760', '2009-01-22 10:38:32', 58031),
('15950596760', '2009-01-22 13:44:06', 20972),
('15950596760', '2009-01-22 22:33:35', 162422),
('15950596760', '2009-01-23 02:02:06', 84832),
('15950596760', '2009-01-23 10:37:58', 128385),
('15950596760', '2009-01-23 10:53:34', 65152),
('15950596760', '2009-01-23 18:05:09', 73321),
('15950596760', '2009-01-24 01:02:57', 43173),
('15950596760', '2009-01-24 01:08:52', 57999),
('15950596760', '2009-01-24 01:15:50', 1120722),
('15950596760', '2009-01-24 08:04:37', 33704),
('15950596760', '2009-01-24 08:08:50', 19560),
('15950596760', '2009-01-24 09:25:56', 144273),
('15950596760', '2009-01-24 10:12:33', 26425),
('15950596760', '2009-01-24 13:19:20', 57420),
('15950596760', '2009-01-25 08:58:37', 32250),
('15950596760', '2009-01-25 09:59:12', 7636),
('15950596760', '2009-01-25 10:12:10', 196916),
('15950596760', '2009-01-25 11:13:53', 10212),
('15950596760', '2009-01-25 11:17:58', 43558),
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -