From 29e1bf3f2ebddddc1969ecd385dcbb4f6d0f88f1 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期五, 11 三月 2022 13:29:21 +0800
Subject: [PATCH] add 增加 4.0 升级 4.1 的 sql 脚本

---
 script/sql/oracle/oracle_ry_vue_4.X.sql |    9 +++++----
 1 files changed, 5 insertions(+), 4 deletions(-)

diff --git a/script/sql/oracle/oracle_ry_vue_4.X.sql b/script/sql/oracle/oracle_ry_vue_4.X.sql
index 5342d14..6295231 100644
--- a/script/sql/oracle/oracle_ry_vue_4.X.sql
+++ b/script/sql/oracle/oracle_ry_vue_4.X.sql
@@ -57,8 +57,8 @@
 create table sys_user (
   user_id           number(20)      not null,
   dept_id           number(20)      default null,
-  user_name         varchar2(30)    not null,
-  nick_name         varchar2(30)    not null,
+  user_name         varchar2(40)    not null,
+  nick_name         varchar2(40)    not null,
   user_type         varchar2(10)    default 'sys_user',
   email             varchar2(50)    default '',
   phonenumber       varchar2(11)    default '',
@@ -953,7 +953,8 @@
 return(Result);
 end find_in_set;
 
-/ -- 鍑芥暟鍒嗛殧绗�
+-- 鍑芥暟鍒嗛殧绗�
+/
 
 -- ----------------------------
 -- 閽╁瓙 锛岀敤浜巗ession杩炴帴涔嬪悗 鑷姩璁剧疆榛樿鐨刣ate绫诲瀷鏍煎紡鍖� 绠�鍖栨椂闂存煡璇�
@@ -964,4 +965,4 @@
 after logon on database
 begin
 execute immediate 'alter session set nls_date_format=''YYYY-MM-DD HH24:MI:SS''';
-end login_trg;
+end;

--
Gitblit v1.9.3