4 ## Queries to update the CUI table.
6 postauth_query = "INSERT IGNORE INTO ${cui_table} \
7 (clientipaddress, callingstationid, username, cui, lastaccounting) \
9 ('%{%{Packet-Src-IPv6-Address}:-%{Packet-Src-IP-Address}}', '%{Calling-Station-Id}', '%{User-Name}', '%{reply:Chargeable-User-Identity}', NULL) ON DUPLICATE KEY UPDATE lastaccounting='0000-00-00 00:00:00', cui='%{reply:Chargeable-User-Identity}'";
11 accounting_start_query = "UPDATE ${cui_table} \
13 lastaccounting = CURRENT_TIMESTAMP \
14 WHERE clientipaddress = '%{%{Packet-Src-IPv6-Address}:-%{Packet-Src-IP-Address}}' \
15 AND callingstationid = '%{Calling-Station-Id}' \
16 AND username = '%{User-Name}' \
17 AND cui = '%{Chargeable-User-Identity}'";
19 accounting_update_query = "UPDATE ${cui_table} \
21 lastaccounting = CURRENT_TIMESTAMP \
22 WHERE clientipaddress = '%{%{Packet-Src-IPv6-Address}:-%{Packet-Src-IP-Address}}' \
23 AND callingstationid = '%{Calling-Station-Id}' \
24 AND username = '%{User-Name}' \
25 AND cui = '%{Chargeable-User-Identity}'";
27 accounting_stop_query = "DELETE FROM ${cui_table} WHERE \
28 clientipaddress = '%{%{Packet-Src-IPv6-Address}:-%{Packet-Src-IP-Address}}' \
29 AND callingstationid = '%{Calling-Station-Id}' \
30 AND username = '%{User-Name}' \
31 AND cui = '%{Chargeable-User-Identity}'";