text: -- CreateTable
  CREATE TABLE `Account` (
      `id` VARCHAR(191) NOT NULL,
      `userId` VARCHAR(191) NOT NULL,
      `providerType` VARCHAR(191) NOT NULL,
      `providerId` VARCHAR(191) NOT NULL,
      `providerAccountId` VARCHAR(191) NOT NULL,
      `refreshToken` VARCHAR(191),
      `accessToken` VARCHAR(191),
      `accessTokenExpires` DATETIME(3),
      `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
      `updatedAt` DATETIME(3) NOT NULL,
  
      UNIQUE INDEX `Account.providerId_providerAccountId_unique`(`providerId`, `providerAccountId`),
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `Content` (
      `id` VARCHAR(191) NOT NULL,
      `content_text` TEXT,
      `created_at` TIMESTAMP(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
      `userId` VARCHAR(191) NOT NULL,
      `image_id` VARCHAR(191),
      `numLikes` INTEGER NOT NULL DEFAULT 0,
      `numComments` INTEGER NOT NULL DEFAULT 0,
      `gif_url` VARCHAR(191),
  
      UNIQUE INDEX `Content_image_id_unique`(`image_id`),
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `Group` (
      `id` VARCHAR(191) NOT NULL,
      `group_name` VARCHAR(30) NOT NULL,
      `group_description` VARCHAR(255),
      `admin_id` VARCHAR(191) NOT NULL,
  
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `Image` (
      `id` VARCHAR(191) NOT NULL,
      `url` VARCHAR(255) NOT NULL,
  
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `Message` (
      `id` VARCHAR(191) NOT NULL,
      `created_at` TIMESTAMP(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
      `text_message` VARCHAR(255),
      `userId` VARCHAR(191) NOT NULL,
      `group_id` VARCHAR(191) NOT NULL,
      `image_id` VARCHAR(191),
      `gif_url` VARCHAR(191),
  
      UNIQUE INDEX `Message_image_id_unique`(`image_id`),
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `Session` (
      `id` VARCHAR(191) NOT NULL,
      `userId` VARCHAR(191) NOT NULL,
      `expires` DATETIME(3) NOT NULL,
      `sessionToken` VARCHAR(191) NOT NULL,
      `accessToken` VARCHAR(191) NOT NULL,
      `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
      `updatedAt` DATETIME(3) NOT NULL,
  
      UNIQUE INDEX `Session.sessionToken_unique`(`sessionToken`),
      UNIQUE INDEX `Session.accessToken_unique`(`accessToken`),
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `Hashtag` (
      `id` VARCHAR(191) NOT NULL,
      `text` VARCHAR(191) NOT NULL,
  
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `CommentOnHashtag` (
      `hashtagId` VARCHAR(191) NOT NULL,
      `commentId` VARCHAR(191) NOT NULL,
  
      PRIMARY KEY (`hashtagId`, `commentId`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `ContentOnHashtag` (
      `hashtagId` VARCHAR(191) NOT NULL,
      `contentId` VARCHAR(191) NOT NULL,
  
      PRIMARY KEY (`hashtagId`, `contentId`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `Comment` (
      `id` VARCHAR(191) NOT NULL,
      `content_id` VARCHAR(191) NOT NULL,
      `comment_text` VARCHAR(255) NOT NULL,
      `created_at` TIMESTAMP(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
      `userId` VARCHAR(191) NOT NULL,
      `numLikes` INTEGER NOT NULL DEFAULT 0,
      `gif_url` VARCHAR(191),
  
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `User_in_group` (
      `userId` VARCHAR(191) NOT NULL,
      `group_id` VARCHAR(191) NOT NULL,
  
      PRIMARY KEY (`userId`, `group_id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `User_liked_comment` (
      `userId` VARCHAR(191) NOT NULL,
      `comment_id` VARCHAR(191) NOT NULL,
  
      INDEX `LikedCommentIndex`(`userId`, `comment_id`),
      PRIMARY KEY (`userId`, `comment_id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `User_liked_content` (
      `userId` VARCHAR(191) NOT NULL,
      `content_id` VARCHAR(191) NOT NULL,
  
      INDEX `LikedContentIndex`(`userId`, `content_id`),
      PRIMARY KEY (`userId`, `content_id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `User` (
      `id` VARCHAR(191) NOT NULL,
      `name` VARCHAR(191) NOT NULL,
      `displayName` VARCHAR(25),
      `email` VARCHAR(191) NOT NULL,
      `emailVerified` DATETIME(3),
      `created_at` TIMESTAMP(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
      `updatedAt` DATETIME(3) NOT NULL,
      `image` VARCHAR(255) NOT NULL,
      `bannerUrl` VARCHAR(255),
      `bio` VARCHAR(255),
      `numFollowing` INTEGER NOT NULL DEFAULT 0,
      `numFollowers` INTEGER NOT NULL DEFAULT 0,
      `online` BOOLEAN DEFAULT false,
      `numContributions` INTEGER NOT NULL DEFAULT 0,
  
      UNIQUE INDEX `User.email_unique`(`email`),
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `VerificationRequest` (
      `id` VARCHAR(191) NOT NULL,
      `identifier` VARCHAR(191) NOT NULL,
      `token` VARCHAR(191) NOT NULL,
      `expires` DATETIME(3) NOT NULL,
      `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
      `updatedAt` DATETIME(3) NOT NULL,
  
      UNIQUE INDEX `VerificationRequest.token_unique`(`token`),
      UNIQUE INDEX `VerificationRequest.identifier_token_unique`(`identifier`, `token`),
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `_user1_blocked_user2` (
      `A` VARCHAR(191) NOT NULL,
      `B` VARCHAR(191) NOT NULL,
  
      UNIQUE INDEX `_user1_blocked_user2_AB_unique`(`A`, `B`),
      INDEX `_user1_blocked_user2_B_index`(`B`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `_user1_follows_user2` (
      `A` VARCHAR(191) NOT NULL,
      `B` VARCHAR(191) NOT NULL,
  
      UNIQUE INDEX `_user1_follows_user2_AB_unique`(`A`, `B`),
      INDEX `_user1_follows_user2_B_index`(`B`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- AddForeignKey
  ALTER TABLE `Account` ADD FOREIGN KEY (`userId`) REFERENCES `User`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `Content` ADD FOREIGN KEY (`image_id`) REFERENCES `Image`(`id`) ON DELETE SET NULL ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `Content` ADD FOREIGN KEY (`userId`) REFERENCES `User`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `Message` ADD FOREIGN KEY (`userId`) REFERENCES `User`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `Message` ADD FOREIGN KEY (`group_id`) REFERENCES `Group`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `Message` ADD FOREIGN KEY (`image_id`) REFERENCES `Image`(`id`) ON DELETE SET NULL ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `Session` ADD FOREIGN KEY (`userId`) REFERENCES `User`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `CommentOnHashtag` ADD FOREIGN KEY (`hashtagId`) REFERENCES `Hashtag`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `CommentOnHashtag` ADD FOREIGN KEY (`commentId`) REFERENCES `Comment`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `ContentOnHashtag` ADD FOREIGN KEY (`hashtagId`) REFERENCES `Hashtag`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `ContentOnHashtag` ADD FOREIGN KEY (`contentId`) REFERENCES `Content`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `Comment` ADD FOREIGN KEY (`content_id`) REFERENCES `Content`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `User_in_group` ADD FOREIGN KEY (`userId`) REFERENCES `User`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `User_in_group` ADD FOREIGN KEY (`group_id`) REFERENCES `Group`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `User_liked_comment` ADD FOREIGN KEY (`userId`) REFERENCES `User`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `User_liked_comment` ADD FOREIGN KEY (`comment_id`) REFERENCES `Comment`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `User_liked_content` ADD FOREIGN KEY (`userId`) REFERENCES `User`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `User_liked_content` ADD FOREIGN KEY (`content_id`) REFERENCES `Content`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `_user1_blocked_user2` ADD FOREIGN KEY (`A`) REFERENCES `User`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `_user1_blocked_user2` ADD FOREIGN KEY (`B`) REFERENCES `User`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `_user1_follows_user2` ADD FOREIGN KEY (`A`) REFERENCES `User`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `_user1_follows_user2` ADD FOREIGN KEY (`B`) REFERENCES `User`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  