<commit_before><?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog 
  xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
  xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
        http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">

  <changeSet author="ckhilosiya" id="Specimen freeze/thaw cycles audit value">
    <addColumn tableName="CATISSUE_SPECIMEN_AUD">
      <column name="FREEZE_THAW_CYCLES" type="${mediumint.type}"/>
      <column name="freezeThawCycles_MOD" type="${bit.type}"/>
    </addColumn>
  </changeSet>

  <changeSet author="vlonushte" id="Audit consent comments">
    <renameColumn
      tableName="CATISSUE_COLL_PROT_REG_AUD"
      oldColumnName="CONSENT_DOC_URL"
      newColumnName="CONSENT_COMMENTS"
      columnDataType="${text.type}(1000)"/>
  </changeSet>

  <changeSet author="vlonushte" id="Track consent comment modifications">
    <renameColumn
      tableName="CATISSUE_COLL_PROT_REG_AUD"
      oldColumnName="signedConsentDocumentUrl_MOD"
      newColumnName="consentComments_MOD"
      columnDataType="${bit.type}"/>
  </changeSet>
  
  <changeSet author="mdnasim" id="Audit container types">
    <createTable tableName="OS_CONTAINER_TYPES_AUD">
      <column name="IDENTIFIER" type="${int.type}">
        <constraints nullable="false"/>
      </column>
      
      <column name="REV" type="${int.type}">
        <constraints nullable="false"/>
      </column>
      
      <column name="REVTYPE" type="${smallint.type}"/>
      
      <column name="NAME" type="${text.type}(64)"/>
      
      <column name="name_MOD" type="${bit.type}"/>

      <column name="NAME_FORMAT" type="${text.type}(255)"/>

      <column name="nameFormat_MOD" type="${bit.type}"/>
      
      <column name="TEMPERATURE" type="${double.type}"/>
      
      <column name="temperature_MOD" type="${bit.type}"/>
      
      <column name="NO_OF_COLS" type="${int.type}"/>
      
      <column name="noOfColumns_MOD" type="${bit.type}"/>
      
      <column name="NO_OF_ROWS" type="${int.type}"/>
      
      <column name="noOfRows_MOD" type="${bit.type}"/>
      
      <column name="COLUMN_LABELING_SCHEME" type="${text.type}(64)"/>
      
      <column name="columnLabelingScheme_MOD" type="${bit.type}"/>
      
      <column name="ROW_LABELING_SCHEME" type="${text.type}(64)"/>
      
      <column name="rowLabelingScheme_MOD" type="${bit.type}"/>
      
      <column name="STORE_SPECIMENS" type="${boolean.type}"/>
      
      <column name="storeSpecimenEnabled_MOD" type="${bit.type}"/>
      
      <column name="CAN_HOLD" type="${int.type}"/>
      
      <column name="canHold_MOD" type="${bit.type}"/>
      
      <column name="ACTIVITY_STATUS" type="${text.type}(16)"/>
      
      <column name="activityStatus_MOD" type="${bit.type}"/>
    </createTable>
  </changeSet>

  <changeSet author="mdnasim" id="Column to specify container type">
    <addColumn tableName="OS_STORAGE_CONTAINERS_AUD">
      <column name="TYPE_ID" type="${int.type}"/>
    </addColumn>
  </changeSet>

  <changeSet author="mdnasim" id="Track changes of container type of container">
    <addColumn tableName="OS_STORAGE_CONTAINERS_AUD">
      <column name="type_MOD" type="${bit.type}"/>
    </addColumn>
  </changeSet>
