Charters

From ArcEmu-Wiki
Jump to: navigation, search

Description

This table contains guild charter information.


Contents



charterId

The ID of the charter


charterType

I guess the type of the charter


leaderGuid

The Guid of the leader.

It refers to the characters table column guid.


guildName

The name of the guild on the charter


itemGuid

The Guid of the charter


signer1

Name of signer number 1


signer2

Name of signer number 2


signer3

Name of signer number 3


signer4

Name of signer number 4


signer5

Name of signer number 5


signer6

Name of signer number 6


signer7

Name of signer number 7


signer8

Name of signer number 8


signer9

Name of signer number 9

SQL Structure

CREATE TABLE `charters` (
  `charterId` int(30) NOT NULL,
  `charterType` int(30) NOT NULL DEFAULT '0',
  `leaderGuid` int(20) unsigned NOT NULL DEFAULT '0',
  `guildName` varchar(32) NOT NULL DEFAULT '',
  `itemGuid` bigint(40) unsigned NOT NULL DEFAULT '0',
  `signer1` int(10) unsigned NOT NULL DEFAULT '0',
  `signer2` int(10) unsigned NOT NULL DEFAULT '0',
  `signer3` int(10) unsigned NOT NULL DEFAULT '0',
  `signer4` int(10) unsigned NOT NULL DEFAULT '0',
  `signer5` int(10) unsigned NOT NULL DEFAULT '0',
  `signer6` int(10) unsigned NOT NULL DEFAULT '0',
  `signer7` int(10) unsigned NOT NULL DEFAULT '0',
  `signer8` int(10) unsigned NOT NULL DEFAULT '0',
  `signer9` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`charterId`),
  UNIQUE KEY `leaderGuid` (`charterType`,`leaderGuid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 11264 kB; InnoDB free: 18432 kB';
Personal tools