blob: 611e2dd6e50e364b5f414408a1486d155123378a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
#! /bin/bash
#
# Add missing columns to test db downloaded from:
# https://s3.amazonaws.com/genenetwork2/db_webqtl_s.zip
QUERY="
ALTER TABLE InbredSet
ADD Family varchar(20) AFTER FullName,
ADD FamilyOrder varchar(20) AFTER Family,
ADD MenuOrderId smallint(6) AFTER FamilyOrder,
ADD InbredSetCode varchar(5) AFTER MenuOrderId;
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;
"
USER=gn2
DBNAME=db_webqtl_s
PASS=mysql_password
mysql -u"$USER" -p"$PASS" -h localhost -D "$DBNAME" -e "$QUERY"
|
