-- Curated pool of possible bounties -- hand-written, not procedurally generated. The rotation
-- (mod_bounty_board_rotation) picks among these each week; this table is never written by the
-- server itself. See PLAN.md for the full design.
CREATE TABLE IF NOT EXISTS `mod_bounty_board_template` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` ENUM('kill_count','kill_target') NOT NULL,
  `name` VARCHAR(64) NOT NULL,
  `creature_entry` INT UNSIGNED NOT NULL,
  `count_required` SMALLINT UNSIGNED NOT NULL DEFAULT 1,
  `zone_id` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
  `min_level` TINYINT UNSIGNED NOT NULL DEFAULT 1,
  `item_reward` INT UNSIGNED NOT NULL DEFAULT 0,
  `item_reward_count` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
  `money_reward` INT UNSIGNED NOT NULL DEFAULT 0,
  `weight` SMALLINT UNSIGNED NOT NULL DEFAULT 1,
  `is_champion` TINYINT UNSIGNED NOT NULL DEFAULT 0,
  `position_map` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
  `position_x` FLOAT NOT NULL DEFAULT 0,
  `position_y` FLOAT NOT NULL DEFAULT 0,
  `position_z` FLOAT NOT NULL DEFAULT 0,
  `orientation` FLOAT NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

-- Test bounties (no rotation timer yet -- see mod_bounty_board_rotation.sql). Both are always
-- active until the weekly rotation WorldScript exists.
--
-- id 1: kill_count, v0.1. Ragged Young Wolf (705) is a plain level-1 Elwynn Forest mob, picked
-- for easy in-game testing rather than as real content.
--
-- id 2: kill_target, v0.2. Defias Cutpurse (94, level 5-6) fits the "Wanted Board" bounty fantasy
-- and is placed a few yards from the wolf test spot for convenient side-by-side testing.
-- position_map/x/y/z/orientation are only meaningful for kill_target rows -- ignored for
-- kill_count.
DELETE FROM `mod_bounty_board_template` WHERE `id` IN (1, 2);
INSERT INTO `mod_bounty_board_template`
    (`id`, `type`, `name`, `creature_entry`, `count_required`, `zone_id`, `min_level`,
     `item_reward`, `item_reward_count`, `money_reward`, `weight`, `is_champion`,
     `position_map`, `position_x`, `position_y`, `position_z`, `orientation`)
VALUES
    (1, 'kill_count', 'Wolf Culling: Ragged Young Wolves', 705, 5, 12, 1, 0, 0, 1000, 1, 0,
     0, 0, 0, 0, 0),
    (2, 'kill_target', 'Wanted: A Defias Cutpurse', 94, 1, 12, 5, 0, 0, 2500, 1, 0,
     0, -6195.0, 205.0, 398.799, 0.0);