From 0819935913aecfb9e45b64d113a30820ba762f1e Mon Sep 17 00:00:00 2001
From: wuxw7 <wuxw7@asiainfo.com>
Date: 星期日, 18 十一月 2018 23:13:06 +0800
Subject: [PATCH] console 修改登录时走api 服务
---
java110-config/docker/mysql/create_sql.sql | 138 ++++++++++++++++++++++++---------------------
1 files changed, 73 insertions(+), 65 deletions(-)
diff --git a/java110-config/docker/mysql/create_sql.sql b/java110-config/docker/mysql/create_sql.sql
index acf6cad..8e96cf3 100644
--- a/java110-config/docker/mysql/create_sql.sql
+++ b/java110-config/docker/mysql/create_sql.sql
@@ -132,22 +132,23 @@
-- c_service
CREATE TABLE c_service(
- service_id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
+ 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琛�',
`name` VARCHAR(50) NOT NULL COMMENT '鏈嶅姟鍚嶇О',
seq INT NOT NULL COMMENT '椤哄簭 鍙湁鍚屾鏂瑰紡涓嬫牴鎹畇eq浠庡皬鍒板ぇ璋冪敤鎺ュ彛',
messageQueueName VARCHAR(50) COMMENT '娑堟伅闃熼噷鍚嶇О 鍙湁寮傛鏃舵湁鐢�',
- is_instance varchar(2) not null default 'N' comment '鏄惁Instance Y 闇�瑕侊紝N涓嶉渶瑕�',
+ is_instance varchar(2) not null default 'N' comment '鏄惁Instance Y 闇�瑕侊紝N涓嶉渶瑕侊紝NT閫忎紶绫�',
url VARCHAR(200) COMMENT '鐩爣鍦板潃',
method VARCHAR(50) COMMENT '鏂规硶 绌� 涓篽ttp post LOCAL_SERVICE 涓鸿皟鐢ㄦ湰鍦版湇鍔� 鍏朵粬涓簑ebservice鏂瑰紡璋冪敤',
timeout INT NOT NULL DEFAULT 60 COMMENT '瓒呮椂鏃堕棿',
retry_count INT NOT NULL DEFAULT 3 COMMENT '閲嶈瘯娆℃暟',
provide_app_id VARCHAR(30) NOT NULL COMMENT '搴旂敤ID',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- status_cd VARCHAR(2) NOT NULL default '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝0鍦ㄧ敤锛�1澶辨晥'
+ status_cd VARCHAR(2) NOT NULL default '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝0鍦ㄧ敤锛�1澶辨晥',
+ UNIQUE KEY (service_id)
);
-
-- c_mapping
@@ -192,7 +193,8 @@
black_list_ip VARCHAR(200) COMMENT '榛戝悕鍗昳p 澶氫釜涔嬮棿鐢�;闅斿紑',
remark VARCHAR(200) COMMENT '鎻忚堪',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝0鍦ㄧ敤锛�1澶辨晥'
+ status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝0鍦ㄧ敤锛�1澶辨晥',
+ UNIQUE KEY (app_id)
);
-- c_service_sql
@@ -226,100 +228,106 @@
values('8000418003','鐢ㄦ埛绠＄悊搴旂敤','WEBURFPKIFJUHNCJUEIKMKJUJHULSMNCHDY89KMC','鐢ㄦ埛绠＄悊搴旂敤','0');
-insert into c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id,status_cd)
-values('query.user.userInfo','Q','鐢ㄦ埛淇℃伅鏌ヨ',1,'http://...','8000418001','0');
+insert into c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id,status_cd)
+values('1','query.user.userInfo','Q','鐢ㄦ埛淇℃伅鏌ヨ',1,'http://...','8000418001','0');
-insert into c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id,status_cd)
-values('query.order.orderInfo','Q','璁㈠崟淇℃伅',1,'http://center-service/businessApi/query','8000418001','0');
+insert into c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id,status_cd)
+values('2','query.order.orderInfo','Q','璁㈠崟淇℃伅',1,'http://center-service/businessApi/query','8000418001','0');
-insert into c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id,status_cd)
-values('query.console.menu','Q','鏌ヨ鑿滃崟',1,'http://center-service/businessApi/query','8000418002','0');
+insert into c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id,status_cd)
+values('3','query.console.menu','Q','鏌ヨ鑿滃崟',1,'http://center-service/businessApi/query','8000418002','0');
-insert into c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id,status_cd)
-values('query.user.loginInfo','Q','鏌ヨ鐢ㄦ埛鐧诲綍淇℃伅',1,'http://center-service/businessApi/query','8000418002','0');
+insert into c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id,status_cd)
+values('4','query.user.loginInfo','Q','鏌ヨ鐢ㄦ埛鐧诲綍淇℃伅',1,'http://center-service/businessApi/query','8000418002','0');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('query.console.template','Q','鏌ヨ妯℃澘淇℃伅',1,'http://center-service/businessApi/query','8000418002');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('5','query.console.template','Q','鏌ヨ妯℃澘淇℃伅',1,'http://center-service/businessApi/query','8000418002');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('query.console.templateCol','Q','鏌ヨ鍒楁ā鏉夸俊鎭�',1,'http://center-service/businessApi/query','8000418002');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('6','query.console.templateCol','Q','鏌ヨ鍒楁ā鏉夸俊鎭�',1,'http://center-service/businessApi/query','8000418002');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('query.center.mapping','Q','鏌ヨ鏄犲皠鏁版嵁',1,'http://center-service/businessApi/query','8000418002');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('7','query.center.mapping','Q','鏌ヨ鏄犲皠鏁版嵁',1,'http://center-service/businessApi/query','8000418002');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('query.center.apps','Q','鏌ヨ澶栭儴搴旂敤',1,'http://center-service/businessApi/query','8000418002');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('8','query.center.apps','Q','鏌ヨ澶栭儴搴旂敤',1,'http://center-service/businessApi/query','8000418002');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('query.center.services','Q','鏌ヨ鏈嶅姟',1,'http://center-service/businessApi/query','8000418002');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('9','query.center.services','Q','鏌ヨ鏈嶅姟',1,'http://center-service/businessApi/query','8000418002');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('query.center.routes','Q','鏌ヨ璺敱',1,'http://center-service/businessApi/query','8000418002');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('10','query.center.routes','Q','鏌ヨ璺敱',1,'http://center-service/businessApi/query','8000418002');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('flush.center.cache','Q','CenterService缂撳瓨',1,'http://center-service/cacheApi/flush','8000418002');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('11','flush.center.cache','Q','CenterService缂撳瓨',1,'http://center-service/cacheApi/flush','8000418002');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('query.console.caches','Q','鏌ヨ鎵�鏈夌紦瀛�',1,'http://center-service/businessApi/query','8000418002');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('12','query.console.caches','Q','鏌ヨ鎵�鏈夌紦瀛�',1,'http://center-service/businessApi/query','8000418002');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('query.console.cache','Q','鏌ヨ鎵�鏈夌紦瀛�',1,'http://center-service/businessApi/query','8000418002');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('13','query.console.cache','Q','鏌ヨ鎵�鏈夌紦瀛�',1,'http://center-service/businessApi/query','8000418002');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('save.center.mapping','Q','淇濆瓨鏄犲皠淇℃伅',1,'http://center-service/businessApi/do','8000418002');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('14','save.center.mapping','Q','淇濆瓨鏄犲皠淇℃伅',1,'http://center-service/businessApi/do','8000418002');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('delete.center.mapping','Q','鍒犻櫎鏄犲皠淇℃伅',1,'http://center-service/businessApi/do','8000418002');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('15','delete.center.mapping','Q','鍒犻櫎鏄犲皠淇℃伅',1,'http://center-service/businessApi/do','8000418002');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('update.center.mapping','Q','淇敼鏄犲皠淇℃伅',1,'http://center-service/businessApi/do','8000418002');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('16','update.center.mapping','Q','淇敼鏄犲皠淇℃伅',1,'http://center-service/businessApi/do','8000418002');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('save.user.userInfo','D','淇濆瓨鐢ㄦ埛淇℃伅',1,'http://user-service/userApi/service','8000418003');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('17','save.user.userInfo','D','淇濆瓨鐢ㄦ埛淇℃伅',1,'http://user-service/userApi/service','8000418003');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('save.store.info','D','淇濆瓨鍟嗘埛淇℃伅',1,'http://store-service/storeApi/service','8000418003');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('18','save.store.info','D','淇濆瓨鍟嗘埛淇℃伅',1,'http://store-service/storeApi/service','8000418003');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('update.store.info','D','淇敼鍟嗘埛淇℃伅',1,'http://store-service/storeApi/service','8000418003');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('19','update.store.info','D','淇敼鍟嗘埛淇℃伅',1,'http://store-service/storeApi/service','8000418003');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('delete.store.info','D','鍒犻櫎鍟嗘埛淇℃伅',1,'http://store-service/storeApi/service','8000418003');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('20','delete.store.info','D','鍒犻櫎鍟嗘埛淇℃伅',1,'http://store-service/storeApi/service','8000418003');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('transfer.console.menu','T','閫忎紶鑿滃崟鏌ヨ',1,'http://192.168.31.199:8001/userApi/service','8000418001');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('21','transfer.console.menu','T','閫忎紶鑿滃崟鏌ヨ',1,'http://192.168.31.199:8001/userApi/service','8000418001');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('save.shop.info','D','淇濆瓨鍟嗗搧淇℃伅',1,'http://shop-service/shopApi/service','8000418003');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('22','save.shop.info','D','淇濆瓨鍟嗗搧淇℃伅',1,'http://shop-service/shopApi/service','8000418003');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('update.shop.info','D','淇敼鍟嗗搧淇℃伅',1,'http://shop-service/shopApi/service','8000418003');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('23','update.shop.info','D','淇敼鍟嗗搧淇℃伅',1,'http://shop-service/shopApi/service','8000418003');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('delete.shop.info','D','鍒犻櫎鍟嗗搧淇℃伅',1,'http://shop-service/shopApi/service','8000418003');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('24','delete.shop.info','D','鍒犻櫎鍟嗗搧淇℃伅',1,'http://shop-service/shopApi/service','8000418003');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('buy.shop.info','D','璐拱鍟嗗搧淇℃伅',1,'http://shop-service/shopApi/service','8000418003');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('25','buy.shop.info','D','璐拱鍟嗗搧淇℃伅',1,'http://shop-service/shopApi/service','8000418003');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('save.shop.catalog','D','淇濆瓨鍟嗗搧鐩綍淇℃伅',1,'http://shop-service/shopApi/service','8000418003');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('26','save.shop.catalog','D','淇濆瓨鍟嗗搧鐩綍淇℃伅',1,'http://shop-service/shopApi/service','8000418003');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('update.shop.catalog','D','淇敼鍟嗗搧鐩綍淇℃伅',1,'http://shop-service/shopApi/service','8000418003');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('27','update.shop.catalog','D','淇敼鍟嗗搧鐩綍淇℃伅',1,'http://shop-service/shopApi/service','8000418003');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('delete.shop.catalog','D','鍒犻櫎鍟嗗搧鐩綍淇℃伅',1,'http://shop-service/shopApi/service','8000418003');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('28','delete.shop.catalog','D','鍒犻櫎鍟嗗搧鐩綍淇℃伅',1,'http://shop-service/shopApi/service','8000418003');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('save.comment.info','D','淇濆瓨璇勮',1,'http://comment-service/commentApi/service','8000418003');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('29','save.comment.info','D','淇濆瓨璇勮',1,'http://comment-service/commentApi/service','8000418003');
-INSERT INTO c_service(service_code,business_type_cd,`name`,seq,url,provide_app_id)
-VALUES('delete.comment.info','D','鍒犻櫎璇勮',1,'http://comment-service/commentApi/service','8000418003');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('30','delete.comment.info','D','鍒犻櫎璇勮',1,'http://comment-service/commentApi/service','8000418003');
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('31','member.joined.store','D','鍟嗘埛鎴愬憳鍔犲叆',1,'http://store-service/storeApi/service','8000418003');
+
+INSERT INTO c_service(service_id,service_code,business_type_cd,`name`,seq,url,provide_app_id)
+VALUES('32','member.quit.store','D','鍟嗘埛鎴愬憳閫�鍑�',1,'http://store-service/storeApi/service','8000418003');
+
insert into c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) values(
'8000418001','1','S','Q','0'
);
--
Gitblit v1.8.0