-- MySQL dump 10.9
--
-- Host: asylum    Database: music
-- ------------------------------------------------------
-- Server version	4.1.19-log

--
-- Table structure for table `tunes`
--

CREATE TABLE `tunes` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `Path` varchar(250) NOT NULL default '',
  `FileName` varbinary(250) NOT NULL default '',
  `Category` enum('80s','ads','alternative','classic','funny','metal','misc','movies_TV_games','oldies','rock','techno_and_dance') NOT NULL default '80s',
  `Genre` tinyint(3) unsigned NOT NULL default '0',
  `Artist` varchar(250) NOT NULL default '',
  `Title` varchar(250) NOT NULL default '',
  `Album` varchar(250) NOT NULL default '',
  `TrackNum` tinyint(3) unsigned NOT NULL default '0',
  `Length` time NOT NULL default '00:00:00',
  `DateAdded` date NOT NULL default '0000-00-00',
  `IsOnIPod` enum('unknown','N','Y') NOT NULL default 'unknown',
  `PlayLists` varchar(255) NOT NULL default '',
  `MyRip` enum('unknown','Y','N') NOT NULL default 'unknown',
  `Best` enum('Y','N') NOT NULL default 'Y',
  `MP3Bitrate` float unsigned NOT NULL default '0',
  `MP3Size` int(10) unsigned NOT NULL default '0',
  `MP3md5sum` varchar(33) default NULL,
  `FLACBitrate` float unsigned NOT NULL default '0',
  `FLACSize` int(10) unsigned NOT NULL default '0',
  `FLACmd5sum` varchar(33) default NULL,
  `AC3Bitrate` float unsigned NOT NULL default '0',
  `AC3Size` int(10) unsigned NOT NULL default '0',
  `AC3md5sum` varchar(33) default NULL,
  `OGGBitrate` float unsigned NOT NULL default '0',
  `OGGSize` int(10) unsigned NOT NULL default '0',
  `OGGmd5sum` varchar(33) default NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `File` (`Path`,`FileName`),
  UNIQUE KEY `FileName` (`FileName`),
  UNIQUE KEY `MP3md5sum` (`MP3md5sum`),
  UNIQUE KEY `FLACmd5sum` (`FLACmd5sum`),
  UNIQUE KEY `AC3md5sum` (`AC3md5sum`),
  UNIQUE KEY `OGGmd5sum` (`OGGmd5sum`),
  KEY `DateAdded` (`DateAdded`),
  KEY `Length` (`Length`),
  KEY `MP3Size` (`MP3Size`),
  KEY `FLACSize` (`FLACSize`),
  KEY `AC3Size` (`AC3Size`),
  KEY `OGGSize` (`OGGSize`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;