From 632653dadddc2d1ae4e605dd19b81567c6903f6f Mon Sep 17 00:00:00 2001
From: Shane Jaroch <chown_tee@proton.me>
Date: Wed, 21 Jan 2026 05:11:24 -0500
Subject: [PATCH] re-add

---
 tests/firefox-146-aes/key4.db    | 13 +++++++++++++
 tests/firefox-14iv/cert9.db      |  9 +++++++++
 tests/firefox-14iv/key4.db       | 13 +++++++++++++
 tests/firefox-70/key4.db         | 12 ++++++++++++
 tests/firefox-84/key4.db         | 13 +++++++++++++
 tests/firefox-mixed-keys/key4.db |  9 +++++++++
 tests/firefox-mp-70/key4.db      | 12 ++++++++++++
 tests/firefox-mp-84/key4.db      | 13 +++++++++++++
 tests/firefox-mp-test/key4.db    |  8 ++++++++
 9 files changed, 102 insertions(+)
 create mode 100644 tests/firefox-146-aes/key4.db
 create mode 100644 tests/firefox-14iv/cert9.db
 create mode 100644 tests/firefox-14iv/key4.db
 create mode 100644 tests/firefox-70/key4.db
 create mode 100644 tests/firefox-84/key4.db
 create mode 100644 tests/firefox-mixed-keys/key4.db
 create mode 100644 tests/firefox-mp-70/key4.db
 create mode 100644 tests/firefox-mp-84/key4.db
 create mode 100644 tests/firefox-mp-test/key4.db

