-- SQL script to add fixed result columns to gameOver table
-- Run this in your MySQL database

ALTER TABLE `gameOver` 
ADD COLUMN `fixed_easy` INT(11) NULL DEFAULT NULL COMMENT 'Fixed result for Easy difficulty (1-24)',
ADD COLUMN `fixed_medium` INT(11) NULL DEFAULT NULL COMMENT 'Fixed result for Medium difficulty (1-24)',
ADD COLUMN `fixed_hard` INT(11) NULL DEFAULT NULL COMMENT 'Fixed result for Hard difficulty (1-24)',
ADD COLUMN `fixed_hardcore` INT(11) NULL DEFAULT NULL COMMENT 'Fixed result for Hard Core difficulty (1-24)';

-- Optional: Update existing record if it exists
UPDATE `gameOver` SET 
    `fixed_easy` = NULL,
    `fixed_medium` = NULL,
    `fixed_hard` = NULL,
    `fixed_hardcore` = NULL
WHERE `id` = 1;