diff options
| author | Frederick Muriuki Muriithi | 2024-03-22 11:15:15 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2024-03-22 11:15:15 +0300 |
| commit | b91c9febb3e0197f683d72e7511c625b77e9cde0 (patch) | |
| tree | b4c7bb1e80befdb4fbf8eb9da03c1269a8b0bf7f | |
| parent | 5fa946c9da7896fbc5c588f339653e1b5c749269 (diff) | |
| download | genenetwork2-b91c9febb3e0197f683d72e7511c625b77e9cde0.tar.gz | |
Update ProbeSetSE table schema.
| -rw-r--r-- | scripts/updates/20240322_update_probesetse_schema.sql | 7 |
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; |