From 6c002508ad1de1d5e5c5fc37ee7a42bdabadf6e7 Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Mon, 22 Nov 2021 10:16:37 +0800 Subject: [PATCH] 20211122 --- gc-shop/src/main/resources/sql | 14 ++++++++++++++ 1 files changed, 14 insertions(+), 0 deletions(-) diff --git a/gc-shop/src/main/resources/sql b/gc-shop/src/main/resources/sql index 0ae06e8..48eefe5 100644 --- a/gc-shop/src/main/resources/sql +++ b/gc-shop/src/main/resources/sql @@ -95,6 +95,20 @@ PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='首页弹窗表'; +ALTER TABLE `xzx_score_goods` +ADD COLUMN `quota_time` int(11) NULL COMMENT '限购次数' AFTER `present_price`; + +ALTER TABLE `xzx_jhy_order` +ADD COLUMN `unit_name` varchar(32) NULL COMMENT '单元栋' AFTER `username`; + +ALTER TABLE `xzx_jhy_order` +ADD COLUMN `house_number` varchar(32) NULL COMMENT '门牌号' AFTER `unit_name`; + +ALTER TABLE `xzx_score_order` +ADD COLUMN `is_finish_time` datetime NULL COMMENT '确认提货时间' AFTER `is_finish`; + + + -- Gitblit v1.9.1