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