Releases · JeffersonLab/adm

DROP SEQUENCE ADM_OWNER.ENV_ID;

CREATE SEQUENCE ADM_OWNER.APP_ENV_ID
    INCREMENT BY 1
    START WITH 1
    NOCYCLE
    NOCACHE
    ORDER;

CREATE SEQUENCE ADM_OWNER.DEPLOY_JOB_ID
    INCREMENT BY 1
    START WITH 1
    NOCYCLE
    NOCACHE
    ORDER;

alter table ADM_OWNER.APP_ENV rename column ENV_ID to APP_ENV_ID;

CREATE TABLE ADM_OWNER.DEPLOY_JOB
(
    DEPLOY_JOB_ID INTEGER NOT NULL,
    APP_ENV_ID    INTEGER NOT NULL ,
    VERSION       VARCHAR2(32 CHAR) NOT NULL ,
    EXIT_CODE     INTEGER NULL ,
    OUT           CLOB NULL ,
    ERR           CLOB NULL ,
    STACK_TRACE   CLOB NULL ,
    JOB_START     DATE NOT NULL , -- Does not handle DST as local time (oh well - it's complicated to do so in JPA)
    JOB_END       DATE NULL , -- Does not handle DST
    CONSTRAINT REMOTE_COMMAND_RESULT_PK PRIMARY KEY (DEPLOY_JOB_ID) ,
    CONSTRAINT ENV_FK1 FOREIGN KEY (APP_ENV_ID) REFERENCES ADM_OWNER.APP_ENV (APP_ENV_ID) ON DELETE CASCADE
);

Full Changelog: v1.2.1...v1.3.0

No results found