aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_12.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_12.sql b/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_12.sql
new file mode 100644
index 00000000000..1d9354f9d15
--- /dev/null
+++ b/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_12.sql
@@ -0,0 +1,12 @@
+--
+-- Table structure for table `item_child_equipment`
+--
+DROP TABLE IF EXISTS `item_child_equipment`;
+CREATE TABLE `item_child_equipment` (
+ `ID` int(10) unsigned NOT NULL DEFAULT '0',
+ `ItemID` int(10) unsigned NOT NULL DEFAULT '0',
+ `AltItemID` int(10) unsigned NOT NULL DEFAULT '0',
+ `AltEquipmentSlot` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;