2 DROP TABLE IF EXISTS `spell_teleport`;
3 CREATE TABLE `spell_teleport` (
4 `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
5 `target_map` int(11) unsigned NOT NULL default '0',
6 `target_position_x` float NOT NULL default '0',
7 `target_position_y` float NOT NULL default '0',
8 `target_position_z` float NOT NULL default '0',
9 `target_orientation` float NOT NULL default '0',
11 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell System';
13 INSERT INTO `spell_teleport`
14 SELECT `id`,`target_map`,`target_position_x`,`target_position_y`,`target_position_z`,`target_orientation`
15 FROM `areatrigger_teleport`;
17 DELETE FROM `spell_teleport` WHERE `target_position_x` = 0 AND `target_position_y` = 0 AND `target_position_z` = 0;