Actions
Bug #17171
closed4.1.1RC1: DB Checks suggest to 'DROP KEY uid'
Start date:
2007-03-30
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
4.1
PHP Version:
5.1
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
With the current 4.1.1RC1 and globally installed tt_products the Database Analyzer always suggests to drop the uid key of the sys_products_orders table. The box is unchecked. This is however not recommended, because the listing of orders would be much slower then. And I do not understand why this key should not remain. I even think it is necessary with TYPO3. The EM does not suggest this too.
--------------
Drop fields (really!)
ALTER TABLE sys_products_orders DROP KEY uid;
-------------
- Table structure for table 'sys_products_orders'
#
CREATE TABLE sys_products_orders (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
...
PRIMARY KEY (uid),
KEY parent (pid),
KEY tracking (tracking_code),
KEY status (status)
);
(issue imported from #M5327)
Files
Actions