How to define a non-incremental primary key in Laravel 5?

Question

How to define a non-incremental primary key in Laravel 5?

Navigation

#1 by (2 votes)

1

A query. I have the table clients with the id and name fields.

By means of a barcode reader I read a card, and I want to save the number that has said card (ex: 123465) in the id field, and that this field is my primary key.

Laravel, saves by default the id as incremental, however if I take the incremental option and put integer , when doing migrate , it does not keep the id as primary key.

What I need is to create the id field, but that it is a primary key and in turn is not incremental.

laravel-5

asked by Pablo Rivera Madrazo 16.03.2017 в 17:16

source

1 answer

How to make an event only load once javascript Convert LPWSTR to string

score 2 · Accepted Answer

The solution is to declare the field as you normally do, but add the index by means of:

Schema::table('users', function($table)
{
    $table->integer('id')->unsigned();
    $table->primary('id');
});

as the documentation shows Adding indexes