-- Add featured yachts support (home page "Featured" section).
-- Run once on existing databases: mysql -u root -p dxb-yachts < backend/sql/featured_yachts_migration.sql

ALTER TABLE `yachts`
  ADD COLUMN `is_featured` tinyint(1) NOT NULL DEFAULT 0 AFTER `sort_order`,
  ADD COLUMN `featured_sort_order` int NOT NULL DEFAULT 0 AFTER `is_featured`,
  ADD KEY `is_featured` (`is_featured`);
