"Fossies" - the Fresh Open Source Software Archive

Member "administrator/components/com_admin/sql/updates/postgresql/4.0.0-2018-03-05.sql" (13 Sep 2021, 5683 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-2016-07-03.sql
    2 INSERT INTO "#__extensions" ("name", "type", "element", "folder", "client_id", "enabled", "access", "protected", "manifest_cache", "params", "custom_data", "system_data", "checked_out", "checked_out_time", "ordering", "state") VALUES
    3 ('plg_behaviour_taggable', 'plugin', 'taggable', 'behaviour', 0, 1, 1, 0, '', '{}', '', '', 0, '1970-01-01 00:00:00', 0, 0),
    4 ('plg_behaviour_versionable', 'plugin', 'versionable', 'behaviour', 0, 1, 1, 0, '', '{}', '', '', 0, '1970-01-01 00:00:00', 0, 0);
    5 
    6 -- From 4.0.0-2016-09-22.sql
    7 DELETE FROM "#__extensions" WHERE "type" = 'library' AND "element" = 'phputf8';
    8 
    9 -- From 4.0.0-2016-09-28.sql
   10 DELETE FROM "#__extensions" WHERE "type" = 'plugin' AND "element" = 'p3p' AND "folder" = 'system';
   11 
   12 -- From 4.0.0-2016-10-02.sql
   13 ALTER TABLE "#__user_keys" DROP COLUMN "invalid";
   14 
   15 --
   16 -- Insert the new templates into the database. Set as home if the old template is the active one
   17 --
   18 INSERT INTO "#__extensions" ("name", "type", "element", "folder", "client_id", "enabled", "access", "protected", "manifest_cache", "params", "custom_data", "system_data", "checked_out", "checked_out_time", "ordering", "state") VALUES
   19 ('atum', 'template', 'atum', '', 1, 1, 1, 0, '{}', '{}', '', '', 0, '1970-01-01 00:00:00', 0, 0),
   20 ('cassiopeia', 'template', 'cassiopeia', '', 0, 1, 1, 0, '{}', '{}', '', '', 0, '1970-01-01 00:00:00', 0, 0);
   21 
   22 INSERT INTO "#__template_styles" ("template", "client_id", "home", "title", "params") VALUES
   23 ('atum', 1, (CASE WHEN (SELECT b."count" FROM (SELECT count(a."id") AS "count" FROM "#__template_styles" a WHERE a."home" = '1' AND a."client_id" = 1 AND a."template" IN ('isis', 'hathor')) AS b) = 0 THEN '0' ELSE '1' END), 'atum - Default', '{}'),
   24 ('cassiopeia', 0, (CASE WHEN (SELECT d."count" FROM (SELECT count(c."id") AS "count" FROM "#__template_styles" c WHERE c."home" = '1' AND c."client_id" = 0 AND c."template" IN ('protostar', 'beez3')) AS d) = 0 THEN '0' ELSE '1' END), 'cassiopeia - Default', '{}');
   25 
   26 --
   27 -- Move mod_version to the right position for the atum template
   28 --
   29 UPDATE "#__modules" SET "position" = 'status' WHERE "module" = 'mod_version' AND "client_id" = 1;
   30 
   31 --
   32 -- Now we can clean up the old templates
   33 --
   34 DELETE FROM "#__extensions" WHERE "type" = 'template' AND "element" = 'hathor' AND "client_id" = 1;
   35 DELETE FROM "#__template_styles" WHERE "template" = 'hathor' AND "client_id" = 1;
   36 
   37 DELETE FROM "#__template_styles" WHERE "template" = 'isis' AND "client_id" = 1;
   38 DELETE FROM "#__extensions" WHERE "type" = 'template' AND "element" = 'isis' AND "client_id" = 1;
   39 
   40 DELETE FROM "#__template_styles" WHERE "template" = 'protostar' AND "client_id" = 0;
   41 DELETE FROM "#__extensions" WHERE "type" = 'template' AND "element" = 'protostar' AND "client_id" = 0;
   42 
   43 DELETE FROM "#__template_styles" WHERE "template" = 'beez3' AND "client_id" = 0;
   44 DELETE FROM "#__extensions" WHERE "type" = 'template' AND "element" = 'beez3' AND "client_id" = 0;
   45 
   46 -- From 4.0.0-2016-10-03.sql
   47 DELETE FROM "#__extensions" WHERE "name" = 'mod_submenu';
   48 
   49 -- From 4.0.0-2017-03-18.sql
   50 ALTER TABLE "#__extensions" DROP COLUMN "system_data";
   51 
   52 -- From 4.0.0-2017-04-25.sql
   53 INSERT INTO "#__extensions" ("name", "type", "element", "folder", "client_id", "enabled", "access", "protected", "manifest_cache", "params", "custom_data", "checked_out", "checked_out_time", "ordering", "state") VALUES
   54 ('plg_filesystem_local', 'plugin', 'local', 'filesystem', 0, 1, 1, 0, '', '{}', '', 0, '1970-01-01 00:00:00', 0, 0),
   55 ('plg_media-action_crop', 'plugin', 'crop', 'media-action', 0, 1, 1, 0, '', '{}', '', 0, '1970-01-01 00:00:00', 0, 0),
   56 ('plg_media-action_resize', 'plugin', 'resize', 'media-action', 0, 1, 1, 0, '', '{}', '', 0, '1970-01-01 00:00:00', 0, 0),
   57 ('plg_media-action_rotate', 'plugin', 'rotate', 'media-action', 0, 1, 1, 0, '', '{}', '', 0, '1970-01-01 00:00:00', 0, 0);
   58 
   59 -- From 4.0.0-2017-05-31.sql
   60 UPDATE "#__menu" SET "link" = 'index.php?option=com_config&view=config' WHERE "link" = 'index.php?option=com_config&view=config&controller=config.display.config';
   61 UPDATE "#__menu" SET "link" = 'index.php?option=com_config&view=templates' WHERE "link" = 'index.php?option=com_config&view=templates&controller=config.display.templates';
   62 
   63 -- From 4.0.0-2017-06-03.sql
   64 ALTER TABLE "#__extensions" ADD COLUMN "changelogurl" text;
   65 ALTER TABLE "#__updates" ADD COLUMN "changelogurl" text;
   66 
   67 -- From 4.0.0-2017-10-10.sql
   68 INSERT INTO "#__extensions" ("name", "type", "element", "folder", "client_id", "enabled", "access", "protected", "manifest_cache", "params", "custom_data", "checked_out", "checked_out_time", "ordering", "state") VALUES
   69 ('plg_system_httpheaders', 'plugin', 'httpheaders', 'system', 0, 0, 1, 0, '', '{}', '', 0, '1970-01-01 00:00:00', 0, 0);
   70 
   71 INSERT INTO "#__postinstall_messages" ("extension_id", "title_key", "description_key", "action_key", "language_extension", "language_client_id", "type", "action_file", "action", "condition_file", "condition_method", "version_introduced", "enabled")
   72 SELECT "extension_id", 'PLG_SYSTEM_HTTPHEADERS_POSTINSTALL_INTRODUCTION_TITLE', 'PLG_SYSTEM_HTTPHEADERS_POSTINSTALL_INTRODUCTION_BODY', 'PLG_SYSTEM_HTTPHEADERS_POSTINSTALL_INTRODUCTION_ACTION', 'plg_system_httpheaders', 1, 'action', 'site://plugins/system/httpheaders/postinstall/introduction.php', 'httpheaders_postinstall_action', 'site://plugins/system/httpheaders/postinstall/introduction.php', 'httpheaders_postinstall_condition', '4.0.0', 1 FROM "#__extensions" WHERE "name" = 'files_joomla';
   73 
   74 -- From 4.0.0-2018-02-24.sql
   75 DELETE FROM "#__extensions" WHERE "type" = 'library' AND "element" = 'idna_convert';
   76 
   77 -- From 4.0.0-2018-03-05.sql
   78 ALTER TABLE "#__modules" ALTER COLUMN "content" DROP NOT NULL;