Revision 4bbad921 hg18/makeDb.sql
| b/hg18/makeDb.sql | ||
|---|---|---|
| 201 | 201 |
); |
| 202 | 202 |
load data local infile "scaffoldInfo" into table scaffoldInfo; |
| 203 | 203 |
|
| 204 |
|
|
| 205 |
drop table if exists publichub; |
|
| 206 |
create table publichub ( |
|
| 207 |
id varchar(255) not null primary key, |
|
| 208 |
name varchar(255) not null, |
|
| 209 |
logo text null, |
|
| 210 |
url text not null, |
|
| 211 |
institution text not null, |
|
| 212 |
description text not null |
|
| 213 |
); |
|
| 214 |
load data local infile 'publichub' into table publichub; |
|
Also available in: Unified diff