|
1
|
/*
|
|
2
|
* logging.sql -- Create or replace tables for logging events
|
|
3
|
*/
|
|
4
|
|
|
5
|
/*
|
|
6
|
*Logging -- table to store metadata and data access log
|
|
7
|
*/
|
|
8
|
CREATE SEQUENCE access_log_id_seq;
|
|
9
|
CREATE TABLE access_log (
|
|
10
|
entryid INT8 default nextval ('access_log_id_seq'),
|
|
11
|
ip_address VARCHAR(512),
|
|
12
|
principal VARCHAR(512),
|
|
13
|
docid VARCHAR(250), -- the document id #
|
|
14
|
rev INT8, -- the revision number
|
|
15
|
event VARCHAR(512),
|
|
16
|
date_logged TIMESTAMP,
|
|
17
|
CONSTRAINT access_log_pk PRIMARY KEY (entryid)
|
|
18
|
);
|