Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateEarthquakesTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('earthquakes', function (Blueprint $table) {
$table->id();
$table->float('latitude');
$table->float('longitude');
$table->float('depth');
$table->float('md')->nullable();//Generally empty
$table->float('ml');
$table->float('mw')->nullable();//Generally empty
$table->string('region');
$table->timestamp('happened_at');
$table->string('hash')->index('hash');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('earthquakes');
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment