View Single Post
Old 12-15-2011, 01:54 AM   #1475
bonzi
Enthusiast
bonzi once ate a cherry pie in a record 7 seconds.bonzi once ate a cherry pie in a record 7 seconds.bonzi once ate a cherry pie in a record 7 seconds.bonzi once ate a cherry pie in a record 7 seconds.bonzi once ate a cherry pie in a record 7 seconds.bonzi once ate a cherry pie in a record 7 seconds.bonzi once ate a cherry pie in a record 7 seconds.bonzi once ate a cherry pie in a record 7 seconds.bonzi once ate a cherry pie in a record 7 seconds.bonzi once ate a cherry pie in a record 7 seconds.bonzi once ate a cherry pie in a record 7 seconds.
 
bonzi's Avatar
 
Posts: 46
Karma: 1530
Join Date: Nov 2011
Location: Zagreb, Croatia
Device: K2i, K3/KK WiFi, Basic (old), 2xFire, 2xPW (old), Voyage, Scribe
Quote:
Originally Posted by Faw View Post
I see no book information anywhere in the databases though.
They seem to be in table collection_item_v1_0.

Edit: entries for Amazon content seem to be simply book file names (ASIN and type, mostly); other items look like Microsoft object IDs, though.

Code:
create table collection_item_v1_0 ( 
    collection_id integer not null,
    item_uid varchar(32) not null,
    create_ts datetime not null,
    primary key(collection_id, item_uid),
    foreign key(collection_id) references collection(collection_id)
)

Last edited by bonzi; 12-15-2011 at 02:08 AM.
bonzi is offline