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/update/postgres/update_5.0-5.1.sql | 14 +++++++-------
1 files changed, 7 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..c98b5a7 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,
@@ -78,11 +78,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,
@@ -93,7 +93,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