summaryrefslogtreecommitdiff
path: root/topics/editing
diff options
context:
space:
mode:
authorFrederick Muriuki Muriithi2024-03-13 04:30:23 +0300
committerFrederick Muriuki Muriithi2024-03-13 04:30:23 +0300
commitb0f137449b7b9e33f97871ec0aeb519952c87080 (patch)
tree2005c5b576e66801d213f235d984c5c96f9500a6 /topics/editing
parentd2fcd0582882c200679105b6df99f62f56ea75d6 (diff)
downloadgn-gemtext-b0f137449b7b9e33f97871ec0aeb519952c87080.tar.gz
Add link to script to migrate `CaseAttribute*` tables' schemas.
Diffstat (limited to 'topics/editing')
-rw-r--r--topics/editing/case_attributes.gmi4
1 files changed, 4 insertions, 0 deletions
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)