Backend Layouts

Note

Please use the Upgrade Wizard for upgrading your database.

Overview

backend_layout

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

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

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

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';