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

[Daniel-Constantin Mierla]

Module: sip-router
Branch: master
Commit: 7436e3f66782597d66d052ee9c87bdb3b91756ef
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=7436e3f66782597d66d052ee9c87bdb3b91756ef

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at 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)
 );