From 64de4b38ef5eddb14d9d456740fee62595c89e06 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 16 Jul 2016 13:52:12 +0200 Subject: Core/Items: Implemented child equipment --- sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_12.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_12.sql (limited to 'sql') 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; -- cgit v1.2.3