-- v0.2: adds kill_target support (position + champion flag) to an existing v0.1 install, and
-- seeds the Defias Cutpurse test bounty alongside the existing wolf one. See PLAN.md.
ALTER TABLE `mod_bounty_board_template`
    ADD COLUMN `is_champion` TINYINT UNSIGNED NOT NULL DEFAULT 0 AFTER `weight`,
    ADD COLUMN `position_map` SMALLINT UNSIGNED NOT NULL DEFAULT 0 AFTER `is_champion`,
    ADD COLUMN `position_x` FLOAT NOT NULL DEFAULT 0 AFTER `position_map`,
    ADD COLUMN `position_y` FLOAT NOT NULL DEFAULT 0 AFTER `position_x`,
    ADD COLUMN `position_z` FLOAT NOT NULL DEFAULT 0 AFTER `position_y`,
    ADD COLUMN `orientation` FLOAT NOT NULL DEFAULT 0 AFTER `position_z`;

DELETE FROM `mod_bounty_board_template` WHERE `id` = 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
    (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);

DELETE FROM `mod_bounty_board_rotation` WHERE `id` = 2;
INSERT INTO `mod_bounty_board_rotation`
    (`id`, `template_id`, `week_id`, `slot_index`)
VALUES
    (2, 2, 0, 1);
