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

Module: sip-router Branch: master Commit: 64fa789c3bc94b36e79a8d886c5c2742c8a1629d URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=64fa789… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)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) );