diff options
Diffstat (limited to 'fooconf.sql')
-rw-r--r-- | fooconf.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/fooconf.sql b/fooconf.sql new file mode 100644 index 0000000..a4861b4 --- /dev/null +++ b/fooconf.sql @@ -0,0 +1,20 @@ + + +CREATE TABLE account (id INTEGER PRIMARY KEY, name VARCHAR, email VARCHAR, enabled BOOLEAN, password VARCHAR); + +-- ACTION: e.g. cron, php, cgi, wedav... +CREATE TABLE permission (id INTEGER, action VARCHAR); + +CREATE TABLE mailbox (name VARCHAR, password VARCHAR, owner INTEGER, enabled BOOLEAN); + +-- TYPE: e.g. forward, mailbox +CREATE TABLE mail_alias (local VARCHAR, domain VARCHAR, type CHAR, recipient VARCHAR); + +CREATE TABLE domain (name VARCHAR PRIMARY KEY, owner INTEGER); + +CREATE TABLE domain_vhost (name VARCHAR PRIMARY KEY, enabled BOOLEAN, origin_email VARCHAR); +CREATE TABLE domain_alias (name VARCHAR PRIMARY KEY, vhost VARCHAR); + +-- TYPE: proxy, redirect +CREATE TABLE domain_redirect (name VARCHAR PRIMARY KEY, destination VARCHAR, type VARCHAR); + |