Commit | Line | Data |
0009fa49 |
1 | -- |
2 | -- Created by SQL::Translator::Producer::SQLite |
3 | -- Created on Fri Jan 27 01:16:24 2006 |
4 | -- |
5 | BEGIN TRANSACTION; |
6 | |
7 | -- |
8 | -- Table: twokeys |
9 | -- |
10 | CREATE TABLE twokeys ( |
11 | artist integer NOT NULL, |
12 | cd integer NOT NULL, |
13 | PRIMARY KEY (artist, cd) |
14 | ); |
15 | |
16 | -- |
17 | -- Table: liner_notes |
18 | -- |
19 | CREATE TABLE liner_notes ( |
20 | liner_id INTEGER PRIMARY KEY NOT NULL, |
21 | notes varchar NOT NULL |
22 | ); |
23 | |
24 | -- |
25 | -- Table: cd_to_producer |
26 | -- |
27 | CREATE TABLE cd_to_producer ( |
28 | cd integer NOT NULL, |
29 | producer integer NOT NULL, |
30 | PRIMARY KEY (cd, producer) |
31 | ); |
32 | |
33 | -- |
34 | -- Table: artist |
35 | -- |
36 | CREATE TABLE artist ( |
37 | artistid INTEGER PRIMARY KEY NOT NULL, |
38 | name varchar |
39 | ); |
40 | |
41 | -- |
42 | -- Table: self_ref_alias |
43 | -- |
44 | CREATE TABLE self_ref_alias ( |
45 | self_ref integer NOT NULL, |
46 | alias integer NOT NULL |
47 | ); |
48 | |
49 | -- |
50 | -- Table: fourkeys |
51 | -- |
52 | CREATE TABLE fourkeys ( |
53 | foo integer NOT NULL, |
54 | bar integer NOT NULL, |
55 | hello integer NOT NULL, |
56 | goodbye integer NOT NULL, |
57 | PRIMARY KEY (foo, bar, hello, goodbye) |
58 | ); |
59 | |
60 | -- |
61 | -- Table: cd |
62 | -- |
63 | CREATE TABLE cd ( |
64 | cdid INTEGER PRIMARY KEY NOT NULL, |
65 | artist integer NOT NULL, |
66 | title varchar NOT NULL, |
67 | year varchar NOT NULL |
68 | ); |
69 | |
70 | -- |
71 | -- Table: artist_undirected_map |
72 | -- |
73 | CREATE TABLE artist_undirected_map ( |
74 | id1 integer NOT NULL, |
75 | id2 integer NOT NULL, |
76 | PRIMARY KEY (id1, id2) |
77 | ); |
78 | |
79 | -- |
80 | -- Table: onekey |
81 | -- |
82 | CREATE TABLE onekey ( |
83 | id INTEGER PRIMARY KEY NOT NULL, |
84 | artist integer NOT NULL, |
85 | cd integer NOT NULL |
86 | ); |
87 | |
88 | -- |
89 | -- Table: track |
90 | -- |
91 | CREATE TABLE track ( |
92 | trackid INTEGER PRIMARY KEY NOT NULL, |
93 | cd integer NOT NULL, |
94 | position integer NOT NULL, |
95 | title varchar NOT NULL |
96 | ); |
97 | |
98 | -- |
99 | -- Table: producer |
100 | -- |
101 | CREATE TABLE producer ( |
102 | producerid INTEGER PRIMARY KEY NOT NULL, |
103 | name varchar NOT NULL |
104 | ); |
105 | |
106 | -- |
107 | -- Table: self_ref |
108 | -- |
109 | CREATE TABLE self_ref ( |
110 | id INTEGER PRIMARY KEY NOT NULL, |
111 | name varchar NOT NULL |
112 | ); |
113 | |
114 | -- |
115 | -- Table: tags |
116 | -- |
117 | CREATE TABLE tags ( |
118 | tagid varchar NOT NULL, |
119 | cd integer NOT NULL, |
120 | tag varchar NOT NULL, |
121 | PRIMARY KEY (tagid) |
122 | ); |
123 | |
124 | COMMIT; |