[Summary view] [Print] [Text view]

   1  -- The following statement was moved from below to here and modified for 4.1.1 by adding the "/** CAN FAIL **/" installer hint.
   2  -- See https://github.com/joomla/joomla-cms/pull/37156
   3  ALTER TABLE `#__extensions` DROP COLUMN `system_data` /** CAN FAIL **/;
   4  
   5  -- From 4.0.0-2016-07-03.sql
   6  -- The following statement was modified for 4.1.1 by removing the `system_data` column.
   7  -- See https://github.com/joomla/joomla-cms/pull/37156
   8  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
   9  ('plg_behaviour_taggable', 'plugin', 'taggable', 'behaviour', 0, 1, 1, 0, '', '{}', '', 0, '0000-00-00 00:00:00', 0, 0),
  10  ('plg_behaviour_versionable', 'plugin', 'versionable', 'behaviour', 0, 1, 1, 0, '', '{}', '', 0, '0000-00-00 00:00:00', 0, 0);
  11  
  12  -- From 4.0.0-2016-09-22.sql
  13  DELETE FROM `#__extensions` WHERE `type` = 'library' AND `element` = 'phputf8';
  14  
  15  -- From 4.0.0-2016-09-28.sql
  16  DELETE FROM `#__extensions` WHERE `type` = 'plugin' AND `element` = 'p3p' AND `folder` = 'system';
  17  
  18  -- From 4.0.0-2016-10-02.sql
  19  -- The following statement was modified for 4.1.1 by adding the "/** CAN FAIL **/" installer hint.
  20  -- See https://github.com/joomla/joomla-cms/pull/37156
  21  ALTER TABLE `#__user_keys` DROP COLUMN `invalid` /** CAN FAIL **/;
  22  
  23  --
  24  -- Insert the new templates into the database. Set as home if the old template is the active one
  25  --
  26  
  27  -- The following statement was modified for 4.1.1 by removing the `system_data` column.
  28  -- See https://github.com/joomla/joomla-cms/pull/37156
  29  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
  30  ('atum', 'template', 'atum', '', 1, 1, 1, 0, '{}', '{}', '', 0, '0000-00-00 00:00:00', 0, 0),
  31  ('cassiopeia', 'template', 'cassiopeia', '', 0, 1, 1, 0, '{}', '{}', '', 0, '0000-00-00 00:00:00', 0, 0);
  32  
  33  -- The following statement had to be modified for 4.1 by adding the `inheritable` and `parent` columns.
  34  -- See https://github.com/joomla/joomla-cms/pull/36585
  35  INSERT INTO `#__template_styles` (`template`, `client_id`, `home`, `title`, `inheritable`, `parent`, `params`) VALUES
  36  ('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', 1, '', '{}'),
  37  ('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', 1, '', '{}');
  38  
  39  --
  40  -- Move mod_version to the right position for the atum template
  41  --
  42  UPDATE `#__modules` SET `position` = 'status' WHERE `module` = 'mod_version' AND `client_id` = 1;
  43  
  44  --
  45  -- Now we can clean up the old templates
  46  --
  47  DELETE FROM `#__extensions` WHERE `type` = 'template' AND `element` = 'hathor' AND `client_id` = 1;
  48  DELETE FROM `#__template_styles` WHERE `template` = 'hathor' AND `client_id` = 1;
  49  
  50  DELETE FROM `#__extensions` WHERE `type` = 'template' AND `element` = 'isis' AND `client_id` = 1;
  51  DELETE FROM `#__template_styles` WHERE `template` = 'isis' AND `client_id` = 1;
  52  
  53  DELETE FROM `#__extensions` WHERE `type` = 'template' AND `element` = 'protostar' AND `client_id` = 0;
  54  DELETE FROM `#__template_styles` WHERE `template` = 'protostar' AND `client_id` = 0;
  55  
  56  DELETE FROM `#__extensions` WHERE `type` = 'template' AND `element` = 'beez3' AND `client_id` = 0;
  57  DELETE FROM `#__template_styles` WHERE `template` = 'beez3' AND `client_id` = 0;
  58  
  59  -- From 4.0.0-2016-10-03.sql
  60  DELETE FROM `#__extensions` WHERE `name` = 'mod_submenu';
  61  
  62  -- From 4.0.0-2017-03-18.sql
  63  -- The following statement was moved to the top for 4.1.1.
  64  -- See https://github.com/joomla/joomla-cms/pull/37156
  65  -- ALTER TABLE `#__extensions` DROP COLUMN `system_data`;
  66  
  67  -- From 4.0.0-2017-04-25.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_filesystem_local', 'plugin', 'local', 'filesystem', 0, 1, 1, 0, '', '{}', '', 0, '0000-00-00 00:00:00', 0, 0),
  70  ('plg_media-action_crop', 'plugin', 'crop', 'media-action', 0, 1, 1, 0, '', '{}', '', 0, '0000-00-00 00:00:00', 0, 0),
  71  ('plg_media-action_resize', 'plugin', 'resize', 'media-action', 0, 1, 1, 0, '', '{}', '', 0, '0000-00-00 00:00:00', 0, 0),
  72  ('plg_media-action_rotate', 'plugin', 'rotate', 'media-action', 0, 1, 1, 0, '', '{}', '', 0, '0000-00-00 00:00:00', 0, 0);
  73  
  74  -- From 4.0.0-2017-05-31.sql
  75  UPDATE `#__menu` SET `link` = 'index.php?option=com_config&view=config' WHERE `link` = 'index.php?option=com_config&view=config&controller=config.display.config';
  76  UPDATE `#__menu` SET `link` = 'index.php?option=com_config&view=templates' WHERE `link` = 'index.php?option=com_config&view=templates&controller=config.display.templates';
  77  
  78  -- From 4.0.0-2017-06-03.sql
  79  -- The following two statements were modified for 4.1.1 by adding the "/** CAN FAIL **/" installer hint.
  80  -- See https://github.com/joomla/joomla-cms/pull/37156
  81  ALTER TABLE `#__extensions` ADD COLUMN `changelogurl` text AFTER `element` /** CAN FAIL **/;
  82  ALTER TABLE `#__updates` ADD COLUMN `changelogurl` text AFTER `infourl` /** CAN FAIL **/;
  83  
  84  -- From 4.0.0-2017-10-10.sql
  85  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
  86  ('plg_system_httpheaders', 'plugin', 'httpheaders', 'system', 0, 0, 1, 0, '', '{}', '', 0, '0000-00-00 00:00:00', 0, 0);
  87  
  88  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`)
  89  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';
  90  
  91  -- From 4.0.0-2018-02-24.sql
  92  DELETE FROM `#__extensions` WHERE `type` = 'library' AND `element` = 'idna_convert';
  93  
  94  -- From 4.0.0-2018-03-05.sql
  95  ALTER TABLE `#__modules` CHANGE `content` `content` TEXT NULL;