[TASK] Doctrine: Migrate AbstractExportTestCase 68/49168/7
authorWouter Wolters <typo3@wouterwolters.nl>
Fri, 22 Jul 2016 12:20:41 +0000 (14:20 +0200)
committerChristian Kuhn <lolli@schwarzbu.ch>
Thu, 28 Jul 2016 19:19:22 +0000 (21:19 +0200)
Resolves: #77214
Releases: master
Change-Id: I84a121d462cf33400dd6eec4a622f9daed153c91
Reviewed-on: https://review.typo3.org/49168
Tested-by: Bamboo TYPO3com <info@typo3.com>
Reviewed-by: Mathias Schreiber <mathias.schreiber@wmdb.de>
Tested-by: Mathias Schreiber <mathias.schreiber@wmdb.de>
Reviewed-by: Christian Kuhn <lolli@schwarzbu.ch>
Tested-by: Christian Kuhn <lolli@schwarzbu.ch>
typo3/sysext/impexp/Classes/Task/ImportExportTask.php
typo3/sysext/impexp/Tests/Functional/Export/AbstractExportTestCase.php
typo3/sysext/impexp/Tests/Functional/Fixtures/ImportExportXml/irre-records.xml

index 95229cf..f2ae753 100644 (file)
@@ -242,12 +242,4 @@ class ImportExportTask implements TaskInterface
     {
         return $GLOBALS['LANG'];
     }
-
-    /**
-     * @return mixed
-     */
-    protected function getDatabase()
-    {
-        return $GLOBALS['TYPO3_DB'];
-    }
 }
index 82b0b78..3d419b8 100644 (file)
@@ -14,7 +14,9 @@ namespace TYPO3\CMS\Impexp\Tests\Functional\Export;
  * The TYPO3 project - inspiring people to share!
  */
 
