text: -- CreateTable
  CREATE TABLE "users" (
      "id" TEXT NOT NULL,
      "name" VARCHAR(255) NOT NULL,
      "username" VARCHAR(255) NOT NULL,
      "email" VARCHAR(255) NOT NULL,
      "password" VARCHAR(255) NOT NULL,
      "github_id" TEXT NOT NULL,
      "github_username" VARCHAR(255) NOT NULL,
      "github_profile" TEXT NOT NULL,
      "bio" TEXT NOT NULL,
      "avatar_url" TEXT,
      "banner_url" TEXT,
      "website" TEXT,
      "location" TEXT,
      "date_of_birth" TIMESTAMP(3),
      "is_disabled" BOOLEAN NOT NULL DEFAULT false,
      "created_at" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
      "updated_at" TIMESTAMP(3) NOT NULL,
  
      CONSTRAINT "users_pkey" PRIMARY KEY ("id")
  );
  
  -- CreateTable
  CREATE TABLE "followers" (
      "id" TEXT NOT NULL,
      "follower_id" TEXT NOT NULL,
      "followed_id" TEXT NOT NULL,
      "created_at" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  
      CONSTRAINT "followers_pkey" PRIMARY KEY ("id")
  );
  
  -- CreateTable
  CREATE TABLE "posts" (
      "id" TEXT NOT NULL,
      "content" TEXT NOT NULL,
      "author_id" TEXT NOT NULL,
      "created_at" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
      "updated_at" TIMESTAMP(3) NOT NULL,
  
      CONSTRAINT "posts_pkey" PRIMARY KEY ("id")
  );
  
  -- CreateTable
  CREATE TABLE "posts_likes" (
      "id" TEXT NOT NULL,
      "post_id" TEXT NOT NULL,
      "author_id" TEXT NOT NULL,
      "created_at" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  
      CONSTRAINT "posts_likes_pkey" PRIMARY KEY ("id")
  );
  
  -- CreateTable
  CREATE TABLE "posts_dislikes" (
      "id" TEXT NOT NULL,
      "post_id" TEXT NOT NULL,
      "author_id" TEXT NOT NULL,
      "created_at" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  
      CONSTRAINT "posts_dislikes_pkey" PRIMARY KEY ("id")
  );
  
  -- CreateTable
  CREATE TABLE "posts_comments" (
      "id" TEXT NOT NULL,
      "post_id" TEXT NOT NULL,
      "author_id" TEXT NOT NULL,
      "content" TEXT NOT NULL,
      "created_at" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
      "updated_at" TIMESTAMP(3) NOT NULL,
  
      CONSTRAINT "posts_comments_pkey" PRIMARY KEY ("id")
  );
  
  -- CreateIndex
  CREATE UNIQUE INDEX "users_username_key" ON "users"("username");
  
  -- CreateIndex
  CREATE UNIQUE INDEX "users_email_key" ON "users"("email");
  
  -- CreateIndex
  CREATE UNIQUE INDEX "users_github_id_key" ON "users"("github_id");
  
  -- CreateIndex
  CREATE UNIQUE INDEX "users_github_username_key" ON "users"("github_username");
  
  -- CreateIndex
  CREATE UNIQUE INDEX "users_username_github_id_email_key" ON "users"("username", "github_id", "email");
  
  -- AddForeignKey
  ALTER TABLE "followers" ADD CONSTRAINT "followers_follower_id_fkey" FOREIGN KEY ("follower_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION;
  
  -- AddForeignKey
  ALTER TABLE "followers" ADD CONSTRAINT "followers_followed_id_fkey" FOREIGN KEY ("followed_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION;
  
  -- AddForeignKey
  ALTER TABLE "posts" ADD CONSTRAINT "posts_author_id_fkey" FOREIGN KEY ("author_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION;
  
  -- AddForeignKey
  ALTER TABLE "posts_likes" ADD CONSTRAINT "posts_likes_post_id_fkey" FOREIGN KEY ("post_id") REFERENCES "posts"("id") ON DELETE CASCADE ON UPDATE NO ACTION;
  
  -- AddForeignKey
  ALTER TABLE "posts_likes" ADD CONSTRAINT "posts_likes_author_id_fkey" FOREIGN KEY ("author_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION;
  
  -- AddForeignKey
  ALTER TABLE "posts_dislikes" ADD CONSTRAINT "posts_dislikes_post_id_fkey" FOREIGN KEY ("post_id") REFERENCES "posts"("id") ON DELETE CASCADE ON UPDATE NO ACTION;
  
  -- AddForeignKey
  ALTER TABLE "posts_dislikes" ADD CONSTRAINT "posts_dislikes_author_id_fkey" FOREIGN KEY ("author_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION;
  
  -- AddForeignKey
  ALTER TABLE "posts_comments" ADD CONSTRAINT "posts_comments_post_id_fkey" FOREIGN KEY ("post_id") REFERENCES "posts"("id") ON DELETE CASCADE ON UPDATE NO ACTION;
  
  -- AddForeignKey
  ALTER TABLE "posts_comments" ADD CONSTRAINT "posts_comments_author_id_fkey" FOREIGN KEY ("author_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION;
  