<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class ExtendedUsers extends Migration
{

    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('users', function (Blueprint $table) {
            $table->integer('gender');
            $table->timestamp('birthdate')->nullable()->after('failed_login_attempts');
            $table->string('street')->after('failed_login_attempts');
            $table->string('house_number')->after('failed_login_attempts');
            $table->string('postal_code')->after('failed_login_attempts');
            $table->string('city')->after('failed_login_attempts');
            $table->string('country')->after('failed_login_attempts');
            $table->string('telephone')->after('failed_login_attempts');
            $table->string('mobile')->after('failed_login_attempts');
            $table->string('bank_account_number')->after('failed_login_attempts');
            $table->timestamp('certificate_valid_trough_date')->nullable()->after('failed_login_attempts');;
            $table->timestamp('certificate_acquirement_date')->nullable()->after('failed_login_attempts');;
            $table->string('certificate_number')->after('failed_login_attempts');;
        });
    }


    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('users', function (Blueprint $table) {
            $table->dropColumn([
                'birthdate',
                'certificate_valid_trough_date',
                'certificate_acquirement_date',
                'street',
                'house_number',
                'postal_code',
                'city',
                'country',
                'telephone',
                'mobile',
                'bank_account_number',
            ]);
        });
    }
}