2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Thu Mar 23 19:41:26 2006
10 CREATE TABLE serialized (
11 id INTEGER PRIMARY KEY NOT NULL,
12 serialized text NOT NULL
16 -- Table: employees_positioned
18 CREATE TABLE employees_positioned (
19 employee_id INTEGER PRIMARY KEY NOT NULL,
20 position integer NOT NULL,
26 -- Table: employees_adjacencylist
28 CREATE TABLE employees_adjacencylist (
29 employee_id INTEGER PRIMARY KEY NOT NULL,
30 parent_id integer NOT NULL,
38 CREATE TABLE liner_notes (
39 liner_id INTEGER PRIMARY KEY NOT NULL,
40 notes varchar(100) NOT NULL
44 -- Table: cd_to_producer
46 CREATE TABLE cd_to_producer (
48 producer integer NOT NULL,
49 PRIMARY KEY (cd, producer)
56 artistid INTEGER PRIMARY KEY NOT NULL,
61 -- Table: self_ref_alias
63 CREATE TABLE self_ref_alias (
64 self_ref integer NOT NULL,
65 alias integer NOT NULL,
66 PRIMARY KEY (self_ref, alias)
73 cdid INTEGER PRIMARY KEY NOT NULL,
74 artist integer NOT NULL,
75 title varchar(100) NOT NULL,
76 year varchar(100) NOT NULL
83 trackid INTEGER PRIMARY KEY NOT NULL,
85 position integer NOT NULL,
86 title varchar(100) NOT NULL
92 CREATE TABLE self_ref (
93 id INTEGER PRIMARY KEY NOT NULL,
94 name varchar(100) NOT NULL
101 tagid INTEGER PRIMARY KEY NOT NULL,
103 tag varchar(100) NOT NULL
109 CREATE TABLE treelike (
110 id INTEGER PRIMARY KEY NOT NULL,
111 parent integer NOT NULL,
112 name varchar(100) NOT NULL
118 CREATE TABLE twokeys (
119 artist integer NOT NULL,
121 PRIMARY KEY (artist, cd)
127 CREATE TABLE fourkeys (
128 foo integer NOT NULL,
129 bar integer NOT NULL,
130 hello integer NOT NULL,
131 goodbye integer NOT NULL,
132 PRIMARY KEY (foo, bar, hello, goodbye)
136 -- Table: artist_undirected_map
138 CREATE TABLE artist_undirected_map (
139 id1 integer NOT NULL,
140 id2 integer NOT NULL,
141 PRIMARY KEY (id1, id2)
147 CREATE TABLE producer (
148 producerid INTEGER PRIMARY KEY NOT NULL,
149 name varchar(100) NOT NULL
155 CREATE TABLE onekey (
156 id INTEGER PRIMARY KEY NOT NULL,
157 artist integer NOT NULL,