"Fossies" - the Fresh Open Source Software Archive

Member "administrator/components/com_admin/sql/updates/postgresql/4.0.0-2021-04-22.sql" (13 Sep 2021, 1042 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-2021-02-28.sql
    2 DELETE FROM "#__postinstall_messages"
    3  WHERE "title_key"
    4     IN ('COM_CPANEL_MSG_EACCELERATOR_TITLE',
    5         'COM_CPANEL_MSG_HTACCESS_TITLE',
    6         'COM_CPANEL_MSG_JOOMLA40_PRE_CHECKS_TITLE',
    7         'COM_CPANEL_MSG_UPDATEDEFAULTSETTINGS_TITLE',
    8         'PLG_PLG_RECAPTCHA_VERSION_1_POSTINSTALL_TITLE',
    9         'TPL_HATHOR_MESSAGE_POSTINSTALL_TITLE');
   10 
   11 -- From 4.0.0-2021-04-11.sql
   12 ALTER TABLE "#__fields" ADD COLUMN "only_use_in_subform" smallint DEFAULT 0 NOT NULL;
   13 
   14 -- From 4.0.0-2021-04-20.sql
   15 UPDATE "#__extensions" SET "name" = 'plg_fields_subform', "element" = 'subform' WHERE "name" = 'plg_fields_subfields' AND "type" = 'plugin' AND "element" = 'subfields' AND "folder" = 'fields' AND "client_id" = 0;
   16 UPDATE "#__fields" SET "type" = 'subform' WHERE "type" = 'subfields';
   17 
   18 -- From 4.0.0-2021-04-22.sql
   19 ALTER TABLE "#__mail_templates" ADD COLUMN "extension" VARCHAR(127) NOT NULL DEFAULT '';
   20 UPDATE "#__mail_templates" SET "extension" = SUBSTRING("template_id", 1, POSITION('.' IN "template_id") - 1);