From b91c9febb3e0197f683d72e7511c625b77e9cde0 Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Fri, 22 Mar 2024 11:15:15 +0300
Subject: Update ProbeSetSE table schema.

---
 scripts/updates/20240322_update_probesetse_schema.sql | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 scripts/updates/20240322_update_probesetse_schema.sql

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;
-- 
cgit v1.2.3