timegridio / concierge

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

class CreateDomainsTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

        Schema::create('domains', function (Blueprint $table) {

            $table->increments('id');

            $table->string('slug', 50)->unique();

            $table->integer('owner_id')->unsigned();

            $table->foreign('owner_id')->references('id')->on('users')->onDelete('cascade');

            $table->nullableTimestamps();

            $table->softdeletes();

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::drop('domains');

    }

}

use Illuminate\Database\Migrations\Migration;

class CreateServiceTypesTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

        Schema::create('service_types', function ($table) {

            $table->increments('id');

            $table->integer('business_id')->unsigned();

            $table->foreign('business_id')->references('id')->on('businesses');

            $table->string('slug')->index();

            $table->string('name');

            $table->string('description');

            $table->nullableTimestamps();

            $table->softDeletes();

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::drop('service_types');

    }

}