| @@ 689-703 (lines=15) @@ | ||
| 686 | /** |
|
| 687 | * {@inheritdoc} |
|
| 688 | */ |
|
| 689 | protected function getQuotedAlterTableRenameColumnSQL() |
|
| 690 | { |
|
| 691 | return array( |
|
| 692 | "ALTER TABLE mytable " . |
|
| 693 | "CHANGE unquoted1 unquoted INT NOT NULL COMMENT 'Unquoted 1', " . |
|
| 694 | "CHANGE unquoted2 `where` INT NOT NULL COMMENT 'Unquoted 2', " . |
|
| 695 | "CHANGE unquoted3 `foo` INT NOT NULL COMMENT 'Unquoted 3', " . |
|
| 696 | "CHANGE `create` reserved_keyword INT NOT NULL COMMENT 'Reserved keyword 1', " . |
|
| 697 | "CHANGE `table` `from` INT NOT NULL COMMENT 'Reserved keyword 2', " . |
|
| 698 | "CHANGE `select` `bar` INT NOT NULL COMMENT 'Reserved keyword 3', " . |
|
| 699 | "CHANGE quoted1 quoted INT NOT NULL COMMENT 'Quoted 1', " . |
|
| 700 | "CHANGE quoted2 `and` INT NOT NULL COMMENT 'Quoted 2', " . |
|
| 701 | "CHANGE quoted3 `baz` INT NOT NULL COMMENT 'Quoted 3'" |
|
| 702 | ); |
|
| 703 | } |
|
| 704 | ||
| 705 | /** |
|
| 706 | * {@inheritdoc} |
|
| @@ 457-471 (lines=15) @@ | ||
| 454 | /** |
|
| 455 | * {@inheritdoc} |
|
| 456 | */ |
|
| 457 | protected function getQuotedAlterTableRenameColumnSQL() |
|
| 458 | { |
|
| 459 | return array( |
|
| 460 | 'ALTER TABLE mytable ' . |
|
| 461 | 'RENAME COLUMN unquoted1 TO unquoted ' . |
|
| 462 | 'RENAME COLUMN unquoted2 TO "where" ' . |
|
| 463 | 'RENAME COLUMN unquoted3 TO "foo" ' . |
|
| 464 | 'RENAME COLUMN "create" TO reserved_keyword ' . |
|
| 465 | 'RENAME COLUMN "table" TO "from" ' . |
|
| 466 | 'RENAME COLUMN "select" TO "bar" ' . |
|
| 467 | 'RENAME COLUMN quoted1 TO quoted ' . |
|
| 468 | 'RENAME COLUMN quoted2 TO "and" ' . |
|
| 469 | 'RENAME COLUMN quoted3 TO "baz"' |
|
| 470 | ); |
|
| 471 | } |
|
| 472 | ||
| 473 | /** |
|
| 474 | * {@inheritdoc} |
|