##########################################################################
# ClusterGenes.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 ClusterGenes;
create table ClusterGenes
(
	# attributes
	ClusterId			int			not null,
	GeneId				int			not null,
	Rank				tinyint		not null,
	
	# key definition
	primary key(ClusterId, GeneId, Rank),
	index cg_gene(GeneId),
	index cg_rank(Rank)
);
	
	