Guild data

From ArcEmu-Wiki
Jump to: navigation, search

Description

This table stores information on guild data.


Contents



guildid

The id of the guild


playerid

The Guid of the player.


guildRank

The rank of the player.


publicNote

Public note of the player.


officerNote

Officer note of the player.


lastWithdrawReset

withdrawlsSinceLastReset

lastItemWithdrawReset0

itemWithdrawlsSinceLastReset0

lastItemWithdrawReset1

itemWithdrawlsSinceLastReset1

lastItemWithdrawReset2

itemWithdrawlsSinceLastReset2

lastItemWithdrawReset3

itemWithdrawlsSinceLastReset3

lastItemWithdrawReset4

itemWithdrawlsSinceLastReset4

lastItemWithdrawReset5

itemWithdrawlsSinceLastReset5

SQL Structure

CREATE TABLE `guild_data` (
  `guildid` int(30) NOT NULL,
  `playerid` int(30) NOT NULL,
  `guildRank` int(30) NOT NULL,
  `publicNote` varchar(300) NOT NULL,
  `officerNote` varchar(300) NOT NULL,
  `lastWithdrawReset` int(30) NOT NULL DEFAULT '0',
  `withdrawlsSinceLastReset` int(30) NOT NULL DEFAULT '0',
  `lastItemWithdrawReset0` int(30) NOT NULL DEFAULT '0',
  `itemWithdrawlsSinceLastReset0` int(30) NOT NULL DEFAULT '0',
  `lastItemWithdrawReset1` int(30) NOT NULL,
  `itemWithdrawlsSinceLastReset1` int(30) NOT NULL,
  `lastItemWithdrawReset2` int(30) NOT NULL,
  `itemWithdrawlsSinceLastReset2` int(30) NOT NULL,
  `lastItemWithdrawReset3` int(30) NOT NULL,
  `itemWithdrawlsSinceLastReset3` int(30) NOT NULL,
  `lastItemWithdrawReset4` int(30) NOT NULL,
  `itemWithdrawlsSinceLastReset4` int(30) NOT NULL,
  `lastItemWithdrawReset5` int(30) NOT NULL,
  `itemWithdrawlsSinceLastReset5` int(30) NOT NULL,
  KEY `a` (`guildid`),
  KEY `b` (`playerid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Personal tools