awpti - php source

CREATE DATABASE MusicDB;
CREATE TABLE Artists (
        Artist   VARCHAR(64),
        ArtistID        INT NOT NULL PRIMARY KEY AUTO_INCREMENT
);
 
CREATE TABLE Songs (
        SName      VARCHAR(64),
        SLength  INT, # Seconds
        SGenreID        INT,
        SArtistID       INT, # ID from the Artists Table
        SAlbumID        INT, # Comma-seperated list of Albums a song appears on.
        SongID    INT NOT NULL PRIMARY KEY AUTO_INCREMENT
);
 
CREATE TABLE Albums (
        AName      VARCHAR(128),
        ANumSongs       INT, # Number of songs on the album. Duh.
        AArtistID       INT, # ID from the Artists Table.
        AlbumID  INT NOT NULL PRIMARY KEY AUTO_INCREMENT
);
 
CREATE TABLE Genre (
        Genre   VARCHAR(32),
        GenreID INT NOT NULL PRIMARY KEY AUTO_INCREMENT
);
 
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Alternative', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Ambient', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Blues', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Children\'s Music', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Christian & Gospel', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Classical', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Comedy', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Country & Western', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Electronica & Dance', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Folk & Acoustic', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Jazz', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Rock', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Heavy Metal', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('New Age', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Pop', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Rap & Hip-Hop', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Roots & World', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Soul/R&B', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Soundtracks', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Vocal', NULL);