Level 44
You can run it as a raw query in a new migration that modifies the column:
public function up()
{
DB::statement("ALTER TABLE users MODIFY COLUMN role VARCHAR(50) NULL");
}
Jan 21, 2019
1
Level 1
Change Column name and datatype
I have a users table for my project, i already have column Role ( enum ['admin', 'student', 'teacher']) in my table, and i want to change the designation column ('string'), but as per laravel docs we cannot update the column with enum datatype, so in this case what should i do, i am new to laravel.
Please or to participate in this conversation.