[sr-dev] [kamailio/kamailio] sca: add server_id column to sca_subscriptions table (#814)

[Victor Seva]

In order to have more than one server with the same DB ``sca`` module has to have a ``server_id`` column to partition subscriptions

version bumped to ``2``

See #782

You can view, comment on, or merge this pull request online at:

  https://github.com/kamailio/kamailio/pull/814

-- Commit Summary --

  * lib/srdb1: sca add server_id
  * utils/kamctl: refresh dbschema
  * sca: use new server_id column

-- File Changes --

    M lib/srdb1/schema/sca.xml (11)
    M modules/sca/sca_db.c (4)
    M modules/sca/sca_db.h (6)
    M modules/sca/sca_subscribe.c (39)
    M modules/sca/sca_subscribe.h (1)
    M utils/kamctl/db_berkeley/kamailio/sca_subscriptions (4)
    M utils/kamctl/db_berkeley/kamailio/version (2)
    M utils/kamctl/db_sqlite/sca-create.sql (5)
    M utils/kamctl/dbtext/kamailio/sca_subscriptions (2)
    M utils/kamctl/dbtext/kamailio/version (2)
    M utils/kamctl/mysql/sca-create.sql (5)
    M utils/kamctl/oracle/sca-create.sql (5)
    M utils/kamctl/postgres/sca-create.sql (5)
    M utils/kamctl/xhttp_pi/pi_framework.xml (4)
    M utils/kamctl/xhttp_pi/sca-mod (3)
    M utils/kamctl/xhttp_pi/sca-table (1)

-- Patch Links --

https://github.com/kamailio/kamailio/pull/814.patch
https://github.com/kamailio/kamailio/pull/814.diff

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/pull/814
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20161005/c1dd448b/attachment.html>