2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Thu Mar 23 11:13:18 2006
8 -- Table: employees_positioned
10 CREATE TABLE employees_positioned (
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
26 -- Table: cd_to_producer
28 CREATE TABLE cd_to_producer (
30 producer integer NOT NULL,
31 PRIMARY KEY (cd, producer)
37 CREATE TABLE liner_notes (
38 liner_id INTEGER PRIMARY KEY NOT NULL,
39 notes varchar(100) NOT NULL
43 -- Table: employees_adjacencylist
45 CREATE TABLE employees_adjacencylist (
46 employee_id INTEGER PRIMARY KEY NOT NULL,
55 artistid INTEGER PRIMARY KEY NOT NULL,
60 -- Table: employees_positioned_adjacencylist
62 CREATE TABLE employees_positioned_adjacencylist (
63 employee_id INTEGER PRIMARY KEY NOT NULL,
65 position integer NOT NULL,
70 -- Table: self_ref_alias
72 CREATE TABLE self_ref_alias (
73 self_ref integer NOT NULL,
74 alias integer NOT NULL,
75 PRIMARY KEY (self_ref, alias)
82 cdid INTEGER PRIMARY KEY NOT NULL,
83 artist integer NOT NULL,
84 title varchar(100) NOT NULL,
85 year varchar(100) NOT NULL
92 trackid INTEGER PRIMARY KEY NOT NULL,
94 position integer NOT NULL,
95 title varchar(100) NOT NULL
101 CREATE TABLE treelike (
102 id INTEGER PRIMARY KEY NOT NULL,
103 parent integer NOT NULL,
104 name varchar(100) NOT NULL
111 tagid INTEGER PRIMARY KEY NOT NULL,
113 tag varchar(100) NOT NULL
119 CREATE TABLE self_ref (
120 id INTEGER PRIMARY KEY NOT NULL,
121 name varchar(100) NOT NULL
127 CREATE TABLE twokeys (
128 artist integer NOT NULL,
130 PRIMARY KEY (artist, cd)
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)
145 -- Table: artist_undirected_map
147 CREATE TABLE artist_undirected_map (
148 id1 integer NOT NULL,
149 id2 integer NOT NULL,
150 PRIMARY KEY (id1, id2)
156 CREATE TABLE onekey (
157 id INTEGER PRIMARY KEY NOT NULL,
158 artist integer NOT NULL,
165 CREATE TABLE producer (
166 producerid INTEGER PRIMARY KEY NOT NULL,
167 name varchar(100) NOT NULL