listing mail

1 files changed, 1 insertions, 1 deletions

diff --git a/lib/db/index.js b/lib/db/index.js
index ab4cdcf..b6fa235 100644
--- a/lib/db/index.js
+++ b/lib/db/index.js
@@ -138,7 +138,7 @@ db.getMailboxCounts = function(boxes){
 db.getMessages = function(username, box, limit, offset){
   var mbox = username + "." + box
   return Message.query(function(qb){
-    qb.column('id', 'mbox', 'unread', 'sender', 'recipient', 'date', 'subject').where("mbox", "=", mbox).orderBy("id", "desc")
+    qb.column('id', 'mbox', 'unread', 'sender', 'recipient', 'date', 'subject', knex.raw("CHAR_LENGTH(body) as size")).where("mbox", "=", mbox).orderBy("id", "desc")
     if (limit) {
       qb.limit(limit)
     }