From 5e877bb95b18e9966787d937893c97024b9c30f2 Mon Sep 17 00:00:00 2001 From: mitao <2763622819@qq.com> Date: 星期四, 16 五月 2024 11:31:42 +0800 Subject: [PATCH] 提交数据库文件修改 --- sql/la_promotion.sql | 168 ++++++++++++++++++++++++++++---------------------------- 1 files changed, 84 insertions(+), 84 deletions(-) diff --git a/sql/la_promotion.sql b/sql/la_promotion.sql index 4fd547b..e46d60e 100644 --- a/sql/la_promotion.sql +++ b/sql/la_promotion.sql @@ -11,7 +11,7 @@ Target Server Version : 50718 (5.7.18-log) File Encoding : 65001 - Date: 16/05/2024 09:49:34 + Date: 16/05/2024 11:22:46 */ SET NAMES utf8mb4; @@ -22,26 +22,26 @@ -- ---------------------------- DROP TABLE IF EXISTS `t_coupon`; CREATE TABLE `t_coupon` ( - `id` bigint(20) NOT NULL, - `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '优惠券名称', - `coupon_type` tinyint(4) NOT NULL COMMENT '优惠券类型 1=满减券 2=代金券 3=折扣券', - `coupon_status` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态 0=已上架 1=已下架', - `full_reduction_amount` decimal(10, 0) NULL DEFAULT NULL COMMENT '满减金额，例如：满100元', - `reduction_amount` decimal(10, 0) NULL DEFAULT NULL COMMENT '减少金额，例如：减50元', - `voucher_amount` decimal(10, 0) NULL DEFAULT NULL COMMENT '代金券金额，例如：50元', - `discount_rate` int(11) NULL DEFAULT NULL COMMENT '折扣额度，例如：8折', - `max_discount` decimal(10, 0) NULL DEFAULT NULL COMMENT '最高可抵扣金额，例如：200元', - `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '优惠券说明', - `start_date` datetime NOT NULL COMMENT '有效期起', - `end_date` datetime NOT NULL COMMENT '有效期止', - `member_level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '会员等级，多等级以\",\"隔开', - `issued_quantity` int(11) NOT NULL COMMENT '发放张数', - `create_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', - `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', - `update_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', - `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', - `del_flag` tinyint(4) NULL DEFAULT 0 COMMENT '删除标志（0代表存在 1代表删除）', - PRIMARY KEY (`id`) USING BTREE + `id` bigint(20) NOT NULL, + `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '优惠券名称', + `coupon_type` tinyint(4) NOT NULL COMMENT '优惠券类型 1=满减券 2=代金券 3=折扣券', + `coupon_status` tinyint(4) NULL DEFAULT NULL COMMENT '状态 0=已上架 1=已下架', + `full_reduction_amount` decimal(10, 0) NULL DEFAULT NULL COMMENT '满减金额，例如：满100元', + `reduction_amount` decimal(10, 0) NULL DEFAULT NULL COMMENT '减少金额，例如：减50元', + `voucher_amount` decimal(10, 0) NULL DEFAULT NULL COMMENT '代金券金额，例如：50元', + `discount_rate` double NULL DEFAULT NULL COMMENT '折扣额度，例如：8折', + `max_discount` decimal(10, 0) NULL DEFAULT NULL COMMENT '最高可抵扣金额，例如：200元', + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '优惠券说明', + `start_date` datetime NOT NULL COMMENT '有效期起', + `end_date` datetime NOT NULL COMMENT '有效期止', + `member_level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '会员等级，多等级以\",\"隔开', + `issued_quantity` int(11) NOT NULL COMMENT '发放张数', + `create_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', + `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', + `update_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', + `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', + `del_flag` tinyint(4) NULL DEFAULT 0 COMMENT '删除标志（0代表存在 1代表删除）', + PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '优惠券表' ROW_FORMAT = Dynamic; -- ---------------------------- @@ -53,26 +53,26 @@ -- ---------------------------- DROP TABLE IF EXISTS `t_coupon_member`; CREATE TABLE `t_coupon_member` ( - `id` bigint(20) NOT NULL COMMENT '优惠券领取id', - `coupon_id` bigint(20) NOT NULL COMMENT '优惠券id', - `member_id` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '会员id', - `coupon_type` tinyint(4) NOT NULL COMMENT '优惠券类型 1=满减券 2=代金券 3=折扣券', - `coupon_status` tinyint(4) NULL DEFAULT NULL COMMENT '优惠券状态-1删除0已过期1已领取2已使用', - `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '优惠券名称', - `full_reduction_amount` decimal(10, 0) NULL DEFAULT NULL COMMENT '满减金额，例如：满100元', - `reduction_amount` decimal(10, 0) NULL DEFAULT NULL COMMENT '减少金额，例如：减50元', - `voucher_amount` decimal(10, 0) NULL DEFAULT NULL COMMENT '代金券金额，例如：50元', - `discount_rate` int(11) NULL DEFAULT NULL COMMENT '折扣额度，例如：8折', - `max_discount` decimal(10, 0) NULL DEFAULT NULL COMMENT '最高可抵扣金额，例如：200元', - `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '优惠券说明', - `start_date` datetime NOT NULL COMMENT '有效期起', - `end_date` datetime NOT NULL COMMENT '有效期止', - `create_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', - `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', - `update_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', - `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', - `del_flag` tinyint(4) NULL DEFAULT 0 COMMENT '删除标志（0代表存在 1代表删除）', - PRIMARY KEY (`id`) USING BTREE + `id` bigint(20) NOT NULL COMMENT '优惠券领取id', + `coupon_id` bigint(20) NOT NULL COMMENT '优惠券id', + `member_id` bigint(20) NOT NULL COMMENT '会员id', + `coupon_type` tinyint(4) NOT NULL COMMENT '优惠券类型 1=满减券 2=代金券 3=折扣券', + `coupon_status` tinyint(4) NULL DEFAULT NULL COMMENT '优惠券状态-1删除0已过期1已领取2已使用', + `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '优惠券名称', + `full_reduction_amount` decimal(10, 0) NULL DEFAULT NULL COMMENT '满减金额，例如：满100元', + `reduction_amount` decimal(10, 0) NULL DEFAULT NULL COMMENT '减少金额，例如：减50元', + `voucher_amount` decimal(10, 0) NULL DEFAULT NULL COMMENT '代金券金额，例如：50元', + `discount_rate` int(11) NULL DEFAULT NULL COMMENT '折扣额度，例如：8折', + `max_discount` decimal(10, 0) NULL DEFAULT NULL COMMENT '最高可抵扣金额，例如：200元', + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '优惠券说明', + `start_date` datetime NOT NULL COMMENT '有效期起', + `end_date` datetime NOT NULL COMMENT '有效期止', + `create_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', + `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', + `update_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', + `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', + `del_flag` tinyint(4) NULL DEFAULT 0 COMMENT '删除标志（0代表存在 1代表删除）', + PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '优惠券领取表' ROW_FORMAT = Dynamic; -- ---------------------------- @@ -84,17 +84,17 @@ -- ---------------------------- DROP TABLE IF EXISTS `t_promotion_banner`; CREATE TABLE `t_promotion_banner` ( - `id` bigint(20) NOT NULL COMMENT '轮播图id', - `banner_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '轮播图名称', - `banner_type` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '轮播图类型 1=商城首页 2=资讯首页', - `pic_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '图片', - `sort_num` int(11) NOT NULL COMMENT '排序 数字越大，权重越大', - `create_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', - `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', - `update_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', - `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', - `del_flag` tinyint(4) NULL DEFAULT 0 COMMENT '删除标志（0代表存在 1代表删除）', - PRIMARY KEY (`id`) USING BTREE + `id` bigint(20) NOT NULL COMMENT '轮播图id', + `banner_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '轮播图名称', + `banner_type` tinyint(4) NULL DEFAULT NULL COMMENT '轮播图类型 1=商城首页 2=资讯首页', + `pic_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '图片', + `sort_num` int(11) NOT NULL COMMENT '排序 数字越大，权重越大', + `create_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', + `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', + `update_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', + `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', + `del_flag` tinyint(4) NULL DEFAULT 0 COMMENT '删除标志（0代表存在 1代表删除）', + PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '轮播图表' ROW_FORMAT = Dynamic; -- ---------------------------- @@ -106,15 +106,15 @@ -- ---------------------------- DROP TABLE IF EXISTS `t_promotion_video`; CREATE TABLE `t_promotion_video` ( - `id` bigint(20) NOT NULL COMMENT '视频id', - `video_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '视频名称', - `video_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '视频链接', - `create_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', - `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', - `update_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', - `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', - `del_flag` tinyint(4) NULL DEFAULT 0 COMMENT '删除标志（0代表存在 1代表删除）', - PRIMARY KEY (`id`) USING BTREE + `id` bigint(20) NOT NULL COMMENT '视频id', + `video_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '视频名称', + `video_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '视频链接', + `create_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', + `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', + `update_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', + `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', + `del_flag` tinyint(4) NULL DEFAULT 0 COMMENT '删除标志（0代表存在 1代表删除）', + PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '视频表' ROW_FORMAT = Dynamic; -- ---------------------------- @@ -126,18 +126,18 @@ -- ---------------------------- DROP TABLE IF EXISTS `t_promotion_wish_list`; CREATE TABLE `t_promotion_wish_list` ( - `id` bigint(20) NOT NULL COMMENT '心愿求购id', - `goods_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品名称', - `expected_price` decimal(10, 0) NOT NULL COMMENT '期望价格', - `goods_image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '商品图片 [\'a\',\'b\',\'c\',\'d\',\'e\']', - `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注', - `replies` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '平台回复', - `create_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', - `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', - `update_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', - `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', - `del_flag` tinyint(4) NULL DEFAULT 0 COMMENT '删除标志（0代表存在 1代表删除）', - PRIMARY KEY (`id`) USING BTREE + `id` bigint(20) NOT NULL COMMENT '心愿求购id', + `goods_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品名称', + `expected_price` decimal(10, 0) NOT NULL COMMENT '期望价格', + `goods_image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '商品图片 [\'a\',\'b\',\'c\',\'d\',\'e\']', + `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注', + `replies` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '平台回复', + `create_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', + `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', + `update_by` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', + `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', + `del_flag` tinyint(4) NULL DEFAULT 0 COMMENT '删除标志（0代表存在 1代表删除）', + PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '心愿求购表' ROW_FORMAT = Dynamic; -- ---------------------------- @@ -149,17 +149,17 @@ -- ---------------------------- DROP TABLE IF EXISTS `undo_log`; CREATE TABLE `undo_log` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `branch_id` bigint(20) NOT NULL, - `xid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, - `context` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, - `rollback_info` longblob NOT NULL, - `log_status` int(11) NOT NULL, - `log_created` datetime NOT NULL, - `log_modified` datetime NOT NULL, - `ext` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, - PRIMARY KEY (`id`) USING BTREE, - UNIQUE INDEX `ux_undo_log`(`xid`, `branch_id`) USING BTREE + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `branch_id` bigint(20) NOT NULL, + `xid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, + `context` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, + `rollback_info` longblob NOT NULL, + `log_status` int(11) NOT NULL, + `log_created` datetime NOT NULL, + `log_modified` datetime NOT NULL, + `ext` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `ux_undo_log`(`xid`, `branch_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Gitblit v1.7.1