@@ -265,9 +265,9 @@ discard block |
||
| 265 | 265 | // Handle id => "field_name" to support AUTO_INCREMENT |
| 266 | 266 | $column = new Column(); |
| 267 | 267 | $column->setName($options['id']) |
| 268 | - ->setType('integer') |
|
| 269 | - ->setSigned($options['signed'] ?? true) |
|
| 270 | - ->setIdentity(true); |
|
| 268 | + ->setType('integer') |
|
| 269 | + ->setSigned($options['signed'] ?? true) |
|
| 270 | + ->setIdentity(true); |
|
| 271 | 271 | |
| 272 | 272 | if (isset($options['limit'])) { |
| 273 | 273 | $column->setLimit($options['limit']); |
@@ -440,12 +440,12 @@ discard block |
||
| 440 | 440 | |
| 441 | 441 | $column = new Column(); |
| 442 | 442 | $column->setName($columnInfo['Field']) |
| 443 | - ->setNull($columnInfo['Null'] !== 'NO') |
|
| 444 | - ->setDefault($columnInfo['Default']) |
|
| 445 | - ->setType($phinxType['name']) |
|
| 446 | - ->setSigned(strpos($columnInfo['Type'], 'unsigned') === false) |
|
| 447 | - ->setLimit($phinxType['limit']) |
|
| 448 | - ->setScale($phinxType['scale']); |
|
| 443 | + ->setNull($columnInfo['Null'] !== 'NO') |
|
| 444 | + ->setDefault($columnInfo['Default']) |
|
| 445 | + ->setType($phinxType['name']) |
|
| 446 | + ->setSigned(strpos($columnInfo['Type'], 'unsigned') === false) |
|
| 447 | + ->setLimit($phinxType['limit']) |
|
| 448 | + ->setScale($phinxType['scale']); |
|
| 449 | 449 | |
| 450 | 450 | if ($columnInfo['Extra'] === 'auto_increment') { |
| 451 | 451 | $column->setIdentity(true); |
@@ -533,16 +533,16 @@ |
||
| 533 | 533 | $updatedAt = $updatedAt ?? 'updated_at'; |
| 534 | 534 | |
| 535 | 535 | $this->addColumn($createdAt, 'timestamp', [ |
| 536 | - 'default' => 'CURRENT_TIMESTAMP', |
|
| 537 | - 'update' => '', |
|
| 538 | - 'timezone' => $withTimezone, |
|
| 539 | - ]) |
|
| 540 | - ->addColumn($updatedAt, 'timestamp', [ |
|
| 541 | - 'null' => true, |
|
| 542 | - 'default' => null, |
|
| 543 | - 'update' => 'CURRENT_TIMESTAMP', |
|
| 544 | - 'timezone' => $withTimezone, |
|
| 545 | - ]); |
|
| 536 | + 'default' => 'CURRENT_TIMESTAMP', |
|
| 537 | + 'update' => '', |
|
| 538 | + 'timezone' => $withTimezone, |
|
| 539 | + ]) |
|
| 540 | + ->addColumn($updatedAt, 'timestamp', [ |
|
| 541 | + 'null' => true, |
|
| 542 | + 'default' => null, |
|
| 543 | + 'update' => 'CURRENT_TIMESTAMP', |
|
| 544 | + 'timezone' => $withTimezone, |
|
| 545 | + ]); |
|
| 546 | 546 | |
| 547 | 547 | return $this; |
| 548 | 548 | } |