[TYPO3-core] RFC #6998.: Bugfix: Installation misses key-definition of table pages

[Steffen Müller]

Hi,

This is an SVN patch request.

Type: Bugfix

Bugtracker references:
http://bugs.typo3.org/view.php?id=6998

Branches:
4.2, trunk

Problem:
after setup (done with new install) these compare results are given:

ALTER TABLE pages DROP KEY parent;
ALTER TABLE pages ADD KEY parent (pid,sorting,deleted,hidden);

This is because the 1-2-3-tool uses /t3lib/stddb/tables.sql with:
KEY parent (pid,sorting)
but the Database Analyser COMPARE uses typo3/sysext/cms/ext_tables.sql with:
KEY parent (pid,sorting,deleted,hidden)

Solution:
move the hidden column from typo3/sysext/cms/ext_tables.sql to 
t3lib/stddb/tables.sql and extend the parent key in 
t3lib/stddb/tables.sql to pid,sorting,deleted,hidden


-- 
cheers,
Steffen
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bug_6998.diff
Type: text/x-patch
Size: 1603 bytes
Desc: not available
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20080509/0d51541b/attachment.bin