Database changes in Platform since 1.10.0

Platform 2.0-alpha is about to be released and as we move towards Platform 2.0-Beta, the main focus is to expose a wider range of our core API through the webservices.rest module. As suggested by @darius, a good way to find what new features need to be introduced in the webservices.rest module would be look at the database changes. Thanks to @burke’s groovy script, here are the database changes between Platform 2.0.0-alpha and OpenMRS 1.10.0. (assumption : when OpenMRS 1.10.0 was released, the webservices.rest module provides access to >90% of core services)

  1. Reverting concept name type to NULL for concepts having names tagged as default
  2. Setting concept name type to fully specified for names tagged as default
  3. (Fixed)Change person_merge_log.voided to BOOLEAN
  4. Adding uniqueness_behavior column to patient_identifier_type table
  5. Dropping the drug_ingredient table
  6. Creating the drug_ingredient table
  7. Adding a primary key to the drug_ingredient table
  8. Adding a new foreign key from drug_ingredient.units to concept.concept_id
  9. Adding a new foreign key from drug_ingredient.drug_id to drug.drug_id
  10. Adding a new foreign key from drug_ingredient.ingredient_id to concept.concept_id
  11. Inserting the new application privileges
  12. Inserting the new API privileges
  13. Granting the new patient overview tab application privileges
  14. Assigning the new API-level privileges to roles that used to have the renamed privileges
  15. Increasing the size of the privilege column in the privilege table
  16. Increasing the size of the privilege column in the role_privilege table
  17. Add optional property view_privilege to encounter_type table
  18. Add optional property edit_privilege to encounter_type table
  19. Adding not-null constraint to orders.as_needed
  20. Changing test_order.laterality to be a varchar
  21. Adding FK constraint for test_order.specimen_source if necessary
  22. Normalize varchar length of locale columns
  23. Removing concept set derived table
  24. Dropping not null constraint from concept_class.description column
  25. Dropping not null constraint from concept_datatype.description column
  26. Dropping not null constraint from patient_identifier_type.description column
  27. Dropping not null constraint from person_attribute_type.description column
  28. Dropping not null constraint from privilege.description column
  29. Dropping not null constraint from role.description column
  30. Dropping not null constraint from relationship_type.description column
  31. Dropping not null constraint from encounter_type.description column
  32. Adding deathdate_estimated column to person.
  33. Adding configurability to Patient Header on Dashboard. Therefore the cd4_count property is dropped and replaced with a header.showConcept property.
  34. Adding “display_precision” column to concept_numeric table
  35. Custom changesets to identify and resolve duplicate EncounterRole names
  36. Custom changesets to identify and resolve duplicate EncounterType names
  37. Adding the unique constraint to the encounter_type.name column
  38. Adding the unique constraint to the encounter_role.name column
  39. Rename concept_numeric.precise to concept_numeric.allow_decimal
  40. Custom changeset to identify and resolve duplicate Location Attribute Type names
  41. Adding the unique constraint to the location_attribute_type.name column
  42. Removing the concept_word table (replaced by Lucene)
  43. Deleting the update concept index task
  44. Removing invalid foreign key constraint from order_type.parent column to order.order_id column
  45. Adding foreign key constraint from order_type.parent column to order_type.order_type_id column
  46. Updating description for visits.encounterTypeToVisitTypeMapping GP to the value set in OpenmrsContants
  47. Dropping foreign key on patient.tribe
  48. Dropping the tribe field from patient table because it has been moved to person_attribute.
  49. Dropping not null constraint from program.description column
  50. Dropping not null constraint from order_type.description column
  51. Dropping not null constraint from concept_name_tag.description column
  52. Dropping not null constraint from active_list_type.description column
  53. Adding form_namespace_and_path column to obs table
  54. Renaming drug_ingredient.quantity to strength
  55. Updating layout.address.format global property
  56. Removing dashboard.regimen.standardRegimens global property
  57. Encrypting the users.secret_answer column
  58. Temporarily removing foreign key constraint from person_attribute_type.edit_privilege column
  59. Temporarily removing foreign key constraint from role_privilege.privilege column
  60. Increasing the size of the privilege column in the privilege table
  61. Adding foreign key constraint to person_attribute_type.edit_privilege column
  62. Increasing the size of the privilege column in the role_privilege table
  63. Adding foreign key constraint to role_privilege.privilege column
  64. Adding foreign key on patient_identifier.patient_id column
  65. Adding birthtime column to person
  66. Add changed_by column to encounter_type table
  67. Add date_changed column to encounter_type table
  68. Add an index to the global_property.property column
  69. Add an index to the concept_class.name column
  70. Add an index to the concept_datatype.name column
  71. Create allergy table
  72. Create allergy_reaction table
  73. Add allergy_status field to the patient table
  74. Custom changeset to migrate allergies from old to new tables
  75. Removing the active_list_problem table (active_list feature removed)
  76. Removing the active_list_allergy table (active_list feature removed)
  77. Removing the active_list table (active_list feature removed)
  78. Removing the active_list_type table (active_list feature removed)
  79. Add drug_non_coded column to drug_order table
  80. Adding address columns (7-15) to person_address and location
2 Likes

Hi Dev’s

To track progress on this issue, we will be using the following issue :

Feel free to claim it!