 create table CATISSUE_DISTRIBUTION (
    IDENTIFIER number(19,0) not null,
    TO_SITE_ID number(19,0),
-   FROM_SITE_ID number(19,0),
    DISTRIBUTION_PROTOCOL_ID number(19,0),
    ACTIVITY_STATUS varchar2(50),
+   SPECIMEN_ID number(19,0),
+   EVENT_TIMESTAMP date,
+   USER_ID number(19,0),
+   COMMENTS varchar2(500),
    primary key (IDENTIFIER)
 );
 create table CATISSUE_AUDIT_EVENT_DETAILS (

drop table CATISSUE_USER cascade constraints;
drop table CATISSUE_TIS_SPE_EVENT_PARAM cascade constraints;
drop table CATISSUE_SPECIMEN_COLL_GROUP cascade constraints;
drop sequence hibernate_sequence;
create table CATISSUE_INTERFACE_COLUMN_DATA (
   IDENTIFIER number(19,0) not null,
   TABLE_ID number(19,0),

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 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;
