-- /usr/local/nf/bin/mysqldump  --force --quick --quote-names -h mysqlhost -u u70437235 -p168125 d60397330 
--
-- MySQL dump 10.10
--
-- Host: mysqlhost    Database: d60397330
-- ------------------------------------------------------
-- Server version	5.0.24a-log

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `album`
--

DROP TABLE IF EXISTS `album`;
CREATE TABLE `album` (
  `AlbumID` int(11) NOT NULL auto_increment,
  `AlbumName` varchar(100) default NULL,
  `ArtistID` int(11) NOT NULL default '0',
  `AlbumPrice` int(11) default '0',
  `AlbumNotes` text,
  `AlbumCatalogNumber` int(11) default '0',
  `AlbumAvailable` tinyint(3) unsigned default NULL,
  `AlbumCoverURL` varchar(100) default NULL,
  `AlbumCoverThumbnailURL` varchar(100) default NULL,
  PRIMARY KEY  (`AlbumID`),
  KEY `AlbumID` (`AlbumID`),
  KEY `ArtistID` (`ArtistID`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `album`
--


/*!40000 ALTER TABLE `album` DISABLE KEYS */;
LOCK TABLES `album` WRITE;
INSERT INTO `album` VALUES (1,'The Helen Lundy Trio',1,15,'Stellar performances and driving beat make this album a must for all Macromusica fans and collectors. Featuring Color Combination; Margot, Margaux, Margot; Lovely But Unlikely; La Rondalla; Concrete Jungle; Exit Gilman Street; Big Fives; Mysterious Disappearances; Patiently Waiting; I Believe Down Where You Are; Next.',10001,1,'assets/bands/HLT_blackcover.jpg','assets/bands/HLT_blackcover_thumbnail.jpg'),(2,'Have you seen Tintin?',2,16,'Experimental music that challenges the mind and the ear.',10002,1,'assets/bands/YL_hyst.jpg','assets/bands/YL_hyst_thumbnail.jpg'),(4,'MX',8,18,'Software isn\'t the only thing these engineer types produce. 12 Dreamweaver inspired songs developed along with the software.<br><br>The feelgood CD of the season…',10003,1,'assets/bands/UB_cover.jpg','assets/bands/UB_thumbnail.jpg'),(5,'Call out the Cavalry',7,35,'These guys talk a lot of smack, the friendly website visitor says to themself, I wonder what they sound like?',10004,1,'assets/bands/LS_cover.JPG','assets/bands/LS_thumbnail.JPG'),(6,'The Road Less Traveled',5,19,'Launching a Dream is like the Mind taking a Breath of Fresh Air...Like a Surprise Gift always waiting to be opened... Like a Journey to a Favorite Place!',10005,1,'assets/bands/JAENUS_cover.jpg','assets/bands/JAENUS_thumbnail.jpg'),(7,'MySQL Divas of 1999',6,12,'Hear the developers sing! If you dare!',12345,1,'assets/bands/KODJ_cover.jpg','assets/bands/KODJ_thumbnail.jpg'),(8,'Eden In Atlantis',7,25,'A selection of modern classical music by Australian composers. Main items Cello/piano Sonata, Lute Concerto, (title piece) Scena for soprano, flute, piano. Varied, accessible, elegant, exciting, moody.',500,1,'assets/bands/revolve3.jpg','assets/bands/revolve3_small.jpg');
UNLOCK TABLES;
/*!40000 ALTER TABLE `album` ENABLE KEYS */;

--
-- Table structure for table `artist`
--

DROP TABLE IF EXISTS `artist`;
CREATE TABLE `artist` (
  `ArtistID` int(11) NOT NULL auto_increment,
  `ArtistGroupName` varchar(100) default NULL,
  `ArtistStyle` varchar(50) default NULL,
  `ArtistNames` varchar(100) default NULL,
  `ArtistPhoto` varchar(100) default NULL,
  PRIMARY KEY  (`ArtistID`),
  KEY `ArtistID` (`ArtistID`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `artist`
--


/*!40000 ALTER TABLE `artist` DISABLE KEYS */;
LOCK TABLES `artist` WRITE;
INSERT INTO `artist` VALUES (1,'Helen Lundy Trio','Rock','Karla Milosevich, Craig Goodman, and Kota Ezawa','assets/bands/HLT_wall.jpg'),(2,'Yellow Lotus','Experimental','Raven, Winnie Davis, and dd macdonald','assets/bands/YL_band.jpg'),(4,'The Doilies','Country-Folk','','assets/bands/DOILY_band.gif'),(5,'Jaenus','Rock','Niles Rowland, Brian Schretzmann, Dan Hoffman, Sepehr Valizadeh','assets/bands/JAENUS_band.jpg'),(6,'KODJ','Rock','Alyn Kelley, Mark Fletche, Kevin Christian, Greg Costanzo, Alan Cole, Tom Haunert','assets/bands/KODJ_grouppic.jpg'),(7,'Solo','Classical Guitar','Derek Strahan, Sam Jones','assets/bands/revolve3.jpg');
UNLOCK TABLES;
/*!40000 ALTER TABLE `artist` ENABLE KEYS */;

--
-- Table structure for table `news`
--

DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `NewsID` int(11) NOT NULL auto_increment,
  `NewsDate` varchar(19) default NULL,
  `NewsItem` text,
  PRIMARY KEY  (`NewsID`),
  KEY `NewsID` (`NewsID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `news`
--


/*!40000 ALTER TABLE `news` DISABLE KEYS */;
LOCK TABLES `news` WRITE;
INSERT INTO `news` VALUES (1,'2002-04-28','RecordStore hits the road! Find RecordStore reps in your town. In your favorite CD shop. ON YOUR BLOCK. Come here the latest and meet the RecordStore Team');
UNLOCK TABLES;
/*!40000 ALTER TABLE `news` ENABLE KEYS */;

--
-- Table structure for table `person`
--

DROP TABLE IF EXISTS `person`;
CREATE TABLE `person` (
  `FirstName` varchar(15) default NULL,
  `LastName` varchar(15) default NULL,
  `Age` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `person`
--


/*!40000 ALTER TABLE `person` DISABLE KEYS */;
LOCK TABLES `person` WRITE;
INSERT INTO `person` VALUES ('Peter','Griffin',35),('Glenn','Quagmire',33),('David','Bronte',23),('Tom','Chan',88),('Charlotte','Bronte',37),('Jane','Davis',77),('Sonja','Hamilton',25),('Sara','Jones',5);
UNLOCK TABLES;
/*!40000 ALTER TABLE `person` ENABLE KEYS */;

--
-- Table structure for table `userauthentication`
--

DROP TABLE IF EXISTS `userauthentication`;
CREATE TABLE `userauthentication` (
  `UserID` int(11) NOT NULL auto_increment,
  `UserName` text NOT NULL,
  `UserPassword` text NOT NULL,
  PRIMARY KEY  (`UserID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userauthentication`
--


/*!40000 ALTER TABLE `userauthentication` DISABLE KEYS */;
LOCK TABLES `userauthentication` WRITE;
INSERT INTO `userauthentication` VALUES (1,'mbrown','foobar'),(3,'admin','a1q1a1q1'),(4,'user1','8855');
UNLOCK TABLES;
/*!40000 ALTER TABLE `userauthentication` ENABLE KEYS */;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `username` varchar(15) default NULL,
  `password` varchar(15) default NULL,
  `auth_level` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--


/*!40000 ALTER TABLE `users` DISABLE KEYS */;
LOCK TABLES `users` WRITE;
INSERT INTO `users` VALUES ('tom','chan',1),('Peykan','Pezeshki',3),('Fariba','Owrak',2),('mary','bronte',1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;