From 25836328835ca4f017658ab546b654a5e5b92c09 Mon Sep 17 00:00:00 2001 From: 疯狂的狮子Li <15040126243@163.com> Date: 星期四, 25 四月 2024 12:50:42 +0800 Subject: [PATCH] update springboot 3.2.4 => 3.2.5 update mybatis-plus 3.5.5 => 3.5.6 适配更改代码 update springdoc 2.4.0 => 2.5.0 update easyexcel 3.3.3 => 3.3.4 update redisson 3.27.2 => 3.29.0 update lombok 1.18.30 => 1.18.32 update sms4j 3.2.0 => 3.2.1 --- script/sql/update/postgres/update_5.1.2-5.2.0.sql | 12 +++++++----- 1 files changed, 7 insertions(+), 5 deletions(-) diff --git a/script/sql/update/postgres/update_5.1.2-5.2.0.sql b/script/sql/update/postgres/update_5.1.2-5.2.0.sql index e8b2199..6b123b4 100644 --- a/script/sql/update/postgres/update_5.1.2-5.2.0.sql +++ b/script/sql/update/postgres/update_5.1.2-5.2.0.sql @@ -1,6 +1,8 @@ -ALTER TABLE sys_dept - ADD COLUMN dept_category VARCHAR(100) DEFAULT NULL COMMENT '閮ㄩ棬绫诲埆缂栫爜'; -ALTER TABLE sys_post - ADD COLUMN dept_id BIGINT NOT NULL COMMENT '閮ㄩ棬id', - ADD COLUMN post_category VARCHAR(100) DEFAULT NULL COMMENT '宀椾綅绫诲埆缂栫爜'; +ALTER TABLE sys_dept ADD COLUMN dept_category varchar(100) default null::varchar; +COMMENT ON COLUMN sys_dept.dept_category IS '瀹㈡埛绔�'; +ALTER TABLE sys_post ADD COLUMN dept_id int8 NOT NULL; +COMMENT ON COLUMN sys_post.dept_id IS '閮ㄩ棬id'; +ALTER TABLE sys_post ADD COLUMN post_category varchar(100) default null::varchar; +COMMENT ON COLUMN sys_post.post_category IS '宀椾綅绫诲埆缂栫爜'; UPDATE sys_post SET dept_id = 100; +UPDATE sys_post SET dept_id = 103 where post_id = 1; -- Gitblit v1.9.3