[sr-dev] git:master:d3e45d32: utils/kamctl: updated sql scripts for table version

Module: kamailio Branch: master Commit: d3e45d3204a9966f9beb5135082e3870c528c1ba URL: https://github.com/kamailio/kamailio/commit/d3e45d3204a9966f9beb5135082e387… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: 2015-11-30T09:17:06+01:00 utils/kamctl: updated sql scripts for table version --- Modified: utils/kamctl/db_berkeley/kamailio/version Modified: utils/kamctl/db_sqlite/standard-create.sql Modified: utils/kamctl/dbtext/kamailio/version Modified: utils/kamctl/mysql/standard-create.sql Modified: utils/kamctl/oracle/standard-create.sql Modified: utils/kamctl/postgres/standard-create.sql --- Diff: https://github.com/kamailio/kamailio/commit/d3e45d3204a9966f9beb5135082e387… Patch: https://github.com/kamailio/kamailio/commit/d3e45d3204a9966f9beb5135082e387… --- diff --git a/utils/kamctl/db_berkeley/kamailio/version b/utils/kamctl/db_berkeley/kamailio/version index de38c48..5796a95 100644 --- a/utils/kamctl/db_berkeley/kamailio/version +++ b/utils/kamctl/db_berkeley/kamailio/version @@ -8,6 +8,8 @@ METADATA_LOGFLAGS 0 METADATA_DEFAULTS NIL|0 +version| +version|1 acc| acc|5 acc_cdrs| diff --git a/utils/kamctl/db_sqlite/standard-create.sql b/utils/kamctl/db_sqlite/standard-create.sql index ae5ce2a..b576b1a 100644 --- a/utils/kamctl/db_sqlite/standard-create.sql +++ b/utils/kamctl/db_sqlite/standard-create.sql @@ -1,3 +1,4 @@ +INSERT INTO version (table_name, table_version) values ('version','1'); CREATE TABLE version ( table_name VARCHAR(32) NOT NULL, table_version INTEGER DEFAULT 0 NOT NULL, diff --git a/utils/kamctl/dbtext/kamailio/version b/utils/kamctl/dbtext/kamailio/version index 899ab5a..adcfd00 100644 --- a/utils/kamctl/dbtext/kamailio/version +++ b/utils/kamctl/dbtext/kamailio/version @@ -1,4 +1,5 @@ table_name(string) table_version(int) +version:1 acc:5 acc_cdrs:2 active_watchers:11 diff --git a/utils/kamctl/mysql/standard-create.sql b/utils/kamctl/mysql/standard-create.sql index eeeacf9..588b332 100644 --- a/utils/kamctl/mysql/standard-create.sql +++ b/utils/kamctl/mysql/standard-create.sql @@ -1,3 +1,4 @@ +INSERT INTO version (table_name, table_version) values ('version','1'); CREATE TABLE `version` ( `table_name` VARCHAR(32) NOT NULL, `table_version` INT UNSIGNED DEFAULT 0 NOT NULL, diff --git a/utils/kamctl/oracle/standard-create.sql b/utils/kamctl/oracle/standard-create.sql index 6f29e49..d4407fb 100644 --- a/utils/kamctl/oracle/standard-create.sql +++ b/utils/kamctl/oracle/standard-create.sql @@ -1,3 +1,4 @@ +INSERT INTO version (table_name, table_version) values ('version','1'); CREATE TABLE version ( table_name VARCHAR2(32), table_version NUMBER(10) DEFAULT 0 NOT NULL, diff --git a/utils/kamctl/postgres/standard-create.sql b/utils/kamctl/postgres/standard-create.sql index ae5ce2a..b576b1a 100644 --- a/utils/kamctl/postgres/standard-create.sql +++ b/utils/kamctl/postgres/standard-create.sql @@ -1,3 +1,4 @@ +INSERT INTO version (table_name, table_version) values ('version','1'); CREATE TABLE version ( table_name VARCHAR(32) NOT NULL, table_version INTEGER DEFAULT 0 NOT NULL,