From 18e3b424d603aed47408081bf66398532b24df12 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期日, 28 四月 2024 12:31:59 +0800
Subject: [PATCH] fix 修复 兼容redis5.0出现的问题

---
 script/sql/update/oracle/update_5.1.2-5.2.0.sql |    9 +++++++--
 1 files changed, 7 insertions(+), 2 deletions(-)

diff --git a/script/sql/update/oracle/update_5.1.2-5.2.0.sql b/script/sql/update/oracle/update_5.1.2-5.2.0.sql
index 42769a2..90f488b 100644
--- a/script/sql/update/oracle/update_5.1.2-5.2.0.sql
+++ b/script/sql/update/oracle/update_5.1.2-5.2.0.sql
@@ -1,3 +1,8 @@
-ALTER TABLE sys_dept ADD dept_category VARCHAR2(100) DEFAULT NULL COMMENT '閮ㄩ棬绫诲埆缂栫爜';
-ALTER TABLE sys_post ADD dept_id NUMBER(20) NOT NULL COMMENT '閮ㄩ棬id', ADD post_category VARCHAR2(100) DEFAULT NULL COMMENT '宀椾綅绫诲埆缂栫爜';
+ALTER TABLE sys_dept ADD (dept_category varchar2(100) DEFAULT NULL) COMMENT '閮ㄩ棬绫诲埆缂栫爜';
+COMMENT ON COLUMN sys_dept.dept_category IS '閮ㄩ棬绫诲埆缂栫爜';
+ALTER TABLE sys_post ADD (dept_id number(20) NOT NULL) COMMENT '閮ㄩ棬id';
+COMMENT ON COLUMN sys_post.dept_id IS '閮ㄩ棬id';
+ALTER TABLE sys_post ADD (post_category VARCHAR2(100) DEFAULT NULL) COMMENT '宀椾綅绫诲埆缂栫爜';
+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