DB Migration / Fix things

bmlt-enabled / bmlt-root-server

This is the Main Root Server Repo for the Basic Meeting List Toolbox

MIT License

13 stars 14 forks source link

Open pjaudiomv opened 1 month ago

pjaudiomv commented 1 month ago

This is here to track various data integrity items either due to old servers data or just in general

pjaudiomv commented 1 month ago

empty fields vs NULL. 2.x Servers would have empty strings in _comdef_meetings_main and in 3.x these fields are NULL.
a _comdef_meetings_data field for instance location_neighborhood could me an empty string. in 3.x this row would be removed and not exist.

A side effect of this is they show up as meeting changes. IE. email was changed from "" to "".

alanb2718 commented 1 month ago

Some others:

meetings that refer to a format that no longer exists
meetings owned by a service body that was deleted
service bodies with editors that no longer exist
(maybe - since this is not currently checked for) different formats with the same key in the same language, e.g. two formats with key B in English