Skip to content
Snippets Groups Projects

feat: add docker-compose and fix schema

Merged Jean-Pierre Péclard requested to merge f/add-docker-and-fix-schema into main
4 files
+ 40
13
Compare changes
  • Side-by-side
  • Inline
Files
4
@@ -15,7 +15,7 @@ CREATE TABLE "Account" (
"oauth_token_secret" TEXT,
"oauth_token" TEXT,
PRIMARY KEY ("id")
CONSTRAINT "Account_pkey" PRIMARY KEY ("id")
);
-- CreateTable
@@ -25,7 +25,7 @@ CREATE TABLE "Session" (
"userId" TEXT NOT NULL,
"expires" TIMESTAMP(3) NOT NULL,
PRIMARY KEY ("id")
CONSTRAINT "Session_pkey" PRIMARY KEY ("id")
);
-- CreateTable
@@ -36,7 +36,7 @@ CREATE TABLE "User" (
"emailVerified" TIMESTAMP(3),
"image" TEXT,
PRIMARY KEY ("id")
CONSTRAINT "User_pkey" PRIMARY KEY ("id")
);
-- CreateTable
@@ -47,22 +47,22 @@ CREATE TABLE "VerificationToken" (
);
-- CreateIndex
CREATE UNIQUE INDEX "Account.provider_providerAccountId_unique" ON "Account"("provider", "providerAccountId");
CREATE UNIQUE INDEX "Account_provider_providerAccountId_key" ON "Account"("provider", "providerAccountId");
-- CreateIndex
CREATE UNIQUE INDEX "Session.sessionToken_unique" ON "Session"("sessionToken");
CREATE UNIQUE INDEX "Session_sessionToken_key" ON "Session"("sessionToken");
-- CreateIndex
CREATE UNIQUE INDEX "User.email_unique" ON "User"("email");
CREATE UNIQUE INDEX "User_email_key" ON "User"("email");
-- CreateIndex
CREATE UNIQUE INDEX "VerificationToken.token_unique" ON "VerificationToken"("token");
CREATE UNIQUE INDEX "VerificationToken_token_key" ON "VerificationToken"("token");
-- CreateIndex
CREATE UNIQUE INDEX "VerificationToken.identifier_token_unique" ON "VerificationToken"("identifier", "token");
CREATE UNIQUE INDEX "VerificationToken_identifier_token_key" ON "VerificationToken"("identifier", "token");
-- AddForeignKey
ALTER TABLE "Account" ADD FOREIGN KEY ("userId") REFERENCES "User"("id") ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE "Account" ADD CONSTRAINT "Account_userId_fkey" FOREIGN KEY ("userId") REFERENCES "User"("id") ON DELETE CASCADE ON UPDATE CASCADE;
-- AddForeignKey
ALTER TABLE "Session" ADD FOREIGN KEY ("userId") REFERENCES "User"("id") ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE "Session" ADD CONSTRAINT "Session_userId_fkey" FOREIGN KEY ("userId") REFERENCES "User"("id") ON DELETE CASCADE ON UPDATE CASCADE;
Loading