--
-- Table structure for table `pics`
--

CREATE TABLE pics (
  PicID smallint(5) unsigned NOT NULL auto_increment,
  PicFileName varchar(255) binary NOT NULL default '',
  PicWidth smallint(5) unsigned NOT NULL default '0',
  PicHeight smallint(5) unsigned NOT NULL default '0',
  PicSize int(10) unsigned NOT NULL default '0',
  ThumbWidth tinyint(3) unsigned NOT NULL default '0',
  ThumbHeight tinyint(3) unsigned NOT NULL default '0',
  pichitcount smallint(5) unsigned NOT NULL default '0',
  IsAvailable enum('Y','N') NOT NULL default 'Y',
  DateAdded date NOT NULL default '0000-00-00',
  md5sum varchar(32) NOT NULL default '',
  Location enum('hellmouth','bikergeeks','asylum') NOT NULL default 'hellmouth',
  PRIMARY KEY  (PicID),
  UNIQUE KEY PicFileName (PicFileName),
  UNIQUE KEY md5sum (md5sum),
  KEY pichitcount (pichitcount),
  KEY IsAvailable (IsAvailable),
  KEY picfiledata (PicID,PicFileName,PicWidth,PicHeight,PicSize,ThumbWidth,ThumbHeight,IsAvailable)
) TYPE=MyISAM;
