<changeSet id="TRUNK-5413" author="odorajonathan">
      <preConditions onFail="MARK_RAN">
            <not><columnExists tableName="order_set" columnName="category"/></not>
      </preConditions>
      <comment>
          Add a category field to the order_set table
      </comment>
      <addColumn tableName="order_set">
            <column name="category" type="int"/>
      </addColumn>
      <addForeignKeyConstraint constraintName="category_order_set_fk" referencedTableName="concept"
      baseColumnNames="category" baseTableName="order_set" referencedColumnNames="concept_id"/>
    </changeSet>

 <changeSet id="" author="">
    <addColumn tableName="drug">
            <column name="pre_conditions" type="varchar(50)" >
    			<constraints nullable="false"/>
    		</column>
            <column name="blood_group" type="varchar(50)">
            <constraints nullable="false"/>
    		</column>
            <column name="rh_type" type="varchar(50)">
            <constraints nullable="false"/>
    		</column>
            <column name="habits" type="varchar(50)">
            <constraints nullable="false"/>
    		</column>
            <column name="ethnicity" type="varchar(50)">
            <constraints nullable="false"/>
            </column>
        </addColumn>
    </changeSet>