From 5d75fcaea0a3774052b7484a4ffe755258502363 Mon Sep 17 00:00:00 2001 From: wlzboy <66905212@qq.com> Date: 星期六, 06 十二月 2025 20:49:11 +0800 Subject: [PATCH] fix:开始执行人员就绪按钮 --- sql/add_can_view_all_consult_to_sys_user.sql | 12 ++++++++++++ 1 files changed, 12 insertions(+), 0 deletions(-) diff --git a/sql/add_can_view_all_consult_to_sys_user.sql b/sql/add_can_view_all_consult_to_sys_user.sql new file mode 100644 index 0000000..6ce673b --- /dev/null +++ b/sql/add_can_view_all_consult_to_sys_user.sql @@ -0,0 +1,12 @@ +-- 娣诲姞sys_user琛ㄥ瓧娈碉細鏄惁鍙互鏌ョ湅绠$悊閮ㄩ棬鐨勬墍鏈夊挩璇㈠崟 +-- 鎵ц鏃堕棿: 2025-12-04 +-- 鍔熻兘璇存槑: 鐢ㄤ簬鏍囪瘑鐢ㄦ埛鏄惁鎷ユ湁鏌ョ湅鍏剁鐞嗛儴闂ㄦ墍鏈夊挩璇㈠崟鐨勬潈闄� + +-- 娣诲姞瀛楁 +ALTER TABLE `sys_user` ADD COLUMN `can_view_all_consult` CHAR(1) DEFAULT '0' COMMENT '鏄惁鍙煡鐪嬫墍鏈夊挩璇㈠崟锛�0鍚� 1鏄級' AFTER `wechat_nickname`; + +-- 璇存槑 +-- 1. can_view_all_consult: 鏍囪瘑鐢ㄦ埛鏄惁鍙互鏌ョ湅绠$悊閮ㄩ棬鐨勬墍鏈夊挩璇㈠崟 +-- 2. 榛樿鍊间负 '0'锛堝惁锛夛紝琛ㄧず鏅�氱敤鎴� +-- 3. 鍊间负 '1'锛堟槸锛夎〃绀鸿鐢ㄦ埛鏈夋煡鐪嬫墍鏈夊挩璇㈠崟鐨勬潈闄� +-- 4. 璇ユ潈闄愪笌OA绯荤粺涓殑OA_Power瀛楁鍏宠仈锛屽寘鍚�',020112,'琛ㄧず鎷ユ湁璇ユ潈闄� -- Gitblit v1.9.1