| | |
|---|
| | | insert into sys_menu values('2', '系统监控', '0', '3', 'monitor', null, '', '1', '0', 'M', '0', '0', '', 'monitor', 103, 1, now(), null, null, '系统监控目录'); |
|---|
| | | insert into sys_menu values('3', '系统工具', '0', '4', 'tool', null, '', '1', '0', 'M', '0', '0', '', 'tool', 103, 1, now(), null, null, '系统工具目录'); |
|---|
| | | insert into sys_menu values('4', 'PLUS官网', '0', '5', 'https://gitee.com/dromara/RuoYi-Vue-Plus', null, '', '0', '0', 'M', '0', '0', '', 'guide', 103, 1, now(), null, null, 'RuoYi-Vue-Plus官网地址'); |
|---|
| | | insert into sys_menu VALUES('5', '测试菜单', '0', '5', 'demo', null, '1', '0', 'M', '0', '0', null, 'star', 103, 1, now(), null, null, '测试菜单'); |
|---|
| | | insert into sys_menu VALUES('5', '测试菜单', '0', '5', 'demo', null, '', '1', '0', 'M', '0', '0', null, 'star', 103, 1, now(), null, null, '测试菜单'); |
|---|
| | | -- 二级菜单 |
|---|
| | | insert into sys_menu values('100', '用户管理', '1', '1', 'user', 'system/user/index', '', '1', '0', 'C', '0', '0', 'system:user:list', 'user', 103, 1, now(), null, null, '用户管理菜单'); |
|---|
| | | insert into sys_menu values('101', '角色管理', '1', '2', 'role', 'system/role/index', '', '1', '0', 'C', '0', '0', 'system:role:list', 'peoples', 103, 1, now(), 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, 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, '文件管理菜单'); |
|---|
| | | -- 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控制台菜单'); |
|---|
| | | -- snail-job server控制台 |
|---|
| | | insert into sys_menu values('120', '任务调度中心', '2', '6', 'snailjob', 'monitor/snailjob/index', '', '1', '0', 'C', '0', '0', 'monitor:snailjob:list', 'job', 103, 1, now(), 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, now(), null, null, '操作日志菜单'); |
|---|
| | |
|---|
| | | -- 测试菜单 |
|---|
| | | INSERT INTO sys_menu VALUES('1500', '测试单表', '5', '1', 'demo', 'demo/demo/index', '', '1', '0', 'C', '0', '0', 'demo:demo:list', '#', 103, 1, now(), NULL, NULL, '测试单表菜单'); |
|---|
| | | INSERT INTO sys_menu VALUES('1501', '测试单表查询', '1500', '1', '#', '', '', '1', '0', 'F', '0', '0', 'demo:demo:query', '#', 103, 1, now(), NULL, NULL, ''); |
|---|
| | | INSERT INTO sys_menu VALUES('1502', '测试单表新增', '1500', '2,' '#', '', '', '1', '0', 'F', '0', '0', 'demo:demo:add', '#', 103, 1, now(), NULL, NULL, ''); |
|---|
| | | INSERT INTO sys_menu VALUES('1503', '测试单表修改', '1500', '3', '#', '', '', '1', '0,' 'F', '0', '0', 'demo:demo:edit', '#', 103, 1, now(), NULL, NULL, ''); |
|---|
| | | INSERT INTO sys_menu VALUES('1502', '测试单表新增', '1500', '2', '#', '', '', '1', '0', 'F', '0', '0', 'demo:demo:add', '#', 103, 1, now(), NULL, NULL, ''); |
|---|
| | | INSERT INTO sys_menu VALUES('1503', '测试单表修改', '1500', '3', '#', '', '', '1', '0', 'F', '0', '0', 'demo:demo:edit', '#', 103, 1, now(), NULL, NULL, ''); |
|---|
| | | INSERT INTO sys_menu VALUES('1504', '测试单表删除', '1500', '4', '#', '', '', '1', '0', 'F', '0', '0', 'demo:demo:remove', '#', 103, 1, now(), NULL, NULL, ''); |
|---|
| | | INSERT INTO sys_menu VALUES('1505', '测试单表导出', '1500', '5', '#', '', '', '1', '0', 'F', '0', '0', 'demo:demo:export', '#', 103, 1, now(), NULL, NULL, ''); |
|---|
| | | INSERT INTO sys_menu VALUES('1506', '测试树表', '5', '1', 'tree', 'demo/tree/index', '', '1', '0', 'C', '0', '0', 'demo:tree:list', '#', 103, 1, now(), NULL, NULL, '测试树表菜单'); |
|---|
| | |
|---|
| | | ); |
|---|
| | | |
|---|
| | | 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'; |
|---|
| | |
|---|
| | | ); |
|---|
| | | |
|---|
| | | 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 '客户端秘钥'; |
|---|
| | |
|---|
| | | test_key varchar(255), |
|---|
| | | value varchar(255), |
|---|
| | | version int4 default 0, |
|---|
| | | create_time timestamp, |
|---|
| | | create_dept int8, |
|---|
| | | create_time timestamp, |
|---|
| | | create_by int8, |
|---|
| | | update_time timestamp, |
|---|
| | | update_by int8, |
|---|
| | |
|---|
| | | user_id int8, |
|---|
| | | tree_name varchar(255), |
|---|
| | | version int4 default 0, |
|---|
| | | create_time timestamp, |
|---|
| | | create_dept int8, |
|---|
| | | create_time timestamp, |
|---|
| | | create_by int8, |
|---|
| | | update_time timestamp, |
|---|
| | | update_by int8, |
|---|
