diff options
| author | Drahy <none@none> | 2009-02-22 04:18:30 +0100 |
|---|---|---|
| committer | Drahy <none@none> | 2009-02-22 04:18:30 +0100 |
| commit | b2a41e0e607294b71015a060eb72ff92a63f2054 (patch) | |
| tree | e5a215014e0cc69341d0fff5d8284cdc87387b2e /sql/updates | |
| parent | 242c2cff4a9cebbc94512f3441651e33e45ad44d (diff) | |
* Trinity sql coding style for latest files
* Updated characters.sql up to this revision
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/1495_mangos_7312_01_world_trinity_string.sql | 5 | ||||
| -rw-r--r-- | sql/updates/1497_mangos_7314_01_characters_guild_rank.sql | 3 | ||||
| -rw-r--r-- | sql/updates/7312_01_mangos_mangos_string.sql | 5 | ||||
| -rw-r--r-- | sql/updates/7314_01_characters_guild_rank.sql | 3 | ||||
| -rw-r--r-- | sql/updates/CMakeLists.txt | 3 |
5 files changed, 11 insertions, 8 deletions
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 |