diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-08-05 13:54:37 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-08-05 13:54:37 +0000 |
| commit | bcad0d8ff2049311f84d6727190601999d63d4bd (patch) | |
| tree | f368ccf3ea7bc47f4281f94f1bb06b86f49393e1 /create/postgresql/schema.sql | |
| parent | 31be0f053d6ce0073e84c8bfc27348cf1a290a61 (diff) | |
| download | zabbix-bcad0d8ff2049311f84d6727190601999d63d4bd.tar.gz zabbix-bcad0d8ff2049311f84d6727190601999d63d4bd.tar.xz zabbix-bcad0d8ff2049311f84d6727190601999d63d4bd.zip | |
Added zabbix_agentd. A lot of other changes.
git-svn-id: svn://svn.zabbix.com/trunk@160 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 1b060b7d..46f4bf50 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -148,10 +148,11 @@ CREATE TABLE alarms ( clock int4 DEFAULT '0' NOT NULL, istrue int4 DEFAULT '0' NOT NULL, PRIMARY KEY (alarmid), - FOREIGN KEY (triggerid) REFERENCES triggers, - KEY (triggerid, clock) + FOREIGN KEY (triggerid) REFERENCES triggers ); +CREATE INDEX alarms_triggerid_clock on alarms (triggerid, clock); + -- -- Table structure for table 'functions' -- @@ -248,6 +249,7 @@ CREATE TABLE sysmaps_hosts ( shostid serial, sysmapid int4 DEFAULT '0' NOT NULL, hostid int4 DEFAULT '0' NOT NULL, + icon varchar(32) DEFAULT 'Server' NOT NULL, label varchar(128) DEFAULT '' NOT NULL, x int4 DEFAULT '0' NOT NULL, y int4 DEFAULT '0' NOT NULL, |