##########################################################################
# RawReplicants.sql:  MySQL source file for the Simcal1 module.          #
# Copyright (c) 2004 Daniel Dvorkin.                                     #
# Distributed under the Artistic License, WITHOUT "optional clause 8"    #
# (see http://www.opensource.org/licenses/artistic-license.php).         #
# All rights not granted in this license are reserved by the author.     #
##########################################################################

drop table if exists RawReplicants;
create table RawReplicants
(
	Replicant		int			not null,
	Id				int			not null,
	AffyName		text		not null,
	Pvalue			double		not null,
	Control			double		not null,
	Iso1			double		not null,
	Iso2			double		not null,
	Iso3			double		not null,
	Psr1			double		not null,
	Psr2			double		not null,
	Psr3			double		not null,
	AffyAnnotation	text		not null,
	
	primary key(Replicant, Id)
);