Lines Matching full:into
5 INSERT INTO _deleted_people VALUES(1249441421793000,'20d08a710c3df43d','android.contacts.test.eclair@gmail.com',NULL);
7 INSERT INTO _sync_state VALUES(1,'android.contacts.test.eclair@gmail.com','');
9 INSERT INTO _sync_state_metadata VALUES(2);
11 INSERT INTO android_metadata VALUES('en_US');
13 INSERT INTO calls VALUES(1,18004664411,1249177360040,10,2,1,'Jane Doe',1,NULL);
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);
24 INSERT INTO contact_methods VALUES(10,2,3,'f','pre:1',3,NULL,0);
25 INSERT INTO contact_methods VALUES(11,2,3,'g','pre:6',3,NULL,0);
26 INSERT INTO contact_methods VALUES(12,2,3,'h','pre:7',3,NULL,0);
27 INSERT INTO contact_methods VALUES(13,3,1,'deer@acme.com',NULL,2,NULL,1);
28 INSERT INTO contact_methods VALUES(14,3,2,'12345 Main Street
30 INSERT INTO contact_methods VALUES(15,3,3,'deerdough','pre:5',3,NULL,0);
35 INSERT INTO faves VALUES(1,1,0,'','',000000000000,NULL,NULL,NULL);
36 INSERT INTO faves VALUES(2,2,0,'','',000000000000,NULL,NULL,NULL);
37 INSERT INTO faves VALUES(3,3,0,'','',000000000000,NULL,NULL,NULL);
38 INSERT INTO faves VALUES(4,4,0,'','',000000000000,NULL,NULL,NULL);
39 INSERT INTO faves VALUES(5,5,0,'','',000000000000,NULL,NULL,NULL);
41 INSERT INTO groupmembership VALUES(1,2,NULL,'android.contacts.test.eclair@gmail.com',6);
42 INSERT INTO groupmembership VALUES(2,3,NULL,'android.contacts.test.eclair@gmail.com',6);
43 INSERT INTO groupmembership VALUES(3,3,NULL,'android.contacts.test.eclair@gmail.com','20a186238cf27aaa');
44 INSERT INTO groupmembership VALUES(9,3,NULL,'android.contacts.test.eclair@gmail.com',55555555555);
45 INSERT INTO groupmembership VALUES(10,11,1,NULL,NULL);
46 INSERT INTO groupmembership VALUES(11,2,3,'android.contacts.test.eclair@gmail.com','2fcbf74c8be345dc');
48 INSERT INTO groups VALUES(1,'android.contacts.test.eclair@gmail.com',6,NULL,NULL,NULL,0,1,'System Group: My Contacts','System Group: My Contacts',0,'Contacts');
49 INSERT INTO groups VALUES(2,'android.contacts.test.eclair@gmail.com','20a186238cf27aaa',1249172992736000,1249172992736000,NULL,0,1,'Eclair Contacts','Eclair Contacts',0,NULL);
50 INSERT INTO groups VALUES(3,'android.contacts.test.eclair@gmail.com','2fcbf74c8be345dc',1249176693566000,1249176693566000,NULL,0,1,'Starred in Android','Starred in Android',0,NULL);
52 INSERT INTO organizations VALUES(1,'Acme Corp','President',0,1,NULL,3);
54 INSERT INTO people VALUES(1,'non_syncable',NULL,NULL,NULL,NULL,1,1,'Test Android',NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
55 INSERT INTO people VALUES(2,'android.contacts.test.eclair@gmail.com','3d09f37e0f0dbc6f',1249441106583000,1249441106583000,NULL,1,1,'Jane Doe',NULL,1,1249177384979,1,1,NULL,1,NULL,NULL,NULL,NULL);
56 INSERT INTO people VALUES(3,'android.contacts.test.eclair@gmail.com','5c9ae978b346ac9',1249441067558000,1249441067558000,NULL,1,1,'John Doe','This is a test account for Eclair Android Contacts',0,NULL,1,8,1,13,NULL,'content://media/internal/audio/media/80',1,NULL);
57 INSERT INTO people VALUES(11,'android.contacts.test.eclair@gmail.com',NULL,NULL,NULL,NULL,1,NULL,'Added On Android',NULL,0,NULL,0,16,NULL,NULL,NULL,NULL,0,'');
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);
69 INSERT INTO peopleLookupWithPhoneticName VALUES('4f314d4f0629432f4b45392f',1,0);
70 INSERT INTO peopleLookupWithPhoneticName VALUES('29432f4b45392f',1,1);
71 INSERT INTO peopleLookupWithPhoneticName VALUES('3b294331062f4531',2,0);
72 INSERT INTO peopleLookupWithPhoneticName VALUES('2f4531',2,1);
73 INSERT INTO peopleLookupWithPhoneticName VALUES('3b453743062f4531',3,0);
74 INSERT INTO peopleLookupWithPhoneticName VALUES('2f4531',3,1);
75 INSERT INTO peopleLookupWithPhoneticName VALUES('292f2f312f0645430629432f4b45392f',11,0);
76 INSERT INTO peopleLookupWithPhoneticName VALUES(4543,11,1);
77 INSERT INTO peopleLookupWithPhoneticName VALUES('29432f4b45392f',11,2);
79 INSERT INTO phones VALUES(1,2,1,'1-800-466-4411',11446640081,NULL,1);
80 INSERT INTO phones VALUES(2,2,3,2345678901,1098765432,NULL,0);
81 INSERT INTO phones VALUES(3,2,2,3456789012,2109876543,NULL,0);
82 INSERT INTO phones VALUES(4,2,5,4567890123,3210987654,NULL,0);
83 INSERT INTO phones VALUES(5,2,4,5678901234,4321098765,NULL,0);
84 INSERT INTO phones VALUES(6,2,6,6789012345,5432109876,NULL,0);
85 INSERT INTO phones VALUES(7,2,7,7890123456,6543210987,NULL,0);
86 INSERT INTO phones VALUES(8,3,2,'555-555-5555',5555555555,NULL,0);
87 INSERT INTO phones VALUES(11,2,1,1234567890,0987654321,NULL,0);
88 INSERT INTO phones VALUES(16,11,2,'1-987-4563',36547891,NULL,1);
90 INSERT INTO photos VALUES(1,0,1,NULL,NULL,NULL,'non_syncable',NULL,NULL,NULL,NULL,0,1);
91 INSERT INTO photos VALUES(2,1,2,'4Yujp-X7nRp5v8zJca7cxg','????',NULL,'android.contacts.test.eclair@gmail.com','3d09f37e0f0dbc6f','4Yujp-X7nRp5v8zJca7cxg','4Yujp-X7nRp5v8zJca7cxg',NULL,0,1);
92 INSERT INTO photos VALUES(3,1,3,'sQwgwiST8gBzusqDIFkOgg','????',NULL,'android.contacts.test.eclair@gmail.com','5c9ae978b346ac9','sQwgwiST8gBzusqDIFkOgg','sQwgwiST8gBzusqDIFkOgg',NULL,0,1);
93 INSERT INTO photos VALUES(11,0,11,NULL,NULL,NULL,'android.contacts.test.eclair@gmail.com',NULL,NULL,NULL,NULL,0,NULL);
95 INSERT INTO settings VALUES(1,NULL,'syncEverything',1);
97 INSERT INTO sqlite_sequence VALUES('groups',3);
98 INSERT INTO sqlite_sequence VALUES('people',11);
99 INSERT INTO sqlite_sequence VALUES('photos',11);
100 INSERT INTO sqlite_sequence VALUES('phones',16);
101 INSERT INTO sqlite_sequence VALUES('contact_methods',24);
102 INSERT INTO sqlite_sequence VALUES('organizations',2);
103 INSERT INTO sqlite_sequence VALUES('calls',1);
105 INSERT INTO voice_dialer_timestamp VALUES(1,1249441215);
135 CREATE TRIGGER groups_to_deleted DELETE ON groups WHEN old._sync_id is not null BEGIN INSERT INTO _deleted_groups (_sync_id, _sync_account, _sync_version) VALUES (old._sync_id, old._sync_account, old._sync_version);END;
