Advertisement
Guest User

Untitled

a guest
Mar 14th, 2021
22
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <changeSet id="nigeriaemr-2020-07-06" author="wande">
  2. <comment>
  3. Creating the nigeriaemr_ndr export table
  4. </comment>
  5. <createTable tableName="nigeriaemr_ndr_export">
  6. <column name="nigeriaemr_ndr_export_id" type="int" autoIncrement="true">
  7. <constraints primaryKey="true" nullable="false"/>
  8. </column>
  9. <column name="owner" type="int" />
  10. <column name="total_number_of_patients" type="int" />
  11. <column name="total_number_of_patients_processed" type="int" defaultValue="0" />
  12. <column name="date_started" type="TIMESTAMP" />
  13. <column name="date_ended" type="TIMESTAMP" defaultValueDate="now()"/>
  14. <column name="path" type="varchar(255)"/>
  15. <column name="status" type="varchar(25)"/>
  16. <column name="voided" type="BIT(1)"/>
  17. <column name="name" type="varchar(255)"/>
  18. <column name="report_folder" type="varchar(255)"/>
  19. <column name="context_path" type="varchar(255)"/>
  20. </createTable>
  21. </changeSet>
Advertisement
RAW Paste Data Copied
Advertisement