I am trying to create a new migration for my users table, I have the following schema:
Schema::create('users', function($t) {
$t->increments('id');
$t->string('username', 16);
$t->string('password', 64);
$t->integer('role', 64);
$t->timestamps();
});
When I try to run php artisan from the terminal, I get the following error:
[Exception]
SQLSTATE [42000]: Syntax error or access violation: 1075 The definition of the table is incorrect; there can be only one automatic column, and it should be defined as a key (SQL: create table users( idint unsigne d not null auto_increment primary key, usernamevarchar (16) not null, passwordvarchar (64) no t null, roleint not null auto_increment primary key, created_attimestamp default 0 not null, updated_attimestamp default 0 not null)) (Bindings: array (
))
- "role", , .
.