From 9a15bae9743972d2aef5d3a4368104387bf8f78c Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Fri, 22 Mar 2024 10:23:31 +0300
Subject: Database: Provide query to solve issue.

---
 issues/database-ProbeSetSE-schema-bug.gmi | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'issues/database-ProbeSetSE-schema-bug.gmi')

diff --git a/issues/database-ProbeSetSE-schema-bug.gmi b/issues/database-ProbeSetSE-schema-bug.gmi
index a451002..39d02f8 100644
--- a/issues/database-ProbeSetSE-schema-bug.gmi
+++ b/issues/database-ProbeSetSE-schema-bug.gmi
@@ -50,3 +50,12 @@ MariaDB [db_webqtl]> DESC ProbeSetSE;
 From this, you can see that "ProbeSetSE" has the column "StrainId" but with a different size integer (smaller) than that in table "Strain". This could at best, cause errors when inserting data, if the strain exceeds the value 65535, or at worst, do a silent conversion of inserted "StrainId" values into a value in the range [0, 65535] leading to data corruption.
 
 The schema needs to be updated accordingly.
+
+
+## Solution
+
+Run this query against the database:
+
+```
+ALTER TABLE ProbeSetSE MODIFY StrainId INT(20) NOT NULL;
+```
-- 
cgit v1.2.3