| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142 |
- -- CreateSchema
- CREATE SCHEMA IF NOT EXISTS "public";
- -- CreateEnum
- CREATE TYPE "WorkspaceTier" AS ENUM ('FREE', 'PRO');
- -- CreateEnum
- CREATE TYPE "ContributorStatus" AS ENUM ('INVITED', 'SUBMITTED', 'NOT_SUBMITTED');
- -- CreateTable
- CREATE TABLE "Workspace" (
- "id" TEXT NOT NULL,
- "name" TEXT NOT NULL,
- "slug" TEXT NOT NULL,
- "sector" TEXT,
- "companySize" INTEGER,
- "contactEmail" TEXT,
- "tier" "WorkspaceTier" NOT NULL DEFAULT 'FREE',
- "llmCallsThisMonth" INTEGER NOT NULL DEFAULT 0,
- "llmCallsResetAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
- "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
- "updatedAt" TIMESTAMP(3) NOT NULL,
- "ownerId" TEXT NOT NULL,
- CONSTRAINT "Workspace_pkey" PRIMARY KEY ("id")
- );
- -- CreateTable
- CREATE TABLE "Contributor" (
- "id" TEXT NOT NULL,
- "workspaceId" TEXT NOT NULL,
- "email" TEXT NOT NULL,
- "status" "ContributorStatus" NOT NULL DEFAULT 'INVITED',
- "invitedAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
- "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
- CONSTRAINT "Contributor_pkey" PRIMARY KEY ("id")
- );
- -- CreateTable
- CREATE TABLE "Post" (
- "id" SERIAL NOT NULL,
- "name" TEXT NOT NULL,
- "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
- "updatedAt" TIMESTAMP(3) NOT NULL,
- "createdById" TEXT NOT NULL,
- CONSTRAINT "Post_pkey" PRIMARY KEY ("id")
- );
- -- CreateTable
- CREATE TABLE "Account" (
- "id" TEXT NOT NULL,
- "userId" TEXT NOT NULL,
- "type" TEXT NOT NULL,
- "provider" TEXT NOT NULL,
- "providerAccountId" TEXT NOT NULL,
- "refresh_token" TEXT,
- "access_token" TEXT,
- "expires_at" INTEGER,
- "token_type" TEXT,
- "scope" TEXT,
- "id_token" TEXT,
- "session_state" TEXT,
- "refresh_token_expires_in" INTEGER,
- CONSTRAINT "Account_pkey" PRIMARY KEY ("id")
- );
- -- CreateTable
- CREATE TABLE "Session" (
- "id" TEXT NOT NULL,
- "sessionToken" TEXT NOT NULL,
- "userId" TEXT NOT NULL,
- "expires" TIMESTAMP(3) NOT NULL,
- CONSTRAINT "Session_pkey" PRIMARY KEY ("id")
- );
- -- CreateTable
- CREATE TABLE "User" (
- "id" TEXT NOT NULL,
- "name" TEXT,
- "email" TEXT,
- "emailVerified" TIMESTAMP(3),
- "password" TEXT,
- "image" TEXT,
- CONSTRAINT "User_pkey" PRIMARY KEY ("id")
- );
- -- CreateTable
- CREATE TABLE "VerificationToken" (
- "identifier" TEXT NOT NULL,
- "token" TEXT NOT NULL,
- "expires" TIMESTAMP(3) NOT NULL
- );
- -- CreateIndex
- CREATE UNIQUE INDEX "Workspace_slug_key" ON "Workspace"("slug");
- -- CreateIndex
- CREATE UNIQUE INDEX "Workspace_ownerId_key" ON "Workspace"("ownerId");
- -- CreateIndex
- CREATE INDEX "Contributor_workspaceId_idx" ON "Contributor"("workspaceId");
- -- CreateIndex
- CREATE UNIQUE INDEX "Contributor_workspaceId_email_key" ON "Contributor"("workspaceId", "email");
- -- CreateIndex
- CREATE INDEX "Post_name_idx" ON "Post"("name");
- -- CreateIndex
- CREATE UNIQUE INDEX "Account_provider_providerAccountId_key" ON "Account"("provider", "providerAccountId");
- -- CreateIndex
- CREATE UNIQUE INDEX "Session_sessionToken_key" ON "Session"("sessionToken");
- -- CreateIndex
- CREATE UNIQUE INDEX "User_email_key" ON "User"("email");
- -- CreateIndex
- CREATE UNIQUE INDEX "VerificationToken_token_key" ON "VerificationToken"("token");
- -- CreateIndex
- CREATE UNIQUE INDEX "VerificationToken_identifier_token_key" ON "VerificationToken"("identifier", "token");
- -- AddForeignKey
- ALTER TABLE "Workspace" ADD CONSTRAINT "Workspace_ownerId_fkey" FOREIGN KEY ("ownerId") REFERENCES "User"("id") ON DELETE CASCADE ON UPDATE CASCADE;
- -- AddForeignKey
- ALTER TABLE "Contributor" ADD CONSTRAINT "Contributor_workspaceId_fkey" FOREIGN KEY ("workspaceId") REFERENCES "Workspace"("id") ON DELETE CASCADE ON UPDATE CASCADE;
- -- AddForeignKey
- ALTER TABLE "Post" ADD CONSTRAINT "Post_createdById_fkey" FOREIGN KEY ("createdById") REFERENCES "User"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
- -- AddForeignKey
- 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 CONSTRAINT "Session_userId_fkey" FOREIGN KEY ("userId") REFERENCES "User"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|