migration.sql 4.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
  1. /*
  2. Add missing values to enums to prepare for schema alignment
  3. */
  4. -- Add missing values to ExerciseAttributeValueEnum
  5. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'BODYWEIGHT';
  6. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'POWERLIFTING';
  7. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'CALISTHENIC';
  8. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'STRETCHING';
  9. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'STRONGMAN';
  10. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'STABILIZATION';
  11. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'POWER';
  12. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'RESISTANCE';
  13. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'WEIGHTLIFTING';
  14. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'BICEPS';
  15. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'CHEST';
  16. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'BACK';
  17. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'TRICEPS';
  18. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'CALVES';
  19. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'TRAPS';
  20. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'ABDOMINALS';
  21. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'NECK';
  22. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'LATS';
  23. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'ADDUCTORS';
  24. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'ABDUCTORS';
  25. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'OBLIQUES';
  26. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'GROIN';
  27. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'ROTATOR_CUFF';
  28. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'HIP_FLEXOR';
  29. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'ACHILLES_TENDON';
  30. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'FINGERS';
  31. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'DUMBBELL';
  32. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'KETTLEBELLS';
  33. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'SMITH_MACHINE';
  34. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'BODY_ONLY';
  35. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'OTHER';
  36. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'BANDS';
  37. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'EZ_BAR';
  38. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'MACHINE';
  39. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'DESK';
  40. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'PULLUP_BAR';
  41. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'NONE';
  42. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'MEDICINE_BALL';
  43. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'SWISS_BALL';
  44. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'FOAM_ROLL';
  45. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'WEIGHT_PLATE';
  46. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'TRX';
  47. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'BOX';
  48. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'ROPES';
  49. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'SPIN_BIKE';
  50. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'STEP';
  51. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'BOSU';
  52. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'TYRE';
  53. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'SANDBAG';
  54. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'POLE';
  55. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'WALL';
  56. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'RACK';
  57. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'CAR';
  58. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'SLED';
  59. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'CHAIN';
  60. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'SKIERG';
  61. ALTER TYPE "ExerciseAttributeValueEnum" ADD VALUE IF NOT EXISTS 'NA';
  62. -- Add missing values to ExerciseAttributeNameEnum (if needed)
  63. ALTER TYPE "ExerciseAttributeNameEnum" ADD VALUE IF NOT EXISTS 'TYPE';
  64. ALTER TYPE "ExerciseAttributeNameEnum" ADD VALUE IF NOT EXISTS 'PRIMARY_MUSCLE';
  65. ALTER TYPE "ExerciseAttributeNameEnum" ADD VALUE IF NOT EXISTS 'SECONDARY_MUSCLE';
  66. ALTER TYPE "ExerciseAttributeNameEnum" ADD VALUE IF NOT EXISTS 'EQUIPMENT';
  67. ALTER TYPE "ExerciseAttributeNameEnum" ADD VALUE IF NOT EXISTS 'MECHANICS_TYPE';