From cd5a704fc1629d5f606535b3756195fb311b5ef2 Mon Sep 17 00:00:00 2001 From: Roc13x Date: Wed, 18 Apr 2018 16:41:23 +0100 Subject: Core/Items: Implemented ItemLimitCategoryCondition.db2 (#21835) --- sql/updates/hotfixes/master/2018_04_18_00_hotfixes.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/hotfixes/master/2018_04_18_00_hotfixes.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/master/2018_04_18_00_hotfixes.sql b/sql/updates/hotfixes/master/2018_04_18_00_hotfixes.sql new file mode 100644 index 00000000000..669723989bb --- /dev/null +++ b/sql/updates/hotfixes/master/2018_04_18_00_hotfixes.sql @@ -0,0 +1,12 @@ +-- +-- Table structure for table `item_limit_category_condition` +-- +DROP TABLE IF EXISTS `item_limit_category_condition`; +CREATE TABLE `item_limit_category_condition` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `AddQuantity` tinyint(3) NOT NULL DEFAULT '0', + `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0', + `ParentItemLimitCategoryID` int(10) NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3