建表sql

CREATE TABLE credit_manage_rule ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT ‘条例名称’, value int(11) DEFAULT NULL COMMENT ‘值’, start_date date DEFAULT NULL COMMENT ‘开始时间’, end_date date DEFAULT NULL COMMENT ‘结束时间’, period varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT ‘周期(年:year)’, status tinyint(4) NOT NULL DEFAULT ‘1’ COMMENT ‘状态’, description varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT ‘描述’, create_time datetime DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’, create_by bigint(20) DEFAULT NULL COMMENT ‘创建人’, update_time datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘更新时间’, update_by bigint(20) DEFAULT NULL COMMENT ‘修改人’, del tinyint(4) NOT NULL DEFAULT ‘0’ COMMENT ‘删除标识’, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT=‘信用管理条例表’;