-use TYPO3\CMS\Backend\Utility\BackendUtility;
+use TYPO3\CMS\Core\Database\ConnectionPool;
+use TYPO3\CMS\Core\Database\Query\QueryHelper;
+use TYPO3\CMS\Core\Database\Query\Restriction\DeletedRestriction;
 use TYPO3\CMS\Core\Utility\GeneralUtility;
 
 /**
@@ -91,15 +93,27 @@ abstract class AbstractExportTestCase extends \TYPO3\CMS\Core\Tests\FunctionalTe
         foreach ($GLOBALS['TCA'] as $table => $value) {
             if ($table != 'pages' && (in_array($table, $tables) || in_array('_ALL', $tables))) {
                 if ($GLOBALS['BE_USER']->check('tables_select', $table) && !$GLOBALS['TCA'][$table]['ctrl']['is_static']) {
-                    $orderBy = $GLOBALS['TCA'][$table]['ctrl']['sortby'] ? 'ORDER BY ' . $GLOBALS['TCA'][$table]['ctrl']['sortby'] : $GLOBALS['TCA'][$table]['ctrl']['default_sortby'];
-                    $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
-                        '*',
-                        $table,
-                            'pid = ' . (int)$pid . BackendUtility::deleteClause($table),
-                        '',
-                        $GLOBALS['TYPO3_DB']->stripOrderBy($orderBy)
-                    );
-                    while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
+                    $orderBy = $GLOBALS['TCA'][$table]['ctrl']['sortby'] ?: $GLOBALS['TCA'][$table]['ctrl']['default_sortby'];
+
+                    $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)
+                        ->getQueryBuilderForTable($table);
+
+                    $queryBuilder->getRestrictions()
+                        ->removeAll()
+                        ->add(GeneralUtility::makeInstance(DeletedRestriction::class));
+
+                    $queryBuilder
+                        ->select('*')
+                        ->from($table)
+                        ->where($queryBuilder->expr()->eq('pid', (int)$pid));
+
+                    foreach (QueryHelper::parseOrderBy((string)$orderBy) as $orderPair) {
+                        list($fieldName, $order) = $orderPair;
+                        $queryBuilder->addOrderBy($fieldName, $order);
+                    }
+
+                    $result = $queryBuilder->execute();
+                    while ($row = $result->fetch()) {
                         $this->export->export_addRecord($table, $row);
                     }
                 }
index 361f8cf..63e1667 100644 (file)
@@ -17,7 +17,7 @@
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>Test content</title>
-                                       <size>254</size>
+                                       <size>230</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_1nff_hotel:1" type="array">
                                                        <id>1</id>
@@ -44,7 +44,7 @@
                                        <uid>2</uid>
                                        <pid>1</pid>
                                        <title>Hotel 2 (csv)</title>
-                                       <size>247</size>
+                                       <size>215</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_1ncsv_offer:3" type="array">
                                                        <id>3</id>
@@ -57,7 +57,7 @@
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>Hotel 1 (csv)</title>
-                                       <size>249</size>
+                                       <size>217</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_1ncsv_offer:1" type="array">
                                                        <id>1</id>
@@ -76,7 +76,7 @@
                                        <uid>3</uid>
                                        <pid>1</pid>
                                        <title>Offer 2.2 (csv)</title>
-                                       <size>248</size>
+                                       <size>216</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_1ncsv_price:3" type="array">
                                                        <id>3</id>
@@ -89,7 +89,7 @@
                                        <uid>2</uid>
                                        <pid>1</pid>
                                        <title>Offer 1.2 (csv)</title>
-                                       <size>249</size>
+                                       <size>217</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_1ncsv_price:2" type="array">
                                                        <id>2</id>
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>Offer 1.1 (csv)</title>
-                                       <size>249</size>
+                                       <size>217</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_1ncsv_price:1" type="array">
                                                        <id>1</id>
                                        <uid>3</uid>
                                        <pid>1</pid>
                                        <title>Price 2.2.1 (csv)</title>
-                                       <size>254</size>
+                                       <size>215</size>
                                        <relations index="rels" type="array"></relations>
                                        <softrefs type="array"></softrefs>
                                </rec>
                                        <uid>2</uid>
                                        <pid>1</pid>
                                        <title>Price 1.2.1 (csv)</title>
-                                       <size>254</size>
+                                       <size>215</size>
                                        <relations index="rels" type="array"></relations>
                                        <softrefs type="array"></softrefs>
                                </rec>
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>Price 1.1.1 (csv)</title>
-                                       <size>255</size>
+                                       <size>216</size>
                                        <relations index="rels" type="array"></relations>
                                        <softrefs type="array"></softrefs>
                                </rec>
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>Hotel 1 (nff)</title>
-                                       <size>336</size>
+                                       <size>296</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_1nff_offer:1" type="array">
                                                        <id>1</id>
                                        <uid>2</uid>
                                        <pid>1</pid>
                                        <title>Hotel 2 (nff)</title>
-                                       <size>336</size>
+                                       <size>296</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_1nff_offer:3" type="array">
                                                        <id>3</id>
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>Offer 1.1 (nff)</title>
-                                       <size>354</size>
+                                       <size>314</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_1nff_price:1" type="array">
                                                        <id>1</id>
                                        <uid>3</uid>
                                        <pid>1</pid>
                                        <title>Offer 2.1 (nff)</title>
-                                       <size>354</size>
+                                       <size>314</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_1nff_price:4" type="array">
                                                        <id>4</id>
                                        <uid>2</uid>
                                        <pid>1</pid>
                                        <title>Offer 1.2 (nff)</title>
-                                       <size>354</size>
+                                       <size>314</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_1nff_price:3" type="array">
                                                        <id>3</id>
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>Price 1.1.1 (nff)</title>
-                                       <size>358</size>
+                                       <size>315</size>
                                        <relations index="rels" type="array"></relations>
                                        <softrefs type="array"></softrefs>
                                </rec>
                                        <uid>3</uid>
                                        <pid>1</pid>
                                        <title>Price 1.2.1 (nff)</title>
-                                       <size>360</size>
+                                       <size>317</size>
                                        <relations index="rels" type="array"></relations>
                                        <softrefs type="array"></softrefs>
                                </rec>
                                        <uid>4</uid>
                                        <pid>1</pid>
                                        <title>Price 2.1.1 (nff)</title>
-                                       <size>365</size>
+                                       <size>321</size>
                                        <relations index="rels" type="array"></relations>
                                        <softrefs type="array"></softrefs>
                                </rec>
                                        <uid>2</uid>
                                        <pid>1</pid>
                                        <title>Price 1.1.2 (nff)</title>
-                                       <size>360</size>
+                                       <size>317</size>
                                        <relations index="rels" type="array"></relations>
                                        <softrefs type="array"></softrefs>
                                </rec>
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>Hotel 1 (m:n ASym)</title>
-                                       <size>252</size>
+                                       <size>216</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnasym_hotel_offer_rel:2" type="array">
                                                        <id>2</id>
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>1</title>
-                                       <size>282</size>
+                                       <size>234</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnasym_hotel:1" type="array">
                                                        <id>1</id>
                                        <uid>2</uid>
                                        <pid>1</pid>
                                        <title>2</title>
-                                       <size>282</size>
+                                       <size>234</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnasym_hotel:1" type="array">
                                                        <id>1</id>
                                        <uid>2</uid>
                                        <pid>1</pid>
                                        <title>Offer 2 (m:n ASym)</title>
-                                       <size>252</size>
+                                       <size>216</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnasym_hotel_offer_rel:1" type="array">
                                                        <id>1</id>
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>Offer 1 (m:n ASym)</title>
-                                       <size>252</size>
+                                       <size>216</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnasym_hotel_offer_rel:2" type="array">
                                                        <id>2</id>
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>Price 1 1:2 (m:n ASym)</title>
-                                       <size>281</size>
+                                       <size>238</size>
                                        <relations index="rels" type="array"></relations>
                                        <softrefs type="array"></softrefs>
                                </rec>
                                        <uid>2</uid>
                                        <pid>1</pid>
                                        <title>Price 2 1:1 (m:n ASym)</title>
-                                       <size>280</size>
+                                       <size>237</size>
                                        <relations index="rels" type="array"></relations>
                                        <softrefs type="array"></softrefs>
                                </rec>
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>Hotel 1 (m:n Attr)</title>
-                                       <size>252</size>
+                                       <size>216</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnattr_hotel_offer_rel:1" type="array">
                                                        <id>1</id>
                                        <uid>2</uid>
                                        <pid>1</pid>
                                        <title>Hotel 2 (m:n Attr)</title>
-                                       <size>252</size>
+                                       <size>216</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnattr_hotel_offer_rel:2" type="array">
                                                        <id>2</id>
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>1</title>
-                                       <size>305</size>
+                                       <size>253</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnattr_hotel:1" type="array">
                                                        <id>1</id>
                                        <uid>2</uid>
                                        <pid>1</pid>
                                        <title>2</title>
-                                       <size>305</size>
+                                       <size>253</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnattr_hotel:2" type="array">
                                                        <id>2</id>
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>Offer 1 (m:n Attr)</title>
-                                       <size>252</size>
+                                       <size>216</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnattr_hotel_offer_rel:1" type="array">
                                                        <id>1</id>
                                        <uid>2</uid>
                                        <pid>1</pid>
                                        <title>Offer 2 (m:n Attr)</title>
-                                       <size>252</size>
+                                       <size>216</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnattr_hotel_offer_rel:2" type="array">
                                                        <id>2</id>
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>Hotel 1 (m:n (MM) ASym)</title>
-                                       <size>257</size>
+                                       <size>221</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnmmasym_offer:1" type="array">
                                                        <id>1</id>
                                        <uid>2</uid>
                                        <pid>1</pid>
                                        <title>Hotel 2 (m:n (MM) ASym)</title>
-                                       <size>257</size>
+                                       <size>221</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnmmasym_offer:3" type="array">
                                                        <id>3</id>
                                        <uid>3</uid>
                                        <pid>1</pid>
                                        <title>Offer 2.1 (m:n (MM) ASym)</title>
-                                       <size>279</size>
+                                       <size>239</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnmmasym_price:3" type="array">
                                                        <id>3</id>
                                        <uid>2</uid>
                                        <pid>1</pid>
                                        <title>Offer 1.2 (m:n (MM) ASym)</title>
-                                       <size>280</size>
+                                       <size>240</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnmmasym_price:2" type="array">
                                                        <id>2</id>
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>Offer 1.1 (m:n (MM) ASym)</title>
-                                       <size>280</size>
+                                       <size>240</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnmmasym_price:1" type="array">
                                                        <id>1</id>
                                        <uid>3</uid>
                                        <pid>1</pid>
                                        <title>Price (m:n (MM) ASym)</title>
-                                       <size>279</size>
+                                       <size>236</size>
                                        <relations index="rels" type="array"></relations>
                                        <softrefs type="array"></softrefs>
                                </rec>
                                        <uid>2</uid>
                                        <pid>1</pid>
                                        <title>Price 1.2.2 (m:n (MM) ASym)</title>
-                                       <size>286</size>
+                                       <size>243</size>
                                        <relations index="rels" type="array"></relations>
                                        <softrefs type="array"></softrefs>
                                </rec>
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>Price 1.1.1 (m:n (MM) ASym)</title>
-                                       <size>286</size>
+                                       <size>243</size>
                                        <relations index="rels" type="array"></relations>
                                        <softrefs type="array"></softrefs>
                                </rec>
                                        <uid>2</uid>
                                        <pid>1</pid>
                                        <title>Hotel Branch 1.1 (mm sym)</title>
-                                       <size>261</size>
+                                       <size>225</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnsym_hotel_rel:1" type="array">
                                                        <id>1</id>
                                        <uid>3</uid>
                                        <pid>1</pid>
                                        <title>Hotel branch 1.2 (mm sym)</title>
-                                       <size>261</size>
+                                       <size>225</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnsym_hotel_rel:2" type="array">
                                                        <id>2</id>
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>Hotel 1 (mm sym)</title>
-                                       <size>252</size>
+                                       <size>216</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnsym_hotel_rel:1" type="array">
                                                        <id>1</id>
                                        <uid>1</uid>
                                        <pid>1</pid>
                                        <title>1</title>
-                                       <size>264</size>
+                                       <size>220</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnsym_hotel:1" type="array">
                                                        <id>1</id>
                                        <uid>2</uid>
                                        <pid>1</pid>
                                        <title>2</title>
-                                       <size>264</size>
+                                       <size>220</size>
                                        <relations index="rels" type="array">
                                                <element index="tx_irretutorial_mnsym_hotel:1" type="array">
                                                        <id>1</id>
                </tablerow>
                <tablerow index="tt_content:1" type="array">
                        <fieldlist index="data" type="array">
-                               <field index="uid">1</field>
-                               <field index="pid">1</field>
-                               <field index="t3ver_oid">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="t3ver_oid" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="CType">text</field>
                                <field index="header">Test content</field>
-                               <field index="deleted">0</field>
-                               <field index="tx_irretutorial_1nff_hotels">2</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="tx_irretutorial_1nff_hotels" type="integer">2</field>
                                <field index="tx_irretutorial_1ncsv_hotels">1,2</field>
                        </fieldlist>
                        <related index="rels" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">128</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">128</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Hotel 2 (csv)</field>
                                <field index="offers">3</field>
                        </fieldlist>
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">256</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">256</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Hotel 1 (csv)</field>
                                <field index="offers">1,2</field>
                        </fieldlist>
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">64</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">3</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">64</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Offer 2.2 (csv)</field>
                                <field index="prices">3</field>
                        </fieldlist>
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">128</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">128</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Offer 1.2 (csv)</field>
                                <field index="prices">2</field>
                        </fieldlist>
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">256</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">256</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Offer 1.1 (csv)</field>
                                <field index="prices">1</field>
                        </fieldlist>
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">64</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">3</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">64</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Price 2.2.1 (csv)</field>
-                               <field index="price">112.00</field>
+                               <field index="price" type="double">112</field>
                        </fieldlist>
                        <related index="rels" type="array"></related>
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">128</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">128</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Price 1.2.1 (csv)</field>
-                               <field index="price">90.00</field>
+                               <field index="price" type="double">90</field>
                        </fieldlist>
                        <related index="rels" type="array"></related>
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">256</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">256</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Price 1.1.1 (csv)</field>
-                               <field index="price">567.00</field>
+                               <field index="price" type="double">567</field>
                        </fieldlist>
                        <related index="rels" type="array"></related>
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">1</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
-                               <field index="parentid">1</field>
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">1</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="parentid" type="integer">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="offers" type="integer">2</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="offers" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">2</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
-                               <field index="parentid">1</field>
+                               <field index="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">2</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="parentid" type="integer">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="offers" type="integer">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="offers" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">1</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
-                               <field index="parentid">1</field>
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">1</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="parentid" type="integer">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="prices" type="integer">2</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="prices" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">1</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
-                               <field index="parentid">2</field>
+                               <field index="uid" type="integer">3</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">1</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="parentid" type="integer">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="prices" type="integer">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="prices" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">2</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
-                               <field index="parentid">1</field>
+                               <field index="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">2</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="parentid" type="integer">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="prices" type="integer">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="prices" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">1</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
-                               <field index="parentid">1</field>
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">1</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="parentid" type="integer">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="price" type="double">4</field>
                        </fieldlist>
                        <related index="rels" type="array"></related>
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">1</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
-                               <field index="parentid">2</field>
+                               <field index="uid" type="integer">3</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">1</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="parentid" type="integer">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="price" type="double">678</field>
                        </fieldlist>
                        <related index="rels" type="array"></related>
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">1</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
-                               <field index="parentid">3</field>
+                               <field index="uid" type="integer">4</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">1</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="parentid" type="integer">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="price" type="double">5467567</field>
                        </fieldlist>
                        <related index="rels" type="array"></related>
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">2</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
-                               <field index="parentid">1</field>
+                               <field index="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">2</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="parentid" type="integer">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="price" type="double">869</field>
                        </fieldlist>
                        <related index="rels" type="array"></related>
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">256</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">256</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Hotel 1 (m:n ASym)</field>
-                               <field index="offers">2</field>
+                               <field index="offers" type="integer">2</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="offers" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</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="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="hotelid" type="integer">1</field>
+                               <field index="offerid" type="integer">2</field>
+                               <field index="hotelsort" type="integer">2</field>
+                               <field index="offersort" type="integer">1</field>
+                               <field index="prices" type="integer">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="hotelid" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</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="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="hotelid" type="integer">1</field>
+                               <field index="offerid" type="integer">1</field>
+                               <field index="hotelsort" type="integer">1</field>
+                               <field index="offersort" type="integer">1</field>
+                               <field index="prices" type="integer">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="hotelid" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">128</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">128</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Offer 2 (m:n ASym)</field>
-                               <field index="hotels">1</field>
+                               <field index="hotels" type="integer">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="hotels" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">256</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">256</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Offer 1 (m:n ASym)</field>
-                               <field index="hotels">1</field>
+                               <field index="hotels" type="integer">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="hotels" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">1</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
-                               <field index="parentid">1</field>
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">1</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="parentid" type="integer">1</field>
                                <field index="title">Price 1 1:2 (m:n ASym)</field>
-                               <field index="price">678.00</field>
+                               <field index="price" type="double">678</field>
                        </fieldlist>
                        <related index="rels" type="array"></related>
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">1</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
-                               <field index="parentid">2</field>
+                               <field index="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">1</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="parentid" type="integer">2</field>
                                <field index="title">Price 2 1:1 (m:n ASym)</field>
-                               <field index="price">45.00</field>
+                               <field index="price" type="double">45</field>
                        </fieldlist>
                        <related index="rels" type="array"></related>
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">256</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">256</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Hotel 1 (m:n Attr)</field>
-                               <field index="offers">1</field>
+                               <field index="offers" type="integer">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="offers" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">512</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">512</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Hotel 2 (m:n Attr)</field>
-                               <field index="offers">1</field>
+                               <field index="offers" type="integer">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="offers" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</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="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="hotelid" type="integer">1</field>
+                               <field index="offerid" type="integer">1</field>
+                               <field index="hotelsort" type="integer">1</field>
+                               <field index="offersort" type="integer">0</field>
+                               <field index="quality" type="integer">2</field>
+                               <field index="allincl" type="integer">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="hotelid" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</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="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="hotelid" type="integer">2</field>
+                               <field index="offerid" type="integer">2</field>
+                               <field index="hotelsort" type="integer">1</field>
+                               <field index="offersort" type="integer">0</field>
+                               <field index="quality" type="integer">4</field>
+                               <field index="allincl" type="integer">0</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="hotelid" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">256</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">256</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Offer 1 (m:n Attr)</field>
-                               <field index="hotels">0</field>
+                               <field index="hotels" type="integer">0</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="hotels" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">512</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">512</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Offer 2 (m:n Attr)</field>
-                               <field index="hotels">0</field>
+                               <field index="hotels" type="integer">0</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="hotels" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">256</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">256</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Hotel 1 (m:n (MM) ASym)</field>
-                               <field index="offers">2</field>
+                               <field index="offers" type="integer">2</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="offers" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">512</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">512</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Hotel 2 (m:n (MM) ASym)</field>
-                               <field index="offers">1</field>
+                               <field index="offers" type="integer">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="offers" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">64</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">3</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">64</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Offer 2.1 (m:n (MM) ASym)</field>
-                               <field index="hotels">0</field>
-                               <field index="prices">1</field>
+                               <field index="hotels" type="integer">0</field>
+                               <field index="prices" type="integer">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="prices" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">128</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">128</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Offer 1.2 (m:n (MM) ASym)</field>
-                               <field index="hotels">0</field>
-                               <field index="prices">1</field>
+                               <field index="hotels" type="integer">0</field>
+                               <field index="prices" type="integer">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="prices" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">256</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">256</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Offer 1.1 (m:n (MM) ASym)</field>
-                               <field index="hotels">0</field>
-                               <field index="prices">1</field>
+                               <field index="hotels" type="integer">0</field>
+                               <field index="prices" type="integer">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="prices" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">64</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">3</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">64</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Price (m:n (MM) ASym)</field>
-                               <field index="price">223.00</field>
-                               <field index="offers">0</field>
+                               <field index="price" type="double">223</field>
+                               <field index="offers" type="integer">0</field>
                        </fieldlist>
                        <related index="rels" type="array"></related>
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">128</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">128</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</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="price" type="double">567</field>
+                               <field index="offers" type="integer">0</field>
                        </fieldlist>
                        <related index="rels" type="array"></related>
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">256</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">256</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</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="price" type="double">567</field>
+                               <field index="offers" type="integer">0</field>
                        </fieldlist>
                        <related index="rels" type="array"></related>
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">128</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">128</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Hotel Branch 1.1 (mm sym)</field>
-                               <field index="branches">1</field>
+                               <field index="branches" type="integer">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="branches" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">192</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">3</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">192</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Hotel branch 1.2 (mm sym)</field>
-                               <field index="branches">0</field>
+                               <field index="branches" type="integer">0</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="branches" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="sorting">256</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="sorting" type="integer">256</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
                                <field index="title">Hotel 1 (mm sym)</field>
-                               <field index="branches">2</field>
+                               <field index="branches" type="integer">2</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="branches" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
-                               <field index="hotelid">1</field>
-                               <field index="branchid">2</field>
-                               <field index="hotelsort">1</field>
-                               <field index="branchsort">1</field>
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="hotelid" type="integer">1</field>
+                               <field index="branchid" type="integer">2</field>
+                               <field index="hotelsort" type="integer">1</field>
+                               <field index="branchsort" type="integer">1</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="hotelid" type="array">
                </tablerow>
                <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="cruser_id">1</field>
-                               <field index="sys_language_uid">0</field>
-                               <field index="l18n_parent">0</field>
-                               <field index="deleted">0</field>
-                               <field index="hidden">0</field>
-                               <field index="hotelid">1</field>
-                               <field index="branchid">3</field>
-                               <field index="hotelsort">2</field>
-                               <field index="branchsort">0</field>
+                               <field index="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="cruser_id" type="integer">1</field>
+                               <field index="sys_language_uid" type="integer">0</field>
+                               <field index="l18n_parent" type="integer">0</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="hotelid" type="integer">1</field>
+                               <field index="branchid" type="integer">3</field>
+                               <field index="hotelsort" type="integer">2</field>
+                               <field index="branchsort" type="integer">0</field>
                        </fieldlist>
                        <related index="rels" type="array">
                                <field index="hotelid" type="array">