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 | |
c7aececc |
24 | -- |
25 | -- Table: artist_washed_up |
26 | -- |
27 | CREATE TABLE artist_washed_up ( |
28 | fk_artistid INTEGER PRIMARY KEY NOT NULL |
29 | ); |
c1a04675 |
30 | |
31 | -- |
32 | -- Table: cd |
33 | -- |
34 | CREATE TABLE cd ( |
35 | cdid INTEGER PRIMARY KEY NOT NULL, |
36 | artist integer NOT NULL, |
37 | title varchar(100) NOT NULL, |
38 | year varchar(100) NOT NULL |
39 | ); |
40 | |
41 | -- |
42 | -- Table: track |
43 | -- |
44 | CREATE TABLE track ( |
45 | trackid INTEGER PRIMARY KEY NOT NULL, |
46 | cd integer NOT NULL, |
47 | position integer NOT NULL, |
48 | title varchar(100) NOT NULL, |
49 | last_updated_on datetime NULL |
50 | ); |
51 | |
52 | -- |
53 | -- Table: tags |
54 | -- |
55 | CREATE TABLE tags ( |
56 | tagid INTEGER PRIMARY KEY NOT NULL, |
57 | cd integer NOT NULL, |
58 | tag varchar(100) NOT NULL |
59 | ); |
60 | |
61 | -- |
62 | -- Table: producer |
63 | -- |
64 | CREATE TABLE producer ( |
65 | producerid INTEGER PRIMARY KEY NOT NULL, |
66 | name varchar(100) NOT NULL |
67 | ); |
68 | |
69 | COMMIT; |