1 files changed, 11 insertions, 0 deletions
diff --git a/src/libraries/qmfclient/resources/mailmessageidentifiers-100-101.sqlite.sql b/src/libraries/qmfclient/resources/mailmessageidentifiers-100-101.sqlite.sql
new file mode 100644
index 00000000..c5a4a82f
--- /dev/null
+++ b/src/libraries/qmfclient/resources/mailmessageidentifiers-100-101.sqlite.sql
@@ -0,0 +1,11 @@
+ALTER TABLE mailmessageidentifiers RENAME TO wasmailmessageidentifiers;
+
+CREATE TABLE mailmessageidentifiers( 
+    id INTEGER,
+    identifier VARCHAR,
+    FOREIGN KEY (id) REFERENCES mailmessages(id));
+
+INSERT INTO mailmessageidentifiers (id, identifier)
+    SELECT id, identifier FROM wasmailmessageidentifiers;
+
+DROP TABLE wasmailmessageidentifiers;