From bafced8d1665bd9b8e3b8225ade993de377b439e Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Mon, 3 Mar 2003 07:07:17 +0000
Subject:  - user-defined parameters will overwrite already existing  (Alexei) 
 - fixed field order for PostgreSQL, table items (Alexei)

git-svn-id: svn://svn.zabbix.com/trunk@708 97f52cf1-0a1b-0410-bd0e-c28be96e8082
---
 create/postgresql/schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'create/postgresql/schema.sql')

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 723ffa91..7a43fb50 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -45,7 +45,6 @@ CREATE UNIQUE INDEX hosts_host on hosts (host);
 CREATE TABLE items (
   itemid		serial,
   type			int4		NOT NULL,
-  value_type		int4		DEFAULT '0'	NOT NULL,
   snmp_community	varchar(64)	DEFAULT ''	NOT NULL,
   snmp_oid		varchar(255)	DEFAULT ''	NOT NULL,
   snmp_port		int4		DEFAULT '161'	NOT NULL,
@@ -60,6 +59,7 @@ CREATE TABLE items (
   lastclock		int4		DEFAULT NULL,
   prevvalue		varchar(255)	DEFAULT NULL,
   status		int4		DEFAULT '0' NOT NULL,
+  value_type		int4		DEFAULT '0' NOT NULL,
   trapper_hosts		varchar(255)	DEFAULT '' NOT NULL,
   PRIMARY KEY (itemid),
   FOREIGN KEY (hostid) REFERENCES hosts
-- 
cgit 

