From 2dd746205354cfab4b4ae6a7c8624bc54b1843fa Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期四, 13 七月 2023 17:17:45 +0800
Subject: [PATCH] update 优化 三方授权 增加一条默认绑定数据
---
script/sql/update/postgres/update_5.0-5.1.sql | 17 ++++++++++-------
1 files changed, 10 insertions(+), 7 deletions(-)
diff --git a/script/sql/update/postgres/update_5.0-5.1.sql b/script/sql/update/postgres/update_5.0-5.1.sql
index 3537bfd..df0df7f 100644
--- a/script/sql/update/postgres/update_5.0-5.1.sql
+++ b/script/sql/update/postgres/update_5.0-5.1.sql
@@ -20,7 +20,7 @@
email varchar(255) default ''::varchar,
avatar varchar(500) default ''::varchar,
access_token varchar(255) not null,
- expire_in int8 default null::varchar,
+ expire_in int8 default null,
refresh_token varchar(255) default null::varchar,
access_code varchar(255) default null::varchar,
union_id varchar(255) default null::varchar,
@@ -72,17 +72,20 @@
comment on column sys_social.update_time is '鏇存柊鏃堕棿';
comment on column sys_social.del_flag is '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�';
+insert into sys_social values (1, 1, '000000', 'GITEE1766278', 'GITEE', NULL, 'JavaLionLi', '', '', 'https://foruda.gitee.com/avatar/1676987709652631782/1766278_javalionli_1585201115.png', '2a25b8a8b6803939070d931cdb1f9540', 86400, '448155d0a9c35e6a036a346f7a090f9b3aa7fd41fd2e9563e71e38a7faffbe1c', NULL, NULL, 'user_info projects', 'bearer', NULL, NULL, NULL, NULL, NULL, NULL, 103, 1, '2023-07-13 17:12:01', 1, '2023-07-13 17:12:01', '0');
+
+
-- ----------------------------
-- 绯荤粺鎺堟潈琛�
-- ----------------------------
drop table if exists sys_client;
create table sys_client (
id int8,
- client_id varchar(64) ''::varchar,
- client_key varchar(32) ''::varchar,
- client_secret varchar(255) ''::varchar,
- grant_type varchar(255) ''::varchar,
- device_type varchar(32) ''::varchar,
+ client_id varchar(64) default ''::varchar,
+ client_key varchar(32) default ''::varchar,
+ client_secret varchar(255) default ''::varchar,
+ grant_type varchar(255) default ''::varchar,
+ device_type varchar(32) default ''::varchar,
active_timeout int4 default 1800,
timeout int4 default 604800,
status char(1) default '0'::bpchar,
@@ -93,7 +96,7 @@
update_by int8,
update_time timestamp,
constraint sys_client_pk primary key (id)
-)
+);
comment on table sys_client is '绯荤粺鎺堟潈琛�';
comment on column sys_client.id is '涓诲缓';
--
Gitblit v1.9.3