timegridio / concierge

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

class CreateServicesTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

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

            $table->increments('id');

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

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

            $table->string('slug');

            $table->string('name');

            $table->integer('duration')->unsigned()->default(60);

            $table->string('description');

            $table->string('prerequisites')->nullable();

            $table->string('color', 12)->nullable();

            $table->integer('type_id')->unsigned()->nullable()->after('id');

            $table->foreign('type_id')->references('id')->on('service_types')->onDelete('cascade');

            $table->softDeletes();

            $table->nullableTimestamps();

            $table->unique(['business_id', 'slug']);

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::drop('services');

    }

}

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

class CreateContactsTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

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

            $table->increments('id');

            $table->integer('user_id')->unsigned()->nullable();

            $table->foreign('user_id')->references('id')->on('users');

            $table->string('nin')->nullable()->index();

            $table->enum('gender', ['M', 'F']);

            $table->string('firstname');

            $table->string('lastname');

            $table->string('occupation')->nullable();

            $table->string('martial_status')->nullable();

            $table->string('postal_address')->nullable();

            $table->date('birthdate')->nullable();

            $table->char('mobile', 15)->nullable();

            $table->char('mobile_country', 2)->nullable();

            $table->string('email')->nullable();

            $table->nullableTimestamps();

            $table->softDeletes();

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::drop('contacts');

    }

}