Task #91909

Move sys_collection database tables into custom extension

Added by Benni Mack 14 days ago. Updated 11 days ago.

Status:
Resolved
Priority:
Should have
Assignee:
Category:
Code Cleanup
Target version:
Start date:
2020-07-31
Due date:
% Done:

100%

TYPO3 Version:
11
PHP Version:
Tags:
Complexity:
Sprint Focus:

Related issues

Related to TYPO3 Core - Bug #89695: Record collection - adding an item duplicates it New 2019-11-16

Associated revisions

Revision 0970231d (diff)
Added by Benni Mack 11 days ago

[!!!][TASK] Move sys_collection_* DB and TCA definitions into legacy_collections

A new TER Extension "legacy_collections" has been added to FriendsOfTYPO3
which contains DB tables and TCA definitions for "sys_collection" and its MM
relation table.

The functionality was originally intended with the introduction of taxonomy
and FAL File relations (which are stored in sys_file_collection) to be used
as a generic TCA store for collections, which was never picked up in the past
8 years.

A personal survey of several installations showed that almost none of the TYPO3
instances have the database tables filled, making this unneeded code
and database code, for only a handful of people.

Instead of providing the database tables by default in all installations, the
database tables and their TCA definitions are now available in a separate
extension "legacy_collections", which serves as a drop-in replacement
for everybody who needs this API and the database tables.

An update wizard checks if the sys_collection database table is filled,
and allows to install this extension.

The new extension is compatible with TYPO3 v10, so it should ease
the migration path.

Resolves: #91909
Releases: master
Change-Id: I85d53cc7969f9f9ce93311dd483be31735bf8c05
Reviewed-on: https://review.typo3.org/c/Packages/TYPO3.CMS/+/65147
Tested-by: Christian Kuhn <>
Tested-by: TYPO3com <>
Tested-by: Anja Leichsenring <>
Reviewed-by: Christian Kuhn <>
Reviewed-by: Anja Leichsenring <>

History

#1 Updated by Gerrit Code Review 14 days ago

  • Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/65147

#2 Updated by Gerrit Code Review 14 days ago

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/65147

#3 Updated by Gerrit Code Review 14 days ago

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/65147

#4 Updated by Gerrit Code Review 14 days ago

Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/65147

#5 Updated by Gerrit Code Review 13 days ago

Patch set 5 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/65147

#6 Updated by Christian Kuhn 11 days ago

  • Related to Bug #89695: Record collection - adding an item duplicates it added

#7 Updated by Gerrit Code Review 11 days ago

Patch set 6 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/65147

#8 Updated by Gerrit Code Review 11 days ago

Patch set 7 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/65147

#9 Updated by Gerrit Code Review 11 days ago

Patch set 8 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/65147

#10 Updated by Benni Mack 11 days ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100

Also available in: Atom PDF