From 3361bcc5945293951a62ebd2fb2a21f3b90bd115 Mon Sep 17 00:00:00 2001 From: Marcus Eggenberger Date: Mon, 18 Feb 2008 11:37:18 +0000 Subject: [PATCH] added missing queries --- src/core/SQL/SQLite/7/select_buffer_lastseen_dates.sql | 3 +++ src/core/SQL/SQLite/7/update_buffer_lastseen.sql | 3 +++ 2 files changed, 6 insertions(+) create mode 100644 src/core/SQL/SQLite/7/select_buffer_lastseen_dates.sql create mode 100644 src/core/SQL/SQLite/7/update_buffer_lastseen.sql 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 -- 2.20.1