/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 vote200 views1 answer
Laravel collection max
PHP Laravel
22 votes157 views2 answers
Where status is null sql in laravel
PHP
1 vote169 views1 answer
Calcolo iva php
PHP
2 votes189 views2 answers
How to use vue 3 in laravel 8
PHP
1 vote226 views2 answers
Get unique values in laravel
PHP
0 vote226 views1 answer
Comment supprimer les onglets WooCommerce dans WordPress
PHP
26 votes186 views6 answers
Laravel validation integer
PHP Laravel
8 votes191 views6 answers
Print last query in codeigniter
PHP
0 vote204 views1 answer
Woocommerce get post terms product
PHP
0 vote286 views1 answer
Yii form custom label
PHP Yii