--- a/db.mysql Wed Aug 20 14:53:03 2008 +0000
+++ b/db.mysql Fri Aug 22 15:54:00 2008 +0000
@@ -40,6 +40,7 @@
/*!50001 DROP VIEW IF EXISTS `eht_message`*/;
/*!50001 CREATE TABLE `eht_message` (
`message_id` bigint(20),
+ `timestamp` timestamp,
`mandant` int(11),
`typ` int(11),
`vorgang` int(11),
@@ -106,7 +107,7 @@
/*!50001 DROP VIEW IF EXISTS `eht_message`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`mail`@`%` SQL SECURITY DEFINER */
-/*!50001 VIEW `eht_message` AS select `eht`.`message_id` AS `message_id`,`eht`.`mandant` AS `mandant`,`eht`.`typ` AS `typ`,`eht`.`vorgang` AS `vorgang`,`message`.`content` AS `content` from (`eht` left join `message` on((`eht`.`message_id` = `message`.`id`))) */;
+/*!50001 VIEW `eht_message` AS select `eht`.`message_id` AS `message_id`,`message`.`timestamp` AS `timestamp`,`eht`.`mandant` AS `mandant`,`eht`.`typ` AS `typ`,`eht`.`vorgang` AS `vorgang`,`message`.`content` AS `content` from (`eht` left join `message` on((`eht`.`message_id` = `message`.`id`))) */;
--
-- Final view structure for view `header`
@@ -127,4 +128,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2008-08-20 14:45:22
+-- Dump completed on 2008-08-22 15:33:33
--- a/mail2db Wed Aug 20 14:53:03 2008 +0000
+++ b/mail2db Fri Aug 22 15:54:00 2008 +0000
@@ -353,6 +353,7 @@
VIEW eht_message
------------------
message_id: bigint, foreign key message.id
+ timestamp: timestamp (from message)
mandant: int
typ: int
vorgang: int