text: -- CreateTable
  CREATE TABLE "User" (
      "id" TEXT NOT NULL,
      "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
      "updatedAt" TIMESTAMP(3) NOT NULL,
      "email" TEXT NOT NULL,
      "password" TEXT NOT NULL,
  
      PRIMARY KEY ("id")
  );
  
  -- CreateTable
  CREATE TABLE "Role" (
      "id" TEXT NOT NULL,
      "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
      "updatedAt" TIMESTAMP(3) NOT NULL,
      "name" TEXT NOT NULL,
  
      PRIMARY KEY ("id")
  );
  
  -- CreateTable
  CREATE TABLE "Host" (
      "id" TEXT NOT NULL,
      "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
      "updatedAt" TIMESTAMP(3) NOT NULL,
      "name" TEXT NOT NULL,
      "hostname" TEXT NOT NULL,
  
      PRIMARY KEY ("id")
  );
  
  -- CreateTable
  CREATE TABLE "Subrole" (
      "id" TEXT NOT NULL,
      "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
      "updatedAt" TIMESTAMP(3) NOT NULL,
      "username" TEXT NOT NULL,
      "hostId" TEXT NOT NULL,
      "roleId" TEXT NOT NULL,
  
      PRIMARY KEY ("id")
  );
  
  -- CreateTable
  CREATE TABLE "_RoleToUser" (
      "A" TEXT NOT NULL,
      "B" TEXT NOT NULL
  );
  
  -- CreateIndex
  CREATE UNIQUE INDEX "_RoleToUser_AB_unique" ON "_RoleToUser"("A", "B");
  
  -- CreateIndex
  CREATE INDEX "_RoleToUser_B_index" ON "_RoleToUser"("B");
  
  -- AddForeignKey
  ALTER TABLE "Subrole" ADD FOREIGN KEY ("roleId") REFERENCES "Role"("id") ON DELETE CASCADE ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE "Subrole" ADD FOREIGN KEY ("hostId") REFERENCES "Host"("id") ON DELETE CASCADE ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE "_RoleToUser" ADD FOREIGN KEY ("A") REFERENCES "Role"("id") ON DELETE CASCADE ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE "_RoleToUser" ADD FOREIGN KEY ("B") REFERENCES "User"("id") ON DELETE CASCADE ON UPDATE CASCADE;
  