-- Per-character progress against an active rotation slot. No seed data -- populated by the
-- server as players land kills.
CREATE TABLE IF NOT EXISTS `mod_bounty_board_progress` (
  `guid` INT UNSIGNED NOT NULL,
  `rotation_id` INT UNSIGNED NOT NULL,
  `kill_count` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
  `completed` TINYINT UNSIGNED NOT NULL DEFAULT 0,
  `turned_in` TINYINT UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`guid`, `rotation_id`)
) ENGINE=InnoDB;