Module: kamailio Branch: master Commit: b847ff224ac8e738e07f9631cb7ba27091d9b22b URL: https://github.com/kamailio/kamailio/commit/b847ff224ac8e738e07f9631cb7ba27… Author: Victor Seva <linuxmaniac(a)torreviejawireless.org> Committer: Victor Seva <linuxmaniac(a)torreviejawireless.org> Date: 2015-04-21T16:18:39+02:00 kamctl: upgrade schema for acc --- Modified: utils/kamctl/db_berkeley/kamailio/acc_cdrs Modified: utils/kamctl/db_sqlite/acc-create.sql Modified: utils/kamctl/mysql/acc-create.sql Modified: utils/kamctl/oracle/acc-create.sql Modified: utils/kamctl/postgres/acc-create.sql --- Diff: https://github.com/kamailio/kamailio/commit/b847ff224ac8e738e07f9631cb7ba27… Patch: https://github.com/kamailio/kamailio/commit/b847ff224ac8e738e07f9631cb7ba27… --- diff --git a/utils/kamctl/db_berkeley/kamailio/acc_cdrs b/utils/kamctl/db_berkeley/kamailio/acc_cdrs index 8eb3cbb..57ab533 100644 --- a/utils/kamctl/db_berkeley/kamailio/acc_cdrs +++ b/utils/kamctl/db_berkeley/kamailio/acc_cdrs @@ -7,4 +7,4 @@ METADATA_READONLY METADATA_LOGFLAGS 0 METADATA_DEFAULTS -NIL|''|''|'' +NIL|'2000-01-01 00:00:00'|'2000-01-01 00:00:00'|0 diff --git a/utils/kamctl/db_sqlite/acc-create.sql b/utils/kamctl/db_sqlite/acc-create.sql index d27d307..60b4193 100644 --- a/utils/kamctl/db_sqlite/acc-create.sql +++ b/utils/kamctl/db_sqlite/acc-create.sql @@ -15,9 +15,9 @@ CREATE INDEX acc_callid_idx ON acc (callid); INSERT INTO version (table_name, table_version) values ('acc_cdrs','2'); CREATE TABLE acc_cdrs ( id INTEGER PRIMARY KEY NOT NULL, - start_time TIMESTAMP WITHOUT TIME ZONE DEFAULT '' NOT NULL, - end_time TIMESTAMP WITHOUT TIME ZONE DEFAULT '' NOT NULL, - duration REAL DEFAULT '' NOT NULL + start_time TIMESTAMP WITHOUT TIME ZONE DEFAULT '2000-01-01 00:00:00' NOT NULL, + end_time TIMESTAMP WITHOUT TIME ZONE DEFAULT '2000-01-01 00:00:00' NOT NULL, + duration REAL DEFAULT 0 NOT NULL ); CREATE INDEX acc_cdrs_start_time_idx ON acc_cdrs (start_time); diff --git a/utils/kamctl/mysql/acc-create.sql b/utils/kamctl/mysql/acc-create.sql index c088ca4..0d02811 100644 --- a/utils/kamctl/mysql/acc-create.sql +++ b/utils/kamctl/mysql/acc-create.sql @@ -15,9 +15,9 @@ CREATE INDEX callid_idx ON acc (callid); INSERT INTO version (table_name, table_version) values ('acc_cdrs','2'); CREATE TABLE acc_cdrs ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, - start_time DATETIME DEFAULT '' NOT NULL, - end_time DATETIME DEFAULT '' NOT NULL, - duration FLOAT(10,3) DEFAULT '' NOT NULL + start_time DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL, + end_time DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL, + duration FLOAT(10,3) DEFAULT 0 NOT NULL ); CREATE INDEX start_time_idx ON acc_cdrs (start_time); diff --git a/utils/kamctl/oracle/acc-create.sql b/utils/kamctl/oracle/acc-create.sql index b84a97b..2a71e85 100644 --- a/utils/kamctl/oracle/acc-create.sql +++ b/utils/kamctl/oracle/acc-create.sql @@ -23,9 +23,9 @@ CREATE INDEX acc_callid_idx ON acc (callid); INSERT INTO version (table_name, table_version) values ('acc_cdrs','2'); CREATE TABLE acc_cdrs ( id NUMBER(10) PRIMARY KEY, - start_time DATE DEFAULT '', - end_time DATE DEFAULT '', - duration NUMBER(10,3) DEFAULT '' + start_time DATE DEFAULT '2000-01-01 00:00:00', + end_time DATE DEFAULT '2000-01-01 00:00:00', + duration NUMBER(10,3) DEFAULT 0 NOT NULL ); CREATE OR REPLACE TRIGGER acc_cdrs_tr diff --git a/utils/kamctl/postgres/acc-create.sql b/utils/kamctl/postgres/acc-create.sql index 8ae4336..713514f 100644 --- a/utils/kamctl/postgres/acc-create.sql +++ b/utils/kamctl/postgres/acc-create.sql @@ -15,9 +15,9 @@ CREATE INDEX acc_callid_idx ON acc (callid); INSERT INTO version (table_name, table_version) values ('acc_cdrs','2'); CREATE TABLE acc_cdrs ( id SERIAL PRIMARY KEY NOT NULL, - start_time TIMESTAMP WITHOUT TIME ZONE DEFAULT '' NOT NULL, - end_time TIMESTAMP WITHOUT TIME ZONE DEFAULT '' NOT NULL, - duration REAL DEFAULT '' NOT NULL + start_time TIMESTAMP WITHOUT TIME ZONE DEFAULT '2000-01-01 00:00:00' NOT NULL, + end_time TIMESTAMP WITHOUT TIME ZONE DEFAULT '2000-01-01 00:00:00' NOT NULL, + duration REAL DEFAULT 0 NOT NULL ); CREATE INDEX acc_cdrs_start_time_idx ON acc_cdrs (start_time);