diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/10320_world_smart_scripts.sql | 32 | ||||
| -rw-r--r-- | sql/updates/10320_world_waypoints.sql | 10 |
2 files changed, 42 insertions, 0 deletions
diff --git a/sql/updates/10320_world_smart_scripts.sql b/sql/updates/10320_world_smart_scripts.sql new file mode 100644 index 00000000000..99fdaf747a0 --- /dev/null +++ b/sql/updates/10320_world_smart_scripts.sql @@ -0,0 +1,32 @@ +DROP TABLE IF EXISTS smart_scripts; +CREATE TABLE `smart_scripts` ( + `entryorguid` mediumint(11) NOT NULL, + `source_type` mediumint(5) unsigned NOT NULL DEFAULT '0', + `id` mediumint(11) unsigned NOT NULL DEFAULT '0', + `link` mediumint(11) unsigned NOT NULL DEFAULT '0', + `event_type` mediumint(5) unsigned NOT NULL DEFAULT '0', + `event_phase_mask` mediumint(11) unsigned NOT NULL DEFAULT '0', + `event_chance` mediumint(5) unsigned NOT NULL DEFAULT '100', + `event_flags` mediumint(11) unsigned NOT NULL DEFAULT '0', + `event_param1` mediumint(11) unsigned NOT NULL DEFAULT '0', + `event_param2` mediumint(11) unsigned NOT NULL DEFAULT '0', + `event_param3` mediumint(11) unsigned NOT NULL DEFAULT '0', + `event_param4` mediumint(11) unsigned NOT NULL DEFAULT '0', + `action_type` mediumint(5) unsigned NOT NULL DEFAULT '0', + `action_param1` mediumint(11) unsigned NOT NULL DEFAULT '0', + `action_param2` mediumint(11) unsigned NOT NULL DEFAULT '0', + `action_param3` mediumint(11) unsigned NOT NULL DEFAULT '0', + `action_param4` mediumint(11) unsigned NOT NULL DEFAULT '0', + `action_param5` mediumint(11) unsigned NOT NULL DEFAULT '0', + `action_param6` mediumint(11) unsigned NOT NULL DEFAULT '0', + `target_type` mediumint(11) unsigned NOT NULL DEFAULT '0', + `target_param1` mediumint(11) unsigned NOT NULL DEFAULT '0', + `target_param2` mediumint(11) unsigned NOT NULL DEFAULT '0', + `target_param3` mediumint(11) unsigned NOT NULL DEFAULT '0', + `target_x` float NOT NULL DEFAULT '0', + `target_y` float NOT NULL DEFAULT '0', + `target_z` float NOT NULL DEFAULT '0', + `target_o` float NOT NULL DEFAULT '0', + `comment` varchar(255) NOT NULL DEFAULT '' COMMENT 'Event Comment', + PRIMARY KEY (`entryorguid`,`source_type`,`id`,`link`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; diff --git a/sql/updates/10320_world_waypoints.sql b/sql/updates/10320_world_waypoints.sql new file mode 100644 index 00000000000..6fc27aa9d9c --- /dev/null +++ b/sql/updates/10320_world_waypoints.sql @@ -0,0 +1,10 @@ +DROP TABLE IF EXISTS waypoints; +CREATE TABLE `waypoints` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `pointid` mediumint(8) unsigned NOT NULL DEFAULT '0', + `position_x` float NOT NULL DEFAULT '0', + `position_y` float NOT NULL DEFAULT '0', + `position_z` float NOT NULL DEFAULT '0', + `point_comment` text, + PRIMARY KEY (`entry`,`pointid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature waypoints'; |