Revision 6542
Added by ben leinfelder over 12 years ago
| xmltables-postgres.sql | ||
|---|---|---|
| 390 | 390 |
CREATE TABLE access_log ( |
| 391 | 391 |
entryid INT8 default nextval ('access_log_id_seq'), -- the identifier for the log event
|
| 392 | 392 |
ip_address VARCHAR(512), -- the ip address inititiating the event |
| 393 |
principal VARCHAR(512), -- the user initiiating the event |
|
| 393 |
user_agent VARCHAR(512), -- the user agent for the request |
|
| 394 |
principal VARCHAR(512), -- the user initiating the event |
|
| 394 | 395 |
docid VARCHAR(250), -- the document id # |
| 395 | 396 |
event VARCHAR(512), -- the code symbolizing the event type |
| 396 | 397 |
date_logged TIMESTAMP, -- the datetime on which the event occurred |
Also available in: Unified diff
add User-Agent logging to support D1 requirements