2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Fri Mar 24 15:47:00 2006
10 CREATE TABLE employees (
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
46 artistid INTEGER PRIMARY KEY NOT NULL,
51 -- Table: self_ref_alias
53 CREATE TABLE self_ref_alias (
54 self_ref integer NOT NULL,
55 alias integer NOT NULL,
56 PRIMARY KEY (self_ref, alias)
63 cdid INTEGER PRIMARY KEY NOT NULL,
64 artist integer NOT NULL,
65 title varchar(100) NOT NULL,
66 year varchar(100) NOT NULL
73 trackid INTEGER PRIMARY KEY NOT NULL,
75 position integer NOT NULL,
76 title varchar(100) NOT NULL
82 CREATE TABLE self_ref (
83 id INTEGER PRIMARY KEY NOT NULL,
84 name varchar(100) NOT NULL
90 CREATE TABLE treelike (
91 id INTEGER PRIMARY KEY NOT NULL,
92 parent integer NOT NULL,
93 name varchar(100) NOT NULL
100 tagid INTEGER PRIMARY KEY NOT NULL,
102 tag varchar(100) NOT NULL
108 CREATE TABLE twokeys (
109 artist integer NOT NULL,
111 PRIMARY KEY (artist, cd)
117 CREATE TABLE fourkeys (
118 foo integer NOT NULL,
119 bar integer NOT NULL,
120 hello integer NOT NULL,
121 goodbye integer NOT NULL,
122 PRIMARY KEY (foo, bar, hello, goodbye)
126 -- Table: artist_undirected_map
128 CREATE TABLE artist_undirected_map (
129 id1 integer NOT NULL,
130 id2 integer NOT NULL,
131 PRIMARY KEY (id1, id2)
137 CREATE TABLE producer (
138 producerid INTEGER PRIMARY KEY NOT NULL,
139 name varchar(100) NOT NULL
145 CREATE TABLE onekey (
146 id INTEGER PRIMARY KEY NOT NULL,
147 artist integer NOT NULL,