From dd1e1557c1280b9517c5ca6ab9c024d00b87f669 Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Mon, 20 Feb 2006 14:15:16 +0000
Subject:  - added tables valuemaps and mappings (Alexei)

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 21c3c0ef..16c2d383 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -760,4 +760,28 @@ CREATE TABLE autoreg (
   PRIMARY KEY (id)
 );
 
+--
+-- Table structure for table 'valuemaps'
+--
+
+CREATE TABLE valuemaps (
+  valuemapid		serial,
+  name			varchar(64)	DEFAULT '' NOT NULL,
+  PRIMARY KEY (valuemapid)
+);
+
+--
+-- Table structure for table 'mapping'
+--
+
+CREATE TABLE mappings (
+  mappingid		serial,
+  valuemapid		int4		DEFAULT '0' NOT NULL,
+  value			varchar(64)	DEFAULT '' NOT NULL,
+  newvalue		varchar(64)	DEFAULT '' NOT NULL,
+  PRIMARY KEY (mappingid),
+);
+
+CREATE INDEX mappings_valuemapid on mappings (valuemapid);
+
 VACUUM ANALYZE;
-- 
cgit 

