/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

2 votes367 views1 answer
Guzzle bearer token
PHP
5 votes379 views3 answers
Get last month using php
PHP
1 vote382 views1 answer
How to alias table name in laravel model
PHP Laravel
1 vote348 views2 answers
Image acf
PHP
7 votes342 views1 answer
Laravel eloquent whereDateBetween
PHP
11 votes381 views6 answers
Convert object to array php
PHP
0 vote332 views1 answer
Like %% inside the array php
PHP
0 vote356 views1 answer
LDownload multiple files as a zip-file using php
PHP
1 vote406 views1 answer
How to add an custom error to validater error in laravel
PHP Laravel
0 vote378 views1 answer
__invoke in laravel
PHP Laravel