aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/auth_database.sql57
-rw-r--r--sql/base/characters_database.sql55
-rw-r--r--sql/base/dev/hotfixes_database.sql18
-rw-r--r--sql/base/hotfixes_database.sql56
4 files changed, 168 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');