diff options
-rw-r--r-- | sql/base/auth_database.sql | 15 | ||||
-rw-r--r-- | sql/updates/characters/2011_11_25_00_characters_character_stats_4x.sql (renamed from sql/updates/characters/2011_11_25_00_characters_character_stats.sql) | 0 | ||||
-rw-r--r-- | sql/updates/characters/2011_11_25_01_characters_characters_4x.sql (renamed from sql/updates/characters/2011_11_25_01_characters_characters.sql) | 0 | ||||
-rw-r--r-- | sql/updates/characters/2011_11_25_02_characters_character_pet_4x.sql (renamed from sql/updates/characters/2011_11_25_02_characters_character_pet.sql) | 0 | ||||
-rw-r--r-- | sql/updates/characters/2011_11_25_03_characters_character_stats_4x.sql (renamed from sql/updates/characters/2011_11_25_03_characters_character_stats.sql) | 0 | ||||
-rw-r--r-- | sql/updates/characters/2011_11_25_03_characters_characters_4x.sql (renamed from sql/updates/characters/2011_11_25_03_characters_characters.sql) | 0 | ||||
-rw-r--r-- | sql/updates/characters/2011_11_25_03_characters_corpse_4x.sql (renamed from sql/updates/characters/2011_11_25_03_characters_corpse.sql) | 0 | ||||
-rw-r--r-- | sql/updates/characters/2011_11_26_00_characters_characters_4x.sql (renamed from sql/updates/characters/2011_11_26_00_characters_characters.sql) | 0 | ||||
-rw-r--r-- | sql/updates/characters/2012_01_29_00_characters_characters_4x.sql (renamed from sql/updates/characters/2012_01_29_00_characters_characters.sql) | 0 | ||||
-rw-r--r-- | sql/updates/characters/2012_01_29_01_characters_characters_4x.sql (renamed from sql/updates/characters/2012_01_29_01_characters_characters.sql) | 0 | ||||
-rw-r--r-- | sql/updates/characters/2012_05_30_00_characters_characters_4x.sql (renamed from sql/updates/characters/2012_05_30_00_characters_characters.sql) | 0 | ||||
-rw-r--r-- | sql/updates/world/2012_01_31_02_world_hotfix_data_4x.sql (renamed from sql/updates/world/2012_01_31_02_world_hotfix_data.sql) | 0 |
12 files changed, 7 insertions, 8 deletions
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_4x.sql index 60506a491e3..60506a491e3 100644 --- a/sql/updates/characters/2011_11_25_00_characters_character_stats.sql +++ b/sql/updates/characters/2011_11_25_00_characters_character_stats_4x.sql diff --git a/sql/updates/characters/2011_11_25_01_characters_characters.sql b/sql/updates/characters/2011_11_25_01_characters_characters_4x.sql index 6e56aaf9aea..6e56aaf9aea 100644 --- a/sql/updates/characters/2011_11_25_01_characters_characters.sql +++ b/sql/updates/characters/2011_11_25_01_characters_characters_4x.sql 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_4x.sql index 61a1490b219..61a1490b219 100644 --- a/sql/updates/characters/2011_11_25_02_characters_character_pet.sql +++ b/sql/updates/characters/2011_11_25_02_characters_character_pet_4x.sql 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_4x.sql index 5f41b6e40db..5f41b6e40db 100644 --- a/sql/updates/characters/2011_11_25_03_characters_character_stats.sql +++ b/sql/updates/characters/2011_11_25_03_characters_character_stats_4x.sql diff --git a/sql/updates/characters/2011_11_25_03_characters_characters.sql b/sql/updates/characters/2011_11_25_03_characters_characters_4x.sql index cede344b6bf..cede344b6bf 100644 --- a/sql/updates/characters/2011_11_25_03_characters_characters.sql +++ b/sql/updates/characters/2011_11_25_03_characters_characters_4x.sql diff --git a/sql/updates/characters/2011_11_25_03_characters_corpse.sql b/sql/updates/characters/2011_11_25_03_characters_corpse_4x.sql index e1823602b65..e1823602b65 100644 --- a/sql/updates/characters/2011_11_25_03_characters_corpse.sql +++ b/sql/updates/characters/2011_11_25_03_characters_corpse_4x.sql diff --git a/sql/updates/characters/2011_11_26_00_characters_characters.sql b/sql/updates/characters/2011_11_26_00_characters_characters_4x.sql index 9fe2b4c804e..9fe2b4c804e 100644 --- a/sql/updates/characters/2011_11_26_00_characters_characters.sql +++ b/sql/updates/characters/2011_11_26_00_characters_characters_4x.sql diff --git a/sql/updates/characters/2012_01_29_00_characters_characters.sql b/sql/updates/characters/2012_01_29_00_characters_characters_4x.sql index baaf37ac467..baaf37ac467 100644 --- a/sql/updates/characters/2012_01_29_00_characters_characters.sql +++ b/sql/updates/characters/2012_01_29_00_characters_characters_4x.sql diff --git a/sql/updates/characters/2012_01_29_01_characters_characters.sql b/sql/updates/characters/2012_01_29_01_characters_characters_4x.sql index ae8aefc75b6..ae8aefc75b6 100644 --- a/sql/updates/characters/2012_01_29_01_characters_characters.sql +++ b/sql/updates/characters/2012_01_29_01_characters_characters_4x.sql diff --git a/sql/updates/characters/2012_05_30_00_characters_characters.sql b/sql/updates/characters/2012_05_30_00_characters_characters_4x.sql index 9336e826580..9336e826580 100644 --- a/sql/updates/characters/2012_05_30_00_characters_characters.sql +++ b/sql/updates/characters/2012_05_30_00_characters_characters_4x.sql 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_4x.sql index ce45feed943..ce45feed943 100644 --- a/sql/updates/world/2012_01_31_02_world_hotfix_data.sql +++ b/sql/updates/world/2012_01_31_02_world_hotfix_data_4x.sql |