 drop table if exists CATISSUE_SPECIMEN;
 drop table if exists CATISSUE_USER;
 drop table if exists CATISSUE_TIS_SPE_EVENT_PARAM;
+drop table if exists CATISSUE_STORAGE_CONT_COLL_PROT_REL;
 drop table if exists CATISSUE_SPECIMEN_COLL_GROUP;
-create table CATISSUE_INTERFACE_COLUMN_DATA (
-   IDENTIFIER bigint not null auto_increment,
-   TABLE_ID bigint,
-   COLUMN_NAME varchar(50),
-   DISPLAY_NAME varchar(50),
-   primary key (IDENTIFIER)
-);
-create table CATISSUE_COLL_COORDINATORS (
-   COLLECTION_PROTOCOL_ID bigint not null,
-   USER_ID bigint not null,
-   primary key (COLLECTION_PROTOCOL_ID, USER_ID)
-);
+drop table if exists CATISSUE_SPECIMEN_TYPE;
 create table CATISSUE_PERMISSIBLE_VALUE (
    IDENTIFIER bigint not null auto_increment,
    CONCEPT_CODE varchar(40),

   REASON varchar(50) not null,
   primary key (IDENTIFIER)
);
create table CATISSUE_CDE (
   PUBLIC_ID varchar(30) not null,
   LONG_NAME varchar(200),
   DEFINITION text,
   VERSION varchar(50),
   LAST_UPDATED date,
   primary key (PUBLIC_ID)
);
create table CATISSUE_SPECIMEN_REQUIREMENT (
   IDENTIFIER bigint not null auto_increment,
   SPECIMEN_CLASS varchar(255) not null,
   SPECIMEN_TYPE varchar(50),
   TISSUE_SITE varchar(150),
   PATHOLOGY_STATUS varchar(50),
   QUANTITY double precision,
   primary key (IDENTIFIER)
);

alter table CATISSUE_COLL_DISTRIBUTION_REL drop foreign key FK1483BCB56B1F36E7;
alter table CATISSUE_COLL_DISTRIBUTION_REL drop foreign key FK1483BCB548304401;
alter table CATISSUE_DISPOSAL_EVENT_PARAM drop foreign key FK1BC818D6BC7298A9;
alter table CATISSUE_SPECIMEN_REQUIREMENT drop foreign key FK39AFE96861A1C94F;
alter table CATISSUE_STOR_CONT_STOR_TYPE_REL drop foreign key FK703B902159A3CE5C;
alter table CATISSUE_STOR_CONT_STOR_TYPE_REL drop foreign key FK703B9021B3DFB11D;
alter table CATISSUE_SPECIMEN_PROTOCOL drop foreign key FKB8481373870EB740;
alter table CATISSUE_FLUID_SPE_EVENT_PARAM drop foreign key FK70565D20BC7298A9;
alter table CATISSUE_SPUN_EVENT_PARAMETERS drop foreign key FK312D77BCBC7298A9;
alter table CATISSUE_RECEIVED_EVENT_PARAM drop foreign key FKA7139D06BC7298A9;
alter table CATISSUE_RACE drop foreign key FKB0242ECD87E5ADC7;
alter table CATISSUE_CLINICAL_REPORT drop foreign key FK54A4264515246F7;
alter table CATISSUE_COLL_SPECIMEN_REQ drop foreign key FK860E6ABEBE10F0CE;
alter table CATISSUE_COLL_SPECIMEN_REQ drop foreign key FK860E6ABE53B01F66;
alter table CATISSUE_SPECIMEN_ARRAY_CONTENT drop foreign key FKBEA9D458C4A3C438;
alter table CATISSUE_SPECIMEN_ARRAY_CONTENT drop foreign key FKBEA9D45860773DB2;
alter table CATISSUE_SPECIMEN_ARRAY_CONTENT drop foreign key FKBEA9D45892AB74B4;
alter table CATISSUE_SPECIMEN_ARRAY drop foreign key FKECBF8B3E64B129CC;
alter table CATISSUE_SPECIMEN_ARRAY drop foreign key FKECBF8B3EF8278B6;
alter table CATISSUE_SPECIMEN_ARRAY drop foreign key FKECBF8B3EBC7298A9;
alter table CATISSUE_SPECIMEN_ARRAY drop foreign key FKECBF8B3EB3DFB11D;
alter table CATISSUE_SPECIMEN_ARRAY drop foreign key FKECBF8B3EECE89343;
alter table CATISSUE_SPECIMEN_ARRAY_TYPE drop foreign key FKD36E0B9BBC7298A9;
alter table CATISSUE_DISTRIBUTED_ITEM drop foreign key FKA7C3ED4B60773DB2;
alter table CATISSUE_DISTRIBUTED_ITEM drop foreign key FKA7C3ED4BF8278B6;
alter table CATISSUE_SPECIMEN_EVENT_PARAM drop foreign key FK753F33AD60773DB2;
alter table CATISSUE_SPECIMEN_EVENT_PARAM drop foreign key FK753F33AD2206F20F;
alter table CATISSUE_STOR_TYPE_SPEC_CLASS drop foreign key FK1BCF33BA59A3CE5C;
alter table CATISSUE_COLL_PROT_EVENT drop foreign key FK7AE7715948304401;
alter table CATISSUE_CONTAINER_TYPE drop foreign key FKCBBC9954DAC76C0;
alter table CATISSUE_PART_MEDICAL_ID drop foreign key FK349E77F9A7F77D13;
alter table CATISSUE_PART_MEDICAL_ID drop foreign key FK349E77F987E5ADC7;
alter table CATISSUE_STORAGE_CONTAINER drop foreign key FK28429D01BC7298A9;
alter table CATISSUE_STORAGE_CONTAINER drop foreign key FK28429D01A7F77D13;
alter table CATISSUE_STORAGE_CONTAINER drop foreign key FK28429D0159A3CE5C;
alter table CATISSUE_CELL_SPE_REVIEW_PARAM drop foreign key FK52F40EDEBC7298A9;
alter table CATISSUE_DISTRIBUTION drop foreign key FK542766802206F20F;
alter table CATISSUE_DISTRIBUTION drop foreign key FK542766806B1F36E7;
alter table CATISSUE_DISTRIBUTION drop foreign key FK542766801DBE834F;
alter table CATISSUE_DISTRIBUTION drop foreign key FK5427668060773DB2;
alter table CATISSUE_PROCEDURE_EVENT_PARAM drop foreign key FKEC6B4260BC7298A9;
alter table CATISSUE_DISTRIBUTION_PROTOCOL drop foreign key FKC8999977BC7298A9;
alter table CATISSUE_EXTERNAL_IDENTIFIER drop foreign key FK5CF2FA2160773DB2;
