search

ispyb / ispyb-database-modeling

4 stars 3 forks source link

New enum options for DataCollectionGroup.experimentType to support serial crystallography #27

Open KarlLevik opened 6 years ago

KarlLevik commented 6 years ago

We (DLS) would like to add two new options to DCG experimentType in order to support serial crystallography: 'Serial Fixed' and 'Serial Jet'.

In the DLS fork of the database schema the following DDL will add the needed options:

ALTER TABLE DataCollectionGroup 
  MODIFY experimentType enum('SAD','SAD - Inverse Beam','OSC',
    'Collect - Multiwedge','MAD','Helical','Multi-positional','Mesh','Burn',
    'MAD - Inverse Beam','Characterization','Dehydration','tomo','experiment','EM','PDF',
    'PDF+Bragg','Bragg','single particle', 'Serial Fixed', 'Serial Jet'), 
ALGORITHM=INPLACE;
KarlLevik commented 5 years ago

Agreed at VC meeting today.