[sr-dev] git:master: dbschema: regenerated db creation scripts

Module: sip-router Branch: master Commit: 7ed91f0632fac344668ee7be5332d8e45490e2cd URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=7ed91f0… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Sat Jun 18 19:42:27 2011 +0200 dbschema: regenerated db creation scripts - updates to lcr tables and rls_watchers --- utils/kamctl/db_berkeley/kamailio/version | 4 ++-- utils/kamctl/dbtext/kamailio/version | 2 +- utils/kamctl/mysql/lcr-create.sql | 5 +++-- utils/kamctl/mysql/rls-create.sql | 4 ++-- utils/kamctl/oracle/lcr-create.sql | 5 +++-- utils/kamctl/oracle/rls-create.sql | 4 ++-- utils/kamctl/postgres/lcr-create.sql | 5 +++-- utils/kamctl/postgres/rls-create.sql | 4 ++-- 8 files changed, 18 insertions(+), 15 deletions(-) diff --git a/utils/kamctl/db_berkeley/kamailio/version b/utils/kamctl/db_berkeley/kamailio/version index 28d3bba..c533ac2 100644 --- a/utils/kamctl/db_berkeley/kamailio/version +++ b/utils/kamctl/db_berkeley/kamailio/version @@ -16,10 +16,10 @@ address| address|4 aliases| aliases|1004 -carrierfailureroute| -carrierfailureroute|2 carrier_name| carrier_name|1 +carrierfailureroute| +carrierfailureroute|2 carrierroute| carrierroute|3 cpl| diff --git a/utils/kamctl/dbtext/kamailio/version b/utils/kamctl/dbtext/kamailio/version index 0b9aad0..4410f97 100644 --- a/utils/kamctl/dbtext/kamailio/version +++ b/utils/kamctl/dbtext/kamailio/version @@ -3,8 +3,8 @@ acc:4 active_watchers:9 address:4 aliases:1004 -carrierfailureroute:2 carrier_name:1 +carrierfailureroute:2 carrierroute:3 cpl:1 dbaliases:1 diff --git a/utils/kamctl/mysql/lcr-create.sql b/utils/kamctl/mysql/lcr-create.sql index 0c23051..f0887c5 100644 --- a/utils/kamctl/mysql/lcr-create.sql +++ b/utils/kamctl/mysql/lcr-create.sql @@ -13,10 +13,11 @@ CREATE TABLE lcr_gw ( prefix VARCHAR(16) DEFAULT NULL, tag VARCHAR(64) DEFAULT NULL, flags INT UNSIGNED DEFAULT 0 NOT NULL, - defunct INT UNSIGNED DEFAULT NULL, - CONSTRAINT lcr_id_ip_addr_port_hostname_idx UNIQUE (lcr_id, ip_addr, port, hostname) + defunct INT UNSIGNED DEFAULT NULL ) ENGINE=MyISAM; +CREATE INDEX lcr_id_idx ON lcr_gw (lcr_id); + INSERT INTO version (table_name, table_version) values ('lcr_rule_target','1'); CREATE TABLE lcr_rule_target ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, diff --git a/utils/kamctl/mysql/rls-create.sql b/utils/kamctl/mysql/rls-create.sql index 28e8067..9b4e66d 100644 --- a/utils/kamctl/mysql/rls-create.sql +++ b/utils/kamctl/mysql/rls-create.sql @@ -26,10 +26,10 @@ CREATE TABLE rls_watchers ( event_id VARCHAR(64), to_tag VARCHAR(64) NOT NULL, from_tag VARCHAR(64) NOT NULL, - callid VARCHAR(64) NOT NULL, + callid VARCHAR(128) NOT NULL, local_cseq INT(11) NOT NULL, remote_cseq INT(11) NOT NULL, - contact VARCHAR(64) NOT NULL, + contact VARCHAR(128) NOT NULL, record_route TEXT, expires INT(11) NOT NULL, status INT(11) DEFAULT 2 NOT NULL, diff --git a/utils/kamctl/oracle/lcr-create.sql b/utils/kamctl/oracle/lcr-create.sql index 89e9bbc..bdf3dc2 100644 --- a/utils/kamctl/oracle/lcr-create.sql +++ b/utils/kamctl/oracle/lcr-create.sql @@ -13,8 +13,7 @@ CREATE TABLE lcr_gw ( prefix VARCHAR2(16) DEFAULT NULL, tag VARCHAR2(64) DEFAULT NULL, flags NUMBER(10) DEFAULT 0 NOT NULL, - defunct NUMBER(10) DEFAULT NULL, - CONSTRAINT ORA_lcr_id_ip_addr_port_hostname_idx UNIQUE (lcr_id, ip_addr, port, hostname) + defunct NUMBER(10) DEFAULT NULL ); CREATE OR REPLACE TRIGGER lcr_gw_tr @@ -25,6 +24,8 @@ END lcr_gw_tr; / BEGIN map2users('lcr_gw'); END; / +CREATE INDEX lcr_gw_lcr_id_idx ON lcr_gw (lcr_id); + INSERT INTO version (table_name, table_version) values ('lcr_rule_target','1'); CREATE TABLE lcr_rule_target ( id NUMBER(10) PRIMARY KEY, diff --git a/utils/kamctl/oracle/rls-create.sql b/utils/kamctl/oracle/rls-create.sql index 2d46b15..fdd64c3 100644 --- a/utils/kamctl/oracle/rls-create.sql +++ b/utils/kamctl/oracle/rls-create.sql @@ -34,10 +34,10 @@ CREATE TABLE rls_watchers ( event_id VARCHAR2(64), to_tag VARCHAR2(64), from_tag VARCHAR2(64), - callid VARCHAR2(64), + callid VARCHAR2(128), local_cseq NUMBER(10), remote_cseq NUMBER(10), - contact VARCHAR2(64), + contact VARCHAR2(128), record_route CLOB, expires NUMBER(10), status NUMBER(10) DEFAULT 2 NOT NULL, diff --git a/utils/kamctl/postgres/lcr-create.sql b/utils/kamctl/postgres/lcr-create.sql index 714615f..316e3ab 100644 --- a/utils/kamctl/postgres/lcr-create.sql +++ b/utils/kamctl/postgres/lcr-create.sql @@ -13,10 +13,11 @@ CREATE TABLE lcr_gw ( prefix VARCHAR(16) DEFAULT NULL, tag VARCHAR(64) DEFAULT NULL, flags INTEGER DEFAULT 0 NOT NULL, - defunct INTEGER DEFAULT NULL, - CONSTRAINT lcr_gw_lcr_id_ip_addr_port_hostname_idx UNIQUE (lcr_id, ip_addr, port, hostname) + defunct INTEGER DEFAULT NULL ); +CREATE INDEX lcr_gw_lcr_id_idx ON lcr_gw (lcr_id); + INSERT INTO version (table_name, table_version) values ('lcr_rule_target','1'); CREATE TABLE lcr_rule_target ( id SERIAL PRIMARY KEY NOT NULL, diff --git a/utils/kamctl/postgres/rls-create.sql b/utils/kamctl/postgres/rls-create.sql index 2da3fe2..4cb0d13 100644 --- a/utils/kamctl/postgres/rls-create.sql +++ b/utils/kamctl/postgres/rls-create.sql @@ -26,10 +26,10 @@ CREATE TABLE rls_watchers ( event_id VARCHAR(64), to_tag VARCHAR(64) NOT NULL, from_tag VARCHAR(64) NOT NULL, - callid VARCHAR(64) NOT NULL, + callid VARCHAR(128) NOT NULL, local_cseq INTEGER NOT NULL, remote_cseq INTEGER NOT NULL, - contact VARCHAR(64) NOT NULL, + contact VARCHAR(128) NOT NULL, record_route TEXT, expires INTEGER NOT NULL, status INTEGER DEFAULT 2 NOT NULL,