[sr-dev] git:master:fd208710: lib/srdb1: sca add server_id

[Victor Seva]

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

Author: Victor Seva <linuxmaniac at torreviejawireless.org>
Committer: Victor Seva <linuxmaniac at torreviejawireless.org>
Date: 2016-10-05T15:27:08+02:00

lib/srdb1: sca add server_id

* bump sca_susbcriptions version to 2

See #782

---

Modified: lib/srdb1/schema/sca.xml

---

Diff:  https://github.com/kamailio/kamailio/commit/fd208710a6912cc5cd0d6320b9be05b707a8178b.diff
Patch: https://github.com/kamailio/kamailio/commit/fd208710a6912cc5cd0d6320b9be05b707a8178b.patch

---

diff --git a/lib/srdb1/schema/sca.xml b/lib/srdb1/schema/sca.xml
index 337b315..52a2380 100644
--- a/lib/srdb1/schema/sca.xml
+++ b/lib/srdb1/schema/sca.xml
@@ -9,7 +9,7 @@
 
 <table id="sca_susbcriptions" xmlns:db="http://docbook.org/ns/docbook">
     <name>sca_subscriptions</name>
-    <version>1</version>
+    <version>2</version>
     <type db="mysql">&MYSQL_TABLE_TYPE;</type>
     <description>
         <db:para>This table is used by the sca module to store active subscriptions. At startup time, the sca module loads unexpired subscriptions into its subscription hash table. More information about the sca module can be found at: &KAMAILIO_MOD_DOC;sca.html
@@ -111,6 +111,14 @@
         <description>Cseq for SUBSCRIBEs sent from subscriber</description>
     </column>
 
+    <column id="server_id">
+        <name>server_id</name>
+        <type>int</type>
+        <size>11</size>
+        <default>0</default>
+        <description>The value of server_id from configuration file</description>
+    </column>
+
     <index>
 	<name>sca_subscriptions_idx</name>
 	<colref linkend="subscriber" />
@@ -122,6 +130,7 @@
 
     <index>
 	<name>sca_expires_idx</name>
+	<colref linkend="server_id" />
 	<colref linkend="expires" />
     </index>