CoreFiles by mySites.guru
3.7.0-2016-11-24.sql6 lines, 299 bytes, from Joomla_3.7.2-Stable-Full_Package.zip
Raw History Compare with 3.7.1
md5
c7c7fa43c1cbcb1c31d696a097de5698
sha1
4c536dd5f14393fb3b415d65d284f1c2c2e31905
sha256
4e39392b7fbfac73ac184a2c3c64e941f9b1c547dd7dc4628fcf13afd82dcaa8
ALTER TABLE "#__extensions" ADD COLUMN "package_id" bigint DEFAULT 0 NOT NULL;

UPDATE "#__extensions"
SET "package_id" = sub.extension_id
FROM (SELECT "extension_id" FROM "#__extensions" WHERE "type" = 'package' AND "element" = 'pkg_en-GB') AS sub
WHERE "type"= 'language' AND "element" = 'en-GB';

The same content is in 145 releases, Joomla 3.7.0-alpha1 to 3.10.12. See them all, or every version of this file.