From 0894b9328ae1c11146175b492ae348bbd4b13404 Mon Sep 17 00:00:00 2001
From: wuxw <928255095@qq.com>
Date: 星期一, 29 四月 2019 16:42:32 +0800
Subject: [PATCH] 加入统一消息提示功能 请用 vc.messege('错误内容')
---
java110-config/db/StoreService/create_table.sql | 269 ++++++++++++++++++++++++++++++++++++++++++++++-------
1 files changed, 232 insertions(+), 37 deletions(-)
diff --git a/java110-config/db/StoreService/create_table.sql b/java110-config/db/StoreService/create_table.sql
index 1bc87f2..2bde403 100644
--- a/java110-config/db/StoreService/create_table.sql
+++ b/java110-config/db/StoreService/create_table.sql
@@ -1,19 +1,36 @@
-- store 琛� 杩囩▼琛�
-create table business_store(
+CREATE TABLE business_store(
store_id VARCHAR(30) NOT NULL COMMENT '鍟嗗簵ID',
b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
- name varchar(100) not null comment '搴楅摵鍚嶇О',
- address varchar(200) not null comment '搴楅摵鍦板潃',
- tel varchar(11) not null comment '鐢佃瘽',
- store_type_cd varchar(10) not null commnet '搴楅摵绉嶇被锛屽搴旇〃 store_type',
- nearby_landmarks varchar(200) comment '鍦版爣锛屽鐜嬪簻浜曞寳60绫�',
- map_x varchar(20) not null comment '鍦板尯 x鍧愭爣',
- map_y varchar(20) not null comment '鍦板尯 y鍧愭爣',
+ `name` VARCHAR(100) NOT NULL COMMENT '搴楅摵鍚嶇О',
+ address VARCHAR(200) NOT NULL COMMENT '搴楅摵鍦板潃',
+ tel VARCHAR(11) NOT NULL COMMENT '鐢佃瘽',
+ store_type_cd VARCHAR(12) NOT NULL COMMENT '搴楅摵绉嶇被锛屽搴旇〃 store_type',
+ nearby_landmarks VARCHAR(200) COMMENT '鍦版爣锛屽鐜嬪簻浜曞寳60绫�',
+ map_x VARCHAR(20) NOT NULL COMMENT '鍦板尯 x鍧愭爣',
+ map_y VARCHAR(20) NOT NULL COMMENT '鍦板尯 y鍧愭爣',
+ `month` INT NOT NULL COMMENT '鏈堜唤',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
operate VARCHAR(3) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL'
+)
+PARTITION BY RANGE (`month`) (
+ PARTITION business_store_1 VALUES LESS THAN (2),
+ PARTITION business_store_2 VALUES LESS THAN (3),
+ PARTITION business_store_3 VALUES LESS THAN (4),
+ PARTITION business_store_4 VALUES LESS THAN (5),
+ PARTITION business_store_5 VALUES LESS THAN (6),
+ PARTITION business_store_6 VALUES LESS THAN (7),
+ PARTITION business_store_7 VALUES LESS THAN (8),
+ PARTITION business_store_8 VALUES LESS THAN (9),
+ PARTITION business_store_9 VALUES LESS THAN (10),
+ PARTITION business_store_10 VALUES LESS THAN (11),
+ PARTITION business_store_11 VALUES LESS THAN (12),
+ PARTITION business_store_12 VALUES LESS THAN (13)
);
+CREATE INDEX idx_business_store_store_id ON business_store(store_id);
+CREATE INDEX idx_business_store_b_id ON business_store(b_id);
create table business_store_attr(
b_id VARCHAR(30) NOT NULL COMMENT '璁㈠崟ID',
@@ -21,20 +38,54 @@
store_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
spec_cd VARCHAR(12) NOT NULL COMMENT '瑙勬牸id,鍙傝�僺pec琛�',
value VARCHAR(50) 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'
+)
+partition BY RANGE (`month`) (
+ partition business_store_attr_1 VALUES LESS THAN (2),
+ partition business_store_attr_2 VALUES LESS THAN (3),
+ partition business_store_attr_3 VALUES LESS THAN (4),
+ partition business_store_attr_4 VALUES LESS THAN (5),
+ partition business_store_attr_5 VALUES LESS THAN (6),
+ partition business_store_attr_6 VALUES LESS THAN (7),
+ partition business_store_attr_7 VALUES LESS THAN (8),
+ partition business_store_attr_8 VALUES LESS THAN (9),
+ partition business_store_attr_9 VALUES LESS THAN (10),
+ partition business_store_attr_10 VALUES LESS THAN (11),
+ partition business_store_attr_11 VALUES LESS THAN (12),
+ partition business_store_attr_12 VALUES LESS THAN (13)
);
+CREATE INDEX idx_business_store_attr_store_id ON business_store_attr(store_id);
+CREATE INDEX idx_business_store_attr_b_id ON business_store_attr(b_id);
-- 鍟嗗簵鐓х墖
-create table business_store_photo(
- store_photo_id varchar(30) not null commnet '鍟嗘埛鐓х墖ID',
+CREATE TABLE business_store_photo(
+ store_photo_id VARCHAR(30) NOT NULL COMMENT '鍟嗘埛鐓х墖ID',
b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
store_id VARCHAR(30) NOT NULL COMMENT '鍟嗗簵ID',
- store_photo_type_cd varchar(12) not null comment '鍟嗘埛鐓х墖绫诲瀷,T 闂ㄥご鐓� I 鍐呮櫙鐓�',
- photo varchar(100) not null comment '鐓х墖',
+ store_photo_type_cd VARCHAR(12) NOT NULL COMMENT '鍟嗘埛鐓х墖绫诲瀷,T 闂ㄥご鐓� I 鍐呮櫙鐓�',
+ photo VARCHAR(100) 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'
+)
+PARTITION BY RANGE (`month`) (
+ PARTITION business_store_photo_1 VALUES LESS THAN (2),
+ PARTITION business_store_photo_2 VALUES LESS THAN (3),
+ PARTITION business_store_photo_3 VALUES LESS THAN (4),
+ PARTITION business_store_photo_4 VALUES LESS THAN (5),
+ PARTITION business_store_photo_5 VALUES LESS THAN (6),
+ PARTITION business_store_photo_6 VALUES LESS THAN (7),
+ PARTITION business_store_photo_7 VALUES LESS THAN (8),
+ PARTITION business_store_photo_8 VALUES LESS THAN (9),
+ PARTITION business_store_photo_9 VALUES LESS THAN (10),
+ PARTITION business_store_photo_10 VALUES LESS THAN (11),
+ PARTITION business_store_photo_11 VALUES LESS THAN (12),
+ PARTITION business_store_photo_12 VALUES LESS THAN (13)
);
+CREATE INDEX idx_business_store_photo_store_id ON business_store_photo(store_id);
+CREATE INDEX idx_business_store_photo_b_id ON business_store_photo(b_id);
-- 鍟嗘埛璇佷欢
create table business_store_cerdentials(
store_cerdentials_id varchar(30) not null comment '鍟嗘埛璇佷欢ID',
@@ -42,73 +93,217 @@
store_id VARCHAR(30) NOT NULL COMMENT '鍟嗗簵ID',
credentials_cd varchar(12) not null comment '璇佷欢绫诲瀷锛屽搴斾簬 credentials琛�',
value varchar(50) not null comment '璇佷欢鍙风爜',
- validity_period TIMESTAMP NOT NULL COMMENT '鏈夋晥鏈燂紝濡傛灉鏄暱鏈熸湁鏁� 鍐欐垚 3000/1/1',
+ validity_period DATE NOT NULL COMMENT '鏈夋晥鏈燂紝濡傛灉鏄暱鏈熸湁鏁� 鍐欐垚 3000/1/1',
positive_photo varchar(100) comment '姝ｉ潰鐓х墖',
negative_photo varchar(100) comment '鍙嶉潰鐓х墖',
+ `month` INT NOT NULL comment '鏈堜唤',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
operate VARCHAR(3) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL'
+)
+partition BY RANGE (`month`) (
+ partition business_store_cerdentials_1 VALUES LESS THAN (2),
+ partition business_store_cerdentials_2 VALUES LESS THAN (3),
+ partition business_store_cerdentials_3 VALUES LESS THAN (4),
+ partition business_store_cerdentials_4 VALUES LESS THAN (5),
+ partition business_store_cerdentials_5 VALUES LESS THAN (6),
+ partition business_store_cerdentials_6 VALUES LESS THAN (7),
+ partition business_store_cerdentials_7 VALUES LESS THAN (8),
+ partition business_store_cerdentials_8 VALUES LESS THAN (9),
+ partition business_store_cerdentials_9 VALUES LESS THAN (10),
+ partition business_store_cerdentials_10 VALUES LESS THAN (11),
+ partition business_store_cerdentials_11 VALUES LESS THAN (12),
+ partition business_store_cerdentials_12 VALUES LESS THAN (13)
);
+CREATE INDEX idx_business_store_cerdentials_store_id ON business_store_cerdentials(store_id);
+CREATE INDEX idx_business_store_cerdentials_b_id ON business_store_cerdentials(b_id);
+
+-- 鍟嗘埛鎴愬憳
+create table business_member_store(
+ member_store_id varchar(30) not null comment 'ID',
+ b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
+ store_id VARCHAR(30) NOT NULL COMMENT '鍟嗗簵ID',
+ member_id varchar(50) not null comment '鍟嗘埛鎴愬憳ID',
+ `month` INT NOT NULL comment '鏈堜唤',
+ create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ operate VARCHAR(3) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL'
+)
+partition BY RANGE (`month`) (
+ partition business_member_store_1 VALUES LESS THAN (2),
+ partition business_member_store_2 VALUES LESS THAN (3),
+ partition business_member_store_3 VALUES LESS THAN (4),
+ partition business_member_store_4 VALUES LESS THAN (5),
+ partition business_member_store_5 VALUES LESS THAN (6),
+ partition business_member_store_6 VALUES LESS THAN (7),
+ partition business_member_store_7 VALUES LESS THAN (8),
+ partition business_member_store_8 VALUES LESS THAN (9),
+ partition business_member_store_9 VALUES LESS THAN (10),
+ partition business_member_store_10 VALUES LESS THAN (11),
+ partition business_member_store_11 VALUES LESS THAN (12),
+ partition business_member_store_12 VALUES LESS THAN (13)
+);
+CREATE INDEX idx_business_member_store_store_id ON business_member_store(store_id);
+CREATE INDEX idx_business_member_store_b_id ON business_member_store(b_id);
-create table s_store(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
+CREATE TABLE s_store(
store_id VARCHAR(30) NOT NULL COMMENT '鍟嗗簵ID',
b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
- name varchar(100) not null comment '搴楅摵鍚嶇О',
- address varchar(200) not null comment '搴楅摵鍦板潃',
- tel varchar(11) not null comment '鐢佃瘽',
- store_type varchar(10) not null commnet '搴楅摵绉嶇被',
- nearby_landmarks varchar(200) comment '鍦版爣锛屽鐜嬪簻浜曞寳60绫�',
- map_x varchar(20) not null comment '鍦板尯 x鍧愭爣',
- map_y varchar(20) not null comment '鍦板尯 y鍧愭爣',
+ `name` VARCHAR(100) NOT NULL COMMENT '搴楅摵鍚嶇О',
+ address VARCHAR(200) NOT NULL COMMENT '搴楅摵鍦板潃',
+ tel VARCHAR(11) NOT NULL COMMENT '鐢佃瘽',
+ store_type_cd VARCHAR(12) NOT NULL COMMENT '搴楅摵绉嶇被',
+ nearby_landmarks VARCHAR(200) COMMENT '鍦版爣锛屽鐜嬪簻浜曞寳60绫�',
+ map_x VARCHAR(20) NOT NULL COMMENT '鍦板尯 x鍧愭爣',
+ map_y VARCHAR(20) NOT NULL COMMENT '鍦板尯 y鍧愭爣',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- status_cd VARCHAR(2) NOT NULL default '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥'
+ status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥',
+ UNIQUE KEY (store_id)
);
+CREATE INDEX idx_store_b_id ON s_store(b_id);
+CREATE UNIQUE INDEX idx_store_store_id ON s_store(store_id);
-create table s_store_attr(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
+CREATE TABLE s_store_attr(
b_id VARCHAR(30) NOT NULL COMMENT '璁㈠崟ID',
attr_id VARCHAR(30) NOT NULL COMMENT '灞炴�d',
store_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
spec_cd VARCHAR(12) NOT NULL COMMENT '瑙勬牸id,鍙傝�僺pec琛�',
- value VARCHAR(50) NOT NULL COMMENT '灞炴�у��',
+ VALUE VARCHAR(50) 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澶辨晥'
+ status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥',
+ UNIQUE KEY (attr_id)
);
+CREATE INDEX idx_store_attr_b_id ON s_store_attr(b_id);
+CREATE INDEX idx_store_attr_store_id ON s_store_attr(store_id);
-- 鍟嗗簵鐓х墖
-create table s_store_photo(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- store_photo_id varchar(30) not null commnet '鍟嗘埛鐓х墖ID',
+CREATE TABLE s_store_photo(
+ store_photo_id VARCHAR(30) NOT NULL COMMENT '鍟嗘埛鐓х墖ID',
b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
store_id VARCHAR(30) NOT NULL COMMENT '鍟嗗簵ID',
- store_photo_type_cd varchar(12) not null comment '鍟嗘埛鐓х墖绫诲瀷,T 闂ㄥご鐓� I 鍐呮櫙鐓�',
- photo varchar(100) not null comment '鐓х墖',
+ store_photo_type_cd VARCHAR(12) NOT NULL COMMENT '鍟嗘埛鐓х墖绫诲瀷,T 闂ㄥご鐓� I 鍐呮櫙鐓�',
+ 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澶辨晥'
+ status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥',
+ UNIQUE KEY (store_photo_id)
);
+CREATE INDEX idx_store_photo_b_id ON s_store_photo(b_id);
+CREATE INDEX idx_store_photo_store_id ON s_store_photo(store_id);
+CREATE INDEX idx_store_photo_store_photo_id ON s_store_photo(store_photo_id);
+
-- 鍟嗘埛璇佷欢
create table s_store_cerdentials(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
store_cerdentials_id varchar(30) not null comment '鍟嗘埛璇佷欢ID',
b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
store_id VARCHAR(30) NOT NULL COMMENT '鍟嗗簵ID',
credentials_cd varchar(12) not null comment '璇佷欢绫诲瀷锛屽搴斾簬 credentials琛�',
value varchar(50) not null comment '璇佷欢鍙风爜',
- validity_period TIMESTAMP NOT NULL COMMENT '鏈夋晥鏈燂紝濡傛灉鏄暱鏈熸湁鏁� 鍐欐垚 3000/1/1',
+ validity_period DATE NOT NULL COMMENT '鏈夋晥鏈燂紝濡傛灉鏄暱鏈熸湁鏁� 鍐欐垚 3000/1/1',
positive_photo varchar(100) comment '姝ｉ潰鐓х墖',
negative_photo varchar(100) comment '鍙嶉潰鐓х墖',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- status_cd VARCHAR(2) NOT NULL default '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥'
+ status_cd VARCHAR(2) NOT NULL default '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥',
+ unique KEY (store_cerdentials_id)
);
+
+CREATE INDEX idx_store_cerdentials_b_id ON s_store_cerdentials(b_id);
+CREATE INDEX idx_store_cerdentials_store_id ON s_store_cerdentials(store_id);
+CREATE INDEX idx_store_cerdentials_store_cerdentials_id ON s_store_cerdentials(store_cerdentials_id);
+
+-- 鍟嗘埛鎴愬憳
+create table s_member_store(
+ member_store_id varchar(30) not null comment 'ID',
+ b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
+ store_id VARCHAR(30) NOT NULL COMMENT '鍟嗗簵ID',
+ member_id varchar(50) not null comment '鍟嗘埛鎴愬憳ID',
+ create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ status_cd VARCHAR(2) NOT NULL default '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥',
+ unique KEY (member_store_id)
+)
+CREATE INDEX idx_s_member_store_store_id ON s_member_store(store_id);
+CREATE INDEX idx_s_member_store_b_id ON s_member_store(b_id);
+-- 鐗╀笟璐� 鍋滆溅璐�
+CREATE TABLE s_store_fee(
+ fee_id VARCHAR(30) NOT NULL COMMENT 'ID',
+ b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
+ store_id VARCHAR(30) NOT NULL COMMENT '鍟嗗簵ID',
+ user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
+ fee_type_cd VARCHAR(10) NOT NULL COMMENT '璐圭敤绫诲瀷,鐗╀笟璐癸紝鍋滆溅璐� 璇锋煡鐪媠tore_fee_type琛�',
+ fee_money VARCHAR(20) NOT NULL COMMENT '璐圭敤閲戦',
+ fee_time VARCHAR(10) NOT NULL COMMENT '璐圭敤鍛ㄦ湡锛屼竴涓湀锛屽崐骞达紝鎴栦竴骞� 璇锋煡鐪媠tore_fee_time琛�',
+ create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ start_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '寮�濮嬫椂闂�',
+ end_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '缁撴潫鏃堕棿',
+ status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥',
+ UNIQUE KEY (fee_id)
+);
+CREATE INDEX idx_store_fee_fee_id ON s_store_fee(fee_id);
+CREATE INDEX idx_store_fee_b_id ON s_store_fee(b_id);
+
+CREATE TABLE s_store_house(
+ house_id VARCHAR(30) NOT NULL COMMENT 'ID',
+ house_num VARCHAR(30) NOT NULL COMMENT '闂ㄧ墝鍙�',
+ house_name VARCHAR(50) NOT NULL COMMENT '浣忔埛鍚嶇О',
+ house_phone VARCHAR(11) COMMENT '浣忔埛鑱旂郴鍙风爜',
+ house_area VARCHAR(30) NOT NULL COMMENT '鎴垮眿闈㈢Н',
+ fee_type_cd VARCHAR(10) NOT NULL COMMENT '璐圭敤绫诲瀷 store_fee_type琛�',
+ fee_price VARCHAR(30) NOT NULL COMMENT '璐圭敤鍗曚环',
+ user_id VARCHAR(10) NOT NULL COMMENT '褰曞叆浜�',
+ create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
+ status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥',
+ UNIQUE KEY (house_id)
+);
+
+CREATE TABLE s_store_house_attr(
+ attr_id VARCHAR(30) NOT NULL COMMENT '灞炴�d',
+ house_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
+ spec_cd VARCHAR(12) NOT NULL COMMENT '瑙勬牸id,鍙傝�僺pec琛�',
+ VALUE VARCHAR(50) 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)
+);
+
-- 搴楅摵绉嶇被
create table store_type(
id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
+ domain varchar(20) not null comment '鍩�',
store_type_cd VARCHAR(12) NOT NULL COMMENT '搴楅摵缂栫爜',
`name` VARCHAR(50) NOT NULL COMMENT '搴楅摵绉嶇被缂栫爜',
description VARCHAR(200) COMMENT '鎻忚堪',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿'
+ create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ unique KEY (store_type_cd)
);
+
+-- 鏀惰垂绫诲瀷琛�
+CREATE TABLE store_fee_type(
+ id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
+ domain VARCHAR(20) NOT NULL COMMENT '鍩�',
+ fee_type_cd VARCHAR(12) NOT NULL COMMENT '鏀惰垂绫诲瀷 鐗╀笟璐� 鍋滆溅璐圭瓑',
+ `name` VARCHAR(50) NOT NULL COMMENT '鏀惰垂绫诲瀷缂栫爜',
+ description VARCHAR(200) COMMENT '鎻忚堪',
+ create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ UNIQUE KEY (fee_type_cd)
+);
+
+-- 鏀惰垂鍛ㄦ湡琛�
+CREATE TABLE store_fee_time(
+ id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
+ domain VARCHAR(20) NOT NULL COMMENT '鍩�',
+ fee_time_cd VARCHAR(12) NOT NULL COMMENT '璐圭敤鍛ㄦ湡缂栫爜 涓�骞达紝鍗婂勾绛�',
+ `name` VARCHAR(50) NOT NULL COMMENT '鏀惰垂绫诲瀷缂栫爜',
+ description VARCHAR(200) COMMENT '鎻忚堪',
+ create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ UNIQUE KEY (fee_time_cd)
+);
+
+insert into store_type(domain,store_type_cd,name,description) values('CORE_STROE','870000000001','灏忓尯','灏忓尯');
+insert into store_type(domain,store_type_cd,name,description) values('CORE_STROE','870000000002','鐗╀笟','鐗╀笟');
+insert into store_type(domain,store_type_cd,name,description) values('CORE_STROE','870000000003','鐗╂祦鍏徃','鐗╂祦鍏徃');
+insert into store_type(domain,store_type_cd,name,description) values('APP_VIEW','870181027001','楗簵','楗簵');
+insert into store_type(domain,store_type_cd,name,description) values('APP_VIEW','870181027002','椁愬巺','椁愬巺');
+insert into store_type(domain,store_type_cd,name,description) values('APP_VIEW','870181027003','鐏攨搴�','鐏攨搴�');
+insert into store_type(domain,store_type_cd,name,description) values('APP_VIEW','870181027004','瓒呭競','瓒呭競');
--
Gitblit v1.8.0