From bd9c2fefa8d2268b233cc0c15038ec1c9342db8c Mon Sep 17 00:00:00 2001 From: Drahy Date: Thu, 19 Feb 2009 01:38:54 +0100 Subject: * Moved sqls to proper directories again --HG-- branch : trunk --- sql/updates/444_world.sql | 37 ------------------------------------- 1 file changed, 37 deletions(-) delete mode 100644 sql/updates/444_world.sql (limited to 'sql/updates/444_world.sql') diff --git a/sql/updates/444_world.sql b/sql/updates/444_world.sql deleted file mode 100644 index b5d588c39fa..00000000000 --- a/sql/updates/444_world.sql +++ /dev/null @@ -1,37 +0,0 @@ -DROP TABLE IF EXISTS `waypoint_data`; - -CREATE TABLE `waypoint_data` ( - `id` int(10) unsigned NOT NULL default '0' COMMENT 'Creature GUID', - `point` 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', - `delay` int(10) unsigned NOT NULL default '0', - `move_flag` tinyint(1) NOT NULL default '0', - `action` int(11) NOT NULL default '0', - `action_chance` smallint(3) NOT NULL default '100', - `wpguid` int(11) NOT NULL default '0' -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -DROP TABLE IF EXISTS `waypoint_scripts`; - -CREATE TABLE `waypoint_scripts` ( - `id` int(11) unsigned NOT NULL default '0', - `delay` int(11) unsigned NOT NULL default '0', - `command` int(11) unsigned NOT NULL default '0', - `datalong` int(11) unsigned NOT NULL default '0', - `datalong2` int(11) unsigned NOT NULL default '0', - `dataint` int(11) unsigned NOT NULL default '0', - `x` float NOT NULL default '0', - `y` float NOT NULL default '0', - `z` float NOT NULL default '0', - `o` float NOT NULL default '0', - `guid` int(11) NOT NULL default '0', - PRIMARY KEY (`guid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -ALTER TABLE `creature_addon` - ADD `path_id` int(11) unsigned NOT NULL default '0' AFTER `guid`; -ALTER TABLE `creature_template_addon` - ADD `path_id` int(11) unsigned NOT NULL default '0' AFTER `entry`; - -- cgit v1.2.3