From 0969e93d151533fa8a74bb88b04ab8ee7c4602d9 Mon Sep 17 00:00:00 2001 From: Shauren Date: Thu, 26 Mar 2020 20:09:40 +0100 Subject: Core/DataStore: Load ItemNameDescription --- .../hotfixes/master/2020_03_26_00_hotfixes.sql | 23 ++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 sql/updates/hotfixes/master/2020_03_26_00_hotfixes.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/master/2020_03_26_00_hotfixes.sql b/sql/updates/hotfixes/master/2020_03_26_00_hotfixes.sql new file mode 100644 index 00000000000..808075ed1e6 --- /dev/null +++ b/sql/updates/hotfixes/master/2020_03_26_00_hotfixes.sql @@ -0,0 +1,23 @@ +-- +-- Table structure for table `item_name_description` +-- +DROP TABLE IF EXISTS `item_name_description`; +CREATE TABLE `item_name_description` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Description` text, + `Color` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `item_name_description_locale` +-- +DROP TABLE IF EXISTS `item_name_description_locale`; +CREATE TABLE `item_name_description_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Description_lang` text, + `VerifiedBuild` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3