From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/guild.md | 220 +++++++++++++++++++++++++++++++++++++++++++++++++++++----- 1 file changed, 204 insertions(+), 16 deletions(-) (limited to 'docs/guild.md') diff --git a/docs/guild.md b/docs/guild.md index ff874f9..542d772 100644 --- a/docs/guild.md +++ b/docs/guild.md @@ -1,16 +1,204 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [guild](guild) - -Column | Type | Description ---- | --- | --- -Guildid | int(10) unsigned | -Name | varchar(24) | -Leaderguid | int(10) unsigned | -EmblemStyle | tinyint(3) unsigned | -EmblemColor | tinyint(3) unsigned | -BorderStyle | tinyint(3) unsigned | -BorderColor | tinyint(3) unsigned | -BackgroundColor | tinyint(3) unsigned | -Info | varchar(500) | -Motd | varchar(128) | -Createdate | int(10) unsigned | -BankMoney | bigint(20) unsigned | +# guild + +`Back-to:Characters` + +**The \`guild\` table** + +This table holds the main guild information. All created guilds or all guilds in the process of being created have a record in this table. + +**Structure** + + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guildid

int(10)

unsigned

PRI

NO

0

Unique

 

name

varchar(24)

signed

 

NO

"

 

 

leaderguid

int(10)

unsigned

 

NO

0

 

 

EmblemStyle

tinyint(3)

unsigned

 

NO

0

 

 

EmblemColor

tinyint(3)

unsigned

 

NO

0

 

 

BorderStyle

tinyint(3)

unsigned

 

NO

0

 

 

BorderColor

tinyint(3)

unsigned

 

NO

0

 

 

BackgroundColor

tinyint(3)

signed

 

NO

0

 

 

info

text

signed

 

NO

"

 

 

motd

varchar(128)

signed

 

NO

"

 

 

createdate

int(10)

unsigned

 

NO

0

 

 

BankMoney

bigint(20)

signed

 

NO

0

 

 

+ +**Description of the fields** + +### guildid + +The ID of the guild. This number is unique to each guild and is the main method to identify a guild. + +### name + +The guild name. + +### leaderguid + +The GUID of the character who created the guild. See characters.guid + +### EmblemStyle + +The emblem style of the guild tabard. + +### EmblemColor + +The emblem color of the guild tabard. + +### BorderStyle + +The border style of the guild tabard. + +### BorderColor + +The border color of the guild tabard. + +### BackgroundColor + +The background color of the guild tabard. + +### info + +The text message that appears in the Guild Information box. + +### motd + +The text that appears in the Message Of The Day box. + +### createdate + +The date when the guild was created. + +### BankMoney + +The total money, in copper, that is currently in the guild's guild bank. -- cgit