56,678
社区成员
发帖
与我相关
我的任务
分享
-- 导出 表 fox.ut_mail 结构
CREATE TABLE IF NOT EXISTS `ut_mail` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`playerid` varbinary(20) NOT NULL,
`sendname` varchar(20) DEFAULT NULL,
`title` varchar(100) DEFAULT NULL,
`content` text,
`sendtime` datetime DEFAULT NULL,
`readit` smallint(6) NOT NULL DEFAULT '0',
`items` text,
PRIMARY KEY (`id`),
KEY `playerid` (`playerid`),
KEY `index0_name` (`sendname`)
) ENGINE=InnoDB AUTO_INCREMENT=4285 DEFAULT CHARSET=utf8;
-- 正在导出表 fox.ut_mail 的数据:~523 rows (大约)
/*!40000 ALTER TABLE `ut_mail` DISABLE KEYS */;
INSERT INTO `ut_mail` (`id`, `playerid`, `sendname`, `title`, `content`, `sendtime`, `readit`, `items`) VALUES
(3639, _binary 0x7864657667736E303030306D5132624939, 'system_mail', '888', '2013-12-10 10:15:10', 0, '{"zp":5588,"ex":5842,"jb":20000}'),
(4284, _binary 0x7864657667733730304730686334444944, 'system_mail', '888', '2014-01-09 10:04:21', 0, '{"zp":5588,"ex":5842,"jb":20000,"30800":1}');
/*!40000 ALTER TABLE `ut_mail` ENABLE KEYS */;