From 6c1a535a157864b177c17aa14afcda9ad92a2a9b Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Wed, 25 Aug 2021 15:08:23 +0800 Subject: [PATCH] 20210825 --- gc-shop/src/main/resources/sql | 84 +++++++++++++++++++++++++++++++++++++++++ 1 files changed, 83 insertions(+), 1 deletions(-) diff --git a/gc-shop/src/main/resources/sql b/gc-shop/src/main/resources/sql index 56b7e26..0ae06e8 100644 --- a/gc-shop/src/main/resources/sql +++ b/gc-shop/src/main/resources/sql @@ -23,4 +23,86 @@ MODIFY COLUMN `del_flag` smallint(2) NULL DEFAULT NULL COMMENT '删除标识0 正常 1已删除 ' AFTER `CREATED_TIME`; ALTER TABLE `xzx_score_order_details` -MODIFY COLUMN `del_flag` smallint(2) NULL DEFAULT NULL COMMENT '删除标识0 正常 1已删除 ' AFTER `CREATED_TIME`; \ No newline at end of file +MODIFY COLUMN `del_flag` smallint(2) NULL DEFAULT NULL COMMENT '删除标识0 正常 1已删除 ' AFTER `CREATED_TIME`; + +ALTER TABLE `xzx_score_goods` +CHANGE COLUMN `gq_end_time` `qg_end_time` datetime NULL DEFAULT NULL COMMENT '抢购结束时间' AFTER `qg_start_time`; + +ALTER TABLE `xzx_score_goods` +MODIFY COLUMN `del_flag` smallint(2) NULL DEFAULT 0 COMMENT '删除标识0 正常 1已删除 ' AFTER `CREATED_TIME`; + +ALTER TABLE `xzx_score_goods_category` +MODIFY COLUMN `del_flag` smallint(2) NULL DEFAULT 0 COMMENT '删除标识0 正常 1已删除 ' AFTER `CREATED_TIME`; + +ALTER TABLE `xzx_score_goods_sku` +MODIFY COLUMN `del_flag` smallint(2) NULL DEFAULT 0 COMMENT '删除标识0 正常 1已删除 ' AFTER `CREATED_TIME`; + +ALTER TABLE `xzx_score_goods_style` +MODIFY COLUMN `del_flag` smallint(2) NULL DEFAULT 0 COMMENT '删除标识0 正常 1已删除 ' AFTER `CREATED_TIME`; + +ALTER TABLE `xzx_score_order` +MODIFY COLUMN `del_flag` smallint(2) NULL DEFAULT 0 COMMENT '删除标识0 正常 1已删除 ' AFTER `CREATED_TIME`; + +ALTER TABLE `xzx_score_order_details` +MODIFY COLUMN `del_flag` smallint(2) NULL DEFAULT 0 COMMENT '删除标识0 正常 1已删除 ' AFTER `CREATED_TIME`; + +ALTER TABLE `xzx_score_goods` +ADD COLUMN `category_id` bigint(20) NULL COMMENT '分类ID' AFTER `price_range`, +ADD COLUMN `category_name` varchar(100) NULL COMMENT '分类名称' AFTER `category_id`; + +ALTER TABLE `xzx_score_order` +ADD COLUMN `voucher_img` varchar(500) NULL COMMENT '凭证' AFTER `remark`; + +ALTER TABLE `xzx_user_info` +MODIFY COLUMN `mobile_phone` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '手机号码' AFTER `user_id`; + +ALTER TABLE `xzx_user_info` +MODIFY COLUMN `nick_name` varchar(100) CHARACTER SET utf8mb4 NULL DEFAULT NULL AFTER `name`; + + +ALTER TABLE `xzx_score_order` +ADD COLUMN `is_finish` int(11) NULL DEFAULT 2 COMMENT '后台确认提货 1：是 2：否' AFTER `remark`; + +ALTER TABLE `xzx_sys_news` +DROP COLUMN `del_flag`, +ADD COLUMN `del_flag` int(1) NULL DEFAULT 0 COMMENT '删除0:未删除，1:删除' AFTER `picture`; + +ALTER TABLE `xzx_sys_news` +ADD COLUMN `sort` int(5) NULL DEFAULT 10 COMMENT '排序' AFTER `del_flag`; + +ALTER TABLE `xzx_sys_news` +ADD COLUMN `status` int(1) NULL DEFAULT 1 COMMENT '状态 1：未发布 2：已发布' AFTER `sort`; + +ALTER TABLE `xzx_sys_banner` +ADD COLUMN `status` int(1) NULL DEFAULT 1 COMMENT '状态 1：未上架 2：已上架' AFTER `city_id`; + +ALTER TABLE `xzx_user_redpaper_rule` +MODIFY COLUMN `rule_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规则类型：1：红包规则，2：分享分利规则 3阶梯 4推广 5重量返利 7提成 8提佣 9积分规则 10邀请奖励规则' AFTER `share_ratio`; + + +CREATE TABLE `xzx_sys_popup` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `area` int(11) DEFAULT NULL COMMENT '广告区域 1:首页2：其他', + `name` varchar(100) DEFAULT NULL COMMENT '广告名称', + `aims` int(11) DEFAULT NULL COMMENT '弹窗人群：1:新用戶 2：老用戶', + `rules` int(11) DEFAULT NULL COMMENT '弹窗规则：1:每日首次登录 2：每次登录', + `is_out` int(11) DEFAULT NULL COMMENT '是否跳转 1：是 2：否', + `out_text` varchar(500) DEFAULT NULL COMMENT '内容链接', + `start_time` varchar(100) DEFAULT NULL COMMENT '开始日期', + `end_time` varchar(100) DEFAULT NULL COMMENT '结束日期', + `img` varchar(500) DEFAULT NULL COMMENT '上传图片', + `state` int(11) DEFAULT NULL COMMENT '是否上架 1:是2：否', + PRIMARY KEY (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='首页弹窗表'; + + + + + + + + + + + + -- Gitblit v1.9.1