From 8ecfe7a2fc61caf890e319e7a2f298b71dc90826 Mon Sep 17 00:00:00 2001 From: Kevin Chabowski Date: Wed, 28 Aug 2013 21:48:47 +0200 Subject: Some improvements to the model --- model/mysql/queries.go | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'model/mysql/queries.go') 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` = ?", -- cgit v1.2.3-70-g09d2