From 6135498971ee5a76621f9f574927bc45bd2ad36a Mon Sep 17 00:00:00 2001
From: wuxw <928255095@qq.com>
Date: 星期二, 07 五月 2019 00:33:42 +0800
Subject: [PATCH] 调整web服务docker文件
---
java110-config/db/ShopService/create_table.sql | 51 +++++++++++++++++++++++----------------------------
1 files changed, 23 insertions(+), 28 deletions(-)
diff --git a/java110-config/db/ShopService/create_table.sql b/java110-config/db/ShopService/create_table.sql
index fac4d8a..8973e6a 100644
--- a/java110-config/db/ShopService/create_table.sql
+++ b/java110-config/db/ShopService/create_table.sql
@@ -149,15 +149,13 @@
CREATE INDEX idx_business_shop_attr_param_b_id ON business_shop_attr_param(b_id);
-- 鍟嗗搧浼樻儬琛�
-create table business_shop_preferential(
- shop_preferential_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧ID',
- shop_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧ID',
+CREATE TABLE business_shop_preferential(
+ preferential_id VARCHAR(30) NOT NULL COMMENT '浼樻儬ID',
b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- original_price DECIMAL(10,2) not null comment '鍟嗗搧閿�鍞环锛屽啀娌℃湁浼樻儬鐨勬儏鍐典笅鍜屽敭浠锋槸涓�鑷寸殑',
- discount_rate decimal(1,2) not null default 1.00 comment '鍟嗗搧鎵撴姌鐜�',
- show_original_price varchar(2) not null default 'N' comment '鏄惁鏄剧ず鍘熶环锛孻鏄剧ず锛孨 涓嶆樉绀�',
- preferential_start_date not null comment '鍟嗗搧浼樻儬寮�濮嬫椂闂�',
- preferential_end_date date not null comment '鍟嗗搧浼樻儬缁撴潫鏃堕棿',
+ preferential_type varchar(10) not null default 'U' comment '浼樻儬绫诲瀷锛孶 鎵撴姌 锛� N 鏂扮敤鎴蜂紭鎯�',
+ preferential_value varchar(10) not null comment '鏍规嵁浼樻儬绫诲瀷濉啓鍊�',
+ preferential_start_date DATE NOT NULL COMMENT '鍟嗗搧浼樻儬寮�濮嬫椂闂�',
+ preferential_end_date DATE NOT NULL COMMENT '鍟嗗搧浼樻儬缁撴潫鏃堕棿',
`month` INT NOT NULL COMMENT '鏈堜唤',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
operate VARCHAR(3) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL'
@@ -176,8 +174,8 @@
PARTITION business_shop_preferential_11 VALUES LESS THAN (12),
PARTITION business_shop_preferential_12 VALUES LESS THAN (13)
);
-CREATE INDEX idx_business_shop_preferential_shop_id ON business_shop_preferential(shop_id);
CREATE INDEX idx_business_shop_preferential_b_id ON business_shop_preferential(b_id);
+
-- 鍟嗗搧鎻忚堪
create table business_shop_desc(
shop_desc_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧鎻忚堪ID',
@@ -253,22 +251,20 @@
CREATE INDEX idx_shop_attr_param_b_id ON s_shop_attr_param(b_id);
CREATE INDEX idx_shop_attr_param_shop_id ON s_shop_attr_param(shop_id);
--- 鍟嗗搧浼樻儬琛�
+
create table s_shop_preferential(
- shop_preferential_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧ID',
- shop_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧ID',
+ preferential_id VARCHAR(30) NOT NULL COMMENT '浼樻儬ID',
b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- original_price DECIMAL(10,2) not null comment '鍟嗗搧閿�鍞环锛屽啀娌℃湁浼樻儬鐨勬儏鍐典笅鍜屽敭浠锋槸涓�鑷寸殑',
- discount_rate decimal(1,2) not null default 1.00 comment '鍟嗗搧鎵撴姌鐜�',
- show_original_price varchar(2) not null default 'N' comment '鏄惁鏄剧ず鍘熶环锛孻鏄剧ず锛孨 涓嶆樉绀�',
- preferential_start_date not null comment '鍟嗗搧浼樻儬寮�濮嬫椂闂�',
+ preferential_type varchar(10) not null default 'U' comment '浼樻儬绫诲瀷锛孶 鎵撴姌 锛� N 鏂扮敤鎴蜂紭鎯�',
+ preferential_value varchar(10) not null comment '鏍规嵁浼樻儬绫诲瀷濉啓鍊�',
+ preferential_start_date date not null comment '鍟嗗搧浼樻儬寮�濮嬫椂闂�',
preferential_end_date date not null comment '鍟嗗搧浼樻儬缁撴潫鏃堕棿',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥',
- UNIQUE KEY (shop_preferential_id)
+ UNIQUE KEY (preferential_id)
);
CREATE INDEX idx_shop_preferential_b_id ON s_shop_preferential(b_id);
-CREATE INDEX idx_shop_preferential_shop_id ON s_shop_preferential(shop_id);
+
-- 鍟嗗搧鎻忚堪
create table s_shop_desc(
shop_desc_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧鎻忚堪ID',
@@ -291,11 +287,11 @@
photo VARCHAR(100) NOT NULL COMMENT '鐓х墖',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥',
- UNIQUE KEY (store_photo_id)
+ UNIQUE KEY (shop_photo_id)
);
-CREATE INDEX idx_shop_photo_b_id ON s_store_photo(b_id);
-CREATE INDEX idx_shop_photo_shop_id ON s_store_photo(shop_id);
-CREATE INDEX idx_shop_photo_shop_photo_id ON s_store_photo(shop_photo_id);
+CREATE INDEX idx_shop_photo_b_id ON s_shop_photo(b_id);
+CREATE INDEX idx_shop_photo_shop_id ON s_shop_photo(shop_id);
+CREATE INDEX idx_shop_photo_shop_photo_id ON s_shop_photo(shop_photo_id);
create table s_shop_catalog(
catalog_id varchar(30) not null comment '鐩綍ID',
@@ -304,7 +300,6 @@
`name` varchar(100) not null comment '鐩綍鍚嶇О',
level varchar(2) not null comment '鐩綍绛夌骇',
parent_catalog_id varchar(30) not null default '-1' comment '鐖剁洰褰旾D锛屼竴绾х洰褰曞垯鍐�-1',
- `month` INT NOT NULL COMMENT '鏈堜唤',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥',
UNIQUE KEY (catalog_id)
@@ -315,15 +310,15 @@
-- 鍟嗗搧璐拱璁板綍
-create table s_buy_shop(
- buy_id varchar(30) not null comment '璐拱ID',
+CREATE TABLE s_buy_shop(
+ buy_id VARCHAR(30) NOT NULL COMMENT '璐拱ID',
b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
shop_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧ID',
- buy_count DECIMAL(10,0) not null default 1 comment '璐拱鍟嗗搧鏁�',
+ buy_count DECIMAL(10,0) NOT NULL DEFAULT 1 COMMENT '璐拱鍟嗗搧鏁�',
`month` INT NOT NULL COMMENT '鏈堜唤',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥',
- UNIQUE KEY (buy_id)
+ UNIQUE KEY (buy_id,`month`)
)
PARTITION BY RANGE (`month`) (
PARTITION buy_shop_1 VALUES LESS THAN (2),
@@ -350,7 +345,7 @@
`month` INT NOT NULL COMMENT '鏈堜唤',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥',
- UNIQUE KEY (attr_id)
+ UNIQUE KEY (attr_id,`month`)
)
PARTITION BY RANGE (`month`) (
PARTITION buy_shop_attr_1 VALUES LESS THAN (2),
--
Gitblit v1.8.0