Къде имам грешка ??

[TiMaTa]

Ето един СЯЛ и при него ми дава грешка :

CREATE TABLE `pastebin` (
`pid` int(11) NOT NULL auto_increment,
`poster` varchar(16) default NULL,
`posted` datetime default NULL,
`code` text,
`parent_pid` int(11) default '0',
`format` varchar(16) default NULL,
`codefmt` mediumtext,
`codecss` text,
`domain` varchar(255) default '',
`expires` DATETIME,
`expiry_flag` ENUM('d','m', 'f') NOT NULL DEFAULT 'm',
PRIMARY KEY (`pid`),
KEY `domain` (`domain`),
KEY `parent_pid`,
KEY `expires`
);

грешката е :

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 '
KEY `expires`
)' at line 15

 

[Galli]

CREATE TABLE `pastebin` (
`pid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`poster` varchar( 16 ) default NULL ,
`posted` datetime default NULL ,
`code` text,
`parent_pid` int( 11 ) default '0',
`format` varchar( 16 ) default NULL ,
`codefmt` mediumtext,
`codecss` text,
`domain` varchar( 255 ) default '',
`expires` DATETIME,
`expiry_flag` ENUM( 'd', 'm', 'f' ) NOT NULL DEFAULT 'm',
PRIMARY KEY ( `pid` ) ,
KEY ( `domain` ) ,
KEY ( `parent_pid` ) ,
KEY ( `expires` )
);

 

[TiMaTa]

Благодаря ти )) Къде беше грешката :? +1

 

[jooorooo]

KEY ( `parent_pid` ) ,
KEY ( `expires` )