Update ProbeSetSE table schema.

1 files changed, 7 insertions, 0 deletions

diff --git a/scripts/updates/20240322_update_probesetse_schema.sql b/scripts/updates/20240322_update_probesetse_schema.sql
new file mode 100644
index 00000000..dcd097ad
--- /dev/null
+++ b/scripts/updates/20240322_update_probesetse_schema.sql
@@ -0,0 +1,7 @@
+-- Issue: https://github.com/genenetwork/gn-gemtext-threads/blob/9a15bae9743972d2aef5d3a4368104387bf8f78c/issues/database-ProbeSetSE-schema-bug.gmi
+-- The `Strain`(`Id`) column's datatype was `INT(20)` before this is run
+-- The related `ProbeSetSE`(`StrainId`) column was `SMALLINT(5)`
+-- This would lead to errors when inserting, or data corruption
+-- The query below updates the schema to make the dependent `ProbeSet(`StrainId`)`
+-- column the same data type as the parent `Strain`(`Id`) column.
+ALTER TABLE ProbeSetSE MODIFY StrainId INT(20) NOT NULL;