From 396acf3bbbe00a192cb0ea0a9ccf91b1d8d2850b Mon Sep 17 00:00:00 2001 From: Fuwn <50817549+Fuwn@users.noreply.github.com> Date: Sat, 24 Jan 2026 13:09:50 +0000 Subject: Initial commit Created from https://vercel.com/new --- prisma/migrations/06_session_data/migration.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 prisma/migrations/06_session_data/migration.sql (limited to 'prisma/migrations/06_session_data/migration.sql') diff --git a/prisma/migrations/06_session_data/migration.sql b/prisma/migrations/06_session_data/migration.sql new file mode 100644 index 0000000..e15b260 --- /dev/null +++ b/prisma/migrations/06_session_data/migration.sql @@ -0,0 +1,18 @@ +-- DropIndex +DROP INDEX IF EXISTS "event_data_website_id_created_at_event_key_idx"; + +-- AlterTable +ALTER TABLE "event_data" RENAME COLUMN "event_key" TO "data_key"; + +-- AlterTable +ALTER TABLE "session_data" DROP COLUMN "deleted_at"; +ALTER TABLE "session_data" RENAME COLUMN "session_key" TO "data_key"; + +-- CreateIndex +CREATE INDEX "event_data_website_id_created_at_data_key_idx" ON "event_data"("website_id", "created_at", "data_key"); + +-- CreateIndex +CREATE INDEX "session_data_session_id_created_at_idx" ON "session_data"("session_id", "created_at"); + +-- CreateIndex +CREATE INDEX "session_data_website_id_created_at_data_key_idx" ON "session_data"("website_id", "created_at", "data_key"); -- cgit v1.2.3