aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2014-12-26 01:38:40 +0100
committerShauren <shauren.trinity@gmail.com>2014-12-26 01:38:40 +0100
commit3c3b42362f19c35467e10923c521a8b93913b40d (patch)
tree1b441ec43742d5ece03d5fbbe6145fd5ba8dd13e /sql
parentdef2bfc83cadb8a78dcb9a004aab097973dd0cba (diff)
Core/DataStores: Added DB2Manager
* Moved DB2 helpers to new class * Moved hotfix data to hotfixes database and core management functions to DB2Manager class * Updated HotfixNotifyBlob packet
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/hotfixes/2014_12_26_00_hotfixes_hotfix_data.sql14
-rw-r--r--sql/updates/world/2014_12_26_00_world.sql2
2 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/2014_12_26_00_hotfixes_hotfix_data.sql b/sql/updates/hotfixes/2014_12_26_00_hotfixes_hotfix_data.sql
new file mode 100644
index 00000000000..9fc1a21ede3
--- /dev/null
+++ b/sql/updates/hotfixes/2014_12_26_00_hotfixes_hotfix_data.sql
@@ -0,0 +1,14 @@
+--
+-- Table structure for table `hotfix_data`
+--
+
+DROP TABLE IF EXISTS `hotfix_data`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `hotfix_data` (
+ `TableHash` int(10) unsigned NOT NULL DEFAULT '0',
+ `RecordID` int(10) NOT NULL,
+ `Timestamp` int(10) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`TableHash`,`RecordID`,`Timestamp`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
diff --git a/sql/updates/world/2014_12_26_00_world.sql b/sql/updates/world/2014_12_26_00_world.sql
new file mode 100644
index 00000000000..c4de6d0f326
--- /dev/null
+++ b/sql/updates/world/2014_12_26_00_world.sql
@@ -0,0 +1,2 @@
+DROP TABLE IF EXISTS `hotfix_data`;
+DROP TABLE IF EXISTS `keychain_db2`;