On Thu, Mar 20, 2003 at 03:52:41PM -0500, Stephen Hedges said:
Hi, Paul. Looks like you've been busy! I have a couple of comments on your notes:
timestamp 005 DATE AND TIME OF LATEST TRANSACTION [computer generated] / ==> for instance, timestamp is not auto-managed in koha. It should be possible to develop a plugin to do this./
Now that I'm beginning to become a semi-geek :-) , it seems to me that the timestamp columns in Koha would be automatically updated by MySQL whenever the record is inserted or updated, so long as that column is not specifically addressed. I'm basing this on http://www.mysql.com/doc/en/DATETIME.html . Maybe somebody on the developers list can confirm that?
Thats right, mysql handles this for us. Paul may be thinking to make it less mysql specific tho, so that it would still work with another database engine that doesnt have this neat feature. Speaking of neat features, now mysql 4 is stable, i cant wait to ply with the query cache, i think it will give us lots of improvements especially in circulation. Chris