From ce1fba3d0a107bd6ea79b3ad9ae47c63f57a0a13 Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Mon, 27 Sep 2021 20:12:18 +0800 Subject: [PATCH] 20210927 --- sql/xc_mall.sql | 16 ++++++++++++++++ 1 files changed, 16 insertions(+), 0 deletions(-) diff --git a/sql/xc_mall.sql b/sql/xc_mall.sql index e0215ce..04fa050 100644 --- a/sql/xc_mall.sql +++ b/sql/xc_mall.sql @@ -338,3 +338,19 @@ bank VARCHAR(255) COMMENT '开户行' , PRIMARY KEY (ID) ) COMMENT = '用户收款方式'; +alter table mall_goods_category add image varchar(500) null comment '分类图片'; + + +DROP TABLE IF EXISTS app_version; +create table app_version +( + id bigint auto_increment primary key, + version varchar(255) null comment '版本号', + content varchar(255) null comment '更新内容', + createtime datetime null comment '更新时间', + address varchar(255) null comment '下载地址', + type tinyint null comment '类型:1安卓,2苹果' +)comment '版本表'; + +alter table mall_order_info add pay_trade_no text null comment '支付交易单号'; + -- Gitblit v1.9.1