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

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