</databaseChangeLog><commit_msg>OPSMN-2997: Unable to save Specimen comments of length > 255 characters.  - Increased length of specimen's comment field for audit table, to save comments of length > 255 chars.  - For specimen audit table comments datatype made same as its base table.<commit_after><?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog 
  xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
  xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
        http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">

  <changeSet author="ckhilosiya" id="Specimen freeze/thaw cycles audit value">
    <addColumn tableName="CATISSUE_SPECIMEN_AUD">
      <column name="FREEZE_THAW_CYCLES" type="${mediumint.type}"/>
      <column name="freezeThawCycles_MOD" type="${bit.type}"/>
    </addColumn>
  </changeSet>

  <changeSet author="vlonushte" id="Audit consent comments">
    <renameColumn
      tableName="CATISSUE_COLL_PROT_REG_AUD"
      oldColumnName="CONSENT_DOC_URL"
      newColumnName="CONSENT_COMMENTS"
      columnDataType="${text.type}(1000)"/>
  </changeSet>

  <changeSet author="vlonushte" id="Track consent comment modifications">
    <renameColumn
      tableName="CATISSUE_COLL_PROT_REG_AUD"
      oldColumnName="signedConsentDocumentUrl_MOD"
      newColumnName="consentComments_MOD"
      columnDataType="${bit.type}"/>
  </changeSet>
  
  <changeSet author="mdnasim" id="Audit container types">
    <createTable tableName="OS_CONTAINER_TYPES_AUD">
      <column name="IDENTIFIER" type="${int.type}">
        <constraints nullable="false"/>
      </column>
      
      <column name="REV" type="${int.type}">
        <constraints nullable="false"/>
      </column>
      
      <column name="REVTYPE" type="${smallint.type}"/>
      
      <column name="NAME" type="${text.type}(64)"/>
      
      <column name="name_MOD" type="${bit.type}"/>

      <column name="NAME_FORMAT" type="${text.type}(255)"/>

      <column name="nameFormat_MOD" type="${bit.type}"/>
      
      <column name="TEMPERATURE" type="${double.type}"/>
      
      <column name="temperature_MOD" type="${bit.type}"/>
      
      <column name="NO_OF_COLS" type="${int.type}"/>
      
      <column name="noOfColumns_MOD" type="${bit.type}"/>
      
      <column name="NO_OF_ROWS" type="${int.type}"/>
      
      <column name="noOfRows_MOD" type="${bit.type}"/>
      
      <column name="COLUMN_LABELING_SCHEME" type="${text.type}(64)"/>
      
      <column name="columnLabelingScheme_MOD" type="${bit.type}"/>
      
      <column name="ROW_LABELING_SCHEME" type="${text.type}(64)"/>
      
      <column name="rowLabelingScheme_MOD" type="${bit.type}"/>
      
      <column name="STORE_SPECIMENS" type="${boolean.type}"/>
      
      <column name="storeSpecimenEnabled_MOD" type="${bit.type}"/>
      
      <column name="CAN_HOLD" type="${int.type}"/>
      
      <column name="canHold_MOD" type="${bit.type}"/>
      
      <column name="ACTIVITY_STATUS" type="${text.type}(16)"/>
      
      <column name="activityStatus_MOD" type="${bit.type}"/>
    </createTable>
  </changeSet>

  <changeSet author="mdnasim" id="Column to specify container type">
    <addColumn tableName="OS_STORAGE_CONTAINERS_AUD">
      <column name="TYPE_ID" type="${int.type}"/>
    </addColumn>
  </changeSet>

  <changeSet author="mdnasim" id="Track changes of container type of container">
    <addColumn tableName="OS_STORAGE_CONTAINERS_AUD">
      <column name="type_MOD" type="${bit.type}"/>
    </addColumn>
  </changeSet>
  
  <changeSet author="slakhani" id="Modifying comments field's datatype to support long values" dbms="mysql">
    <modifyDataType 
      tableName="catissue_specimen_aud" 
      columnName="COMMENTS" 
      newDataType="text" />
  </changeSet>
  
  <changeSet author="slakhani" id="Modifying comments field's datatype to support long values" dbms="oracle">
    <modifyDataType 
      tableName="catissue_specimen_aud" 
      columnName="COMMENTS" 
      newDataType="VARCHAR2(500 BYTE)" />
  </changeSet>
</databaseChangeLog>
{'fraction_non_alphanumeric': 0.1667094455852156, 'fraction_numerical': 0.008213552361396304, 'mean_word_length': 3.635930993456276, 'pattern_counts': {'":': 0, '<': 121, '<?xml version=': 2, '>': 123, 'https://': 0, 'lorem ipsum': 0, 'www.': 14, 'xml': 20}, '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': '5609124', 'n_tokens_mistral': 2706, 'n_tokens_neox': 2572, 'n_words': 401}