当前位置： 首页 > news >正文

ruoyi-vue-pro yudao 项目商城 mall 模块启用及相关SQL脚本

news 2025/8/24 23:14:43

目前ruoyi-vue-pro 项目虽然开源，但是商城 mall 模块被屏蔽了，查看文档却要收费 199元（知识星球），价格有点太高了吧。

分享下如何启用 mall 模块，顺便贴上sql相关脚本。

一、启用模块

修改根目录 pom.xml

启用模块参与编译

 二、修改 yudao-server pom.xml， 启用模块

三、启动项目，数据库表如下

 如下图 开头的表需要额外脚本导入

  

-- ----------------------------
-- Table structure for market_activity
-- ----------------------------
DROP TABLE IF EXISTS `market_activity`;
CREATE TABLE `market_activity`  (`id` bigint(20) NOT NULL,`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`activity_type` tinyint(4) NOT NULL,`status` tinyint(4) NOT NULL,`start_time` datetime(0) NOT NULL,`end_time` datetime(0) NOT NULL,`invalid_time` datetime(0) NULL DEFAULT NULL,`delete_time` datetime(0) NULL DEFAULT NULL,`time_limited_discount` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`full_privilege` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',`tenant_id` bigint(20) NOT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '促销活动' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for member_user
-- ----------------------------
DROP TABLE IF EXISTS `member_user`;
CREATE TABLE `member_user`  (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',`nickname` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户昵称',`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '头像',`status` tinyint(4) NOT NULL COMMENT '状态',`mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号',`password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '密码',`register_ip` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '注册 IP',`login_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '最后登录IP',`login_date` datetime(0) NULL DEFAULT NULL COMMENT '最后登录时间',`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',`tenant_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '租户编号',PRIMARY KEY (`id`) USING BTREE,UNIQUE INDEX `uk_mobile`(`mobile`) USING BTREE COMMENT '手机号'
) ENGINE = InnoDB AUTO_INCREMENT = 248 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for pay_app
-- ----------------------------
DROP TABLE IF EXISTS `pay_app`;
CREATE TABLE `pay_app`  (`id` bigint(20) NOT NULL,`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`status` tinyint(4) NOT NULL,`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`order_notify_url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`refund_notify_url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付应用' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for pay_channel
-- ----------------------------
DROP TABLE IF EXISTS `pay_channel`;
CREATE TABLE `pay_channel`  (`id` bigint(20) NOT NULL,`code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`status` tinyint(4) NOT NULL,`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`fee_rate` double NOT NULL DEFAULT 0,`app_id` bigint(20) NOT NULL,`config` varchar(10240) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',`tenant_id` bigint(20) NOT NULL DEFAULT 0,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付渠道' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for pay_notify_log
-- ----------------------------
DROP TABLE IF EXISTS `pay_notify_log`;
CREATE TABLE `pay_notify_log`  (`id` bigint(20) NOT NULL,`task_id` bigint(20) NOT NULL,`notify_times` int(11) NOT NULL,`response` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`status` tinyint(4) NOT NULL,`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付通知日志' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for pay_notify_task
-- ----------------------------
DROP TABLE IF EXISTS `pay_notify_task`;
CREATE TABLE `pay_notify_task`  (`id` bigint(20) NOT NULL,`app_id` bigint(20) NOT NULL,`type` tinyint(4) NOT NULL,`data_id` bigint(20) NOT NULL,`merchant_order_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`status` tinyint(4) NOT NULL,`next_notify_time` datetime(0) NULL DEFAULT NULL,`last_execute_time` datetime(0) NULL DEFAULT NULL,`notify_times` int(11) NOT NULL,`max_notify_times` int(11) NOT NULL,`notify_url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',`tenant_id` bigint(20) NOT NULL DEFAULT 0,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付通知任务' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for pay_order
-- ----------------------------
DROP TABLE IF EXISTS `pay_order`;
CREATE TABLE `pay_order`  (`id` bigint(20) NOT NULL,`app_id` bigint(20) NOT NULL,`channel_id` bigint(20) NULL DEFAULT NULL,`channel_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`merchant_order_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`subject` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`body` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`notify_url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`price` bigint(20) NOT NULL,`channel_fee_rate` double NULL DEFAULT 0,`channel_fee_price` bigint(20) NULL DEFAULT 0,`status` tinyint(4) NOT NULL,`user_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`expire_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`success_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),`notify_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),`extension_id` bigint(20) NULL DEFAULT NULL,`no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`refund_price` bigint(20) NOT NULL,`channel_user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`channel_order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付订单' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for pay_order_extension
-- ----------------------------
DROP TABLE IF EXISTS `pay_order_extension`;
CREATE TABLE `pay_order_extension`  (`id` bigint(20) NOT NULL,`no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`order_id` bigint(20) NOT NULL,`channel_id` bigint(20) NOT NULL,`channel_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`user_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`status` tinyint(4) NOT NULL,`channel_extras` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`channel_error_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`channel_error_msg` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`channel_notify_data` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付订单拓展' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for pay_refund
-- ----------------------------
DROP TABLE IF EXISTS `pay_refund`;
CREATE TABLE `pay_refund`  (`id` bigint(20) NOT NULL,`no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`app_id` bigint(20) NOT NULL,`channel_id` bigint(20) NOT NULL,`channel_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`order_id` bigint(20) NOT NULL,`order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`merchant_order_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`merchant_refund_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`notify_url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`status` tinyint(4) NOT NULL,`pay_price` bigint(20) NOT NULL,`refund_price` bigint(20) NOT NULL,`reason` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`user_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`channel_order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`channel_refund_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`success_time` datetime(0) NULL DEFAULT NULL,`channel_error_code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`channel_error_msg` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`channel_notify_data` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '退款订单' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for product_brand
-- ----------------------------
DROP TABLE IF EXISTS `product_brand`;
CREATE TABLE `product_brand`  (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '品牌编号',`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '品牌名称',`pic_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '品牌图片',`sort` int(11) NULL DEFAULT 0 COMMENT '品牌排序',`description` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品牌描述',`status` tinyint(4) NOT NULL COMMENT '状态',`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',`tenant_id` bigint(20) NOT NULL DEFAULT 0,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品品牌' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for product_category
-- ----------------------------
DROP TABLE IF EXISTS `product_category`;
CREATE TABLE `product_category`  (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '分类编号',`parent_id` bigint(20) NOT NULL COMMENT '父分类编号',`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分类名称',`pic_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '移动端分类图',`big_pic_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'PC 端分类图',`sort` int(11) NULL DEFAULT 0 COMMENT '分类排序',`status` tinyint(4) NOT NULL COMMENT '开启状态',`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',`tenant_id` bigint(20) NOT NULL DEFAULT 0,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品分类' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for product_comment
-- ----------------------------
DROP TABLE IF EXISTS `product_comment`;
CREATE TABLE `product_comment`  (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '评论编号，主键自增',`user_id` bigint(20) NULL DEFAULT NULL COMMENT '评价人的用户编号关联 MemberUserDO 的 id 编号',`user_nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '评价人名称',`user_avatar` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '评价人头像',`anonymous` bit(1) NULL DEFAULT NULL COMMENT '是否匿名',`order_id` bigint(20) NULL DEFAULT NULL COMMENT '交易订单编号关联 TradeOrderDO 的 id 编号',`order_item_id` bigint(20) NULL DEFAULT NULL COMMENT '交易订单项编号关联 TradeOrderItemDO 的 id 编号',`spu_id` bigint(20) NULL DEFAULT NULL COMMENT '商品 SPU 编号关联 ProductSpuDO 的 id',`spu_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '商品 SPU 名称',`sku_id` bigint(20) NULL DEFAULT NULL COMMENT '商品 SKU 编号关联 ProductSkuDO 的 id 编号',`visible` bit(1) NULL DEFAULT NULL COMMENT '是否可见true:显示false:隐藏',`scores` tinyint(4) NULL DEFAULT NULL COMMENT '评分星级1-5分',`description_scores` tinyint(4) NULL DEFAULT NULL COMMENT '描述星级1-5 星',`benefit_scores` tinyint(4) NULL DEFAULT NULL COMMENT '服务星级1-5 星',`content` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '评论内容',`pic_urls` varchar(4096) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '评论图片地址数组',`reply_status` bit(1) NULL DEFAULT NULL COMMENT '商家是否回复',`reply_user_id` bigint(20) NULL DEFAULT NULL COMMENT '回复管理员编号关联 AdminUserDO 的 id 编号',`reply_content` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '商家回复内容',`reply_time` datetime(0) NULL DEFAULT NULL COMMENT '商家回复时间',`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',`tenant_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '租户编号',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品评论' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for product_property
-- ----------------------------
DROP TABLE IF EXISTS `product_property`;
CREATE TABLE `product_property`  (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规格名称',`status` tinyint(4) NULL DEFAULT NULL COMMENT '状态： 0 开启 ，1 禁用',`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',`tenant_id` bigint(20) NOT NULL DEFAULT 0,`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '规格名称' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for product_property_value
-- ----------------------------
DROP TABLE IF EXISTS `product_property_value`;
CREATE TABLE `product_property_value`  (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`property_id` bigint(20) NULL DEFAULT NULL COMMENT '规格键id',`name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规格值名字',`status` tinyint(4) NULL DEFAULT NULL COMMENT '状态： 1 开启 ，2 禁用',`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',`tenant_id` bigint(20) NOT NULL DEFAULT 0,`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '规格值' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for product_sku
-- ----------------------------
DROP TABLE IF EXISTS `product_sku`;
CREATE TABLE `product_sku`  (`id` bigint(20) NOT NULL,`spu_id` bigint(20) NOT NULL COMMENT 'spu编号',`properties` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '属性数组，JSON 格式',`price` int(11) NOT NULL DEFAULT -1 COMMENT '商品价格，单位：分',`market_price` int(11) NULL DEFAULT NULL COMMENT '市场价，单位：分',`cost_price` int(11) NOT NULL DEFAULT -1 COMMENT '成本价，单位： 分',`bar_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'SKU 的条形码',`pic_url` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '图片地址',`stock` int(11) NULL DEFAULT NULL COMMENT '库存',`weight` double NULL DEFAULT NULL COMMENT '商品重量，单位：kg 千克',`volume` double NULL DEFAULT NULL COMMENT '商品体积，单位：m^3 平米',`sub_commission_first_price` int(11) NULL DEFAULT NULL COMMENT '一级分销的佣金，单位：分',`sub_commission_second_price` int(11) NULL DEFAULT NULL COMMENT '二级分销的佣金，单位：分',`sales_count` int(11) NULL DEFAULT NULL COMMENT '商品销量',`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',`tenant_id` bigint(20) NOT NULL DEFAULT 0,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品sku' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for product_spu
-- ----------------------------
DROP TABLE IF EXISTS `product_spu`;
CREATE TABLE `product_spu`  (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '商品 SPU 编号，自增',`name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品名称',`keyword` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关键字',`introduction` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品简介',`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品详情',`bar_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '条形码',`category_id` bigint(20) NOT NULL COMMENT '商品分类编号',`brand_id` int(11) NULL DEFAULT NULL COMMENT '商品品牌编号',`pic_url` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品封面图',`slider_pic_urls` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '商品轮播图地址\n 数组，以逗号分隔\n 最多上传15张',`video_url` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品视频',`unit` tinyint(4) NOT NULL COMMENT '单位',`sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序字段',`status` tinyint(4) NOT NULL COMMENT '商品状态: 0 上架（开启） 1 下架（禁用）-1 回收',`spec_type` bit(1) NOT NULL COMMENT '规格类型：0 单规格 1 多规格',`price` int(11) NOT NULL DEFAULT -1 COMMENT '商品价格，单位使用：分',`market_price` int(11) NOT NULL COMMENT '市场价，单位使用：分',`cost_price` int(11) NOT NULL DEFAULT -1 COMMENT '成本价，单位： 分',`stock` int(11) NOT NULL DEFAULT 0 COMMENT '库存',`delivery_template_id` bigint(20) NOT NULL COMMENT '物流配置模板编号',`recommend_hot` bit(1) NOT NULL COMMENT '是否热卖推荐: 0 默认 1 热卖',`recommend_benefit` bit(1) NOT NULL COMMENT '是否优惠推荐: 0 默认 1 优选',`recommend_best` bit(1) NOT NULL COMMENT '是否精品推荐: 0 默认 1 精品',`recommend_new` bit(1) NOT NULL COMMENT '是否新品推荐: 0 默认 1 新品',`recommend_good` bit(1) NOT NULL COMMENT '是否优品推荐',`give_integral` int(11) NOT NULL COMMENT '赠送积分',`give_coupon_template_ids` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '赠送的优惠劵编号的数组',`sub_commission_type` bit(1) NOT NULL COMMENT '分销类型',`activity_orders` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '活动显示排序0=默认, 1=秒杀，2=砍价，3=拼团',`sales_count` int(11) NULL DEFAULT 0 COMMENT '商品销量',`virtual_sales_count` int(11) NULL DEFAULT 0 COMMENT '虚拟销量',`browse_count` int(11) NULL DEFAULT 0 COMMENT '商品点击量',`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',`tenant_id` bigint(20) NOT NULL DEFAULT 0,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品spu' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for promotion_combination_activity
-- ----------------------------
DROP TABLE IF EXISTS `promotion_combination_activity`;
CREATE TABLE `promotion_combination_activity`  (`id` bigint(20) NOT NULL,`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`spu_id` bigint(20) NULL DEFAULT NULL,`total_limit_count` int(11) NOT NULL,`single_limit_count` int(11) NOT NULL,`start_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`end_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`user_size` int(11) NOT NULL,`total_num` int(11) NOT NULL,`success_num` int(11) NOT NULL,`order_user_count` int(11) NOT NULL,`virtual_group` int(11) NOT NULL,`status` int(11) NOT NULL,`limit_duration` int(11) NOT NULL,`creator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',`tenant_id` bigint(20) NOT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '拼团活动' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for promotion_coupon
-- ----------------------------
DROP TABLE IF EXISTS `promotion_coupon`;
CREATE TABLE `promotion_coupon`  (`id` bigint(20) NOT NULL,`template_id` bigint(20) NOT NULL,`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`status` int(11) NOT NULL,`user_id` bigint(20) NOT NULL,`take_type` int(11) NOT NULL,`useprice` int(11) NOT NULL,`valid_start_time` datetime(0) NOT NULL,`valid_end_time` datetime(0) NOT NULL,`product_scope` int(11) NOT NULL,`product_spu_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`discount_type` int(11) NOT NULL,`discount_percent` int(11) NULL DEFAULT NULL,`discount_price` int(11) NULL DEFAULT NULL,`discount_limit_price` int(11) NULL DEFAULT NULL,`use_order_id` bigint(20) NULL DEFAULT NULL,`use_time` datetime(0) NULL DEFAULT NULL,`creator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '优惠劵' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for promotion_coupon_template
-- ----------------------------
DROP TABLE IF EXISTS `promotion_coupon_template`;
CREATE TABLE `promotion_coupon_template`  (`id` bigint(20) NOT NULL AUTO_INCREMENT,`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`status` int(11) NOT NULL,`total_count` int(11) NOT NULL,`take_limit_count` int(11) NOT NULL,`take_type` int(11) NOT NULL,`use_price` int(11) NOT NULL,`product_scope` int(11) NOT NULL,`product_spu_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`validity_type` int(11) NOT NULL,`valid_start_time` datetime(0) NULL DEFAULT NULL,`valid_end_time` datetime(0) NULL DEFAULT NULL,`fixed_start_term` int(11) NULL DEFAULT NULL,`fixed_end_term` int(11) NULL DEFAULT NULL,`discount_type` int(11) NOT NULL,`discount_percent` int(11) NULL DEFAULT NULL,`discount_price` int(11) NULL DEFAULT NULL,`discount_limit_price` int(11) NULL DEFAULT NULL,`take_count` int(11) NOT NULL DEFAULT 0,`use_count` int(11) NOT NULL DEFAULT 0,`creator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',`tenant_id` bigint(20) NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '优惠劵模板' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for promotion_discount_activity
-- ----------------------------
DROP TABLE IF EXISTS `promotion_discount_activity`;
CREATE TABLE `promotion_discount_activity`  (`id` bigint(20) NOT NULL,`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`status` int(11) NOT NULL,`start_time` datetime(0) NOT NULL,`end_time` datetime(0) NOT NULL,`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`creator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',`tenant_id` int(20) NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '限时折扣活动' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for promotion_reward_activity
-- ----------------------------
DROP TABLE IF EXISTS `promotion_reward_activity`;
CREATE TABLE `promotion_reward_activity`  (`id` bigint(20) NOT NULL,`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`status` int(11) NOT NULL,`start_time` datetime(0) NOT NULL,`end_time` datetime(0) NOT NULL,`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`condition_type` int(11) NOT NULL,`product_scope` int(11) NOT NULL,`product_spu_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`rules` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`creator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',`tenant_id` int(20) NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '满减送活动' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for promotion_seckill_activity
-- ----------------------------
DROP TABLE IF EXISTS `promotion_seckill_activity`;
CREATE TABLE `promotion_seckill_activity`  (`id` bigint(20) NOT NULL,`spu_id` bigint(20) NOT NULL,`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`status` int(11) NOT NULL,`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`start_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`end_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`sort` int(11) NOT NULL,`config_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`order_count` int(11) NOT NULL,`user_count` int(11) NOT NULL,`total_price` int(11) NOT NULL,`total_limit_count` int(11) NULL DEFAULT NULL,`single_limit_count` int(11) NULL DEFAULT NULL,`stock` int(11) NULL DEFAULT NULL,`total_stock` int(11) NULL DEFAULT NULL,`creator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',`tenant_id` bigint(20) NOT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '秒杀活动' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for promotion_seckill_config
-- ----------------------------
DROP TABLE IF EXISTS `promotion_seckill_config`;
CREATE TABLE `promotion_seckill_config`  (`id` bigint(20) NOT NULL,`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`start_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`end_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`pic_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`status` int(11) NOT NULL,`creator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',`tenant_id` bigint(20) NOT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '秒杀时段配置' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for trade_after_sale
-- ----------------------------
DROP TABLE IF EXISTS `trade_after_sale`;
CREATE TABLE `trade_after_sale`  (`id` bigint(20) NOT NULL,`no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`status` int(11) NOT NULL,`type` int(11) NOT NULL,`way` int(11) NOT NULL,`user_id` bigint(20) NOT NULL,`apply_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`apply_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`apply_pic_urls` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`order_id` bigint(20) NOT NULL,`order_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`order_item_id` bigint(20) NOT NULL,`spu_id` bigint(20) NOT NULL,`spu_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`sku_id` bigint(20) NOT NULL,`properties` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`pic_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`count` int(11) NOT NULL,`audit_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`audit_user_id` bigint(20) NULL DEFAULT NULL,`audit_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`refund_price` int(11) NOT NULL,`pay_refund_id` bigint(20) NULL DEFAULT NULL,`refund_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`logistics_id` bigint(20) NULL DEFAULT NULL,`logistics_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`delivery_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`receive_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`receive_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`creator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',`tenant_id` bigint(20) NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '交易售后表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for trade_after_sale_log
-- ----------------------------
DROP TABLE IF EXISTS `trade_after_sale_log`;
CREATE TABLE `trade_after_sale_log`  (`id` bigint(20) NOT NULL,`user_id` bigint(20) NOT NULL,`user_type` int(11) NOT NULL,`after_sale_id` bigint(20) NOT NULL,`order_id` bigint(20) NOT NULL,`order_item_id` bigint(20) NOT NULL,`before_status` int(11) NULL DEFAULT NULL,`after_status` int(11) NOT NULL,`content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`creator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '交易售后日志' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for trade_order
-- ----------------------------
DROP TABLE IF EXISTS `trade_order`;
CREATE TABLE `trade_order`  (`id` bigint(20) NOT NULL,`no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`type` int(11) NOT NULL,`terminal` int(11) NOT NULL,`user_id` bigint(20) NOT NULL,`user_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`status` int(11) NOT NULL,`product_count` int(11) NOT NULL,`cancel_type` int(11) NULL DEFAULT NULL,`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`pay_status` bit(1) NOT NULL,`pay_time` datetime(0) NULL DEFAULT NULL,`finish_time` datetime(0) NULL DEFAULT NULL,`cancel_time` datetime(0) NULL DEFAULT NULL,`original_price` int(11) NOT NULL,`order_price` int(11) NOT NULL,`discount_price` int(11) NOT NULL,`delivery_price` int(11) NOT NULL,`adjust_price` int(11) NOT NULL,`pay_price` int(11) NOT NULL,`pay_order_id` bigint(20) NULL DEFAULT NULL,`pay_channel_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`delivery_template_id` bigint(20) NULL DEFAULT NULL,`logistics_id` bigint(20) NULL DEFAULT NULL,`logistics_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`delivery_status` smallint(6) NOT NULL,`delivery_time` datetime(0) NULL DEFAULT NULL,`receive_time` datetime(0) NULL DEFAULT NULL,`receiver_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`receiver_mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`receiver_area_id` int(11) NOT NULL,`receiver_post_code` int(11) NULL DEFAULT NULL,`receiver_detail_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`after_sale_status` int(11) NOT NULL,`refund_price` int(11) NOT NULL,`coupon_id` bigint(20) NOT NULL,`coupon_price` int(11) NOT NULL,`point_price` int(11) NOT NULL,`creator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',`tenant_id` bigint(20) NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '交易订单表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for trade_order_item
-- ----------------------------
DROP TABLE IF EXISTS `trade_order_item`;
CREATE TABLE `trade_order_item`  (`id` bigint(20) NOT NULL,`user_id` bigint(20) NOT NULL,`order_id` bigint(20) NOT NULL,`spu_id` bigint(20) NOT NULL,`spu_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,`sku_id` bigint(20) NOT NULL,`properties` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`pic_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,`count` int(11) NOT NULL,`original_price` int(11) NOT NULL,`original_unit_price` int(11) NOT NULL,`discount_price` int(11) NOT NULL,`pay_price` int(11) NOT NULL,`order_part_price` int(11) NOT NULL,`order_divide_price` int(11) NOT NULL,`after_sale_status` int(11) NOT NULL,`creator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),`updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),`deleted` bit(1) NOT NULL DEFAULT b'0',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '交易订单明细表' ROW_FORMAT = Dynamic;

四、问题描述

以上整理 ruoyi-vue-pro mall 模块基本的相关脚本，有些模块没有脚本，估计功能还在设计，表也没出，前端没有接口请求，如果后续有更新再补上。

五、写在后面

需要其他模块开启的请留言
 

ruoyi-vue-pro yudao 项目bpm模块启用及相关SQL脚本
ruoyi-vue-pro yudao 项目mp 微信模块启用及相关SQL脚本
ruoyi-vue-pro yudao 项目 报表设计器

相关文章：

ruoyi-vue-pro yudao 项目商城 mall 模块启用及相关SQL脚本

目前ruoyi-vue-pro 项目虽然开源，但是商城 mall 模块被屏蔽了，查看文档却要收费 199元（知识星球），价格有点太高了吧。 分享下如何启用 mall 模块，顺便贴上sql相关脚本。 一、启用模块 修改根目录 pom.xm…...

编程日记 2023/9/22 8:42:12

default 和 delete 与默认构造函数 的使用

前言 使用default和delete关键字来干预编译器自动生成的函数。让我详细解释一下这些知识点： 正文 编译器生成的默认构造函数： 如果类A没有定义任何构造函数，那么编译器会自动生成一个无参的默认构造函数 A()。这个默认构造函数实际上是一个…...

编程日记 2023/9/22 8:41:11

【开发篇】一、热部署

文章目录 1、手工启动热部署2、自动启动热部署3、热部署范围配置4、关闭热部署功能 1、手工启动热部署 日常开发与调试&#xff0c;改几行代码想看效果就得手动点重启&#xff0c;很繁琐&#xff0c;接下来考虑启动热部署。首先引入springboot开发者工具&#xff1a; <dep…...

编程日记 2023/9/22 8:37:06

点云从入门到精通技术详解100篇-定子装配过程中基于深度学习的易变形材料的点云分割（下）

目录 4.3.2 校正网络 4.3.3 浅层特征提取网络 4.3.4 空间边界 Transformer 深层特征提取网络 4.3.5 损失函数...

编程日记 2023/9/22 8:35:03

谷歌浏览器关闭自动更新功能

背景&#xff1a;自动化测试需要下载webdriver驱动&#xff0c;然而浏览器自动更新会导致原来的驱动版本与现有浏览器版本不匹配&#xff0c;所以要禁用掉浏览器自动更新功能。 1.右键-我的电脑-打开管理&#xff1b; 2.选择任务计划程序-任务计划程序库-找到两个chrome自动更新…...

编程日记 2023/9/22 8:33:00

电商业务--技术负责人 250K*15

职位描述 研发团队管理 系统搭建 技术管理 系统架构 岗位职责 负责/参与到中大型负责系统的整体架构和设计&#xff1b; 根据业务特点和行业最佳实践&#xff0c;设计符合多个市场物流业务需求&#xff0c;且具备可扩展能力的系统架构和业务架构承担团队稳定性建设工作&#…...

编程日记 2023/9/22 8:29:57

MySQL只同步单个表或多个表，非全部同步！

replicate-do-table 是 MySQL 复制配置中的一个选项&#xff0c;它允许您指定要在从服务器上复制的表。如果您想要只复制主服务器上特定的表到从服务器&#xff0c;您可以使用这个选项。 以下是如何操作 replicate-do-table 的步骤&#xff1a; 停止从服务器: 在从服务器上执行…...

编程日记 2023/9/22 8:27:55

【论文基本功】【LaTeX】个人常用易忘LaTeX命令

【论文基本功】【LaTeX】个人常用易忘LaTeX命令 1. 基本符号2. 引用3. 字体及符号大小4. 其他参考 1. 基本符号 符号LaTeX命令备注 ∣ ⋅ ∣ | \cdot | ∣⋅∣| \cdot |绝对值 ∣ ∣ ⋅ ∣ ∣ || \cdot || ∣∣⋅∣∣\| \cdot \|范数 ⌈ ⋅ ⌉ \lceil \cdot \rceil ⌈⋅⌉\lce…...

编程日记 2023/9/22 8:26:55

JVM参数调优——G1收集器

开启 G1 Collector G1收集器的出现除了提供可控的低延迟GC&#xff0c;解决历史收集器的一些弊病&#xff0c;同时还尽力简化调优参数 对于大多数应用&#xff0c;开启收集器&#xff0c;再配置一下Xms和Xmx就足够了&#xff08;不建议配置Xmn&#xff09; -XX:UseG1GC核心参…...

编程日记 2023/9/22 8:25:54

Linux cp命令使用指南：详细教程及实际应用场景解析

文章目录 Linux中的cp命令使用指南1. 简介1.1 Linux操作系统简介1.2 文件系统和目录结构1.3 cp命令概述 2. cp命令基本用法2.1 复制文件2.2 复制目录2.3 复制多个文件或目录2.4 递归复制2.5 强制覆盖已存在文件2.6 保留文件权限和属性 3. 高级用法3.1 保留符号链接3.2 仅复制更…...

编程日记 2023/9/22 8:22:51

树结构数据在table中回显 treeselect disabled

<el-table-column label"产业认定" align"center" prop"industryIdentification"><template slot-scope"scope"><treeselectv-if"scope.row.industryIdentification"v-model"scope.row.industryIdentif…...

编程日记 2023/9/22 8:21:50

BOA服务器移植

BOA服务器移植 1、源码下载 http://www.boa.org/ News! (last updated 23 February 2005) Latest Released Version (0.94.13) here (signature here) --- 下载地址1.1 boa简介&#xff1a; 其可执行代码只有大约60KB左右&#xff0c;Boa是一个单任务的HTTP服务器&#xff…...

编程日记 2023/9/22 8:19:48

洛谷刷题入门篇：顺序结构

链接如下&#xff1a;https://www.luogu.com.cn/training/100#problems 一、Hello,World! 题目链接&#xff1a;https://www.luogu.com.cn/problem/B2002 题目描述 编写一个能够输出 Hello,World! 的程序。 提示&#xff1a; 使用英文标点符号&#xff1b;Hello,World! 逗…...

编程日记 2023/9/22 8:16:44

LVS+Haproxy

LVSHaproxy 一、Haproxy简介1.1、Haproxy应用分析1.2、Haproxy的特性1.3、常见负载均衡策略1.4、LVS、Haproxy、Nginx区别1.5、 Haproxy的优点1.6、常见的Web集群调度器 二、Haproxy部署实例四、日志定义优化 一、Haproxy简介 Haproxy 是一个使用C语言编写的自由及开放源代码软…...

编程日记 2023/9/22 8:15:43

Linux知识

文章目录 一、Apt1、查看操作系统信息2、换源3、比较4、用法5、ubuntu获取源码 二、pkg-config三、调试glibc 一、Apt 1、查看操作系统信息 使用以下命令查看本机的操作系统和位数信息&#xff1a; uname -m && cat /etc/*release输出&#xff1a; x86_64 DISTRIB_I…...

编程日记 2023/9/22 8:14:42

Java基础（三）

前言&#xff1a;前面主要涉及到java的基本语法&#xff0c;接下来本篇博客主要记录Java中Collections类、泛型、以及File类、IO流的学习。 目录 数据结构 泛型 集合 分类 Collection的分类 collection常用方法 collection遍历方式 迭代器 for循环 Lambda表达式 Lis…...

编程日记 2023/9/22 8:13:41

[Firefox/快捷键] 禁用Ctrl-W快捷键

最近给Firefox这一快捷键坑了几次。恰好发现在CMU也有人遇到类似的烦恼&#xff0c;找到一篇基于Linux的教程。 我使用的是Windows&#xff0c;所以根据自己的情况做了些修改&#xff0c;成功了。小众需求就犯懒直接将笔记贴上了&#xff0c;如果有谁用得上的话&#xff0c;我写…...

编程日记 2023/9/22 8:12:40

Git常用命令diff和mv

Git常用命令diff和mv 1、diff # 查看工作区和暂存区所有文件的对比 # 该命令可以显示尚未添加到stage的文件的变更 $ git diff# 查看工作区和暂存区单个文件的对比 $ git diff file# 显示暂存区和上一个commit的差异 # 查看暂存区与指定提交版本的不同,版本可缺省为HEAD $ gi…...

编程日记 2023/9/22 8:11:39

【谢希尔 计算机网络】第3章 数据链路层

数据链路层 数据链路层的地位 网络中的主机、路由器等都必须实现数据链路层局域网中的主机、交换机等都必须实现数据链路层不同链路层可能采用不同的数据链路层协议 数据链路层信道类型 点对点信道 使用一对一的点对点通信方式广播通信 必须使用专用的共享系电脑协议来协调这些…...

编程日记 2023/9/22 8:10:38

《DevOps实践指南》- 读书笔记（九）

DevOps实践指南 25. 附录附录 1 DevOps 的大融合精益运动敏捷运动Velocity 大会运动敏捷基础设施运动持续交付运动丰田套路运动精益创业运动精益用户体验运动Rugged Computing 运动 附录 2 约束理论和核心的长期冲突附录 3 恶性循环列表附录 4 交接和队列的危害附录 5 工业安全…...

编程日记 2023/9/22 8:09:37

国防科技大学计算机基础课程笔记02信息编码

1.机内码和国标码 国标码就是我们非常熟悉的这个GB2312,但是因为都是16进制&#xff0c;因此这个了16进制的数据既可以翻译成为这个机器码&#xff0c;也可以翻译成为这个国标码&#xff0c;所以这个时候很容易会出现这个歧义的情况&#xff1b; 因此&#xff0c;我们的这个国…...

编程新知 2025/8/20 2:05:50

【网络】每天掌握一个Linux命令 - iftop

在Linux系统中&#xff0c;iftop是网络管理的得力助手&#xff0c;能实时监控网络流量、连接情况等&#xff0c;帮助排查网络异常。接下来从多方面详细介绍它。 目录 【网络】每天掌握一个Linux命令 - iftop工具概述安装方式核心功能基础用法进阶操作实战案例面试题场景生产场景…...

编程新知 2025/8/4 15:02:27

Lombok 的 @Data 注解失效，未生成 getter/setter 方法引发的HTTP 406 错误

HTTP 状态码 406 (Not Acceptable) 和 500 (Internal Server Error) 是两类完全不同的错误&#xff0c;它们的含义、原因和解决方法都有显著区别。以下是详细对比&#xff1a; 1. HTTP 406 (Not Acceptable) 含义&#xff1a; 客户端请求的内容类型与服务器支持的内容类型不匹…...

编程新知 2025/8/20 1:45:17

k8s从入门到放弃之Ingress七层负载

k8s从入门到放弃之Ingress七层负载 在Kubernetes&#xff08;简称K8s&#xff09;中&#xff0c;Ingress是一个API对象&#xff0c;它允许你定义如何从集群外部访问集群内部的服务。Ingress可以提供负载均衡、SSL终结和基于名称的虚拟主机等功能。通过Ingress&#xff0c;你可…...

编程新知 2025/7/18 7:48:04

练习（含atoi的模拟实现,自定义类型等练习）

一、结构体大小的计算及位段 &#xff08;结构体大小计算及位段 详解请看&#xff1a;自定义类型&#xff1a;结构体进阶-CSDN博客&#xff09; 1.在32位系统环境&#xff0c;编译选项为4字节对齐&#xff0c;那么sizeof(A)和sizeof(B)是多少&#xff1f; #pragma pack(4)st…...

编程新知 2025/8/22 3:26:39

FFmpeg 低延迟同屏方案

引言 在实时互动需求激增的当下&#xff0c;无论是在线教育中的师生同屏演示、远程办公的屏幕共享协作&#xff0c;还是游戏直播的画面实时传输&#xff0c;低延迟同屏已成为保障用户体验的核心指标。FFmpeg 作为一款功能强大的多媒体框架&#xff0c;凭借其灵活的编解码、数据…...

编程新知 2025/6/21 15:38:27

vscode（仍待补充）

写于2025 6.9 主包将加入vscode这个更权威的圈子 vscode的基本使用 侧边栏 vscode还能连接ssh&#xff1f; debug时使用的launch文件 1.task.json {"tasks": [{"type": "cppbuild","label": "C/C: gcc.exe 生成活动文件"…...

编程新知 2025/8/24 15:53:58

YSYX学习记录（八）

C语言&#xff0c;练习0&#xff1a; 先创建一个文件夹&#xff0c;我用的是物理机&#xff1a; 安装build-essential 练习1&#xff1a; 我注释掉了 #include <stdio.h> 出现下面错误 在你的文本编辑器中打开ex1文件&#xff0c;随机修改或删除一部分&#xff0c;之后…...

编程新知 2025/8/22 4:16:32

Python实现prophet 理论及参数优化

文章目录 Prophet理论及模型参数介绍Python代码完整实现prophet 添加外部数据进行模型优化 之前初步学习prophet的时候&#xff0c;写过一篇简单实现&#xff0c;后期随着对该模型的深入研究&#xff0c;本次记录涉及到prophet 的公式以及参数调优&#xff0c;从公式可以更直观…...

编程新知 2025/8/15 19:10:13

ffmpeg（四）：滤镜命令

FFmpeg 的滤镜命令是用于音视频处理中的强大工具&#xff0c;可以完成剪裁、缩放、加水印、调色、合成、旋转、模糊、叠加字幕等复杂的操作。其核心语法格式一般如下&#xff1a; ffmpeg -i input.mp4 -vf "滤镜参数" output.mp4或者带音频滤镜&#xff1a; ffmpeg…...

编程新知 2025/7/23 10:55:13