1BEGIN;
2
3CREATE UNIQUE INDEX jobs_queued ON admin (
4  action,
5  coalesce(subaction, '_x_'),
6  coalesce(device, '255.255.255.255'),
7  coalesce(port, '_x_')
8) WHERE status LIKE 'queued%';
9
10COMMIT;
11