Module: kamailio Branch: master Commit: 1a76fb05126d8154e59fc1524727d7f84d8cff2c URL: https://github.com/kamailio/kamailio/commit/1a76fb05126d8154e59fc1524727d7f8...

Author: Daniel-Constantin Mierla miconda@gmail.com Committer: Daniel-Constantin Mierla miconda@gmail.com 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/1a76fb05126d8154e59fc1524727d7f8... Patch: https://github.com/kamailio/kamailio/commit/1a76fb05126d8154e59fc1524727d7f8...

---

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:paraPersistent 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>