diff --git a/tests/firefox-146-aes/key4.db b/tests/firefox-146-aes/key4.db
new file mode 100644
index 0000000..a3f3726
--- /dev/null
+++ b/tests/firefox-146-aes/key4.db
@@ -0,0 +1,13 @@
+PRAGMA user_version = 0;
+PRAGMA foreign_keys=OFF;
+BEGIN TRANSACTION;
+CREATE TABLE metaData (id PRIMARY KEY UNIQUE ON CONFLICT REPLACE, item1, item2);
+CREATE TABLE nssPrivate (id PRIMARY KEY UNIQUE ON CONFLICT ABORT, a0, a1, a2, a3, a4, a10, a11, a12, a80, a81, a82, a83, a84, a85, a86, a87, a88, a89, a8a, a8b, a8c, a90, a100, a101, a102, a103, a104, a105, a106, a107, a108, a109, a10a, a10b, a10c, a110, a111, a120, a121, a122, a123, a124, a125, a126, a127, a128, a129, a130, a131, a132, a133, a134, a160, a161, a162, a163, a164, a165, a166, a170, a171, a172, a180, a181, a200, a201, a202, a210, a40000211, a40000212, a40000213, a220, a221, a222, a223, a224, a225, a226, a227, a22e, a22f, a22a, a22b, a22c, a22d, a250, a251, a252, a300, a301, a302, a400, a401, a402, a403, a404, a405, a406, a480, a481, a482, a500, a501, a502, a503, a601, a602, a603, a604, a605, a606, a607, a608, a609, a60a, a60b, a60c, a60d, a60e, a60f, a610, a611, a612, a617, a618, a619, a61a, a61b, a61c, a61d, a61e, a61f, a620, a621, a622, a623, a624, a625, a626, a627, a629, a628, a62a, a62b, a62c, a62d, a62e, a62f, a630, a631, a632, a633, a634, a635, a636, a637, a80000001, ace534351, ace534352, ace534353, ace534354, ace534355, ace534356, ace534357, ace534358, ace534364, ace534365, ace534366, ace534367, ace534368, ace534369, ace534373, ace534374, ace536351, ace536352, ace536353, ace536354, ace536355, ace536356, ace536357, ace536358, ace536359, ace53635a, ace53635b, ace53635c, ace53635d, ace53635e, ace53635f, ace536360, ace5363b4, ace5363b5, ad5a0db00);
+INSERT INTO "metaData" ("id", "item1", "item2") VALUES ('password', X'F93F912988415C345CE8BF46CABB5884090A04B1', X'308181306D06092A864886F70D01050D3060304106092A864886F70D01050C303404209C4E5B7A06CABF4215AC5D13762E0B1DEE4F1D62FDEC46E13A3EAFD8B680FFAE020101020120300A06082A864886F70D0209301B060960864801650304012A040E925930A1FB223607A8E9EFC243CD0410CDBAF974799027EEB36E6DD3A1B97BFD');
+INSERT INTO "metaData" ("id", "item1", "item2") VALUES ('sig_key_3f4a3840_00000011', X'308180305C06092A864886F70D01050E304F304106092A864886F70D01050C3034042085A9A58C21A8986B4BF5A3F3B494CD1618F933B7FD0D48FCE685435DD027FB85020101020120300A06082A864886F70D0209300A06082A864886F70D0209042002FE4A8E3814E455A108399507993030B66F4BCB0C8E23ABBB87BA7864B3DB8C', NULL);
+INSERT INTO "nssPrivate" ("id", "a0", "a1", "a2", "a3", "a4", "a10", "a11", "a12", "a80", "a81", "a82", "a83", "a84", "a85", "a86", "a87", "a88", "a89", "a8a", "a8b", "a8c", "a90", "a100", "a101", "a102", "a103", "a104", "a105", "a106", "a107", "a108", "a109", "a10a", "a10b", "a10c", "a110", "a111", "a120", "a121", "a122", "a123", "a124", "a125", "a126", "a127", "a128", "a129", "a130", "a131", "a132", "a133", "a134", "a160", "a161", "a162", "a163", "a164", "a165", "a166", "a170", "a171", "a172", "a180", "a181", "a200", "a201", "a202", "a210", "a40000211", "a40000212", "a40000213", "a220", "a221", "a222", "a223", "a224", "a225", "a226", "a227", "a22e", "a22f", "a22a", "a22b", "a22c", "a22d", "a250", "a251", "a252", "a300", "a301", "a302", "a400", "a401", "a402", "a403", "a404", "a405", "a406", "a480", "a481", "a482", "a500", "a501", "a502", "a503", "a601", "a602", "a603", "a604", "a605", "a606", "a607", "a608", "a609", "a60a", "a60b", "a60c", "a60d", "a60e", "a60f", "a610", "a611", "a612", "a617", "a618", "a619", "a61a", "a61b", "a61c", "a61d", "a61e", "a61f", "a620", "a621", "a622", "a623", "a624", "a625", "a626", "a627", "a629", "a628", "a62a", "a62b", "a62c", "a62d", "a62e", "a62f", "a630", "a631", "a632", "a633", "a634", "a635", "a636", "a637", "a80000001", "ace534351", "ace534352", "ace534353", "ace534354", "ace534355", "ace534356", "ace534357", "ace534358", "ace534364", "ace534365", "ace534366", "ace534367", "ace534368", "ace534369", "ace534373", "ace534374", "ace536351", "ace536352", "ace536353", "ace536354", "ace536355", "ace536356", "ace536357", "ace536358", "ace536359", "ace53635a", "ace53635b", "ace53635c", "ace53635d", "ace53635e", "ace53635f", "ace536360", "ace5363b4", "ace5363b5", "ad5a0db00") VALUES (1061828672, X'00000004', X'01', X'01', X'A5005A', NULL, NULL, X'3081A1306D06092A864886F70D01050D3060304106092A864886F70D01050C3034042044F7FB06E1135919092A88CBF58BAA0809EDD4587B4B930FAACC5FE2745128BA020101020120300A06082A864886F70D0209301B060960864801650304012A040E11E4D7138AD979C2B1F971C3547C0430EA10B058C0464C85BF5DF466F1C00C477D33C9F658C731254ACAB651EEB25CB51EDA46411A9C8A9E2F5DCA294CAB544A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, X'0000001F', NULL, X'F8000000000000000000000000000001', X'00', X'01', X'01', X'01', X'01', X'01', NULL, X'00', NULL, NULL, X'A5005A', X'A5005A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, X'00000020', X'01', X'00', X'00', X'01', NULL, X'01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+CREATE INDEX issuer ON nssPrivate (a81);
+CREATE INDEX subject ON nssPrivate (a101);
+CREATE INDEX label ON nssPrivate (a3);
+CREATE INDEX ckaid ON nssPrivate (a102);
+COMMIT;
diff --git a/tests/firefox-14iv/cert9.db b/tests/firefox-14iv/cert9.db
new file mode 100644
index 0000000..dbf9976
--- /dev/null
+++ b/tests/firefox-14iv/cert9.db
@@ -0,0 +1,9 @@
+PRAGMA user_version = 0;
+PRAGMA foreign_keys=OFF;
+BEGIN TRANSACTION;
+CREATE TABLE nssPublic (id PRIMARY KEY UNIQUE ON CONFLICT ABORT, a0, a1, a2, a3, a4, a10, a11, a12, a80, a81, a82, a83, a84, a85, a86, a87, a88, a89, a8a, a8b, a8c, a90, a100, a101, a102, a103, a104, a105, a106, a107, a108, a109, a10a, a10b, a10c, a110, a111, a120, a121, a122, a123, a124, a125, a126, a127, a128, a129, a130, a131, a132, a133, a134, a160, a161, a162, a163, a164, a165, a166, a170, a171, a172, a180, a181, a200, a201, a202, a210, a40000211, a40000212, a40000213, a220, a221, a222, a223, a224, a225, a226, a227, a22e, a22f, a22a, a22b, a22c, a22d, a250, a251, a252, a300, a301, a302, a400, a401, a402, a403, a404, a405, a406, a480, a481, a482, a500, a501, a502, a503, a601, a602, a603, a604, a605, a606, a607, a608, a609, a60a, a60b, a60c, a60d, a60e, a60f, a610, a611, a612, a617, a618, a619, a61a, a61b, a61c, a61d, a61e, a61f, a620, a621, a622, a623, a624, a625, a626, a627, a629, a628, a62a, a62b, a62c, a62d, a62e, a62f, a630, a631, a632, a633, a634, a635, a636, a637, a80000001, ace534351, ace534352, ace534353, ace534354, ace534355, ace534356, ace534357, ace534358, ace534364, ace534365, ace534366, ace534367, ace534368, ace534369, ace534373, ace534374, ace536351, ace536352, ace536353, ace536354, ace536355, ace536356, ace536357, ace536358, ace536359, ace53635a, ace53635b, ace53635c, ace53635d, ace53635e, ace53635f, ace536360, ace5363b4, ace5363b5, ad5a0db00);
+CREATE INDEX issuer ON nssPublic (a81);
+CREATE INDEX subject ON nssPublic (a101);
+CREATE INDEX label ON nssPublic (a3);
+CREATE INDEX ckaid ON nssPublic (a102);
+COMMIT;
diff --git a/tests/firefox-14iv/key4.db b/tests/firefox-14iv/key4.db
new file mode 100644
index 0000000..b8798c3
--- /dev/null
+++ b/tests/firefox-14iv/key4.db
@@ -0,0 +1,13 @@
+PRAGMA user_version = 0;
+PRAGMA foreign_keys=OFF;
+BEGIN TRANSACTION;
+CREATE TABLE metaData (id PRIMARY KEY UNIQUE ON CONFLICT REPLACE, item1, item2);
+CREATE TABLE nssPrivate (id PRIMARY KEY UNIQUE ON CONFLICT ABORT, a0, a1, a2, a3, a4, a10, a11, a12, a80, a81, a82, a83, a84, a85, a86, a87, a88, a89, a8a, a8b, a8c, a90, a100, a101, a102, a103, a104, a105, a106, a107, a108, a109, a10a, a10b, a10c, a110, a111, a120, a121, a122, a123, a124, a125, a126, a127, a128, a129, a130, a131, a132, a133, a134, a160, a161, a162, a163, a164, a165, a166, a170, a171, a172, a180, a181, a200, a201, a202, a210, a40000211, a40000212, a40000213, a220, a221, a222, a223, a224, a225, a226, a227, a22e, a22f, a22a, a22b, a22c, a22d, a250, a251, a252, a300, a301, a302, a400, a401, a402, a403, a404, a405, a406, a480, a481, a482, a500, a501, a502, a503, a601, a602, a603, a604, a605, a606, a607, a608, a609, a60a, a60b, a60c, a60d, a60e, a60f, a610, a611, a612, a617, a618, a619, a61a, a61b, a61c, a61d, a61e, a61f, a620, a621, a622, a623, a624, a625, a626, a627, a629, a628, a62a, a62b, a62c, a62d, a62e, a62f, a630, a631, a632, a633, a634, a635, a636, a637, a80000001, ace534351, ace534352, ace534353, ace534354, ace534355, ace534356, ace534357, ace534358, ace534364, ace534365, ace534366, ace534367, ace534368, ace534369, ace534373, ace534374, ace536351, ace536352, ace536353, ace536354, ace536355, ace536356, ace536357, ace536358, ace536359, ace53635a, ace53635b, ace53635c, ace53635d, ace53635e, ace53635f, ace536360, ace5363b4, ace5363b5, ad5a0db00);
+INSERT INTO "metaData" ("id", "item1", "item2") VALUES ('password', X'644F4F43B2F24340237D05E7B85C14E5E212B923433D10CC7256FB84636BFC42878E1E9782A728CDDDDC0F5B25A19D76', X'308182306E06092A864886F70D01050D3061304206092A864886F70D01050C30350420C7AC67B9D422F20BC46845ACA1735D455AA3C745B0AC75D0A68643B6BC90094E02022710020120300A06082A864886F70D0209301B060960864801650304012A040E54673F250D10A73193432DE314E00410EAEF13D0C501C4AEB5CF7236D07C8906');
+INSERT INTO "metaData" ("id", "item1", "item2") VALUES ('sig_key_0e5820d8_00000011', X'308181305D06092A864886F70D01050E3050304206092A864886F70D01050C303504205C16F6B2E6557B038CB674D990B6263C1BA6C802A726E55C23481ABB60F5D2A002022710020120300A06082A864886F70D0209300A06082A864886F70D0209042079183F69FC307A354FC658767A65E85B12372231AEE96991E88CF08DD8B9EC71', NULL);
+INSERT INTO "nssPrivate" ("id", "a0", "a1", "a2", "a3", "a4", "a10", "a11", "a12", "a80", "a81", "a82", "a83", "a84", "a85", "a86", "a87", "a88", "a89", "a8a", "a8b", "a8c", "a90", "a100", "a101", "a102", "a103", "a104", "a105", "a106", "a107", "a108", "a109", "a10a", "a10b", "a10c", "a110", "a111", "a120", "a121", "a122", "a123", "a124", "a125", "a126", "a127", "a128", "a129", "a130", "a131", "a132", "a133", "a134", "a160", "a161", "a162", "a163", "a164", "a165", "a166", "a170", "a171", "a172", "a180", "a181", "a200", "a201", "a202", "a210", "a40000211", "a40000212", "a40000213", "a220", "a221", "a222", "a223", "a224", "a225", "a226", "a227", "a22e", "a22f", "a22a", "a22b", "a22c", "a22d", "a250", "a251", "a252", "a300", "a301", "a302", "a400", "a401", "a402", "a403", "a404", "a405", "a406", "a480", "a481", "a482", "a500", "a501", "a502", "a503", "a601", "a602", "a603", "a604", "a605", "a606", "a607", "a608", "a609", "a60a", "a60b", "a60c", "a60d", "a60e", "a60f", "a610", "a611", "a612", "a617", "a618", "a619", "a61a", "a61b", "a61c", "a61d", "a61e", "a61f", "a620", "a621", "a622", "a623", "a624", "a625", "a626", "a627", "a629", "a628", "a62a", "a62b", "a62c", "a62d", "a62e", "a62f", "a630", "a631", "a632", "a633", "a634", "a635", "a636", "a637", "a80000001", "ace534351", "ace534352", "ace534353", "ace534354", "ace534355", "ace534356", "ace534357", "ace534358", "ace534364", "ace534365", "ace534366", "ace534367", "ace534368", "ace534369", "ace534373", "ace534374", "ace536351", "ace536352", "ace536353", "ace536354", "ace536355", "ace536356", "ace536357", "ace536358", "ace536359", "ace53635a", "ace53635b", "ace53635c", "ace53635d", "ace53635e", "ace53635f", "ace536360", "ace5363b4", "ace5363b5", "ad5a0db00") VALUES (240656600, X'00000004', X'01', X'01', X'A5005A', NULL, NULL, X'3081A2306E06092A864886F70D01050D3061304206092A864886F70D01050C303504200A4D100BDCC7FA08A0F4757F9A1789D9F5ADF1FF3AA19092C5D8F97D918AE8ED02022710020120300A06082A864886F70D0209301B060960864801650304012A040EB179C6E4302F05738D48CFA24C40043027CD8D2097D6DFB0B4AB4D5381620E8051C6760A7F4A7E9C1B91BDDEF1CAFF72C9B0777B731C67EACF053FBE4084D35E', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, X'0000001F', NULL, X'F8000000000000000000000000000001', X'00', X'01', X'01', X'01', X'01', X'01', NULL, X'00', NULL, NULL, X'A5005A', X'A5005A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, X'00000020', X'01', X'00', X'00', X'01', NULL, X'01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+CREATE INDEX issuer ON nssPrivate (a81);
+CREATE INDEX subject ON nssPrivate (a101);
+CREATE INDEX label ON nssPrivate (a3);
+CREATE INDEX ckaid ON nssPrivate (a102);
+COMMIT;
diff --git a/tests/firefox-70/key4.db b/tests/firefox-70/key4.db
new file mode 100644
index 0000000..81ebfe0
--- /dev/null
+++ b/tests/firefox-70/key4.db
@@ -0,0 +1,12 @@
+PRAGMA user_version = 0;
+PRAGMA foreign_keys=OFF;
+BEGIN TRANSACTION;
+CREATE TABLE metaData (id PRIMARY KEY UNIQUE ON CONFLICT REPLACE, item1, item2);
+CREATE TABLE nssPrivate (id PRIMARY KEY UNIQUE ON CONFLICT ABORT, a0, a1, a2, a3, a10, a11, a12, a80, a81, a82, a83, a84, a85, a86, a87, a88, a89, a8a, a8b, a90, a100, a101, a102, a103, a104, a105, a106, a107, a108, a109, a10a, a10b, a10c, a110, a111, a120, a121, a122, a123, a124, a125, a126, a127, a128, a130, a131, a132, a133, a134, a160, a161, a162, a163, a164, a165, a166, a170, a180, a181, a200, a201, a202, a210, a40000211, a40000212, a300, a301, a302, a400, a401, a402, a403, a404, a405, a406, a480, a481, a482, a500, a501, a502, a503, ace534351, ace534352, ace534353, ace534354, ace534355, ace534356, ace534357, ace534358, ace534364, ace534365, ace534366, ace534367, ace534368, ace536351, ace536352, ace536353, ace536354, ace536355, ace536356, ace536357, ace536358, ace536359, ace53635a, ace53635b, ace53635c, ace53635d, ace53635e, ace53635f, ace536360, ace5363b4, ace5363b5, ad5a0db00, a80000001, ace534369, a129);
+INSERT INTO "metaData" ("id", "item1", "item2") VALUES ('password', X'AA510555364A6F024263605F113D852E9867C2BE', X'303C3028060B2A864886F70D010C05010330190414AA25C3A3A252D1043F0895A89B3C7765402932B4020101041098BAF135FFF4AE98C240CB7AF0B66BB7');
+INSERT INTO "nssPrivate" ("id", "a0", "a1", "a2", "a3", "a10", "a11", "a12", "a80", "a81", "a82", "a83", "a84", "a85", "a86", "a87", "a88", "a89", "a8a", "a8b", "a90", "a100", "a101", "a102", "a103", "a104", "a105", "a106", "a107", "a108", "a109", "a10a", "a10b", "a10c", "a110", "a111", "a120", "a121", "a122", "a123", "a124", "a125", "a126", "a127", "a128", "a130", "a131", "a132", "a133", "a134", "a160", "a161", "a162", "a163", "a164", "a165", "a166", "a170", "a180", "a181", "a200", "a201", "a202", "a210", "a40000211", "a40000212", "a300", "a301", "a302", "a400", "a401", "a402", "a403", "a404", "a405", "a406", "a480", "a481", "a482", "a500", "a501", "a502", "a503", "ace534351", "ace534352", "ace534353", "ace534354", "ace534355", "ace534356", "ace534357", "ace534358", "ace534364", "ace534365", "ace534366", "ace534367", "ace534368", "ace536351", "ace536352", "ace536353", "ace536354", "ace536355", "ace536356", "ace536357", "ace536358", "ace536359", "ace53635a", "ace53635b", "ace53635c", "ace53635d", "ace53635e", "ace53635f", "ace536360", "ace5363b4", "ace5363b5", "ad5a0db00", "a80000001", "ace534369", "a129") VALUES (302496841, X'00000004', X'01', X'01', X'A5005A', NULL, X'304C3028060B2A864886F70D010C050103301904147A9E1A3C7EB5D44BC9216CC49885886F5F370D82020101042069E43E9BF205CC28DF2BEA9C4AE2F0AA63CD0198EA4201C69B9961A10C54F201', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, X'00000015', NULL, X'F8000000000000000000000000000001', X'00', X'01', X'01', X'01', X'01', X'01', NULL, X'00', NULL, NULL, X'A5005A', X'A5005A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, X'01', X'00', X'00', X'01', NULL, X'01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+CREATE INDEX issuer ON nssPrivate (a81);
+CREATE INDEX subject ON nssPrivate (a101);
+CREATE INDEX label ON nssPrivate (a3);
+CREATE INDEX ckaid ON nssPrivate (a102);
+COMMIT;
diff --git a/tests/firefox-84/key4.db b/tests/firefox-84/key4.db
new file mode 100644
index 0000000..6259f80
--- /dev/null
+++ b/tests/firefox-84/key4.db
@@ -0,0 +1,13 @@
+PRAGMA user_version = 0;
+PRAGMA foreign_keys=OFF;
+BEGIN TRANSACTION;
+CREATE TABLE metaData (id PRIMARY KEY UNIQUE ON CONFLICT REPLACE, item1, item2);
+CREATE TABLE nssPrivate (id PRIMARY KEY UNIQUE ON CONFLICT ABORT, a0, a1, a2, a3, a10, a11, a12, a80, a81, a82, a83, a84, a85, a86, a87, a88, a89, a8a, a8b, a90, a100, a101, a102, a103, a104, a105, a106, a107, a108, a109, a10a, a10b, a10c, a110, a111, a120, a121, a122, a123, a124, a125, a126, a127, a128, a130, a131, a132, a133, a134, a160, a161, a162, a163, a164, a165, a166, a170, a180, a181, a200, a201, a202, a210, a40000211, a40000212, a300, a301, a302, a400, a401, a402, a403, a404, a405, a406, a480, a481, a482, a500, a501, a502, a503, ace534351, ace534352, ace534353, ace534354, ace534355, ace534356, ace534357, ace534358, ace534364, ace534365, ace534366, ace534367, ace534368, ace536351, ace536352, ace536353, ace536354, ace536355, ace536356, ace536357, ace536358, ace536359, ace53635a, ace53635b, ace53635c, ace53635d, ace53635e, ace53635f, ace536360, ace5363b4, ace5363b5, ad5a0db00, a80000001, ace534369, a129);
+INSERT INTO "metaData" ("id", "item1", "item2") VALUES ('password', X'AA510555364A6F024263605F113D852E9867C2BE', X'308181306D06092A864886F70D01050D3060304106092A864886F70D01050C3034042060F1540EF413CAE0F159D7724450B345A8E7D63AC871486A2FBB2A972EBA637F020101020120300A06082A864886F70D0209301B060960864801650304012A040E3A8CB6557759A053C8443B5EC8F004100A12E00E7BFC4F93EA6841D87DE69F54');
+INSERT INTO "metaData" ("id", "item1", "item2") VALUES ('sig_key_d207bc49_00000011', X'308180305C06092A864886F70D01050E304F304106092A864886F70D01050C30340420DA57728DCD9969F312626E5B6357D21382A0047665C12DA5957A603F92A1D537020101020120300A06082A864886F70D0209300A06082A864886F70D02090420FBC4E5EB2DF5F424E34A327B72F2060BEA02E21B9DED22C0AEC1A4C0EAFC3518', NULL);
+INSERT INTO "nssPrivate" ("id", "a0", "a1", "a2", "a3", "a10", "a11", "a12", "a80", "a81", "a82", "a83", "a84", "a85", "a86", "a87", "a88", "a89", "a8a", "a8b", "a90", "a100", "a101", "a102", "a103", "a104", "a105", "a106", "a107", "a108", "a109", "a10a", "a10b", "a10c", "a110", "a111", "a120", "a121", "a122", "a123", "a124", "a125", "a126", "a127", "a128", "a130", "a131", "a132", "a133", "a134", "a160", "a161", "a162", "a163", "a164", "a165", "a166", "a170", "a180", "a181", "a200", "a201", "a202", "a210", "a40000211", "a40000212", "a300", "a301", "a302", "a400", "a401", "a402", "a403", "a404", "a405", "a406", "a480", "a481", "a482", "a500", "a501", "a502", "a503", "ace534351", "ace534352", "ace534353", "ace534354", "ace534355", "ace534356", "ace534357", "ace534358", "ace534364", "ace534365", "ace534366", "ace534367", "ace534368", "ace536351", "ace536352", "ace536353", "ace536354", "ace536355", "ace536356", "ace536357", "ace536358", "ace536359", "ace53635a", "ace53635b", "ace53635c", "ace53635d", "ace53635e", "ace53635f", "ace536360", "ace5363b4", "ace5363b5", "ad5a0db00", "a80000001", "ace534369", "a129") VALUES (302496841, X'00000004', X'01', X'01', X'A5005A', NULL, X'308191306D06092A864886F70D01050D3060304106092A864886F70D01050C3034042070C7FE609731CC9C8F9FAF6D0A6C51DE6946E226499242DC9674133DAF22024D020101020120300A06082A864886F70D0209301B060960864801650304012A040E296760ED873759093F483F543FD5042022E961EBADDB26F8D82375FC0B49B1C8C25FCB321C91D586FEEFE327734AD252', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, X'00000015', NULL, X'F8000000000000000000000000000001', X'00', X'01', X'01', X'01', X'01', X'01', NULL, X'00', NULL, NULL, X'A5005A', X'A5005A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, X'01', X'00', X'00', X'01', NULL, X'01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+CREATE INDEX issuer ON nssPrivate (a81);
+CREATE INDEX subject ON nssPrivate (a101);
+CREATE INDEX label ON nssPrivate (a3);
+CREATE INDEX ckaid ON nssPrivate (a102);
+COMMIT;
diff --git a/tests/firefox-mixed-keys/key4.db b/tests/firefox-mixed-keys/key4.db
new file mode 100644
index 0000000..66d0d4e
--- /dev/null
+++ b/tests/firefox-mixed-keys/key4.db
@@ -0,0 +1,9 @@
+PRAGMA user_version = 0;
+PRAGMA foreign_keys=OFF;
+BEGIN TRANSACTION;
+CREATE TABLE metadata (id TEXT PRIMARY KEY, item1, item2);
+CREATE TABLE nssPrivate (a11, a102);
+INSERT INTO "metadata" ("id", "item1", "item2") VALUES ('password', X'676C6F62616C5F73616C74', X'70775F636865636B5F626C6F62');
+INSERT INTO "nssPrivate" ("a11", "a102") VALUES (X'626C6F625F6C65676163795F3234', X'F8000000000000000000000000000001');
+INSERT INTO "nssPrivate" ("a11", "a102") VALUES (X'626C6F625F6D6F6465726E5F3332', X'F8000000000000000000000000000001');
+COMMIT;
diff --git a/tests/firefox-mp-70/key4.db b/tests/firefox-mp-70/key4.db
new file mode 100644
index 0000000..5fb28fa
--- /dev/null
+++ b/tests/firefox-mp-70/key4.db
@@ -0,0 +1,12 @@
+PRAGMA user_version = 0;
+PRAGMA foreign_keys=OFF;
+BEGIN TRANSACTION;
+CREATE TABLE metaData (id PRIMARY KEY UNIQUE ON CONFLICT REPLACE, item1, item2);
+CREATE TABLE nssPrivate (id PRIMARY KEY UNIQUE ON CONFLICT ABORT, a0, a1, a2, a3, a10, a11, a12, a80, a81, a82, a83, a84, a85, a86, a87, a88, a89, a8a, a8b, a90, a100, a101, a102, a103, a104, a105, a106, a107, a108, a109, a10a, a10b, a10c, a110, a111, a120, a121, a122, a123, a124, a125, a126, a127, a128, a130, a131, a132, a133, a134, a160, a161, a162, a163, a164, a165, a166, a170, a180, a181, a200, a201, a202, a210, a40000211, a40000212, a300, a301, a302, a400, a401, a402, a403, a404, a405, a406, a480, a481, a482, a500, a501, a502, a503, ace534351, ace534352, ace534353, ace534354, ace534355, ace534356, ace534357, ace534358, ace534364, ace534365, ace534366, ace534367, ace534368, ace536351, ace536352, ace536353, ace536354, ace536355, ace536356, ace536357, ace536358, ace536359, ace53635a, ace53635b, ace53635c, ace53635d, ace53635e, ace53635f, ace536360, ace5363b4, ace5363b5, ad5a0db00, a80000001, ace534369, a129);
+INSERT INTO "metaData" ("id", "item1", "item2") VALUES ('password', X'AA510555364A6F024263605F113D852E9867C2BE', X'303C3028060B2A864886F70D010C05010330190414CB977D9AE3CBB80693EED803E2183D7514559DEC0201010410F278BC4A22CA8CEE2D298C3F0F016982');
+INSERT INTO "nssPrivate" ("id", "a0", "a1", "a2", "a3", "a10", "a11", "a12", "a80", "a81", "a82", "a83", "a84", "a85", "a86", "a87", "a88", "a89", "a8a", "a8b", "a90", "a100", "a101", "a102", "a103", "a104", "a105", "a106", "a107", "a108", "a109", "a10a", "a10b", "a10c", "a110", "a111", "a120", "a121", "a122", "a123", "a124", "a125", "a126", "a127", "a128", "a130", "a131", "a132", "a133", "a134", "a160", "a161", "a162", "a163", "a164", "a165", "a166", "a170", "a180", "a181", "a200", "a201", "a202", "a210", "a40000211", "a40000212", "a300", "a301", "a302", "a400", "a401", "a402", "a403", "a404", "a405", "a406", "a480", "a481", "a482", "a500", "a501", "a502", "a503", "ace534351", "ace534352", "ace534353", "ace534354", "ace534355", "ace534356", "ace534357", "ace534358", "ace534364", "ace534365", "ace534366", "ace534367", "ace534368", "ace536351", "ace536352", "ace536353", "ace536354", "ace536355", "ace536356", "ace536357", "ace536358", "ace536359", "ace53635a", "ace53635b", "ace53635c", "ace53635d", "ace53635e", "ace53635f", "ace536360", "ace5363b4", "ace5363b5", "ad5a0db00", "a80000001", "ace534369", "a129") VALUES (302496841, X'00000004', X'01', X'01', X'A5005A', NULL, X'304C3028060B2A864886F70D010C050103301904144E193D28C1F03449E788659AA6B1D2E667C6E5170201010420401736CBDD452215FC4CECA598384DA5BC9A0517C6FAC76A7E0F691D21E266B0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, X'00000015', NULL, X'F8000000000000000000000000000001', X'00', X'01', X'01', X'01', X'01', X'01', NULL, X'00', NULL, NULL, X'A5005A', X'A5005A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, X'01', X'00', X'00', X'01', NULL, X'01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+CREATE INDEX issuer ON nssPrivate (a81);
+CREATE INDEX subject ON nssPrivate (a101);
+CREATE INDEX label ON nssPrivate (a3);
+CREATE INDEX ckaid ON nssPrivate (a102);
+COMMIT;
diff --git a/tests/firefox-mp-84/key4.db b/tests/firefox-mp-84/key4.db
new file mode 100644
index 0000000..067d9f3
--- /dev/null
+++ b/tests/firefox-mp-84/key4.db
@@ -0,0 +1,13 @@
+PRAGMA user_version = 0;
+PRAGMA foreign_keys=OFF;
+BEGIN TRANSACTION;
+CREATE TABLE metaData (id PRIMARY KEY UNIQUE ON CONFLICT REPLACE, item1, item2);
+CREATE TABLE nssPrivate (id PRIMARY KEY UNIQUE ON CONFLICT ABORT, a0, a1, a2, a3, a10, a11, a12, a80, a81, a82, a83, a84, a85, a86, a87, a88, a89, a8a, a8b, a90, a100, a101, a102, a103, a104, a105, a106, a107, a108, a109, a10a, a10b, a10c, a110, a111, a120, a121, a122, a123, a124, a125, a126, a127, a128, a130, a131, a132, a133, a134, a160, a161, a162, a163, a164, a165, a166, a170, a180, a181, a200, a201, a202, a210, a40000211, a40000212, a300, a301, a302, a400, a401, a402, a403, a404, a405, a406, a480, a481, a482, a500, a501, a502, a503, ace534351, ace534352, ace534353, ace534354, ace534355, ace534356, ace534357, ace534358, ace534364, ace534365, ace534366, ace534367, ace534368, ace536351, ace536352, ace536353, ace536354, ace536355, ace536356, ace536357, ace536358, ace536359, ace53635a, ace53635b, ace53635c, ace53635d, ace53635e, ace53635f, ace536360, ace5363b4, ace5363b5, ad5a0db00, a80000001, ace534369, a129);
+INSERT INTO "metaData" ("id", "item1", "item2") VALUES ('password', X'AA510555364A6F024263605F113D852E9867C2BE', X'308181306D06092A864886F70D01050D3060304106092A864886F70D01050C30340420DD6BAB544E0A3112B83B6D5ED6AC8B4B2D0DE7F6D3DB2042B92A275BE2E43BD3020101020120300A06082A864886F70D0209301B060960864801650304012A040E5E2CE7254C69D4C1DB97E659D90E041044A0B10B0B5B27C6515C32B871F25847');
+INSERT INTO "metaData" ("id", "item1", "item2") VALUES ('sig_key_d207bc49_00000011', X'308180305C06092A864886F70D01050E304F304106092A864886F70D01050C3034042034556075B138A0AA60D7363D0FD97735A9DA2B1C6B8A24D1E4C1D7D86D8D9C77020101020120300A06082A864886F70D0209300A06082A864886F70D02090420C9A51087BBFA9502BD75C156FFDD6A7DF87695A7D3F3D0328B71200184AAD685', NULL);
+INSERT INTO "nssPrivate" ("id", "a0", "a1", "a2", "a3", "a10", "a11", "a12", "a80", "a81", "a82", "a83", "a84", "a85", "a86", "a87", "a88", "a89", "a8a", "a8b", "a90", "a100", "a101", "a102", "a103", "a104", "a105", "a106", "a107", "a108", "a109", "a10a", "a10b", "a10c", "a110", "a111", "a120", "a121", "a122", "a123", "a124", "a125", "a126", "a127", "a128", "a130", "a131", "a132", "a133", "a134", "a160", "a161", "a162", "a163", "a164", "a165", "a166", "a170", "a180", "a181", "a200", "a201", "a202", "a210", "a40000211", "a40000212", "a300", "a301", "a302", "a400", "a401", "a402", "a403", "a404", "a405", "a406", "a480", "a481", "a482", "a500", "a501", "a502", "a503", "ace534351", "ace534352", "ace534353", "ace534354", "ace534355", "ace534356", "ace534357", "ace534358", "ace534364", "ace534365", "ace534366", "ace534367", "ace534368", "ace536351", "ace536352", "ace536353", "ace536354", "ace536355", "ace536356", "ace536357", "ace536358", "ace536359", "ace53635a", "ace53635b", "ace53635c", "ace53635d", "ace53635e", "ace53635f", "ace536360", "ace5363b4", "ace5363b5", "ad5a0db00", "a80000001", "ace534369", "a129") VALUES (302496841, X'00000004', X'01', X'01', X'A5005A', NULL, X'308191306D06092A864886F70D01050D3060304106092A864886F70D01050C303404204FCDFAEA4DA81E19AB283B1B24022DD6EF2DE9BCFF9495425B879D1152883E50020101020120300A06082A864886F70D0209301B060960864801650304012A040E116E64DABAEE4AA020C6AF2C22830420045B1487CA30CD5E847191F1626C6DF6981446B179CA3719C1B3D2CE1BA2ACCC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, X'00000015', NULL, X'F8000000000000000000000000000001', X'00', X'01', X'01', X'01', X'01', X'01', NULL, X'00', NULL, NULL, X'A5005A', X'A5005A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, X'01', X'00', X'00', X'01', NULL, X'01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+CREATE INDEX issuer ON nssPrivate (a81);
+CREATE INDEX subject ON nssPrivate (a101);
+CREATE INDEX label ON nssPrivate (a3);
+CREATE INDEX ckaid ON nssPrivate (a102);
+COMMIT;
diff --git a/tests/firefox-mp-test/key4.db b/tests/firefox-mp-test/key4.db
new file mode 100644
index 0000000..a6071c0
--- /dev/null
+++ b/tests/firefox-mp-test/key4.db
@@ -0,0 +1,8 @@
+PRAGMA user_version = 0;
+PRAGMA foreign_keys=OFF;
+BEGIN TRANSACTION;
+CREATE TABLE metadata (id TEXT PRIMARY KEY, item1, item2);
+CREATE TABLE nssPrivate (a11, a102);
+INSERT INTO "metadata" ("id", "item1", "item2") VALUES ('password', X'BA3B648D6B717FCE048E0E315C6F2330ABD015FA', X'303C3028060B2A864886F70D010C0501033019041435B16FB4E00CF2E8DB4C61BDABAE8561A4C9A57B0201010410160E10B48BCC7A3C6290A5FF3BE22F7D');
+INSERT INTO "nssPrivate" ("a11", "a102") VALUES (X'304C3028060B2A864886F70D010C050103301904148B9CAAFD3DAA7652317AB6F66612F6FA66EDA9870201010420CD652B28246E01A2F556EF3B49DEDC60772D08209220E1452BEA5F4823535A5C', X'F8000000000000000000000000000001');
+COMMIT;
-- 
2.52.0