
-- Performance Optimization Migration

ALTER TABLE `rdps` ADD INDEX `idx_rdp_ip` (`ip_address`);

ALTER TABLE `browsers` ADD INDEX `idx_browser_rdp` (`rdp_id`);

ALTER TABLE `email_accounts` ADD INDEX `idx_email_browser` (`browser_id`);

ALTER TABLE `consoles` ADD INDEX `idx_console_email` (`email_id`);
ALTER TABLE `consoles` ADD INDEX `idx_console_status` (`status`);
ALTER TABLE `consoles` ADD INDEX `idx_console_check_at` (`last_check_at`);

ALTER TABLE `apps` ADD INDEX `idx_app_console` (`console_id`);
ALTER TABLE `apps` ADD INDEX `idx_app_status` (`status`);

ALTER TABLE `activity_logs` ADD INDEX `idx_log_admin` (`admin_id`);
ALTER TABLE `activity_logs` ADD INDEX `idx_log_created` (`created_at`);
