PHP

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'");

enum in laravel migration

$table->enum('gender',['Male','Female'])->default('Male');

enum table in laravel

$table->enum('priority', ['normal', 'medium', 'high'])->default('normal');

enum in migration laravel

// For identifying user
$table->enum('is_admin',['1','0'])->default('1');

// For User roles
$table->enum('user_role',['admin','manager','quest'])->default('quest');

Laravel Migration - Update Enum Options

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