diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2019_XX_XX_00_world.sql | 34 |
1 files changed, 34 insertions, 0 deletions
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 new file mode 100644 index 00000000000..fc2055606a5 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_XX_XX_00_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=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); |
