CoreFiles by mySites.guru
3.7.0-2017-03-09.sql17 lines, 627 bytes, from Joomla_3.7.1-Stable-Full_Package.zip
Raw History Compare with 3.7.0
md5
55134eb472cc4518f3da5d061eed3837
sha1
1e1ecfd406fd82e8a0a73a953fd10b1ef39ba9b8
sha256
0f9fa9c886193871c97e97ab34b9b46a0f0e27013dbcd2bc1676d57a22ffeef6
UPDATE "#__categories" AS "c"
SET published = c2.newPublished
FROM (
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
WHERE c2.id = c.id;

UPDATE "#__menu" AS "c"
SET published = c2.newPublished
FROM (
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
WHERE c2.id = c.id;

The same content is in 10 releases, Joomla 3.7.0-beta4 to 3.7.2. See them all, or every version of this file.