Spaces:

oex2003
/

evolution-api

Runtime error

evolution-api / prisma /postgresql-migrations /20240725184147_create_template_table /migration.sql

oex2003

Deploy Evolution API to Hugging Face Space

5e518ea about 1 year ago

690 Bytes

-- CreateTable
CREATE TABLE "Template" (
    "id" TEXT NOT NULL,
    "templateId" VARCHAR(255) NOT NULL,
    "name" VARCHAR(255) NOT NULL,
    "template" JSONB NOT NULL,
    "createdAt" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    "updatedAt" TIMESTAMP NOT NULL,
    "instanceId" TEXT NOT NULL,

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

-- CreateIndex
CREATE UNIQUE INDEX "Template_templateId_key" ON "Template"("templateId");

-- CreateIndex
CREATE UNIQUE INDEX "Template_name_key" ON "Template"("name");

-- AddForeignKey
ALTER TABLE "Template" ADD CONSTRAINT "Template_instanceId_fkey" FOREIGN KEY ("instanceId") REFERENCES "Instance"("id") ON DELETE CASCADE ON UPDATE CASCADE;

	-- CreateTable
	CREATE TABLE "Template" (
	"id" TEXT NOT NULL,
	"templateId" VARCHAR(255) NOT NULL,
	"name" VARCHAR(255) NOT NULL,
	"template" JSONB NOT NULL,
	"createdAt" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
	"updatedAt" TIMESTAMP NOT NULL,
	"instanceId" TEXT NOT NULL,

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

	-- CreateIndex
	CREATE UNIQUE INDEX "Template_templateId_key" ON "Template"("templateId");

	-- CreateIndex
	CREATE UNIQUE INDEX "Template_name_key" ON "Template"("name");

	-- AddForeignKey
	ALTER TABLE "Template" ADD CONSTRAINT "Template_instanceId_fkey" FOREIGN KEY ("instanceId") REFERENCES "Instance"("id") ON DELETE CASCADE ON UPDATE CASCADE;