Add a primary key on an existing table

[william-suppo]

Hello guys,

How we can add a primary key on an existing table ?

I try to do this but the table dont be updated :

    public function up()
    {
        $this->table('toto', array('id' => true))
            ->save();
    }

But Table::update() method was call and this method didn't create primary key ...

[william-suppo]

My provisional solution (because i worked with prostresql) :

    public function up()
    {
        $this->execute('ALTER TABLE toto ADD COLUMN id serial PRIMARY KEY');
    }

[shadowhand]

I would expect addIndex('id', array('primary' => true)) to work, but it won't because primary is not a valid option for table index. Weird.

[etki]

Voting up for this, though setting unique index on column made mysql's describe output treat it as PRI.

[sergejkaravajnij]

I have exactly the same task and not found any solution except using ALTER TABLE ... :(
But in this case I couldn't use change() method.

[DerMika]

You should be able to create a primary key by creating an index of type "PRIMARY" just as you can create a unique key. However, the current implementation only looks at the UNIQUE type.

I was expecting $table->addIndex(['someId', 'someOtherId'], ['type' => 'PRIMARY']) to work, but I found out that any index type besides 'unique' is ignored.

With that said: here is my vote for fixing this bug.

[berarma]

+1

+1

[purpleweb]

+1

[burzum]

Can we add a method addPrimaryKey()? :)

[djcvijic]

I think this can be closed now, Table::changePrimaryKey covers this functionality fully, right?