Revision 2101
Added by Matt Jones about 20 years ago
| upgrade-db-to-1.4_postgres.sql | ||
|---|---|---|
| 31 | 31 |
ip_address VARCHAR(512), -- the ip address inititiating the event |
| 32 | 32 |
principal VARCHAR(512), -- the user initiiating the event |
| 33 | 33 |
docid VARCHAR(250), -- the document id # |
| 34 |
rev INT8, -- the revision number |
|
| 35 | 34 |
event VARCHAR(512), -- the code symbolizing the event type |
| 36 | 35 |
date_logged TIMESTAMP, -- the datetime on which the event occurred |
| 37 | 36 |
CONSTRAINT access_log_pk PRIMARY KEY (entryid) |
Also available in: Unified diff
Modified EventLog to eliminate the separate revision column and instead fold
that into the docid string. Log now includes read events, but need to update
the data sent there.