The blackberry handheld backup file contains user data. The file have extention of .ipd. With IPDEditor, you can visualy edit the backup file of blackberry. You can even do data export/import to ipd file.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001088s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.090124s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001536s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002074s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001631s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005574s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001235s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.006564s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015658s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001651s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 247494 [ RunTime:0.035964s ]
