"Fossies" - the Fresh Open Source Software Archive

Member "administrator/components/com_admin/sql/updates/mysql/4.0.0-2020-03-10.sql" (13 Sep 2021, 1412 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-2020-02-08.sql
    2 ALTER TABLE `#__banners` MODIFY `metakey` text;
    3 ALTER TABLE `#__banner_clients` MODIFY `metakey` text;
    4 ALTER TABLE `#__contact_details` MODIFY `metakey` text;
    5 ALTER TABLE `#__content` MODIFY `metakey` text;
    6 ALTER TABLE `#__languages` MODIFY `metakey` text;
    7 ALTER TABLE `#__newsfeeds` MODIFY `metakey` text;
    8 ALTER TABLE `#__tags` MODIFY `metakey` varchar(1024) NOT NULL DEFAULT '';
    9 
   10 -- From 4.0.0-2020-02-20.sql
   11 ALTER TABLE `#__content_types` MODIFY `table` varchar(2048) NOT NULL DEFAULT '';
   12 
   13 -- From 4.0.0-2020-02-22.sql
   14 DELETE FROM `#__extensions` WHERE `name` = 'com_mailto';
   15 
   16 -- From 4.0.0-2020-02-29.sql
   17 INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `checked_out`, `checked_out_time`, `ordering`, `state`) VALUES
   18 (0, 'plg_system_accessibility', 'plugin', 'accessibility', 'system', 0, 0, 1, 0, '', '{}', '', 0, NULL, 0, 0);
   19 
   20 -- From 4.0.0-2020-03-10.sql
   21 INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `checked_out`, `checked_out_time`, `ordering`, `state`)
   22 SELECT `extension_id`, 'English (en-GB)', 'language', 'en-GB', '', 3, 1, 1, 1, '', '', '', 0, NULL, 0, 0 FROM `#__extensions` WHERE `name` = 'English (en-GB) Language Pack';