Auto_migrations does not like :timestamp

Fields defined as :timestamp do not live well with db:auto:migrate.

They are compared to the database, which presents the field as datetime.

Rails converts timestamp fields into datetime fields:

http://jacqueschirag.wordpress.c...

The rake task throws an error about the invalid default value. I don't know why the default value is set to ''.

** Execute db:auto:migrate

-- change_column("us_hits", :timestamp, :timestamp)

rake aborted!

Mysql::Error: Invalid default value for 'timestamp': ALTER TABLE us_hits CHANGE timestamp timestamp datetime DEFAULT ''

Here is the table definition:

create_table "us_hits", :force => true do |t|

t.column "timestamp", :timestamp

end