ALTER TABLE TASK ADD (
  PRODUCT_VERSION_ID_DEV NUMBER(10) DEFAULT NULL NULL
)
/
ALTER TABLE TASK ADD CONSTRAINT TASK_PRODUCT_VERSION_DEV_FK FOREIGN KEY (PRODUCT_VERSION_ID_DEV) REFERENCES PRODUCT_VERSION (ID)
/
ALTER TABLE PRODUCT_FILES ADD (
  PARENT_ID NUMBER(10) DEFAULT NULL NULL, 
  PRODUCT_VERSION_ID NUMBER(10) DEFAULT NULL NULL
)
/
ALTER TABLE PRODUCT_FILES ADD CONSTRAINT PRODUCT_FILES_PARENT_FK FOREIGN KEY (PARENT_ID) REFERENCES PRODUCT_FILES (ID)
/
ALTER TABLE PRODUCT_FILES ADD CONSTRAINT PRODUCT_FILES_PROD_VER_FK FOREIGN KEY (PRODUCT_VERSION_ID) REFERENCES PRODUCT_VERSION (ID)
/
ALTER TABLE PRODUCT_VERSION ADD (
  MODULES_CONFIGURATION CLOB DEFAULT NULL NULL
)
/
ALTER TABLE PRODUCT ADD (
  NUMBER_LTS_AVAILABLE NUMBER(10) DEFAULT NULL NULL
)
/
ALTER TABLE SUBRELEASE ADD (
  PRODUCT_VERSION_ID NUMBER(10) DEFAULT NULL NULL
)
/
ALTER TABLE SUBRELEASE ADD CONSTRAINT SUBRELEASE_PRODUCT_VERSION_FK FOREIGN KEY (PRODUCT_VERSION_ID) REFERENCES PRODUCT_VERSION (ID)
/
ALTER TABLE PROJECT ADD (
  PRODUCT_VERSION_ID NUMBER(10) DEFAULT NULL NULL
)
/
ALTER TABLE PROJECT ADD CONSTRAINT PROJECT_PRODUCT_VERSION_FK FOREIGN KEY (PRODUCT_VERSION_ID) REFERENCES PRODUCT_VERSION (ID)