aboutsummaryrefslogtreecommitdiff
path: root/scripts/add_missing_columns.sh
diff options
context:
space:
mode:
authorBonfaceKilz2021-08-16 11:13:40 +0300
committerBonfaceKilz2021-08-16 11:13:40 +0300
commit7f2a1f9d1b91b9d0d24da56afcfe26197a434af3 (patch)
tree70a1b1e3b7af25772a77e78779565b6de73b65c8 /scripts/add_missing_columns.sh
parent579ae94b08f0b1cef00350b54dadc12869ad70de (diff)
downloadgenenetwork2-7f2a1f9d1b91b9d0d24da56afcfe26197a434af3.tar.gz
Add "Description" column to CaseAttribute
See: eecaad2d
Diffstat (limited to 'scripts/add_missing_columns.sh')
-rw-r--r--scripts/add_missing_columns.sh3
1 files changed, 3 insertions, 0 deletions
diff --git a/scripts/add_missing_columns.sh b/scripts/add_missing_columns.sh
index 70d5fdeb..611e2dd6 100644
--- a/scripts/add_missing_columns.sh
+++ b/scripts/add_missing_columns.sh
@@ -13,6 +13,9 @@
ALTER TABLE PublishXRef
ADD mean double AFTER DataId;
+ ALTER TABLE CaseAttribute
+ ADD Description varchar(255) AFTER Name;
+
-- This takes some time
ALTER TABLE ProbeSet
ADD UniProtID varchar(20) AFTER ProteinName;