diff options
Diffstat (limited to 'prisma/migrations/06_session_data/migration.sql')
| -rw-r--r-- | prisma/migrations/06_session_data/migration.sql | 18 |
1 files changed, 18 insertions, 0 deletions
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"); |