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

Module: kamailio Branch: master Commit: 76835b62986d2bb05b34c870b362126290b15317 URL: https://github.com/kamailio/kamailio/commit/76835b62986d2bb05b34c870b362126… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)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/76835b62986d2bb05b34c870b362126… Patch: https://github.com/kamailio/kamailio/commit/76835b62986d2bb05b34c870b362126… --- 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'); +