| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150 |
- ALTER TABLE gen_table ADD data_name varchar(200) default ''::varchar;
- COMMENT ON COLUMN gen_table.data_name IS '数据源名称';
- UPDATE sys_menu SET path = 'powerjob', component = 'monitor/powerjob/index', perms = 'monitor:powerjob:list', remark = 'powerjob控制台菜单' WHERE menu_id = 120;
- -- ----------------------------
- -- 第三方平台授权表
- -- ----------------------------
- 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,
- 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 '平台+平台唯一id';
- comment on column sys_social.source is '用户来源';
- 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 '用户邮箱';
- 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 '用户的授权code，部分平台可能没有';
- 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_client;
- create table sys_client (
- id int8,
- 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,
- del_flag char(1) default '0'::bpchar,
- create_dept int8,
- create_by int8,
- create_time timestamp,
- 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 '主建';
- comment on column sys_client.client_id is '客户端id';
- comment on column sys_client.client_key is '客户端key';
- comment on column sys_client.client_secret is '客户端秘钥';
- comment on column sys_client.grant_type is '授权类型';
- comment on column sys_client.device_type is '设备类型';
- comment on column sys_client.active_timeout is 'token活跃超时时间';
- comment on column sys_client.timeout is 'token固定超时';
- comment on column sys_client.status is '状态（0正常 1停用）';
- comment on column sys_client.del_flag is '删除标志（0代表存在 2代表删除）';
- comment on column sys_client.create_dept is '创建部门';
- comment on column sys_client.create_by is '创建者';
- comment on column sys_client.create_time is '创建时间';
- comment on column sys_client.update_by is '更新者';
- comment on column sys_client.update_time is '更新时间';
- insert into sys_client values (1, 'e5cd7e4891bf95d1d19206ce24a7b32e', 'pc', 'pc123', 'password,social', 'pc', 1800, 604800, 0, 0, 103, 1, now(), 1, now());
- insert into sys_client values (2, '428a8310cd442757ae699df5d894f051', 'app', 'app123', 'password,sms,social', 'android', 1800, 604800, 0, 0, 103, 1, now(), 1, now());
- insert into sys_dict_type values(11, '000000', '授权类型', 'sys_grant_type', '0', 103, 1, now(), null, null, '认证授权类型');
- insert into sys_dict_type values(12, '000000', '设备类型', 'sys_device_type', '0', 103, 1, now(), null, null, '客户端设备类型');
- insert into sys_dict_data values(30, '000000', 0, '密码认证', 'password', 'sys_grant_type', '', 'default', 'N', '0', 103, 1, now(), null, null, '密码认证');
- insert into sys_dict_data values(31, '000000', 0, '短信认证', 'sms', 'sys_grant_type', '', 'default', 'N', '0', 103, 1, now(), null, null, '短信认证');
- insert into sys_dict_data values(32, '000000', 0, '邮件认证', 'email', 'sys_grant_type', '', 'default', 'N', '0', 103, 1, now(), null, null, '邮件认证');
- insert into sys_dict_data values(33, '000000', 0, '小程序认证', 'xcx', 'sys_grant_type', '', 'default', 'N', '0', 103, 1, now(), null, null, '小程序认证');
- insert into sys_dict_data values(34, '000000', 0, '三方登录认证', 'social', 'sys_grant_type', '', 'default', 'N', '0', 103, 1, now(), null, null, '三方登录认证');
- insert into sys_dict_data values(35, '000000', 0, 'PC', 'pc', 'sys_device_type', '', 'default', 'N', '0', 103, 1, now(), null, null, 'PC');
- insert into sys_dict_data values(36, '000000', 0, '安卓', 'android', 'sys_device_type', '', 'default', 'N', '0', 103, 1, now(), null, null, '安卓');
- insert into sys_dict_data values(37, '000000', 0, 'iOS', 'ios', 'sys_device_type', '', 'default', 'N', '0', 103, 1, now(), null, null, 'iOS');
- insert into sys_dict_data values(38, '000000', 0, '小程序', 'xcx', 'sys_device_type', '', 'default', 'N', '0', 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, '客户端管理菜单');
- -- 客户端管理按钮
- insert into sys_menu values('1061', '客户端管理查询', '123', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:client:query', '#', 103, 1, now(), null, null, '');
- insert into sys_menu values('1062', '客户端管理新增', '123', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:client:add', '#', 103, 1, now(), null, null, '');
- insert into sys_menu values('1063', '客户端管理修改', '123', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:client:edit', '#', 103, 1, now(), null, null, '');
- insert into sys_menu values('1064', '客户端管理删除', '123', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:client:remove', '#', 103, 1, now(), null, null, '');
- insert into sys_menu values('1065', '客户端管理导出', '123', '5', '#', '', '', '1', '0', 'F', '0', '0', 'system:client:export', '#', 103, 1, now(), null, null, '');
- -- 角色菜单权限
- insert into sys_role_menu values ('2', '1061');
- insert into sys_role_menu values ('2', '1062');
- insert into sys_role_menu values ('2', '1063');
- insert into sys_role_menu values ('2', '1064');
- insert into sys_role_menu values ('2', '1065');
- update sys_dept set leader = null;
- ALTER TABLE sys_dept ALTER COLUMN leader TYPE int8;
|
