USE `silkhea2_jlfc`;

ALTER TABLE `seasons`
    MODIFY COLUMN `status` ENUM('upcoming', 'active', 'paused', 'completed', 'cancelled') NOT NULL DEFAULT 'upcoming',
    ADD COLUMN `paused_at` TIMESTAMP NULL DEFAULT NULL AFTER `status`;

ALTER TABLE `fixtures`
    ADD COLUMN `postponement_reason` TEXT NULL AFTER `status`,
    ADD COLUMN `postponed_at` TIMESTAMP NULL DEFAULT NULL AFTER `postponement_reason`,
    ADD COLUMN `rescheduled_from_date` DATE NULL AFTER `postponed_at`,
    ADD COLUMN `rescheduled_from_time` TIME NULL AFTER `rescheduled_from_date`;