summaryrefslogtreecommitdiff
path: root/maintenance/oracle/archives/patch-fa_sha1.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/oracle/archives/patch-fa_sha1.sql')
-rw-r--r--maintenance/oracle/archives/patch-fa_sha1.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/maintenance/oracle/archives/patch-fa_sha1.sql b/maintenance/oracle/archives/patch-fa_sha1.sql
new file mode 100644
index 00000000..70c9e60c
--- /dev/null
+++ b/maintenance/oracle/archives/patch-fa_sha1.sql
@@ -0,0 +1,5 @@
+define mw_prefix='{$wgDBprefix}';
+
+ALTER TABLE &mw_prefix.filearchive ADD fa_sha1 VARCHAR2(32);
+CREATE INDEX &mw_prefix.filearchive_i05 ON &mw_prefix.filearchive (fa_sha1);
+