database/migrations/2018_07_03_091314_create_route_table.php
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
return new class extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up(): void
{
Schema::create('route', function (Blueprint $table) {
$table->unsignedInteger('device_id');
$table->string('context_name', 128);
$table->string('ipRouteDest', 39);
$table->string('ipRouteIfIndex', 256)->nullable();
$table->string('ipRouteMetric', 256);
$table->string('ipRouteNextHop', 39);
$table->string('ipRouteType', 256);
$table->string('ipRouteProto', 256);
$table->unsignedInteger('discoveredAt');
$table->string('ipRouteMask', 256);
$table->index(['device_id', 'context_name', 'ipRouteDest', 'ipRouteNextHop'], 'device');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down(): void
{
Schema::drop('route');
}
};