summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.4/postgresql/patch/httptestitem.sql
diff options
context:
space:
mode:
authoralex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2007-06-22 18:12:58 +0000
committeralex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2007-06-22 18:12:58 +0000
commit901b9d2bd5c402e45526e151604afd119c6e0ec1 (patch)
tree94de1db7561d6cfe82b41cbc803011a2ab932eb0 /upgrades/dbpatches/1.4/postgresql/patch/httptestitem.sql
parentf4af73c3a3b19f6f850c2eda0717272ca9b24001 (diff)
downloadzabbix-901b9d2bd5c402e45526e151604afd119c6e0ec1.tar.gz
zabbix-901b9d2bd5c402e45526e151604afd119c6e0ec1.tar.xz
zabbix-901b9d2bd5c402e45526e151604afd119c6e0ec1.zip
- fixed PostgreSQL upgrade patch (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@4353 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'upgrades/dbpatches/1.4/postgresql/patch/httptestitem.sql')
-rw-r--r--upgrades/dbpatches/1.4/postgresql/patch/httptestitem.sql3
1 files changed, 1 insertions, 2 deletions
diff --git a/upgrades/dbpatches/1.4/postgresql/patch/httptestitem.sql b/upgrades/dbpatches/1.4/postgresql/patch/httptestitem.sql
index 17ffd7c3..9c12b040 100644
--- a/upgrades/dbpatches/1.4/postgresql/patch/httptestitem.sql
+++ b/upgrades/dbpatches/1.4/postgresql/patch/httptestitem.sql
@@ -4,5 +4,4 @@ CREATE TABLE httptestitem (
itemid bigint DEFAULT '0' NOT NULL,
type integer DEFAULT '0' NOT NULL,
PRIMARY KEY (httptestitemid)
-);
-CREATE UNIQUE INDEX httptestitem_httptestitem_1 on httptestitem (httptestid,itemid);
+) with OIDS;