diff options
| author | megamage <none@none> | 2009-02-21 17:04:38 -0600 |
|---|---|---|
| committer | megamage <none@none> | 2009-02-21 17:04:38 -0600 |
| commit | 39c8c6d6e80e2b1fb8b2882a6870458864010570 (patch) | |
| tree | a03a21349df677de30a3d6ceff1317883c6a3886 /sql | |
| parent | 4ecbdb128c59a20c9cfd5c59b4bc960b64e4dc19 (diff) | |
[7314] Not set GR_RIGHT_WITHDRAW_GOLD_LOCK flag for guild masters, remove in DB. Author: Zerg2000
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/7314_01_characters_guild_rank.sql | 3 |
2 files changed, 4 insertions, 1 deletions
diff --git a/sql/characters.sql b/sql/characters.sql index 4149459543a..b0fc4151d0b 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -21,7 +21,7 @@ DROP TABLE IF EXISTS `character_db_version`; CREATE TABLE `character_db_version` ( - `required_7307_01_characters_arena_team_member` bit(1) default NULL + `required_7314_01_characters_guild_rank` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB'; -- diff --git a/sql/updates/7314_01_characters_guild_rank.sql b/sql/updates/7314_01_characters_guild_rank.sql new file mode 100644 index 00000000000..54cf219fc85 --- /dev/null +++ b/sql/updates/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 |