diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-02-21 11:54:22 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-02-21 11:54:22 +0000 |
| commit | 8ffd7881d8c2cbefe8d11dc0f590b025e5a32007 (patch) | |
| tree | dfd439071f712c450dd26188a5dd1b5d77539513 /upgrades/dbpatches | |
| parent | ea8dd6d996d195ae41d648a1e4fe19c756925631 (diff) | |
| download | zabbix-8ffd7881d8c2cbefe8d11dc0f590b025e5a32007.tar.gz zabbix-8ffd7881d8c2cbefe8d11dc0f590b025e5a32007.tar.xz zabbix-8ffd7881d8c2cbefe8d11dc0f590b025e5a32007.zip | |
Minor changes.
git-svn-id: svn://svn.zabbix.com/trunk@2665 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'upgrades/dbpatches')
| -rw-r--r-- | upgrades/dbpatches/1.1beta6_to_1.1beta7/mysql/patch.sql | 3 | ||||
| -rw-r--r-- | upgrades/dbpatches/1.1beta6_to_1.1beta7/postgresql/patch.sql | 2 |
2 files changed, 4 insertions, 1 deletions
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' -- |