Areatrigger involvedrelation 548

From Project Skyfire
Jump to navigation Jump to search

Back to world database list of tables.

The `areatrigger_involvedrelations` table

This table holds the information for when an areatrigger completes an objective for a quest, such as an exploration quest.


Structure

Field Type Attribute Key Null Default Comment
id mediumint(8) unsigned PRI NO 0 Identifier
quest mediumint(8) unsigned NO 0 Quest Identifier


DB Structure

CREATE TABLE `areatrigger_involvedrelation` (
	`id` MEDIUMINT NOT NULL DEFAULT '0' COMMENT 'Identifier',
	`quest` MEDIUMINT NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
	PRIMARY KEY (`id`) USING BTREE
)
COMMENT='Trigger System'
COLLATE='utf8_general_ci'
ENGINE=MyISAM
ROW_FORMAT=FIXED
;


Description of the fields

id

The ID# of the areatrigger to use for the quest. Contained in AreaTrigger.dbc.

quest

The ID# of the quest that the areatrigger completes the objective. Contained in Quest_template