From 4c7eaa485848ba3c1630db3f00289f2ac6edd370 Mon Sep 17 00:00:00 2001 From: Marcus Eggenberger Date: Tue, 30 Dec 2008 23:26:13 +0100 Subject: [PATCH] /* no comment */ --- src/core/SQL/SQLite/13/select_messagesNewerThan.sql | 7 +++++++ src/core/SQL/SQLite/13/select_messagesNewestK.sql | 6 ++++++ 2 files changed, 13 insertions(+) create mode 100644 src/core/SQL/SQLite/13/select_messagesNewerThan.sql create mode 100644 src/core/SQL/SQLite/13/select_messagesNewestK.sql diff --git a/src/core/SQL/SQLite/13/select_messagesNewerThan.sql b/src/core/SQL/SQLite/13/select_messagesNewerThan.sql new file mode 100644 index 00000000..69d948d6 --- /dev/null +++ b/src/core/SQL/SQLite/13/select_messagesNewerThan.sql @@ -0,0 +1,7 @@ +SELECT messageid, time, type, flags, sender, message +FROM backlog +JOIN sender ON backlog.senderid = sender.senderid +WHERE bufferid = :bufferid + AND backlog.messageid >= :firstmsg +ORDER BY messageid DESC +LIMIT :limit diff --git a/src/core/SQL/SQLite/13/select_messagesNewestK.sql b/src/core/SQL/SQLite/13/select_messagesNewestK.sql new file mode 100644 index 00000000..6cc81cc5 --- /dev/null +++ b/src/core/SQL/SQLite/13/select_messagesNewestK.sql @@ -0,0 +1,6 @@ +SELECT messageid, time, type, flags, sender, message +FROM backlog +JOIN sender ON backlog.senderid = sender.senderid +WHERE bufferid = :bufferid +ORDER BY messageid DESC +LIMIT :limit -- 2.20.1