--
-- Definition of table `eaglebre_linpha`.`anluke_photos`
--

DROP TABLE IF EXISTS `eaglebre_linpha`.`anluke_photos`;
CREATE TABLE  `eaglebre_linpha`.`anluke_photos` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `name` varchar(255) default NULL,
  `filename` varchar(255) NOT NULL,
  `thumbnail` mediumblob,
  `prev_path` varchar(255) default NULL,
  `level` tinyint(3) unsigned default NULL,
  `res` int(5) NOT NULL default '0',
  `md5sum` varchar(40) default NULL,
  `downloads` mediumint(9) default NULL,
  `fmkey_location` varchar(100) default NULL,
  `fmkey_type` varchar(100) default NULL,
  `fmkey_date` varchar(100) default NULL,
  `rotation` varchar(10) default '0',
  PRIMARY KEY  (`ID`),
  KEY `date` (`date`),
  KEY `name` (`name`),
  KEY `filename` (`filename`),
  KEY `res` (`res`),
  KEY `md5sum` (`md5sum`),
  KEY `prev_path` (`prev_path`)
) ENGINE=MyISAM AUTO_INCREMENT=5458 DEFAULT CHARSET=latin1;