From dcf79d91192e821fe7b1e62260dba82eede64d9f Mon Sep 17 00:00:00 2001 From: 疯狂的狮子li <15040126243@163.com> Date: 星期一, 17 一月 2022 18:32:02 +0800 Subject: [PATCH] add 增加 3.X update 4.0 更新sql --- script/sql/update/update-3.X-4.0.sql | 6 ++++++ script/sql/ry_vue_4.0.sql | 0 2 files changed, 6 insertions(+), 0 deletions(-) diff --git a/script/sql/ry_20210908.sql b/script/sql/ry_vue_4.0.sql similarity index 100% rename from script/sql/ry_20210908.sql rename to script/sql/ry_vue_4.0.sql diff --git a/script/sql/update/update-3.X-4.0.sql b/script/sql/update/update-3.X-4.0.sql new file mode 100644 index 0000000..de41178 --- /dev/null +++ b/script/sql/update/update-3.X-4.0.sql @@ -0,0 +1,6 @@ +ALTER TABLE `sys_user` MODIFY COLUMN `user_type` varchar(10) DEFAULT 'sys_user' COMMENT '鐢ㄦ埛绫诲瀷锛坰ys_user绯荤粺鐢ㄦ埛锛�' AFTER `nick_name`; + +UPDATE `sys_user` SET `nick_name` = '鐤媯鐨勭嫯瀛怢i', `user_type` = 'sys_user', `email` = 'crazyLionLi@163.com' WHERE `user_id` = 1; +UPDATE `sys_user` SET `user_name` = 'lionli', `nick_name` = '鐤媯鐨勭嫯瀛怢i', `user_type` = 'sys_user', `email` = 'crazyLionLi@163.com' WHERE `user_id` = 2; +UPDATE `sys_user` SET `user_type` = 'sys_user' WHERE `user_id` = 3; +UPDATE `sys_user` SET `user_type` = 'sys_user' WHERE `user_id` = 4; -- Gitblit v1.9.3