From 71f31835a62f903b06d3f97476ec906eb4e9c8ed Mon Sep 17 00:00:00 2001
From: Jules Laplace <jules@okfoc.us>
Date: Mon, 7 Sep 2015 15:07:24 -0400
Subject: listing mail

---
 lib/db/index.js | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'lib/db/index.js')

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)
     }
-- 
cgit v1.2.3-70-g09d2