Hello,
like Alex said, you can have two version tables, one for each versions of kamailio you play with and use in config the core parameter to set the name of that table.
I am actually writing to say that address table never had accountcode and notes columns. Likely they were added in your deployment for other purposes or either the default column names were changed. The default column names are listed at:
- https://kamailio.org/docs/db-tables/kamailio-db-5.2.x.html#gen-db-address
These were the same for rather long time, iirc the recent version number changed mainly due to with modifications done to the size, not due to new columns.
Cheers, Daniel
On 18.06.19 20:50, JR Richardson wrote:
Hey All,
I'm doing some upgrades and noticed database table version numbers have increased.
database table adjustments: | address | production ver 3 | upgrade 5.2 ver 6 | need to add accountcode and notes column | dispatcher | production ver 3 | upgrade 5.2 ver 4 | need to add attr column | trusted | production ver 5 | upgrade 5.2 ver 6 | need to add ruri_pattern and priority column
I run mysql master/slave so I'm concerned about the master database not having the correct version numbers or can I just update the version number in the table when I do the upgrade of the kamailio versions?
Thanks.
JR