| | |
|---|
| | | 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监控菜单'); |
|---|
| | | -- oss菜单 |
|---|
| | | 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, '文件管理菜单'); |
|---|
| | | -- xxl-job-admin控制台 |
|---|
| | | insert into sys_menu values('120', '任务调度中心', '2', '5', 'XxlJob', 'monitor/xxljob/index', '', '1', '0', 'C', '0', '0', 'monitor:xxljob:list', 'job', 103, 1, now(), null, null, 'Xxl-Job控制台菜单'); |
|---|
| | | -- 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控制台菜单'); |
|---|
| | | |
|---|
| | | -- 三级菜单 |
|---|
| | | 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, '操作日志菜单'); |
|---|
| | |
|---|
| | | constraint sys_oper_log_pk primary key (oper_id) |
|---|
| | | ); |
|---|
| | | |
|---|
| | | create unique index idx_sys_oper_log_bt ON sys_oper_log (business_type); |
|---|
| | | create unique index idx_sys_oper_log_s ON sys_oper_log (status); |
|---|
| | | create unique index idx_sys_oper_log_ot ON sys_oper_log (oper_time); |
|---|
| | | create index idx_sys_oper_log_bt ON sys_oper_log (business_type); |
|---|
| | | create index idx_sys_oper_log_s ON sys_oper_log (status); |
|---|
| | | create index idx_sys_oper_log_ot ON sys_oper_log (oper_time); |
|---|
| | | |
|---|
| | | comment on table sys_oper_log is '操作日志记录'; |
|---|
| | | comment on column sys_oper_log.oper_id is '日志主键'; |
|---|
| | |
|---|
| | | constraint sys_logininfor_pk primary key (info_id) |
|---|
| | | ); |
|---|
| | | |
|---|
| | | create unique index idx_sys_logininfor_s ON sys_logininfor (status); |
|---|
| | | create unique index idx_sys_logininfor_lt ON sys_logininfor (login_time); |
|---|
| | | create index idx_sys_logininfor_s ON sys_logininfor (status); |
|---|
| | | create index idx_sys_logininfor_lt ON sys_logininfor (login_time); |
|---|
| | | |
|---|
| | | comment on table sys_logininfor is '系统访问记录'; |
|---|
| | | comment on column sys_logininfor.info_id is '访问ID'; |
|---|
| | |
|---|
| | | create table if not exists gen_table |
|---|
| | | ( |
|---|
| | | table_id int8, |
|---|
| | | data_name varchar(200) default ''::varchar, |
|---|
| | | table_name varchar(200) default ''::varchar, |
|---|
| | | table_comment varchar(500) default ''::varchar, |
|---|
| | | sub_table_name varchar(64) default ''::varchar, |
|---|
| | |
|---|
| | | |
|---|
| | | comment on table gen_table is '代码生成业务表'; |
|---|
| | | comment on column gen_table.table_id is '编号'; |
|---|
| | | comment on column gen_table.data_name is '数据源名称'; |
|---|
| | | comment on column gen_table.table_name is '表名称'; |
|---|
| | | comment on column gen_table.table_comment is '表描述'; |
|---|
| | | comment on column gen_table.sub_table_name is '关联子表的表名'; |
|---|
