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
463 B
SQL
10 lines
463 B
SQL
-- Add up migration script here
|
|
ALTER TABLE queue DROP COLUMN priority;
|
|
DROP INDEX IF EXISTS queue_sort;
|
|
CREATE INDEX IF NOT EXISTS queue_sort ON queue (scheduled_for, created_at, tag) WHERE running = false;
|
|
DROP INDEX IF EXISTS queue_suspended;
|
|
CREATE INDEX IF NOT EXISTS queue_suspended ON queue (created_at, suspend_until, suspend, tag) WHERE suspend_until is not null;
|
|
|
|
ALTER TABLE completed_job DROP COLUMN priority;
|
|
ALTER TABLE script DROP COLUMN priority;
|