prisma導入

npm install prisma --save-dev

npx prisma init

npx prisma db pull

CREATE TABLE IF NOT EXISTS `todos` (
    `id`         INT UNSIGNED AUTO_INCREMENT,
    `title`      TEXT NOT NULL,
    `status`     ENUM('pending', 'completed') DEFAULT 'pending',
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `update_at`  TIMESTAMP DEFAULT CURRENT_TIMESTAMP,

    PRIMARY KEY (`id`)
);

model todos {
  id         Int           @id @default(autoincrement()) @db.UnsignedInt
  title      String        @db.Text
  status     todos_status? @default(pending)
  created_at DateTime?     @default(now()) @db.Timestamp(0)
  update_at  DateTime?     @default(now()) @db.Timestamp(0)
}

enum todos_status {
  pending
  completed
}

grant create, alter, drop, references on *.* to user;