Lines Matching refs:MailboxColumns
46 import com.android.emailcommon.provider.EmailContent.MailboxColumns;
95 " where " + MailboxColumns.ACCOUNT_KEY + "=old." + BaseColumns._ID +
217 " begin update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.MESSAGE_COUNT +
218 '=' + MailboxColumns.MESSAGE_COUNT + "+1" +
225 " begin update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.MESSAGE_COUNT +
226 '=' + MailboxColumns.MESSAGE_COUNT + "-1" +
233 " begin update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.MESSAGE_COUNT +
234 '=' + MailboxColumns.MESSAGE_COUNT + "-1" +
236 "; update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.MESSAGE_COUNT +
237 '=' + MailboxColumns.MESSAGE_COUNT + "+1" +
279 + "(select " + MailboxColumns.TYPE + " from " + Mailbox.TABLE_NAME
280 + " where " + MailboxColumns._ID + "=new."
293 + " and (select " + Mailbox.TABLE_NAME + "." + MailboxColumns.TYPE + " from "
294 + Mailbox.TABLE_NAME + " where " + MailboxColumns._ID + "="
373 " begin update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.UNREAD_COUNT +
374 '=' + MailboxColumns.UNREAD_COUNT + "+1" +
381 " begin update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.UNREAD_COUNT +
382 '=' + MailboxColumns.UNREAD_COUNT + "-1" +
390 " begin update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.UNREAD_COUNT +
391 '=' + MailboxColumns.UNREAD_COUNT + "-1" +
393 "; update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.UNREAD_COUNT +
394 '=' + MailboxColumns.UNREAD_COUNT + "+1" +
402 " begin update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.UNREAD_COUNT +
403 '=' + MailboxColumns.UNREAD_COUNT + "+ case OLD." + MessageColumns.FLAG_READ +
589 String s = " (" + MailboxColumns._ID + " integer primary key autoincrement, "
590 + MailboxColumns.DISPLAY_NAME + " text, "
591 + MailboxColumns.SERVER_ID + " text, "
592 + MailboxColumns.PARENT_SERVER_ID + " text, "
593 + MailboxColumns.PARENT_KEY + " integer, "
594 + MailboxColumns.ACCOUNT_KEY + " integer, "
595 + MailboxColumns.TYPE + " integer, "
596 + MailboxColumns.DELIMITER + " integer, "
597 + MailboxColumns.SYNC_KEY + " text, "
598 + MailboxColumns.SYNC_LOOKBACK + " integer, "
599 + MailboxColumns.SYNC_INTERVAL + " integer, "
600 + MailboxColumns.SYNC_TIME + " integer, "
601 + MailboxColumns.UNREAD_COUNT + " integer, "
602 + MailboxColumns.FLAG_VISIBLE + " integer, "
603 + MailboxColumns.FLAGS + " integer, "
604 + MailboxColumns.VISIBLE_LIMIT + " integer, "
605 + MailboxColumns.SYNC_STATUS + " text, "
606 + MailboxColumns.MESSAGE_COUNT + " integer not null default 0, "
607 + MailboxColumns.LAST_TOUCHED_TIME + " integer default 0, "
608 + MailboxColumns.UI_SYNC_STATUS + " integer default 0, "
609 + MailboxColumns.UI_LAST_SYNC_RESULT + " integer default 0, "
610 + MailboxColumns.LAST_NOTIFIED_MESSAGE_KEY + " integer not null default 0, "
611 + MailboxColumns.LAST_NOTIFIED_MESSAGE_COUNT + " integer not null default 0, "
612 + MailboxColumns.TOTAL_COUNT + " integer, "
613 + MailboxColumns.HIERARCHICAL_NAME + " text, "
614 + MailboxColumns.LAST_FULL_SYNC_TIME + " integer"
617 db.execSQL("create index mailbox_" + MailboxColumns.SERVER_ID
618 + " on " + Mailbox.TABLE_NAME + " (" + MailboxColumns.SERVER_ID + ")");
619 db.execSQL("create index mailbox_" + MailboxColumns.ACCOUNT_KEY
620 + " on " + Mailbox.TABLE_NAME + " (" + MailboxColumns
829 db.execSQL("update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.MESSAGE_COUNT +
832 Mailbox.TABLE_NAME + "." + MailboxColumns._ID + ")");
1157 + " add column " + MailboxColumns.TOTAL_COUNT + " integer;");
1166 MailboxColumns.LAST_TOUCHED_TIME + " = " +
1167 Mailbox.DRAFTS_DEFAULT_TOUCH_TIME + " WHERE " + MailboxColumns.TYPE +
1170 MailboxColumns.LAST_TOUCHED_TIME + " = " +
1171 Mailbox.SENT_DEFAULT_TOUCH_TIME + " WHERE " + MailboxColumns.TYPE +
1182 MailboxColumns.FLAGS + "=" + MailboxColumns.FLAGS + "|" +
1184 MailboxColumns.FLAGS + "&" + Mailbox.FLAG_HOLDS_MAIL + ")!=0 and " +
1185 MailboxColumns.ACCOUNT_KEY + " IN (SELECT " + Account.TABLE_NAME +
1222 + " add " + MailboxColumns.HIERARCHICAL_NAME + " text");
1285 db.execSQL("update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.SYNC_INTERVAL
1287 + MailboxColumns.SYNC_INTERVAL + "<" + Mailbox.CHECK_INTERVAL_PUSH);
1296 db.execSQL("update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.SYNC_LOOKBACK
1298 + MailboxColumns.SYNC_LOOKBACK + " is null or "
1299 + MailboxColumns.SYNC_LOOKBACK + "<" + SyncWindow.SYNC_WINDOW_1_DAY + " or "
1300 + MailboxColumns.SYNC_LOOKBACK + ">" + SyncWindow.SYNC_WINDOW_ALL);
1304 db.execSQL("delete from " + Mailbox.TABLE_NAME + " where " + MailboxColumns.TYPE
1311 db.execSQL("update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.SYNC_INTERVAL
1312 + "=case when " + MailboxColumns.SYNC_INTERVAL + "="
1327 + " add column " + MailboxColumns.LAST_FULL_SYNC_TIME +" integer" + ";");
1329 cv.put(MailboxColumns.LAST_FULL_SYNC_TIME, 0);
1367 db.execSQL("update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.SYNC_INTERVAL
1368 + "=0 where " + MailboxColumns.ACCOUNT_KEY + " in (select "
1393 db.execSQL("update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.SYNC_INTERVAL
1394 + "=0 where " + MailboxColumns.TYPE + "=" + Mailbox.TYPE_DRAFTS);
1400 + MailboxColumns._ID + " from " + Mailbox.TABLE_NAME + " where "
1401 + MailboxColumns.TYPE + "=" + Mailbox.TYPE_DRAFTS + ")");
1529 + MailboxColumns.SERVER_ID + "=" + MailboxColumns.DISPLAY_NAME
1531 + Mailbox.TABLE_NAME + "." + MailboxColumns._ID + " IN ( SELECT "
1532 + Mailbox.TABLE_NAME + "." + MailboxColumns._ID + " FROM "
1536 + Mailbox.TABLE_NAME + "." + MailboxColumns.PARENT_KEY + " isnull OR "
1537 + Mailbox.TABLE_NAME + "." + MailboxColumns.PARENT_KEY + "=0 "
1539 + Mailbox.TABLE_NAME + "." + MailboxColumns.ACCOUNT_KEY + "="
1869 MailboxColumns.LAST_TOUCHED_TIME + " = " +
1870 Mailbox.DRAFTS_DEFAULT_TOUCH_TIME + " WHERE " + MailboxColumns.TYPE +
1873 MailboxColumns.LAST_TOUCHED_TIME + " = " +
1874 Mailbox.SENT_DEFAULT_TOUCH_TIME + " WHERE " + MailboxColumns.TYPE +
1883 MailboxColumns.FLAGS + "=" + MailboxColumns.FLAGS + "|" +
1885 MailboxColumns.FLAGS + "&" + Mailbox.FLAG_HOLDS_MAIL + ")!=0 and " +
1886 MailboxColumns.ACCOUNT_KEY + " IN (SELECT " + Account.TABLE_NAME +