DELIMITER $$

DROP PROCEDURE IF EXISTS `create_icis_indexes`$$

CREATE PROCEDURE `create_icis_indexes`()
BEGIN
	
	-- Factor Indexes
	CREATE INDEX gid1_idx on Factors (`251.91.17`);
	CREATE INDEX gid2_idx on Factors (`251.93.17`);
	CREATE INDEX gid3_idx on Factors (`251.97.17`);
	CREATE INDEX gid4_idx on Factors (`251.103.17`);
	
	-- Variates Indexes
	CREATE INDEX endo_type_idx on Variates (`1262.640.638`);
	
	CREATE INDEX seed_coat_idx on Variates (`1266.615.612`);
	
	CREATE INDEX subm_idx on Variates (`1215.27.4`);
	
	CREATE INDEX cco_rev_veg_idx on Variates (`1077.650.647`);
	
	CREATE INDEX sheath_blight_idx on Variates (`1118.23.45`);
	
	CREATE INDEX drt4_idx on Variates (`1206.28.48`);	
	
	CREATE INDEX grn_shape_idx on Variates (`1053.1539.853`);
	
	CREATE INDEX grn_elong_idx on Variates (`1254.132.122`);
	
	CREATE INDEX grn_width_idx on Variates (`1052.637.635`);	
	
	CREATE INDEX grn_length1_idx on Variates (`1051.1540.36`);
	CREATE INDEX grn_length2_idx on Variates (`1051.638.636`);
	
	CREATE INDEX grn_weight1_idx on Variates (`1264.636.634`);
	CREATE INDEX grn_weight2_idx on Variates (`1264.636.566`);
	CREATE INDEX grn_weight3_idx on Variates (`1264.636.567`);

	CREATE INDEX blast1_idx on Variates (`1104.21.157`);
	CREATE INDEX blast2_idx on Variates (`1104.21.43`);
	CREATE INDEX blast3_idx on Variates (`1119.168.158`);
	CREATE INDEX blast4_idx on Variates (`1119.167.158`);
	
	CREATE INDEX grn_yld1_idx on Variates (`1003.9.30`);
	CREATE INDEX grn_yld2_idx on Variates (`1003.153.30`);
	CREATE INDEX grn_yld3_idx on Variates (`1003.1535.851`);
	CREATE INDEX grn_yld4_idx on Variates (`1003.1528.851`);
	CREATE INDEX grn_yld5_idx on Variates (`1003.154.30`);	
	
	CREATE INDEX blight1_idx on Variates (`1101.164.44`);
	CREATE INDEX blight2_idx on Variates (`1101.163.335`);
	CREATE INDEX blight3_idx on Variates (`1101.164.119`);
	CREATE INDEX blight4_idx on Variates (`1101.163.334`);
	CREATE INDEX blight5_idx on Variates (`1101.163.733`);	
	
	CREATE INDEX mat1_idx on Variates (`1006.4.24`);
	CREATE INDEX mat2_idx on Variates (`1005.8.29`);
	CREATE INDEX mat3_idx on Variates (`1012.3.23`);
	CREATE INDEX mat4_idx on Variates (`1051.1540.36`);
	CREATE INDEX mat5_idx on Variates (`1053.1539.853`);
	CREATE INDEX mat6_idx on Variates (`1012.625.623`);
	CREATE INDEX mat7_idx on Variates (`1006.4.792`)
	CREATE INDEX mat8_idx on Variates (`1005.1529.29`);
	CREATE INDEX mat9_idx on Variates (`1204.171.47`);
	CREATE INDEX mat10_idx on Variates (`1005.93.29`);
	CREATE INDEX mat11_idx on Variates (`1006.352.24`);	

END$$

DELIMITER ;