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
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
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);