CoreFiles by mySites.guru
3.7.0-2017-03-09.sql19 lines, 769 bytes, from Joomla_3.9.21-Stable-Full_Package.zip
Raw History Compare with 3.9.20
md5
0f370a081abd9e0ecfdfe10f4459c376
sha1
a38e6880a4e524dc674561eefb59f29a111fea28
sha256
c3c94148589f8d5260843234555a86aa44eb2a358ed0dc151e9e54975036a280
UPDATE "#__categories" SET published = 1 WHERE alias = 'root';
UPDATE "c"
SET published = c2.newPublished
FROM "#__categories" AS "c"
INNER JOIN (
SELECT c2.id,CASE WHEN MIN(p.published) > 0 THEN MAX(p.published) ELSE MIN(p.published) END AS newPublished
FROM "#__categories" AS "c2"
INNER JOIN "#__categories" AS "p" ON p.lft <= c2.lft AND c2.rgt <= p.rgt
GROUP BY c2.id) AS c2 ON c2.id = c.id;

UPDATE "#__menu" SET published = 1 WHERE alias = 'root';
UPDATE "c"
SET published = c2.newPublished
FROM "#__menu" AS "c"
INNER JOIN (
SELECT c2.id,CASE WHEN MIN(p.published) > 0 THEN MAX(p.published) ELSE MIN(p.published) END AS newPublished
FROM "#__menu" AS "c2"
INNER JOIN "#__menu" AS "p" ON p.lft <= c2.lft AND c2.rgt <= p.rgt
GROUP BY c2.id) AS c2 ON c2.id = c.id;

The same content is in 130 releases, Joomla 3.7.3-beta1 to 3.10.12. See them all, or every version of this file.