This blog is a dumping-ground for research, thoughts and developments. dgtlmoon@gmail.com
skype: dgtlmoon
mysql> select * from friendlist_statuses; +-----+--------------+--------------+------+---------+------------+------+------------------+ | sid | requester_id | requestee_id | rtid | status | rid_origin | rid | last_update_time | +-----+--------------+--------------+------+---------+------------+------+------------------+ | 7 | 1 | 5484 | 1 | TW_BOTH | 232 | 232 | 1259898195 | | 8 | 5484 | 1 | 1 | TW_BOTH | 233 | 233 | 1259898195 | +-----+--------------+--------------+------+---------+------------+------+------------------+ 2 rows in set (0.00 sec) mysql> select * from friendlist_relations; +-----+--------------+--------------+------+---------+-------------+---------------------+ | rid | requester_id | requestee_id | rtid | message | create_time | tw_disregarded_time | +-----+--------------+--------------+------+---------+-------------+---------------------+ | 232 | 1 | 5484 | 1 | hi | 1259898117 | 0 | | 233 | 5484 | 1 | 1 | thanks! | 1259898195 | 0 | +-----+--------------+--------------+------+---------+-------------+---------------------+ 2 rows in set (0.00 sec)