CoreFiles by mySites.guru
3.9.0-2018-10-20.sql25 lines, 1,138 bytes, from Joomla_3.9.21-Stable-Full_Package.zip
Raw History Compare with 3.9.20
md5
8f567598da822223668d92e408e50a09
sha1
7300632d6b9cc18471b91195810cdecea297abbc
sha256
c6999873f213cc6e38bb13010260b9f76c11e99e5d51197a9352890a9ff6186a
-- Drop default values
DECLARE @table AS nvarchar(100)
DECLARE @constraintName AS nvarchar(100)
DECLARE @constraintQuery AS nvarchar(1000)
SET QUOTED_IDENTIFIER OFF
SET @table = "#__privacy_requests"
SET QUOTED_IDENTIFIER ON

-- Drop default value from checked_out
SELECT @constraintName = name FROM sys.default_constraints
WHERE parent_object_id = object_id(@table)
AND parent_column_id = columnproperty(object_id(@table), 'checked_out', 'ColumnId')
SET @constraintQuery = 'ALTER TABLE [' + @table + '] DROP CONSTRAINT [' + @constraintName + ']'
EXECUTE sp_executesql @constraintQuery

-- Drop default value from checked_out_time
SELECT @constraintName = name FROM sys.default_constraints
WHERE parent_object_id = object_id(@table)
AND parent_column_id = columnproperty(object_id(@table), 'checked_out_time', 'ColumnId')
SET @constraintQuery = 'ALTER TABLE [' + @table + '] DROP CONSTRAINT [' + @constraintName + ']'
EXECUTE sp_executesql @constraintQuery;

DROP INDEX "idx_checkout" ON "#__privacy_requests";
ALTER TABLE "#__privacy_requests" DROP COLUMN "checked_out";
ALTER TABLE "#__privacy_requests" DROP COLUMN "checked_out_time";

The same content is in 79 releases, Joomla 3.9.3-rc to 3.10.12. See them all, or every version of this file.