3.7.0-2016-11-24.sql 265 Bytes Raw Blame History Permalink 1 2 3 4 5 ALTER TABLE [#__extensions] ADD [package_id] [bigint] NOT NULL DEFAULT 0; UPDATE [#__extensions] SET [package_id] = (SELECT [extension_id] FROM [#__extensions] WHERE [type] = 'package' AND [element] = 'pkg_en-GB') WHERE [type]= 'language' AND [element] = 'en-GB';