ALTER TABLE `news_posts`
    MODIFY COLUMN `category` ENUM('general', 'competition_update', 'fixture_postponement', 'fixture_reschedule', 'transfer_update', 'match_report', 'match_update') NOT NULL DEFAULT 'general',
    ADD COLUMN IF NOT EXISTS `fixture_id` BIGINT UNSIGNED NULL AFTER `category`,
    ADD KEY `idx_news_posts_fixture_id` (`fixture_id`),
    ADD CONSTRAINT `fk_news_posts_fixture_id` FOREIGN KEY (`fixture_id`) REFERENCES `fixtures` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;