Project

General

Profile

« Previous | Next » 

Revision 2101

Added by Matt Jones over 20 years ago

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.

View differences:

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