Hi, I need two columns in tables of MySQL/Postgres:
- "created" (timestamp/datetime)
- "last_modified" (timestamp/datetime)
I want to avoid doing it with Ruby ("table[:created] = Time.now" and so) as I
expect it's much faster if we let this job for the database itself.
How could I tell Sequel to create a column datetime column with default value
"NOW()"? Of course the following doesn't work:
column :modified, DateTime, :default => "NOW()"
Also I need it working for MySQL and Postgres.
Obviously "created" must be set to NOW() by the database when creating the
row, and "last_modified" must be set to NOW() by the database when updating
it.
Is it possible with Sequel::Schema::Generator ?
Thanks a lot.
--
Iñaki Baz Castillo <[email protected]>
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
