Different TIMESTAMP columns

[Lieven De Keyzer]

I 'm writing a webapplication in Java that allows users to store bookmarks. 
The system scans these pages for differences at user-selected intervals. At 
another user-selected interval, the system sends notification mails about 
changed bookmarks. The bookmark table provisionally looks like this:

CREATE TABLE bookmark (
 bookmark_id INTEGER NOT NULL AUTO_INCREMENT,
 bookmarkname VARCHAR (80) NOT NULL,
 url VARCHAR (150) NOT NULL,
 folder_id INTEGER NOT NULL,
 last_scanned TIMESTAMP NOT NULL,
 PRIMARY KEY (bookmark_id),
 FOREIGN KEY (folder_id) REFERENCES folder(folder_id) ON DELETE CASCADE) 
TYPE = InnoDB;

I want to add another TIMESTAMP column, last_notified. But whenever I insert 
a new bookmark, the first TIMESTAMP column will be set, the other will be 
0000-00-00 00:00:00.
When they get mapped by the iBatis framework to Java objects, I get an 
exception that aTimestamp object can not be created with 0000-00-00 00:00:0

Is there a way I can set them both when the bookmark is created? I rather 
not set one of them to NULL, because that would imply a lot more code to 
check if a user should be notified or a bookmark should be scanned.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]