-- 注意：该页面对应的前台目录为views/iot文件夹下
-- 如果你想更改到其他目录，请修改sql中component字段对应的值


INSERT INTO sys_permission(id, parent_id, name, url, component, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_route, is_leaf, keep_alive, hidden, hide_tab, description, status, del_flag, rule_flag, create_by, create_time, update_by, update_time, internal_or_external) 
VALUES ('2022092802093800200', NULL, 'iot_device_access_opcua', '/iot/iotDeviceAccessOpcuaList', 'iot/IotDeviceAccessOpcuaList', NULL, NULL, 0, NULL, '1', 1.00, 0, NULL, 1, 1, 0, 0, 0, NULL, '1', 0, 0, 'admin', '2022-09-28 14:09:20', NULL, NULL, 0);

-- 权限控制sql
-- 新增
INSERT INTO sys_permission(id, parent_id, name, url, component, is_route, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_leaf, keep_alive, hidden, hide_tab, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
VALUES ('2022092802093800201', '2022092802093800200', '添加iot_device_access_opcua', NULL, NULL, 0, NULL, NULL, 2, 'com.juload.jcloudiot:iot_device_access_opcua:add', '1', NULL, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2022-09-28 14:09:20', NULL, NULL, 0, 0, '1', 0);
-- 编辑
INSERT INTO sys_permission(id, parent_id, name, url, component, is_route, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_leaf, keep_alive, hidden, hide_tab, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
VALUES ('2022092802093800202', '2022092802093800200', '编辑iot_device_access_opcua', NULL, NULL, 0, NULL, NULL, 2, 'com.juload.jcloudiot:iot_device_access_opcua:edit', '1', NULL, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2022-09-28 14:09:20', NULL, NULL, 0, 0, '1', 0);
-- 删除
INSERT INTO sys_permission(id, parent_id, name, url, component, is_route, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_leaf, keep_alive, hidden, hide_tab, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
VALUES ('2022092802093800203', '2022092802093800200', '删除iot_device_access_opcua', NULL, NULL, 0, NULL, NULL, 2, 'com.juload.jcloudiot:iot_device_access_opcua:delete', '1', NULL, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2022-09-28 14:09:20', NULL, NULL, 0, 0, '1', 0);
-- 批量删除
INSERT INTO sys_permission(id, parent_id, name, url, component, is_route, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_leaf, keep_alive, hidden, hide_tab, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
VALUES ('2022092802093800204', '2022092802093800200', '批量删除iot_device_access_opcua', NULL, NULL, 0, NULL, NULL, 2, 'com.juload.jcloudiot:iot_device_access_opcua:deleteBatch', '1', NULL, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2022-09-28 14:09:20', NULL, NULL, 0, 0, '1', 0);
-- 导出excel
INSERT INTO sys_permission(id, parent_id, name, url, component, is_route, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_leaf, keep_alive, hidden, hide_tab, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
VALUES ('2022092802093810205', '2022092802093800200', '导出excel_iot_device_access_opcua', NULL, NULL, 0, NULL, NULL, 2, 'com.juload.jcloudiot:iot_device_access_opcua:exportXls', '1', NULL, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2022-09-28 14:09:20', NULL, NULL, 0, 0, '1', 0);
-- 导入excel
INSERT INTO sys_permission(id, parent_id, name, url, component, is_route, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_leaf, keep_alive, hidden, hide_tab, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
VALUES ('2022092802093810206', '2022092802093800200', '导入excel_iot_device_access_opcua', NULL, NULL, 0, NULL, NULL, 2, 'com.juload.jcloudiot:iot_device_access_opcua:importExcel', '1', NULL, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2022-09-28 14:09:20', NULL, NULL, 0, 0, '1', 0);