Skip to content

Instantly share code, notes, and snippets.

@bharatak
Created April 25, 2016 04:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bharatak/26ac0cf19335499c579c9307cc42fd69 to your computer and use it in GitHub Desktop.
Save bharatak/26ac0cf19335499c579c9307cc42fd69 to your computer and use it in GitHub Desktop.
Appointment Module Liquibase migrations
<changeSet id="JSS-201509232323" author="Swathi, Jaswanth" context="rel0.76">
<preConditions onFail="MARK_RAN">
<sqlCheck expectedResult="0">
SELECT COUNT(*) FROM person_attribute_type where name = 'Telephone Number';
</sqlCheck>
</preConditions>
<comment>Adding Telephone Number person attribute type</comment>
<sql>
INSERT INTO person_attribute_type (name, description, format, searchable, creator, date_created, retired, sort_weight, uuid) VALUES ('Telephone Number', 'Telephone Number', 'java.lang.String', '0', 1, now(), 0, 3, uuid());
</sql>
</changeSet>
<changeSet id="JSS-201509232326" author="Swathi, Jaswanth" context="rel0.76">
<preConditions onFail="MARK_RAN">
<sqlCheck expectedResult="0">
SELECT COUNT(*) FROM person_attribute_type where name = 'Unknown patient';
</sqlCheck>
</preConditions>
<comment>Adding Unknown patient person attribute type</comment>
<sql>
INSERT INTO person_attribute_type (name, description, format, searchable, creator, date_created, retired, sort_weight, uuid) VALUES ('Unknown patient', 'Unknown Patient', 'java.lang.String', '0', 1, now(), 0, 3, uuid());
</sql>
</changeSet>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment