summaryrefslogtreecommitdiffstats
path: root/src/libraries/qmfclient/resources/deletedmessages.sqlite.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/libraries/qmfclient/resources/deletedmessages.sqlite.sql')
-rw-r--r--src/libraries/qmfclient/resources/deletedmessages.sqlite.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/src/libraries/qmfclient/resources/deletedmessages.sqlite.sql b/src/libraries/qmfclient/resources/deletedmessages.sqlite.sql
new file mode 100644
index 00000000..47f48bc8
--- /dev/null
+++ b/src/libraries/qmfclient/resources/deletedmessages.sqlite.sql
@@ -0,0 +1,8 @@
+CREATE TABLE deletedmessages(
+ id INTEGER PRIMARY KEY NOT NULL,
+ parentaccountid INTEGER NOT NULL,
+ serveruid VARCHAR,
+ frommailbox VARCHAR,
+ parentfolderid INTEGER,
+ FOREIGN KEY (parentaccountid) REFERENCES mailaccounts(id),
+ FOREIGN KEY (parentfolderid) REFERENCES mailfolders(id));