[OpenSIPS-Devel] [opensips] Add "strict_sql_tables = true" option (#671)

[Liviu Chircu]

The global `db_version_table` parameter has one big pitfall: all OpenSIPS tables **must** be created with `opensipsdbctl`. Although this is a solid/recommended way of installing OpenSIPS, real life sometimes imposes some restrictions. For example, some tables (dispatcher, drouting, etc.) may actually be SQL views of other platform-related tables.

When views / hand-made tables come in place, OpenSIPS is left *without any* real mechanism of validating its input table structure, leading to all sort of buggy behaviour, i.e. incorrectly balancing between dispatcher destinations (that show up in `fifo ds_list`) because the *state* field is `varchar(1)` instead of `int(11)`.

This feature request discussion aims at adding a new way of checking SQL tables, by validating the type of each column. It also has the side-effect of rendering the entire `db_version_table` mechanism useless. Please reply with feedback / ideas / further suggestions.

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