Breaking News: Grepper is joining You.com. Read the official announcement!

laravel create enum migration

Add Answer

@CodeGrepperManu answered on July 23, 2020 Popularity 3/10 Helpfulness 7/10

answer laravel create enum migration

related laravel enum migration example

related laravel enum migration

related enum in laravel migration

related enum in migration laravel

related Laravel Migration - Update Enum Options

related laravel enum migration

laravel create enum migration

Comment

/**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
       
		Schema::table('leads', function (Blueprint $table) 
        {
            //Give the moving column a temporary name:
            Schema::table('leads', function($table)
            {
                $table->renameColumn('status', 'status_old');
            });

            //Add a new column with the regular name:
            Schema::table('leads', function(Blueprint $table)
            {
                $table-> enum('status',['active', 'inactive', 'cancelled'])->nullable()->after('lead_source_id');
            
            });

            //Copy the data across to the new column:
            DB::table('leads')->update([
                'status' => DB::raw('status_old')   
            ]);

            //Remove the old column:
            Schema::table('leads', function(Blueprint $table)
            {
                $table->dropColumn('status_old');
            });  
        });
		
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
		Schema::table('leads', function (Blueprint $table) 
        {
            //Give the moving column a temporary name:
            Schema::table('leads', function($table)
            {
                $table->renameColumn('status', 'status_old');
            });

            //Add a new column with the regular name:
            Schema::table('leads', function(Blueprint $table)
            {
                $table-> enum('status',['active', 'inactive'])->nullable()->after('lead_source_id');
            
            });

            //Copy the data across to the new column:
            DB::table('leads')->update([
                'status' => DB::raw('status_old')   
            ]);

            //Remove the old column:
            Schema::table('leads', function(Blueprint $table)
            {
                $table->dropColumn('status_old');
            });  
      
        });
			
    }

Popularity 3/10 Helpfulness 7/10 Language php

Source: Grepper

Tags: laravel migration php

Link to this answer
Share Copy Link

Contributed on Apr 24 2024

@CodeGrepperManu

0 Answers Avg Quality 2/10

Closely Related Answers

laravel enum migration example

Comment

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

Popularity 10/10 Helpfulness 10/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Oct 02 2021

Matio

0 Answers Avg Quality 2/10

laravel enum migration

Comment

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

Popularity 10/10 Helpfulness 7/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Jul 23 2020

Lokesh003Coding

0 Answers Avg Quality 2/10

enum in laravel migration

Comment

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

Popularity 10/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Aug 12 2022

Snippets

0 Answers Avg Quality 2/10

enum in migration laravel

Comment

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

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

Popularity 10/10 Helpfulness 4/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Jul 20 2022

Rilwanu Isyaku

0 Answers Avg Quality 2/10

Laravel Migration - Update Enum Options

Comment

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

Popularity 10/10 Helpfulness 3/10 Language php

Source: stackoverflow.com

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Apr 28 2021

Scary Skimmer

0 Answers Avg Quality 2/10

laravel enum migration

Comment

 \DB::statement("ALTER TABLE users MODIFY COLUMN role ENUM('1','2','3')");

Popularity 1/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: laravel migration php

Link to this answer
Share Copy Link

Contributed on May 10 2022

Adnan Zaheer

0 Answers Avg Quality 2/10

laravel enum migration

Comment

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class UpdateRoleColumn extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        //
        \DB::statement("ALTER TABLE users MODIFY COLUMN role ENUM('1','2','3')");
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
    }
}

Popularity 1/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: laravel migration php

Link to this answer
Share Copy Link

Contributed on May 10 2022

Adnan Zaheer

0 Answers Avg Quality 2/10

laravel create enum migration

Contents

More Related Answers

laravel create enum migration

Closely Related Answers

laravel enum migration example

laravel enum migration

enum in laravel migration

enum in migration laravel

Laravel Migration - Update Enum Options

laravel enum migration

laravel enum migration

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.