From 8a89054c2f1dfa06c6dfc744217b35e66b8a3661 Mon Sep 17 00:00:00 2001 From: 疯狂的狮子li <15040126243@163.com> Date: 星期三, 09 三月 2022 16:21:53 +0800 Subject: [PATCH] add 增加 oracle_test.sql 测试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