[Typo3-dev] ALTER TABLE with selfmade tables

Thomas Hempel thomas at work.de
Tue Mar 2 09:56:23 CET 2004


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





More information about the TYPO3-dev mailing list