search

ispyb / ispyb-database-modeling

4 stars 3 forks source link

Add a name column to the BLSampleGroup table #61

Closed KarlLevik closed 3 years ago

KarlLevik commented 3 years ago

We have a BLSampleGroup table which has only the primary key column - no other columns! This is not so useful, so we want to add a name column:


ALTER TABLE BLSampleGroup ADD name varchar(100) COMMENT 'Human-readable name';```
KarlLevik commented 3 years ago

ISPyB dev. collaboration meeting 2020-09-09: We agreed I could go ahead and make a pull request for this. BLSampleGroup is only used at Diamond so far, although the table does exist in the pydb schema as well.

KarlLevik commented 3 years ago

PR accepted.