From 2c88dcbac3de23650e7fccaa91f003e9ae54550d Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Tue, 3 Jul 2001 06:07:26 +0000
Subject: Patches for alpha6->alpha7. Fixed bug with lost  status of trigger.

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index c002a55b..366e4dd6 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -241,21 +241,6 @@ CREATE UNIQUE INDEX sysmaps_name on sysmaps (name);
 -- Table structure for table 'sysmaps_hosts'
 --
 
-CREATE TABLE sysmaps_links (
-  linkid		serial,
-  sysmapid		int4		DEFAULT '0' NOT NULL,
-  shostid1		int4		DEFAULT '0' NOT NULL,
-  shostid2		int4		DEFAULT '0' NOT NULL,
-  PRIMARY KEY (linkid),
-  FOREIGN KEY (sysmapid) REFERENCES sysmaps,
-  FOREIGN KEY (shostid1) REFERENCES sysmaps_hosts,
-  FOREIGN KEY (shostid2) REFERENCES sysmaps_hosts
-);
-
---
--- Table structure for table 'sysmaps_hosts'
---
-
 CREATE TABLE sysmaps_hosts (
   shostid		serial,
   sysmapid		int4		DEFAULT '0' NOT NULL,
@@ -268,6 +253,21 @@ CREATE TABLE sysmaps_hosts (
   FOREIGN KEY (hostid) REFERENCES hosts
 );
 
+--
+-- Table structure for table 'sysmaps_links'
+--
+
+CREATE TABLE sysmaps_links (
+  linkid		serial,
+  sysmapid		int4		DEFAULT '0' NOT NULL,
+  shostid1		int4		DEFAULT '0' NOT NULL,
+  shostid2		int4		DEFAULT '0' NOT NULL,
+  PRIMARY KEY (linkid),
+  FOREIGN KEY (sysmapid) REFERENCES sysmaps,
+  FOREIGN KEY (shostid1) REFERENCES sysmaps_hosts,
+  FOREIGN KEY (shostid2) REFERENCES sysmaps_hosts
+);
+
 --
 -- Table structure for table 'graphs'
 --
-- 
cgit 

