Revision 2101
Added by Matt Jones almost 20 years ago
upgrade-db-to-1.4.sql | ||
---|---|---|
30 | 30 |
ip_address VARCHAR2(512), -- the ip address inititiating the event |
31 | 31 |
principal VARCHAR2(512), -- the user initiiating the event |
32 | 32 |
docid VARCHAR2(250), -- the document id # |
33 |
rev NUMBER(10), -- the revision number |
|
34 | 33 |
event VARCHAR2(512), -- the code symbolizing the event type |
35 | 34 |
date_logged DATE, -- the datetime on which the event occurred |
36 | 35 |
CONSTRAINT access_log_pk PRIMARY KEY (entryid) |
... | ... | |
44 | 43 |
INTO :new.entryid |
45 | 44 |
FROM dual; |
46 | 45 |
END; |
47 |
/ |
|
46 |
/ |
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.