1 ALTER TABLE `areatrigger_template`
2 DROP COLUMN `trigger_map`,
3 DROP COLUMN `trigger_position_x`,
4 DROP COLUMN `trigger_position_y`,
5 DROP COLUMN `trigger_position_z`;
8 DELETE FROM `areatrigger_template`
9 WHERE `required_level` = 0 AND `required_item` = 0
10 AND `target_map` = 0 AND `target_position_x` = 0 AND `target_position_y` = 0 AND `target_position_z` = 0 AND `target_orientation` = 0;
12 ALTER TABLE `areatrigger_template` RENAME TO `areatrigger_teleport`;