summaryrefslogtreecommitdiff
path: root/model/mysql/queries.go
diff options
context:
space:
mode:
authorKevin Chabowski <kevin@kch42.de>2013-08-28 21:48:47 +0200
committerKevin Chabowski <kevin@kch42.de>2013-08-28 21:48:47 +0200
commit8ecfe7a2fc61caf890e319e7a2f298b71dc90826 (patch)
treeebec6cedcafd2c6bae07ff2edeaff4e5d5377466 /model/mysql/queries.go
parent3e52620c29e6893ce1cf5e45ec4e00a37184edd6 (diff)
downloadmailremind-8ecfe7a2fc61caf890e319e7a2f298b71dc90826.tar.gz
mailremind-8ecfe7a2fc61caf890e319e7a2f298b71dc90826.tar.bz2
mailremind-8ecfe7a2fc61caf890e319e7a2f298b71dc90826.zip
Some improvements to the model
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` = ?",