SHARE
TWEET

Untitled

a guest May 23rd, 2019 83 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- Drop constraints
  2. ALTER TABLE specialization_abilities DROP CONSTRAINT specialization_abilities_ability_id_fkey;
  3. ALTER TABLE characters_abilities DROP CONSTRAINT characters_abilities_ability_id_fkey;
  4. ALTER TABLE class_realm_abilities DROP CONSTRAINT class_realm_abilities_abilitiy_id_fkey;
  5. ALTER TABLE npc_template_abilities DROP CONSTRAINT npc_template_abilities_ability_id_fkey;
  6.  
  7. -- Move Detect Hidden to free up ID=42
  8. UPDATE abilities SET id=44 WHERE id=42;
  9. UPDATE specialization_abilities SET ability_id=44 WHERE ability_id=42;
  10.  
  11. -- Move Dirty Tricks to free up ID=204
  12. UPDATE abilities SET id=47 WHERE id=204;
  13. UPDATE specialization_abilities SET ability_id=47 WHERE ability_id=204;
  14.  
  15. -- Move Flurry to free up ID=258
  16. UPDATE abilities SET id=46 WHERE id=258;
  17. UPDATE specialization_abilities SET ability_id=46 WHERE ability_id=258;
  18.  
  19. -- Move CCImmunity to free up ID=310
  20. UPDATE abilities SET id=311 WHERE id=310;
  21. UPDATE specialization_abilities SET ability_id=311 WHERE ability_id=310;
  22.  
  23. -- Prevent Flight
  24. UPDATE abilities SET id=42 WHERE id=245;
  25. UPDATE specialization_abilities SET ability_id=42 WHERE ability_id=245;
  26.  
  27. -- Augmented Strength
  28. UPDATE abilities SET id=201 WHERE id=129;
  29. UPDATE specialization_abilities SET ability_id=201 WHERE ability_id=129;
  30.  
  31. -- Augmented Constitution
  32. UPDATE abilities SET id=203 WHERE id=158;
  33. UPDATE specialization_abilities SET ability_id=203 WHERE ability_id=158;
  34.  
  35. -- Augmented Quickness
  36. UPDATE abilities SET id=204 WHERE id=174;
  37. UPDATE specialization_abilities SET ability_id=204 WHERE ability_id=174;
  38.  
  39. -- Augmented Acuity
  40. UPDATE abilities SET id=205 WHERE id=194;
  41. UPDATE specialization_abilities SET ability_id=194 WHERE ability_id=194;
  42.  
  43. -- Long Wind
  44. UPDATE abilities SET id=206 WHERE id=213;
  45. UPDATE specialization_abilities SET ability_id=206 WHERE ability_id=213;
  46.  
  47. -- Physical Defense
  48. UPDATE abilities SET id=207 WHERE id=1037;
  49. UPDATE specialization_abilities SET ability_id=207 WHERE ability_id=1037;
  50.  
  51. -- Toughness
  52. UPDATE abilities SET id=209 WHERE id=259;
  53. UPDATE specialization_abilities SET ability_id=209 WHERE ability_id=259;
  54.  
  55. -- Ethereal Bond
  56. UPDATE abilities SET id=210 WHERE id=274;
  57. UPDATE specialization_abilities SET ability_id=210 WHERE ability_id=274;
  58.  
  59. -- Avoidance of Magic
  60. UPDATE abilities SET id=211 WHERE id=136;
  61. UPDATE specialization_abilities SET ability_id=211 WHERE ability_id=136;
  62.  
  63. -- Veil Recovery
  64. UPDATE abilities SET id=213 WHERE id=141;
  65. UPDATE specialization_abilities SET ability_id=213 WHERE ability_id=141;
  66.  
  67. -- Mastery of Pain
  68. UPDATE abilities SET id=216 WHERE id=146;
  69. UPDATE specialization_abilities SET ability_id=216 WHERE ability_id=146;
  70.  
  71. -- Wild Power
  72. UPDATE abilities SET id=217 WHERE id=147;
  73. UPDATE specialization_abilities SET ability_id=217 WHERE ability_id=147;
  74.  
  75. -- Wild Minion
  76. UPDATE abilities SET id=220 WHERE id=149;
  77. UPDATE specialization_abilities SET ability_id=220 WHERE ability_id=149;
  78.  
  79. -- Mastery of Stealth
  80. UPDATE abilities SET id=221 WHERE id=151;
  81. UPDATE specialization_abilities SET ability_id=221 WHERE ability_id=151;
  82.  
  83. -- Mastery of Magery
  84. UPDATE abilities SET id=224 WHERE id=161;
  85. UPDATE specialization_abilities SET ability_id=224 WHERE ability_id=161;
  86.  
  87. -- Falcon's Eye
  88. UPDATE abilities SET id=225 WHERE id=69;
  89. UPDATE specialization_abilities SET ability_id=225 WHERE ability_id=69;
  90.  
  91. -- Determination
  92. UPDATE abilities SET id=226 WHERE id=163;
  93. UPDATE specialization_abilities SET ability_id=226 WHERE ability_id=163;
  94.  
  95. -- Mastery of Focus
  96. UPDATE abilities SET id=227 WHERE id=1039;
  97. UPDATE specialization_abilities SET ability_id=227 WHERE ability_id=1039;
  98.  
  99. -- First Aid
  100. UPDATE abilities SET id=228 WHERE id=167;
  101. UPDATE specialization_abilities SET ability_id=228 WHERE ability_id=167;
  102.  
  103. -- Adrenaline Rush
  104. UPDATE abilities SET id=229 WHERE id=1038;
  105. UPDATE specialization_abilities SET ability_id=229 WHERE ability_id=1038;
  106.  
  107. -- Second Wind
  108. UPDATE abilities SET id=230 WHERE id=169;
  109. UPDATE specialization_abilities SET ability_id=230 WHERE ability_id=169;
  110.  
  111. -- Ignore Pain
  112. UPDATE abilities SET id=231 WHERE id=170;
  113. UPDATE specialization_abilities SET ability_id=231 WHERE ability_id=170;
  114.  
  115. -- Concentration
  116. UPDATE abilities SET id=237 WHERE id=176;
  117. UPDATE specialization_abilities SET ability_id=237 WHERE ability_id=176;
  118.  
  119. -- Mastery of Concentration
  120. UPDATE abilities SET id=238 WHERE id=178;
  121. UPDATE specialization_abilities SET ability_id=238 WHERE ability_id=176;
  122.  
  123. -- The Empty Mind
  124. UPDATE abilities SET id=239 WHERE id=181;
  125. UPDATE specialization_abilities SET ability_id=237 WHERE ability_id=181;
  126.  
  127. -- Mystic Crystal Lore
  128. UPDATE abilities SET id=240 WHERE id=184;
  129. UPDATE specialization_abilities SET ability_id=240 WHERE ability_id=184;
  130.  
  131. -- Raging Power
  132. UPDATE abilities SET id=241 WHERE id=187;
  133. UPDATE specialization_abilities SET ability_id=241 WHERE ability_id=187;
  134.  
  135. -- Purge
  136. UPDATE abilities SET id=242 WHERE id=188;
  137. UPDATE specialization_abilities SET ability_id=242 WHERE ability_id=188;
  138.  
  139. -- Reflex Attack
  140. UPDATE abilities SET id=243 WHERE id=189;
  141. UPDATE specialization_abilities SET ability_id=243 WHERE ability_id=189;
  142.  
  143. -- Viper
  144. UPDATE abilities SET id=244 WHERE id=190;
  145. UPDATE specialization_abilities SET ability_id=244 WHERE ability_id=190;
  146.  
  147. -- Barrier of Fortitude
  148. UPDATE abilities SET id=247 WHERE id=1036;
  149. UPDATE specialization_abilities SET ability_id=247 WHERE ability_id=1036;
  150.  
  151. -- Vehement Renewal
  152. UPDATE abilities SET id=248 WHERE id=1033;
  153. UPDATE specialization_abilities SET ability_id=248 WHERE ability_id=1033;
  154.  
  155. -- Perfect Recovery
  156. UPDATE abilities SET id=250 WHERE id=197;
  157. UPDATE specialization_abilities SET ability_id=250 WHERE ability_id=197;
  158.  
  159. -- Vanish
  160. UPDATE abilities SET id=251 WHERE id=199;
  161. UPDATE specialization_abilities SET ability_id=251 WHERE ability_id=199;
  162.  
  163. -- Speed of Sound
  164. UPDATE abilities SET id=252 WHERE id=202;
  165. UPDATE specialization_abilities SET ability_id=252 WHERE ability_id=202;
  166.  
  167. -- Anger of the Gods
  168. UPDATE abilities SET id=254 WHERE id=1035;
  169. UPDATE specialization_abilities SET ability_id=254 WHERE ability_id=1035;
  170.  
  171. -- Wrath of Champions
  172. UPDATE abilities SET id=255 WHERE id=1043;
  173. UPDATE specialization_abilities SET ability_id=255 WHERE ability_id=1043;
  174.  
  175. -- Volcanic Pillar
  176. UPDATE abilities SET id=256 WHERE id=208;
  177. UPDATE specialization_abilities SET ability_id=256 WHERE ability_id=208;
  178.  
  179. -- Decimation Trap
  180. UPDATE abilities SET id=257 WHERE id=1045;
  181. UPDATE specialization_abilities SET ability_id=257 WHERE ability_id=1045;
  182.  
  183. -- Thornweed Field
  184. UPDATE abilities SET id=259 WHERE id=215;
  185. UPDATE specialization_abilities SET ability_id=259 WHERE ability_id=215;
  186.  
  187. -- Ichor of the Deep
  188. UPDATE abilities SET id=260 WHERE id=219;
  189. UPDATE specialization_abilities SET ability_id=260 WHERE ability_id=219;
  190.  
  191. -- Bedazzling Aura
  192. UPDATE abilities SET id=261 WHERE id=1041;
  193. UPDATE specialization_abilities SET ability_id=261 WHERE ability_id=1041;
  194.  
  195. -- Juggernaut
  196. UPDATE abilities SET id=262 WHERE id=222;
  197. UPDATE specialization_abilities SET ability_id=262 WHERE ability_id=222;
  198.  
  199. -- Static Tempest
  200. UPDATE abilities SET id=263 WHERE id=223;
  201. UPDATE specialization_abilities SET ability_id=263 WHERE ability_id=223;
  202.  
  203. -- Dashing Defense
  204. UPDATE abilities SET id=264 WHERE id=1040;
  205. UPDATE specialization_abilities SET ability_id=264 WHERE ability_id=1040;
  206.  
  207. -- Dual Threat
  208. UPDATE abilities SET id=265 WHERE id=1042;
  209. UPDATE specialization_abilities SET ability_id=265 WHERE ability_id=1042;
  210.  
  211. -- Divine Intervention
  212. UPDATE abilities SET id=268 WHERE id=1044;
  213. UPDATE specialization_abilities SET ability_id=268 WHERE ability_id=1044;
  214.  
  215. -- Strike Prediction
  216. UPDATE abilities SET id=269 WHERE id=1034;
  217. UPDATE specialization_abilities SET ability_id=269 WHERE ability_id=1034;
  218.  
  219. -- Stoicism
  220. UPDATE abilities SET id=270 WHERE id=1031;
  221. UPDATE specialization_abilities SET ability_id=270 WHERE ability_id=1031;
  222.  
  223. -- Augmented Dexterity
  224. UPDATE abilities SET id=202 WHERE id=135;
  225. UPDATE specialization_abilities SET ability_id=202 WHERE ability_id=135;
  226.  
  227. -- Serenity
  228. UPDATE abilities SET id=208 WHERE id=246;
  229. UPDATE specialization_abilities SET ability_id=208 WHERE ability_id=246;
  230.  
  231. -- Mastery of Parrying
  232. UPDATE abilities SET id=215 WHERE id=144;
  233. UPDATE specialization_abilities SET ability_id=215 WHERE ability_id=144;
  234.  
  235. -- Wild Healing
  236. UPDATE abilities SET id=219 WHERE id=148;
  237. UPDATE specialization_abilities SET ability_id=219 WHERE ability_id=148;
  238.  
  239. -- Mastery of Healing
  240. UPDATE abilities SET id=223 WHERE id=159;
  241. UPDATE specialization_abilities SET ability_id=223 WHERE ability_id=159;
  242.  
  243. -- Soldier's Barricade
  244. UPDATE abilities SET id=246 WHERE id=171;
  245. UPDATE specialization_abilities SET ability_id=246 WHERE ability_id=171;
  246.  
  247. -- Ameliorating Melodies
  248. UPDATE abilities SET id=253 WHERE id=203;
  249. UPDATE specialization_abilities SET ability_id=253 WHERE ability_id=203;
  250.  
  251. -- Negative Maelstrom
  252. UPDATE abilities SET id=258 WHERE id=214;
  253. UPDATE specialization_abilities SET ability_id=258 WHERE ability_id=214;
  254.  
  255. -- Tireless
  256. UPDATE abilities SET id=310 WHERE id=212;
  257. UPDATE specialization_abilities SET ability_id=310 WHERE ability_id=212;
  258.  
  259. -- Lifter
  260. UPDATE abilities SET id=212 WHERE id=140;
  261. UPDATE specialization_abilities SET ability_id=212 WHERE ability_id=140;
  262.  
  263. -- Mastery of Blocking
  264. UPDATE abilities SET id=214 WHERE id=143;
  265. UPDATE specialization_abilities SET ability_id=214 WHERE ability_id=143;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top