From 587a30326ef446ba4e2d150401323eef7f21b3de Mon Sep 17 00:00:00 2001
From: mrzcc <121184950@qq.com>
Date: 星期一, 17 二月 2020 18:30:23 +0800
Subject: [PATCH] 巡检计划xml
---
java110-config/docker/mysql/create_sql.sql | 1862 ----------------------------------------------------------
1 files changed, 0 insertions(+), 1,862 deletions(-)
diff --git a/java110-config/docker/mysql/create_sql.sql b/java110-config/docker/mysql/create_sql.sql
index 4d8199d..e69de29 100644
--- a/java110-config/docker/mysql/create_sql.sql
+++ b/java110-config/docker/mysql/create_sql.sql
@@ -1,1862 +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
-set character set utf8;
-
-CREATE TABLE c_orders(
- o_id VARCHAR(30) NOT NULL UNIQUE COMMENT '璁㈠崟ID',
- app_id VARCHAR(30) NOT NULL COMMENT '搴旂敤ID',
- ext_transaction_id VARCHAR(30) NOT NULL COMMENT '澶栭儴浜ゆ槗娴佹按',
- user_id VARCHAR(30) 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(30) NOT NULL COMMENT '璁㈠崟ID',
- attr_id VARCHAR(30) 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(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琛�',
- finish_time DATE COMMENT '瀹屾垚鏃堕棿',
- remark VARCHAR(200) COMMENT '澶囨敞',
- status_cd VARCHAR(2) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛�'
-);
-
---c_orders_attrs
-
-CREATE TABLE c_business_attrs(
- b_id VARCHAR(30) NOT NULL COMMENT '璁㈠崟ID',
- attr_id VARCHAR(30) 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 UNIQUE 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','璁㈠崟瀹屾垚','璁㈠崟瀹屾垚');
-INSERT INTO c_status(status_cd,NAME,description) VALUES('B','Business杩囩▼','Business杩囩▼');
-INSERT INTO c_status(status_cd,NAME,description) VALUES('I','Instance杩囩▼','Instance杩囩▼')
-
-
---c_order_type
-
-CREATE TABLE c_order_type(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- order_type_cd VARCHAR(4) NOT NULL UNIQUE 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 UNIQUE COMMENT '涓氬姟椤圭被鍨�',
- `name` VARCHAR(50) NOT NULL COMMENT '鍚嶇О',
- description VARCHAR(200) COMMENT '鎻忚堪',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿'
-);
-
-insert into c_business_type(business_type_cd,name,description) values('DO','鎾ゅ崟','浣滃簾璁㈠崟');
-
--- spec
-
-CREATE TABLE spec(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- domain varchar(20) not null comment '灞炴�у煙',
- spec_cd VARCHAR(4) NOT NULL UNIQUE 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 '鍒涘缓鏃堕棿'
-);
-
-insert into spec(domain,spec_cd,name,description) values('ORDERS','100001','璁㈠崟鏉ユ簮','璁㈠崟鏉ユ簮');
-insert into spec(domain,spec_cd,name,description) values('BUSINESS','200001','鎺ㄨ崘UserID','鎺ㄨ崘UserID');
-
--- c_route
-
-CREATE TABLE c_route(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- app_id VARCHAR(30) 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 '鎺ュ彛璋冪敤涓�鍒嗛挓璋冪敤娆℃暟',
- invoke_model VARCHAR(1) NOT NULL COMMENT '1-鍚屾鏂瑰紡 2-寮傛鏂瑰紡',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- status_cd VARCHAR(2) NOT NULL DEFAULT '0' 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 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涓嶉渶瑕�',
- 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澶辨晥'
-);
-
-
-
--- 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,T','涓嶄繚瀛樿鍗曚俊鎭�');
-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','鎺у埗鏈嶅姟閴存潈绉橀挜');
-INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES('DOMAIN.COMMON','缂栫爜鐢熸垚鏈嶅姟鍦板潃','CODE_PATH','http://code-service/codeApi/generate','缂栫爜鐢熸垚鏈嶅姟鍦板潃');
-
--- c_app
-CREATE TABLE c_app(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- app_id VARCHAR(30) NOT NULL UNIQUE 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 DEFAULT '0' 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 UNIQUE 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 DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝0鍦ㄧ敤锛�1澶辨晥'
-);
-
--- 娴嬭瘯鐢�
-
-insert into c_order_type(order_type_cd,`name`,description) values('Q','鏌ヨ鍗�','鏌ヨ鍗�');
-insert into c_order_type(order_type_cd,`name`,description) values('D','鍙楃悊鍗�','鍙楃悊鍗�');
-
-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_app(app_id,`name`,security_code,remark,status_cd)
-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_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_code,business_type_cd,`name`,seq,url,provide_app_id,status_cd)
-values('query.console.menu','Q','鏌ヨ鑿滃崟',1,'http://console-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://console-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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_route(app_id,service_id,invoke_model,order_type_cd,status_cd) values(
-'8000418001','1','S','Q','0'
-);
-
-insert into c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) values(
-'8000418001','3','S','Q','0'
-);
-
-insert into c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) values(
-'8000418002','4','S','Q','0'
-);
-
-insert into c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) values(
-'8000418002','5','Q','0'
-);
-
-INSERT INTO c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) VALUES(
-'8000418002','6','S','Q','0'
-);
-
-INSERT INTO c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) VALUES(
-'8000418002','7','S','Q','0'
-);
-
-INSERT INTO c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) VALUES(
-'8000418002','8','S','Q','0'
-);
-
-INSERT INTO c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) VALUES(
-'8000418002','9','S','Q','0'
-);
-
-
-INSERT INTO c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) VALUES(
-'8000418002','10','S','Q','0'
-);
-
-INSERT INTO c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) VALUES(
-'8000418002','11','S','Q','0'
-);
-
-INSERT INTO c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) VALUES(
-'8000418002','12','S','Q','0'
-);
-INSERT INTO c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) VALUES(
-'8000418002','13','S','Q','0'
-);
-
-INSERT INTO c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) VALUES(
-'8000418002','14','S','Q','0'
-);
-INSERT INTO c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) VALUES(
-'8000418002','15','S','Q','0'
-);
-
-INSERT INTO c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) VALUES(
-'8000418002','16','S','Q','0'
-);
-INSERT INTO c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) VALUES(
-'8000418002','17','S','Q','0'
-);
-
-insert into c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) values(
-'8000418001','21','S','Q','0'
-);
-
-insert into c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) values(
-'8000418001','22','S','Q','0'
-);
-
-insert into c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) values(
-'8000418001','23','S','Q','0'
-);
-
-insert into c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) values(
-'8000418001','24','S','Q','0'
-);
-insert into c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) values(
-'8000418001','25','S','Q','0'
-);
-insert into c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) values(
-'8000418001','26','S','Q','0'
-);
-insert into c_route(app_id,service_id,invoke_model,order_type_cd,status_cd) values(
-'8000418001','27','S','Q','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');
-
-INSERT INTO c_service_sql(service_code,`name`,params,query_model,`sql`,proc,template,remark,status_cd)
-VALUES('query.console.menu','鏌ヨ鑿滃崟','manageId,menuGroup','1','{
- "param1":"select mm.m_id mId,mm.name name,mm.level level,mm.parent_id parentId,mm.menu_group menuGroup,mm.user_id userId,mm.create_time createTime,
- mm.remark remark,mmc.url url,mmc.template template
- from m_menu_2_user mm2u,m_menu mm, m_menu_ctg mmc
- where mm2u.user_id = #manageId#
- and mm2u.m_id = mm.m_id
- AND mm.menu_group = #menuGroup#
- and mm2u.status_cd = ''0''
- and mm.status_cd = ''0''
- and mmc.m_id = mm.m_id
- and mmc.status_cd = ''0''
- order by mm.seq asc"
- }','','{"PARAM":{
- "param1": "$.#menus#Array"
- },"TEMPLATE":{
- "response": {
- "code": "0000",
- "message": "鎴愬姛"
- }
- }}','','0');
-
-INSERT INTO c_service_sql(service_code,`name`,params,query_model,`sql`,proc,template,remark,status_cd)
-VALUES('query.user.loginInfo','鏌ヨ鐢ㄦ埛鐧诲綍淇℃伅','userCode','1','{
- "param1":"select u.userId userId,u.name userName,u.password userPwd from user u where u.userCode = #userCode# and u.status_cd = ''0''"
- }','','{"PARAM":{
- "param1": "$.#user#Object"
- },"TEMPLATE":{
- "response": {
- "code": "0000",
- "message": "鎴愬姛"
- }
- }}','','0');
-
-INSERT INTO c_service_sql(service_code,`name`,params,query_model,`sql`,proc,template,remark,status_cd)
-VALUES('query.console.template','鏌ヨ妯℃澘淇℃伅','templateCode','1','{
- "param1":"SELECT t.template_code templateCode,t.name templateName,t.`html_name` htmlName,t.`url` templateUrl
- FROM c_template t WHERE t.status_cd = ''0'' AND t.template_code = #templateCode#"
- }','','{"PARAM":{
- "param1": "$.#template#Object"
- },"TEMPLATE":{
- "response": {
- "code": "0000",
- "message": "鎴愬姛"
- }
- }}','','0');
-
-
-INSERT INTO c_service_sql(service_code,`name`,params,query_model,`sql`,proc,template,remark,status_cd)
-VALUES('query.console.templateCol','鏌ヨ妯℃澘鍒椾俊鎭�','templateCode','1','{
- "param1":"SELECT t.template_code templateCode,t.name templateName,tc.col_name colName,tc.col_model colModel FROM c_template t,c_template_col tc WHERE t.status_cd = ''0'' AND t.template_code = tc.template_code
- AND tc.status_cd = ''0''
- AND t.template_code = #templateCode#"
- }','','{"PARAM":{
- "param1": "$.#template#Array"
- },"TEMPLATE":{
- "response": {
- "code": "0000",
- "message": "鎴愬姛"
- }
- }}','','0');
-
-INSERT INTO c_service_sql(service_code,`name`,params,query_model,`sql`,proc,template,remark,status_cd)
-VALUES('query.center.mapping','鏌ヨ鏄犲皠鏁版嵁','page,rows,sord','1','{"param1":"select count(1) records,ceil(#page#/#rows#)+1 page,ceil(count(1)/#rows#) total from c_mapping m where m.status_cd = ''0''",
- "param2":"SELECT m.`id` id,m.`domain` domain,m.name name,m.`key` `key` ,m.`value` `value`,m.`remark` remark FROM c_mapping m WHERE m.`status_cd` = ''0'' LIMIT #page#, #rows#"
- }','','{
- "PARAM": {
- "param1": "$.##Object",
- "param2": "$.#rows#Array"
- },
- "TEMPLATE": {
- "response": {
- "code": "0000",
- "message": "鎴愬姛"
- }
- }
- }','','0');
-INSERT INTO c_service_sql(service_code,`name`,params,query_model,`sql`,proc,template,remark,status_cd)
-VALUES('query.center.apps','鏌ヨ澶栭儴搴旂敤','page,rows,sord','1','{"param1":"select count(1) records,ceil(#page#/#rows#)+1 page,ceil(count(1)/#rows#) total from c_app a where a.status_cd = ''0''",
- "param2":"SELECT m.`id` id,m.`app_id` appId,m.name `name`,m.`security_code` securityCode ,m.`while_list_ip` whileListIp,m.`black_list_ip` blackListIp,m.`remark` remark FROM c_app m WHERE m.`status_cd` = ''0'' LIMIT #page#, #rows#"
- }','','{
- "PARAM": {
- "param1": "$.##Object",
- "param2": "$.#rows#Array"
- },
- "TEMPLATE": {
- "response": {
- "code": "0000",
- "message": "鎴愬姛"
- }
- }
- }','','0');
-
-INSERT INTO c_service_sql(service_code,`name`,params,query_model,`sql`,proc,template,remark,status_cd)
-VALUES('query.center.services','鏌ヨ鏈嶅姟鏁版嵁','page,rows,sord','1','{"param1":"select count(1) records,ceil(#page#/#rows#)+1 page,ceil(count(1)/#rows#) total from c_service a where a.status_cd = ''0''",
- "param2":"SELECT s.`service_id` serviceId,s.`service_code` serviceCode,s.`business_type_cd` businessTypeCd,s.name `name`,s.is_instance isInstance,
- s.`messageQueueName` messageQueueName,s.url url,s.`provide_app_id` provideAppId FROM c_service s WHERE s.`status_cd` = ''0'' LIMIT #page#, #rows#"
- }','','{
- "PARAM": {
- "param1": "$.##Object",
- "param2": "$.#rows#Array"
- },
- "TEMPLATE": {
- "response": {
- "code": "0000",
- "message": "鎴愬姛"
- }
- }
- }','','0');
-
-INSERT INTO c_service_sql(service_code,`name`,params,query_model,`sql`,proc,template,remark,status_cd)
-VALUES('query.center.route','鏌ヨ璺敱鏁版嵁','page,rows,sord','1','{"param1":"select count(1) records,ceil(#page#/#rows#)+1 page,ceil(count(1)/#rows#) total from c_route a,c_service cs WHERE a.`service_id` = cs.`service_id` AND cs.`status_cd` = ''0'' and a.status_cd = ''0''",
- "param2":"SELECT s.id id,s.`app_id` appId,s.`service_id` serviceId,s.`invoke_model` invokeModel,cs.`name` serviceName,cs.`service_code` serviceCode,s.`order_type_cd` orderTypeCd,s.`invoke_limit_times` invokelimitTimes FROM c_route s,c_service cs WHERE s.`service_id` = cs.`service_id` AND cs.`status_cd` = ''0'' AND s.`status_cd` = ''0'' LIMIT #page#, #rows#"
- }','','{
- "PARAM": {
- "param1": "$.##Object",
- "param2": "$.#rows#Array"
- },
- "TEMPLATE": {
- "response": {
- "code": "0000",
- "message": "鎴愬姛"
- }
- }
- }','','0');
-
-INSERT INTO c_service_sql(service_code,`name`,params,query_model,`sql`,proc,template,remark,status_cd)
-VALUES('query.console.caches','鏌ヨ缂撳瓨鏁版嵁','userId','1','{
- "param1":"SELECT c.id id,c.`cache_code` cacheCode, c.`name` cacheName FROM c_cache c, c_cache_2_user c2u WHERE c.`cache_code` = c2u.`cache_code` AND c.`status_cd` = ''0''
- AND c2u.`status_cd` = ''0'' AND c2u.`user_id` = #userId# AND c.`group` = ''COMMON'' ORDER BY c.`seq` ASC"
- }','','{
- "PARAM": {
- "param1": "$.#rows#Array"
- },
- "TEMPLATE": {
- "response": {
- "code": "0000",
- "message": "鎴愬姛"
- }
- }
- }','','0');
-INSERT INTO c_service_sql(service_code,`name`,params,query_model,`sql`,proc,template,remark,status_cd)
-VALUES('query.console.cache','鏌ヨ鍗曟潯缂撳瓨淇℃伅','cacheCode','1','{
- "param1":"SELECT c.id id,c.`cache_code` cacheCode, c.`name` cacheName,c.`param` param,c.`service_code` serviceCode FROM c_cache c WHERE c.`status_cd` = ''0'' AND c.`cache_code` = #cacheCode#"
- }','','{
- "PARAM": {
- "param1": "$.#cache#Object"
- },
- "TEMPLATE": {
- "response": {
- "code": "0000",
- "message": "鎴愬姛"
- }
- }
- }','','0');
-
-
-INSERT INTO c_service_sql(service_code,`name`,params,query_model,`sql`,proc,template,remark,status_cd)
-VALUES('save.center.mapping','淇濆瓨鏄犲皠淇℃伅','domain,name,key,value,remark','1','{
- "param1":"INSERT c_mapping(domain,`name`,`key`,`value`,remark) VALUES(#domain#,#name#,#key#,#value#,#remark#)"
- }','','{
- "TEMPLATE": {
- "response": {
- "code": "0000",
- "message": "鎴愬姛"
- }
- }
- }','','0');
-INSERT INTO c_service_sql(service_code,`name`,params,query_model,`sql`,proc,template,remark,status_cd)
-VALUES('delete.center.mapping','鍒犻櫎鏄犲皠淇℃伅','id','1','{
- "param1":"UPDATE c_mapping m SET m.status_cd = ''1'' WHERE m.status_cd = ''0'' AND m.id = #id#"
- }','','{
- "TEMPLATE": {
- "response": {
- "code": "0000",
- "message": "鎴愬姛"
- }
- }
- }','','0');
-INSERT INTO c_service_sql(service_code,`name`,params,query_model,`sql`,proc,template,remark,status_cd)
-VALUES('update.center.mapping','淇敼鏄犲皠淇℃伅','id,domain,name,key,value,remark','1','{
- "param1":"UPDATE c_mapping m SET m.domain=#domain#,m.name = #name#,m.key=#key#,m.value=#value#,m.remark=#remark# WHERE m.status_cd = ''0'' AND m.id = #id#"
- }','','{
- "TEMPLATE": {
- "response": {
- "code": "0000",
- "message": "鎴愬姛"
- }
- }
- }','','0');
-
-create table c_comment(
- comment_id VARCHAR(30) NOT NULL COMMENT '璇勮ID',
- user_id varchar(30) not null comment '璇勮鑰呯敤鎴稩D',
- b_id VARCHAR(30) NOT NULL COMMENT '璁㈠崟ID',
- comment_type_cd varchar(2) not null default 'S' comment '璇勮绫诲瀷 S琛ㄧず 鍟嗗搧 M琛ㄧず 鍟嗘埛 T 鐗╂祦',
- out_id varchar(30) not null comment '澶栭儴ID锛屽鍟嗗搧ID 鍟嗘埛ID绛�',
- `month` INT 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澶辨晥'
-)
-PARTITION BY RANGE (`month`) (
- PARTITION comment_1 VALUES LESS THAN (2),
- PARTITION comment_2 VALUES LESS THAN (3),
- PARTITION comment_3 VALUES LESS THAN (4),
- PARTITION comment_4 VALUES LESS THAN (5),
- PARTITION comment_5 VALUES LESS THAN (6),
- PARTITION comment_6 VALUES LESS THAN (7),
- PARTITION comment_7 VALUES LESS THAN (8),
- PARTITION comment_8 VALUES LESS THAN (9),
- PARTITION comment_9 VALUES LESS THAN (10),
- PARTITION comment_10 VALUES LESS THAN (11),
- PARTITION comment_11 VALUES LESS THAN (12),
- PARTITION comment_12 VALUES LESS THAN (13)
-);
-
-CREATE INDEX idx_comment_b_id ON c_comment(b_id);
-CREATE INDEX idx_comment_out_id ON c_comment(out_id);
--- 璇勮瀛愯〃
-create table c_sub_comment(
- sub_comment_id varchar(30) not null comment '瀛愯瘎璁篒D',
- comment_id varchar(30) not null comment '璇勮ID ',
- b_id VARCHAR(30) NOT NULL COMMENT '璁㈠崟ID',
- parent_sub_comment_id varchar(30) not null default '-1' comment '鐖� 瀛愯瘎璁篒D 濡傛灉涓嶆槸鍥炲 鍐欐垚-1',
- sub_comment_type_cd varchar(2) not null default 'C' comment '璇勮绫诲瀷 C 璇勮 R 鍥炲 A 杩藉姞',
- comment_context LONGTEXT not null COMMENT '璇勮鍐呭',
- `month` INT 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澶辨晥'
-)
-PARTITION BY RANGE (`month`) (
- PARTITION sub_comment_1 VALUES LESS THAN (2),
- PARTITION sub_comment_2 VALUES LESS THAN (3),
- PARTITION sub_comment_3 VALUES LESS THAN (4),
- PARTITION sub_comment_4 VALUES LESS THAN (5),
- PARTITION sub_comment_5 VALUES LESS THAN (6),
- PARTITION sub_comment_6 VALUES LESS THAN (7),
- PARTITION sub_comment_7 VALUES LESS THAN (8),
- PARTITION sub_comment_8 VALUES LESS THAN (9),
- PARTITION sub_comment_9 VALUES LESS THAN (10),
- PARTITION sub_comment_10 VALUES LESS THAN (11),
- PARTITION sub_comment_11 VALUES LESS THAN (12),
- PARTITION sub_comment_12 VALUES LESS THAN (13)
-);
-
-CREATE INDEX idx_sub_comment_b_id ON c_sub_comment(b_id);
-CREATE INDEX idx_sub_comment_comment_id ON c_sub_comment(comment_id);
-CREATE INDEX idx_sub_comment_parent_sub_comment_id ON c_sub_comment(parent_sub_comment_id);
-
--- 灞炴��
-create table c_sub_comment_attr(
- attr_id VARCHAR(30) NOT NULL COMMENT '灞炴�d',
- sub_comment_id VARCHAR(30) NOT NULL COMMENT '瀛愯瘎璁篒D',
- b_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 '鍒涘缓鏃堕棿',
- status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥'
-)
-PARTITION BY RANGE (`month`) (
- PARTITION sub_comment_attr_1 VALUES LESS THAN (2),
- PARTITION sub_comment_attr_2 VALUES LESS THAN (3),
- PARTITION sub_comment_attr_3 VALUES LESS THAN (4),
- PARTITION sub_comment_attr_4 VALUES LESS THAN (5),
- PARTITION sub_comment_attr_5 VALUES LESS THAN (6),
- PARTITION sub_comment_attr_6 VALUES LESS THAN (7),
- PARTITION sub_comment_attr_7 VALUES LESS THAN (8),
- PARTITION sub_comment_attr_8 VALUES LESS THAN (9),
- PARTITION sub_comment_attr_9 VALUES LESS THAN (10),
- PARTITION sub_comment_attr_10 VALUES LESS THAN (11),
- PARTITION sub_comment_attr_11 VALUES LESS THAN (12),
- PARTITION sub_comment_attr_12 VALUES LESS THAN (13)
-);
-
-CREATE INDEX idx_sub_comment_attr_b_id ON c_sub_comment_attr(b_id);
-CREATE INDEX idx_sub_comment_attr_sub_comment_id ON c_sub_comment_attr(sub_comment_id);
-CREATE INDEX idx_sub_comment_attr_spec_cd ON c_sub_comment_attr(spec_cd);
-
-
-
--- 璇勮 鐓х墖
-CREATE TABLE c_sub_comment_photo(
- comment_photo_id VARCHAR(30) NOT NULL COMMENT '璇勮鐓х墖ID',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- sub_comment_id VARCHAR(30) NOT NULL COMMENT '鍟嗗簵ID',
- comment_photo_type_cd VARCHAR(12) NOT NULL default 'S' COMMENT '璇勮鐓х墖绫诲瀷,S 鍟嗗搧鐓х墖 M 鍟嗘埛ID',
- photo VARCHAR(100) NOT NULL COMMENT '鐓х墖',
- `month` INT 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澶辨晥'
-)
-PARTITION BY RANGE (`month`) (
- PARTITION sub_comment_photo_1 VALUES LESS THAN (2),
- PARTITION sub_comment_photo_2 VALUES LESS THAN (3),
- PARTITION sub_comment_photo_3 VALUES LESS THAN (4),
- PARTITION sub_comment_photo_4 VALUES LESS THAN (5),
- PARTITION sub_comment_photo_5 VALUES LESS THAN (6),
- PARTITION sub_comment_photo_6 VALUES LESS THAN (7),
- PARTITION sub_comment_photo_7 VALUES LESS THAN (8),
- PARTITION sub_comment_photo_8 VALUES LESS THAN (9),
- PARTITION sub_comment_photo_9 VALUES LESS THAN (10),
- PARTITION sub_comment_photo_10 VALUES LESS THAN (11),
- PARTITION sub_comment_photo_11 VALUES LESS THAN (12),
- PARTITION sub_comment_photo_12 VALUES LESS THAN (13)
-);
-CREATE INDEX idx_sub_comment_photo_b_id ON c_sub_comment_photo(b_id);
-CREATE INDEX idx_sub_comment_photo_sub_comment_id ON c_sub_comment_photo(sub_comment_id);
--- 璇勮鍒嗘暟
-CREATE TABLE c_comment_score(
- comment_score_id VARCHAR(30) NOT NULL COMMENT '璇勮鍒嗘暟ID',
- comment_id VARCHAR(30) NOT NULL COMMENT '璇勮ID',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- score_type_cd VARCHAR(30) NOT NULL COMMENT '鎵撳垎绫诲埆锛孲 鍟嗗搧鐩哥锛孶 鍗栧鎵撳垎锛孴 鐗╂祦鎵撳垎',
- `value` INT NOT NULL COMMENT '鍒嗘暟',
- `month` INT 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澶辨晥'
-)
-PARTITION BY RANGE (`month`) (
- PARTITION comment_score_1 VALUES LESS THAN (2),
- PARTITION comment_score_2 VALUES LESS THAN (3),
- PARTITION comment_score_3 VALUES LESS THAN (4),
- PARTITION comment_score_4 VALUES LESS THAN (5),
- PARTITION comment_score_5 VALUES LESS THAN (6),
- PARTITION comment_score_6 VALUES LESS THAN (7),
- PARTITION comment_score_7 VALUES LESS THAN (8),
- PARTITION comment_score_8 VALUES LESS THAN (9),
- PARTITION comment_score_9 VALUES LESS THAN (10),
- PARTITION comment_score_10 VALUES LESS THAN (11),
- PARTITION comment_score_11 VALUES LESS THAN (12),
- PARTITION comment_score_12 VALUES LESS THAN (13)
-);
-
-CREATE INDEX idx_comment_score_b_id ON c_comment_score(b_id);
-CREATE INDEX idx_comment_score_comment_id ON c_comment_score(comment_id);
-
-
-create table m_menu(
- m_id INT NOT NULL AUTO_INCREMENT KEY COMMENT '鑿滃崟ID',
- name varchar(10) not null comment '鑿滃崟鍚嶇О',
- level varchar(2) not null comment '鑿滃崟绾у埆 涓�绾ц彍鍗� 涓� 1 浜岀骇鑿滃崟涓�2',
- parent_id int not null comment '鐖剁被鑿滃崟id 濡傛灉鏄竴绫昏彍鍗曞垯鍐欎负-1 濡傛灉鏄簩绫昏彍鍗曞垯鍐欑埗绫荤殑鑿滃崟id',
- menu_group varchar(10) not null comment '鑿滃崟缁� left 鏄剧ず鍦ㄩ〉闈㈠乏杈圭殑鑿滃崟',
- user_id varchar(12) not null comment '鍒涘缓鑿滃崟鐨勭敤鎴穒d',
- remark VARCHAR(200) COMMENT '鎻忚堪',
- seq INT NOT NULL COMMENT '鍒楅『搴�',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝0鍦ㄧ敤锛�1澶辨晥'
-);
-
--- m_menu_ctg
-
-create table m_menu_ctg(
- m_ctg_id INT NOT NULL AUTO_INCREMENT KEY COMMENT '鑿滃崟閰嶇疆ID',
- m_id INT NOT NULL COMMENT '鑿滃崟ID',
- url varchar(100) not null comment '鑿滃崟鎵撳紑鍦板潃',
- template varchar(50) comment '椤甸潰妯℃澘 妯℃澘鍚嶇О',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝0鍦ㄧ敤锛�1澶辨晥'
-);
-
--- m_menu_2_user
-
-create table m_menu_2_user(
- m_user_id INT NOT NULL AUTO_INCREMENT KEY COMMENT '鑿滃崟鐢ㄦ埛ID',
- m_id int not null comment '鑿滃崟id',
- user_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澶辨晥'
-);
-
-insert into m_menu(name,level,parent_id,menu_group,user_id,remark,seq) values('绯荤粺閰嶇疆','1','-1','LEFT','10001','',1);
-insert into m_menu(name,level,parent_id,menu_group,user_id,remark,seq) values('鏄犲皠绠＄悊','2','1','LEFT','10001','',2);
-insert into m_menu(name,level,parent_id,menu_group,user_id,remark,seq) values('澶栭儴搴旂敤','2','1','LEFT','10001','',3);
-insert into m_menu(name,level,parent_id,menu_group,user_id,remark,seq) values('璺敱绠＄悊','2','1','LEFT','10001','',4);
-insert into m_menu(name,level,parent_id,menu_group,user_id,remark,seq) values('鏈嶅姟绠＄悊','2','1','LEFT','10001','',5);
-insert into m_menu(name,level,parent_id,menu_group,user_id,remark,seq) values('缂撳瓨绠＄悊','1','-1','LEFT','10001','',1);
-insert into m_menu(name,level,parent_id,menu_group,user_id,remark,seq) values('鍒锋柊缂撳瓨','2','1','LEFT','10001','',2);
-
-insert into m_menu_ctg(m_id,url,template) values(1,'#','');
-insert into m_menu_ctg(m_id,url,template) values(2,'/console/list?templateCode=mapping','');
-insert into m_menu_ctg(m_id,url,template) values(3,'/console/list?templateCode=app','');
-insert into m_menu_ctg(m_id,url,template) values(4,'/console/list?templateCode=service','');
-insert into m_menu_ctg(m_id,url,template) values(5,'/console/list?templateCode=route','');
-insert into m_menu_ctg(m_id,url,template) values(6,'#','');
-insert into m_menu_ctg(m_id,url,template) values(7,'/','');
-
-
-insert into m_menu_2_user(m_id,user_id) values(1,'10001');
-insert into m_menu_2_user(m_id,user_id) values(2,'10001');
-insert into m_menu_2_user(m_id,user_id) values(3,'10001');
-insert into m_menu_2_user(m_id,user_id) values(4,'10001');
-insert into m_menu_2_user(m_id,user_id) values(5,'10001');
-insert into m_menu_2_user(m_id,user_id) values(6,'10001');
-insert into m_menu_2_user(m_id,user_id) values(7,'10001');
-
--- c_template
-create table c_template(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT '妯℃澘ID',
- template_code varchar(20) not null UNIQUE comment '妯℃澘缂栫爜 妯℃澘鑻辨枃鍚�',
- name varchar(50) not null comment '妯℃澘鍚嶇О',
- html_name varchar(20) not null comment '瀵瑰簲HTML鏂囦欢鍚嶇О',
- url varchar(200) not null comment '鏌ヨ鏁版嵁锛屼慨鏀规暟鎹畊rl 鍏剁湡瀹炲湴鍧�瀵瑰簲浜巑apping琛ㄤ腑 LIST->key 瀵瑰簲 鏌ヨ澶氭潯鏁版嵁 QUERY->key 瀵瑰簲鍗曟潯鏁版嵁 UPDATE-> 瀵瑰簲淇敼鏁版嵁 DELETE->key 瀵瑰簲鍒犻櫎鏁版嵁 澶氭潯涔嬮棿鐢� ; 鍒嗛殧',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝0鍦ㄧ敤锛�1澶辨晥'
-);
-
--- c_template_col
-
-create table c_template_col(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT '妯℃澘ID',
- template_code varchar(20) not null comment '妯℃澘缂栫爜 妯℃澘鑻辨枃鍚�',
- col_name varchar(50) not null comment '鍓嶅彴鏄剧ず鍚嶇О',
- col_code varchar(20) not null comment '瀛楁鐨勭紪鐮�',
- col_model longtext not null comment 'jqgrid鐨刢olmodel',
- seq INT NOT NULL COMMENT '鍒楅『搴�',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝0鍦ㄧ敤锛�1澶辨晥'
-);
-
-
-insert into c_template(template_code,name,html_name,url) values('mapping','鏄犲皠绠＄悊','list_template','LIST->query.center.mapping;QUERY->mapping_query_url;INSERT->save.center.mapping;UPDATE->update.center.mapping;DELETE->delete.center.mapping');
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('mapping','鍒桰D','id','{ "name": "id","index": "id","width": "90",
- "editable": true,
- "sorttype": "int" }',1);
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('mapping','鍩�','domain','{ "name": "domain","index": "domain","width": "90",
- "editable": true,
- "formatoptions": { "defaultValue": "DOMAIN.COMMON" }
- }',2);
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('mapping','鍚嶇О','name','{ "name": "name","index": "name","width": "90",
- "editable": true }',3);
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('mapping','閿�','key','{ "name": "key","index": "key","width": "90",
- "editable": true }',4);
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('mapping','鍊�','value','{ "name": "value","index": "value","width": "90",
- "editable": true }',5);
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('mapping','澶囨敞','value','{ "name": "remark","index": "remark","width": "90",
- "editable": true }',6);
-
-INSERT INTO c_template_col(template_code,col_name,col_code,col_model,seq) VALUES('mapping','BUTTON','BUTTON','{
- "name": "detail",
- "index": "",
- "width": "40",
- "fixed": "true",
- "sortable": "false",
- "resize": "false",
- "formatter": "function(cellvalue, options, rowObject){\n var temp =\"<div style=''margin-left:8px;''><div title=''璇︽儏璁板綍'' style=''float:left;cursor:pointer;'' class=''ui-pg-div'' id=''jEditButton_3'' onclick=''detail(\"+rowObject+\")'' onmouseover=''jQuery(this).addClass(''ui-state-hover'');'' onmouseout=''jQuery(this).removeClass(''ui-state-hover'');''><span class=''ui-icon fa-search-plus''/></div></div>\";\n return temp; \n}"
- }',7);
-/** 濡傛灉BUTTON 鎶ラ敊涓嶆樉绀猴紝鍒欑洿鎺ョ矘璐村埌col_model涓�
- {
- "name": "detail",
- "index": "",
- "width": "40",
- "fixed": true,
- "sortable": "false",
- "resize": "false",
- "formatter": "function(cellvalue, options, rowObject){ var temp =\"<div style='margin-left:8px;'><div title='璇︽儏璁板綍' style='float:left;cursor:pointer;' class='ui-pg-div' id='jEditButton_3' onclick='detail(\" + rowObject + \")' onmouseover='jQuery(this).addClass('ui-state-hover');' onmouseout='jQuery(this).removeClass('ui-state-hover');'><span class='ui-icon fa-search-plus'/></div></div>\";return temp; }"
- }
-**/
-
-
-
-insert into c_template(template_code,name,html_name,url) values('app','澶栭儴搴旂敤','list_template','LIST->query.center.apps;QUERY->query.center.app');
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('app','鍒桰D','id','{ "name": "id","index": "id","width": "20",
- "editable": true,
- "sorttype": "int" }',1);
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('app','AppId','domain','{ "name": "appId","index": "appId","width": "40",
- "editable": true
- }',2);
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('app','鍚嶇О','name','{ "name": "name","index": "name","width": "50",
- "editable": true }',3);
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('app','绉橀挜','securityCode','{ "name": "securityCode","index": "securityCode","width": "50",
- "editable": true }',4);
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('app','鐧藉悕鍗�','whileListIp','{ "name": "whileListIp","index": "whileListIp","width": "90",
- "editable": true }',5);
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('app','榛戝悕鍗�','blackListIp','{ "name": "blackListIp","index": "blackListIp","width": "40",
- "editable": true }',6);
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('app','澶囨敞','value','{ "name": "remark","index": "remark","width": "90",
- "editable": true }',7);
-
-INSERT INTO c_template_col(template_code,col_name,col_code,col_model,seq) VALUES('app','BUTTON','BUTTON','{
- "name": "detail",
- "index": "",
- "width": "40",
- "fixed": "true",
- "sortable": "false",
- "resize": "false",
- "formatter": "function(cellvalue, options, rowObject){\n var temp =\"<div style=''margin-left:8px;''><div title=''璇︽儏璁板綍'' style=''float:left;cursor:pointer;'' class=''ui-pg-div'' id=''jEditButton_3'' onclick=''detail(\"+rowObject+\")'' onmouseover=''jQuery(this).addClass(''ui-state-hover'');'' onmouseout=''jQuery(this).removeClass(''ui-state-hover'');''><span class=''ui-icon fa-search-plus''/></div></div>\";\n return temp; \n}"
- }',8);
-
-
-insert into c_template(template_code,name,html_name,url) values('service','鏈嶅姟绠＄悊','list_template','LIST->query.center.services;QUERY->query.center.service');
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('service','鏈嶅姟ID','serviceId','{ "name": "serviceId","index": "serviceId","width": "20",
- "editable": true,
- "sorttype": "int" }',1);
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('service','鏈嶅姟缂栫爜','serviceCode','{ "name": "serviceCode","index": "serviceCode","width": "40",
- "editable": true
- }',2);
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('service','涓氬姟绫诲瀷','businessTypeCd','{ "name": "businessTypeCd","index": "businessTypeCd","width": "50",
- "editable": true }',3);
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('service','鍚嶇О','name','{ "name": "name","index": "name","width": "40",
- "editable": true }',4);
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('service','娑堟伅闃熷垪','messageQueueName','{ "name": "messageQueueName","index": "messageQueueName","width": "10",
- "editable": true }',5);
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('service','闇�瑕両nstance','isInstance','{ "name": "isInstance","index": "isInstance","width": "10",
- "editable": true }',6);
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('service','URL','url','{ "name": "url","index": "url","width": "60",
- "editable": true }',7);
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('service','鎻愪緵鑰匒ppId','provideAppId','{ "name": "provideAppId","index": "provideAppId","width": "10",
- "editable": true }',8);
-
-INSERT INTO c_template_col(template_code,col_name,col_code,col_model,seq) VALUES('service','BUTTON','BUTTON','{
- "name": "detail",
- "index": "",
- "width": "40",
- "fixed": "true",
- "sortable": "false",
- "resize": "false",
- "formatter": "function(cellvalue, options, rowObject){\n var temp =\"<div style=''margin-left:8px;''><div title=''璇︽儏璁板綍'' style=''float:left;cursor:pointer;'' class=''ui-pg-div'' id=''jEditButton_3'' onclick=''detail(\"+rowObject+\")'' onmouseover=''jQuery(this).addClass(''ui-state-hover'');'' onmouseout=''jQuery(this).removeClass(''ui-state-hover'');''><span class=''ui-icon fa-search-plus''/></div></div>\";\n return temp; \n}"
- }',9);
-
-
-insert into c_template(template_code,name,html_name,url) values('route','璺敱绠＄悊','list_template','LIST->query.center.routes;QUERY->query.center.route');
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('route','璺敱ID','id','{ "name": "id","index": "id","width": "10",
- "editable": true,
- "sorttype": "int" }',1);
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('route','AppId','appId','{ "name": "appId","index": "appId","width": "30",
- "editable": true
- }',2);
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('route','鏈嶅姟ID','serviceId','{ "name": "serviceId","index": "serviceId","width": "30",
- "editable": true }',3);
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('route','璋冪敤鏂瑰紡','invokeModel','{ "name": "invokeModel","index": "invokeModel","width": "50",
- "editable": true }',4);
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('route','鏈嶅姟鍚嶇О','serviceName','{ "name": "serviceName","index": "serviceName","width": "30",
- "editable": true }',5);
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('route','鏈嶅姟缂栫爜','serviceCode','{ "name": "serviceCode","index": "serviceCode","width": "30",
- "editable": true }',6);
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('route','璁㈠崟绫诲瀷','orderTypeCd','{ "name": "orderTypeCd","index": "orderTypeCd","width": "30",
- "editable": true }',7);
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('route','璋冪敤娆℃暟闄愬埗','invokelimitTimes','{ "name": "invokelimitTimes","index": "invokelimitTimes","width": "40",
- "editable": true }',8);
-
-INSERT INTO c_template_col(template_code,col_name,col_code,col_model,seq) VALUES('route','BUTTON','BUTTON','{
- "name": "detail",
- "index": "",
- "width": "40",
- "fixed": "true",
- "sortable": "false",
- "resize": "false",
- "formatter": "function(cellvalue, options, rowObject){\n var temp =\"<div style=''margin-left:8px;''><div title=''璇︽儏璁板綍'' style=''float:left;cursor:pointer;'' class=''ui-pg-div'' id=''jEditButton_3'' onclick=''detail(\"+rowObject+\")'' onmouseover=''jQuery(this).addClass(''ui-state-hover'');'' onmouseout=''jQuery(this).removeClass(''ui-state-hover'');''><span class=''ui-icon fa-search-plus''/></div></div>\";\n return temp; \n}"
-
-
-insert into c_template(template_code,name,html_name,url) values('cache','鍒锋柊缂撳瓨','list_template_cache','LIST->query.center.caches;QUERY->query.center.cacheOne');
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('cache','缂撳瓨ID','id','{ "name": "id","index": "id","width": "10",
- "editable": true,
- "sorttype": "int" }',1);
-
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('cache','缂撳瓨缂栫爜','cacheCode','{ "name": "cacheCode","index": "cacheCode","width": "30",
- "editable": true }',2);
-insert into c_template_col(template_code,col_name,col_code,col_model,seq) values('cache','缂撳瓨鍚嶇О','cacheName','{ "name": "cacheName","index": "cacheName","width": "30",
- "editable": true }',3);
-INSERT INTO c_template_col(template_code,col_name,col_code,col_model,seq) VALUES('cache','BUTTON','BUTTON','{
- "name": "detail",
- "index": "",
- "width": "40",
- "fixed": "true",
- "sortable": "false",
- "resize": "false",
- "formatter": ""function(cellvalue, options, rowObject){ var temp =\"<div style='margin-left:8px;'><button type='button' class='btn btn-warning' style='border-radius: .25rem;' onclick='flush(this,\"+rowObject.cacheCode+\")'>鍒锋柊缂撳瓨</button></div>\";return temp; }"
- }',4);
-
-
--- 缂撳瓨閰嶇疆琛�
-CREATE TABLE c_cache(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT '缂撳瓨ID',
- cache_code VARCHAR(10) NOT NULL UNIQUE COMMENT '缂撳瓨缂栫爜 寮�濮嬩簬1001',
- service_code VARCHAR(50) NOT NULL COMMENT '璋冪敤鏈嶅姟缂栫爜 瀵瑰簲 c_service',
- `name` VARCHAR(50) NOT NULL COMMENT '鍓嶅彴鏄剧ず鍚嶇О',
- param LONGTEXT NOT NULL COMMENT '璇锋眰缂撳瓨绯荤粺鏃剁殑鍙傛暟',
- seq INT NOT NULL COMMENT '鍒楅『搴�',
- `group` VARCHAR(10) NOT NULL DEFAULT 'COMMON' COMMENT '缁勶紝缂撳瓨灞炰簬鍝釜缁�',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝0鍦ㄧ敤锛�1澶辨晥'
-);
--- 缂撳瓨鐢ㄦ埛琛�
-create table c_cache_2_user(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT '缂撳瓨鐢ㄦ埛ID',
- cache_code int not null comment '缂撳瓨缂栫爜',
- user_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澶辨晥'
-);
-
-
-insert into c_cache (cache_code,service_code,`name`,param,seq) values('1001','flush.center.cache','鏄犲皠缂撳瓨锛坈_mapping琛級','{"cacheName":"MAPPING"}',1);
-insert into c_cache (cache_code,service_code,`name`,param,seq) values('1002','flush.center.cache','涓氬姟閰嶇疆缂撳瓨锛坈_app,c_service,c_route琛級','{"cacheName":"APP_ROUTE_SERVICE"}',2);
-insert into c_cache (cache_code,service_code,`name`,param,seq) values('1003','flush.center.cache','鍏敤鏈嶅姟缂撳瓨锛坈_service_sql琛級','{"cacheName":"SERVICE_SQL"}',3);
-
-insert into c_cache_2_user(cache_code,user_id) values('1001','10001');
-insert into c_cache_2_user(cache_code,user_id) values('1002','10001');
-insert into c_cache_2_user(cache_code,user_id) values('1003','10001');
-
-
-
-create table l_transaction_log(
- log_id varchar(30) not null COMMENT 'id',
- transaction_id VARCHAR(30) NOT NULL COMMENT '澶栭儴浜ゆ槗娴佹按',
- contract_id varchar(64) not null comment '涓婁笅鏂嘔D',
- ip varchar(20) not null comment '鏃ュ織浜х敓涓绘満IP',
- port varchar(10) not null comment '鏃ュ織浜х敓绔彛',
- src_ip varchar(20) comment '璋冪敤鏂笽P',
- src_port varchar(10) comment '璋冪敤鏂圭鍙�',
- app_id varchar(30) not null comment '璋冪敤鏂瑰簲鐢↖D',
- user_id varchar(30) comment '鐢ㄦ埛ID',
- service_code varchar(50) comment '鏈嶅姟缂栫爜',
- service_name varchar(50) comment '鏈嶅姟鍚嶇О',
- timestamp TIMESTAMP NOT NULL comment '鏃ュ織浜や簰鏃堕棿锛屾椂闂存埑',
- cost_time int not null default 0 comment '鑰楁椂',
- status_cd varchar(2) not null comment '浜や簰鐘舵�� S 鎴愬姛 F 澶辫触',
- month INT NOT NULL comment '鏈堜唤',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- unique KEY (log_id,month)
-)
-partition BY RANGE (month) (
- partition transaction_log_1 VALUES LESS THAN (2),
- partition transaction_log_2 VALUES LESS THAN (3),
- partition transaction_log_3 VALUES LESS THAN (4),
- partition transaction_log_4 VALUES LESS THAN (5),
- partition transaction_log_5 VALUES LESS THAN (6),
- partition transaction_log_6 VALUES LESS THAN (7),
- partition transaction_log_7 VALUES LESS THAN (8),
- partition transaction_log_8 VALUES LESS THAN (9),
- partition transaction_log_9 VALUES LESS THAN (10),
- partition transaction_log_10 VALUES LESS THAN (11),
- partition transaction_log_11 VALUES LESS THAN (12),
- partition transaction_log_12 VALUES LESS THAN (13)
-);
-
-
-
--- 鏃ュ織鍘熷鍐呭琛�
-
-create table l_transaction_log_message(
- log_id varchar(30) not null COMMENT 'id',
- request_header LONGTEXT COMMENT '璇锋眰澶翠俊鎭�',
- response_header LONGTEXT COMMENT '杩斿洖澶翠俊鎭�',
- request_message LONGTEXT comment '璇锋眰鎶ユ枃',
- response_message LONGTEXT comment '杩斿洖鎶ユ枃',
- remark varchar(200) comment '澶囨敞',
- month INT NOT NULL comment '鏈堜唤',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- UNIQUE KEY (log_id,`month`)
-)
-partition BY RANGE (month) (
- partition transaction_log_message_1 VALUES LESS THAN (2),
- partition transaction_log_message_2 VALUES LESS THAN (3),
- partition transaction_log_message_3 VALUES LESS THAN (4),
- partition transaction_log_message_4 VALUES LESS THAN (5),
- partition transaction_log_message_5 VALUES LESS THAN (6),
- partition transaction_log_message_6 VALUES LESS THAN (7),
- partition transaction_log_message_7 VALUES LESS THAN (8),
- partition transaction_log_message_8 VALUES LESS THAN (9),
- partition transaction_log_message_9 VALUES LESS THAN (10),
- partition transaction_log_message_10 VALUES LESS THAN (11),
- partition transaction_log_message_11 VALUES LESS THAN (12),
- partition transaction_log_message_12 VALUES LESS THAN (13)
-);
-
-
-
-create table business_shop(
- shop_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧ID',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- catalog_id varchar(30) not null comment '鐩綍ID',
- store_id VARCHAR(30) NOT NULL COMMENT '鍟嗗簵ID',
- `name` VARCHAR(100) NOT NULL COMMENT '鍟嗗搧鍚嶇О',
- hot_buy varchar(2) not null default 'N' comment '鏄惁鐑崠 Y鏄� N鍚�',
- sale_price DECIMAL(10,2) not null comment '鍟嗗搧閿�鍞环,鍐嶆病鏈夋墦鎶樻儏鍐典笅鏄剧ず',
- open_shop_count varchar(2) not null default 'N' comment '鏄惁寮�鍚簱瀛樼鐞嗭紝榛樿N Y寮�鍚紝N鍏抽棴锛屽紑鍚悗鐣岄潰鏄剧ず鏁伴噺锛屽鏋滀负0 鍒欎笅鏋�',
- shop_count DECIMAL(10,0) not null default 10000 comment '鍟嗗搧搴撳瓨',
- start_date date not null comment '鍟嗗搧寮�濮嬫椂闂�',
- end_date date 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_shop_1 VALUES LESS THAN (2),
- PARTITION business_shop_2 VALUES LESS THAN (3),
- PARTITION business_shop_3 VALUES LESS THAN (4),
- PARTITION business_shop_4 VALUES LESS THAN (5),
- PARTITION business_shop_5 VALUES LESS THAN (6),
- PARTITION business_shop_6 VALUES LESS THAN (7),
- PARTITION business_shop_7 VALUES LESS THAN (8),
- PARTITION business_shop_8 VALUES LESS THAN (9),
- PARTITION business_shop_9 VALUES LESS THAN (10),
- PARTITION business_shop_10 VALUES LESS THAN (11),
- PARTITION business_shop_11 VALUES LESS THAN (12),
- PARTITION business_shop_12 VALUES LESS THAN (13)
-);
-CREATE INDEX idx_business_shop_shop_id ON business_shop(shop_id);
-CREATE INDEX idx_business_shop_b_id ON business_shop(b_id);
--- 鍟嗗搧灞炴�ц〃
-create table business_shop_attr(
- b_id VARCHAR(30) NOT NULL COMMENT '璁㈠崟ID',
- attr_id VARCHAR(30) NOT NULL COMMENT '灞炴�d',
- shop_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_shop_attr_1 VALUES LESS THAN (2),
- PARTITION business_shop_attr_2 VALUES LESS THAN (3),
- PARTITION business_shop_attr_3 VALUES LESS THAN (4),
- PARTITION business_shop_attr_4 VALUES LESS THAN (5),
- PARTITION business_shop_attr_5 VALUES LESS THAN (6),
- PARTITION business_shop_attr_6 VALUES LESS THAN (7),
- PARTITION business_shop_attr_7 VALUES LESS THAN (8),
- PARTITION business_shop_attr_8 VALUES LESS THAN (9),
- PARTITION business_shop_attr_9 VALUES LESS THAN (10),
- PARTITION business_shop_attr_10 VALUES LESS THAN (11),
- PARTITION business_shop_attr_11 VALUES LESS THAN (12),
- PARTITION business_shop_attr_12 VALUES LESS THAN (13)
-);
-CREATE INDEX idx_business_shop_attr_shop_id ON business_shop_attr(shop_id);
-CREATE INDEX idx_business_shop_attr_b_id ON business_shop_attr(b_id);
-
--- 鍟嗗搧 鐩綍
-create table business_shop_catalog(
- catalog_id varchar(30) not null comment '鐩綍ID',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- store_id VARCHAR(30) NOT NULL COMMENT '鍟嗗簵ID',
- `name` varchar(100) not null comment '鐩綍鍚嶇О',
- level varchar(2) not null comment '鐩綍绛夌骇',
- parent_catalog_id varchar(30) not null default '-1' comment '鐖剁洰褰旾D锛屼竴绾х洰褰曞垯鍐�-1',
- `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_shop_catalog_1 VALUES LESS THAN (2),
- PARTITION business_shop_catalog_2 VALUES LESS THAN (3),
- PARTITION business_shop_catalog_3 VALUES LESS THAN (4),
- PARTITION business_shop_catalog_4 VALUES LESS THAN (5),
- PARTITION business_shop_catalog_5 VALUES LESS THAN (6),
- PARTITION business_shop_catalog_6 VALUES LESS THAN (7),
- PARTITION business_shop_catalog_7 VALUES LESS THAN (8),
- PARTITION business_shop_catalog_8 VALUES LESS THAN (9),
- PARTITION business_shop_catalog_9 VALUES LESS THAN (10),
- PARTITION business_shop_catalog_10 VALUES LESS THAN (11),
- PARTITION business_shop_catalog_11 VALUES LESS THAN (12),
- PARTITION business_shop_catalog_12 VALUES LESS THAN (13)
-);
-CREATE INDEX idx_business_shop_catalog_store_id ON business_shop_catalog(store_id);
-CREATE INDEX idx_business_shop_catalog_b_id ON business_shop_catalog(b_id);
-
-
--- 鍟嗗簵鐓х墖
-CREATE TABLE business_shop_photo(
- shop_photo_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧鐓х墖ID',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- shop_id VARCHAR(30) NOT NULL COMMENT '鍟嗗簵ID',
- shop_photo_type_cd VARCHAR(12) NOT NULL COMMENT '鍟嗗搧鐓х墖绫诲瀷,L logo O 鍏朵粬鐓х墖',
- 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_shop_photo_1 VALUES LESS THAN (2),
- PARTITION business_shop_photo_2 VALUES LESS THAN (3),
- PARTITION business_shop_photo_3 VALUES LESS THAN (4),
- PARTITION business_shop_photo_4 VALUES LESS THAN (5),
- PARTITION business_shop_photo_5 VALUES LESS THAN (6),
- PARTITION business_shop_photo_6 VALUES LESS THAN (7),
- PARTITION business_shop_photo_7 VALUES LESS THAN (8),
- PARTITION business_shop_photo_8 VALUES LESS THAN (9),
- PARTITION business_shop_photo_9 VALUES LESS THAN (10),
- PARTITION business_shop_photo_10 VALUES LESS THAN (11),
- PARTITION business_shop_photo_11 VALUES LESS THAN (12),
- PARTITION business_shop_photo_12 VALUES LESS THAN (13)
-);
-
-CREATE INDEX idx_business_shop_photo_shop_id ON business_shop_photo(shop_id);
-CREATE INDEX idx_business_shop_photo_b_id ON business_shop_photo(b_id);
-
-
--- 鍟嗗搧灞炴�� 绂绘暎鍊艰〃锛屼緥濡� 鎵嬫満棰滆壊 榛� 鐧� 绾�
-create table business_shop_attr_param(
- attr_param_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧灞炴�у弬鏁癐D',
- b_id VARCHAR(30) NOT NULL COMMENT '璁㈠崟ID',
- shop_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧ID',
- spec_cd VARCHAR(12) NOT NULL COMMENT '瑙勬牸id,鍙傝�僺pec琛�',
- param 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_shop_attr_param_1 VALUES LESS THAN (2),
- PARTITION business_shop_attr_param_2 VALUES LESS THAN (3),
- PARTITION business_shop_attr_param_3 VALUES LESS THAN (4),
- PARTITION business_shop_attr_param_4 VALUES LESS THAN (5),
- PARTITION business_shop_attr_param_5 VALUES LESS THAN (6),
- PARTITION business_shop_attr_param_6 VALUES LESS THAN (7),
- PARTITION business_shop_attr_param_7 VALUES LESS THAN (8),
- PARTITION business_shop_attr_param_8 VALUES LESS THAN (9),
- PARTITION business_shop_attr_param_9 VALUES LESS THAN (10),
- PARTITION business_shop_attr_param_10 VALUES LESS THAN (11),
- PARTITION business_shop_attr_param_11 VALUES LESS THAN (12),
- PARTITION business_shop_attr_param_12 VALUES LESS THAN (13)
-);
-
-CREATE INDEX idx_business_shop_attr_param_shop_id ON business_shop_attr_param(shop_id);
-CREATE INDEX idx_business_shop_attr_param_b_id ON business_shop_attr_param(b_id);
-
--- 鍟嗗搧浼樻儬琛�
-CREATE TABLE business_shop_preferential(
- shop_preferential_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧ID',
- shop_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧ID',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- original_price DECIMAL(10,2) NOT NULL COMMENT '鍟嗗搧閿�鍞环锛屽啀娌℃湁浼樻儬鐨勬儏鍐典笅鍜屽敭浠锋槸涓�鑷寸殑',
- discount_rate DECIMAL(3,2) NOT NULL DEFAULT 1.00 COMMENT '鍟嗗搧鎵撴姌鐜�',
- show_original_price VARCHAR(2) NOT NULL DEFAULT 'N' COMMENT '鏄惁鏄剧ず鍘熶环锛孻鏄剧ず锛孨 涓嶆樉绀�',
- preferential_start_date DATE NOT NULL COMMENT '鍟嗗搧浼樻儬寮�濮嬫椂闂�',
- preferential_end_date DATE 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_shop_preferential_1 VALUES LESS THAN (2),
- PARTITION business_shop_preferential_2 VALUES LESS THAN (3),
- PARTITION business_shop_preferential_3 VALUES LESS THAN (4),
- PARTITION business_shop_preferential_4 VALUES LESS THAN (5),
- PARTITION business_shop_preferential_5 VALUES LESS THAN (6),
- PARTITION business_shop_preferential_6 VALUES LESS THAN (7),
- PARTITION business_shop_preferential_7 VALUES LESS THAN (8),
- PARTITION business_shop_preferential_8 VALUES LESS THAN (9),
- PARTITION business_shop_preferential_9 VALUES LESS THAN (10),
- PARTITION business_shop_preferential_10 VALUES LESS THAN (11),
- PARTITION business_shop_preferential_11 VALUES LESS THAN (12),
- PARTITION business_shop_preferential_12 VALUES LESS THAN (13)
-);
-CREATE INDEX idx_business_shop_preferential_shop_id ON business_shop_preferential(shop_id);
-CREATE INDEX idx_business_shop_preferential_b_id ON business_shop_preferential(b_id);
--- 鍟嗗搧鎻忚堪
-create table business_shop_desc(
- shop_desc_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧鎻忚堪ID',
- shop_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧ID',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- shop_describe LONGTEXT 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_shop_desc_1 VALUES LESS THAN (2),
- PARTITION business_shop_desc_2 VALUES LESS THAN (3),
- PARTITION business_shop_desc_3 VALUES LESS THAN (4),
- PARTITION business_shop_desc_4 VALUES LESS THAN (5),
- PARTITION business_shop_desc_5 VALUES LESS THAN (6),
- PARTITION business_shop_desc_6 VALUES LESS THAN (7),
- PARTITION business_shop_desc_7 VALUES LESS THAN (8),
- PARTITION business_shop_desc_8 VALUES LESS THAN (9),
- PARTITION business_shop_desc_9 VALUES LESS THAN (10),
- PARTITION business_shop_desc_10 VALUES LESS THAN (11),
- PARTITION business_shop_desc_11 VALUES LESS THAN (12),
- PARTITION business_shop_desc_12 VALUES LESS THAN (13)
-);
-CREATE INDEX idx_business_shop_desc_shop_id ON business_shop_desc(shop_id);
-CREATE INDEX idx_business_shop_desc_b_id ON business_shop_desc(b_id);
-
-
--- create 鍟嗗搧琛�
-create table s_shop(
- shop_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧ID',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- store_id VARCHAR(30) NOT NULL COMMENT '鍟嗗簵ID',
- catalog_id varchar(30) not null comment '鐩綍ID',
- `name` VARCHAR(100) NOT NULL COMMENT '鍟嗗搧鍚嶇О',
- hot_buy varchar(2) not null default 'N' comment '鏄惁鐑崠 Y鏄� N鍚�',
- sale_price DECIMAL(10,2) not null comment '鍟嗗搧閿�鍞环,鍐嶆病鏈夋墦鎶樻儏鍐典笅鏄剧ず',
- open_shop_count varchar(2) not null default 'N' comment '鏄惁寮�鍚簱瀛樼鐞嗭紝榛樿N Y寮�鍚紝N鍏抽棴锛屽紑鍚悗鐣岄潰鏄剧ず鏁伴噺锛屽鏋滀负0 鍒欎笅鏋�',
- shop_count DECIMAL(10,0) not null default 10000 comment '鍟嗗搧搴撳瓨',
- start_date date not null comment '鍟嗗搧寮�濮嬫椂闂�',
- end_date date 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 (shop_id)
-);
-CREATE INDEX idx_store_b_id ON s_shop(b_id);
-CREATE UNIQUE INDEX idx_shop_shop_id ON s_shop(shop_id);
--- 鍟嗗搧灞炴�ц〃
-create table s_shop_attr(
- b_id VARCHAR(30) NOT NULL COMMENT '璁㈠崟ID',
- attr_id VARCHAR(30) NOT NULL COMMENT '灞炴�d',
- shop_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 INDEX idx_store_attr_b_id ON s_shop_attr(b_id);
-CREATE INDEX idx_shop_attr_shop_id ON s_shop_attr(shop_id);
-
--- 鍟嗗搧灞炴�� 绂绘暎鍊艰〃锛屼緥濡� 鎵嬫満棰滆壊 榛� 鐧� 绾�
-create table s_shop_attr_param(
- attr_param_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧灞炴�у弬鏁癐D',
- b_id VARCHAR(30) NOT NULL COMMENT '璁㈠崟ID',
- shop_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧ID',
- spec_cd VARCHAR(12) NOT NULL COMMENT '瑙勬牸id,鍙傝�僺pec琛�',
- param 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_param_id)
-);
-CREATE INDEX idx_shop_attr_param_b_id ON s_shop_attr_param(b_id);
-CREATE INDEX idx_shop_attr_param_shop_id ON s_shop_attr_param(shop_id);
-
--- 鍟嗗搧浼樻儬琛�
-create table s_shop_preferential(
- shop_preferential_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧ID',
- shop_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧ID',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- original_price DECIMAL(10,2) not null comment '鍟嗗搧閿�鍞环锛屽啀娌℃湁浼樻儬鐨勬儏鍐典笅鍜屽敭浠锋槸涓�鑷寸殑',
- discount_rate decimal(3,2) not null default 1.00 comment '鍟嗗搧鎵撴姌鐜�',
- show_original_price varchar(2) not null default 'N' comment '鏄惁鏄剧ず鍘熶环锛孻鏄剧ず锛孨 涓嶆樉绀�',
- preferential_start_date date not null comment '鍟嗗搧浼樻儬寮�濮嬫椂闂�',
- preferential_end_date date 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 (shop_preferential_id)
-);
-CREATE INDEX idx_shop_preferential_b_id ON s_shop_preferential(b_id);
-CREATE INDEX idx_shop_preferential_shop_id ON s_shop_preferential(shop_id);
--- 鍟嗗搧鎻忚堪
-create table s_shop_desc(
- shop_desc_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧鎻忚堪ID',
- shop_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧ID',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- shop_describe LONGTEXT 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 (shop_desc_id)
-);
-CREATE INDEX idx_shop_desc_b_id ON s_shop_desc(b_id);
-CREATE INDEX idx_shop_desc_shop_id ON s_shop_desc(shop_id);
-
--- 鍟嗗簵鐓х墖
-CREATE TABLE s_shop_photo(
- shop_photo_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧鐓х墖ID',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- shop_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧ID',
- shop_photo_type_cd VARCHAR(12) NOT NULL COMMENT '鍟嗗搧鐓х墖绫诲瀷,L logo O 鍏朵粬鐓х墖',
- 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澶辨晥',
- UNIQUE KEY (shop_photo_id)
-);
-CREATE INDEX idx_shop_photo_b_id ON s_shop_photo(b_id);
-CREATE INDEX idx_shop_photo_shop_id ON s_shop_photo(shop_id);
-CREATE INDEX idx_shop_photo_shop_photo_id ON s_shop_photo(shop_photo_id);
-
-create table s_shop_catalog(
- catalog_id varchar(30) not null comment '鐩綍ID',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- store_id VARCHAR(30) NOT NULL COMMENT '鍟嗗簵ID',
- `name` varchar(100) not null comment '鐩綍鍚嶇О',
- level varchar(2) not null comment '鐩綍绛夌骇',
- parent_catalog_id varchar(30) not null default '-1' comment '鐖剁洰褰旾D锛屼竴绾х洰褰曞垯鍐�-1',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥',
- UNIQUE KEY (catalog_id)
-);
-CREATE INDEX idx_shop_catalog_b_id ON s_shop_catalog(b_id);
-CREATE INDEX idx_shop_catalog_store_id ON s_shop_catalog(store_id);
-CREATE INDEX idx_shop_catalog_catalog_id ON s_shop_catalog(catalog_id);
-
--- 鍟嗗搧璐拱璁板綍
-
-CREATE TABLE s_buy_shop(
- buy_id VARCHAR(30) NOT NULL COMMENT '璐拱ID',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- shop_id VARCHAR(30) NOT NULL COMMENT '鍟嗗搧ID',
- buy_count DECIMAL(10,0) NOT NULL DEFAULT 1 COMMENT '璐拱鍟嗗搧鏁�',
- `month` INT 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 (buy_id,`month`)
-)
-PARTITION BY RANGE (`month`) (
- PARTITION buy_shop_1 VALUES LESS THAN (2),
- PARTITION buy_shop_2 VALUES LESS THAN (3),
- PARTITION buy_shop_3 VALUES LESS THAN (4),
- PARTITION buy_shop_4 VALUES LESS THAN (5),
- PARTITION buy_shop_5 VALUES LESS THAN (6),
- PARTITION buy_shop_6 VALUES LESS THAN (7),
- PARTITION buy_shop_7 VALUES LESS THAN (8),
- PARTITION buy_shop_8 VALUES LESS THAN (9),
- PARTITION buy_shop_9 VALUES LESS THAN (10),
- PARTITION buy_shop_10 VALUES LESS THAN (11),
- PARTITION buy_shop_11 VALUES LESS THAN (12),
- PARTITION buy_shop_12 VALUES LESS THAN (13)
-);
-CREATE INDEX idx_buy_shop_b_id ON s_buy_shop(b_id);
--- 鍟嗗搧璐拱灞炴��
-create table s_buy_shop_attr(
- b_id VARCHAR(30) NOT NULL COMMENT '璁㈠崟ID',
- attr_id VARCHAR(30) NOT NULL COMMENT '灞炴�d',
- buy_id VARCHAR(30) NOT NULL COMMENT '璐拱ID buy_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 '鍒涘缓鏃堕棿',
- status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥',
- UNIQUE KEY (attr_id,`month`)
-)
-PARTITION BY RANGE (`month`) (
- PARTITION buy_shop_attr_1 VALUES LESS THAN (2),
- PARTITION buy_shop_attr_2 VALUES LESS THAN (3),
- PARTITION buy_shop_attr_3 VALUES LESS THAN (4),
- PARTITION buy_shop_attr_4 VALUES LESS THAN (5),
- PARTITION buy_shop_attr_5 VALUES LESS THAN (6),
- PARTITION buy_shop_attr_6 VALUES LESS THAN (7),
- PARTITION buy_shop_attr_7 VALUES LESS THAN (8),
- PARTITION buy_shop_attr_8 VALUES LESS THAN (9),
- PARTITION buy_shop_attr_9 VALUES LESS THAN (10),
- PARTITION buy_shop_attr_10 VALUES LESS THAN (11),
- PARTITION buy_shop_attr_11 VALUES LESS THAN (12),
- PARTITION buy_shop_attr_12 VALUES LESS THAN (13)
-);
-CREATE INDEX idx_buy_shop_attr_b_id ON s_buy_shop_attr(b_id);
-CREATE INDEX idx_buy_shop_attr_buy_id ON s_buy_shop_attr(buy_id);
-
-
-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 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',
- 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 '灞炴�у��',
- `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 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 '鐓х墖',
- `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',
- 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 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 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_cd VARCHAR(10) 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澶辨晥',
- 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(
- 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 '灞炴�у��',
- 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 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(
- 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 '鐓х墖',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- 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(
- 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 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澶辨晥',
- 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 store_type(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- 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 business_user(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
- name VARCHAR(50) NOT NULL COMMENT '鍚嶇О',
- email VARCHAR(30) COMMENT '閭鍦板潃',
- address VARCHAR(200) COMMENT '鐜板眳浣忓湴鍧�',
- password varchar(128) comment '鐢ㄦ埛瀵嗙爜锛屽姞瀵嗚繃鍚�',
- location_cd varchar(8) comment '鐢ㄦ埛鍦板尯锛岀紪鐮佽瑙� u_location',
- age int comment '鐢ㄦ埛骞撮緞',
- sex varchar(1) comment '鎬у埆锛�0琛ㄧず鐢峰 1琛ㄧず濂冲',
- tel varchar(11) comment '鐢ㄦ埛鎵嬫満',
- level_cd varchar(2) not null default '0' comment '鐢ㄦ埛绾у埆,鍏宠仈user_level',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- operate VARCHAR(3) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL'
-);
-
--- user_level
-
-CREATE TABLE user_level(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- level_cd VARCHAR(4) NOT NULL UNIQUE COMMENT '鐢ㄦ埛绾у埆',
- `name` VARCHAR(50) NOT NULL COMMENT '鍚嶇О',
- description VARCHAR(200) COMMENT '鎻忚堪',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿'
-);
-
-insert into user_level(level_cd,name,description) values('0','鏅�氱敤鎴�','鏅�氱敤鎴�');
-
--- u_location
-CREATE TABLE u_location(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- location_cd VARCHAR(4) NOT NULL UNIQUE COMMENT '鍖哄煙缂栫爜',
- level VARCHAR(4) not null comment '鍖哄煙绾у埆锛�1 琛ㄧず涓�绾у湴鍖�',
- `name` VARCHAR(50) NOT NULL COMMENT '鍖哄煙鍚嶇О',
- description VARCHAR(200) COMMENT '鎻忚堪',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿'
-);
-
--- business_user_attr
-CREATE TABLE business_user_attr(
- b_id VARCHAR(30) NOT NULL COMMENT '璁㈠崟ID',
- attr_id VARCHAR(30) NOT NULL COMMENT '灞炴�d',
- user_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 '鍒涘缓鏃堕棿',
- operate VARCHAR(3) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL'
-);
-
--- u_user
-create table u_user(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- user_id VARCHAR(30) NOT NULL UNIQUE COMMENT '鐢ㄦ埛ID',
- name VARCHAR(50) NOT NULL COMMENT '鍚嶇О',
- email VARCHAR(30) COMMENT '閭鍦板潃',
- address VARCHAR(200) COMMENT '鐜板眳浣忓湴鍧�',
- password varchar(128) comment '鐢ㄦ埛瀵嗙爜锛屽姞瀵嗚繃鍚�',
- location_cd varchar(8) comment '鐢ㄦ埛鍦板尯锛岀紪鐮佽瑙� u_location',
- age int comment '鐢ㄦ埛骞撮緞',
- sex varchar(1) comment '鎬у埆锛�0琛ㄧず鐢峰 1琛ㄧず濂冲',
- tel varchar(11) comment '鐢ㄦ埛鎵嬫満',
- level_cd varchar(2) not null default '0' comment '鐢ㄦ埛绾у埆,鍏宠仈user_level',
- b_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琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥'
-);
-
-
--- u_user_attr
-
-CREATE TABLE u_user_attr(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- attr_id VARCHAR(30) NOT NULL COMMENT '灞炴�d',
- user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
- spec_cd VARCHAR(12) NOT NULL COMMENT '瑙勬牸id,鍙傝�僺pec琛�',
- value VARCHAR(50) NOT NULL COMMENT '灞炴�у��',
- b_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琛紝S 淇濆瓨锛�0鍦ㄧ敤锛�1澶辨晥'
-);
--- 鐢ㄦ埛 鐗╂祦鍦板潃
-create table business_user_address(
- address_id VARCHAR(30) NOT NULL COMMENT '鍦板潃ID',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
- tel varchar(11) not null comment '鐢佃瘽',
- postal_code varchar(10) not null comment '閭斂缂栫爜',
- address varchar(200) not null comment '鍦板潃',
- is_default varchar(1) not null comment '鏄惁涓洪粯璁ゅ湴鍧� 1锛岃〃绀洪粯璁ゅ湴鍧� 0 鎴栫┖涓嶆槸榛樿鍦板潃',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- operate VARCHAR(3) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL'
-);
-
--- u_user_address
-create table u_user_address(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- address_id VARCHAR(30) NOT NULL COMMENT '鍦板潃ID',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
- tel varchar(11) not null comment '鐢佃瘽',
- postal_code varchar(10) not null comment '閭斂缂栫爜',
- address varchar(200) not null comment '鍦板潃',
- is_default varchar(1) not null comment '鏄惁涓洪粯璁ゅ湴鍧� 1锛岃〃绀洪粯璁ゅ湴鍧� 0 鎴栫┖涓嶆槸榛樿鍦板潃',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- status_cd VARCHAR(2) NOT NULL default '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0鍦ㄧ敤锛�1澶辨晥'
-);
--- 鐢ㄦ埛鏍囩
-create table business_user_tag(
- tag_id VARCHAR(30) NOT NULL COMMENT '鎵撴爣ID',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
- tag_cd VARCHAR(12) NOT NULL COMMENT '鏍囩缂栫爜,鍙傝�僼ag琛�',
- remark VARCHAR(200) COMMENT '澶囨敞',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- operate VARCHAR(3) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL'
-
-);
-
--- 鐢ㄦ埛鏍囩
-create table u_user_tag(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- tag_id VARCHAR(30) NOT NULL COMMENT '鎵撴爣ID',
- user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
- tag_cd VARCHAR(12) NOT NULL COMMENT '鏍囩缂栫爜,鍙傝�僼ag琛�',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- remark VARCHAR(200) COMMENT '澶囨敞',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- status_cd VARCHAR(2) NOT NULL default '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0鍦ㄧ敤锛�1澶辨晥'
-);
-
--- 鏍囩
-create table tag(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- domain varchar(20) not null comment '鏍囩鍩�',
- tag_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 table business_user_credentials(
- credentials_id VARCHAR(30) NOT NULL COMMENT '璇佷欢ID',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
- credentials_cd varchar(12) not null comment '璇佷欢绫诲瀷',
- value varchar(50) not null comment '璇佷欢鍙风爜',
- create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- operate VARCHAR(3) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL'
-);
-
-
--- 鐢ㄦ埛璇佷欢琛�
-create table u_user_credentials(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- credentials_id VARCHAR(30) NOT NULL COMMENT '璇佷欢ID',
- b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
- credentials_cd varchar(12) 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澶辨晥'
-);
-
--- 鏍囩
-create table credentials(
- id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- credentials_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 '鍒涘缓鏃堕棿'
-);
-
-
-
-
-
-
--
Gitblit v1.8.0