##########################################################################
# NormalReplicants.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 NormalReplicants;
create table NormalReplicants
(
	Replicant		int			not null,
	Id				int			not null,
	AffyName		text		not null,
	Reliability		double		not null,
	Exp1			double		not null,
	Exp2			double		not null,
	Exp3			double		not null,
	AffyAnnotation	text		not null,
	
	primary key(Replicant, Id)
);
	
	