created_on not working

Jonathan Dobbie wrote:

created_on timestamp,
updated_on timestamp,
index(id)
) ENGINE=InnoDB
http://localhost/.../student/new has entries for created_on
and updated_on. I'd like these to be handled automatically.

I know that Rails will automatically update a field called 'updated_at' if you're using AR for session management. I've copied in my script below. I haven't used 'created_at' but I believe that works the same way. I'm using MySQL. I don't know whether or not that's a requirement.

hth,
Bill

create table sessions (
  id int not null auto_increment,
  sessid varchar(255),
  data text,
  updated_at datetime default NULL,
  primary key(id),
  index session_index (sessid)
) engine=InnoDB;