Files
pj_service_cloud/db/1001pjcloudx_integrated.sql

80 lines
5.6 KiB
SQL

-- 该脚本不要直接执行, 注意维护菜单的父节点ID 默认 父节点-1 , 默认租户 1
--常见问题分类
-- 菜单SQL
-- 该脚本不要直接执行, 注意维护菜单的父节点ID 默认 父节点-1 , 默认租户 1
-- 菜单SQL
-- 该脚本不要直接执行, 注意维护菜单的父节点ID 默认 父节点-1 , 默认租户 1
-- 菜单SQL
insert into sys_menu ( menu_id,parent_id, path, permission, menu_type, icon, del_flag, create_time, sort_order, update_time, name, tenant_id)
values (1744015467528, '-1', '/integrated/faqCategory/index', '', '0', 'icon-bangzhushouji', '0', null , '8', null , '常见问题分类表管理', 1);
-- 菜单对应按钮SQL
insert into sys_menu ( menu_id,parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name, tenant_id)
values (1744015467529,1744015467528, 'integrated_faqCategory_view', '1', null, '1', '0', null, '0', null, '常见问题分类表查看', 1);
insert into sys_menu ( menu_id,parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name, tenant_id)
values (1744015467530,1744015467528, 'integrated_faqCategory_add', '1', null, '1', '0', null, '1', null, '常见问题分类表新增', 1);
insert into sys_menu (menu_id, parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name, tenant_id)
values (1744015467531,1744015467528, 'integrated_faqCategory_edit', '1', null, '1', '0', null, '2', null, '常见问题分类表修改', 1);
insert into sys_menu (menu_id, parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name, tenant_id)
values (1744015467532,1744015467528, 'integrated_faqCategory_del', '1', null, '1', '0', null, '3', null, '常见问题分类表删除', 1);
insert into sys_menu ( menu_id,parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name, tenant_id)
values (1744015467533,1744015467528, 'integrated_faqCategory_export', '1', null, '1', '0', null, '3', null, '导入导出', 1);
-- 该脚本不要直接执行, 注意维护菜单的父节点ID 默认 父节点-1 , 默认租户 1
-- 菜单SQL
insert into sys_menu ( menu_id,parent_id, path, permission, menu_type, icon, del_flag, create_time, sort_order, update_time, name, tenant_id)
values (1744015545424, '-1', '/integrated/faqInfo/index', '', '0', 'icon-bangzhushouji', '0', null , '8', null , '常见问题内容表管理', 1);
-- 菜单对应按钮SQL
insert into sys_menu ( menu_id,parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name, tenant_id)
values (1744015545425,1744015545424, 'integrated_faqInfo_view', '1', null, '1', '0', null, '0', null, '常见问题内容表查看', 1);
insert into sys_menu ( menu_id,parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name, tenant_id)
values (1744015545426,1744015545424, 'integrated_faqInfo_add', '1', null, '1', '0', null, '1', null, '常见问题内容表新增', 1);
insert into sys_menu (menu_id, parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name, tenant_id)
values (1744015545427,1744015545424, 'integrated_faqInfo_edit', '1', null, '1', '0', null, '2', null, '常见问题内容表修改', 1);
insert into sys_menu (menu_id, parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name, tenant_id)
values (1744015545428,1744015545424, 'integrated_faqInfo_del', '1', null, '1', '0', null, '3', null, '常见问题内容表删除', 1);
insert into sys_menu ( menu_id,parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name, tenant_id)
values (1744015545429,1744015545424, 'integrated_faqInfo_export', '1', null, '1', '0', null, '3', null, '导入导出', 1);
-- 该脚本不要直接执行, 注意维护菜单的父节点ID 默认 父节点-1 , 默认租户 1
-- 菜单SQL
insert into sys_menu ( menu_id,parent_id, path, permission, menu_type, icon, del_flag, create_time, sort_order, update_time, name, tenant_id)
values (1744183369178, '-1', '/integrated/visitors/index', '', '0', 'icon-bangzhushouji', '0', null , '8', null , '访客表管理', 1);
-- 菜单对应按钮SQL
insert into sys_menu ( menu_id,parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name, tenant_id)
values (1744183369179,1744183369178, 'integrated_visitors_view', '1', null, '1', '0', null, '0', null, '访客表查看', 1);
insert into sys_menu ( menu_id,parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name, tenant_id)
values (1744183369180,1744183369178, 'integrated_visitors_add', '1', null, '1', '0', null, '1', null, '访客表新增', 1);
insert into sys_menu (menu_id, parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name, tenant_id)
values (1744183369181,1744183369178, 'integrated_visitors_edit', '1', null, '1', '0', null, '2', null, '访客表修改', 1);
insert into sys_menu (menu_id, parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name, tenant_id)
values (1744183369182,1744183369178, 'integrated_visitors_del', '1', null, '1', '0', null, '3', null, '访客表删除', 1);
insert into sys_menu ( menu_id,parent_id, permission, menu_type, path, icon, del_flag, create_time, sort_order, update_time, name, tenant_id)
values (1744183369183,1744183369178, 'integrated_visitors_export', '1', null, '1', '0', null, '3', null, '导入导出', 1);