From c1d865f09bacc06cb78ed3404e8a2d20f9d907b5 Mon Sep 17 00:00:00 2001 From: joschiwald Date: Sun, 15 Apr 2018 21:25:24 +0200 Subject: Core/DataStores: Implemented RewardPackXCurrencyType.db2 --- sql/updates/hotfixes/master/2018_04_15_00_hotfixes.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/hotfixes/master/2018_04_15_00_hotfixes.sql (limited to 'sql/updates') diff --git a/sql/updates/hotfixes/master/2018_04_15_00_hotfixes.sql b/sql/updates/hotfixes/master/2018_04_15_00_hotfixes.sql new file mode 100644 index 00000000000..1fb655438a2 --- /dev/null +++ b/sql/updates/hotfixes/master/2018_04_15_00_hotfixes.sql @@ -0,0 +1,12 @@ +-- +-- Table structure for table `reward_pack_x_currency_type` +-- +DROP TABLE IF EXISTS `reward_pack_x_currency_type`; +CREATE TABLE `reward_pack_x_currency_type` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `CurrencyTypeID` int(10) unsigned NOT NULL DEFAULT '0', + `Quantity` int(11) NOT NULL DEFAULT '0', + `RewardPackID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3