-- MySQL dump 9.11
--
-- Host: localhost    Database: visiGene
-- ------------------------------------------------------
-- Server version	4.0.27-standard-log

--
-- Table structure for table `imageFile`
--

CREATE TABLE imageFile (
  id int(11) NOT NULL auto_increment,
  fileName varchar(255) NOT NULL default '',
  priority float NOT NULL default '0',
  imageWidth int(11) NOT NULL default '0',
  imageHeight int(11) NOT NULL default '0',
  fullLocation int(11) NOT NULL default '0',
  thumbLocation int(11) NOT NULL default '0',
  submissionSet int(11) NOT NULL default '0',
  submitId varchar(255) NOT NULL default '',
  caption int(11) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY fullLocation (fullLocation,fileName(12)),
  KEY submissionSet (submissionSet),
  KEY submitId (submitId(12)),
  KEY submissionSet_2 (submissionSet,submitId(8))
) TYPE=MyISAM;
