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

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