From f54ca21bb5823e935f7fc910b3883ef630052297 Mon Sep 17 00:00:00 2001
From: Lennart Poettering <lennart@poettering.net>
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 

