ALTER TABLE DEPLOY_PACKAGE DROP CONSTRAINT DEPLOY_PACKAGE_PACKAGE_FK
/
ALTER TABLE DEPLOY_PACKAGE RENAME COLUMN package_id TO PRODUCT_VERSION_PACKAGE_ID
/
ALTER TABLE DEPLOY_PACKAGE ADD CONSTRAINT DEPLOY_PACK_PROD_VER_PACK_FK FOREIGN KEY (PRODUCT_VERSION_PACKAGE_ID) REFERENCES PRODUCT_VERSION_PACKAGES (ID)
/
ALTER TABLE DEPLOY ADD (STATUS VARCHAR2(1) NOT NULL, PATH_BACKUP VARCHAR2(500) NULL)