Laravel-Schema für PostgreSQL-Sequenz

Dies sind meine Anforderungen:

  1. Ich habe eine Tabelle(upload_training_files)
  2. Die Felder sind id, organisation_id(außen), year_id(ausländische), created_by, created_at, updated_by, updated_at, file_path.
  3. Die organisation_id Feld bezieht sich auf id Bereich der organisations. Es sollte auto_incremented und auch identifizieren sollten mit einer Sequenz-Tabelle(upload_training_file_organisation_id_fk_seq).

Habe ich versäumt, dies zu tun in Laravel nach wiederholten versuchen. Das ist mein schema:

<?php

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

    class CreateUploadTrainingFileTable extends Migration {

    public function up()
    {
        Schema::create('upload_training_file', function(Blueprint $table) {
            $table->bigincrements('id');
            $table->biginteger('organisation_id_fk')->unsigned()->unique();
            $table->foreign('organisation_id_fk')->references('organisation_id')->on('organisations');
            $table->biginteger('year_id_fk')->unsigned()->unique();
            $table->foreign('year_id_fk')->references('year_id')->on('year_of_performance');
            $table->biginteger('created_by')->nullable();
            $table->time('created_at')->nullable();
            $table->biginteger('updated_by');
            $table->time('updated_at')->nullable();
            $table->string('file_path')->nullable();
        });
    }

    public function down()
    {
        Schema::drop('upload_training_file');
    }
}

Hier ist der snapshot der Datenbank-Tabelle
Laravel-Schema für PostgreSQL-Sequenz

InformationsquelleAutor Nasif Md. Tanjim | 2015-03-11

  1. 1

    Gelöst. 🙂

    Sie haben, um die drop Primärschlüssel, bevor Sie die Zuweisung jeder neuen auto increment Feld.

    <?php

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

class CreateUploadTrainingFileTable extends Migration {

    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('upload_training_file', function(Blueprint $table) {
            $table->bigincrements('upload_training_file_id');
        });

        Schema::table('upload_training_file', function($table)
        {
            $table->dropPrimary('upload_training_file_upload_training_file_id_primary');
        });

        Schema::table('upload_training_file', function($table)
        {
            $table->bigincrements('organisation_id_fk')->unsigned()->after('id');;
            $table->foreign('organisation_id_fk')->references('organisation_id')->on('organisation');
        });

        Schema::table('upload_training_file', function($table)
        {
            $table->dropPrimary('upload_training_file_organisation_id_fk_primary');
        });

        Schema::table('upload_training_file', function($table)
        {
            $table->bigincrements('year_id_fk')->unsigned()->after('organisation_id_fk');;
            $table->foreign('year_id_fk')->references('year_id')->on('year_of_performance');
            $table->biginteger('created_by')->nullable();
            $table->time('create_date')->nullable();
            $table->biginteger('updated_by')->nullable;
            $table->time('update_date')->nullable();
            $table->string('file_path')->nullable();
        });

        Schema::table('upload_training_file', function($table)
        {
            $table->dropPrimary('upload_training_file_year_id_fk_primary');
            $table->primary('upload_training_file_id');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('upload_training_file');
    }

}
    dropPrimary ist eigentlich fallende Sequenzen. Vielen Dank für diese.

    InformationsquelleAutor Nasif Md. Tanjim

Schreibe einen Kommentar