v0001_config_breed_status.sql 559 B

123456789
  1. CREATE TABLE `config_breed_status` (
  2. `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键Id自增',
  3. `name` varchar(255) NOT NULL DEFAULT '' COMMENT '名称',
  4. `remarks` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  5. `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否启用 1 启用 2 关闭',
  6. `created_at` bigint(20) unsigned NOT NULL COMMENT '创建时间',
  7. `updated_at` bigint(20) unsigned NOT NULL COMMENT '更新时间',
  8. PRIMARY KEY (`id`)
  9. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='繁殖状态表'