diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-05-28 15:16:41 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-05-28 15:16:41 +0000 |
| commit | b3973f9d63fb49b36534ec7a963ec177c46d231c (patch) | |
| tree | aedb6bb55992b4000e75abb36a7afc20dbee54a2 /create/postgresql/schema.sql | |
| parent | 2dbb00f447292a94a24af7aa2b306c7c65d1a5ad (diff) | |
| download | zabbix-b3973f9d63fb49b36534ec7a963ec177c46d231c.tar.gz zabbix-b3973f9d63fb49b36534ec7a963ec177c46d231c.tar.xz zabbix-b3973f9d63fb49b36534ec7a963ec177c46d231c.zip | |
- improved monitoring of log files (Alexei)
- removed all pthread code (Alexei)
- added column items.lastlogsize (Alexei)
- added column screens_items.colspan (Alexei)
- support of colspan in screens (Alexei)
- added column media.period (Alexei)
- activity period for medias (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@1790 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 6c1f7131..cac5d9ac 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -75,6 +75,7 @@ CREATE TABLE items ( snmpv3_privpassphrase varchar(64) DEFAULT '' NOT NULL, formula varchar(255) DEFAULT '{.last(0)}' NOT NULL, error varchar(128) DEFAULT '' NOT NULL, + lastlogsize int4 DEFAULT '0' NOT NULL, PRIMARY KEY (itemid), FOREIGN KEY (hostid) REFERENCES hosts ); @@ -357,6 +358,7 @@ CREATE TABLE media ( sendto varchar(100) DEFAULT '' NOT NULL, active int4 DEFAULT '0' NOT NULL, severity int4 DEFAULT '63' NOT NULL, + period varchar(100) DEFAULT '1-7,00:00-23:59' NOT NULL, PRIMARY KEY (mediaid), FOREIGN KEY (userid) REFERENCES users, FOREIGN KEY (mediatypeid) REFERENCES media_type @@ -556,6 +558,7 @@ CREATE TABLE screens_items ( height int4 DEFAULT '200' NOT NULL, x int4 DEFAULT '0' NOT NULL, y int4 DEFAULT '0' NOT NULL, + colspan int4 DEFAULT '0' NOT NULL, PRIMARY KEY (screenitemid) ); |