From ef5c5110877a79f1fb84727e246908ac40ac1b55 Mon Sep 17 00:00:00 2001 From: Drahy Date: Fri, 10 Apr 2009 09:35:05 +0200 Subject: * Added table script_waypoint and deleted non used files also from previous commits and make it in one file for better orientation, so please import after 2559 only 2565 --HG-- branch : trunk --- sql/world_scripts_structure.sql | 16 ++++++++++++++-- 1 file changed, 14 insertions(+), 2 deletions(-) (limited to 'sql/world_scripts_structure.sql') diff --git a/sql/world_scripts_structure.sql b/sql/world_scripts_structure.sql index 57556ff5910..7ac482bb493 100644 --- a/sql/world_scripts_structure.sql +++ b/sql/world_scripts_structure.sql @@ -98,9 +98,21 @@ CREATE TABLE IF NOT EXISTS `script_texts` ( PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts'; +DROP TABLE IF EXISTS script_waypoint; +CREATE TABLE script_waypoint ( + entry mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template entry', + pointid mediumint(8) unsigned NOT NULL DEFAULT '0', + location_x float NOT NULL DEFAULT '0', + location_y float NOT NULL DEFAULT '0', + location_z float NOT NULL DEFAULT '0', + waittime int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'waittime in millisecs', + point_comment text, + PRIMARY KEY (entry, pointid) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Creature waypoints'; + + DROP TABLE IF EXISTS `sd2_db_version`; DROP TABLE IF EXISTS `script_db_version`; CREATE TABLE `script_db_version` ( `version` varchar(255) NOT NULL default '' COMMENT 'Database version string' -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - +) ENGINE=MyISAM DEFAULT CHARSET=utf8; \ No newline at end of file -- cgit v1.2.3