search

ispyb / ISPyB

ISPyB
https://ispyb.github.io/ISPyB/
12 stars 29 forks source link

Update the Database schema with missing fields #310

Open delageniere opened 6 years ago

delageniere commented 6 years ago

The ccAno and sigAno fields in AutoProcScalingStatistics. They were added in 2016_12_06_Added_ccAno_sigAno.sql but are not present in .mdb file.

Check if there are other fields, then update the .mdb and the .pdf present on: https://github.com/ispyb/ISPyB/tree/master/documentation/database

delageniere commented 6 years ago

There has been a problem of updating : the correct schema was ISPyB_dataModel_5.mwb, but in the 5.5.0 there are a lot of missing tables/fields.

It seems necessary to restart from the ISPyB_dataModel_5.mwb adding the fileds specific to 5.5.0

antolinos commented 6 years ago

We should probably just update one scheme with no version (ispyb.mwb) and then remove the rest of them.

delageniere commented 6 years ago

Yes, I agree, that makes sense and would avoid this type of problem.

On 26/06/2018 17:04, antolinos wrote:

We should probably just update one scheme with no version (ispyb.mwb) and then remove the rest of them.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/ispyb/ISPyB/issues/310#issuecomment-400343455, or mute the thread https://github.com/notifications/unsubscribe-auth/ALsNf4_KxuIyzs04S-Ag55X7hLqaPNP9ks5uAk12gaJpZM4UgL-A.