3 files changed, 52 insertions, 0 deletions
diff --git a/sql/updates/characters/2015_03_20_00_characters.sql b/sql/updates/characters/2015_03_20_00_characters.sql
new file mode 100644
index 00000000000..05c120274da
--- /dev/null
+++ b/sql/updates/characters/2015_03_20_00_characters.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/characters/2015_03_20_01_characters.sql b/sql/updates/characters/2015_03_20_01_characters.sql
new file mode 100644
index 00000000000..69c8767e239
--- /dev/null
+++ b/sql/updates/characters/2015_03_20_01_characters.sql
@@ -0,0 +1,6 @@
+-- Characters database update data
+TRUNCATE TABLE `updates_include`;
+INSERT INTO `updates_include` (`path`, `state`) VALUES
+('$/sql/updates/characters', 'RELEASED'),
+('$/sql/custom/characters', 'RELEASED'),
+('$/sql/old/6.x/characters', 'ARCHIVED');
diff --git a/sql/updates/characters/2015_03_20_02_characters.sql b/sql/updates/characters/2015_03_20_02_characters.sql
new file mode 100644
index 00000000000..32f7ecffb26
--- /dev/null
+++ b/sql/updates/characters/2015_03_20_02_characters.sql
@@ -0,0 +1,23 @@
+INSERT IGNORE INTO `updates` (`name`, `hash`) VALUES
+('2014_10_20_00_characters.sql', 'A5882DA0979CF4DAE33DA011EBAA006C24BE7230'),
+('2014_10_23_00_characters.sql', 'E2AC4758133EE19B7F08464A445802154D1261C8'),
+('2014_10_23_01_characters.sql', '20029E6323D9773B32C34D84FFED1711CC60F09F'),
+('2014_10_23_02_characters.sql', '8A7A16886EE71E7ACDDB3DDA6D0ECAC2FD2FDCA8'),
+('2014_10_24_00_characters.sql', 'D008FE81AE844FCA686439D6ECC5108FB0DD1EB9'),
+('2014_10_25_00_characters.sql', 'A39C7BE46686B54776BDAB9D7A882D91EDEC51A4'),
+('2014_10_26_00_characters.sql', 'C787954CC35FE34B4101FDE6527F14C027F4947C'),
+('2014_11_12_00_characters.sql', 'B160BB2313F1BD5F3B076A5A9279DC10D4796E34'),
+('2014_12_23_00_characters.sql', '3D9D648B2387B357F4BD090B33F80682F7924882'),
+('2014_12_28_00_characters.sql', '5362922FF4483A336311D73082A5727309CD9219'),
+('2014_12_31_00_characters.sql', '498DDF2DD936CF156D74A8208DC93DCE9FCAB5AA'),
+('2015_01_02_00_characters.sql', 'E5940BE836F253982E07930120422E598D08BDE1'),
+('2015_01_10_00_characters.sql', '30796056C8623699B2FE1BF626A19D38262E9284'),
+('2015_01_16_00_characters.sql', '96642760A54C8D799AAFE438049A63AA521656F2'),
+('2015_01_27_00_characters.sql', 'EB710E3EB9F2CAFD84AB62CDC84E898403A80A4F'),
+('2015_02_13_00_characters.sql', '405BEB4ED207DC6076442A37EE2AFB1F21E274A0'),
+('2015_02_13_01_characters.sql', '35F582D4F33BF55D1685A1BA89273ED895FD09C5'),
+('2015_02_17_00_characters.sql', '8D21FC5A55BF8B55D6DCDCE5F02CF2B640230E94'),
+('2015_03_10_00_characters.sql', 'E565B89B145C340067742DFF2DEF1B74F5F1BD4E'),
+('2015_03_20_00_characters.sql', 'B761760804EA73BD297F296C5C1919687DF7191C'),
+('2015_03_20_01_characters.sql', '20BD68468C57FCF7E665B4DA185DCD52FACE8B3F'),
+('2015_03_20_02_characters.sql', '');