This is an automated email from the ASF dual-hosted git repository.
xiaoyu pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shenyu.git
The following commit(s) were added to refs/heads/master by this push:
new acfe8be35 style:sql notes description (#3899)
acfe8be35 is described below
commit acfe8be357df88dba4d37c8670d1a8a27b1fc259
Author: 奕仁 <[email protected]>
AuthorDate: Wed Aug 31 11:17:49 2022 +0800
style:sql notes description (#3899)
Co-authored-by: 奕仁 <choviwu>
---
db/init/mysql/schema.sql | 20 ++++++++++----------
db/init/oracle/schema.sql | 26 +++++++++++++-------------
db/init/pg/create-table.sql | 20 ++++++++++----------
3 files changed, 33 insertions(+), 33 deletions(-)
diff --git a/db/init/mysql/schema.sql b/db/init/mysql/schema.sql
index e7d78d992..9033b7727 100644
--- a/db/init/mysql/schema.sql
+++ b/db/init/mysql/schema.sql
@@ -50,8 +50,8 @@ CREATE TABLE `app_auth` (
`user_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL
DEFAULT NULL COMMENT 'user id',
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL
DEFAULT NULL COMMENT 'phone number when the user applies',
`ext_info` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
NULL DEFAULT NULL COMMENT 'extended parameter json',
- `open` tinyint(0) NOT NULL COMMENT 'open auth path or not',
- `enabled` tinyint(0) NOT NULL COMMENT 'delete or not',
+ `open` tinyint(0) NOT NULL COMMENT 'open auth path or not (0 close, 1 open)
',
+ `enabled` tinyint(0) NOT NULL COMMENT 'delete or not (0 close, 1 open) ',
`date_created` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT
'create time',
`date_updated` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE
CURRENT_TIMESTAMP(3) COMMENT 'update time',
PRIMARY KEY (`id`) USING BTREE
@@ -88,7 +88,7 @@ CREATE TABLE `auth_path` (
`auth_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT
NULL COMMENT 'auth table id',
`app_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT
NULL COMMENT 'module',
`path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT
NULL COMMENT 'path',
- `enabled` tinyint(0) NOT NULL COMMENT 'whether pass 1 is',
+ `enabled` tinyint(0) NOT NULL COMMENT 'whether pass 1 is (0 close, 1 open)
',
`date_created` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT
'create time',
`date_updated` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE
CURRENT_TIMESTAMP(3) COMMENT 'update time',
PRIMARY KEY (`id`) USING BTREE
@@ -107,7 +107,7 @@ CREATE TABLE `dashboard_user` (
`user_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT
NULL COMMENT 'user name',
`password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
NULL DEFAULT NULL COMMENT 'user password',
`role` int(0) NOT NULL COMMENT 'role',
- `enabled` tinyint(0) NOT NULL COMMENT 'delete or not',
+ `enabled` tinyint(0) NOT NULL COMMENT 'delete or not (0 close, 1 open) ',
`date_created` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT
'create time',
`date_updated` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE
CURRENT_TIMESTAMP(3) COMMENT 'update time',
PRIMARY KEY (`id`) USING BTREE,
@@ -153,7 +153,7 @@ CREATE TABLE `meta_data` (
`rpc_ext` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL
DEFAULT NULL COMMENT 'rpc extended information, json format',
`date_created` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT
'create time',
`date_updated` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE
CURRENT_TIMESTAMP(3) COMMENT 'update time',
- `enabled` tinyint(0) NOT NULL DEFAULT 0 COMMENT 'enabled state',
+ `enabled` tinyint(0) NOT NULL DEFAULT 0 COMMENT 'enabled state (0 close, 1
open) ',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci
ROW_FORMAT = Dynamic;
@@ -1214,8 +1214,8 @@ CREATE TABLE `rule` (
`selector_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
NOT NULL COMMENT 'selector id',
`match_mode` int(0) NOT NULL COMMENT 'matching mode (0 and 1 or)',
`name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT
NULL COMMENT 'rule name',
- `enabled` tinyint(0) NOT NULL COMMENT 'whether to open',
- `loged` tinyint(0) NOT NULL COMMENT 'whether to log or not',
+ `enabled` tinyint(0) NOT NULL COMMENT 'whether to open (0 close, 1 open) ',
+ `loged` tinyint(0) NOT NULL COMMENT 'whether to log or not (0 no print, 1
print) ',
`sort` int(0) NOT NULL COMMENT 'sort',
`handle` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL
DEFAULT NULL COMMENT 'processing logic (here for different plug-ins, there will
be different fields to identify different processes, all data in JSON format is
stored)',
`date_created` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT
'create time',
@@ -1259,8 +1259,8 @@ CREATE TABLE `selector` (
`type` int(0) NOT NULL COMMENT 'type (0, full flow, 1 custom flow)',
`sort` int(0) NOT NULL COMMENT 'sort',
`handle` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL
DEFAULT NULL COMMENT 'processing logic (here for different plug-ins, there will
be different fields to identify different processes, all data in JSON format is
stored)',
- `enabled` tinyint(0) NOT NULL COMMENT 'whether to open',
- `loged` tinyint(0) NOT NULL COMMENT 'whether to print the log',
+ `enabled` tinyint(0) NOT NULL COMMENT 'whether to open (0 close, 1 open) ',
+ `loged` tinyint(0) NOT NULL COMMENT 'whether to print the log (0 no print, 1
print) ',
`continued` tinyint(0) NOT NULL COMMENT 'whether to continue execution',
`date_created` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT
'create time',
`date_updated` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE
CURRENT_TIMESTAMP(3) COMMENT 'update time',
@@ -1303,7 +1303,7 @@ CREATE TABLE `shenyu_dict` (
`dict_value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
NULL DEFAULT NULL COMMENT 'dictionary value',
`desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL
DEFAULT NULL COMMENT 'dictionary description or remarks',
`sort` int(0) NOT NULL COMMENT 'sort',
- `enabled` tinyint(0) NULL DEFAULT NULL COMMENT 'whether it is enabled',
+ `enabled` tinyint(0) NULL DEFAULT NULL COMMENT 'whether it is enabled (0
close, 1 open) ',
`date_created` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT
'create time',
`date_updated` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE
CURRENT_TIMESTAMP(3) COMMENT 'update time',
PRIMARY KEY (`id`) USING BTREE,
diff --git a/db/init/oracle/schema.sql b/db/init/oracle/schema.sql
index 09bd92c2c..e04e08369 100644
--- a/db/init/oracle/schema.sql
+++ b/db/init/oracle/schema.sql
@@ -62,11 +62,11 @@ comment on column PLUGIN.name
comment on column PLUGIN.config
is 'plugin configuration';
comment on column PLUGIN.role
- is 'plug-in role';
+ is 'plugin role';
comment on column PLUGIN.sort
is 'sort';
comment on column PLUGIN.enabled
- is 'whether to open (0, not open, 1 open)';
+ is 'plugin whether to open (0 not open, 1 open)';
comment on column PLUGIN.date_created
is 'create time';
comment on column PLUGIN.date_updated
@@ -132,15 +132,15 @@ comment on column SELECTOR.name
comment on column SELECTOR.match_mode
is 'matching mode (0 and 1 or)';
comment on column SELECTOR.type
- is 'type (0, full flow, 1 custom flow)';
+ is 'type (0 full flow, 1 custom flow)';
comment on column SELECTOR.sort
is 'sort';
comment on column SELECTOR.handle
- is 'processing logic (here for different plug-ins, there will be different
fields to identify different processes, all data in JSON format is stored)';
+ is 'processing logic (here for different plugins, there will be different
fields to identify different processes, all data in JSON format is stored)';
comment on column SELECTOR.enabled
- is 'whether to open';
+ is 'whether to open (0 not open, 1 open)';
comment on column SELECTOR.loged
- is 'whether to print the log';
+ is 'whether to print the log (0 not print, 1 print)';
comment on column SELECTOR.continued
is 'whether to continue execution';
comment on column SELECTOR.date_created
@@ -201,9 +201,9 @@ comment on column RULE.match_mode
comment on column RULE.name
is 'rule name';
comment on column RULE.enabled
- is 'whether to open';
+ is 'whether to open (0 not open, 1 open)';
comment on column RULE.loged
- is 'whether to log or not';
+ is 'whether to log or not (0 not print, 1 print)';
comment on column RULE.sort
is 'sort';
comment on column RULE.handle
@@ -282,7 +282,7 @@ comment on column META_DATA.date_created
comment on column META_DATA.date_updated
is 'update time';
comment on column META_DATA.enabled
- is 'enabled state';
+ is 'enabled state (0 close, 1 enabled) ';
create table operation_record_log
(
@@ -342,9 +342,9 @@ comment on column APP_AUTH.phone
comment on column APP_AUTH.ext_info
is 'extended parameter json';
comment on column APP_AUTH.open
- is 'open auth path or not';
+ is 'open auth path or not (0 not open, 1 open) ';
comment on column APP_AUTH.enabled
- is 'delete or not';
+ is 'delete or not (0 close, 1 open) ';
comment on column APP_AUTH.date_created
is 'create time';
comment on column APP_AUTH.date_updated
@@ -395,7 +395,7 @@ comment on column AUTH_PATH.app_name
comment on column AUTH_PATH.path
is 'path';
comment on column AUTH_PATH.enabled
- is 'whether pass 1 is';
+ is 'whether pass 1 is (0 close, 1 open) ';
comment on column AUTH_PATH.date_created
is 'create time';
comment on column AUTH_PATH.date_updated
@@ -432,7 +432,7 @@ comment on column SHENYU_DICT."desc"
comment on column SHENYU_DICT.sort
is 'sort';
comment on column SHENYU_DICT.enabled
- is 'whether it is enabled';
+ is 'whether it is enabled (0 close, 1 open) ';
comment on column SHENYU_DICT.date_created
is 'create time';
comment on column SHENYU_DICT.date_updated
diff --git a/db/init/pg/create-table.sql b/db/init/pg/create-table.sql
index 4d45fe31a..bfe3004c1 100644
--- a/db/init/pg/create-table.sql
+++ b/db/init/pg/create-table.sql
@@ -70,8 +70,8 @@ COMMENT ON COLUMN "public"."app_auth"."app_secret" IS
'encryption algorithm secr
COMMENT ON COLUMN "public"."app_auth"."user_id" IS 'user id';
COMMENT ON COLUMN "public"."app_auth"."phone" IS 'phone number when the user
applies';
COMMENT ON COLUMN "public"."app_auth"."ext_info" IS 'extended parameter json';
-COMMENT ON COLUMN "public"."app_auth"."open" IS 'open auth path or not';
-COMMENT ON COLUMN "public"."app_auth"."enabled" IS 'delete or not';
+COMMENT ON COLUMN "public"."app_auth"."open" IS 'open auth path or not (0
close, 1 open) ';
+COMMENT ON COLUMN "public"."app_auth"."enabled" IS 'delete or not (0 close, 1
open) ';
COMMENT ON COLUMN "public"."app_auth"."date_created" IS 'create time';
COMMENT ON COLUMN "public"."app_auth"."date_updated" IS 'update time';
@@ -121,7 +121,7 @@ COMMENT ON COLUMN "public"."auth_path"."id" IS 'primary key
id';
COMMENT ON COLUMN "public"."auth_path"."auth_id" IS 'auth table id';
COMMENT ON COLUMN "public"."auth_path"."app_name" IS 'module';
COMMENT ON COLUMN "public"."auth_path"."path" IS 'path';
-COMMENT ON COLUMN "public"."auth_path"."enabled" IS 'whether pass 1 is';
+COMMENT ON COLUMN "public"."auth_path"."enabled" IS 'whether pass 1 is (0
close, 1 open) ';
COMMENT ON COLUMN "public"."auth_path"."date_created" IS 'create time';
COMMENT ON COLUMN "public"."auth_path"."date_updated" IS 'update time';
@@ -147,7 +147,7 @@ COMMENT ON COLUMN "public"."dashboard_user"."id" IS
'primary key id';
COMMENT ON COLUMN "public"."dashboard_user"."user_name" IS 'user name';
COMMENT ON COLUMN "public"."dashboard_user"."password" IS 'user password';
COMMENT ON COLUMN "public"."dashboard_user"."role" IS 'role';
-COMMENT ON COLUMN "public"."dashboard_user"."enabled" IS 'delete or not';
+COMMENT ON COLUMN "public"."dashboard_user"."enabled" IS 'delete or not (0
close, 1 open) ';
COMMENT ON COLUMN "public"."dashboard_user"."date_created" IS 'create time';
COMMENT ON COLUMN "public"."dashboard_user"."date_updated" IS 'update time';
@@ -211,7 +211,7 @@ COMMENT ON COLUMN "public"."meta_data"."parameter_types" IS
'parameter types are
COMMENT ON COLUMN "public"."meta_data"."rpc_ext" IS 'rpc extended information,
json format';
COMMENT ON COLUMN "public"."meta_data"."date_created" IS 'create time';
COMMENT ON COLUMN "public"."meta_data"."date_updated" IS 'update time';
-COMMENT ON COLUMN "public"."meta_data"."enabled" IS 'enabled state';
+COMMENT ON COLUMN "public"."meta_data"."enabled" IS 'enabled state (0 close, 1
open) ';
-- ----------------------------
-- Records of meta_data
@@ -1337,8 +1337,8 @@ COMMENT ON COLUMN "public"."rule"."id" IS 'primary key
id';
COMMENT ON COLUMN "public"."rule"."selector_id" IS 'selector id';
COMMENT ON COLUMN "public"."rule"."match_mode" IS 'matching mode (0 and 1 or)';
COMMENT ON COLUMN "public"."rule"."name" IS 'rule name';
-COMMENT ON COLUMN "public"."rule"."enabled" IS 'whether to open';
-COMMENT ON COLUMN "public"."rule"."loged" IS 'whether to log or not';
+COMMENT ON COLUMN "public"."rule"."enabled" IS 'whether to open (0 close, 1
open) ';
+COMMENT ON COLUMN "public"."rule"."loged" IS 'whether to log or not (0 no
print, 1 print) ';
COMMENT ON COLUMN "public"."rule"."sort" IS 'sort';
COMMENT ON COLUMN "public"."rule"."handle" IS 'processing logic (here for
different plug-ins, there will be different fields to identify different
processes, all data in JSON format is stored)';
COMMENT ON COLUMN "public"."rule"."date_created" IS 'create time';
@@ -1402,8 +1402,8 @@ COMMENT ON COLUMN "public"."selector"."match_mode" IS
'matching mode (0 and 1 or
COMMENT ON COLUMN "public"."selector"."type" IS 'type (0, full flow, 1 custom
flow)';
COMMENT ON COLUMN "public"."selector"."sort" IS 'sort';
COMMENT ON COLUMN "public"."selector"."handle" IS 'processing logic (here for
different plug-ins, there will be different fields to identify different
processes, all data in JSON format is stored)';
-COMMENT ON COLUMN "public"."selector"."enabled" IS 'whether to open';
-COMMENT ON COLUMN "public"."selector"."loged" IS 'whether to print the log';
+COMMENT ON COLUMN "public"."selector"."enabled" IS 'whether to open (0 close,
1 open) ';
+COMMENT ON COLUMN "public"."selector"."loged" IS 'whether to print the log (0
no print, 1 print) ';
COMMENT ON COLUMN "public"."selector"."continued" IS 'whether to continue
execution';
COMMENT ON COLUMN "public"."selector"."date_created" IS 'create time';
COMMENT ON COLUMN "public"."selector"."date_updated" IS 'update time';
@@ -1464,7 +1464,7 @@ COMMENT ON COLUMN "public"."shenyu_dict"."dict_name" IS
'dictionary name';
COMMENT ON COLUMN "public"."shenyu_dict"."dict_value" IS 'dictionary value';
COMMENT ON COLUMN "public"."shenyu_dict"."desc" IS 'dictionary description or
remarks';
COMMENT ON COLUMN "public"."shenyu_dict"."sort" IS 'sort';
-COMMENT ON COLUMN "public"."shenyu_dict"."enabled" IS 'whether it is enabled';
+COMMENT ON COLUMN "public"."shenyu_dict"."enabled" IS 'whether it is enabled
(0 close, 1 open) ';
COMMENT ON COLUMN "public"."shenyu_dict"."date_created" IS 'create time';
COMMENT ON COLUMN "public"."shenyu_dict"."date_updated" IS 'update time';
