CreateTranslatorTables::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines	33
Code Lines	18

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

<?php
    public function up() {
        DB::beginTransaction();

        // Create table for storing roles
        Schema::create('translation_identifiers', function(Blueprint $table) {
            $table->increments('id')->unique();
            $table->text('identifier');

            $table->string('parameters', 512)->nullable();
            $table->string('group')->default('default');

            $table->string('page_name')->nullable();
            $table->text('description')->nullable();

            $table->timestamps();
        });

        // Create table for storing roles
        Schema::create('translations', function(Blueprint $table) {
            $table->integer('translation_identifier_id')->unsigned();
            $table->foreign('translation_identifier_id')->references('id')->on('translation_identifiers')->onDelete('cascade')->onUpdate('no action');

            $table->string('locale', 5);
            $table->primary(['translation_identifier_id', 'locale']);

            $table->text('translation');

            $table->timestamps();
        });

        DB::statement('ALTER TABLE `translations` CHANGE `updated_at` `updated_at` TIMESTAMP on update CURRENT_TIMESTAMP NULL DEFAULT NULL;');

        DB::commit();
    }