survey-sdgs/database/migrations/2021_09_12_221906_create_pr...

34 lines
686 B
PHP
Executable File

<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateProvinsiTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('provinsi', function (Blueprint $table) {
$table->id();
$table->string('nama');
$table->json('coordinate')->nullable();
$table->json('geojson')->nullable();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('provinsi');
}
}