kpt-pasture/migrator/v0001_demo.sql

CREATE TABLE IF NOT EXISTS `demo` (
   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键自增id',
   `created_at` bigint(20) unsigned NOT NULL COMMENT '创建时间',
   `updated_at` bigint(20) unsigned NOT NULL COMMENT '更新时间',
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='demo';



ALTER TABLE `kpt_pasture`.`app_pasture_list` 
ADD COLUMN `pasture_id` int(11) NULL COMMENT '饲喂系统牧场id' AFTER `updated_at`,
ADD COLUMN `pasture_url` varchar(80) NULL COMMENT '饲喂系统url' AFTER `pasture_id`;