From 30b46c6db471f4277b2f062941345cf84e3b41aa Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Wed, 30 May 2001 08:45:32 +0000
Subject: Minor changes.

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 02a6cb91..50d20dae 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -1,30 +1,17 @@
 \connect zabbix
 
---
--- Table structure for table 'platforms'
---
-
---CREATE TABLE platforms (
---  platformid		serial,
---  platform		varchar(32)	DEFAULT '' NOT NULL,
---  PRIMARY KEY (platformid)
---);
-
 --
 -- Table structure for table 'hosts'
 --
 
 CREATE TABLE hosts (
   hostid		serial,
---platformid		int4		NOT NULL,
   host			varchar(64)	DEFAULT '' NOT NULL,
   port			int4		DEFAULT '0' NOT NULL,
   status		int4		DEFAULT '0' NOT NULL,
   PRIMARY KEY (hostid)
---FOREIGN KEY (platformid) REFERENCES platforms
 );
 
---CREATE INDEX hosts_platformid on hosts (platformid);
 CREATE INDEX hosts_status on hosts (status);
 
 --
@@ -198,17 +185,13 @@ CREATE TABLE history (
 
 CREATE TABLE items_template (
   itemtemplateid	int4		NOT NULL,
---  platformid		int4		NOT NULL,
   description		varchar(255)	DEFAULT '' NOT NULL,
   key_			varchar(64)	DEFAULT '' NOT NULL,
   delay			int4		DEFAULT '0' NOT NULL,
   PRIMARY KEY (itemtemplateid)
---  FOREIGN KEY (platformid) REFERENCES platforms
 );
 
---CREATE UNIQUE INDEX items_template_p_k on items_template (platformid, key_);
 CREATE UNIQUE INDEX items_template_p_k on items_template (key_);
---CREATE INDEX items_template_itemid on items_template (platformid);
 
 --
 -- Table structure for table 'triggers_template'
@@ -236,3 +219,5 @@ CREATE TABLE media (
   PRIMARY KEY (mediaid),
   FOREIGN KEY (userid) REFERENCES users
 );
+
+VACUUM ANALYZE;
-- 
cgit 

