From f54ca21bb5823e935f7fc910b3883ef630052297 Mon Sep 17 00:00:00 2001 From: Lennart Poettering Date: Tue, 7 Dec 2004 16:53:18 +0000 Subject: move stuff into trunk git-svn-id: file:///home/lennart/svn/public/fooconf/trunk@5 a3b0ba65-a9ea-0310-aec1-fe512e4e1665 --- fooconf.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 fooconf.sql (limited to 'fooconf.sql') 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); + -- cgit