/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 vote175 views1 answer
Laravel 8 - get values of url query strings in controller
PHP Laravel
0 vote171 views1 answer
Php pass 2 date value to javascript
PHP
1 vote150 views2 answers
Laravel seconds to hours minutes seconds
PHP Laravel
0 vote140 views1 answer
Php new PDO timeout
PHP
0 vote137 views1 answer
Shop manager Redirect @ WooCommerce
PHP
0 vote134 views1 answer
Including ACF in a custom theme or plugin
PHP
0 vote216 views1 answer
Laravel eloquent update quantity
PHP Laravel
1 vote140 views2 answers
Laravel middleware in constructor
PHP Laravel
0 vote93 views1 answer
Call a blade from a blade in laravel 8
PHP
1 vote132 views1 answer
Laravel createmany example
PHP