diff options
author | Drahy <none@none> | 2009-02-19 01:38:54 +0100 |
---|---|---|
committer | Drahy <none@none> | 2009-02-19 01:38:54 +0100 |
commit | bd9c2fefa8d2268b233cc0c15038ec1c9342db8c (patch) | |
tree | 7226c1c5b8fe9bf2f38f009b288de3851e8e65d9 /sql/updates/444_world.sql | |
parent | 13fd0ed366d250c59b46825628e0507e6dc21489 (diff) |
* Moved sqls to proper directories again
--HG--
branch : trunk
Diffstat (limited to 'sql/updates/444_world.sql')
-rw-r--r-- | sql/updates/444_world.sql | 37 |
1 files changed, 0 insertions, 37 deletions
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`; - |