From 0c09adfe0a69b00df83e347e1e95864d07e7abba Mon Sep 17 00:00:00 2001 From: 疯狂的狮子Li <15040126243@163.com> Date: 星期五, 28 七月 2023 15:37:49 +0800 Subject: [PATCH] update 优化 过期的 Security 方法 --- script/sql/postgres/postgres_ry_vue_5.X.sql | 14 +++++++------- 1 files changed, 7 insertions(+), 7 deletions(-) diff --git a/script/sql/postgres/postgres_ry_vue_5.X.sql b/script/sql/postgres/postgres_ry_vue_5.X.sql index eff1217..d2f39f0 100644 --- a/script/sql/postgres/postgres_ry_vue_5.X.sql +++ b/script/sql/postgres/postgres_ry_vue_5.X.sql @@ -14,7 +14,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, @@ -1225,11 +1225,11 @@ 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, @@ -1240,7 +1240,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