xonecas.io
4436
Sl

sesame-labs-coding-assignment / files

sesame-labs-coding-assignment / api / prisma / migrations / 20230116011331_init / migration.sql

707 bytes
1-- CreateTable
2CREATE TABLE "User" (
3    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
4    "walletAddress" TEXT,
5    "discordTokenId" INTEGER,
6    "verified" BOOLEAN NOT NULL DEFAULT false,
7    "coupon" TEXT,
8    CONSTRAINT "User_discordTokenId_fkey" FOREIGN KEY ("discordTokenId") REFERENCES "DiscordToken" ("id") ON DELETE SET NULL ON UPDATE CASCADE
9);
10
11-- CreateTable
12CREATE TABLE "DiscordToken" (
13    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
14    "accessToken" TEXT NOT NULL,
15    "expiresIn" INTEGER NOT NULL,
16    "refreshToken" TEXT NOT NULL,
17    "scope" TEXT NOT NULL,
18    "tokenType" TEXT NOT NULL
19);
20
21-- CreateIndex
22CREATE UNIQUE INDEX "User_walletAddress_key" ON "User"("walletAddress");