"Fossies" - the Fresh Open Source Software Archive

Member "administrator/components/com_admin/sql/updates/postgresql/4.0.0-2019-10-06.sql" (13 Sep 2021, 7460 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-09-23.sql
    2 ALTER TABLE "#__redirect_links" ALTER COLUMN "created_date" DROP DEFAULT;
    3 ALTER TABLE "#__redirect_links" ALTER COLUMN "modified_date" DROP DEFAULT;
    4 
    5 UPDATE "#__redirect_links" SET "created_date" = '1980-01-01 00:00:00' WHERE "created_date" = '1970-01-01 00:00:00';
    6 UPDATE "#__redirect_links" SET "modified_date" = "created_date" WHERE "modified_date" = '1970-01-01 00:00:00';
    7 
    8 -- From 4.0.0-2019-09-24.sql
    9 ALTER TABLE "#__action_logs" ALTER COLUMN "log_date" DROP DEFAULT;
   10 
   11 -- From 4.0.0-2019-09-25.sql
   12 ALTER TABLE "#__fields" ALTER COLUMN "created_time" DROP DEFAULT;
   13 ALTER TABLE "#__fields" ALTER COLUMN "modified_time" DROP DEFAULT;
   14 ALTER TABLE "#__fields" ALTER COLUMN "checked_out_time" DROP NOT NULL;
   15 ALTER TABLE "#__fields" ALTER COLUMN "checked_out_time" DROP DEFAULT;
   16 
   17 ALTER TABLE "#__fields_groups" ALTER COLUMN "created" DROP DEFAULT;
   18 ALTER TABLE "#__fields_groups" ALTER COLUMN "modified" DROP DEFAULT;
   19 ALTER TABLE "#__fields_groups" ALTER COLUMN "checked_out_time" DROP NOT NULL;
   20 ALTER TABLE "#__fields_groups" ALTER COLUMN "checked_out_time" DROP DEFAULT;
   21 
   22 UPDATE "#__fields" SET "modified_time" = "created_time", "modified_by" = "created_user_id" WHERE "modified_time" = '1970-01-01 00:00:00';
   23 UPDATE "#__fields" SET "checked_out_time" = NULL WHERE "checked_out_time" = '1970-01-01 00:00:00';
   24 
   25 UPDATE "#__fields_groups" SET "modified" = "created", "modified_by" = "created_by" WHERE "modified" = '1970-01-01 00:00:00';
   26 UPDATE "#__fields_groups" SET "checked_out_time" = NULL WHERE "checked_out_time" = '1970-01-01 00:00:00';
   27 
   28 -- From 4.0.0-2019-09-26.sql
   29 ALTER TABLE "#__privacy_requests" ALTER COLUMN "requested_at" DROP DEFAULT;
   30 
   31 ALTER TABLE "#__privacy_requests" ALTER COLUMN "confirm_token_created_at" DROP NOT NULL;
   32 ALTER TABLE "#__privacy_requests" ALTER COLUMN "confirm_token_created_at" DROP DEFAULT;
   33 
   34 ALTER TABLE "#__privacy_consents" ALTER COLUMN "created" DROP DEFAULT;
   35 
   36 UPDATE "#__privacy_requests" SET "confirm_token_created_at" = NULL WHERE "confirm_token_created_at" = '1970-01-01 00:00:00';
   37 
   38 -- From 4.0.0-2019-09-27.sql
   39 ALTER TABLE "#__tags" ALTER COLUMN "created_time" DROP DEFAULT;
   40 
   41 ALTER TABLE "#__tags" ALTER COLUMN "modified_time" DROP DEFAULT;
   42 
   43 ALTER TABLE "#__tags" ALTER COLUMN "publish_up" DROP NOT NULL;
   44 ALTER TABLE "#__tags" ALTER COLUMN "publish_up" DROP DEFAULT;
   45 
   46 ALTER TABLE "#__tags" ALTER COLUMN "publish_down" DROP NOT NULL;
   47 ALTER TABLE "#__tags" ALTER COLUMN "publish_down" DROP DEFAULT;
   48 
   49 ALTER TABLE "#__tags" ALTER COLUMN "checked_out_time" DROP NOT NULL;
   50 ALTER TABLE "#__tags" ALTER COLUMN "checked_out_time" DROP DEFAULT;
   51 
   52 UPDATE "#__tags" SET "modified_time" = "created_time", "modified_user_id" = "created_user_id" WHERE "modified_time" = '1970-01-01 00:00:00';
   53 
   54 UPDATE "#__tags" SET "publish_up" = NULL WHERE "publish_up" = '1970-01-01 00:00:00';
   55 UPDATE "#__tags" SET "publish_down" = NULL WHERE "publish_down" = '1970-01-01 00:00:00';
   56 UPDATE "#__tags" SET "checked_out_time" = NULL WHERE "checked_out_time" = '1970-01-01 00:00:00';
   57 
   58 UPDATE "#__ucm_content" SET "core_modified_time" = "core_created_time"
   59  WHERE "core_type_alias" = 'com_tags.tag'
   60    AND "core_modified_time" = '1970-01-01 00:00:00';
   61 
   62 UPDATE "#__ucm_content" SET "core_publish_up" = NULL
   63  WHERE "core_type_alias" = 'com_tags.tag'
   64    AND "core_publish_up" = '1970-01-01 00:00:00';
   65 UPDATE "#__ucm_content" SET "core_publish_down" = NULL
   66  WHERE "core_type_alias" = 'com_tags.tag'
   67    AND "core_publish_down" = '1970-01-01 00:00:00';
   68 UPDATE "#__ucm_content" SET "core_checked_out_time" = NULL
   69  WHERE "core_type_alias" = 'com_tags.tag'
   70    AND "core_checked_out_time" = '1970-01-01 00:00:00';
   71 
   72 -- From 4.0.0-2019-09-28.sql
   73 ALTER TABLE "#__user_notes" ALTER COLUMN "created_time" DROP DEFAULT;
   74 
   75 ALTER TABLE "#__user_notes" ALTER COLUMN "modified_time" DROP DEFAULT;
   76 
   77 ALTER TABLE "#__user_notes" ALTER COLUMN "review_time" DROP NOT NULL;
   78 ALTER TABLE "#__user_notes" ALTER COLUMN "review_time" DROP DEFAULT;
   79 
   80 ALTER TABLE "#__user_notes" ALTER COLUMN "publish_up" DROP NOT NULL;
   81 ALTER TABLE "#__user_notes" ALTER COLUMN "publish_up" DROP DEFAULT;
   82 
   83 ALTER TABLE "#__user_notes" ALTER COLUMN "publish_down" DROP NOT NULL;
   84 ALTER TABLE "#__user_notes" ALTER COLUMN "publish_down" DROP DEFAULT;
   85 
   86 ALTER TABLE "#__user_notes" ALTER COLUMN "checked_out_time" DROP NOT NULL;
   87 ALTER TABLE "#__user_notes" ALTER COLUMN "checked_out_time" DROP DEFAULT;
   88 
   89 UPDATE "#__user_notes" SET "modified_time" = "created_time", "modified_user_id" = "created_user_id" WHERE "modified_time" = '1970-01-01 00:00:00';
   90 
   91 UPDATE "#__user_notes" SET "review_time" = NULL WHERE "review_time" = '1970-01-01 00:00:00';
   92 UPDATE "#__user_notes" SET "publish_up" = NULL WHERE "publish_up" = '1970-01-01 00:00:00';
   93 UPDATE "#__user_notes" SET "publish_down" = NULL WHERE "publish_down" = '1970-01-01 00:00:00';
   94 UPDATE "#__user_notes" SET "checked_out_time" = NULL WHERE "checked_out_time" = '1970-01-01 00:00:00';
   95 
   96 UPDATE "#__ucm_content" SET "core_modified_time" = "core_created_time"
   97  WHERE "core_type_alias" = 'com_users.note'
   98    AND "core_modified_time" = '1970-01-01 00:00:00';
   99 
  100 UPDATE "#__ucm_content" SET "core_publish_up" = NULL
  101  WHERE "core_type_alias" = 'com_users.note'
  102    AND "core_publish_up" = '1970-01-01 00:00:00';
  103 UPDATE "#__ucm_content" SET "core_publish_down" = NULL
  104  WHERE "core_type_alias" = 'com_users.note'
  105    AND "core_publish_down" = '1970-01-01 00:00:00';
  106 UPDATE "#__ucm_content" SET "core_checked_out_time" = NULL
  107  WHERE "core_type_alias" = 'com_users.note'
  108    AND "core_checked_out_time" = '1970-01-01 00:00:00';
  109 
  110 -- From 4.0.0-2019-09-29.sql
  111 ALTER TABLE "#__categories" ALTER COLUMN "created_time" DROP DEFAULT;
  112 
  113 ALTER TABLE "#__categories" ALTER COLUMN "modified_time" DROP DEFAULT;
  114 
  115 ALTER TABLE "#__categories" ALTER COLUMN "checked_out_time" DROP NOT NULL;
  116 ALTER TABLE "#__categories" ALTER COLUMN "checked_out_time" DROP DEFAULT;
  117 
  118 UPDATE "#__categories" SET "created_time" = '1980-01-01 00:00:00' WHERE "created_time" = '1970-01-01 00:00:00';
  119 UPDATE "#__categories" SET "modified_time" = "created_time", "modified_user_id" = "created_user_id" WHERE "modified_time" = '1970-01-01 00:00:00';
  120 
  121 UPDATE "#__categories" SET "checked_out_time" = NULL WHERE "checked_out_time" = '1970-01-01 00:00:00';
  122 
  123 UPDATE "#__ucm_content" SET "core_created_time" = '1980-01-01 00:00:00'
  124  WHERE "core_type_alias" IN ('com_content.category', 'com_contact.category', 'com_newsfeeds.category', 'com_banners.category', 'com_users.category')
  125    AND "core_created_time" = '1970-01-01 00:00:00';
  126 
  127 UPDATE "#__ucm_content" SET "core_modified_time" = "core_created_time"
  128  WHERE "core_type_alias" IN ('com_content.category', 'com_contact.category', 'com_newsfeeds.category', 'com_banners.category', 'com_users.category')
  129    AND "core_modified_time" = '1970-01-01 00:00:00';
  130 
  131 UPDATE "#__ucm_content" SET "core_checked_out_time" = NULL
  132  WHERE "core_type_alias" IN ('com_content.category', 'com_contact.category', 'com_newsfeeds.category', 'com_banners.category', 'com_users.category')
  133    AND "core_checked_out_time" = '1970-01-01 00:00:00';
  134 
  135 -- From 4.0.0-2019-10-06.sql
  136 ALTER TABLE "#__extensions" ALTER COLUMN "checked_out_time" DROP NOT NULL;
  137 ALTER TABLE "#__extensions" ALTER COLUMN "checked_out_time" DROP DEFAULT;
  138 
  139 UPDATE "#__extensions" SET "checked_out_time" = NULL WHERE "checked_out_time" = '1970-01-01 00:00:00';