CreateSitecTranslationsTable

Complexity

Total Complexity

5

Size/Duplication

Total Lines	86
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	up()	0	46	4
A	down()	0	5	1

<?php


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

This use statement conflicts with another class in this namespace, Schema. Consider defining an alias.

class CreateSitecTranslationsTable extends Migration
{

    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        //     if (!Schema::hasColumn('flights', 'departure_time')) {
        //   $table->timestamp('departure_time');
        //     }
        if (!Schema::hasTable('countries')) {
            Schema::create(
                'countries', function (Blueprint $table) {
                    $table->string('code')->unique();
                    $table->primary('code');
                    $table->string('name', 255);
    
                    $table->timestamps();
                    $table->softDeletes();
                }
            );
        }
        if (!Schema::hasTable('languages')) {
            Schema::create(
                'languages', function (Blueprint $table) {
                    $table->engine = 'InnoDB';
                    $table->string('code')->unique();
                    $table->primary('code');

                    $table->integer('position')->nullable();
                    $table->string('name', 255);
                    $table->boolean('is_default')->default(false);

                    $table->timestamps();
                    $table->softDeletes();
                }
            );
        }
        if (!Schema::hasTable('locales')) {
            Schema::create(
                'locales', function (Blueprint $table) {
                    $table->string('language_code');
                    $table->string('country_code')->nullable();
                
                    $table->primary(['language_code','country_code']);

                    $table->foreign('language_code')->references('code')->on('languages');
                    $table->foreign('country_code')->references('code')->on('countries');

                    $table->timestamps();
                    $table->softDeletes();
                }
            );
        }

        // Schema::create('translations', function (Blueprint $table) {
        //     $table->increments('id');
        //     $table->timestamps();
        //     $table->integer('locale_id')->unsigned();
        //     $table->integer('translation_id')->unsigned()->nullable();
        //     $table->text('translation');

        //     $table->foreign('locale_id')->references('id')->on('locales')
        //         ->onUpdate('restrict')
        //         ->onDelete('cascade');

        //     $table->foreign('translation_id')->references('id')->on('translations')
        //         ->onUpdate('restrict')
        //         ->onDelete('cascade');
        // });

    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('locations');
        Schema::dropIfExists('languages');
        Schema::dropIfExists('locales');
    }
}