| | |
|---|
| | | -- ---------------------------- |
|---|
| | | -- 初始化-岗位信息表数据 |
|---|
| | | -- ---------------------------- |
|---|
| | | insert into sys_post values(1, '000000', 100, 'ceo', null, '董事长', 1, '0', 103, 1, sysdate, null, null, ''); |
|---|
| | | insert into sys_post values(1, '000000', 103, 'ceo', null, '董事长', 1, '0', 103, 1, sysdate, null, null, ''); |
|---|
| | | insert into sys_post values(2, '000000', 100, 'se', null, '项目经理', 2, '0', 103, 1, sysdate, null, null, ''); |
|---|
| | | insert into sys_post values(3, '000000', 100, 'hr', null, '人力资源', 3, '0', 103, 1, sysdate, null, null, ''); |
|---|
| | | insert into sys_post values(4, '000000', 100, 'user', null, '普通员工', 4, '0', 103, 1, sysdate, null, null, ''); |
|---|
| | |
|---|
| | | insert into sys_menu values('117', 'Admin监控', '2', '5', 'Admin', 'monitor/admin/index', '', 1, 0, 'C', '0', '0', 'monitor:admin:list', 'dashboard', 103, 1, sysdate, null, null, 'Admin监控菜单'); |
|---|
| | | -- oss菜单 |
|---|
| | | insert into sys_menu values('118', '文件管理', '1', '10', 'oss', 'system/oss/index', '', 1, 0, 'C', '0', '0', 'system:oss:list', 'upload', 103, 1, sysdate, 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, sysdate, null, null, 'PowerJob控制台菜单'); |
|---|
| | | -- snail-job server控制台 |
|---|
| | | insert into sys_menu values('120', '任务调度中心', '2', '5', 'snailjob', 'monitor/snailjob/index', '', 1, 0, 'C', '0', '0', 'monitor:snailjob:list', 'job', 103, 1, sysdate, null, null, 'snailjob控制台菜单'); |
|---|
| | | |
|---|
| | | -- 三级菜单 |
|---|
| | | insert into sys_menu values('500', '操作日志', '108', '1', 'operlog', 'monitor/operlog/index', '', 1, 0, 'C', '0', '0', 'monitor:operlog:list', 'form', 103, 1, sysdate, null, null, '操作日志菜单'); |
|---|
| | |
|---|
| | | alter table sys_oss_config add constraint pk_sys_oss_config primary key (oss_config_id); |
|---|
| | | |
|---|
| | | comment on table sys_oss_config is '对象存储配置表'; |
|---|
| | | comment on column sys_oss_config.oss_config_id is '主建'; |
|---|
| | | comment on column sys_oss_config.oss_config_id is '主键'; |
|---|
| | | comment on column sys_oss_config.tenant_id is '租户编码'; |
|---|
| | | comment on column sys_oss_config.config_key is '配置key'; |
|---|
| | | comment on column sys_oss_config.access_key is 'accesskey'; |
|---|
| | |
|---|
| | | alter table sys_client add constraint pk_sys_client primary key (id); |
|---|
| | | |
|---|
| | | comment on table sys_client is '系统授权表'; |
|---|
| | | comment on column sys_client.id 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 '客户端秘钥'; |
|---|
