1 ALTER TABLE db_version CHANGE COLUMN required_7622_01_mangos_creature_ai_scripts required_7622_02_mangos_creature_ai_summons bit;
4 DROP TABLE IF EXISTS `creature_ai_summons`;
5 CREATE TABLE `creature_ai_summons` (
6 `id` int(11) unsigned NOT NULL COMMENT 'Location Identifier' AUTO_INCREMENT,
7 `position_x` float NOT NULL default '0',
8 `position_y` float NOT NULL default '0',
9 `position_z` float NOT NULL default '0',
10 `orientation` float NOT NULL default '0',
11 `spawntimesecs` int(11) unsigned NOT NULL default '120',
12 `comment` varchar(255) NOT NULL default '' COMMENT 'Summon Comment',
14 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Summoning Locations';