aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/base/auth_database.sql15
-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