Lines Matching defs:Tables
149 public interface Tables {
205 + " JOIN " + Tables.ACCOUNTS + " ON ("
211 public static final String RAW_CONTACTS_JOIN_SETTINGS_DATA_GROUPS = Tables.RAW_CONTACTS
212 + " JOIN " + Tables.ACCOUNTS + " ON ("
215 + "LEFT OUTER JOIN " + Tables.SETTINGS + " ON ("
235 + " FROM " + Tables.ACCOUNTS
246 Tables.CONTACTS
247 + " INNER JOIN " + Tables.RAW_CONTACTS
251 + " INNER JOIN " + Tables.DATA
258 + " FROM " + Tables.MIMETYPES
270 + " JOIN " + Tables.ACCOUNTS + " ON ("
293 public static final String RAW_CONTACTS_JOIN_ACCOUNTS = Tables.RAW_CONTACTS
294 + " JOIN " + Tables.ACCOUNTS + " ON ("
298 public static final String RAW_CONTACTS_JOIN_METADATA_SYNC = Tables.RAW_CONTACTS
299 + " JOIN " + Tables.METADATA_SYNC + " ON ("
373 " FROM " + Tables.ACCOUNTS +
397 " FROM " + Tables.RAW_CONTACTS_JOIN_SETTINGS_DATA_GROUPS +
399 " FROM " + Tables.RAW_CONTACTS + " AS " + OUTER_RAW_CONTACTS +
407 "EXISTS (SELECT _id FROM " + Tables.VISIBLE_CONTACTS
408 + " WHERE " + Tables.CONTACTS +"." + Contacts._ID
409 + "=" + Tables.VISIBLE_CONTACTS +"." + Contacts._ID + ")";
412 "EXISTS (SELECT _id FROM " + Tables.DEFAULT_DIRECTORY
413 + " WHERE " + Tables.CONTACTS +"." + Contacts._ID
414 + "=" + Tables.DEFAULT_DIRECTORY +"." + Contacts._ID + ")";
420 public static final String CONCRETE_ID = Tables.CONTACTS + "." + BaseColumns._ID;
422 public static final String CONCRETE_PHOTO_FILE_ID = Tables.CONTACTS + "."
425 public static final String CONCRETE_RAW_TIMES_CONTACTED = Tables.CONTACTS + "."
427 public static final String CONCRETE_RAW_LAST_TIME_CONTACTED = Tables.CONTACTS + "."
430 public static final String CONCRETE_STARRED = Tables.CONTACTS + "." + Contacts.STARRED;
431 public static final String CONCRETE_PINNED = Tables.CONTACTS + "." + Contacts.PINNED;
432 public static final String CONCRETE_CUSTOM_RINGTONE = Tables.CONTACTS + "."
434 public static final String CONCRETE_SEND_TO_VOICEMAIL = Tables.CONTACTS + "."
436 public static final String CONCRETE_LOOKUP_KEY = Tables.CONTACTS + "."
438 public static final String CONCRETE_CONTACT_LAST_UPDATED_TIMESTAMP = Tables.CONTACTS + "."
448 Tables.RAW_CONTACTS + "." + BaseColumns._ID;
451 public static final String CONCRETE_ACCOUNT_ID = Tables.RAW_CONTACTS + "." + ACCOUNT_ID;
453 Tables.RAW_CONTACTS + "." + RawContacts.SOURCE_ID;
455 Tables.RAW_CONTACTS + "." + RawContacts.BACKUP_ID;
457 Tables.RAW_CONTACTS + "." + RawContacts.VERSION;
459 Tables.RAW_CONTACTS + "." + RawContacts.DIRTY;
461 Tables.RAW_CONTACTS + "." + RawContacts.DELETED;
463 Tables.RAW_CONTACTS + "." + RawContacts.SYNC1;
465 Tables.RAW_CONTACTS + "." + RawContacts.SYNC2;
467 Tables.RAW_CONTACTS + "." + RawContacts.SYNC3;
469 Tables.RAW_CONTACTS + "." + RawContacts.SYNC4;
471 Tables.RAW_CONTACTS + "." + RawContacts.CUSTOM_RINGTONE;
473 Tables.RAW_CONTACTS + "." + RawContacts.SEND_TO_VOICEMAIL;
475 Tables.RAW_CONTACTS + "." + RawContacts.RAW_LAST_TIME_CONTACTED;
477 Tables.RAW_CONTACTS + "." + RawContacts.RAW_TIMES_CONTACTED;
479 Tables.RAW_CONTACTS + "." + RawContacts.STARRED;
481 Tables.RAW_CONTACTS + "." + RawContacts.PINNED;
484 Tables.RAW_CONTACTS + "." + RawContacts.METADATA_DIRTY;
490 Tables.RAW_CONTACTS + "." + DISPLAY_NAME;
492 Tables.RAW_CONTACTS + "." + RawContacts.CONTACT_ID;
520 public static final String CONCRETE_ID = Tables.DATA + "." + BaseColumns._ID;
521 public static final String CONCRETE_MIMETYPE_ID = Tables.DATA + "." + MIMETYPE_ID;
522 public static final String CONCRETE_RAW_CONTACT_ID = Tables.DATA + "."
524 public static final String CONCRETE_GROUP_ID = Tables.DATA + "."
527 public static final String CONCRETE_DATA1 = Tables.DATA + "." + Data.DATA1;
528 public static final String CONCRETE_DATA2 = Tables.DATA + "." + Data.DATA2;
529 public static final String CONCRETE_DATA3 = Tables.DATA + "." + Data.DATA3;
530 public static final String CONCRETE_DATA4 = Tables.DATA + "." + Data.DATA4;
531 public static final String CONCRETE_DATA5 = Tables.DATA + "." + Data.DATA5;
532 public static final String CONCRETE_DATA6 = Tables.DATA + "." + Data.DATA6;
533 public static final String CONCRETE_DATA7 = Tables.DATA + "." + Data.DATA7;
534 public static final String CONCRETE_DATA8 = Tables.DATA + "." + Data.DATA8;
535 public static final String CONCRETE_DATA9 = Tables.DATA + "." + Data.DATA9;
536 public static final String CONCRETE_DATA10 = Tables.DATA + "." + Data.DATA10;
537 public static final String CONCRETE_DATA11 = Tables.DATA + "." + Data.DATA11;
538 public static final String CONCRETE_DATA12 = Tables.DATA + "." + Data.DATA12;
539 public static final String CONCRETE_DATA13 = Tables.DATA + "." + Data.DATA13;
540 public static final String CONCRETE_DATA14 = Tables.DATA + "." + Data.DATA14;
541 public static final String CONCRETE_DATA15 = Tables.DATA + "." + Data.DATA15;
542 public static final String CONCRETE_IS_PRIMARY = Tables.DATA + "." + Data.IS_PRIMARY;
543 public static final String CONCRETE_PACKAGE_ID = Tables.DATA + "." + PACKAGE_ID;
559 public static final String CONCRETE_PACKAGE_ID = Tables.GROUPS + "." + PACKAGE_ID;
561 public static final String CONCRETE_ID = Tables.GROUPS + "." + BaseColumns._ID;
562 public static final String CONCRETE_SOURCE_ID = Tables.GROUPS + "." + Groups.SOURCE_ID;
565 public static final String CONCRETE_ACCOUNT_ID = Tables.GROUPS + "." + ACCOUNT_ID;
598 public static final String CONCRETE_ID = Tables.PACKAGES + "." + _ID;
605 public static final String CONCRETE_ID = Tables.MIMETYPES + "." + BaseColumns._ID;
606 public static final String CONCRETE_MIMETYPE = Tables.MIMETYPES + "." + MIMETYPE;
619 public static final String CONCRETE_ACCOUNT_NAME = Tables.SETTINGS + "."
621 public static final String CONCRETE_ACCOUNT_TYPE = Tables.SETTINGS + "."
623 public static final String CONCRETE_DATA_SET = Tables.SETTINGS + "."
634 String CONCRETE_CONTACT_ID = Tables.AGGREGATED_PRESENCE + "." + CONTACT_ID;
640 String CONCRETE_DATA_ID = Tables.STATUS_UPDATES + "." + DATA_ID;
642 String CONCRETE_PRESENCE = Tables.STATUS_UPDATES + "." + StatusUpdates.PRESENCE;
643 String CONCRETE_STATUS = Tables.STATUS_UPDATES + "." + StatusUpdates.STATUS;
644 String CONCRETE_STATUS_TIMESTAMP = Tables.STATUS_UPDATES + "."
646 String CONCRETE_STATUS_RES_PACKAGE = Tables.STATUS_UPDATES + "."
648 String CONCRETE_STATUS_LABEL = Tables.STATUS_UPDATES + "." + StatusUpdates.STATUS_LABEL;
649 String CONCRETE_STATUS_ICON = Tables.STATUS_UPDATES + "." + StatusUpdates.STATUS_ICON;
653 String ALIAS = "contacts_" + Tables.STATUS_UPDATES;
666 final String CONCRETE_ID = Tables.STREAM_ITEMS + "." + BaseColumns._ID;
668 Tables.STREAM_ITEMS + "." + StreamItems.RAW_CONTACT_ID;
669 final String CONCRETE_PACKAGE = Tables.STREAM_ITEMS + "." + StreamItems.RES_PACKAGE;
670 final String CONCRETE_ICON = Tables.STREAM_ITEMS + "." + StreamItems.RES_ICON;
671 final String CONCRETE_LABEL = Tables.STREAM_ITEMS + "." + StreamItems.RES_LABEL;
672 final String CONCRETE_TEXT = Tables.STREAM_ITEMS + "." + StreamItems.TEXT;
673 final String CONCRETE_TIMESTAMP = Tables.STREAM_ITEMS + "." + StreamItems.TIMESTAMP;
674 final String CONCRETE_COMMENTS = Tables.STREAM_ITEMS + "." + StreamItems.COMMENTS;
675 final String CONCRETE_SYNC1 = Tables.STREAM_ITEMS + "." + StreamItems.SYNC1;
676 final String CONCRETE_SYNC2 = Tables.STREAM_ITEMS + "." + StreamItems.SYNC2;
677 final String CONCRETE_SYNC3 = Tables.STREAM_ITEMS + "." + StreamItems.SYNC3;
678 final String CONCRETE_SYNC4 = Tables.STREAM_ITEMS + "." + StreamItems.SYNC4;
682 final String CONCRETE_ID = Tables.STREAM_ITEM_PHOTOS + "." + BaseColumns._ID;
683 final String CONCRETE_STREAM_ITEM_ID = Tables.STREAM_ITEM_PHOTOS + "."
686 Tables.STREAM_ITEM_PHOTOS + "." + StreamItemPhotos.SORT_INDEX;
687 final String CONCRETE_PHOTO_FILE_ID = Tables.STREAM_ITEM_PHOTOS + "."
689 final String CONCRETE_SYNC1 = Tables.STREAM_ITEM_PHOTOS + "." + StreamItemPhotos.SYNC1;
690 final String CONCRETE_SYNC2 = Tables.STREAM_ITEM_PHOTOS + "." + StreamItemPhotos.SYNC2;
691 final String CONCRETE_SYNC3 = Tables.STREAM_ITEM_PHOTOS + "." + StreamItemPhotos.SYNC3;
692 final String CONCRETE_SYNC4 = Tables.STREAM_ITEM_PHOTOS + "." + StreamItemPhotos.SYNC4;
696 String CONCRETE_ID = Tables.PHOTO_FILES + "." + BaseColumns._ID;
697 String CONCRETE_HEIGHT = Tables.PHOTO_FILES + "." + PhotoFiles.HEIGHT;
698 String CONCRETE_WIDTH = Tables.PHOTO_FILES + "." + PhotoFiles.WIDTH;
699 String CONCRETE_FILESIZE = Tables.PHOTO_FILES + "." + PhotoFiles.FILESIZE;
703 String CONCRETE_ID = Tables.ACCOUNTS + "." + BaseColumns._ID;
709 String CONCRETE_ACCOUNT_NAME = Tables.ACCOUNTS + "." + ACCOUNT_NAME;
710 String CONCRETE_ACCOUNT_TYPE = Tables.ACCOUNTS + "." + ACCOUNT_TYPE;
711 String CONCRETE_DATA_SET = Tables.ACCOUNTS + "." + DATA_SET;
737 public static final String CONCRETE_ID = Tables.DATA_USAGE_STAT + "." + _ID;
741 public static final String CONCRETE_DATA_ID = Tables.DATA_USAGE_STAT + "." + DATA_ID;
752 Tables.DATA_USAGE_STAT + "." + RAW_LAST_TIME_USED;
755 Tables.DATA_USAGE_STAT + "." + RAW_TIMES_USED;
758 Tables.DATA_USAGE_STAT + "." + LR_LAST_TIME_USED;
761 Tables.DATA_USAGE_STAT + "." + LR_TIMES_USED;
766 Tables.DATA_USAGE_STAT + "." + USAGE_TYPE_INT;
779 static final String CONCRETE_ID = Tables.METADATA_SYNC + "._id";
781 static final String CONCRETE_BACKUP_ID = Tables.METADATA_SYNC + "." +
783 static final String CONCRETE_ACCOUNT_ID = Tables.METADATA_SYNC + "." + ACCOUNT_ID;
784 static final String CONCRETE_DELETED = Tables.METADATA_SYNC + "." +
789 static final String CONCRETE_ID = Tables.METADATA_SYNC_STATE + "._id";
791 static final String CONCRETE_ACCOUNT_ID = Tables.METADATA_SYNC_STATE + "." + ACCOUNT_ID;
795 public static final String TABLE = Tables.DATA;
811 public static final String TABLE = Tables.DATA;
828 public static final String TABLE = Tables.DATA;
859 " FROM " + Tables.DATA +
1110 db.execSQL("DELETE FROM " + Tables.PRESENCE + ";");
1111 db.execSQL("DELETE FROM " + Tables.AGGREGATED_PRESENCE + ";");
1149 db.execSQL("CREATE TABLE IF NOT EXISTS " + Tables.PRESENCE + " ("+
1164 + Tables.PRESENCE + " (" + PresenceColumns.RAW_CONTACT_ID + ");");
1166 + Tables.PRESENCE + " (" + PresenceColumns.CONTACT_ID + ");");
1169 + Tables.AGGREGATED_PRESENCE + " ("+
1176 db.execSQL("CREATE TRIGGER IF NOT EXISTS " + Tables.PRESENCE + "_deleted"
1177 + " BEFORE DELETE ON " + Tables.PRESENCE
1179 + " DELETE FROM " + Tables.AGGREGATED_PRESENCE
1182 " FROM " + Tables.PRESENCE +
1187 " FROM " + Tables.PRESENCE +
1195 "INSERT OR REPLACE INTO " + Tables.AGGREGATED_PRESENCE + "("
1203 + " FROM " + Tables.PRESENCE
1210 + " FROM " + Tables.PRESENCE
1216 db.execSQL("CREATE TRIGGER IF NOT EXISTS " + Tables.PRESENCE + "_inserted"
1217 + " AFTER INSERT ON " + Tables.PRESENCE
1222 db.execSQL("CREATE TRIGGER IF NOT EXISTS " + Tables.PRESENCE + "_updated"
1223 + " AFTER UPDATE ON " + Tables.PRESENCE
1241 db.execSQL("CREATE TABLE " + Tables.ACCOUNTS + " (" +
1263 db.execSQL("CREATE TABLE " + Tables.CONTACTS + " (" +
1291 db.execSQL("CREATE TABLE " + Tables.RAW_CONTACTS + " (" +
1294 Tables.ACCOUNTS + "(" + AccountsColumns._ID + ")," +
1341 db.execSQL("CREATE INDEX raw_contacts_contact_id_index ON " + Tables.RAW_CONTACTS + " (" +
1346 Tables.RAW_CONTACTS + " (" +
1352 Tables.RAW_CONTACTS + " (" +
1357 db.execSQL("CREATE TABLE " + Tables.STREAM_ITEMS + " (" +
1371 Tables.RAW_CONTACTS + "(" + RawContacts._ID + "));");
1373 db.execSQL("CREATE TABLE " + Tables.STREAM_ITEM_PHOTOS + " (" +
1383 Tables.STREAM_ITEMS + "(" + StreamItems._ID + "));");
1385 db.execSQL("CREATE TABLE " + Tables.PHOTO_FILES + " (" +
1392 // db.execSQL("CREATE INDEX raw_contacts_agg_index ON " + Tables.RAW_CONTACTS + " (" +
1397 db.execSQL("CREATE TABLE " + Tables.PACKAGES + " (" +
1403 db.execSQL("CREATE TABLE " + Tables.MIMETYPES + " (" +
1409 db.execSQL("CREATE UNIQUE INDEX mime_type ON " + Tables.MIMETYPES + " (" +
1414 db.execSQL("CREATE TABLE " + Tables.DATA + " (" +
1446 db.execSQL("CREATE INDEX data_raw_contact_id ON " + Tables.DATA + " (" +
1453 db.execSQL("CREATE INDEX data_mimetype_data1_index ON " + Tables.DATA + " (" +
1461 db.execSQL("CREATE INDEX IF NOT EXISTS data_hash_id_index ON " + Tables.DATA + " (" +
1467 db.execSQL("CREATE TABLE " + Tables.PHONE_LOOKUP + " (" +
1476 db.execSQL("CREATE INDEX phone_lookup_index ON " + Tables.PHONE_LOOKUP + " (" +
1482 db.execSQL("CREATE INDEX phone_lookup_min_match_index ON " + Tables.PHONE_LOOKUP + " (" +
1488 db.execSQL("CREATE INDEX phone_lookup_data_id_min_match_index ON " + Tables.PHONE_LOOKUP +
1492 db.execSQL("CREATE TABLE " + Tables.NAME_LOOKUP + " (" +
1505 db.execSQL("CREATE INDEX name_lookup_raw_contact_id_index ON " + Tables.NAME_LOOKUP + " (" +
1509 db.execSQL("CREATE TABLE " + Tables.NICKNAME_LOOKUP + " (" +
1514 db.execSQL("CREATE UNIQUE INDEX nickname_lookup_index ON " + Tables.NICKNAME_LOOKUP + " (" +
1520 db.execSQL("CREATE TABLE " + Tables.GROUPS + " (" +
1524 Tables.ACCOUNTS + "(" + AccountsColumns._ID + ")," +
1544 db.execSQL("CREATE INDEX groups_source_id_account_id_index ON " + Tables.GROUPS + " (" +
1549 db.execSQL("CREATE TABLE IF NOT EXISTS " + Tables.AGGREGATION_EXCEPTIONS + " (" +
1559 Tables.AGGREGATION_EXCEPTIONS + " (" +
1565 Tables.AGGREGATION_EXCEPTIONS + " (" +
1570 db.execSQL("CREATE TABLE IF NOT EXISTS " + Tables.SETTINGS + " (" +
1578 db.execSQL("CREATE TABLE " + Tables.VISIBLE_CONTACTS + " (" +
1582 db.execSQL("CREATE TABLE " + Tables.DEFAULT_DIRECTORY + " (" +
1586 db.execSQL("CREATE TABLE " + Tables.STATUS_UPDATES + " (" +
1598 db.execSQL("CREATE TABLE " + Tables.DATA_USAGE_STAT + "(" +
1610 + Tables.DATA + "(" + Data._ID + ")" +
1613 Tables.DATA_USAGE_STAT + " (" +
1619 + Tables.METADATA_SYNC + " (" +
1627 Tables.METADATA_SYNC + " (" +
1631 db.execSQL("CREATE TABLE " + Tables.PRE_AUTHORIZED_URIS + " ("+
1637 + Tables.METADATA_SYNC_STATE + " (" +
1643 Tables.METADATA_SYNC_STATE + " (" +
1692 db.execSQL("CREATE TABLE " + Tables.DIRECTORIES + "(" +
1716 db.execSQL("DROP TABLE IF EXISTS " + Tables.SEARCH_INDEX);
1717 db.execSQL("CREATE VIRTUAL TABLE " + Tables.SEARCH_INDEX
1736 db.execSQL("DROP TRIGGER IF EXISTS " + Tables.RAW_CONTACTS + "_deleted;");
1737 db.execSQL("CREATE TRIGGER " + Tables.RAW_CONTACTS + "_deleted "
1738 + " BEFORE DELETE ON " + Tables.RAW_CONTACTS
1740 + " DELETE FROM " + Tables.DATA
1743 + " DELETE FROM " + Tables.AGGREGATION_EXCEPTIONS
1748 + " DELETE FROM " + Tables.VISIBLE_CONTACTS
1750 + " AND (SELECT COUNT(*) FROM " + Tables.RAW_CONTACTS
1753 + " DELETE FROM " + Tables.DEFAULT_DIRECTORY
1755 + " AND (SELECT COUNT(*) FROM " + Tables.RAW_CONTACTS
1758 + " DELETE FROM " + Tables.CONTACTS
1760 + " AND (SELECT COUNT(*) FROM " + Tables.RAW_CONTACTS
1771 db.execSQL("DROP TRIGGER IF EXISTS " + Tables.RAW_CONTACTS + "_marked_deleted;");
1772 db.execSQL("CREATE TRIGGER " + Tables.RAW_CONTACTS + "_marked_deleted "
1773 + " AFTER UPDATE ON " + Tables.RAW_CONTACTS
1775 + " UPDATE " + Tables.RAW_CONTACTS
1782 db.execSQL("DROP TRIGGER IF EXISTS " + Tables.DATA + "_updated;");
1783 db.execSQL("CREATE TRIGGER " + Tables.DATA + "_updated AFTER UPDATE ON " + Tables.DATA
1785 + " UPDATE " + Tables.DATA
1788 + " UPDATE " + Tables.RAW_CONTACTS
1793 db.execSQL("DROP TRIGGER IF EXISTS " + Tables.DATA + "_deleted;");
1794 db.execSQL("CREATE TRIGGER " + Tables.DATA + "_deleted BEFORE DELETE ON " + Tables.DATA
1796 + " UPDATE " + Tables.RAW_CONTACTS
1799 + " DELETE FROM " + Tables.PHONE_LOOKUP
1801 + " DELETE FROM " + Tables.STATUS_UPDATES
1803 + " DELETE FROM " + Tables.NAME_LOOKUP
1808 db.execSQL("DROP TRIGGER IF EXISTS " + Tables.GROUPS + "_updated1;");
1809 db.execSQL("CREATE TRIGGER " + Tables.GROUPS + "_updated1 "
1810 + " AFTER UPDATE ON " + Tables.GROUPS
1812 + " UPDATE " + Tables.GROUPS
1820 " INSERT OR IGNORE INTO " + Tables.DEFAULT_DIRECTORY +
1822 " FROM " + Tables.RAW_CONTACTS +
1827 " INSERT OR IGNORE INTO " + Tables.DEFAULT_DIRECTORY +
1829 " FROM " + Tables.RAW_CONTACTS +
1832 " FROM " + Tables.GROUPS +
1838 " INSERT OR IGNORE INTO " + Tables.DEFAULT_DIRECTORY +
1840 " FROM " + Tables.RAW_CONTACTS +
1841 " JOIN " + Tables.DATA +
1845 "(SELECT " + MimetypesColumns._ID + " FROM " + Tables.MIMETYPES +
1850 " FROM " + Tables.GROUPS +
1855 db.execSQL("DROP TRIGGER IF EXISTS " + Tables.GROUPS + "_auto_add_updated1;");
1856 db.execSQL("CREATE TRIGGER " + Tables.GROUPS + "_auto_add_updated1 "
1857 + " AFTER UPDATE OF " + Groups.AUTO_ADD + " ON " + Tables.GROUPS
1859 + " DELETE FROM " + Tables.DEFAULT_DIRECTORY + ";"
1868 db.execSQL("CREATE INDEX name_lookup_index ON " + Tables.NAME_LOOKUP + " (" +
1876 db.execSQL("CREATE INDEX raw_contact_sort_key1_index ON " + Tables.RAW_CONTACTS + " (" +
1881 db.execSQL("CREATE INDEX raw_contact_sort_key2_index ON " + Tables.RAW_CONTACTS + " (" +
2024 + Tables.GROUPS + "." + Groups.SOURCE_ID + " AS " + GroupMembership.GROUP_SOURCE_ID
2025 + " FROM " + Tables.DATA
2026 + " JOIN " + Tables.MIMETYPES + " ON ("
2028 + " JOIN " + Tables.RAW_CONTACTS + " ON ("
2030 + " JOIN " + Tables.ACCOUNTS + " ON ("
2033 + " JOIN " + Tables.CONTACTS + " ON ("
2035 + " JOIN " + Tables.RAW_CONTACTS + " AS name_raw_contact ON("
2037 + " LEFT OUTER JOIN " + Tables.PACKAGES + " ON ("
2039 + " LEFT OUTER JOIN " + Tables.GROUPS + " ON ("
2042 + Tables.DATA + "." + GroupMembership.GROUP_ROW_ID + ")";
2079 + " FROM " + Tables.RAW_CONTACTS
2080 + " JOIN " + Tables.ACCOUNTS + " ON ("
2116 + " FROM " + Tables.CONTACTS
2117 + " JOIN " + Tables.RAW_CONTACTS + " AS name_raw_contact ON("
2136 + Tables.GROUPS + "." + Groups.SOURCE_ID + " AS " + GroupMembership.GROUP_SOURCE_ID
2137 + " FROM " + Tables.RAW_CONTACTS
2138 + " JOIN " + Tables.ACCOUNTS + " ON ("
2141 + " LEFT OUTER JOIN " + Tables.DATA + " ON ("
2143 + " LEFT OUTER JOIN " + Tables.PACKAGES + " ON ("
2145 + " LEFT OUTER JOIN " + Tables.MIMETYPES + " ON ("
2147 + " LEFT OUTER JOIN " + Tables.GROUPS + " ON ("
2150 + Tables.DATA + "." + GroupMembership.GROUP_ROW_ID + ")";
2174 + Tables.GROUPS + "." + Groups.SOURCE_ID + " AS " + GroupMembership.GROUP_SOURCE_ID
2175 + " FROM " + Tables.RAW_CONTACTS
2176 + " JOIN " + Tables.ACCOUNTS + " ON ("
2179 + " JOIN " + Tables.CONTACTS + " ON ("
2181 + " JOIN " + Tables.RAW_CONTACTS + " AS name_raw_contact ON("
2183 + " LEFT OUTER JOIN " + Tables.DATA + " ON ("
2185 + " LEFT OUTER JOIN " + Tables.PACKAGES + " ON ("
2187 + " LEFT OUTER JOIN " + Tables.MIMETYPES + " ON ("
2189 + " LEFT OUTER JOIN " + Tables.GROUPS + " ON ("
2192 + Tables.DATA + "." + GroupMembership.GROUP_ROW_ID + ")";
2208 + " FROM " + Tables.DATA_USAGE_STAT;
2224 + " FROM " + Views.DATA_USAGE_LR + " AS " + Tables.DATA_USAGE_STAT
2225 + " JOIN " + Tables.DATA + " ON ("
2227 + " JOIN " + Tables.RAW_CONTACTS + " ON ("
2230 + " JOIN " + Tables.MIMETYPES + " ON ("
2257 " FROM " + Tables.STREAM_ITEMS
2258 + " JOIN " + Tables.RAW_CONTACTS + " ON ("
2261 + " JOIN " + Tables.ACCOUNTS + " ON ("
2264 + " JOIN " + Tables.CONTACTS + " ON ("
2277 " FROM " + Tables.METADATA_SYNC
2278 + " JOIN " + Tables.ACCOUNTS + " ON ("
2290 " FROM " + Tables.METADATA_SYNC_STATE
2291 + " JOIN " + Tables.ACCOUNTS + " ON ("
2365 + " FROM " + Tables.GROUPS
2366 + " JOIN " + Tables.ACCOUNTS + " ON ("
2368 + " LEFT OUTER JOIN " + Tables.PACKAGES + " ON ("
2814 Cursor cursor = db.query(Tables.RAW_CONTACTS, new String[] {RawContacts._ID},
2827 db.execSQL("DELETE FROM " + Tables.NAME_LOOKUP);
2830 "INSERT OR IGNORE INTO " + Tables.NAME_LOOKUP + "("
2915 * Inserts a record in the {@link Tables#NAME_LOOKUP} table.
3302 "UPDATE " + Tables.DATA +
3306 final Cursor c = db.query(Tables.DATA,
3388 db.update(Tables.DATA, values, DataColumns.MIMETYPE_ID + " = " + mimeTypeId, null);
3516 * Inserts a new mimetype into the table Tables.MIMETYPES and returns its id. Use
3525 final String insert = "INSERT INTO " + Tables.MIMETYPES + "("
3536 * Looks up Tables.MIMETYPES for the mime type and returns its id. Returns -1 if the mime type
3550 MimetypesColumns._ID + " FROM " + Tables.MIMETYPES + " WHERE "
3625 updateIndexStats(db, Tables.CONTACTS,
3627 updateIndexStats(db, Tables.CONTACTS,
3629 updateIndexStats(db, Tables.CONTACTS, MoreDatabaseUtils.buildIndexName(Tables.CONTACTS,
3632 updateIndexStats(db, Tables.RAW_CONTACTS,
3634 updateIndexStats(db, Tables.RAW_CONTACTS,
3636 updateIndexStats(db, Tables.RAW_CONTACTS,
3638 updateIndexStats(db, Tables.RAW_CONTACTS,
3641 updateIndexStats(db, Tables.NAME_LOOKUP,
3643 updateIndexStats(db, Tables.NAME_LOOKUP,
3645 updateIndexStats(db, Tables.NAME_LOOKUP,
3648 updateIndexStats(db, Tables.PHONE_LOOKUP,
3650 updateIndexStats(db, Tables.PHONE_LOOKUP,
3652 updateIndexStats(db, Tables.PHONE_LOOKUP,
3655 updateIndexStats(db, Tables.DATA,
3657 updateIndexStats(db, Tables.DATA,
3660 updateIndexStats(db, Tables.GROUPS,
3663 updateIndexStats(db, Tables.NICKNAME_LOOKUP,
3666 updateIndexStats(db, Tables.STATUS_UPDATES,
3669 updateIndexStats(db, Tables.STREAM_ITEMS,
3671 updateIndexStats(db, Tables.STREAM_ITEM_PHOTOS,
3674 updateIndexStats(db, Tables.ACCOUNTS,
3677 updateIndexStats(db, Tables.PRE_AUTHORIZED_URIS,
3680 updateIndexStats(db, Tables.VISIBLE_CONTACTS,
3683 updateIndexStats(db, Tables.PHOTO_FILES,
3686 updateIndexStats(db, Tables.DEFAULT_DIRECTORY,
3689 updateIndexStats(db, Tables.MIMETYPES,
3692 updateIndexStats(db, Tables.DATA_USAGE_STAT,
3695 updateIndexStats(db, Tables.METADATA_SYNC,
3699 updateIndexStats(db, Tables.AGGREGATION_EXCEPTIONS,
3701 updateIndexStats(db, Tables.SETTINGS,
3703 updateIndexStats(db, Tables.PACKAGES,
3705 updateIndexStats(db, Tables.DIRECTORIES,
3718 updateIndexStats(db, Tables.METADATA_SYNC_STATE,
3733 updateIndexStats(db, Tables.PRESENCE, "presenceIndex", "1 1");
3734 updateIndexStats(db, Tables.PRESENCE, "presenceIndex2", "1 1");
3735 updateIndexStats(db, Tables.AGGREGATED_PRESENCE, null, "1");
3769 db.execSQL("DELETE FROM " + Tables.ACCOUNTS + ";");
3770 db.execSQL("DELETE FROM " + Tables.CONTACTS + ";");
3771 db.execSQL("DELETE FROM " + Tables.RAW_CONTACTS + ";");
3772 db.execSQL("DELETE FROM " + Tables.STREAM_ITEMS + ";");
3773 db.execSQL("DELETE FROM " + Tables.STREAM_ITEM_PHOTOS + ";");
3774 db.execSQL("DELETE FROM " + Tables.PHOTO_FILES + ";");
3775 db.execSQL("DELETE FROM " + Tables.DATA + ";");
3776 db.execSQL("DELETE FROM " + Tables.PHONE_LOOKUP + ";");
3777 db.execSQL("DELETE FROM " + Tables.NAME_LOOKUP + ";");
3778 db.execSQL("DELETE FROM " + Tables.GROUPS + ";");
3779 db.execSQL("DELETE FROM " + Tables.AGGREGATION_EXCEPTIONS + ";");
3780 db.execSQL("DELETE FROM " + Tables.SETTINGS + ";");
3781 db.execSQL("DELETE FROM " + Tables.DIRECTORIES + ";");
3782 db.execSQL("DELETE FROM " + Tables.SEARCH_INDEX + ";");
3783 db.execSQL("DELETE FROM " + Tables.DELETED_CONTACTS + ";");
3784 db.execSQL("DELETE FROM " + Tables.MIMETYPES + ";");
3785 db.execSQL("DELETE FROM " + Tables.PACKAGES + ";");
3786 db.execSQL("DELETE FROM " + Tables.PRESENCE + ";");
3787 db.execSQL("DELETE FROM " + Tables.AGGREGATED_PRESENCE + ";");
3790 // Note: we are not removing reference data from Tables.NICKNAME_LOOKUP
3850 * Convert a package name into an integer, using {@link Tables#PACKAGES} for
3856 " FROM " + Tables.PACKAGES +
3860 "INSERT INTO " + Tables.PACKAGES + "("
3878 * Convert a mimetype into an integer, using {@link Tables#MIMETYPES} for
3950 " FROM " + Tables.DATA_JOIN_MIMETYPES +
3951 " WHERE " + Tables.DATA + "." + Data._ID + "=?");
3970 " FROM " + Tables.ACCOUNTS, null);
3990 " FROM " + Tables.ACCOUNTS +
4027 "INSERT INTO " + Tables.ACCOUNTS +
4059 * {@link Tables#DEFAULT_DIRECTORY} for a specific contact.
4078 " FROM " + Tables.RAW_CONTACTS +
4079 " JOIN " + Tables.DATA +
4086 " FROM " + Tables.RAW_CONTACTS +
4090 " FROM " + Tables.GROUPS +
4097 " FROM " + Tables.RAW_CONTACTS +
4115 db.execSQL("INSERT OR IGNORE INTO " + Tables.DEFAULT_DIRECTORY + " VALUES(?)",
4119 db.execSQL("DELETE FROM " + Tables.DEFAULT_DIRECTORY +
4122 db.execSQL("DELETE FROM " + Tables.SEARCH_INDEX +
4132 "SELECT 1 FROM " + Tables.DEFAULT_DIRECTORY +
4155 "DELETE FROM " + Tables.VISIBLE_CONTACTS +
4158 " FROM " + Tables.CONTACTS +
4163 "INSERT INTO " + Tables.VISIBLE_CONTACTS +
4165 " FROM " + Tables.CONTACTS +
4168 Contacts._ID + " NOT IN " + Tables.VISIBLE_CONTACTS +
4179 " FROM " + Tables.RAW_CONTACTS +
4192 " FROM " + Tables.RAW_CONTACTS +
4225 sb.append(Tables.RAW_CONTACTS);
4227 + " ON (contacts_view._id = " + Tables.RAW_CONTACTS
4230 PhoneLookupColumns.NORMALIZED_NUMBER + " FROM "+ Tables.PHONE_LOOKUP + " "
4231 + "WHERE (" + Tables.PHONE_LOOKUP + "." + PhoneLookupColumns.MIN_MATCH + " = '");
4234 "ON lookup." + PhoneLookupColumns.DATA_ID + "=" + Tables.DATA + "." + Data._ID
4235 + " JOIN " + Tables.DATA + " "
4236 + "ON " + Tables.DATA + "." + Data.RAW_CONTACT_ID + "=" + Tables.RAW_CONTACTS + "."
4242 sb.append("PHONE_NUMBERS_EQUAL(" + Tables.DATA + "." + Phone.NUMBER + ", ");
4279 sb.append(Tables.RAW_CONTACTS);
4285 + " FROM phone_lookup " + " WHERE (" + Tables.PHONE_LOOKUP + "."
4288 sb.append("')) AS lookup, " + Tables.DATA);
4345 db.execSQL("DELETE FROM " + Tables.NICKNAME_LOOKUP);
4354 + Tables.NICKNAME_LOOKUP + "(" + NicknameLookupColumns.NAME + ","
4407 * Returns the value from the {@link PropertyUtils.Tables#PROPERTIES} table.
4414 * Stores a key-value pair in the {@link PropertyUtils.Tables#PROPERTIES} table.
4506 "DELETE FROM " + Tables.STATUS_UPDATES +
4515 "INSERT OR REPLACE INTO " + Tables.STATUS_UPDATES + "("
4535 "INSERT INTO " + Tables.STATUS_UPDATES + "("
4553 "UPDATE " + Tables.STATUS_UPDATES +
4567 "UPDATE " + Tables.STATUS_UPDATES +
4777 "UPDATE " + Tables.RAW_CONTACTS +
4816 "UPDATE " + Tables.DATA +
4832 "UPDATE " + Tables.DATA +
4849 "UPDATE " + Tables.DATA +
4854 " FROM " + Tables.RAW_CONTACTS +
4857 " FROM " + Tables.RAW_CONTACTS +
4866 * Inserts a record in the {@link Tables#NAME_LOOKUP} table.
4874 "INSERT OR IGNORE INTO " + Tables.NAME_LOOKUP + "("
4888 * Deletes all {@link Tables#NAME_LOOKUP} table rows associated with the specified data element.
4892 "DELETE FROM " + Tables.NAME_LOOKUP +
4929 "SELECT EXISTS(SELECT 1 FROM " + Tables.DATA +
4960 " FROM " + Tables.SEARCH_INDEX +
4969 " FROM " + Tables.SEARCH_INDEX +
4976 "INSERT OR REPLACE INTO " + Tables.METADATA_SYNC + "("
5019 invalidTokens.remove(Tables.DEFAULT_DIRECTORY.toLowerCase());