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

Module: kamailio Branch: master Commit: fd208710a6912cc5cd0d6320b9be05b707a8178b URL: https://github.com/kamailio/kamailio/commit/fd208710a6912cc5cd0d6320b9be05b… Author: Victor Seva &lt;linuxmaniac(a)torreviejawireless.org&gt; Committer: Victor Seva &lt;linuxmaniac(a)torreviejawireless.org&gt; 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/fd208710a6912cc5cd0d6320b9be05b… Patch: https://github.com/kamailio/kamailio/commit/fd208710a6912cc5cd0d6320b9be05b… --- 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>