[TYPO3-dev] SQL parser odities

[R. van Twisk]

Steffen Kamper wrote:
> "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
>   
Yes Sir!!!

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