text: -- CreateTable
  CREATE TABLE `users` (
      `id` INTEGER NOT NULL AUTO_INCREMENT,
      `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
      `updated_at` DATETIME(3) NOT NULL,
      `email` VARCHAR(191) NOT NULL,
      `firstname` VARCHAR(191) NOT NULL,
      `lastname` VARCHAR(191) NOT NULL,
      `password` VARCHAR(191) NOT NULL,
      `role_id` INTEGER NOT NULL,
      `rookie_id` INTEGER NOT NULL,
  
      UNIQUE INDEX `users_email_rookie_id_key`(`email`, `rookie_id`),
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `roles` (
      `id` INTEGER NOT NULL AUTO_INCREMENT,
      `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
      `updated_at` DATETIME(3) NOT NULL,
      `title` VARCHAR(191) NOT NULL,
  
      UNIQUE INDEX `roles_title_key`(`title`),
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `reviews` (
      `id` INTEGER NOT NULL AUTO_INCREMENT,
      `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
      `updated_at` DATETIME(3) NOT NULL,
      `message` VARCHAR(1000) NOT NULL,
      `user_id` INTEGER NOT NULL,
  
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `subjects` (
      `id` INTEGER NOT NULL AUTO_INCREMENT,
      `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
      `updated_at` DATETIME(3) NOT NULL,
      `title` VARCHAR(191) NOT NULL,
  
      UNIQUE INDEX `subjects_title_key`(`title`),
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `contact_requests` (
      `id` INTEGER NOT NULL AUTO_INCREMENT,
      `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
      `updated_at` DATETIME(3) NOT NULL,
      `name` VARCHAR(191) NOT NULL,
      `email` VARCHAR(191) NOT NULL,
      `message` TEXT NOT NULL,
      `is_resolved` BOOLEAN NOT NULL DEFAULT false,
      `rookie_id` INTEGER NOT NULL,
  
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `tutoring_classes` (
      `id` INTEGER NOT NULL AUTO_INCREMENT,
      `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
      `updated_at` DATETIME(3) NOT NULL,
      `description` VARCHAR(500) NOT NULL,
      `teacher_id` INTEGER NOT NULL,
      `subject_id` INTEGER NOT NULL,
      `rookie_id` INTEGER NOT NULL,
  
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `enrolments` (
      `id` INTEGER NOT NULL AUTO_INCREMENT,
      `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
      `updated_at` DATETIME(3) NOT NULL,
      `student_id` INTEGER NOT NULL,
      `tutoring_class_id` INTEGER NOT NULL,
  
      UNIQUE INDEX `enrolments_student_id_tutoring_class_id_key`(`student_id`, `tutoring_class_id`),
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `rookies` (
      `id` INTEGER NOT NULL AUTO_INCREMENT,
      `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
      `updated_at` DATETIME(3) NOT NULL,
      `token` VARCHAR(191) NOT NULL,
  
      UNIQUE INDEX `rookies_token_key`(`token`),
      INDEX `rookies_token_idx`(`token`),
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- AddForeignKey
  ALTER TABLE `users` ADD CONSTRAINT `users_role_id_fkey` FOREIGN KEY (`role_id`) REFERENCES `roles`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `users` ADD CONSTRAINT `users_rookie_id_fkey` FOREIGN KEY (`rookie_id`) REFERENCES `rookies`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `reviews` ADD CONSTRAINT `reviews_user_id_fkey` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `contact_requests` ADD CONSTRAINT `contact_requests_rookie_id_fkey` FOREIGN KEY (`rookie_id`) REFERENCES `rookies`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `tutoring_classes` ADD CONSTRAINT `tutoring_classes_teacher_id_fkey` FOREIGN KEY (`teacher_id`) REFERENCES `users`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `tutoring_classes` ADD CONSTRAINT `tutoring_classes_subject_id_fkey` FOREIGN KEY (`subject_id`) REFERENCES `subjects`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `tutoring_classes` ADD CONSTRAINT `tutoring_classes_rookie_id_fkey` FOREIGN KEY (`rookie_id`) REFERENCES `rookies`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `enrolments` ADD CONSTRAINT `enrolments_student_id_fkey` FOREIGN KEY (`student_id`) REFERENCES `users`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `enrolments` ADD CONSTRAINT `enrolments_tutoring_class_id_fkey` FOREIGN KEY (`tutoring_class_id`) REFERENCES `tutoring_classes`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
  