cakephp /
phinx
| @@ 211-222 (lines=12) @@ | ||
| 208 | } |
|
| 209 | ||
| 210 | // set the primary key(s) |
|
| 211 | if (isset($options['primary_key'])) { |
|
| 212 | $sql = rtrim($sql); |
|
| 213 | $sql .= sprintf(' CONSTRAINT %s_pkey PRIMARY KEY (', $table->getName()); |
|
| 214 | if (is_string($options['primary_key'])) { // handle primary_key => 'id' |
|
| 215 | $sql .= $this->quoteColumnName($options['primary_key']); |
|
| 216 | } elseif (is_array($options['primary_key'])) { // handle primary_key => array('tag_id', 'resource_id') |
|
| 217 | $sql .= implode(',', array_map([$this, 'quoteColumnName'], $options['primary_key'])); |
|
| 218 | } |
|
| 219 | $sql .= ')'; |
|
| 220 | } else { |
|
| 221 | $sql = substr(rtrim($sql), 0, -1); // no primary keys |
|
| 222 | } |
|
| 223 | ||
| 224 | // set the foreign keys |
|
| 225 | $foreignKeys = $table->getForeignKeys(); |
|
| @@ 193-204 (lines=12) @@ | ||
| 190 | } |
|
| 191 | ||
| 192 | // set the primary key(s) |
|
| 193 | if (isset($options['primary_key'])) { |
|
| 194 | $sql = rtrim($sql); |
|
| 195 | $sql .= ' PRIMARY KEY ('; |
|
| 196 | if (is_string($options['primary_key'])) { // handle primary_key => 'id' |
|
| 197 | $sql .= $this->quoteColumnName($options['primary_key']); |
|
| 198 | } elseif (is_array($options['primary_key'])) { // handle primary_key => array('tag_id', 'resource_id') |
|
| 199 | $sql .= implode(',', array_map([$this, 'quoteColumnName'], $options['primary_key'])); |
|
| 200 | } |
|
| 201 | $sql .= ')'; |
|
| 202 | } else { |
|
| 203 | $sql = substr(rtrim($sql), 0, -1); // no primary keys |
|
| 204 | } |
|
| 205 | ||
| 206 | // set the foreign keys |
|
| 207 | $foreignKeys = $table->getForeignKeys(); |
|
| @@ 290-301 (lines=12) @@ | ||
| 287 | } |
|
| 288 | ||
| 289 | // set the primary key(s) |
|
| 290 | if (isset($options['primary_key'])) { |
|
| 291 | $sql = rtrim($sql); |
|
| 292 | $sql .= ' PRIMARY KEY ('; |
|
| 293 | if (is_string($options['primary_key'])) { // handle primary_key => 'id' |
|
| 294 | $sql .= $this->quoteColumnName($options['primary_key']); |
|
| 295 | } elseif (is_array($options['primary_key'])) { // handle primary_key => array('tag_id', 'resource_id') |
|
| 296 | $sql .= implode(',', array_map([$this, 'quoteColumnName'], $options['primary_key'])); |
|
| 297 | } |
|
| 298 | $sql .= ')'; |
|
| 299 | } else { |
|
| 300 | $sql = substr(rtrim($sql), 0, -1); // no primary keys |
|
| 301 | } |
|
| 302 | ||
| 303 | // set the indexes |
|
| 304 | $indexes = $table->getIndexes(); |
|
