diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-04-21 11:11:25 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-04-21 11:11:25 +0000 |
| commit | 39e1ce46747b38b39dcdd961a579fe3041ec8960 (patch) | |
| tree | e00630deceac0059ad6d3ec917998f5118c67b49 /create/postgresql/schema.sql | |
| parent | 8bbc3250ea4573531d19a43c41264230d1346a3a (diff) | |
| download | zabbix-39e1ce46747b38b39dcdd961a579fe3041ec8960.tar.gz zabbix-39e1ce46747b38b39dcdd961a579fe3041ec8960.tar.xz zabbix-39e1ce46747b38b39dcdd961a579fe3041ec8960.zip | |
- added column alerts.userid (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@2759 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 54522d18..f642aa3b 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -264,6 +264,7 @@ CREATE TABLE alerts ( alertid serial, actionid int4 DEFAULT '0' NOT NULL, triggerid int4 DEFAULT '0' NOT NULL, + userid int4 DEFAULT '0' NOT NULL, clock int4 DEFAULT '0' NOT NULL, -- type varchar(10) DEFAULT '' NOT NULL, mediatypeid int4 DEFAULT '0' NOT NULL, @@ -286,6 +287,7 @@ CREATE TABLE alerts ( CREATE INDEX alerts_actionid on alerts (actionid); CREATE INDEX alerts_clock on alerts (clock); CREATE INDEX alerts_status_retires on alerts (status,retries); +CREATE INDEX alerts_userid on alerts (userid); -- -- Table structure for table 'alarms' |