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;