diff options
Diffstat (limited to 'sql/base/characters_database.sql')
| -rw-r--r-- | sql/base/characters_database.sql | 95 |
1 files changed, 55 insertions, 40 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 795be321d7d..a85591767d4 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 5.5.40, for debian-linux-gnu (x86_64) +-- MySQL dump 10.13 Distrib 5.6.9-rc, for Win64 (x86_64) -- --- Host: localhost Database: characters +-- Host: localhost Database: characters335 -- ------------------------------------------------------ --- Server version 5.5.40-0ubuntu0.14.04.1 +-- Server version 5.6.9-rc /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -2489,6 +2489,57 @@ LOCK TABLES `reserved_name` WRITE; UNLOCK TABLES; -- +-- Table structure for table `updates` +-- + +DROP TABLE IF EXISTS `updates`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `updates` ( + `name` varchar(200) NOT NULL COMMENT 'filename with extension of the update.', + `hash` char(40) 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`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of all applied updates in this database.'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `updates` +-- + +LOCK TABLES `updates` WRITE; +/*!40000 ALTER TABLE `updates` DISABLE KEYS */; +INSERT INTO `updates` VALUES ('2015_03_20_00_characters.sql','B761760804EA73BD297F296C5C1919687DF7191C','ARCHIVED','2015-03-21 21:44:15',0),('2015_03_20_01_characters.sql','894F08B70449A5481FFAF394EE5571D7FC4D8A3A','ARCHIVED','2015-03-21 21:44:15',0),('2015_03_20_02_characters.sql','97D7BE0CAADC79F3F11B9FD296B8C6CD40FE593B','ARCHIVED','2015-03-21 21:44:51',0); +/*!40000 ALTER TABLE `updates` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `updates_include` +-- + +DROP TABLE IF EXISTS `updates_include`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of directories where we want to include sql updates.'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `updates_include` +-- + +LOCK TABLES `updates_include` WRITE; +/*!40000 ALTER TABLE `updates_include` DISABLE KEYS */; +INSERT INTO `updates_include` VALUES ('$/sql/updates/characters','RELEASED'),('$/sql/custom/characters','RELEASED'),('$/sql/old/3.3.5a/characters','ARCHIVED'); +/*!40000 ALTER TABLE `updates_include` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `warden_action` -- @@ -2545,40 +2596,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2014-10-18 18:02:06 - --- 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/3.3.5a/characters', 'ARCHIVED'); - -INSERT IGNORE INTO `updates` (`name`, `hash`) VALUES -('2015_03_20_00_characters.sql', 'B761760804EA73BD297F296C5C1919687DF7191C'), -('2015_03_20_01_characters.sql', '894F08B70449A5481FFAF394EE5571D7FC4D8A3A'), -('2015_03_20_02_characters.sql', ''); +-- Dump completed on 2015-03-21 21:48:11 |