CREATE TABLE `artists` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `url` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB;

-- --------------------------------------------------------

-- 
-- Table structure for table `plays_new`
-- 

CREATE TABLE `plays_new` (
  `uid` int(10) unsigned NOT NULL,
  `time` int(7) unsigned NOT NULL,
  `artist` int(10) unsigned NOT NULL,
  `track` int(10) unsigned NOT NULL,
  KEY `uid` (`uid`),
  KEY `time` (`time`),
  KEY `artist` (`artist`),
  KEY `track` (`track`)
) ENGINE=InnoDB;

-- --------------------------------------------------------

-- 
-- Table structure for table `tracks`
-- 

CREATE TABLE `tracks` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `url` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB;