Lines Matching refs:_ID
79 private static final String WHERE_ID = BaseColumns._ID + "=?";
85 " where " + MessageColumns.MAILBOX_KEY + "=old." + BaseColumns._ID +
87 " where " + MessageColumns.MAILBOX_KEY + "=old." + BaseColumns._ID +
89 " where " + MessageColumns.MAILBOX_KEY + "=old." + BaseColumns._ID +
95 " where " + MailboxColumns.ACCOUNT_KEY + "=old." + BaseColumns._ID +
97 " where " + BaseColumns._ID + "=old." + AccountColumns.HOST_AUTH_KEY_RECV +
99 " where " + BaseColumns._ID + "=old." + AccountColumns.HOST_AUTH_KEY_SEND +
101 " where " + BaseColumns._ID + "=old." + AccountColumns.POLICY_KEY +
107 " where " + Credential._ID + "=old." + HostAuthColumns.CREDENTIAL_KEY +
219 " where " + BaseColumns._ID + "=NEW." + MessageColumns.MAILBOX_KEY +
227 " where " + BaseColumns._ID + "=OLD." + MessageColumns.MAILBOX_KEY +
235 " where " + BaseColumns._ID + "=OLD." + MessageColumns.MAILBOX_KEY +
238 " where " + BaseColumns._ID + "=NEW." + MessageColumns.MAILBOX_KEY +
243 String s = " (" + Credential._ID + " integer primary key autoincrement, "
267 * (select type from Mailbox where _id=new.mailboxKey) != 8 and
269 * new.accountKey=account._id and account.hostAuthKeyRecv=hostAuth._id) = 'gEas'
272 * (select Mailbox.type from Mailbox where _id=mailboxKey) != 8; end
280 + " where " + MailboxColumns._ID + "=new."
286 + "=" + Account.TABLE_NAME + "." + AccountColumns._ID
288 + "=" + HostAuth.TABLE_NAME + "." + HostAuthColumns._ID
294 + Mailbox.TABLE_NAME + " where " + MailboxColumns._ID + "="
327 String createString = " (" + BaseColumns._ID + " integer primary key autoincrement, "
335 String altCreateString = " (" + BaseColumns._ID + " integer unique, "
362 " where " + AttachmentColumns.MESSAGE_KEY + "=old." + BaseColumns._ID +
375 " where " + BaseColumns._ID + "=NEW." + MessageColumns.MAILBOX_KEY +
383 " where " + BaseColumns._ID + "=OLD." + MessageColumns.MAILBOX_KEY +
392 " where " + BaseColumns._ID + "=OLD." + MessageColumns.MAILBOX_KEY +
395 " where " + BaseColumns._ID + "=NEW." + MessageColumns.MAILBOX_KEY +
405 " where " + BaseColumns._ID + "=OLD." + MessageColumns.MAILBOX_KEY +
455 + " where " + MessageChangeLogTable.MESSAGE_KEY + "=old." + MessageColumns._ID
461 + " where " + MessageChangeLogTable.ACCOUNT_KEY + "=old." + AccountColumns._ID
499 String s = " (" + AccountColumns._ID + " integer primary key autoincrement, "
535 String s = " (" + PolicyColumns._ID + " integer primary key autoincrement, "
563 String s = " (" + HostAuthColumns._ID + " integer primary key autoincrement, "
589 String s = " (" + MailboxColumns._ID + " integer primary key autoincrement, "
634 String s = " (" + AttachmentColumns._ID + " integer primary key autoincrement, "
665 String s = " (" + QuickResponseColumns._ID + " integer primary key autoincrement, "
674 String s = " (" + BodyColumns._ID + " integer primary key autoincrement, "
832 Mailbox.TABLE_NAME + "." + MailboxColumns._ID + ")");
1004 " where " + Message.TABLE_NAME + "." + MessageColumns._ID + " = " +
1186 "." + AccountColumns._ID + " from " + Account.TABLE_NAME + "," +
1189 HostAuthColumns._ID + " and " + HostAuthColumns.PROTOCOL + "='" +
1369 + Account.TABLE_NAME + "." + AccountColumns._ID + " from "
1371 + HostAuth.TABLE_NAME + "." + HostAuthColumns._ID + "="
1400 + MailboxColumns._ID + " from " + Mailbox.TABLE_NAME + " where "
1493 new String[] {BaseColumns._ID /*0*/, AccountColumns.SECURITY_FLAGS /*1*/},
1504 args[0] = Long.toString(c.getLong(0 /*_ID*/));
1505 db.update(Account.TABLE_NAME, cv, BaseColumns._ID + "=?", args);
1520 //sqlite> UPDATE mailbox SET serverid=displayname WHERE mailbox._id in (
1521 // ...> SELECT mailbox._id FROM mailbox,account,hostauth WHERE
1523 // ...> mailbox.accountkey=account._id AND
1524 // ...> account.hostauthkeyrecv=hostauth._id AND
1531 + Mailbox.TABLE_NAME + "." + MailboxColumns._ID + " IN ( SELECT "
1532 + Mailbox.TABLE_NAME + "." + MailboxColumns._ID + " FROM "
1540 + Account.TABLE_NAME + "." + AccountColumns._ID + " AND "
1542 + HostAuth.TABLE_NAME + "." + HostAuthColumns._ID + " AND ( "
1621 V21_HOSTAUTH_PROJECTION, HostAuthColumns._ID + "=?", hostAuthArgs,
1698 new String[] {AccountColumns._ID, AccountColumns.FLAGS, AccountColumns.HOST_AUTH_KEY_RECV};
1719 V25_HOSTAUTH_PROJECTION, HostAuthColumns._ID + "=?", hostAuthArgs,
1729 db.update(Account.TABLE_NAME, cv, AccountColumns._ID + "=?",
1826 // UPDATE Account SET flags=flags|[new flags] WHERE _id IN (SELECT t1._id FROM Account
1827 // t1 INNER JOIN HostAuth t2 ON t1.hostAuthKeyRecv=t2._id WHERE t2.protocol='gEas' AND
1832 AccountColumns._ID + " IN (SELECT t1." + AccountColumns._ID + " FROM " +
1834 " t2 ON t1." + AccountColumns.HOST_AUTH_KEY_RECV + "=t2._id WHERE t2." +
1887 "." + AccountColumns._ID + " from " + Account.TABLE_NAME + "," +
1890 HostAuthColumns._ID + " and " + HostAuthColumns.PROTOCOL + "='" +
