From 140d7a7de72b6a69f9b08e7f09e794b2765c2804 Mon Sep 17 00:00:00 2001 From: hugetoad Date: Thu, 16 Sep 2004 20:25:50 +0000 Subject: - added table audit (Alexei) - added audit.php (Alexei) - new default port numbers for agent and trapper, 10050 and 10051 (Alexei) - better internal coding standard for ZABBIX agent (Alexei) - added support for md5sum for files less than 64M (Alexei) - added include md5.c and md5.h (Alexei) - remove trends.php, trend.php (Alexei) - remove compare.php, chart3.php (Alexei) - show trigger dependencies in list of configuration of triggers (Alexei) - make Zabbix reset nextcheck for items when updating or adding a trigger (Alexei) - minimum value of PingerFrequency changed to 1 (Alexei) git-svn-id: svn://svn.zabbix.com/trunk@1423 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- create/postgresql/schema.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) (limited to 'create/postgresql/schema.sql') diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 01f696ae..98df0fc1 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -168,6 +168,23 @@ CREATE TABLE users ( CREATE UNIQUE INDEX users_alias on users (alias); +-- +-- Table structure for table 'audit' +-- + +CREATE TABLE audit ( + auditid serial, + userid int4 DEFAULT '0' NOT NULL, + clock int4 DEFAULT '0' NOT NULL, + action int4 DEFAULT '0' NOT NULL, + resource int4 DEFAULT '0' NOT NULL, + details varchar(128) DEFAULT '0' NOT NULL, + PRIMARY KEY (auditid) +); + +CREATE UNIQUE INDEX audit_userid_clock on audit (userid,clock); +CREATE INDEX audit_clock on audit (clock); + -- -- Table structure for table 'actions' -- -- cgit