- added tables valuemaps and mappings (Alexei)

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

1 files changed, 24 insertions, 0 deletions

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;