 CREATE TABLE stat_result_phenotype_call_summary (
 	categorical_result_id     INT(10) UNSIGNED DEFAULT NULL,
 	unidimensional_result_id  INT(10) UNSIGNED DEFAULT NULL,
-  rrplus_result_id          INT(10) UNSIGNED DEFAULT NULL,
+	rrplus_result_id          INT(10) UNSIGNED DEFAULT NULL,
 	phenotype_call_summary_id INT(10) UNSIGNED NOT NULL,
 
 	PRIMARY KEY (phenotype_call_summary_id),

CREATE TABLE phenotyped_colony (
	id                                          INT(11)     NOT NULL AUTO_INCREMENT,
	colony_name                                 VARCHAR(64) NOT NULL,
	es_cell_name                                VARCHAR(64),
	gf_acc                                      VARCHAR(20) NOT NULL,
	gf_db_id                                    INT(11)     NOT NULL,
	allele_symbol                               VARCHAR(64) NOT NULL,


	PRIMARY KEY (id),
	KEY observation_id_idx (observation_id),
	UNIQUE KEY parameter_association_uk (observation_id, parameter_id, parameter_association_value(287))	-- 287 is the maximum key length. Anything greater throws a 'key too long' error.

) COLLATE=utf8_general_ci ENGINE=MyISAM ;

