[sr-dev] git:master: db scheme: add missing usrloc and aliases version increase, reported from Juha
Henning Westerholt
hw at kamailio.org
Tue Sep 11 15:14:47 CEST 2012
Module: sip-router
Branch: master
Commit: 78dae896127ce6762e3fa7c2541e1b5f9b8a9023
URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=78dae896127ce6762e3fa7c2541e1b5f9b8a9023
Author: Henning Westerholt <hw at kamailio.org>
Committer: Henning Westerholt <hw at kamailio.org>
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,
More information about the sr-dev
mailing list