summaryrefslogtreecommitdiff
path: root/model/mysql/queries.go
diff options
context:
space:
mode:
Diffstat (limited to 'model/mysql/queries.go')
-rw-r--r--model/mysql/queries.go2
1 files changed, 1 insertions, 1 deletions
diff --git a/model/mysql/queries.go b/model/mysql/queries.go
index da2a554..7d7b860 100644
--- a/model/mysql/queries.go
+++ b/model/mysql/queries.go
@@ -44,7 +44,7 @@ var queries = map[int]string{
qSetContent: "UPDATE `jobs` SET `content` = ? WHERE `id` = ?",
qSetNext: "UPDATE `jobs` SET `next` = ? WHERE `id` = ?",
qDelJob: "DELETE FROM `jobs` WHERE `id` = ?",
- qJobsBefore: "SELECT `id` FROM `jobs` WHERE `next` <= ?",
+ qJobsBefore: qfragSelJob + "WHERE `next` <= ?",
qInsertJob: "INSERT INTO `jobs` (`user`, `subject`, `content`, `next`, `chronos`) VALUES (?, ?, ?, ?, ?)",
qInsertUser: "INSERT INTO `users` (`email`, `passwd`, `location`, `active`, `activationcode`, `added`) VALUES (?, ?, ?, ?, ?, ?)",
qSetChronos: "UPDATE `jobs` SET `chronos` = ? WHERE `id` = ?",