github.com/tuingking/flamingo@v0.0.0-20220403134817-2796ae0e84ca/script/migrations/000002_product_schema.up.sql (about)

     1  CREATE TABLE IF NOT EXISTS `product` (
     2    `id`              bigint          NOT NULL AUTO_INCREMENT,
     3    `name`            varchar(250)    CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
     4    `price`           DECIMAL(18,4)   NOT NULL DEFAULT 0,
     5    `created_at`      timestamp(6)    NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
     6    `updated_at`      timestamp(6)    NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
     7    PRIMARY KEY (`id`)
     8  ) ENGINE=InnoDB;