Re: [SR-Users] Question on Database Version Table

/usr/share/kamailio/mysql/acc-create.sql:INSERT INTO version (table_name, table_version) values ('acc','5'); /usr/share/kamailio/mysql/acc-create.sql:INSERT INTO version (table_name, table_version) values ('acc_cdrs','2'); /usr/share/kamailio/mysql/acc-create.sql:INSERT INTO version (table_name, table_version) values ('missed_calls','4'); /usr/share/kamailio/mysql/alias_db-create.sql:INSERT INTO version (table_name, table_version) values ('dbaliases','1'); /usr/share/kamailio/mysql/auth_db-create.sql:INSERT INTO version (table_name, table_version) values ('subscriber','7'); /usr/share/kamailio/mysql/avpops-create.sql:INSERT INTO version (table_name, table_version) values ('usr_preferences','2'); /usr/share/kamailio/mysql/carrierroute-create.sql:INSERT INTO version (table_name, table_version) values ('carrierroute','3'); /usr/share/kamailio/mysql/carrierroute-create.sql:INSERT INTO version (table_name, table_version) values ('carrierfailureroute','2'); /usr/share/kamailio/mysql/carrierroute-create.sql:INSERT INTO version (table_name, table_version) values ('carrier_name','1'); /usr/share/kamailio/mysql/carrierroute-create.sql:INSERT INTO version (table_name, table_version) values ('domain_name','1'); /usr/share/kamailio/mysql/cpl-create.sql:INSERT INTO version (table_name, table_version) values ('cpl','1'); /usr/share/kamailio/mysql/dialog-create.sql:INSERT INTO version (table_name, table_version) values ('dialog','7'); /usr/share/kamailio/mysql/dialog-create.sql:INSERT INTO version (table_name, table_version) values ('dialog_vars','1'); /usr/share/kamailio/mysql/dialplan-create.sql:INSERT INTO version (table_name, table_version) values ('dialplan','2'); /usr/share/kamailio/mysql/dispatcher-create.sql:INSERT INTO version (table_name, table_version) values ('dispatcher','4'); /usr/share/kamailio/mysql/domain-create.sql:INSERT INTO version (table_name, table_version) values ('domain','2'); /usr/share/kamailio/mysql/domain-create.sql:INSERT INTO version (table_name, table_version) values ('domain_attrs','1'); /usr/share/kamailio/mysql/domainpolicy-create.sql:INSERT INTO version (table_name, table_version) values ('domainpolicy','2'); /usr/share/kamailio/mysql/drouting-create.sql:INSERT INTO version (table_name, table_version) values ('dr_gateways','3'); /usr/share/kamailio/mysql/drouting-create.sql:INSERT INTO version (table_name, table_version) values ('dr_rules','3'); /usr/share/kamailio/mysql/drouting-create.sql:INSERT INTO version (table_name, table_version) values ('dr_gw_lists','1'); /usr/share/kamailio/mysql/drouting-create.sql:INSERT INTO version (table_name, table_version) values ('dr_groups','2'); /usr/share/kamailio/mysql/group-create.sql:INSERT INTO version (table_name, table_version) values ('grp','2'); /usr/share/kamailio/mysql/group-create.sql:INSERT INTO version (table_name, table_version) values ('re_grp','1'); /usr/share/kamailio/mysql/htable-create.sql:INSERT INTO version (table_name, table_version) values ('htable','2'); /usr/share/kamailio/mysql/imc-create.sql:INSERT INTO version (table_name, table_version) values ('imc_rooms','1'); /usr/share/kamailio/mysql/imc-create.sql:INSERT INTO version (table_name, table_version) values ('imc_members','1'); /usr/share/kamailio/mysql/ims_charging_create.sql:INSERT INTO version (table_name, table_version) values ('ro_session','6'); /usr/share/kamailio/mysql/ims_dialog-create.sql:INSERT INTO version (table_name, table_version) values ('dialog_in', 7), ('dialog_out', 7), ('dialog_vars', 7); /usr/share/kamailio/mysql/ims_usrloc_pcscf-create.sql:INSERT INTO version (table_name, table_version) values ('location','6'); /usr/share/kamailio/mysql/ims_usrloc_scscf-create.sql:INSERT INTO version (table_name, table_version) values ('contact','6'); /usr/share/kamailio/mysql/ims_usrloc_scscf-create.sql:INSERT INTO version (table_name, table_version) values ('impu','6'); /usr/share/kamailio/mysql/ims_usrloc_scscf-create.sql:INSERT INTO version (table_name, table_version) values ('impu_contact','6'); /usr/share/kamailio/mysql/ims_usrloc_scscf-create.sql:INSERT INTO version (table_name, table_version) values ('subscriber','6'); /usr/share/kamailio/mysql/ims_usrloc_scscf-create.sql:INSERT INTO version (table_name, table_version) values ('impu_subscriber','6'); /usr/share/kamailio/mysql/lcr-create.sql:INSERT INTO version (table_name, table_version) values ('lcr_gw','3'); /usr/share/kamailio/mysql/lcr-create.sql:INSERT INTO version (table_name, table_version) values ('lcr_rule_target','1'); /usr/share/kamailio/mysql/lcr-create.sql:INSERT INTO version (table_name, table_version) values ('lcr_rule','3'); /usr/share/kamailio/mysql/matrix-create.sql:INSERT INTO version (table_name, table_version) values ('matrix','1'); /usr/share/kamailio/mysql/mohqueue-create.sql:INSERT INTO version (table_name, table_version) values ('mohqcalls','1'); /usr/share/kamailio/mysql/mohqueue-create.sql:INSERT INTO version (table_name, table_version) values ('mohqueues','1'); /usr/share/kamailio/mysql/msilo-create.sql:INSERT INTO version (table_name, table_version) values ('silo','8'); /usr/share/kamailio/mysql/mtree-create.sql:INSERT INTO version (table_name, table_version) values ('mtree','1'); /usr/share/kamailio/mysql/mtree-create.sql:INSERT INTO version (table_name, table_version) values ('mtrees','2'); /usr/share/kamailio/mysql/pdt-create.sql:INSERT INTO version (table_name, table_version) values ('pdt','1'); /usr/share/kamailio/mysql/permissions-create.sql:INSERT INTO version (table_name, table_version) values ('trusted','6'); /usr/share/kamailio/mysql/permissions-create.sql:INSERT INTO version (table_name, table_version) values ('address','6'); /usr/share/kamailio/mysql/pipelimit-create.sql:INSERT INTO version (table_name, table_version) values ('pl_pipes','1'); /usr/share/kamailio/mysql/presence-create.sql:INSERT INTO version (table_name, table_version) values ('presentity','5'); /usr/share/kamailio/mysql/presence-create.sql:INSERT INTO version (table_name, table_version) values ('active_watchers','12'); /usr/share/kamailio/mysql/presence-create.sql:INSERT INTO version (table_name, table_version) values ('watchers','3'); /usr/share/kamailio/mysql/presence-create.sql:INSERT INTO version (table_name, table_version) values ('xcap','4'); /usr/share/kamailio/mysql/presence-create.sql:INSERT INTO version (table_name, table_version) values ('pua','7'); /usr/share/kamailio/mysql/purple-create.sql:INSERT INTO version (table_name, table_version) values ('purplemap','1'); /usr/share/kamailio/mysql/registrar-create.sql:INSERT INTO version (table_name, table_version) values ('aliases','8'); /usr/share/kamailio/mysql/rls-create.sql:INSERT INTO version (table_name, table_version) values ('rls_presentity','1'); /usr/share/kamailio/mysql/rls-create.sql:INSERT INTO version (table_name, table_version) values ('rls_watchers','3'); /usr/share/kamailio/mysql/rtpengine-create.sql:INSERT INTO version (table_name, table_version) values ('rtpengine','1'); /usr/share/kamailio/mysql/rtpproxy-create.sql:INSERT INTO version (table_name, table_version) values ('rtpproxy','1'); /usr/share/kamailio/mysql/sca-create.sql:INSERT INTO version (table_name, table_version) values ('sca_subscriptions','2'); /usr/share/kamailio/mysql/siptrace-create.sql:INSERT INTO version (table_name, table_version) values ('sip_trace','4'); /usr/share/kamailio/mysql/speeddial-create.sql:INSERT INTO version (table_name, table_version) values ('speed_dial','2'); /usr/share/kamailio/mysql/standard-create.sql:INSERT INTO version (table_name, table_version) values ('version','1'); /usr/share/kamailio/mysql/topos-create.sql:INSERT INTO version (table_name, table_version) values ('topos_d','1'); /usr/share/kamailio/mysql/topos-create.sql:INSERT INTO version (table_name, table_version) values ('topos_t','1'); /usr/share/kamailio/mysql/uac-create.sql:INSERT INTO version (table_name, table_version) values ('uacreg','3'); /usr/share/kamailio/mysql/uid_auth_db-create.sql:INSERT INTO version (table_name, table_version) values ('uid_credentials','7'); /usr/share/kamailio/mysql/uid_avp_db-create.sql:INSERT INTO version (table_name, table_version) values ('uid_user_attrs','3'); /usr/share/kamailio/mysql/uid_domain-create.sql:INSERT INTO version (table_name, table_version) values ('uid_domain','2'); /usr/share/kamailio/mysql/uid_domain-create.sql:INSERT INTO version (table_name, table_version) values ('uid_domain_attrs','1'); /usr/share/kamailio/mysql/uid_gflags-create.sql:INSERT INTO version (table_name, table_version) values ('uid_global_attrs','1'); /usr/share/kamailio/mysql/uid_uri_db-create.sql:INSERT INTO version (table_name, table_version) values ('uid_uri','3'); /usr/share/kamailio/mysql/uid_uri_db-create.sql:INSERT INTO version (table_name, table_version) values ('uid_uri_attrs','2'); /usr/share/kamailio/mysql/uri_db-create.sql:INSERT INTO version (table_name, table_version) values ('uri','1'); /usr/share/kamailio/mysql/userblacklist-create.sql:INSERT INTO version (table_name, table_version) values ('userblacklist','1'); /usr/share/kamailio/mysql/userblacklist-create.sql:INSERT INTO version (table_name, table_version) values ('globalblacklist','1'); /usr/share/kamailio/mysql/usrloc-create.sql:INSERT INTO version (table_name, table_version) values ('location','9'); /usr/share/kamailio/mysql/usrloc-create.sql:INSERT INTO version (table_name, table_version) values ('location_attrs','1');

Hello All, I need to do a version upgrade from 5 to 5.2. I read about the version_table parameter and i know i can create it and set the versions there. But where do i get the correct versions for the table? i.e.: location is version N? Thanks all! Regards, David Villasmil email: david.villasmil.work(a)gmail.com phone: +34669448337 On Wed, Jun 19, 2019 at 8:35 AM Daniel-Constantin Mierla < miconda(a)gmail.com&gt; wrote: