
START TRANSACTION;

ALTER TABLE `bookings` ADD INDEX `status` (`status`);
ALTER TABLE `bookings_items` ADD INDEX `b_id` (`booking_id`);
ALTER TABLE `items` ADD INDEX `is_active` (`is_active`);
ALTER TABLE `packages` ADD INDEX `is_active` (`is_active`);

COMMIT;