CoreFiles by mySites.guru
4.0.0-2019-03-30.sql9 lines, 582 bytes, from Joomla_4.2.8-Stable-Full_Package.zip
Raw History Compare with 4.2.7
md5
35c476814f58f4ad806b842b32db2a0f
sha1
5eb3e5a69c9ed78cbe188d63f1b4e15103aa4233
sha256
8fbbe6a26429b896b09f2301e2483e8770331803e2c54763d490f72b6cc80334
-- The following two statements were modified for 4.1.1 by adding the "/** CAN FAIL **/" installer hint.
-- See https://github.com/joomla/joomla-cms/pull/37156
ALTER TABLE "#__menu" ADD COLUMN "publish_up" timestamp without time zone /** CAN FAIL **/;
ALTER TABLE "#__menu" ADD COLUMN "publish_down" timestamp without time zone /** CAN FAIL **/;

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

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

The same content is in 80 releases, Joomla 4.2.0-alpha1 to 4.4.14. See them all, or every version of this file.