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

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

news 2025/10/14 12:47:28

目前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、手工启动热部署日常开发与调试，改几行代码想看效果就得手动点重启，很繁琐，接下来考虑启动热部署。首先引入springboot开发者工具： <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

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

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

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

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

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

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

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

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

编程日记 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，解决历史收集器的一些弊病，同时还尽力简化调优参数对于大多数应用，开启收集器，再配置一下Xms和Xmx就足够了（不建议配置Xmn） -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简介： 其可执行代码只有大约60KB左右，Boa是一个单任务的HTTP服务器&#xff…...

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

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

链接如下：https://www.luogu.com.cn/training/100#problems 一、Hello,World! 题目链接：https://www.luogu.com.cn/problem/B2002 题目描述编写一个能够输出 Hello,World! 的程序。提示： 使用英文标点符号；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、查看操作系统信息使用以下命令查看本机的操作系统和位数信息： uname -m && cat /etc/*release输出： x86_64 DISTRIB_I…...

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

Java基础（三）

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

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

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

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

编程日记 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

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

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

编程新知 2025/10/10 17:03:53

【WiFi帧结构】

文章目录帧结构MAC头部管理帧帧结构 Wi-Fi的帧分为三部分组成：MAC头部frame bodyFCS，其中MAC是固定格式的，frame body是可变长度。 MAC头部有frame control，duration，address1，address2，addre…...

编程新知 2025/10/9 17:29:18

Debian系统简介

目录 Debian系统介绍 Debian版本介绍 Debian软件源介绍软件包管理工具dpkg dpkg核心指令详解安装软件包卸载软件包查询软件包状态验证软件包完整性手动处理依赖关系 dpkg vs apt Debian系统介绍 Debian 和 Ubuntu 都是基于 Debian内核的 Linux 发行版&#xff…...

编程新知 2025/10/10 10:47:37

使用分级同态加密防御梯度泄漏

抽象联邦学习 （FL） 支持跨分布式客户端进行协作模型训练，而无需共享原始数据，这使其成为在互联和自动驾驶汽车 （CAV） 等领域保护隐私的机器学习的一种很有前途的方法。然而，最近的研究表明&…...

编程新知 2025/9/27 23:59:21

Go 语言接口详解

Go 语言接口详解核心概念接口定义在 Go 语言中，接口是一种抽象类型，它定义了一组方法的集合： // 定义接口 type Shape interface {Area() float64Perimeter() float64 } 接口实现 Go 接口的实现是隐式的： // 矩形结构体…...

编程新知 2025/8/13 18:32:28

条件运算符

C中的三目运算符（也称条件运算符，英文：ternary operator）是一种简洁的条件选择语句，语法如下： 条件表达式 ? 表达式1 : 表达式2• 如果“条件表达式”为true，则整个表达式的结果为“表达式1”…...

编程新知 2025/9/19 12:51:08

macOS多出来了：Google云端硬盘、YouTube、表格、幻灯片、Gmail、Google文档等应用

文章目录问题现象问题原因解决办法问题现象 macOS启动台（Launchpad）多出来了：Google云端硬盘、YouTube、表格、幻灯片、Gmail、Google文档等应用。问题原因很明显，都是Google家的办公全家桶。这些应用并不是通过独立安装的…...

编程新知 2025/9/24 19:23:45

c#开发AI模型对话

AI模型前面已经介绍了一般AI模型本地部署，直接调用现成的模型数据。这里主要讲述讲接口集成到我们自己的程序中使用方式。微软提供了ML.NET来开发和使用AI模型，但是目前国内可能使用不多，至少实践例子很少看见。开发训练模型就不介绍了&am…...

编程新知 2025/9/28 4:51:52

MySQL中【正则表达式】用法

MySQL 中正则表达式通过 REGEXP 或 RLIKE 操作符实现（两者等价），用于在 WHERE 子句中进行复杂的字符串模式匹配。以下是核心用法和示例： 一、基础语法 SELECT column_name FROM table_name WHERE column_name REGEXP pattern; …...

编程新知 2025/10/14 4:10:21

LINUX 69 FTP 客服管理系统 man 5 /etc/vsftpd/vsftpd.conf

FTP 客服管理系统实现kefu123登录，不允许匿名访问，kefu只能访问/data/kefu目录，不能查看其他目录创建账号密码 useradd kefu echo 123|passwd -stdin kefu [rootcode caozx26420]# echo 123|passwd --stdin kefu 更改用户 kefu 的密码…...

编程新知 2025/9/29 16:55:13

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

ruoyi-vue-pro yudao 项目mp 微信模块启用及相关SQL脚本

ruoyi-vue-pro yudao 项目 报表设计器

相关文章：

ruoyi-vue-pro yudao 项目报表设计器