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

.. _upgrades_start_10003000_sqlstatements_backendLayouts:


Backend Layouts
===============

.. note::

  Please use the :ref:`Upgrade Wizard <upgrades_start_10003000_upgradewizard>` for upgrading your database.


Overview
''''''''

**backend_layout**

.. code:: sql

  SELECT
    count(`backend_layout`) as sum,
    `backend_layout`
  FROM
    pages
  WHERE 
    `backend_layout` != ''
  GROUP BY
    `backend_layout`
  ORDER BY
    `backend_layout`;
    

**backend_layout_next_level**

.. code:: sql

  SELECT
    count(`backend_layout_next_level`) as sum,
    `backend_layout_next_level`
  FROM
    pages
  WHERE 
    `backend_layout_next_level` != ''
  GROUP BY
    `backend_layout_next_level`
  ORDER BY
    `backend_layout_next_level`;
    

Update 
''''''

.. note::

  Make a copy of your table pages!


**backend_layout**

.. code:: sql

  UPDATE `pages` SET `backend_layout` = 'start__mixed_01' WHERE `backend_layout` = 'start__blue_01';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_01_01_lr' WHERE `backend_layout` = 'start__blue_01_01_lr';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_01_02_r' WHERE `backend_layout` = 'start__blue_01_02_r';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_01_03_l' WHERE `backend_layout` = 'start__blue_01_03_l';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_02' WHERE `backend_layout` = 'start__blue_02';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_03' WHERE `backend_layout` = 'start__blue_03';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_09_gcms' WHERE `backend_layout` = 'start__bronze_02_gcms';
  UPDATE `pages` SET `backend_layout` = 'start__wide_01' WHERE `backend_layout` = 'start__blue_04';
  UPDATE `pages` SET `backend_layout` = 'start__wide_01_bottom' WHERE `backend_layout` = 'start__blue_04_bottom';
  UPDATE `pages` SET `backend_layout` = 'start__wide_01_top' WHERE `backend_layout` = 'start__blue_04_top';
  UPDATE `pages` SET `backend_layout` = 'start__wide_01_wo' WHERE `backend_layout` = 'start__blue_04_wo';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_05' WHERE `backend_layout` = 'start__blue_05';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_05_01_lr' WHERE `backend_layout` = 'start__blue_05_01_lr';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_05_02_r' WHERE `backend_layout` = 'start__blue_05_02_r';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_05_03_l' WHERE `backend_layout` = 'start__blue_05_03_l';
  UPDATE `pages` SET `backend_layout` = 'start__slim_01' WHERE `backend_layout` = 'start__bronze_01';
  UPDATE `pages` SET `backend_layout` = 'start__slim_02' WHERE `backend_layout` = 'start__bronze_02';
  UPDATE `pages` SET `backend_layout` = 'start__slim_03' WHERE `backend_layout` = 'start__bronze_03';
  UPDATE `pages` SET `backend_layout` = 'start__slim_04' WHERE `backend_layout` = 'start__bronze_04';
  UPDATE `pages` SET `backend_layout` = 'start__slim_extended_04' WHERE `backend_layout` = 'start__silver_04';
  UPDATE `pages` SET `backend_layout` = 'start__slim_extended_05' WHERE `backend_layout` = 'start__silver_05';
  UPDATE `pages` SET `backend_layout` = 'start__slim_extended_06' WHERE `backend_layout` = 'start__silver_06';
  UPDATE `pages` SET `backend_layout` = 'start__slim_extended_07' WHERE `backend_layout` = 'start__silver_07';
  UPDATE `pages` SET `backend_layout` = 'start__slim_extended_08' WHERE `backend_layout` = 'start__silver_08';
  UPDATE `pages` SET `backend_layout` = 'start__slim_extended_09' WHERE `backend_layout` = 'start__silver_09';


**backend_layout_next_level**

.. code:: sql

  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_01' WHERE `backend_layout_next_level` = 'start__blue_01';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_01_01_lr' WHERE `backend_layout_next_level` = 'start__blue_01_01_lr';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_01_02_r' WHERE `backend_layout_next_level` = 'start__blue_01_02_r';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_01_03_l' WHERE `backend_layout_next_level` = 'start__blue_01_03_l';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_02' WHERE `backend_layout_next_level` = 'start__blue_02';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_03' WHERE `backend_layout_next_level` = 'start__blue_03';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_09_gcms' WHERE `backend_layout` = 'start__bronze_02_gcms';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__wide_01' WHERE `backend_layout_next_level` = 'start__blue_04';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__wide_01_bottom' WHERE `backend_layout_next_level` = 'start__blue_04_bottom';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__wide_01_top' WHERE `backend_layout_next_level` = 'start__blue_04_top';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__wide_01_wo' WHERE `backend_layout_next_level` = 'start__blue_04_wo';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_05' WHERE `backend_layout_next_level` = 'start__blue_05';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_05_01_lr' WHERE `backend_layout_next_level` = 'start__blue_05_01_lr';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_05_02_r' WHERE `backend_layout_next_level` = 'start__blue_05_02_r';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_05_03_l' WHERE `backend_layout_next_level` = 'start__blue_05_03_l';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__slim_01' WHERE `backend_layout_next_level` = 'start__bronze_01';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__slim_02' WHERE `backend_layout_next_level` = 'start__bronze_02';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__slim_03' WHERE `backend_layout_next_level` = 'start__bronze_03';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__slim_04' WHERE `backend_layout_next_level` = 'start__bronze_04';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__slim_extended_04' WHERE `backend_layout_next_level` = 'start__silver_04';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__slim_extended_05' WHERE `backend_layout_next_level` = 'start__silver_05';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__slim_extended_06' WHERE `backend_layout_next_level` = 'start__silver_06';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__slim_extended_07' WHERE `backend_layout_next_level` = 'start__silver_07';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__slim_extended_08' WHERE `backend_layout_next_level` = 'start__silver_08';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__slim_extended_09' WHERE `backend_layout_next_level` = 'start__silver_09';