/PHP/Laravel/Laravel enum migration example

Laravel enum migration example

$table->enum('animal_type',['cat','dog','unknown'])->default('unknown');

Laravel enum migration

Add Laravel enmu migration : 
------------------------------
$table->enum('question_type', ['objective', 'subjective', 'multiple_choice']);

Update Laravel enum migration :
---------------------------------
DB::statement("ALTER TABLE users CHANGE COLUMN permissions permissions ENUM('admin', 'user', 'candidate') NOT NULL DEFAULT 'user'");

Laravel Migration - Update Enum Options

DB::statement("ALTER TABLE users CHANGE COLUMN permissions permissions ENUM('admin', 'user', 'candidate') NOT NULL DEFAULT 'user'");

Source: stackoverflow.com

Similar codes

2 votes279 views6 answers
Get last id in laravel
PHP Laravel
0 vote229 views1 answer
Send multiple db notification same function in laravel
PHP Laravel
0 vote251 views1 answer
Laravel array cast
PHP Laravel
0 vote218 views2 answers
Unique sql queries laravel
PHP Laravel
0 vote226 views1 answer
Double in migration laravel
PHP Laravel
0 vote339 views1 answer
Laravel timestamps on pivot table
PHP Laravel
0 vote227 views2 answers
Laravel download file from public folder
PHP Laravel
4 votes203 views1 answer
Disable register laravel
PHP Laravel
7 votes243 views6 answers
Remove foreign key constraint laravel
PHP Laravel
2 votes219 views1 answer
Laravel schema default string length
PHP Laravel