Cross Reference: /packages/apps/Dialer/src/com/android/dialer/database/DialerDatabaseHelper.java

Lines Matching defs:Tables
87     public interface Tables {
208                 Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.LAST_TIME_USED + ")";
225                 Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.STARRED + " DESC, "
226                 + Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.IS_SUPER_PRIMARY + " DESC, "
228                 + Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.TIMES_USED + " DESC, "
229                 + Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.IN_VISIBLE_GROUP + " DESC, "
230                 + Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.DISPLAY_NAME_PRIMARY + ", "
231                 + Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.CONTACT_ID + ", "
232                 + Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.IS_PRIMARY + " DESC";
357         db.execSQL("CREATE TABLE " + Tables.SMARTDIAL_TABLE + " (" +
374         db.execSQL("CREATE TABLE " + Tables.PREFIX_TABLE + " (" +
380         db.execSQL("CREATE TABLE " + Tables.PROPERTIES + " (" +
390         db.execSQL("DROP TABLE IF EXISTS " + Tables.PREFIX_TABLE);
391         db.execSQL("DROP TABLE IF EXISTS " + Tables.SMARTDIAL_TABLE);
392         db.execSQL("DROP TABLE IF EXISTS " + Tables.PROPERTIES);
422      * Stores a key-value pair in the {@link Tables#PROPERTIES} table.
432         db.replace(Tables.PROPERTIES, null, values);
436      * Returns the value from the {@link Tables#PROPERTIES} table.
445             final Cursor cursor = db.query(Tables.PROPERTIES,
536                 db.delete(Tables.SMARTDIAL_TABLE,
538                 db.delete(Tables.PREFIX_TABLE,
558         db.delete(Tables.PREFIX_TABLE,
560                 "(SELECT " + SmartDialDbColumns.CONTACT_ID + " FROM " + Tables.SMARTDIAL_TABLE +
564         db.delete(Tables.SMARTDIAL_TABLE,
573         db.delete(Tables.SMARTDIAL_TABLE, null, null);
574         db.delete(Tables.PREFIX_TABLE, null, null);
582         return (int)DatabaseUtils.longForQuery(db, "SELECT COUNT(1) FROM " + Tables.PREFIX_TABLE,
598                 db.delete(Tables.SMARTDIAL_TABLE, SmartDialDbColumns.CONTACT_ID + "=" +
600                 db.delete(Tables.PREFIX_TABLE, PrefixColumns.CONTACT_ID + "=" +
622             final String sqlInsert = "INSERT INTO " + Tables.SMARTDIAL_TABLE + " (" +
639             final String numberSqlInsert = "INSERT INTO " + Tables.PREFIX_TABLE + " (" +
719             final String sqlInsert = "INSERT INTO " + Tables.PREFIX_TABLE + " (" +
830                     " FROM " + Tables.SMARTDIAL_TABLE +
852                     Tables.SMARTDIAL_TABLE + " (" + SmartDialDbColumns.CONTACT_ID  + ");");
855                     Tables.SMARTDIAL_TABLE + " (" +
859                     Tables.SMARTDIAL_TABLE + " (" +
871                     Tables.PREFIX_TABLE + " (" + PrefixColumns.PREFIX + ");");
874                     Tables.PREFIX_TABLE + " (" + PrefixColumns.CONTACT_ID + ");");
881             db.execSQL("ANALYZE " + Tables.SMARTDIAL_TABLE);
882             db.execSQL("ANALYZE " + Tables.PREFIX_TABLE);
932                 " FROM " + Tables.SMARTDIAL_TABLE + " WHERE " +
935                     " FROM " + Tables.PREFIX_TABLE +
936                     " WHERE " + Tables.PREFIX_TABLE + "." + PrefixColumns.PREFIX +