-- Drop constraints
ALTER TABLE specialization_abilities DROP CONSTRAINT specialization_abilities_ability_id_fkey;
ALTER TABLE characters_abilities DROP CONSTRAINT characters_abilities_ability_id_fkey;
ALTER TABLE class_realm_abilities DROP CONSTRAINT class_realm_abilities_abilitiy_id_fkey;
ALTER TABLE npc_template_abilities DROP CONSTRAINT npc_template_abilities_ability_id_fkey;

-- Move Detect Hidden to free up ID=42
UPDATE abilities SET id=44 WHERE id=42;
UPDATE specialization_abilities SET ability_id=44 WHERE ability_id=42;

-- Move Dirty Tricks to free up ID=204
UPDATE abilities SET id=47 WHERE id=204;
UPDATE specialization_abilities SET ability_id=47 WHERE ability_id=204;

-- Move Flurry to free up ID=258
UPDATE abilities SET id=46 WHERE id=258;
UPDATE specialization_abilities SET ability_id=46 WHERE ability_id=258;

-- Move CCImmunity to free up ID=310
UPDATE abilities SET id=311 WHERE id=310;
UPDATE specialization_abilities SET ability_id=311 WHERE ability_id=310;

-- Prevent Flight
UPDATE abilities SET id=42 WHERE id=245;
UPDATE specialization_abilities SET ability_id=42 WHERE ability_id=245;

-- Augmented Strength
UPDATE abilities SET id=201 WHERE id=129;
UPDATE specialization_abilities SET ability_id=201 WHERE ability_id=129;

-- Augmented Constitution
UPDATE abilities SET id=203 WHERE id=158;
UPDATE specialization_abilities SET ability_id=203 WHERE ability_id=158;

-- Augmented Quickness
UPDATE abilities SET id=204 WHERE id=174;
UPDATE specialization_abilities SET ability_id=204 WHERE ability_id=174;

-- Augmented Acuity
UPDATE abilities SET id=205 WHERE id=194;
UPDATE specialization_abilities SET ability_id=194 WHERE ability_id=194;

-- Long Wind
UPDATE abilities SET id=206 WHERE id=213;
UPDATE specialization_abilities SET ability_id=206 WHERE ability_id=213;

-- Physical Defense
UPDATE abilities SET id=207 WHERE id=1037;
UPDATE specialization_abilities SET ability_id=207 WHERE ability_id=1037;

-- Toughness
UPDATE abilities SET id=209 WHERE id=259;
UPDATE specialization_abilities SET ability_id=209 WHERE ability_id=259;

-- Ethereal Bond
UPDATE abilities SET id=210 WHERE id=274;
UPDATE specialization_abilities SET ability_id=210 WHERE ability_id=274;

-- Avoidance of Magic
UPDATE abilities SET id=211 WHERE id=136;
UPDATE specialization_abilities SET ability_id=211 WHERE ability_id=136;

-- Veil Recovery
UPDATE abilities SET id=213 WHERE id=141;
UPDATE specialization_abilities SET ability_id=213 WHERE ability_id=141;

-- Mastery of Pain
UPDATE abilities SET id=216 WHERE id=146;
UPDATE specialization_abilities SET ability_id=216 WHERE ability_id=146;

-- Wild Power
UPDATE abilities SET id=217 WHERE id=147;
UPDATE specialization_abilities SET ability_id=217 WHERE ability_id=147;

-- Wild Minion
UPDATE abilities SET id=220 WHERE id=149;
UPDATE specialization_abilities SET ability_id=220 WHERE ability_id=149;

-- Mastery of Stealth
UPDATE abilities SET id=221 WHERE id=151;
UPDATE specialization_abilities SET ability_id=221 WHERE ability_id=151;

-- Mastery of Magery
UPDATE abilities SET id=224 WHERE id=161;
UPDATE specialization_abilities SET ability_id=224 WHERE ability_id=161;

-- Falcon's Eye
UPDATE abilities SET id=225 WHERE id=69;
UPDATE specialization_abilities SET ability_id=225 WHERE ability_id=69;

-- Determination
UPDATE abilities SET id=226 WHERE id=163;
UPDATE specialization_abilities SET ability_id=226 WHERE ability_id=163;

-- Mastery of Focus
UPDATE abilities SET id=227 WHERE id=1039;
UPDATE specialization_abilities SET ability_id=227 WHERE ability_id=1039;

-- First Aid
UPDATE abilities SET id=228 WHERE id=167;
UPDATE specialization_abilities SET ability_id=228 WHERE ability_id=167;

-- Adrenaline Rush
UPDATE abilities SET id=229 WHERE id=1038;
UPDATE specialization_abilities SET ability_id=229 WHERE ability_id=1038;

-- Second Wind
UPDATE abilities SET id=230 WHERE id=169;
UPDATE specialization_abilities SET ability_id=230 WHERE ability_id=169;

-- Ignore Pain
UPDATE abilities SET id=231 WHERE id=170;
UPDATE specialization_abilities SET ability_id=231 WHERE ability_id=170;

-- Concentration
UPDATE abilities SET id=237 WHERE id=176;
UPDATE specialization_abilities SET ability_id=237 WHERE ability_id=176;

-- Mastery of Concentration
UPDATE abilities SET id=238 WHERE id=178;
UPDATE specialization_abilities SET ability_id=238 WHERE ability_id=176;

-- The Empty Mind
UPDATE abilities SET id=239 WHERE id=181;
UPDATE specialization_abilities SET ability_id=237 WHERE ability_id=181;

-- Mystic Crystal Lore
UPDATE abilities SET id=240 WHERE id=184;
UPDATE specialization_abilities SET ability_id=240 WHERE ability_id=184;

