create table gvPosHg18 (
chrom		VARCHAR,
chromStart	INTEGER,
chromEnd	INTEGER,
name		VARCHAR,
strand		VARCHAR,
label		VARCHAR
);

create table gvPosHg17 (
chrom           VARCHAR,
chromStart      INTEGER,
chromEnd        INTEGER,
name            VARCHAR,
strand          VARCHAR,
label           VARCHAR
);

create table gv (
id		VARCHAR PRIMARY KEY,
name		VARCHAR,
srcId		VARCHAR,
baseChangeType	VARCHAR,
location	VARCHAR,
coordinateAccuracy	SMALLINT         --0=estimated, 1=accurate
);

create table gvAttr (
id		VARCHAR,
attrType	VARCHAR,
attrVal		VARCHAR
);

create table gvLink (
id		VARCHAR,
attrType	VARCHAR,
raKey		VARCHAR,
acc		VARCHAR,
displayVal	VARCHAR
);

create table gvSrc (
srcId		VARCHAR PRIMARY KEY,
src		VARCHAR,
lsdb		VARCHAR
);

create table srcDetails (
srcId		VARCHAR PRIMARY KEY,
url		VARCHAR,
logo		VARCHAR,
description	VARCHAR,
credits		VARCHAR
);

create table linkBuilder (
linkKey		VARCHAR PRIMARY KEY,
url		VARCHAR,
label		VARCHAR,
acc		VARCHAR,
needsEncoded	VARCHAR
);

create table gvAttributes (
attrKey		VARCHAR PRIMARY KEY,
typeDisplay	VARCHAR,
category	VARCHAR,
orderBy		INTEGER
);

