@@ 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} |