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

.. _upgrades_start_10003000_sqlstatements_css:


CSS
===

.. note::

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


CSS class '.panel'
------------------

10.3.0

CSS class ``.panel`` is removed since foundation 6.x. It must replaced by ``.callout``

Have I used the class '.panel'?
'''''''''''''''''''''''''''''''

Please send this queries to your database. If you have used ``.panel``, you will get some hits. 

.. code:: sql

  SELECT
    uid,
    pid,
    header,
    tx_start_additionalclassdefined,
    tx_start_classpanel
  FROM
    tt_content
  WHERE
    (
          tx_start_additionalclassdefined LIKE '%panel%' 
      OR  tx_start_classpanel LIKE '%panel%'
    );


.. code:: sql

  SELECT
    uid,
    pid,
    header,
    bodytext,
    pi_flexform

  FROM
    tt_content
  WHERE
    (
          bodytext LIKE '%panel%'
      OR  pi_flexform LIKE '%panel%'
    );



Replace '.panel' with '.callout'
''''''''''''''''''''''''''''''''

.. note::

  Make a copy of your table tt_content


**tx_start_additionalclassdefined**

.. code:: sql

  UPDATE
    tt_content
  SET
    tx_start_additionalclassdefined =
  REPLACE
    (
      tx_start_additionalclassdefined,
      'panel',
      'callout'
    )
  WHERE
    tx_start_additionalclassdefined LIKE '%panel%'
  -- AND uid = 35666


**tx_start_classpanel**

.. code:: sql

  UPDATE
    tt_content
  SET
    tx_start_classpanel =
  REPLACE
    (
      tx_start_classpanel,
      'panel',
      'callout'
    )
  WHERE
    tx_start_classpanel LIKE '%panel%'
  -- AND uid = 47640


**pi_flexform**

.. code:: sql

  UPDATE
    tt_content
  SET
    pi_flexform =
  REPLACE
    (
      pi_flexform,
      'panel',
      'callout'
    )
  WHERE
    pi_flexform LIKE '%panel%'
  -- AND uid = 47640


**bodytext**

.. note::

  It is recommended to edit the bodytext field manually.
  The upgrade wizard won't update the field bodytext.


.. code:: sql

  UPDATE
    tt_content
  SET
    bodytext =
  REPLACE
    (
      bodytext,
      'panel',
      'callout'
    )
  WHERE
    bodytext LIKE '%panel%'
  -- AND uid = 47640