doctrine / dbal

    /**

     * {@inheritdoc}

     */

    protected function getQuotesTableIdentifiersInAlterTableSQL() : array

    {

        return [

            'ALTER TABLE "foo" DROP CONSTRAINT fk1',

            'ALTER TABLE "foo" DROP CONSTRAINT fk2',

            'ALTER TABLE "foo" ADD bloo INT NOT NULL',

            'ALTER TABLE "foo" DROP baz',

            'ALTER TABLE "foo" ALTER bar DROP NOT NULL',

            'ALTER TABLE "foo" RENAME COLUMN id TO war',

            'ALTER TABLE "foo" RENAME TO "table"',

            'ALTER TABLE "table" ADD CONSTRAINT fk_add FOREIGN KEY (fk3) REFERENCES fk_table (id) NOT DEFERRABLE ' .

            'INITIALLY IMMEDIATE',

            'ALTER TABLE "table" ADD CONSTRAINT fk2 FOREIGN KEY (fk2) REFERENCES fk_table2 (id) NOT DEFERRABLE ' .

            'INITIALLY IMMEDIATE',

        ];

    }

    /**

     * {@inheritdoc}

    /**

     * {@inheritdoc}

     */

    protected function getQuotesTableIdentifiersInAlterTableSQL() : array

    {

        return [

            'ALTER TABLE [foo] DROP CONSTRAINT fk1',

            'ALTER TABLE [foo] DROP CONSTRAINT fk2',

            "sp_RENAME '[foo].id', 'war', 'COLUMN'",

            'ALTER TABLE [foo] ADD bloo INT NOT NULL',

            'ALTER TABLE [foo] DROP COLUMN baz',

            'ALTER TABLE [foo] ALTER COLUMN bar INT',

            "sp_RENAME '[foo]', 'table'",

            "DECLARE @sql NVARCHAR(MAX) = N''; " .

            "SELECT @sql += N'EXEC sp_rename N''' + dc.name + ''', N''' + REPLACE(dc.name, '8C736521', 'F6298F46') + ''', " .

            "''OBJECT'';' FROM sys.default_constraints dc JOIN sys.tables tbl ON dc.parent_object_id = tbl.object_id " .

            "WHERE tbl.name = 'table';EXEC sp_executesql @sql",

            'ALTER TABLE [table] ADD CONSTRAINT fk_add FOREIGN KEY (fk3) REFERENCES fk_table (id)',

            'ALTER TABLE [table] ADD CONSTRAINT fk2 FOREIGN KEY (fk2) REFERENCES fk_table2 (id)',

        ];

    }

    /**

     * {@inheritdoc}

    /**

     * {@inheritdoc}

     */

    protected function getQuotesTableIdentifiersInAlterTableSQL() : array

    {

        return [

            'DROP INDEX IDX_8C736521A81E660E',

            'DROP INDEX IDX_8C736521FDC58D6C',

            'CREATE TEMPORARY TABLE __temp__foo AS SELECT fk, fk2, id, fk3, bar FROM "foo"',

            'DROP TABLE "foo"',

            'CREATE TABLE "foo" (fk2 INTEGER NOT NULL, fk3 INTEGER NOT NULL, fk INTEGER NOT NULL, war INTEGER NOT NULL, ' .

            'bar INTEGER DEFAULT NULL, bloo INTEGER NOT NULL, ' .

            'CONSTRAINT fk2 FOREIGN KEY (fk2) REFERENCES fk_table2 (id) NOT DEFERRABLE INITIALLY IMMEDIATE, ' .

            'CONSTRAINT fk_add FOREIGN KEY (fk3) REFERENCES fk_table (id) NOT DEFERRABLE INITIALLY IMMEDIATE)',

            'INSERT INTO "foo" (fk, fk2, war, fk3, bar) SELECT fk, fk2, id, fk3, bar FROM __temp__foo',

            'DROP TABLE __temp__foo',

            'ALTER TABLE "foo" RENAME TO "table"',

            'CREATE INDEX IDX_8C736521A81E660E ON "table" (fk)',

            'CREATE INDEX IDX_8C736521FDC58D6C ON "table" (fk2)',

        ];

    }

    /**

     * {@inheritdoc}