-- phpMyAdmin SQL Dump
-- version 3.3.8
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 28, 2010 at 02:57 PM
-- Server version: 5.0.91
-- PHP Version: 5.2.6

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: `mmaaaco_mydb`
--

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

--
-- Table structure for table `practice_artists`
--

CREATE TABLE IF NOT EXISTS `practice_artists` (
  `id` int(5) NOT NULL auto_increment,
  `artist` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `practice_artists`
--

INSERT INTO `practice_artists` (`id`, `artist`) VALUES
(1, 'Run DMC'),
(2, 'Public Enemy'),
(3, 'Beastie Boys'),
(4, 'NWA'),
(5, 'Outkast'),
(6, 'LL Cool J');

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

--
-- Table structure for table `practice_cds`
--

CREATE TABLE IF NOT EXISTS `practice_cds` (
  `id` int(5) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `practice_cds`
--

INSERT INTO `practice_cds` (`id`, `title`) VALUES
(1, 'Raising Hell'),
(2, 'It Takes a Nation of Millions to Hold Us Back'),
(3, 'Paul''s Boutique'),
(4, 'Straight Outta Compton'),
(5, 'All Hail the Queen'),
(6, 'The Chronic');

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

--
-- Table structure for table `practice_holder`
--

CREATE TABLE IF NOT EXISTS `practice_holder` (
  `cdid` int(5) NOT NULL,
  `artistid` int(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `practice_holder`
--

INSERT INTO `practice_holder` (`cdid`, `artistid`) VALUES
(1, 1),
(2, 2),
(3, 3),
(4, 4);
