-- Update portal URLs to match current running services

UPDATE portals SET url = 'http://localhost:5173', `order` = 0, show_in_user_dashboard = 0 WHERE `key` = 'admin';
UPDATE portals SET url = 'http://localhost:5174', `order` = 2, show_in_user_dashboard = 1 WHERE `key` = 'lms';
UPDATE portals SET url = 'http://localhost:5178', `order` = 1, show_in_user_dashboard = 1 WHERE `key` = 'user_portal';
UPDATE portals SET url = 'http://localhost:5182', `order` = 6, show_in_user_dashboard = 1 WHERE `key` = 'cws_admin';
UPDATE portals SET url = 'http://localhost:5179', `order` = 5, show_in_user_dashboard = 1 WHERE `key` = 'payments';
UPDATE portals SET url = 'http://localhost:5176', `order` = 3, show_in_user_dashboard = 1 WHERE `key` = 'content';
UPDATE portals SET url = 'http://localhost:5177', `order` = 4, show_in_user_dashboard = 1 WHERE `key` = 'immigopro';
UPDATE portals SET url = 'http://localhost:5180', `order` = 7, show_in_user_dashboard = 1 WHERE `key` = 'cms';