search

FreeHealth / freehealth

Free and open source Electronic Health Record
https://freehealth.io
Other
44 stars 16 forks source link

Drop column TO_PRACT_LKID in table PATIENT_IDENTITY #112

Open jeromecc opened 6 years ago

jeromecc commented 6 years ago

Drop column TO_PRACT_LKID in table PATIENT_IDENTITY (it contains only the value 1 because of the buffy user link id stuff so no data will be lost). Replace by binary(16) column of optimized version of UUID version 1.

This should be done after updating createUuid to produce type 1 UUIDs.

See https://github.com/FreeHealth/freehealth/issues/111

jeromecc commented 6 years ago

Column cannot be dropped for now because it is impractical with SQLite. We shall remove it when we get rid of SQLite.