Module: sip-router Branch: master Commit: 7436e3f66782597d66d052ee9c87bdb3b91756ef URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=7436e3f6...
Author: Daniel-Constantin Mierla miconda@gmail.com Committer: Daniel-Constantin Mierla miconda@gmail.com Date: Mon Nov 11 11:21:21 2013 +0100
kamctl: regenerated db schema scripts
- updated after mohqueue default date change
---
utils/kamctl/db_berkeley/kamailio/mohqcalls | 2 +- utils/kamctl/db_sqlite/mohqueue-create.sql | 2 +- utils/kamctl/mysql/mohqueue-create.sql | 2 +- utils/kamctl/oracle/mohqueue-create.sql | 2 +- utils/kamctl/postgres/mohqueue-create.sql | 2 +- 5 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/utils/kamctl/db_berkeley/kamailio/mohqcalls b/utils/kamctl/db_berkeley/kamailio/mohqcalls index 0ecaef4..3cb22c7 100644 --- a/utils/kamctl/db_berkeley/kamailio/mohqcalls +++ b/utils/kamctl/db_berkeley/kamailio/mohqcalls @@ -7,4 +7,4 @@ METADATA_READONLY METADATA_LOGFLAGS 0 METADATA_DEFAULTS -NIL|NIL|NIL|NIL|NIL|NIL|'to_date('','yyyy-mm-dd hh24:mi:ss')' +NIL|NIL|NIL|NIL|NIL|NIL|NIL diff --git a/utils/kamctl/db_sqlite/mohqueue-create.sql b/utils/kamctl/db_sqlite/mohqueue-create.sql index cc1535b..3989fe8 100644 --- a/utils/kamctl/db_sqlite/mohqueue-create.sql +++ b/utils/kamctl/db_sqlite/mohqueue-create.sql @@ -6,7 +6,7 @@ CREATE TABLE mohqcalls ( call_status INTEGER NOT NULL, call_from VARCHAR(100) NOT NULL, call_contact VARCHAR(100), - call_time TIMESTAMP WITHOUT TIME ZONE DEFAULT 'to_date('','yyyy-mm-dd hh24:mi:ss')' NOT NULL, + call_time TIMESTAMP WITHOUT TIME ZONE NOT NULL, CONSTRAINT mohqcalls_mohqcalls_idx UNIQUE (call_id) );
diff --git a/utils/kamctl/mysql/mohqueue-create.sql b/utils/kamctl/mysql/mohqueue-create.sql index 7b8e776..4326fe4 100644 --- a/utils/kamctl/mysql/mohqueue-create.sql +++ b/utils/kamctl/mysql/mohqueue-create.sql @@ -6,7 +6,7 @@ CREATE TABLE mohqcalls ( call_status INT UNSIGNED NOT NULL, call_from VARCHAR(100) NOT NULL, call_contact VARCHAR(100), - call_time DATETIME DEFAULT 'to_date('','yyyy-mm-dd hh24:mi:ss')' NOT NULL, + call_time DATETIME NOT NULL, CONSTRAINT mohqcalls_idx UNIQUE (call_id) );
diff --git a/utils/kamctl/oracle/mohqueue-create.sql b/utils/kamctl/oracle/mohqueue-create.sql index 7ef6547..1ffec50 100644 --- a/utils/kamctl/oracle/mohqueue-create.sql +++ b/utils/kamctl/oracle/mohqueue-create.sql @@ -6,7 +6,7 @@ CREATE TABLE mohqcalls ( call_status NUMBER(10), call_from VARCHAR2(100), call_contact VARCHAR2(100), - call_time DATE DEFAULT to_date('','yyyy-mm-dd hh24:mi:ss'), + call_time DATE, CONSTRAINT mohqcalls_mohqcalls_idx UNIQUE (call_id) );
diff --git a/utils/kamctl/postgres/mohqueue-create.sql b/utils/kamctl/postgres/mohqueue-create.sql index b9058e4..1dc12ff 100644 --- a/utils/kamctl/postgres/mohqueue-create.sql +++ b/utils/kamctl/postgres/mohqueue-create.sql @@ -6,7 +6,7 @@ CREATE TABLE mohqcalls ( call_status INTEGER NOT NULL, call_from VARCHAR(100) NOT NULL, call_contact VARCHAR(100), - call_time TIMESTAMP WITHOUT TIME ZONE DEFAULT 'to_date('','yyyy-mm-dd hh24:mi:ss')' NOT NULL, + call_time TIMESTAMP WITHOUT TIME ZONE NOT NULL, CONSTRAINT mohqcalls_mohqcalls_idx UNIQUE (call_id) );
-
Daniel-Constantin Mierla