I created migration using the following
Schema::table('packages', function (Blueprint $table) {
$table->integer('star_id')->unsigned()->index()->nullable()->default(null);
$table->foreign('star_id')->references('id')->on('star');
});
in drop part
Schema::table('packages', function (Blueprint $table) {
$table->dropForeign('star_id');
//$table->dropIndex('star_id'); //also tried dropIndex
$table->dropColumn('star_id');
});
but it throws for index and foreign
SQLSTATE[HY000]: General error: 1553 Cannot drop index 'packages_star_id_index': needed in a foreign key constraint (SQL: alter table
packages
dropstar_id
)
error for dropForeign
SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'star_id'; check that column/key exists (SQL: alter table
packages
drop foreign keystar_id
)
I cannot rollback because of the error.
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire