[Typo3] alter and current value in ext_tables.sql

Mathias Schreiber [wmdb>] mathias.schreiber at wmdb.de
Mon Jul 18 09:13:13 CEST 2005

Bartosz Aninowski wrote:
> I am developing my own extension
> I put table definitions in ext_tables.sql.
> Everytime I want to reload extension EM ask about ALTER table.
> EM wants to ALTER fileds which exist or change another
> fg
> ALTER TABLE tx_evpr_dictionary_groups DROP PRIMARY KEY;
> ALTER TABLE tx_evpr_dictionary_groups ADD PRIMARY KEY (uid);
> or
> ALTER TABLE tx_evpr_type_aal CHANGE aal_hotfeet aal_hotfeet int(11) NOT 
> Current value: int(11) NOT NULL default '0'

This is a known problem due to a bug in the kickstarter.
A workaround is to edit the exttables.sql file and set it to the syntax 
of your mysql version

if ($GLOBALS['TSFE']->fe_user->user['ahnung'] == 0) {
	$this->fresseHalten = 1;

More information about the TYPO3-english mailing list