summaryrefslogtreecommitdiff
path: root/www/wiki/maintenance/mssql/archives/patch-pl_from_namespace.sql
blob: b3bbd78dd52c9334c20db3b2c451d1819e6da450 (plain)
1
2
3
4
ALTER TABLE /*_*/pagelinks
	ADD pl_from_namespace int NOT NULL default 0;

CREATE INDEX /*i*/pl_backlinks_namespace ON /*_*/pagelinks (pl_from_namespace,pl_namespace,pl_title,pl_from);