diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2004-12-26 21:18:45 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2004-12-26 21:18:45 +0000 |
| commit | 68d09eea4a0667d9563eced3d5e3ff5964fcee2b (patch) | |
| tree | a6e843adafbfbb08fe1cd14ebaf428cd6141688d /create/postgresql | |
| parent | 4add841323f1e12ae9b485243c2779c05523c0bf (diff) | |
| download | zabbix-68d09eea4a0667d9563eced3d5e3ff5964fcee2b.tar.gz zabbix-68d09eea4a0667d9563eced3d5e3ff5964fcee2b.tar.xz zabbix-68d09eea4a0667d9563eced3d5e3ff5964fcee2b.zip | |
- added table 'escalations' (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@1564 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql')
| -rw-r--r-- | create/postgresql/schema.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index fc9ef9b9..2a7b43ca 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -612,4 +612,16 @@ CREATE TABLE trends ( FOREIGN KEY (itemid) REFERENCES items ); +-- +-- Table structure for table 'escalations' +-- + +CREATE TABLE escalations ( + escalationid serial DEFAULT '0' NOT NULL, + name varchar(64) DEFAULT '0' NOT NULL, + PRIMARY KEY (escalationid) +); + +CREATE UNIQUE INDEX escalations_name on escalations (name); + VACUUM ANALYZE; |