summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2005-10-03 14:14:39 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2005-10-03 14:14:39 +0000
commita4bb707afc71f1060abd3f27f7b9a4f12c4bfff6 (patch)
tree2c79855b2cf754153271dbaf98c3fa97d4f1a4c9 /create/postgresql/schema.sql
parent5ff76a8be623db727c9931913a6513d7c19a116a (diff)
downloadzabbix-a4bb707afc71f1060abd3f27f7b9a4f12c4bfff6.tar.gz
zabbix-a4bb707afc71f1060abd3f27f7b9a4f12c4bfff6.tar.xz
zabbix-a4bb707afc71f1060abd3f27f7b9a4f12c4bfff6.zip
- added new table autoreg (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@2088 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
-rw-r--r--create/postgresql/schema.sql12
1 files changed, 12 insertions, 0 deletions
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;