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

Daniel-Constantin Mierla miconda at gmail.com
Mon Nov 30 09:17:39 CET 2015


Module: kamailio
Branch: master
Commit: d3e45d3204a9966f9beb5135082e3870c528c1ba
URL: https://github.com/kamailio/kamailio/commit/d3e45d3204a9966f9beb5135082e3870c528c1ba

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at 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/d3e45d3204a9966f9beb5135082e3870c528c1ba.diff
Patch: https://github.com/kamailio/kamailio/commit/d3e45d3204a9966f9beb5135082e3870c528c1ba.patch

---

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,




More information about the sr-dev mailing list