Problems loading schema

Rails
1

Hi there,
I’m trying to a db:schema:load into an empty database(mysql5) and am
having some trouble with timestamps and created_at fields:

t.column "created_at", :datetime, :default => Sun Jan 01 00:00:00

EST 2006, :null => false
t.column “updated_at”, :datetime, :default => Sun Jan 01 00:00:00
EST 2006, :null => false

when I run the rake task I get:

13:08:41:rails #> rake db:schema:load --trace
(in /Users/dorian/Sites/animate/rails)
** Invoke db:schema:load (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:schema:load
rake aborted!
./db/schema.rb:30: parse error, unexpected tCONSTANT, expecting kDO or
‘{’ or ‘(’
t.column “created_at”, :datetime, :default => Sun Jan 01 00:00:00
EST 2006, :null => false
^
./db/schema.rb:31: parse error, unexpected tCONSTANT, expecting kDO or
‘{’ or ‘(’
t.column “updated_at”, :datetime, :default => Sun Jan 01 00:00:00
EST 2006, :null => false
^
./db/schema.rb:234: parse error, unexpected tCONSTANT, expecting kDO or
‘{’ or ‘(’
t.column “created_at”, :datetime, :default => Sun Jan 01 00:00:00
EST 2006, :null => false
^
./db/schema.rb:235: parse error, unexpected tCONSTANT, expecting kDO or
‘{’ or ‘(’
t.column “updated_at”, :datetime, :default => Sun Jan 01 00:00:00
EST 2006, :null => false
^
./db/schema.rb:292: parse error, unexpected tCONSTANT, expecting kDO or
‘{’ or ‘(’
t.column “timecode”, :time, :default => Sat Jan 01 00:00:00 EST 2000

these values were already in the schema file and weren’t edited by me,
so I’m not quite sure how that happened.
Can anyone see what might be wrong?

I’m using rails 1.1.6

thanks

dorian

–
I do things for love or money

2

On 11/20/06, Dorian M. [email protected] wrote:

(in /Users/dorian/Sites/animate/rails)
^
these values were already in the schema file and weren’t edited by me, so I’m not quite sure how that happened.

Dorian,

Try this:

t.column “created_at”, :datetime, :default =>
Date.new(2006,1,1).to_time.to_s(:db), :null => false
t.column “updated_at”, :datetime, :default =>
Date.new(2006,1,1).to_time.to_s(:db), :null => false

–
Zack C.
http://depixelate.com
http://trackplace.com