Miscellany

archiveopteryx=# select * from part_numbers ;
 mailbox | uid | part | bodypart | bytes | lines 
---------+-----+------+----------+-------+-------
       1 |   1 |      |          |       |      
       1 |   1 | 1    |        1 |     6 |     1
       1 |   2 |      |          |       |      
       1 |   2 | 1    |        1 |     6 |     1
       1 |   3 |      |          |       |      
       1 |   3 | 1    |        1 |     6 |     1
       3 |   1 |      |          |       |      
       3 |   1 | 1    |        4 |     7 |     1


archiveopteryx=# select * from mailboxes;
 id |                    name                     | owner | uidnext | nextmodseq | first_recent | uidvalidity | deleted 
----+---------------------------------------------+-------+---------+------------+--------------+-------------+---------
  2 | /archiveopteryx/spool                       |       |       1 |          1 |            1 |           1 | f
  1 | /users/postmaster@ceres.netsyncro.com/INBOX |     1 |       4 |          8 |            4 |           1 | f
  3 | /users/bla@ceres.netsyncro.com/INBOX        |     2 |       2 |          2 |            1 |           1 | f
(3 rows)


archiveopteryx=# select * from bodypart 
bodypart_ids  bodyparts     
archiveopteryx=# select * from bodyparts;
 id | bytes |               hash               |  text   | data 
----+-------+----------------------------------+---------+------
  1 |     6 | 9f06243abcb89c70e0c331c61d871fa7 | test\r  | 
                                               :           
  4 |     7 | 34dec65d5cd38c7ac187e5051a78e569 | te2st\r | 
                                               :           
(2 rows)




archiveopteryx=# select * from aliases;
 id | address | mailbox 
----+---------+---------
  1 |       1 |       1
  2 |       3 |       3
(2 rows)



archiveopteryx=> select * from messages;
 mailbox | uid |   idate    | rfc822size 
---------+-----+------------+------------
       1 |   1 | 1196251284 |        518
       1 |   2 | 1196251284 |        518
       1 |   3 | 1196251293 |        518
(3 rows)


archiveopteryx=> select * from addresses;
 id | name | localpart  |       domain        
----+------+------------+---------------------
  1 |      | postmaster | ceres.netsyncro.com
  2 |      | root       | ceres.netsyncro.com
(2 rows)