resources/sql/autopatches/20140711.workerpriority.sql at recaptime-dev/main

@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

fork atom

phorge / resources / sql / autopatches / 20140711.workerpriority.sql

at recaptime-dev/main 11 lines 371 B view raw

wrap content

Joshua Spence Allow worker tasks to have priorities 11y ago

9a679bf3

 1ALTER TABLE {$NAMESPACE}_worker.worker_activetask
 2  ADD COLUMN priority int unsigned NOT NULL;
 3
 4ALTER TABLE {$NAMESPACE}_worker.worker_activetask
 5  ADD KEY (leaseOwner, priority, id);
 6
 7ALTER TABLE {$NAMESPACE}_worker.worker_archivetask
 8  ADD COLUMN priority int unsigned NOT NULL;
 9
10ALTER TABLE {$NAMESPACE}_worker.worker_archivetask
11  ADD KEY (leaseOwner, priority, id);