Minor changes.

git-svn-id: svn://svn.zabbix.com/trunk@79 97f52cf1-0a1b-0410-bd0e-c28be96e8082

1 files changed, 2 insertions, 17 deletions

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;