From 9448782f451790beb05b2e6717683dc0a59d6a24 Mon Sep 17 00:00:00 2001 From: 疯狂的狮子Li <15040126243@163.com> Date: 星期二, 20 六月 2023 15:00:16 +0800 Subject: [PATCH] update 优化 !pr370 完成三方登录授权功能 --- script/sql/postgres/postgres_ry_vue_5.X.sql | 68 ++++++++++++++++++++++++++++++++++ 1 files changed, 68 insertions(+), 0 deletions(-) diff --git a/script/sql/postgres/postgres_ry_vue_5.X.sql b/script/sql/postgres/postgres_ry_vue_5.X.sql index 546deee..a5123ce 100644 --- a/script/sql/postgres/postgres_ry_vue_5.X.sql +++ b/script/sql/postgres/postgres_ry_vue_5.X.sql @@ -1,4 +1,72 @@ -- ---------------------------- +-- 绗笁鏂瑰钩鍙版巿鏉冭〃 +-- ---------------------------- +create table sys_social +( + id int8 not null, + user_id int8 not null, + tenant_id varchar(20) default null::varchar, + auth_id varchar(255) not null, + source varchar(255) not null, + open_id varchar(255) default null::varchar, + user_name varchar(30) not null, + nick_name varchar(30) default ''::varchar, + email varchar(255) default ''::varchar, + avatar varchar(500) default ''::varchar, + access_token varchar(255) not null, + expire_in int8 default null::varchar, + refresh_token varchar(255) default null::varchar, + access_code varchar(255) default null::varchar, + union_id varchar(255) default null::varchar, + scope varchar(255) default null::varchar, + token_type varchar(255) default null::varchar, + id_token varchar(255) default null::varchar, + mac_algorithm varchar(255) default null::varchar, + mac_key varchar(255) default null::varchar, + code varchar(255) default null::varchar, + oauth_token varchar(255) default null::varchar, + oauth_token_secret varchar(255) default null::varchar, + create_dept int8, + create_by int8, + create_time timestamp, + update_by int8, + update_time timestamp, + del_flag char default '0'::bpchar, + constraint "pk_sys_social" primary key (id) +); + +comment on table sys_social is '绀句細鍖栧叧绯昏〃'; +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.source is '鐢ㄦ埛鏉ユ簮'; +comment on column sys_social.open_id is '鍘熺敓openid'; +comment on column sys_social.user_name is '鐧诲綍璐﹀彿'; +comment on column sys_social.nick_name is '鐢ㄦ埛鏄电О'; +comment on column sys_social.email is '鐢ㄦ埛閭'; +comment on column sys_social.avatar is '澶村儚鍦板潃'; +comment on column sys_social.access_token is '鐢ㄦ埛鐨勬巿鏉冧护鐗�'; +comment on column sys_social.expire_in is '鐢ㄦ埛鐨勬巿鏉冧护鐗岀殑鏈夋晥鏈燂紝閮ㄥ垎骞冲彴鍙兘娌℃湁'; +comment on column sys_social.refresh_token is '鍒锋柊浠ょ墝锛岄儴鍒嗗钩鍙板彲鑳芥病鏈�'; +comment on column sys_social.access_code is '骞冲彴鐨勬巿鏉冧俊鎭紝閮ㄥ垎骞冲彴鍙兘娌℃湁'; +comment on column sys_social.union_id is '鐢ㄦ埛鐨� unionid'; +comment on column sys_social.scope is '鎺堜簣鐨勬潈闄愶紝閮ㄥ垎骞冲彴鍙兘娌℃湁'; +comment on column sys_social.token_type is '涓埆骞冲彴鐨勬巿鏉冧俊鎭紝閮ㄥ垎骞冲彴鍙兘娌℃湁'; +comment on column sys_social.id_token is 'id token锛岄儴鍒嗗钩鍙板彲鑳芥病鏈�'; +comment on column sys_social.mac_algorithm is '灏忕背骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁'; +comment on column sys_social.mac_key is '灏忕背骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁'; +comment on column sys_social.code is '鐢ㄦ埛鐨勬巿鏉僣ode锛岄儴鍒嗗钩鍙板彲鑳芥病鏈�'; +comment on column sys_social.oauth_token is 'Twitter骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁'; +comment on column sys_social.oauth_token_secret is 'Twitter骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁'; +comment on column sys_social.create_dept is '鍒涘缓閮ㄩ棬'; +comment on column sys_social.create_by is '鍒涘缓鑰�'; +comment on column sys_social.create_time is '鍒涘缓鏃堕棿'; +comment on column sys_social.update_by is '鏇存柊鑰�'; +comment on column sys_social.update_time is '鏇存柊鏃堕棿'; +comment on column sys_social.del_flag is '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�'; + +-- ---------------------------- -- 绉熸埛琛� -- ---------------------------- drop table if exists sys_tenant; -- Gitblit v1.9.3