| | |
| | | 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, |
| | | id_token varchar(2000) default null::varchar, |
| | | mac_algorithm varchar(255) default null::varchar, |
| | | mac_key varchar(255) default null::varchar, |
| | | code varchar(255) default null::varchar, |
| | |
| | | insert into sys_menu values('118', '文件管理', '1', '10', 'oss', 'system/oss/index', '', '1', '0', 'C', '0', '0', 'system:oss:list', 'upload', 103, 1, now(), null, null, '文件管理菜单'); |
| | | -- powerjob server控制台 |
| | | insert into sys_menu values('120', '任务调度中心', '2', '5', 'powerjob', 'monitor/powerjob/index', '', '1', '0', 'C', '0', '0', 'monitor:powerjob:list', 'job', 103, 1, now(), null, null, 'PowerJob控制台菜单'); |
| | | -- retry server控制台 |
| | | insert into sys_menu values('130', 'EasyRetry控制台', '2', '6', 'easyretry', 'monitor/easyretry/index', '', '1', '0', 'C', '0', '0', 'monitor:easyretry:list', 'job', 103, 1, now(), null, null, 'EasyRetry控制台菜单'); |
| | | |
| | | -- 三级菜单 |
| | | insert into sys_menu values('500', '操作日志', '108', '1', 'operlog', 'monitor/operlog/index', '', '1', '0', 'C', '0', '0', 'monitor:operlog:list', 'form', 103, 1, now(), null, null, '操作日志菜单'); |
| | |
| | | insert into sys_menu values('1601', '文件上传', '118', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:upload', '#', 103, 1, now(), null, null, ''); |
| | | insert into sys_menu values('1602', '文件下载', '118', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:download', '#', 103, 1, now(), null, null, ''); |
| | | insert into sys_menu values('1603', '文件删除', '118', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:remove', '#', 103, 1, now(), null, null, ''); |
| | | insert into sys_menu values('1604', '配置添加', '118', '5', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:add', '#', 103, 1, now(), null, null, ''); |
| | | insert into sys_menu values('1605', '配置编辑', '118', '6', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:edit', '#', 103, 1, now(), null, null, ''); |
| | | insert into sys_menu values('1620', '配置列表', '118', '5', '#', '', '', '1', '0', 'F', '0', '0', 'system:ossConfig:list', '#', 103, 1, now(), null, null, ''); |
| | | insert into sys_menu values('1621', '配置添加', '118', '6', '#', '', '', '1', '0', 'F', '0', '0', 'system:ossConfig:add', '#', 103, 1, now(), null, null, ''); |
| | | insert into sys_menu values('1622', '配置编辑', '118', '6', '#', '', '', '1', '0', 'F', '0', '0', 'system:ossConfig:edit', '#', 103, 1, now(), null, null, ''); |
| | | insert into sys_menu values('1623', '配置删除', '118', '6', '#', '', '', '1', '0', 'F', '0', '0', 'system:ossConfig:remove', '#', 103, 1, now(), null, null, ''); |
| | | -- 租户管理相关按钮 |
| | | insert into sys_menu values('1606', '租户查询', '121', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:tenant:query', '#', 103, 1, now(), null, null, ''); |
| | | insert into sys_menu values('1607', '租户新增', '121', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:tenant:add', '#', 103, 1, now(), null, null, ''); |
| | |
| | | info_id int8, |
| | | tenant_id varchar(20) default '000000'::varchar, |
| | | user_name varchar(50) default ''::varchar, |
| | | client_key varchar(32) default ''::varchar, |
| | | device_type varchar(32) default ''::varchar, |
| | | ipaddr varchar(128) default ''::varchar, |
| | | login_location varchar(255) default ''::varchar, |
| | | browser varchar(50) default ''::varchar, |
| | |
| | | comment on column sys_logininfor.info_id is '访问ID'; |
| | | comment on column sys_logininfor.tenant_id is '租户编号'; |
| | | comment on column sys_logininfor.user_name is '用户账号'; |
| | | comment on column sys_logininfor.client_key is '客户端'; |
| | | comment on column sys_logininfor.device_type is '设备类型'; |
| | | comment on column sys_logininfor.ipaddr is '登录IP地址'; |
| | | comment on column sys_logininfor.login_location is '登录地点'; |
| | | comment on column sys_logininfor.browser is '浏览器类型'; |