"Fossies" - the Fresh Open Source Software Archive

Member "administrator/components/com_admin/sql/updates/postgresql/4.0.0-2020-09-27.sql" (13 Sep 2021, 1581 Bytes) of package /linux/www/Joomla_4.0.3-Stable-Full_Package.tar.bz2:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 -- From 4.0.0-2020-09-19.sql
    2 UPDATE "#__menu" SET "link"='index.php?option=com_finder' WHERE "menutype"='main' AND "title"='com_finder' AND "link"='index.php?option=com_finder&view=index';
    3 
    4 -- From 4.0.0-2020-09-22.sql
    5 UPDATE "#__menu" SET "link"='index.php?option=com_tags&view=tags' WHERE "menutype"='main' AND "path"='Tags';
    6 UPDATE "#__menu" SET "link"='index.php?option=com_associations&view=associations' WHERE "menutype"='main' AND "path"='Multilingual Associations';
    7 
    8 -- From 4.0.0-2020-09-27.sql
    9 DELETE FROM "#__extensions" WHERE "name" = 'plg_content_imagelazyload' AND "type" = 'plugin' AND "element" = 'imagelazyload' AND "folder" = 'content' AND "client_id" = 0;
   10 DELETE FROM "#__extensions" WHERE "name" = 'plg_authentication_gmail' AND "type" = 'plugin' AND "element" = 'gmail' AND "folder" = 'authentication' AND "client_id" = 0;
   11 
   12 --
   13 -- Delete possibly duplicate record for plg_sampledata_multilang
   14 --
   15 DELETE FROM "#__extensions"
   16  WHERE "name" = 'plg_sampledata_multilang' AND "type" = 'plugin' AND "element" = 'multilang' AND "folder" = 'sampledata' AND "client_id" = 0
   17    AND "extension_id" < (SELECT MAX("extension_id") FROM "#__extensions" WHERE "name" = 'plg_sampledata_multilang' AND "type" = 'plugin' AND "element" = 'multilang' AND "folder" = 'sampledata' AND "client_id" = 0);
   18 
   19 --
   20 -- Enable the remaining plg_sampledata_multilang record in case it has been disabled before
   21 --
   22 UPDATE "#__extensions" SET "enabled" = 1 WHERE "name" = 'plg_sampledata_multilang' AND "type" = 'plugin' AND "element" = 'multilang' AND "folder" = 'sampledata' AND "client_id" = 0;