数据库加表
mysql变更格式
数据库:suqian
表名:honor_information
sql:
CREATE TABLE `honor_information` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`img_name` varchar(255) NOT NULL,
`img_path` varchar(255) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1代表有效2无效',
`add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `ix_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8