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/update/update_5.0-5.1.sql | 38 ++++++++++++++++++++++++++++++++++++++ 1 files changed, 38 insertions(+), 0 deletions(-) diff --git a/script/sql/update/update_5.0-5.1.sql b/script/sql/update/update_5.0-5.1.sql index 2959520..353ca21 100644 --- a/script/sql/update/update_5.0-5.1.sql +++ b/script/sql/update/update_5.0-5.1.sql @@ -1,3 +1,41 @@ ALTER TABLE gen_table ADD COLUMN data_name varchar(200) NULL DEFAULT '' COMMENT '鏁版嵁婧愬悕绉�' AFTER table_id; UPDATE sys_menu SET path = 'powerjob', component = 'monitor/powerjob/index', perms = 'monitor:powerjob:list', remark = 'powerjob鎺у埗鍙拌彍鍗�' WHERE menu_id = 120 + +-- ---------------------------- +-- 绗笁鏂瑰钩鍙版巿鏉冭〃 +-- ---------------------------- +drop table if exists sys_social; +create table sys_social +( + id bigint not null comment '涓婚敭', + user_id bigint not null comment '鐢ㄦ埛ID', + tenant_id varchar(20) default null comment '绉熸埛id', + auth_id varchar(255) not null comment '鎺堟潈+鎺堟潈openid', + source varchar(255) not null comment '鐢ㄦ埛鏉ユ簮', + open_id varchar(255) default null comment '鍘熺敓open id', + user_name varchar(30) not null comment '鐧诲綍璐﹀彿', + nick_name varchar(30) default '' comment '鐢ㄦ埛鏄电О', + email varchar(255) default '' comment '鐢ㄦ埛閭', + avatar varchar(500) default '' comment '澶村儚鍦板潃', + access_token varchar(255) not null comment '鐢ㄦ埛鐨勬巿鏉冧护鐗�', + expire_in int default null comment '鐢ㄦ埛鐨勬巿鏉冧护鐗岀殑鏈夋晥鏈燂紝閮ㄥ垎骞冲彴鍙兘娌℃湁', + refresh_token varchar(255) default null comment '鍒锋柊浠ょ墝锛岄儴鍒嗗钩鍙板彲鑳芥病鏈�', + access_code varchar(255) default null comment '骞冲彴鐨勬巿鏉冧俊鎭紝閮ㄥ垎骞冲彴鍙兘娌℃湁', + union_id varchar(255) default null comment '鐢ㄦ埛鐨� unionid', + scope varchar(255) default null comment '鎺堜簣鐨勬潈闄愶紝閮ㄥ垎骞冲彴鍙兘娌℃湁', + token_type varchar(255) default null comment '涓埆骞冲彴鐨勬巿鏉冧俊鎭紝閮ㄥ垎骞冲彴鍙兘娌℃湁', + id_token varchar(255) default null comment 'id token锛岄儴鍒嗗钩鍙板彲鑳芥病鏈�', + mac_algorithm varchar(255) default null comment '灏忕背骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁', + mac_key varchar(255) default null comment '灏忕背骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁', + code varchar(255) default null comment '鐢ㄦ埛鐨勬巿鏉僣ode锛岄儴鍒嗗钩鍙板彲鑳芥病鏈�', + oauth_token varchar(255) default null comment 'Twitter骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁', + oauth_token_secret varchar(255) default null comment 'Twitter骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁', + create_dept bigint(20) comment '鍒涘缓閮ㄩ棬', + create_by bigint(20) comment '鍒涘缓鑰�', + create_time datetime comment '鍒涘缓鏃堕棿', + update_by bigint(20) comment '鏇存柊鑰�', + update_time datetime comment '鏇存柊鏃堕棿', + del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�', + PRIMARY KEY (id) +) engine=innodb comment = '绀句細鍖栧叧绯昏〃'; -- Gitblit v1.9.3