ALTER TABLE `banners`
  ADD COLUMN `placement` enum('court','restaurant') NOT NULL DEFAULT 'court'
  AFTER `restaurant_id`;

ALTER TABLE `banners`
  DROP INDEX `IDX_banners_public_order`,
  DROP INDEX `IDX_banners_restaurant`,
  ADD KEY `IDX_banners_public_order`
    (`food_court_id`, `placement`, `is_active`, `sort_order`),
  ADD KEY `IDX_banners_restaurant`
    (`restaurant_id`, `placement`, `is_active`, `sort_order`);
