-- Generalize attachments: any file type (mime/name), optional thumbnail,
-- and attach points on focus items + checklist items.
ALTER TABLE "Attachment" ALTER COLUMN "thumbPath" DROP NOT NULL;
ALTER TABLE "Attachment" ADD COLUMN "mime" TEXT;
ALTER TABLE "Attachment" ADD COLUMN "name" TEXT;
ALTER TABLE "Attachment" ADD COLUMN "focusItemId" TEXT;
ALTER TABLE "Attachment" ADD COLUMN "checklistItemId" TEXT;
ALTER TABLE "Attachment" ADD CONSTRAINT "Attachment_focusItemId_fkey"
    FOREIGN KEY ("focusItemId") REFERENCES "FocusItem"("id") ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE "Attachment" ADD CONSTRAINT "Attachment_checklistItemId_fkey"
    FOREIGN KEY ("checklistItemId") REFERENCES "ChecklistItem"("id") ON DELETE CASCADE ON UPDATE CASCADE;