Commit | Line | Data |
0009fa49 |
1 | -- |
2 | -- Created by SQL::Translator::Producer::SQLite |
9c2c91ea |
3 | -- Created on Fri May 12 01:09:57 2006 |
0009fa49 |
4 | -- |
5 | BEGIN TRANSACTION; |
6 | |
7 | -- |
8fcf21b3 |
8 | -- Table: serialized |
9 | -- |
10 | CREATE TABLE serialized ( |
11 | id INTEGER PRIMARY KEY NOT NULL, |
12 | serialized text NOT NULL |
13 | ); |
14 | |
15 | -- |
8fcf21b3 |
16 | -- Table: liner_notes |
17 | -- |
18 | CREATE TABLE liner_notes ( |
19 | liner_id INTEGER PRIMARY KEY NOT NULL, |
20 | notes varchar(100) NOT NULL |
21 | ); |
22 | |
23 | -- |
0009fa49 |
24 | -- Table: cd_to_producer |
25 | -- |
26 | CREATE TABLE cd_to_producer ( |
27 | cd integer NOT NULL, |
28 | producer integer NOT NULL, |
29 | PRIMARY KEY (cd, producer) |
30 | ); |
31 | |
32 | -- |
33 | -- Table: artist |
34 | -- |
35 | CREATE TABLE artist ( |
36 | artistid INTEGER PRIMARY KEY NOT NULL, |
8fcf21b3 |
37 | name varchar(100) |
0009fa49 |
38 | ); |
39 | |
40 | -- |
9c2c91ea |
41 | -- Table: twokeytreelike |
42 | -- |
43 | CREATE TABLE twokeytreelike ( |
44 | id1 integer NOT NULL, |
45 | id2 integer NOT NULL, |
46 | parent1 integer NOT NULL, |
47 | parent2 integer NOT NULL, |
48 | name varchar(100) NOT NULL, |
49 | PRIMARY KEY (id1, id2) |
50 | ); |
51 | |
52 | -- |
0009fa49 |
53 | -- Table: self_ref_alias |
54 | -- |
55 | CREATE TABLE self_ref_alias ( |
56 | self_ref integer NOT NULL, |
887ce227 |
57 | alias integer NOT NULL, |
58 | PRIMARY KEY (self_ref, alias) |
0009fa49 |
59 | ); |
60 | |
61 | -- |
0009fa49 |
62 | -- Table: cd |
63 | -- |
64 | CREATE TABLE cd ( |
65 | cdid INTEGER PRIMARY KEY NOT NULL, |
66 | artist integer NOT NULL, |
8fcf21b3 |
67 | title varchar(100) NOT NULL, |
68 | year varchar(100) NOT NULL |
0009fa49 |
69 | ); |
70 | |
71 | -- |
9c2c91ea |
72 | -- Table: bookmark |
0009fa49 |
73 | -- |
9c2c91ea |
74 | CREATE TABLE bookmark ( |
0009fa49 |
75 | id INTEGER PRIMARY KEY NOT NULL, |
9c2c91ea |
76 | link integer NOT NULL |
0009fa49 |
77 | ); |
78 | |
79 | -- |
80 | -- Table: track |
81 | -- |
82 | CREATE TABLE track ( |
83 | trackid INTEGER PRIMARY KEY NOT NULL, |
84 | cd integer NOT NULL, |
85 | position integer NOT NULL, |
8fcf21b3 |
86 | title varchar(100) NOT NULL |
0009fa49 |
87 | ); |
88 | |
89 | -- |
9c2c91ea |
90 | -- Table: link |
1c339d71 |
91 | -- |
9c2c91ea |
92 | CREATE TABLE link ( |
93 | id INTEGER PRIMARY KEY NOT NULL, |
94 | url varchar(100), |
95 | title varchar(100) |
96 | ); |
97 | |
98 | -- |
99 | -- Table: self_ref |
100 | -- |
101 | CREATE TABLE self_ref ( |
102 | id INTEGER PRIMARY KEY NOT NULL, |
103 | name varchar(100) NOT NULL |
104 | ); |
105 | |
106 | -- |
107 | -- Table: treelike |
108 | -- |
109 | CREATE TABLE treelike ( |
110 | id INTEGER PRIMARY KEY NOT NULL, |
111 | parent integer NOT NULL, |
8fcf21b3 |
112 | name varchar(100) NOT NULL |
0009fa49 |
113 | ); |
114 | |
115 | -- |
116 | -- Table: tags |
117 | -- |
118 | CREATE TABLE tags ( |
333cce60 |
119 | tagid INTEGER PRIMARY KEY NOT NULL, |
0009fa49 |
120 | cd integer NOT NULL, |
8fcf21b3 |
121 | tag varchar(100) NOT NULL |
0009fa49 |
122 | ); |
123 | |
887ce227 |
124 | -- |
9c2c91ea |
125 | -- Table: twokeys |
887ce227 |
126 | -- |
9c2c91ea |
127 | CREATE TABLE twokeys ( |
128 | artist integer NOT NULL, |
129 | cd integer NOT NULL, |
130 | PRIMARY KEY (artist, cd) |
131 | ); |
132 | |
133 | -- |
134 | -- Table: fourkeys |
135 | -- |
136 | CREATE TABLE fourkeys ( |
137 | foo integer NOT NULL, |
138 | bar integer NOT NULL, |
139 | hello integer NOT NULL, |
140 | goodbye integer NOT NULL, |
141 | PRIMARY KEY (foo, bar, hello, goodbye) |
142 | ); |
143 | |
144 | -- |
145 | -- Table: artist_undirected_map |
146 | -- |
147 | CREATE TABLE artist_undirected_map ( |
148 | id1 integer NOT NULL, |
149 | id2 integer NOT NULL, |
150 | PRIMARY KEY (id1, id2) |
151 | ); |
152 | |
153 | -- |
154 | -- Table: producer |
155 | -- |
156 | CREATE TABLE producer ( |
157 | producerid INTEGER PRIMARY KEY NOT NULL, |
8fcf21b3 |
158 | name varchar(100) NOT NULL |
887ce227 |
159 | ); |
160 | |
9fcda149 |
161 | -- |
9c2c91ea |
162 | -- Table: onekey |
9fcda149 |
163 | -- |
9c2c91ea |
164 | CREATE TABLE onekey ( |
8fcf21b3 |
165 | id INTEGER PRIMARY KEY NOT NULL, |
9c2c91ea |
166 | artist integer NOT NULL, |
167 | cd integer NOT NULL |
9fcda149 |
168 | ); |
169 | |
0009fa49 |
170 | COMMIT; |