From: Marcus Eggenberger <egs@quassel-irc.org>
Date: Sun, 30 Nov 2008 13:53:16 +0000 (+0100)
Subject: Uncrapificating some queries... I must have been above ballmer peak when I wrote... 
X-Git-Tag: 0.4.0~384
X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=commitdiff_plain;h=a2e7df3cffc6fa931288fcebb4145042c81b7c5d

Uncrapificating some queries... I must have been above ballmer peak when I wrote them... o_O
---

diff --git a/src/core/SQL/SQLite/11/select_messages.sql b/src/core/SQL/SQLite/11/select_messages.sql
index dcadad95..641179f2 100644
--- a/src/core/SQL/SQLite/11/select_messages.sql
+++ b/src/core/SQL/SQLite/11/select_messages.sql
@@ -1,8 +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
+WHERE bufferid = :bufferid
     AND backlog.messageid >= :firstmsg
     AND backlog.messageid < :lastmsg
 ORDER BY messageid DESC
diff --git a/src/core/SQL/SQLite/11/select_messagesNew.sql b/src/core/SQL/SQLite/11/select_messagesNew.sql
index e549252a..69d948d6 100644
--- a/src/core/SQL/SQLite/11/select_messagesNew.sql
+++ b/src/core/SQL/SQLite/11/select_messagesNew.sql
@@ -1,8 +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
+WHERE bufferid = :bufferid
     AND backlog.messageid >= :firstmsg
 ORDER BY messageid DESC
 LIMIT :limit