text: -- CreateTable
  CREATE TABLE "comments" (
      "id" UUID NOT NULL,
      "message" TEXT NOT NULL,
      "createdAt" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
      "updatedAt" TIMESTAMPTZ(6) NOT NULL,
      "taskId" UUID,
      "authorId" UUID,
  
      PRIMARY KEY ("id")
  );
  
  -- CreateTable
  CREATE TABLE "projects" (
      "id" UUID NOT NULL,
      "title" VARCHAR(255) NOT NULL,
      "accessibility" BOOLEAN DEFAULT false,
      "createdAt" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
      "updatedAt" TIMESTAMPTZ(6) NOT NULL,
      "owner" UUID,
  
      PRIMARY KEY ("id")
  );
  
  -- CreateTable
  CREATE TABLE "sections" (
      "id" UUID NOT NULL,
      "title" VARCHAR(255) NOT NULL,
      "order" SERIAL NOT NULL,
      "createdAt" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
      "updatedAt" TIMESTAMPTZ(6) NOT NULL,
      "projectId" UUID,
  
      PRIMARY KEY ("id")
  );
  
  -- CreateTable
  CREATE TABLE "tasks" (
      "id" UUID NOT NULL,
      "title" VARCHAR(255) NOT NULL,
      "dueDate" TIMESTAMPTZ(6),
      "description" TEXT,
      "createdAt" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
      "updatedAt" TIMESTAMPTZ(6) NOT NULL,
      "sectionId" UUID,
  
      PRIMARY KEY ("id")
  );
  
  -- CreateTable
  CREATE TABLE "users" (
      "id" UUID NOT NULL,
      "email" VARCHAR(255) NOT NULL,
      "password" VARCHAR(255),
      "name" VARCHAR(255) DEFAULT E'unknown',
      "role" VARCHAR(255) DEFAULT E'user',
      "reset_token" VARCHAR(255),
      "reset_token_expires" TIMESTAMPTZ(6),
      "createdAt" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
      "updatedAt" TIMESTAMPTZ(6) NOT NULL,
  
      PRIMARY KEY ("id")
  );
  
  -- CreateIndex
  CREATE UNIQUE INDEX "sections.order_unique" ON "sections"("order");
  
  -- CreateIndex
  CREATE UNIQUE INDEX "users.email_unique" ON "users"("email");
  
  -- AddForeignKey
  ALTER TABLE "comments" ADD FOREIGN KEY ("authorId") REFERENCES "users"("id") ON DELETE SET NULL ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE "comments" ADD FOREIGN KEY ("taskId") REFERENCES "tasks"("id") ON DELETE SET NULL ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE "projects" ADD FOREIGN KEY ("owner") REFERENCES "users"("id") ON DELETE SET NULL ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE "sections" ADD FOREIGN KEY ("projectId") REFERENCES "projects"("id") ON DELETE SET NULL ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE "tasks" ADD FOREIGN KEY ("sectionId") REFERENCES "sections"("id") ON DELETE SET NULL ON UPDATE CASCADE;
  