Guild banklogs

From ArcEmu-Wiki
Jump to: navigation, search

Description

This table stores the logs for guild banks.


Contents



log_id

The id of the log.


guildid

The id of the guild.


tabid

The id of the tab.


action

player_guid

The Guid of the player.


item_entry

The entry id of the item.


stack_count

How much the player took.


timestamp

SQL Structure

CREATE TABLE `guild_banklogs` (
  `log_id` int(30) NOT NULL,
  `guildid` int(30) NOT NULL,
  `tabid` int(30) NOT NULL COMMENT 'tab 6 is money logs',
  `action` int(5) NOT NULL,
  `player_guid` int(30) NOT NULL,
  `item_entry` int(30) NOT NULL,
  `stack_count` int(30) NOT NULL,
  `timestamp` int(30) NOT NULL,
  PRIMARY KEY (`log_id`,`guildid`),
  KEY `a` (`guildid`),
  KEY `b` (`tabid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Personal tools