Problems to modify table attribute in migrations, laravel 5.5

$table->dropUnique('users_email_unique');

https://laravel.com/docs/5.8/migrations Dropping Indexes Section

Execute the command php artisan make:migration alter_email_on_users_table --table=users

Then a migration will be loaded with your table already set up. Inside the table() function you may alter columns using the ->change() method at the end of your call. Basically what you need is to specify all the characteristics of your columns as if it were a new one but just call change() at the end of the chain. Like this: $table->string('mail')->after('other_example_column')->nullable()->change()

But be careful - if the new data type does not match the old one, you might loose data. In addition, there is a module that needed to be included to laravel in order to modify columns, but it was a long time ago when I last had to enable that functionality so I forgot the details... but there was something exceptional!

Hope that narrows it down for you.

Hi, you can read more about this in https://laravel.com/docs/5.8/migrations#modifying-columns

PS: take a look about the warnings!

Suppose I make the change in the migration, but I do not understand how to execute that migration, without deleting the data that I already have in the users table

create new migration

php artisan make:migration remove_unique_key --table=users

    public function up()
    {
        Schema::table('users', function (Blueprint $table) {
            $table->dropUnique('users_email_unique');
        });
    }

php artisan migrate

Thank you very much, I do not erase data, now I understand