In this version, we can combine the queries, because we support dropping

nonexistent columns.


git-svn-id: http://svn.digium.com/svn/asterisk/trunk@176501 f38db490-d61c-443f-a65b-d21fe96a405b

1 files changed, 2 insertions, 5 deletions

diff --git a/channels/chan_sip.c b/channels/chan_sip.c
index f9f0c9455..da32f627a 100644
--- a/channels/chan_sip.c
+++ b/channels/chan_sip.c
@@ -4158,18 +4158,15 @@ static void realtime_update_peer(const char *peername, struct sockaddr_in *sin,
 		ast_update_realtime(tablename, "name", peername, "ipaddr", ipaddr,
 			"port", port, "regseconds", regseconds,
 			deprecated_username ? "username" : "defaultuser", defaultuser,
-			"useragent", useragent,
+			"useragent", useragent, "lastms", str_lastms,
 			fc, fullcontact, syslabel, sysname, SENTINEL); /* note fc and syslabel _can_ be NULL */
 	} else {
 		ast_update_realtime(tablename, "name", peername, "ipaddr", ipaddr,
 			"port", port, "regseconds", regseconds,
-			"useragent", useragent,
+			"useragent", useragent, "lastms", str_lastms,
 			deprecated_username ? "username" : "defaultuser", defaultuser,
 			syslabel, sysname, SENTINEL); /* note syslabel _can_ be NULL */
 	}
-	/* We cannot do this in the same statement as above, because the lack of
-	 * this field could cause the whole statement to fail. */
-	ast_update_realtime("sippeers", "name", peername, "lastms", str_lastms, NULL);
 }
 
 /*! \brief Automatically add peer extension to dial plan */