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/OrderService/create_table.sql | 65 ++++++++++++++++++++++++++++++--
1 files changed, 60 insertions(+), 5 deletions(-)
diff --git a/java110-config/db/OrderService/create_table.sql b/java110-config/db/OrderService/create_table.sql
index 09ed801..ed052bb 100644
--- a/java110-config/db/OrderService/create_table.sql
+++ b/java110-config/db/OrderService/create_table.sql
@@ -32,7 +32,7 @@
b_id VARCHAR(30) NOT NULL UNIQUE COMMENT '涓氬姟Id',
o_id VARCHAR(30) NOT NULL COMMENT '璁㈠崟ID',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- business_type_cd VARCHAR(4) NOT NULL COMMENT '涓氬姟椤圭被鍨嬶紝鍙傝�僣_business_type琛�',
+ business_type_cd VARCHAR(12) NOT NULL COMMENT '涓氬姟椤圭被鍨嬶紝鍙傝�僣_business_type琛�',
finish_time DATE COMMENT '瀹屾垚鏃堕棿',
remark VARCHAR(200) COMMENT '澶囨敞',
status_cd VARCHAR(2) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛�'
@@ -85,13 +85,66 @@
CREATE TABLE c_business_type(
id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- business_type_cd VARCHAR(4) NOT NULL UNIQUE COMMENT '涓氬姟椤圭被鍨�',
+ business_type_cd VARCHAR(12) NOT NULL UNIQUE 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 (business_type_cd)
);
insert into c_business_type(business_type_cd,name,description) values('DO','鎾ゅ崟','浣滃簾璁㈠崟');
+insert into c_business_type(business_type_cd,name,description) values('100100030001','淇濆瓨鐢ㄦ埛淇℃伅','淇濆瓨鐢ㄦ埛淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('100100030002','淇濆瓨鐢ㄦ埛鍦板潃淇℃伅','淇濆瓨鐢ㄦ埛鍦板潃淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('100100030003','鐢ㄦ埛鎵撴爣','鐢ㄦ埛鎵撴爣');
+insert into c_business_type(business_type_cd,name,description) values('100100030004','鐢ㄦ埛璇佷欢','淇濆瓨鐢ㄦ埛鍦板潃淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('100100040001','淇敼鐢ㄦ埛淇℃伅','淇敼鐢ㄦ埛淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('100100040002','鍋滅敤鐢ㄦ埛淇℃伅','鍋滅敤鐢ㄦ埛淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('100100040003','鎭㈠鐢ㄦ埛淇℃伅','鎭㈠鐢ㄦ埛淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('200100030001','淇濆瓨鍟嗘埛淇℃伅','淇濆瓨鍟嗘埛淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('200100030002','鍟嗘埛鎴愬憳鍔犲叆淇℃伅','鍟嗘埛鎴愬憳鍔犲叆淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('200100040001','淇敼鍟嗘埛淇℃伅','淇敼鍟嗘埛淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('200100040002','鍟嗘埛鎴愬憳閫�鍑轰俊鎭�','鍟嗘埛鎴愬憳閫�鍑轰俊鎭�');
+insert into c_business_type(business_type_cd,name,description) values('200100050001','鍒犻櫎鍟嗘埛淇℃伅','鍒犻櫎鍟嗘埛淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('300100030001','淇濆瓨鍟嗗搧淇℃伅','淇濆瓨鍟嗗搧淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('300100030002','璐拱鍟嗗搧','璐拱鍟嗗搧');
+insert into c_business_type(business_type_cd,name,description) values('300100030003','淇濆瓨鍟嗗搧鐩綍','淇濆瓨鍟嗗搧鐩綍');
+insert into c_business_type(business_type_cd,name,description) values('300100040001','淇敼鍟嗗搧淇℃伅','淇敼鍟嗗搧淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('300100040002','淇敼鍟嗗搧鐩綍','淇敼鍟嗗搧鐩綍');
+insert into c_business_type(business_type_cd,name,description) values('300100050001','鍒犻櫎鍟嗗搧淇℃伅','鍒犻櫎鍟嗗搧淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('300100050002','淇敼鍟嗗搧鐩綍','淇敼鍟嗗搧鐩綍');
+insert into c_business_type(business_type_cd,name,description) values('400100030001','淇濆瓨璇勮','淇濆瓨璇勮');
+insert into c_business_type(business_type_cd,name,description) values('400100050001','鍒犻櫎璇勮','鍒犻櫎璇勮');
+insert into c_business_type(business_type_cd,name,description) values('500100030001','淇濆瓨灏忓尯淇℃伅','淇濆瓨灏忓尯淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('500100030002','灏忓尯鎴愬憳鍔犲叆淇℃伅','灏忓尯鎴愬憳鍔犲叆淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('500100040001','淇敼鍟嗘埛淇℃伅','淇敼鍟嗘埛淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('500100040002','灏忓尯鎴愬憳閫�鍑轰俊鎭�','灏忓尯鎴愬憳閫�鍑轰俊鎭�');
+insert into c_business_type(business_type_cd,name,description) values('500100050001','鍒犻櫎鍟嗘埛淇℃伅','鍒犻櫎鍟嗘埛淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('600100030002','淇濆瓨鐗╀笟鐓х墖','淇濆瓨鐗╀笟鐓х墖');
+insert into c_business_type(business_type_cd,name,description) values('600100030003','淇濆瓨鐗╀笟璇佷欢','淇濆瓨鐗╀笟璇佷欢');
+insert into c_business_type(business_type_cd,name,description) values('600100030004','淇濆瓨鐗╀笟鍛樺伐','淇濆瓨鐗╀笟鍛樺伐');
+insert into c_business_type(business_type_cd,name,description) values('600100030005','淇濆瓨鐗╀笟璐圭敤','淇濆瓨鐗╀笟璐圭敤');
+insert into c_business_type(business_type_cd,name,description) values('600100030006','淇濆瓨浣忔埛','淇濆瓨浣忔埛');
+insert into c_business_type(business_type_cd,name,description) values('600100040001','淇敼鐗╀笟淇℃伅','淇敼鐗╀笟淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('600100040002','淇敼鐗╀笟鐓х墖','淇敼鐗╀笟鐓х墖');
+insert into c_business_type(business_type_cd,name,description) values('600100040003','淇敼鐗╀笟璇佷欢','淇敼鐗╀笟璇佷欢');
+insert into c_business_type(business_type_cd,name,description) values('600100040004','淇敼 璐圭敤淇℃伅','淇敼 璐圭敤淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('600100040005','淇敼浣忔埛淇℃伅','淇敼浣忔埛淇℃伅');
+insert into c_business_type(business_type_cd,name,description) values('600100050001','鍒犻櫎鐗╀笟灞炴��','鍒犻櫎鐗╀笟灞炴��');
+insert into c_business_type(business_type_cd,name,description) values('600100050002','鍒犻櫎鐗╀笟鐓х墖','鍒犻櫎鐗╀笟鐓х墖');
+insert into c_business_type(business_type_cd,name,description) values('600100050003','鍒犻櫎 鐗╀笟璇佷欢','鍒犻櫎 鐗╀笟璇佷欢');
+insert into c_business_type(business_type_cd,name,description) values('600100050004','鍒犻櫎鐗╀笟鍛樺伐','鍒犻櫎鐗╀笟鍛樺伐');
+insert into c_business_type(business_type_cd,name,description) values('600100050005','鍒犻櫎浣忔埛','鍒犻櫎浣忔埛');
+insert into c_business_type(business_type_cd,name,description) values('700100030001','淇濆瓨浠ｇ悊鍟嗕俊鎭�','淇濆瓨浠ｇ悊鍟嗕俊鎭�');
+insert into c_business_type(business_type_cd,name,description) values('700100030002','淇濆瓨浠ｇ悊鍟嗙収鐗�','淇濆瓨浠ｇ悊鍟嗙収鐗�');
+insert into c_business_type(business_type_cd,name,description) values('700100030003','淇濆瓨浠ｇ悊鍟嗚瘉浠�','淇濆瓨浠ｇ悊鍟嗚瘉浠�');
+insert into c_business_type(business_type_cd,name,description) values('700100030004','娣诲姞浠ｇ悊鍟嗗憳宸�','娣诲姞浠ｇ悊鍟嗗憳宸�');
+insert into c_business_type(business_type_cd,name,description) values('700100040001','淇敼浠ｇ悊鍟嗕俊鎭�','淇敼浠ｇ悊鍟嗕俊鎭�');
+insert into c_business_type(business_type_cd,name,description) values('700100040002','淇敼浠ｇ悊鍟嗙収鐗�','淇敼浠ｇ悊鍟嗙収鐗�');
+insert into c_business_type(business_type_cd,name,description) values('700100040003','淇敼浠ｇ悊鍟嗚瘉浠�','淇敼浠ｇ悊鍟嗚瘉浠�');
+insert into c_business_type(business_type_cd,name,description) values('700100050001','鍒犻櫎浠ｇ悊鍟嗗睘鎬�','鍒犻櫎浠ｇ悊鍟嗗睘鎬�');
+insert into c_business_type(business_type_cd,name,description) values('700100050002','鍒犻櫎浠ｇ悊鍟嗙収鐗�','鍒犻櫎浠ｇ悊鍟嗙収鐗�');
+insert into c_business_type(business_type_cd,name,description) values('700100050003','鍒犻櫎浠ｇ悊鍟嗚瘉浠�','鍒犻櫎浠ｇ悊鍟嗚瘉浠�');
+insert into c_business_type(business_type_cd,name,description) values('700100050004','鍒犻櫎浠ｇ悊鍟嗗憳宸�','鍒犻櫎浠ｇ悊鍟嗗憳宸�');
-- spec
@@ -128,7 +181,7 @@
id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
service_id VARCHAR(12) NOT NULL COMMENT '鏈嶅姟ID',
service_code VARCHAR(50) NOT NULL UNIQUE COMMENT '鑷畾涔夛紝鍛藉悕鏂瑰紡鏌ヨ绫籷uery.+鐩爣绯荤粺+.+涓氬姟鍚嶇О 淇濆瓨绫� save.+鐩爣绯荤粺+.+涓氬姟鍚嶇О 淇敼绫� modify.+鐩爣绯荤粺+.+涓氬姟鍚嶇О 鍒犻櫎绫� remove.+鐩爣绯荤粺+.+涓氬姟鍚嶇О 渚嬪锛歲uery.user.userinfo save.user.adduserinfo',
- business_type_cd VARCHAR(4) NOT NULL COMMENT '涓氬姟椤圭被鍨嬶紝鍙傝�僣_business_type琛�',
+ business_type_cd VARCHAR(12) NOT NULL COMMENT '涓氬姟椤圭被鍨嬶紝鍙傝�僣_business_type琛�',
`name` VARCHAR(50) NOT NULL COMMENT '鏈嶅姟鍚嶇О',
seq INT NOT NULL COMMENT '椤哄簭 鍙湁鍚屾鏂瑰紡涓嬫牴鎹畇eq浠庡皬鍒板ぇ璋冪敤鎺ュ彛',
messageQueueName VARCHAR(50) COMMENT '娑堟伅闃熼噷鍚嶇О 鍙湁寮傛鏃舵湁鐢�',
@@ -145,7 +198,7 @@
-- 鏈嶅姟涓氬姟琛�
create table c_service_business(
service_business_id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- business_type_cd VARCHAR(4) NOT NULL COMMENT '涓氬姟椤圭被鍨嬶紝鍙傝�僣_business_type琛�',
+ business_type_cd VARCHAR(12) NOT NULL COMMENT '涓氬姟椤圭被鍨嬶紝鍙傝�僣_business_type琛�',
invoke_type varchar(4) not null comment '璋冪敤绫诲瀷锛�1 http-post(寰湇鍔″唴搴旂敤) 2 webservice 3 http-post(寰湇鍔′箣澶栧簲鐢�)',
url VARCHAR(200) COMMENT '鐩爣鍦板潃',
message_topic varchar(50) comment '寮傛鏃剁殑娑堟伅topic鍚嶇О',
@@ -158,6 +211,8 @@
+
+
-- c_mapping
CREATE TABLE c_mapping(
--
Gitblit v1.8.0