1-- 2-- Table: artist 3-- 4CREATE TABLE artist ( 5 artistid INTEGER PRIMARY KEY NOT NULL, 6 name varchar(100), 7 rank integer NOT NULL DEFAULT '13', 8 charfield char(10) 9); 10 11 12-- 13-- Table: artist_undirected_map 14-- 15CREATE TABLE artist_undirected_map ( 16 id1 integer NOT NULL, 17 id2 integer NOT NULL, 18 PRIMARY KEY (id1, id2) 19); 20 21CREATE INDEX artist_undirected_map_idx_id1_ ON artist_undirected_map (id1); 22CREATE INDEX artist_undirected_map_idx_id2_ ON artist_undirected_map (id2); 23 24-- 25-- Table: cd_artwork 26-- 27CREATE TABLE cd_artwork ( 28 cd_id INTEGER PRIMARY KEY NOT NULL 29); 30 31CREATE INDEX cd_artwork_idx_cd_id_cd_artwor ON cd_artwork (cd_id); 32 33-- 34-- Table: artwork_to_artist 35-- 36CREATE TABLE artwork_to_artist ( 37 artwork_cd_id integer NOT NULL, 38 artist_id integer NOT NULL, 39 PRIMARY KEY (artwork_cd_id, artist_id) 40); 41 42CREATE INDEX artwork_to_artist_idx_artist_id_artwork_to_arti ON artwork_to_artist (artist_id); 43CREATE INDEX artwork_to_artist_idx_artwork_cd_id_artwork_to_ ON artwork_to_artist (artwork_cd_id); 44 45-- 46-- Table: bookmark 47-- 48CREATE TABLE bookmark ( 49 id INTEGER PRIMARY KEY NOT NULL, 50 link integer NOT NULL 51); 52 53CREATE INDEX bookmark_idx_link_bookmark ON bookmark (link); 54 55-- 56-- Table: books 57-- 58CREATE TABLE books ( 59 id INTEGER PRIMARY KEY NOT NULL, 60 source varchar(100) NOT NULL, 61 owner integer NOT NULL, 62 title varchar(100) NOT NULL, 63 price integer 64); 65 66 67-- 68-- Table: cd 69-- 70CREATE TABLE cd ( 71 cdid INTEGER PRIMARY KEY NOT NULL, 72 artist integer NOT NULL, 73 title varchar(100) NOT NULL, 74 year varchar(100) NOT NULL, 75 genreid integer, 76 single_track_id integer 77); 78 79CREATE INDEX cd_idx_artist_cd ON cd (artist); 80CREATE INDEX cd_idx_genreid_cd ON cd (genreid); 81CREATE INDEX cd_idx_single_track_cd ON cd (single_track_id); 82CREATE UNIQUE INDEX cd_artist_title_cd ON cd (artist, title); 83 84-- 85-- Table: cd_to_producer 86-- 87CREATE TABLE cd_to_producer ( 88 cd integer NOT NULL, 89 producer integer NOT NULL, 90 PRIMARY KEY (cd, producer) 91); 92 93CREATE INDEX cd_to_producer_idx_cd_cd_to_pr ON cd_to_producer (cd); 94CREATE INDEX cd_to_producer_idx_producer_cd ON cd_to_producer (producer); 95 96-- 97-- Table: collection 98-- 99CREATE TABLE collection ( 100 collectionid INTEGER PRIMARY KEY NOT NULL, 101 name varchar(100) NOT NULL 102); 103 104 105-- 106-- Table: collection_object 107-- 108CREATE TABLE collection_object ( 109 collection integer NOT NULL, 110 object integer NOT NULL, 111 PRIMARY KEY (collection, object) 112); 113 114CREATE INDEX collection_object_idx_collection_collection_obj ON collection_object (collection); 115CREATE INDEX collection_object_idx_object_c ON collection_object (object); 116 117-- 118-- Table: employee 119-- 120CREATE TABLE employee ( 121 employee_id INTEGER PRIMARY KEY NOT NULL, 122 position integer NOT NULL, 123 group_id integer, 124 group_id_2 integer, 125 name varchar(100) 126); 127 128 129-- 130-- Table: event 131-- 132CREATE TABLE event ( 133 id INTEGER PRIMARY KEY NOT NULL, 134 starts_at datetime NOT NULL, 135 created_on timestamp NOT NULL, 136 varchar_date varchar(20), 137 varchar_datetime varchar(20), 138 skip_inflation datetime 139); 140 141 142-- 143-- Table: file_columns 144-- 145CREATE TABLE file_columns ( 146 id INTEGER PRIMARY KEY NOT NULL, 147 file varchar(255) NOT NULL 148); 149 150 151-- 152-- Table: forceforeign 153-- 154CREATE TABLE forceforeign ( 155 artist INTEGER PRIMARY KEY NOT NULL, 156 cd integer NOT NULL 157); 158 159CREATE INDEX forceforeign_idx_artist_forcef ON forceforeign (artist); 160 161-- 162-- Table: fourkeys 163-- 164CREATE TABLE fourkeys ( 165 foo integer NOT NULL, 166 bar integer NOT NULL, 167 hello integer NOT NULL, 168 goodbye integer NOT NULL, 169 sensors character NOT NULL, 170 PRIMARY KEY (foo, bar, hello, goodbye) 171); 172 173 174-- 175-- Table: fourkeys_to_twokeys 176-- 177CREATE TABLE fourkeys_to_twokeys ( 178 f_foo integer NOT NULL, 179 f_bar integer NOT NULL, 180 f_hello integer NOT NULL, 181 f_goodbye integer NOT NULL, 182 t_artist integer NOT NULL, 183 t_cd integer NOT NULL, 184 autopilot character NOT NULL, 185 PRIMARY KEY (f_foo, f_bar, f_hello, f_goodbye, t_artist, t_cd) 186); 187 188CREATE INDEX fourkeys_to_twokeys_idx_f_foo_f_bar_f_hello_f_goodbye_ ON fourkeys_to_twokeys (f_foo, f_bar, f_hello, f_goodbye); 189CREATE INDEX fourkeys_to_twokeys_idx_t_artist_t_cd_fourkeys_to ON fourkeys_to_twokeys (t_artist, t_cd); 190 191-- 192-- Table: genre 193-- 194CREATE TABLE genre ( 195 genreid INTEGER PRIMARY KEY NOT NULL, 196 name varchar(100) NOT NULL 197); 198 199CREATE UNIQUE INDEX genre_name_genre ON genre (name); 200 201-- 202-- Table: images 203-- 204CREATE TABLE images ( 205 id INTEGER PRIMARY KEY NOT NULL, 206 artwork_id integer NOT NULL, 207 name varchar(100) NOT NULL, 208 data blob 209); 210 211CREATE INDEX images_idx_artwork_id_images ON images (artwork_id); 212 213-- 214-- Table: liner_notes 215-- 216CREATE TABLE liner_notes ( 217 liner_id INTEGER PRIMARY KEY NOT NULL, 218 notes varchar(100) NOT NULL 219); 220 221CREATE INDEX liner_notes_idx_liner_id_liner ON liner_notes (liner_id); 222 223-- 224-- Table: link 225-- 226CREATE TABLE link ( 227 id INTEGER PRIMARY KEY NOT NULL, 228 url varchar(100), 229 title varchar(100) 230); 231 232 233-- 234-- Table: lyric_versions 235-- 236CREATE TABLE lyric_versions ( 237 id INTEGER PRIMARY KEY NOT NULL, 238 lyric_id integer NOT NULL, 239 text varchar(100) NOT NULL 240); 241 242CREATE INDEX lyric_versions_idx_lyric_id_ly ON lyric_versions (lyric_id); 243 244-- 245-- Table: lyrics 246-- 247CREATE TABLE lyrics ( 248 lyric_id INTEGER PRIMARY KEY NOT NULL, 249 track_id integer NOT NULL 250); 251 252CREATE INDEX lyrics_idx_track_id_lyrics ON lyrics (track_id); 253 254-- 255-- Table: noprimarykey 256-- 257CREATE TABLE noprimarykey ( 258 foo integer NOT NULL, 259 bar integer NOT NULL, 260 baz integer NOT NULL 261); 262 263CREATE UNIQUE INDEX foo_bar_noprimarykey ON noprimarykey (foo, bar); 264 265-- 266-- Table: onekey 267-- 268CREATE TABLE onekey ( 269 id INTEGER PRIMARY KEY NOT NULL, 270 artist integer NOT NULL, 271 cd integer NOT NULL 272); 273 274 275-- 276-- Table: owners 277-- 278CREATE TABLE owners ( 279 ownerid INTEGER PRIMARY KEY NOT NULL, 280 name varchar(100) NOT NULL 281); 282 283 284-- 285-- Table: producer 286-- 287CREATE TABLE producer ( 288 producerid INTEGER PRIMARY KEY NOT NULL, 289 name varchar(100) NOT NULL 290); 291 292CREATE UNIQUE INDEX prod_name_producer ON producer (name); 293 294-- 295-- Table: self_ref 296-- 297CREATE TABLE self_ref ( 298 id INTEGER PRIMARY KEY NOT NULL, 299 name varchar(100) NOT NULL 300); 301 302 303-- 304-- Table: self_ref_alias 305-- 306CREATE TABLE self_ref_alias ( 307 self_ref integer NOT NULL, 308 alias integer NOT NULL, 309 PRIMARY KEY (self_ref, alias) 310); 311 312CREATE INDEX self_ref_alias_idx_alias_self_ ON self_ref_alias (alias); 313CREATE INDEX self_ref_alias_idx_self_ref_se ON self_ref_alias (self_ref); 314 315-- 316-- Table: sequence_test 317-- 318CREATE TABLE sequence_test ( 319 pkid1 integer NOT NULL, 320 pkid2 integer NOT NULL, 321 nonpkid integer NOT NULL, 322 name varchar(100), 323 PRIMARY KEY (pkid1, pkid2) 324); 325 326 327-- 328-- Table: serialized 329-- 330CREATE TABLE serialized ( 331 id INTEGER PRIMARY KEY NOT NULL, 332 serialized text NOT NULL 333); 334 335 336-- 337-- Table: tags 338-- 339CREATE TABLE tags ( 340 tagid INTEGER PRIMARY KEY NOT NULL, 341 cd integer NOT NULL, 342 tag varchar(100) NOT NULL 343); 344 345CREATE INDEX tags_idx_cd_tags ON tags (cd); 346 347-- 348-- Table: track 349-- 350CREATE TABLE track ( 351 trackid INTEGER PRIMARY KEY NOT NULL, 352 cd integer NOT NULL, 353 position integer NOT NULL, 354 title varchar(100) NOT NULL, 355 last_updated_on datetime 356); 357 358CREATE INDEX track_idx_cd_track ON track (cd); 359CREATE UNIQUE INDEX track_cd_position_track ON track (cd, position); 360CREATE UNIQUE INDEX track_cd_title_track ON track (cd, title); 361 362-- 363-- Table: treelike 364-- 365CREATE TABLE treelike ( 366 id INTEGER PRIMARY KEY NOT NULL, 367 parent integer, 368 name varchar(100) NOT NULL 369); 370 371CREATE INDEX treelike_idx_parent_treelike ON treelike (parent); 372 373-- 374-- Table: twokeytreelike 375-- 376CREATE TABLE twokeytreelike ( 377 id1 integer NOT NULL, 378 id2 integer NOT NULL, 379 parent1 integer NOT NULL, 380 parent2 integer NOT NULL, 381 name varchar(100) NOT NULL, 382 PRIMARY KEY (id1, id2) 383); 384 385CREATE INDEX twokeytreelike_idx_parent1_parent2_twokeytre ON twokeytreelike (parent1, parent2); 386CREATE UNIQUE INDEX tktlnameunique_twokeytreelike ON twokeytreelike (name); 387 388-- 389-- Table: twokeys 390-- 391CREATE TABLE twokeys ( 392 artist integer NOT NULL, 393 cd integer NOT NULL, 394 PRIMARY KEY (artist, cd) 395); 396 397CREATE INDEX twokeys_idx_artist_twokeys ON twokeys (artist); 398 399-- 400-- Table: typed_object 401-- 402CREATE TABLE typed_object ( 403 objectid INTEGER PRIMARY KEY NOT NULL, 404 type varchar(100) NOT NULL, 405 value varchar(100) NOT NULL 406); 407 408