From c1f9b1f7b1b77776192048005dcc66dcf3df2bfb Mon Sep 17 00:00:00 2001 From: Pierre Schmitz Date: Sat, 27 Dec 2014 15:41:37 +0100 Subject: Update to MediaWiki 1.24.1 --- maintenance/mssql/archives/named_constraints.sql | 38 ++++++++++++++++++++++++ 1 file changed, 38 insertions(+) create mode 100644 maintenance/mssql/archives/named_constraints.sql (limited to 'maintenance/mssql/archives/named_constraints.sql') diff --git a/maintenance/mssql/archives/named_constraints.sql b/maintenance/mssql/archives/named_constraints.sql new file mode 100644 index 00000000..94b77ea7 --- /dev/null +++ b/maintenance/mssql/archives/named_constraints.sql @@ -0,0 +1,38 @@ +DECLARE @fullyQualifiedTableName nvarchar(max), +@tableName sysname, +@fieldName sysname, +@constr sysname, +@constrNew sysname, +@sqlcmd nvarchar(max), +@sqlcreate nvarchar(max) + +SET @fullyQualifiedTableName = '/*_*//*$tableName*/' +SET @tableName = '/*$tableName*/' +SET @fieldName = '/*$fieldName*/' + +SELECT @constr = CONSTRAINT_NAME +FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS +WHERE TABLE_NAME = @tableName +AND CONSTRAINT_CATALOG = '/*$wgDBname*/' +AND CONSTRAINT_SCHEMA = '/*$wgDBmwschema*/' +AND CONSTRAINT_TYPE = 'CHECK' +AND CONSTRAINT_NAME LIKE ('CK__' + left(@tableName,9) + '__' + left(@fieldName,5) + '%') + +SELECT @constrNew = CONSTRAINT_NAME +FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS +WHERE TABLE_NAME = @tableName +AND CONSTRAINT_CATALOG = '/*$wgDBname*/' +AND CONSTRAINT_SCHEMA = '/*$wgDBmwschema*/' +AND CONSTRAINT_TYPE = 'CHECK' +AND CONSTRAINT_NAME = (@fieldName + '_ckc') + +IF @constr IS NOT NULL +BEGIN + SET @sqlcmd = 'ALTER TABLE ' + @fullyQualifiedTableName + ' DROP CONSTRAINT [' + @constr + ']' + EXECUTE sp_executesql @sqlcmd +END +IF @constrNew IS NULL +BEGIN + SET @sqlcreate = 'ALTER TABLE ' + @fullyQualifiedTableName + ' WITH NOCHECK ADD CONSTRAINT ' + @fieldName + '_ckc CHECK /*$checkConstraint*/;' + EXECUTE sp_executesql @sqlcreate +END \ No newline at end of file -- cgit v1.2.3-54-g00ecf