How can I create laravel migration with enum type column?

Question

I am trying to create enum column in laravel migration. Upon executing the query it does create column in the table but checking in postgresql for created enum types, it shows theres none. Does anyone ever experience this?

I am using laravel 5.4, php 7 and vagrant

Migration code

public function up()
    {
        Schema::create('restaurant_tables', function(Blueprint $table){
            $table->increments('_id');
            $table->string('tableNo', 100);
            $table->json('spatialLocation');
            $table->enum('tableStatus' , array('Occupied', 'Reserved', 'Vacant', 'For Cleaning'))->default('Vacant');
            $table->integer('numberOfCustomers');
            $table->integer('seatLimit');
            $table->string('tableDimension', 100);
            $table->enum('tableType', ['4x4','16x4','8x4']);
            $table->bigInteger('chairID');
        });

        Schema::table('restaurant_tables', function(Blueprint $table){
            $table->foreign('chairID')->references('_id')->on('restaurant_chairs');
        });
    }

Does this answer your question? Laravel 5.3 Schema::create ENUM field is VARCHAR — miken32
– miken32, Commented Nov 18, 2019 at 3:51
@miken32 how can I implement it? the answer is pretty straightforward, would you like to explain a little bit more about it? the link you provide is related to my problem but the OP does not explain how he arrive to the answer — nyx97
– nyx97, Commented Nov 18, 2019 at 4:16
No idea; if Laravel/Doctrine won't do it you can just use raw SQL query in your migration. — miken32
– miken32, Commented Nov 18, 2019 at 4:21

Anil Stha · Accepted Answer · 2020-01-23 13:13:37Z

4

You can simply do:

$table -> enum('tableStatus',['VACANT','OCCUPIED','RESERVED','FOR CLEANING'])->default('VACANT');

edited Jan 23, 2020 at 13:13

answered Jan 23, 2020 at 12:56

Anil Stha

5617 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Swayok Over a year ago

This won't create real ENUM type. It will just add CHECK constraint like this: alter table "ads" add column "status" varchar(255) check ("status" in ('draft', 'in_moderation', 'published', 'declined', 'blocked', 'expired', 'closed', 'sold', 'paused')). And this is totally not you usually want from real PosgreSQL ENUM type which is stored as int value, not varchar and has performance of int type instead of varchar.

Suraj Rao · Accepted Answer · 2022-03-09 06:58:01Z

2

$table->enum('tableStatus',['Vacant', 'Reserved', 'Occupied', 'For Cleaning']);

First one will be default

edited Mar 9, 2022 at 6:58

Suraj Rao

29.7k11 gold badges96 silver badges104 bronze badges

answered Mar 9, 2022 at 6:47

Aleena Antony

441 bronze badge

Comments

Swayok · Accepted Answer · 2025-09-29 13:37:59Z

Here is explanation: https://hbgl.dev/add-columns-with-custom-types-in-laravel-migrations/

Hope this will save some time for those who meets this problem like me.

In short:

Grammar::macro('typeTableTypeEnum', function () {
    return 'tableTypeEnum';
});
 
DB::unprepared("CREATE TYPE tableTypeEnum AS ENUM ('4x4','16x4','8x4');");
 
Schema::create('restaurant_tables', function (Blueprint $table) {
    ...
    $table->rawColumn('tableType', 'tableTypeEnum');
    ...
});

Alternative version (use for existing table updates):

DB::unprepared("CREATE TYPE \"tableTypeEnum\" AS ENUM ('4x4','16x4','8x4');");
DB::unprepared('ALTER TABLE "restaurant_tables" add column "tableType" "tableTypeEnum" NOT NULL');

Additional steps to extend Doctrine DBAL (required for renaming, for example):

Create class TableTypeEnumDbType:

<?php

declare(strict_types=1);

namespace App\Models\Types;

use Doctrine\DBAL\Types\StringType;

class TableTypeEnumDbType extends StringType
{
    public function getName(): string
    {
        return 'tableTypeEnum';
    }
}

add this to config/database.php:

/*
|--------------------------------------------------------------------------
| Doctrine DBAL settings.
|--------------------------------------------------------------------------
*/
'dbal' => [
    'types' => [
        'tableTypeEnum' => \App\Models\Types\AdStatusType::class,
    ],
],

Collectives™ on Stack Overflow

How can I create laravel migration with enum type column?

3 Answers 3

1 Comment

First one will be default

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

First one will be default

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related