Adjust the default table names to be SQL-standard compliant. Add the other supported...
[freeradius.git] / raddb / mods-config / sql / moonshot-targeted-ids / mysql / queries.conf
1 # -*- text -*-
2 #
3 #  moonshot-targeted-ids/mysql/queries.conf -- Queries to update a MySQL Moonshot-Targeted-Ids table.
4 #
5 #  $Id$
6
7 post-auth {
8         #  Query to store the Moonshot-*-TargetedId
9         query = "\
10                 INSERT IGNORE INTO ${..moonshot_tid_table} \
11                         (gss_acceptor, namespace, username, targeted_id) \
12                 VALUES \
13                         ('%{control:Moonshot-MSTID-GSS-Acceptor}', '%{control:Moonshot-MSTID-Namespace}', \
14                         '%{tolower:%{User-Name}}', '%{control:Moonshot-MSTID-TargetedId}')"
15 }