CenturyLinkCloud / mdw

https://centurylinkcloud.github.io/mdw/
MIT License
46 stars 10 forks source link

Add primary key to ACTIVITY_LOG table for Oracle #776

Closed donaldoakes closed 4 years ago

donaldoakes commented 4 years ago

Here's what the table create looks like with these changes (needs to be tested):

CREATE TABLE ACTIVITY_LOG
(
  LOG_ID                NUMBER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1) NOT NULL,
  PROCESS_INSTANCE_ID   NUMBER(20)             NOT NULL,
  ACTIVITY_INSTANCE_ID  NUMBER(20),            -- empty for process-level logging
  CREATE_DT             TIMESTAMP              DEFAULT SYSTIMESTAMP,
  LOG_LEVEL             VARCHAR(5),
  THREAD                VARCHAR(32),
  MESSAGE               VARCHAR(4000),
  CONSTRAINT activity_log_pk PRIMARY KEY (LOG_ID)
  USING INDEX
);

Impacted artifacts: