From b2a41e0e607294b71015a060eb72ff92a63f2054 Mon Sep 17 00:00:00 2001
From: Drahy <none@none>
Date: Sun, 22 Feb 2009 04:18:30 +0100
Subject: * Trinity sql coding style for latest files * Updated characters.sql
 up to this revision

--HG--
branch : trunk
---
 sql/updates/1495_mangos_7312_01_world_trinity_string.sql  | 5 +++++
 sql/updates/1497_mangos_7314_01_characters_guild_rank.sql | 3 +++
 sql/updates/7312_01_mangos_mangos_string.sql              | 5 -----
 sql/updates/7314_01_characters_guild_rank.sql             | 3 ---
 sql/updates/CMakeLists.txt                                | 3 +++
 5 files changed, 11 insertions(+), 8 deletions(-)
 create mode 100644 sql/updates/1495_mangos_7312_01_world_trinity_string.sql
 create mode 100644 sql/updates/1497_mangos_7314_01_characters_guild_rank.sql
 delete mode 100644 sql/updates/7312_01_mangos_mangos_string.sql
 delete mode 100644 sql/updates/7314_01_characters_guild_rank.sql

(limited to 'sql/updates')

diff --git a/sql/updates/1495_mangos_7312_01_world_trinity_string.sql b/sql/updates/1495_mangos_7312_01_world_trinity_string.sql
new file mode 100644
index 00000000000..9eb246ea6f3
--- /dev/null
+++ b/sql/updates/1495_mangos_7312_01_world_trinity_string.sql
@@ -0,0 +1,5 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7303_01_mangos_pools required_7312_01_mangos_mangos_string bit;*/
+
+DELETE FROM `mangos_string` WHERE entry = 810;
+INSERT INTO `mangos_string` VALUES
+(810,'|Hplayer:$N|h[$N]|h has earned the achievement $a!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
\ No newline at end of file
diff --git a/sql/updates/1497_mangos_7314_01_characters_guild_rank.sql b/sql/updates/1497_mangos_7314_01_characters_guild_rank.sql
new file mode 100644
index 00000000000..80aa49c21c4
--- /dev/null
+++ b/sql/updates/1497_mangos_7314_01_characters_guild_rank.sql
@@ -0,0 +1,3 @@
+/*ALTER TABLE character_db_version CHANGE COLUMN required_7307_01_characters_arena_team_member required_7314_01_characters_guild_rank bit;*/
+
+UPDATE guild_rank SET rights = rights & ~0x00020000;
\ No newline at end of file
diff --git a/sql/updates/7312_01_mangos_mangos_string.sql b/sql/updates/7312_01_mangos_mangos_string.sql
deleted file mode 100644
index 8a5f848d438..00000000000
--- a/sql/updates/7312_01_mangos_mangos_string.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-ALTER TABLE db_version CHANGE COLUMN required_7303_01_mangos_pools required_7312_01_mangos_mangos_string bit;
-
-DELETE FROM `mangos_string` WHERE entry = 810;
-INSERT INTO `mangos_string` VALUES
-(810,'|Hplayer:$N|h[$N]|h has earned the achievement $a!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
diff --git a/sql/updates/7314_01_characters_guild_rank.sql b/sql/updates/7314_01_characters_guild_rank.sql
deleted file mode 100644
index 54cf219fc85..00000000000
--- a/sql/updates/7314_01_characters_guild_rank.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-ALTER TABLE character_db_version CHANGE COLUMN required_7307_01_characters_arena_team_member required_7314_01_characters_guild_rank bit;
-
-UPDATE guild_rank SET rights = rights & ~0x00020000;
\ No newline at end of file
diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt
index 285677f469b..a9c343b7353 100644
--- a/sql/updates/CMakeLists.txt
+++ b/sql/updates/CMakeLists.txt
@@ -40,4 +40,7 @@ INSTALL(FILES
 1426_mangos_7292_02_world_locales_points_of_interest.sql
 1463_mangos_7303_01_world_pools.sql
 1470_world_scripts.sql
+1484_mangos_7307_01_characters_arena_team_member.sql
+1495_mangos_7312_01_world_trinity_string.sql
+1497_mangos_7314_01_characters_guild_rank.sql
 DESTINATION share/trinity/sql/updates)
\ No newline at end of file
-- 
cgit v1.2.3