diff options
Diffstat (limited to 'lib/db/index.js')
| -rw-r--r-- | lib/db/index.js | 2 |
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) } |