Posted by Tony Peardon on 02/28/06 01:11

Hi all,

How do I timestamp a table? I have a table that contains references to the
files of a website. I want to track when the file is created, modified, and
published, and I also want to track if and when the file should be
refreshed, and so, I need to know how to make a timestamp.

create table files
(
---- cut
created date default ??thedate??, -- how do I timestamp?
modified date default ??thedate?? on update ??thedate??, --can I reset
the modified date automatically?
interval date default ??10 days??, -- can I do this? how?
refresh date default ??thedate+interval?? --can I add two dates??
published date on update ??resetrefresh?? -- can the refresh date be
reset automatically when the file is published?
);

Am I even barking up the right tree, or is this sort of stuff better handled
with php?

Please help.

Thanks.

[Back to original message]