Blame view

administrator/components/com_admin/sql/updates/sqlazure/3.7.0-2016-11-24.sql 265 Bytes
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';