<?xml version="1.0" encoding="UTF-8"?>

<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.9"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.9
                  http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd">

    <!--
    	See http://wiki.openmrs.org/display/docs/Module+liquibase+File for
    	documentation on this file.

        See http://www.liquibase.org/manual/home#available_database_refactorings
        for a list of supported elements and attributes
    -->

 	<!-- Uncomment the changeset below if you want to make the Item class persistable, see also Item and PatientvitalsDaoTest -->

	<!-- <changeSet id="patientvitals-2016-08-02-12-21" author="raff">
		<preConditions onFail="MARK_RAN">
			<not><tableExists tableName="patientvitals_item"/></not>
		</preConditions>
		<comment>
			Creating the patientvitals_item table
		</comment>
		<createTable tableName="patientvitals_item">
			<column name="patientvitals_item_id" type="int" autoIncrement="true">
				<constraints primaryKey="true" nullable="false"/>
			</column>
			<column name="uuid" type="char(38)">
				<constraints nullable="false" unique="true"></constraints>
			</column>
			<column name="owner" type="int" />
			<column name="description" type="varchar(255)" />
		</createTable>
        <addForeignKeyConstraint constraintName="patientvitals_item_owner_fk" baseTableName="patientvitals_item" baseColumnNames="owner"  referencedTableName="users"
                                 referencedColumnNames="user_id" />

    </changeSet>  -->


 <changeSet id="patientvitals-2016-08-02-12-21" author="Tendo Kiiza Martyn">
 			<preConditions onFail="MARK_RAN">
			<not><tableExists tableName="PATIENTVITALS"/></not>
		</preConditions>
        <createTable tableName="patientvitals_item">
        <column name="patientvitals_item_id" type="int" autoIncrement="true">
				<constraints primaryKey="true" nullable="false"/>	<column/>
            <column name="blood_pressure" type="varchar(255)"/>
             <column name="bmi" type="float"/>
            <column name="description" type="String"/>
            <column name="height" type="float"/>
            <column name="owner" type="User"/>
             <column name="pulse_rate" type="int"/>
            <column name="temperature" type="int"/>
            <column name="weight" type="int"/>
        </createTable>
        <addForeignKeyConstraint constraintName="patientvitals_item_owner_fk" baseTableName="patientvitals_item" baseColumnNames="owner"  referencedTableName="users"
                                 referencedColumnNames="user_id" />
    </changeSet>
</databaseChangeLog>