From 1f5a4a142c53921b74238aa93934be448be5e36f Mon Sep 17 00:00:00 2001
From: alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Thu, 15 Mar 2007 17:54:37 +0000
Subject:  - new tables drules,dchecks,dhosts,dservices (Alexei)  - basic
 support of auto-discovery (Alexei)  - new Server parameter StartDiscoverers
 (Alexei)

git-svn-id: svn://svn.zabbix.com/trunk@3890 97f52cf1-0a1b-0410-bd0e-c28be96e8082
---
 upgrades/dbpatches/1.3/postgresql/patch/drules.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 upgrades/dbpatches/1.3/postgresql/patch/drules.sql

(limited to 'upgrades/dbpatches/1.3/postgresql/patch/drules.sql')

diff --git a/upgrades/dbpatches/1.3/postgresql/patch/drules.sql b/upgrades/dbpatches/1.3/postgresql/patch/drules.sql
new file mode 100644
index 00000000..f05f14b9
--- /dev/null
+++ b/upgrades/dbpatches/1.3/postgresql/patch/drules.sql
@@ -0,0 +1,14 @@
+CREATE TABLE drules (
+        druleid         bigint DEFAULT '0'     NOT NULL,
+        name            varchar(255)            DEFAULT ''      NOT NULL,
+        ipfirst         varchar(15)             DEFAULT ''      NOT NULL,
+        iplast          varchar(15)             DEFAULT ''      NOT NULL,
+        delay           integer         DEFAULT '0'     NOT NULL,
+        nextcheck       integer         DEFAULT '0'     NOT NULL,
+        status          integer         DEFAULT '0'     NOT NULL,
+        upevent         integer         DEFAULT '0'     NOT NULL,
+        downevent               integer         DEFAULT '0'     NOT NULL,
+        svcupevent              integer         DEFAULT '0'     NOT NULL,
+        svcdownevent            integer         DEFAULT '0'     NOT NULL,
+        PRIMARY KEY (druleid)
+);
-- 
cgit 

