USE `silkhea2_jlfc`;

ALTER TABLE `competitions`
    MODIFY COLUMN `status` ENUM('draft', 'open', 'active', 'paused', 'completed', 'cancelled') NOT NULL DEFAULT 'draft';

ALTER TABLE `news_posts`
    ADD COLUMN `category` ENUM('general', 'competition_update', 'fixture_postponement', 'fixture_reschedule', 'transfer_update') NOT NULL DEFAULT 'general' AFTER `slug`;