X-Git-Url: http://git.squeep.com/?p=squeep-indie-auther;a=blobdiff_plain;f=src%2Fdb%2Fsqlite%2Fsql%2Fticket-token-published.sql;fp=src%2Fdb%2Fsqlite%2Fsql%2Fticket-token-published.sql;h=077c24f5d26c9ae6581401162a79d9c8b6f3f9a7;hp=0000000000000000000000000000000000000000;hb=726cd980f0ed5588cfe8cbb2d994d5e4aef6e292;hpb=3c145bc590577c738df4d279744f3e2f9a250294

diff --git a/src/db/sqlite/sql/ticket-token-published.sql b/src/db/sqlite/sql/ticket-token-published.sql
new file mode 100644
index 0000000..077c24f
--- /dev/null
+++ b/src/db/sqlite/sql/ticket-token-published.sql
@@ -0,0 +1,11 @@
+--
+UPDATE redeemed_ticket SET
+	published = (strftime('%s', 'now'))
+WHERE
+	subject = :subject
+AND
+	resource = :resource
+AND
+	iss = :iss
+AND
+	ticket = :ticket