How in migration to change type of field?

Question

In Laravel 5.7 I created tiny field with rule

$table->tinyInteger('renewal_raise_invoice_before')->unsigned()->nullable()->after('renewal_raise_invoice_pre_pay');

But it appears that I need a bigger range. Which is the correct way to change its type to smallInteger?

https://stackoverflow.com/a/32940664/712558 – danronmoon Sep 03 '20 at 00:18 — danronmoon, Sep 03 '20 at 00:18

score 1 · Answer 1 · answered Sep 03 '20 at 00:16

1

Make new migration with:

Schema::table('sometable',function (Blueprint $table){
        $table->smallInteger('renewal_raise_invoice_before')->unsigned()->nullable()->change();
    });

answered Sep 03 '20 at 00:16

Emil Georgiev

529
4
15

score 1 · Accepted Answer · answered Sep 03 '20 at 01:08

In case you ran into some mysql issues as I ran before with 5.7 & 5.8 and MySql 8 you can do RAW queries in the migration

Schema::table('table_name',function (Blueprint $table){

  DB::statement('ALTER TABLE table_name MODIFY COLUMN renewal_raise_invoice_before smallint UNSIGNED NULL');

}

How in migration to change type of field?

2 Answers2