X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;f=src%2Fcore%2FSQL%2FSQLite%2F7%2Fselect_messages.sql;fp=src%2Fcore%2FSQL%2FSQLite%2F7%2Fselect_messages.sql;h=698debaac088b2b6dacdd6e57033d490b6279c05;hb=76929fefa96b80fe4f3be89c334c820b13ad7e3b;hp=0000000000000000000000000000000000000000;hpb=3a99cf632f7918b85087373272904f6ed17cca25;p=quassel.git diff --git a/src/core/SQL/SQLite/7/select_messages.sql b/src/core/SQL/SQLite/7/select_messages.sql new file mode 100644 index 00000000..698debaa --- /dev/null +++ b/src/core/SQL/SQLite/7/select_messages.sql @@ -0,0 +1,7 @@ +SELECT messageid, time, type, flags, sender, message +FROM backlog +JOIN buffer ON backlog.bufferid = buffer.bufferid +JOIN sender ON backlog.senderid = sender.senderid +WHERE buffer.bufferid = :bufferid +ORDER BY messageid DESC +LIMIT :limit OFFSET :offset