<?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">

  <property name="now" value="now()"   dbms="mysql" />
  <property name="now" value="sysdate" dbms="oracle" />

  <changeSet author="vlonushte" id="Cohort PV category">
    <sql>
      insert into catissue_cde
        (public_id, long_name, definition, version, last_updated)
      values
        ('cohort', 'Cohort', 'Cohort', '2.2', ${now})
    </sql>
  </changeSet>
</databaseChangeLog>

<?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">

  <property name="now" value="now()"   dbms="mysql" />
  <property name="now" value="sysdate" dbms="oracle" />

  <changeSet author="vlonushte" id="Cohort PV category">
    <sql>
      insert into catissue_cde
        (public_id, long_name, definition, version, last_updated)
      values
        ('cohort', 'Cohort', 'Cohort', '2.2', ${now})
    </sql>
  </changeSet>

  <changeSet author="ahegade" id="Update specimen unit table with concentration measures">
    <sql>
      update
        OS_SPECIMEN_UNITS
      set
        CONC_UNIT = 'cells'
      where
        SPECIMEN_CLASS = 'Cell';

      update
        OS_SPECIMEN_UNITS
      set
        CONC_UNIT = 'microgram/ml',
        CONC_HTML_DISPLAY_CODE='&#181;g/ml'
      where
        SPECIMEN_CLASS in ('Molecular', 'Fluid', 'Tissue');

    </sql>
  </changeSet>
</databaseChangeLog>

Allow "Concentration" field to all specimen classes
OPSMN-2454: Allow "Concentration" field to all specimen classes

- Adding seedadata for concentration measures.
