[sr-dev] git:master: db scheme(k): update schemes after version increment in trusted table from Juha

[Henning Westerholt]

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

Author: Henning Westerholt <henning.westerholt at 1und1.de>
Committer: Henning Westerholt <henning.westerholt at 1und1.de>
Date:   Fri Oct 23 18:23:38 2009 +0200

db scheme(k): update schemes after version increment in trusted table from Juha

---

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

diff --git a/utils/kamctl/db_berkeley/kamailio/version b/utils/kamctl/db_berkeley/kamailio/version
index d977706..e03028f 100644
--- a/utils/kamctl/db_berkeley/kamailio/version
+++ b/utils/kamctl/db_berkeley/kamailio/version
@@ -79,7 +79,7 @@ speed_dial|2
 subscriber|
 subscriber|6
 trusted|
-trusted|4
+trusted|5
 uri|
 uri|1
 userblacklist|
diff --git a/utils/kamctl/dbtext/kamailio/version b/utils/kamctl/dbtext/kamailio/version
index 2822a7a..5b9b49d 100644
--- a/utils/kamctl/dbtext/kamailio/version
+++ b/utils/kamctl/dbtext/kamailio/version
@@ -34,7 +34,7 @@ silo:5
 sip_trace:2
 speed_dial:2
 subscriber:6
-trusted:4
+trusted:5
 uri:1
 userblacklist:1
 usr_preferences:2
diff --git a/utils/kamctl/mysql/permissions-create.sql b/utils/kamctl/mysql/permissions-create.sql
index ecc92e8..f3be981 100644
--- a/utils/kamctl/mysql/permissions-create.sql
+++ b/utils/kamctl/mysql/permissions-create.sql
@@ -1,10 +1,10 @@
-INSERT INTO version (table_name, table_version) values ('trusted','4');
+INSERT INTO version (table_name, table_version) values ('trusted','5');
 CREATE TABLE trusted (
     id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
     src_ip VARCHAR(50) NOT NULL,
     proto VARCHAR(4) NOT NULL,
     from_pattern VARCHAR(64) DEFAULT NULL,
-    tag VARCHAR(32)
+    tag VARCHAR(64)
 ) ENGINE=MyISAM;
 
 CREATE INDEX peer_idx ON trusted (src_ip);
diff --git a/utils/kamctl/oracle/permissions-create.sql b/utils/kamctl/oracle/permissions-create.sql
index 4153147..c6045d0 100644
--- a/utils/kamctl/oracle/permissions-create.sql
+++ b/utils/kamctl/oracle/permissions-create.sql
@@ -1,10 +1,10 @@
-INSERT INTO version (table_name, table_version) values ('trusted','4');
+INSERT INTO version (table_name, table_version) values ('trusted','5');
 CREATE TABLE trusted (
     id NUMBER(10) PRIMARY KEY,
     src_ip VARCHAR2(50),
     proto VARCHAR2(4),
     from_pattern VARCHAR2(64) DEFAULT NULL,
-    tag VARCHAR2(32)
+    tag VARCHAR2(64)
 );
 
 CREATE OR REPLACE TRIGGER trusted_tr
diff --git a/utils/kamctl/postgres/permissions-create.sql b/utils/kamctl/postgres/permissions-create.sql
index 886ec12..5514ef5 100644
--- a/utils/kamctl/postgres/permissions-create.sql
+++ b/utils/kamctl/postgres/permissions-create.sql
@@ -1,10 +1,10 @@
-INSERT INTO version (table_name, table_version) values ('trusted','4');
+INSERT INTO version (table_name, table_version) values ('trusted','5');
 CREATE TABLE trusted (
     id SERIAL PRIMARY KEY NOT NULL,
     src_ip VARCHAR(50) NOT NULL,
     proto VARCHAR(4) NOT NULL,
     from_pattern VARCHAR(64) DEFAULT NULL,
-    tag VARCHAR(32)
+    tag VARCHAR(64)
 );
 
 CREATE INDEX trusted_peer_idx ON trusted (src_ip);