Revision control
Copy as Markdown
Other Tools
-- Address book data for use in various tests.
PRAGMA user_version = 1;
CREATE TABLE cards (uid TEXT PRIMARY KEY, localId INTEGER);
CREATE TABLE properties (card TEXT, name TEXT, value TEXT);
CREATE TABLE lists (uid TEXT PRIMARY KEY, localId INTEGER, name TEXT, nickName TEXT, description TEXT);
CREATE TABLE list_cards (list TEXT, card TEXT, PRIMARY KEY(list, card));
INSERT INTO cards (uid, localId) VALUES
('0a64d642-7b51-4a84-be67-59b27ff2b528', 1),
('ce1bd5ad-17e7-4a1b-a51e-fbce76556ebd', 2),
('caaadb6c-425d-40e3-8f19-72546f6b01d8', 3),
('23acb230-f0d9-4348-a7be-1242cd579631', 4),
('02cf43d5-e5b8-48b4-9546-1bb509cd998f', 5);
INSERT INTO properties (card, name, value) VALUES
('0a64d642-7b51-4a84-be67-59b27ff2b528', 'PrimaryEmail', 'test1@foo.invalid'),
('0a64d642-7b51-4a84-be67-59b27ff2b528', 'LowercasePrimaryEmail', 'test1@foo.invalid'),
('0a64d642-7b51-4a84-be67-59b27ff2b528', 'PreferMailFormat', '0'),
('0a64d642-7b51-4a84-be67-59b27ff2b528', 'PopularityIndex', '0'),
('0a64d642-7b51-4a84-be67-59b27ff2b528', 'AllowRemoteContent', '0'),
('0a64d642-7b51-4a84-be67-59b27ff2b528', 'LastModifiedDate', '0'),
('ce1bd5ad-17e7-4a1b-a51e-fbce76556ebd', 'PrimaryEmail', 'test2@foo.invalid'),
('ce1bd5ad-17e7-4a1b-a51e-fbce76556ebd', 'LowercasePrimaryEmail', 'test2@foo.invalid'),
('ce1bd5ad-17e7-4a1b-a51e-fbce76556ebd', 'PreferMailFormat', '0'),
('ce1bd5ad-17e7-4a1b-a51e-fbce76556ebd', 'PopularityIndex', '0'),
('ce1bd5ad-17e7-4a1b-a51e-fbce76556ebd', 'AllowRemoteContent', '0'),
('ce1bd5ad-17e7-4a1b-a51e-fbce76556ebd', 'LastModifiedDate', '0'),
('caaadb6c-425d-40e3-8f19-72546f6b01d8', 'PrimaryEmail', 'test3@foo.invalid'),
('caaadb6c-425d-40e3-8f19-72546f6b01d8', 'LowercasePrimaryEmail', 'test3@foo.invalid'),
('caaadb6c-425d-40e3-8f19-72546f6b01d8', 'PreferMailFormat', '0'),
('caaadb6c-425d-40e3-8f19-72546f6b01d8', 'PopularityIndex', '0'),
('caaadb6c-425d-40e3-8f19-72546f6b01d8', 'AllowRemoteContent', '0'),
('caaadb6c-425d-40e3-8f19-72546f6b01d8', 'LastModifiedDate', '0'),
('23acb230-f0d9-4348-a7be-1242cd579631', 'PrimaryEmail', 'test4@foo.invalid'),
('23acb230-f0d9-4348-a7be-1242cd579631', 'LowercasePrimaryEmail', 'test4@foo.invalid'),
('23acb230-f0d9-4348-a7be-1242cd579631', 'LastModifiedDate', '1200685646'),
('23acb230-f0d9-4348-a7be-1242cd579631', 'PreferMailFormat', '1'),
('23acb230-f0d9-4348-a7be-1242cd579631', 'PopularityIndex', '0'),
('23acb230-f0d9-4348-a7be-1242cd579631', 'AllowRemoteContent', '0'),
('02cf43d5-e5b8-48b4-9546-1bb509cd998f', 'PrimaryEmail', 'test5@foo.invalid'),
('02cf43d5-e5b8-48b4-9546-1bb509cd998f', 'LowercasePrimaryEmail', 'test5@foo.invalid'),
('02cf43d5-e5b8-48b4-9546-1bb509cd998f', 'LastModifiedDate', '1200685651'),
('02cf43d5-e5b8-48b4-9546-1bb509cd998f', 'PreferMailFormat', '2'),
('02cf43d5-e5b8-48b4-9546-1bb509cd998f', 'PopularityIndex', '0'),
('02cf43d5-e5b8-48b4-9546-1bb509cd998f', 'AllowRemoteContent', '0');
INSERT INTO lists (uid, localId, name, nickName, description) VALUES
('98636844-ed9c-4ac1-98ac-de7989a93615', 1, 'TestList1', '', ''),
('31c44c28-450f-44d6-ba39-71cae90fac21', 2, 'TestList2', '', ''),
('46cf4cbf-5945-43e4-a822-30c2f2969db9', 3, 'TestList3', '', '');
INSERT INTO list_cards (list, card) VALUES
('98636844-ed9c-4ac1-98ac-de7989a93615', '0a64d642-7b51-4a84-be67-59b27ff2b528'),
('98636844-ed9c-4ac1-98ac-de7989a93615', 'ce1bd5ad-17e7-4a1b-a51e-fbce76556ebd'),
('98636844-ed9c-4ac1-98ac-de7989a93615', 'caaadb6c-425d-40e3-8f19-72546f6b01d8'),
('31c44c28-450f-44d6-ba39-71cae90fac21', '23acb230-f0d9-4348-a7be-1242cd579631'),
('46cf4cbf-5945-43e4-a822-30c2f2969db9', '02cf43d5-e5b8-48b4-9546-1bb509cd998f');