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

[Daniel-Constantin Mierla]

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

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

---

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>