error in your SQL syntax near 'NOW() NOT NULL

Pavel Chytil paja@asp.ogi.edu
Sun, 9 Dec 2001 16:03:40 -0800


 Hello,

 I have tried to create table for kronolith (using kronolith/docs/kronolith.sql
 from cvs) in mysql and get following error:

 mysql> CREATE TABLE kronolith_events (
     ->     event_id bigint DEFAULT 0 NOT NULL,
     ->     calendar_id varchar(255) NOT NULL,
     ->     event_description text,
     ->     event_location text,
     ->     event_keywords text,
     ->     event_title varchar(80),
     ->     event_category varchar(80),
     ->     event_recurtype varchar(11) DEFAULT '0',
     ->     event_recurinterval varchar(11),
     ->     event_recurdays varchar(11),
     ->     event_recurenddate datetime,
     ->     event_start datetime DEFAULT NOW() NOT NULL,
     ->     event_end datetime DEFAULT NOW() NOT NULL,
     ->     event_alarm int DEFAULT 0,
     ->     PRIMARY KEY (event_id)
     -> );
 ERROR 1064: You have an error in your SQL syntax near 'NOW() NOT NULL,
     event_end datetime DEFAULT NOW() NOT NULL,
     event_alarm i' at line 13
 mysql>

 Any advice?
 Thanks,
         Pavel