| | |
|---|
| | | 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, |
|---|
| | |
|---|
| | | 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.auth_id is '平台+平台唯一id'; |
|---|
| | | comment on column sys_social.source is '用户来源'; |
|---|
| | | comment on column sys_social.open_id is '原生openid'; |
|---|
| | | comment on column sys_social.open_id is '平台编号唯一id'; |
|---|
| | | comment on column sys_social.user_name is '登录账号'; |
|---|
| | | comment on column sys_social.nick_name is '用户昵称'; |
|---|
| | | comment on column sys_social.email is '用户邮箱'; |
|---|
| | |
|---|
| | | insert into sys_menu values('115', '代码生成', '3', '2', 'gen', 'tool/gen/index', '', '1', '0', 'C', '0', '0', 'tool:gen:list', 'code', 103, 1, now(), null, null, '代码生成菜单'); |
|---|
| | | insert into sys_menu values('121', '租户管理', '6', '1', 'tenant', 'system/tenant/index', '', '1', '0', 'C', '0', '0', 'system:tenant:list', 'list', 103, 1, now(), null, null, '租户管理菜单'); |
|---|
| | | insert into sys_menu values('122', '租户套餐管理', '6', '2', 'tenantPackage', 'system/tenantPackage/index', '', '1', '0', 'C', '0', '0', 'system:tenantPackage:list', 'form', 103, 1, now(), null, null, '租户套餐管理菜单'); |
|---|
| | | insert into sys_menu values('123', '客户端管理', '1', '1', 'client', 'system/client/index', '', '1', '0', 'C', '0', '0', 'system:client:list', 'international', 103, 1, now(), null, null, '客户端管理菜单'); |
|---|
| | | insert into sys_menu values('123', '客户端管理', '1', '11', 'client', 'system/client/index', '', '1', '0', 'C', '0', '0', 'system:client:list', 'international', 103, 1, now(), null, null, '客户端管理菜单'); |
|---|
| | | |
|---|
| | | -- springboot-admin监控 |
|---|
| | | insert into sys_menu values('117', 'Admin监控', '2', '5', 'Admin', 'monitor/admin/index', '', '1', '0', 'C', '0', '0', 'monitor:admin:list', 'dashboard', 103, 1, now(), null, null, 'Admin监控菜单'); |
|---|
| | |
|---|
| | | 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, |
|---|
| | |
|---|
| | | 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 '主建'; |
|---|
