db: Fix wrong state in view

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

diff --git a/src/database.sql b/src/database.sql
index 5161fbc528503863803c5b366680f39829868efe..f0fadee1d3071823a9eb58372226808ec399e66f 100644 (file)
--- a/src/database.sql
+++ b/src/database.sql
@@ -877,7 +877,7 @@ CREATE VIEW jobs_queue AS
             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 = 'new'::text) AND (jobs.dependency_check_succeeded IS TRUE))
+          WHERE ((jobs.state = 'pending'::text) AND (jobs.dependency_check_succeeded IS TRUE))
         )
  SELECT queue.id AS job_id,
     queue.rank