/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 vote52 views1 answer
Vue js mouseover event
PHP
0 vote92 views1 answer
Illuminate\Auth\EloquentUserProvider::validateCredentials()
PHP
0 vote113 views1 answer
Update query in codeigniter using where condition
PHP CodeIgniter
12 votes99 views4 answers
Laravel auth setup
PHP
0 vote161 views1 answer
Wordpress highlight text excerpt
PHP Wordpress
0 vote85 views1 answer
How to import Yomo in larave;
PHP
34 votes98 views4 answers
Get post in php
PHP
1 vote84 views1 answer
CURL : Get elements by class name
PHP
0 vote52 views0 answer
PHP
15 votes106 views3 answers
Pass data to blade laravel
PHP Laravel