Searched refs:peopleLookup (Results 1 – 3 of 3) sorted by relevance
| /packages/providers/ContactsProvider/tests/assets/testSynced/ |
| D | legacy_contacts.sql | 56 CREATE TABLE peopleLookup (token TEXT,source INTEGER REFERENCES people(_id),token_index INTEGER); table
57 INSERT INTO peopleLookup VALUES('3f31414159064f314d4f',1,0);
58 INSERT INTO peopleLookup VALUES('4f314d4f',1,1);
59 INSERT INTO peopleLookup VALUES('4129393f',3,0);
60 INSERT INTO peopleLookup VALUES('4351412b314b',5,0);
61 INSERT INTO peopleLookup VALUES('4351412b314b0629432f064129393f',6,0);
62 INSERT INTO peopleLookup VALUES('29432f',6,1);
63 INSERT INTO peopleLookup VALUES('4129393f',6,2);
64 INSERT INTO peopleLookup VALUES('43454f064d59432d312f064351412b314b',7,0);
65 INSERT INTO peopleLookup VALUES('4d59432d312f',7,1);
[all …]
|
| /packages/providers/ContactsProvider/tests/assets/test1/ |
| D | legacy_contacts.sql | 58 CREATE TABLE peopleLookup (token TEXT,source INTEGER REFERENCES people(_id),token_index INTEGER); table
59 INSERT INTO peopleLookup VALUES('4f314d4f0629432f4b45392f',1,0);
60 INSERT INTO peopleLookup VALUES('29432f4b45392f',1,1);
61 INSERT INTO peopleLookup VALUES('3b294331062f4531',2,0);
62 INSERT INTO peopleLookup VALUES('2f4531',2,1);
63 INSERT INTO peopleLookup VALUES('3b453743062f4531',3,0);
64 INSERT INTO peopleLookup VALUES('2f4531',3,1);
65 INSERT INTO peopleLookup VALUES('292f2f312f0645430629432f4b45392f',11,0);
66 INSERT INTO peopleLookup VALUES(4543,11,1);
67 INSERT INTO peopleLookup VALUES('29432f4b45392f',11,2);
[all …]
|
| /packages/providers/ContactsProvider/tests/assets/testUnsynced/ |
| D | legacy_contacts.sql | 39 CREATE TABLE peopleLookup (token TEXT,source INTEGER REFERENCES people(_id),token_index INTEGER); table
40 INSERT INTO peopleLookup VALUES('4351412b314b0629432f064129393f',1,0);
41 INSERT INTO peopleLookup VALUES('29432f',1,1);
42 INSERT INTO peopleLookup VALUES('4129393f',1,2);
43 INSERT INTO peopleLookup VALUES('4351412b314b',2,0);
44 INSERT INTO peopleLookup VALUES('4129393f',3,0);
45 INSERT INTO peopleLookup VALUES('',4,0);
46 INSERT INTO peopleLookup VALUES('',5,0);
81 CREATE INDEX peopleLookupIndex ON peopleLookup (token,source);
90 CREATE TRIGGER contact_cleanup DELETE ON people BEGIN DELETE FROM peopleLookup WHERE source = old._…
[all …]
|