1 ALTER TABLE character_db_version CHANGE COLUMN required_8402_01_characters_guild_eventlog required_8402_02_characters_guild_bank_eventlog bit;
4 -- THIS SCRIPT DELETES table `guild_bank_eventlog` - MAKE BACKUP, if you need it.
6 DROP TABLE IF EXISTS `guild_bank_eventlog`;
7 CREATE TABLE `guild_bank_eventlog` (
8 `guildid` int(11) unsigned NOT NULL default '0' COMMENT 'Guild Identificator',
9 `LogGuid` int(11) unsigned NOT NULL default '0' COMMENT 'Log record identificator - auxiliary column',
10 `TabId` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Guild bank TabId',
11 `EventType` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Event type',
12 `PlayerGuid` int(11) unsigned NOT NULL default '0',
13 `ItemOrMoney` int(11) unsigned NOT NULL default '0',
14 `ItemStackCount` tinyint(3) unsigned NOT NULL default '0',
15 `DestTabId` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Destination Tab Id',
16 `TimeStamp` bigint(20) unsigned NOT NULL default '0' COMMENT 'Event UNIX time',
17 PRIMARY KEY (`guildid`,`LogGuid`,`TabId`),
18 KEY `guildid_key` (`guildid`)
19 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
21 -- The reason i decided for such dramatic change is that old guild_bank_eventlog table used `TabId` = 0 for Money events and
22 -- used `LogGuid` from 0 to infinity
23 -- New system uses `LogGuid` from 0 to number defined in config.