Ispyb

-------------------

Return additional columns in the ``retrieve_scm_sample*`` stored procedures:

* qMin
* qMax
* reductionParametersAveraging

-------------------

New versions of stored procedures:

* ``upsert_particle_picker_v2`` - new parameter ``p_summaryImageFullPath``
* ``upsert_particle_classification_v2`` - new parameter ``p_classDistribution``

-------------------

Column changes:

* In ``Screening``: new column ``autoProcProgramId``
* In ``AutoProcScalingStatistics``: new column ``resIOverSigI2`` (resolution where I/Sigma(I) equals 2)
* In ``AutoProcProgram``: removed column ``dataCollectionId`` and its foreign key constraint
* In ``ProposalHasPerson``: added enum option 'Associate' to the role column
* In ``Session_has_Person``: added enum option 'Associate' to the role column

Added tables:

* ``Positioner``: An arbitrary positioner and its value, could be e.g. a motor. Allows for instance to store some positions with a sample or subsample
* ``BLSample_has_Positioner``
* ``BLSubSample_has_Positioner``

Stored procedure changes:

* ``upsert_session_for_proposal_code_number``: This is now truly an "upsert" procedure, as it allows specifying an existing session either through p_id OR through p_proposalCode + p_proposalNumber + p_visitNumber.
* ``insert_processing_scaling_v2``: Version 2 of ``insert_processing_scaling`` which allows writing to the new ``AutoProcScalingStatistics.resIOverSigI2`` column.

Grants for the new stored procedure and some table grants have also been added.

-------------------

New columns:

* ``DiffractionPlan``: ``qMin``, ``qMax``, ``reductionParametersAveraging``
* ``ParticleClassification``: ``classDistribution``
* ``ParticlePicker``: ``summaryImageFullPath``
* ``BLSampleGroup``: ``proposalId`` (and populate it based on ``BLSampleGroup_has_BLSample -> BLSample -> Crystal -> Protein.proposalId``)

New tables:

* ``zc_ZocaloBuffer``: A table for temporary Zocalo data.

Lookup table data changes:

* ``SpaceGroup``: Changed a few ``spaceGroupShortName`` values for common spacegroups, and set ``MX_used = 0`` for less commonly used spacegroups.
* ``UserGroup``: Add groups ``detector_admin``, ``prop_admin``, ``goods_handling``, ``imaging_admin``, ``spectroscopy_admin``, ``mm_admin``.

Additionally, new enum options have been added to DataCollectionGroup.experimentType: Mesh3D, Screening.

-------------------

New stored programs:

* Function retrieve_proposal_title_v2
* Procedure upsert_mx_sample

-------------------

* Updated ``schemas/ispyb/routines.sql`` with the changes to stored procedure ``retrieve_sample sproc``.