mysql变更格式
数据库：ucs
表名：tb_province_credit_business
sql：
CREATE TABLE `tb_province_credit_business` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`company_name` varchar(255) NOT NULL,
`company_name_digest` varchar(32) NOT NULL,
`province` varchar(32) NOT NULL,
`add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `ix_company_name_digest` (`company_name_digest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
