<changeSet id="nigeriaemr-2020-07-06" author="wande">
		<comment>
			Creating the nigeriaemr_ndr export table
		</comment>
		<createTable tableName="nigeriaemr_ndr_export">
			<column name="nigeriaemr_ndr_export_id" type="int" autoIncrement="true">
				<constraints primaryKey="true" nullable="false"/>
			</column>
			<column name="owner" type="int" />
            <column name="total_number_of_patients" type="int" />
            <column name="total_number_of_patients_processed" type="int" defaultValue="0" />
            <column name="date_started" type="TIMESTAMP" />
            <column name="date_ended" type="TIMESTAMP"  defaultValueDate="now()"/>
			<column name="path" type="varchar(255)"/>
			<column name="status" type="varchar(25)"/>
			<column name="voided" type="BIT(1)"/>
			<column name="name" type="varchar(255)"/>
			<column name="report_folder" type="varchar(255)"/>
			<column name="context_path" type="varchar(255)"/>
		</createTable>
    </changeSet>