Issue Bug Closed

#171714.1.1RC1: DB Checks suggest to 'DROP KEY uid'

Franz Holzinger 03/30/07, 09:24 updated 06/27/08, 10:50

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;
——————-

#
  1. 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.