From b0f137449b7b9e33f97871ec0aeb519952c87080 Mon Sep 17 00:00:00 2001 From: Frederick Muriuki Muriithi Date: Wed, 13 Mar 2024 04:30:23 +0300 Subject: Add link to script to migrate `CaseAttribute*` tables' schemas. --- topics/editing/case_attributes.gmi | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/topics/editing/case_attributes.gmi b/topics/editing/case_attributes.gmi index 541c689..5a11026 100644 --- a/topics/editing/case_attributes.gmi +++ b/topics/editing/case_attributes.gmi @@ -93,6 +93,10 @@ while the `CaseAttributeXRefNew` table ends up with the following columns: There will not be any `NULL` values allowed for any of the columns in both tables. If a strain has no value, we simply delete the corresponding record from the `CaseAttributeXRefNew` table. +To that end, the following script has been added to ease the migration of the table schemas: +=> https://github.com/genenetwork/genenetwork3/blob/dd0b29c07017ec398c447ca683dd4b4be18d73b7/scripts/update-case-attribute-tables-20230818 +The script is meant to be run only once, and makes the changes mentioned above for both tables. + ## Data Types > ... (and exist separately from "normal" traits mainly because they're non-numeric) -- cgit v1.2.3