@recaptime-dev's working patches + fork for Phorge, a community fork of Phabricator. (Upstream dev and stable branches are at upstream/main and upstream/stable respectively.)
hq.recaptime.dev/wiki/Phorge
phorge
phabricator
1create table {$NAMESPACE}_worker.worker_task (
2 id int unsigned not null auto_increment primary key,
3 taskClass varchar(255) not null,
4 leaseOwner varchar(255),
5 leaseExpires int unsigned,
6 priority bigint unsigned not null,
7 failureCount int unsigned not null,
8 key(taskClass(128)),
9 key(leaseOwner(128)),
10 key(leaseExpires)
11);
12
13create table {$NAMESPACE}_worker.worker_taskdata (
14 id int unsigned not null auto_increment primary key,
15 taskID int unsigned not null,
16 data longblob not null,
17 unique key (taskID)
18);