Searched refs:raw_contact_id (Results 1 – 4 of 4) sorted by relevance
| /packages/providers/ContactsProvider/tests/assets/upgradeTest/ |
| D | contacts2_1108.sql | 18 …raw_contact_id INTEGER NOT NULL, res_package TEXT, icon TEXT, label TEXT, text TEXT, timestamp INT… field
34 …S package(_id),mimetype_id INTEGER REFERENCES mimetype(_id) NOT NULL,raw_contact_id INTEGER REFERE… field
35 CREATE TABLE phone_lookup (data_id INTEGER REFERENCES data(_id) NOT NULL,raw_contact_id INTEGER REF… field
36 CREATE TABLE name_lookup (data_id INTEGER REFERENCES data(_id) NOT NULL,raw_contact_id INTEGER REFE… field
125 CREATE INDEX data_raw_contact_id ON data (raw_contact_id);
128 CREATE INDEX phone_lookup_index ON phone_lookup (normalized_number,raw_contact_id,data_id);
129 CREATE INDEX phone_lookup_min_match_index ON phone_lookup (min_match,raw_contact_id,data_id);
131 CREATE INDEX name_lookup_raw_contact_id_index ON name_lookup (raw_contact_id);
139 …raw_contact_id, raw_contacts.contact_id AS contact_id, raw_contacts.account_id,accounts.account_na…
142 …(raw_contacts.account_id=accounts._id) LEFT OUTER JOIN data ON (data.raw_contact_id=raw_contacts._…
[all …]
|
| /packages/providers/ContactsProvider/tests/assets/test1/ |
| D | expected_data.txt | 3 3 raw_contact_id=1
30 30 raw_contact_id=2
57 57 raw_contact_id=3
84 84 raw_contact_id=3
111 111 raw_contact_id=11
138 138 raw_contact_id=3
165 165 raw_contact_id=2
192 192 raw_contact_id=2
219 219 raw_contact_id=2
246 246 raw_contact_id=2
[all …]
|
| /packages/providers/ContactsProvider/tests/assets/testSynced/ |
| D | expected_data.txt | 3 3 raw_contact_id=1
30 30 raw_contact_id=3
57 57 raw_contact_id=5
84 84 raw_contact_id=6
111 111 raw_contact_id=7
138 138 raw_contact_id=8
165 165 raw_contact_id=9
192 192 raw_contact_id=10
219 219 raw_contact_id=2
246 246 raw_contact_id=5
[all …]
|
| /packages/providers/ContactsProvider/tests/assets/testUnsynced/ |
| D | expected_data.txt | 3 3 raw_contact_id=1
30 30 raw_contact_id=2
57 57 raw_contact_id=3
84 84 raw_contact_id=1
111 111 raw_contact_id=2
138 138 raw_contact_id=4
165 165 raw_contact_id=1
192 192 raw_contact_id=3
219 219 raw_contact_id=5
246 246 raw_contact_id=1
[all …]
|