cd /home/user/.rtcom-eventlogger/ ~./rtcom-eventlogger/sqlite3 el.db SQLite version 3.6.14 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .tables Attachments Flags Plugins call_duration EventTypes GroupCache Remotes chat_group_info Events Headers Services sqlite>
sqlite3 el.db "select * from events order by id desc limit 5"; 23|1|2|1259485990|1259485989|0|0|0|0|0|ring/tel/ring||04xxxxxxxxxxx||| 22|1|1|1259424929|1259424913|0|0|0|0|0|ring/tel/ring||+358xxxxxxxxxx||| 21|1|1|1259325775|1259325767|0|0|0|0|0|ring/tel/ring||+358xxxxxxxxxx||| 20|1|2|1259325537|1259325536|0|0|0|0|0|ring/tel/ring||04xxxxxxxxxxx||| 19|1|2|1259325509|1259325508|0|0|0|0|0|ring/tel/ring||04xxxxxxxxxx||| (x marks numbers :-) ) edit: columns are: id|service_id|event_type_id|storage_time|start_time|end_time|is_read|flags|bytes_send|bytes_received|local_uid|local_name|remote_uid|channel|free_text|group_ud|