From a4bb707afc71f1060abd3f27f7b9a4f12c4bfff6 Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Mon, 3 Oct 2005 14:14:39 +0000
Subject:  - added new table autoreg (Alexei)

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 6bd5fa95..ab44e29b 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -706,4 +706,16 @@ CREATE TABLE history_log (
 
 CREATE INDEX history_log_i_c on history_str (itemid, clock);
 
+--
+-- Table structure for table 'autoreg'
+--
+
+CREATE TABLE autoreg (
+  id                    serial,
+  priority              int4		DEFAULT '0' NOT NULL,
+  pattern               varchar(255)	DEFAULT '' NOT NULL,
+  hostid                int4		DEFAULT '0' NOT NULL,
+  PRIMARY KEY (id)
+);
+
 VACUUM ANALYZE;
-- 
cgit 

