USE `silkhea2_jlfc`;

ALTER TABLE `competitions`
    ADD COLUMN `group_count` INT UNSIGNED NOT NULL DEFAULT 0 AFTER `number_of_teams`,
    ADD COLUMN `qualifiers_per_group` INT UNSIGNED NOT NULL DEFAULT 0 AFTER `group_count`;

ALTER TABLE `fixtures`
    ADD COLUMN `stage_type` ENUM('league', 'group_stage', 'knockout') NOT NULL DEFAULT 'league' AFTER `matchday`,
    ADD COLUMN `group_label` VARCHAR(50) NULL AFTER `stage_type`,
    ADD COLUMN `knockout_round` VARCHAR(50) NULL AFTER `group_label`;