8 lines
336 B
MySQL
8 lines
336 B
MySQL
|
-- Migration 020: Add UNIQUE constraint to exercise_skills
|
||
|
|
-- Fixes: "no unique or exclusion constraint matching the ON CONFLICT specification"
|
||
|
|
-- Required for ON CONFLICT (exercise_id, skill_id) in import_wiki.py
|
||
|
|
|
||
|
|
ALTER TABLE exercise_skills
|
||
|
|
ADD CONSTRAINT exercise_skills_exercise_skill_unique
|
||
|
|
UNIQUE (exercise_id, skill_id);
|