From: Marcus Eggenberger <egs@quassel-irc.org>
Date: Mon, 18 Feb 2008 11:37:18 +0000 (+0000)
Subject: added missing queries
X-Git-Tag: 0.2.0-alpha1~51
X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=commitdiff_plain;h=3361bcc5945293951a62ebd2fb2a21f3b90bd115

added missing queries
---

diff --git a/src/core/SQL/SQLite/7/select_buffer_lastseen_dates.sql b/src/core/SQL/SQLite/7/select_buffer_lastseen_dates.sql
new file mode 100644
index 00000000..4e307a41
--- /dev/null
+++ b/src/core/SQL/SQLite/7/select_buffer_lastseen_dates.sql
@@ -0,0 +1,3 @@
+SELECT bufferid, lastseen
+FROM buffer
+WHERE userid = :userid
diff --git a/src/core/SQL/SQLite/7/update_buffer_lastseen.sql b/src/core/SQL/SQLite/7/update_buffer_lastseen.sql
new file mode 100644
index 00000000..72b99b20
--- /dev/null
+++ b/src/core/SQL/SQLite/7/update_buffer_lastseen.sql
@@ -0,0 +1,3 @@
+UPDATE buffer
+SET lastseen = :lastseen
+WHERE userid = :userid AND bufferid = :bufferid