From f22c2c3f303ee76c76f804f94aa0a7c7b2094ce5 Mon Sep 17 00:00:00 2001 From: MitchesD Date: Sat, 4 Jul 2015 13:56:49 +0200 Subject: Core/DataStores: moved GameTables to separate method and load them from DB2 --- sql/updates/hotfixes/2015_07_04_00_hotfixes.sql | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 sql/updates/hotfixes/2015_07_04_00_hotfixes.sql (limited to 'sql/updates') diff --git a/sql/updates/hotfixes/2015_07_04_00_hotfixes.sql b/sql/updates/hotfixes/2015_07_04_00_hotfixes.sql new file mode 100644 index 00000000000..c4853061485 --- /dev/null +++ b/sql/updates/hotfixes/2015_07_04_00_hotfixes.sql @@ -0,0 +1,24 @@ +/*Table structure for table `game_tables` */ + +DROP TABLE IF EXISTS `game_tables`; + +CREATE TABLE `game_tables` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text NOT NULL, + `NumRows` int(10) unsigned NOT NULL DEFAULT '0', + `NumColumns` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) NOT NULL, + PRIMARY KEY (`ID`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +/*Table structure for table `game_tables_locale` */ + +DROP TABLE IF EXISTS `game_tables_locale`; + +CREATE TABLE `game_tables_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Name_lang` text NOT NULL, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3