From 329c71b3ab547107d5ea8f9c3add62522b1fbe0d Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Tue, 7 Feb 2006 16:29:18 +0000
Subject:  - added hosts.templateid and items.templateid (Alexei)

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index b925fbac..ada6dfff 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -34,6 +34,7 @@ CREATE TABLE hosts (
   error			varchar(128)	DEFAULT ''		NOT NULL,
   available		int4		DEFAULT '0'		NOT NULL,
   errors_from		int4		DEFAULT '0'		NOT NULL,
+  templateid		int4		DEFAULT '0'		NOT NULL,
   PRIMARY KEY (hostid)
 );
 
@@ -77,6 +78,7 @@ CREATE TABLE items (
   error			varchar(128)	DEFAULT '' NOT NULL,
   lastlogsize		int4		DEFAULT '0' NOT NULL,
   logtimefmt		varchar(64)	DEFAULT '' NOT NULL,
+  templateid		int4		DEFAULT '0' NOT NULL,
   PRIMARY KEY (itemid),
   FOREIGN KEY (hostid) REFERENCES hosts
 );
-- 
cgit 

