Music Database, Version 3
=========================

musicdb/v3/README.txt			This file
musicdb/v3/createdb.sql			SQL script to CREATE DATABASE (run 1st)
musicdb/v3/createusers.sql		SQL script to create users and
					 do GRANTs (run 2nd)
musicdb/v3/createtables.sql		SQL script to CREATE TABLEs (run 3rd)

musicdb/v3/db.inc			Database, user, password info
musicdb/v3/handle_errors.php		PHP functions to handle CGI and
					 MySQL errors
musicdb/v3/index.php			PHP application to insert new tracks
					 into database
musicdb/v3/safeinput.php		PHP functions to minimize the threat
					 of SQL injection

musicdb/v3/insert_album_tracks.sql	SQL scripts to INSERT initial rows
musicdb/v3/insert_albums.sql		 (run these in any order, after
musicdb/v3/insert_artists.sql		  the first three SQL scripts)
musicdb/v3/insert_genres.sql
musicdb/v3/insert_media_types.sql
musicdb/v3/insert_singles.sql
musicdb/v3/insert_tracks.sql

musicdb/v3/select_singles.sql			SQL queries demonstrating
musicdb/v3/select_singles_from_albums.sql	 joins 
musicdb/v3/select_specific_album.sql

Last updated:
Tue Nov 25 21:36:38 EST 2008