2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Sat May 20 01:05:10 2006
10 CREATE TABLE employee (
11 employee_id INTEGER PRIMARY KEY NOT NULL,
12 position integer NOT NULL,
20 CREATE TABLE serialized (
21 id INTEGER PRIMARY KEY NOT NULL,
22 serialized text NOT NULL
28 CREATE TABLE liner_notes (
29 liner_id INTEGER PRIMARY KEY NOT NULL,
30 notes varchar(100) NOT NULL
34 -- Table: cd_to_producer
36 CREATE TABLE cd_to_producer (
38 producer integer NOT NULL,
39 PRIMARY KEY (cd, producer)
46 artistid INTEGER PRIMARY KEY NOT NULL,
51 -- Table: twokeytreelike
53 CREATE TABLE twokeytreelike (
56 parent1 integer NOT NULL,
57 parent2 integer NOT NULL,
58 name varchar(100) NOT NULL,
59 PRIMARY KEY (id1, id2)
63 -- Table: self_ref_alias
65 CREATE TABLE self_ref_alias (
66 self_ref integer NOT NULL,
67 alias integer NOT NULL,
68 PRIMARY KEY (self_ref, alias)
75 cdid INTEGER PRIMARY KEY NOT NULL,
76 artist integer NOT NULL,
77 title varchar(100) NOT NULL,
78 year varchar(100) NOT NULL
84 CREATE TABLE bookmark (
85 id INTEGER PRIMARY KEY NOT NULL,
93 trackid INTEGER PRIMARY KEY NOT NULL,
95 position integer NOT NULL,
96 title varchar(100) NOT NULL
102 CREATE TABLE self_ref (
103 id INTEGER PRIMARY KEY NOT NULL,
104 name varchar(100) NOT NULL
110 CREATE TABLE treelike (
111 id INTEGER PRIMARY KEY NOT NULL,
112 parent integer NOT NULL,
113 name varchar(100) NOT NULL
120 tagid INTEGER PRIMARY KEY NOT NULL,
122 tag varchar(100) NOT NULL
128 CREATE TABLE treelike (
129 id INTEGER PRIMARY KEY NOT NULL,
130 parent integer NOT NULL,
131 name varchar(100) NOT NULL
138 id INTEGER PRIMARY KEY NOT NULL,
147 id INTEGER PRIMARY KEY NOT NULL,
148 starts_at datetime NOT NULL
154 CREATE TABLE twokeys (
155 artist integer NOT NULL,
157 PRIMARY KEY (artist, cd)
163 CREATE TABLE fourkeys (
164 foo integer NOT NULL,
165 bar integer NOT NULL,
166 hello integer NOT NULL,
167 goodbye integer NOT NULL,
168 PRIMARY KEY (foo, bar, hello, goodbye)
172 -- Table: artist_undirected_map
174 CREATE TABLE artist_undirected_map (
175 id1 integer NOT NULL,
176 id2 integer NOT NULL,
177 PRIMARY KEY (id1, id2)
183 CREATE TABLE onekey (
184 id INTEGER PRIMARY KEY NOT NULL,
185 artist integer NOT NULL,
192 CREATE TABLE producer (
193 producerid INTEGER PRIMARY KEY NOT NULL,
194 name varchar(100) NOT NULL
197 CREATE UNIQUE INDEX tktlnameunique_twokeytreelike on twokeytreelike (name);
198 CREATE UNIQUE INDEX artist_title_cd on cd (artist, title);