LJH_Shop/niucloud/addon/mall/app/upgrade/v003/upgrade.sql

CREATE TABLE `mall_goods_browse`  (
                                         `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
                                         `site_id` int NOT NULL DEFAULT 0,
                                         `member_id` int NOT NULL DEFAULT 0 COMMENT '浏览人',
                                         `sku_id` int NOT NULL DEFAULT 0 COMMENT 'sku_id',
                                         `goods_id` int NOT NULL DEFAULT 0 COMMENT '商品id',
                                         `browse_time` int NOT NULL DEFAULT 0 COMMENT '浏览时间',
                                         `goods_cover` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品图片',
                                         `goods_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品名称',
                                         PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品浏览历史' ROW_FORMAT = Dynamic;

ALTER TABLE `mall_invoice` MODIFY COLUMN `header_name` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称（发票抬头）' AFTER `header_type`;

ALTER TABLE `mall_invoice` MODIFY COLUMN `name` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发票内容' AFTER `type`;

ALTER TABLE `mall_invoice` MODIFY COLUMN `address` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '注册地址' AFTER `telephone`;

ALTER TABLE `mall_invoice` MODIFY COLUMN `bank_name` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '开户银行' AFTER `address`;

ALTER TABLE `mall_invoice` MODIFY COLUMN `bank_card_number` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '银行账号' AFTER `bank_name`;

ALTER TABLE `mall_invoice` MODIFY COLUMN `remark` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注' AFTER `invoice_voucher`;

CREATE TABLE `mall_order_batch_delivery`  (
                                                 `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
                                                 `site_id` int NOT NULL DEFAULT 0 COMMENT '站点id',
                                                 `main_id` int NOT NULL DEFAULT 0 COMMENT '操作人id',
                                                 `status` int NOT NULL DEFAULT 1 COMMENT '状态 进行中  已完成  已失败',
                                                 `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '操作类型 批量发货  批量打单 ....' COMMENT '操作类型',
                                                 `total_num` int NOT NULL DEFAULT 0 COMMENT '总发货单数',
                                                 `success_num` int NOT NULL DEFAULT 0 COMMENT '成功发货单数',
                                                 `fail_num` int NOT NULL DEFAULT 0 COMMENT '失败发货单数',
                                                 `data` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '导入文件的路径',
                                                 `output` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '对外输出记录',
                                                 `fail_output` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '失败记录',
                                                 `fail_remark` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '失败原因',
                                                 `create_time` int NOT NULL COMMENT '创建时间',
                                                 `update_time` int NOT NULL DEFAULT 0 COMMENT '操作时间',
                                                 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单批量发货表' ROW_FORMAT = DYNAMIC;