Guild bankitems

From ArcEmu-Wiki
Jump to: navigation, search

Description

This table stores information, such as tab and slot location, for the items in guild banks.


Contents



guildId

The id of the guild that this item belongs to.

tabId

The id of the tab in which this item is contained.

slotId

The id of the slot in which the item is contained.

itemGuid

The item Guid.


SQL Structure

CREATE TABLE `guild_bankitems` (
  `guildId` int(30) NOT NULL,
  `tabId` int(30) NOT NULL,
  `slotId` int(30) NOT NULL,
  `itemGuid` int(30) NOT NULL,
  PRIMARY KEY (`guildId`,`tabId`,`slotId`),
  KEY `a` (`guildId`),
  KEY `b` (`tabId`),
  KEY `c` (`slotId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Personal tools