[TYPO3-dev] SQL parser odities

[R. van Twisk]

Hey All,

I defined this table

CREATE TABLE tx_extensioname_index (
    otype             varchar(24)  DEFAULT '' NOT NULL,
    fname             varchar(24)  DEFAULT '' NOT NULL,
    fvalue             varchar(64)  DEFAULT '' NOT NULL,
    record_uid        int(11)         DEFAULT '0' NOT NULL,
    KEY lookup(otype, fname)
)


But for some reason the SQL parser creates something weird,
of it during extension installation:


     CREATE TABLE tx_extensioname_index (
otype varchar(24) NOT NULL default '',
fname varchar(24) NOT NULL default '',
fvalue varchar(64) NOT NULL default '',
record_uid int(11) DEFAULT '0' NOT NULL,
) ,
KEY lookup(otype, fname)
);

Why would the SQL parser add an extra ) , before the KEY?

Ries



-- 
Ries van Twisk
Freelance Typo3 Developer
=== Private:
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/freelance-typo3.html
skype: callto://r.vantwisk