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