-- CreateEnum
CREATE TYPE "BlockedEntryType" AS ENUM ('brand', 'blend');

-- CreateTable
CREATE TABLE "blocklist" (
    "id" TEXT NOT NULL,
    "type" "BlockedEntryType" NOT NULL,
    "name" TEXT NOT NULL,
    "note" TEXT,
    "blocked_by_user_id" TEXT NOT NULL,
    "created_at" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,

    CONSTRAINT "blocklist_pkey" PRIMARY KEY ("id")
);

-- CreateIndex
CREATE UNIQUE INDEX "blocklist_type_name_key" ON "blocklist"("type", "name");

-- AddForeignKey
ALTER TABLE "blocklist" ADD CONSTRAINT "blocklist_blocked_by_user_id_fkey" FOREIGN KEY ("blocked_by_user_id") REFERENCES "users"("id") ON DELETE RESTRICT ON UPDATE CASCADE;