[BUGFIX] Ensure dynamically added TCA DB fields are added first 55/57155/4
authorBenni Mack <benni@typo3.org>
Sat, 9 Jun 2018 13:02:46 +0000 (15:02 +0200)
committerSusanne Moog <susanne.moog@typo3.org>
Sat, 9 Jun 2018 14:41:42 +0000 (16:41 +0200)
The new functionality introduced in #85160 adds TCA control
database fields dynamically.
However, newly created extensions add these fields (except "uid"
which is a primary column) at the end after the content-related
fields.

The patch re-orders the columns to be added to move them to the
very beginning.

Resolves: #85195
Related: #85160
Releases: master
Change-Id: Ibcf77ae3fea41f067dca0f247bef50d00bdd014f
Reviewed-on: https://review.typo3.org/57155
Tested-by: TYPO3com <no-reply@typo3.com>
Reviewed-by: Anja Leichsenring <aleichsenring@ab-softlab.de>
Tested-by: Anja Leichsenring <aleichsenring@ab-softlab.de>
Reviewed-by: Susanne Moog <susanne.moog@typo3.org>
Tested-by: Susanne Moog <susanne.moog@typo3.org>
typo3/sysext/core/Classes/Database/Schema/DefaultTcaSchema.php
typo3/sysext/core/Classes/Database/Schema/SchemaMigrator.php
typo3/sysext/impexp/Tests/Functional/Fixtures/XmlExports/impexp-group-file-and-file_reference-item-but-images-not-included.xml
typo3/sysext/impexp/Tests/Functional/Fixtures/XmlExports/impexp-group-file-and-file_reference-item-in-ff.xml
typo3/sysext/impexp/Tests/Functional/Fixtures/XmlExports/impexp-group-file-and-file_reference-item.xml
typo3/sysext/impexp/Tests/Functional/Fixtures/XmlExports/irre-records.xml
typo3/sysext/impexp/Tests/Functional/Fixtures/XmlExports/pages-and-ttcontent-with-corrupt-image.xml
typo3/sysext/impexp/Tests/Functional/Fixtures/XmlExports/pages-and-ttcontent-with-image-but-not-included.xml
typo3/sysext/impexp/Tests/Functional/Fixtures/XmlExports/pages-and-ttcontent-with-image.xml
typo3/sysext/impexp/Tests/Functional/Fixtures/XmlExports/pages-and-ttcontent.xml

