-- MySQL dump 9.11
--
-- Host: localhost    Database: music
-- ------------------------------------------------------
-- Server version	4.0.24

--
-- Table structure for table `trackerz`
--

CREATE TABLE trackerz (
  ID int(10) unsigned NOT NULL auto_increment,
  FileName varchar(250) NOT NULL default '',
  FileSize int(10) unsigned NOT NULL default '0',
  Format varchar(200) NOT NULL default '',
  Title varchar(255) NOT NULL default '',
  Length time NOT NULL default '00:00:00',
  Tracks tinyint(3) unsigned NOT NULL default '0',
  Samples tinyint(3) unsigned NOT NULL default '0',
  Patterns smallint(5) unsigned NOT NULL default '0',
  DateAdded date NOT NULL default '0000-00-00',
  Artist varchar(255) NOT NULL default '',
  md5sum varchar(33) NOT NULL default '',
  PRIMARY KEY  (ID),
  UNIQUE KEY FileName (FileName),
  UNIQUE KEY md5sum (md5sum),
  KEY DateAdded (DateAdded),
  KEY Tracks (Tracks),
  KEY Length (Length),
  KEY Title (Title)
) TYPE=MyISAM;

