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;