Mercurial > gemma
annotate schema/updates/1435/01.add_import_state_idx.sql @ 5217:70d83b7d36ef new-fwa
Track the number days LDCs are not available at bottlenecks.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Mon, 11 May 2020 19:52:25 +0200 |
parents | 38491057807b |
children |
rev | line source |
---|---|
5122
0b6b62d247e8
Prioritize review jobs on selection
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
1 DROP INDEX import.enqueued_idx; |
0b6b62d247e8
Prioritize review jobs on selection
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
2 CREATE INDEX enqueued_idx ON import.imports(enqueued); |
0b6b62d247e8
Prioritize review jobs on selection
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
3 CREATE INDEX state_idx ON import.imports(state); |