From 74926cf1787fa4d6fc424cbc05023a46f464c711 Mon Sep 17 00:00:00 2001 From: ccrs Date: Wed, 24 Jul 2019 23:56:44 +0200 Subject: Core/Totem: 915f8a9 followup --- sql/updates/world/3.3.5/2019_07_24_01_world.sql | 34 +++++++++++++++++++++++++ sql/updates/world/3.3.5/2019_XX_XX_00_world.sql | 34 ------------------------- 2 files changed, 34 insertions(+), 34 deletions(-) create mode 100644 sql/updates/world/3.3.5/2019_07_24_01_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_XX_XX_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2019_07_24_01_world.sql b/sql/updates/world/3.3.5/2019_07_24_01_world.sql new file mode 100644 index 00000000000..125b9bc21ad --- /dev/null +++ b/sql/updates/world/3.3.5/2019_07_24_01_world.sql @@ -0,0 +1,34 @@ +DROP TABLE IF EXISTS `player_totem_model`; +CREATE TABLE `player_totem_model` ( + `TotemSlot` TINYINT(3) UNSIGNED NOT NULL, + `RaceId` TINYINT(3) UNSIGNED NOT NULL, + `DisplayId` INT(10) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`TotemSlot`,`RaceID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +INSERT INTO `player_totem_model` (`TotemSlot`, `RaceId`, `DisplayId`) VALUES +-- Orc +(1, 2, 30758), +(2, 2, 30757), +(3, 2, 30759), +(4, 2, 30756), +-- Dwarf +(1, 3, 30754), +(2, 3, 30753), +(3, 3, 30755), +(4, 3, 30736), +-- Tauren +(1, 6, 4589), +(2, 6, 4588), +(3, 6, 4587), +(4, 6, 4590), +-- Troll +(1, 8, 30762), +(2, 8, 30761), +(3, 8, 30763), +(4, 8, 30760), +-- Draenei +(1, 11, 19074), +(2, 11, 19073), +(3, 11, 19075), +(4, 11, 19071); diff --git a/sql/updates/world/3.3.5/2019_XX_XX_00_world.sql b/sql/updates/world/3.3.5/2019_XX_XX_00_world.sql deleted file mode 100644 index fc2055606a5..00000000000 --- a/sql/updates/world/3.3.5/2019_XX_XX_00_world.sql +++ /dev/null @@ -1,34 +0,0 @@ -DROP TABLE IF EXISTS `player_totem_model`; -CREATE TABLE `player_totem_model` ( - `TotemSlot` TINYINT(3) UNSIGNED NOT NULL, - `RaceId` TINYINT(3) UNSIGNED NOT NULL, - `DisplayId` INT(10) UNSIGNED NOT NULL DEFAULT '0', - PRIMARY KEY (`TotemSlot`,`RaceID`) -) ENGINE=MYISAM DEFAULT CHARSET=utf8; - -INSERT INTO `player_totem_model` (`TotemSlot`, `RaceId`, `DisplayId`) VALUES --- Orc -(1, 2, 30758), -(2, 2, 30757), -(3, 2, 30759), -(4, 2, 30756), --- Dwarf -(1, 3, 30754), -(2, 3, 30753), -(3, 3, 30755), -(4, 3, 30736), --- Tauren -(1, 6, 4589), -(2, 6, 4588), -(3, 6, 4587), -(4, 6, 4590), --- Troll -(1, 8, 30762), -(2, 8, 30761), -(3, 8, 30763), -(4, 8, 30760), --- Draenei -(1, 11, 19074), -(2, 11, 19073), -(3, 11, 19075), -(4, 11, 19071); -- cgit v1.2.3