source: aowow/tools/sql/instances.sql

-- Alterac Valley
UPDATE aowow_zones SET areatableID=2597 WHERE mapID=30;

-- Shadowfang Keep
UPDATE aowow_zones SET areatableID=209 WHERE mapID=33;

-- Deadmines
UPDATE aowow_zones SET areatableID=1581 WHERE mapID=36;

-- Razorfen Kraul
UPDATE aowow_zones SET areatableID=491 WHERE mapID=47;

-- Razorfen Downs
UPDATE aowow_zones SET areatableID=722 WHERE mapID=129;

-- Emerald Dream
-- UPDATE aowow_zones SET areatableID=111 WHERE mapID=169;

-- Scarlet Monastery
UPDATE aowow_zones SET areatableID=796 WHERE mapID=189;

-- Zul'Farrak
UPDATE aowow_zones SET areatableID=978 WHERE mapID=209;

-- Opening of the Dark Portal
UPDATE aowow_zones SET areatableID=111 WHERE mapID=269;

-- Scholomance
UPDATE aowow_zones SET areatableID=2057 WHERE mapID=289;

-- Zul'Gurub
UPDATE aowow_zones SET areatableID=19 WHERE mapID=309;

-- Stratholme
UPDATE aowow_zones SET areatableID=2017 WHERE mapID=329;

-- Tempest Keep
UPDATE aowow_zones SET areatableID=3842 WHERE mapID=550;

-- Nagrand Arena
UPDATE aowow_zones SET areatableID=3698 WHERE mapID=559;

-- Black Temple
UPDATE aowow_zones SET areatableID=3959 WHERE mapID=564;

-- Eye of the Storm
UPDATE aowow_zones SET areatableID=3820 WHERE mapID=566;

-- Zul'Aman
UPDATE aowow_zones SET areatableID=3805 WHERE mapID=568;

-- Ruins of Lordaeron
UPDATE aowow_zones SET areatableID=3968 WHERE mapID=572;

-- The Sunwell
UPDATE aowow_zones SET areatableID=4075 WHERE mapID=580;

-- Magister's Terrace
UPDATE aowow_zones SET areatableID=4095 WHERE mapID=585;


-- Champions' Hall
INSERT INTO aowow_zones(mapID, areatableID, name) VALUES (449, 2918, "Champions' Hall");