Module: sip-router Branch: carstenbock/ims Commit: 35e5a129aec0bd61f4fdd9a5c04387891cb6555f URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=35e5a12… Author: Carsten Bock <carsten(a)bock.info> Committer: Carsten Bock <carsten(a)bock.info> Date: Tue Mar 29 11:37:15 2011 +0200 - increased table version for usrloc to 1005 - updated the table definitions --- modules_k/usrloc/ul_mod.h | 2 +- utils/kamctl/db_berkeley/kamailio/location | 4 ++-- utils/kamctl/db_berkeley/kamailio/version | 2 +- utils/kamctl/dbtext/kamailio/location | 3 ++- utils/kamctl/dbtext/kamailio/version | 2 +- utils/kamctl/mysql/usrloc-create.sql | 5 +++-- utils/kamctl/oracle/usrloc-create.sql | 5 +++-- utils/kamctl/postgres/usrloc-create.sql | 5 +++-- 8 files changed, 16 insertions(+), 12 deletions(-) diff --git a/modules_k/usrloc/ul_mod.h b/modules_k/usrloc/ul_mod.h index d67c513..06573c1 100644 --- a/modules_k/usrloc/ul_mod.h +++ b/modules_k/usrloc/ul_mod.h @@ -43,7 +43,7 @@ */ -#define UL_TABLE_VERSION 1004 +#define UL_TABLE_VERSION 1005 extern str user_col; extern str domain_col; diff --git a/utils/kamctl/db_berkeley/kamailio/location b/utils/kamctl/db_berkeley/kamailio/location index 061f3ef..c1fad1e 100644 --- a/utils/kamctl/db_berkeley/kamailio/location +++ b/utils/kamctl/db_berkeley/kamailio/location @@ -1,5 +1,5 @@ METADATA_COLUMNS -id(int) username(str) domain(str) contact(str) received(str) path(str) expires(datetime) q(double) callid(str) cseq(int) last_modified(datetime) flags(int) cflags(int) user_agent(str) socket(str) methods(int) +id(int) username(str) domain(str) contact(str) received(str) path(str) expires(datetime) q(double) callid(str) cseq(int) last_modified(datetime) flags(int) cflags(int) user_agent(str) socket(str) methods(int) reg_avps(str) METADATA_KEY 1 2 METADATA_READONLY @@ -7,4 +7,4 @@ METADATA_READONLY METADATA_LOGFLAGS 0 METADATA_DEFAULTS -NIL|''|NULL|''|NULL|NULL|'2020-05-28 21:32:15'|1.0|'Default-Call-ID'|13|'1900-01-01 00:00:01'|0|0|''|NULL|NULL +NIL|''|NULL|''|NULL|NULL|'2020-05-28 21:32:15'|1.0|'Default-Call-ID'|13|'1900-01-01 00:00:01'|0|0|''|NULL|NULL|NULL diff --git a/utils/kamctl/db_berkeley/kamailio/version b/utils/kamctl/db_berkeley/kamailio/version index 7adb9d6..96dffb5 100644 --- a/utils/kamctl/db_berkeley/kamailio/version +++ b/utils/kamctl/db_berkeley/kamailio/version @@ -68,7 +68,7 @@ lcr_rule|1 lcr_rule_target| lcr_rule_target|1 location| -location|1004 +location|1005 matrix| matrix|1 missed_calls| diff --git a/utils/kamctl/dbtext/kamailio/location b/utils/kamctl/dbtext/kamailio/location index 3f80cc4..4a6df19 100644 --- a/utils/kamctl/dbtext/kamailio/location +++ b/utils/kamctl/dbtext/kamailio/location @@ -1 +1,2 @@ -id(int,auto) username(string) domain(string,null) contact(string) received(string,null) path(string,null) expires(int) q(double) callid(string) cseq(int) last_modified(int) flags(int) cflags(int) user_agent(string) socket(string,null) methods(int,null) + +id(int,auto) username(string) domain(string,null) contact(string) received(string,null) path(string,null) expires(int) q(double) callid(string) cseq(int) last_modified(int) flags(int) cflags(int) user_agent(string) socket(string,null) methods(int,null) reg_avps(string,null) diff --git a/utils/kamctl/dbtext/kamailio/version b/utils/kamctl/dbtext/kamailio/version index bbb8503..2505374 100644 --- a/utils/kamctl/dbtext/kamailio/version +++ b/utils/kamctl/dbtext/kamailio/version @@ -29,7 +29,7 @@ id(int,auto) lcr_id(int) prefix(string,null) from_uri(string,null) grp_id(int) p lcr_gw:1 lcr_rule:1 lcr_rule_target:1 -location:1004 +location:1005 matrix:1 missed_calls:3 mtree:1 diff --git a/utils/kamctl/mysql/usrloc-create.sql b/utils/kamctl/mysql/usrloc-create.sql index 5dd6f6c..66919d6 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','1004'); +INSERT INTO version (table_name, table_version) values ('location','1005'); CREATE TABLE location ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, username VARCHAR(64) DEFAULT '' NOT NULL, @@ -15,7 +15,8 @@ CREATE TABLE location ( cflags INT(11) DEFAULT 0 NOT NULL, user_agent VARCHAR(255) DEFAULT '' NOT NULL, socket VARCHAR(64) DEFAULT NULL, - methods INT(11) DEFAULT NULL + methods INT(11) DEFAULT NULL, + reg_avps VARCHAR(255) DEFAULT NULL, ) ENGINE=MyISAM; CREATE INDEX account_contact_idx ON location (username, domain, contact); diff --git a/utils/kamctl/oracle/usrloc-create.sql b/utils/kamctl/oracle/usrloc-create.sql index 055de44..94f466b 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','1004'); +INSERT INTO version (table_name, table_version) values ('location','1005'); CREATE TABLE location ( id NUMBER(10) PRIMARY KEY, username VARCHAR2(64) DEFAULT '', @@ -15,7 +15,8 @@ CREATE TABLE location ( cflags NUMBER(10) DEFAULT 0 NOT NULL, user_agent VARCHAR2(255) DEFAULT '', socket VARCHAR2(64) DEFAULT NULL, - methods NUMBER(10) DEFAULT NULL + methods NUMBER(10) DEFAULT NULL, + reg_avps VARCHAR(255) DEFAULT NULL, ); CREATE OR REPLACE TRIGGER location_tr diff --git a/utils/kamctl/postgres/usrloc-create.sql b/utils/kamctl/postgres/usrloc-create.sql index a93c034..2764291 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','1004'); +INSERT INTO version (table_name, table_version) values ('location','1005'); CREATE TABLE location ( id SERIAL PRIMARY KEY NOT NULL, username VARCHAR(64) DEFAULT '' NOT NULL, @@ -15,7 +15,8 @@ CREATE TABLE location ( cflags INTEGER DEFAULT 0 NOT NULL, user_agent VARCHAR(255) DEFAULT '' NOT NULL, socket VARCHAR(64) DEFAULT NULL, - methods INTEGER DEFAULT NULL + methods INTEGER DEFAULT NULL, + reg_avps VARCHAR(255) DEFAULT NULL, ); CREATE INDEX location_account_contact_idx ON location (username, domain, contact);