aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2017-04-19 19:10:49 +0200
committerShauren <shauren.trinity@gmail.com>2017-04-19 19:10:49 +0200
commit6636ca8585f41aad9c984241506e63ba67d79576 (patch)
tree69ca3a3461c7d575d1a7ececf67195b673a3cdfb /sql/updates
parent15b1aaff4189df291fc28e3607ed2b0e4d297341 (diff)
Core/DataStores: Updated sending out hotfixes
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/hotfixes/master/2017_04_19_01_hotfixes.sql8
-rw-r--r--sql/updates/world/master/2017_04_19_01_world.sql1
2 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/master/2017_04_19_01_hotfixes.sql b/sql/updates/hotfixes/master/2017_04_19_01_hotfixes.sql
new file mode 100644
index 00000000000..373a04d0ba4
--- /dev/null
+++ b/sql/updates/hotfixes/master/2017_04_19_01_hotfixes.sql
@@ -0,0 +1,8 @@
+DROP TABLE IF EXISTS `hotfix_data`;
+CREATE TABLE `hotfix_data` (
+ `Id` int(11) NOT NULL,
+ `TableHash` int(10) unsigned NOT NULL,
+ `RecordId` int(11) NOT NULL,
+ `Deleted` tinyint(3) unsigned NULL DEFAULT '0',
+ PRIMARY KEY (`Id`, `TableHash`, `RecordId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
diff --git a/sql/updates/world/master/2017_04_19_01_world.sql b/sql/updates/world/master/2017_04_19_01_world.sql
new file mode 100644
index 00000000000..7aeddee48a9
--- /dev/null
+++ b/sql/updates/world/master/2017_04_19_01_world.sql
@@ -0,0 +1 @@
+ALTER TABLE `version` ADD `hotfix_cache_id` int(11) NOT NULL DEFAULT '0';