index 7be52fa..4247253 100644 (file)
@@ -520,6 +520,89 @@ class DefaultTcaSchema
     }
 
     /**
+     * If the enrich() method adds fields, they should be added in the beginning of a table.
+     *
+     * @param string $tableName
+     * @return string[]
+     */
+    public function getPrioritizedFieldNames(string $tableName): array
+    {
+        if (!isset($GLOBALS['TCA'][$tableName])) {
+            return [];
+        }
+
+        $prioritizedFieldNames = [
+            'uid',
+            'pid'
+        ];
+
+        $tableDefinition = $GLOBALS['TCA']['ctrl'];
+
+        if (!empty($tableDefinition['crdate'])) {
+            $prioritizedFieldNames[] = $tableDefinition['crdate'];
+        }
+        if (!empty($tableDefinition['tstamp'])) {
+            $prioritizedFieldNames[] = $tableDefinition['tstamp'];
+        }
+        if (!empty($tableDefinition['cruser_id'])) {
+            $prioritizedFieldNames[] = $tableDefinition['cruser_id'];
+        }
+        if (!empty($tableDefinition['delete'])) {
+            $prioritizedFieldNames[] = $tableDefinition['delete'];
+        }
+        if (!empty($tableDefinition['enablecolumns']['disabled'])) {
+            $prioritizedFieldNames[] = $tableDefinition['enablecolumns']['disabled'];
+        }
+        if (!empty($tableDefinition['enablecolumns']['starttime'])) {
+            $prioritizedFieldNames[] = $tableDefinition['enablecolumns']['starttime'];
+        }
+        if (!empty($tableDefinition['enablecolumns']['endtime'])) {
+            $prioritizedFieldNames[] = $tableDefinition['enablecolumns']['endtime'];
+        }
+        if (!empty($tableDefinition['enablecolumns']['fe_group'])) {
+            $prioritizedFieldNames[] = $tableDefinition['enablecolumns']['fe_group'];
+        }
+        if (!empty($tableDefinition['languageField'])) {
+            $prioritizedFieldNames[] = $tableDefinition['languageField'];
+            if (!empty($tableDefinition['transOrigPointerField'])) {
+                $prioritizedFieldNames[] = $tableDefinition['transOrigPointerField'];
+                $prioritizedFieldNames[] = 'l10n_state';
+            }
+            if (!empty($tableDefinition['translationSource'])) {
+                $prioritizedFieldNames[] = $tableDefinition['translationSource'];
+            }
+            if (!empty($tableDefinition['transOrigDiffSourceField'])) {
+                $prioritizedFieldNames[] = $tableDefinition['transOrigDiffSourceField'];
+            }
+        }
+        if (!empty($tableDefinition['sortby'])) {
+            $prioritizedFieldNames[] = $tableDefinition['sortby'];
+        }
+        if (!empty($tableDefinition['descriptionColumn'])) {
+            $prioritizedFieldNames[] = $tableDefinition['descriptionColumn'];
+        }
+        if (!empty($tableDefinition['editlock'])) {
+            $prioritizedFieldNames[] = $tableDefinition['editlock'];
+        }
+        if (!empty($tableDefinition['origUid'])) {
+            $prioritizedFieldNames[] = $tableDefinition['origUid'];
+        }
+        if (!empty($tableDefinition['versioningWS'])) {
+            $prioritizedFieldNames[] = 't3ver_wsid';
+            $prioritizedFieldNames[] = 't3ver_oid';
+            $prioritizedFieldNames[] = 't3ver_state';
+            $prioritizedFieldNames[] = 't3ver_stage';
+            $prioritizedFieldNames[] = 't3ver_id';
+            $prioritizedFieldNames[] = 't3ver_move_id';
+            $prioritizedFieldNames[] = 't3ver_count';
+            $prioritizedFieldNames[] = 't3ver_tstamp';
+            $prioritizedFieldNames[] = 't3ver_label';
+        }
+
+        return $prioritizedFieldNames;
+    }
+
+    /**
      * True if table with given table name is defined within incoming $tables array
      *
      * @param Table[] $tables
index ebd3e2f..178fb04 100644 (file)
@@ -271,17 +271,44 @@ class SchemaMigrator
         // Flatten the array of arrays by one level
         $tables = array_merge(...$tables);
 
+        // @deprecated (?!) Drop any definition of pages_language_overlay in SQL
+        // will be removed in TYPO3 v10.0 once the feature is enabled by default
+        $disabledPagesLanguageOverlay = GeneralUtility::makeInstance(Features::class)->isFeatureEnabled('unifiedPageTranslationHandling');
+
+        // Add default TCA fields
         $defaultTcaSchema = GeneralUtility::makeInstance(DefaultTcaSchema::class);
         $tables = $defaultTcaSchema->enrich($tables);
+        // Ensure the default TCA fields are ordered
+        foreach ($tables as $k => $table) {
+            if ($disabledPagesLanguageOverlay && $table->getName() === 'pages_language_overlay') {
+                unset($tables[$k]);
+                continue;
+            }
+            $prioritizedColumnNames = $defaultTcaSchema->getPrioritizedFieldNames($table->getName());
+            // no TCA table
+            if (empty($prioritizedColumnNames)) {
+                continue;
+            }
 
-        // @deprecated (?!) Drop any definition of pages_language_overlay in SQL
-        // will be removed in TYPO3 v10.0 once the feature is enabled by default
-        if (GeneralUtility::makeInstance(Features::class)->isFeatureEnabled('unifiedPageTranslationHandling')) {
-            foreach ($tables as $k => $table) {
-                if ($table->getName() === 'pages_language_overlay') {
-                    unset($tables[$k]);
+            $prioritizedColumns = [];
+            $nonPrioritizedColumns = [];
+
+            foreach ($table->getColumns() as $columnObject) {
+                if (in_array($columnObject->getName(), $prioritizedColumnNames, true)) {
+                    $prioritizedColumns[] = $columnObject;
+                } else {
+                    $nonPrioritizedColumns[] = $columnObject;
                 }
             }
+
+            $tables[$k] = new Table(
+                $table->getName(),
+                array_merge($prioritizedColumns, $nonPrioritizedColumns),
+                $table->getIndexes(),
+                $table->getForeignKeys(),
+                0,
+                $table->getOptions()
+            );
         }
 
         return $tables;
index 6639567..f4ccb86 100644 (file)
                <tablerow index="pages:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="perms_everybody">15</field>
                                <field index="title">Root</field>
                                <field index="doktype">1</field>
-                               <field index="pid">0</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                        </fieldlist>
                <tablerow index="tx_impexpgroupfiles_item:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="title">Test item</field>
                                <field index="images">typo3_image4.jpg</field>
                                <field index="image_references">fileadmin/user_upload/typo3_image5.jpg</field>
-                               <field index="pid">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                        </fieldlist>
                <tablerow index="sys_file:3" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">3</field>
+                               <field index="pid">0</field>
                                <field index="storage">1</field>
                                <field index="type">2</field>
                                <field index="metadata">0</field>
                                <field index="size">7425</field>
                                <field index="creation_date">1393432184</field>
                                <field index="modification_date">1393432183</field>
-                               <field index="pid">0</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="storage" type="array">
                <tablerow index="sys_file_storage:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="name">fileadmin/ (auto-created)</field>
                                <field index="driver">Local</field>
                                <field index="configuration">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot; standalone=&quot;yes&quot; ?&gt;
                                <field index="is_public">1</field>
                                <field index="is_writable">1</field>
                                <field index="is_online">1</field>
-                               <field index="pid">0</field>
                                <field index="description" type="NULL"></field>
                        </fieldlist>
                        <related index="rels" type="array">
index cd0ba34..dfea130 100644 (file)
                <tablerow index="pages:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="perms_everybody">15</field>
                                <field index="title">Dummy 1-2</field>
                                <field index="doktype">1</field>
-                               <field index="pid">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                        </fieldlist>
                <tablerow index="tx_impexpgroupfiles_item:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">2</field>
                                <field index="title">Test item 2</field>
                                <field index="images"></field>
                                <field index="image_references"></field>
                &lt;/sheet&gt;
        &lt;/data&gt;
 &lt;/T3FlexForms&gt;</field>
-                               <field index="pid">2</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                        </fieldlist>
                <tablerow index="sys_file:3" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">3</field>
+                               <field index="pid">0</field>
                                <field index="storage">1</field>
                                <field index="type">2</field>
                                <field index="metadata">0</field>
                                <field index="size">7425</field>
                                <field index="creation_date">1393432184</field>
                                <field index="modification_date">1393432183</field>
-                               <field index="pid">0</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="storage" type="array">
                <tablerow index="sys_file:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">0</field>
                                <field index="storage">1</field>
                                <field index="type">2</field>
                                <field index="metadata">0</field>
                                <field index="size">5565</field>
                                <field index="creation_date">1393346082</field>
                                <field index="modification_date">1392907534</field>
-                               <field index="pid">0</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="storage" type="array">
                <tablerow index="sys_file_storage:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="name">fileadmin/ (auto-created)</field>
                                <field index="driver">Local</field>
                                <field index="configuration">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot; standalone=&quot;yes&quot; ?&gt;
                                <field index="is_public">1</field>
                                <field index="is_writable">1</field>
                                <field index="is_online">1</field>
-                               <field index="pid">0</field>
                                <field index="description" type="NULL"></field>
                        </fieldlist>
                        <related index="rels" type="array">
index 2bffaab..96662ae 100644 (file)
                <tablerow index="pages:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="perms_everybody">15</field>
                                <field index="title">Root</field>
                                <field index="doktype">1</field>
-                               <field index="pid">0</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                        </fieldlist>
                <tablerow index="tx_impexpgroupfiles_item:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="title">Test item</field>
                                <field index="images">typo3_image4.jpg</field>
                                <field index="image_references">fileadmin/user_upload/typo3_image5.jpg</field>
-                               <field index="pid">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                        </fieldlist>
                <tablerow index="sys_file:3" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">3</field>
+                               <field index="pid">0</field>
                                <field index="storage">1</field>
                                <field index="type">2</field>
                                <field index="metadata">0</field>
                                <field index="size">7425</field>
                                <field index="creation_date">1393432184</field>
                                <field index="modification_date">1393432183</field>
-                               <field index="pid">0</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="storage" type="array">
                <tablerow index="sys_file_storage:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="name">fileadmin/ (auto-created)</field>
                                <field index="driver">Local</field>
                                <field index="configuration">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot; standalone=&quot;yes&quot; ?&gt;
                                <field index="is_public">1</field>
                                <field index="is_writable">1</field>
                                <field index="is_online">1</field>
-                               <field index="pid">0</field>
                                <field index="description" type="NULL"></field>
                        </fieldlist>
                        <related index="rels" type="array">
index c6e62da..dcfd5a7 100644 (file)
                <tablerow index="pages:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="perms_everybody">15</field>
                                <field index="title">IRRE</field>
                                <field index="doktype">1</field>
-                               <field index="pid">0</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                        </fieldlist>
                <tablerow index="tt_content:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="CType">text</field>
                                <field index="header">Test content</field>
-                               <field index="pid">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                                <field index="t3ver_oid">0</field>
                <tablerow index="tx_irretutorial_1ncsv_hotel:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="title">Hotel 2 (csv)</field>
                                <field index="offers">3</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_1ncsv_hotel:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="title">Hotel 1 (csv)</field>
                                <field index="offers">1,2</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_1ncsv_offer:3" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">3</field>
+                               <field index="pid">1</field>
                                <field index="title">Offer 2.2 (csv)</field>
                                <field index="prices">3</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_1ncsv_offer:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="title">Offer 1.2 (csv)</field>
                                <field index="prices">2</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_1ncsv_offer:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="title">Offer 1.1 (csv)</field>
                                <field index="prices">1</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_1ncsv_price:3" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">3</field>
+                               <field index="pid">1</field>
                                <field index="title">Price 2.2.1 (csv)</field>
                                <field index="price">112.00</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_1ncsv_price:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="title">Price 1.2.1 (csv)</field>
                                <field index="price">90.00</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_1ncsv_price:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="title">Price 1.1.1 (csv)</field>
                                <field index="price">567.00</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_1nff_hotel:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="parentid">1</field>
                                <field index="parenttable">tt_content</field>
                                <field index="parentidentifier"></field>
                                <field index="title">Hotel 1 (nff)</field>
                                <field index="offers">2</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_1nff_hotel:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="parentid">1</field>
                                <field index="parenttable">tt_content</field>
                                <field index="parentidentifier"></field>
                                <field index="title">Hotel 2 (nff)</field>
                                <field index="offers">1</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_1nff_offer:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="parentid">1</field>
                                <field index="parenttable">tx_irretutorial_1nff_hotel</field>
                                <field index="parentidentifier"></field>
                                <field index="title">Offer 1.1 (nff)</field>
                                <field index="prices">2</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_1nff_offer:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="parentid">1</field>
                                <field index="parenttable">tx_irretutorial_1nff_hotel</field>
                                <field index="parentidentifier"></field>
                                <field index="title">Offer 1.2 (nff)</field>
                                <field index="prices">1</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_1nff_offer:3" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">3</field>
+                               <field index="pid">1</field>
                                <field index="parentid">2</field>
                                <field index="parenttable">tx_irretutorial_1nff_hotel</field>
                                <field index="parentidentifier"></field>
                                <field index="title">Offer 2.1 (nff)</field>
                                <field index="prices">1</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_1nff_price:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="parentid">1</field>
                                <field index="parenttable">tx_irretutorial_1nff_offer</field>
                                <field index="parentidentifier"></field>
                                <field index="title">Price 1.1.1 (nff)</field>
                                <field index="price">4.00</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_1nff_price:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="parentid">1</field>
                                <field index="parenttable">tx_irretutorial_1nff_offer</field>
                                <field index="parentidentifier"></field>
                                <field index="title">Price 1.1.2 (nff)</field>
                                <field index="price">869.00</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_1nff_price:3" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">3</field>
+                               <field index="pid">1</field>
                                <field index="parentid">2</field>
                                <field index="parenttable">tx_irretutorial_1nff_offer</field>
                                <field index="parentidentifier"></field>
                                <field index="title">Price 1.2.1 (nff)</field>
                                <field index="price">678.00</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_1nff_price:4" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">4</field>
+                               <field index="pid">1</field>
                                <field index="parentid">3</field>
                                <field index="parenttable">tx_irretutorial_1nff_offer</field>
                                <field index="parentidentifier"></field>
                                <field index="title">Price 2.1.1 (nff)</field>
                                <field index="price">5467567.00</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnasym_hotel:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="title">Hotel 1 (m:n ASym)</field>
                                <field index="offers">2</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnasym_hotel_offer_rel:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="hotelid">1</field>
                                <field index="offerid">2</field>
                                <field index="hotelsort">2</field>
                                <field index="offersort">1</field>
                                <field index="prices">1</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnasym_hotel_offer_rel:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="hotelid">1</field>
                                <field index="offerid">1</field>
                                <field index="hotelsort">1</field>
                                <field index="offersort">1</field>
                                <field index="prices">1</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnasym_offer:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="title">Offer 2 (m:n ASym)</field>
                                <field index="hotels">1</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnasym_offer:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="title">Offer 1 (m:n ASym)</field>
                                <field index="hotels">1</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnasym_price:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="parentid">1</field>
                                <field index="title">Price 1 1:2 (m:n ASym)</field>
                                <field index="price">678.00</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnasym_price:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="parentid">2</field>
                                <field index="title">Price 2 1:1 (m:n ASym)</field>
                                <field index="price">45.00</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnattr_hotel:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="title">Hotel 1 (m:n Attr)</field>
                                <field index="offers">1</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnattr_hotel:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="title">Hotel 2 (m:n Attr)</field>
                                <field index="offers">1</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnattr_hotel_offer_rel:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="hotelid">1</field>
                                <field index="offerid">1</field>
                                <field index="hotelsort">1</field>
                                <field index="offersort">0</field>
                                <field index="quality">2</field>
                                <field index="allincl">1</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnattr_hotel_offer_rel:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="hotelid">2</field>
                                <field index="offerid">2</field>
                                <field index="hotelsort">1</field>
                                <field index="offersort">0</field>
                                <field index="quality">4</field>
                                <field index="allincl">0</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnattr_offer:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="title">Offer 1 (m:n Attr)</field>
                                <field index="hotels">0</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnattr_offer:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="title">Offer 2 (m:n Attr)</field>
                                <field index="hotels">0</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnmmasym_hotel:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="title">Hotel 1 (m:n (MM) ASym)</field>
                                <field index="offers">2</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnmmasym_hotel:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="title">Hotel 2 (m:n (MM) ASym)</field>
                                <field index="offers">1</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnmmasym_offer:3" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">3</field>
+                               <field index="pid">1</field>
                                <field index="title">Offer 2.1 (m:n (MM) ASym)</field>
                                <field index="hotels">0</field>
                                <field index="prices">1</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnmmasym_offer:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="title">Offer 1.2 (m:n (MM) ASym)</field>
                                <field index="hotels">0</field>
                                <field index="prices">1</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnmmasym_offer:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="title">Offer 1.1 (m:n (MM) ASym)</field>
                                <field index="hotels">0</field>
                                <field index="prices">1</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnmmasym_price:3" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">3</field>
+                               <field index="pid">1</field>
                                <field index="title">Price (m:n (MM) ASym)</field>
                                <field index="price">223.00</field>
                                <field index="offers">0</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnmmasym_price:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="title">Price 1.2.2 (m:n (MM) ASym)</field>
                                <field index="price">567.00</field>
                                <field index="offers">0</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnmmasym_price:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="title">Price 1.1.1 (m:n (MM) ASym)</field>
                                <field index="price">567.00</field>
                                <field index="offers">0</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnsym_hotel:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="title">Hotel Branch 1.1 (mm sym)</field>
                                <field index="branches">1</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnsym_hotel:3" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">3</field>
+                               <field index="pid">1</field>
                                <field index="title">Hotel branch 1.2 (mm sym)</field>
                                <field index="branches">0</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnsym_hotel:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="title">Hotel 1 (mm sym)</field>
                                <field index="branches">2</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnsym_hotel_rel:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="hotelid">1</field>
                                <field index="branchid">2</field>
                                <field index="hotelsort">1</field>
                                <field index="branchsort">1</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                <tablerow index="tx_irretutorial_mnsym_hotel_rel:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="hotelid">1</field>
                                <field index="branchid">3</field>
                                <field index="hotelsort">2</field>
                                <field index="branchsort">0</field>
-                               <field index="pid">1</field>
                                <field index="cruser_id">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
index 6bfa364..8838d23 100644 (file)
                <tablerow index="pages:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="perms_everybody">15</field>
                                <field index="title">Root</field>
                                <field index="doktype">1</field>
-                               <field index="pid">0</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                        </fieldlist>
                <tablerow index="pages:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="perms_everybody">15</field>
                                <field index="title">Dummy 1-2</field>
                                <field index="doktype">1</field>
-                               <field index="pid">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                        </fieldlist>
                <tablerow index="tt_content:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="CType">textpic</field>
                                <field index="header">Test content</field>
                                <field index="image">1</field>
                                <field index="header_link">file:1</field>
-                               <field index="pid">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                                <field index="t3ver_oid">0</field>
                <tablerow index="sys_language:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="title">Deutsch</field>
                                <field index="flag">de</field>
-                               <field index="pid">0</field>
                                <field index="hidden">0</field>
                        </fieldlist>
                        <related index="rels" type="array"></related>
                <tablerow index="sys_file_reference:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="uid_local">1</field>
                                <field index="uid_foreign">1</field>
                                <field index="tablenames">tt_content</field>
                                <field index="description" type="NULL"></field>
                                <field index="alternative" type="NULL"></field>
                                <field index="link"></field>
-                               <field index="pid">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="uid_local" type="array">
                <tablerow index="sys_file:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="storage">1</field>
                                <field index="type">2</field>
                                <field index="metadata">0</field>
                                <field index="size">1958</field>
                                <field index="creation_date">1389878273</field>
                                <field index="modification_date">1389878273</field>
-                               <field index="pid">0</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="storage" type="array">
                <tablerow index="sys_file_storage:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="name">fileadmin/ (auto-created)</field>
                                <field index="driver">Local</field>
                                <field index="configuration">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot; standalone=&quot;yes&quot; ?&gt;
                                <field index="is_public">1</field>
                                <field index="is_writable">1</field>
                                <field index="is_online">1</field>
-                               <field index="pid">0</field>
                                <field index="description" type="NULL"></field>
                        </fieldlist>
                        <related index="rels" type="array">
                <tablerow index="sys_file_metadata:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="file">1</field>
                                <field index="title">Dummy image</field>
                                <field index="width">400</field>
                                <field index="height">300</field>
                                <field index="description">This is a dummy image.</field>
                                <field index="alternative">Photo of program code</field>
-                               <field index="pid">0</field>
                                <field index="sys_language_uid">0</field>
                                <field index="l10n_parent">0</field>
                        </fieldlist>
                <tablerow index="sys_file_metadata:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">0</field>
                                <field index="file">1</field>
                                <field index="title">Beispiel Bild</field>
                                <field index="width">400</field>
                                <field index="height">300</field>
                                <field index="description">Nur ein Beispielbild.</field>
                                <field index="alternative">Foto von Programmcode</field>
-                               <field index="pid">0</field>
                                <field index="sys_language_uid">1</field>
                                <field index="l10n_parent">1</field>
                        </fieldlist>
index 4cbc752..29c07ae 100644 (file)
                <tablerow index="pages:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="perms_everybody">15</field>
                                <field index="title">Root</field>
                                <field index="doktype">1</field>
-                               <field index="pid">0</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                        </fieldlist>
                <tablerow index="pages:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="perms_everybody">15</field>
                                <field index="title">Dummy 1-2</field>
                                <field index="doktype">1</field>
-                               <field index="pid">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                        </fieldlist>
                <tablerow index="tt_content:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="CType">textpic</field>
                                <field index="header">Test content</field>
                                <field index="image">1</field>
                                <field index="header_link">file:1</field>
-                               <field index="pid">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                                <field index="t3ver_oid">0</field>
                <tablerow index="sys_language:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="title">Deutsch</field>
                                <field index="flag">de</field>
-                               <field index="pid">0</field>
                                <field index="hidden">0</field>
                        </fieldlist>
                        <related index="rels" type="array"></related>
                <tablerow index="sys_file_reference:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="uid_local">1</field>
                                <field index="uid_foreign">1</field>
                                <field index="tablenames">tt_content</field>
                                <field index="description" type="NULL"></field>
                                <field index="alternative" type="NULL"></field>
                                <field index="link"></field>
-                               <field index="pid">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="uid_local" type="array">
                <tablerow index="sys_file:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="storage">1</field>
                                <field index="type">2</field>
                                <field index="metadata">0</field>
                                <field index="size">7958</field>
                                <field index="creation_date">1389878273</field>
                                <field index="modification_date">1389878273</field>
-                               <field index="pid">0</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="storage" type="array">
                <tablerow index="sys_file_storage:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="name">fileadmin/ (auto-created)</field>
                                <field index="driver">Local</field>
                                <field index="configuration">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot; standalone=&quot;yes&quot; ?&gt;
                                <field index="is_public">1</field>
                                <field index="is_writable">1</field>
                                <field index="is_online">1</field>
-                               <field index="pid">0</field>
                                <field index="description" type="NULL"></field>
                        </fieldlist>
                        <related index="rels" type="array">
                <tablerow index="sys_file_metadata:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="file">1</field>
                                <field index="title">Dummy image</field>
                                <field index="width">400</field>
                                <field index="height">300</field>
                                <field index="description">This is a dummy image.</field>
                                <field index="alternative">Photo of program code</field>
-                               <field index="pid">0</field>
                                <field index="sys_language_uid">0</field>
                                <field index="l10n_parent">0</field>
                        </fieldlist>
                <tablerow index="sys_file_metadata:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">0</field>
                                <field index="file">1</field>
                                <field index="title">Beispiel Bild</field>
                                <field index="width">400</field>
                                <field index="height">300</field>
                                <field index="description">Nur ein Beispielbild.</field>
                                <field index="alternative">Foto von Programmcode</field>
-                               <field index="pid">0</field>
                                <field index="sys_language_uid">1</field>
                                <field index="l10n_parent">1</field>
                        </fieldlist>
index f5aa546..234072a 100644 (file)
                <tablerow index="pages:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="perms_everybody">15</field>
                                <field index="title">Root</field>
                                <field index="doktype">1</field>
-                               <field index="pid">0</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                        </fieldlist>
                <tablerow index="pages:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="perms_everybody">15</field>
                                <field index="title">Dummy 1-2</field>
                                <field index="doktype">1</field>
-                               <field index="pid">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                        </fieldlist>
                <tablerow index="tt_content:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="CType">textpic</field>
                                <field index="header">Test content</field>
                                <field index="image">1</field>
                                <field index="header_link">file:1</field>
-                               <field index="pid">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                                <field index="t3ver_oid">0</field>
                <tablerow index="sys_language:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="title">Deutsch</field>
                                <field index="flag">de</field>
-                               <field index="pid">0</field>
                                <field index="hidden">0</field>
                        </fieldlist>
                        <related index="rels" type="array"></related>
                <tablerow index="sys_file_reference:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="uid_local">1</field>
                                <field index="uid_foreign">1</field>
                                <field index="tablenames">tt_content</field>
                                <field index="description" type="NULL"></field>
                                <field index="alternative" type="NULL"></field>
                                <field index="link"></field>
-                               <field index="pid">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="uid_local" type="array">
                <tablerow index="sys_file:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="storage">1</field>
                                <field index="type">2</field>
                                <field index="metadata">0</field>
                                <field index="size">7958</field>
                                <field index="creation_date">1389878273</field>
                                <field index="modification_date">1389878273</field>
-                               <field index="pid">0</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="storage" type="array">
                <tablerow index="sys_file_storage:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="name">fileadmin/ (auto-created)</field>
                                <field index="driver">Local</field>
                                <field index="configuration">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot; standalone=&quot;yes&quot; ?&gt;
                                <field index="is_public">1</field>
                                <field index="is_writable">1</field>
                                <field index="is_online">1</field>
-                               <field index="pid">0</field>
                                <field index="description" type="NULL"></field>
                        </fieldlist>
                        <related index="rels" type="array">
                <tablerow index="sys_file_metadata:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="file">1</field>
                                <field index="title">Dummy image</field>
                                <field index="width">400</field>
                                <field index="height">300</field>
                                <field index="description">This is a dummy image.</field>
                                <field index="alternative">Photo of program code</field>
-                               <field index="pid">0</field>
                                <field index="sys_language_uid">0</field>
                                <field index="l10n_parent">0</field>
                        </fieldlist>
                <tablerow index="sys_file_metadata:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">0</field>
                                <field index="file">1</field>
                                <field index="title">Beispiel Bild</field>
                                <field index="width">400</field>
                                <field index="height">300</field>
                                <field index="description">Nur ein Beispielbild.</field>
                                <field index="alternative">Foto von Programmcode</field>
-                               <field index="pid">0</field>
                                <field index="sys_language_uid">1</field>
                                <field index="l10n_parent">1</field>
                        </fieldlist>
index 20b0e05..b848ffc 100644 (file)
                <tablerow index="pages:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">0</field>
                                <field index="perms_everybody">15</field>
                                <field index="title">Root</field>
                                <field index="doktype">1</field>
-                               <field index="pid">0</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                        </fieldlist>
                <tablerow index="pages:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="perms_everybody">15</field>
                                <field index="title">Dummy 1-2</field>
                                <field index="doktype">1</field>
-                               <field index="pid">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                        </fieldlist>
                <tablerow index="tt_content:1" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">1</field>
+                               <field index="pid">1</field>
                                <field index="CType">text</field>
                                <field index="header">Test content</field>
                                <field index="header_link">file:2</field>
-                               <field index="pid">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                                <field index="t3ver_oid">0</field>
                <tablerow index="tt_content:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">1</field>
                                <field index="CType">text</field>
                                <field index="header">Test content 2</field>
                                <field index="header_link">file:4</field>
-                               <field index="pid">1</field>
                                <field index="deleted">0</field>
                                <field index="hidden">0</field>
                                <field index="t3ver_oid">0</field>
                <tablerow index="sys_file:2" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">2</field>
+                               <field index="pid">0</field>
                                <field index="storage">1</field>
                                <field index="type">2</field>
                                <field index="metadata">0</field>
                                <field index="size">5565</field>
                                <field index="creation_date">1393346082</field>
                                <field index="modification_date">1392907534</field>
-                               <field index="pid">0</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="storage" type="array">
                <tablerow index="sys_file:4" type="array">
                        <fieldlist index="data" type="array">
                                <field index="uid">4</field>
+                               <field index="pid">0</field>
                                <field index="storage">0</field>
                                <field index="type">1</field>
                                <field index="metadata">0</field>
                                <field index="size">92</field>
                                <field index="creation_date">1400176659</field>
                                <field index="modification_date">1400176659</field>
-                               <field index="pid">0</field>
                        </fieldlist>
                        <related index="rels" type="array"></related>
                </tablerow>