Migration to Add Comment to Existing Column

I have a column as tinyInteger. Now I would like to add comment to the column with new migration file.

public function up() { Schema::table('sales_invoices', function (Blueprint $table) { $table->tinyInteger('invoice_type')->comment('0 > A Normal Invoice, 1 > A Recurring Invoice'); }); }

Now above is the code I am trying in new schema to add comment, but it doesn't work and gives error.

D9705996

7 years ago

Best Answer

Level 51

You need to use the change function

public function up() {
  Schema::table('sales_invoices', function (Blueprint $table) { 
    $table->tinyInteger('invoice_type')
        ->comment('0 > A Normal Invoice, 1 > A Recurring Invoice')
        ->change();
  }); 
}

There are some caveats to using this and you will need to run composer require doctrine/dbal

https://laravel.com/docs/5.7/migrations#modifying-columns

1 like

pthai-it-dev

3 years ago

Level 1

@D9705996 but doctrine/dbal does not support tinyinteger, right? https://stackoverflow.com/questions/45591455/change-column-type-to-tinyinteger

rijans

7 years ago

Level 1

@D9705996 - Worked thanks.

Please or to participate in this conversation.