"Fossies" - the Fresh Open Source Software Archive

Member "administrator/components/com_admin/sql/updates/mysql/3.0.0.sql" (18 Jun 2022, 8848 Bytes) of package /linux/www/Joomla_3.10.10-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. See also the last Fossies "Diffs" side-by-side code changes report for "3.0.0.sql": 3.10.6_vs_3.10.7.

A hint: This file contains one or more very long lines, so maybe it is better readable using the pure text view mode that shows the contents as wrapped lines within the browser window.

    1 ALTER TABLE `#__users` DROP INDEX `usertype`;
    2 ALTER TABLE `#__session` DROP INDEX `whosonline`;
    3 
    4 DROP TABLE IF EXISTS `#__update_categories`;
    5 
    6 ALTER TABLE `#__contact_details` DROP `imagepos`;
    7 ALTER TABLE `#__content` DROP COLUMN `title_alias`;
    8 ALTER TABLE `#__content` DROP COLUMN `sectionid`;
    9 ALTER TABLE `#__content` DROP COLUMN `mask`;
   10 ALTER TABLE `#__content` DROP COLUMN `parentid`;
   11 ALTER TABLE `#__newsfeeds` DROP COLUMN `filename`;
   12 ALTER TABLE `#__menu` DROP COLUMN `ordering`;
   13 ALTER TABLE `#__session` DROP COLUMN `usertype`;
   14 ALTER TABLE `#__users` DROP COLUMN `usertype`;
   15 ALTER TABLE `#__updates` DROP COLUMN `categoryid`;
   16 
   17 UPDATE `#__extensions` SET protected = 0 WHERE
   18 `name` = 'com_search' OR
   19 `name` = 'mod_articles_archive' OR
   20 `name` = 'mod_articles_latest' OR
   21 `name` = 'mod_banners' OR
   22 `name` = 'mod_feed' OR
   23 `name` = 'mod_footer' OR
   24 `name` = 'mod_users_latest' OR
   25 `name` = 'mod_articles_category' OR
   26 `name` = 'mod_articles_categories' OR
   27 `name` = 'plg_content_pagebreak' OR
   28 `name` = 'plg_content_pagenavigation' OR
   29 `name` = 'plg_content_vote' OR
   30 `name` = 'plg_editors_tinymce' OR
   31 `name` = 'plg_system_p3p' OR
   32 `name` = 'plg_user_contactcreator' OR
   33 `name` = 'plg_user_profile';
   34 
   35 DELETE FROM `#__extensions` WHERE `extension_id` = 800;
   36 
   37 ALTER TABLE `#__assets` ENGINE=InnoDB;
   38 ALTER TABLE `#__associations` ENGINE=InnoDB;
   39 ALTER TABLE `#__banners` ENGINE=InnoDB;
   40 ALTER TABLE `#__banner_clients` ENGINE=InnoDB;
   41 ALTER TABLE `#__banner_tracks` ENGINE=InnoDB;
   42 ALTER TABLE `#__categories` ENGINE=InnoDB;
   43 ALTER TABLE `#__contact_details` ENGINE=InnoDB;
   44 ALTER TABLE `#__content` ENGINE=InnoDB;
   45 ALTER TABLE `#__content_frontpage` ENGINE=InnoDB;
   46 ALTER TABLE `#__content_rating` ENGINE=InnoDB;
   47 ALTER TABLE `#__core_log_searches` ENGINE=InnoDB;
   48 ALTER TABLE `#__extensions` ENGINE=InnoDB;
   49 ALTER TABLE `#__finder_filters` ENGINE=InnoDB;
   50 ALTER TABLE `#__finder_links` ENGINE=InnoDB;
   51 ALTER TABLE `#__finder_links_terms0` ENGINE=InnoDB;
   52 ALTER TABLE `#__finder_links_terms1` ENGINE=InnoDB;
   53 ALTER TABLE `#__finder_links_terms2` ENGINE=InnoDB;
   54 ALTER TABLE `#__finder_links_terms3` ENGINE=InnoDB;
   55 ALTER TABLE `#__finder_links_terms4` ENGINE=InnoDB;
   56 ALTER TABLE `#__finder_links_terms5` ENGINE=InnoDB;
   57 ALTER TABLE `#__finder_links_terms6` ENGINE=InnoDB;
   58 ALTER TABLE `#__finder_links_terms7` ENGINE=InnoDB;
   59 ALTER TABLE `#__finder_links_terms8` ENGINE=InnoDB;
   60 ALTER TABLE `#__finder_links_terms9` ENGINE=InnoDB;
   61 ALTER TABLE `#__finder_links_termsa` ENGINE=InnoDB;
   62 ALTER TABLE `#__finder_links_termsb` ENGINE=InnoDB;
   63 ALTER TABLE `#__finder_links_termsc` ENGINE=InnoDB;
   64 ALTER TABLE `#__finder_links_termsd` ENGINE=InnoDB;
   65 ALTER TABLE `#__finder_links_termse` ENGINE=InnoDB;
   66 ALTER TABLE `#__finder_links_termsf` ENGINE=InnoDB;
   67 ALTER TABLE `#__finder_taxonomy` ENGINE=InnoDB;
   68 ALTER TABLE `#__finder_taxonomy_map` ENGINE=InnoDB;
   69 ALTER TABLE `#__finder_terms` ENGINE=InnoDB;
   70 ALTER TABLE `#__finder_terms_common` ENGINE=InnoDB;
   71 ALTER TABLE `#__finder_types` ENGINE=InnoDB;
   72 ALTER TABLE `#__languages` ENGINE=InnoDB;
   73 ALTER TABLE `#__menu` ENGINE=InnoDB;
   74 ALTER TABLE `#__menu_types` ENGINE=InnoDB;
   75 ALTER TABLE `#__messages` ENGINE=InnoDB;
   76 ALTER TABLE `#__messages_cfg` ENGINE=InnoDB;
   77 ALTER TABLE `#__modules` ENGINE=InnoDB;
   78 ALTER TABLE `#__modules_menu` ENGINE=InnoDB;
   79 ALTER TABLE `#__newsfeeds` ENGINE=InnoDB;
   80 ALTER TABLE `#__overrider` ENGINE=InnoDB;
   81 ALTER TABLE `#__redirect_links` ENGINE=InnoDB;
   82 ALTER TABLE `#__schemas` ENGINE=InnoDB;
   83 ALTER TABLE `#__session` ENGINE=InnoDB;
   84 ALTER TABLE `#__template_styles` ENGINE=InnoDB;
   85 ALTER TABLE `#__updates` ENGINE=InnoDB;
   86 ALTER TABLE `#__update_sites` ENGINE=InnoDB;
   87 ALTER TABLE `#__update_sites_extensions` ENGINE=InnoDB;
   88 ALTER TABLE `#__users` ENGINE=InnoDB;
   89 ALTER TABLE `#__usergroups` ENGINE=InnoDB;
   90 ALTER TABLE `#__user_notes` ENGINE=InnoDB;
   91 ALTER TABLE `#__user_profiles` ENGINE=InnoDB;
   92 ALTER TABLE `#__user_usergroup_map` ENGINE=InnoDB;
   93 ALTER TABLE `#__viewlevels` ENGINE=InnoDB;
   94 
   95 ALTER TABLE `#__newsfeeds` ADD COLUMN `description` text NOT NULL;
   96 ALTER TABLE `#__newsfeeds` ADD COLUMN `version` int unsigned NOT NULL DEFAULT '1';
   97 ALTER TABLE `#__newsfeeds` ADD COLUMN `hits` int unsigned NOT NULL DEFAULT '0';
   98 ALTER TABLE `#__newsfeeds` ADD COLUMN `images` text NOT NULL;
   99 ALTER TABLE `#__contact_details` ADD COLUMN `version` int unsigned NOT NULL DEFAULT '1';
  100 ALTER TABLE `#__contact_details` ADD COLUMN `hits` int unsigned NOT NULL DEFAULT '0';
  101 ALTER TABLE `#__banners` ADD COLUMN `created_by` int unsigned NOT NULL DEFAULT '0';
  102 ALTER TABLE `#__banners` ADD COLUMN `created_by_alias` varchar(255) NOT NULL DEFAULT '';
  103 ALTER TABLE `#__banners` ADD COLUMN `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
  104 ALTER TABLE `#__banners` ADD COLUMN `modified_by` int unsigned NOT NULL DEFAULT '0';
  105 ALTER TABLE `#__banners` ADD COLUMN `version` int unsigned NOT NULL DEFAULT '1';
  106 ALTER TABLE `#__categories` ADD COLUMN `version` int unsigned NOT NULL DEFAULT '1';
  107 UPDATE  `#__assets` SET name=REPLACE( name, 'com_user.notes.category','com_users.category'  );
  108 UPDATE  `#__categories` SET extension=REPLACE( extension, 'com_user.notes.category','com_users.category'  );
  109 
  110 ALTER TABLE `#__finder_terms` ADD COLUMN `language` char(3) NOT NULL DEFAULT '';
  111 ALTER TABLE `#__finder_tokens` ADD COLUMN `language` char(3) NOT NULL DEFAULT '';
  112 ALTER TABLE `#__finder_tokens_aggregate` ADD COLUMN `language` char(3) NOT NULL DEFAULT '';
  113 
  114 INSERT INTO `#__extensions`
  115     (`name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `system_data`, `checked_out`, `checked_out_time`, `ordering`, `state`)
  116     VALUES
  117     ('isis', 'template', 'isis', '', 1, 1, 1, 0, '{"name":"isis","type":"template","creationDate":"3\\/30\\/2012","author":"Kyle Ledbetter","copyright":"(C) 2012 Open Source Matters, Inc.","authorEmail":"admin@joomla.org","authorUrl":"","version":"1.0","description":"TPL_ISIS_XML_DESCRIPTION","group":""}', '{"templateColor":"","logoFile":""}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
  118     ('protostar', 'template', 'protostar', '', 0, 1, 1, 0, '{"name":"protostar","type":"template","creationDate":"4\\/30\\/2012","author":"Kyle Ledbetter","copyright":"(C) 2012 Open Source Matters, Inc.","authorEmail":"admin@joomla.org","authorUrl":"","version":"1.0","description":"TPL_PROTOSTAR_XML_DESCRIPTION","group":""}', '{"templateColor":"","logoFile":"","googleFont":"0","googleFontName":"Open+Sans","fluidContainer":"0"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
  119     ('beez3', 'template', 'beez3', '', 0, 1, 1, 0, '{"legacy":false,"name":"beez3","type":"template","creationDate":"25 November 2009","author":"Angie Radtke","copyright":"(C) 2009 Open Source Matters, Inc.","authorEmail":"a.radtke@derauftritt.de","authorUrl":"http:\\/\\/www.der-auftritt.de","version":"1.6.0","description":"TPL_BEEZ3_XML_DESCRIPTION","group":""}', '{"wrapperSmall":"53","wrapperLarge":"72","sitetitle":"","sitedescription":"","navposition":"center","templatecolor":"nature"}', '', '', 0, '0000-00-00 00:00:00', 0, 0);
  120 
  121 INSERT INTO `#__template_styles` (`template`, `client_id`, `home`, `title`, `params`) VALUES
  122     ('protostar', 0, '0', 'protostar - Default', '{"templateColor":"","logoFile":"","googleFont":"0","googleFontName":"Open+Sans","fluidContainer":"0"}'),
  123     ('isis', 1, '1', 'isis - Default', '{"templateColor":"","logoFile":""}'),
  124     ('beez3', 0, '0', 'beez3 - Default', '{"wrapperSmall":53,"wrapperLarge":72,"logo":"","sitetitle":"","sitedescription":"","navposition":"center","bootstrap":"","templatecolor":"nature","headerImage":"","backgroundcolor":"#eee"}');
  125 
  126 UPDATE `#__template_styles`
  127 SET home = (CASE WHEN (SELECT count FROM (SELECT count(`id`) AS count
  128             FROM `#__template_styles`
  129             WHERE home = '1'
  130             AND client_id = 1) as c) = 0
  131             THEN '1'
  132             ELSE '0'
  133             END)
  134 WHERE template = 'isis'
  135 AND home != '1';
  136 
  137 UPDATE `#__template_styles`
  138 SET home = 0
  139 WHERE template = 'bluestork';
  140 
  141 INSERT INTO `#__extensions` (`extension_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `system_data`, `checked_out`, `checked_out_time`, `ordering`, `state`) VALUES
  142 (315, 'mod_stats_admin', 'module', 'mod_stats_admin', '', 1, 1, 1, 0, '{"name":"mod_stats_admin","type":"module","creationDate":"September 2012","author":"Joomla! Project","copyright":"(C) 2012 Open Source Matters, Inc.","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"3.0.0","description":"MOD_STATS_XML_DESCRIPTION","group":""}', '{"serverinfo":"0","siteinfo":"0","counter":"0","increase":"0","cache":"1","cache_time":"900","cachemode":"static"}', '', '', 0, '0000-00-00 00:00:00', 0, 0);
  143 
  144 UPDATE `#__update_sites`
  145 SET location = 'https://update.joomla.org/language/translationlist_3.xml'
  146 WHERE location = 'https://update.joomla.org/language/translationlist.xml'
  147 AND name = 'Accredited Joomla! Translations';