redeem proffered tickets, db schema 1.1.0

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

diff --git a/src/db/postgres/sql/ticket-token-published.sql b/src/db/postgres/sql/ticket-token-published.sql
new file mode 100644 (file)
index 0000000..9c2e542
--- /dev/null
+++ b/src/db/postgres/sql/ticket-token-published.sql
@@ -0,0 +1,11 @@
+--
+UPDATE redeemed_ticket SET
+       published = now()
+WHERE
+       subject = $(subject)
+AND
+       resource = $(resource)
+AND
+       iss = $(iss)
+AND
+       ticket = $(ticket)