From f93059e07d744741376a211d6fb0ec706e5297b0 Mon Sep 17 00:00:00 2001 From: Michael Tremer Date: Sat, 21 Oct 2017 16:01:54 +0100 Subject: [PATCH] jobs: Drop type column Signed-off-by: Michael Tremer --- src/database.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/src/database.sql b/src/database.sql index 61d3b7a..53b57c5 100644 --- a/src/database.sql +++ b/src/database.sql @@ -853,7 +853,6 @@ ALTER SEQUENCE builds_id_seq OWNED BY builds.id; CREATE TABLE jobs ( id integer NOT NULL, uuid text NOT NULL, - type jobs_type DEFAULT 'build'::jobs_type NOT NULL, build_id integer NOT NULL, state jobs_state DEFAULT 'new'::jobs_state NOT NULL, arch text NOT NULL, @@ -1164,7 +1163,7 @@ ALTER SEQUENCE jobs_packages_id_seq OWNED BY jobs_packages.id; CREATE VIEW jobs_queue AS WITH queue AS ( SELECT jobs.id, - rank() OVER (ORDER BY jobs.type, builds.priority DESC, jobs.time_created) AS rank + rank() OVER (ORDER BY (NOT jobs.test), builds.priority DESC, jobs.time_created) AS rank FROM (jobs LEFT JOIN builds ON ((jobs.build_id = builds.id))) WHERE (jobs.state = 'pending'::jobs_state) -- 2.47.3