toni
16 lines
469 B
SQL
16 lines
469 B
SQL
-- CreateTable
|
|
CREATE TABLE "PushSubscription" (
|
|
"id" UUID NOT NULL DEFAULT uuidv7(),
|
|
"endpoint" VARCHAR NOT NULL,
|
|
"expirationTime" DOUBLE PRECISION,
|
|
"userSubscriptionId" UUID,
|
|
"p256dh" VARCHAR NOT NULL,
|
|
"auth" VARCHAR NOT NULL,
|
|
"userId" VARCHAR NOT NULL,
|
|
|
|
CONSTRAINT "PushSubscription_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "PushSubscription_userSubscriptionId_key" ON "PushSubscription"("userSubscriptionId");
|