mri_protocol table's ScannerID is set to 0 in RaisinBread and not nullable #7476
Labels
Category: Bug
PR or issue that aims to report or fix a bug
Language: SQL
PR or issue that update SQL code
The
ScannerID
field of themri_protocol
table has been modified to add a foreign key constraint with theID
field of themri_scanner
table.Historically, we used to set the
ScannerID
field of themri_protocol
table to0
when a protocol is valid on all study's scanners. Instead of setting theScannerID
field to0
when an MRI protocol should be valid across all scanners, we should allow forNULL
values in theScannerID
field of themri_protocol
table.TODOs:
NULL
values:Loris/SQL/0000-00-00-schema.sql
Line 623 in 12041ad
mri_protocol
table in https://github.com/aces/Loris/tree/main/SQL/New_patches so that existing LORIS instances can update theirmri_protocol
tableScannerID
of themri_protocol
table toNULL
instead of0
in the following file: https://github.com/aces/Loris/blob/main/raisinbread/RB_files/RB_mri_protocol.sqlThe text was updated successfully, but these errors were encountered: