[OpenSIPS-Devel] [opensips] Fix some PgSQL schema issues (#218)

[Nick Altmann]

Bogdan, look please at this solution. If it's correct, I'll patch all supported previous versions.
You can merge this Pull Request by running:

  git pull https://github.com/nikbyte/opensips master

Or you can view, comment on it, or merge it online at:

  https://github.com/OpenSIPS/opensips/pull/218

-- Commit Summary --

  * PostgreSQL DB schema: remove bytea size because pgsql has no fixed size for this type of field
  * PostgreSQL DB schema: set for all serials maxvalue and cycle because sometimes serials may overflow

-- File Changes --

    M doc/dbschema/xsl/postgres.xsl (28)
    M scripts/postgres/acc-create.sql (2)
    M scripts/postgres/alias_db-create.sql (1)
    M scripts/postgres/auth_db-create.sql (1)
    M scripts/postgres/avpops-create.sql (1)
    M scripts/postgres/b2b-create.sql (2)
    M scripts/postgres/b2b_sca-create.sql (1)
    M scripts/postgres/call_center-create.sql (3)
    M scripts/postgres/carrierroute-create.sql (3)
    M scripts/postgres/closeddial-create.sql (1)
    M scripts/postgres/cpl-create.sql (1)
    M scripts/postgres/dialog-create.sql (2)
    M scripts/postgres/dialplan-create.sql (1)
    M scripts/postgres/dispatcher-create.sql (1)
    M scripts/postgres/domain-create.sql (1)
    M scripts/postgres/domainpolicy-create.sql (1)
    M scripts/postgres/drouting-create.sql (4)
    M scripts/postgres/group-create.sql (2)
    M scripts/postgres/imc-create.sql (2)
    M scripts/postgres/load_balancer-create.sql (1)
    M scripts/postgres/msilo-create.sql (1)
    M scripts/postgres/pdt-create.sql (1)
    M scripts/postgres/permissions-create.sql (1)
    M scripts/postgres/presence-create.sql (5)
    M scripts/postgres/registrant-create.sql (1)
    M scripts/postgres/registrar-create.sql (1)
    M scripts/postgres/rls-create.sql (2)
    M scripts/postgres/rtpproxy-create.sql (1)
    M scripts/postgres/siptrace-create.sql (1)
    M scripts/postgres/speeddial-create.sql (1)
    M scripts/postgres/uri_db-create.sql (1)
    M scripts/postgres/userblacklist-create.sql (2)
    M scripts/postgres/usrloc-create.sql (1)

-- Patch Links --

https://github.com/OpenSIPS/opensips/pull/218.patch
https://github.com/OpenSIPS/opensips/pull/218.diff

---
Reply to this email directly or view it on GitHub:
https://github.com/OpenSIPS/opensips/pull/218
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/devel/attachments/20140502/a634bdfc/attachment.htm>