aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/auth_database.sql4
-rw-r--r--sql/create/create_mysql.sql4
-rw-r--r--sql/create/drop_mysql.sql6
-rw-r--r--sql/updates/3.3.3a_old/8770_world_areatrigger_scripts.sql (renamed from sql/updates/8770_world_areatrigger_scripts.sql)0
-rw-r--r--sql/updates/3.3.3a_old/8770_world_script_waypoints.sql (renamed from sql/updates/8770_world_script_waypoints.sql)0
-rw-r--r--sql/updates/3.3.3a_old/8770_world_scriptname.sql (renamed from sql/updates/8770_world_scriptname.sql)0
-rw-r--r--sql/updates/3.3.3a_old/8790_world_locales_item_set_names.sql (renamed from sql/updates/8790_world_locales_item_set_names.sql)0
-rw-r--r--sql/updates/3.3.3a_old/8816_world_spell_bonus_data.sql (renamed from sql/updates/8816_world_spell_bonus_data.sql)0
-rw-r--r--sql/updates/3.3.3a_old/8821_world_spell_dbc.sql (renamed from sql/updates/8821_world_spell_dbc.sql)0
-rw-r--r--sql/updates/3.3.3a_old/8836_world_spell_linked_spell.sql (renamed from sql/updates/8836_world_spell_linked_spell.sql)0
-rw-r--r--sql/updates/3.3.3a_old/8842_world_script_texts.sql (renamed from sql/updates/8842_world_script_texts.sql)0
-rw-r--r--sql/updates/3.3.3a_old/8842_world_scriptname.sql (renamed from sql/updates/8842_world_scriptname.sql)0
-rw-r--r--sql/updates/3.3.3a_old/8843_world_scriptname.sql (renamed from sql/updates/8843_world_scriptname.sql)0
-rw-r--r--sql/updates/3.3.5a_old/8861_auth_realmlist.sql3
-rw-r--r--sql/updates/3.3.5a_old/CMakeLists.txt3
-rw-r--r--sql/updates/CMakeLists.txt1
16 files changed, 14 insertions, 7 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 50940b45705..459b3fa1468 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -196,7 +196,7 @@ CREATE TABLE `realmlist` (
`timezone` tinyint(3) unsigned NOT NULL default '0',
`allowedSecurityLevel` tinyint(3) unsigned NOT NULL default '0',
`population` float unsigned NOT NULL default '0',
- `gamebuild` int(11) unsigned NOT NULL default '11723',
+ `gamebuild` int(11) unsigned NOT NULL default '12340',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Realm System';
@@ -209,7 +209,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,11723);
+(1,'Trinity','127.0.0.1',8085,1,0,1,0,0,12340);
/*!40000 ALTER TABLE `realmlist` ENABLE KEYS */;
UNLOCK TABLES;
diff --git a/sql/create/create_mysql.sql b/sql/create/create_mysql.sql
index dc272ebf697..e182e06168f 100644
--- a/sql/create/create_mysql.sql
+++ b/sql/create/create_mysql.sql
@@ -4,10 +4,10 @@ CREATE DATABASE `world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
-CREATE DATABASE `realmd` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
+CREATE DATABASE `auth` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL PRIVILEGES ON `world` . * TO 'trinity'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `characters` . * TO 'trinity'@'localhost' WITH GRANT OPTION;
-GRANT ALL PRIVILEGES ON `realmd` . * TO 'trinity'@'localhost' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON `auth` . * TO 'trinity'@'localhost' WITH GRANT OPTION;
diff --git a/sql/create/drop_mysql.sql b/sql/create/drop_mysql.sql
index c0ec81e378f..ee05439df99 100644
--- a/sql/create/drop_mysql.sql
+++ b/sql/create/drop_mysql.sql
@@ -8,9 +8,9 @@ REVOKE ALL PRIVILEGES ON `characters` . * FROM 'trinity'@'localhost';
REVOKE GRANT OPTION ON `characters` . * FROM 'trinity'@'localhost';
-REVOKE ALL PRIVILEGES ON `realmd` . * FROM 'trinity'@'localhost';
+REVOKE ALL PRIVILEGES ON `auth` . * FROM 'trinity'@'localhost';
-REVOKE GRANT OPTION ON `realmd` . * FROM 'trinity'@'localhost';
+REVOKE GRANT OPTION ON `auth` . * FROM 'trinity'@'localhost';
DROP USER 'trinity'@'localhost';
@@ -18,4 +18,4 @@ DROP DATABASE IF EXISTS `world`;
DROP DATABASE IF EXISTS `characters`;
-DROP DATABASE IF EXISTS `realmd`;
+DROP DATABASE IF EXISTS `auth`;
diff --git a/sql/updates/8770_world_areatrigger_scripts.sql b/sql/updates/3.3.3a_old/8770_world_areatrigger_scripts.sql
index 044725b3a5f..044725b3a5f 100644
--- a/sql/updates/8770_world_areatrigger_scripts.sql
+++ b/sql/updates/3.3.3a_old/8770_world_areatrigger_scripts.sql
diff --git a/sql/updates/8770_world_script_waypoints.sql b/sql/updates/3.3.3a_old/8770_world_script_waypoints.sql
index c2418f6da33..c2418f6da33 100644
--- a/sql/updates/8770_world_script_waypoints.sql
+++ b/sql/updates/3.3.3a_old/8770_world_script_waypoints.sql
diff --git a/sql/updates/8770_world_scriptname.sql b/sql/updates/3.3.3a_old/8770_world_scriptname.sql
index e173f7e41f2..e173f7e41f2 100644
--- a/sql/updates/8770_world_scriptname.sql
+++ b/sql/updates/3.3.3a_old/8770_world_scriptname.sql
diff --git a/sql/updates/8790_world_locales_item_set_names.sql b/sql/updates/3.3.3a_old/8790_world_locales_item_set_names.sql
index 4f6015ac749..4f6015ac749 100644
--- a/sql/updates/8790_world_locales_item_set_names.sql
+++ b/sql/updates/3.3.3a_old/8790_world_locales_item_set_names.sql
diff --git a/sql/updates/8816_world_spell_bonus_data.sql b/sql/updates/3.3.3a_old/8816_world_spell_bonus_data.sql
index 67d01d19b77..67d01d19b77 100644
--- a/sql/updates/8816_world_spell_bonus_data.sql
+++ b/sql/updates/3.3.3a_old/8816_world_spell_bonus_data.sql
diff --git a/sql/updates/8821_world_spell_dbc.sql b/sql/updates/3.3.3a_old/8821_world_spell_dbc.sql
index 903a932edaf..903a932edaf 100644
--- a/sql/updates/8821_world_spell_dbc.sql
+++ b/sql/updates/3.3.3a_old/8821_world_spell_dbc.sql
diff --git a/sql/updates/8836_world_spell_linked_spell.sql b/sql/updates/3.3.3a_old/8836_world_spell_linked_spell.sql
index 64c3c66c9e1..64c3c66c9e1 100644
--- a/sql/updates/8836_world_spell_linked_spell.sql
+++ b/sql/updates/3.3.3a_old/8836_world_spell_linked_spell.sql
diff --git a/sql/updates/8842_world_script_texts.sql b/sql/updates/3.3.3a_old/8842_world_script_texts.sql
index 617b61a694f..617b61a694f 100644
--- a/sql/updates/8842_world_script_texts.sql
+++ b/sql/updates/3.3.3a_old/8842_world_script_texts.sql
diff --git a/sql/updates/8842_world_scriptname.sql b/sql/updates/3.3.3a_old/8842_world_scriptname.sql
index 5ef8e4b6aa9..5ef8e4b6aa9 100644
--- a/sql/updates/8842_world_scriptname.sql
+++ b/sql/updates/3.3.3a_old/8842_world_scriptname.sql
diff --git a/sql/updates/8843_world_scriptname.sql b/sql/updates/3.3.3a_old/8843_world_scriptname.sql
index 4517544d99d..4517544d99d 100644
--- a/sql/updates/8843_world_scriptname.sql
+++ b/sql/updates/3.3.3a_old/8843_world_scriptname.sql
diff --git a/sql/updates/3.3.5a_old/8861_auth_realmlist.sql b/sql/updates/3.3.5a_old/8861_auth_realmlist.sql
new file mode 100644
index 00000000000..c6622d5ce1e
--- /dev/null
+++ b/sql/updates/3.3.5a_old/8861_auth_realmlist.sql
@@ -0,0 +1,3 @@
+UPDATE `realmlist` SET `gamebuild`=12340 WHERE `id`=1;
+ALTER TABLE `realmlist` CHANGE COLUMN `gamebuild` `gamebuild` int(11) unsigned NOT NULL default '12340';
+
diff --git a/sql/updates/3.3.5a_old/CMakeLists.txt b/sql/updates/3.3.5a_old/CMakeLists.txt
new file mode 100644
index 00000000000..63cb6eab23e
--- /dev/null
+++ b/sql/updates/3.3.5a_old/CMakeLists.txt
@@ -0,0 +1,3 @@
+FILE(GLOB _SQL_335 *.sql)
+
+INSTALL(FILES ${_SQL_333} DESTINATION share/trinity/sql/updates/3.3.5a_old)
diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt
index 0d2d6cd6bfa..fca7e740f90 100644
--- a/sql/updates/CMakeLists.txt
+++ b/sql/updates/CMakeLists.txt
@@ -4,6 +4,7 @@ add_subdirectory(3.1.3_old)
add_subdirectory(3.2.2a_old)
add_subdirectory(3.3.2_old)
add_subdirectory(3.3.3a_old)
+add_subdirectory(3.3.5a_old)
FILE(GLOB _SQL_UPDATES *.sql)