/* SQG is now better at parsing CREATE TABLE query files
   like this one.  "primary key" is now parsed and the
   words "create table" can be mixed case.  see gettable.c
   in MODULE_ChangeLog for more details.  */


/* This table is for albums only */
CrEAtE TABLE Albums(artist

       CHAR(85)     NOT NULL,
artist_website1  CHAR(128),
artist_website2  CHAR(128),
album_name       CHAR(85)     NOT NULL,
album_year       CHAR(4),
album_id         INT          NOT NULL primary key,
num_tracks       INT ,
location1        CHAR(15),
location2        CHAR(15),
location3        CHAR(15),
comments         CHAR(255)

);



/* Movie Soundtracks only */
CREATE TABLE Soundtracks
(

movie_name      CHAR(75)      NOT NULL,
movie_year      CHAR(4),
sndtrack_id     INT           NOT NULL, /* primary key */
num_tracks      INT ,
comments        CHAR(255)     NOT NULL

);


/*  Table for DVD's */

CREATE TABLE dvd_collection(

dvd_number    INT NOT NULL PRIMARY KEY , /*this is the primary key*/
dvd_name      CHAR(50),
year          CHAR(4) NOT NULL      /* the year it was made */

);