From ef5c5110877a79f1fb84727e246908ac40ac1b55 Mon Sep 17 00:00:00 2001
From: Drahy <none@none>
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

