[sr-dev] git:master:1a76fb05: srdb1/schema: new columns to table location

Module: kamailio Branch: master Commit: 1a76fb05126d8154e59fc1524727d7f84d8cff2c URL: https://github.com/kamailio/kamailio/commit/1a76fb05126d8154e59fc1524727d7f… Author: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Committer: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Date: 2015-03-27T15:43:37+01:00 srdb1/schema: new columns to table location - server_id - store the value for server id - connection_id - store the value for connection id of location record, to be used for db only mode tcp optimizations (not restored after restart) - keepalive - set if the nat branch flag is set for the contact, to speedup selection of records for nat keep alive in db only mode --- Modified: lib/srdb1/schema/location.xml --- Diff: https://github.com/kamailio/kamailio/commit/1a76fb05126d8154e59fc1524727d7f… Patch: https://github.com/kamailio/kamailio/commit/1a76fb05126d8154e59fc1524727d7f… --- diff --git a/lib/srdb1/schema/location.xml b/lib/srdb1/schema/location.xml index be92306..a39cd52 100644 --- a/lib/srdb1/schema/location.xml +++ b/lib/srdb1/schema/location.xml @@ -9,7 +9,7 @@ <table id="location" xmlns:db="http://docbook.org/ns/docbook"> <name>location</name> - <version>6</version> + <version>7</version> <type db="mysql">&MYSQL_TABLE_TYPE;</type> <description> <db:para>Persistent user location information for the usrloc module. More information can be found at: &KAMAILIO_MOD_DOC;usrloc.html @@ -179,6 +179,30 @@ <description>The value of reg-id contact parameter</description> </column> + <column> + <name>server_id</name> + <type>int</type> + <size>11</size> + <default>0</default> + <description>The value of server_id from configuration file</description> + </column> + + <column> + <name>connection_id</name> + <type>int</type> + <size>11</size> + <default>0</default> + <description>The value of connection id for location record</description> + </column> + + <column> + <name>keepalive</name> + <type>int</type> + <size>11</size> + <default>0</default> + <description>The value to control sending keep alive requests</description> + </column> + <index> <name>account_contact_idx</name>