# -*- text -*-
#
#  moonshot-targeted-ids/postgresql/queries.conf -- Queries to update a PostgreSQL Moonshot-*-Targeted-Ids table.
#
#  $Id: f757a870a0b68c5dc3827c00bb501082fc7e03e9 $

post-auth {
	#  Query to store the Moonshot-*-TargetedId
	query = "\
		INSERT INTO ${..moonshot_tid_table} \
			(gss_acceptor, namespace, username, targeted_id) \
		VALUES \
			('%{control:Moonshot-MSTID-GSS-Acceptor}', '%{control:Moonshot-MSTID-Namespace}', \
			'%{tolower:%{User-Name}}', '%{control:Moonshot-MSTID-TargetedId}')"
}