GuildsTable

UE	Field	Type	Key Type	Default	Extra	Description
	id	int(11)	PRI		auto_increment
	name	varchar(25)	UNI
	char_id_founder	int(10)		0
	web_page	varchar(255)
	date_created	datetime		0000-00-00 00:00:00
	karma_points	int(10)		0
	secret_ind	char(1)
	max_guild_points	int(10)		100		Stores the maximum amount of gp allowed for assignment in this guild
	motd	char(200)
	alliance	int(11)
	bank_money_circles	int(10) unsigned		0
	bank_money_octas	int(10) unsigned		0
	bank_money_hexas	int(10) unsigned		0
	bank_money_trias	int(10) unsigned		0
ADD	housetype	varchar(100)				Describes the type of guildhouse, example gugguild, ojaguild, ... If empty this guild has no guildhouse
ADD	houseid	int(11)		-1		Incremental instance guildhouse number
ADD	house_dev_owned	int(11)		0		If 1, then points to a guildhouse managed by devs and not players (example Hydlaa Museum)
ADD	housedoorid	int(11)		-1		The actionlocation id representing the entrance to the guildhouse
ADD	housemasterkeyid	int(11)		-1		The psitem ID representing the master key for this guildhouse
ADD	houselockid	int(11)		-1		The psitem ID representing the lock for the guildhouse door
ADD	houseflags	varchar(100)				Unlocked features for the guildhouse (HEAL, MUSICHALL, FEASTHALL,...)