[TYPO3-dev] SQL parser odities

[Steffen Kamper]

"R. van Twisk" <typo3 at rvt.dds.nl> schrieb im Newsbeitrag 
news:mailman.50935.1164565530.30218.typo3-dev at lists.netfielders.de...
> 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
>
>
Hi Ries,

where do you defined that?
in ext_tables.sql ?

vg   Steffen

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