56,679
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE IF NOT EXISTS `mj_online_day` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT '0',
`online_time` int(11) NOT NULL DEFAULT '0' COMMENT '在线时长',
`login_times` int(11) NOT NULL DEFAULT '0' COMMENT '登录次数',
`lv` smallint(6) NOT NULL DEFAULT '0' COMMENT '当天角色等级',
`date` date NOT NULL DEFAULT '0000-00-00',
PRIMARY KEY (`id`),
KEY `cid` (`cid`),
KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='每天各个用户在线信息' AUTO_INCREMENT=86801 ;
--
-- 转存表中的数据 `mj_online_day`
--
INSERT INTO `mj_online_day` (`id`, `cid`, `online_time`, `login_times`, `lv`, `date`) VALUES
(86786, 10001, 279, 1, 40, '2013-02-22'),
(86774, 10025, 15842, 1, 20, '2013-02-24'),
(86784, 100142, 15206, 1, 18, '2013-02-22'),
(86764, 100141, 22616, 2, 18, '2013-02-22'),
(86798, 10014, 10571, 3, 18, '2013-02-22'),
(86777, 10028, 6347, 2, 16, '2013-02-24'),
(86762, 10252, 17435, 1, 12, '2013-04-06'),
(86775, 10026, 2371, 1, 10, '2013-02-24'),
(86699, 10217, 6032, 1, 10, '2013-04-06'),
(86800, 10024, 20, 1, 9, '2013-02-23'),
(86773, 10024, 6910, 1, 9, '2013-02-24'),
(86780, 10008, 1629, 1, 6, '2013-02-23'),
(86793, 10008, 9204, 2, 6, '2013-02-22'),
(86763, 10008, 5557, 2, 6, '2013-02-24'),
(86700, 10273, 482, 1, 5, '2013-04-06'),
(86781, 10009, 6013, 1, 5, '2013-02-23'),
(86696, 10009, 640, 12, 5, '2013-04-06'),
(86794, 10009, 39, 1, 5, '2013-02-22'),
(86785, 10016, 49156, 1, 4, '2013-02-23'),
(86778, 10029, 4315, 1, 4, '2013-02-24');