CoreFiles by mySites.guru
3.7.0-2016-11-04.sql13 lines, 653 bytes, from Joomla_3.9.13-Stable-Full_Package.zip
Raw History Compare with 3.9.12
md5
3e6a116edf63b775a11155dd43609734
sha1
81b70620d7f0f353576f7a7df7d5a2cc90605e80
sha256
fc9013a379df7086c5aa493bf9197c811500355aff42748fac24ea1f3811a3fa
-- Change default value for enabled column.
DECLARE @table AS nvarchar(100)
DECLARE @constraintName AS nvarchar(100)
DECLARE @constraintQuery AS nvarchar(1000)
SET QUOTED_IDENTIFIER OFF
SET @table = "#__extensions"
SET QUOTED_IDENTIFIER ON
SELECT @constraintName = name FROM sys.default_constraints
WHERE parent_object_id = object_id(@table)
AND parent_column_id = columnproperty(object_id(@table), 'enabled', 'ColumnId')
SET @constraintQuery = 'ALTER TABLE [' + @table + '] DROP CONSTRAINT [' + @constraintName
+ ']; ALTER TABLE [' + @table + '] ADD CONSTRAINT [' + @constraintName + '] DEFAULT 0 FOR [enabled]'
EXECUTE sp_executesql @constraintQuery;

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