[sr-dev] git:master: dbschema: regenerated db creation scripts
Daniel-Constantin Mierla
miconda at gmail.com
Sat Jun 18 19:43:38 CEST 2011
Module: sip-router
Branch: master
Commit: 7ed91f0632fac344668ee7be5332d8e45490e2cd
URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=7ed91f0632fac344668ee7be5332d8e45490e2cd
Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at 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,
More information about the sr-dev
mailing list