doctrine / dbal

    /**

     * @group DBAL-511

     */

    public function testDefaultValueCharacterVarying()

    {

        $testTable = new \Doctrine\DBAL\Schema\Table('dbal511_default');

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

        $testTable->addColumn('def', 'string', array('default' => 'foo'));

        $testTable->setPrimaryKey(array('id'));

        $this->_sm->createTable($testTable);

        $databaseTable = $this->_sm->listTableDetails($testTable->getName());

        $this->assertEquals('foo', $databaseTable->getColumn('def')->getDefault());

    }

    /**

     * @group DDC-2843

     * @group DBAL-50

     * @group DBAL-1063

     */

    public function testPrimaryKeyOverrulingUniqueIndexDoesNotDropUniqueIndex()

    {

        $table = new Table("bar");

        $table->addColumn('baz', 'integer', array());

        $table->addUniqueIndex(array('baz'), 'idx_unique');

        $table->setPrimaryKey(array('baz'));

        $indexes = $table->getIndexes();

        $this->assertEquals(2, count($indexes), "Table should only contain both the primary key table index and the unique one, even though it was overruled.");

        $this->assertTrue($table->hasPrimaryKey());

        $this->assertTrue($table->hasIndex('idx_unique'));

    }

    public function testAddingFulfillingRegularIndexOverridesImplicitForeignKeyConstraintIndex()

    {