From 140d7a7de72b6a69f9b08e7f09e794b2765c2804 Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
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 

