From 15377955b388639cbfdcbbe684e09f2bde30cafa Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Fri, 22 Jun 2001 20:20:43 +0000
Subject: Support for table sysmaps.

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 65e53fad..754b73b3 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -1,5 +1,19 @@
 \connect zabbix
 
+--
+-- Table structure for table 'sysmaps'
+--
+
+CREATE TABLE sysmaps (
+  sysmapid		serial,
+  name			varchar(128)	DEFAULT '' NOT NULL,
+  width			int4		DEFAULT '0' NOT NULL,
+  height		int4		DEFAULT '0' NOT NULL,
+  PRIMARY KEY (sysmapid)
+);
+
+CREATE UNIQUE INDEX sysmaps_name on sysmaps (name);
+
 --
 -- Table structure for table 'hosts'
 --
-- 
cgit 

