Skip to content

An AI-powered search engine with a generative UI

523 B
Raw Blame
ALTER TABLE "parts" ADD COLUMN IF NOT EXISTS "file_key" text;
ALTER TABLE "files" ADD COLUMN IF NOT EXISTS "object_key" text;

CREATE INDEX IF NOT EXISTS "files_object_key_idx" ON "files" USING btree ("object_key");

ALTER TABLE "parts" DROP CONSTRAINT IF EXISTS "file_fields_required";
ALTER TABLE "parts" ADD CONSTRAINT "file_fields_required"
  CHECK (
    (type != 'file')
    OR (
      file_media_type IS NOT NULL
      AND file_filename IS NOT NULL
      AND (file_key IS NOT NULL OR file_url IS NOT NULL)
    )
  );