# HG changeset patch
# User heiko
# Date 1216589265 0
# Node ID 1f7a596258632797a1f225f982658883dfd8aa6b
# Parent  2638ae65724069bf9dc3d7b22fa3e9712d6cb604
- created a view (and dumped it)

diff -r 2638ae657240 -r 1f7a59625863 db.mysql
--- a/db.mysql	Sun Jul 20 21:21:38 2008 +0000
+++ b/db.mysql	Sun Jul 20 21:27:45 2008 +0000
@@ -16,6 +16,19 @@
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 
 --
+-- Temporary table structure for view `header`
+--
+
+DROP TABLE IF EXISTS `header`;
+/*!50001 DROP VIEW IF EXISTS `header`*/;
+/*!50001 CREATE TABLE `header` (
+  `message_id` int(11),
+  `name` char(255),
+  `idx` int(11),
+  `content` text
+) */;
+
+--
 -- Table structure for table `header_field`
 --
 
@@ -53,6 +66,16 @@
   CONSTRAINT `message_header_ibfk_1` FOREIGN KEY (`header_field_id`) REFERENCES `header_field` (`id`) ON DELETE CASCADE,
   CONSTRAINT `message_header_ibfk_2` FOREIGN KEY (`message_id`) REFERENCES `message` (`id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Final view structure for view `header`
+--
+
+/*!50001 DROP TABLE IF EXISTS `header`*/;
+/*!50001 DROP VIEW IF EXISTS `header`*/;
+/*!50001 CREATE ALGORITHM=UNDEFINED */
+/*!50013 DEFINER=`mail`@`%` SQL SECURITY DEFINER */
+/*!50001 VIEW `header` AS select `message_header`.`message_id` AS `message_id`,`header_field`.`name` AS `name`,`message_header`.`idx` AS `idx`,`message_header`.`content` AS `content` from (`message_header` join `header_field` on((`header_field`.`id` = `message_header`.`header_field_id`))) order by `message_header`.`message_id`,`header_field`.`name`,`message_header`.`idx` */;
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 
 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
@@ -63,4 +86,4 @@
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2008-07-20 20:54:13
+-- Dump completed on 2008-07-20 21:24:42
diff -r 2638ae657240 -r 1f7a59625863 mail2db
--- a/mail2db	Sun Jul 20 21:21:38 2008 +0000
+++ b/mail2db	Sun Jul 20 21:27:45 2008 +0000
@@ -267,8 +267,15 @@
 	timestamp:      timestamp           -- date of insertion
 	content:        text                -- complete message (incl. all headers)
 
+	VIEW header
+	------------------
+	message_id:		int, foreign key message.id
+	name:			char(255)
+	idx:			int
+	content:		text
 
-If you want to see the message headers in a nice form, you may create view or just
+
+If you want to see the message headers in a nice form, you may use the view above or just
 use the following statement:
 
 	SELECT message_header.message_id,