Biginteger auto_increment primary key Phinx

Question

I am trying to create a migration with a biginteger-primary key and switch it to auto_increment.

I am using robmorgans Phinx to create the migration.

Is it possible to change a table's primary key of the datatype BIGINTEGER to be auto_incremented after you've created it?

Currently it looks like this.

$positions = $this->table('positions', ['id' => false, 'primary_key' => 'id'])
        ->changeColumn('id', 'biginteger', ['auto_increment' => true])
        ->addColumn('work_order_id', 'char', ['after' => 'vehicle_id','default' => null, 'null' => true,'limit' => 36])
        ->update();

Please add an actual question to your question - thanks! – ndm Jan 13 '16 at 13:20 — ndm, Jan 13 '16 at 13:20

score 9 · Accepted Answer · edited Jan 20 '21 at 11:05

9

There is no auto_increment option, see

https://book.cakephp.org/phinx/0/en/migrations.html#valid-column-options

What you are looking for is the identity option, which will, quote

enable or disable automatic incrementing

->changeColumn('id', 'biginteger', ['identity' => true])

edited Jan 20 '21 at 11:05

sdexp

756
4
18
36

answered Jan 13 '16 at 13:31

ndm

59,784
9
71
110

How could i miss.. :) Thanks alot ndm!! – JazzCat Jan 13 '16 at 13:56

Biginteger auto_increment primary key Phinx

1 Answers1