[7422] Allow localization base at guildmaster locale default guild rank names at guild creating. Author: VladimirMangos

--HG--
branch : trunk

1 files changed, 9 insertions, 0 deletions

diff --git a/sql/updates/7422_01_mangos_mangos_string.sql b/sql/updates/7422_01_mangos_mangos_string.sql
new file mode 100644
index 00000000000..affe8f74780
--- /dev/null
+++ b/sql/updates/7422_01_mangos_mangos_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 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);