2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Sun Mar 19 19:16:50 2006
10 CREATE TABLE serialized (
11 id INTEGER PRIMARY KEY NOT NULL,
12 serialized text NOT NULL
18 CREATE TABLE twokeys (
19 artist integer NOT NULL,
21 PRIMARY KEY (artist, cd)
27 CREATE TABLE liner_notes (
28 liner_id INTEGER PRIMARY KEY NOT NULL,
29 notes varchar(100) NOT NULL
33 -- Table: cd_to_producer
35 CREATE TABLE cd_to_producer (
37 producer integer NOT NULL,
38 PRIMARY KEY (cd, producer)
45 artistid INTEGER PRIMARY KEY NOT NULL,
50 -- Table: self_ref_alias
52 CREATE TABLE self_ref_alias (
53 self_ref integer NOT NULL,
54 alias integer NOT NULL,
55 PRIMARY KEY (self_ref, alias)
61 CREATE TABLE fourkeys (
64 hello integer NOT NULL,
65 goodbye integer NOT NULL,
66 PRIMARY KEY (foo, bar, hello, goodbye)
73 cdid INTEGER PRIMARY KEY NOT NULL,
74 artist integer NOT NULL,
75 title varchar(100) NOT NULL,
76 year varchar(100) NOT NULL
80 -- Table: artist_undirected_map
82 CREATE TABLE artist_undirected_map (
85 PRIMARY KEY (id1, id2)
92 id INTEGER PRIMARY KEY NOT NULL,
93 artist integer NOT NULL,
101 trackid INTEGER PRIMARY KEY NOT NULL,
103 position integer NOT NULL,
104 title varchar(100) NOT NULL
110 CREATE TABLE producer (
111 producerid INTEGER PRIMARY KEY NOT NULL,
112 name varchar(100) NOT NULL
119 tagid INTEGER PRIMARY KEY NOT NULL,
121 tag varchar(100) NOT NULL
127 CREATE TABLE self_ref (
128 id INTEGER PRIMARY KEY NOT NULL,
129 name varchar(100) NOT NULL
135 CREATE TABLE treelike (
136 id INTEGER PRIMARY KEY NOT NULL,
137 parent integer NOT NULL,
138 name varchar(100) NOT NULL