wujunqi
1/21/2018 - 9:24 AM

[createSqlTable] 创建数据库表语句 #mysql命令

[createSqlTable] 创建数据库表语句 #mysql命令

CREATE TABLE `movie_group_month_report` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`month` char(7) NOT NULL DEFAULT '0000-00' COMMENT '发布年月',
`cover` varchar(255) NOT NULL COMMENT '封面',
`recommend_films` text NOT NULL COMMENT '推荐电影',
`recommend_critics` text NOT NULL COMMENT '推荐影评人',
`share_content` varchar(500) NOT NULL COMMENT '分享文案',
`status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否发布',
`alter_user` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '修改者',
`create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_month` (`month`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='点评团月度报告'