How to set Foreign Key Constraint in Cakephp 3.3 Migration?

Question

I am new to Cakephp and building an application with Cakephp3.3, I am working on Migrations, I have to create a user_infos table, and want to add a new column user_id, I am able to add new columns through migrations but I don't know how to add foreign key.

here is my migration file

    public function change()
    {
        $table = $this->table('user_infos');
        $table->addColumn('user_id', 'integer', [
            'default' => null,
            'limit' => 11,
            'null' => false,
        ]);
        $table->addColumn('title', 'string', [
            'default' => null,
            'limit' => 255,
            'null' => false,
        ]);
        $table->addColumn('created', 'datetime', [
            'default' => null,
            'null' => false,
        ]);
        $table->addColumn('modified', 'datetime', [
            'default' => null,
            'null' => false,
        ]);
        $table->create();
    }

score 7 · Accepted Answer · answered Oct 14 '16 at 10:55

7

Your migration seems to be based on Phinx; you can find relevant methods in Phinx\Db\Table. Add

->addIndex(['user_id'])
->addForeignKey('user_id', 'users', 'id')

to your migration for the constraint on the users table.

answered Oct 14 '16 at 10:55

code-kobold

829
14
18

hi thanks, but how can we set On delete cascade for the same? – Amrinder Singh Oct 14 '16 at 11:58
Would this count as an association? – DevDave Nov 11 '20 at 09:23

score 2 · Answer 2 · edited Jul 17 '17 at 20:35

2

In Phinx, you can use the below code to add foreign key with cascading

$table->addForeignKey('user_id', 'users', 'id', ['delete'=> 'CASCADE', 'update'=> 'CASCADE']);

edited Jul 17 '17 at 20:35

Paul Roub

36,322
27
84
93

answered Jul 17 '17 at 20:13

Akhlaq Ahmad

44
1

How to set Foreign Key Constraint in Cakephp 3.3 Migration?

2 Answers2