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 | 122 ++++++++++++++++++++++++++++++++++++++--
1 files changed, 116 insertions(+), 6 deletions(-)
diff --git a/java110-config/db/StoreService/create_table.sql b/java110-config/db/StoreService/create_table.sql
index 225bc05..2bde403 100644
--- a/java110-config/db/StoreService/create_table.sql
+++ b/java110-config/db/StoreService/create_table.sql
@@ -7,7 +7,7 @@
`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 COMMENT '搴楅摵绉嶇被锛屽搴旇〃 store_type',
+ 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鍧愭爣',
@@ -117,17 +117,43 @@
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',
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 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鍧愭爣',
@@ -139,7 +165,6 @@
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',
b_id VARCHAR(30) NOT NULL COMMENT '璁㈠崟ID',
attr_id VARCHAR(30) NOT NULL COMMENT '灞炴�d',
store_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
@@ -154,7 +179,6 @@
-- 鍟嗗簵鐓х墖
CREATE TABLE s_store_photo(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
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',
@@ -170,7 +194,6 @@
-- 鍟嗘埛璇佷欢
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',
@@ -188,12 +211,99 @@
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 '鍒涘缓鏃堕棿',
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