Home | History | Annotate | Download | only in testSynced

Lines Matching refs:INTO

6 INSERT INTO _sync_state VALUES(1,'lemmytest@gmail.com','');
8 INSERT INTO _sync_state_metadata VALUES(2);
10 INSERT INTO android_metadata VALUES('en_US');
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);
20 INSERT INTO fave_msg_status VALUES(100,16359444020020760201000000000000000000000000000000000000000000000000000000000000,1268764830477,2);
23 INSERT INTO faves VALUES(1,1,0,'','',000000000000,NULL,NULL,NULL);
24 INSERT INTO faves VALUES(2,2,0,'','',000000000000,NULL,NULL,NULL);
25 INSERT INTO faves VALUES(3,3,0,'','',000000000000,NULL,NULL,NULL);
26 INSERT INTO faves VALUES(4,4,0,'','',000000000000,NULL,NULL,NULL);
27 INSERT INTO faves VALUES(5,5,0,'','',000000000000,NULL,NULL,NULL);
29 INSERT INTO groupmembership VALUES(3,2,NULL,'lemmytest@gmail.com',6);
30 INSERT INTO groupmembership VALUES(4,3,NULL,'lemmytest@gmail.com',6);
31 INSERT INTO groupmembership VALUES(5,4,NULL,'lemmytest@gmail.com',6);
32 INSERT INTO groupmembership VALUES(6,5,NULL,'lemmytest@gmail.com',6);
33 INSERT INTO groupmembership VALUES(7,6,NULL,'lemmytest@gmail.com',6);
34 INSERT INTO groupmembership VALUES(8,7,1,NULL,NULL);
35 INSERT INTO groupmembership VALUES(9,8,1,NULL,NULL);
36 INSERT INTO groupmembership VALUES(10,9,1,NULL,NULL);
37 INSERT INTO groupmembership VALUES(11,10,1,NULL,NULL);
38 INSERT INTO groupmembership VALUES(12,11,1,NULL,NULL);
39 INSERT INTO groupmembership VALUES(13,12,1,NULL,NULL);
41 INSERT INTO groups VALUES(1,'lemmytest@gmail.com',6,NULL,NULL,NULL,0,1,'System Group: My Contacts','System Group: My Contacts',0,'Contacts');
44 INSERT INTO people VALUES(1,'non_syncable',NULL,NULL,NULL,NULL,1,1,'Lemmy Test',NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
45 INSERT INTO people VALUES(2,'lemmytest@gmail.com','561d08a30def1f46',1268764045346000,1268764045346000,NULL,0,1,NULL,NULL,0,NULL,0,1,NULL,NULL,NULL,NULL,0,NULL);
46 INSERT INTO people VALUES(3,'lemmytest@gmail.com','506b6479896c635d',1268764047603000,1268764047603000,NULL,0,1,'Mail',NULL,0,NULL,0,NULL,NULL,1,NULL,NULL,0,NULL);
47 INSERT INTO people VALUES(4,'lemmytest@gmail.com','192ec38f0de81866',1268764074839000,1268764074839000,NULL,0,1,NULL,NULL,0,NULL,0,NULL,NULL,2,NULL,NULL,0,NULL);
48 INSERT INTO people VALUES(5,'lemmytest@gmail.com','3e879d80b2673fc',1268764126701000,1268764126701000,NULL,0,1,'Number',NULL,0,NULL,0,2,NULL,NULL,NULL,NULL,0,NULL);
49 INSERT INTO people VALUES(6,'lemmytest@gmail.com','4413217a0a1f5437',1268764154975000,1268764154975000,NULL,0,1,'Number And Mail',NULL,0,NULL,0,3,NULL,NULL,NULL,NULL,0,NULL);
50 INSERT INTO people VALUES(7,'lemmytest@gmail.com',NULL,NULL,NULL,NULL,1,NULL,'Not Synced Number',NULL,0,NULL,0,4,NULL,NULL,NULL,NULL,0,'');
51 INSERT INTO people VALUES(8,'lemmytest@gmail.com',NULL,NULL,NULL,NULL,1,NULL,'Not Synced NumberMail',NULL,0,NULL,0,5,NULL,3,NULL,NULL,0,'');
52 INSERT INTO people VALUES(9,'lemmytest@gmail.com',NULL,NULL,NULL,NULL,1,NULL,'Not Synced Mail',NULL,0,NULL,0,NULL,NULL,4,NULL,NULL,0,'');
53 INSERT INTO people VALUES(10,'lemmytest@gmail.com',NULL,NULL,NULL,NULL,1,NULL,'Not Synced',NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'');
54 INSERT INTO people VALUES(11,'lemmytest@gmail.com',NULL,NULL,NULL,NULL,1,NULL,'',NULL,0,NULL,0,6,NULL,NULL,NULL,NULL,0,'');
55 INSERT INTO people VALUES(12,'lemmytest@gmail.com',NULL,NULL,NULL,NULL,1,NULL,'',NULL,0,NULL,0,NULL,NULL,5,NULL,NULL,0,'');
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);
66 INSERT INTO peopleLookup VALUES('4351412b314b',7,2);
67 INSERT INTO peopleLookup VALUES('43454f064d59432d312f064351412b314b4129393f',8,0);
68 INSERT INTO peopleLookup VALUES('4d59432d312f',8,1);
69 INSERT INTO peopleLookup VALUES('4351412b314b4129393f',8,2);
70 INSERT INTO peopleLookup VALUES('43454f064d59432d312f064129393f',9,0);
71 INSERT INTO peopleLookup VALUES('4d59432d312f',9,1);
72 INSERT INTO peopleLookup VALUES('4129393f',9,2);
73 INSERT INTO peopleLookup VALUES('43454f064d59432d312f',10,0);
74 INSERT INTO peopleLookup VALUES('4d59432d312f',10,1);
75 INSERT INTO peopleLookup VALUES('',11,0);
76 INSERT INTO peopleLookup VALUES('',12,0);
78 INSERT INTO peopleLookupWithPhoneticName VALUES('3f31414159064f314d4f',1,0);
79 INSERT INTO peopleLookupWithPhoneticName VALUES('4f314d4f',1,1);
80 INSERT INTO peopleLookupWithPhoneticName VALUES('225d',2,0);
81 INSERT INTO peopleLookupWithPhoneticName VALUES('4129393f',3,0);
82 INSERT INTO peopleLookupWithPhoneticName VALUES('225d',4,0);
83 INSERT INTO peopleLookupWithPhoneticName VALUES('4351412b314b',5,0);
84 INSERT INTO peopleLookupWithPhoneticName VALUES('4351412b314b0629432f064129393f',6,0);
85 INSERT INTO peopleLookupWithPhoneticName VALUES('29432f',6,1);
86 INSERT INTO peopleLookupWithPhoneticName VALUES('4129393f',6,2);
87 INSERT INTO peopleLookupWithPhoneticName VALUES('43454f064d59432d312f064351412b314b',7,0);
88 INSERT INTO peopleLookupWithPhoneticName VALUES('4d59432d312f',7,1);
89 INSERT INTO peopleLookupWithPhoneticName VALUES('4351412b314b',7,2);
90 INSERT INTO peopleLookupWithPhoneticName VALUES('43454f064d59432d312f064351412b314b4129393f',8,0);
91 INSERT INTO peopleLookupWithPhoneticName VALUES('4d59432d312f',8,1);
92 INSERT INTO peopleLookupWithPhoneticName VALUES('4351412b314b4129393f',8,2);
93 INSERT INTO peopleLookupWithPhoneticName VALUES('43454f064d59432d312f064129393f',9,0);
94 INSERT INTO peopleLookupWithPhoneticName VALUES('4d59432d312f',9,1);
95 INSERT INTO peopleLookupWithPhoneticName VALUES('4129393f',9,2);
96 INSERT INTO peopleLookupWithPhoneticName VALUES('43454f064d59432d312f',10,0);
97 INSERT INTO peopleLookupWithPhoneticName VALUES('4d59432d312f',10,1);
98 INSERT INTO peopleLookupWithPhoneticName VALUES('225d',11,0);
99 INSERT INTO peopleLookupWithPhoneticName VALUES('225d',12,0);
101 INSERT INTO phones VALUES(1,2,2,'698-147-02',20741896,NULL,1);
102 INSERT INTO phones VALUES(2,5,2,'716-5432',2345617,NULL,1);
103 INSERT INTO phones VALUES(3,6,2,'542-31',13245,NULL,1);
104 INSERT INTO phones VALUES(4,7,2,'564-123-789',987321465,NULL,1);
105 INSERT INTO phones VALUES(5,8,2,'841-735-24',42537148,NULL,1);
106 INSERT INTO phones VALUES(6,11,2,1111111111,1111111111,NULL,1);
108 INSERT INTO photos VALUES(1,0,1,NULL,NULL,NULL,'non_syncable',NULL,NULL,NULL,NULL,0,1);
109 INSERT INTO photos VALUES(2,0,2,NULL,NULL,NULL,'lemmytest@gmail.com','561d08a30def1f46','1B2M2Y8AsgTpgAmY7PhCfg','1B2M2Y8AsgTpgAmY7PhCfg',NULL,0,1);
110 INSERT INTO photos VALUES(3,0,3,NULL,NULL,NULL,'lemmytest@gmail.com','506b6479896c635d','1B2M2Y8AsgTpgAmY7PhCfg','1B2M2Y8AsgTpgAmY7PhCfg',NULL,0,1);
111 INSERT INTO photos VALUES(4,0,4,NULL,NULL,NULL,'lemmytest@gmail.com','192ec38f0de81866','1B2M2Y8AsgTpgAmY7PhCfg','1B2M2Y8AsgTpgAmY7PhCfg',NULL,0,1);
112 INSERT INTO photos VALUES(5,0,5,NULL,NULL,NULL,'lemmytest@gmail.com','3e879d80b2673fc','1B2M2Y8AsgTpgAmY7PhCfg','1B2M2Y8AsgTpgAmY7PhCfg',NULL,0,1);
113 INSERT INTO photos VALUES(6,0,6,NULL,NULL,NULL,'lemmytest@gmail.com','4413217a0a1f5437','1B2M2Y8AsgTpgAmY7PhCfg','1B2M2Y8AsgTpgAmY7PhCfg',NULL,0,1);
114 INSERT INTO photos VALUES(7,0,7,NULL,NULL,NULL,'lemmytest@gmail.com',NULL,NULL,NULL,NULL,0,NULL);
115 INSERT INTO photos VALUES(8,0,8,NULL,NULL,NULL,'lemmytest@gmail.com',NULL,NULL,NULL,NULL,0,NULL);
116 INSERT INTO photos VALUES(9,0,9,NULL,NULL,NULL,'lemmytest@gmail.com',NULL,NULL,NULL,NULL,0,NULL);
117 INSERT INTO photos VALUES(10,0,10,NULL,NULL,NULL,'lemmytest@gmail.com',NULL,NULL,NULL,NULL,0,NULL);
118 INSERT INTO photos VALUES(11,0,11,NULL,NULL,NULL,'lemmytest@gmail.com',NULL,NULL,NULL,NULL,0,NULL);
119 INSERT INTO photos VALUES(12,0,12,NULL,NULL,NULL,'lemmytest@gmail.com',NULL,NULL,NULL,NULL,0,NULL);
121 INSERT INTO settings VALUES(1,NULL,'syncEverything',1);
123 INSERT INTO sqlite_sequence VALUES('groups',1);
124 INSERT INTO sqlite_sequence VALUES('people',12);
125 INSERT INTO sqlite_sequence VALUES('photos',12);
126 INSERT INTO sqlite_sequence VALUES('phones',6);
127 INSERT INTO sqlite_sequence VALUES('contact_methods',5);
129 INSERT INTO voice_dialer_timestamp VALUES(1,1268764377);
159 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;