| legacy_contacts.sql | 14 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 VALUES(9,2,3,'e','pre:4',3,NULL,0)
[all...] |