- 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

1 files changed, 17 insertions, 0 deletions

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
@@ -169,6 +169,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'
 --