56,675
社区成员
发帖
与我相关
我的任务
分享
`id` int(11) NOT NULL auto_increment,
`uid` varchar(64) NOT NULL default "",
`chat_uid` varchar(64) NOT NULL default "",
`msg_num` int(11) NOT NULL default "0",
`s_gender` tinyint(3) NOT NULL default "-1",
`p_gender` tinyint(3) NOT NULL default "-1",
`s_age` tinyint(3) NOT NULL default "-1",
`p_age` tinyint(3) NOT NULL default "-1",
`role` tinyint(3) NOT NULL default "2",
`content` text NOT NULL default "",
`postdate` int(10) NOT NULL default "0",
`code` tinyint(3) NOT NULL default "2",
`ifread` tinyint(3) NOT NULL default "2",
`ifover` tinyint(3) NOT NULL default "2",
PRIMARY KEY(id),
KEY `idx_uid` (`uid`),
KEY `idx_chat_uid` (`chat_uid`),
KEY `idx_role` (`role`),
KEY `idx_s_gender` (`s_gender`),
KEY `idx_p_gender` (`p_gender`),
KEY `idx_s_age` (`s_age`),
KEY `idx_p_age` (`p_age`),
KEY `idx_ifread` (`ifread`)