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]