Guild bankitems

From ArcEmu-Wiki
Revision as of 20:30, 8 August 2010 by Alleycat (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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