[sr-dev] git:master: kamctl: regenerated db definition scripts

Daniel-Constantin Mierla miconda at gmail.com
Sat Mar 27 23:31:34 CET 2010


Module: sip-router
Branch: master
Commit: 64fa789c3bc94b36e79a8d886c5c2742c8a1629d
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=64fa789c3bc94b36e79a8d886c5c2742c8a1629d

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date:   Sat Mar 27 23:29:01 2010 +0100

kamctl: regenerated db definition scripts

- due to update of address table structure with new column 'tag'

---

 utils/kamctl/db_berkeley/kamailio/address    |    4 ++--
 utils/kamctl/db_berkeley/kamailio/version    |    8 +++-----
 utils/kamctl/dbtext/kamailio/address         |    2 +-
 utils/kamctl/dbtext/kamailio/version         |    5 ++---
 utils/kamctl/mysql/permissions-create.sql    |    5 +++--
 utils/kamctl/oracle/permissions-create.sql   |    5 +++--
 utils/kamctl/postgres/permissions-create.sql |    5 +++--
 7 files changed, 17 insertions(+), 17 deletions(-)

diff --git a/utils/kamctl/db_berkeley/kamailio/address b/utils/kamctl/db_berkeley/kamailio/address
index e49cd3f..0b0ee35 100644
--- a/utils/kamctl/db_berkeley/kamailio/address
+++ b/utils/kamctl/db_berkeley/kamailio/address
@@ -1,5 +1,5 @@
 METADATA_COLUMNS
-id(int) grp(int) ip_addr(str) mask(int) port(int)
+id(int) grp(int) ip_addr(str) mask(int) port(int) tag(str)
 METADATA_KEY
 1 
 METADATA_READONLY
@@ -7,4 +7,4 @@ METADATA_READONLY
 METADATA_LOGFLAGS
 0
 METADATA_DEFAULTS
-NIL|0|NIL|32|0
+NIL|0|NIL|32|0|NIL
diff --git a/utils/kamctl/db_berkeley/kamailio/version b/utils/kamctl/db_berkeley/kamailio/version
index 539e2ff..86f1a9a 100644
--- a/utils/kamctl/db_berkeley/kamailio/version
+++ b/utils/kamctl/db_berkeley/kamailio/version
@@ -13,13 +13,13 @@ acc|4
 active_watchers|
 active_watchers|9
 address|
-address|3
+address|4
 aliases|
 aliases|1004
-carrierfailureroute|
-carrierfailureroute|2
 carrier_name|
 carrier_name|1
+carrierfailureroute|
+carrierfailureroute|2
 carrierroute|
 carrierroute|3
 cpl|
@@ -88,8 +88,6 @@ subscriber|
 subscriber|6
 trusted|
 trusted|5
-uacreg|
-uacreg|1
 uri|
 uri|1
 userblacklist|
diff --git a/utils/kamctl/dbtext/kamailio/address b/utils/kamctl/dbtext/kamailio/address
index 8d58a84..070e156 100644
--- a/utils/kamctl/dbtext/kamailio/address
+++ b/utils/kamctl/dbtext/kamailio/address
@@ -1 +1 @@
-id(int,auto) grp(int) ip_addr(string) mask(int) port(int) 
+id(int,auto) grp(int) ip_addr(string) mask(int) port(int) tag(string,null) 
diff --git a/utils/kamctl/dbtext/kamailio/version b/utils/kamctl/dbtext/kamailio/version
index 788c7c0..8647481 100644
--- a/utils/kamctl/dbtext/kamailio/version
+++ b/utils/kamctl/dbtext/kamailio/version
@@ -1,10 +1,10 @@
 table_name(string) table_version(int) 
 acc:4
 active_watchers:9
-address:3
+address:4
 aliases:1004
-carrierfailureroute:2
 carrier_name:1
+carrierfailureroute:2
 carrierroute:3
 cpl:1
 dbaliases:1
@@ -39,7 +39,6 @@ sip_trace:2
 speed_dial:2
 subscriber:6
 trusted:5
-uacreg:1
 uri:1
 userblacklist:1
 usr_preferences:2
diff --git a/utils/kamctl/mysql/permissions-create.sql b/utils/kamctl/mysql/permissions-create.sql
index f3be981..4d71642 100644
--- a/utils/kamctl/mysql/permissions-create.sql
+++ b/utils/kamctl/mysql/permissions-create.sql
@@ -9,12 +9,13 @@ CREATE TABLE trusted (
 
 CREATE INDEX peer_idx ON trusted (src_ip);
 
-INSERT INTO version (table_name, table_version) values ('address','3');
+INSERT INTO version (table_name, table_version) values ('address','4');
 CREATE TABLE address (
     id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
     grp SMALLINT(5) UNSIGNED DEFAULT 0 NOT NULL,
     ip_addr VARCHAR(15) NOT NULL,
     mask TINYINT DEFAULT 32 NOT NULL,
-    port SMALLINT(5) UNSIGNED DEFAULT 0 NOT NULL
+    port SMALLINT(5) UNSIGNED DEFAULT 0 NOT NULL,
+    tag VARCHAR(64)
 ) ENGINE=MyISAM;
 
diff --git a/utils/kamctl/oracle/permissions-create.sql b/utils/kamctl/oracle/permissions-create.sql
index c6045d0..6caad1a 100644
--- a/utils/kamctl/oracle/permissions-create.sql
+++ b/utils/kamctl/oracle/permissions-create.sql
@@ -17,13 +17,14 @@ BEGIN map2users('trusted'); END;
 /
 CREATE INDEX trusted_peer_idx  ON trusted (src_ip);
 
-INSERT INTO version (table_name, table_version) values ('address','3');
+INSERT INTO version (table_name, table_version) values ('address','4');
 CREATE TABLE address (
     id NUMBER(10) PRIMARY KEY,
     grp NUMBER(5) DEFAULT 0 NOT NULL,
     ip_addr VARCHAR2(15),
     mask NUMBER(5) DEFAULT 32 NOT NULL,
-    port NUMBER(5) DEFAULT 0 NOT NULL
+    port NUMBER(5) DEFAULT 0 NOT NULL,
+    tag VARCHAR2(64)
 );
 
 CREATE OR REPLACE TRIGGER address_tr
diff --git a/utils/kamctl/postgres/permissions-create.sql b/utils/kamctl/postgres/permissions-create.sql
index 5514ef5..e7bee3b 100644
--- a/utils/kamctl/postgres/permissions-create.sql
+++ b/utils/kamctl/postgres/permissions-create.sql
@@ -9,12 +9,13 @@ CREATE TABLE trusted (
 
 CREATE INDEX trusted_peer_idx ON trusted (src_ip);
 
-INSERT INTO version (table_name, table_version) values ('address','3');
+INSERT INTO version (table_name, table_version) values ('address','4');
 CREATE TABLE address (
     id SERIAL PRIMARY KEY NOT NULL,
     grp SMALLINT DEFAULT 0 NOT NULL,
     ip_addr VARCHAR(15) NOT NULL,
     mask SMALLINT DEFAULT 32 NOT NULL,
-    port SMALLINT DEFAULT 0 NOT NULL
+    port SMALLINT DEFAULT 0 NOT NULL,
+    tag VARCHAR(64)
 );
 




More information about the sr-dev mailing list