-- 2021-03-24
-- 代php提交后台GM邮件记录表更新
DROP TABLE IF EXISTS `log_gm_mail`;
CREATE TABLE `log_gm_mail` (
  `mid` int(11) NOT NULL AUTO_INCREMENT,
  `id` int(11) NOT NULL,
  `accid` int(11) NOT NULL,
  `accname` varchar(50) NOT NULL,
  `last_login_time` int(10) NOT NULL,
  `server_id` int(11) NOT NULL,
  `nickname` varchar(2000) NOT NULL COMMENT '昵称',
  `title` varchar(512) NOT NULL,
  `content` varchar(1024) NOT NULL,
  `goods_id` int(11) NOT NULL,
  `goods_num` int(11) NOT NULL,
  `bcoin` int(11) NOT NULL,
  `coin` int(11) NOT NULL,
  `silver` int(11) NOT NULL,
  `gold` int(11) NOT NULL,
  `admin_name` varchar(50) NOT NULL,
  `ctime` int(11) NOT NULL,
  `stren` int(11) NOT NULL,
  `prefix` int(11) NOT NULL,
  `realname` varchar(50) NOT NULL,
  `minlv` int(11) NOT NULL,
  `maxlv` int(11) NOT NULL,
  `role_gold` int(11) NOT NULL,
  `pass_admin_name` varchar(50) NOT NULL,
  `special_attachment` varchar(1000) DEFAULT '[]' COMMENT '附件',
  `minvip` int(5) DEFAULT NULL,
  `maxvip` int(5) DEFAULT NULL,
  `days` int(5) NOT NULL,
  `res` text,
  PRIMARY KEY (`mid`),
  KEY `nickname` (`nickname`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT="后台GM邮件记录";