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

[Michael Stucki]

Hi Ries,

if you rewrite your mail in a more readable form then I will probably find
out what your problem is. But for now I have no idea...

(see below)

- michael

> when I create a ext_tables.sql file in my extention then my sql is
> rewritten (obviosly) but also incorrect SQL is created.
> Here is a example:
> 
> This is the created SQL
> CREATE TABLE ip4_0 (
> ( ,
> b tinyint UNSIGNED NOT NULL, -- second byte of quad,
> c tinyint UNSIGNED NOT NULL, -- third byte of quad,
> country smallint UNSIGNED NOT NULL, -- <65536 countries,
> city smallint UNSIGNED NOT NULL, -- <65536 cities,
> cron TIMESTAMP NOT NULL,
> KEY kCountry(country) ,
> KEY kCity(city) ,
> KEY kb(b) ,
> KEY kc(c) ,
> KEY kcron(cron)
> );
> 
>  From this table:
> CREATE TABLE ip4_0
>     (
>     b                tinyint UNSIGNED NOT NULL,        -- second byte of
> quad
>     c                tinyint UNSIGNED NOT NULL,        -- third byte of
>     quad
>     country            smallint UNSIGNED NOT NULL,        -- <65536
> countries
>     city            smallint UNSIGNED NOT NULL,        -- <65536 cities
>     cron            TIMESTAMP NOT NULL,
>     KEY                kCountry(country),
>     KEY                kCity(city),
>     KEY                kb(b),
>     KEY                kc(c),
>     KEY                kcron(cron)
>     );
> 
> My first thought is that the SQL parser 'expects' a autonumbering field,
> Can anybody confirm this?
> 
> Is there any workaround to this???
> 
> cheers,
> Ries
> 
> 
> 

-- 
Use a newsreader! Check out
http://typo3.org/community/mailing-lists/use-a-news-reader/