doctrine / dbal

        $this->assertTrue($table->getIndex('my_idx')->spansColumns(array('id')));

    }

    public function testAddPrimaryKey_ColumnsAreExplicitlySetToNotNull()

    {

        $table = new Table("foo");

        $column = $table->addColumn("id", 'integer', array('notnull' => false));

        $this->assertFalse($column->getNotnull());

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

        $this->assertTrue($column->getNotnull());

    }

    /**

     * @group DDC-133

    /**

     * @group DBAL-79

     */

    public function testTableHasPrimaryKey()

    {

        $table = new Table("test");

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

        $table->addColumn("foo", "integer");

        $table->setPrimaryKey(array("foo"));

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

    }

    /**

     * @group DBAL-91

    /**

     * @group DBAL-224

     */

    public function testDropPrimaryKey()

    {

        $table = new Table("test");

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

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

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

        $table->dropPrimaryKey();

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

    }

    /**

     * @group DBAL-234