CREATE TABLE IF NOT EXISTS ArrayData (
        spotId INT(10) unsigned NOT NULL,
	subExpId INT(10) unsigned NOT NULL,
	log2Ratio FLOAT NOT NULL,
	log2RatioNormalized FLOAT,
	control FLOAT,
	treatment FLOAT,
	dyeCorr FLOAT, # an indicator of spot quality from GenePix

	# where on the chip
	leftPix INT(10),
	rightPix INT(10),
	topPix INT(10),
	bottomPix INT(10),

        INDEX(spotId), INDEX(subExpId)
   );
