CREATE TABLE IF NOT EXISTS `artists` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `biography` text NOT NULL,
  `bio_author` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `name` (`name`,`slug`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7707 ;

CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(11) NOT NULL auto_increment,
  `category` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

CREATE TABLE IF NOT EXISTS `videos` (
  `id` int(11) NOT NULL auto_increment,
  `artist_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `yahoo_id` varchar(30) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `thumb_url` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `url` (`url`),
  KEY `artist_id` (`artist_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26693 ;

INSERT INTO `videos` (`id`, `artist_id`, `category_id`, `yahoo_id`, `title`, `slug`, `url`, `thumb_url`) VALUES
(1, 1924, 1, '2161725', 'Real Compton City G''s', 'Real-Compton-City-G''s', 'http://new.music.yahoo.com/Eazy-E/videos/view/Real-Compton-City-G''s--2161725', 'http://d.yimg.com/ec/image/v1/video/2161725');

INSERT INTO `categories` (`id`, `category`) VALUES
(1, '1980s Hip Hop'),

INSERT INTO `artists` (`id`, `name`, `slug`, `biography`, `bio_author`) VALUES
(1, '10,000 Maniacs', '10000Maniacs', '10,000 Maniacs (named after the low-budget horror movie 2,000 Maniacs) was formed in Jamestown, NY, in 1981 by singer Natalie Merchant and guitarist John Lombardo. Other members of the sextet were Robert Buck (guitar), Steven Gustafson (bass), Dennis Drew (keyboards), and Jerry Augustyniak (drums). The group gigged extensively and recorded independently before signing with Elektra and making The Wishing Chair in 1985. Co-founder Lombardo left the band in 1986, and they continued as a quintet, releasing their second album, In My Tribe, in 1987. This album broke into the charts, where it stayed 77 weeks, peaking at number 37. Blind Man''s Zoo, the 1989 follow-up, hit number 13 and went gold. <p>\nAfter 1992''s Our Time in Eden had finished its run on the charts, Merchant announced that she was leaving for a solo career. MTV Unplugged was released a few months after her departure. The remaining 10,000 Maniacs decided to continue performing, adding the folk-rock duo John & Mary (original member Lombardo and violinist/vocalist Mary Ramsey). The new lineup released Love Among the Ruins. Merchant released her first solo album, Tigerlily, in the summer of 1995 and a follow-up, Ophelia, in 1998. In 1999, the remaining Maniacs released The Earth Pressed Flat on Bar/None. Sadly a year later lead guitarist and founding member Robert Buck, who co-wrote some of the band''s classics like "Hey Jack Kerouac," "What''s The Matter Here?," and "These Are Days," died of liver failure. He was 42. ~ William Ruhlmann, All Music Guide', 'William Ruhlmann');