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');