[sr-dev] git:master:76835b62: kamctl: updates to sql creation scripts for rtpegine
Daniel-Constantin Mierla
miconda at gmail.com
Tue Feb 2 16:55:06 CET 2016
Module: kamailio
Branch: master
Commit: 76835b62986d2bb05b34c870b362126290b15317
URL: https://github.com/kamailio/kamailio/commit/76835b62986d2bb05b34c870b362126290b15317
Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at 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/76835b62986d2bb05b34c870b362126290b15317.diff
Patch: https://github.com/kamailio/kamailio/commit/76835b62986d2bb05b34c870b362126290b15317.patch
---
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');
+
More information about the sr-dev
mailing list