"Fossies" - the Fresh Open Source Software Archive

Member "administrator/components/com_admin/sql/updates/mysql/4.0.0-2019-05-20.sql" (13 Sep 2021, 1612 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-2019-05-05.sql
    2 UPDATE `#__menu` SET `link`='index.php?option=com_banners&view=banners' WHERE `menutype`='main' AND `path`='Banners/Banners';
    3 UPDATE `#__menu` SET `link`='index.php?option=com_categories&view=categories&extension=com_banners' WHERE `menutype`='main' AND `path`='Banners/Categories';
    4 UPDATE `#__menu` SET `link`='index.php?option=com_contact&view=contacts' WHERE `menutype`='main' AND `path`='Contacts/Contacts';
    5 UPDATE `#__menu` SET `link`='index.php?option=com_categories&view=categories&extension=com_contact' WHERE `menutype`='main' AND `path`='Contacts/Categories';
    6 UPDATE `#__menu` SET `link`='index.php?option=com_newsfeeds&view=newsfeeds' WHERE `menutype`='main' AND `path`='News Feeds/Feeds';
    7 UPDATE `#__menu` SET `link`='index.php?option=com_categories&view=categories&extension=com_newsfeeds' WHERE `menutype`='main' AND `path`='News Feeds/Categories';
    8 UPDATE `#__menu` SET `link`='index.php?option=com_redirect&view=links' WHERE `menutype`='main' AND `path`='Redirect';
    9 UPDATE `#__menu` SET `link`='index.php?option=com_search&view=searches' WHERE `menutype`='main' AND `path`='Basic Search';
   10 UPDATE `#__menu` SET `link`='index.php?option=com_finder&view=index' WHERE `menutype`='main' AND `path`='Smart Search';
   11 UPDATE `#__menu` SET `link`='index.php?option=com_tags&view=tags' WHERE `menutype`='main' AND `path`='Tags';
   12 UPDATE `#__menu` SET `link`='index.php?option=com_associations&view=associations' WHERE `menutype`='main' AND `path`='Multilingual Associations';
   13 
   14 -- From 4.0.0-2019-05-20.sql
   15 ALTER TABLE `#__extensions` ADD COLUMN `note` varchar(255) AFTER `state`;