mysql变更格式
数据库:wiki
表名:tb_medical_history
CREATE TABLE `tb_medical_history` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`company_name_digest` varchar(32) NOT NULL,
`content` varchar(20000) NOT NULL,
`status` smallint(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 `company_name_digest` (`company_name_digest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8