10 lines
450 B
MySQL
10 lines
450 B
MySQL
|
-- Reintroduce per-task assignment for lab workflow
|
||
|
|
|
||
|
|
ALTER TABLE "lab_case_tasks" ADD COLUMN "assigneeUserId" TEXT;
|
||
|
|
ALTER TABLE "lab_case_tasks" ADD COLUMN "assignedAt" TIMESTAMP(3);
|
||
|
|
|
||
|
|
ALTER TABLE "lab_case_tasks" ADD CONSTRAINT "lab_case_tasks_assigneeUserId_fkey"
|
||
|
|
FOREIGN KEY ("assigneeUserId") REFERENCES "users"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|
||
|
|
|
||
|
|
CREATE INDEX "lab_case_tasks_assigneeUserId_idx" ON "lab_case_tasks"("assigneeUserId");
|