diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/mangos.sql | 3 | ||||
| -rw-r--r-- | sql/updates/7312_01_mangos_mangos_string.sql | 5 |
2 files changed, 7 insertions, 1 deletions
diff --git a/sql/mangos.sql b/sql/mangos.sql index a7e555be112..75b4fce25e6 100644 --- a/sql/mangos.sql +++ b/sql/mangos.sql @@ -22,7 +22,7 @@ DROP TABLE IF EXISTS `db_version`; CREATE TABLE `db_version` ( `version` varchar(120) default NULL, - `required_7303_01_mangos_pools` bit(1) default NULL + `required_7312_01_mangos_mangos_string` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; -- @@ -2870,6 +2870,7 @@ INSERT INTO `mangos_string` VALUES (807,'Please provide character name',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (808,'Player %s not found or offline',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (809,'Account for character %s not found',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(810,'|Hplayer:$N|h[$N]|h has earned the achievement $a!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1000,'Exiting daemon...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1001,'Account deleted: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1002,'Account %s NOT deleted (probably sql file format was updated)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), diff --git a/sql/updates/7312_01_mangos_mangos_string.sql b/sql/updates/7312_01_mangos_mangos_string.sql new file mode 100644 index 00000000000..8a5f848d438 --- /dev/null +++ b/sql/updates/7312_01_mangos_mangos_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); |