diff options
| -rw-r--r-- | sql/updates/3257_world_waypoint_data_converter.sql | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/sql/updates/3257_world_waypoint_data_converter.sql b/sql/updates/3257_world_waypoint_data_converter.sql index 3533f948747..4a620ad73f7 100644 --- a/sql/updates/3257_world_waypoint_data_converter.sql +++ b/sql/updates/3257_world_waypoint_data_converter.sql @@ -1,6 +1,15 @@ +ALTER TABLE creature_addon ADD INDEX ( `path_id` ); +ALTER TABLE waypoint_data ADD INDEX ( `id` ); + ALTER TABLE waypoint_data ADD COLUMN id_old int(10) unsigned NOT NULL default '0' COMMENT 'Creature GUID' AFTER wpguid; + UPDATE waypoint_data SET id_old=id; +ALTER TABLE waypoint_data ADD INDEX ( `id_old` ); + UPDATE waypoint_data,creature_addon SET waypoint_data.id=creature_addon.guid*10 WHERE creature_addon.path_id > 0 AND creature_addon.path_id=waypoint_data.id_old; UPDATE waypoint_data SET id = 1343801 WHERE id_old = 2084; UPDATE waypoint_scripts SET datalong = 1343801 WHERE id = 515; -ALTER TABLE waypoint_data DROP COLUMN id_old;
\ No newline at end of file + +ALTER TABLE waypoint_data DROP COLUMN id_old; +ALTER TABLE `creature_addon` DROP INDEX `path_id` ; +ALTER TABLE waypoint_data DROP INDEX `id`;
\ No newline at end of file |