The Current implementation of Patient Flags uses SQLDIFF to deploy tables relevant to It. Some tables are UTF8 and others are not. Its complex to cotroll versions in SQLDIFF implementation than in liquibase. The Current implemenation is causing migration issues whenever there is a change. It is importing to migrate the module to use liquibase changesets from the SQLDIFF which are currently being used.
Must have all the SQL statement from sqldiff.xml file to liqubase statements into the liquibase.xml file.
SQLDIFF File will not have any statement left that creates or changes the database
The following tables must be created when the module is deployed:
The source code is at https://github.com/openmrs/openmrs-module-patientflags