Commit | Line | Data |
0009fa49 |
1 | -- |
2 | -- Created by SQL::Translator::Producer::SQLite |
8fcf21b3 |
3 | -- Created on Sun Mar 19 19:16:50 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 | -- |
0009fa49 |
16 | -- Table: twokeys |
17 | -- |
18 | CREATE TABLE twokeys ( |
19 | artist integer NOT NULL, |
20 | cd integer NOT NULL, |
21 | PRIMARY KEY (artist, cd) |
22 | ); |
23 | |
24 | -- |
8fcf21b3 |
25 | -- Table: liner_notes |
26 | -- |
27 | CREATE TABLE liner_notes ( |
28 | liner_id INTEGER PRIMARY KEY NOT NULL, |
29 | notes varchar(100) NOT NULL |
30 | ); |
31 | |
32 | -- |
0009fa49 |
33 | -- Table: cd_to_producer |
34 | -- |
35 | CREATE TABLE cd_to_producer ( |
36 | cd integer NOT NULL, |
37 | producer integer NOT NULL, |
38 | PRIMARY KEY (cd, producer) |
39 | ); |
40 | |
41 | -- |
42 | -- Table: artist |
43 | -- |
44 | CREATE TABLE artist ( |
45 | artistid INTEGER PRIMARY KEY NOT NULL, |
93cec8c3 |
46 | name varchar, |
47 | position INTEGER |
0009fa49 |
48 | ); |
49 | |
50 | -- |
51 | -- Table: self_ref_alias |
52 | -- |
53 | CREATE TABLE self_ref_alias ( |
54 | self_ref integer NOT NULL, |
887ce227 |
55 | alias integer NOT NULL, |
56 | PRIMARY KEY (self_ref, alias) |
0009fa49 |
57 | ); |
58 | |
59 | -- |
60 | -- Table: fourkeys |
61 | -- |
62 | CREATE TABLE fourkeys ( |
63 | foo integer NOT NULL, |
64 | bar integer NOT NULL, |
65 | hello integer NOT NULL, |
66 | goodbye integer NOT NULL, |
67 | PRIMARY KEY (foo, bar, hello, goodbye) |
68 | ); |
69 | |
70 | -- |
71 | -- Table: cd |
72 | -- |
73 | CREATE TABLE cd ( |
74 | cdid INTEGER PRIMARY KEY NOT NULL, |
75 | artist integer NOT NULL, |
8fcf21b3 |
76 | title varchar(100) NOT NULL, |
77 | year varchar(100) NOT NULL |
0009fa49 |
78 | ); |
79 | |
80 | -- |
81 | -- Table: artist_undirected_map |
82 | -- |
83 | CREATE TABLE artist_undirected_map ( |
84 | id1 integer NOT NULL, |
85 | id2 integer NOT NULL, |
86 | PRIMARY KEY (id1, id2) |
87 | ); |
88 | |
89 | -- |
90 | -- Table: onekey |
91 | -- |
92 | CREATE TABLE onekey ( |
93 | id INTEGER PRIMARY KEY NOT NULL, |
94 | artist integer NOT NULL, |
95 | cd integer NOT NULL |
96 | ); |
97 | |
98 | -- |
99 | -- Table: track |
100 | -- |
101 | CREATE TABLE track ( |
102 | trackid INTEGER PRIMARY KEY NOT NULL, |
103 | cd integer NOT NULL, |
104 | position integer NOT NULL, |
8fcf21b3 |
105 | title varchar(100) NOT NULL |
0009fa49 |
106 | ); |
107 | |
108 | -- |
1c339d71 |
109 | -- Table: producer |
110 | -- |
111 | CREATE TABLE producer ( |
112 | producerid INTEGER PRIMARY KEY NOT NULL, |
8fcf21b3 |
113 | name varchar(100) NOT NULL |
0009fa49 |
114 | ); |
115 | |
116 | -- |
117 | -- Table: tags |
118 | -- |
119 | CREATE TABLE tags ( |
333cce60 |
120 | tagid INTEGER PRIMARY KEY NOT NULL, |
0009fa49 |
121 | cd integer NOT NULL, |
8fcf21b3 |
122 | tag varchar(100) NOT NULL |
0009fa49 |
123 | ); |
124 | |
887ce227 |
125 | -- |
126 | -- Table: self_ref |
127 | -- |
128 | CREATE TABLE self_ref ( |
129 | id INTEGER PRIMARY KEY NOT NULL, |
8fcf21b3 |
130 | name varchar(100) NOT NULL |
887ce227 |
131 | ); |
132 | |
9fcda149 |
133 | -- |
8fcf21b3 |
134 | -- Table: treelike |
9fcda149 |
135 | -- |
8fcf21b3 |
136 | CREATE TABLE treelike ( |
137 | id INTEGER PRIMARY KEY NOT NULL, |
138 | parent integer NOT NULL, |
139 | name varchar(100) NOT NULL |
9fcda149 |
140 | ); |
141 | |
0009fa49 |
142 | COMMIT; |