bd69bafe59
* BE v1 for priority queue * Add FE prototype * sqlx prepare * Disply priority badge in job detail view * sqlx prepare post merge * Add priority number input field next to toggle * increase dnd timeout for app events * Update db migration * Fix FE import * Add badge to script/flow details page and fix EE-only mention in tooltip --------- Co-authored-by: Ruben Fiszel <ruben@rubenfiszel.com> Co-authored-by: Ruben Fiszel <ruben@windmill.dev>
10 lines
539 B
SQL
10 lines
539 B
SQL
-- Add up migration script here
|
|
ALTER TABLE queue ADD COLUMN priority SMALLINT;
|
|
DROP INDEX IF EXISTS queue_sort;
|
|
CREATE INDEX IF NOT EXISTS queue_sort ON queue (priority DESC NULLS LAST, scheduled_for, created_at, tag) WHERE running = false;
|
|
DROP INDEX IF EXISTS queue_suspended;
|
|
CREATE INDEX IF NOT EXISTS queue_suspended ON queue (priority DESC NULLS LAST, created_at, suspend_until, suspend, tag) WHERE suspend_until is not null;
|
|
|
|
ALTER TABLE completed_job ADD COLUMN priority SMALLINT;
|
|
ALTER TABLE script ADD COLUMN priority SMALLINT;
|