Commit | Line | Data |
c1a04675 |
1 | -- |
2 | -- Created by SQL::Translator::Producer::SQLite |
3 | -- Created on Tue Aug 8 01:53:20 2006 |
4 | -- |
5 | BEGIN TRANSACTION; |
6 | |
7 | -- |
8 | -- Table: cd_to_producer |
9 | -- |
10 | CREATE TABLE cd_to_producer ( |
11 | cd integer NOT NULL, |
12 | producer integer NOT NULL, |
13 | PRIMARY KEY (cd, producer) |
14 | ); |
15 | |
16 | -- |
17 | -- Table: artist |
18 | -- |
19 | CREATE TABLE artist ( |
20 | artistid INTEGER PRIMARY KEY NOT NULL, |
21 | name varchar(100) |
22 | ); |
23 | |
24 | |
25 | -- |
26 | -- Table: cd |
27 | -- |
28 | CREATE TABLE cd ( |
29 | cdid INTEGER PRIMARY KEY NOT NULL, |
30 | artist integer NOT NULL, |
31 | title varchar(100) NOT NULL, |
32 | year varchar(100) NOT NULL |
33 | ); |
34 | |
35 | -- |
36 | -- Table: track |
37 | -- |
38 | CREATE TABLE track ( |
39 | trackid INTEGER PRIMARY KEY NOT NULL, |
40 | cd integer NOT NULL, |
41 | position integer NOT NULL, |
42 | title varchar(100) NOT NULL, |
43 | last_updated_on datetime NULL |
44 | ); |
45 | |
46 | -- |
47 | -- Table: tags |
48 | -- |
49 | CREATE TABLE tags ( |
50 | tagid INTEGER PRIMARY KEY NOT NULL, |
51 | cd integer NOT NULL, |
52 | tag varchar(100) NOT NULL |
53 | ); |
54 | |
55 | -- |
56 | -- Table: producer |
57 | -- |
58 | CREATE TABLE producer ( |
59 | producerid INTEGER PRIMARY KEY NOT NULL, |
60 | name varchar(100) NOT NULL |
61 | ); |
62 | |
63 | COMMIT; |