view schema/updates/1435/01.add_import_state_idx.sql @ 5721:0500d76e074b uploadwg

Fixed eraseObsoleteGaugesSQL by reintroducing matching on users CC. The condition was removed when introducing file upload, but that leads to too many gauges being removed.
author Sascha Wilde <wilde@sha-bang.de>
date Fri, 19 Apr 2024 16:52:14 +0200
parents 38491057807b
children
line wrap: on
line source

DROP INDEX import.enqueued_idx;
CREATE INDEX enqueued_idx ON import.imports(enqueued);
CREATE INDEX state_idx ON import.imports(state);