doctrine / dbal

        self::assertSame($seq, $diffSchema->newSequences[0]);

    }

    public function testTableAddForeignKey()

    {

        $tableForeign = new Table("bar");

        $tableForeign->addColumn('id', 'integer');

        $table1 = new Table("foo");

        $table1->addColumn('fk', 'integer');

        $table2 = new Table("foo");

        $table2->addColumn('fk', 'integer');

        $table2->addForeignKeyConstraint($tableForeign, array('fk'), array('id'));

        $c = new Comparator();

        $tableDiff = $c->diffTable($table1, $table2);

        self::assertInstanceOf('Doctrine\DBAL\Schema\TableDiff', $tableDiff);

        self::assertCount(1, $tableDiff->addedForeignKeys);

    }

    public function testTableRemoveForeignKey()

    {

        self::assertCount(1, $tableDiff->addedForeignKeys);

    }

    public function testTableRemoveForeignKey()

    {

        $tableForeign = new Table("bar");

        $tableForeign->addColumn('id', 'integer');

        $table1 = new Table("foo");

        $table1->addColumn('fk', 'integer');

        $table2 = new Table("foo");

        $table2->addColumn('fk', 'integer');

        $table2->addForeignKeyConstraint($tableForeign, array('fk'), array('id'));

        $c = new Comparator();

        $tableDiff = $c->diffTable($table2, $table1);

        self::assertInstanceOf('Doctrine\DBAL\Schema\TableDiff', $tableDiff);

        self::assertCount(1, $tableDiff->removedForeignKeys);

    }

    public function testTableUpdateForeignKey()

    {

        self::assertFalse($tableDiff);

    }

    public function testCompareIndexBasedOnPropertiesNotName()

    {

        $tableA = new Table("foo");

        $tableA->addColumn('id', 'integer');

        $tableA->addIndex(array("id"), "foo_bar_idx");

        $tableB = new Table("foo");

        $tableB->addColumn('ID', 'integer');

        $tableB->addIndex(array("id"), "bar_foo_idx");

        $c = new Comparator();

        $tableDiff = new TableDiff('foo');

        $tableDiff->fromTable = $tableA;

        $tableDiff->renamedIndexes['foo_bar_idx'] = new Index('bar_foo_idx', array('id'));

        self::assertEquals(

            $tableDiff,

            $c->diffTable($tableA, $tableB)

        );

    }

    public function testCompareForeignKeyBasedOnPropertiesNotName()

    {