-- Raging Power
UPDATE abilities SET id=241 WHERE id=187;
UPDATE specialization_abilities SET ability_id=241 WHERE ability_id=187;

-- Purge
UPDATE abilities SET id=242 WHERE id=188;
UPDATE specialization_abilities SET ability_id=242 WHERE ability_id=188;

-- Reflex Attack
UPDATE abilities SET id=243 WHERE id=189;
UPDATE specialization_abilities SET ability_id=243 WHERE ability_id=189;

-- Viper
UPDATE abilities SET id=244 WHERE id=190;
UPDATE specialization_abilities SET ability_id=244 WHERE ability_id=190;

-- Barrier of Fortitude
UPDATE abilities SET id=247 WHERE id=1036;
UPDATE specialization_abilities SET ability_id=247 WHERE ability_id=1036;

-- Vehement Renewal
UPDATE abilities SET id=248 WHERE id=1033;
UPDATE specialization_abilities SET ability_id=248 WHERE ability_id=1033;

-- Perfect Recovery
UPDATE abilities SET id=250 WHERE id=197;
UPDATE specialization_abilities SET ability_id=250 WHERE ability_id=197;

-- Vanish
UPDATE abilities SET id=251 WHERE id=199;
UPDATE specialization_abilities SET ability_id=251 WHERE ability_id=199;

-- Speed of Sound
UPDATE abilities SET id=252 WHERE id=202;
UPDATE specialization_abilities SET ability_id=252 WHERE ability_id=202;

-- Anger of the Gods
UPDATE abilities SET id=254 WHERE id=1035;
UPDATE specialization_abilities SET ability_id=254 WHERE ability_id=1035;

-- Wrath of Champions
UPDATE abilities SET id=255 WHERE id=1043;
UPDATE specialization_abilities SET ability_id=255 WHERE ability_id=1043;

-- Volcanic Pillar
UPDATE abilities SET id=256 WHERE id=208;
UPDATE specialization_abilities SET ability_id=256 WHERE ability_id=208;

-- Decimation Trap
UPDATE abilities SET id=257 WHERE id=1045;
UPDATE specialization_abilities SET ability_id=257 WHERE ability_id=1045;

-- Thornweed Field
UPDATE abilities SET id=259 WHERE id=215;
UPDATE specialization_abilities SET ability_id=259 WHERE ability_id=215;

-- Ichor of the Deep
UPDATE abilities SET id=260 WHERE id=219;
UPDATE specialization_abilities SET ability_id=260 WHERE ability_id=219;

-- Bedazzling Aura
UPDATE abilities SET id=261 WHERE id=1041;
UPDATE specialization_abilities SET ability_id=261 WHERE ability_id=1041;

-- Juggernaut
UPDATE abilities SET id=262 WHERE id=222;
UPDATE specialization_abilities SET ability_id=262 WHERE ability_id=222;

-- Static Tempest
UPDATE abilities SET id=263 WHERE id=223;
UPDATE specialization_abilities SET ability_id=263 WHERE ability_id=223;

-- Dashing Defense
UPDATE abilities SET id=264 WHERE id=1040;
UPDATE specialization_abilities SET ability_id=264 WHERE ability_id=1040;

-- Dual Threat
UPDATE abilities SET id=265 WHERE id=1042;
UPDATE specialization_abilities SET ability_id=265 WHERE ability_id=1042;

-- Divine Intervention
UPDATE abilities SET id=268 WHERE id=1044;
UPDATE specialization_abilities SET ability_id=268 WHERE ability_id=1044;

-- Strike Prediction
UPDATE abilities SET id=269 WHERE id=1034;
UPDATE specialization_abilities SET ability_id=269 WHERE ability_id=1034;

-- Stoicism
UPDATE abilities SET id=270 WHERE id=1031;
UPDATE specialization_abilities SET ability_id=270 WHERE ability_id=1031;

-- Augmented Dexterity
UPDATE abilities SET id=202 WHERE id=135;
UPDATE specialization_abilities SET ability_id=202 WHERE ability_id=135;

-- Serenity
UPDATE abilities SET id=208 WHERE id=246;
UPDATE specialization_abilities SET ability_id=208 WHERE ability_id=246;

-- Mastery of Parrying
UPDATE abilities SET id=215 WHERE id=144;
UPDATE specialization_abilities SET ability_id=215 WHERE ability_id=144;

-- Wild Healing
UPDATE abilities SET id=219 WHERE id=148;
UPDATE specialization_abilities SET ability_id=219 WHERE ability_id=148;

-- Mastery of Healing
UPDATE abilities SET id=223 WHERE id=159;
UPDATE specialization_abilities SET ability_id=223 WHERE ability_id=159;

-- Soldier's Barricade
UPDATE abilities SET id=246 WHERE id=171;
UPDATE specialization_abilities SET ability_id=246 WHERE ability_id=171;

-- Ameliorating Melodies
UPDATE abilities SET id=253 WHERE id=203;
UPDATE specialization_abilities SET ability_id=253 WHERE ability_id=203;

-- Negative Maelstrom
UPDATE abilities SET id=258 WHERE id=214;
UPDATE specialization_abilities SET ability_id=258 WHERE ability_id=214;

-- Tireless
UPDATE abilities SET id=310 WHERE id=212;
UPDATE specialization_abilities SET ability_id=310 WHERE ability_id=212;

-- Lifter
UPDATE abilities SET id=212 WHERE id=140;
UPDATE specialization_abilities SET ability_id=212 WHERE ability_id=140;

-- Mastery of Blocking
UPDATE abilities SET id=214 WHERE id=143;
UPDATE specialization_abilities SET ability_id=214 WHERE ability_id=143;