--- 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.