Project

General

Profile

Actions

Bug #76636

closed

Install Tool DB Analyzer is not aware of FOREIGN KEY constraints

Added by Viktor Livakivskyi over 8 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Install Tool
Target version:
-
Start date:
2016-06-15
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
7
PHP Version:
5.6
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

Hi,

This is a reborn of #18651 and #17160.

I have in my ext_tables.sql:
FOREIGN KEY fe_users_uid (user) REFERENCES fe_users (uid)

Which is correctly shown in DB Analyzer:
ALTER TABLE tx_mytable ADD FOREIGN KEY fe_users_uid (user) REFERENCES fe_users (uid);

After execution the constraint is correctly created in DB, but Install Tool still prompts me to ALTER TABLE.


Related issues 2 (0 open2 closed)

Has duplicate TYPO3 Core - Bug #18651: Extension Manager does not recognize more than one foreign keyClosed2008-04-20

Actions
Has duplicate TYPO3 Core - Bug #17160: EM doesn't recognize FOREIGN key constraints in ext_tables.sqlClosedChris topher2007-03-27

Actions
Actions #1

Updated by Morton Jonuschat almost 8 years ago

  • Status changed from New to Needs Feedback

Hi,

this issue is very old. Does the problem still exist within newer versions of TYPO3 CMS (8.3+)?
This should have been be fixed by the migration to the Doctrine SchemaManager which supports foreign keys.

Actions #2

Updated by Riccardo De Contardi over 7 years ago

  • Status changed from Needs Feedback to Closed

No feedback since the last 90 days > closing.

If you think that this is the wrong decision or experience the issue again then please reopen it or open a new issue with a reference to this one. Thank you.

Actions

Also available in: Atom PDF