diff options
Diffstat (limited to 'comm/mailnews/test/data/tb2hexpopularity.sql')
-rw-r--r-- | comm/mailnews/test/data/tb2hexpopularity.sql | 76 |
1 files changed, 76 insertions, 0 deletions
diff --git a/comm/mailnews/test/data/tb2hexpopularity.sql b/comm/mailnews/test/data/tb2hexpopularity.sql new file mode 100644 index 0000000000..2ab6bd2c68 --- /dev/null +++ b/comm/mailnews/test/data/tb2hexpopularity.sql @@ -0,0 +1,76 @@ +-- 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'); |