1 files changed, 33 insertions, 0 deletions
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;