Lines Matching refs:MailboxColumns
42 import com.android.emailcommon.provider.EmailContent.MailboxColumns;
74 " where " + MailboxColumns.ACCOUNT_KEY + "=old." + EmailContent.RECORD_ID +
225 " begin update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.UNREAD_COUNT +
226 '=' + MailboxColumns.UNREAD_COUNT + "+1" +
233 " begin update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.UNREAD_COUNT +
234 '=' + MailboxColumns.UNREAD_COUNT + "-1" +
242 " begin update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.UNREAD_COUNT +
243 '=' + MailboxColumns.UNREAD_COUNT + "-1" +
245 "; update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.UNREAD_COUNT +
246 '=' + MailboxColumns.UNREAD_COUNT + "+1" +
254 " begin update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.UNREAD_COUNT +
255 '=' + MailboxColumns.UNREAD_COUNT + "+ case OLD." + MessageColumns.FLAG_READ +
265 " begin update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.MESSAGE_COUNT +
266 '=' + MailboxColumns.MESSAGE_COUNT + "+1" +
273 " begin update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.MESSAGE_COUNT +
274 '=' + MailboxColumns.MESSAGE_COUNT + "-1" +
281 " begin update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.MESSAGE_COUNT +
282 '=' + MailboxColumns.MESSAGE_COUNT + "-1" +
284 "; update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.MESSAGE_COUNT +
285 '=' + MailboxColumns.MESSAGE_COUNT + "+1" +
390 + MailboxColumns.DISPLAY_NAME + " text, "
391 + MailboxColumns.SERVER_ID + " text, "
392 + MailboxColumns.PARENT_SERVER_ID + " text, "
393 + MailboxColumns.PARENT_KEY + " integer, "
394 + MailboxColumns.ACCOUNT_KEY + " integer, "
395 + MailboxColumns.TYPE + " integer, "
396 + MailboxColumns.DELIMITER + " integer, "
397 + MailboxColumns.SYNC_KEY + " text, "
398 + MailboxColumns.SYNC_LOOKBACK + " integer, "
399 + MailboxColumns.SYNC_INTERVAL + " integer, "
400 + MailboxColumns.SYNC_TIME + " integer, "
401 + MailboxColumns.UNREAD_COUNT + " integer, "
402 + MailboxColumns.FLAG_VISIBLE + " integer, "
403 + MailboxColumns.FLAGS + " integer, "
404 + MailboxColumns.VISIBLE_LIMIT + " integer, "
405 + MailboxColumns.SYNC_STATUS + " text, "
406 + MailboxColumns.MESSAGE_COUNT + " integer not null default 0, "
407 + MailboxColumns.LAST_TOUCHED_TIME + " integer default 0, "
408 + MailboxColumns.UI_SYNC_STATUS + " integer default 0, "
409 + MailboxColumns.UI_LAST_SYNC_RESULT + " integer default 0, "
410 + MailboxColumns.LAST_NOTIFIED_MESSAGE_KEY + " integer not null default 0, "
411 + MailboxColumns.LAST_NOTIFIED_MESSAGE_COUNT + " integer not null default 0, "
412 + MailboxColumns.TOTAL_COUNT + " integer, "
413 + MailboxColumns.LAST_SEEN_MESSAGE_KEY + " integer"
416 db.execSQL("create index mailbox_" + MailboxColumns.SERVER_ID
417 + " on " + Mailbox.TABLE_NAME + " (" + MailboxColumns.SERVER_ID + ")");
418 db.execSQL("create index mailbox_" + MailboxColumns.ACCOUNT_KEY
419 + " on " + Mailbox.TABLE_NAME + " (" + MailboxColumns.ACCOUNT_KEY + ")");
550 db.execSQL("update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.MESSAGE_COUNT +
907 + " add column " + MailboxColumns.TOTAL_COUNT + " integer;");
985 + MailboxColumns.SERVER_ID + "=" + MailboxColumns.DISPLAY_NAME
987 + Mailbox.TABLE_NAME + "." + MailboxColumns.ID + " IN ( SELECT "
988 + Mailbox.TABLE_NAME + "." + MailboxColumns.ID + " FROM "
992 + Mailbox.TABLE_NAME + "." + MailboxColumns.PARENT_KEY + " isnull OR "
993 + Mailbox.TABLE_NAME + "." + MailboxColumns.PARENT_KEY + "=0 "
995 + Mailbox.TABLE_NAME + "." + MailboxColumns.ACCOUNT_KEY + "="
