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

[Jan-Martin Ziem]

hi devlist,

Ries van Twisk wrote:
> 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
> );
> 

problems with internal sql parser/wrapper are nothing new. esp. if you 
need support for something like "fulltext" etc.
other failures of this parser:
- fulltext or special types
- special key types (fulltext search keys etc.)
- within older versions: even to much space chars between key and 
keyname, or just linebreaks
- complex keys
- MANY type failures - but you don't have these types within your 
extension manager / kickstarter, so it seems that these standard types 
are just not supported. (try an enum!)


best wishes, jan