Module: sip-router Branch: master Commit: 78dae896127ce6762e3fa7c2541e1b5f9b8a9023 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=78dae89… Author: Henning Westerholt &lt;hw(a)kamailio.org&gt; Committer: Henning Westerholt &lt;hw(a)kamailio.org&gt; Date: Tue Sep 11 15:13:39 2012 +0200 db scheme: add missing usrloc and aliases version increase, reported from Juha --- lib/srdb1/schema/aliases.xml | 2 +- lib/srdb1/schema/location.xml | 2 +- utils/kamctl/db_berkeley/kamailio/version | 4 ++-- utils/kamctl/db_sqlite/registrar-create.sql | 2 +- utils/kamctl/db_sqlite/usrloc-create.sql | 2 +- utils/kamctl/dbtext/kamailio/version | 4 ++-- utils/kamctl/mysql/registrar-create.sql | 2 +- utils/kamctl/mysql/usrloc-create.sql | 2 +- utils/kamctl/oracle/registrar-create.sql | 2 +- utils/kamctl/oracle/usrloc-create.sql | 2 +- utils/kamctl/postgres/registrar-create.sql | 2 +- utils/kamctl/postgres/usrloc-create.sql | 2 +- 12 files changed, 14 insertions(+), 14 deletions(-) diff --git a/lib/srdb1/schema/aliases.xml b/lib/srdb1/schema/aliases.xml index 29975de..5f135b9 100644 --- a/lib/srdb1/schema/aliases.xml +++ b/lib/srdb1/schema/aliases.xml @@ -9,7 +9,7 @@ <table id="aliases" xmlns:db="http://docbook.org/ns/docbook"> <name>aliases</name> - <version>5</version> + <version>6</version> <type db="mysql">&MYSQL_TABLE_TYPE;</type> <description> <db:para>This table for the registrar module is similar to the "location" table, (the aliases index makes lookup of missed calls much faster). Thus, the function lookup("alias") can be used to map aliases to AORs. More information is available at: &KAMAILIO_MOD_DOC;registrar.html. Most people uses the dbaliases table with the alias_db module now. diff --git a/lib/srdb1/schema/location.xml b/lib/srdb1/schema/location.xml index fc1c8e7..add435b 100644 --- a/lib/srdb1/schema/location.xml +++ b/lib/srdb1/schema/location.xml @@ -9,7 +9,7 @@ <table id="location" xmlns:db="http://docbook.org/ns/docbook"> <name>location</name> - <version>5</version> + <version>6</version> <type db="mysql">&MYSQL_TABLE_TYPE;</type> <description> <db:para>Persistent user location information for the usrloc module. More information can be found at: &KAMAILIO_MOD_DOC;usrloc.html diff --git a/utils/kamctl/db_berkeley/kamailio/version b/utils/kamctl/db_berkeley/kamailio/version index c51ace4..4d0e5ee 100644 --- a/utils/kamctl/db_berkeley/kamailio/version +++ b/utils/kamctl/db_berkeley/kamailio/version @@ -15,7 +15,7 @@ active_watchers|11 address| address|5 aliases| -aliases|5 +aliases|6 carrier_name| carrier_name|1 carrierfailureroute| @@ -67,7 +67,7 @@ lcr_rule|2 lcr_rule_target| lcr_rule_target|1 location| -location|5 +location|6 matrix| matrix|1 missed_calls| diff --git a/utils/kamctl/db_sqlite/registrar-create.sql b/utils/kamctl/db_sqlite/registrar-create.sql index f9a4cc4..b32d61c 100644 --- a/utils/kamctl/db_sqlite/registrar-create.sql +++ b/utils/kamctl/db_sqlite/registrar-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('aliases','5'); +INSERT INTO version (table_name, table_version) values ('aliases','6'); CREATE TABLE aliases ( id INTEGER PRIMARY KEY NOT NULL, ruid VARCHAR(64) DEFAULT '' NOT NULL, diff --git a/utils/kamctl/db_sqlite/usrloc-create.sql b/utils/kamctl/db_sqlite/usrloc-create.sql index 6286179..ee86dd0 100644 --- a/utils/kamctl/db_sqlite/usrloc-create.sql +++ b/utils/kamctl/db_sqlite/usrloc-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('location','5'); +INSERT INTO version (table_name, table_version) values ('location','6'); CREATE TABLE location ( id INTEGER PRIMARY KEY NOT NULL, ruid VARCHAR(64) DEFAULT '' NOT NULL, diff --git a/utils/kamctl/dbtext/kamailio/version b/utils/kamctl/dbtext/kamailio/version index 0396a99..996c37f 100644 --- a/utils/kamctl/dbtext/kamailio/version +++ b/utils/kamctl/dbtext/kamailio/version @@ -2,7 +2,7 @@ table_name(string) table_version(int) acc:4 active_watchers:11 address:5 -aliases:5 +aliases:6 carrier_name:1 carrierfailureroute:2 carrierroute:3 @@ -28,7 +28,7 @@ imc_rooms:1 lcr_gw:2 lcr_rule:2 lcr_rule_target:1 -location:5 +location:6 matrix:1 missed_calls:3 mtree:1 diff --git a/utils/kamctl/mysql/registrar-create.sql b/utils/kamctl/mysql/registrar-create.sql index 4d7d9e8..3cb5287 100644 --- a/utils/kamctl/mysql/registrar-create.sql +++ b/utils/kamctl/mysql/registrar-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('aliases','5'); +INSERT INTO version (table_name, table_version) values ('aliases','6'); CREATE TABLE aliases ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, ruid VARCHAR(64) DEFAULT '' NOT NULL, diff --git a/utils/kamctl/mysql/usrloc-create.sql b/utils/kamctl/mysql/usrloc-create.sql index 8f4f425..4823757 100644 --- a/utils/kamctl/mysql/usrloc-create.sql +++ b/utils/kamctl/mysql/usrloc-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('location','5'); +INSERT INTO version (table_name, table_version) values ('location','6'); CREATE TABLE location ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, ruid VARCHAR(64) DEFAULT '' NOT NULL, diff --git a/utils/kamctl/oracle/registrar-create.sql b/utils/kamctl/oracle/registrar-create.sql index 4c0d5ba..346564d 100644 --- a/utils/kamctl/oracle/registrar-create.sql +++ b/utils/kamctl/oracle/registrar-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('aliases','5'); +INSERT INTO version (table_name, table_version) values ('aliases','6'); CREATE TABLE aliases ( id NUMBER(10) PRIMARY KEY, ruid VARCHAR2(64) DEFAULT '', diff --git a/utils/kamctl/oracle/usrloc-create.sql b/utils/kamctl/oracle/usrloc-create.sql index 8cc677e..35798f5 100644 --- a/utils/kamctl/oracle/usrloc-create.sql +++ b/utils/kamctl/oracle/usrloc-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('location','5'); +INSERT INTO version (table_name, table_version) values ('location','6'); CREATE TABLE location ( id NUMBER(10) PRIMARY KEY, ruid VARCHAR2(64) DEFAULT '', diff --git a/utils/kamctl/postgres/registrar-create.sql b/utils/kamctl/postgres/registrar-create.sql index 86d0b11..11306cf 100644 --- a/utils/kamctl/postgres/registrar-create.sql +++ b/utils/kamctl/postgres/registrar-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('aliases','5'); +INSERT INTO version (table_name, table_version) values ('aliases','6'); CREATE TABLE aliases ( id SERIAL PRIMARY KEY NOT NULL, ruid VARCHAR(64) DEFAULT '' NOT NULL, diff --git a/utils/kamctl/postgres/usrloc-create.sql b/utils/kamctl/postgres/usrloc-create.sql index c161178..9998d86 100644 --- a/utils/kamctl/postgres/usrloc-create.sql +++ b/utils/kamctl/postgres/usrloc-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('location','5'); +INSERT INTO version (table_name, table_version) values ('location','6'); CREATE TABLE location ( id SERIAL PRIMARY KEY NOT NULL, ruid VARCHAR(64) DEFAULT '' NOT NULL,