From 91f58ac34a01db7bb4e30a57af4454e0c36fd1c9 Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期日, 14 六月 2020 13:06:21 +0800
Subject: [PATCH] 处理服务启动失败问题
---
java110-config/docker/mysql/create_sql.sql | 244 ------------------------------------------------
1 files changed, 0 insertions(+), 244 deletions(-)
diff --git a/java110-config/docker/mysql/create_sql.sql b/java110-config/docker/mysql/create_sql.sql
index f1e519b..e69de29 100644
--- a/java110-config/docker/mysql/create_sql.sql
+++ b/java110-config/docker/mysql/create_sql.sql
@@ -1,244 +0,0 @@
-
-CREATE USER 'TT'@'%' IDENTIFIED BY 'TT@12345678';
-
-GRANT ALL ON *.* TO 'TT'@'%';
-
-create database `TT` default character set utf8 collate utf8_general_ci;
-
-use TT;
--- c_orders
-
-CREATE TABLE c_orders(
- o_id VARCHAR(18) NOT NULL COMMENT '璁㈠崟ID',
- app_id VARCHAR(10) NOT NULL COMMENT '搴旂敤ID',
- ext_transaction_id VARCHAR(30) NOT NULL COMMENT '澶栭儴浜ゆ槗娴佹按',
- user_id VARCHAR(12) NOT NULL COMMENT '鐢ㄦ埛ID',
- request_time VARCHAR(16) NOT NULL COMMENT '澶栭儴绯荤粺璇锋眰鏃堕棿',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- order_type_cd VARCHAR(4) NOT NULL COMMENT '璁㈠崟绫诲瀷锛屽弬鑰僣_order_type琛�',
- finish_time DATE COMMENT '璁㈠崟瀹屾垚鏃堕棿',
- remark VARCHAR(200) COMMENT '澶囨敞',
- status_cd VARCHAR(2) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛�'
-);
-
--- c_orders_attrs
-
-CREATE TABLE c_orders_attrs(
- o_id VARCHAR(18) NOT NULL COMMENT '璁㈠崟ID',
- attr_id VARCHAR(18) NOT NULL COMMENT '灞炴�d',
- spec_cd VARCHAR(12) NOT NULL COMMENT '瑙勬牸id,鍙傝�僺pec琛�',
- VALUE VARCHAR(50) NOT NULL COMMENT '灞炴�у��'
-);
-
--- c_business
-
-CREATE TABLE c_business(
- b_id VARCHAR(18) NOT NULL COMMENT '涓氬姟Id',
- o_id VARCHAR(18) NOT NULL COMMENT '璁㈠崟ID',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- business_type_cd VARCHAR(4) NOT NULL COMMENT '涓氬姟椤圭被鍨嬶紝鍙傝�僣_business_type琛�',
- finish_time DATE COMMENT '瀹屾垚鏃堕棿',
- remark VARCHAR(200) COMMENT '澶囨敞',
- status_cd VARCHAR(2) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛�'
-);
-
--- c_business_attrs
-
-CREATE TABLE c_business_attrs(
- b_id VARCHAR(18) NOT NULL COMMENT '璁㈠崟ID',
- attr_id VARCHAR(18) NOT NULL COMMENT '灞炴�d',
- spec_cd VARCHAR(12) NOT NULL COMMENT '瑙勬牸id,鍙傝�僺pec琛�',
- VALUE VARCHAR(50) NOT NULL COMMENT '灞炴�у��'
-);
-
--- c_status
-
-CREATE TABLE c_status(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- status_cd VARCHAR(4) NOT NULL COMMENT '鐘舵��',
- `name` VARCHAR(50) NOT NULL COMMENT '鍚嶇О',
- description VARCHAR(200) COMMENT '鎻忚堪',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿'
-);
-
-INSERT INTO c_status(status_cd,NAME,description) VALUES('1','鏃犳晥鐨勶紝涓嶅湪鐢ㄧ殑','鏃犳晥鐨勶紝涓嶅湪鐢ㄧ殑');
-INSERT INTO c_status(status_cd,NAME,description) VALUES('0','鏈夋晥鐨勶紝鍦ㄧ敤鐨�','鏈夋晥鐨勶紝鍦ㄧ敤鐨�');
-INSERT INTO c_status(status_cd,NAME,description) VALUES('S','淇濆瓨鎴愬姛','淇濆瓨鎴愬姛');
-INSERT INTO c_status(status_cd,NAME,description) VALUES('D','浣滃簾璁㈠崟','浣滃簾璁㈠崟');
-INSERT INTO c_status(status_cd,NAME,description) VALUES('E','閿欒璁㈠崟','閿欒璁㈠崟');
-INSERT INTO c_status(status_cd,NAME,description) VALUES('NE','閫氱煡閿欒璁㈠崟','閫氱煡閿欒璁㈠崟');
-INSERT INTO c_status(status_cd,NAME,description) VALUES('C','閿欒璁㈠崟','閿欒璁㈠崟');
-
--- c_order_type
-
-CREATE TABLE c_order_type(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- order_type_cd VARCHAR(4) NOT NULL COMMENT '璁㈠崟绫诲瀷',
- `name` VARCHAR(50) NOT NULL COMMENT '鍚嶇О',
- description VARCHAR(200) COMMENT '鎻忚堪',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿'
-);
-
-
--- c_business_type
-
-CREATE TABLE c_business_type(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- business_type_cd VARCHAR(4) NOT NULL COMMENT '涓氬姟椤圭被鍨�',
- `name` VARCHAR(50) NOT NULL COMMENT '鍚嶇О',
- description VARCHAR(200) COMMENT '鎻忚堪',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿'
-);
-
--- spec
-
-CREATE TABLE spec(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- spec_cd VARCHAR(4) NOT NULL COMMENT '涓氬姟椤圭被鍨嬭鏍肩紪鐮侊紝浠巟00020001寮�濮嬫瘡娆″姞涓�灏卞彲浠�(绾﹀畾锛寈=10琛ㄧずc_orders_attrs 涓睘鎬э紝x=11琛ㄧずc_business_attrs 涓殑灞炴��)',
- `name` VARCHAR(50) NOT NULL COMMENT '鍚嶇О',
- description VARCHAR(200) COMMENT '鎻忚堪',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿'
-);
-
--- c_route
-
-CREATE TABLE c_route(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- app_id VARCHAR(10) NOT NULL COMMENT '搴旂敤ID',
- service_id INT NOT NULL COMMENT '涓嬫父鎺ュ彛閰嶇疆ID',
- order_type_cd VARCHAR(4) NOT NULL COMMENT '璁㈠崟绫诲瀷锛屽弬鑰僣_order_type琛�',
- invoke_limit_times INT COMMENT '鎺ュ彛璋冪敤涓�鍒嗛挓璋冪敤娆℃暟',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- status_cd VARCHAR(2) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝0鍦ㄧ敤锛�1澶辨晥锛�2 琛ㄧず涓嬬嚎锛堝綋缁勪欢璋冪敤鏈嶅姟瓒呰繃闄愬埗鏃惰嚜鍔ㄤ笅绾匡級'
-);
-
-
-
--- c_service
-
-CREATE TABLE c_service(
- service_id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- service_code VARCHAR(50) NOT NULL COMMENT '鑷畾涔夛紝鍛藉悕鏂瑰紡鏌ヨ绫籷uery.+鐩爣绯荤粺+.+涓氬姟鍚嶇О 淇濆瓨绫� save.+鐩爣绯荤粺+.+涓氬姟鍚嶇О 淇敼绫� modify.+鐩爣绯荤粺+.+涓氬姟鍚嶇О 鍒犻櫎绫� remove.+鐩爣绯荤粺+.+涓氬姟鍚嶇О 渚嬪锛歲uery.user.userinfo save.user.adduserinfo',
- invoke_model VARCHAR(1) NOT NULL COMMENT '1-鍚屾鏂瑰紡 2-寮傛鏂瑰紡',
- 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 '娑堟伅闃熼噷鍚嶇О 鍙湁寮傛鏃舵湁鐢�',
- 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(10) 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澶辨晥'
-);
-
-
-
--- c_mapping
-
-CREATE TABLE c_mapping(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- domain VARCHAR(50) NOT NULL COMMENT '鍩�',
- `name` VARCHAR(50) NOT NULL COMMENT '鍚嶇О',
- `key` VARCHAR(100) NOT NULL COMMENT 'key',
- `value` VARCHAR(1000) NOT NULL COMMENT 'value',
- 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澶辨晥'
-);
-
-INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES('DOMAIN.COMMON','鏃ュ織寮�鍏�','LOG_ON_OFF','ON','鏃ュ織寮�鍏�');
-INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES('DOMAIN.COMMON','鑰楁椂寮�鍏�','COST_TIME_ON_OFF','ON','鑰楁椂寮�鍏�');
-INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES('DOMAIN.COMMON','瑙勫垯寮�鍏�','RULE_ON_OFF','OFF','瑙勫垯寮�鍏�');
-INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES('DOMAIN.COMMON','涓嶈皟瑙勫垯鏈嶅姟鐨勮鍗曠被鍨�','NO_NEED_RULE_VALDATE_ORDER','Q','涓嶈皟瑙勫垯鏈嶅姟鐨勮鍗曠被鍨�');
-INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES('DOMAIN.COMMON','涓嶄繚瀛樿鍗曚俊鎭�','NO_SAVE_ORDER','Q','涓嶄繚瀛樿鍗曚俊鎭�');
-INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES('DOMAIN.COMMON','涓嶇敤璋冪敤 涓嬫父绯荤粺鐨勯厤缃�','NO_INVOKE_BUSINESS_SYSTEM','Q','涓嶇敤璋冪敤 涓嬫父绯荤粺鐨勯厤缃�(涓�鑸笉瀛樺湪杩欑鎯呭喌锛岃繖閲屼富瑕佹槸鍦ㄦ病鏈変笅娓哥郴缁熺殑鎯呭喌涓嬫祴璇曚腑蹇冩湇鍔＄敤)');
-INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES('DOMAIN.COMMON','涓嶇敤璋冪敤 浣滃簾涓嬫父绯荤粺鐨勯厤缃�','NO_INVALID_BUSINESS_SYSTEM','Q','涓嶇敤璋冪敤 浣滃簾涓嬫父绯荤粺鐨勯厤缃� (涓�鑸笉瀛樺湪杩欑鎯呭喌锛岃繖閲屼富瑕佹槸鍦ㄦ病鏈変笅娓哥郴缁熺殑鎯呭喌涓嬫祴璇曚腑蹇冩湇鍔＄敤)');
-INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES('DOMAIN.COMMON','闇�瑕佽皟鐢ㄦ湇鍔＄敓鎴愬悇涓狪D','NEED_INVOKE_SERVICE_GENERATE_ID','OFF','闇�瑕佽皟鐢ㄦ湇鍔＄敓鎴愬悇涓狪D');
-INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES('DOMAIN.COMMON','鍏挜','PUBLIC_STRING','MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDloKXSBA5+tP39uS8yi5RZOs6Jdrt0znRQetyXX2l/IUCi1x1QAMgoZbnEavmdZ5jOZN/T1WYFbt/VomXEHaTdStAiYm3DCnxxy5CMMyRKai0+6n4lLJQpUmnAQPFENrOV8b70gBSBVjUXksImgui5qYaNqX90pjEzcyq+6CugBwIDAQAB','鍏挜');
-INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES('DOMAIN.COMMON','绉侀挜','PRIVATE_STRING','MIICdgIBADANBgkqhkiG9w0BAQEFAASCAmAwggJcAgEAAoGBAJbtQYV+VpWZvifoc0R11MyAfIyMGoJKHDrWQau7oxLHotDDJM80o7ea7oL2onaHWOXaybpUp5FpZgjuixYMhlQOA/VXosrJOGJhgNv0dAL6VVXxmjlg2UWqIEoyTS7IzF3BuQCqy2k9aT7mGiC0RYRpndTuwe/0DKwFx70dIIIrAgMBAAECgYBMNMHnqLIJWZa1Sd6hy6lGFP5ObROZg9gbMUH5d4XQnrKsHEyCvz6HH5ic0fGYTaDqdn1zMvllJ8XYbrIV0P8lvHr9/LCnoXessmf61hKZyTKi5ycNkiPHTjmJZCoVTQFprcNgYeVX4cvNsqB2zWwzoAk8bbdWY6X5jB6YEpfBmQJBANiO9GiBtw+T9h60MpyV1xhJKsx0eCvxRZcsDB1OLZvQ7dHnsHmh0xUBL2MraHKnQyxOlrIzOtyttxSTrQzwcM0CQQCyajkzxpF6EjrXWHYVHb3AXFSoz5krjOkLEHegYlGhx0gtytBNVwftCn6hqtaxCxKMp00ZJoXIxo8d9tQy4N7XAkBljnTT5bEBnzPWpk7t298pRnbJtvz8LoOiJ0fvHlCJN+uvemXqRJeGzC165kpvKj14M8q7+wZpoxWukqqe3MspAkAuFYHw/blV7p+EQDU//w6kQTUc5YKK3TrUwMwlgT/UqcTbDyf+0hwZ/jv3RkluMY35Br3DYU/tLFyLQNZOzgbBAkEApWARXVlleEYbv8dPUL+56S0ky1hZSuPfVOBda4V3p0q18LjcHIyYcVhKGqkpii5JgblaYyjUriNDisFalCp8jQ==','绉侀挜');
-INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES('DOMAIN.COMMON','澶栭儴搴旂敤鍏挜','PUBLIC_STRING','MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCW7UGFflaVmb4n6HNEddTMgHyMjBqCShw61kGru6MSx6LQwyTPNKO3mu6C9qJ2h1jl2sm6VKeRaWYI7osWDIZUDgP1V6LKyThiYYDb9HQC+lVV8Zo5YNlFqiBKMk0uyMxdwbkAqstpPWk+5hogtEWEaZ3U7sHv9AysBce9HSCCKwIDAQAB','澶栭儴搴旂敤鍏挜');
-INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES('DOMAIN.COMMON','澶栭儴搴旂敤绉侀挜','PRIVATE_STRING','MIICdgIBADANBgkqhkiG9w0BAQEFAASCAmAwggJcAgEAAoGBAOWgpdIEDn60/f25LzKLlFk6zol2u3TOdFB63JdfaX8hQKLXHVAAyChlucRq+Z1nmM5k39PVZgVu39WiZcQdpN1K0CJibcMKfHHLkIwzJEpqLT7qfiUslClSacBA8UQ2s5XxvvSAFIFWNReSwiaC6Lmpho2pf3SmMTNzKr7oK6AHAgMBAAECgYEAlfR5FVNM2/X6QC0k408/i53Zru94r2j7kGsLj1bhoAHpIe502AAKtkboL5rkc6Rpp688dCvRug6T4gFxj8cEF7rOOU4CHqVCHUHa4sWSDL2Rg7pMbQOVB7PGmM4C/hEgXcwM6tmLiU3xkkQDrpgT1bPpAm7iwDx4HkZBv1naYnECQQDyk40+KDvyUgp/r1tKbkMLoQOAfTZPXy+HgeAkU3PCUTFQlvn2OU6Fsl3Yjlp6utxPVnd00DoPZ8qvx1falaeLAkEA8lWoIDgyYwnibv2fr3A715PkieJ0exKfLb5lSD9UIfGJ9s7oTcltl7pprykfSP46heWjScS7YJRZHPfqb1/Y9QJAJNUQqjJzv7yDSZX3t5p8ZaSiIn1gpLagQeQPg5SETCoF4eW6uI9FA/nsU/hxdpcu4oEPjFYdqr8owH31MgRtNwJAaE+6qPPHrJ3qnAAMJoZXG/qLG1cg8IEZh6U3D5xC6MGBs31ovWMBC5iwOTeoQdE8+7nXSb+nMHFq0m9cuEg3qQJAH4caPSQ9RjVOP9on+niy9b1mATbvurepIB95KUtaHLz1hpihCLR7dTwrz8JOitgFE75Wzt4a00GZYxnaq3jsjA==','澶栭儴搴旂敤绉侀挜');
-INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES('DOMAIN.COMMON','榛樿KEY_SIZE','DEFAULT_DECRYPT_KEY_SIZE','2048','榛樿KEY_SIZE');
-INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES('DOMAIN.COMMON','涓績鏈嶅姟鍦板潃','CENTER_SERVICE_URL','http://center-service/httpApi/service','涓績鏈嶅姟鍦板潃');
-INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES('DOMAIN.COMMON','鎺у埗涓績APP_ID','CONSOLE_SERVICE_APP_ID','8000418002','鎺у埗涓績APP_ID');
-INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES('DOMAIN.COMMON','鎺у埗鏈嶅姟鍔犲瘑寮�鍏�','KEY_CONSOLE_SERVICE_SECURITY_ON_OFF','ON','鎺у埗鏈嶅姟鍔犲瘑寮�鍏�');
-INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES('DOMAIN.COMMON','鎺у埗鏈嶅姟閴存潈绉橀挜','CONSOLE_SECURITY_CODE','WEBURFPKIFJUHNCJUEIKMKJUJHULSMNCHDY89KMC','鎺у埗鏈嶅姟閴存潈绉橀挜');
-
--- c_app
-CREATE TABLE c_app(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- app_id VARCHAR(10) NOT NULL COMMENT '搴旂敤ID',
- `name` VARCHAR(50) NOT NULL COMMENT '鍚嶇О 瀵瑰簲绯荤粺鍚嶇О',
- security_code VARCHAR(64) NOT NULL COMMENT '绛惧悕鐮� sign绛惧悕鏃剁敤',
- while_list_ip VARCHAR(200) COMMENT '鐧藉悕鍗昳p 澶氫釜涔嬮棿鐢�;闅斿紑',
- 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 COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝0鍦ㄧ敤锛�1澶辨晥'
-);
-
--- c_service_sql
-CREATE TABLE c_service_sql(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- service_code VARCHAR(50) NOT NULL COMMENT '瀵瑰簲c_service琛�',
- `name` VARCHAR(50) NOT NULL COMMENT '鍚嶇О',
- params VARCHAR(500) NOT NULL COMMENT '鍙傛暟',
- query_model VARCHAR(1) NOT NULL COMMENT '鏌ヨ鏂瑰紡 1銆乻ql,2銆佸瓨鍌ㄨ繃绋�',
- `sql` LONGTEXT COMMENT '鎵цsql',
- proc VARCHAR(200) COMMENT '瀛樺偍杩囩▼鍚嶇О',
- java_script LONGTEXT COMMENT '鎵цjava鑴氭湰浠ｇ爜',
- template LONGTEXT COMMENT '杈撳嚭妯℃澘',
- remark VARCHAR(200) COMMENT '鎻忚堪',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- status_cd VARCHAR(2) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝0鍦ㄧ敤锛�1澶辨晥'
-);
-
--- 娴嬭瘯鐢�
-
-insert into c_order_type(order_type_cd,`name`,description) values('Q','鏌ヨ鍗�','鏌ヨ鍗�');
-
-insert into c_app(app_id,`name`,security_code,remark,status_cd)
-values('8000418001','鍐呴儴娴嬭瘯搴旂敤','WEBURFPKIFJUHNCJUEIKMKJUJHULSMNCHDY89KMC','璁板緱鍒犻櫎','0');
-
-INSERT INTO c_app(app_id,`name`,security_code,remark,status_cd)
-VALUES('8000418002','鎺у埗涓績搴旂敤','WEBURFPKIFJUHNCJUEIKMKJUJHULSMNCHDY89KMC','鎺у埗涓績搴旂敤','0');
-
-insert into c_route(app_id,service_id,order_type_cd,status_cd) values(
-'8000418001','1','Q','0'
-);
-
-insert into c_route(app_id,service_id,order_type_cd,status_cd) values(
-'8000418001','3','Q','0'
-);
-
-insert into c_service(service_code,invoke_model,business_type_cd,`name`,seq,url,provide_app_id,status_cd)
-values('query.user.userInfo','1','Q','鐢ㄦ埛淇℃伅鏌ヨ',1,'http://...','8000418001','0');
-
-insert into c_service(service_code,invoke_model,business_type_cd,`name`,seq,url,provide_app_id,status_cd)
-values('query.order.orderInfo','1','Q','璁㈠崟淇℃伅',1,'http://center-service/businessApi/query','8000418001','0');
-
-INSERT INTO c_service_sql(service_code,`name`,params,query_model,`sql`,proc,template,remark,status_cd)
-VALUES('query.order.orderInfo','璁㈠崟淇℃伅','oId','1','{
- "param1":"SELECT co.app_id appId,co.create_time createTime,co.ext_transaction_id extTransactionId,co.finish_time finishTime
- ,co.order_type_cd orderTypeCd,co.o_id oId ,co.remark remark ,co.request_time requestTime ,co.user_id userId,co.status_cd statusCd
- FROM c_orders co WHERE co.o_id = #oId#",
- "param2":"SELECT cb.b_id bId, cb.business_type_cd businessTypeCd,cb.create_time createTime,cb.finish_time finishTime ,cb.o_id oId,
- cb.remark remark,cb.status_cd statusCd FROM c_business cb WHERE cb.o_id = #oId#"
- }','','{"PARAM:"{
- "param1": "$.#order#Object",
- "param2": "$.#business#Array"
- },"TEMPLATE":"{
- "response": {
- "code": "0000",
- "message": "鎴愬姛"
- }
- }"}','','0');
-
-
-
-
-
-
-
--
Gitblit v1.8.0