 alter table CATISSUE_STORAGE_CONTAINER drop constraint FK28429D0159A3CE5C;
 alter table CATISSUE_STORAGE_CONTAINER drop constraint FK28429D01DB097B2E;
 alter table CATISSUE_CELL_SPE_REVIEW_PARAM drop constraint FK52F40EDEBC7298A9;
+alter table CATISSUE_DISTRIBUTION drop constraint FK542766802206F20F;
 alter table CATISSUE_DISTRIBUTION drop constraint FK542766806B1F36E7;
 alter table CATISSUE_DISTRIBUTION drop constraint FK542766801DBE834F;
-alter table CATISSUE_DISTRIBUTION drop constraint FK54276680BC7298A9;
-alter table CATISSUE_DISTRIBUTION drop constraint FK54276680FB9AE97E;
+alter table CATISSUE_DISTRIBUTION drop constraint FK5427668060773DB2;
 alter table CATISSUE_AUDIT_EVENT_DETAILS drop constraint FK5C07745D34FFD77F;
 alter table CATISSUE_PROCEDURE_EVENT_PARAM drop constraint FKEC6B4260BC7298A9;
 alter table CATISSUE_DISTRIBUTION_PROTOCOL drop constraint FKC8999977BC7298A9;

alter table CATISSUE_SPECIMEN_COLL_GROUP add constraint FKDEBAF1674CE21DDA foreign key (CLINICAL_REPORT_ID) references CATISSUE_CLINICAL_REPORT;
alter table CATISSUE_SPECIMEN_COLL_GROUP add constraint FKDEBAF16753B01F66 foreign key (COLLECTION_PROTOCOL_EVENT_ID) references CATISSUE_COLL_PROT_EVENT;
alter table CATISSUE_SPECIMEN_COLL_GROUP add constraint FKDEBAF1677E07C4AC foreign key (COLLECTION_PROTOCOL_REG_ID) references CATISSUE_COLL_PROT_REG;
create sequence hibernate_sequence increment by 1 start with 1 NOMAXVALUE minvalue 1 nocycle nocache noorder;

ALTER TABLE CATISSUE_COLL_SPECIMEN_REQ ADD(IDENTIFIER number(20));
ALTER TABLE CATISSUE_DISTRIBUTION_SPE_REQ ADD(IDENTIFIER number(20));
alter table CATISSUE_STORAGE_CONTAINER add constraint FK28429D0159A3CE5C foreign key (STORAGE_TYPE_ID) references CATISSUE_STORAGE_TYPE;
alter table CATISSUE_STORAGE_CONTAINER add constraint FK28429D01DB097B2E foreign key (PARENT_CONTAINER_ID) references CATISSUE_STORAGE_CONTAINER;
alter table CATISSUE_CELL_SPE_REVIEW_PARAM add constraint FK52F40EDEBC7298A9 foreign key (IDENTIFIER) references CATISSUE_EVENT_PARAM;
alter table CATISSUE_DISTRIBUTION add constraint FK542766802206F20F foreign key (USER_ID) references CATISSUE_USER;
alter table CATISSUE_DISTRIBUTION add constraint FK542766806B1F36E7 foreign key (DISTRIBUTION_PROTOCOL_ID) references CATISSUE_DISTRIBUTION_PROTOCOL;
alter table CATISSUE_DISTRIBUTION add constraint FK542766801DBE834F foreign key (TO_SITE_ID) references CATISSUE_SITE;
alter table CATISSUE_DISTRIBUTION add constraint FK5427668060773DB2 foreign key (SPECIMEN_ID) references CATISSUE_SPECIMEN;
alter table CATISSUE_AUDIT_EVENT_DETAILS add constraint FK5C07745D34FFD77F foreign key (AUDIT_EVENT_LOG_ID) references CATISSUE_AUDIT_EVENT_LOG;
alter table CATISSUE_PROCEDURE_EVENT_PARAM add constraint FKEC6B4260BC7298A9 foreign key (IDENTIFIER) references CATISSUE_SPECIMEN_EVENT_PARAM;
alter table CATISSUE_DISTRIBUTION_PROTOCOL add constraint FKC8999977BC7298A9 foreign key (IDENTIFIER) references CATISSUE_SPECIMEN_PROTOCOL;
