diff options
Diffstat (limited to 'src/libraries/qmfclient/resources/deletedmessages.sqlite.sql')
| -rw-r--r-- | src/libraries/qmfclient/resources/deletedmessages.sqlite.sql | 8 |
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)); |
