-- AlterTable: Eric answering the answer, and the thread that keeps both halves
ALTER TABLE "Investigation" ADD COLUMN "note" TEXT;
ALTER TABLE "Investigation" ADD COLUMN "noteAudio" TEXT;
ALTER TABLE "Investigation" ADD COLUMN "noteMime" TEXT;
ALTER TABLE "Investigation" ADD COLUMN "parentId" TEXT;

ALTER TABLE "Investigation" ADD CONSTRAINT "Investigation_parentId_fkey"
  FOREIGN KEY ("parentId") REFERENCES "Investigation"("id") ON DELETE SET NULL ON UPDATE CASCADE;

-- AlterTable: acknowledgement lives on the check, beside the truth rather than
-- replacing it
ALTER TABLE "HostCheck" ADD COLUMN "ackedAt" TIMESTAMP(3);
ALTER TABLE "HostCheck" ADD COLUMN "ackNote" TEXT;
ALTER TABLE "HostCheck" ADD COLUMN "ackSignature" TEXT;