[Summary view] [Print] [Text view]

   1  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
   2  ('search', 'package', 'pkg_search', '', 0, 1, 1, 0, '', '', '', 0, NULL, 0, 0);
   3  
   4  UPDATE `#__extensions` a
   5   CROSS JOIN (SELECT `extension_id` FROM `#__extensions` WHERE `type`='package' AND `element`='pkg_search') AS b
   6     SET a.`package_id` = b.`extension_id`
   7   WHERE (`type` = 'component' AND `element` = 'com_search')
   8      OR (`type` = 'module' AND `element` = 'mod_search' AND `client_id` = 0)
   9      OR (`type` = 'plugin' AND `element` IN ('categories', 'contacts', 'content', 'newsfeeds', 'tags') AND `folder` = 'search');
  10  
  11  INSERT INTO `#__update_sites` (`name`, `type`, `location`, `enabled`) VALUES
  12  ('Search Update Site', 'extension', 'https://raw.githubusercontent.com/joomla-extensions/search/main/manifest.xml', 1);
  13  
  14  INSERT INTO `#__update_sites_extensions` (`update_site_id`, `extension_id`) VALUES
  15  ((SELECT `update_site_id` FROM `#__update_sites` WHERE `name` = 'Search Update Site'), (SELECT `extension_id` FROM `#__extensions` WHERE `element` = 'pkg_search' AND `type` = 'package'));