redeem proffered tickets, db schema 1.1.0

[squeep-indie-auther] / src / db / sqlite / sql / ticket-token-published.sql

diff --git a/src/db/sqlite/sql/ticket-token-published.sql b/src/db/sqlite/sql/ticket-token-published.sql
new file mode 100644 (file)
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