NilPortugues\Tests\App\Migrations\CreateEmployeesTable

Complexity

Total Complexity

3

Size/Duplication

Total Lines	40
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Importance

Changes	1
Bugs	0	Features	0

<?php
class CreateEmployeesTable extends Migration
{
    /**
     * Run the migrations.
     */
    public function up()
    {
        Schema::create('employees', function (Blueprint $table) {
            $table->integer('id', true);

            $table->string('company', 50)->nullable()->index('company');
            $table->string('last_name', 50)->nullable()->index('last_name');
            $table->string('first_name', 50)->nullable()->index('first_name');
            $table->string('email_address', 50)->nullable();
            $table->string('job_title', 50)->nullable();
            $table->string('business_phone', 25)->nullable();
            $table->string('home_phone', 25)->nullable();
            $table->string('mobile_phone', 25)->nullable();
            $table->string('fax_number', 25)->nullable();
            $table->text('address')->nullable();
            $table->string('city', 50)->nullable()->index('city');
            $table->string('state_province', 50)->nullable()->index('state_province');
            $table->string('zip_postal_code', 15)->nullable()->index('zip_postal_code');
            $table->string('country_region', 50)->nullable();
            $table->text('web_page')->nullable();
            $table->text('notes')->nullable();
            $table->binary('attachments')->nullable();
        });
    }

    /**
     * Reverse the migrations.
     */
    public function down()
    {
        if (Schema::hasTable('employees')) {
            Schema::drop('employees');
        }
    }
}