-- createVar.sql
-- Purpose: Set up table for data generated using the script var2tab
-- Author: Bernhard Haubold, haubold@evolbio.mpg.de
-- Date: 16th February 2012
-- License: GNU General Public License
drop table if exists var;
create table var(
	chrom varchar(5),
	pos int,
	id char(1),
	ref char(1),
	alt_1 char(1),
	alt_2 char(1),
	alt_3 char(1),
	qual float,
	filter char(1),
	dp int,
	af1 float,
	ci95_1 float,
	ci95_2 float,
	dp4_1 int,
	dp4_2 int,
	dp4_3 int,
	dp4_4 int,
	mq int,
	fq float,
	pv4_1 float,
	pv4_2 float,
	pv4_3 float,
	pv4_4 float,
	gt varchar(3),
	pl_1 int,
	pl_2 int,
	pl_3 int,
	pl_4 int,
	pl_5 int,
	pl_6 int,
	pl_7 int,
	pl_8 int,
	pl_9 int,
	pl_10 int,
	gq int,
	primary key(chrom,pos)
);