From 8bff33d6728d8a51bece7c60b0fa96394e066cb5 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期日, 02 七月 2023 15:21:52 +0800
Subject: [PATCH] update 优化 将oracle脚本 varchar 更新为 varchar2
---
script/sql/update/oracle/update_5.0-5.1.sql | 50 +++++++++++++++++++++++++-------------------------
1 files changed, 25 insertions(+), 25 deletions(-)
diff --git a/script/sql/update/oracle/update_5.0-5.1.sql b/script/sql/update/oracle/update_5.0-5.1.sql
index d490f23..aa3ac6d 100644
--- a/script/sql/update/oracle/update_5.0-5.1.sql
+++ b/script/sql/update/oracle/update_5.0-5.1.sql
@@ -11,27 +11,27 @@
(
id number(20) not null,
user_id number(20) not null,
- tenant_id varchar(20) default null,
- auth_id varchar(255) not null,
- source varchar(255) not null,
- open_id varchar(255) default null,
- user_name varchar(30) not null,
- nick_name varchar(30) default '',
- email varchar(255) default '',
- avatar varchar(500) default '',
- access_token varchar(255) not null,
+ tenant_id varchar2(20) default null,
+ auth_id varchar2(255) not null,
+ source varchar2(255) not null,
+ open_id varchar2(255) default null,
+ user_name varchar2(30) not null,
+ nick_name varchar2(30) default '',
+ email varchar2(255) default '',
+ avatar varchar2(500) default '',
+ access_token varchar2(255) not null,
expire_in number(100) default null,
- refresh_token varchar(255) default null,
- access_code varchar(255) default null,
- union_id varchar(255) default null,
- scope varchar(255) default null,
- token_type varchar(255) default null,
- id_token varchar(255) default null,
- mac_algorithm varchar(255) default null,
- mac_key varchar(255) default null,
- code varchar(255) default null,
- oauth_token varchar(255) default null,
- oauth_token_secret varchar(255) default null,
+ refresh_token varchar2(255) default null,
+ access_code varchar2(255) default null,
+ union_id varchar2(255) default null,
+ scope varchar2(255) default null,
+ token_type varchar2(255) default null,
+ id_token varchar2(255) default null,
+ mac_algorithm varchar2(255) default null,
+ mac_key varchar2(255) default null,
+ code varchar2(255) default null,
+ oauth_token varchar2(255) default null,
+ oauth_token_secret varchar2(255) default null,
create_dept number(20),
create_by number(20),
create_time date,
@@ -78,11 +78,11 @@
-- ----------------------------
create table sys_client (
id number(20) not null,
- client_id varchar(64) default null,
- client_key varchar(32) default null,
- client_secret varchar(255) default null,
- grant_type varchar(255) default null,
- device_type varchar(32) default null,
+ client_id varchar2(64) default null,
+ client_key varchar2(32) default null,
+ client_secret varchar2(255) default null,
+ grant_type varchar2(255) default null,
+ device_type varchar2(32) default null,
active_timeout number(11) default 1800,
timeout number(11) default 604800,
status char(1) default '0',
--
Gitblit v1.9.3