-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Feb 06, 2006 at 11:44 AM
-- Server version: 5.0.18
-- PHP Version: 5.0.5
-- 
-- Database: `poddb`
-- 

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

-- 
-- Table structure for table `artists`
-- 

DROP TABLE IF EXISTS `artists`;
CREATE TABLE `artists` (
  `ArtistID` int(4) NOT NULL auto_increment,
  `ArtistName` varchar(50) NOT NULL,
  `ArtistURL` varchar(255) default NULL,
  PRIMARY KEY  (`ArtistID`),
  KEY `ArtistName` (`ArtistName`,`ArtistURL`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

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

-- 
-- Table structure for table `comments`
-- 

DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
  `CommentId` int(4) NOT NULL auto_increment,
  `UserId` varchar(100) NOT NULL,
  `SongId` int(4) NOT NULL,
  `CommentTxt` varchar(250) NOT NULL,
  PRIMARY KEY  (`CommentId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

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

-- 
-- Table structure for table `favorites`
-- 

DROP TABLE IF EXISTS `favorites`;
CREATE TABLE `favorites` (
  `FavoriteId` int(4) NOT NULL auto_increment,
  `UserId` varchar(100) NOT NULL,
  `SongID` int(4) NOT NULL,
  PRIMARY KEY  (`FavoriteId`),
  KEY `UserId` (`UserId`),
  KEY `SongID` (`SongID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='This table holds your favorite songs' AUTO_INCREMENT=33 ;

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

-- 
-- Table structure for table `notifications`
-- 

DROP TABLE IF EXISTS `notifications`;
CREATE TABLE `notifications` (
  `NotifyID` int(11) NOT NULL auto_increment,
  `UserId` varchar(100) NOT NULL,
  `ArtistID` int(11) NOT NULL,
  PRIMARY KEY  (`NotifyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

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

-- 
-- Table structure for table `songs`
-- 

DROP TABLE IF EXISTS `songs`;
CREATE TABLE `songs` (
  `SongID` int(4) NOT NULL auto_increment,
  `SongName` varchar(50) NOT NULL,
  `SongURL` varchar(255) NOT NULL,
  `ArtistID` int(4) NOT NULL,
  PRIMARY KEY  (`SongID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
