* Added sql trinity code style.

--HG--
branch : trunk

6 files changed, 13 insertions, 13 deletions

diff --git a/sql/updates/1764_world.sql b/sql/updates/1764_world.sql
index b87a0488e9c..016066430b6 100644
--- a/sql/updates/1764_world.sql
+++ b/sql/updates/1764_world.sql
@@ -6,4 +6,4 @@ REPLACE INTO `spell_proc_event` VALUES (20210, 0x00, 10, 3221225472, 0x00000000,
 REPLACE INTO `spell_proc_event` VALUES (20212, 0x00, 10, 3221225472, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0);
 REPLACE INTO `spell_proc_event` VALUES (20213, 0x00, 10, 3221225472, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0);
 REPLACE INTO `spell_proc_event` VALUES (20214, 0x00, 10, 3221225472, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0);
-REPLACE INTO `spell_proc_event` VALUES (20215, 0x00, 10, 3221225472, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0);
+REPLACE INTO `spell_proc_event` VALUES (20215, 0x00, 10, 3221225472, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0);
\ No newline at end of file
diff --git a/sql/updates/1791_mangos_7422_01_world_trinity_string.sql b/sql/updates/1791_mangos_7422_01_world_trinity_string.sql
new file mode 100644
index 00000000000..c1394e16ad8
--- /dev/null
+++ b/sql/updates/1791_mangos_7422_01_world_trinity_string.sql
@@ -0,0 +1,9 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7399_01_mangos_mangos_string required_7422_01_mangos_mangos_string bit;*/
+
+DELETE FROM `trinity_string` WHERE `entry` IN (811, 812, 813, 814, 815);
+INSERT INTO `trinity_string` VALUES
+(811,'Guild Master',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(812,'Officer',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(813,'Veteran',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(814,'Member',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(815,'Initiate',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
\ No newline at end of file
diff --git a/sql/updates/1825_world.sql b/sql/updates/1825_world.sql
index 9548a529cdd..3b40e758455 100644
--- a/sql/updates/1825_world.sql
+++ b/sql/updates/1825_world.sql
@@ -1 +1 @@
-INSERT INTO `spell_linked_spell` VALUES (-47953, 60406, 0, 'Divine hymn buff to enemies');
+INSERT INTO `spell_linked_spell` VALUES (-47953, 60406, 0, 'Divine hymn buff to enemies');
\ No newline at end of file
diff --git a/sql/updates/1828_world.sql b/sql/updates/1828_world.sql
index 64b6e54bfdf..1b80fd33559 100644
--- a/sql/updates/1828_world.sql
+++ b/sql/updates/1828_world.sql
@@ -1,4 +1,3 @@
 INSERT INTO `spell_linked_spell` VALUES (48265, 49772, 2, 'Unholy Presence');
 INSERT INTO `spell_linked_spell` VALUES (49772, 55222, 2, 'Unholy Presence');
-
-INSERT INTO `spell_linked_spell` VALUES (48263, 61261, 2, 'Frost Presence');
+INSERT INTO `spell_linked_spell` VALUES (48263, 61261, 2, 'Frost Presence');
\ No newline at end of file
diff --git a/sql/updates/7422_01_mangos_mangos_string.sql b/sql/updates/7422_01_mangos_mangos_string.sql
deleted file mode 100644
index affe8f74780..00000000000
--- a/sql/updates/7422_01_mangos_mangos_string.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-ALTER TABLE db_version CHANGE COLUMN required_7399_01_mangos_mangos_string required_7422_01_mangos_mangos_string bit;
-
-DELETE FROM mangos_string WHERE entry in (811, 812, 813, 814, 815);
-INSERT INTO mangos_string VALUES
- (811,'Guild Master',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
- (812,'Officer',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
- (813,'Veteran',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
- (814,'Member',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
- (815,'Initiate',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt
index 931649d6512..3b8a3a5a82e 100644
--- a/sql/updates/CMakeLists.txt
+++ b/sql/updates/CMakeLists.txt
@@ -74,6 +74,7 @@ INSTALL(FILES
 1755_world.sql
 1764_world.sql
 1766_world.sql
+1791_mangos_7422_01_world_trinity_string.sql
 1814_world.sql
 1825_world.sql
 1828_world.sql