Closed firehalt closed 6 months ago
描述 提交sql上线的时候,提示表的例里面内容不能为空,其实我们业务上设计是可以的
重现 CREATE TABLE bi_forecasting_rr ( id bigint NOT NULL AUTO_INCREMENT COMMENT 'id', vc_code varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'vc账号编码', asin varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品唯一标识', product_title varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品名称', brand varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '品牌', upc varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品条形码upc', ean varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品条形码ean', data_date bigint DEFAULT NULL COMMENT '报表数据时间', created_at bigint DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (id), KEY product_title (product_title) USING BTREE, KEY brand (brand) USING BTREE, KEY upc (upc) USING BTREE, KEY ean (ean) USING BTREE, KEY asin (asin,vc_code) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='BI预测报表';
bi_forecasting_rr
id
vc_code
asin
product_title
brand
upc
ean
data_date
created_at
环境
错误
描述 提交sql上线的时候,提示表的例里面内容不能为空,其实我们业务上设计是可以的
重现 CREATE TABLE
bi_forecasting_rr
(id
bigint NOT NULL AUTO_INCREMENT COMMENT 'id',vc_code
varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'vc账号编码',asin
varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品唯一标识',product_title
varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品名称',brand
varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '品牌',upc
varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品条形码upc',ean
varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品条形码ean',data_date
bigint DEFAULT NULL COMMENT '报表数据时间',created_at
bigint DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (id
), KEYproduct_title
(product_title
) USING BTREE, KEYbrand
(brand
) USING BTREE, KEYupc
(upc
) USING BTREE, KEYean
(ean
) USING BTREE, KEYasin
(asin
,vc_code
) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='BI预测报表';环境
错误