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
('9c4232ec-8992-44b2-8fd7-71dfb23a93c6', 1),
('40326ec9-5361-4f8c-9797-0de3b28edce9', 2),
('f96f5eb1-6181-4588-b0d4-0fc47c9ac995', 3),
('a95c192c-ad3d-4e56-a7e3-8b969c80c717', 4),
('620c1226-eb2d-4df7-a532-f731544525ba', 5);
INSERT INTO properties (card, name, value) VALUES
('9c4232ec-8992-44b2-8fd7-71dfb23a93c6', 'FirstName', 'firs'),
('9c4232ec-8992-44b2-8fd7-71dfb23a93c6', 'LastName', 'lastn'),
('9c4232ec-8992-44b2-8fd7-71dfb23a93c6', 'PrimaryEmail', 'ema@test.invalid'),
('9c4232ec-8992-44b2-8fd7-71dfb23a93c6', 'LowercasePrimaryEmail', 'ema@test.invalid'),
('9c4232ec-8992-44b2-8fd7-71dfb23a93c6', 'DisplayName', 'd'),
('9c4232ec-8992-44b2-8fd7-71dfb23a93c6', 'NickName', 'ni'),
('9c4232ec-8992-44b2-8fd7-71dfb23a93c6', 'PreferMailFormat', '0'),
('9c4232ec-8992-44b2-8fd7-71dfb23a93c6', 'PopularityIndex', '0'),
('9c4232ec-8992-44b2-8fd7-71dfb23a93c6', 'AllowRemoteContent', '0'),
('9c4232ec-8992-44b2-8fd7-71dfb23a93c6', 'LastModifiedDate', '0'),
('40326ec9-5361-4f8c-9797-0de3b28edce9', 'FirstName', 'first'),
('40326ec9-5361-4f8c-9797-0de3b28edce9', 'NickName', 'nic'),
('40326ec9-5361-4f8c-9797-0de3b28edce9', 'PrimaryEmail', 'emai@test.invalid'),
('40326ec9-5361-4f8c-9797-0de3b28edce9', 'LowercasePrimaryEmail', 'emai@test.invalid'),
('40326ec9-5361-4f8c-9797-0de3b28edce9', 'LastName', 'l'),
('40326ec9-5361-4f8c-9797-0de3b28edce9', 'DisplayName', 'di'),
('40326ec9-5361-4f8c-9797-0de3b28edce9', 'PreferMailFormat', '0'),
('40326ec9-5361-4f8c-9797-0de3b28edce9', 'PopularityIndex', '0'),
('40326ec9-5361-4f8c-9797-0de3b28edce9', 'AllowRemoteContent', '0'),
('40326ec9-5361-4f8c-9797-0de3b28edce9', 'LastModifiedDate', '0'),
('f96f5eb1-6181-4588-b0d4-0fc47c9ac995', 'DisplayName', 'dis'),
('f96f5eb1-6181-4588-b0d4-0fc47c9ac995', 'NickName', 'nick'),
('f96f5eb1-6181-4588-b0d4-0fc47c9ac995', 'PrimaryEmail', 'email@test.invalid'),
('f96f5eb1-6181-4588-b0d4-0fc47c9ac995', 'LowercasePrimaryEmail', 'email@test.invalid'),
('f96f5eb1-6181-4588-b0d4-0fc47c9ac995', 'FirstName', 'f'),
('f96f5eb1-6181-4588-b0d4-0fc47c9ac995', 'LastName', 'la'),
('f96f5eb1-6181-4588-b0d4-0fc47c9ac995', 'PreferMailFormat', '0'),
('f96f5eb1-6181-4588-b0d4-0fc47c9ac995', 'PopularityIndex', '0'),
('f96f5eb1-6181-4588-b0d4-0fc47c9ac995', 'AllowRemoteContent', '0'),
('f96f5eb1-6181-4588-b0d4-0fc47c9ac995', 'LastModifiedDate', '0'),
('a95c192c-ad3d-4e56-a7e3-8b969c80c717', 'LastName', 'las'),
('a95c192c-ad3d-4e56-a7e3-8b969c80c717', 'DisplayName', 'disp'),
('a95c192c-ad3d-4e56-a7e3-8b969c80c717', 'NickName', 'nickn'),
('a95c192c-ad3d-4e56-a7e3-8b969c80c717', 'PrimaryEmail', 'e@test.invalid'),
('a95c192c-ad3d-4e56-a7e3-8b969c80c717', 'LowercasePrimaryEmail', 'e@test.invalid'),
('a95c192c-ad3d-4e56-a7e3-8b969c80c717', 'FirstName', 'fi'),
('a95c192c-ad3d-4e56-a7e3-8b969c80c717', 'PreferMailFormat', '0'),
('a95c192c-ad3d-4e56-a7e3-8b969c80c717', 'PopularityIndex', '0'),
('a95c192c-ad3d-4e56-a7e3-8b969c80c717', 'AllowRemoteContent', '0'),
('a95c192c-ad3d-4e56-a7e3-8b969c80c717', 'LastModifiedDate', '0'),
('620c1226-eb2d-4df7-a532-f731544525ba', 'FirstName', 'fir'),
('620c1226-eb2d-4df7-a532-f731544525ba', 'LastName', 'last'),
('620c1226-eb2d-4df7-a532-f731544525ba', 'DisplayName', 'displ'),
('620c1226-eb2d-4df7-a532-f731544525ba', 'PrimaryEmail', 'em@test.invalid'),
('620c1226-eb2d-4df7-a532-f731544525ba', 'LowercasePrimaryEmail', 'em@test.invalid'),
('620c1226-eb2d-4df7-a532-f731544525ba', 'NickName', 'n'),
('620c1226-eb2d-4df7-a532-f731544525ba', 'PreferMailFormat', '0'),
('620c1226-eb2d-4df7-a532-f731544525ba', 'PopularityIndex', 'a'),
('620c1226-eb2d-4df7-a532-f731544525ba', 'AllowRemoteContent', '0'),
('620c1226-eb2d-4df7-a532-f731544525ba', 'LastModifiedDate', '0');
INSERT INTO lists (uid, localId, name, nickName, description) VALUES
('ab831252-d358-435b-a5a4-7f8536ea53d5', 6, 't', '', 'list'),
('52924d31-3a7d-420f-b4b4-039e9888ed08', 7, 'te', '', 'lis'),
('71b6f54e-dbc4-4bf0-a7d7-7235a5551ba5', 8, 'tes', '', 'li'),
('a0f4d368-7451-4756-b003-1018f231c7b4', 9, 'test', 'abcdef', 'l');