From ffa702935c0ad3d263d46eec03f356fdd51b74bf Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期四, 25 四月 2024 00:03:01 +0800
Subject: [PATCH] update 优化 !pr520 存在的问题

---
 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