数据库加表
mysql变更格式
数据库:ucs
表名:tb_credit_circle_subject
sql:
CREATE TABLE `tb_credit_circle_subject` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`company_name_digest` varchar(32) NOT NULL,
`company_name` varchar(255) NOT NULL,
`platform_name` varchar(255) NOT NULL,
`credit_circle_number` int(11) NOT NULL DEFAULT '0',
`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`) USING BTREE,
KEY `ix_credit_circle_number` (`credit_circle_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8