-- Alter 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;

ALTER TABLE specialization_abilities
ADD CONSTRAINT specialization_abilities_ability_id_fkey
FOREIGN KEY (ability_id) REFERENCES abilities(id) ON UPDATE CASCADE;

ALTER TABLE characters_abilities
ADD CONSTRAINT characters_abilities_ability_id_fkey
FOREIGN KEY (ability_id) REFERENCES abilities(id) ON UPDATE CASCADE;

ALTER TABLE class_realm_abilities
ADD CONSTRAINT class_realm_abilities_abilitiy_id_fkey
FOREIGN KEY (abilitiy_id) REFERENCES abilities(id) ON UPDATE CASCADE;

ALTER TABLE npc_template_abilities
ADD CONSTRAINT npc_template_abilities_ability_id_fkey
FOREIGN KEY (ability_id) REFERENCES abilities(id) ON UPDATE CASCADE;

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

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

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

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

-------------

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

------

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

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

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

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

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

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

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

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

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

-----

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

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

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