aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/characters_database.sql2
-rw-r--r--sql/updates/9911_characters_guild_bank_eventlog.sql1
2 files changed, 2 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index df37dbe0e00..094cf5c4009 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1449,7 +1449,7 @@ CREATE TABLE `guild_bank_eventlog` (
`EventType` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Event type',
`PlayerGuid` int(11) unsigned NOT NULL default '0',
`ItemOrMoney` int(11) unsigned NOT NULL default '0',
- `ItemStackCount` tinyint(3) unsigned NOT NULL default '0',
+ `ItemStackCount` smallint(4) unsigned NOT NULL default '0',
`DestTabId` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Destination Tab Id',
`TimeStamp` bigint(20) unsigned NOT NULL default '0' COMMENT 'Event UNIX time',
PRIMARY KEY (`guildid`,`LogGuid`,`TabId`),
diff --git a/sql/updates/9911_characters_guild_bank_eventlog.sql b/sql/updates/9911_characters_guild_bank_eventlog.sql
new file mode 100644
index 00000000000..405d8eb599c
--- /dev/null
+++ b/sql/updates/9911_characters_guild_bank_eventlog.sql
@@ -0,0 +1 @@
+ALTER TABLE `guild_bank_eventlog` CHANGE `ItemStackCount` `ItemStackCount` SMALLINT(4) UNSIGNED DEFAULT '0' NOT NULL;