Searched refs:TABLE (Results 1 - 18 of 18) sorted by relevance

/packages/apps/Gallery2/src/com/android/photos/data/
H A DPhotoProvider.java73 public static final String TABLE = "accounts"; field in interface:PhotoProvider.Accounts
77 public static final Uri CONTENT_URI = Uri.withAppendedPath(BASE_CONTENT_URI, TABLE);
95 public static final String TABLE = "photos"; field in interface:PhotoProvider.Photos
97 public static final Uri CONTENT_URI = Uri.withAppendedPath(BASE_CONTENT_URI, TABLE);
134 public static final String TABLE = "albums"; field in interface:PhotoProvider.Albums
136 public static final Uri CONTENT_URI = Uri.withAppendedPath(BASE_CONTENT_URI, TABLE);
171 public static final String TABLE = "metadata"; field in interface:PhotoProvider.Metadata
173 public static final Uri CONTENT_URI = Uri.withAppendedPath(BASE_CONTENT_URI, TABLE);
218 + Albums.TABLE;
220 + Photos.TABLE;
[all...]
H A DPhotoDatabase.java39 private static final String SQL_CREATE_TABLE = "CREATE TABLE ";
88 createTable(db, Accounts.TABLE, getAccountTableDefinition());
89 createTable(db, Albums.TABLE, getAlbumTableDefinition());
90 createTable(db, Photos.TABLE, getPhotoTableDefinition());
91 createTable(db, Metadata.TABLE, getMetadataTableDefinition());
113 dropTable(db, Metadata.TABLE);
114 dropTable(db, Photos.TABLE);
115 dropTable(db, Albums.TABLE);
116 dropTable(db, Accounts.TABLE);
/packages/apps/Gallery2/src/com/android/gallery3d/filtershow/data/
H A DFilterStackDBHelper.java27 private static final String SQL_CREATE_TABLE = "CREATE TABLE ";
33 public static final String TABLE = "filterstack"; field in interface:FilterStackDBHelper.FilterStack
60 createTable(db, FilterStack.TABLE, CREATE_FILTER_STACK);
65 dropTable(db, FilterStack.TABLE);
H A DFilterStackSource.java63 ret = (-1 != database.insert(FilterStack.TABLE, null, val));
76 database.update(FilterStack.TABLE, val, FilterStack._ID + " = ?",
88 ret = (0 != database.delete(FilterStack.TABLE, FilterStack._ID + " = ?",
100 database.delete(FilterStack.TABLE, null, null);
112 c = database.query(FilterStack.TABLE,
136 c = database.query(FilterStack.TABLE,
173 c = database.query(FilterStack.TABLE,
/packages/providers/ContactsProvider/src/com/android/providers/contacts/aggregation/util/
H A DCommonNicknameCache.java48 public final static String TABLE = Tables.NICKNAME_LOOKUP; field in class:CommonNicknameCache.NicknameLookupPreloadQuery
71 Cursor cursor = mDb.query(NicknameLookupPreloadQuery.TABLE,
123 String TABLE = Tables.NICKNAME_LOOKUP; field in interface:CommonNicknameCache.NicknameLookupQuery
134 Cursor cursor = mDb.query(NicknameLookupQuery.TABLE, NicknameLookupQuery.COLUMNS,
/packages/providers/ContactsProvider/tests/assets/testUnsynced/
H A Dlegacy_contacts.sql3 CREATE TABLE _deleted_groups (_sync_version TEXT,_sync_id TEXT,_sync_account TEXT,_sync_mark INTEGER);
4 CREATE TABLE _deleted_people (_sync_version TEXT,_sync_id TEXT,_sync_account TEXT,_sync_mark INTEGER);
5 CREATE TABLE _sync_state (_id INTEGER PRIMARY KEY,_sync_account TEXT,data TEXT,UNIQUE(_sync_account));
6 CREATE TABLE _sync_state_metadata (version INTEGER);
8 CREATE TABLE android_metadata (locale TEXT);
10 CREATE TABLE calls (_id INTEGER PRIMARY KEY AUTOINCREMENT,number TEXT,date INTEGER,duration INTEGER,type INTEGER,new INTEGER,name TEXT,numbertype INTEGER,numberlabel TEXT);
11 CREATE TABLE contact_methods (_id INTEGER PRIMARY KEY AUTOINCREMENT,person INTEGER REFERENCES people(_id),kind INTEGER NOT NULL,data TEXT,aux_data TEXT,type INTEGER NOT NULL,label TEXT,isprimary INTEGER NOT NULL DEFAULT 0);
15 CREATE TABLE extensions (_id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT NOT NULL,value TEXT NOT NULL,person INTEGER REFERENCES people(_id),UNIQUE(person, name));
16 CREATE TABLE fave_msg_status (_id INTEGER PRIMARY KEY, msg TEXT, next_retry INTEGER, num_retries INTEGER);
17 CREATE TABLE fave_phone_change
[all...]
/packages/apps/UnifiedEmail/tests/src/com/android/mail/browse/
H A DTestProvider.java68 /* package */static final int TABLE = 100; field in class:TestProvider
120 sURIMatcher.addURI(AUTHORITY, table, TABLE);
140 case TABLE:
179 case TABLE:
217 case TABLE:
H A DTestProviderTests.java107 assertEquals(TestProvider.TABLE, TestProvider.sURIMatcher.match(uri));
/packages/providers/ContactsProvider/tests/assets/test1/
H A Dlegacy_contacts.sql3 CREATE TABLE _deleted_groups (_sync_version TEXT,_sync_id TEXT,_sync_account TEXT,_sync_mark INTEGER);
4 CREATE TABLE _deleted_people (_sync_version TEXT,_sync_id TEXT,_sync_account TEXT,_sync_mark INTEGER);
6 CREATE TABLE _sync_state (_id INTEGER PRIMARY KEY,_sync_account TEXT,data TEXT,UNIQUE(_sync_account));
8 CREATE TABLE _sync_state_metadata (version INTEGER);
10 CREATE TABLE android_metadata (locale TEXT);
12 CREATE TABLE calls (_id INTEGER PRIMARY KEY AUTOINCREMENT,number TEXT,date INTEGER,duration INTEGER,type INTEGER,new INTEGER,name TEXT,numbertype INTEGER,numberlabel TEXT);
14 CREATE TABLE contact_methods (_id INTEGER PRIMARY KEY AUTOINCREMENT,person INTEGER REFERENCES people(_id),kind INTEGER NOT NULL,data TEXT,aux_data TEXT,type INTEGER NOT NULL,label TEXT,isprimary INTEGER NOT NULL DEFAULT 0);
31 CREATE TABLE extensions (_id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT NOT NULL,value TEXT NOT NULL,person INTEGER REFERENCES people(_id),UNIQUE(person, name));
32 CREATE TABLE fave_msg_status (_id INTEGER PRIMARY KEY, msg TEXT, next_retry INTEGER, num_retries INTEGER);
33 CREATE TABLE fave_phone_change
[all...]
/packages/providers/ContactsProvider/tests/assets/testSynced/
H A Dlegacy_contacts.sql3 CREATE TABLE _deleted_groups (_sync_version TEXT,_sync_id TEXT,_sync_account TEXT,_sync_mark INTEGER);
4 CREATE TABLE _deleted_people (_sync_version TEXT,_sync_id TEXT,_sync_account TEXT,_sync_mark INTEGER);
5 CREATE TABLE _sync_state (_id INTEGER PRIMARY KEY,_sync_account TEXT,data TEXT,UNIQUE(_sync_account));
7 CREATE TABLE _sync_state_metadata (version INTEGER);
9 CREATE TABLE android_metadata (locale TEXT);
11 CREATE TABLE calls (_id INTEGER PRIMARY KEY AUTOINCREMENT,number TEXT,date INTEGER,duration INTEGER,type INTEGER,new INTEGER,name TEXT,numbertype INTEGER,numberlabel TEXT);
12 CREATE TABLE contact_methods (_id INTEGER PRIMARY KEY AUTOINCREMENT,person INTEGER REFERENCES people(_id),kind INTEGER NOT NULL,data TEXT,aux_data TEXT,type INTEGER NOT NULL,label TEXT,isprimary INTEGER NOT NULL DEFAULT 0);
18 CREATE TABLE extensions (_id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT NOT NULL,value TEXT NOT NULL,person INTEGER REFERENCES people(_id),UNIQUE(person, name));
19 CREATE TABLE fave_msg_status (_id INTEGER PRIMARY KEY, msg TEXT, next_retry INTEGER, num_retries INTEGER);
21 CREATE TABLE fave_phone_change
[all...]
/packages/providers/ContactsProvider/tests/assets/upgradeTest/
H A Dcontacts2_1108.sql3 CREATE TABLE _sync_state (_id INTEGER PRIMARY KEY,account_name TEXT NOT NULL,account_type TEXT NOT NULL,data TEXT,UNIQUE(account_name, account_type));
4 CREATE TABLE _sync_state_metadata (version INTEGER);
6 CREATE TABLE properties (property_key TEXT PRIMARY KEY, property_value TEXT );
14 CREATE TABLE accounts (_id INTEGER PRIMARY KEY AUTOINCREMENT,account_name TEXT, account_type TEXT, data_set TEXT);
15 CREATE TABLE contacts (_id INTEGER PRIMARY KEY AUTOINCREMENT,name_raw_contact_id INTEGER REFERENCES raw_contacts(_id),photo_id INTEGER REFERENCES data(_id),photo_file_id INTEGER REFERENCES photo_files(_id),custom_ringtone TEXT,send_to_voicemail INTEGER NOT NULL DEFAULT 0,times_contacted INTEGER NOT NULL DEFAULT 0,last_time_contacted INTEGER,starred INTEGER NOT NULL DEFAULT 0,pinned INTEGER NOT NULL DEFAULT 0,has_phone_number INTEGER NOT NULL DEFAULT 0,lookup TEXT,status_update_id INTEGER REFERENCES data(_id),contact_last_updated_timestamp INTEGER);
16 CREATE TABLE deleted_contacts (contact_id INTEGER PRIMARY KEY,contact_deleted_timestamp INTEGER NOT NULL default 0);
17 CREATE TABLE raw_contacts (_id INTEGER PRIMARY KEY AUTOINCREMENT,account_id INTEGER REFERENCES accounts(_id),sourceid TEXT,backup_id TEXT,raw_contact_is_read_only INTEGER NOT NULL DEFAULT 0,version INTEGER NOT NULL DEFAULT 1,dirty INTEGER NOT NULL DEFAULT 0,deleted INTEGER NOT NULL DEFAULT 0,metadata_dirty INTEGER NOT NULL DEFAULT 0,contact_id INTEGER REFERENCES contacts(_id),aggregation_mode INTEGER NOT NULL DEFAULT 0,aggregation_needed INTEGER NOT NULL DEFAULT 1,custom_ringtone TEXT,send_to_voicemail INTEGER NOT NULL DEFAULT 0,times_contacted INTEGER NOT NULL DEFAULT 0,last_time_contacted INTEGER,starred INTEGER NOT NULL DEFAULT 0,pinned INTEGER NOT NULL DEFAULT 0,display_name TEXT,display_name_alt TEXT,display_name_source INTEGER NOT NULL DEFAULT 0,phonetic_name TEXT,phonetic_name_style TEXT,sort_key TEXT COLLATE PHONEBOOK,phonebook_label TEXT,phonebook_bucket INTEGER,sort_key_alt TEXT COLLATE PHONEBOOK,phonebook_label_alt TEXT,phonebook_bucket_alt INTEGER,name_verified INTEGER NOT NULL DEFAULT 0,sync1 TEXT, sync2 TEXT, sync3 TEXT, sync4 TEXT );
18 CREATE TABLE stream_items (_id INTEGER PRIMARY KEY AUTOINCREMENT, raw_contact_id INTEGER NOT NULL, res_package TEXT, icon TEXT, label TEXT, text TEXT, timestamp INTEGER NOT NULL, comments TEXT, stream_item_sync1 TEXT, stream_item_sync2 TEXT, stream_item_sync3 TEXT, stream_item_sync4 TEXT, FOREIGN KEY(raw_contact_id) REFERENCES raw_contacts(_id));
19 CREATE TABLE stream_item_photos (_id INTEGER PRIMARY KEY AUTOINCREMENT, stream_item_id INTEGER NOT NULL, sort_index INTEGER, photo_file_id INTEGER NOT NULL, stream_item_photo_sync1 TEXT, stream_item_photo_sync2 TEXT, stream_item_photo_sync3 TEXT, stream_item_photo_sync4 TEXT, FOREIGN KEY(stream_item_id) REFERENCES stream_items(_id));
20 CREATE TABLE photo_file
[all...]
/packages/providers/ContactsProvider/src/com/android/providers/contacts/aggregation/
H A DContactAggregator2.java468 Cursor cursor = db.query(RawContactIdQuery.TABLE, RawContactIdQuery.COLUMNS,
513 final Cursor c = db.query(AggregateExceptionQuery.TABLE,
559 Cursor c = db.query(IdentityLookupMatchQuery.TABLE, IdentityLookupMatchQuery.COLUMNS,
583 Cursor c = db.query(NameLookupMatchQuery.TABLE, NameLookupMatchQuery.COLUMNS,
613 Cursor c = db.query(EmailLookupQuery.TABLE, EmailLookupQuery.COLUMNS,
644 Cursor c = db.query(NameLookupMatchQueryWithParameter.TABLE,
670 Cursor c = db.query(PhoneLookupQuery.TABLE, PhoneLookupQuery.COLUMNS,
717 String TABLE = Tables.NAME_LOOKUP_JOIN_RAW_CONTACTS; field in interface:ContactAggregator2.ContactNameLookupQuery
740 final Cursor c = db.query(ContactNameLookupQuery.TABLE, ContactNameLookupQuery.COLUMNS,
814 final Cursor c = db.query(RawContactIdQuery.TABLE, RawContactIdQuer
935 final String TABLE = Tables.DATA + " dataA" field in interface:ContactAggregator2.IdentityLookupMatchQuery
961 String TABLE = Tables.NAME_LOOKUP + " nameA" field in interface:ContactAggregator2.NameLookupMatchQuery
990 String TABLE = Tables.DATA + " dataA" field in interface:ContactAggregator2.EmailLookupQuery
1015 String TABLE = Tables.PHONE_LOOKUP + " phoneA" field in interface:ContactAggregator2.PhoneLookupQuery
1044 final String TABLE = Tables.RAW_CONTACTS + " LEFT OUTER JOIN " + Tables.NAME_LOOKUP field in interface:ContactAggregator2.NullNameRawContactsIdsQuery
[all...]
H A DContactAggregator.java483 Cursor cursor = db.query(RawContactIdQuery.TABLE, RawContactIdQuery.COLUMNS,
523 String TABLE = Tables.AGGREGATION_EXCEPTIONS field in interface:ContactAggregator.AggregateExceptionQuery
562 final Cursor c = db.query(AggregateExceptionQuery.TABLE,
687 final String TABLE = Tables.DATA + " dataA" field in interface:ContactAggregator.IdentityLookupMatchQuery
717 Cursor c = db.query(IdentityLookupMatchQuery.TABLE, IdentityLookupMatchQuery.COLUMNS,
732 String TABLE = Tables.NAME_LOOKUP + " nameA" field in interface:ContactAggregator.NameLookupMatchQuery
763 Cursor c = db.query(NameLookupMatchQuery.TABLE, NameLookupMatchQuery.COLUMNS,
788 Cursor c = db.query(EmailLookupQuery.TABLE, EmailLookupQuery.COLUMNS,
805 Cursor c = db.query(PhoneLookupQuery.TABLE, PhoneLookupQuery.COLUMNS,
847 String TABLE field in interface:ContactAggregator.ContactNameLookupQuery
[all...]
H A DAbstractContactAggregator.java562 public static final String TABLE = Tables.RAW_CONTACTS; field in class:AbstractContactAggregator.RawContactIdAndAggregationModeQuery
577 Cursor cursor = db.query(RawContactIdAndAggregationModeQuery.TABLE,
657 public static final String TABLE = Tables.RAW_CONTACTS; field in class:AbstractContactAggregator.RawContactIdAndAccountQuery
682 Cursor cursor = db.query(RawContactIdAndAccountQuery.TABLE,
889 public static final String TABLE = Tables.RAW_CONTACTS; field in class:AbstractContactAggregator.RawContactIdQuery
942 String TABLE = Tables.AGGREGATION_EXCEPTIONS; field in interface:AbstractContactAggregator.AggregateExceptionPrefetchQuery
969 final Cursor c = db.query(AggregateExceptionPrefetchQuery.TABLE,
988 String TABLE = Tables.NAME_LOOKUP; field in interface:AbstractContactAggregator.NameLookupQuery
1007 Cursor c = db.query(NameLookupQuery.TABLE, NameLookupQuery.COLUMNS,
1024 String TABLE field in interface:AbstractContactAggregator.AggregateExceptionQuery
1054 String TABLE = Tables.NAME_LOOKUP field in interface:AbstractContactAggregator.NameLookupMatchQueryWithParameter
1154 String TABLE = Tables.DATA + " dataA" field in interface:AbstractContactAggregator.EmailLookupQuery
1180 String TABLE = Tables.PHONE_LOOKUP + " phoneA" field in interface:AbstractContactAggregator.PhoneLookupQuery
1210 String TABLE = Tables.NAME_LOOKUP_JOIN_RAW_CONTACTS; field in interface:AbstractContactAggregator.ContactNameLookupQuery
1850 String TABLE = Views.RAW_CONTACTS; field in interface:AbstractContactAggregator.LookupKeyQuery
[all...]
/packages/providers/ContactsProvider/src/com/android/providers/contacts/
H A DDataRowHandlerForGroupMembership.java44 String TABLE = Tables.RAW_CONTACTS; field in interface:DataRowHandlerForGroupMembership.RawContactsQuery
193 Cursor c = db.query(RawContactsQuery.TABLE, RawContactsQuery.COLUMNS,
H A DDataRowHandler.java45 public static final String TABLE = Tables.DATA_JOIN_MIMETYPES; field in interface:DataRowHandler.DataDeleteQuery
343 Cursor c = db.query(DataDeleteQuery.TABLE,
H A DContactsProvider2.java498 public static final String TABLE = "data " field in interface:ContactsProvider2.DataContactsQuery
523 String TABLE = Tables.RAW_CONTACTS_JOIN_ACCOUNTS; field in interface:ContactsProvider2.RawContactsQuery
2564 String TABLE = Tables.RAW_CONTACTS_JOIN_METADATA_SYNC; field in interface:ContactsProvider2.MetadataSyncQuery
2582 final Cursor cursor = db.query(MetadataSyncQuery.TABLE,
3442 cursor = db.query(DataContactsQuery.TABLE, DataContactsQuery.PROJECTION,
4379 String TABLE = Views.GROUPS; field in interface:ContactsProvider2.GroupAccountQuery
4427 final Cursor c = db.query(GroupAccountQuery.TABLE, GroupAccountQuery.COLUMNS,
4570 Cursor cursor = db.query(RawContactsQuery.TABLE, RawContactsQuery.COLUMNS,
4949 String TABLE = Tables.RAW_CONTACTS; field in interface:ContactsProvider2.RawContactsBackupQuery
4970 final Cursor cursor = db.query(RawContactsBackupQuery.TABLE,
4984 String TABLE = Tables.DATA; field in interface:ContactsProvider2.DataHashQuery
5039 String TABLE = Tables.AGGREGATION_EXCEPTIONS; field in interface:ContactsProvider2.AggregationExceptionQuery
7813 String TABLE = Views.RAW_CONTACTS; field in interface:ContactsProvider2.LookupBySourceIdQuery
7869 String TABLE = Views.RAW_CONTACTS; field in interface:ContactsProvider2.LookupByRawContactIdQuery
7924 String TABLE = Tables.NAME_LOOKUP_JOIN_RAW_CONTACTS; field in interface:ContactsProvider2.LookupByDisplayNameQuery
9906 String TABLE = Tables.DATA_USAGE_STAT; field in interface:ContactsProvider2.DataUsageStatQuery
[all...]
H A DContactsDatabaseHelper.java792 public static final String TABLE = Tables.DATA; field in interface:ContactsDatabaseHelper.EmailQuery
808 public static final String TABLE = Tables.DATA; field in interface:ContactsDatabaseHelper.StructuredNameQuery
825 public static final String TABLE = Tables.DATA; field in interface:ContactsDatabaseHelper.NicknameQuery
1141 db.execSQL("CREATE TABLE IF NOT EXISTS " + Tables.PRESENCE + " ("+
1160 db.execSQL("CREATE TABLE IF NOT EXISTS "
1233 db.execSQL("CREATE TABLE " + Tables.ACCOUNTS + " (" +
1255 db.execSQL("CREATE TABLE " + Tables.CONTACTS + " (" +
1283 db.execSQL("CREATE TABLE " + Tables.RAW_CONTACTS + " (" +
1349 db.execSQL("CREATE TABLE " + Tables.STREAM_ITEMS + " (" +
1365 db.execSQL("CREATE TABLE "
[all...]

Completed in 277 milliseconds