Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add primary key to ACTIVITY_LOG table for Oracle #776

Closed
donaldoakes opened this issue Nov 27, 2019 · 0 comments
Closed

Add primary key to ACTIVITY_LOG table for Oracle #776

donaldoakes opened this issue Nov 27, 2019 · 0 comments
Assignees
Milestone

Comments

@donaldoakes
Copy link
Collaborator

donaldoakes commented Nov 27, 2019

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:

  • mdw/database/oracle/create_tables.sql
  • mdw/database/oracle/mdw_upgrade_6.0_To_6.1.sql
  • mdw-common/src/META-INF/mdw/db/oracle/upgrade.json
@donaldoakes donaldoakes added this to the 6.1.29 milestone Nov 27, 2019
@donaldoakes donaldoakes modified the milestones: 6.1.29, 6.1.30 Dec 13, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
database
Awaiting triage
mdw
Awaiting triage
Development

No branches or pull requests

2 participants