cakephp /
phinx
| @@ 231-242 (lines=12) @@ | ||
| 228 | } |
|
| 229 | ||
| 230 | // set the primary key(s) |
|
| 231 | if (isset($options['primary_key'])) { |
|
| 232 | $sql = rtrim($sql); |
|
| 233 | $sql .= sprintf(' CONSTRAINT %s PRIMARY KEY (', $this->quoteColumnName($parts['table'] . '_pkey')); |
|
| 234 | if (is_string($options['primary_key'])) { // handle primary_key => 'id' |
|
| 235 | $sql .= $this->quoteColumnName($options['primary_key']); |
|
| 236 | } elseif (is_array($options['primary_key'])) { // handle primary_key => array('tag_id', 'resource_id') |
|
| 237 | $sql .= implode(',', array_map([$this, 'quoteColumnName'], $options['primary_key'])); |
|
| 238 | } |
|
| 239 | $sql .= ')'; |
|
| 240 | } else { |
|
| 241 | $sql = rtrim($sql, ', '); // no primary keys |
|
| 242 | } |
|
| 243 | ||
| 244 | $sql .= ')'; |
|
| 245 | $queries[] = $sql; |
|
| @@ 402-413 (lines=12) @@ | ||
| 399 | } |
|
| 400 | ||
| 401 | // set the primary key(s) |
|
| 402 | if (isset($options['primary_key'])) { |
|
| 403 | $sql = rtrim($sql); |
|
| 404 | $sql .= ' PRIMARY KEY ('; |
|
| 405 | if (is_string($options['primary_key'])) { // handle primary_key => 'id' |
|
| 406 | $sql .= $this->quoteColumnName($options['primary_key']); |
|
| 407 | } elseif (is_array($options['primary_key'])) { // handle primary_key => array('tag_id', 'resource_id') |
|
| 408 | $sql .= implode(',', array_map([$this, 'quoteColumnName'], $options['primary_key'])); |
|
| 409 | } |
|
| 410 | $sql .= ')'; |
|
| 411 | } else { |
|
| 412 | $sql = substr(rtrim($sql), 0, -1); // no primary keys |
|
| 413 | } |
|
| 414 | ||
| 415 | $sql = rtrim($sql) . ');'; |
|
| 416 | // execute the sql |
|
| @@ 298-309 (lines=12) @@ | ||
| 295 | } |
|
| 296 | ||
| 297 | // set the primary key(s) |
|
| 298 | if (isset($options['primary_key'])) { |
|
| 299 | $sql = rtrim($sql); |
|
| 300 | $sql .= ' PRIMARY KEY ('; |
|
| 301 | if (is_string($options['primary_key'])) { // handle primary_key => 'id' |
|
| 302 | $sql .= $this->quoteColumnName($options['primary_key']); |
|
| 303 | } elseif (is_array($options['primary_key'])) { // handle primary_key => array('tag_id', 'resource_id') |
|
| 304 | $sql .= implode(',', array_map([$this, 'quoteColumnName'], $options['primary_key'])); |
|
| 305 | } |
|
| 306 | $sql .= ')'; |
|
| 307 | } else { |
|
| 308 | $sql = substr(rtrim($sql), 0, -1); // no primary keys |
|
| 309 | } |
|
| 310 | ||
| 311 | // set the indexes |
|
| 312 | foreach ($indexes as $index) { |
|
