diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-11-24 14:20:36 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-11-24 14:20:36 +0000 |
| commit | 772e6d0f37d4533b39a51f7b5c42c618e6af7c13 (patch) | |
| tree | d49130bb4b0f06ab440dd288cabeccfb5918a94b /create/postgresql/schema.sql | |
| parent | 3013847c08c1b9c6e8941cbaeb0d2da7cdb002b5 (diff) | |
| download | zabbix-772e6d0f37d4533b39a51f7b5c42c618e6af7c13.tar.gz zabbix-772e6d0f37d4533b39a51f7b5c42c618e6af7c13.tar.xz zabbix-772e6d0f37d4533b39a51f7b5c42c618e6af7c13.zip | |
- added columns alert_history and alarm_history to table config (Alexei)
- added link from graphs to trends and vs (Alexei)
- housekeeping process in zabbix_suckerd will also delete old records from tables
alerts and alarms (Alexei)
- added directory upgrades/dbpatches/1.0alpha11_to_1.0alpha12 (Alexei)
- added index on column "clock" for table alarms (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@252 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index bf7913ac..504dac74 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -53,7 +53,9 @@ CREATE TABLE config ( smtp_server varchar(255) DEFAULT '' NOT NULL, smtp_helo varchar(255) DEFAULT '' NOT NULL, smtp_email varchar(255) DEFAULT '' NOT NULL, - password_required int4 DEFAULT '0' NOT NULL + password_required int4 DEFAULT '0' NOT NULL, + alert_history int4 DEFAULT '0' NOT NULL, + alarm_history int4 DEFAULT '0' NOT NULL ); -- @@ -165,6 +167,7 @@ CREATE TABLE alarms ( ); CREATE INDEX alarms_triggerid_clock on alarms (triggerid, clock); +CREATE INDEX alarms_clock on alarms (clock); -- -- Table structure for table 'functions' |