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