|
7675.395.60
by Stuart Bishop
Remove some unused indexes |
1 |
SET client_min_messages=ERROR; |
2 |
||
3 |
/* Nuke some unused indexes */
|
|
4 |
||
5 |
DROP INDEX translationmessage__current_or_imported__idx; |
|
6 |
DROP INDEX hwsubmissiondevice__parent__idx; |
|
7 |
DROP INDEX shippingrequest__recipientdisplayname__idx; |
|
8 |
||
9 |
/* This has gotten bloated */
|
|
10 |
reindex table oauthnonce; |
|
11 |
||
12 |
INSERT INTO LaunchpadDatabaseRevision VALUES (2207, 45, 0); |