diff options
| author | Shauren <shauren.trinity@gmail.com> | 2012-08-23 12:34:36 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2012-08-23 12:34:36 +0200 |
| commit | bd4609e8293a3ce6ebbe40b74828ce4c34156b49 (patch) | |
| tree | cf2a2d7280cdbdcb7f08e096a2488acbb64ef75f /sql | |
| parent | fa546654c36ef3545c95882017ef63327ea37037 (diff) | |
Core/Guilds: Fixed saving bank withdraw limits for tabs 7 and 8
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 4 | ||||
| -rw-r--r-- | sql/updates/characters/2012_08_23_00_characters_guild_member.sql | 4 |
2 files changed, 8 insertions, 0 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 330b6936104..e9703fe0b28 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1815,6 +1815,10 @@ CREATE TABLE `guild_member` ( `BankRemSlotsTab4` int(10) unsigned NOT NULL DEFAULT '0', `BankResetTimeTab5` int(10) unsigned NOT NULL DEFAULT '0', `BankRemSlotsTab5` int(10) unsigned NOT NULL DEFAULT '0', + `BankResetTimeTab6` int(10) unsigned NOT NULL DEFAULT '0', + `BankRemSlotsTab6` int(10) unsigned NOT NULL DEFAULT '0', + `BankResetTimeTab7` int(10) unsigned NOT NULL DEFAULT '0', + `BankRemSlotsTab7` int(10) unsigned NOT NULL DEFAULT '0', UNIQUE KEY `guid_key` (`guid`), KEY `guildid_key` (`guildid`), KEY `guildid_rank_key` (`guildid`,`rank`) diff --git a/sql/updates/characters/2012_08_23_00_characters_guild_member.sql b/sql/updates/characters/2012_08_23_00_characters_guild_member.sql new file mode 100644 index 00000000000..cdd4781c0c0 --- /dev/null +++ b/sql/updates/characters/2012_08_23_00_characters_guild_member.sql @@ -0,0 +1,4 @@ +ALTER TABLE guild_member ADD BankResetTimeTab6 INT(10) unsigned DEFAULT '0' AFTER BankRemSlotsTab5; +ALTER TABLE guild_member ADD BankRemSlotsTab6 INT(10) unsigned DEFAULT '0' AFTER BankResetTimeTab6; +ALTER TABLE guild_member ADD BankResetTimeTab7 INT(10) unsigned DEFAULT '0' AFTER BankRemSlotsTab6; +ALTER TABLE guild_member ADD BankRemSlotsTab7 INT(10) unsigned DEFAULT '0' AFTER BankResetTimeTab7; |