-- =============================================
-- 补齐后端 @PreAuthorize 使用、但 system_menu 中缺失的权限点（type=3 按钮）
-- 目的：非超管账号调用这些接口时不再 403；侧栏不显示（type=3）
-- 脚本可重复执行（幂等），父菜单按模块根菜单 path 定位
-- =============================================
SET NAMES utf8mb4;

INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603000,'权限点-bi:dashboard:query','bi:dashboard:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('bi','/bi') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603001,'权限点-bpm:oa-notice:query','bpm:oa-notice:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('bpm','/bpm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603002,'权限点-crm:invoice:query','crm:invoice:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('crm','/crm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603003,'权限点-crm:sale-quotation:convert-contract','crm:sale-quotation:convert-contract',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('crm','/crm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603004,'权限点-crm:sale-quotation:export','crm:sale-quotation:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('crm','/crm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603005,'权限点-crm:sale-quotation:query','crm:sale-quotation:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('crm','/crm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603006,'权限点-erp:purchase-order:import','erp:purchase-order:import',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603007,'权限点-erp:purchase-request:generate-order','erp:purchase-request:generate-order',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603008,'权限点-erp:purchase-request:query','erp:purchase-request:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603009,'权限点-erp:purchase-request:submit','erp:purchase-request:submit',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603010,'权限点-erp:sale-order:cancel','erp:sale-order:cancel',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603011,'权限点-erp:sale-order:enable','erp:sale-order:enable',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603012,'权限点-erp:sale-order:import','erp:sale-order:import',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603013,'权限点-erp:supplier:create','erp:supplier:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603014,'权限点-erp:supplier:delete','erp:supplier:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603015,'权限点-erp:supplier:export','erp:supplier:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603016,'权限点-erp:supplier:query','erp:supplier:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603017,'权限点-erp:supplier:update','erp:supplier:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603018,'权限点-mdm:brand:create','mdm:brand:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603019,'权限点-mdm:brand:delete','mdm:brand:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603020,'权限点-mdm:brand:query','mdm:brand:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603021,'权限点-mdm:brand:update','mdm:brand:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603022,'权限点-mdm:item-category:create','mdm:item-category:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603023,'权限点-mdm:item-category:delete','mdm:item-category:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603024,'权限点-mdm:item-category:query','mdm:item-category:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603025,'权限点-mdm:item-category:update','mdm:item-category:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603026,'权限点-mdm:unit:export','mdm:unit:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603027,'权限点-mdm:unit:import','mdm:unit:import',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603028,'权限点-mdm:warehouse:create','mdm:warehouse:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603029,'权限点-mdm:warehouse:delete','mdm:warehouse:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603030,'权限点-mdm:warehouse:query','mdm:warehouse:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603031,'权限点-mdm:warehouse:update','mdm:warehouse:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603032,'权限点-member:config:query','member:config:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603033,'权限点-member:config:save','member:config:save',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603034,'权限点-member:experience-record:query','member:experience-record:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603035,'权限点-member:group:create','member:group:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603036,'权限点-member:group:delete','member:group:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603037,'权限点-member:group:query','member:group:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603038,'权限点-member:group:update','member:group:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603039,'权限点-member:level:create','member:level:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603040,'权限点-member:level:delete','member:level:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603041,'权限点-member:level:query','member:level:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603042,'权限点-member:level:update','member:level:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603043,'权限点-member:level-record:query','member:level-record:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603044,'权限点-member:tag:create','member:tag:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603045,'权限点-member:tag:delete','member:tag:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603046,'权限点-member:tag:query','member:tag:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603047,'权限点-member:tag:update','member:tag:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603048,'权限点-member:user:query','member:user:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603049,'权限点-member:user:update','member:user:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603050,'权限点-member:user:update-level','member:user:update-level',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603051,'权限点-member:user:update-point','member:user:update-point',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603052,'权限点-mes:dv-metering:import','mes:dv-metering:import',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603053,'权限点-mes:md-unit-measure:create','mes:md-unit-measure:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603054,'权限点-mes:md-unit-measure:delete','mes:md-unit-measure:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603055,'权限点-mes:md-unit-measure:export','mes:md-unit-measure:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603056,'权限点-mes:md-unit-measure:query','mes:md-unit-measure:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603057,'权限点-mes:md-unit-measure:update','mes:md-unit-measure:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603058,'权限点-mes:md-workshop:export','mes:md-workshop:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603059,'权限点-mes:pd-archive:create','mes:pd-archive:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603060,'权限点-mes:pd-document:create','mes:pd-document:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603061,'权限点-mes:pd-document:delete','mes:pd-document:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603062,'权限点-mes:pd-document:export','mes:pd-document:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603063,'权限点-mes:pd-document:query','mes:pd-document:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603064,'权限点-mes:pd-document:update','mes:pd-document:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603065,'权限点-mes:pd-document-audit:create','mes:pd-document-audit:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603066,'权限点-mes:pd-document-audit:delete','mes:pd-document-audit:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603067,'权限点-mes:pd-document-audit:export','mes:pd-document-audit:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603068,'权限点-mes:pd-document-audit:query','mes:pd-document-audit:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603069,'权限点-mes:pd-document-audit:update','mes:pd-document-audit:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603070,'权限点-mes:pd-process-param:create','mes:pd-process-param:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603071,'权限点-mes:pd-process-param:delete','mes:pd-process-param:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603072,'权限点-mes:pd-process-param:export','mes:pd-process-param:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603073,'权限点-mes:pd-process-param:query','mes:pd-process-param:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603074,'权限点-mes:pd-process-param:update','mes:pd-process-param:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603075,'权限点-mes:pd-process-param-template:create','mes:pd-process-param-template:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603076,'权限点-mes:pd-process-param-template:delete','mes:pd-process-param-template:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603077,'权限点-mes:pd-process-param-template:export','mes:pd-process-param-template:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603078,'权限点-mes:pd-process-param-template:query','mes:pd-process-param-template:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603079,'权限点-mes:pd-process-param-template:update','mes:pd-process-param-template:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603080,'权限点-mes:pro-mps:query','mes:pro-mps:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603081,'权限点-mes:pro-task-issue:create','mes:pro-task-issue:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603082,'权限点-mes:pro-task-issue:delete','mes:pro-task-issue:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603083,'权限点-mes:pro-task-issue:query','mes:pro-task-issue:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603084,'权限点-mes:pro-task-issue:update','mes:pro-task-issue:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603085,'权限点-mes:qc:update','mes:qc:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603086,'权限点-mes:qc-ipqc:finish','mes:qc-ipqc:finish',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603087,'权限点-mes:qc-iqc:finish','mes:qc-iqc:finish',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603088,'权限点-mes:qc-oqc:finish','mes:qc-oqc:finish',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603089,'权限点-mes:qc-rqc:finish','mes:qc-rqc:finish',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603090,'权限点-mes:wm-material-stock:import','mes:wm-material-stock:import',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603091,'权限点-mes:wm-outsource-issue:finish','mes:wm-outsource-issue:finish',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603092,'权限点-mes:wm-product-produce:query','mes:wm-product-produce:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603093,'权限点-mes:wm-return-vendor:finish','mes:wm-return-vendor:finish',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603094,'权限点-mes:wm-stock-taking-task:finish','mes:wm-stock-taking-task:finish',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603095,'权限点-point:record:query','point:record:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('point','/point') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603096,'权限点-point:sign-in-config:create','point:sign-in-config:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('point','/point') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603097,'权限点-point:sign-in-config:delete','point:sign-in-config:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('point','/point') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603098,'权限点-point:sign-in-config:query','point:sign-in-config:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('point','/point') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603099,'权限点-point:sign-in-config:update','point:sign-in-config:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('point','/point') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603100,'权限点-point:sign-in-record:query','point:sign-in-record:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('point','/point') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603101,'权限点-srm:supplier-contact:create','srm:supplier-contact:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('srm','/srm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603102,'权限点-srm:supplier-contact:delete','srm:supplier-contact:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('srm','/srm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603103,'权限点-srm:supplier-contact:query','srm:supplier-contact:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('srm','/srm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603104,'权限点-srm:supplier-contact:update','srm:supplier-contact:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('srm','/srm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603105,'权限点-srm:tender-config:query','srm:tender-config:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('srm','/srm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603106,'权限点-srm:tender-config:update','srm:tender-config:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('srm','/srm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603107,'权限点-trade:domestic-order:cancel','trade:domestic-order:cancel',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603108,'权限点-trade:domestic-order:complete','trade:domestic-order:complete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603109,'权限点-trade:domestic-order:create','trade:domestic-order:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603110,'权限点-trade:domestic-order:delete','trade:domestic-order:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603111,'权限点-trade:domestic-order:export','trade:domestic-order:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603112,'权限点-trade:domestic-order:outbound','trade:domestic-order:outbound',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603113,'权限点-trade:domestic-order:query','trade:domestic-order:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603114,'权限点-trade:domestic-order:submit','trade:domestic-order:submit',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603115,'权限点-trade:domestic-order:update','trade:domestic-order:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603116,'权限点-trade:foreign-order:complete','trade:foreign-order:complete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603117,'权限点-trade:foreign-order:create','trade:foreign-order:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603118,'权限点-trade:foreign-order:delete','trade:foreign-order:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603119,'权限点-trade:foreign-order:export','trade:foreign-order:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603120,'权限点-trade:foreign-order:outbound','trade:foreign-order:outbound',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603121,'权限点-trade:foreign-order:query','trade:foreign-order:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603122,'权限点-trade:foreign-order:receive','trade:foreign-order:receive',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603123,'权限点-trade:foreign-order:submit','trade:foreign-order:submit',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603124,'权限点-trade:foreign-order:update','trade:foreign-order:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603125,'权限点-trade:port-batch:create','trade:port-batch:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603126,'权限点-trade:port-batch:delete','trade:port-batch:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603127,'权限点-trade:port-batch:query','trade:port-batch:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603128,'权限点-trade:port-batch:update','trade:port-batch:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';

-- 授权给所有现有角色
INSERT INTO `system_role_menu` (`role_id`,`menu_id`,`creator`,`create_time`,`updater`,`update_time`,`deleted`)
SELECT r.id, m.id, '1', NOW(), '1', NOW(), b'0'
FROM `system_role` r JOIN `system_menu` m ON m.id BETWEEN 603000 AND 603128 AND m.deleted=b'0'
WHERE r.deleted=b'0' AND NOT EXISTS (SELECT 1 FROM `system_role_menu` rm WHERE rm.role_id=r.id AND rm.menu_id=m.id AND rm.deleted=b'0');

SELECT CONCAT('已补齐权限点: ', COUNT(*)) AS result FROM `system_menu` WHERE id BETWEEN 603000 AND 603128 AND deleted=b'0';