diff options
Diffstat (limited to 'sql')
24 files changed, 524 insertions, 18 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 6fba92991d9..d4bc9246ed2 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -622,3 +622,60 @@ UNLOCK TABLES; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2014-12-28 23:10:07 + +-- 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; + +-- Auth database update data +TRUNCATE TABLE `updates_include`; +INSERT INTO `updates_include` (`path`, `state`) VALUES +('$/sql/updates/auth', 'RELEASED'), +('$/sql/custom/auth', 'RELEASED'), +('$/sql/old/6.x/auth', 'ARCHIVED'); + +INSERT IGNORE INTO `updates` (`name`, `hash`) VALUES +('2014_10_04_00_auth.sql', 'C3BC70A6EC381474B7308F442346F1E721176BC6'), +('2014_10_19_00_auth.sql', '7472B490A4F86C9D3DA609CDD3197499CB80C87C'), +('2014_10_26_00_auth.sql', '75CC67ADE2A3B2E54FD57D6B0DCAA8FE50F4EE35'), +('2014_11_03_00_auth.sql', '5948C9F286CF0FEA8E241785C0259FF36B73BDC5'), +('2014_11_04_00_auth.sql', '3AFC68B2375C2A417DDEA94583C53AFF83DE50DF'), +('2014_11_09_00_auth.sql', 'B8DD1A7047C0FDDB80344B239343EC33BF1A0D97'), +('2014_11_10_00_auth.sql', '8FBA737A1D3FF4631A1E662A5B500A8BD304EC63'), +('2014_11_10_00_auth_from_335.sql', '0E3CB119442D09DD88E967015319BBC8DAFBBFE0'), +('2014_11_10_01_auth.sql', '327E77A1DA3546D5275AB249915DD57EDD6FDD3D'), +('2014_11_23_00_auth.sql', '0BBEB3EB3AED0FEF277A062819B6B2C00084A742'), +('2014_11_25_00_auth.sql', '4F45CDB26BDBB3EE83F1988E3D7818C5926ADC02'), +('2014_12_05_00_auth.sql', '6A7BBCEF43111C73A2D2C3CCB6911BE50DE7DD94'), +('2014_12_10_00_auth.sql', '821703A96D80F9080074852B5A46E2909C9562EA'), +('2014_12_19_00_auth.sql', '44D8E12FFF327AD07878FBDF8D9C16B6B7DCB122'), +('2014_12_20_00_auth.sql', '4DAA02AE285C02AE6C82EA2C8B97AC71990F1085'), +('2014_12_25_00_auth.sql', '61411930F482BC73FC7FD2C370C811E944F5FF92'), +('2014_12_27_00_auth.sql', 'CE2E5D2CD82E79C25294539ADED27A1429105B43'), +('2014_12_28_00_auth.sql', '0A913217610E76AFF119C27259737BBC523090E6'), +('2015_02_22_00_auth.sql', '21CCCF8B01252E16CA3D6C9E3E8DAA4C9B28ED6E'), +('2015_03_01_00_auth.sql', '911881E273207FF6182D1FDAC8C85FFAE8F1C852'), +('2015_03_10_00_auth.sql', '2CC8502C11412EFEB5C11BE166761A8754A59009'), +('2015_03_20_00_auth.sql', 'B761760804EA73BD297F296C5C1919687DF7191C'), +('2015_03_20_01_auth.sql', '5CCEDF20C8189FB1E8DF064A9F0DDC342841FBF0'), +('2015_03_20_02_auth.sql', ''); diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index b37dd5dffac..69c367a56c8 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2986,3 +2986,58 @@ UNLOCK TABLES; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2015-01-27 22:41:44 + +-- 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; + +-- 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'); + +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', ''); diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql deleted file mode 100644 index 0d5a5d2f23c..00000000000 --- a/sql/base/dev/hotfixes_database.sql +++ /dev/null @@ -1,18 +0,0 @@ --- MySQL dump 10.13 Distrib 5.6.9-rc, for Win64 (x86_64) --- --- Host: localhost Database: hotfixes --- ------------------------------------------------------ --- Server version 5.6.9-rc - -/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; -/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; -/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; -/*!40101 SET NAMES utf8 */; -/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; -/*!40103 SET TIME_ZONE='+00:00' */; -/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; -/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; -/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; - --- Dump completed on 2014-10-19 23:50:46 diff --git a/sql/base/hotfixes_database.sql b/sql/base/hotfixes_database.sql new file mode 100644 index 00000000000..61ec102c295 --- /dev/null +++ b/sql/base/hotfixes_database.sql @@ -0,0 +1,56 @@ +-- MySQL dump 10.13 Distrib 5.6.9-rc, for Win64 (x86_64) +-- +-- Host: localhost Database: hotfixes +-- ------------------------------------------------------ +-- Server version 5.6.9-rc + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; +/*!40101 SET NAMES utf8 */; +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- Dump completed on 2014-10-19 23:50:46 + +-- Workaround for the update system +-- As long as no full hotfix db exists + +-- 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; + +-- 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'); + +INSERT IGNORE INTO `updates` (`name`, `hash`) VALUES +('2015_03_20_00_hotfixes.sql', 'B761760804EA73BD297F296C5C1919687DF7191C'), +('2015_03_20_01_hotfixes.sql', 'A79521F16AE82F0D7487495D0BF7A726D81F250D'); diff --git a/sql/custom/auth/.gitignore b/sql/custom/auth/.gitignore new file mode 100644 index 00000000000..d1b811b7de5 --- /dev/null +++ b/sql/custom/auth/.gitignore @@ -0,0 +1 @@ +*.sql diff --git a/sql/custom/characters/.gitignore b/sql/custom/characters/.gitignore new file mode 100644 index 00000000000..d1b811b7de5 --- /dev/null +++ b/sql/custom/characters/.gitignore @@ -0,0 +1 @@ +*.sql diff --git a/sql/custom/hotfixes/.gitignore b/sql/custom/hotfixes/.gitignore new file mode 100644 index 00000000000..d1b811b7de5 --- /dev/null +++ b/sql/custom/hotfixes/.gitignore @@ -0,0 +1 @@ +*.sql diff --git a/sql/custom/world/.gitignore b/sql/custom/world/.gitignore new file mode 100644 index 00000000000..d1b811b7de5 --- /dev/null +++ b/sql/custom/world/.gitignore @@ -0,0 +1 @@ +*.sql diff --git a/sql/old/6.x/auth/CREATE_SUBDIRECTORIES_HERE b/sql/old/6.x/auth/CREATE_SUBDIRECTORIES_HERE new file mode 100644 index 00000000000..e69de29bb2d --- /dev/null +++ b/sql/old/6.x/auth/CREATE_SUBDIRECTORIES_HERE diff --git a/sql/old/6.x/characters/CREATE_SUBDIRECTORIES_HERE b/sql/old/6.x/characters/CREATE_SUBDIRECTORIES_HERE new file mode 100644 index 00000000000..e69de29bb2d --- /dev/null +++ b/sql/old/6.x/characters/CREATE_SUBDIRECTORIES_HERE diff --git a/sql/old/6.x/hotfixes/CREATE_SUBDIRECTORIES_HERE b/sql/old/6.x/hotfixes/CREATE_SUBDIRECTORIES_HERE new file mode 100644 index 00000000000..e69de29bb2d --- /dev/null +++ b/sql/old/6.x/hotfixes/CREATE_SUBDIRECTORIES_HERE diff --git a/sql/old/6.x/world/CREATE_SUBDIRECTORIES_HERE b/sql/old/6.x/world/CREATE_SUBDIRECTORIES_HERE new file mode 100644 index 00000000000..e69de29bb2d --- /dev/null +++ b/sql/old/6.x/world/CREATE_SUBDIRECTORIES_HERE diff --git a/sql/updates/auth/2015_03_20_00_auth.sql b/sql/updates/auth/2015_03_20_00_auth.sql new file mode 100644 index 00000000000..05c120274da --- /dev/null +++ b/sql/updates/auth/2015_03_20_00_auth.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/auth/2015_03_20_01_auth.sql b/sql/updates/auth/2015_03_20_01_auth.sql new file mode 100644 index 00000000000..ecee16a2274 --- /dev/null +++ b/sql/updates/auth/2015_03_20_01_auth.sql @@ -0,0 +1,6 @@ +-- Auth database update data +TRUNCATE TABLE `updates_include`; +INSERT INTO `updates_include` (`path`, `state`) VALUES +('$/sql/updates/auth', 'RELEASED'), +('$/sql/custom/auth', 'RELEASED'), +('$/sql/old/6.x/auth', 'ARCHIVED'); diff --git a/sql/updates/auth/2015_03_20_02_auth.sql b/sql/updates/auth/2015_03_20_02_auth.sql new file mode 100644 index 00000000000..12427489f01 --- /dev/null +++ b/sql/updates/auth/2015_03_20_02_auth.sql @@ -0,0 +1,25 @@ +INSERT IGNORE INTO `updates` (`name`, `hash`) VALUES +('2014_10_04_00_auth.sql', 'C3BC70A6EC381474B7308F442346F1E721176BC6'), +('2014_10_19_00_auth.sql', '7472B490A4F86C9D3DA609CDD3197499CB80C87C'), +('2014_10_26_00_auth.sql', '75CC67ADE2A3B2E54FD57D6B0DCAA8FE50F4EE35'), +('2014_11_03_00_auth.sql', '5948C9F286CF0FEA8E241785C0259FF36B73BDC5'), +('2014_11_04_00_auth.sql', '3AFC68B2375C2A417DDEA94583C53AFF83DE50DF'), +('2014_11_09_00_auth.sql', 'B8DD1A7047C0FDDB80344B239343EC33BF1A0D97'), +('2014_11_10_00_auth.sql', '8FBA737A1D3FF4631A1E662A5B500A8BD304EC63'), +('2014_11_10_00_auth_from_335.sql', '0E3CB119442D09DD88E967015319BBC8DAFBBFE0'), +('2014_11_10_01_auth.sql', '327E77A1DA3546D5275AB249915DD57EDD6FDD3D'), +('2014_11_23_00_auth.sql', '0BBEB3EB3AED0FEF277A062819B6B2C00084A742'), +('2014_11_25_00_auth.sql', '4F45CDB26BDBB3EE83F1988E3D7818C5926ADC02'), +('2014_12_05_00_auth.sql', '6A7BBCEF43111C73A2D2C3CCB6911BE50DE7DD94'), +('2014_12_10_00_auth.sql', '821703A96D80F9080074852B5A46E2909C9562EA'), +('2014_12_19_00_auth.sql', '44D8E12FFF327AD07878FBDF8D9C16B6B7DCB122'), +('2014_12_20_00_auth.sql', '4DAA02AE285C02AE6C82EA2C8B97AC71990F1085'), +('2014_12_25_00_auth.sql', '61411930F482BC73FC7FD2C370C811E944F5FF92'), +('2014_12_27_00_auth.sql', 'CE2E5D2CD82E79C25294539ADED27A1429105B43'), +('2014_12_28_00_auth.sql', '0A913217610E76AFF119C27259737BBC523090E6'), +('2015_02_22_00_auth.sql', '21CCCF8B01252E16CA3D6C9E3E8DAA4C9B28ED6E'), +('2015_03_01_00_auth.sql', '911881E273207FF6182D1FDAC8C85FFAE8F1C852'), +('2015_03_10_00_auth.sql', '2CC8502C11412EFEB5C11BE166761A8754A59009'), +('2015_03_20_00_auth.sql', 'B761760804EA73BD297F296C5C1919687DF7191C'), +('2015_03_20_01_auth.sql', '5CCEDF20C8189FB1E8DF064A9F0DDC342841FBF0'), +('2015_03_20_02_auth.sql', ''); 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', ''); 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', ''); diff --git a/sql/updates/world/2015_03_20_04_world.sql b/sql/updates/world/2015_03_20_04_world.sql new file mode 100644 index 00000000000..05c120274da --- /dev/null +++ b/sql/updates/world/2015_03_20_04_world.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/world/2015_03_20_05_world.sql b/sql/updates/world/2015_03_20_05_world.sql new file mode 100644 index 00000000000..018e1929c34 --- /dev/null +++ b/sql/updates/world/2015_03_20_05_world.sql @@ -0,0 +1,6 @@ +-- World database update data +TRUNCATE TABLE `updates_include`; +INSERT INTO `updates_include` (`path`, `state`) VALUES +('$/sql/updates/world', 'RELEASED'), +('$/sql/custom/world', 'RELEASED'), +('$/sql/old/6.x/world', 'ARCHIVED'); diff --git a/sql/updates/world/2015_03_20_06_world.sql b/sql/updates/world/2015_03_20_06_world.sql new file mode 100644 index 00000000000..692381573eb --- /dev/null +++ b/sql/updates/world/2015_03_20_06_world.sql @@ -0,0 +1,170 @@ +INSERT IGNORE INTO `updates` (`name`, `hash`, `state`) VALUES +('2014_10_19_00_world.sql', 'C9D12A22A30EAA0E602D5DEF7E72BF2F18BC8546', 'ARCHIVED'), +('2014_10_19_01_world.sql', '140B2E47A3B997C03CE00B29E963900643FFB820', 'ARCHIVED'), +('2014_10_19_01_world_from_335.sql', '76D19F7888A41B1B4AB4A5F366AE98057F066128', 'ARCHIVED'), +('2014_10_19_02_world.sql', '58AB6AAAFC6FED71B66DF6A8DF279DB195BD0E2F', 'ARCHIVED'), +('2014_10_20_00_world.sql', 'BD3D440770748809709C002C3DD4FFD7399E045A', 'ARCHIVED'), +('2014_10_20_00_world_from_335.sql', 'E74390D42EF46218FE189C22A2A68BC454293F30', 'ARCHIVED'), +('2014_10_21_00_world.sql', '0E29A91E897F5EF08BFD09893475B483084F9BB9', 'ARCHIVED'), +('2014_10_22_00_world.sql', '73246FCC28EFA348C2345EDB092053A3D4AE2ECF', 'ARCHIVED'), +('2014_10_22_00_world_from_335.sql', '5C5268C959A22284F6E9E05D873EA153BFBBD835', 'ARCHIVED'), +('2014_10_22_01_world.sql', 'A93FE6F9BDA6D8DDD06303B1CF2D546ABAC31B00', 'ARCHIVED'), +('2014_10_23_00_world.sql', 'C4CE350F917717F646C074294DC21DFD4A531358', 'ARCHIVED'), +('2014_10_23_01_world.sql', 'A1B8C1E18FD43AE8D1A9A0E00C91804DA5391F33', 'ARCHIVED'), +('2014_10_24_01_world_from_335.sql', '5A6EFA81F56575F85B27709944371C3E0A75D5D6', 'ARCHIVED'), +('2014_10_24_02_world.sql', '7AADECF3AB832E8E7662917E5E42E8ED0B911EF9', 'ARCHIVED'), +('2014_10_24_03_world.sql', '1A3BE9C3443254E8040700014CD0553C60079C3E', 'ARCHIVED'), +('2014_10_24_04_world.sql', '31D594C935B0BDCD85381FCE710A08724C367988', 'ARCHIVED'), +('2014_10_25_00_world.sql', '9F251D021F9F15F33D60998C50779BE25566B7DF', 'ARCHIVED'), +('2014_10_26_00_world.sql', '171319C2ACDB3DB8B93C34C8FD8AF8741CA5FBCB', 'ARCHIVED'), +('2014_10_26_01_world.sql', 'E10E2EB04D4B2C332BB5EFEFE04F54FA3471B699', 'ARCHIVED'), +('2014_10_26_02_world.sql', '61DD9CCFBE84A87433EDBACF9657C9222D5DEC21', 'ARCHIVED'), +('2014_10_26_03_world.sql', '6CD3E46FB34BB74D563E98A8F0E6C3D158651CF5', 'ARCHIVED'), +('2014_10_26_04_world.sql', '664B0B4EC3338289B6CA60EEE999D8363D4E4A58', 'ARCHIVED'), +('2014_10_26_05_world.sql', '769D4D8E652A7E30B819633AAD01154BCDA73A63', 'ARCHIVED'), +('2014_10_26_06_world_from_335.sql', 'FA22609D1B1D0B56760595FEA7445B0724A44EE6', 'ARCHIVED'), +('2014_10_27_00_world.sql', '431C68103E11C4A7579EF62DC4CD27D254C4E47A', 'ARCHIVED'), +('2014_10_27_01_world.sql', '735AD9C0307926D7CF6AC6845FF27B67650CD935', 'ARCHIVED'), +('2014_10_27_02_world.sql', '3DAEB7EC510D924B37BFAC7D8CA06B8E38D60FEA', 'ARCHIVED'), +('2014_10_28_00_world.sql', 'C59E8BCC1A58FB150B08A6D2F4003E5EC151E696', 'ARCHIVED'), +('2014_10_29_00_world.sql', 'E7A909C7DC8B50DCFC2E737909540041A89AEE11', 'ARCHIVED'), +('2014_10_29_01_world.sql', 'F478D2AE25B9C36E3456DD35884357063556AA36', 'ARCHIVED'), +('2014_10_30_00_world.sql', '46D284FE1E2847CE99FE707ECC0BDAB4C9F7EE06', 'ARCHIVED'), +('2014_10_30_01_world.sql', 'B1C5B27B6D4984F7BBB40388E92DD46FB5E8BFF0', 'ARCHIVED'), +('2014_10_30_02_world.sql', '6F0FFB389D698B8AFFA723EF55895C6CF2CBF7D3', 'ARCHIVED'), +('2014_10_31_00_world.sql', '6406626D2883AEF64DEA38E2D88A71A46915B5B6', 'ARCHIVED'), +('2014_10_31_01_world.sql', 'D397CEFFE883BB910FEDCE5EA5EDFB537FB2370A', 'ARCHIVED'), +('2014_10_31_02_world.sql', '215FB85430078FE0AFB771F34B5CEC85D6D4C22A', 'ARCHIVED'), +('2014_10_31_03_world.sql', 'A9BE071C624ABF152BAE5A97452CC505CE100D98', 'ARCHIVED'), +('2014_11_01_00_world.sql', 'D05FB5907D59AE2520A8658064A1DFC3D256256C', 'ARCHIVED'), +('2014_11_02_00_world.sql', 'AC4CBDC7BB6A51927841EF2BD98045CCD56C6AED', 'ARCHIVED'), +('2014_11_02_01_world.sql', '48DC7D245D7A7019B3333BA8F598AB566A321EE4', 'ARCHIVED'), +('2014_11_02_02_world.sql', '856AE4A3990B38A68155845C6D68F28F4B075C41', 'ARCHIVED'), +('2014_11_04_00_world.sql', '517BE655C4F39EAAA3025F843B29A0F276559FEF', 'ARCHIVED'), +('2014_11_07_00_world.sql', '16A0E153EDE2AB8C63A3BA6656AD71BB237FBCF3', 'ARCHIVED'), +('2014_11_07_01_world.sql', '5DCE2E3A55185587AD2DF83D5FB146C7A7D794A3', 'ARCHIVED'), +('2014_11_08_00_world.sql', 'B3C5B811A1C4805EDE7D11740187048A79A2369A', 'ARCHIVED'), +('2014_11_08_01_world.sql', '0C1F022696DF96302AB62B4A215FC37FAD66FA35', 'ARCHIVED'), +('2014_11_08_02_world.sql', '136936E2E16955DCD4B0EEA34AA3D22B6852A031', 'ARCHIVED'), +('2014_11_10_00_world.sql', '13B0D432ABC18E32531C1C97ECC51AA45EC506C7', 'ARCHIVED'), +('2014_11_10_01_world.sql', 'B9FFFED95D327392EA5CB264F6712BAC766C84BD', 'ARCHIVED'), +('2014_11_10_02_world.sql', 'A8830AD02DD7DF119721A979E165ED3259ED420B', 'ARCHIVED'), +('2014_11_10_03_world.sql', '8734F326B496D24871E16809D167F055B10D6F93', 'ARCHIVED'), +('2014_11_10_04_world.sql', 'F22AB772400FB35B1BFF6F58534CA681BF769281', 'ARCHIVED'), +('2014_11_10_05_world.sql', '4DC43402104F8296FA992C40916036B76F35560C', 'ARCHIVED'), +('2014_11_16_00_world.sql', 'BEBE47FC0D0E499FB6DBED310985BD9516F2935B', 'ARCHIVED'), +('2014_11_16_01_world.sql', 'C036EC4786AF8D5E01F6A681B3B9F1953FE0F5B0', 'ARCHIVED'), +('2014_11_16_02_world.sql', '4F16F69F0AAAA23C0254D4B89CA3AC3FDEC6DA03', 'ARCHIVED'), +('2014_11_16_03_world.sql', '178BA69418C7784475F36518CEE6D3C0233A3A07', 'ARCHIVED'), +('2014_11_16_04_world.sql', '0F14EE0A04BB2C3E393265082C2B7600236B2F14', 'ARCHIVED'), +('2014_11_16_05_world.sql', 'F6F0D8A12F64CAE47530F77E53B31FE9BA685CB3', 'ARCHIVED'), +('2014_11_16_06_world.sql', 'FF7C64269FD4C26EF6FB79D1EE5774E13C3C20D1', 'ARCHIVED'), +('2014_11_19_00_world.sql', '6E1D3D0451297EAE3A85903D4901E824BB4B5E50', 'ARCHIVED'), +('2014_11_19_01_world.sql', '2E545A1875301B2622B59BEF0473E90BA56EC4FD', 'ARCHIVED'), +('2014_11_20_00_world.sql', '2C0E3B63F1572F584C8E0B134FA925814ACDFE95', 'ARCHIVED'), +('2014_11_20_01_world.sql', '2FC08035F0F09783E228788781D5D492452803F7', 'ARCHIVED'), +('2014_11_20_02_world.sql', 'BF817119E9F568CDD5BEA712FA5DAABE008DA9F7', 'ARCHIVED'), +('2014_11_30_00_world.sql', 'F70897BD3E34C87320A2E3E6C72C66C6877A13FB', 'ARCHIVED'), +('2014_12_01_00_world.sql', 'B370BBB22E09C233ABB2CB3999E2BDD9A49A35A1', 'ARCHIVED'), +('2014_12_04_00_world.sql', 'C22F9C77CEF8805FFCB950BB7038D1EF12D49731', 'ARCHIVED'), +('2014_12_04_01_world.sql', 'D8353D92E679FABEE7B1F978B5394F5A18F7D40F', 'ARCHIVED'), +('2014_12_12_00_world.sql', '3E31732550055B7EB72443C30EA2ED975862215D', 'ARCHIVED'), +('2014_12_12_01_world.sql', 'D52B5EF4374EE67FE77D3C1AF004E42E1425DB10', 'ARCHIVED'), +('2014_12_12_02_world.sql', 'F0E9DDCF540B58123811993D09F61A2EFA34BC8D', 'ARCHIVED'), +('2014_12_12_03_world.sql', 'BFB07C36367BD9A198BB9CC34103EC0C401A09E8', 'ARCHIVED'), +('2014_12_13_00_world.sql', '394CF64309B1BACD7BDF1A6BF7D88DE2A335FFEE', 'ARCHIVED'), +('2014_12_15_00_world.sql', '88FF35DC8B665070E96249CA01AA079DBE995BBB', 'ARCHIVED'), +('2014_12_17_00_world.sql', '545A3022BB1D85E8FCF9BC1086D5C3864BF1F0CA', 'ARCHIVED'), +('2014_12_19_00_world.sql', 'AF594EB0D80B3DEC01686597DF369BC34D7398E8', 'ARCHIVED'), +('2014_12_19_01_world.sql', '557FF34D129C6758A1CE66AAD7A1A3516631D36D', 'ARCHIVED'), +('2014_12_21_00_world.sql', '4F07D137F7628A7DABED5FDD8EDB1B1A83086C0B', 'ARCHIVED'), +('2014_12_24_00_world.sql', 'BCD9B5C90A35CA1BA9ACCC31B053DCFDD8B714B0', 'ARCHIVED'), +('2014_12_25_00_world.sql', '925F10E1D8D69502293D2EEDE2DFC3D448D23724', 'ARCHIVED'), +('2014_12_25_01_world.sql', 'E4BB18FEC17307D04EA1E314DD36D770242C049B', 'ARCHIVED'), +('2014_12_26_00_world.sql', '0829D8347CB6BFFE08E0F5DF82F46CA071566E50', 'ARCHIVED'), +('2014_12_26_01_world.sql', 'B5FDA0031AFCB729C6079FB7D9DE81E8768A8F14', 'ARCHIVED'), +('2014_12_26_02_world.sql', 'BDC397D2FCB3E737F6520ACEDB6836C88E0B84A5', 'ARCHIVED'), +('2014_12_26_03_world.sql', '89E0C5196DA72793FFA26F259BD602066CBBC31E', 'ARCHIVED'), +('2014_12_26_04_world.sql', '58564849E75F397C8E1C744692191ADE39DFA514', 'ARCHIVED'), +('2014_12_26_05_world.sql', 'D370DC75186601FCBABB63845922B294099DA13B', 'ARCHIVED'), +('2014_12_26_06_world.sql', 'BE8F3B85AB5F89EF081B984A2E4B66B3D88BB9E9', 'ARCHIVED'), +('2014_12_26_07_world.sql', '69792C539312FB965DEA2206D129314E6B411445', 'ARCHIVED'), +('2014_12_27_00_world.sql', 'C58A8454E3D39A2021C8D82BCCB621EE992E0ACF', 'ARCHIVED'), +('2014_12_27_01_world.sql', '841BF49D1D54E7C8BBD3AAD8E233E0A592AF903E', 'ARCHIVED'), +('2014_12_27_02_world.sql', '9440E74C6E2D07B50F747895E285C5AA3D6CE3D3', 'ARCHIVED'), +('2014_12_27_03_world.sql', '4BB55FF64EDD594B0062E7056666D1E1B5A559B9', 'ARCHIVED'), +('2014_12_27_04_world.sql', '7C8BFB2FE5F58288E98C6395B1D7952BA0D923A0', 'ARCHIVED'), +('2014_12_27_05_world.sql', '7FC53862CD96381DE5C15C404FE25935E1AC603D', 'ARCHIVED'), +('2014_12_27_06_world.sql', 'EDB26E7292183B8867BD3D22941B3A21B350A18C', 'ARCHIVED'), +('2014_12_27_07_world.sql', 'B9455E80DEF0ADADE466632AC6206F43B8CF98EE', 'ARCHIVED'), +('2014_12_27_08_world.sql', '135C58B097B834FF4D195C9B13E9C462E5A12070', 'ARCHIVED'), +('2014_12_28_00_world.sql', '855E107ADD7D3078B2ED37D77BE8CDCD2E76D9E5', 'ARCHIVED'), +('2014_12_28_01_world.sql', '46ED66ED9F997555CFFF0ABF48712D4B54A015AF', 'ARCHIVED'), +('2014_12_28_02_world.sql', '8DE39EDA6246CF885B04BBE3C403A984A7947EB7', 'ARCHIVED'), +('2014_12_28_03_world.sql', '53E8B3A24AEB4467C5765FFF2B99CB646CC77319', 'ARCHIVED'), +('2014_12_28_04_world.sql', '67B7936CA2DB03E64380E61C520FE808EC900687', 'ARCHIVED'), +('2014_12_28_05_world.sql', '28542CF3F4EFCAF60E96B61740A7755CE4189FD9', 'ARCHIVED'), +('2014_12_28_06_world.sql', '277DFC82FE17489C519001A778ABE17F0FBCC605', 'ARCHIVED'), +('2014_12_28_07_world.sql', '717CF0E7F4795A972096EDFECCAAB561FBD8E987', 'ARCHIVED'), +('2014_12_29_00_world.sql', 'EF70B832664A0822CEA30EF51B4BEEDF185EC53D', 'ARCHIVED'), +('2014_12_30_00_world.sql', '468E05F2FB5B73647F77DDF375C1D10B5B5F35B1', 'ARCHIVED'), +('2015_01_10_00_world.sql', '9F93ABE80EBAA370971F61C094713CC73448DD74', 'ARCHIVED'), +('2015_01_10_01_world.sql', 'EDDA230907DE93B2E23171DBE757A8831F3EF0B3', 'ARCHIVED'), +('2015_01_10_02_world.sql', 'C6CC35B2021CA60C0BF43D3C88FCD323FF0D39F8', 'ARCHIVED'), +('2015_01_10_03_world.sql', '135690CAC7B6F786F00EBB8F5B385B815CFE9BFD', 'ARCHIVED'), +('2015_01_10_04_world.sql', 'F6098B3B1E2ED9484A15FE27E5ABE4960EFA3A28', 'ARCHIVED'), +('2015_01_10_05_world.sql', '9ADBEE777B28618822269D5D5923056D86194867', 'ARCHIVED'), +('2015_01_10_06_world.sql', 'D3CB658D8C880BF5988E31D2789DC1188AF12244', 'ARCHIVED'), +('2015_01_10_07_world.sql', '11FC9708637F44455A1EEB2D920652C11AF73204', 'ARCHIVED'), +('2015_01_11_01_world.sql', '880F9053836285B014E4F85787BB17B035ACA2BD', 'ARCHIVED'), +('2015_01_11_02_world.sql', '652501E5CC18ABAD377AF825667ACC91D07EA9AB', 'ARCHIVED'), +('2015_01_11_03_world.sql', '1D3AB865CC7C6241E43053B85B7289100F112A1E', 'ARCHIVED'), +('2015_01_12_00_world.sql', '6D97DF64ED2BA6668E1BBD20869B5D00A83AB6DC', 'ARCHIVED'), +('2015_01_15_00_world.sql', '9E1CB22E3F128A6597842DCA85E4A08C8E6A3B00', 'ARCHIVED'), +('2015_01_16_00_world.sql', '81959173F25898F3EDFC94A9BD40800B7459434D', 'ARCHIVED'), +('2015_01_18_00_world.sql', '7CA65728C59A00BECFAFC5585A79ED4B4AF5FAA3', 'ARCHIVED'), +('2015_01_30_00_world.sql', '0200615B833CB70E82C9B6D50BA6ED6F37C5A046', 'ARCHIVED'), +('2015_01_30_01_world.sql', '56DC1B47EE659D5B2C0740A3710B6BA9168C0A8D', 'ARCHIVED'), +('2015_02_02_00_world.sql', '3210E3CD12FCEE5E505D293113A0B77071FAA41B', 'ARCHIVED'), +('2015_02_02_00_world_from_335.sql', '4A7F644212D0BC1D8B4BDC7E27BA70BBBCF5C1A8', 'ARCHIVED'), +('2015_02_02_01_world.sql', '56FFF84EC62A9A8647C94B535EB6A0A2BAA4EECA', 'ARCHIVED'), +('2015_02_06_00_world.sql', '8D965E6D688C50DEB197E4B5B6D3F911264FF00B', 'ARCHIVED'), +('2015_02_08_00_world.sql', 'B64B75BC708A959CB370557949671CB75BBB87D9', 'ARCHIVED'), +('2015_02_11_00_world.sql', '50B5E9DAFC4BF3260DF78DA4D9A874728C11D589', 'ARCHIVED'), +('2015_02_12_00_world.sql', 'AA1E0BFE3C23ABAECE17E151EE9F74C86FDB32C2', 'ARCHIVED'), +('2015_02_13_00_world.sql', '4A552FFBB0218FB2E7E54429DD27F9F6B3C71DBA', 'ARCHIVED'), +('2015_02_18_00_world.sql', '9224197FD3427974D942FEBCCEDE7ABD40300E23', 'ARCHIVED'), +('2015_02_19_00_world.sql', '4E9ED1DC0DF1FD173CD15FA35A79353E08455A30', 'ARCHIVED'), +('2015_02_20_00_world.sql', '52BA5B5A6F386B852E1A115F2C39B66108314A5F', 'ARCHIVED'), +('2015_02_20_01_world.sql', '1C0C6A74212690BB07BA50524A8BB54D3AEC7708', 'ARCHIVED'), +('2015_02_20_02_world.sql', '77DE8E0108E079741E0C3CED01AB4FD60260C57A', 'ARCHIVED'), +('2015_02_22_00_world.sql', '8CC806EC21F9F194CE06DC80F0C8F5A4509EFBDA', 'ARCHIVED'), +('2015_02_22_01_world.sql', 'A2AD10247D226951FEE769F3872194F0E1D9C44A', 'ARCHIVED'), +('2015_03_07_00_world.sql', '9DA807070CA63F4342884DF65C7FE409EEEBAE49', 'ARCHIVED'), +('2015_03_07_01_world.sql', '60835178B525B1E2A842A7AB660AD7B6F0832063', 'ARCHIVED'), +('2015_03_07_02_world.sql', '3FBA2EDD2A3641A697CA71D0E0C5E716A057C13E', 'ARCHIVED'), +('2015_03_07_03_world.sql', '560D71607A4E444B5C51D7E2B333D2064AD55D75', 'ARCHIVED'), +('2015_03_10_00_world.sql', 'E9B5D25DF80B70998336A580E419AF3E78266597', 'ARCHIVED'), +('2015_03_16_00_world.sql', 'E386644A485C16DDA4EE83415808BB6C77DC1E87', 'ARCHIVED'), +('2015_03_16_01_world.sql', 'D8018D2645F6A21308F7AB2EA12F09474B5BFF46', 'ARCHIVED'), +('2015_03_16_02_world.sql', '68914E093312389F0AADEDFEF0BD190117965AC4', 'ARCHIVED'), +('2015_03_16_03_world.sql', '673267031A5450A7C010B28D99E4CCC3A90B778D', 'ARCHIVED'), +('2015_03_16_04_world.sql', '74275F00F6C5168870F7A01CEF19DD3D06572734', 'ARCHIVED'), +('2015_03_16_05_world.sql', '6E44CFA09EF45C7FA2D63F0679F2B216B620D7C7', 'ARCHIVED'), +('2015_03_16_06_world.sql', '44C2A4C393AB3E5401FBD122784E6E56B28942B6', 'ARCHIVED'), +('2015_03_16_07_world.sql', '83D3171C249FA95CB2576EABE7EB469F34DEAB2D', 'ARCHIVED'), +('2015_03_16_08_world.sql', '96C9E201D6F5F896C96A06E94228F1067C19D7CE', 'ARCHIVED'), +('2015_03_16_09_world.sql', 'AE99495134C2AA1762047853A48193E1E2B7E240', 'ARCHIVED'), +('2015_03_16_10_world.sql', '6166BEE0E14FE9F15777F041747230AF546ED99E', 'ARCHIVED'), +('2015_03_17_00_world.sql', 'F71FE9758B3AFFD80E391209A743D43B04E6F93A', 'ARCHIVED'), +('2015_03_17_02_world.sql', '6212A1CF186600907CBAE1000B9D6AF2026B6E7D', 'ARCHIVED'), +('2015_03_18_00_world.sql', '1103C059C8FE207DAC6F3E1D629852968EB6F917', 'ARCHIVED'), +('2015_03_18_01_world.sql', '3BC3E66ECFABCCDCFF43ABAFBE4381AD0ED4228A', 'ARCHIVED'), +('2015_03_19_00_world.sql', '45B0A3D93365CE324AD25C72554B13AE47356F43', 'ARCHIVED'), +('2015_03_20_00_world.sql', '8E7C56D7C5F6FC85C291BEEFCEDF036431A399E9', 'ARCHIVED'), +('2015_03_20_01_world.sql', '618093A729BC0FE4FC141AF79F702C28D370E70B', 'ARCHIVED'), +('2015_03_20_02_world.sql', 'A0FF748366FEA70998B6F9639355C67EBCA95572', 'ARCHIVED'), +('2015_03_20_03_world.sql', '062DA1A1DE0186948FD9A8958BD6D7EA8CE5507D', 'ARCHIVED'), +('2015_03_20_04_world.sql', 'B761760804EA73BD297F296C5C1919687DF7191C', 'ARCHIVED'), +('2015_03_20_05_world.sql', '8481BE9B805704C97D2D8D54272F1E443184B3B2', 'ARCHIVED'), +('2015_03_20_06_world.sql', '', 'ARCHIVED'); |