20220109130532_create_stream_media_table.php 582 B

12345678910111213141516171819202122
  1. <?php
  2. declare(strict_types=1);
  3. use Phinx\Migration\AbstractMigration;
  4. final class CreateStreamMediaTable extends AbstractMigration
  5. {
  6. public function up(): void
  7. {
  8. $table = $this->table('stream_media');
  9. $table->addColumn('node_id', 'integer', ['comment' => '节点id'])
  10. ->addColumn('result', 'text', ['comment' => '检测结果'])
  11. ->addColumn('created_at', 'integer', ['comment' => '创建时间'])
  12. ->create();
  13. }
  14. public function down(): void
  15. {
  16. $this->table('stream_media')->drop()->update();
  17. }
  18. }