/PHP/Laravel migration remove unique constraint

Laravel migration remove unique constraint

/** To drop an index you must specify the index's name. 
Laravel assigns a reasonable name to the indexes by default. 
Simply concatenate the table name, the names of the column in the index, 
and the index type **/

// Format of unique key tableName_column_unique
$table->dropUnique('users_email_unique');

Laravel migration remove unique

//The UNique need be a constraint name
// This name has this format:
// [TABLE_NAME]_[COLUMN_NAME]_unique
// For 'users' table and 'user_code' column, whe get the name:
// users_user_code_unique
$table->dropUnique('users_user_code_unique');

//The inverst is 
$table->unique('user_code');

Similar codes

1 vote142 views1 answer
Add user meta
PHP
0 vote382 views1 answer
Best Performance monitoring tools for php
PHP
12 votes150 views6 answers
Php array remove empty values
PHP
1 vote156 views1 answer
Cart::total return number format value laravel
PHP Laravel
6 votes134 views3 answers
Php get file contents
PHP
1 vote148 views1 answer
Php text colors
PHP
2 votes183 views4 answers
Laravel hash password check
PHP Laravel
-1 vote148 views2 answers
Laravel OrderBy on Eloquent whereHas relationship
PHP
0 vote130 views1 answer
Tinker colorful
PHP
0 vote135 views2 answers
Merge strings in php
PHP