From bd4609e8293a3ce6ebbe40b74828ce4c34156b49 Mon Sep 17 00:00:00 2001 From: Shauren Date: Thu, 23 Aug 2012 12:34:36 +0200 Subject: Core/Guilds: Fixed saving bank withdraw limits for tabs 7 and 8 --- sql/base/characters_database.sql | 4 ++++ sql/updates/characters/2012_08_23_00_characters_guild_member.sql | 4 ++++ 2 files changed, 8 insertions(+) create mode 100644 sql/updates/characters/2012_08_23_00_characters_guild_member.sql (limited to 'sql') 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; -- cgit v1.2.3