[sr-dev] git:master:de953dfb: kamctl: refreshed db creation scripts for sql databases

[Daniel-Constantin Mierla]

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

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: 2017-07-11T12:36:07+02:00

kamctl: refreshed db creation scripts for sql databases

---

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/de953dfb93cfc3a14295f4167af01e522444b066.diff
Patch: https://github.com/kamailio/kamailio/commit/de953dfb93cfc3a14295f4167af01e522444b066.patch

---

diff --git a/utils/kamctl/db_sqlite/rtpengine-create.sql b/utils/kamctl/db_sqlite/rtpengine-create.sql
index 43fc12dd4f..1af1a9a4b5 100644
--- a/utils/kamctl/db_sqlite/rtpengine-create.sql
+++ b/utils/kamctl/db_sqlite/rtpengine-create.sql
@@ -5,7 +5,7 @@ CREATE TABLE rtpengine (
     weight INTEGER DEFAULT 1 NOT NULL,
     disabled INTEGER DEFAULT 0 NOT NULL,
     stamp TIMESTAMP WITHOUT TIME ZONE DEFAULT '1900-01-01 00:00:01' NOT NULL,
-    CONSTRAINT rtpengine_rtpengine_nodes PRIMARY KEY  (setid, url)
+    CONSTRAINT rtpengine_rtpengine_nodes UNIQUE (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 29dbf12683..a0c7dd6386 100644
--- a/utils/kamctl/mysql/rtpengine-create.sql
+++ b/utils/kamctl/mysql/rtpengine-create.sql
@@ -5,7 +5,7 @@ CREATE TABLE `rtpengine` (
     `weight` INT(10) UNSIGNED DEFAULT 1 NOT NULL,
     `disabled` INT(1) DEFAULT 0 NOT NULL,
     `stamp` DATETIME DEFAULT '1900-01-01 00:00:01' NOT NULL,
-    CONSTRAINT rtpengine_nodes PRIMARY KEY  (`setid`, `url`)
+    CONSTRAINT rtpengine_nodes UNIQUE (`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 12626739bc..0392580244 100644
--- a/utils/kamctl/oracle/rtpengine-create.sql
+++ b/utils/kamctl/oracle/rtpengine-create.sql
@@ -5,7 +5,7 @@ CREATE TABLE rtpengine (
     weight NUMBER(10) DEFAULT 1 NOT NULL,
     disabled NUMBER(10) DEFAULT 0 NOT NULL,
     stamp DATE DEFAULT '1900-01-01 00:00:01',
-    CONSTRAINT rtpengine_rtpengine_nodes  PRIMARY KEY  (setid, url)
+    CONSTRAINT rtpengine_rtpengine_nodes  UNIQUE (setid, url)
 );
 
 CREATE OR REPLACE TRIGGER rtpengine_tr
diff --git a/utils/kamctl/postgres/rtpengine-create.sql b/utils/kamctl/postgres/rtpengine-create.sql
index c0f0ec22cb..a6536e551d 100644
--- a/utils/kamctl/postgres/rtpengine-create.sql
+++ b/utils/kamctl/postgres/rtpengine-create.sql
@@ -5,7 +5,7 @@ CREATE TABLE rtpengine (
     weight INTEGER DEFAULT 1 NOT NULL,
     disabled INTEGER DEFAULT 0 NOT NULL,
     stamp TIMESTAMP WITHOUT TIME ZONE DEFAULT '1900-01-01 00:00:01' NOT NULL,
-    CONSTRAINT rtpengine_rtpengine_nodes PRIMARY KEY  (setid, url)
+    CONSTRAINT rtpengine_rtpengine_nodes UNIQUE (setid, url)
 );
 
 INSERT INTO version (table_name, table_version) values ('rtpengine','1');