diff options
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; |