#171714.1.1RC1: DB Checks suggest to 'DROP KEY uid'
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)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.