<commit_before>drop table if exists CATISSUE_COLL_COORDINATORS
drop table if exists CATISSUE_CANCER_RESEARCH_GROUP
drop table if exists CATISSUE_COLLECTION_PROTOCOL
drop table if exists CATISSUE_EVENT_PARAM
drop table if exists CATISSUE_TRANSFER_EVENT_PARAM
drop table if exists CATISSUE_STOR_CONT_SPEC_CLASS
drop table if exists CATISSUE_COLL_EVENT_PARAM
drop table if exists CATISSUE_PASSWORD
drop table if exists CATISSUE_SPECIMEN_BIOHZ_REL
drop table if exists CATISSUE_MOL_SPE_REVIEW_PARAM
drop table if exists CATISSUE_STORAGE_TYPE
drop table if exists CATISSUE_CONTAINER
drop table if exists CATISSUE_DISTRIBUTION_SPE_REQ
drop table if exists CATISSUE_SITE
drop table if exists CATISSUE_EMBEDDED_EVENT_PARAM
drop table if exists CATISSUE_IN_OUT_EVENT_PARAM
drop table if exists CATISSUE_COLL_DISTRIBUTION_REL
drop table if exists CATISSUE_DISPOSAL_EVENT_PARAM
drop table if exists CATISSUE_SPECIMEN_REQUIREMENT
drop table if exists CATISSUE_SPECI_ARRAY_CONTENT
drop table if exists CATISSUE_INSTITUTION
drop table if exists CATISSUE_SPECIMEN_PROTOCOL
drop table if exists CATISSUE_FLUID_SPE_EVENT_PARAM
drop table if exists CATISSUE_BIOHAZARD
drop table if exists CATISSUE_QUANTITY
drop table if exists CATISSUE_SPUN_EVENT_PARAMETERS
drop table if exists CATISSUE_RECEIVED_EVENT_PARAM
drop table if exists CATISSUE_RACE
drop table if exists CATISSUE_CLINICAL_REPORT
drop table if exists CATISSUE_COLL_SPECIMEN_REQ
drop table if exists CATISSUE_ST_CONT_ST_TYPE_REL
drop table if exists CATISSUE_ADDRESS
drop table if exists CATISSUE_REPORTED_PROBLEM
drop table if exists CATISSUE_SPECIMEN_ARRAY
drop table if exists CATISSUE_CONT_HOLDS_SPARRTYPE
drop table if exists CATISSUE_ST_CONT_COLL_PROT_REL
drop table if exists CATISSUE_SPECIMEN_ARRAY_TYPE
drop table if exists CATISSUE_DISTRIBUTED_ITEM
drop table if exists CATISSUE_PARTICIPANT
drop table if exists CATISSUE_SPECIMEN_CHAR
drop table if exists CATISSUE_SPECIMEN_EVENT_PARAM
drop table if exists CATISSUE_STOR_TYPE_SPEC_CLASS
drop table if exists CATISSUE_COLL_PROT_EVENT
drop table if exists CATISSUE_CONTAINER_TYPE
drop table if exists CATISSUE_STOR_TYPE_HOLDS_TYPE
drop table if exists CATISSUE_CAPACITY
drop table if exists CATISSUE_PART_MEDICAL_ID
drop table if exists CATISSUE_CELL_SPE_REVIEW_PARAM
drop table if exists CATISSUE_STORAGE_CONTAINER
drop table if exists CATISSUE_DISTRIBUTION
drop table if exists CATISSUE_STORTY_HOLDS_SPARRTY
drop table if exists CATISSUE_PROCEDURE_EVENT_PARAM
drop table if exists CATISSUE_DISTRIBUTION_PROTOCOL
drop table if exists CATISSUE_DEPARTMENT
drop table if exists CATISSUE_EXTERNAL_IDENTIFIER
drop table if exists CATISSUE_FIXED_EVENT_PARAM
drop table if exists CATISSUE_THAW_EVENT_PARAMETERS
drop table if exists CATISSUE_COLL_PROT_REG
drop table if exists CATISSUE_FROZEN_EVENT_PARAM
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_SPECIMEN_COLL_GROUP
drop table if exists CATISSUE_SPECIMEN_TYPE
create table CATISSUE_COLL_COORDINATORS (
   COLLECTION_PROTOCOL_ID BIGINT not null,
   USER_ID BIGINT not null,
   primary key (USER_ID, COLLECTION_PROTOCOL_ID)
)
create table CATISSUE_CANCER_RESEARCH_GROUP (
   IDENTIFIER BIGINT NOT NULL AUTO_INCREMENT,
   NAME VARCHAR(50) not null unique,
   primary key (IDENTIFIER)
)
create table CATISSUE_COLLECTION_PROTOCOL (
   IDENTIFIER BIGINT not null,
   ALIQUOT_IN_SAME_CONTAINER BIT,
   primary key (IDENTIFIER)
)
create table CATISSUE_EVENT_PARAM (
   IDENTIFIER BIGINT not null,
   primary key (IDENTIFIER)
)
create table CATISSUE_TRANSFER_EVENT_PARAM (
   IDENTIFIER BIGINT not null,
   FROM_POSITION_DIMENSION_ONE INTEGER,
   FROM_POSITION_DIMENSION_TWO INTEGER,
   TO_POSITION_DIMENSION_ONE INTEGER,
   TO_POSITION_DIMENSION_TWO INTEGER,
   TO_STORAGE_CONTAINER_ID BIGINT,
   FROM_STORAGE_CONTAINER_ID BIGINT,
   primary key (IDENTIFIER)
)
create table CATISSUE_STOR_CONT_SPEC_CLASS (
   STORAGE_CONTAINER_ID BIGINT not null,
   SPECIMEN_CLASS VARCHAR(50)
)
create table CATISSUE_COLL_EVENT_PARAM (
   IDENTIFIER BIGINT not null,
   COLLECTION_PROCEDURE VARCHAR(50),
   CONTAINER VARCHAR(50),
   primary key (IDENTIFIER)
)
create table CATISSUE_PASSWORD (
   IDENTIFIER BIGINT NOT NULL AUTO_INCREMENT,
   PASSWORD VARCHAR(50),
   UPDATE_DATE DATE,
   USER_ID BIGINT,
   primary key (IDENTIFIER)
)
create table CATISSUE_SPECIMEN_BIOHZ_REL (
   BIOHAZARD_ID BIGINT not null,
   SPECIMEN_ID BIGINT not null,
   primary key (SPECIMEN_ID, BIOHAZARD_ID)
)
create table CATISSUE_MOL_SPE_REVIEW_PARAM (
   IDENTIFIER BIGINT not null,
   GEL_IMAGE_URL VARCHAR(200),
   QUALITY_INDEX VARCHAR(50),
   LANE_NUMBER VARCHAR(50),
   GEL_NUMBER INTEGER,
   ABSORBANCE_AT_260 DOUBLE PRECISION,
   ABSORBANCE_AT_280 DOUBLE PRECISION,
   RATIO_28S_TO_18S DOUBLE PRECISION,
   primary key (IDENTIFIER)
)
create table CATISSUE_STORAGE_TYPE (
   IDENTIFIER BIGINT not null,
   DEFAULT_TEMPERATURE DOUBLE PRECISION,
   primary key (IDENTIFIER)
)
create table CATISSUE_CONTAINER (
   IDENTIFIER BIGINT NOT NULL AUTO_INCREMENT,
   ACTIVITY_STATUS VARCHAR(20),
   BARCODE VARCHAR(100),
   CAPACITY_ID BIGINT,
   PARENT_CONTAINER_ID BIGINT,
   COMMENTS TEXT,
   FULL BIT,
   NAME VARCHAR(100),
   POSITION_DIMENSION_ONE INTEGER,
   POSITION_DIMENSION_TWO INTEGER,
   primary key (IDENTIFIER)<commit_msg>'FULL' column name of catissue_container table is changed to 'CONT_FULL' to support MsSqlServer create table query as it is a keyword inMsSqlServer.<commit_after>drop table if exists CATISSUE_COLL_COORDINATORS
drop table if exists CATISSUE_CANCER_RESEARCH_GROUP
drop table if exists CATISSUE_COLLECTION_PROTOCOL
drop table if exists CATISSUE_EVENT_PARAM
drop table if exists CATISSUE_TRANSFER_EVENT_PARAM
drop table if exists CATISSUE_STOR_CONT_SPEC_CLASS
drop table if exists CATISSUE_COLL_EVENT_PARAM
drop table if exists CATISSUE_PASSWORD
drop table if exists CATISSUE_SPECIMEN_BIOHZ_REL
drop table if exists CATISSUE_MOL_SPE_REVIEW_PARAM
drop table if exists CATISSUE_STORAGE_TYPE
drop table if exists CATISSUE_CONTAINER
drop table if exists CATISSUE_DISTRIBUTION_SPE_REQ
drop table if exists CATISSUE_SITE
drop table if exists CATISSUE_EMBEDDED_EVENT_PARAM
drop table if exists CATISSUE_IN_OUT_EVENT_PARAM
drop table if exists CATISSUE_COLL_DISTRIBUTION_REL
drop table if exists CATISSUE_DISPOSAL_EVENT_PARAM
drop table if exists CATISSUE_SPECIMEN_REQUIREMENT
drop table if exists CATISSUE_SPECI_ARRAY_CONTENT
drop table if exists CATISSUE_INSTITUTION
drop table if exists CATISSUE_SPECIMEN_PROTOCOL
drop table if exists CATISSUE_FLUID_SPE_EVENT_PARAM
drop table if exists CATISSUE_BIOHAZARD
drop table if exists CATISSUE_QUANTITY
drop table if exists CATISSUE_SPUN_EVENT_PARAMETERS
drop table if exists CATISSUE_RECEIVED_EVENT_PARAM
drop table if exists CATISSUE_RACE
drop table if exists CATISSUE_CLINICAL_REPORT
drop table if exists CATISSUE_COLL_SPECIMEN_REQ
drop table if exists CATISSUE_ST_CONT_ST_TYPE_REL
drop table if exists CATISSUE_ADDRESS
drop table if exists CATISSUE_REPORTED_PROBLEM
drop table if exists CATISSUE_SPECIMEN_ARRAY
drop table if exists CATISSUE_CONT_HOLDS_SPARRTYPE
drop table if exists CATISSUE_ST_CONT_COLL_PROT_REL
drop table if exists CATISSUE_SPECIMEN_ARRAY_TYPE
drop table if exists CATISSUE_DISTRIBUTED_ITEM
drop table if exists CATISSUE_PARTICIPANT
drop table if exists CATISSUE_SPECIMEN_CHAR
drop table if exists CATISSUE_SPECIMEN_EVENT_PARAM
drop table if exists CATISSUE_STOR_TYPE_SPEC_CLASS
drop table if exists CATISSUE_COLL_PROT_EVENT
drop table if exists CATISSUE_CONTAINER_TYPE
drop table if exists CATISSUE_STOR_TYPE_HOLDS_TYPE
drop table if exists CATISSUE_CAPACITY
drop table if exists CATISSUE_PART_MEDICAL_ID
drop table if exists CATISSUE_CELL_SPE_REVIEW_PARAM
drop table if exists CATISSUE_STORAGE_CONTAINER
drop table if exists CATISSUE_DISTRIBUTION
drop table if exists CATISSUE_STORTY_HOLDS_SPARRTY
drop table if exists CATISSUE_PROCEDURE_EVENT_PARAM
drop table if exists CATISSUE_DISTRIBUTION_PROTOCOL
drop table if exists CATISSUE_DEPARTMENT
drop table if exists CATISSUE_EXTERNAL_IDENTIFIER
drop table if exists CATISSUE_FIXED_EVENT_PARAM
drop table if exists CATISSUE_THAW_EVENT_PARAMETERS
drop table if exists CATISSUE_COLL_PROT_REG
drop table if exists CATISSUE_FROZEN_EVENT_PARAM
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_SPECIMEN_COLL_GROUP
drop table if exists CATISSUE_SPECIMEN_TYPE
create table CATISSUE_COLL_COORDINATORS (
   COLLECTION_PROTOCOL_ID BIGINT not null,
   USER_ID BIGINT not null,
   primary key (USER_ID, COLLECTION_PROTOCOL_ID)
)
create table CATISSUE_CANCER_RESEARCH_GROUP (
   IDENTIFIER BIGINT NOT NULL AUTO_INCREMENT,
   NAME VARCHAR(50) not null unique,
   primary key (IDENTIFIER)
)
create table CATISSUE_COLLECTION_PROTOCOL (
   IDENTIFIER BIGINT not null,
   ALIQUOT_IN_SAME_CONTAINER BIT,
   primary key (IDENTIFIER)
)
create table CATISSUE_EVENT_PARAM (
   IDENTIFIER BIGINT not null,
   primary key (IDENTIFIER)
)
create table CATISSUE_TRANSFER_EVENT_PARAM (
   IDENTIFIER BIGINT not null,
   FROM_POSITION_DIMENSION_ONE INTEGER,
   FROM_POSITION_DIMENSION_TWO INTEGER,
   TO_POSITION_DIMENSION_ONE INTEGER,
   TO_POSITION_DIMENSION_TWO INTEGER,
   TO_STORAGE_CONTAINER_ID BIGINT,
   FROM_STORAGE_CONTAINER_ID BIGINT,
   primary key (IDENTIFIER)
)
create table CATISSUE_STOR_CONT_SPEC_CLASS (
   STORAGE_CONTAINER_ID BIGINT not null,
   SPECIMEN_CLASS VARCHAR(50)
)
create table CATISSUE_COLL_EVENT_PARAM (
   IDENTIFIER BIGINT not null,
   COLLECTION_PROCEDURE VARCHAR(50),
   CONTAINER VARCHAR(50),
   primary key (IDENTIFIER)
)
create table CATISSUE_PASSWORD (
   IDENTIFIER BIGINT NOT NULL AUTO_INCREMENT,
   PASSWORD VARCHAR(50),
   UPDATE_DATE DATE,
   USER_ID BIGINT,
   primary key (IDENTIFIER)
)
create table CATISSUE_SPECIMEN_BIOHZ_REL (
   BIOHAZARD_ID BIGINT not null,
   SPECIMEN_ID BIGINT not null,
   primary key (SPECIMEN_ID, BIOHAZARD_ID)
)
create table CATISSUE_MOL_SPE_REVIEW_PARAM (
   IDENTIFIER BIGINT not null,
   GEL_IMAGE_URL VARCHAR(200),
   QUALITY_INDEX VARCHAR(50),
   LANE_NUMBER VARCHAR(50),
   GEL_NUMBER INTEGER,
   ABSORBANCE_AT_260 DOUBLE PRECISION,
   ABSORBANCE_AT_280 DOUBLE PRECISION,
   RATIO_28S_TO_18S DOUBLE PRECISION,
   primary key (IDENTIFIER)
)
create table CATISSUE_STORAGE_TYPE (
   IDENTIFIER BIGINT not null,
   DEFAULT_TEMPERATURE DOUBLE PRECISION,
   primary key (IDENTIFIER)
)
create table CATISSUE_CONTAINER (
   IDENTIFIER BIGINT NOT NULL AUTO_INCREMENT,
   ACTIVITY_STATUS VARCHAR(20),
   BARCODE VARCHAR(100),
   CAPACITY_ID BIGINT,
   PARENT_CONTAINER_ID BIGINT,
   COMMENTS TEXT,
   CONT_FULL BIT,
   NAME VARCHAR(100),
   POSITION_DIMENSION_ONE INTEGER,
   POSITION_DIMENSION_TWO INTEGER,
   primary key (IDENTIFIER)
{'fraction_non_alphanumeric': 0.02188365650969529, 'fraction_numerical': 0.006463527239150508, 'mean_word_length': 6.516308119361555, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4691297', 'n_tokens_mistral': 4279, 'n_tokens_neox': 3739, 'n_words': 1058}