56,679
社区成员
发帖
与我相关
我的任务
分享
/*Table structure for table `tbl_mail` */
DROP TABLE IF EXISTS `tbl_mail`;
CREATE TABLE `tbl_mail` (
`MailID` INT(64) NOT NULL COMMENT '邮件ID',
`UserID` INT(64) NOT NULL COMMENT '用户ID',
`ActorID` INT(32) NOT NULL COMMENT '角色ID',
`MailItemID` INT(32) COMMENT '邮件模板ID',
`MailType` TINYINT(1) NOT NULL COMMENT '邮件类型',
`MailTitle` VARCHAR(64) NOT NULL COMMENT '邮件标题',
`MailBody` VARCHAR(512) NOT NULL COMMENT '邮件内容',
`SendActorID` INT(32) COMMENT '发送玩家ID',
`SendActorName` VARCHAR(32) COMMENT '发送玩家名字',
`SendTime` DATETIME NOT NULL COMMENT '创建时间',
PRIMARY KEY (`MailID`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;
/*Table structure for table `tbl_mailgoods` */
DROP TABLE IF EXISTS `tbl_mailgoods`;
CREATE TABLE `tbl_mailgoods` (
`MailID` INT(64) NOT NULL COMMENT '邮件ID',
`UserID` INT(64) NOT NULL COMMENT '用户ID',
`ActorID` INT(32) NOT NULL COMMENT '角色ID',
`GoodsID` INT(32) NOT NULL COMMENT '物品ID',
`GoodsType` TINYINT(1) NOT NULL COMMENT '物品类型',
`Num` INT(32) NOT NULL COMMENT '物品数量',
PRIMARY KEY (`MailID`, `GoodsID`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;