Searched refs:contact_methods (Results 1 - 3 of 3) sorted by relevance

/packages/providers/ContactsProvider/tests/assets/test1/
H A Dlegacy_contacts.sql14 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); 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 VALUE
[all...]
/packages/providers/ContactsProvider/tests/assets/testUnsynced/
H A Dlegacy_contacts.sql11 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); 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 CREATE TABLE people (_id INTEGER PRIMARY KEY AUTOINCREMENT,_sync_account TEXT,_sync_id TEXT,_sync_time TEXT,_sync_version TEXT,_sync_local_id INTEGER,_sync_dirty INTEGER NOT NULL DEFAULT 0,_sync_mark INTEGER,name TEXT COLLATE LOCALIZED,notes TEXT COLLATE LOCALIZED,times_contacted INTEGER NOT NULL DEFAULT 0,last_time_contacted INTEGER,starred INTEGER NOT NULL DEFAULT 0,primary_phone INTEGER REFERENCES phones(_id),primary_organization INTEGER REFERENCES organizations(_id),primary_email INTEGER REFERENCES contact_methods(_id),photo_version TEXT,custom_ringtone TEXT,send_to_voicemail INTEGER,phonetic_name TEXT COLLATE LOCALIZED);
71 INSERT INTO sqlite_sequence VALUES('contact_methods',3);
74 CREATE INDEX contactMethodsPeopleIndex ON contact_methods (person);
90 CREATE TRIGGER contact_cleanup DELETE ON people BEGIN DELETE FROM peopleLookup WHERE source = old._id;DELETE FROM peopleLookupWithPhoneticName WHERE source = old._id;DELETE FROM phones WHERE person = old._id;DELETE FROM contact_methods WHERE person = old._id;DELETE FROM organizations WHERE person = old._id;DELETE FROM groupmembership WHERE person = old._id;DELETE FROM extensions WHERE person = old._id;END;
91 CREATE TRIGGER contact_methods_INSERT_typeAndLabel AFTER INSERT ON contact_methods WHEN (NEW.type != 0 AND NEW.label IS NOT NULL) OR (NEW.type = 0 AND NEW.label IS NULL) BEGIN SELECT RAISE (ABORT, 'exactly one of type or label must be set'); END;
92 CREATE TRIGGER contact_methods_UPDATE_typeAndLabel AFTER UPDATE ON contact_methods WHE
[all...]
/packages/providers/ContactsProvider/tests/assets/testSynced/
H A Dlegacy_contacts.sql12 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); 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 CREATE TABLE people (_id INTEGER PRIMARY KEY AUTOINCREMENT,_sync_account TEXT,_sync_id TEXT,_sync_time TEXT,_sync_version TEXT,_sync_local_id INTEGER,_sync_dirty INTEGER NOT NULL DEFAULT 0,_sync_mark INTEGER,name TEXT COLLATE LOCALIZED,notes TEXT COLLATE LOCALIZED,times_contacted INTEGER NOT NULL DEFAULT 0,last_time_contacted INTEGER,starred INTEGER NOT NULL DEFAULT 0,primary_phone INTEGER REFERENCES phones(_id),primary_organization INTEGER REFERENCES organizations(_id),primary_email INTEGER REFERENCES contact_methods(_id),photo_version TEXT,custom_ringtone TEXT,send_to_voicemail INTEGER,phonetic_name TEXT COLLATE LOCALIZED);
127 INSERT INTO sqlite_sequence VALUES('contact_methods',5);
130 CREATE INDEX contactMethodsPeopleIndex ON contact_methods (person);
146 CREATE TRIGGER contact_cleanup DELETE ON people BEGIN DELETE FROM peopleLookup WHERE source = old._id;DELETE FROM peopleLookupWithPhoneticName WHERE source = old._id;DELETE FROM phones WHERE person = old._id;DELETE FROM contact_methods WHER
[all...]

Completed in 32 milliseconds