Versuch es mal so:
Code:
CREATE TABLE CalendarNotes (
id char(36) NOT NULL,
date_entered datetime NOT NULL ,
date_modified datetime NOT NULL ,
assigned_user_id char(36),
created_by char(36),
modified_user_id char(36) NOT NULL ,
deleted bool DEFAULT 0 NOT NULL ,
type varchar(25),
date_start date NOT NULL ,
date_end date NOT NULL ,
name varchar(150),
date_selection varchar(10),
duration int DEFAULT 1,
repeat varchar(5) DEFAULT 'none',
repeat_times int DEFAULT 1,
repeat_weekday varchar(4) DEFAULT 'non',
repeat_monthday int DEFAULT 1,
repeat_month int DEFAULT 1,
PRIMARY KEY (id))