2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Tue Mar 21 12:11:03 2006
8 -- Table: employees_positioned
10 CREATE TABLE employees_positioned (
11 employee_id INTEGER PRIMARY KEY NOT NULL,
12 position integer NOT NULL,
19 CREATE TABLE serialized (
20 id INTEGER PRIMARY KEY NOT NULL,
21 serialized text NOT NULL
25 -- Table: cd_to_producer
27 CREATE TABLE cd_to_producer (
29 producer integer NOT NULL,
30 PRIMARY KEY (cd, producer)
36 CREATE TABLE liner_notes (
37 liner_id INTEGER PRIMARY KEY NOT NULL,
38 notes varchar(100) NOT NULL
42 -- Table: employees_adjacencylist
44 CREATE TABLE employees_adjacencylist (
45 employee_id INTEGER PRIMARY KEY NOT NULL,
54 artistid INTEGER PRIMARY KEY NOT NULL,
59 -- Table: employees_positioned_adjacencylist
61 CREATE TABLE employees_positioned_adjacencylist (
62 employee_id INTEGER PRIMARY KEY NOT NULL,
64 position integer NOT NULL,
69 -- Table: self_ref_alias
71 CREATE TABLE self_ref_alias (
72 self_ref integer NOT NULL,
73 alias integer NOT NULL,
74 PRIMARY KEY (self_ref, alias)
81 cdid INTEGER PRIMARY KEY NOT NULL,
82 artist integer NOT NULL,
83 title varchar(100) NOT NULL,
84 year varchar(100) NOT NULL
91 trackid INTEGER PRIMARY KEY NOT NULL,
93 position integer NOT NULL,
94 title varchar(100) NOT NULL
100 CREATE TABLE treelike (
101 id INTEGER PRIMARY KEY NOT NULL,
102 parent integer NOT NULL,
103 name varchar(100) NOT NULL
110 tagid INTEGER PRIMARY KEY NOT NULL,
112 tag varchar(100) NOT NULL
118 CREATE TABLE self_ref (
119 id INTEGER PRIMARY KEY NOT NULL,
120 name varchar(100) NOT NULL
126 CREATE TABLE twokeys (
127 artist integer NOT NULL,
129 PRIMARY KEY (artist, cd)
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)
144 -- Table: artist_undirected_map
146 CREATE TABLE artist_undirected_map (
147 id1 integer NOT NULL,
148 id2 integer NOT NULL,
149 PRIMARY KEY (id1, id2)
155 CREATE TABLE onekey (
156 id INTEGER PRIMARY KEY NOT NULL,
157 artist integer NOT NULL,
164 CREATE TABLE producer (
165 producerid INTEGER PRIMARY KEY NOT NULL,
166 name varchar(100) NOT NULL