Php – Laravel Migration: auto increment key when it is not primary

database-migrationlaravellaravel-4mysqlphp

I'm trying to create a table with Laravel migrations but I'm having some trouble.
I just need to create a table with a primary pair ('id' and 'revision'), being 'id' an auto increment.
I can do it in MySQL, but I can't manage to do it with Laravel Migrations since increments() also set the field as primary.
So far I have this:

Schema::create('bibliographies', function(Blueprint $table)
    {
        $table->increments('id');
        $table->integer('revision');
        ...
        $table->timestamps();
        $table->softDeletes();
        $table->primary(array('id', 'revision'));
    });

Note: changing increments() method is not an option since it is Laravel core.

Thank you for your help in advance.

Best Solution

Just drop the primary key before you re-add it:

$table->dropPrimary( 'id' );
$table->primary( array( 'id', 'revision' ) );

Related Solutions

Mysql – thesql, alter column remove primary key and auto incremement

If you need to remove the auto-increment and the primary key from the id column in a single SQL statement, this should do:

ALTER TABLE companies DROP PRIMARY KEY, CHANGE id id int(11);

In fact, you should be able to do everything in a single ALTER TABLE query:

ALTER TABLE companies
DROP PRIMARY KEY,
CHANGE id id int(11),
ADD PRIMARY KEY (uuid);

PHP array delete by value (not key)

Using array_search() and unset, try the following:

if (($key = array_search($del_val, $messages)) !== false) {
    unset($messages[$key]);
}

array_search() returns the key of the element it finds, which can be used to remove that element from the original array using unset(). It will return FALSE on failure, however it can return a false-y value on success (your key may be 0 for example), which is why the strict comparison !== operator is used.

The if() statement will check whether array_search() returned a value, and will only perform an action if it did.

Best Solution

Related Solutions

Mysql – thesql, alter column remove primary key and auto incremement

PHP array delete by value (not key)

Related Question