add column with primarykey migrations on update cakephp

Question

I am writing migrations script in cakephp 3 using Phinx. I need to add a column with primary key while updating the table(using update() command) using migrations. But when I run the script, it created the column but does not include the primary key.

  $table->addColumn('book_id', 'integer', [
     'default' => null,
     'limit' => 11,
     'null' => true
  ])->addPrimaryKey('book_id');
  $table->update();

Thanks

score 1 · Accepted Answer · answered Mar 17 '17 at 14:07

1

Per the Docs:

Dealing with primary key can only be done on table creation operations. This is due to limitations for some database servers the plugin supports.

answered Mar 17 '17 at 14:07

Andy Hoffner

3,267
2
21
22

score 1 · Answer 2 · answered Apr 08 '21 at 08:53

1

public function change(): void
{
    $this->table('table_name')
    ->changePrimaryKey(['column1', 'column2'])
    ->save();
}

answered Apr 08 '21 at 08:53

prophp

91
2
4

add column with primarykey migrations on update cakephp

2 Answers2