-- phpMyAdmin SQL Dump
-- version 3.3.9.2
-- http://www.phpmyadmin.net
--
-- Host: studdb-mysql.fos.auckland.ac.nz
-- Generation Time: Apr 01, 2011 at 11:36 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.6-1+lenny9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `stu_spat251_COMPSCI_280_C_S1_2010`
--

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

--
-- Table structure for table `Album`
--

CREATE TABLE IF NOT EXISTS `Album` (
  `album_id` int(10) unsigned NOT NULL auto_increment,
  `album` varchar(100) default NULL,
  PRIMARY KEY  (`album_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `Album`
--

INSERT INTO `Album` (`album_id`, `album`) VALUES(1, 'Zooropa');
INSERT INTO `Album` (`album_id`, `album`) VALUES(2, 'Pop');
INSERT INTO `Album` (`album_id`, `album`) VALUES(3, 'Achtung Baby');
INSERT INTO `Album` (`album_id`, `album`) VALUES(4, 'The Best of 1980–1990');
INSERT INTO `Album` (`album_id`, `album`) VALUES(5, 'The Best of 1990–2000');

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

--
-- Table structure for table `Artist`
--

CREATE TABLE IF NOT EXISTS `Artist` (
  `artistID` int(11) NOT NULL auto_increment,
  `Name` varchar(60) NOT NULL,
  PRIMARY KEY  (`artistID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `Artist`
--

INSERT INTO `Artist` (`artistID`, `Name`) VALUES(1, 'U2');

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

--
-- Table structure for table `ArtistAlbum`
--

CREATE TABLE IF NOT EXISTS `ArtistAlbum` (
  `artist_id` int(10) unsigned NOT NULL,
  `album_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`artist_id`,`album_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ArtistAlbum`
--

INSERT INTO `ArtistAlbum` (`artist_id`, `album_id`) VALUES(1, 1);
INSERT INTO `ArtistAlbum` (`artist_id`, `album_id`) VALUES(1, 2);
INSERT INTO `ArtistAlbum` (`artist_id`, `album_id`) VALUES(1, 3);
INSERT INTO `ArtistAlbum` (`artist_id`, `album_id`) VALUES(1, 4);
INSERT INTO `ArtistAlbum` (`artist_id`, `album_id`) VALUES(1, 5);

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

--
-- Table structure for table `Disk`
--

CREATE TABLE IF NOT EXISTS `Disk` (
  `disk_id` int(10) unsigned NOT NULL auto_increment,
  `disk` varchar(11) default NULL,
  PRIMARY KEY  (`disk_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `Disk`
--


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

--
-- Table structure for table `Disktrack`
--

CREATE TABLE IF NOT EXISTS `Disktrack` (
  `disktrack_id` int(10) unsigned NOT NULL auto_increment,
  `disk_id` int(10) unsigned NOT NULL,
  `track_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`disktrack_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `Disktrack`
--


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

--
-- Table structure for table `Track`
--

CREATE TABLE IF NOT EXISTS `Track` (
  `track_id` int(10) unsigned NOT NULL auto_increment,
  `track` varchar(100) default NULL,
  `duration` varchar(5) default NULL,
  PRIMARY KEY  (`track_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `Track`
--

INSERT INTO `Track` (`track_id`, `track`, `duration`) VALUES(1, 'Mysterious Ways', '4:02');
INSERT INTO `Track` (`track_id`, `track`, `duration`) VALUES(2, 'Mysterious Ways', '4:02');
INSERT INTO `Track` (`track_id`, `track`, `duration`) VALUES(3, 'Even Better Than the Real Thing', '3:39');
INSERT INTO `Track` (`track_id`, `track`, `duration`) VALUES(4, 'Even Better Than the Real Thing', '3:39');

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

--
-- Table structure for table `TrackAlbum`
--

CREATE TABLE IF NOT EXISTS `TrackAlbum` (
  `track_id` int(10) unsigned NOT NULL,
  `album_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`track_id`,`album_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TrackAlbum`
--

INSERT INTO `TrackAlbum` (`track_id`, `album_id`) VALUES(1, 3);
INSERT INTO `TrackAlbum` (`track_id`, `album_id`) VALUES(2, 5);
INSERT INTO `TrackAlbum` (`track_id`, `album_id`) VALUES(3, 5);
INSERT INTO `TrackAlbum` (`track_id`, `album_id`) VALUES(4, 3);