From 4bed1b724fa02682babe5d529f404dd49fdf5990 Mon Sep 17 00:00:00 2001 From: Nay Date: Wed, 30 May 2012 12:53:26 +0100 Subject: Append _4x to all 4.x sqls. Update/fix auth_database.sql --- sql/base/auth_database.sql | 15 +++++++-------- .../2011_11_25_00_characters_character_stats.sql | 5 ----- .../2011_11_25_00_characters_character_stats_4x.sql | 5 +++++ .../characters/2011_11_25_01_characters_characters.sql | 5 ----- .../characters/2011_11_25_01_characters_characters_4x.sql | 5 +++++ .../characters/2011_11_25_02_characters_character_pet.sql | 1 - .../2011_11_25_02_characters_character_pet_4x.sql | 1 + .../2011_11_25_03_characters_character_stats.sql | 7 ------- .../2011_11_25_03_characters_character_stats_4x.sql | 7 +++++++ .../characters/2011_11_25_03_characters_characters.sql | 9 --------- .../characters/2011_11_25_03_characters_characters_4x.sql | 9 +++++++++ .../characters/2011_11_25_03_characters_corpse.sql | 1 - .../characters/2011_11_25_03_characters_corpse_4x.sql | 1 + .../characters/2011_11_26_00_characters_characters.sql | 5 ----- .../characters/2011_11_26_00_characters_characters_4x.sql | 5 +++++ .../characters/2012_01_29_00_characters_characters.sql | 1 - .../characters/2012_01_29_00_characters_characters_4x.sql | 1 + .../characters/2012_01_29_01_characters_characters.sql | 2 -- .../characters/2012_01_29_01_characters_characters_4x.sql | 2 ++ .../characters/2012_05_30_00_characters_characters.sql | 2 -- .../characters/2012_05_30_00_characters_characters_4x.sql | 2 ++ sql/updates/world/2012_01_31_02_world_hotfix_data.sql | 5 ----- sql/updates/world/2012_01_31_02_world_hotfix_data_4x.sql | 5 +++++ 23 files changed, 50 insertions(+), 51 deletions(-) delete mode 100644 sql/updates/characters/2011_11_25_00_characters_character_stats.sql create mode 100644 sql/updates/characters/2011_11_25_00_characters_character_stats_4x.sql delete mode 100644 sql/updates/characters/2011_11_25_01_characters_characters.sql create mode 100644 sql/updates/characters/2011_11_25_01_characters_characters_4x.sql delete mode 100644 sql/updates/characters/2011_11_25_02_characters_character_pet.sql create mode 100644 sql/updates/characters/2011_11_25_02_characters_character_pet_4x.sql delete mode 100644 sql/updates/characters/2011_11_25_03_characters_character_stats.sql create mode 100644 sql/updates/characters/2011_11_25_03_characters_character_stats_4x.sql delete mode 100644 sql/updates/characters/2011_11_25_03_characters_characters.sql create mode 100644 sql/updates/characters/2011_11_25_03_characters_characters_4x.sql delete mode 100644 sql/updates/characters/2011_11_25_03_characters_corpse.sql create mode 100644 sql/updates/characters/2011_11_25_03_characters_corpse_4x.sql delete mode 100644 sql/updates/characters/2011_11_26_00_characters_characters.sql create mode 100644 sql/updates/characters/2011_11_26_00_characters_characters_4x.sql delete mode 100644 sql/updates/characters/2012_01_29_00_characters_characters.sql create mode 100644 sql/updates/characters/2012_01_29_00_characters_characters_4x.sql delete mode 100644 sql/updates/characters/2012_01_29_01_characters_characters.sql create mode 100644 sql/updates/characters/2012_01_29_01_characters_characters_4x.sql delete mode 100644 sql/updates/characters/2012_05_30_00_characters_characters.sql create mode 100644 sql/updates/characters/2012_05_30_00_characters_characters_4x.sql delete mode 100644 sql/updates/world/2012_01_31_02_world_hotfix_data.sql create mode 100644 sql/updates/world/2012_01_31_02_world_hotfix_data_4x.sql (limited to 'sql') diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 9e894850fd7..2d024e552c2 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 5.5.22, for Win64 (x86) +-- MySQL dump 10.13 Distrib 5.5.21, for Win64 (x86) -- --- Host: localhost Database: auth +-- Host: localhost Database: auth_4x -- ------------------------------------------------------ --- Server version 5.5.22 +-- Server version 5.5.21 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -36,7 +36,7 @@ CREATE TABLE `account` ( `locked` tinyint(3) unsigned NOT NULL DEFAULT '0', `last_login` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `online` tinyint(3) unsigned NOT NULL DEFAULT '0', - `expansion` tinyint(3) unsigned NOT NULL DEFAULT '2', + `expansion` tinyint(3) unsigned NOT NULL DEFAULT '3', `mutetime` bigint(20) NOT NULL DEFAULT '0', `locale` tinyint(3) unsigned NOT NULL DEFAULT '0', `os` varchar(3) NOT NULL DEFAULT '', @@ -191,7 +191,7 @@ DROP TABLE IF EXISTS `realmlist`; CREATE TABLE `realmlist` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(32) NOT NULL DEFAULT '', - `address` varchar(255) NOT NULL DEFAULT '127.0.0.1', + `address` varchar(64) NOT NULL DEFAULT '127.0.0.1', `port` smallint(5) unsigned NOT NULL DEFAULT '8085', `icon` tinyint(3) unsigned NOT NULL DEFAULT '0', `flag` tinyint(3) unsigned NOT NULL DEFAULT '2', @@ -210,8 +210,7 @@ CREATE TABLE `realmlist` ( LOCK TABLES `realmlist` WRITE; /*!40000 ALTER TABLE `realmlist` DISABLE KEYS */; -INSERT INTO `realmlist` (`id`,`name`,`address`,`port`,`icon`,`color`,`timezone`,`allowedSecurityLevel`,`population`,`gamebuild`) VALUES -(1,'Trinity','127.0.0.1',8085,1,0,1,0,0,14545); +INSERT INTO `realmlist` VALUES (1,'Trinity','127.0.0.1',8085,1,0,1,0,0,14545); /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */; UNLOCK TABLES; @@ -250,4 +249,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2012-03-28 18:26:06 +-- Dump completed on 2012-05-30 12:52:33 diff --git a/sql/updates/characters/2011_11_25_00_characters_character_stats.sql b/sql/updates/characters/2011_11_25_00_characters_character_stats.sql deleted file mode 100644 index 60506a491e3..00000000000 --- a/sql/updates/characters/2011_11_25_00_characters_character_stats.sql +++ /dev/null @@ -1,5 +0,0 @@ -ALTER TABLE `character_stats` -ADD COLUMN `maxpower8` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `maxpower7`, -ADD COLUMN `maxpower9` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `maxpower8`, -ADD COLUMN `maxpower10` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `maxpower9`, -ADD COLUMN `maxpower11` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `maxpower10`; diff --git a/sql/updates/characters/2011_11_25_00_characters_character_stats_4x.sql b/sql/updates/characters/2011_11_25_00_characters_character_stats_4x.sql new file mode 100644 index 00000000000..60506a491e3 --- /dev/null +++ b/sql/updates/characters/2011_11_25_00_characters_character_stats_4x.sql @@ -0,0 +1,5 @@ +ALTER TABLE `character_stats` +ADD COLUMN `maxpower8` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `maxpower7`, +ADD COLUMN `maxpower9` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `maxpower8`, +ADD COLUMN `maxpower10` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `maxpower9`, +ADD COLUMN `maxpower11` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `maxpower10`; diff --git a/sql/updates/characters/2011_11_25_01_characters_characters.sql b/sql/updates/characters/2011_11_25_01_characters_characters.sql deleted file mode 100644 index 6e56aaf9aea..00000000000 --- a/sql/updates/characters/2011_11_25_01_characters_characters.sql +++ /dev/null @@ -1,5 +0,0 @@ -ALTER TABLE `characters` -ADD COLUMN `power8` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `power7`, -ADD COLUMN `power9` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `power8`, -ADD COLUMN `power10` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `power9`, -ADD COLUMN `power11` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `power10`; diff --git a/sql/updates/characters/2011_11_25_01_characters_characters_4x.sql b/sql/updates/characters/2011_11_25_01_characters_characters_4x.sql new file mode 100644 index 00000000000..6e56aaf9aea --- /dev/null +++ b/sql/updates/characters/2011_11_25_01_characters_characters_4x.sql @@ -0,0 +1,5 @@ +ALTER TABLE `characters` +ADD COLUMN `power8` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `power7`, +ADD COLUMN `power9` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `power8`, +ADD COLUMN `power10` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `power9`, +ADD COLUMN `power11` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `power10`; diff --git a/sql/updates/characters/2011_11_25_02_characters_character_pet.sql b/sql/updates/characters/2011_11_25_02_characters_character_pet.sql deleted file mode 100644 index 61a1490b219..00000000000 --- a/sql/updates/characters/2011_11_25_02_characters_character_pet.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `character_pet` DROP COLUMN `curhappiness`; diff --git a/sql/updates/characters/2011_11_25_02_characters_character_pet_4x.sql b/sql/updates/characters/2011_11_25_02_characters_character_pet_4x.sql new file mode 100644 index 00000000000..61a1490b219 --- /dev/null +++ b/sql/updates/characters/2011_11_25_02_characters_character_pet_4x.sql @@ -0,0 +1 @@ +ALTER TABLE `character_pet` DROP COLUMN `curhappiness`; diff --git a/sql/updates/characters/2011_11_25_03_characters_character_stats.sql b/sql/updates/characters/2011_11_25_03_characters_character_stats.sql deleted file mode 100644 index 5f41b6e40db..00000000000 --- a/sql/updates/characters/2011_11_25_03_characters_character_stats.sql +++ /dev/null @@ -1,7 +0,0 @@ -ALTER TABLE `character_stats` -DROP COLUMN `maxpower6`, -DROP COLUMN `maxpower7`, -DROP COLUMN `maxpower8`, -DROP COLUMN `maxpower9`, -DROP COLUMN `maxpower10`, -DROP COLUMN `maxpower11`; diff --git a/sql/updates/characters/2011_11_25_03_characters_character_stats_4x.sql b/sql/updates/characters/2011_11_25_03_characters_character_stats_4x.sql new file mode 100644 index 00000000000..5f41b6e40db --- /dev/null +++ b/sql/updates/characters/2011_11_25_03_characters_character_stats_4x.sql @@ -0,0 +1,7 @@ +ALTER TABLE `character_stats` +DROP COLUMN `maxpower6`, +DROP COLUMN `maxpower7`, +DROP COLUMN `maxpower8`, +DROP COLUMN `maxpower9`, +DROP COLUMN `maxpower10`, +DROP COLUMN `maxpower11`; diff --git a/sql/updates/characters/2011_11_25_03_characters_characters.sql b/sql/updates/characters/2011_11_25_03_characters_characters.sql deleted file mode 100644 index cede344b6bf..00000000000 --- a/sql/updates/characters/2011_11_25_03_characters_characters.sql +++ /dev/null @@ -1,9 +0,0 @@ -ALTER TABLE `characters` -DROP COLUMN `power6`, -DROP COLUMN `power7`, -DROP COLUMN `power8`, -DROP COLUMN `power9`, -DROP COLUMN `power10`, -DROP COLUMN `power11`, -DROP COLUMN `ammoId`, -ADD COLUMN `guildId` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `grantableLevels`; diff --git a/sql/updates/characters/2011_11_25_03_characters_characters_4x.sql b/sql/updates/characters/2011_11_25_03_characters_characters_4x.sql new file mode 100644 index 00000000000..cede344b6bf --- /dev/null +++ b/sql/updates/characters/2011_11_25_03_characters_characters_4x.sql @@ -0,0 +1,9 @@ +ALTER TABLE `characters` +DROP COLUMN `power6`, +DROP COLUMN `power7`, +DROP COLUMN `power8`, +DROP COLUMN `power9`, +DROP COLUMN `power10`, +DROP COLUMN `power11`, +DROP COLUMN `ammoId`, +ADD COLUMN `guildId` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `grantableLevels`; diff --git a/sql/updates/characters/2011_11_25_03_characters_corpse.sql b/sql/updates/characters/2011_11_25_03_characters_corpse.sql deleted file mode 100644 index e1823602b65..00000000000 --- a/sql/updates/characters/2011_11_25_03_characters_corpse.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `corpse` DROP COLUMN `guildId`; diff --git a/sql/updates/characters/2011_11_25_03_characters_corpse_4x.sql b/sql/updates/characters/2011_11_25_03_characters_corpse_4x.sql new file mode 100644 index 00000000000..e1823602b65 --- /dev/null +++ b/sql/updates/characters/2011_11_25_03_characters_corpse_4x.sql @@ -0,0 +1 @@ +ALTER TABLE `corpse` DROP COLUMN `guildId`; diff --git a/sql/updates/characters/2011_11_26_00_characters_characters.sql b/sql/updates/characters/2011_11_26_00_characters_characters.sql deleted file mode 100644 index 9fe2b4c804e..00000000000 --- a/sql/updates/characters/2011_11_26_00_characters_characters.sql +++ /dev/null @@ -1,5 +0,0 @@ -ALTER TABLE `characters` -DROP COLUMN `todayHonorPoints`, -DROP COLUMN `yesterdayHonorPoints`, -DROP COLUMN `knownCurrencies`, -CHANGE COLUMN `arenaPoints` `conquestPoints` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `taxi_path`; diff --git a/sql/updates/characters/2011_11_26_00_characters_characters_4x.sql b/sql/updates/characters/2011_11_26_00_characters_characters_4x.sql new file mode 100644 index 00000000000..9fe2b4c804e --- /dev/null +++ b/sql/updates/characters/2011_11_26_00_characters_characters_4x.sql @@ -0,0 +1,5 @@ +ALTER TABLE `characters` +DROP COLUMN `todayHonorPoints`, +DROP COLUMN `yesterdayHonorPoints`, +DROP COLUMN `knownCurrencies`, +CHANGE COLUMN `arenaPoints` `conquestPoints` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `taxi_path`; diff --git a/sql/updates/characters/2012_01_29_00_characters_characters.sql b/sql/updates/characters/2012_01_29_00_characters_characters.sql deleted file mode 100644 index baaf37ac467..00000000000 --- a/sql/updates/characters/2012_01_29_00_characters_characters.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `characters` ADD `talentTree` smallint(5) UNSIGNED NOT NULL DEFAULT 0 AFTER `resettalents_time`; diff --git a/sql/updates/characters/2012_01_29_00_characters_characters_4x.sql b/sql/updates/characters/2012_01_29_00_characters_characters_4x.sql new file mode 100644 index 00000000000..baaf37ac467 --- /dev/null +++ b/sql/updates/characters/2012_01_29_00_characters_characters_4x.sql @@ -0,0 +1 @@ +ALTER TABLE `characters` ADD `talentTree` smallint(5) UNSIGNED NOT NULL DEFAULT 0 AFTER `resettalents_time`; diff --git a/sql/updates/characters/2012_01_29_01_characters_characters.sql b/sql/updates/characters/2012_01_29_01_characters_characters.sql deleted file mode 100644 index ae8aefc75b6..00000000000 --- a/sql/updates/characters/2012_01_29_01_characters_characters.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE `characters` CHANGE `talentTree` `talentTree` varchar(10) NOT NULL DEFAULT '0 0 ' AFTER `resettalents_time`; -UPDATE `characters` SET `talentTree`='0 0 '; diff --git a/sql/updates/characters/2012_01_29_01_characters_characters_4x.sql b/sql/updates/characters/2012_01_29_01_characters_characters_4x.sql new file mode 100644 index 00000000000..ae8aefc75b6 --- /dev/null +++ b/sql/updates/characters/2012_01_29_01_characters_characters_4x.sql @@ -0,0 +1,2 @@ +ALTER TABLE `characters` CHANGE `talentTree` `talentTree` varchar(10) NOT NULL DEFAULT '0 0 ' AFTER `resettalents_time`; +UPDATE `characters` SET `talentTree`='0 0 '; diff --git a/sql/updates/characters/2012_05_30_00_characters_characters.sql b/sql/updates/characters/2012_05_30_00_characters_characters.sql deleted file mode 100644 index 9336e826580..00000000000 --- a/sql/updates/characters/2012_05_30_00_characters_characters.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Remove unused flag -UPDATE `characters` SET `extra_flags`=`extra_flags`&~0x40; diff --git a/sql/updates/characters/2012_05_30_00_characters_characters_4x.sql b/sql/updates/characters/2012_05_30_00_characters_characters_4x.sql new file mode 100644 index 00000000000..9336e826580 --- /dev/null +++ b/sql/updates/characters/2012_05_30_00_characters_characters_4x.sql @@ -0,0 +1,2 @@ +-- Remove unused flag +UPDATE `characters` SET `extra_flags`=`extra_flags`&~0x40; diff --git a/sql/updates/world/2012_01_31_02_world_hotfix_data.sql b/sql/updates/world/2012_01_31_02_world_hotfix_data.sql deleted file mode 100644 index ce45feed943..00000000000 --- a/sql/updates/world/2012_01_31_02_world_hotfix_data.sql +++ /dev/null @@ -1,5 +0,0 @@ -ALTER TABLE hotfix_data ADD `hotfixDate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `unk`; -UPDATE `hotfix_data` SET `hotfixDate`=FROM_UNIXTIME(`unk`); -ALTER TABLE `hotfix_data` DROP PRIMARY KEY; -ALTER TABLE `hotfix_data` ADD PRIMARY KEY (`entry`,`type`,`hotfixDate`); -ALTER TABLE `hotfix_data` DROP `unk`; diff --git a/sql/updates/world/2012_01_31_02_world_hotfix_data_4x.sql b/sql/updates/world/2012_01_31_02_world_hotfix_data_4x.sql new file mode 100644 index 00000000000..ce45feed943 --- /dev/null +++ b/sql/updates/world/2012_01_31_02_world_hotfix_data_4x.sql @@ -0,0 +1,5 @@ +ALTER TABLE hotfix_data ADD `hotfixDate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `unk`; +UPDATE `hotfix_data` SET `hotfixDate`=FROM_UNIXTIME(`unk`); +ALTER TABLE `hotfix_data` DROP PRIMARY KEY; +ALTER TABLE `hotfix_data` ADD PRIMARY KEY (`entry`,`type`,`hotfixDate`); +ALTER TABLE `hotfix_data` DROP `unk`; -- cgit v1.2.3