9 lines
334 B
SQL
9 lines
334 B
SQL
-- Add unique constraints for task completions per service/project
|
|
-- Matches Django's unique_task_per_service constraint
|
|
|
|
CREATE UNIQUE INDEX idx_service_task_completion_unique
|
|
ON service_task_completions(service_id, task_id);
|
|
|
|
CREATE UNIQUE INDEX idx_project_task_completion_unique
|
|
ON project_task_completions(project_id, task_id);
|