From 0de1adf2812a4fa896dc5cd21314e596b44457b9 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 18 Jun 2016 23:03:16 +0200 Subject: Core/PacketIO: Updated equipment set packets and implemented saving transmog outfits (even if transmog itself isnt updated) --- .../2016_xx_xx_xx_characters_legion_07.sql | 33 ++++++++++++++++++++++ 1 file changed, 33 insertions(+) create mode 100644 sql/updates/characters/2016_xx_xx_xx_characters_legion_07.sql (limited to 'sql/updates') diff --git a/sql/updates/characters/2016_xx_xx_xx_characters_legion_07.sql b/sql/updates/characters/2016_xx_xx_xx_characters_legion_07.sql new file mode 100644 index 00000000000..96d45a97a01 --- /dev/null +++ b/sql/updates/characters/2016_xx_xx_xx_characters_legion_07.sql @@ -0,0 +1,33 @@ +DROP TABLE IF EXISTS `character_transmog_outfits`; +CREATE TABLE `character_transmog_outfits` ( + `guid` bigint(20) NOT NULL DEFAULT '0', + `setguid` bigint(20) NOT NULL AUTO_INCREMENT, + `setindex` tinyint(3) unsigned NOT NULL DEFAULT '0', + `name` varchar(128) NOT NULL, + `iconname` varchar(256) NOT NULL, + `ignore_mask` int(11) NOT NULL DEFAULT '0', + `appearance0` int(10) NOT NULL DEFAULT '0', + `appearance1` int(10) NOT NULL DEFAULT '0', + `appearance2` int(10) NOT NULL DEFAULT '0', + `appearance3` int(10) NOT NULL DEFAULT '0', + `appearance4` int(10) NOT NULL DEFAULT '0', + `appearance5` int(10) NOT NULL DEFAULT '0', + `appearance6` int(10) NOT NULL DEFAULT '0', + `appearance7` int(10) NOT NULL DEFAULT '0', + `appearance8` int(10) NOT NULL DEFAULT '0', + `appearance9` int(10) NOT NULL DEFAULT '0', + `appearance10` int(10) NOT NULL DEFAULT '0', + `appearance11` int(10) NOT NULL DEFAULT '0', + `appearance12` int(10) NOT NULL DEFAULT '0', + `appearance13` int(10) NOT NULL DEFAULT '0', + `appearance14` int(10) NOT NULL DEFAULT '0', + `appearance15` int(10) NOT NULL DEFAULT '0', + `appearance16` int(10) NOT NULL DEFAULT '0', + `appearance17` int(10) NOT NULL DEFAULT '0', + `appearance18` int(10) NOT NULL DEFAULT '0', + `mainHandEnchant` int(10) NOT NULL DEFAULT '0', + `offHandEnchant` int(10) NOT NULL DEFAULT '0', + PRIMARY KEY (`setguid`), + UNIQUE KEY `idx_set` (`guid`,`setguid`,`setindex`), + KEY `Idx_setindex` (`setindex`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- cgit v1.2.3