Project

General

Profile

Actions

Bug #17171

closed

4.1.1RC1: DB Checks suggest to 'DROP KEY uid'

Added by Franz Holzinger over 17 years ago. Updated over 16 years ago.

Status:
Closed
Priority:
Should have
Category:
Install Tool
Target version:
-
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;
-------------

#
  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)


Files

sys_orders_uid.png (21.9 KB) sys_orders_uid.png Administrator Admin, 2007-03-30 09:31
Actions

Also available in: Atom PDF