[Typo3-dev] Incorrect SQL when creating tables using ext_tables.sql

[Ries van Twisk]

Ruport,

if you create the table with the kickstarter then everything is fine,
it happens when you place the ( on the second line of your table, like this

CREATE TABLE mytable
(

b tinyint UNSIGNED NOT NULL
);


I use mysql 4.1.x, but it's a typo3 SQL parser issue,

Ries

>Hi Ries,
>
>Ries van Twisk wrote:
>  
>
>>this happens in all typo3 versions >= 3.7.0 including 3.8.0beta 2.1
>>    
>>
>
>I tried to reproduce this with no succes. I created a new extension with the
>kickstarter (from cvs) added a table and inserted the sql lines from your
>mail. Then I installed the extension and the extmanager showed the correct
>syntax:
>
>CREATE TABLE tx_bla_test (
>b tinyint UNSIGNED NOT NULL,
>c tinyint UNSIGNED NOT NULL,
>....
>
>no extra comma.
>
>which MySQL version do you use ?
>
>greets
>rupi
>_______________________________________________
>Typo3-dev mailing list
>Typo3-dev at lists.netfielders.de
>http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
>  
>


-- 
R. van Twisk
http://www.metamorf.net

Our Typo3 enabled website: http://www.livetravelguides.com
Instand help for Typo3?    irc:/irc.freenode.net/typo3
Looking for documentation? http://typo3.org/documentation/