blob: 70d5fdeb022807a2ce4ef0543366930f8f3211d9 (
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
|
#! /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;
-- 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"
|
