# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Oct 26, 2003 at 09:15 PM
# Server version: 4.0.13
# PHP Version: 4.1.2
# 
# Database : `lamp`
# 

# --------------------------------------------------------

#
# Table structure for table `albums`
#

CREATE TABLE `albums` (
  `album_id` int(11) NOT NULL auto_increment,
  `album_name` text NOT NULL,
  `album_description` text NOT NULL,
  `album_upc` text NOT NULL,
  `media_id` text NOT NULL,
  `volume` text NOT NULL,
  `cd_count` text NOT NULL,
  `album_duration` text NOT NULL,
  `album_genre` text NOT NULL,
  `label` text NOT NULL,
  `copyright` text NOT NULL,
  `copyright_year` text NOT NULL,
  `p_line` text NOT NULL,
  `p_line_year` text NOT NULL,
  `release_date` text NOT NULL,
  `catalog_number` text NOT NULL,
  `explicit_lyrics` text NOT NULL,
  `album_works` text NOT NULL,
  `artist_name` text NOT NULL,
  `composer` text NOT NULL,
  `conductor` text NOT NULL,
  `ensemble` text NOT NULL,
  `guest_artists` text NOT NULL,
  `performers` text NOT NULL,
  `numtracks` int(11) NOT NULL default '0',
  PRIMARY KEY  (`album_id`,`album_id`),
  UNIQUE KEY `album_id` (`album_id`),
  UNIQUE KEY `album_id_3` (`album_id`),
  KEY `album_id_2` (`album_id`)
) TYPE=MyISAM AUTO_INCREMENT=3442 ;

# --------------------------------------------------------

#
# Table structure for table `channels`
#

CREATE TABLE `channels` (
  `channel_number` int(11) NOT NULL auto_increment,
  `username` text NOT NULL,
  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `timeout_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `now_playing` text NOT NULL,
  `is_jukebox_channel` tinyint(4) NOT NULL default '0',
  `player_pid` int(11) NOT NULL default '0',
  `byte_index` int(11) NOT NULL default '0',
  PRIMARY KEY  (`channel_number`),
  UNIQUE KEY `channel_number` (`channel_number`)
) TYPE=MyISAM AUTO_INCREMENT=78 ;

# --------------------------------------------------------

#
# Table structure for table `eventlog`
#

CREATE TABLE `eventlog` (
  `logid` int(32) NOT NULL auto_increment,
  `username` text NOT NULL,
  `info` text NOT NULL,
  `eventcode` text NOT NULL,
  `timestamp` timestamp(14) NOT NULL,
  UNIQUE KEY `logid` (`logid`)
) TYPE=MyISAM AUTO_INCREMENT=18438 ;

# --------------------------------------------------------

#
# Table structure for table `playlists`
#

CREATE TABLE `playlists` (
  `queue_position` int(11) NOT NULL auto_increment,
  `username` text NOT NULL,
  `track_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`queue_position`),
  UNIQUE KEY `queue_position` (`queue_position`)
) TYPE=MyISAM AUTO_INCREMENT=25174 ;

# --------------------------------------------------------

#
# Table structure for table `suggestions`
#

CREATE TABLE `suggestions` (
  `suggestion_id` int(11) NOT NULL auto_increment,
  `username` text NOT NULL,
  `upc` text NOT NULL,
  `comments` text NOT NULL,
  `timestamp` timestamp(14) NOT NULL,
  UNIQUE KEY `suggestion_id` (`suggestion_id`)
) TYPE=MyISAM AUTO_INCREMENT=274 ;

# --------------------------------------------------------

#
# Table structure for table `tracks`
#

CREATE TABLE `tracks` (
  `track_id` int(11) NOT NULL auto_increment,
  `track_number` int(11) NOT NULL default '0',
  `album_id` text NOT NULL,
  `track_name` text NOT NULL,
  `duration` text NOT NULL,
  `track_filename` text NOT NULL,
  `num_times_played` int(11) NOT NULL default '0',
  `artist_name` text NOT NULL,
  `composer` text NOT NULL,
  `conductor` text NOT NULL,
  `ensemble` text NOT NULL,
  `guest_artists` text NOT NULL,
  `performers` text NOT NULL,
  `track_work` text NOT NULL,
  PRIMARY KEY  (`track_id`,`track_id`,`track_number`,`track_id`,`track_id`),
  UNIQUE KEY `song_id` (`track_id`),
  UNIQUE KEY `track_id_2` (`track_id`),
  UNIQUE KEY `track_id_3` (`track_id`),
  UNIQUE KEY `track_id_4` (`track_id`),
  UNIQUE KEY `track_id_6` (`track_id`),
  KEY `track_id` (`track_id`),
  KEY `track_id_5` (`track_id`)
) TYPE=MyISAM AUTO_INCREMENT=48152 ;

# --------------------------------------------------------

#
# Table structure for table `users`
#

CREATE TABLE `users` (
  `user_id` int(11) NOT NULL auto_increment,
  `username` text NOT NULL,
  `num_songs_played` int(11) NOT NULL default '0',
  `last_song_played` timestamp(14) NOT NULL,
  `first_login` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`user_id`,`user_id`),
  KEY `user_id` (`user_id`),
  KEY `user_id_2` (`user_id`),
  KEY `user_id_3` (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=216 ;
