From d593184d6d517aa3afd0ae6d6e40a0d0e1584d87 Mon Sep 17 00:00:00 2001 From: Helius <wangdoubleone@gmail.com> Date: Thu, 23 Sep 2021 16:51:57 +0800 Subject: [PATCH] Merge branch 'master' of http://120.27.238.55:7000/r/xc-mall --- sql/xc_mall.sql | 35 +++++++++++++++++++++++++++++++++++ 1 files changed, 35 insertions(+), 0 deletions(-) diff --git a/sql/xc_mall.sql b/sql/xc_mall.sql index 736c82c..5f99d0f 100644 --- a/sql/xc_mall.sql +++ b/sql/xc_mall.sql @@ -241,3 +241,38 @@ PRIMARY KEY (ID) ) COMMENT = '物流信息表'; +alter table mall_order_info add receiving_time datetime null comment '收货时间'; + +DROP TABLE IF EXISTS mall_order_refund; +CREATE TABLE mall_order_refund( + REVISION INT COMMENT '乐观锁' , + CREATED_BY VARCHAR(32) COMMENT '创建人' , + CREATED_TIME DATETIME COMMENT '创建时间' , + UPDATED_BY VARCHAR(32) COMMENT '更新人' , + UPDATED_TIME DATETIME COMMENT '更新时间' , + ID BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键' , + member_id BIGINT COMMENT '用户ID' , + order_id BIGINT COMMENT '订单ID' , + reason VARCHAR(255) COMMENT '退款原因' , + desp TEXT COMMENT '描述' , + remark TEXT COMMENT '备注' , + status INT COMMENT '状态;1-已申请2-同意退款3-驳回退款4-已提交物流信息5-已退款' , + express_no VARCHAR(255) COMMENT '物流单号' , + express_com VARCHAR(255) COMMENT '物流公司' , + PRIMARY KEY (ID) +) COMMENT = '订单退款'; + +DROP TABLE IF EXISTS mall_order_refund_operation; +CREATE TABLE mall_order_refund_operation( + REVISION INT COMMENT '乐观锁' , + CREATED_BY VARCHAR(32) COMMENT '创建人' , + CREATED_TIME DATETIME COMMENT '创建时间' , + UPDATED_BY VARCHAR(32) COMMENT '更新人' , + UPDATED_TIME DATETIME COMMENT '更新时间' , + ID BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键' , + refund_id BIGINT COMMENT '退款ID' , + order_id BIGINT COMMENT '订单ID' , + content TEXT COMMENT '操作内容' , + PRIMARY KEY (ID) +) COMMENT = '退款操作明细'; + -- Gitblit v1.9.1