From bd50596038614e8fced3d7a2396b4b28602ba7f5 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期二, 04 七月 2023 22:25:45 +0800
Subject: [PATCH] fix 修复 postgres 更新sql语法问题
---
script/sql/oracle/oracle_ry_vue_5.X.sql | 114 ++++++++++++++++++++++++++++----------------------------
1 files changed, 57 insertions(+), 57 deletions(-)
diff --git a/script/sql/oracle/oracle_ry_vue_5.X.sql b/script/sql/oracle/oracle_ry_vue_5.X.sql
index 69efffc..25c855a 100644
--- a/script/sql/oracle/oracle_ry_vue_5.X.sql
+++ b/script/sql/oracle/oracle_ry_vue_5.X.sql
@@ -5,27 +5,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,
@@ -40,9 +40,9 @@
comment on column sys_social.id is '涓婚敭';
comment on column sys_social.user_id is '鐢ㄦ埛ID';
comment on column sys_social.tenant_id is '绉熸埛id';
-comment on column sys_social.auth_id is '鎺堟潈+鎺堟潈openid';
+comment on column sys_social.auth_id is '骞冲彴+骞冲彴鍞竴id';
comment on column sys_social.source is '鐢ㄦ埛鏉ユ簮';
-comment on column sys_social.open_id is '鍘熺敓openid';
+comment on column sys_social.open_id is '骞冲彴缂栧彿鍞竴id';
comment on column sys_social.user_name is '鐧诲綍璐﹀彿';
comment on column sys_social.nick_name is '鐢ㄦ埛鏄电О';
comment on column sys_social.email is '鐢ㄦ埛閭';
@@ -373,9 +373,9 @@
menu_name varchar2(50) not null,
parent_id number(20) default 0,
order_num number(4) default 0,
- path varchar(200) default '',
- component varchar(255) default null,
- query_param varchar(255) default null,
+ path varchar2(200) default '',
+ component varchar2(255) default null,
+ query_param varchar2(255) default null,
is_frame number(1) default 1,
is_cache number(1) default 0,
menu_type char(1) default '',
@@ -440,7 +440,7 @@
insert into sys_menu values('115', '浠ｇ爜鐢熸垚', '3', '2', 'gen', 'tool/gen/index', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 103, 1, sysdate, null, null, '浠ｇ爜鐢熸垚鑿滃崟');
insert into sys_menu values('121', '绉熸埛绠＄悊', '6', '1', 'tenant', 'system/tenant/index', '', 1, 0, 'C', '0', '0', 'system:tenant:list', 'list', 103, 1, sysdate, null, null, '绉熸埛绠＄悊鑿滃崟');
insert into sys_menu values('122', '绉熸埛濂楅绠＄悊', '6', '2', 'tenantPackage', 'system/tenantPackage/index', '', 1, 0, 'C', '0', '0', 'system:tenantPackage:list', 'form', 103, 1, sysdate, null, null, '绉熸埛濂楅绠＄悊鑿滃崟');
-insert into sys_menu values('123', '瀹㈡埛绔鐞�', '1', '1', 'client', 'system/client/index', '', 1, 0, 'C', '0', '0', 'system:client:list', 'international', 103, 1, sysdate, null, null, '瀹㈡埛绔鐞嗚彍鍗�');
+insert into sys_menu values('123', '瀹㈡埛绔鐞�', '1', '11', 'client', 'system/client/index', '', 1, 0, 'C', '0', '0', 'system:client:list', 'international', 103, 1, sysdate, null, null, '瀹㈡埛绔鐞嗚彍鍗�');
-- springboot-admin鐩戞帶
insert into sys_menu values('117', 'Admin鐩戞帶', '2', '5', 'Admin', 'monitor/admin/index', '', 1, 0, 'C', '0', '0', 'monitor:admin:list', 'dashboard', 103, 1, sysdate, null, null, 'Admin鐩戞帶鑿滃崟');
-- oss鑿滃崟
@@ -538,11 +538,11 @@
insert into sys_menu values('1614', '绉熸埛濂楅鍒犻櫎', '122', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:tenantPackage:remove', '#', 103, 1, sysdate, null, null, '');
insert into sys_menu values('1615', '绉熸埛濂楅瀵煎嚭', '122', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:tenantPackage:export', '#', 103, 1, sysdate, null, null, '');
-- 瀹㈡埛绔鐞嗘寜閽�
-insert into sys_menu values('1061', '瀹㈡埛绔鐞嗘煡璇�', '123', '1', '#', '', 1, 0, 'F', '0', '0', 'system:client:query', '#', 103, 1, sysdate, null, null, '');
-insert into sys_menu values('1062', '瀹㈡埛绔鐞嗘柊澧�', '123', '2', '#', '', 1, 0, 'F', '0', '0', 'system:client:add', '#', 103, 1, sysdate, null, null, '');
-insert into sys_menu values('1063', '瀹㈡埛绔鐞嗕慨鏀�', '123', '3', '#', '', 1, 0, 'F', '0', '0', 'system:client:edit', '#', 103, 1, sysdate, null, null, '');
-insert into sys_menu values('1064', '瀹㈡埛绔鐞嗗垹闄�', '123', '4', '#', '', 1, 0, 'F', '0', '0', 'system:client:remove', '#', 103, 1, sysdate, null, null, '');
-insert into sys_menu values('1065', '瀹㈡埛绔鐞嗗鍑�', '123', '5', '#', '', 1, 0, 'F', '0', '0', 'system:client:export', '#', 103, 1, sysdate, null, null, '');
+insert into sys_menu values('1061', '瀹㈡埛绔鐞嗘煡璇�', '123', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:client:query', '#', 103, 1, sysdate, null, null, '');
+insert into sys_menu values('1062', '瀹㈡埛绔鐞嗘柊澧�', '123', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:client:add', '#', 103, 1, sysdate, null, null, '');
+insert into sys_menu values('1063', '瀹㈡埛绔鐞嗕慨鏀�', '123', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:client:edit', '#', 103, 1, sysdate, null, null, '');
+insert into sys_menu values('1064', '瀹㈡埛绔鐞嗗垹闄�', '123', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:client:remove', '#', 103, 1, sysdate, null, null, '');
+insert into sys_menu values('1065', '瀹㈡埛绔鐞嗗鍑�', '123', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:client:export', '#', 103, 1, sysdate, null, null, '');
-- ----------------------------
-- 6銆佺敤鎴峰拰瑙掕壊鍏宠仈琛� 鐢ㄦ埛N-1瑙掕壊
@@ -719,7 +719,7 @@
title varchar2(50) default '',
business_type number(2) default 0,
method varchar2(100) default '',
- request_method varchar(10) default '',
+ request_method varchar2(10) default '',
operator_type number(1) default 0,
oper_name varchar2(50) default '',
dept_name varchar2(50) default '',
@@ -1003,8 +1003,8 @@
data_name varchar2(200) default '',
table_name varchar2(200) default '',
table_comment varchar2(500) default '',
- sub_table_name varchar(64) default null,
- sub_table_fk_name varchar(64) default null,
+ sub_table_name varchar2(64) default null,
+ sub_table_fk_name varchar2(64) default null,
class_name varchar2(100) default '',
tpl_category varchar2(200) default 'crud',
package_name varchar2(100),
@@ -1068,9 +1068,9 @@
is_edit char(1),
is_list char(1),
is_query char(1),
- query_type varchar(200) default 'EQ',
- html_type varchar(200),
- dict_type varchar(200) default '',
+ query_type varchar2(200) default 'EQ',
+ html_type varchar2(200),
+ dict_type varchar2(200) default '',
sort number(4),
create_dept number(20) default null,
create_by number(20) default null,
@@ -1113,11 +1113,11 @@
create table sys_oss (
oss_id number(20) not null,
tenant_id varchar2(20) default '000000',
- file_name varchar(255) not null,
- original_name varchar(255) not null,
- file_suffix varchar(10) not null,
- url varchar(500) not null,
- service varchar(20) default 'minio' not null,
+ file_name varchar2(255) not null,
+ original_name varchar2(255) not null,
+ file_suffix varchar2(10) not null,
+ url varchar2(500) not null,
+ service varchar2(20) default 'minio' not null,
create_dept number(20) default null,
create_by number(20) default null,
create_time date,
@@ -1148,19 +1148,19 @@
create table sys_oss_config (
oss_config_id number(20) not null,
tenant_id varchar2(20) default '000000',
- config_key varchar(20) not null,
- access_key varchar(255) default '',
- secret_key varchar(255) default '',
- bucket_name varchar(255) default '',
- prefix varchar(255) default '',
- endpoint varchar(255) default '',
- domain varchar(255) default '',
+ config_key varchar2(20) not null,
+ access_key varchar2(255) default '',
+ secret_key varchar2(255) default '',
+ bucket_name varchar2(255) default '',
+ prefix varchar2(255) default '',
+ endpoint varchar2(255) default '',
+ domain varchar2(255) default '',
is_https char(1) default 'N',
- region varchar(255) default '',
+ region varchar2(255) default '',
access_policy char(1) default '1' not null,
status char(1) default '1',
- ext1 varchar(255) default '',
- remark varchar(500) default null,
+ ext1 varchar2(255) default '',
+ remark varchar2(500) default null,
create_dept number(20) default null,
create_by number(20) default null,
create_time date,
@@ -1203,11 +1203,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