/home/mip/mip/database/migrations/client/2017_08_15_023814_create_locations_table.php
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateLocationsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('locations', function (Blueprint $table) {
$table->increments('id');
$table->string('category');
$table->integer('affiliate_id')->nullable();
$table->integer('specialization_id')->nullable();
$table->string('name');
$table->string('lat');
$table->string('lng');
$table->string('tel_no');
$table->string('email')->nullable();
$table->string('address_number');
$table->string('street');
$table->string('barangay');
$table->string('city_id')->nullable();
$table->integer('municipality_id')->nullable();
$table->string('province_id')->nullable();
$table->string('zip_code');
$table->longText('details');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('locations');
}
}