來個(gè)網(wǎng)站吧好人一生平安2021足球積分排行榜最新
目前ruoyi-vue-pro 項(xiàng)目雖然開源，但是商城?mall 模塊被屏蔽了，查看文檔卻要收費(fèi) 199元（知識(shí)星球），價(jià)格有點(diǎn)太高了吧。
分享下如何啟用?mall 模塊，順便貼上sql相關(guān)腳本。
一、啟用模塊
修改根目錄 pom.xml
啟用模塊參與編譯
?二、修改 yudao-server pom.xml， 啟用模塊
三、啟動(dòng)項(xiàng)目，數(shù)據(jù)庫(kù)表如下
?如下圖?開頭的表需要額外腳本導(dǎo)入
??
-- ----------------------------
-- 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 = '促銷活動(dòng)' 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 '編號(hào)',`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 '狀態(tài)',`mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手機(jī)號(hào)',`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 '注冊(cè) IP',`login_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '最后登錄IP',`login_date` datetime(0) NULL DEFAULT NULL COMMENT '最后登錄時(shí)間',`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '創(chuàng)建者',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '創(chuàng)建時(shí)間',`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 '更新時(shí)間',`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否刪除',`tenant_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '租戶編號(hào)',PRIMARY KEY (`id`) USING BTREE,UNIQUE INDEX `uk_mobile`(`mobile`) USING BTREE COMMENT '手機(jī)號(hào)'
) 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 = '支付應(yīng)用' 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 = '支付通知任務(wù)' 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 '品牌編號(hào)',`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 '狀態(tài)',`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 '分類編號(hào)',`parent_id` bigint(20) NOT NULL COMMENT '父分類編號(hào)',`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 '移動(dòng)端分類圖',`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 '開啟狀態(tài)',`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 '評(píng)論編號(hào)，主鍵自增',`user_id` bigint(20) NULL DEFAULT NULL COMMENT '評(píng)價(jià)人的用戶編號(hào)關(guān)聯(lián) MemberUserDO 的 id 編號(hào)',`user_nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '評(píng)價(jià)人名稱',`user_avatar` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '評(píng)價(jià)人頭像',`anonymous` bit(1) NULL DEFAULT NULL COMMENT '是否匿名',`order_id` bigint(20) NULL DEFAULT NULL COMMENT '交易訂單編號(hào)關(guān)聯(lián) TradeOrderDO 的 id 編號(hào)',`order_item_id` bigint(20) NULL DEFAULT NULL COMMENT '交易訂單項(xiàng)編號(hào)關(guān)聯(lián) TradeOrderItemDO 的 id 編號(hào)',`spu_id` bigint(20) NULL DEFAULT NULL COMMENT '商品 SPU 編號(hào)關(guān)聯(lián) 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 編號(hào)關(guān)聯(lián) ProductSkuDO 的 id 編號(hào)',`visible` bit(1) NULL DEFAULT NULL COMMENT '是否可見true:顯示false:隱藏',`scores` tinyint(4) NULL DEFAULT NULL COMMENT '評(píng)分星級(jí)1-5分',`description_scores` tinyint(4) NULL DEFAULT NULL COMMENT '描述星級(jí)1-5 星',`benefit_scores` tinyint(4) NULL DEFAULT NULL COMMENT '服務(wù)星級(jí)1-5 星',`content` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '評(píng)論內(nèi)容',`pic_urls` varchar(4096) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '評(píng)論圖片地址數(shù)組',`reply_status` bit(1) NULL DEFAULT NULL COMMENT '商家是否回復(fù)',`reply_user_id` bigint(20) NULL DEFAULT NULL COMMENT '回復(fù)管理員編號(hào)關(guān)聯(lián) AdminUserDO 的 id 編號(hào)',`reply_content` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '商家回復(fù)內(nèi)容',`reply_time` datetime(0) NULL DEFAULT NULL COMMENT '商家回復(fù)時(shí)間',`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '創(chuàng)建者',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '創(chuàng)建時(shí)間',`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 '更新時(shí)間',`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否刪除',`tenant_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '租戶編號(hào)',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品評(píng)論' 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 '規(guī)格名稱',`status` tinyint(4) NULL DEFAULT NULL COMMENT '狀態(tài)： 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 = '規(guī)格名稱' 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 '規(guī)格鍵id',`name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '規(guī)格值名字',`status` tinyint(4) NULL DEFAULT NULL COMMENT '狀態(tài)： 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 = '規(guī)格值' 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編號(hào)',`properties` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '屬性數(shù)組，JSON 格式',`price` int(11) NOT NULL DEFAULT -1 COMMENT '商品價(jià)格，單位：分',`market_price` int(11) NULL DEFAULT NULL COMMENT '市場(chǎng)價(jià)，單位：分',`cost_price` int(11) NOT NULL DEFAULT -1 COMMENT '成本價(jià)，單位： 分',`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 '庫(kù)存',`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 '一級(jí)分銷的傭金，單位：分',`sub_commission_second_price` int(11) NULL DEFAULT NULL COMMENT '二級(jí)分銷的傭金，單位：分',`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 編號(hào)，自增',`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 '關(guān)鍵字',`introduction` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品簡(jiǎn)介',`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 '商品分類編號(hào)',`brand_id` int(11) NULL DEFAULT NULL COMMENT '商品品牌編號(hào)',`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 數(shù)組，以逗號(hào)分隔\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 '商品狀態(tài): 0 上架（開啟） 1 下架（禁用）-1 回收',`spec_type` bit(1) NOT NULL COMMENT '規(guī)格類型：0 單規(guī)格 1 多規(guī)格',`price` int(11) NOT NULL DEFAULT -1 COMMENT '商品價(jià)格，單位使用：分',`market_price` int(11) NOT NULL COMMENT '市場(chǎng)價(jià)，單位使用：分',`cost_price` int(11) NOT NULL DEFAULT -1 COMMENT '成本價(jià)，單位： 分',`stock` int(11) NOT NULL DEFAULT 0 COMMENT '庫(kù)存',`delivery_template_id` bigint(20) NOT NULL COMMENT '物流配置模板編號(hào)',`recommend_hot` bit(1) NOT NULL COMMENT '是否熱賣推薦: 0 默認(rèn) 1 熱賣',`recommend_benefit` bit(1) NOT NULL COMMENT '是否優(yōu)惠推薦: 0 默認(rèn) 1 優(yōu)選',`recommend_best` bit(1) NOT NULL COMMENT '是否精品推薦: 0 默認(rèn) 1 精品',`recommend_new` bit(1) NOT NULL COMMENT '是否新品推薦: 0 默認(rèn) 1 新品',`recommend_good` bit(1) NOT NULL COMMENT '是否優(yōu)品推薦',`give_integral` int(11) NOT NULL COMMENT '贈(zèng)送積分',`give_coupon_template_ids` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '贈(zèng)送的優(yōu)惠劵編號(hào)的數(shù)組',`sub_commission_type` bit(1) NOT NULL COMMENT '分銷類型',`activity_orders` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '活動(dòng)顯示排序0=默認(rèn), 1=秒殺，2=砍價(jià)，3=拼團(tuán)',`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 '商品點(diǎn)擊量',`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 = '拼團(tuán)活動(dòng)' 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 = '優(yōu)惠劵' 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 = '優(yōu)惠劵模板' 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 = '限時(shí)折扣活動(dòng)' 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 = '滿減送活動(dòng)' 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 = '秒殺活動(dòng)' 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 = '秒殺時(shí)段配置' 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 = '交易訂單明細(xì)表' ROW_FORMAT = Dynamic;四、問題描述
以上整理 ruoyi-vue-pro?mall?模塊基本的相關(guān)腳本，有些模塊沒有腳本，估計(jì)功能還在設(shè)計(jì)，表也沒出，前端沒有接口請(qǐng)求，如果后續(xù)有更新再補(bǔ)上。
五、寫在后面
需要其他模塊開啟的請(qǐng)留言
?