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

[Ingmar Schlecht]

Committed to trunk and TYPO3_4-2.

The only change I made to the patch is removing the superfluous / wrong 
comma after the last key of the pages table definition.

@Masi, I don't think it's that important where the TCA is defined, as 
it's both always included anyway as sysext/cms/ is a require ext. Hope 
the commit is OK with you.

cheers
Ingmar

Martin Kutschker schrieb:
> Steffen Müller schrieb:
>> 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)
> 
> And where is the tca definition for "hidden"? It should be there where 
> the field's sql definition is.
> 
> Masi


-- 
Ingmar Schlecht
TYPO3 Association Active Member
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 6998_v2.patch
Type: text/x-diff
Size: 1499 bytes
Desc: not available
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20080605/07ea2bbb/attachment.patch