summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.3/postgresql/patch/drules.sql
diff options
context:
space:
mode:
authoralex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2007-03-15 17:54:37 +0000
committeralex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2007-03-15 17:54:37 +0000
commit1f5a4a142c53921b74238aa93934be448be5e36f (patch)
tree4335ada21366762d2117c43362da531f73dffdcb /upgrades/dbpatches/1.3/postgresql/patch/drules.sql
parentf459deea77b1b44cff468c5b22fb5137f502a33b (diff)
downloadzabbix-1f5a4a142c53921b74238aa93934be448be5e36f.tar.gz
zabbix-1f5a4a142c53921b74238aa93934be448be5e36f.tar.xz
zabbix-1f5a4a142c53921b74238aa93934be448be5e36f.zip
- 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
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/drules.sql')
-rw-r--r--upgrades/dbpatches/1.3/postgresql/patch/drules.sql14
1 files changed, 14 insertions, 0 deletions
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)
+);