From 8f21e9e2fde6f1e5acc5355f3a9a4c8dbfbeba47 Mon Sep 17 00:00:00 2001 From: AprilWind <2100166581@qq.com> Date: 星期三, 15 一月 2025 20:46:11 +0800 Subject: [PATCH] update 优化代码以及注释 --- ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysTenant.java | 2 ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysClient.java | 2 ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysRole.java | 2 script/sql/sqlserver/sqlserver_ry_workflow.sql | 2 script/sql/update/sqlserver/update_5.0-5.1.sql | 4 +- script/sql/postgres/postgres_ry_workflow.sql | 2 script/sql/ry_vue_5.X.sql | 14 +++--- script/sql/ry_workflow.sql | 2 script/sql/update/postgres/update_5.0-5.1.sql | 4 +- ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysUser.java | 2 script/sql/sqlserver/sqlserver_ry_vue_5.X.sql | 14 +++--- ruoyi-common/ruoyi-common-core/src/main/java/org/dromara/common/core/constant/SystemConstants.java | 7 +++ script/sql/update/update_5.0-5.1.sql | 4 +- ruoyi-common/ruoyi-common-core/src/main/java/org/dromara/common/core/constant/Constants.java | 2 ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysTenantPackage.java | 8 +++ script/sql/update/oracle/update_5.0-5.1.sql | 4 +- script/sql/postgres/postgres_ry_vue_5.X.sql | 14 +++--- script/sql/oracle/oracle_ry_workflow.sql | 2 ruoyi-modules/ruoyi-workflow/src/main/java/org/dromara/workflow/domain/FlowCategory.java | 2 script/sql/oracle/oracle_ry_vue_5.X.sql | 14 +++--- ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysDept.java | 2 21 files changed, 60 insertions(+), 49 deletions(-) diff --git a/ruoyi-common/ruoyi-common-core/src/main/java/org/dromara/common/core/constant/Constants.java b/ruoyi-common/ruoyi-common-core/src/main/java/org/dromara/common/core/constant/Constants.java index d031921..273c734 100644 --- a/ruoyi-common/ruoyi-common-core/src/main/java/org/dromara/common/core/constant/Constants.java +++ b/ruoyi-common/ruoyi-common-core/src/main/java/org/dromara/common/core/constant/Constants.java @@ -68,7 +68,7 @@ Integer CAPTCHA_EXPIRATION = 2; /** - * 椤剁骇閮ㄩ棬id + * 椤剁骇鐖剁骇id */ Long TOP_PARENT_ID = 0L; diff --git a/ruoyi-common/ruoyi-common-core/src/main/java/org/dromara/common/core/constant/SystemConstants.java b/ruoyi-common/ruoyi-common-core/src/main/java/org/dromara/common/core/constant/SystemConstants.java index 79afb95..55240bb 100644 --- a/ruoyi-common/ruoyi-common-core/src/main/java/org/dromara/common/core/constant/SystemConstants.java +++ b/ruoyi-common/ruoyi-common-core/src/main/java/org/dromara/common/core/constant/SystemConstants.java @@ -1,7 +1,7 @@ package org.dromara.common.core.constant; /** - * 鐢ㄦ埛甯搁噺淇℃伅 + * 绯荤粺甯搁噺淇℃伅 * * @author Lion Li */ @@ -23,6 +23,11 @@ String YES = "Y"; /** + * 鏄惁涓虹郴缁熼粯璁わ紙鍚︼級 + */ + String NO = "N"; + + /** * 鏄惁鑿滃崟澶栭摼锛堟槸锛� */ String YES_FRAME = "0"; diff --git a/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysClient.java b/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysClient.java index 0f681be..ee2475d 100644 --- a/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysClient.java +++ b/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysClient.java @@ -68,7 +68,7 @@ private String status; /** - * 鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛� + * 鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛� */ @TableLogic private String delFlag; diff --git a/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysDept.java b/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysDept.java index 48ca682..b94fd8a 100644 --- a/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysDept.java +++ b/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysDept.java @@ -70,7 +70,7 @@ private String status; /** - * 鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛� + * 鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛� */ @TableLogic private String delFlag; diff --git a/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysRole.java b/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysRole.java index 2b42464..a7c0ad5 100644 --- a/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysRole.java +++ b/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysRole.java @@ -62,7 +62,7 @@ private String status; /** - * 鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛� + * 鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛� */ @TableLogic private String delFlag; diff --git a/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysTenant.java b/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysTenant.java index a564a40..9800c30 100644 --- a/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysTenant.java +++ b/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysTenant.java @@ -95,7 +95,7 @@ private String status; /** - * 鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛� + * 鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛� */ @TableLogic private String delFlag; diff --git a/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysTenantPackage.java b/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysTenantPackage.java index f7e423f..5f58e3e 100644 --- a/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysTenantPackage.java +++ b/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysTenantPackage.java @@ -25,28 +25,34 @@ */ @TableId(value = "package_id") private Long packageId; + /** * 濂楅鍚嶇О */ private String packageName; + /** * 鍏宠仈鑿滃崟id */ private String menuIds; + /** * 澶囨敞 */ private String remark; + /** * 鑿滃崟鏍戦�夋嫨椤规槸鍚﹀叧鑱旀樉绀猴紙 0锛氱埗瀛愪笉浜掔浉鍏宠仈鏄剧ず 1锛氱埗瀛愪簰鐩稿叧鑱旀樉绀猴級 */ private Boolean menuCheckStrictly; + /** * 鐘舵�侊紙0姝e父 1鍋滅敤锛� */ private String status; + /** - * 鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛� + * 鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛� */ @TableLogic private String delFlag; diff --git a/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysUser.java b/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysUser.java index 4e603e5..3712f80 100644 --- a/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysUser.java +++ b/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/domain/SysUser.java @@ -83,7 +83,7 @@ private String status; /** - * 鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛� + * 鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛� */ @TableLogic private String delFlag; diff --git a/ruoyi-modules/ruoyi-workflow/src/main/java/org/dromara/workflow/domain/FlowCategory.java b/ruoyi-modules/ruoyi-workflow/src/main/java/org/dromara/workflow/domain/FlowCategory.java index 2ec297c..86ac1ac 100644 --- a/ruoyi-modules/ruoyi-workflow/src/main/java/org/dromara/workflow/domain/FlowCategory.java +++ b/ruoyi-modules/ruoyi-workflow/src/main/java/org/dromara/workflow/domain/FlowCategory.java @@ -50,7 +50,7 @@ private Long orderNum; /** - * 鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛� + * 鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛� */ @TableLogic private String delFlag; diff --git a/script/sql/oracle/oracle_ry_vue_5.X.sql b/script/sql/oracle/oracle_ry_vue_5.X.sql index 6171b8d..2dd8198 100644 --- a/script/sql/oracle/oracle_ry_vue_5.X.sql +++ b/script/sql/oracle/oracle_ry_vue_5.X.sql @@ -65,7 +65,7 @@ comment on column sys_social.create_time is '鍒涘缓鏃堕棿'; comment on column sys_social.update_by is '鏇存柊鑰�'; comment on column sys_social.update_time is '鏇存柊鏃堕棿'; -comment on column sys_social.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +comment on column sys_social.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; -- ---------------------------- -- 绉熸埛琛� @@ -108,7 +108,7 @@ comment on column sys_tenant.expire_time is '杩囨湡鏃堕棿'; comment on column sys_tenant.account_count is '鐢ㄦ埛鏁伴噺锛�-1涓嶉檺鍒讹級'; comment on column sys_tenant.status is '绉熸埛鐘舵�侊紙0姝e父 1鍋滅敤锛�'; -comment on column sys_tenant.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +comment on column sys_tenant.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; comment on column sys_tenant.create_dept is '鍒涘缓閮ㄩ棬'; comment on column sys_tenant.create_by is '鍒涘缓鑰�'; comment on column sys_tenant.create_time is '鍒涘缓鏃堕棿'; @@ -148,7 +148,7 @@ comment on column sys_tenant_package.menu_ids is '鍏宠仈鑿滃崟id'; comment on column sys_tenant_package.remark is '澶囨敞'; comment on column sys_tenant_package.status is '鐘舵�侊紙0姝e父 1鍋滅敤锛�'; -comment on column sys_tenant_package.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +comment on column sys_tenant_package.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; comment on column sys_tenant_package.create_dept is '鍒涘缓閮ㄩ棬'; comment on column sys_tenant_package.create_by is '鍒涘缓鑰�'; comment on column sys_tenant_package.create_time is '鍒涘缓鏃堕棿'; @@ -193,7 +193,7 @@ comment on column sys_dept.phone is '鑱旂郴鐢佃瘽'; comment on column sys_dept.email is '閭'; comment on column sys_dept.status is '閮ㄩ棬鐘舵�侊紙0姝e父 1鍋滅敤锛�'; -comment on column sys_dept.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +comment on column sys_dept.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; comment on column sys_dept.create_dept is '鍒涘缓閮ㄩ棬'; comment on column sys_dept.create_by is '鍒涘缓鑰�'; comment on column sys_dept.create_time is '鍒涘缓鏃堕棿'; @@ -258,7 +258,7 @@ comment on column sys_user.avatar is '澶村儚璺緞'; comment on column sys_user.password is '瀵嗙爜'; comment on column sys_user.status is '甯愬彿鐘舵�侊紙0姝e父 1鍋滅敤锛�'; -comment on column sys_user.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +comment on column sys_user.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; comment on column sys_user.login_ip is '鏈�鍚庣櫥褰旾P'; comment on column sys_user.login_date is '鏈�鍚庣櫥褰曟椂闂�'; comment on column sys_user.create_dept is '鍒涘缓閮ㄩ棬'; @@ -356,7 +356,7 @@ comment on column sys_role.menu_check_strictly is '鑿滃崟鏍戦�夋嫨椤规槸鍚﹀叧鑱旀樉绀�'; comment on column sys_role.dept_check_strictly is '閮ㄩ棬鏍戦�夋嫨椤规槸鍚﹀叧鑱旀樉绀�'; comment on column sys_role.status is '瑙掕壊鐘舵�侊紙0姝e父 1鍋滅敤锛�'; -comment on column sys_role.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +comment on column sys_role.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; comment on column sys_role.create_dept is '鍒涘缓閮ㄩ棬'; comment on column sys_role.create_by is '鍒涘缓鑰�'; comment on column sys_role.create_time is '鍒涘缓鏃堕棿'; @@ -1245,7 +1245,7 @@ comment on column sys_client.active_timeout is 'token娲昏穬瓒呮椂鏃堕棿'; comment on column sys_client.timeout is 'token鍥哄畾瓒呮椂'; comment on column sys_client.status is '鐘舵�侊紙0姝e父 1鍋滅敤锛�'; -comment on column sys_client.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +comment on column sys_client.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; comment on column sys_client.create_dept is '鍒涘缓閮ㄩ棬'; comment on column sys_client.create_by is '鍒涘缓鑰�'; comment on column sys_client.create_time is '鍒涘缓鏃堕棿'; diff --git a/script/sql/oracle/oracle_ry_workflow.sql b/script/sql/oracle/oracle_ry_workflow.sql index a0f71d0..b515b78 100644 --- a/script/sql/oracle/oracle_ry_workflow.sql +++ b/script/sql/oracle/oracle_ry_workflow.sql @@ -307,7 +307,7 @@ COMMENT ON COLUMN flow_category.ancestors IS '绁栫骇鍒楄〃'; COMMENT ON COLUMN flow_category.category_name IS '娴佺▼鍒嗙被鍚嶇О'; COMMENT ON COLUMN flow_category.order_num IS '鏄剧ず椤哄簭'; -COMMENT ON COLUMN flow_category.del_flag IS '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +COMMENT ON COLUMN flow_category.del_flag IS '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; COMMENT ON COLUMN flow_category.create_dept IS '鍒涘缓閮ㄩ棬'; COMMENT ON COLUMN flow_category.create_by IS '鍒涘缓鑰�'; COMMENT ON COLUMN flow_category.create_time IS '鍒涘缓鏃堕棿'; diff --git a/script/sql/postgres/postgres_ry_vue_5.X.sql b/script/sql/postgres/postgres_ry_vue_5.X.sql index af97ac7..b3499e8 100644 --- a/script/sql/postgres/postgres_ry_vue_5.X.sql +++ b/script/sql/postgres/postgres_ry_vue_5.X.sql @@ -64,7 +64,7 @@ comment on column sys_social.create_time is '鍒涘缓鏃堕棿'; comment on column sys_social.update_by is '鏇存柊鑰�'; comment on column sys_social.update_time is '鏇存柊鏃堕棿'; -comment on column sys_social.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +comment on column sys_social.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; -- ---------------------------- -- 绉熸埛琛� @@ -109,7 +109,7 @@ comment on column sys_tenant.expire_time is '杩囨湡鏃堕棿'; comment on column sys_tenant.account_count is '鐢ㄦ埛鏁伴噺锛�-1涓嶉檺鍒讹級'; comment on column sys_tenant.status is '绉熸埛鐘舵�侊紙0姝e父 1鍋滅敤锛�'; -comment on column sys_tenant.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +comment on column sys_tenant.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; comment on column sys_tenant.create_dept is '鍒涘缓閮ㄩ棬'; comment on column sys_tenant.create_by is '鍒涘缓鑰�'; comment on column sys_tenant.create_time is '鍒涘缓鏃堕棿'; @@ -151,7 +151,7 @@ comment on column sys_tenant_package.menu_ids is '鍏宠仈鑿滃崟id'; comment on column sys_tenant_package.remark is '澶囨敞'; comment on column sys_tenant_package.status is '鐘舵�侊紙0姝e父 1鍋滅敤锛�'; -comment on column sys_tenant_package.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +comment on column sys_tenant_package.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; comment on column sys_tenant_package.create_dept is '鍒涘缓閮ㄩ棬'; comment on column sys_tenant_package.create_by is '鍒涘缓鑰�'; comment on column sys_tenant_package.create_time is '鍒涘缓鏃堕棿'; @@ -196,7 +196,7 @@ comment on column sys_dept.phone is '鑱旂郴鐢佃瘽'; comment on column sys_dept.email is '閭'; comment on column sys_dept.status is '閮ㄩ棬鐘舵�侊紙0姝e父 1鍋滅敤锛�'; -comment on column sys_dept.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +comment on column sys_dept.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; comment on column sys_dept.create_dept is '鍒涘缓閮ㄩ棬'; comment on column sys_dept.create_by is '鍒涘缓鑰�'; comment on column sys_dept.create_time is '鍒涘缓鏃堕棿'; @@ -259,7 +259,7 @@ comment on column sys_user.avatar is '澶村儚鍦板潃'; comment on column sys_user.password is '瀵嗙爜'; comment on column sys_user.status is '甯愬彿鐘舵�侊紙0姝e父 1鍋滅敤锛�'; -comment on column sys_user.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +comment on column sys_user.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; comment on column sys_user.login_ip is '鏈�鍚庣櫥闄咺P'; comment on column sys_user.login_date is '鏈�鍚庣櫥闄嗘椂闂�'; comment on column sys_user.create_dept is '鍒涘缓閮ㄩ棬'; @@ -357,7 +357,7 @@ comment on column sys_role.menu_check_strictly is '鑿滃崟鏍戦�夋嫨椤规槸鍚﹀叧鑱旀樉绀�'; comment on column sys_role.dept_check_strictly is '閮ㄩ棬鏍戦�夋嫨椤规槸鍚﹀叧鑱旀樉绀�'; comment on column sys_role.status is '瑙掕壊鐘舵�侊紙0姝e父 1鍋滅敤锛�'; -comment on column sys_role.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +comment on column sys_role.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; comment on column sys_role.create_dept is '鍒涘缓閮ㄩ棬'; comment on column sys_role.create_by is '鍒涘缓鑰�'; comment on column sys_role.create_time is '鍒涘缓鏃堕棿'; @@ -1244,7 +1244,7 @@ comment on column sys_client.active_timeout is 'token娲昏穬瓒呮椂鏃堕棿'; comment on column sys_client.timeout is 'token鍥哄畾瓒呮椂'; comment on column sys_client.status is '鐘舵�侊紙0姝e父 1鍋滅敤锛�'; -comment on column sys_client.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +comment on column sys_client.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; comment on column sys_client.create_dept is '鍒涘缓閮ㄩ棬'; comment on column sys_client.create_by is '鍒涘缓鑰�'; comment on column sys_client.create_time is '鍒涘缓鏃堕棿'; diff --git a/script/sql/postgres/postgres_ry_workflow.sql b/script/sql/postgres/postgres_ry_workflow.sql index 337b066..9bcf2cf 100644 --- a/script/sql/postgres/postgres_ry_workflow.sql +++ b/script/sql/postgres/postgres_ry_workflow.sql @@ -299,7 +299,7 @@ COMMENT ON COLUMN flow_category.ancestors IS '绁栫骇鍒楄〃'; COMMENT ON COLUMN flow_category.category_name IS '娴佺▼鍒嗙被鍚嶇О'; COMMENT ON COLUMN flow_category.order_num IS '鏄剧ず椤哄簭'; -COMMENT ON COLUMN flow_category.del_flag IS '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +COMMENT ON COLUMN flow_category.del_flag IS '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; COMMENT ON COLUMN flow_category.create_dept IS '鍒涘缓閮ㄩ棬'; COMMENT ON COLUMN flow_category.create_by IS '鍒涘缓鑰�'; COMMENT ON COLUMN flow_category.create_time IS '鍒涘缓鏃堕棿'; diff --git a/script/sql/ry_vue_5.X.sql b/script/sql/ry_vue_5.X.sql index d733696..9e6244d 100644 --- a/script/sql/ry_vue_5.X.sql +++ b/script/sql/ry_vue_5.X.sql @@ -31,7 +31,7 @@ create_time datetime comment '鍒涘缓鏃堕棿', update_by bigint(20) comment '鏇存柊鑰�', update_time datetime comment '鏇存柊鏃堕棿', - del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�', + del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�', PRIMARY KEY (id) ) engine=innodb comment = '绀句細鍖栧叧绯昏〃'; @@ -55,7 +55,7 @@ expire_time datetime comment '杩囨湡鏃堕棿', account_count int default -1 comment '鐢ㄦ埛鏁伴噺锛�-1涓嶉檺鍒讹級', status char(1) default '0' comment '绉熸埛鐘舵�侊紙0姝e父 1鍋滅敤锛�', - del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�', + del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�', create_dept bigint(20) comment '鍒涘缓閮ㄩ棬', create_by bigint(20) comment '鍒涘缓鑰�', create_time datetime comment '鍒涘缓鏃堕棿', @@ -82,7 +82,7 @@ remark varchar(200) comment '澶囨敞', menu_check_strictly tinyint(1) default 1 comment '鑿滃崟鏍戦�夋嫨椤规槸鍚﹀叧鑱旀樉绀�', status char(1) default '0' comment '鐘舵�侊紙0姝e父 1鍋滅敤锛�', - del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�', + del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�', create_dept bigint(20) comment '鍒涘缓閮ㄩ棬', create_by bigint(20) comment '鍒涘缓鑰�', create_time datetime comment '鍒涘缓鏃堕棿', @@ -107,7 +107,7 @@ phone varchar(11) default null comment '鑱旂郴鐢佃瘽', email varchar(50) default null comment '閭', status char(1) default '0' comment '閮ㄩ棬鐘舵�侊紙0姝e父 1鍋滅敤锛�', - del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�', + del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�', create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬', create_by bigint(20) default null comment '鍒涘缓鑰�', create_time datetime comment '鍒涘缓鏃堕棿', @@ -149,7 +149,7 @@ avatar bigint(20) comment '澶村儚鍦板潃', password varchar(100) default '' comment '瀵嗙爜', status char(1) default '0' comment '甯愬彿鐘舵�侊紙0姝e父 1鍋滅敤锛�', - del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�', + del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�', login_ip varchar(128) default '' comment '鏈�鍚庣櫥褰旾P', login_date datetime comment '鏈�鍚庣櫥褰曟椂闂�', create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬', @@ -212,7 +212,7 @@ menu_check_strictly tinyint(1) default 1 comment '鑿滃崟鏍戦�夋嫨椤规槸鍚﹀叧鑱旀樉绀�', dept_check_strictly tinyint(1) default 1 comment '閮ㄩ棬鏍戦�夋嫨椤规槸鍚﹀叧鑱旀樉绀�', status char(1) not null comment '瑙掕壊鐘舵�侊紙0姝e父 1鍋滅敤锛�', - del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�', + del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�', create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬', create_by bigint(20) default null comment '鍒涘缓鑰�', create_time datetime comment '鍒涘缓鏃堕棿', @@ -856,7 +856,7 @@ active_timeout int(11) default 1800 comment 'token娲昏穬瓒呮椂鏃堕棿', timeout int(11) default 604800 comment 'token鍥哄畾瓒呮椂', status char(1) default '0' comment '鐘舵�侊紙0姝e父 1鍋滅敤锛�', - del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�', + del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�', create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬', create_by bigint(20) default null comment '鍒涘缓鑰�', create_time datetime default null comment '鍒涘缓鏃堕棿', diff --git a/script/sql/ry_workflow.sql b/script/sql/ry_workflow.sql index c5adb64..9455636 100644 --- a/script/sql/ry_workflow.sql +++ b/script/sql/ry_workflow.sql @@ -160,7 +160,7 @@ ancestors varchar(500) default '' comment '绁栫骇鍒楄〃', category_name varchar(30) not null comment '娴佺▼鍒嗙被鍚嶇О', order_num int(4) default 0 comment '鏄剧ず椤哄簭', - del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�', + del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�', create_dept bigint(20) null comment '鍒涘缓閮ㄩ棬', create_by bigint(20) null comment '鍒涘缓鑰�', create_time datetime null comment '鍒涘缓鏃堕棿', diff --git a/script/sql/sqlserver/sqlserver_ry_vue_5.X.sql b/script/sql/sqlserver/sqlserver_ry_vue_5.X.sql index bc0da26..4607fb2 100644 --- a/script/sql/sqlserver/sqlserver_ry_vue_5.X.sql +++ b/script/sql/sqlserver/sqlserver_ry_vue_5.X.sql @@ -175,7 +175,7 @@ 'COLUMN', N'oauth_token_secret' GO EXEC sys.sp_addextendedproperty - 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�' , + 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�' , 'SCHEMA', N'dbo', 'TABLE', N'sys_social', 'COLUMN', N'del_flag' @@ -330,7 +330,7 @@ 'COLUMN', N'status' GO EXEC sys.sp_addextendedproperty - 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�' , + 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�' , 'SCHEMA', N'dbo', 'TABLE', N'sys_tenant', 'COLUMN', N'del_flag' @@ -427,7 +427,7 @@ 'COLUMN', N'status' GO EXEC sys.sp_addextendedproperty - 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�' , + 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�' , 'SCHEMA', N'dbo', 'TABLE', N'sys_tenant_package', 'COLUMN', N'del_flag' @@ -1017,7 +1017,7 @@ 'COLUMN', N'status' GO EXEC sys.sp_addextendedproperty - 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�' , + 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�' , 'SCHEMA', N'dbo', 'TABLE', N'sys_dept', 'COLUMN', N'del_flag' @@ -2342,7 +2342,7 @@ 'COLUMN', N'status' GO EXEC sys.sp_addextendedproperty - 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�' , + 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�' , 'SCHEMA', N'dbo', 'TABLE', N'sys_role', 'COLUMN', N'del_flag' @@ -2727,7 +2727,7 @@ 'COLUMN', N'status' GO EXEC sys.sp_addextendedproperty - 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�' , + 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�' , 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'del_flag' @@ -3206,7 +3206,7 @@ 'COLUMN', N'status' GO EXEC sp_addextendedproperty - 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�', + 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�', 'SCHEMA', N'dbo', 'TABLE', N'sys_client', 'COLUMN', N'del_flag' diff --git a/script/sql/sqlserver/sqlserver_ry_workflow.sql b/script/sql/sqlserver/sqlserver_ry_workflow.sql index 2ccb6fa..478dc86 100644 --- a/script/sql/sqlserver/sqlserver_ry_workflow.sql +++ b/script/sql/sqlserver/sqlserver_ry_workflow.sql @@ -1035,7 +1035,7 @@ GO EXEC sp_addextendedproperty -'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�', +'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�', 'SCHEMA', N'dbo', 'TABLE', N'flow_category', 'COLUMN', N'del_flag' diff --git a/script/sql/update/oracle/update_5.0-5.1.sql b/script/sql/update/oracle/update_5.0-5.1.sql index 09cfae8..5341fec 100644 --- a/script/sql/update/oracle/update_5.0-5.1.sql +++ b/script/sql/update/oracle/update_5.0-5.1.sql @@ -71,7 +71,7 @@ comment on column sys_social.create_time is '鍒涘缓鏃堕棿'; comment on column sys_social.update_by is '鏇存柊鑰�'; comment on column sys_social.update_time is '鏇存柊鏃堕棿'; -comment on column sys_social.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +comment on column sys_social.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; -- ---------------------------- @@ -107,7 +107,7 @@ comment on column sys_client.active_timeout is 'token娲昏穬瓒呮椂鏃堕棿'; comment on column sys_client.timeout is 'token鍥哄畾瓒呮椂'; comment on column sys_client.status is '鐘舵�侊紙0姝e父 1鍋滅敤锛�'; -comment on column sys_client.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +comment on column sys_client.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; comment on column sys_client.create_dept is '鍒涘缓閮ㄩ棬'; comment on column sys_client.create_by is '鍒涘缓鑰�'; comment on column sys_client.create_time is '鍒涘缓鏃堕棿'; diff --git a/script/sql/update/postgres/update_5.0-5.1.sql b/script/sql/update/postgres/update_5.0-5.1.sql index f5f0a5c..14d7eb6 100644 --- a/script/sql/update/postgres/update_5.0-5.1.sql +++ b/script/sql/update/postgres/update_5.0-5.1.sql @@ -70,7 +70,7 @@ comment on column sys_social.create_time is '鍒涘缓鏃堕棿'; comment on column sys_social.update_by is '鏇存柊鑰�'; comment on column sys_social.update_time is '鏇存柊鏃堕棿'; -comment on column sys_social.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +comment on column sys_social.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; -- ---------------------------- @@ -106,7 +106,7 @@ comment on column sys_client.active_timeout is 'token娲昏穬瓒呮椂鏃堕棿'; comment on column sys_client.timeout is 'token鍥哄畾瓒呮椂'; comment on column sys_client.status is '鐘舵�侊紙0姝e父 1鍋滅敤锛�'; -comment on column sys_client.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; +comment on column sys_client.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; comment on column sys_client.create_dept is '鍒涘缓閮ㄩ棬'; comment on column sys_client.create_by is '鍒涘缓鑰�'; comment on column sys_client.create_time is '鍒涘缓鏃堕棿'; diff --git a/script/sql/update/sqlserver/update_5.0-5.1.sql b/script/sql/update/sqlserver/update_5.0-5.1.sql index bde3813..81434a3 100644 --- a/script/sql/update/sqlserver/update_5.0-5.1.sql +++ b/script/sql/update/sqlserver/update_5.0-5.1.sql @@ -188,7 +188,7 @@ 'COLUMN', N'oauth_token_secret' GO EXEC sys.sp_addextendedproperty - 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�' , + 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�' , 'SCHEMA', N'dbo', 'TABLE', N'sys_social', 'COLUMN', N'del_flag' @@ -304,7 +304,7 @@ 'COLUMN', N'status' GO EXEC sp_addextendedproperty -'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�', +'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�', 'SCHEMA', N'dbo', 'TABLE', N'sys_client', 'COLUMN', N'del_flag' diff --git a/script/sql/update/update_5.0-5.1.sql b/script/sql/update/update_5.0-5.1.sql index 871bda3..4ebd71c 100644 --- a/script/sql/update/update_5.0-5.1.sql +++ b/script/sql/update/update_5.0-5.1.sql @@ -36,7 +36,7 @@ create_time datetime comment '鍒涘缓鏃堕棿', update_by bigint(20) comment '鏇存柊鑰�', update_time datetime comment '鏇存柊鏃堕棿', - del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�', + del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�', PRIMARY KEY (id) ) engine=innodb comment = '绀句細鍖栧叧绯昏〃'; @@ -55,7 +55,7 @@ active_timeout int(11) default 1800 comment 'token娲昏穬瓒呮椂鏃堕棿', timeout int(11) default 604800 comment 'token鍥哄畾瓒呮椂', status char(1) default '0' comment '鐘舵�侊紙0姝e父 1鍋滅敤锛�', - del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�', + del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�', create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬', create_by bigint(20) default null comment '鍒涘缓鑰�', create_time datetime default null comment '鍒涘缓鏃堕棿', -- Gitblit v1.9.3