CoreFiles by mySites.guru
4.0.0-2019-10-17.sql21 lines, 1,085 bytes, from Joomla_4.2.8-Stable-Full_Package.zip
Raw History Compare with 4.2.7
md5
0c4a1bb6a03f37775545bea6013282f5
sha1
51fa0bbd44e966238fa0adf3dfb08d93db7bbec6
sha256
f4a767984a8d17c3926c51e00849d51ccfaf867078ba68bc70a37c5a70ddc748
-- From 4.0.0-2019-10-13.sql
UPDATE "#__content_types"
   SET "field_mappings" = REPLACE("field_mappings",'"core_created_time":"registerdate"','"core_created_time":"registerDate"')
 WHERE "type_alias" = 'com_users.user';

-- From 4.0.0-2019-10-17.sql
ALTER TABLE "#__users" ALTER COLUMN "registerDate" DROP DEFAULT;

ALTER TABLE "#__users" ALTER COLUMN "lastvisitDate" DROP NOT NULL;
ALTER TABLE "#__users" ALTER COLUMN "lastvisitDate" DROP DEFAULT;

ALTER TABLE "#__users" ALTER COLUMN "lastResetTime" DROP NOT NULL;
ALTER TABLE "#__users" ALTER COLUMN "lastResetTime" DROP DEFAULT;

UPDATE "#__users" SET "registerDate" = '1980-01-01 00:00:00' WHERE "registerDate" = '1970-01-01 00:00:00';
UPDATE "#__users" SET "lastvisitDate" = NULL WHERE "lastvisitDate" = '1970-01-01 00:00:00';
UPDATE "#__users" SET "lastResetTime" = NULL WHERE "lastResetTime" = '1970-01-01 00:00:00';

UPDATE "#__content_types"
   SET "field_mappings" = REPLACE("field_mappings",'"core_modified_time":"lastvisitDate"','"core_modified_time":"null"')
 WHERE "type_alias" = 'com_users.user';

The same content is in 124 releases, Joomla 4.0.0-rc1 to 4.4.14. See them all, or every version of this file.