-- CreateTable CREATE TABLE "SearchHistory" ( "id" SERIAL NOT NULL, "query" TEXT NOT NULL, "userId" INTEGER, CONSTRAINT "SearchHistory_pkey" PRIMARY KEY ("id") ); -- AddForeignKey ALTER TABLE "SearchHistory" ADD CONSTRAINT "SearchHistory_userId_fkey" FOREIGN KEY ("userId") REFERENCES "User"("id") ON DELETE SET NULL ON UPDATE CASCADE;