- doc improved eht
authorheiko
Wed, 20 Aug 2008 14:53:03 +0000
brancheht
changeset 17 cfaaf0096975
parent 16 acb001031e19
child 18 806166bd5332
- doc improved
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.