-- MySQL dump 10.11
--
-- Host: localhost    Database: band
-- ------------------------------------------------------
-- Server version	5.0.45-community-nt

/*!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 `albums`
--

DROP TABLE IF EXISTS `albums`;
CREATE TABLE `albums` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `band_id` int(11) default NULL,
  `date` year(4) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `albums`
--

LOCK TABLES `albums` WRITE;
/*!40000 ALTER TABLE `albums` DISABLE KEYS */;
INSERT INTO `albums` VALUES (1,'Deathcrush',1,1987),(2,'Live in Leipzig',1,1991),(3,'De Mysteriis...',1,1994),(4,'Ordo Ad Chao',1,2007),(5,'Consequences of Disobedience',2,2002),(6,'Once upon the cross',3,1995),(7,'Serpents of the Light',3,1997),(10,'The Stench of Redemption',3,2006),(11,'All Eyez on Me',6,1996),(12,'Still I Rise',6,1999),(17,'Tha Doggfather',7,1996),(18,'Tha Blue Carpet Treatment',7,2006),(19,'Tragic Kingdom',8,1995);
/*!40000 ALTER TABLE `albums` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bands`
--

DROP TABLE IF EXISTS `bands`;
CREATE TABLE `bands` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `description` varchar(2000) default NULL,
  `picurl` varchar(200) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bands`
--

LOCK TABLES `bands` WRITE;
/*!40000 ALTER TABLE `bands` DISABLE KEYS */;
INSERT INTO `bands` VALUES (1,'Mayhem','Mayhem (often called \'The True Mayhem\') is a black metal band, formed in 1984 in Oslo, Norway. <br> The band name is taken from the Venom song, Mayhem with Mercy. <br> Much controversy has followed the various murders, suicides and other forms of violence that surrounded the band in the early years. <br> Mayhem is considered one of the most controversial bands in modern musical history, especially due to the vast number of urban legends and myths surrounding their early years, and the controversies have often overshadowed the music, especially in recent years due in part to the Internet and magazine articles. <br> Over time Mayhem has evolved through a variety of black metal styles, delving at times into areas of dark avant-garde industrial and electronica. <br> Highly influential, the group is widely considered to be one of the cornerstones of the black metal movement.','http://upload.wikimedia.org/wikipedia/en/7/7a/Mayhem_Logo.png'),(2,'Velcra','Velcra is a Finnish hard rock music group established 1999. Their music features female vocals (both clean and distorted) on a background of heavily distorted guitars and marching beats with heavy use of sample loops and could be defined as industrial metal or rap-metal.','http://img.mp3sugar.com/artist/artist_918.jpg'),(3,'Deicide','Deicide is an American death metal band. The word \"deicide\" means \"the killing of deities\" or, in the Christian era \"the killing of God or Jesus Christ\". The word can also mean \"one who kills God\". The band has sold close to 500,000 releases (taking into consideration both CD and VHS sales) in the USA since the SoundScan era, making them one of the best selling death metal bands of all time. Their albums Deicide and Legion are also ranked second and third place in best-selling death metal albums of that era.','http://www.headbanger.hu/be/htdocs/updir/deicide.jpg'),(4,'Marduk','Marduk is a Swedish black metal band, who are based in Norrk”ping. <br> Marduk\'s predominant lyrical topics are Satanism, anti-Christianity, Biblical tales, Nazism and World War II. The latter two are a later addition to their lyrical / conceptual themes, stemming from their 1999 release Panzer Division Marduk; quickly growing among their fans\' favorites.','http://www.bibleetnombres.online.fr/images6/marduk.gif'),(5,'Immortal','Immortal is a pioneer black metal band from Bergen, Norway. The band was formed from the remnants of Amputation, a death metal band from 1989.','http://upload.wikimedia.org/wikipedia/en/3/39/Immortal.png'),(6,'2Pac','Tupac Amaru Shakur (June 16, 1971   September 13, 1996), also known by his stage names 2Pac, Makaveli, or simply Pac, was an American artist renowned for his rapping and hip hop music, as well as his movie roles, poetry, and his social activism. He is recognized in the Guinness Book of World Records as the highest-selling rap artist, with over 75,000,000 albums sold worldwide, including over 50,000,000 in the United States alone.[1] Most of Shakur\'s songs are about growing up around violence and hardship in ghettos, racism, problems in society, and sometimes qualms with other rappers. Shakur\'s work is known for advocating political, economic, social, and racial equality as well as his raw descriptions of violence, drug and alcohol abuse, and conflicts with the law. Many fans, critics, and industry insiders rank him as the greatest rapper ever.','http://upload.wikimedia.org/wikipedia/en/thumb/4/4a/2Pac2.jpg/220px-2Pac2.jpg'),(7,'Snoop Dogg','Cordozar Calvin Broadus, Jr.[1] (born October 20, 1971), better known professionally as Snoop Dogg and previously Snoop Doggy Dogg, is an American rapper, record producer, and actor. Snoop is best known as an MC in the West Coast hip hop scene, and for being one of producer Dr. Dre\'s most notable protgs.','http://upload.wikimedia.org/wikipedia/commons/thumb/a/ae/Snoop_Dogg_Hawaii.jpg/220px-Snoop_Dogg_Hawaii.jpg'),(8,'No Doubt','No Doubt is a third wave ska band from Anaheim, California, United States, founded in 1986. The ska-pop sound of its 1992 debut album failed to make waves due to the popularity of the grunge movement at the time. The band\'s diamond-certified album Tragic Kingdom helped to launch the ska revival of the 1990s.','http://upload.wikimedia.org/wikipedia/commons/thumb/8/82/NoDoubtAtWorcester.jpg/300px-NoDoubtAtWorcester.jpg'),(9,'Gwen Stefani','Stefani\'s debut solo album Love. Angel. Music. Baby. was released in November 2004.','http://upload.wikimedia.org/wikipedia/commons/thumb/c/ca/CoolGwenStefanitset.jpg/220px-CoolGwenStefanitset.jpg'),(10,'Christina Aguilera','In March 2006, Aguilera signed a contract with European cell phone operator Orange to promote the new Sony Ericsson Walkman phone. She was featured in a Pepsi commercial alongside Lebanese singer Elissa, as well as Korean pop singer Rain in May. The spot aired during the 2006 World Cup.','http://upload.wikimedia.org/wikipedia/commons/thumb/f/fe/VMA_06.jpg/291px-VMA_06.jpg');
/*!40000 ALTER TABLE `bands` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `forumposts`
--

DROP TABLE IF EXISTS `forumposts`;
CREATE TABLE `forumposts` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `post` varchar(600) default NULL,
  `band_id` int(11) default NULL,
  `date` date default NULL,
  `time` time default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `forumposts`
--

LOCK TABLES `forumposts` WRITE;
/*!40000 ALTER TABLE `forumposts` DISABLE KEYS */;
INSERT INTO `forumposts` VALUES (1,'Joe','owning! this band kickass man, i love them!',4,'2007-11-03','19:56:45'),(2,'a','owning! this band kickass man, i love them!',3,'2007-11-03','19:56:45'),(3,'b','owning! this band kickass man, i love them!',3,'2007-11-03','19:56:45'),(4,'b','owning! this band kickass man, i love them!',3,'2007-11-03','19:56:45'),(5,'b','owning! this band kickass man, i love them!',3,'2007-11-03','19:56:45'),(6,'b','owning! this band kickass man, i love them!',3,'2007-11-03','19:56:45'),(7,'b','owning! this band kickass man, i love them!',3,'2007-11-03','19:56:45'),(8,'b','owning! this band kickass man, i love them!',3,'2007-11-03','19:56:45'),(9,'b','owning! this band kickass man, i love them!',3,'2007-11-03','19:56:45'),(10,'b','owning! this band kickass man, i love them!',3,'2007-11-03','19:56:45'),(11,'sadf','sadfasf',3,'2007-11-04','13:51:31'),(12,'yee','sdf',3,'2007-11-04','13:55:57'),(13,'asdf','asdf',3,'2007-11-04','13:56:23'),(14,'asdf','sdafsdaf',6,'2007-11-04','14:04:54'),(15,'nbig','i kill ya',6,'2007-11-04','14:05:06'),(16,'housewife','i love black ppl',6,'2007-11-04','14:05:26'),(17,'mike','i live thier singer',2,'2007-11-04','14:05:50'),(18,'nike','me not',2,'2007-11-04','14:06:00'),(19,'mike','she is awesome',2,'2007-11-04','14:06:11'),(20,'finnish','kakupelikake lukaporutila',2,'2007-11-04','14:06:29'),(21,'smoker','i like weed, too!',7,'2007-11-04','14:09:07'),(22,'gwenlover','i love gwen',8,'2007-11-04','14:29:54'),(23,'mike','she is nice',8,'2007-11-04','14:30:02'),(24,'realist','she is blond',8,'2007-11-04','14:30:08'),(25,'lover','i still love her',9,'2007-11-04','14:39:54'),(26,'mike','i still not',9,'2007-11-04','14:40:01'),(27,'realist','she is still blond...<br>okok, sometimes pink',9,'2007-11-04','14:40:16'),(28,'feka','papapapa',1,'2007-11-05','18:19:27'),(29,'klsdkghsdkjg','kjsdhfkgjsdhkjgsdfg',4,'2007-11-05','18:23:15'),(30,'Joska','ha ez nagyon ut',7,'2007-11-06','00:41:51'),(31,'dfgsdfg','sdfgsdfg',2,'2007-11-15','23:34:21'),(32,'234234234','24352345234',2,'2007-11-15','23:34:40'),(33,'asdf','asdfadf',7,'2007-11-16','22:57:07');
/*!40000 ALTER TABLE `forumposts` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `news` varchar(600) default NULL,
  `date` date default NULL,
  `time` time default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

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

LOCK TABLES `news` WRITE;
/*!40000 ALTER TABLE `news` DISABLE KEYS */;
INSERT INTO `news` VALUES (1,'started to develop','development of the site is started','2007-11-03','19:56:45'),(2,'added news','added news feature to site','2007-11-03','19:56:45'),(3,'added bands','added bands feature to site','2007-11-03','19:56:45'),(4,'added albums','added albums feature to site','2007-11-03','19:56:45'),(5,'added tracks','added tracks feature to site','2007-11-03','19:56:45'),(6,'added tags','added tags feature to site','2007-11-03','19:56:45'),(7,'RSS test started','started testing the RSS feature','2007-11-03','19:56:45');
/*!40000 ALTER TABLE `news` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tagged`
--

DROP TABLE IF EXISTS `tagged`;
CREATE TABLE `tagged` (
  `band_id` int(11) default NULL,
  `tag_id` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tagged`
--

LOCK TABLES `tagged` WRITE;
/*!40000 ALTER TABLE `tagged` DISABLE KEYS */;
INSERT INTO `tagged` VALUES (1,1),(1,4),(1,5),(2,2),(2,7),(3,3),(3,6),(3,4),(4,1),(5,1),(5,5),(4,8),(6,9),(6,11),(6,12),(1,13),(1,13),(1,14),(7,9),(7,15),(6,6),(6,15),(7,6),(2,17),(8,17),(8,18),(8,19),(8,20),(9,20),(9,17),(10,17);
/*!40000 ALTER TABLE `tagged` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tags`
--

DROP TABLE IF EXISTS `tags`;
CREATE TABLE `tags` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tags`
--

LOCK TABLES `tags` WRITE;
/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
INSERT INTO `tags` VALUES (1,'black metal'),(2,'industrial'),(3,'death metal'),(4,'satanism'),(5,'norway'),(6,'usa'),(7,'finnish'),(8,'sweden'),(9,'rap'),(11,'west coast'),(12,'black'),(13,'dead'),(14,'euro'),(15,'hip-hop'),(17,'female vocalists'),(18,'ska'),(19,'rock'),(20,'Gwen Stefani');
/*!40000 ALTER TABLE `tags` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tracks`
--

DROP TABLE IF EXISTS `tracks`;
CREATE TABLE `tracks` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `album_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=202 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tracks`
--

LOCK TABLES `tracks` WRITE;
/*!40000 ALTER TABLE `tracks` DISABLE KEYS */;
INSERT INTO `tracks` VALUES (1,'Not of This Earth',10),(2,'Desecration',10),(3,'Never to Be Seen Again',10),(4,'Not of This Earth',4),(5,'A Wise Birthgiver',4),(6,'Illuminate Eliminate',4),(7,'Key to the Storms',4),(8,'Anti',4),(88,'Wall of Water',4),(89,'Silvester Anfang',1),(90,'Deathcrush',1),(91,'Chainsaw Gutsfuck',1),(92,'Necrolust',1),(93,'(Weird) Manheim',1),(94,'Pure Fucking Armageddon',1),(95,'Deathcrush',2),(96,'Necrolust',2),(97,'Funeral Fog',2),(98,'The Freezing Moon',2),(99,'Carnage',2),(100,'Buried by Time and Dust',2),(101,'Pagan Fears',2),(102,'Chainsaw Gutsfuck',2),(103,'Pure Fucking Armageddon',2),(104,'Funeral Fog',3),(105,'Freezing Moon',3),(106,'Cursed in Eternity',3),(107,'Pagan Fears',3),(108,'Life Eternal',3),(109,'From the Dark Past',3),(110,'Buried By Time and Dust',3),(111,'De Mysteriis Dom Sathanas',3),(112,'Can\'t C Me',11),(113,'Shorty Wanna Be a Thug',11),(114,'Holla at Me',11),(115,'Wonda Why They Call U Bitch',11),(116,'When We Ride',11),(117,'Thug Passion',11),(118,'Picture Me Rollin\'',11),(119,'Check Out Time',11),(120,'Ratha Be Ya Nigga',11),(121,'All Eyez on Me',11),(122,'Run tha Streetz',11),(123,'Ain\'t Hard 2 Find',11),(124,'Heaven Ain\'t Hard 2 Find',11),(125,'Letter to the President',12),(126,'Still I Rise',12),(127,'Secretz of War',12),(128,'Baby Don\'t Cry (Keep Ya Head Up II)',12),(129,'As the World Turns',12),(130,'Black Jesuz',12),(131,'Homeboyz',12),(132,'Hell 4 a Hustler',12),(133,'High Speed',12),(134,'The Good Die Young',12),(135,'Killuminati',12),(136,'Tear Drops and Closed Caskets',12),(137,'Tattoo Tears',12),(138,'U Can Be Touched',12),(139,'Y\'all Don\'t Know Us',12),(158,'Intro',17),(159,'Doggfather',17),(160,'Ride 4 Me',17),(161,'Up Jump Tha Boogie',17),(162,'Freestyle Conversation',17),(163,'When I Grow Up',17),(164,'Snoop Bounce',17),(165,'Gold Rush',17),(166,'(Tear \'Em Off) Me ',17),(167,'Intrology',18),(168,'Think About It',18),(169,'Crazy',18),(170,'Vato',18),(171,'hat\'s That',18),(172,'Candy (Drippin\' Like Water)',18),(173,'Get a Light',18),(174,'Gangbangin\' 101',18),(175,'Boss\' Life',18),(176,'L.A.X.',18),(177,'10 Lil\' Crips',18),(178,'\'Round Here',18),(179,'A Bitch I Knew',18),(180,'Like This',18),(181,'Which One of You',18),(182,'I Wanna Fuck You',18),(183,'Psst!',18),(184,'Beat Up on Yo\' Pads',18),(185,'Don\'t Stop',18),(186,'Imagine',18),(187,'Conversations',18),(188,'Spiderwebs',19),(189,'Excuse Me Mr.',19),(190,'Just a Girl',19),(191,'Happy Now',19),(192,'Different People',19),(193,'Hey You',19),(194,'The Climb',19),(195,'Sixteen',19),(196,'Sunday Morning',19),(197,'Don\'t Speak',19),(198,'You Can Do It',19),(199,'World Go \'Round',19),(200,'End It on This',19),(201,'Tragic Kingdom',19);
/*!40000 ALTER TABLE `tracks` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 */;

-- Dump completed on 2007-11-18 17:34:28
