"Fossies" - the Fresh Open Source Software Archive

Member "administrator/components/com_admin/sql/updates/mysql/4.0.0-2019-06-29.sql" (13 Sep 2021, 3774 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-2019-06-28.sql
    2 ALTER TABLE `#__banners` MODIFY `created` datetime NOT NULL;
    3 ALTER TABLE `#__banners` MODIFY `modified` datetime NOT NULL;
    4 
    5 ALTER TABLE `#__banners` MODIFY `reset` datetime NULL DEFAULT NULL;
    6 ALTER TABLE `#__banners` MODIFY `publish_up` datetime NULL DEFAULT NULL;
    7 ALTER TABLE `#__banners` MODIFY `publish_down` datetime NULL DEFAULT NULL;
    8 ALTER TABLE `#__banners` MODIFY `checked_out_time` datetime NULL DEFAULT NULL;
    9 
   10 ALTER TABLE `#__banner_clients` MODIFY `checked_out_time` datetime NULL DEFAULT NULL;
   11 
   12 UPDATE `#__banners` SET `created` = '1980-01-01 00:00:00' WHERE `created` = '0000-00-00 00:00:00';
   13 UPDATE `#__banners` SET `modified` = `created`, `modified_by` = `created_by` WHERE `modified` = '0000-00-00 00:00:00';
   14 
   15 UPDATE `#__banners` SET `reset` = NULL WHERE `reset` = '0000-00-00 00:00:00';
   16 UPDATE `#__banners` SET `publish_up` = NULL WHERE `publish_up` = '0000-00-00 00:00:00';
   17 UPDATE `#__banners` SET `publish_down` = NULL WHERE `publish_down` = '0000-00-00 00:00:00';
   18 UPDATE `#__banners` SET `checked_out_time` = NULL WHERE `checked_out_time` = '0000-00-00 00:00:00';
   19 
   20 UPDATE `#__banner_clients` SET `checked_out_time` = NULL WHERE `checked_out_time` = '0000-00-00 00:00:00';
   21 
   22 UPDATE `#__ucm_content` SET `core_created_time` = '1980-01-01 00:00:00'
   23  WHERE `core_type_alias` = 'com_banners.banner'
   24    AND `core_created_time` = '0000-00-00 00:00:00';
   25 
   26 UPDATE `#__ucm_content` SET `core_modified_time` = `core_created_time`
   27  WHERE `core_type_alias` = 'com_banners.banner'
   28    AND `core_modified_time` = '0000-00-00 00:00:00';
   29 
   30 UPDATE `#__ucm_content` SET `core_publish_up` = NULL
   31  WHERE `core_type_alias` = 'com_banners.banner'
   32    AND `core_publish_up` = '0000-00-00 00:00:00';
   33 UPDATE `#__ucm_content` SET `core_publish_down` = NULL
   34  WHERE `core_type_alias` = 'com_banners.banner'
   35    AND `core_publish_down` = '0000-00-00 00:00:00';
   36 UPDATE `#__ucm_content` SET `core_checked_out_time` = NULL
   37  WHERE `core_type_alias` = 'com_banners.banner'
   38    AND `core_checked_out_time` = '0000-00-00 00:00:00';
   39 
   40 -- From 4.0.0-2019-06-29.sql
   41 ALTER TABLE `#__newsfeeds` MODIFY `created` datetime NOT NULL;
   42 ALTER TABLE `#__newsfeeds` MODIFY `modified` datetime NOT NULL;
   43 
   44 ALTER TABLE `#__newsfeeds` MODIFY `publish_up` datetime NULL DEFAULT NULL;
   45 ALTER TABLE `#__newsfeeds` MODIFY `publish_down` datetime NULL DEFAULT NULL;
   46 ALTER TABLE `#__newsfeeds` MODIFY `checked_out_time` datetime NULL DEFAULT NULL;
   47 
   48 UPDATE `#__newsfeeds` SET `created` = '1980-01-01 00:00:00' WHERE `created` = '0000-00-00 00:00:00';
   49 UPDATE `#__newsfeeds` SET `modified` = `created`, `modified_by` = `created_by` WHERE `modified` = '0000-00-00 00:00:00';
   50 
   51 UPDATE `#__newsfeeds` SET `publish_up` = NULL WHERE `publish_up` = '0000-00-00 00:00:00';
   52 UPDATE `#__newsfeeds` SET `publish_down` = NULL WHERE `publish_down` = '0000-00-00 00:00:00';
   53 UPDATE `#__newsfeeds` SET `checked_out_time` = NULL WHERE `checked_out_time` = '0000-00-00 00:00:00';
   54 
   55 UPDATE `#__ucm_content` SET `core_created_time` = '1980-01-01 00:00:00'
   56  WHERE `core_type_alias` = 'com_newsfeeds.newsfeed'
   57    AND `core_created_time` = '0000-00-00 00:00:00';
   58 
   59 UPDATE `#__ucm_content` SET `core_modified_time` = `core_created_time`
   60  WHERE `core_type_alias` = 'com_newsfeeds.newsfeed'
   61    AND `core_modified_time` = '0000-00-00 00:00:00';
   62 
   63 UPDATE `#__ucm_content` SET `core_publish_up` = NULL
   64  WHERE `core_type_alias` = 'com_newsfeeds.newsfeed'
   65    AND `core_publish_up` = '0000-00-00 00:00:00';
   66 UPDATE `#__ucm_content` SET `core_publish_down` = NULL
   67  WHERE `core_type_alias` = 'com_newsfeeds.newsfeed'
   68    AND `core_publish_down` = '0000-00-00 00:00:00';
   69 UPDATE `#__ucm_content` SET `core_checked_out_time` = NULL
   70  WHERE `core_type_alias` = 'com_newsfeeds.newsfeed'
   71    AND `core_checked_out_time` = '0000-00-00 00:00:00';