git:master:76835b62: kamctl: updates to sql creation scripts for rtpegine - sr-dev

2 Feb 2016

Module: kamailio
Branch: master
Commit: 76835b62986d2bb05b34c870b362126290b15317
URL: https://github.com/kamailio/kamailio/commit/76835b62986d2bb05b34c870b3621262...
Author: Daniel-Constantin Mierla miconda@gmail.com
Committer: Daniel-Constantin Mierla miconda@gmail.com
Date: 2016-02-02T16:46:49+01:00
kamctl: updates to sql creation scripts for rtpegine
---
Modified: utils/kamctl/db_sqlite/rtpengine-create.sql
Modified: utils/kamctl/mysql/rtpengine-create.sql
Modified: utils/kamctl/oracle/rtpengine-create.sql
Modified: utils/kamctl/postgres/rtpengine-create.sql
---
Diff:  https://github.com/kamailio/kamailio/commit/76835b62986d2bb05b34c870b3621262...
Patch: https://github.com/kamailio/kamailio/commit/76835b62986d2bb05b34c870b3621262...
---

diff --git a/utils/kamctl/db_sqlite/rtpengine-create.sql b/utils/kamctl/db_sqlite/rtpengine-create.sql
index 20c7358..c7bebb6 100644
--- a/utils/kamctl/db_sqlite/rtpengine-create.sql
+++ b/utils/kamctl/db_sqlite/rtpengine-create.sql
@@ -1,4 +1,3 @@
-INSERT INTO version (table_name, table_version) values ('rtpengine','1');
 CREATE TABLE rtpengine (
     setid INTEGER DEFAULT 0 NOT NULL,
     url VARCHAR(64) NOT NULL,
@@ -7,3 +6,5 @@ CREATE TABLE rtpengine (
     CONSTRAINT rtpengine_rtpengine_nodes PRIMARY KEY  (setid, url)
 );
+INSERT INTO version (table_name, table_version) values ('rtpengine','1');
+
diff --git a/utils/kamctl/mysql/rtpengine-create.sql b/utils/kamctl/mysql/rtpengine-create.sql
index 55662ae..156f1f4 100644
--- a/utils/kamctl/mysql/rtpengine-create.sql
+++ b/utils/kamctl/mysql/rtpengine-create.sql
@@ -1,4 +1,3 @@
-INSERT INTO version (table_name, table_version) values ('rtpengine','1');
 CREATE TABLE `rtpengine` (
     `setid` INT(10) UNSIGNED DEFAULT 0 NOT NULL,
     `url` VARCHAR(64) NOT NULL,
@@ -7,3 +6,5 @@ CREATE TABLE `rtpengine` (
     CONSTRAINT rtpengine_nodes PRIMARY KEY  (`setid`, `url`)
 );
+INSERT INTO version (table_name, table_version) values ('rtpengine','1');
+
diff --git a/utils/kamctl/oracle/rtpengine-create.sql b/utils/kamctl/oracle/rtpengine-create.sql
index 202764b..ab8eda9 100644
--- a/utils/kamctl/oracle/rtpengine-create.sql
+++ b/utils/kamctl/oracle/rtpengine-create.sql
@@ -1,4 +1,3 @@
-INSERT INTO version (table_name, table_version) values ('rtpengine','1');
 CREATE TABLE rtpengine (
     setid NUMBER(10) DEFAULT 0 NOT NULL,
     url VARCHAR2(64),
@@ -15,3 +14,5 @@ END rtpengine_tr;
 /
 BEGIN map2users('rtpengine'); END;
 /
+INSERT INTO version (table_name, table_version) values ('rtpengine','1');
+
diff --git a/utils/kamctl/postgres/rtpengine-create.sql b/utils/kamctl/postgres/rtpengine-create.sql
index 20c7358..c7bebb6 100644
--- a/utils/kamctl/postgres/rtpengine-create.sql
+++ b/utils/kamctl/postgres/rtpengine-create.sql
@@ -1,4 +1,3 @@
-INSERT INTO version (table_name, table_version) values ('rtpengine','1');
 CREATE TABLE rtpengine (
     setid INTEGER DEFAULT 0 NOT NULL,
     url VARCHAR(64) NOT NULL,
@@ -7,3 +6,5 @@ CREATE TABLE rtpengine (
     CONSTRAINT rtpengine_rtpengine_nodes PRIMARY KEY  (setid, url)
 );
+INSERT INTO version (table_name, table_version) values ('rtpengine','1');
+

    