1 ALTER TABLE db_version CHANGE COLUMN required_7988_09_mangos_spell_proc_event required_8016_01_mangos_npc_spellclick_spells bit;
3 ALTER TABLE npc_spellclick_spells
4 CHANGE COLUMN quest_id quest_start mediumint(8) unsigned NOT NULL COMMENT 'reference to quest_template',
5 ADD COLUMN quest_start_active tinyint(1) unsigned NOT NULL default '0' AFTER quest_start,
6 ADD COLUMN quest_end mediumint(8) unsigned NOT NULL default '0' AFTER quest_start_active;
8 /* compatibility with old data */
9 UPDATE npc_spellclick_spells
10 SET quest_end = quest_start, quest_start_active = 1
11 WHERE quest_start <> 0;