MediaWiki 1.11.0

[autoinstallsdev/mediawiki.git] / maintenance / archives / patch-img_sha1.sql

diff --git a/maintenance/archives/patch-img_sha1.sql b/maintenance/archives/patch-img_sha1.sql
new file mode 100644 (file)
index 0000000..35950f5
--- /dev/null
+++ b/maintenance/archives/patch-img_sha1.sql
@@ -0,0 +1,8 @@
+-- Add img_sha1, oi_sha1 and related indexes
+ALTER TABLE /*$wgDBprefix*/image
+  ADD COLUMN img_sha1 varbinary(32) NOT NULL default '',
+  ADD INDEX img_sha1 (img_sha1);
+
+ALTER TABLE /*$wgDBprefix*/oldimage
+  ADD COLUMN oi_sha1 varbinary(32) NOT NULL default '',
+  ADD INDEX oi_sha1 (oi_sha1);