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
_______________________________________________
Devel mailing list
Devel@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
