migration.sql 400 B

1234567891011
  1. -- CreateTable
  2. CREATE TABLE `user` (
  3. `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  4. `username` VARCHAR(191) NOT NULL,
  5. `password` VARCHAR(191) NOT NULL,
  6. `email` VARCHAR(191) NOT NULL,
  7. `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  8. UNIQUE INDEX `user_username_key`(`username`),
  9. PRIMARY KEY (`id`)
  10. ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;