//setting up tables in mySQL

CREATE TABLE genre (
id int(11) NOT NULL auto_increment,
name varchar(100) default ”,
dateAdded int(11) default ’0′,
PRIMARY KEY (id)
) ENGINE=MyISAM;

CREATE TABLE albums (
id int(11) NOT NULL auto_increment,
genreID int(11) NOT NULL default ’0′,
artist varchar(200) NOT NULL default ”,
albumName varchar(200) NOT NULL default ”,
PRIMARY KEY (id)
) ENGINE = MyISAM;

//populating tables in mySQL

INSERT INTO genre (name, dateAdded) VALUES (‘Blues’, 111111);
INSERT INTO genre (name, dateAdded) VALUES (‘Country’, 111111);
INSERT INTO genre (name, dateAdded) VALUES (‘Jazz’, 111111);
INSERT INTO genre (name, dateAdded) VALUES (‘Rock’, 111111);

INSERT INTO albums (genreID, artist, albumName) VALUES (4, ‘Journey’, ‘Journey\’s Rock’);
INSERT INTO albums (genreID, artist, albumName) VALUES (4, ‘etc’, ‘name of album’);