/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

0 vote225 views1 answer
Hardening PHP7
PHP
0 vote247 views1 answer
Laravel make migration controller resource mcr
PHP Laravel
0 vote219 views1 answer
Php inline if condition date time
PHP
0 vote354 views1 answer
Personnaliser le logo de connexion WordPress sans plugin
PHP Wordpress
0 vote267 views1 answer
Laravel select only some columns relationship
PHP Laravel
8 votes416 views4 answers
Log php
PHP
20 votes212 views6 answers
Php sort array by key
PHP
33 votes221 views4 answers
Php unset array key
PHP
1 vote229 views1 answer
Have_rows count acf php
PHP
8 votes217 views3 answers
Php time limit
PHP