-- Which templates are currently active. `week_id` will hold an ISO year*100+week value once the
-- real rotation timer (PLAN.md step 2) exists; until then it's unused and every row here is just
-- "always active" for the v0.1 kill-count vertical slice.
CREATE TABLE IF NOT EXISTS `mod_bounty_board_rotation` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `template_id` INT UNSIGNED NOT NULL,
  `week_id` INT UNSIGNED NOT NULL DEFAULT 0,
  `slot_index` TINYINT UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

-- Always-active test slots, pointing at mod_bounty_board_template rows 1 (kill_count) and
-- 2 (kill_target).
DELETE FROM `mod_bounty_board_rotation` WHERE `id` IN (1, 2);
INSERT INTO `mod_bounty_board_rotation`
    (`id`, `template_id`, `week_id`, `slot_index`)
VALUES
    (1, 1, 0, 0),
    (2, 2, 0, 1);