Multiple primary key defined

[ratacibernetica]

I had a couple tables with 2 primary keys in my Schema (was using dektrium's yii2-user).

This is the code that generates the error:

 /* MYSQL */
        if (!in_array('auth_assignment', $tables)) {
            if ($dbType == "mysql") {
                $this->createTable('{{%auth_assignment}}', [
                    'item_name' => 'VARCHAR(64) NOT NULL',
                    0 => 'PRIMARY KEY (`item_name`)',
                    'user_id' => 'VARCHAR(64) NOT NULL',
                    1 => 'PRIMARY KEY (`user_id`)',
                    'created_at' => 'INT(11) NULL',
                        ], $tableOptions_mysql);
            }
        }

Solved it by changing it to:

/* MYSQL */
        if (!in_array('auth_assignment', $tables)) {
            if ($dbType == "mysql") {
                $this->createTable('{{%auth_assignment}}', [
                    'item_name' => 'VARCHAR(64) NOT NULL',
                    'user_id' => 'VARCHAR(64) NOT NULL',
                    'created_at' => 'INT(11) NULL',
                        ], $tableOptions_mysql);
                $this->addPrimaryKey(
                                     'auth_assignment_pk',
                                    'auth_assignment',
                                    ['item_name','user_id']
                          );
            }
        }

Other than that, everything worked fine!

Great plugin, thanks!

[c006]

Thanks, glad it works for you.

I appreciate the code.
Hadn't tested for multiple PK's.

I'll put that on the list to do.

Regards,
Jon

On Thu, Sep 24, 2015 at 8:20 PM, Ratacibernetica [email protected]
wrote:

I had a couple tables with 2 primary keys in my Schema (was using
dektrium's yii2-user).

This is the code that generates the error:

/* MYSQL */ if (!in_array('auth_assignment', $tables)) { if ($dbType == "mysql") { $this->createTable('{{%auth_assignment}}', [ 'item_name' => 'VARCHAR(64) NOT NULL', 0 => 'PRIMARY KEY (item_name)', 'user_id' => 'VARCHAR(64) NOT NULL', 1 => 'PRIMARY KEY (user_id)', 'created_at' => 'INT(11) NULL', ], $tableOptions_mysql); } }

Solved it by changing it to:

/* MYSQL */ if (!in_array('auth_assignment', $tables)) { if ($dbType == "mysql") { $this->createTable('{{%auth_assignment}}', [ 'item_name' => 'VARCHAR(64) NOT NULL', 'user_id' => 'VARCHAR(64) NOT NULL', 'created_at' => 'INT(11) NULL', ], $tableOptions_mysql); $this->addPrimaryKey('auth_assignment_pk','auth_assignment',['item_name','user_id']); } }

Other than that, everything worked fine!

Great plugin, thanks!

—
Reply to this email directly or view it on GitHub
#13.

[c006]

Hi.

Thank you for the code, I will add it.
I had not thought of composite keys.

Regards,
Jon

On Wed, Dec 9, 2015 at 4:51 AM, Sedov Sergey [email protected]
wrote:

or change source in DefaultController.php in line 90

$k = 0; foreach ($columns->columns as $column) { $appUtility = new AppUtility($column, $dbType); $output->addStr($appUtility->string . "',"); if ($column->isPrimaryKey) { $output->addStr($k . " => 'PRIMARY KEY (" . $column->name . ")',"); } $k++; }

to

$k = 0; $pk = false; foreach ($columns->columns as $column) { $appUtility = new AppUtility($column, $dbType); $output->addStr($appUtility->string . "',"); if ($column->isPrimaryKey && !$pk) { $output->addStr($k . " => 'PRIMARY KEY (" . $column->name . ")',"); $pk = true; } elseif ($column->isPrimaryKey && $pk) $output->addStr($k . " => 'KEY (" . $column->name . ")',"); $k++; }

—
Reply to this email directly or view it on GitHub
#13 (comment)
.

[antick]

I have encountered the same issue. I think you closed this but haven't fixed the code yet.