.. ==================================================
.. FOR YOUR INFORMATION
.. --------------------------------------------------
.. -*- coding: utf-8 -*- with BOM.

.. include:: ../../../Includes.txt


.. _developers_foreignextension_tca:


TCA
===

Create the file Configuration/TCA/Overrides/some_table.php. Replace "some_table" with
the name of the table, you want to extend with a root pid.

some_table.php
--------------

Copy the code from below into ext_tables.sql. Replace "some_table" with
the name of the table, you want to extend with a root pid.

The php sample from below contains two relations:

* one to fe_groups

* and one to sys_categories

Adapt the relations to your needs.

.. code:: php

  <?php

  use Verdigado\Multisite\Utility\TcaAndWhereUtility;

  /* * *****************************
   * ctrl
   * ***************************** */

  $GLOBALS['TCA']['some_table']['ctrl']['extensions']['multisite'] = [
      // EXT:multisite will take some_table into account
      'enabled' => true,
      // Optional: If your rootpid field isn't called rootpid
      //'rootpid' => 'my_rootpid'
  ];

  /* * *****************************
   * columns
   * ***************************** */

  $columns = [
      'categories' => [
          'tableLocal'   => 'some_table',
          'tableForeign' => 'sys_category'
      ],
      'fe_group'   => [
          'tableLocal'   => 'some_table',
          'tableForeign' => 'fe_groups'
      ]
  ];

  TcaAndWhereUtility::Set($columns);