| Index: trunk/phase3/maintenance/archives/patch-uploadstash.sql |
| — | — | @@ -42,3 +42,5 @@ |
| 43 | 43 | CREATE INDEX /*i*/us_user ON /*_*/uploadstash (us_user); |
| 44 | 44 | -- pick out files by key, enforce key uniqueness |
| 45 | 45 | CREATE UNIQUE INDEX /*i*/us_key ON /*_*/uploadstash (us_key); |
| | 46 | +-- the abandoned upload cleanup script needs this |
| | 47 | +CREATE INDEX /*i*/us_timestamp ON /*_*/uploadstash (us_timestamp); |
| \ No newline at end of file |
| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -982,6 +982,8 @@ |
| 983 | 983 | CREATE INDEX /*i*/us_user ON /*_*/uploadstash (us_user); |
| 984 | 984 | -- pick out files by key, enforce key uniqueness |
| 985 | 985 | CREATE UNIQUE INDEX /*i*/us_key ON /*_*/uploadstash (us_key); |
| | 986 | +-- the abandoned upload cleanup script needs this |
| | 987 | +CREATE INDEX /*i*/us_timestamp ON /*_*/uploadstash (us_timestamp); |
| 986 | 988 | |
| 987 | 989 | |
| 988 | 990 | -- |