trying to create a table using migrations

Hi All

I’ve my migration (only one table) ready. But when I execute it I get the following:

I get the impression it has a problem with a table which already exists and has the same name. However, there are no tables in that database at all!!

For the migration I only created the migration directory and in there I have the the following file

m110216_150215_create_user_table

<?php


class m110216_150215_create_user_table extends CDbMigration

{

    public function up()

    {

    	$this->createTable('tbl_user', array(

            'id'           => 'pk',

            'name'         => 'string NOT NULL',

            'surname'      => 'string NOT NULL',

            'organisation' => 'string NOT NULL',

            'email'        => 'string NOT NULL',

            'phone'        => 'string NOT NULL',

            'created_time' => 'timestamp NOT NULL DEFAULT "0000-00-00 00:00:00"',

  	    'update_time'  => 'timestamp NOT NULL DEFAULT "0000-00-00 00:00:00" ON UPDATE CURRENT_TIMESTAMP',

        ));

    }


    public function down()

    {

    	$this->dropTable('tbl_user');

    }

}

Any suggestion why I get this error ?

I found it. In config/console.php you need to define the connection again. In there it was set to sqlite. I found out because I noticed in protected/data a file testdrive.db was created!