upgrade-00.sql

create type queue_status as enum('new', 'inprogress', 'done');
create table delivery_queue (
    delivery_id int not null primary key references dl (id) on delete cascade,
    date_entered timestamp not null default current_timestamp,
    status queue_status not null default 'new'
);

If the queue uses delivery_id, then aren't we expecting that there will be a delivery note for website uploads?

If the queue uses delivery_id, then aren't we expecting that there will be a delivery note for website uploads?

There is a dl record for every web download. Is that what you mean?

I'd add a "failed" to the queue_status.

Good shout. For the record, I was not sure about done but I envisage the row being deleted once the ExportMedia::S3 had done it's thing.

There is a dl record for every web download. Is that what you mean?

If there is, then why did I do all that work to rewrite the S3 code to not rely on a delivery note?