ylrz_saas_his_scrm/sql/lobster_dynamic_node_menu_all.sql

-- 3008 动态节点审批，4 表 × 22 库同步
-- ======== 租户库 sys_menu ========
INSERT IGNORE INTO sys_menu
(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, icon, create_by, create_time, update_by, update_time, remark)
VALUES
(3008, '动态节点审批', 2994, 8, 'lobster-dynamic-impl', 'lobster/dynamic-impl/index', '1', '0', 'C', '0', '0', 'connection', 'admin', NOW(), 'admin', NOW(), '龙虾动态节点学习产物审批');

-- ======== 租户库 company_menu ========
INSERT IGNORE INTO company_menu
(company_id, menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, icon, create_by, create_time, update_by, update_time, remark)
SELECT NULL, 3008, '动态节点审批', 2994, 8, 'lobster-dynamic-impl', 'lobster/dynamic-impl/index', '1', '0', 'C', '0', '0', 'connection', 'admin', NOW(), 'admin', NOW(), '龙虾动态节点学习产物审批'
FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM company_menu WHERE menu_id=3008);

-- ======== 主库 tenant_sys_menu ========
INSERT IGNORE INTO tenant_sys_menu
(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, icon, create_by, create_time, update_by, update_time, remark)
VALUES
(3008, '动态节点审批', 2994, 8, 'lobster-dynamic-impl', 'lobster/dynamic-impl/index', '1', '0', 'C', '0', '0', 'connection', 'admin', NOW(), 'admin', NOW(), '龙虾动态节点学习产物审批');

-- ======== 主库 tenant_company_menu ========
INSERT IGNORE INTO tenant_company_menu
(company_id, menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, icon, create_by, create_time, update_by, update_time, remark)
SELECT NULL, 3008, '动态节点审批', 2994, 8, 'lobster-dynamic-impl', 'lobster/dynamic-impl/index', '1', '0', 'C', '0', '0', 'connection', 'admin', NOW(), 'admin', NOW(), '龙虾动态节点学习产物审批'
FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM tenant_company_menu WHERE menu_id=3008);