Lines Matching defs:RAW_CONTACTS
113 public static final String RAW_CONTACTS = "raw_contacts";
141 RAW_CONTACTS,
190 + " INNER JOIN " + Tables.RAW_CONTACTS
260 public static final String RAW_CONTACTS = "view_raw_contacts";
296 " FROM " + Tables.RAW_CONTACTS + " AS " + OUTER_RAW_CONTACTS +
336 Tables.RAW_CONTACTS + "." + BaseColumns._ID;
338 Tables.RAW_CONTACTS + "." + RawContacts.ACCOUNT_NAME;
340 Tables.RAW_CONTACTS + "." + RawContacts.ACCOUNT_TYPE;
342 Tables.RAW_CONTACTS + "." + RawContacts.DATA_SET;
344 Tables.RAW_CONTACTS + "." + RawContacts.ACCOUNT_TYPE_AND_DATA_SET;
346 Tables.RAW_CONTACTS + "." + RawContacts.SOURCE_ID;
348 Tables.RAW_CONTACTS + "." + RawContacts.VERSION;
350 Tables.RAW_CONTACTS + "." + RawContacts.DIRTY;
352 Tables.RAW_CONTACTS + "." + RawContacts.DELETED;
354 Tables.RAW_CONTACTS + "." + RawContacts.SYNC1;
356 Tables.RAW_CONTACTS + "." + RawContacts.SYNC2;
358 Tables.RAW_CONTACTS + "." + RawContacts.SYNC3;
360 Tables.RAW_CONTACTS + "." + RawContacts.SYNC4;
362 Tables.RAW_CONTACTS + "." + RawContacts.CUSTOM_RINGTONE;
364 Tables.RAW_CONTACTS + "." + RawContacts.SEND_TO_VOICEMAIL;
366 Tables.RAW_CONTACTS + "." + RawContacts.LAST_TIME_CONTACTED;
368 Tables.RAW_CONTACTS + "." + RawContacts.TIMES_CONTACTED;
370 Tables.RAW_CONTACTS + "." + RawContacts.STARRED;
377 Tables.RAW_CONTACTS + "." + DISPLAY_NAME;
379 Tables.RAW_CONTACTS + "." + RawContacts.CONTACT_ID;
381 Tables.RAW_CONTACTS + "." + RawContacts.NAME_VERIFIED;
892 db.execSQL("CREATE TABLE " + Tables.RAW_CONTACTS + " (" +
928 db.execSQL("CREATE INDEX raw_contacts_contact_id_index ON " + Tables.RAW_CONTACTS + " (" +
932 db.execSQL("CREATE INDEX raw_contacts_source_id_index ON " + Tables.RAW_CONTACTS + " (" +
939 Tables.RAW_CONTACTS + " (" +
960 Tables.RAW_CONTACTS + "(" + RawContacts._ID + "));");
981 // db.execSQL("CREATE INDEX raw_contacts_agg_index ON " + Tables.RAW_CONTACTS + " (" +
1345 db.execSQL("DROP TRIGGER IF EXISTS " + Tables.RAW_CONTACTS + "_deleted;");
1346 db.execSQL("CREATE TRIGGER " + Tables.RAW_CONTACTS + "_deleted "
1347 + " BEFORE DELETE ON " + Tables.RAW_CONTACTS
1359 + " AND (SELECT COUNT(*) FROM " + Tables.RAW_CONTACTS
1364 + " AND (SELECT COUNT(*) FROM " + Tables.RAW_CONTACTS
1369 + " AND (SELECT COUNT(*) FROM " + Tables.RAW_CONTACTS
1383 db.execSQL("DROP TRIGGER IF EXISTS " + Tables.RAW_CONTACTS + "_marked_deleted;");
1384 db.execSQL("CREATE TRIGGER " + Tables.RAW_CONTACTS + "_marked_deleted "
1385 + " AFTER UPDATE ON " + Tables.RAW_CONTACTS
1387 + " UPDATE " + Tables.RAW_CONTACTS
1400 + " UPDATE " + Tables.RAW_CONTACTS
1408 + " UPDATE " + Tables.RAW_CONTACTS
1435 " FROM " + Tables.RAW_CONTACTS +
1441 " FROM " + Tables.RAW_CONTACTS +
1453 " FROM " + Tables.RAW_CONTACTS +
1491 db.execSQL("CREATE INDEX raw_contact_sort_key1_index ON " + Tables.RAW_CONTACTS + " (" +
1496 db.execSQL("CREATE INDEX raw_contact_sort_key2_index ON " + Tables.RAW_CONTACTS + " (" +
1504 db.execSQL("DROP VIEW IF EXISTS " + Views.RAW_CONTACTS + ";");
1614 + " JOIN " + Tables.RAW_CONTACTS + " ON ("
1618 + " JOIN " + Tables.RAW_CONTACTS + " AS name_raw_contact ON("
1652 + " FROM " + Tables.RAW_CONTACTS;
1654 db.execSQL("CREATE VIEW " + Views.RAW_CONTACTS + " AS " + rawContactsSelect);
1678 + " JOIN " + Tables.RAW_CONTACTS + " AS name_raw_contact ON("
1697 + " FROM " + Tables.RAW_CONTACTS
1731 + " FROM " + Tables.RAW_CONTACTS
1734 + " JOIN " + Tables.RAW_CONTACTS + " AS name_raw_contact ON("
1761 + " JOIN " + Tables.RAW_CONTACTS + " ON ("
1792 + " JOIN " + Tables.RAW_CONTACTS + " ON ("
1875 db.execSQL("DROP TABLE IF EXISTS " + Tables.RAW_CONTACTS + ";");
2387 "ALTER TABLE " + Tables.RAW_CONTACTS +
2395 " FROM " + Tables.RAW_CONTACTS +
2413 " FROM " + Tables.RAW_CONTACTS +
2429 "UPDATE " + Tables.RAW_CONTACTS +
2437 db.execSQL("CREATE INDEX raw_contact_sort_key1_index ON " + Tables.RAW_CONTACTS + " (" +
2449 db.execSQL("ALTER TABLE " + Tables.RAW_CONTACTS
2451 db.execSQL("ALTER TABLE " + Tables.RAW_CONTACTS
2453 db.execSQL("ALTER TABLE " + Tables.RAW_CONTACTS
2455 db.execSQL("ALTER TABLE " + Tables.RAW_CONTACTS
2458 db.execSQL("ALTER TABLE " + Tables.RAW_CONTACTS
2467 "UPDATE " + Tables.RAW_CONTACTS +
2481 db.execSQL("CREATE INDEX raw_contact_sort_key1_index ON " + Tables.RAW_CONTACTS + " (" +
2486 db.execSQL("CREATE INDEX raw_contact_sort_key2_index ON " + Tables.RAW_CONTACTS + " (" +
2702 db.execSQL("ALTER TABLE " + Tables.RAW_CONTACTS
2927 Cursor cursor = db.query(Tables.RAW_CONTACTS, new String[]{RawContacts._ID},
3604 updateIndexStats(db, Tables.RAW_CONTACTS,
3606 updateIndexStats(db, Tables.RAW_CONTACTS,
3608 updateIndexStats(db, Tables.RAW_CONTACTS,
3610 updateIndexStats(db, Tables.RAW_CONTACTS,
3612 updateIndexStats(db, Tables.RAW_CONTACTS,
3755 db.execSQL("DELETE FROM " + Tables.RAW_CONTACTS + ";");
4007 " FROM " + Tables.RAW_CONTACTS +
4015 " FROM " + Tables.RAW_CONTACTS +
4032 " FROM " + Tables.RAW_CONTACTS +
4108 " FROM " + Tables.RAW_CONTACTS +
4124 " FROM " + Tables.RAW_CONTACTS +
4196 sb.append(Tables.RAW_CONTACTS);
4331 + Tables.RAW_CONTACTS + " WHERE " + RawContacts._ID + "=" + rawContactId + ")";
4335 + Tables.RAW_CONTACTS + " contacts1 JOIN " + Tables.RAW_CONTACTS + " contacts2 ON ("
4553 "UPDATE " + Tables.RAW_CONTACTS +
4557 " FROM " + Tables.RAW_CONTACTS +
4768 "UPDATE " + Tables.RAW_CONTACTS +
4843 " FROM " + Tables.RAW_CONTACTS +
4846 " FROM " + Tables.RAW_CONTACTS +