3 files changed, 47 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/2015_03_20_00_hotfixes.sql b/sql/updates/hotfixes/2015_03_20_00_hotfixes.sql
new file mode 100644
index 00000000000..05c120274da
--- /dev/null
+++ b/sql/updates/hotfixes/2015_03_20_00_hotfixes.sql
@@ -0,0 +1,23 @@
+-- Updates base tables
+DROP TABLE IF EXISTS `updates`;
+CREATE TABLE `updates` (
+    `name` VARCHAR(200) NOT NULL COMMENT 'filename with extension of the update.',
+    `hash` CHAR(40) NULL DEFAULT '' COMMENT 'sha1 hash of the sql file.',
+    `state` ENUM('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.',
+    `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'timestamp when the query was applied.',
+    `speed` INT(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'time the query takes to apply in ms.',
+    PRIMARY KEY (`name`)
+)
+COMMENT='List of all applied updates in this database.'
+COLLATE='utf8_general_ci'
+ENGINE=MyISAM;
+
+DROP TABLE IF EXISTS `updates_include`;
+CREATE TABLE `updates_include` (
+    `path` VARCHAR(200) NOT NULL COMMENT 'directory to include. $ means relative to the source directory.',
+    `state` ENUM('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.',
+    PRIMARY KEY (`path`)
+)
+COMMENT='List of directories where we want to include sql updates.'
+COLLATE='utf8_general_ci'
+ENGINE=MyISAM;
diff --git a/sql/updates/hotfixes/2015_03_20_01_hotfixes.sql b/sql/updates/hotfixes/2015_03_20_01_hotfixes.sql
new file mode 100644
index 00000000000..a56bf038472
--- /dev/null
+++ b/sql/updates/hotfixes/2015_03_20_01_hotfixes.sql
@@ -0,0 +1,6 @@
+-- Hotfixes database update data
+TRUNCATE TABLE `updates_include`;
+INSERT INTO `updates_include` (`path`, `state`) VALUES
+('$/sql/updates/hotfixes', 'RELEASED'),
+('$/sql/custom/hotfixes', 'RELEASED'),
+('$/sql/old/6.x/hotfixes', 'ARCHIVED');
diff --git a/sql/updates/hotfixes/2015_03_20_02_hotfixes.sql b/sql/updates/hotfixes/2015_03_20_02_hotfixes.sql
new file mode 100644
index 00000000000..87b5da36aec
--- /dev/null
+++ b/sql/updates/hotfixes/2015_03_20_02_hotfixes.sql
@@ -0,0 +1,18 @@
+INSERT IGNORE INTO `updates` (`name`, `hash`) VALUES
+('2014_10_19_01_hotfixes_area_poi.sql', 'BEE7AD2717D833074AAB0B7E50D17312D0018DEC'),
+('2014_10_19_02_hotfixes_area_poi_state.sql', 'D70F413FF0EFFAFACF3B8A9B26D118F3D107E097'),
+('2014_10_19_03_hotfixes_creature_difficulty.sql', 'F9FD065AC1A409580AE6E3C01BF8F74E45D31205'),
+('2014_10_19_04_hotfixes_creature.sql', '0A7FD859535F648633449E5351F00257AE202838'),
+('2014_10_19_05_hotfixes_broadcast_text.sql', '0A82925C0B0BC6BB3A4E2F7DDB40A410C24FFE15'),
+('2014_10_19_06_hotfixes_broadcast_text.sql', '29982469F34CB06B6F413009DD761F361E56B3A1'),
+('2014_10_20_00_hotfixes_gameobjects.sql', 'C9DCBE4A88074273CBB64FE568DEFCD2EF27DB8A'),
+('2014_10_24_00_hotfixes_taxi_path_node.sql', 'F038CFD6E79649B6F7734F070BF2466505847E94'),
+('2014_10_24_01_hotfixes_broadcast_text.sql', 'B1CA1B188092B17418D759903E066E0E6FA27420'),
+('2014_12_25_00_hotfixes_locale_broadcast_text.sql', '7F5C494F33B216EBAD6A6C065A923CC71234A599'),
+('2014_12_26_00_hotfixes_hotfix_data.sql', 'ACED65D62DDD9D56E182C6FD6E8001A2AD605118'),
+('2015_02_22_00_hotfixes.sql', 'E15FB22A995AB26A0A0BC61EDE3D0258C394F8B3'),
+('2015_03_04_00_hotfixes.sql', '0DC68F95CE1E6E808B9B2751617384CFCFD727D6'),
+('2015_03_08_00_hotfixes.sql', '8287470D148051AFBCC7EECEAACBE87ABC65A09C'),
+('2015_03_20_00_hotfixes.sql', 'B761760804EA73BD297F296C5C1919687DF7191C'),
+('2015_03_20_01_hotfixes.sql', 'A79521F16AE82F0D7487495D0BF7A726D81F250D'),
+('2015_03_20_02_hotfixes.sql', '');