4 files changed, 8 insertions, 2 deletions
diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql
index e8537cbb..8969c672 100644
--- a/create/mysql/schema.sql
+++ b/create/mysql/schema.sql
@@ -775,7 +775,8 @@ CREATE TABLE autoreg (
 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/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 16c2d383..4aafd179 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -770,6 +770,8 @@ CREATE TABLE valuemaps (
   PRIMARY KEY (valuemapid)
 );
 
+CREATE UNIQUE INDEX valuemaps_name on valuemaps (name);
+
 --
 -- Table structure for table 'mapping'
 --
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'
 --