From 6bf0a5cb5034a7e684dcc3500e841785237ce2dd Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 19:32:43 +0200 Subject: Adding upstream version 1:115.7.0. Signed-off-by: Daniel Baumann --- comm/mailnews/test/data/abLists1.sql | 62 ++++++++++++++++++++++++++++++++++++ 1 file changed, 62 insertions(+) create mode 100644 comm/mailnews/test/data/abLists1.sql (limited to 'comm/mailnews/test/data/abLists1.sql') diff --git a/comm/mailnews/test/data/abLists1.sql b/comm/mailnews/test/data/abLists1.sql new file mode 100644 index 0000000000..77963da29e --- /dev/null +++ b/comm/mailnews/test/data/abLists1.sql @@ -0,0 +1,62 @@ +-- 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'); -- cgit v1.2.3