Fix deleting pages/files when using Microsoft SQL Server
authorRyan Schmidt <skizzerz@skizzerz.net>
Thu, 5 May 2016 05:27:28 +0000 (22:27 -0700)
committerLegoktm <legoktm.wikipedia@gmail.com>
Fri, 6 May 2016 06:28:45 +0000 (06:28 +0000)
commit4ea08502b1b33e334752eadf02fda5d687ec219a
treecc9644a8be4c0de94a8ff4f5039168a2c6d42e8c
parent6a8de1f1aa0bcdbf9385a4f9a01a4ef3bb70be57
Fix deleting pages/files when using Microsoft SQL Server

Right now we have a slew of foreign key violations whenever we try to
delete something due to the way MediaWiki handles page
deletions. Let's remove those foreign keys from places where IDs are
maintained even though the records they are pointing to have been deleted.

Also, work has begun on the massive (re)naming of every constraint in the
schema, so that icky hacks like those employed in these patch files don't
need to be used in the future; rather, we can simply refer to the
constraints by name.

Change-Id: I79938d36a8e35debd3e27052d8ef0e3e6c32f40c
includes/installer/MssqlUpdater.php
maintenance/mssql/archives/patch-archive-drop-fks.sql [new file with mode: 0644]
maintenance/mssql/archives/patch-logging-drop-fks.sql [new file with mode: 0644]
maintenance/mssql/archives/patch-recentchanges-drop-fks.sql [new file with mode: 0644]
maintenance/mssql/tables.sql