# HG changeset patch
# User heiko
# Date 1219243983 0
# Node ID cfaaf0096975bdffb0bfc8487174b8d419f3de24
# Parent  acb001031e193254b2c763632bf5a08886d23999
- doc improved

diff -r acb001031e19 -r cfaaf0096975 mail2db
--- a/mail2db	Wed Aug 20 14:49:54 2008 +0000
+++ b/mail2db	Wed Aug 20 14:53:03 2008 +0000
@@ -324,24 +324,41 @@
 
     message_header
     -------------------
-    message_id:         int, foreign key message.id
+    message_id:         bigint, foreign key message.id
     header_field_id:    int, foreign key header_field.id
     idx:                int             -- position in unfolded header fields
     content:            text (UTF8)
 
     message
     ------------------
-    id:             int, unique, autoincrement
+    id:             bigint, unique, autoincrement
     timestamp:      timestamp           -- date of insertion
     content:        text (UTF8?         -- complete message (incl. all headers)
 
+	eht
+	------------------
+	message_id:		bigint, foreign key message.id
+	mandant:		int
+	typ:			int
+	vorgang:		int
+
     VIEW header
     ------------------
-    message_id:     int, foreign key message.id
+    message_id:     bigint, foreign key message.id
     name:           char(255)
     idx:            int
     content:        text
 
+
+	VIEW eht_message
+	------------------
+	message_id:		bigint, foreign key message.id
+	mandant:		int
+	typ:			int
+	vorgang:		int
+	content:		text
+
+
 All foreign key constraints use "ON DELETE CASCADE" to remove unwanted
 stuff automagically.