1 ALTER TABLE db_version CHANGE COLUMN required_7720_01_mangos_mangos_string required_7776_01_mangos_npc_spellclick_spells bit;
3 CREATE TABLE `npc_spellclick_spells` (
4 `npc_entry` INT UNSIGNED NOT NULL COMMENT 'reference to creature_template',
5 `spell_id` INT UNSIGNED NOT NULL COMMENT 'spell which should be casted ',
6 `quest_id` INT UNSIGNED NOT NULL COMMENT 'reference to quest_template',
7 `cast_flags` TINYINT UNSIGNED NOT NULL COMMENT 'first bit defines caster: 1=player, 0=creature; second bit defines target, same mapping as caster bit'
8 ) ENGINE = MYISAM DEFAULT CHARSET=utf8;