Hola, tengo problemas con las migraciones de mi base de datos en mi aplicación laravel.

Este es el error:

 [Illuminate\Database\QueryException] SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL : alter table `transactions` add constraint `transactions_user_sid_foreign` foreign key (`user_sid`) references `users` (`sid`))

Esta es mi migración de transacciones:

 public function up() { Schema::create('transactions', function (Blueprint $table) { $table->increments('id'); $table->unsignedInteger('user_sid')->index(); $table->unsignedInteger('store_id')->index(); $table->unsignedInteger('value'); $table->timestamps(); $table->softDeletes(); }); }

Esta es la migración de usuarios:

 public function up() { Schema::create('users', function (Blueprint $table) { $table->increments('id'); $table->string('name'); $table->string('email')->unique(); $table->string('password'); $table->unsignedInteger('role_id')->index(); $table->string('sid')->unique(); $table->rememberToken(); $table->timestamps(); $table->softDeletes(); }); }

Y finalmente mis claves foráneas:

 Schema::table('transactions', function (Blueprint $table){ $table->foreign('user_sid')->references('sid')->on('users'); $table->foreign('store_id')->references('id')->on('stores'); });