diff options
Diffstat (limited to 'src/libraries/qmfclient/resources/mailfolders.sqlite.sql')
| -rw-r--r-- | src/libraries/qmfclient/resources/mailfolders.sqlite.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/src/libraries/qmfclient/resources/mailfolders.sqlite.sql b/src/libraries/qmfclient/resources/mailfolders.sqlite.sql new file mode 100644 index 00000000..d08f06af --- /dev/null +++ b/src/libraries/qmfclient/resources/mailfolders.sqlite.sql @@ -0,0 +1,13 @@ +CREATE TABLE mailfolders ( + id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + name VARCHAR(255) NOT NULL, + parentid INTEGER, + parentaccountid INTEGER, + status INTEGER, + displayname VARCHAR(255), + servercount INTEGER, + serverunreadcount INTEGER, + serverundiscoveredcount INTEGER, + FOREIGN KEY (parentaccountid) REFERENCES mailaccounts(id), + FOREIGN KEY (parentid) REFERENCES mailfolder(id)); + |