--
-- Created by SQL::Translator::Producer::SQLite
-- Created on Tue Aug 8 01:53:20 2006
--
BEGIN TRANSACTION;
--
-- Table: cd_to_producer
--
CREATE TABLE cd_to_producer (
cd integer NOT NULL,
producer integer NOT NULL,
PRIMARY KEY (cd, producer)
);
--
-- Table: artist
--
CREATE TABLE artist (
artistid INTEGER PRIMARY KEY NOT NULL,
name varchar(100)
);
--
-- Table: cd
--
CREATE TABLE cd (
cdid INTEGER PRIMARY KEY NOT NULL,
artist integer NOT NULL,
title varchar(100) NOT NULL,
year varchar(100) NOT NULL
);
--
-- Table: track
--
CREATE TABLE track (
trackid INTEGER PRIMARY KEY NOT NULL,
cd integer NOT NULL,
position integer NOT NULL,
title varchar(100) NOT NULL,
last_updated_on datetime NULL
);
--
-- Table: tags
--
CREATE TABLE tags (
tagid INTEGER PRIMARY KEY NOT NULL,
cd integer NOT NULL,
tag varchar(100) NOT NULL
);
--
-- Table: producer
--
CREATE TABLE producer (
producerid INTEGER PRIMARY KEY NOT NULL,
name varchar(100) NOT NULL
);
COMMIT;