my-idlers/database/migrations/2022_02_05_104551_create_disk_speed_table.php

43 lines
1.1 KiB
PHP
Raw Permalink Normal View History

<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateDiskSpeedTable extends Migration
{
/**
* @return void
*/
public function up()
{
Schema::create('disk_speed', function (Blueprint $table) {
2022-03-05 16:58:25 +01:00
$table->char('id', 8)->primary();
$table->char('server_id',8);
$table->float('d_4k');
$table->char('d_4k_type',4);
$table->float('d_4k_as_mbps');
$table->float('d_64k');
$table->char('d_64k_type',4);
$table->float('d_64k_as_mbps');
$table->float('d_512k');
$table->char('d_512k_type',4);
$table->float('d_512k_as_mbps');
$table->float('d_1m');
$table->char('d_1m_type',4);
$table->float('d_1m_as_mbps');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('disk_speed');
}
}