Files
openccb/services/cms-service/migrations/20260117000200_add_course_id_to_assets.sql

3 lines
144 B
SQL

ALTER TABLE assets ADD COLUMN course_id UUID REFERENCES courses(id) ON DELETE SET NULL;
CREATE INDEX idx_assets_course_id ON assets(course_id);