summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-img_sha1.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/archives/patch-img_sha1.sql')
-rw-r--r--maintenance/archives/patch-img_sha1.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/maintenance/archives/patch-img_sha1.sql b/maintenance/archives/patch-img_sha1.sql
new file mode 100644
index 00000000..35950f58
--- /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);