[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"
   5     SET "package_id" = b."extension_id"
   6    FROM (SELECT "extension_id" FROM "#__extensions" WHERE "type"='package' AND "element"='pkg_search') AS b
   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'));