"Fossies" - the Fresh Open Source Software Archive

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