<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"
  xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
  http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd">

  <changeSet author="vgaikwad" id="Change older public id 'Specimen_Type_PID' to 'specimen_type' to refer same">
    <sql>
      update
        catissue_permissible_value
      set
        public_id = 'specimen_type'
      where
        public_id = 'Specimen_Type_PID';

      delete from catissue_cde where public_id = 'Specimen_Type_PID';
    </sql>
  </changeSet>
</databaseChangeLog><commit_msg>OPSMN-3500: Updated change description to indicate all specimen type PV values moved under 'specimen_type' attribute...<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"
  xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
  http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd">

  <changeSet author="vgaikwad" id="Move all PVs under Specimen_Type_PID to specimen_type">
    <sql>
      update
        catissue_permissible_value
      set
        public_id = 'specimen_type'
      where
        public_id = 'Specimen_Type_PID';

      delete from catissue_cde where public_id = 'Specimen_Type_PID';
    </sql>
  </changeSet>
</databaseChangeLog>
{'fraction_non_alphanumeric': 0.1310935441370224, 'fraction_numerical': 0.015810276679841896, 'mean_word_length': 3.9, 'pattern_counts': {'":': 0, '<': 17, '<?xml version=': 2, '>': 17, 'https://': 0, 'lorem ipsum': 0, 'www.': 8, 'xml': 12}, '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': '1543748', 'n_tokens_mistral': 569, 'n_tokens_neox': 530, 'n_words': 86}