USE `jiznksyv_vuscrocodile2026`;

ALTER TABLE `challengelevel`
  ADD COLUMN `time_limit_seconds` INT UNSIGNED NOT NULL DEFAULT 60 AFTER `sort_order`;

ALTER TABLE `playrecord`
  ADD COLUMN `elapsed_time_seconds` INT UNSIGNED NOT NULL DEFAULT 0 AFTER `total_questions`,
  ADD COLUMN `time_limit_seconds` INT UNSIGNED NOT NULL DEFAULT 0 AFTER `elapsed_time_seconds`,
  ADD COLUMN `time_exceeded` TINYINT(1) NOT NULL DEFAULT 0 AFTER `time_limit_seconds`;