1 ALTER TABLE db_version CHANGE COLUMN required_9891_01_mangos_creature_movement required_9891_02_mangos_creature_movement_scripts bit;
3 DROP TABLE IF EXISTS `creature_movement_scripts`;
4 CREATE TABLE `creature_movement_scripts` (
5 `id` mediumint(8) unsigned NOT NULL default '0',
6 `delay` int(10) unsigned NOT NULL default '0',
7 `command` mediumint(8) unsigned NOT NULL default '0',
8 `datalong` mediumint(8) unsigned NOT NULL default '0',
9 `datalong2` int(10) unsigned NOT NULL default '0',
10 `datalong3` int(10) unsigned NOT NULL default '0',
11 `datalong4` int(10) unsigned NOT NULL default '0',
12 `data_flags` tinyint(3) unsigned NOT NULL default '0',
13 `dataint` int(11) NOT NULL default '0',
14 `x` float NOT NULL default '0',
15 `y` float NOT NULL default '0',
16 `z` float NOT NULL default '0',
17 `o` float NOT NULL default '0'
18 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;