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