[Typo3-dev] ALTER TABLE with selfmade tables

[Kasper Skårhøj]

TYPO3 just doesn't "understand" the "UNIQUE" keyword and therefore shows
a discrepancy.

Annoying, no real problem, too small for me to fix in near future.

- kasper

On Tue, 2004-03-02 at 09:56, Thomas Hempel wrote:
> Hello,
> 
> I've added some mySQL Statements to my ext_tables.sql to create some 
> additional tables in database for my new extension. But I have a 
> problem. The table contains a unique field wich is declared like this
> 
> [...]
> fieldname int(11) unsigned DEFAULT '0' NOT NULL,
> [...]
> UNIQUE (fieldname),
> [...]
> 
> The sql statement is executed corectly without any failures. But 
> everytime I call the informationsite of the extension in 
> ExtensionManager I get the following messages with a checbox to alter 
> the table:
> 
> ALTER TABLE tx_myextension_mytable ADD UNIQUE (fieldname);
> 
> That nervs me. How can I prohibit that? Have I to add anything else in 
> any other file?
> 
> 
> Ciao Thomas
> 
> _______________________________________________
> Typo3-dev mailing list
> Typo3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
-- 

Best regards

- kasper

---------------
"Zero MS-gravity" - finally migrated to Linux!