Sql error Opcje

[prest]

Hej

Ktos moze ma pojecie gdzie jest problem

[SQL] pobierz, plaintext 
SQL query: 
 
CREATE TABLE calendar( 
cal_id int NOT NULL AUTO_INCREMENT , 
owner_id int, 
titlechar( 80 ) , 
notechar( 120 ) , 
date date, 
starttimechar( 5 ) , 
stoptimechar( 5 ) , 
repeat enum( 'Y', 'N' ) DEFAULT 'N', 
interv int, 
repeattype enum( 'DAY', 'WEEK', 'MONTH', 'YEAR' ) , 
until date, 
lastupdate date, 
updateby int, 
calread enum( 'Y', 'N' ) DEFAULT 'N', 
calwrite enum( 'Y', 'N' ) DEFAULT 'N', 
calupdate enum( 'Y', 'N' ) DEFAULT 'N', 
caldelete enum( 'Y', 'N' ) DEFAULT 'N', 
PRIMARY KEY ( cal_id ) 
) 
 
MySQL said: Documentation 
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'repeat enum('Y','N') DEFAULT 'N', 
interv int, 
repeattype enum('DAY','WEEK','M' at line 9
[SQL] pobierz, plaintext 

[sf]

a nie podałem? (IMG:http://forum.php.pl/style_emoticons/default/snitch.gif)

[prest]

a nie podałem? (IMG:http://forum.php.pl/style_emoticons/default/snitch.gif)

nie jestem na tyle obeznany z sql (IMG:http://forum.php.pl/style_emoticons/default/smile.gif) niestety potzrebuje syntax sorki