Franz Holzinger wrote: on 23.07.2008 17:16:
> Hello
>
> Dmitry Dulepov [typo3] a écrit :
>> Franz Holzinger wrote:
>>> where can I find a function to alter the keys for a table in t3lib_DB ?
>>>
>>> I want to execute a SQL 'ALTER TABLE ...' command.
>>> But the function $TYPO3_DB->sql is marked as deprecated.
>> $GLOBALS['TYPO3_DB']->sql_query. But if you alter TYPO3 table, EM will
>> prompt you to restore it when you update extension. Altering tables is a
>> task reserved to TYPO3 core by default.
>
> But I should drop the keys before starting a long import script. And
> after this has finished, the keys must be created again.
You don't need to drop the keys, just use:
ALTER TABLE table DISABLE KEYS;
and after finishing the import
ALTER TABLE table ENABLE KEYS;
This is of course MySQL specific.
Cheers,
Ernesto
_______________________________________________
TYPO3-dev mailing list
TYPO3-dev@...
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
