From 8ffd7881d8c2cbefe8d11dc0f590b025e5a32007 Mon Sep 17 00:00:00 2001 From: hugetoad Date: Tue, 21 Feb 2006 11:54:22 +0000 Subject: Minor changes. git-svn-id: svn://svn.zabbix.com/trunk@2665 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- upgrades/dbpatches/1.1beta6_to_1.1beta7/mysql/patch.sql | 3 ++- upgrades/dbpatches/1.1beta6_to_1.1beta7/postgresql/patch.sql | 2 ++ 2 files changed, 4 insertions(+), 1 deletion(-) (limited to 'upgrades/dbpatches') diff --git a/upgrades/dbpatches/1.1beta6_to_1.1beta7/mysql/patch.sql b/upgrades/dbpatches/1.1beta6_to_1.1beta7/mysql/patch.sql index 2dffd403..3a980d9a 100644 --- a/upgrades/dbpatches/1.1beta6_to_1.1beta7/mysql/patch.sql +++ b/upgrades/dbpatches/1.1beta6_to_1.1beta7/mysql/patch.sql @@ -10,7 +10,8 @@ alter table graphs add templateid int(4) DEFAULT '0' NOT NULL; CREATE TABLE valuemaps ( valuemapid int(4) NOT NULL auto_increment, name varchar(64) DEFAULT '' NOT NULL, - PRIMARY KEY (valuemapid) + PRIMARY KEY (valuemapid), + UNIQUE (name) ) type=InnoDB; -- diff --git a/upgrades/dbpatches/1.1beta6_to_1.1beta7/postgresql/patch.sql b/upgrades/dbpatches/1.1beta6_to_1.1beta7/postgresql/patch.sql index 54bab225..2a8eb266 100644 --- a/upgrades/dbpatches/1.1beta6_to_1.1beta7/postgresql/patch.sql +++ b/upgrades/dbpatches/1.1beta6_to_1.1beta7/postgresql/patch.sql @@ -13,6 +13,8 @@ CREATE TABLE valuemaps ( PRIMARY KEY (valuemapid) ); +CREATE UNIQUE INDEX valuemaps_name on valuemaps (name); + -- -- Table structure for table 'mapping' -- -- cgit