Module: sip-router Branch: master Commit: c3305feeccd1a3f063f4c210ec0c6118d9d218ec URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=c3305fe… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Committer: Henning Westerholt <henning.westerholt(a)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);