[sr-dev] git:master: kamctl: updated db creation scripts
Daniel-Constantin Mierla
miconda at gmail.com
Tue Oct 29 11:09:20 CET 2013
Module: sip-router
Branch: master
Commit: c4a4b4f599ba428330899e804877e85d3fdcc3a4
URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=c4a4b4f599ba428330899e804877e85d3fdcc3a4
Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: Tue Oct 29 11:08:49 2013 +0100
kamctl: updated db creation scripts
---
utils/kamctl/db_berkeley/kamailio/mohqcalls | 2 --
utils/kamctl/db_berkeley/kamailio/mohqueues | 2 --
utils/kamctl/db_berkeley/kamailio/version | 4 ++++
utils/kamctl/db_sqlite/alias_db-create.sql | 5 +++--
utils/kamctl/dbtext/kamailio/mohqcalls | 1 -
utils/kamctl/dbtext/kamailio/mohqueues | 1 -
utils/kamctl/dbtext/kamailio/version | 2 ++
utils/kamctl/mysql/alias_db-create.sql | 5 +++--
utils/kamctl/oracle/alias_db-create.sql | 5 +++--
utils/kamctl/postgres/alias_db-create.sql | 5 +++--
10 files changed, 18 insertions(+), 14 deletions(-)
diff --git a/utils/kamctl/db_berkeley/kamailio/mohqcalls b/utils/kamctl/db_berkeley/kamailio/mohqcalls
index b80902e..0ecaef4 100644
--- a/utils/kamctl/db_berkeley/kamailio/mohqcalls
+++ b/utils/kamctl/db_berkeley/kamailio/mohqcalls
@@ -8,5 +8,3 @@ METADATA_LOGFLAGS
0
METADATA_DEFAULTS
NIL|NIL|NIL|NIL|NIL|NIL|'to_date('','yyyy-mm-dd hh24:mi:ss')'
-mohqcalls|
-mohqcalls|1
diff --git a/utils/kamctl/db_berkeley/kamailio/mohqueues b/utils/kamctl/db_berkeley/kamailio/mohqueues
index f5eeb2c..eafd9ce 100644
--- a/utils/kamctl/db_berkeley/kamailio/mohqueues
+++ b/utils/kamctl/db_berkeley/kamailio/mohqueues
@@ -8,5 +8,3 @@ METADATA_LOGFLAGS
0
METADATA_DEFAULTS
NIL|NIL|NIL|NIL|NIL|NIL
-mohqueues|
-mohqueues|1
diff --git a/utils/kamctl/db_berkeley/kamailio/version b/utils/kamctl/db_berkeley/kamailio/version
index c981eaa..e9e350b 100644
--- a/utils/kamctl/db_berkeley/kamailio/version
+++ b/utils/kamctl/db_berkeley/kamailio/version
@@ -76,6 +76,10 @@ matrix|
matrix|1
missed_calls|
missed_calls|3
+mohqcalls|
+mohqcalls|1
+mohqueues|
+mohqueues|1
mtree|
mtree|1
mtrees|
diff --git a/utils/kamctl/db_sqlite/alias_db-create.sql b/utils/kamctl/db_sqlite/alias_db-create.sql
index 90656e9..f9975de 100644
--- a/utils/kamctl/db_sqlite/alias_db-create.sql
+++ b/utils/kamctl/db_sqlite/alias_db-create.sql
@@ -4,9 +4,10 @@ CREATE TABLE dbaliases (
alias_username VARCHAR(64) DEFAULT '' NOT NULL,
alias_domain VARCHAR(64) DEFAULT '' NOT NULL,
username VARCHAR(64) DEFAULT '' NOT NULL,
- domain VARCHAR(64) DEFAULT '' NOT NULL,
- CONSTRAINT dbaliases_alias_idx UNIQUE (alias_username, alias_domain)
+ domain VARCHAR(64) DEFAULT '' NOT NULL
);
+CREATE INDEX dbaliases_alias_user_idx ON dbaliases (alias_username);
+CREATE INDEX dbaliases_alias_idx ON dbaliases (alias_username, alias_domain);
CREATE INDEX dbaliases_target_idx ON dbaliases (username, domain);
diff --git a/utils/kamctl/dbtext/kamailio/mohqcalls b/utils/kamctl/dbtext/kamailio/mohqcalls
index feacec1..c5454dc 100644
--- a/utils/kamctl/dbtext/kamailio/mohqcalls
+++ b/utils/kamctl/dbtext/kamailio/mohqcalls
@@ -1,2 +1 @@
id(int,auto) mohq_id(int) call_id(string) call_status(int) call_from(string) call_contact(string,null) call_time(int)
-mohqcalls:1
diff --git a/utils/kamctl/dbtext/kamailio/mohqueues b/utils/kamctl/dbtext/kamailio/mohqueues
index 687cb17..a44840b 100644
--- a/utils/kamctl/dbtext/kamailio/mohqueues
+++ b/utils/kamctl/dbtext/kamailio/mohqueues
@@ -1,2 +1 @@
id(int,auto) name(string) uri(string) mohdir(string,null) mohfile(string) debug(int)
-mohqueues:1
diff --git a/utils/kamctl/dbtext/kamailio/version b/utils/kamctl/dbtext/kamailio/version
index be869b3..c3ca5ad 100644
--- a/utils/kamctl/dbtext/kamailio/version
+++ b/utils/kamctl/dbtext/kamailio/version
@@ -33,6 +33,8 @@ location:6
location_attrs:1
matrix:1
missed_calls:3
+mohqcalls:1
+mohqueues:1
mtree:1
mtrees:2
pdt:1
diff --git a/utils/kamctl/mysql/alias_db-create.sql b/utils/kamctl/mysql/alias_db-create.sql
index cfb73b9..86fe793 100644
--- a/utils/kamctl/mysql/alias_db-create.sql
+++ b/utils/kamctl/mysql/alias_db-create.sql
@@ -4,9 +4,10 @@ CREATE TABLE dbaliases (
alias_username VARCHAR(64) DEFAULT '' NOT NULL,
alias_domain VARCHAR(64) DEFAULT '' NOT NULL,
username VARCHAR(64) DEFAULT '' NOT NULL,
- domain VARCHAR(64) DEFAULT '' NOT NULL,
- CONSTRAINT alias_idx UNIQUE (alias_username, alias_domain)
+ domain VARCHAR(64) DEFAULT '' NOT NULL
);
+CREATE INDEX alias_user_idx ON dbaliases (alias_username);
+CREATE INDEX alias_idx ON dbaliases (alias_username, alias_domain);
CREATE INDEX target_idx ON dbaliases (username, domain);
diff --git a/utils/kamctl/oracle/alias_db-create.sql b/utils/kamctl/oracle/alias_db-create.sql
index 57a9ba9..03ec78a 100644
--- a/utils/kamctl/oracle/alias_db-create.sql
+++ b/utils/kamctl/oracle/alias_db-create.sql
@@ -4,8 +4,7 @@ CREATE TABLE dbaliases (
alias_username VARCHAR2(64) DEFAULT '',
alias_domain VARCHAR2(64) DEFAULT '',
username VARCHAR2(64) DEFAULT '',
- domain VARCHAR2(64) DEFAULT '',
- CONSTRAINT dbaliases_alias_idx UNIQUE (alias_username, alias_domain)
+ domain VARCHAR2(64) DEFAULT ''
);
CREATE OR REPLACE TRIGGER dbaliases_tr
@@ -16,5 +15,7 @@ END dbaliases_tr;
/
BEGIN map2users('dbaliases'); END;
/
+CREATE INDEX dbaliases_alias_user_idx ON dbaliases (alias_username);
+CREATE INDEX dbaliases_alias_idx ON dbaliases (alias_username, alias_domain);
CREATE INDEX dbaliases_target_idx ON dbaliases (username, domain);
diff --git a/utils/kamctl/postgres/alias_db-create.sql b/utils/kamctl/postgres/alias_db-create.sql
index 1bf29ea..5947b02 100644
--- a/utils/kamctl/postgres/alias_db-create.sql
+++ b/utils/kamctl/postgres/alias_db-create.sql
@@ -4,9 +4,10 @@ CREATE TABLE dbaliases (
alias_username VARCHAR(64) DEFAULT '' NOT NULL,
alias_domain VARCHAR(64) DEFAULT '' NOT NULL,
username VARCHAR(64) DEFAULT '' NOT NULL,
- domain VARCHAR(64) DEFAULT '' NOT NULL,
- CONSTRAINT dbaliases_alias_idx UNIQUE (alias_username, alias_domain)
+ domain VARCHAR(64) DEFAULT '' NOT NULL
);
+CREATE INDEX dbaliases_alias_user_idx ON dbaliases (alias_username);
+CREATE INDEX dbaliases_alias_idx ON dbaliases (alias_username, alias_domain);
CREATE INDEX dbaliases_target_idx ON dbaliases (username, domain);
More information about the sr-dev
mailing list