From 3d780db426093f40d46389fc60ea70be388d2734 Mon Sep 17 00:00:00 2001 From: Ian Baker Date: Wed, 13 Jul 2011 00:38:04 +0000 Subject: [PATCH] Added index for abandoned uploads maintenance script --- maintenance/archives/patch-uploadstash.sql | 2 ++ maintenance/tables.sql | 2 ++ 2 files changed, 4 insertions(+) diff --git a/maintenance/archives/patch-uploadstash.sql b/maintenance/archives/patch-uploadstash.sql index d6610d3255..2d29c3b494 100644 --- a/maintenance/archives/patch-uploadstash.sql +++ b/maintenance/archives/patch-uploadstash.sql @@ -42,3 +42,5 @@ CREATE TABLE /*_*/uploadstash ( CREATE INDEX /*i*/us_user ON /*_*/uploadstash (us_user); -- pick out files by key, enforce key uniqueness CREATE UNIQUE INDEX /*i*/us_key ON /*_*/uploadstash (us_key); +-- the abandoned upload cleanup script needs this +CREATE INDEX /*i*/us_timestamp ON /*_*/uploadstash (us_timestamp); \ No newline at end of file diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 47ce5e164a..48e0d7bb91 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -982,6 +982,8 @@ CREATE TABLE /*_*/uploadstash ( CREATE INDEX /*i*/us_user ON /*_*/uploadstash (us_user); -- pick out files by key, enforce key uniqueness CREATE UNIQUE INDEX /*i*/us_key ON /*_*/uploadstash (us_key); +-- the abandoned upload cleanup script needs this +CREATE INDEX /*i*/us_timestamp ON /*_*/uploadstash (us_timestamp); -- -- 2.20.1