Postgres Migration Problema

[pedrosoares]

I'm using postgres and when i migrate the error bellow shows up.
'''
Migration table created successfully.

[Illuminate\Database\QueryException]
SQLSTATE[42830]: Invalid foreign key: 7 ERROR: there is no unique constrai
nt matching given keys for referenced table "roles" (SQL: alter table "user
s" add constraint "users_role_level_foreign" foreign key ("role_level") ref
erences "roles" ("level"))

[PDOException]
SQLSTATE[42830]: Invalid foreign key: 7 ERROR: there is no unique constrai
nt matching given keys for referenced table "roles"
'''

[FPGL]

It says that roles.level must be unique. Try adding a unique() constraint:

Schema::create('roles', function (Blueprint $table) {
...
$table->integer('level')->unique()->default(1)->unsigned()->index();

[brunocs86]

Tks