Level 47
https://laravel.com/docs/5.2/migrations#modifying-columns
Can't explain it better. Create a new migration file. Add your code to change the column attributes and run migrate command. It will only run new migrations.
2 likes
Jan 12, 2016
4
Level 13
Remove Unique with migration
Hi guys got a question about migrations, I need to remove a unique constrain from a table without refresh the db. how could i do that ?
$table->integer('user_id')->unsigned()->index()->unique();
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
How can i update the user_id row to remove the unique constrain using migrations.
Thanks guys for any help you can give me, must appreciated.
Level 2
I came here looking for how to undo an attribute, but I couldn't find how to undo an attribute on the linked page. I found this on stack overflow, you have to add (false) to the unique field before using ->change:
$table->integer('user_id')->unique(false)->change();
Level 1
If someone try same
$table->dropUnique('tablename_column_unique');
2 likes
Level 1
simply delete the unique key with the column name
$table->dropUnique(['email']);
1 like
Please or to participate in this conversation.