sqlite3 - explore a .db !

Got a .db and tried to find what's inside... :)

$ sqlite3 realtek.db 
SQLite version 3.6.16
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .databases
seq  name             file                                                      
---  ---------------  ----------------------------------------------------------
0    main             /nfstmp/realtek.db                                        
sqlite> .tables
t_file_uid  t_playlist
sqlite> .schema
CREATE TABLE t_file_uid (file_uid INTEGER not null,file_path VARCHAR(512) not null,PRIMARY KEY(file_uid));
CREATE TABLE t_playlist (channel_id INTEGER not null,flip_id INTEGER not null default 0,disk_partition_id VARCHAR(64) not null,file_uid INTEGER not null,resume_play_time INTEGER not null,timestamp DATA not null,PRIMARY KEY(channel_id, file_uid));
sqlite> select * from t_file_uid;
-2071458204|/tmp/usbmounts/sda1/idownloader/20100108危機倒數/AVSEQ01.MPG
-1756245902|/tmp/usbmounts/sda1/idownloader/Email/demoVideo@noMovie.com/20091224十月圍城DVD/cd1.rmvb
-1727616751|/tmp/usbmounts/sda1/idownloader/Email/demoVideo@noMovie.com/20091224十月圍城DVD/cd2.rmvb
-1593361965|/tmp/usbmounts/sda1/idownloader/Email/demoVideo@noMovie.com/20091214福爾摩斯/Sherlock Holmes.rmvb
-1169771785|/tmp/usbmounts/sda1/idownloader/20100108爆裂警官/cd1.rmvb
-1141142634|/tmp/usbmounts/sda1/idownloader/20100108爆裂警官/cd2.rmvb
-364296195|/tmp/usbmounts/sda1/idownloader/2012.iso
-171856212|/tmp/usbmounts/sda1/idownloader/Email/demoVideo@noMovie.com/20091217阿凡達/[无极电影-www.wujidy.com].阿凡达-cd1.rmvb
-154010674|/tmp/usbmounts/sda1/idownloader/2012/2012.avi
-143227061|/tmp/usbmounts/sda1/idownloader/Email/demoVideo@noMovie.com/20091217阿凡達/[无极电影-www.wujidy.com].阿凡达-cd2.rmvb
303893828|/tmp/usbmounts/sda1/idownloader/IronMan2008.rmvb
1141848971|/tmp/usbmounts/sda1/idownloader/WallE.iso
1315910659|/tmp/usbmounts/sda1/idownloader/Monga/VIDEO_TS/VIDEO_TS.IFO
1734234585|/tmp/usbmounts/sda1/idownloader/20100108危機倒數/AVSEQ0.MPG
sqlite> select * from t_playlist;
99|0|0|-1727616751|0|sda1$947285315$6994$cd2.rmvb
99|0|0|-1756245902|0|sda1$947285315$6994$cd1.rmvb
99|0|0|-143227061|0|sda1$947285315$77d6$[无极电影-www.wujidy.com].阿凡达-cd2.rmvb
99|0|0|-171856212|0|sda1$947285315$77d6$[无极电影-www.wujidy.com].阿凡达-cd1.rmvb
99|0|0|-1593361965|0|sda1$947285315$eff6$Sherlock Holmes.rmvb
99|0|0|303893828|0|sda1$947285315$8d3c$IronMan2008.rmvb
99|0|0|-154010674|0|sda1$947265134$f09b$2012.avi
99|0|0|-1169771785|0|sda1$947264575$a0b8$cd1.rmvb
99|0|0|-1141142634|0|sda1$947264575$a0b8$cd2.rmvb
99|0|0|-2071458204|0|sda1$947264471$9fac$AVSEQ01.MPG
99|0|0|1734234585|0|sda1$947264471$9fac$AVSEQ0.MPG
99|0|0|-364296195|7|sda1$947264471$8d3c$2012.iso
99|0|0|1141848971|0|sda1$947264471$8d3c$WallE.iso
99|0|0|1315910659|0|sda1$946658411$e85d$VIDEO_TS.IFO
sqlite> .exit

$