doctrine / dbal

    /**

     * {@inheritdoc}

     */

    protected function getQuotesTableIdentifiersInAlterTableSQL()

    {

        return array(

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

        return new DB2Platform();

    }

    public function getGenerateAlterTableSql()

    {

        return array(

            "ALTER TABLE mytable ALTER COLUMN baz SET DATA TYPE VARCHAR(255)",

            "ALTER TABLE mytable ALTER COLUMN baz SET NOT NULL",

            "ALTER TABLE mytable ALTER COLUMN baz SET DEFAULT 'def'",

            "ALTER TABLE mytable ALTER COLUMN bloo SET DATA TYPE SMALLINT",

            "ALTER TABLE mytable ALTER COLUMN bloo SET NOT NULL",

            "ALTER TABLE mytable ALTER COLUMN bloo SET DEFAULT '0'",

            "ALTER TABLE mytable " .

            "ADD COLUMN quota INTEGER DEFAULT NULL " .

            "DROP COLUMN foo",

            "CALL SYSPROC.ADMIN_CMD ('REORG TABLE mytable')",

            'RENAME TABLE mytable TO userlist',

        );

    }

    public function getGenerateForeignKeySql()

    {

    /**

     * {@inheritdoc}

     */

    protected function getQuotesTableIdentifiersInAlterTableSQL()

    {

        return array(

            'ALTER TABLE "foo" DROP FOREIGN KEY fk1',

            'ALTER TABLE "foo" DROP FOREIGN KEY fk2',

            'ALTER TABLE "foo" ' .

            'ADD COLUMN bloo INTEGER NOT NULL WITH DEFAULT ' .

            'DROP COLUMN baz ' .

            'ALTER COLUMN bar DROP NOT NULL ' .

            'RENAME COLUMN id TO war',

            'CALL SYSPROC.ADMIN_CMD (\'REORG TABLE "foo"\')',

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

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