[Typo3-dev] custom UID of table "pages"

Jean-Baptiste Rio triphot69 at hotmail.com
Tue Jun 7 12:34:08 CEST 2005


I think you have an another solution which is a better solution for 
Relational Database integrity compliance : Record your external keys as 
specific keys in the page table.

If i understand well , you plan to declare categories as top-level 
pages, and then to create your coursedata as subpages of these 
categories. In that case, why not :

- Add a new field to the Pages table which records the category id key 
for category pages
- Add a two fields to the Pages table which records the coursedata id 
for the first one, and the category id key of the coursedata of the 
second one.

When you import your XML files, instead of creating/updating the 
coursedata page as the child of the category page based on 
coursedata_page.pid = category_page.uid, you will create/update the 
coursedata page as the category child page based on 
coursedata_page.catid = category_page.xmlid, and then assign 
coursedata_page.pid = category_page.uid. Quite the same but without 
hacking Typo3 core.

Just M2P

JB




More information about the TYPO3-dev mailing list