Delete zones after velious

[minijag]

-- Delete zones from expansions after Velious
DELETE
FROM zone
WHERE zoneidnumber NOT IN (
1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,17,18,19,20,
21,22,23,24,25,25,27,29,30,31,32,33,34,35,36,37,38,39,40,
41,42,44,45,46,47,48,49,50,51,52,54,55,56,57,58,59,60,
61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,
81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,100,
101,102,103,104,105,106,107,108,110,111,112,113,114,115,116,117,118,119,120,
121,123,124,125,126,127,128,129);
-- Delete zone_points to zones from expansions after Velious
DELETE
FROM zone_points
WHERE target_zone_id NOT IN (
1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,17,18,19,20,
21,22,23,24,25,25,27,29,30,31,32,33,34,35,36,37,38,39,40,
41,42,44,45,46,47,48,49,50,51,52,54,55,56,57,58,59,60,
61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,
81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,100,
101,102,103,104,105,106,107,108,110,111,112,113,114,115,116,117,118,119,120,
121,123,124,125,126,127,128,129);
-- Delete the remaining zone_points that originate from post Velious expansions that point to old world, kunark, and Velious
DELETE
FROM zone_points
where zone IN ('eastwastesshard','breedinggrounds','feerrott2','brellsrest',
'oldfieldofbone','oldblackburrow','oldkithicor','oldcommons','oceangreenhills',
'steamfontmts','innothuleb','toxxulia','corathus','poknowledge','highpasshold',
'commonlands','mistythicket','delvea','broodlands','potimeb','potranquility',
'veksar','jaggedpine','potactics','chardokb','soldungc','nexus','gunthak','commons');
-- Deleting extra zones complete

-- Might need to remove traps as well.

-- Delete starting_zones data for everything after Velious
DELETE
FROM start_zones
WHERE start_zone > 129;

-- Delete ground_spawns data for everything after Velious
DELETE
FROM ground_spawns
WHERE zoneid NOT IN (
1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,17,18,19,20,
21,22,23,24,25,25,27,29,30,31,32,33,34,35,36,37,38,39,40,
41,42,44,45,46,47,48,49,50,51,52,54,55,56,57,58,59,60,
61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,
81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,100,
101,102,103,104,105,106,107,108,110,111,112,113,114,115,116,117,118,119,120,
121,123,124,125,126,127,128,129);

-- Delete forage data for all zones after Velious
DELETE
FROM forage
WHERE zoneid NOT IN (
1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,17,18,19,20,
21,22,23,24,25,25,27,29,30,31,32,33,34,35,36,37,38,39,40,
41,42,44,45,46,47,48,49,50,51,52,54,55,56,57,58,59,60,
61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,
81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,100,
101,102,103,104,105,106,107,108,110,111,112,113,114,115,116,117,118,119,120,
121,123,124,125,126,127,128,129);

-- Delete fishing data for all zones after Velious
DELETE
FROM fishing
WHERE zoneid NOT IN (
1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,17,18,19,20,
21,22,23,24,25,25,27,29,30,31,32,33,34,35,36,37,38,39,40,
41,42,44,45,46,47,48,49,50,51,52,54,55,56,57,58,59,60,
61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,
81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,100,
101,102,103,104,105,106,107,108,110,111,112,113,114,115,116,117,118,119,120,
121,123,124,125,126,127,128,129);