[sr-dev] git:carstenbock/ims: - increased table version for usrloc to 1005
Carsten Bock
carsten at bock.info
Tue Mar 29 13:35:22 CEST 2011
Module: sip-router
Branch: carstenbock/ims
Commit: 35e5a129aec0bd61f4fdd9a5c04387891cb6555f
URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=35e5a129aec0bd61f4fdd9a5c04387891cb6555f
Author: Carsten Bock <carsten at bock.info>
Committer: Carsten Bock <carsten at 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);
More information about the sr-dev
mailing list