aboutsummaryrefslogtreecommitdiff
path: root/sql/world_scripts_structure.sql
diff options
context:
space:
mode:
authorDrahy <none@none>2009-04-10 09:35:05 +0200
committerDrahy <none@none>2009-04-10 09:35:05 +0200
commitef5c5110877a79f1fb84727e246908ac40ac1b55 (patch)
treec9088c564d0a2672cf79be4d1d10c4937a2cf8b4 /sql/world_scripts_structure.sql
parent6d0b82676ca25d1fe1b796f3d19478c2b7fd163b (diff)
* 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
Diffstat (limited to 'sql/world_scripts_structure.sql')
-rw-r--r--sql/world_scripts_structure.sql16
1 files changed, 14 insertions, 2 deletions
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