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

[Steffen Kamper]

"Steffen Müller" <typo3 at t3node.com> schrieb im Newsbeitrag 
news:mailman.1.1210359066.9212.typo3-team-core at lists.netfielders.de...
> 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
>
+1 by reading, talking and testing

vg Steffen