Searched refs:contact_methods (Results 1 – 3 of 3) sorted by relevance
| /packages/providers/ContactsProvider/tests/assets/test1/ |
| D | legacy_contacts.sql | 14 CREATE TABLE contact_methods (_id INTEGER PRIMARY KEY AUTOINCREMENT,person INTEGER REFERENCES peopl… table
15 INSERT INTO contact_methods VALUES(1,2,1,'a@acme.com',NULL,1,NULL,1);
16 INSERT INTO contact_methods VALUES(2,2,1,'b@acme.com',NULL,2,NULL,0);
17 INSERT INTO contact_methods VALUES(3,2,1,'c@acme.com',NULL,3,NULL,0);
18 INSERT INTO contact_methods VALUES(4,2,1,'d@acme.com',NULL,3,NULL,0);
19 INSERT INTO contact_methods VALUES(5,2,3,'a','pre:5',3,NULL,0);
20 INSERT INTO contact_methods VALUES(6,2,3,'b','pre:0',3,NULL,0);
21 INSERT INTO contact_methods VALUES(7,2,3,'c','pre:2',3,NULL,0);
22 INSERT INTO contact_methods VALUES(8,2,3,'d','pre:3',3,NULL,0);
23 INSERT INTO contact_methods VALUES(9,2,3,'e','pre:4',3,NULL,0);
[all …]
|
| /packages/providers/ContactsProvider/tests/assets/testSynced/ |
| D | legacy_contacts.sql | 12 CREATE TABLE contact_methods (_id INTEGER PRIMARY KEY AUTOINCREMENT,person INTEGER REFERENCES peopl… table
13 INSERT INTO contact_methods VALUES(1,3,1,'weyj@xtdt.com',NULL,1,NULL,1);
14 INSERT INTO contact_methods VALUES(2,4,1,'mail@dom.com',NULL,1,NULL,1);
15 INSERT INTO contact_methods VALUES(3,8,1,'doooooo@sgghhh.com',NULL,1,NULL,1);
16 INSERT INTO contact_methods VALUES(4,9,1,'ahhh@glkbgghh.com',NULL,1,NULL,1);
17 INSERT INTO contact_methods VALUES(5,12,1,'notsynced@gmail.com',NULL,1,NULL,1);
43 …TEGER REFERENCES organizations(_id),primary_email INTEGER REFERENCES contact_methods(_id),photo_ve…
130 CREATE INDEX contactMethodsPeopleIndex ON contact_methods (person);
146 …urce = old._id;DELETE FROM phones WHERE person = old._id;DELETE FROM contact_methods WHERE person …
147 CREATE TRIGGER contact_methods_INSERT_typeAndLabel AFTER INSERT ON contact_methods WHEN (NEW.type…
[all …]
|
| /packages/providers/ContactsProvider/tests/assets/testUnsynced/ |
| D | legacy_contacts.sql | 11 CREATE TABLE contact_methods (_id INTEGER PRIMARY KEY AUTOINCREMENT,person INTEGER REFERENCES peopl… table
12 INSERT INTO contact_methods VALUES(1,1,1,'gdgjj.fxhnj@ggh.com',NULL,1,NULL,1);
13 INSERT INTO contact_methods VALUES(2,3,1,'weyj@xtdt.com',NULL,1,NULL,1);
14 INSERT INTO contact_methods VALUES(3,5,1,'mail@dom.com',NULL,1,NULL,1);
33 …TEGER REFERENCES organizations(_id),primary_email INTEGER REFERENCES contact_methods(_id),photo_ve…
74 CREATE INDEX contactMethodsPeopleIndex ON contact_methods (person);
90 …urce = old._id;DELETE FROM phones WHERE person = old._id;DELETE FROM contact_methods WHERE person …
91 CREATE TRIGGER contact_methods_INSERT_typeAndLabel AFTER INSERT ON contact_methods WHEN (NEW.type…
92 CREATE TRIGGER contact_methods_UPDATE_typeAndLabel AFTER UPDATE ON contact_methods WHEN (NEW.type…
93 CREATE TRIGGER contact_methods_delete DELETE ON contact_methods BEGIN UPDATE people SET _sync_dirty…
[all …]
|